管理Oracle时常用的数据字典和动态性能视图(二)
24 860 QMNC AQ Coordinator
PID SPID NAME DESCRIPTION
---------- ------------------------ ----- ----------------------------------------------------------------
25 874 CJQ0 Job Queue Coordinator
28 908 SMCO Space Manager Process
22 rows selected
9.dba_tablespaces
[sql]
select tablespace_name, status, contents from dba_tablespaces;
[html]
TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
SYSTEM ONLINE PERMANENT
SYSAUX ONLINE PERMANENT
UNDOTBS1 ONLINE UNDO
TEMP ONLINE TEMPORARY
USERS ONLINE PERMANENT
EXAMPLE ONLINE PERMANENT
STU ONLINE PERMANENT
7 rows selected
10.user_segments
查看段信息。比如：
[sql]
select segment_name, segment_type, tablespace_name, bytes/1024"Size(KB)", extents, blocks
from user_segments where segment_name ='DEPT'
[html]
SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME Size(KB) EXTENTS BLOCKS
------------------------------ ------------------ ------------------------------ ---------- ---------- ----------
DEPT TABLE USERS 64 1 8
11.user_extents
查看区段信息。比如：
[sql]
select segment_name, tablespace_name, extent_id, bytes/1024"Size(KB)", blocks
from user_extents where segment_name ='DEPT';
[html]
SEGMENT_NAME TABLESPACE_NAME EXTENT_ID Size(KB) BLOCKS
------------------------------ ------------------------------ ---------- ---------- ----------
DEPT USERS 0 64 8
12.dba_data_files
查看数据文件相关信息。比如：
[sql]
select file_id, file_name, tablespace_name from dba_data_files;
[html]
FILE_ID FILE_NAME TABLESPACE_NAME
------- -------------------------------------------------------------------------------- ------------------------------
4 /u01/oradata/mike/users01.dbf USERS
3 /u01/oradata/mike/undotbs01.dbf UNDOTBS1
2 /u01/oradata/mike/sysaux01.dbf SYSAUX
1 /u01/oradata/mike/system01.dbf SYSTEM
5 /u01/oradata/mike/example01.dbf EXAMPLE
6 /u01/oradata/mike/stu01.dbf STU
7 /u01/oradata/mike/undotbs02.dbf UNDOTBS1
ows selected
13.dba_temp_files
查看临时表数据文件信息。比如：
[sql]
select file_id, file_name, tablespace_name from dba_temp_files;
[html]
FILE_ID FILE_NAME TABLESPACE_NAME
---------- -------------------------------------------------------------------------------- ------------------------------
1 /u01/oradata/mike/temp01.dbf TEMP