[oracle@ol8 ~]$ sql / as sysdba
SQLcl: Release 20.3 Production on Sun Jan 24 20:23:49 2021
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL> set sqlformat json-formatted
SQL> select * from v$sysaux_occupants order by space_usage_kbytes desc;
{
"results" : [
{
"columns" : [
{
"name" : "OCCUPANT_NAME",
"type" : "VARCHAR2"
},
{
"name" : "OCCUPANT_DESC",
"type" : "VARCHAR2"
},
{
"name" : "SCHEMA_NAME",
"type" : "VARCHAR2"
},
{
"name" : "MOVE_PROCEDURE",
"type" : "VARCHAR2"
},
{
"name" : "MOVE_PROCEDURE_DESC",
"type" : "VARCHAR2"
},
{
"name" : "SPACE_USAGE_KBYTES",
"type" : "NUMBER"
},
{
"name" : "CON_ID",
"type" : "NUMBER"
}
],
"items" : [
{
"occupant_name" : "SDO",
"occupant_desc" : "Oracle Spatial",
"schema_name" : "MDSYS",
"move_procedure" : "MDSYS.MOVE_SDO",
"move_procedure_desc" : "Move Procedure for Oracle Spatial",
"space_usage_kbytes" : 238464,
"con_id" : 1
},
{
"occupant_name" : "SM/AWR",
"occupant_desc" : "Server Manageability - Automatic Workload Repository",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 194112,
"con_id" : 1
},
{
"occupant_name" : "XDB",
"occupant_desc" : "XDB",
"schema_name" : "XDB",
"move_procedure" : "XDB.DBMS_XDB_ADMIN.MOVEXDB_TABLESPACE",
"move_procedure_desc" : "Move Procedure for XDB",
"space_usage_kbytes" : 70016,
"con_id" : 1
},
{
"occupant_name" : "SM/OTHER",
"occupant_desc" : "Server Manageability - Other Components",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 67392,
"con_id" : 1
},
{
"occupant_name" : "AO",
"occupant_desc" : "Analytical Workspace Object Table",
"schema_name" : "SYS",
"move_procedure" : "DBMS_AW.MOVE_AWMETA",
"move_procedure_desc" : "Move Procedure for Analytical Workspace Object Table",
"space_usage_kbytes" : 46912,
"con_id" : 1
},
{
"occupant_name" : "SM/OPTSTAT",
"occupant_desc" : "Server Manageability - Optimizer Statistics History",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 31616,
"con_id" : 1
},
{
"occupant_name" : "SM/ADVISOR",
"occupant_desc" : "Server Manageability - Advisor Framework",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 11072,
"con_id" : 1
},
{
"occupant_name" : "LOGMNR",
"occupant_desc" : "LogMiner",
"schema_name" : "SYSTEM",
"move_procedure" : "SYS.DBMS_LOGMNR_D.SET_TABLESPACE",
"move_procedure_desc" : "Move Procedure for LogMiner",
"space_usage_kbytes" : 11072,
"con_id" : 1
},
{
"occupant_name" : "WM",
"occupant_desc" : "Workspace Manager",
"schema_name" : "WMSYS",
"move_procedure" : "DBMS_WM.move_proc",
"move_procedure_desc" : "Move Procedure for Workspace Manager",
"space_usage_kbytes" : 6720,
"con_id" : 1
},
{
"occupant_name" : "AUDSYS",
"occupant_desc" : "AUDSYS schema objects",
"schema_name" : "AUDSYS",
"move_procedure" : "DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION",
"move_procedure_desc" : "Move Procedure for Unified Audit Trail",
"space_usage_kbytes" : 5184,
"con_id" : 1
},
{
"occupant_name" : "TEXT",
"occupant_desc" : "Oracle Text",
"schema_name" : "CTXSYS",
"move_procedure" : "DRI_MOVE_CTXSYS",
"move_procedure_desc" : "Move Procedure for Oracle Text",
"space_usage_kbytes" : 2880,
"con_id" : 1
},
{
"occupant_name" : "PL/SCOPE",
"occupant_desc" : "PL/SQL Identifier Collection",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 2880,
"con_id" : 1
},
{
"occupant_name" : "SQL_MANAGEMENT_BASE",
"occupant_desc" : "SQL Management Base Schema",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 2752,
"con_id" : 1
},
{
"occupant_name" : "SMON_SCN_TIME",
"occupant_desc" : "Transaction Layer - SCN to TIME mapping",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 2240,
"con_id" : 1
},
{
"occupant_name" : "JOB_SCHEDULER",
"occupant_desc" : "Unified Job Scheduler",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 2048,
"con_id" : 1
},
{
"occupant_name" : "STREAMS",
"occupant_desc" : "Oracle Streams",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 1728,
"con_id" : 1
},
{
"occupant_name" : "LOGSTDBY",
"occupant_desc" : "Logical Standby",
"schema_name" : "SYSTEM",
"move_procedure" : "SYS.DBMS_LOGSTDBY.SET_TABLESPACE",
"move_procedure_desc" : "Move Procedure for Logical Standby",
"space_usage_kbytes" : 1600,
"con_id" : 1
},
{
"occupant_name" : "AUTO_TASK",
"occupant_desc" : "Automated Maintenance Tasks",
"schema_name" : "SYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 576,
"con_id" : 1
},
{
"occupant_name" : "EM_MONITORING_USER",
"occupant_desc" : "Enterprise Manager Monitoring User",
"schema_name" : "DBSNMP",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 512,
"con_id" : 1
},
{
"occupant_name" : "ORDIM/ORDDATA",
"occupant_desc" : "Oracle Multimedia ORDDATA Components",
"schema_name" : "ORDDATA",
"move_procedure" : "ordsys.ord_admin.move_ordim_tblspc",
"move_procedure_desc" : "Move Procedure for Oracle Multimedia",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "ORDIM/ORDPLUGINS",
"occupant_desc" : "Oracle Multimedia ORDPLUGINS Components",
"schema_name" : "ORDPLUGINS",
"move_procedure" : "ordsys.ord_admin.move_ordim_tblspc",
"move_procedure_desc" : "Move Procedure for Oracle Multimedia",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "ORDIM/SI_INFORMTN_SCHEMA",
"occupant_desc" : "Oracle Multimedia SI_INFORMTN_SCHEMA Components",
"schema_name" : "SI_INFORMTN_SCHEMA",
"move_procedure" : "ordsys.ord_admin.move_ordim_tblspc",
"move_procedure_desc" : "Move Procedure for Oracle Multimedia",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "EM",
"occupant_desc" : "Enterprise Manager Repository",
"schema_name" : "SYSMAN",
"move_procedure" : "emd_maintenance.move_em_tblspc",
"move_procedure_desc" : "Move Procedure for Enterprise Manager Repository",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "XSOQHIST",
"occupant_desc" : "OLAP API History Tables",
"schema_name" : "SYS",
"move_procedure" : "DBMS_XSOQ.OlapiMoveProc",
"move_procedure_desc" : "Move Procedure for OLAP API History Tables",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "STATSPACK",
"occupant_desc" : "Statspack Repository",
"schema_name" : "PERFSTAT",
"move_procedure" : "",
"move_procedure_desc" : "Use export/import (see export parameter file spuexp.par)",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "ULTRASEARCH_DEMO_USER",
"occupant_desc" : "Oracle Ultra Search Demo User",
"schema_name" : "WK_TEST",
"move_procedure" : "MOVE_WK",
"move_procedure_desc" : "Move Procedure for Oracle Ultra Search",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "EXPRESSION_FILTER",
"occupant_desc" : "Expression Filter System",
"schema_name" : "EXFSYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "TSM",
"occupant_desc" : "Oracle Transparent Session Migration User",
"schema_name" : "TSMSYS",
"move_procedure" : "",
"move_procedure_desc" : "*** MOVE PROCEDURE NOT APPLICABLE ***",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "XSAMD",
"occupant_desc" : "OLAP Catalog",
"schema_name" : "OLAPSYS",
"move_procedure" : "DBMS_AMD.Move_OLAP_Catalog",
"move_procedure_desc" : "Move Procedure for OLAP Catalog",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "AUDIT_TABLES",
"occupant_desc" : "DB audit tables",
"schema_name" : "SYS",
"move_procedure" : "DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION",
"move_procedure_desc" : "Move Procedure for Traditional DB audit tables",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "ORDIM",
"occupant_desc" : "Oracle Multimedia ORDSYS Components",
"schema_name" : "ORDSYS",
"move_procedure" : "ordsys.ord_admin.move_ordim_tblspc",
"move_procedure_desc" : "Move Procedure for Oracle Multimedia",
"space_usage_kbytes" : 0,
"con_id" : 1
},
{
"occupant_name" : "ULTRASEARCH",
"occupant_desc" : "Oracle Ultra Search",
"schema_name" : "WKSYS",
"move_procedure" : "MOVE_WK",
"move_procedure_desc" : "Move Procedure for Oracle Ultra Search",
"space_usage_kbytes" : 0,
"con_id" : 1
}
]
}
]
}
32 rows selected.
No comments:
Post a Comment