See the table space usage
round (a.total_size)-round (nvl (b.free_size, 0), 1) "used (M)",
round (nvl (b.free_size, 0), 1) "free (M)",
round (nvl (b.free_size, 0) / total_size * 100,1) "free rate (%)"
from (select tablespace_name, sum (bytes) / 1024/1024 total_size
from dba_data_files
group by tablespace_name) a,
(select tablespace_name, sum (bytes) / 1024/1024 free_size
from dba_free_space
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name (+)
order by "free rate (%)";
Related Posts of See the table space usage
-
UNDO table space reconstruction
$ Sqlplus / nolog SQL> connect / as sysdba SQL> create undo tablespace UNDOTBS2 datafile '/ ora_data/UNDOTBS02.DBF' size 1M extent management local; SQL> alter system set undo_tablespace = UNDOTBS2; SQL> drop tablespace UNDOTBS1 includ
-
ORACLE table space-related operations
sqlplus / nolog connect / as sysdba startup sqlplus / nolog connect / as sysdba SHUTDOWN IMMEDIATE If you want to use windows default date format. English is not in the configuration variables in the environment: NLS_LANG american_america.us7ASCII - ...
-
Oracle Database exp imp Import Export by user examples
◆ 1. From one windows server A on Test1 export all objects in the user, and then into the linux server B on Test2 users. (Test1 known password for the system users Test1passwd or export is required) ◆ 2.B user Test2 machine does not exist, or Test2 b ...
-
Oracle database used to maintain day-to-day command
Oracle database used to maintain day-to-day command At run-time Oracle database, DBA should run the database log and table space for the use of surveillance, early detection of problems that exist in the database. One, Oracle log file monitoring warn ...
-
Oracle to create data table space, the user, authorization, table, index, cluster
/ / Create a temporary table space (log files) create temporary tablespace test_temp tempfile 'E: \ oracle \ test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Create a data table space create tablespa ...
-
Oracle10g ASM database table space maintenance
1. Default naming Oracle when using ASM + OMF management, Oracle distribution file name will automatically create the appropriate file. Our job to create table space can be simplified as follows: A command. The following are the default Oracle naming ...
-
Block Oracle paragraph (reprint)
Starting today, begin reading the second oracle document b10743, "conceps"; do not know can give me a new harvest. The master was oracle's Michele Cyran characters written by people such as cow, a really good book. Alas English not well ...
Leave a Reply