Oracle Database Discussions

Hi,

I was just asked to take a look at a 11g database server for a non-profit organization and Oracle isn't exactly my strong point. The server in question has been neglected for at least a year if not longer and the database on it has filled up the hard drive of the mount point on the server.

After some reading on this forum and others I used the following sqlplus command:

select TABLE_NAME, ROUND((AVG_ROW_LEN * NUM_ROWS / 1024), 2) SIZE_MB from USER_TABLES order by TABLE_NAME;

And discovered several tables that appear to be eating up space (listed below, I've included any tables that had a significant amount of data). I know from asking around that this database has seen very little use and the data was uploaded via a datapump file (a < 4GB file) a few years ago.

My guess is from looking at this is the metrics have grown out of control but I'm not sure what to do about it. Can someone point me in the right direction on cleaning up (ie. purging) old metrics data? Thanks!


TABLE_NAME SIZE_MB
------------------------------ ----------
AQ$_SUBSCRIBER_TABLE .01
AQ$_SYS$SERVICE_METRICS_TAB_G 0
AQ$_SYS$SERVICE_METRICS_TAB_H 0
AQ$_SYS$SERVICE_METRICS_TAB_I 0
AQ$_SYS$SERVICE_METRICS_TAB_S .15
AQ$_SYS$SERVICE_METRICS_TAB_T 0
AQ_EVENT_TABLE
AQ_PROP_TABLE
AQ_SRVNTFN_TABLE
ARGUMENT$ 5193.08
ASSEMBLY$ 0

TABLE_NAME SIZE_MB
------------------------------ ----------
ASSOCIATION$ .05
ATEMPTAB$
ATTRCOL$ 55.16
ATTRIBUTE$ 360.42
ATTRIBUTE_TRANSFORMATIONS$ .09
AUD$ 773.1
AUDIT$ .28
AUDIT_ACTIONS 3.08
AUX_STATS$ .36
AW$ 0
AW_OBJ$ 0

TABLE_NAME SIZE_MB
------------------------------ ----------
AW_PRG$ 0
AW_PROP$ 0
AW_TRACK$ 0
BOOTSTRAP$ 17.11
CACHE_STATS_0$ 0
CACHE_STATS_1$ 0
CCOL$ 121.37
CDC_CHANGE_COLUMNS$ 0
CDC_CHANGE_SETS$ .07
CDC_CHANGE_SOURCES$ .15
CDC_CHANGE_TABLES$ 0

TABLE_NAME SIZE_MB
------------------------------ ----------
CDC_PROPAGATED_SETS$ 0
CDC_PROPAGATIONS$ 0
CDC_SUBSCRIBED_COLUMNS$ 0
CDC_SUBSCRIBED_TABLES$ 0
CDC_SUBSCRIBERS$ 0
CDC_SYSTEM$ 0
CDEF$ 209.6
CHNF$_CLAUSES 0
CHNF$_CLAUSE_DEPENDENTS 0
CHNF$_GROUP_FILTER_IOT 0
CHNF$_QUERIES 0

TABLE_NAME SIZE_MB
------------------------------ ----------
CHNF$_QUERY_BINDS 0
CHNF$_QUERY_DELTAS
CHNF$_QUERY_OBJECT 0
CHNF$_REG_QUERIES 0
CHNFDIRECTLOAD$ 0
CLU$ .44
CLUSTER_DATABASES
CLUSTER_INSTANCES
CLUSTER_NODES
COL$ 3708.26
COLLECTION$ 24.47

TABLE_NAME SIZE_MB
------------------------------ ----------
COLTYPE$ 85.78
COL_USAGE$ 60.41
COM$ 614.25
COMPARISON$ 0
COMPARISON_COL$ 0
COMPARISON_ROW_DIF$ 0
COMPARISON_SCAN$ 0
COMPARISON_SCAN_VAL$ 0
CON$ 132.95
CONTEXT$ .03
CPOOL$ .07

TABLE_NAME SIZE_MB
------------------------------ ----------
DEFSUBPART$ 0
DEFSUBPARTLOB$ 0
DEPENDENCY$ 2396.82
DIANA_VERSION$ 0
DIM$ 0
DIMATTR$ 0
DIMJOINKEY$ 0
DIMLEVEL$ 0
DIMLEVELKEY$ 0
DIR$ .32
DIR$ALERT_HISTORY 0

TABLE_NAME SIZE_MB
------------------------------ ----------
FGR$_FILE_GROUP_EXPORT_INFO 0
FGR$_FILE_GROUP_FILES 0
FGR$_FILE_GROUP_VERSIONS 0
FGR$_TABLESPACE_INFO 0
FGR$_TABLE_INFO 0
FILE$ .52
FINALHIST$
FIXED_OBJ$ 12.8
HIER$ 0
HIERLEVEL$ 0
HISTGRM$ 1650.34

TABLE_NAME SIZE_MB
------------------------------ ----------
HIST_HEAD$ 1205.51
HS$_BASE_CAPS 13.41
HS$_BASE_DD 1.69
HS$_CLASS_CAPS 0
HS$_CLASS_DD 0
HS$_CLASS_INIT 0
HS$_FDS_CLASS .03
HS$_FDS_CLASS_DATE .01
HS$_FDS_INST 0
HS$_INST_CAPS 0
HS$_INST_DD 0

TABLE_NAME SIZE_MB
------------------------------ ----------
HS$_INST_INIT 0
HS$_PARALLEL_HISTOGRAM_DATA 0
HS$_PARALLEL_METADATA 0
HS$_PARALLEL_PARTITION_DATA 0
HS$_PARALLEL_SAMPLE_DATA 0
HS_BULKLOAD_VIEW_OBJ 0
HS_PARTITION_COL_NAME 0
HS_PARTITION_COL_TYPE 0
ICOL$ 104.3
ICOLDEP$ .3
IDL_CHAR$ 61.54

TABLE_NAME SIZE_MB
------------------------------ ----------
IDL_SB4$ 166.79
IDL_UB1$ 521.14
IDL_UB2$ 128.96
ID_GENS$ 0
IMPDP_STATS
INCEXP 0
INCFIL 0
INCVID 0
IND$ 184.08
INDARRAYTYPE$ 0
INDCOMPART$ 0

TABLE_NAME SIZE_MB
------------------------------ ----------
JAVA$COMPILER$OPTIONS 0
JAVA$JVM$RJBC 0
JAVA$JVM$RUNTIME$PARAMETERS 0
JAVA$JVM$STATUS .01
JAVA$JVM$STEPS$DONE 0
JAVA$MC$ 52.01
JAVA$POLICY$ 7.45
JAVA$POLICY$SHARED$TABLE .01
JAVA$PREFS$ .12
JAVA$RMJVM$AUX 0
JAVA$RMJVM$AUX2 0

TABLE_NAME SIZE_MB
------------------------------ ----------
JAVA$RMJVM$AUX3 0
JAVAJAR$ .35
JAVAJAROBJECTS$ 6.62
JAVAOBJ$ 872.72
JAVASNM$ 996.69
JIJOIN$ 0
JIREFRESHSQL$ 0
JOB$ 0
KET$_AUTOTASK_STATUS .08
KET$_CLIENT_CONFIG .25
KET$_CLIENT_TASKS .59

TABLE_NAME SIZE_MB
------------------------------ ----------
KOPM$ .11
KU$NOEXP_TAB
KU$_EXPDP_IMPDP_MASTER_10_1
KU$_EXPDP_IMPDP_MASTER_11_1
KU$_LIST_FILTER_TEMP
KUPC$DATAPUMP_QUETAB
KU_NOEXP_TAB 2.73
KU_UTLUSE .16
LIBRARY$ 7.11
LINK$ 0
LOB$ 24.55

TABLE_NAME SIZE_MB
------------------------------ ----------
METAFILTER$ 213.81
METANAMETRANS$ 208.23
METAPATHMAP$ 43.2
METASCRIPT$ 48.95
METASCRIPTFILTER$ 560.54
METASTYLESHEET 148.28
METAVIEW$ 22.39
METAXSL$ 10.72
METAXSLPARAM$ 48.77
METHOD$ 74.2
MIGRATE$ 0

TABLE_NAME SIZE_MB
------------------------------ ----------
NTAB$ 3.63
OBJ$ 4506.32
OBJAUTH$ 508.75
OBJECT_USAGE 0
OBJERROR$ 0
OBJPRIV$ 0
ODCI_PMO_ROWIDS$
ODCI_SECOBJ$
ODCI_WARNINGS$
OID$ 39.09
OLAP_ATTRIBUTES$ 0

TABLE_NAME SIZE_MB
------------------------------ ----------
OLAP_TAB$ 0
OLAP_TAB_COL$ 0
OLAP_TAB_HIER$ 0
OPANCILLARY$ .13
OPARG$ .55
OPBINDING$ 1.05
OPERATOR$ .16
OPQTYPE$ 3.64
OPTSTAT_HIST_CONTROL$ .7
OPTSTAT_USER_PREFS$ 0
PARAMETER$ 280.58

TABLE_NAME SIZE_MB
------------------------------ ----------
PLSQL_PROFILER_UNITS 0
PROCEDURE$ 79.29
PROCEDUREC$ 11.5
PROCEDUREINFO$ 413.44
PROCEDUREJAVA$ 57.23
PROCEDUREPLSQL$ 92.88
PROFILE$ .43
PROFNAME$ .02
PROPS$ 1.56
PROXY_DATA$ 0
PROXY_INFO$ 0

TABLE_NAME SIZE_MB
------------------------------ ----------
REGISTRY$LOG 2.64
REGISTRY$NONSYS_INV_OBJS 1.78
REGISTRY$PROGRESS 0
REGISTRY$SCHEMAS .07
REGISTRY$SYS_INV_OBJS 2.24
REG_SNAP$ 0
RESOURCE_CAPABILITY$ .01
RESOURCE_CATEGORY$ .25
RESOURCE_CONSUMER_GROUP$ 1.45
RESOURCE_COST$ .04
RESOURCE_GROUP_MAPPING$ .19

TABLE_NAME SIZE_MB
------------------------------ ----------
RESOURCE_INSTANCE_CAPABILITY$ 0
RESOURCE_IO_CALIBRATE$ 0
RESOURCE_MAP .36
RESOURCE_MAPPING_PRIORITY$ .26
RESOURCE_PLAN$ 1.76
RESOURCE_PLAN_DIRECTIVE$ 5.34
RESOURCE_STORAGE_POOL_MAPPING$ .09
RESULT$ 48.68
RGCHILD$ 0
RGROUP$ 0
RLS$ 4.08

TABLE_NAME SIZE_MB
------------------------------ ----------
SCHEDULER$_CREDENTIAL 0
SCHEDULER$_EVENT_LOG 4318.88
SCHEDULER$_EVENT_QTAB
SCHEDULER$_EVTQ_SUB 0
SCHEDULER$_GLOBAL_ATTRIBUTE .15
SCHEDULER$_JOB 6.74
SCHEDULER$_JOB_ARGUMENT .04
SCHEDULER$_JOB_RUN_DETAILS 306.82
SCHEDULER$_LIGHTWEIGHT_JOB 0
SCHEDULER$_LWJOB_OBJ 0
SCHEDULER$_PROGRAM 10.62

TABLE_NAME SIZE_MB
------------------------------ ----------
SCHEDULER$_PROGRAM_ARGUMENT 4.64
SCHEDULER$_REMDB_JOBQTAB
SCHEDULER$_REMOTE_DBS 0
SCHEDULER$_REMOTE_JOB_STATE 0
SCHEDULER$_RJOB_SRC_DB_INFO 0
SCHEDULER$_SAVED_OIDS 39.49
SCHEDULER$_SCHEDULE .15
SCHEDULER$_SRCQ_INFO 0
SCHEDULER$_SRCQ_MAP 0
SCHEDULER$_STEP 0
SCHEDULER$_STEP_STATE 0

TABLE_NAME SIZE_MB
------------------------------ ----------
SCHEDULER$_WINDOW 1.62
SCHEDULER$_WINDOW_DETAILS 1.35
SCHEDULER$_WINDOW_GROUP .14
SCHEDULER$_WINGRP_MEMBER .27
SECOBJ$ .01
SEG$ 275.88
SEQ$ 16.85
SERVICE$ .12
SETTINGS$ 760.47
SLOG$ 0
SMB$CONFIG .06

TABLE_NAME SIZE_MB
------------------------------ ----------
SMON_SCN_TIME 1737.37
SNAP$ 0
SNAP_COLMAP$ 0
SNAP_LOADERTIME$ 0
SNAP_LOGDEP$ 0
SNAP_OBJCOL$ 0
SNAP_REFOP$ 0
SNAP_REFTIME$ 0
SNAP_SITE$ 0
SOURCE$ 22215.3
SQL$ 0

TABLE_NAME SIZE_MB
------------------------------ ----------
SSCR_RES$ 0
STATS_TARGET$ 17.02
STMT_AUDIT_OPTION_MAP 5.59
STREAMS$_APPLY_MILESTONE 0
STREAMS$_APPLY_PROCESS 0
STREAMS$_APPLY_PROGRESS 0
STREAMS$_APPLY_SPILL_MESSAGES 0
STREAMS$_APPLY_SPILL_MSGS_PART 0
STREAMS$_APPLY_SPILL_TXN 0
STREAMS$_APPLY_SPILL_TXN_LIST 0
STREAMS$_CAPTURE_PROCESS 0


TABLE_NAME SIZE_MB
------------------------------ ----------
SUMDELTA$
SUMDEP$ 0
SUMDETAIL$ 0
SUMINLINE$ 0
SUMJOIN$ 0
SUMKEY$ 0
SUMPARTLOG$ 0
SUMPRED$ 0
SUMQB$ 0
SUPEROBJ$ 0
SYN$ 766

TABLE_NAME SIZE_MB
------------------------------ ----------
SYS_IOT_OVER_57387 0
SYS_IOT_OVER_57409 0
SYS_IOT_OVER_70778 0
SYS_MFBA_NCHANGE
SYS_MFBA_NROW
SYS_MFBA_NTCRV
SYS_MFBA_STAGE_RID
SYS_MFBA_TRACKED_TXN
TAB$ 197.34
TABCOMPART$ 0
TABLE_PRIVILEGE_MAP .28

TABLE_NAME SIZE_MB
------------------------------ ----------
TABPART$ 40.56
TABSUBPART$ 0
TAB_STATS$ 0
TRANSACTION_BACKOUT_REPORT$ 0
TRANSACTION_BACKOUT_STATE$ 0
TRANSFORMATIONS$ .28
TRIGGER$ 29.9
TRIGGERCOL$ 55.55
TRIGGERDEP$ 0
TRIGGERJAVAC$ 0
TRIGGERJAVAF$ 0

TABLE_NAME SIZE_MB
------------------------------ ----------
TRIGGERJAVAM$ 0
TRIGGERJAVAS$ 0
TRUSTED_LIST$ 0
TS$ .76
TSM_DST$ 0
TSM_SRC$ 0
TSQ$ .17
TTS_ERROR$
TTS_TBS$
TTS_USR$
TYPE$ 100.32

TABLE_NAME SIZE_MB
------------------------------ ----------
TYPED_VIEW$ 16.8
TYPEHIERARCHY$ .35
TYPE_MISC$ 61.59
UET$ 101.08
UGROUP$ 0
UNDO$ .77
USER$ 4.31
USER_ASTATUS_MAP .17
USER_HISTORY$ .22
USTATS$ .03
UTL_RECOMP_COMPILED .27

TABLE_NAME SIZE_MB
------------------------------ ----------
UTL_RECOMP_ERRORS 0
UTL_RECOMP_SORTED 0
VIEW$ 198.61
VIEWCON$ 0
VIEWTRCOL$ 0
VTABLE$ 52.78
WARNING_SETTINGS$ 158.67
WRH$_ACTIVE_SESSION_HISTORY 121.83
WRH$_ACTIVE_SESSION_HISTORY_BL 0
WRH$_BG_EVENT_SUMMARY 490.28
WRH$_BUFFERED_QUEUES 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_BUFFERED_SUBSCRIBERS 0
WRH$_BUFFER_POOL_STATISTICS 23.09
WRH$_CLUSTER_INTERCON 0
WRH$_COMP_IOSTAT 0
WRH$_CR_BLOCK_SERVER 0
WRH$_CURRENT_BLOCK_SERVER 0
WRH$_DATAFILE 1.03
WRH$_DB_CACHE_ADVICE 290.39
WRH$_DB_CACHE_ADVICE_BL 0
WRH$_DLM_MISC 0
WRH$_DLM_MISC_BL 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_ENQUEUE_STAT 731.45
WRH$_EVENT_HISTOGRAM 2826.61
WRH$_EVENT_HISTOGRAM_BL 0
WRH$_EVENT_NAME 65.5
WRH$_FILEMETRIC_HISTORY 0
WRH$_FILESTATXS 180.69
WRH$_FILESTATXS_BL 0
WRH$_IC_CLIENT_STATS 0
WRH$_IC_DEVICE_STATS 0
WRH$_INSTANCE_RECOVERY 12.69
WRH$_INST_CACHE_TRANSFER 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_INST_CACHE_TRANSFER_BL 0
WRH$_INTERCONNECT_PINGS 0
WRH$_INTERCONNECT_PINGS_BL 0
WRH$_IOSTAT_FILETYPE 145.45
WRH$_IOSTAT_FILETYPE_NAME .28
WRH$_IOSTAT_FUNCTION 122.26
WRH$_IOSTAT_FUNCTION_NAME .24
WRH$_JAVA_POOL_ADVICE 14.63
WRH$_LATCH 5553.38
WRH$_LATCH_BL 0
WRH$_LATCH_CHILDREN 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_LATCH_CHILDREN_BL 0
WRH$_LATCH_MISSES_SUMMARY 1223.79
WRH$_LATCH_MISSES_SUMMARY_BL 0
WRH$_LATCH_NAME 19.77
WRH$_LATCH_PARENT 0
WRH$_LATCH_PARENT_BL 0
WRH$_LIBRARYCACHE 124.14
WRH$_LOG 37.62
WRH$_MEMORY_RESIZE_OPS 0
WRH$_MEMORY_TARGET_ADVICE 40.13
WRH$_MEM_DYNAMIC_COMP 224.03

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_METRIC_NAME 20.34
WRH$_MTTR_TARGET_ADVICE 0
WRH$_MUTEX_SLEEP 68.76
WRH$_OPTIMIZER_ENV 6.09
WRH$_OSSTAT 127.22
WRH$_OSSTAT_BL 0
WRH$_OSSTAT_NAME .56
WRH$_PARAMETER 2671.13
WRH$_PARAMETER_BL 0
WRH$_PARAMETER_NAME 74.51
WRH$_PERSISTENT_QUEUES 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_PERSISTENT_SUBSCRIBERS 0
WRH$_PGASTAT 137.97
WRH$_PGA_TARGET_ADVICE 149.21
WRH$_PROCESS_MEMORY_SUMMARY 56.58
WRH$_RESOURCE_LIMIT 46.81
WRH$_ROWCACHE_SUMMARY 773.22
WRH$_ROWCACHE_SUMMARY_BL 0
WRH$_RSRC_CONSUMER_GROUP 9.93
WRH$_RSRC_PLAN .6
WRH$_RULE_SET 0
WRH$_SEG_STAT 2043.81

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_SEG_STAT_BL 0
WRH$_SEG_STAT_OBJ 85.31
WRH$_SERVICE_NAME .08
WRH$_SERVICE_STAT 619.5
WRH$_SERVICE_STAT_BL 0
WRH$_SERVICE_WAIT_CLASS 281.63
WRH$_SERVICE_WAIT_CLASS_BL 0
WRH$_SESSMETRIC_HISTORY 0
WRH$_SESS_TIME_STATS 0
WRH$_SGA 29.12
WRH$_SGASTAT 141.1

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_SGASTAT_BL 0
WRH$_SGA_TARGET_ADVICE 46.81
WRH$_SHARED_POOL_ADVICE 183.91
WRH$_SQLSTAT 5101.31
WRH$_SQLSTAT_BL 0
WRH$_SQLTEXT 56.46
WRH$_SQL_BIND_METADATA 65.96
WRH$_SQL_PLAN 649.51
WRH$_SQL_SUMMARY 7.28
WRH$_SQL_WORKAREA_HISTOGRAM 79.41
WRH$_STAT_NAME 21.86

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_STREAMS_APPLY_SUM 0
WRH$_STREAMS_CAPTURE 0
WRH$_STREAMS_POOL_ADVICE 0
WRH$_SYSMETRIC_HISTORY 11033.52
WRH$_SYSMETRIC_SUMMARY 2196.01
WRH$_SYSSTAT 2886.62
WRH$_SYSSTAT_BL 0
WRH$_SYSTEM_EVENT 802.72
WRH$_SYSTEM_EVENT_BL 0
WRH$_SYS_TIME_MODEL 118.23
WRH$_SYS_TIME_MODEL_BL 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRH$_TABLESPACE_SPACE_USAGE 81.92
WRH$_TABLESPACE_STAT 108.78
WRH$_TABLESPACE_STAT_BL 0
WRH$_TEMPFILE .07
WRH$_TEMPSTATXS 12.69
WRH$_THREAD 8.32
WRH$_UNDOSTAT 119.12
WRH$_WAITCLASSMETRIC_HISTORY 0
WRH$_WAITSTAT 136.9
WRH$_WAITSTAT_BL 0
WRI$_ADV_ACTIONS 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRI$_ADV_ADDM_FDG 11
WRI$_ADV_ADDM_INST 31.88
WRI$_ADV_ADDM_TASKS 71.01
WRI$_ADV_ASA_RECO_DATA
WRI$_ADV_DEFINITIONS .26
WRI$_ADV_DEF_EXEC_TYPES .16
WRI$_ADV_DEF_PARAMETERS 18.26
WRI$_ADV_DIRECTIVE_DEFS .33
WRI$_ADV_DIRECTIVE_INSTANCES 0
WRI$_ADV_DIRECTIVE_META 1.24
WRI$_ADV_EXECUTIONS 43.03

TABLE_NAME SIZE_MB
------------------------------ ----------
WRI$_ADV_EXEC_PARAMETERS 0
WRI$_ADV_FINDINGS 41
WRI$_ADV_INST_FDG 0
WRI$_ADV_JOURNAL 0
WRI$_ADV_MESSAGE_GROUPS 122.19
WRI$_ADV_OBJECTS 3.41
WRI$_ADV_OBJSPACE_CHROW_DATA
WRI$_ADV_OBJSPACE_TREND_DATA
WRI$_ADV_PARAMETERS 1590.33
WRI$_ADV_RATIONALE 0
WRI$_ADV_RECOMMENDATIONS 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRI$_ADV_REC_ACTIONS 0
WRI$_ADV_SQLA_COLVOL 0
WRI$_ADV_SQLA_FAKE_REG 0
WRI$_ADV_SQLA_MAP 0
WRI$_ADV_SQLA_STMTS 0
WRI$_ADV_SQLA_SUM 0
WRI$_ADV_SQLA_TABLES 0
WRI$_ADV_SQLA_TABVOL 0
WRI$_ADV_SQLA_TMP 0
WRI$_ADV_SQLT_BINDS 0
WRI$_ADV_SQLT_PLANS 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRI$_ADV_SQLT_PLAN_HASH 0
WRI$_ADV_SQLT_PLAN_STATS 0
WRI$_ADV_SQLT_RTN_PLAN 0
WRI$_ADV_SQLT_STATISTICS 0
WRI$_ADV_SQLW_COLVOL 0
WRI$_ADV_SQLW_STMTS 0
WRI$_ADV_SQLW_SUM 0
WRI$_ADV_SQLW_TABLES 0
WRI$_ADV_SQLW_TABVOL 0
WRI$_ADV_TASKS 133.51
WRI$_ADV_USAGE .13

TABLE_NAME SIZE_MB
------------------------------ ----------
WRI$_AGGREGATION_ENABLED 0
WRI$_ALERT_HISTORY 0
WRI$_ALERT_OUTSTANDING .13
WRI$_ALERT_THRESHOLD .05
WRI$_ALERT_THRESHOLD_LOG 0
WRI$_DBU_CPU_USAGE .03
WRI$_DBU_CPU_USAGE_SAMPLE .09
WRI$_DBU_FEATURE_METADATA 23.33
WRI$_DBU_FEATURE_USAGE 13.66
WRI$_DBU_HIGH_WATER_MARK 1.41
WRI$_DBU_HWM_METADATA 2.47

TABLE_NAME SIZE_MB
------------------------------ ----------
WRI$_DBU_USAGE_SAMPLE .09
WRI$_OPTSTAT_AUX_HISTORY 0
WRI$_OPTSTAT_HISTGRM_HISTORY 15727.52
WRI$_OPTSTAT_HISTHEAD_HISTORY 5178.78
WRI$_OPTSTAT_IND_HISTORY 353.06
WRI$_OPTSTAT_OPR 4.58
WRI$_OPTSTAT_SYNOPSIS$ 0
WRI$_OPTSTAT_SYNOPSIS_HEAD$ 0
WRI$_OPTSTAT_SYNOPSIS_PARTGRP 0
WRI$_OPTSTAT_TAB_HISTORY 282.39
WRI$_REPT_COMPONENTS .19

TABLE_NAME SIZE_MB
------------------------------ ----------
WRI$_REPT_FILES 12.23
WRI$_REPT_FORMATS .36
WRI$_REPT_REPORTS .25
WRI$_SCH_CONTROL .03
WRI$_SCH_VOTES .07
WRI$_SEGADV_CNTRLTAB .82
WRI$_SEGADV_OBJLIST 4
WRI$_SQLSET_BINDS 0
WRI$_SQLSET_DEFINITIONS 0
WRI$_SQLSET_MASK 0
WRI$_SQLSET_PLANS 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRI$_SQLSET_PLANS_TOCAP
WRI$_SQLSET_PLAN_LINES 0
WRI$_SQLSET_REFERENCES 0
WRI$_SQLSET_STATEMENTS 0
WRI$_SQLSET_STATISTICS 0
WRI$_SQLSET_WORKSPACE 0
WRI$_SQLSET_WORKSPACE_PLANS 0
WRI$_TRACING_ENABLED 0
WRM$_BASELINE .05
WRM$_BASELINE_DETAILS 0
WRM$_BASELINE_TEMPLATE 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRM$_COLORED_SQL 0
WRM$_DATABASE_INSTANCE 4.36
WRM$_SNAPSHOT 12.06
WRM$_SNAP_ERROR 0
WRM$_WR_CONTROL .08
WRR$_CAPTURES 0
WRR$_CAPTURE_STATS 0
WRR$_CONNECTION_MAP 0
WRR$_FILTERS 0
WRR$_REPLAYS 0
WRR$_REPLAY_DIVERGENCE 0

TABLE_NAME SIZE_MB
------------------------------ ----------
WRR$_REPLAY_SCN_ORDER 0
WRR$_REPLAY_SEQ_DATA 0
WRR$_REPLAY_STATS 0
XDB$XTAB 0
XDB$XTABCOLS 0
XDB$XTABNMSP 0
XDB_INSTALLATION_TAB 3.82
XS$PARAMETERS 0
XS$SESSIONS 0
XS$SESSION_APPNS 0
XS$SESSION_HWS 0

TABLE_NAME SIZE_MB
------------------------------ ----------
XS$SESSION_ROLES 0
XS$VERIFIERS 0
defaultauditing_options_ 0

872 rows selected.

SQL>
--------------------------------------------------------------