WARNING: Since the DB Time is less than one second, there was minimal foreground activity in the snapshot period. Some of the percentage values will be invalid. WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Startup Time Release RAC ------------ ----------- ------------ -------- --------------- ----------- --- MTCCDRT 3496176840 mtccdrt 1 15-Nov-20 17:16 11.2.0.4.0 NO Host Name Platform CPUs Cores Sockets Memory(GB) ---------------- -------------------------------- ---- ----- ------- ---------- mtccdrt01.mtcdc. Linux x86 64-bit .00 Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 90987 11-Feb-21 00:00:16 End Snap: 91010 11-Feb-21 23:00:29 Elapsed: 1,380.21 (mins) DB Time: 0.00 (mins) Load Profile Per Second Per Transaction Per Exec Per Call ~~~~~~~~~~~~~~~ --------------- --------------- --------- --------- DB Time(s): 0.0 0.0 0.00 0.00 DB CPU(s): 0.0 0.0 0.00 0.00 Redo size (bytes): Logical read (blocks): 0.0 1.0 Block changes: 0.0 1.0 Physical read (blocks): 0.0 1.0 Physical write (blocks): 0.0 1.0 Read IO requests: 0.0 1.0 Write IO requests: 0.0 1.0 Read IO (MB): 0.0 0.0 Write IO (MB): 0.0 0.0 User calls: 0.0 1.0 Parses (SQL): 0.0 1.0 Hard parses (SQL): SQL Work Area (MB): 0.0 0.0 Logons: Executes (SQL): 0.0 1.0 Rollbacks: Transactions: 0.0 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: Redo NoWait %: Buffer Hit %: In-memory Sort %: Library Hit %: Soft Parse %: Execute to Parse %: 0.00 Latch Hit %: Parse CPU to Parse Elapsd %: % Non-Parse CPU: Top 10 Foreground Events by Total Wait Time ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Tota Wait % DB Event Waits Time Avg(ms) time Wait Class ------------------------------ ------------ ---- ------- ------ ---------- DB CPU 0 100.0 Wait Classes by Total Wait Time ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg Avg Total Wait Wait % DB Active Wait Class Waits Time (sec) (ms) time Sessions ---------------- ---------------- ---------------- -------- ------ -------- DB CPU 0 100.0 0.0 Host CPU ~~~~~~~~ Load Average CPUs Cores Sockets Begin End %User %System %WIO %Idle ----- ----- ------- --------- --------- --------- --------- --------- --------- Instance CPU ~~~~~~~~~~~~ % of total CPU for Instance: % of busy CPU for Instance: %DB time waiting for CPU - Resource Mgr: IO Profile Read+Write/Second Read/Second Write/Second ~~~~~~~~~~ ----------------- --------------- --------------- Total Requests: 0.0 0.0 0.0 Database Requests: 0.0 0.0 0.0 Optimized Requests: 0.0 0.0 0.0 Redo Requests: Total (MB): 0.0 0.0 0.0 Database (MB): 0.0 0.0 0.0 Optimized Total (MB): 0.0 0.0 0.0 Redo (MB): Database (blocks): 0.0 0.0 0.0 Via Buffer Cache (blocks): Direct (blocks): 0.0 0.0 0.0 Memory Statistics ~~~~~~~~~~~~~~~~~ Begin End ------------ ------------ Host Mem (MB): SGA use (MB): PGA use (MB): % Host Mem used for SGA+PGA: Cache Sizes Begin End ~~~~~~~~~~~ ---------- ---------- Buffer Cache: 0M 0M Std Block Size: 0K Shared Pool Size: 0M 0M Log Buffer: 0K Shared Pool Statistics Begin End ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ------ ------ Memory Usage %: % SQL with executions>1: % Memory for SQL w/exec>1: Time Model Statistics DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Operating System Statistics DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Operating System Statistics - DetailDB/Inst: MTCCDRT/mtccdrt Snaps: 90987-910 No data exists for this section of the report. ------------------------------------------------------ Foreground Wait Class DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> s - second, ms - millisecond - 1000th of a second -> ordered by wait time desc, waits desc -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 -> Captured Time accounts for % of Total DB time .00 (s) -> Total FG Wait Time: (s) DB CPU time: .00 (s) Avg %Time Total Wait wait Wait Class Waits -outs Time (s) (ms) %DB time -------------------- ---------------- ----- ---------------- -------- --------- DB CPU 0 100.0 ------------------------------------------------------ Foreground Wait Events DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Background Wait Events DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Wait Event Histogram DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Wait Event Histogram Detail (64 msec to 2 sec)DB/Inst: MTCCDRT/mtccdrt Snaps No data exists for this section of the report. ------------------------------------------------------ Wait Event Histogram Detail (4 sec to 2 min)DB/Inst: MTCCDRT/mtccdrt Snaps: No data exists for this section of the report. ------------------------------------------------------ Wait Event Histogram Detail (4 min to 1 hr)DB/Inst: MTCCDRT/mtccdrt Snaps: 9 No data exists for this section of the report. ------------------------------------------------------ Service Statistics DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Service Wait Class Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by Elapsed Time DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by CPU Time DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by User I/O Wait TimeDB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by Gets DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by Reads DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by Physical Reads (UnOptimized)DB/Inst: MTCCDRT/mtccdrt Snaps: 9 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by Executions DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by Parse Calls DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by Sharable Memory DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by Version Count DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Key Instance Activity Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Other Instance Activity Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Instance Activity Stats - Absolute ValuesDB/Inst: MTCCDRT/mtccdrt Snaps: 909 No data exists for this section of the report. ------------------------------------------------------ Instance Activity Stats - Thread ActivityDB/Inst: MTCCDRT/mtccdrt Snaps: 9098 No data exists for this section of the report. ------------------------------------------------------ IOStat by Function summary DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ IOStat by Filetype summary DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ IOStat by Function/Filetype summaryDB/Inst: MTCCDRT/mtccdrt Snaps: 90987-9101 No data exists for this section of the report. ------------------------------------------------------ Tablespace IO Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ File IO Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Buffer Pool Statistics DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Checkpoint Activity DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Instance Recovery Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ MTTR Advisory DB/Inst: MTCCDRT/mtccdrt Snap: 91010 No data exists for this section of the report. ------------------------------------------------------ Buffer Pool Advisory DB/Inst: MTCCDRT/mtccdrt Snap: 91010 No data exists for this section of the report. ------------------------------------------------------ PGA Aggr Summary DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ PGA Aggr Target Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ PGA Aggr Target Histogram DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ PGA Memory Advisory DB/Inst: MTCCDRT/mtccdrt Snap: 91010 No data exists for this section of the report. ------------------------------------------------------ Shared Pool Advisory DB/Inst: MTCCDRT/mtccdrt Snap: 91010 No data exists for this section of the report. ------------------------------------------------------ SGA Target Advisory DB/Inst: MTCCDRT/mtccdrt Snap: 91010 No data exists for this section of the report. ------------------------------------------------------ Streams Pool Advisory DB/Inst: MTCCDRT/mtccdrt Snap: 91010 No data exists for this section of the report. ------------------------------------------------------ Java Pool Advisory DB/Inst: MTCCDRT/mtccdrt Snap: 91010 No data exists for this section of the report. ------------------------------------------------------ Buffer Wait Statistics DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Enqueue Activity DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Undo Segment Summary DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Undo Segment Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Latch Activity DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Latch Sleep Breakdown DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Latch Miss Sources DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Mutex Sleep Summary DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Parent Latch Statistics DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Child Latch Statistics DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Segments by Logical Reads DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> Total Logical Reads: 1 -> Captured Segments account for 6.1E+11% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- CDRUSER CDRT_DEFAU HUAWEIDATA_PROSP_TB_ TA_11FEB21 INDEX 445,927,136 4.5E+10 CDRUSER CDRT_DEFAU HD4G_UQ 4G_11FEB21 INDEX 309,493,744 3.1E+10 CDRUSER CDRT_DEFAU MSISDN_PROSP_IDX TA_11FEB21 INDEX 280,170,016 2.8E+10 CDRUSER CDRT_DEFAU IMEI14_PROSP_IDX TA_11FEB21 INDEX 279,485,472 2.8E+10 CDRUSER CDRT_DEFAU CDRGSM_PROSP_NIMSI_I SM_11FEB21 INDEX 262,007,952 2.6E+10 ------------------------------------------------------ Segments by Physical Reads DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> Total Physical Reads: 1 -> Captured Segments account for 1.1E+11% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM AUD$ TABLE 230,903,733 2.3E+10 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RISK_TB SM_25JAN21 TABLE 27,323,144 2.7E+09 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RISK_TB SM_21JAN21 TABLE 26,595,235 2.7E+09 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RISK_TB SM_08JAN21 TABLE 26,369,785 2.6E+09 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RISK_TB SM_13JAN21 TABLE 23,714,514 2.4E+09 ------------------------------------------------------ Segments by Physical Read RequestsDB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> Total Physical Read Requests: 1 -> Captured Segments account for 1.1E+09% of Total Tablespace Subobject Obj. Phys Read Owner Name Object Name Name Type Requests %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM AUD$ TABLE 1,804,476 1.8E+08 CDRUSER CDR_DEFAUL CDR_USSD_PK INDEX 378,953 3.8E+07 CDRUSER CDR_LOADIN DAILY_CDRGSM_PROSP_T PARTITION2 TABLE 350,110 3.5E+07 CDRUSER CDRT_DEFAU HD4G_COCC_UQ CC_04FEB21 INDEX 270,979 2.7E+07 CDRUSER CDRT_DEFAU HD4G_COCC_UQ CC_10FEB21 INDEX 214,608 2.1E+07 ------------------------------------------------------ Segments by UnOptimized Reads DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> Total UnOptimized Read Requests: 1 -> Captured Segments account for 1.1E+09% of Total Tablespace Subobject Obj. UnOptimized Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM AUD$ TABLE 1,804,476 1.8E+08 CDRUSER CDR_DEFAUL CDR_USSD_PK INDEX 378,953 3.8E+07 CDRUSER CDR_LOADIN DAILY_CDRGSM_PROSP_T PARTITION2 TABLE 350,110 3.5E+07 CDRUSER CDRT_DEFAU HD4G_COCC_UQ CC_04FEB21 INDEX 270,979 2.7E+07 CDRUSER CDRT_DEFAU HD4G_COCC_UQ CC_10FEB21 INDEX 214,608 2.1E+07 ------------------------------------------------------ Segments by Optimized Reads DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Segments by Direct Physical Reads DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> Total Direct Physical Reads: 1 -> Captured Segments account for 1.1E+11% of Total Tablespace Subobject Obj. Direct Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM AUD$ TABLE 230,903,733 2.3E+10 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RISK_TB SM_25JAN21 TABLE 27,322,832 2.7E+09 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RISK_TB SM_21JAN21 TABLE 26,594,802 2.7E+09 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RISK_TB SM_08JAN21 TABLE 26,369,330 2.6E+09 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RISK_TB SM_13JAN21 TABLE 23,714,196 2.4E+09 ------------------------------------------------------ Segments by Physical Writes DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> Total Physical Writes: 1 -> Captured Segments account for 1.3E+10% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- CDRUSER CDRT_DEFAU IMEI14_PROSP_IDX TA_11FEB21 INDEX 12,855,365 1.3E+09 CDRUSER CDRT_DEFAU MSISDN_PROSP_IDX TA_11FEB21 INDEX 12,550,540 1.3E+09 CDRUSER CDRT_DEFAU CDRGSM_PROSP_NIMSI_I SM_11FEB21 INDEX 8,099,432 8.1E+08 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RIMSI_I SM_11FEB21 INDEX 7,955,597 8.0E+08 CDRUSER CDRT_DEFAU CDRGSM_PROSP_NIMEI14 SM_11FEB21 INDEX 7,740,735 7.7E+08 ------------------------------------------------------ Segments by Physical Write RequestsDB/Inst: MTCCDRT/mtccdrt Snaps: 90987-9101 -> Total Physical Write Requestss: 1 -> Captured Segments account for 2.2E+09% of Total Tablespace Subobject Obj. Phys Write Owner Name Object Name Name Type Requests %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- CDRUSER CDRT_DEFAU IMEI14_PROSP_IDX TA_11FEB21 INDEX 1,658,566 1.7E+08 CDRUSER CDRT_DEFAU MSISDN_PROSP_IDX TA_11FEB21 INDEX 1,473,177 1.5E+08 CDRUSER CDRT_DEFAU HD4G_COCC_UQ CC_08FEB21 INDEX 1,164,007 1.2E+08 CDRUSER CDRT_DEFAU HD4G_UQ 4G_08FEB21 INDEX 1,045,838 1.0E+08 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RIMSI_I SM_11FEB21 INDEX 968,317 9.7E+07 ------------------------------------------------------ Segments by Direct Physical WritesDB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> Total Direct Physical Writes: 1 -> Captured Segments account for 1.4E+09% of Total Tablespace Subobject Obj. Direct Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- CDRUSER CDRT_DEFAU HD4G_TB 4G_03FEB21 TABLE 1,023,132 1.0E+08 CDRUSER CDRT_DEFAU CDRGSM_PROSP_RISK_TB SM_03FEB21 TABLE 891,093 8.9E+07 CDRUSER CDRT_DEFAU HUAWEIDATA_PROSP_TB TA_03FEB21 TABLE 779,032 7.8E+07 CDRUSER CDRT_DEFAU HUAWEIDATA_PROSP_TB_ TA_03FEB21 INDEX 726,565 7.3E+07 CDRUSER CDRT_DEFAU HD4G_COCC_UQ CC_03FEB21 INDEX 553,138 5.5E+07 ------------------------------------------------------ Segments by Table Scans DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> Total Table Scans: 1 -> Captured Segments account for 1.6E+07% of Total Tablespace Subobject Obj. Table Owner Name Object Name Name Type Scans %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- CDRUSER RISK_ARCH_ CDRGSM_PROSP_RISK_TB SM_18SEP15 TABLE 4,544 4.5E+05 CDRUSER RISK_ARCH_ CDRGSM_PROSP_RISK_TB SM_25SEP15 TABLE 4,540 4.5E+05 CDRUSER RISK_ARCH_ CDRGSM_PROSP_RISK_TB SM_28DEC17 TABLE 4,470 4.5E+05 CDRUSER RISK_ARCH_ CDRGSM_PROSP_RISK_TB SM_10NOV17 TABLE 4,429 4.4E+05 CDRUSER RISK_ARCH_ CDRGSM_PROSP_RISK_TB SM_23MAY16 TABLE 4,409 4.4E+05 ------------------------------------------------------ Segments by DB Blocks Changes DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> % of Capture shows % of DB Block Changes for each top segment compared -> with total DB Block Changes for all segments captured by the Snapshot Tablespace Subobject Obj. DB Block % of Owner Name Object Name Name Type Changes Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- CDRUSER CDRT_DEFAU HUAWEIDATA_PROSP_TB_ TA_11FEB21 INDEX 88,307,232 6.38 CDRUSER CDRT_DEFAU IMEI14_PROSP_IDX TA_11FEB21 INDEX 80,439,408 5.81 CDRUSER CDRT_DEFAU MSISDN_PROSP_IDX TA_11FEB21 INDEX 80,146,080 5.79 CDRUSER CDRT_DEFAU CELLID_PROSP_IDX TA_11FEB21 INDEX 78,773,296 5.69 CDRUSER CDRT_DEFAU CDRGSM_PROSP_NGLOBCE SM_11FEB21 INDEX 74,200,064 5.36 ------------------------------------------------------ Segments by Row Lock Waits DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> % of Capture shows % of row lock waits for each top segment compared -> with total row lock waits for all segments captured by the Snapshot Row Tablespace Subobject Obj. Lock % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- CDRUSER CDRT_DEFAU CDRGSM_PROSP_N_UQ SM_11FEB21 INDEX 5,091 6.53 CDRUSER CDRT_DEFAU SYSTEMTYPE_PROSP_IDX TA_11FEB21 INDEX 4,775 6.12 CDRUSER CDRT_DEFAU LOCALSEQ_PROSP_IDX TA_11FEB21 INDEX 3,568 4.57 CDRUSER CDRT_DEFAU RECORDTYPE_PROSP_IDX TA_11FEB21 INDEX 3,385 4.34 CDRUSER CDRT_DEFAU HD4G_COCC_UQ CC_11FEB21 INDEX 3,316 4.25 ------------------------------------------------------ Segments by ITL Waits DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> % of Capture shows % of ITL waits for each top segment compared -> with total ITL waits for all segments captured by the Snapshot Tablespace Subobject Obj. ITL % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM SEG$ TABLE 343 31.79 CDRUSER CDRT_DEFAU CELLID_PROSP_IDX TA_11FEB21 INDEX 188 17.42 CDRUSER CDRT_DEFAU CDRGSM_PROSP_N_UQ SM_11FEB21 INDEX 98 9.08 CDRUSER CDR_DEFAUL SERVICE_CODE_IDX INDEX 66 6.12 SYS SYSAUX I_WRI$_OPTSTAT_H_ST INDEX 51 4.73 ------------------------------------------------------ Segments by Buffer Busy Waits DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 -> % of Capture shows % of Buffer Busy Waits for each top segment compared -> with total Buffer Busy Waits for all segments captured by the Snapshot Buffer Tablespace Subobject Obj. Busy % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM AUDIT_SERVER_ERROR_L TABLE 6,094 36.27 CDRUSER CDRT_DEFAU CDRGSM_PROSP_NCALLTY SM_11FEB21 INDEX 3,043 18.11 CDRUSER CDR_LOADIN CDRGSM_PROSP_TB SM_11FEB21 TABLE 1,844 10.97 SYS SYSTEM FGA_LOG$ TABLE 1,586 9.44 SYS SYSTEM SEG$ TABLE 1,401 8.34 ------------------------------------------------------ Dictionary Cache Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Library Cache Activity DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Memory Dynamic Components DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Memory Resize Operations Summary DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Memory Resize Ops DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Process Memory Summary DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ ------------------- sum ------------------------------------------------------ SGA breakdown difference DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Streams CPU/IO Usage DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Streams Capture DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Streams Capture Rate DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Streams Apply DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Streams Apply Rate DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Buffered Queues DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Buffered Queue Subscribers DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Rule Set DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Persistent Queues DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Persistent Queues Rate DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Persistent Queue Subscribers DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Resource Limit Stats DB/Inst: MTCCDRT/mtccdrt Snap: 91010 No data exists for this section of the report. ------------------------------------------------------ Shared Servers Activity DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Shared Servers Rates DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Shared Servers Utilization DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Shared Servers Common Queue DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Shared Servers Dispatchers DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ init.ora Parameters DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ init.ora Multi-Valued Parameters DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ Dynamic Remastering Stats DB/Inst: MTCCDRT/mtccdrt Snaps: 90987-91010 No data exists for this section of the report. ------------------------------------------------------ End of Report