All about Oracle10g SYSAUX tablespace(二)
Automatic Workload Repository SYS
SM/ADVISOR Server Manageability - Advisor Framework SYS
SM/OPTSTAT Server Manageability - Optimizer Statistics History SYS
SM/OTHER Server Manageability - Other Components SYS
STATSPACK Statspack Repository PERFSTAT
ODM Oracle Data Mining DMSYS
SDO Oracle Spatial MDSYS
WM Workspace Manager WMSYS
ORDIM Oracle interMedia ORDSYS Components ORDSYS
ORDIM/PLUGINS Oracle interMedia ORDPLUGINS Components ORDPLUGINS
ORDIM/SQLMM Oracle interMedia SI_INFORMTN_SCHEMA Components SI_INFORMTN_SCHEMA
EM Enterprise Manager Repository SYSMAN
TEXT Oracle Text CTXSYS
ULTRASEARCH Oracle Ultra Search WKSYS
JOB_SCHEDULER Unified Job Scheduler SYS
20 rows selected.
11G中又加入了新组件。
SYAAUX表空间具有如下限制:
1. 不能删除
SQL> drop tablespace SYSAUX including contents and datafiles;
drop tablespace SYSAUX including contents and datafiles
*
ERROR at line 1:
ORA-13501: Cannot drop SYSAUX tablespace
2. 不能重命名
SQL> alter tablespace SYSAUX rename to OPT_TBS;
alter tablespace SYSAUX rename to OPT_TBS
*
ERROR at line 1:
ORA-13502: Cannot rename SYSAUX tablespace
3. 不能置为read only
SQL> alter tablesapce SYSAUX read only;
alter tablesapce SYSAUX read only
*
ERROR at line 1:
ORA-00940: invalid ALTER command
如果希望转移这些
系统对象的表空间，可以使用相应得系统包实现:
SQL> set linesize 120
SQL> col schema_name for a18
SQL> col occupant_name for a13
SQL> col move_procedure for a32
SQL> SELECT occupant_name, schema_name, move_procedure,space_usage_kbytes
2 FROM v$sysaux_occupants
3 ORDER BY 1
4 /
OCCUPANT_NAME SCHEMA_NAME MOVE_PROCEDURE SPACE_USAGE_KBYTES
------------- ------------------ -------------------------------- ------------------
AO SYS DBMS_AW.MOVE_AWMETA 768
EM SYSMAN emd_maintenance.move_em_tblspc 0
JOB_SCHEDULER SYS 256
LOGMNR SYSTEM SYS.DBMS_LOGMNR_D.SET_TABLESPACE 7488 -- 注意这里
LOGSTDBY SYSTEM SYS.DBMS_LOGSTDBY.SET_TABLESPACE 0
ODM DMSYS MOVE_ODM 0
ORDIM ORDSYS 0
ORDIM/PLUGINS ORDPLUGINS 0
ORDIM/SQLMM SI_INFORMTN_SCHEMA 0
SDO MDSYS MDSYS.MOVE_SDO 0
SM/ADVISOR SYS 5760
SM/AWR SYS 62848
SM/OPTSTAT SYS 9344
SM/OTHER SYS 2816
STATSPACK PERFSTAT 0
STREAMS SYS