WORKLOAD REPOSITORY PDB report (root snapshots) DB Name DB Id Unique Name DB Role Edition Release RAC CDB ------------ ----------- ----------- ---------------- ------- ---------- --- --- CDRDB 3758444401 cdrdb PRIMARY EE 19.0.0.0.0 NO YES Instance Inst Num Startup Time ------------ -------- --------------- cdrdb 1 31-Jan-21 15:29 Container DB Id Container Name Open Time --------------- --------------- --------------- 4100670825 PCDRDB 03-Feb-21 16:01 Host Name Platform CPUs Cores Sockets Memory(GB) ---------------- -------------------------------- ---- ----- ------- ---------- mtccdrdb01.mtcdc Linux x86 64-bit 56 28 2 565.66 Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 309 13-Feb-21 12:00:25 0 1.0 End Snap: 311 13-Feb-21 14:00:43 2 4.5 Elapsed: 120.30 (mins) DB Time: 86.54 (mins) Load Profile Per Second Per Transaction Per Exec Per Call ~~~~~~~~~~~~~~~ --------------- --------------- --------- --------- DB Time(s): 0.7 0.0 0.01 0.01 DB CPU(s): 0.4 0.0 0.01 0.00 Background CPU(s): 0.0 0.0 0.00 0.00 Redo size (bytes): 8,338,709.8 392,231.5 Logical read (blocks): 63,350.2 2,979.8 Block changes: 37,324.9 1,755.7 Physical read (blocks): 5.8 0.3 Physical write (blocks): 0.0 0.0 Read IO requests: 5.8 0.3 Write IO requests: 0.0 0.0 Read IO (MB): 0.1 0.0 Write IO (MB): 0.0 0.0 IM scan rows: 0.0 0.0 Session Logical Read IM: 0.0 0.0 User calls: 89.0 4.2 Parses (SQL): 35.4 1.7 Hard parses (SQL): 0.0 0.0 SQL Work Area (MB): 4.3 0.2 Logons: 4.2 0.2 User logons: 1.4 0.1 Executes (SQL): 51.0 2.4 Rollbacks: 0.0 0.0 Transactions: 21.3 Top 10 Foreground Events by Total Wait Time ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Total Wait Avg % DB Wait Event Waits Time (sec) Wait time Class ------------------------------ ----------- ---------- --------- ------ -------- DB CPU 2594.1 50.0 log file switch (checkpoint in 2,705 1727.6 638.69ms 33.3 Configur Data file init write 417,912 479.8 1.15ms 9.2 User I/O log file sync 149,351 235.3 1.58ms 4.5 Commit library cache lock 192 127.6 664.78ms 2.5 Concurre log file switch completion 701 57 81.36ms 1.1 Configur control file sequential read 74,448 37.3 501.51us .7 System I db file sequential read 42,145 22.3 529.52us .4 User I/O SQL*Net more data from client 1,189,436 7.3 6.16us .1 Network PX Deq: Join ACK 20,298 5.4 264.35us .1 Other Wait Classes by Total Wait Time ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg Avg Total Wait Wait % DB Active Wait Class Waits Time (sec) Time time Sessions ---------------- ---------------- ---------------- ---------- ------ -------- DB CPU 2,594 50.0 0.4 Configuration 3,547 1,848 520.90ms 35.6 0.3 User I/O 955,027 505 529.30us 9.7 0.1 Commit 149,351 235 1.58ms 4.5 0.0 Concurrency 599 132 220.72ms 2.5 0.0 System I/O 75,859 38 499.06us .7 0.0 Other 666,548 20 30.30us .4 0.0 Network 1,655,471 8 4.73us .2 0.0 Application 101 0 557.22us .0 0.0 IO Profile Read+Write/Second Read/Second Write/Second ~~~~~~~~~~ ----------------- --------------- --------------- Total Requests: 79.8 16.2 63.6 Database Requests: 5.8 5.8 0.0 Optimized Requests: 0.0 0.0 0.0 Redo Requests: Total (MB): 63.8 0.2 63.5 Database (MB): 0.1 0.1 0.0 Optimized Total (MB): 0.0 0.0 0.0 Redo (MB): Database (blocks): 5.8 5.8 0.0 Via Buffer Cache (blocks): 5.8 5.8 0.0 Direct (blocks): 0.0 0.0 0.0 Time Model Statistics DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> DB Time represents total time in user calls -> DB CPU represents CPU time of foreground processes -> Total CPU Time represents foreground and background processes -> Statistics including the word "background" measure background process time, therefore do not contribute to the DB time statistic -> Ordered by % of DB time in descending order, followed by Statistic Name % of % of Total Statistic Name Time (s) DB Time CPU Time ------------------------------------------ ------------------ ------- ---------- sql execute elapsed time 4,528.1 87.2 DB CPU 2,594.1 50.0 100.0 connection management call elapsed time 666.6 12.8 parse time elapsed 12.5 .2 hard parse elapsed time 0.5 .0 hard parse (sharing criteria) elapsed time 0.4 .0 PL/SQL execution elapsed time 0.0 .0 repeated bind elapsed time 0.0 .0 DB time 5,192.5 background elapsed time 1.5 background cpu time 0.2 .0 total CPU time 2,594.3 ------------------------------------------------------ Foreground Wait Class DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> s - second, ms - millisecond, us - microsecond, ns - nanosecond -> 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 102.2% of Total DB time 5,192.48 (s) -> Total FG Wait Time: 2,714.42 (s) DB CPU time: 2,594.11 (s) %Time Total Wait Wait Class Waits -outs Time (s) Avg wait %DB time -------------------- --------------- ----- --------------- ---------- --------- DB CPU 2,594 50.0 Configuration 3,406 0 1,785 523.98ms 34.4 User I/O 954,466 0 505 529.61us 9.7 Commit 149,351 0 235 1.58ms 4.5 Concurrency 556 0 128 229.63ms 2.5 System I/O 74,717 0 37 501.70us 0.7 Other 655,298 0 16 24.34us 0.3 Network 1,635,167 0 8 4.78us 0.2 Application 101 0 0 557.22us 0.0 ------------------------------------------------------ Foreground Wait Events DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> s - second, ms - millisecond, us - microsecond, ns - nanosecond -> Only events with Total Wait Time (s) >= .001 are shown -> ordered by wait time desc, waits desc (idle events last) -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Total %Time Wait Waits % DB Event Waits -outs Time (s) Avg wait /txn time -------------------------- ----------- ----- -------- --------- -------- ------ log file switch (checkpoin 2,705 1,728 638.69ms 0.0 33.3 Data file init write 417,912 480 1.15ms 2.7 9.2 log file sync 149,351 235 1.58ms 1.0 4.5 library cache lock 192 128 664.78ms 0.0 2.5 log file switch completion 701 57 81.36ms 0.0 1.1 control file sequential re 74,448 37 501.51us 0.5 .7 db file sequential read 42,145 22 529.52us 0.3 .4 SQL*Net more data from cli 1,189,436 7 6.16us 7.8 .1 PX Deq: Join ACK 20,298 5 264.35us 0.1 .1 PX Deq: Slave Session Stat 40,301 3 71.89us 0.3 .1 PGA memory operation 544,994 3 5.16us 3.6 .1 Disk file operations I/O 37,648 2 60.81us 0.2 .0 Sync ASM rebalance 380 2 4.99ms 0.0 .0 KSV master wait 84 1 16.25ms 0.0 .0 ASM IO for non-blocking po 456,719 1 2.39us 3.0 .0 enq: PS - contention 10,241 1 68.60us 0.1 .0 SQL*Net message to client 438,965 0 .96us 2.9 .0 latch free 7,037 0 38.43us 0.0 .0 PX Deq: Signal ACK EXT 20,298 0 9.69us 0.1 .0 ASM file metadata operatio 71 0 2.16ms 0.0 .0 DLM cross inst call comple 42 0 3.11ms 0.0 .0 control file parallel writ 255 0 315.76us 0.0 .0 kfk: async disk IO 14 0 4.93ms 0.0 .0 SQL*Net more data to clien 6,766 0 9.69us 0.0 .0 oracle thread bootstrap 4 0 14.69ms 0.0 .0 enq: RC - Result Cache: Co 101 0 557.22us 0.0 .0 rdbms ipc reply 14 0 2.05ms 0.0 .0 PX Deq Credit: free buffer 10,149 0 2.55us 0.1 .0 library cache: mutex X 89 0 219.29us 0.0 .0 db file single write 42 0 459.29us 0.0 .0 enq: DA - Slave Process Ar 2 0 8.89ms 0.0 .0 library cache load lock 59 0 167.20us 0.0 .0 CSS initialization 2 0 3.83ms 0.0 .0 CSS operation: action 10 0 718.20us 0.0 .0 latch: call allocation 384 0 13.15us 0.0 .0 PX qref latch 856 100 0 5.56us 0.0 .0 buffer busy waits 162 0 28.13us 0.0 .0 enq: CF - contention 1 0 3.43ms 0.0 .0 latch: cache buffers chain 34 0 100.41us 0.0 .0 latch: redo allocation 87 0 30.09us 0.0 .0 SQL*Net message from clien 438,963 5,560 12.67ms 2.9 PX Deq: Execution Msg 81,172 209 2.57ms 0.5 PX Deq: Parse Reply 20,298 13 648.95us 0.1 PX Deq: Execute Reply 101,490 12 118.38us 0.7 PX Deq: Table Q Normal 20,292 1 52.14us 0.1 PX Deq: Msg Fragment 20,291 0 1.65us 0.1 PX Deq Credit: send blkd 781 0 18.01us 0.0 ------------------------------------------------------ Service Statistics DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads (K) Reads (K) ---------------------------- ------------ ------------ ------------ ------------ pcdrdb 5,192 2,594 42 457,259 ------------------------------------------------------ Service Wait Class Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Wait Class info for services in the Service Statistics section. -> Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network -> Time Waited (Wt Time) in seconds Service Name ---------------------------------------------------------------- User I/O User I/O Concurcy Concurcy Admin Admin Network Network Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time --------- --------- --------- --------- --------- --------- --------- --------- pcdrdb 954473 506 556 128 0 0 1635193 8 ------------------------------------------------------ Top Process Types by Wait Class DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Top Process Types by CPU Used DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ SQL ordered by Elapsed Time DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100 -> %Total - Elapsed Time as a percentage of Total DB time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 77.3% of Total DB Time (s): 5,192 -> Captured PL/SQL account for 0.0% of Total DB Time (s): 5,192 Elapsed Elapsed Time Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id ---------------- -------------- ------------- ------ ------ ------ ------------- 2,355.2 113,747 0.02 45.4 57.0 .0 85zarqwvf599k Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C 745.8 32,298 0.02 14.4 57.9 .0 0f0zjv1c0rq3q Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ 435.7 10,077 0.04 8.4 1.4 .0 9zg9qd9bm4spu Module: Toad.exe PDB: PCDRDB update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1 173.8 7,390 0.02 3.3 40.6 .0 32vhwk4a4fh6z Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_SERVDATA_TB (SERVD_ORIG_DATE,SERVD_LOCAL_SEQ_NR,SER VD_LINE_NR,SERVD_RATING_GRP,SERVD_CHARG_RULE,SERVD_RESULT,SERVD_FIRST_USED,SERVD _LAST_USED,SERVD_CHNG_CONDIT,SERVD_NEG_QOS,SERVD_SGSN_ADDR,SERVD_SGSN_PLMNID_MCC ,SERVD_SGSN_PLMNID_MNC,SERVD_FBC_UPL,SERVD_FBC_DOWNL,SERVD_REPORT_TIME,SERVD_RAT 153.4 10,149 0.02 3.0 99.4 .0 fd4b9db6ju2ck Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT C.COLUMN_NAME FROM SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS C, SYS.ALL_TAB_COLS T WHER E A.CONSTRAINT_NAME = C.CONSTRAINT_NAME AND A.CONSTRAINT_TYPE = 'C' AND A 43.2 10,149 0.00 .8 40.9 5.0 1abbtfgtkqj15 Module: sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PDB: PCDRDB SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE 16.8 13 1.30 .3 10.5 91.8 bw0pqd06qcdd6 Module: TOAD 11.5.0.56 PDB: PCDRDB Select MAX(d.bytes) total_bytes, nvl(SUM(f.Bytes), 0) free_bytes, d.file_name, MAX(d.bytes) - nvl(SUM(f.bytes), 0) used_bytes, ROUND (SQRT(MAX(f.BLOCKS)/SUM(f.BLOCKS))*(100/SQRT(SQRT(COUNT(f.BLOCKS)) )), 2) frag_i dx from DBA_FREE_SPACE f , DBA_DATA_FILES d where f.tablespace_name(+) = d.ta 15.7 30,887 0.00 .3 83.2 .0 5dqz0hqtp9fru PDB: PCDRDB select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand (nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior p rivilege# and privilege#>0 start with grantee#=:1 and privilege#>0 9.5 808 0.01 .2 2.4 .0 0kkhhb2w93cx0 PDB: PCDRDB update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,e SQL ordered by Elapsed Time DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100 -> %Total - Elapsed Time as a percentage of Total DB time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 77.3% of Total DB Time (s): 5,192 -> Captured PL/SQL account for 0.0% of Total DB Time (s): 5,192 Elapsed Elapsed Time Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id ---------------- -------------- ------------- ------ ------ ------ ------------- xtpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decod e(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,: 17),scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3 8.5 10,149 0.00 .2 90.2 .0 bd13sdj0ty0q4 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJ ECT_TYPE = 'TABLE' ------------------------------------------------------ SQL ordered by CPU Time DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - CPU Time as a percentage of Total DB CPU -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 80.0% of Total CPU Time (s): 2,594 -> Captured PL/SQL account for 0.0% of Total CPU Time (s): 2,594 CPU CPU per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- 1,343.1 113,747 0.01 51.8 2,355.2 57.0 .0 85zarqwvf599k Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C 431.9 32,298 0.01 16.6 745.8 57.9 .0 0f0zjv1c0rq3q Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ 152.5 10,149 0.02 5.9 153.4 99.4 .0 fd4b9db6ju2ck Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT C.COLUMN_NAME FROM SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS C, SYS.ALL_TAB_COLS T WHER E A.CONSTRAINT_NAME = C.CONSTRAINT_NAME AND A.CONSTRAINT_TYPE = 'C' AND A 70.6 7,390 0.01 2.7 173.8 40.6 .0 32vhwk4a4fh6z Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_SERVDATA_TB (SERVD_ORIG_DATE,SERVD_LOCAL_SEQ_NR,SER VD_LINE_NR,SERVD_RATING_GRP,SERVD_CHARG_RULE,SERVD_RESULT,SERVD_FIRST_USED,SERVD _LAST_USED,SERVD_CHNG_CONDIT,SERVD_NEG_QOS,SERVD_SGSN_ADDR,SERVD_SGSN_PLMNID_MCC ,SERVD_SGSN_PLMNID_MNC,SERVD_FBC_UPL,SERVD_FBC_DOWNL,SERVD_REPORT_TIME,SERVD_RAT 17.7 10,149 0.00 0.7 43.2 40.9 5.0 1abbtfgtkqj15 Module: sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PDB: PCDRDB SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE 13.1 30,887 0.00 0.5 15.7 83.2 .0 5dqz0hqtp9fru PDB: PCDRDB select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand (nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior p rivilege# and privilege#>0 start with grantee#=:1 and privilege#>0 7.6 10,149 0.00 0.3 8.5 90.2 .0 bd13sdj0ty0q4 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJ ECT_TYPE = 'TABLE' 6.1 10,077 0.00 0.2 435.7 1.4 .0 9zg9qd9bm4spu Module: Toad.exe PDB: PCDRDB update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1 4.9 10,139 0.00 0.2 8.3 58.9 .0 cf960s7s4nvb5 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE) OPT_PARAM('_ENABLE_VI EW_PDB', 'FALSE') */ "OWNER","OWNERID","CONSTRAINT_NAME","CONSTRAINT_TYPE","TABL SQL ordered by CPU Time DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - CPU Time as a percentage of Total DB CPU -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 80.0% of Total CPU Time (s): 2,594 -> Captured PL/SQL account for 0.0% of Total CPU Time (s): 2,594 CPU CPU per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- E_NAME","OBJECT_ID","OBJECT_TYPE#","STATUS","ORIGIN_CON_ID" FROM NO_CROSS_CONTAI NER("SYS"."INT$INT$DBA_CONSTRAINTS") "INT$INT$DBA_CONSTRAINTS" WHERE "INT$INT$DB 4.8 10,148 0.00 0.2 5.0 96.1 .0 6an16x3f6ducn Module: SQL Loader Conventional Path Load PDB: PCDRDB select count(*) from sys.all_tables at, sys .all_part_tables apt where at.owner = apt.owner and at.table_name = apt.table_name and at.sharded = 'Y' and apt.partition_count = 1 and at.owne ------------------------------------------------------ SQL ordered by User I/O Wait Time DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - User I/O Time as a percentage of Total User I/O Wait time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 4.9% of Total User I/O Wait Time (s): -> Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): User I/O UIO per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- 15.5 13 1.19 3.1 16.8 10.5 91.8 bw0pqd06qcdd6 Module: TOAD 11.5.0.56 PDB: PCDRDB Select MAX(d.bytes) total_bytes, nvl(SUM(f.Bytes), 0) free_bytes, d.file_name, MAX(d.bytes) - nvl(SUM(f.bytes), 0) used_bytes, ROUND (SQRT(MAX(f.BLOCKS)/SUM(f.BLOCKS))*(100/SQRT(SQRT(COUNT(f.BLOCKS)) )), 2) frag_i dx from DBA_FREE_SPACE f , DBA_DATA_FILES d where f.tablespace_name(+) = d.ta 6.8 6 1.13 1.3 7.9 13.4 85.7 2z3y2c48aqk1x Module: TOAD 11.5.0.56 PDB: PCDRDB Select ts.tablespace_name, ts.status, ts.contents, ts.extent_management, ts.bigf ile, size_info.megs_alloc, size_info.megs_free, size_info.megs_used, size_info.pct_free, size_info.pct_used, size_info.max From ( sele ct a.tablespace_name, round(a.bytes_alloc / 1024 / 1024) megs_allo 2.2 10,149 0.00 0.4 43.2 40.9 5.0 1abbtfgtkqj15 Module: sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PDB: PCDRDB SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE 0.1 113,747 0.00 0.0 2,355.2 57.0 .0 85zarqwvf599k Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C 0.0 32,298 0.00 0.0 745.8 57.9 .0 0f0zjv1c0rq3q Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ 0.0 7,390 0.00 0.0 173.8 40.6 .0 32vhwk4a4fh6z Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_SERVDATA_TB (SERVD_ORIG_DATE,SERVD_LOCAL_SEQ_NR,SER VD_LINE_NR,SERVD_RATING_GRP,SERVD_CHARG_RULE,SERVD_RESULT,SERVD_FIRST_USED,SERVD _LAST_USED,SERVD_CHNG_CONDIT,SERVD_NEG_QOS,SERVD_SGSN_ADDR,SERVD_SGSN_PLMNID_MCC ,SERVD_SGSN_PLMNID_MNC,SERVD_FBC_UPL,SERVD_FBC_DOWNL,SERVD_REPORT_TIME,SERVD_RAT 0.0 10,077 0.00 0.0 435.7 1.4 .0 9zg9qd9bm4spu Module: Toad.exe PDB: PCDRDB update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1 0.0 184 0.00 0.0 0.0 98.3 .0 3dbzmtf9ahvzt PDB: PCDRDB merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn 0.0 289 0.00 0.0 0.0 93.1 .0 f3ww8rgva3hrs PDB: PCDRDB SQL ordered by User I/O Wait Time DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - User I/O Time as a percentage of Total User I/O Wait time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 4.9% of Total User I/O Wait Time (s): -> Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): User I/O UIO per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- update /* KSXM:FLUSH COL */ sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equ ijoin_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds = nonequijoi n_preds + decode(bitand(:flag,4),0,0,1), range_preds = range_preds 0.0 10,144 0.00 0.0 7.5 52.7 .0 05uqdabhzncdc PDB: PCDRDB select role# from defrole$ d,user$ u where d.user#=:1 and u.user#=d.user# and u. defrole=2 union select privilege# from sysauth$ s,user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where use r#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3 ------------------------------------------------------ SQL ordered by Gets DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - Buffer Gets as a percentage of Total Buffer Gets -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Buffer Gets: 457,263,712 -> Captured SQL account for 100.1% of Total Buffer Gets Elapsed Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ------------ ------ ---------- ----- ----- ------------- 3.08997E+08 113,747 2,716.5 67.6 2,355.2 57 0 85zarqwvf599k Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C 1.27631E+08 32,298 3,951.7 27.9 745.8 57.9 0 0f0zjv1c0rq3q Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ 12,947,996 7,390 1,752.1 2.8 173.8 40.6 0 32vhwk4a4fh6z Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_SERVDATA_TB (SERVD_ORIG_DATE,SERVD_LOCAL_SEQ_NR,SER VD_LINE_NR,SERVD_RATING_GRP,SERVD_CHARG_RULE,SERVD_RESULT,SERVD_FIRST_USED,SERVD _LAST_USED,SERVD_CHNG_CONDIT,SERVD_NEG_QOS,SERVD_SGSN_ADDR,SERVD_SGSN_PLMNID_MCC ,SERVD_SGSN_PLMNID_MNC,SERVD_FBC_UPL,SERVD_FBC_DOWNL,SERVD_REPORT_TIME,SERVD_RAT 3,557,266 10,149 350.5 0.8 153.4 99.4 0 fd4b9db6ju2ck Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT C.COLUMN_NAME FROM SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS C, SYS.ALL_TAB_COLS T WHER E A.CONSTRAINT_NAME = C.CONSTRAINT_NAME AND A.CONSTRAINT_TYPE = 'C' AND A 1,328,921 10,142 131.0 0.3 5.5 81.8 0 7ac05552jb0v9 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT 'X' FROM SYS.LOADER_PART_INFO WHERE TNAME = :1 AND OWNER = :2 AND PARTTY PE = 3 767,426 30,887 24.8 0.2 15.7 83.2 0 5dqz0hqtp9fru PDB: PCDRDB select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand (nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior p rivilege# and privilege#>0 start with grantee#=:1 and privilege#>0 625,855 10,148 61.7 0.1 5.0 96.1 0 6an16x3f6ducn Module: SQL Loader Conventional Path Load PDB: PCDRDB select count(*) from sys.all_tables at, sys .all_part_tables apt where at.owner = apt.owner and at.table_name = apt.table_name and at.sharded = 'Y' and apt.partition_count = 1 and at.owne 598,791 10,148 59.0 0.1 5.0 75.9 0 8uc59s4afypr0 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT COLUMN_NAME FROM SYS.LOADER_LOB_INDEX_COL WHERE TABLE_OWNER = :1 AND T ABLE_NAME = :2 583,402 10,139 57.5 0.1 8.3 58.9 0 cf960s7s4nvb5 Module: SQL Loader Conventional Path Load SQL ordered by Gets DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - Buffer Gets as a percentage of Total Buffer Gets -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Buffer Gets: 457,263,712 -> Captured SQL account for 100.1% of Total Buffer Gets Elapsed Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ------------ ------ ---------- ----- ----- ------------- PDB: PCDRDB SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE) OPT_PARAM('_ENABLE_VI EW_PDB', 'FALSE') */ "OWNER","OWNERID","CONSTRAINT_NAME","CONSTRAINT_TYPE","TABL E_NAME","OBJECT_ID","OBJECT_TYPE#","STATUS","ORIGIN_CON_ID" FROM NO_CROSS_CONTAI NER("SYS"."INT$INT$DBA_CONSTRAINTS") "INT$INT$DBA_CONSTRAINTS" WHERE "INT$INT$DB 169,160 10,148 16.7 0.0 1.6 92.4 0 6csvyhgf6b0s5 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT COLNAME FROM SYS.LOADER_COL_FLAGS WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2 AND ISVIRTUAL = 'YES' ------------------------------------------------------ SQL ordered by Reads DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> %Total - Physical Reads as a percentage of Total Disk Reads -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Disk Reads: 41,937 -> Captured SQL account for 100.0% of Total Physical Reads Elapsed Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ---------- ------ ---------- ------ ------ ------------- 28,691 13 2,207.0 68.4 16.8 10.5 91.8 bw0pqd06qcdd6 Module: TOAD 11.5.0.56 PDB: PCDRDB Select MAX(d.bytes) total_bytes, nvl(SUM(f.Bytes), 0) free_bytes, d.file_name, MAX(d.bytes) - nvl(SUM(f.bytes), 0) used_bytes, ROUND (SQRT(MAX(f.BLOCKS)/SUM(f.BLOCKS))*(100/SQRT(SQRT(COUNT(f.BLOCKS)) )), 2) frag_i dx from DBA_FREE_SPACE f , DBA_DATA_FILES d where f.tablespace_name(+) = d.ta 13,242 6 2,207.0 31.6 7.9 13.4 85.7 2z3y2c48aqk1x Module: TOAD 11.5.0.56 PDB: PCDRDB Select ts.tablespace_name, ts.status, ts.contents, ts.extent_management, ts.bigf ile, size_info.megs_alloc, size_info.megs_free, size_info.megs_used, size_info.pct_free, size_info.pct_used, size_info.max From ( sele ct a.tablespace_name, round(a.bytes_alloc / 1024 / 1024) megs_allo 0 10,144 0.0 0.0 7.5 52.7 .0 05uqdabhzncdc PDB: PCDRDB select role# from defrole$ d,user$ u where d.user#=:1 and u.user#=d.user# and u. defrole=2 union select privilege# from sysauth$ s,user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where use r#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3 0 32,298 0.0 0.0 745.8 57.9 .0 0f0zjv1c0rq3q Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ 0 808 0.0 0.0 9.5 2.4 .0 0kkhhb2w93cx0 PDB: PCDRDB update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,e xtpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decod e(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,: 17),scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3 0 10,149 0.0 0.0 43.2 40.9 5.0 1abbtfgtkqj15 Module: sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PDB: PCDRDB SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE 0 264 0.0 0.0 0.0 100.0 .0 2p9fv35c7zxtg PDB: PCDRDB select /* KSXM:LOAD_DML_INF *//*+ leading(o) index(m) use_nl(m) */ nv l(m.inserts, 0) ins, nvl(m.updates, 0) upd, nvl(m.deletes, 0) del, nvl( m.drop_segments, 0) dropseg, nvl(m.flags, 0) flags, nvl(ro wcnt, 0) rowcnt, o.pobjn pobjn from 0 7,390 0.0 0.0 173.8 40.6 .0 32vhwk4a4fh6z Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_SERVDATA_TB (SERVD_ORIG_DATE,SERVD_LOCAL_SEQ_NR,SER VD_LINE_NR,SERVD_RATING_GRP,SERVD_CHARG_RULE,SERVD_RESULT,SERVD_FIRST_USED,SERVD _LAST_USED,SERVD_CHNG_CONDIT,SERVD_NEG_QOS,SERVD_SGSN_ADDR,SERVD_SGSN_PLMNID_MCC ,SERVD_SGSN_PLMNID_MNC,SERVD_FBC_UPL,SERVD_FBC_DOWNL,SERVD_REPORT_TIME,SERVD_RAT 0 184 0.0 0.0 0.0 98.3 .0 3dbzmtf9ahvzt PDB: PCDRDB SQL ordered by Reads DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> %Total - Physical Reads as a percentage of Total Disk Reads -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Disk Reads: 41,937 -> Captured SQL account for 100.0% of Total Physical Reads Elapsed Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ---------- ------ ---------- ------ ------ ------------- merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn 0 30,887 0.0 0.0 15.7 83.2 .0 5dqz0hqtp9fru PDB: PCDRDB select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand (nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior p rivilege# and privilege#>0 start with grantee#=:1 and privilege#>0 ------------------------------------------------------ SQL ordered by Physical Reads (UnOptimized)DB/Inst: CDRDB/cdrdb Snaps: 309-31 -> UnOptimized Read Reqs = Physical Read Reqs - (Optimized Read Reqs - Cell Flash Cache Read Hits for Controlfile) -> %Opt - Optimized Reads as percentage of SQL Read Requests -> %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs -> Total Physical Read Requests: 41,937 -> Captured SQL account for 169.4% of Total -> Total UnOptimized Read Requests: 41,937 -> Captured SQL account for 169.4% of Total -> Total Optimized Read Requests: 1 -> Captured SQL account for 0.0% of Total UnOptimized Physical UnOptimized Read Reqs Read Reqs Executions Reqs per Exe %Opt %Total SQL Id ----------- ----------- ---------- ------------ ------ ------ ------------- 71,043 71,043 10,149 7.0 0.0 169.4 1abbtfgtkqj15 Module: sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PDB: PCDRDB SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE 0 0 10,144 0.0 N/A 0.0 05uqdabhzncdc PDB: PCDRDB select role# from defrole$ d,user$ u where d.user#=:1 and u.user#=d.user# and u. defrole=2 union select privilege# from sysauth$ s,user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where use r#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3 0 0 32,298 0.0 N/A 0.0 0f0zjv1c0rq3q Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ 0 0 808 0.0 N/A 0.0 0kkhhb2w93cx0 PDB: PCDRDB update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,e xtpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decod e(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,: 17),scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3 0 0 264 0.0 N/A 0.0 2p9fv35c7zxtg PDB: PCDRDB select /* KSXM:LOAD_DML_INF *//*+ leading(o) index(m) use_nl(m) */ nv l(m.inserts, 0) ins, nvl(m.updates, 0) upd, nvl(m.deletes, 0) del, nvl( m.drop_segments, 0) dropseg, nvl(m.flags, 0) flags, nvl(ro wcnt, 0) rowcnt, o.pobjn pobjn from 0 0 6 0.0 N/A 0.0 2z3y2c48aqk1x Module: TOAD 11.5.0.56 PDB: PCDRDB Select ts.tablespace_name, ts.status, ts.contents, ts.extent_management, ts.bigf ile, size_info.megs_alloc, size_info.megs_free, size_info.megs_used, size_info.pct_free, size_info.pct_used, size_info.max From ( sele ct a.tablespace_name, round(a.bytes_alloc / 1024 / 1024) megs_allo 0 0 7,390 0.0 N/A 0.0 32vhwk4a4fh6z Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_SERVDATA_TB (SERVD_ORIG_DATE,SERVD_LOCAL_SEQ_NR,SER VD_LINE_NR,SERVD_RATING_GRP,SERVD_CHARG_RULE,SERVD_RESULT,SERVD_FIRST_USED,SERVD _LAST_USED,SERVD_CHNG_CONDIT,SERVD_NEG_QOS,SERVD_SGSN_ADDR,SERVD_SGSN_PLMNID_MCC ,SERVD_SGSN_PLMNID_MNC,SERVD_FBC_UPL,SERVD_FBC_DOWNL,SERVD_REPORT_TIME,SERVD_RAT 0 0 184 0.0 N/A 0.0 3dbzmtf9ahvzt PDB: PCDRDB merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn 0 0 30,887 0.0 N/A 0.0 5dqz0hqtp9fru PDB: PCDRDB select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand SQL ordered by Physical Reads (UnOptimized)DB/Inst: CDRDB/cdrdb Snaps: 309-31 -> UnOptimized Read Reqs = Physical Read Reqs - (Optimized Read Reqs - Cell Flash Cache Read Hits for Controlfile) -> %Opt - Optimized Reads as percentage of SQL Read Requests -> %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs -> Total Physical Read Requests: 41,937 -> Captured SQL account for 169.4% of Total -> Total UnOptimized Read Requests: 41,937 -> Captured SQL account for 169.4% of Total -> Total Optimized Read Requests: 1 -> Captured SQL account for 0.0% of Total UnOptimized Physical UnOptimized Read Reqs Read Reqs Executions Reqs per Exe %Opt %Total SQL Id ----------- ----------- ---------- ------------ ------ ------ ------------- (nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior p rivilege# and privilege#>0 start with grantee#=:1 and privilege#>0 0 0 10,148 0.0 N/A 0.0 6an16x3f6ducn Module: SQL Loader Conventional Path Load PDB: PCDRDB select count(*) from sys.all_tables at, sys .all_part_tables apt where at.owner = apt.owner and at.table_name = apt.table_name and at.sharded = 'Y' and apt.partition_count = 1 and at.owne ------------------------------------------------------ SQL ordered by Executions DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Executions: 368,088 -> Captured SQL account for 91.4% of Total Elapsed Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id ------------ --------------- -------------- ---------- ----- ----- ------------- 113,747 16,639,799 146.3 2,355.2 57 0 85zarqwvf599k Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C 32,298 18,744,409 580.4 745.8 57.9 0 0f0zjv1c0rq3q Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ 30,887 457,394 14.8 15.7 83.2 0 5dqz0hqtp9fru PDB: PCDRDB select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand (nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior p rivilege# and privilege#>0 start with grantee#=:1 and privilege#>0 18,510 18,575 1.0 0.6 98.7 0 9xhc0db70kgyq Module: PL/SQL Developer PDB: PCDRDB select '''' || SYS_CONTEXT('USERENV', 'CON_ID') || '''' from sys.dual 10,152 10,152 1.0 3.3 99.4 0 f0h5rpzmhju11 PDB: PCDRDB select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_ NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'INSTANC E'), STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN'), SYS_CONTEXT('USERENV', ' SERVICE_NAME') from v$instance 10,149 10,149 1.0 43.2 40.9 5 1abbtfgtkqj15 Module: sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PDB: PCDRDB SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE 10,149 10,149 1.0 8.5 90.2 0 bd13sdj0ty0q4 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJ ECT_TYPE = 'TABLE' 10,149 0 0.0 1.6 98.6 0 d9q2q82g1tuzx PDB: PCDRDB select decode(upper(failover_method), NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'P REPARSE', 4 , 0), decode(upper(failover_type), NULL, 1, 'NONE', 1, 'SESSION', 2 , 'SELECT', 4, 'TRANSACTION', 8, 'AUTO' , 32, 1 ), failover_retries, failover _delay, flags, nvl(replay_initiation_timeout, 900), decode(upper(session_state_c 10,149 0 0.0 153.4 99.4 0 fd4b9db6ju2ck Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT C.COLUMN_NAME FROM SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS C, SYS.ALL_TAB_COLS T WHER E A.CONSTRAINT_NAME = C.CONSTRAINT_NAME AND A.CONSTRAINT_TYPE = 'C' AND A SQL ordered by Executions DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Executions: 368,088 -> Captured SQL account for 91.4% of Total Elapsed Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id ------------ --------------- -------------- ---------- ----- ----- ------------- 10,148 10,149 1.0 5.0 96.1 0 6an16x3f6ducn Module: SQL Loader Conventional Path Load PDB: PCDRDB select count(*) from sys.all_tables at, sys .all_part_tables apt where at.owner = apt.owner and at.table_name = apt.table_name and at.sharded = 'Y' and apt.partition_count = 1 and at.owne 10,148 0 0.0 1.6 92.4 0 6csvyhgf6b0s5 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT COLNAME FROM SYS.LOADER_COL_FLAGS WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2 AND ISVIRTUAL = 'YES' 10,148 0 0.0 5.0 75.9 0 8uc59s4afypr0 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT COLUMN_NAME FROM SYS.LOADER_LOB_INDEX_COL WHERE TABLE_OWNER = :1 AND T ABLE_NAME = :2 10,144 30,443 3.0 7.5 52.7 0 05uqdabhzncdc PDB: PCDRDB select role# from defrole$ d,user$ u where d.user#=:1 and u.user#=d.user# and u. defrole=2 union select privilege# from sysauth$ s,user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where use r#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3 10,142 0 0.0 5.5 81.8 0 7ac05552jb0v9 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT 'X' FROM SYS.LOADER_PART_INFO WHERE TNAME = :1 AND OWNER = :2 AND PARTTY PE = 3 10,139 37,210 3.7 8.3 58.9 0 cf960s7s4nvb5 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE) OPT_PARAM('_ENABLE_VI EW_PDB', 'FALSE') */ "OWNER","OWNERID","CONSTRAINT_NAME","CONSTRAINT_TYPE","TABL E_NAME","OBJECT_ID","OBJECT_TYPE#","STATUS","ORIGIN_CON_ID" FROM NO_CROSS_CONTAI NER("SYS"."INT$INT$DBA_CONSTRAINTS") "INT$INT$DBA_CONSTRAINTS" WHERE "INT$INT$DB 10,077 10,077 1.0 0.7 100.1 0 865qwpcdyggkk PDB: PCDRDB select spare6 from user$ where user#=:1 10,077 10,077 1.0 435.7 1.4 0 9zg9qd9bm4spu Module: Toad.exe PDB: PCDRDB update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1 7,390 2,148,029 290.7 173.8 40.6 0 32vhwk4a4fh6z Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_SERVDATA_TB (SERVD_ORIG_DATE,SERVD_LOCAL_SEQ_NR,SER VD_LINE_NR,SERVD_RATING_GRP,SERVD_CHARG_RULE,SERVD_RESULT,SERVD_FIRST_USED,SERVD _LAST_USED,SERVD_CHNG_CONDIT,SERVD_NEG_QOS,SERVD_SGSN_ADDR,SERVD_SGSN_PLMNID_MCC ,SERVD_SGSN_PLMNID_MNC,SERVD_FBC_UPL,SERVD_FBC_DOWNL,SERVD_REPORT_TIME,SERVD_RAT ------------------------------------------------------ SQL ordered by Parse Calls DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Total Parse Calls: 255,131 -> Captured SQL account for 84.0% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 30,890 30,887 12.11 5dqz0hqtp9fru PDB: PCDRDB select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand (nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior p rivilege# and privilege#>0 start with grantee#=:1 and privilege#>0 30,332 10,149 11.89 fd4b9db6ju2ck Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT C.COLUMN_NAME FROM SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS C, SYS.ALL_TAB_COLS T WHER E A.CONSTRAINT_NAME = C.CONSTRAINT_NAME AND A.CONSTRAINT_TYPE = 'C' AND A 20,209 18,510 7.92 9xhc0db70kgyq Module: PL/SQL Developer PDB: PCDRDB select '''' || SYS_CONTEXT('USERENV', 'CON_ID') || '''' from sys.dual 10,152 10,152 3.98 f0h5rpzmhju11 PDB: PCDRDB select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_ NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'INSTANC E'), STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN'), SYS_CONTEXT('USERENV', ' SERVICE_NAME') from v$instance 10,149 10,144 3.98 05uqdabhzncdc PDB: PCDRDB select role# from defrole$ d,user$ u where d.user#=:1 and u.user#=d.user# and u. defrole=2 union select privilege# from sysauth$ s,user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where use r#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3 10,149 10,149 3.98 1abbtfgtkqj15 Module: sqlldr@mtccdrdb01.mtcdc.com.na (TNS V1-V3) PDB: PCDRDB SELECT RESULTS FROM SYS.LOADER_DB_OPEN_READ_WRITE 10,149 10,148 3.98 6an16x3f6ducn Module: SQL Loader Conventional Path Load PDB: PCDRDB select count(*) from sys.all_tables at, sys .all_part_tables apt where at.owner = apt.owner and at.table_name = apt.table_name and at.sharded = 'Y' and apt.partition_count = 1 and at.owne 10,149 10,148 3.98 6csvyhgf6b0s5 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT COLNAME FROM SYS.LOADER_COL_FLAGS WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2 AND ISVIRTUAL = 'YES' 10,149 10,142 3.98 7ac05552jb0v9 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT 'X' FROM SYS.LOADER_PART_INFO WHERE TNAME = :1 AND OWNER = :2 AND PARTTY PE = 3 10,149 10,148 3.98 8uc59s4afypr0 Module: SQL Loader Conventional Path Load SQL ordered by Parse Calls DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Total Parse Calls: 255,131 -> Captured SQL account for 84.0% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- PDB: PCDRDB SELECT COLUMN_NAME FROM SYS.LOADER_LOB_INDEX_COL WHERE TABLE_OWNER = :1 AND T ABLE_NAME = :2 10,149 10,149 3.98 bd13sdj0ty0q4 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJ ECT_TYPE = 'TABLE' 10,149 10,139 3.98 cf960s7s4nvb5 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE) OPT_PARAM('_ENABLE_VI EW_PDB', 'FALSE') */ "OWNER","OWNERID","CONSTRAINT_NAME","CONSTRAINT_TYPE","TABL E_NAME","OBJECT_ID","OBJECT_TYPE#","STATUS","ORIGIN_CON_ID" FROM NO_CROSS_CONTAI NER("SYS"."INT$INT$DBA_CONSTRAINTS") "INT$INT$DBA_CONSTRAINTS" WHERE "INT$INT$DB 10,149 10,149 3.98 d9q2q82g1tuzx PDB: PCDRDB select decode(upper(failover_method), NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'P REPARSE', 4 , 0), decode(upper(failover_type), NULL, 1, 'NONE', 1, 'SESSION', 2 , 'SELECT', 4, 'TRANSACTION', 8, 'AUTO' , 32, 1 ), failover_retries, failover _delay, flags, nvl(replay_initiation_timeout, 900), decode(upper(session_state_c 10,077 10,077 3.95 865qwpcdyggkk PDB: PCDRDB select spare6 from user$ where user#=:1 10,077 10,077 3.95 9zg9qd9bm4spu Module: Toad.exe PDB: PCDRDB update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1 3,382 7,390 1.33 32vhwk4a4fh6z Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_SERVDATA_TB (SERVD_ORIG_DATE,SERVD_LOCAL_SEQ_NR,SER VD_LINE_NR,SERVD_RATING_GRP,SERVD_CHARG_RULE,SERVD_RESULT,SERVD_FIRST_USED,SERVD _LAST_USED,SERVD_CHNG_CONDIT,SERVD_NEG_QOS,SERVD_SGSN_ADDR,SERVD_SGSN_PLMNID_MCC ,SERVD_SGSN_PLMNID_MNC,SERVD_FBC_UPL,SERVD_FBC_DOWNL,SERVD_REPORT_TIME,SERVD_RAT 3,382 113,747 1.33 85zarqwvf599k Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C 3,381 32,298 1.33 0f0zjv1c0rq3q Module: SQL Loader Conventional Path Load PDB: PCDRDB INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ ------------------------------------------------------ SQL ordered by Sharable Memory DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- 24,263,736 10,149 0.15 fd4b9db6ju2ck Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT C.COLUMN_NAME FROM SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS C, SYS.ALL_TAB_COLS T WHER E A.CONSTRAINT_NAME = C.CONSTRAINT_NAME AND A.CONSTRAINT_TYPE = 'C' AND A 8,394,029 10,148 0.05 6an16x3f6ducn Module: SQL Loader Conventional Path Load PDB: PCDRDB select count(*) from sys.all_tables at, sys .all_part_tables apt where at.owner = apt.owner and at.table_name = apt.table_name and at.sharded = 'Y' and apt.partition_count = 1 and at.owne 8,257,171 10,149 0.05 bd13sdj0ty0q4 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJ ECT_TYPE = 'TABLE' 7,574,879 10,148 0.05 8uc59s4afypr0 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT COLUMN_NAME FROM SYS.LOADER_LOB_INDEX_COL WHERE TABLE_OWNER = :1 AND T ABLE_NAME = :2 7,421,172 2 0.05 f705bwx3q0ydq PDB: PCDRDB select count(*) from dba_autotask_window_clients c, (select window_name, max(log _date) max_log_date from dba_scheduler_window_log where operation = 'OPEN' group by window_name) wo, (select window_name, max(log_date) max_log_date from dba_sc heduler_window_log where operation = 'CLOSE' group by window_name) wc where c.wi 5,014,585 10,139 0.03 cf960s7s4nvb5 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE) OPT_PARAM('_ENABLE_VI EW_PDB', 'FALSE') */ "OWNER","OWNERID","CONSTRAINT_NAME","CONSTRAINT_TYPE","TABL E_NAME","OBJECT_ID","OBJECT_TYPE#","STATUS","ORIGIN_CON_ID" FROM NO_CROSS_CONTAI NER("SYS"."INT$INT$DBA_CONSTRAINTS") "INT$INT$DBA_CONSTRAINTS" WHERE "INT$INT$DB 4,555,156 184 0.03 3dbzmtf9ahvzt PDB: PCDRDB merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn 2,519,632 264 0.02 2p9fv35c7zxtg PDB: PCDRDB select /* KSXM:LOAD_DML_INF *//*+ leading(o) index(m) use_nl(m) */ nv l(m.inserts, 0) ins, nvl(m.updates, 0) upd, nvl(m.deletes, 0) del, nvl( m.drop_segments, 0) dropseg, nvl(m.flags, 0) flags, nvl(ro wcnt, 0) rowcnt, o.pobjn pobjn from 2,188,294 6 0.01 2z3y2c48aqk1x Module: TOAD 11.5.0.56 PDB: PCDRDB SQL ordered by Sharable Memory DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- Select ts.tablespace_name, ts.status, ts.contents, ts.extent_management, ts.bigf ile, size_info.megs_alloc, size_info.megs_free, size_info.megs_used, size_info.pct_free, size_info.pct_used, size_info.max From ( sele ct a.tablespace_name, round(a.bytes_alloc / 1024 / 1024) megs_allo 1,640,655 10,142 0.01 7ac05552jb0v9 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT 'X' FROM SYS.LOADER_PART_INFO WHERE TNAME = :1 AND OWNER = :2 AND PARTTY PE = 3 1,538,597 289 0.01 f3ww8rgva3hrs PDB: PCDRDB update /* KSXM:FLUSH COL */ sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equ ijoin_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds = nonequijoi n_preds + decode(bitand(:flag,4),0,0,1), range_preds = range_preds 1,483,284 10,148 0.01 6csvyhgf6b0s5 Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT COLNAME FROM SYS.LOADER_COL_FLAGS WHERE TABLE_OWNER = :1 AND TABLE_NAME = :2 AND ISVIRTUAL = 'YES' ------------------------------------------------------ SQL ordered by Version Count DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Only Statements with Version Count greater than 20 are displayed Version Count Executions SQL Id -------- ------------ ------------- 42 2 c8h20n1d0k95m PDB: PCDRDB select /*+ no_parallel */ spare4 from sys.optstat_hist_control$ where sname=:1 40 58 b9nbhsbx8tqz5 PDB: PCDRDB SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SPARE4 FROM SYS.O PTSTAT_HIST_CONTROL$ WHERE SNAME = :B1 39 264 2p9fv35c7zxtg PDB: PCDRDB select /* KSXM:LOAD_DML_INF *//*+ leading(o) index(m) use_nl(m) */ nv l(m.inserts, 0) ins, nvl(m.updates, 0) upd, nvl(m.deletes, 0) del, nvl( m.drop_segments, 0) dropseg, nvl(m.flags, 0) flags, nvl(ro wcnt, 0) rowcnt, o.pobjn pobjn from 39 184 3dbzmtf9ahvzt PDB: PCDRDB merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn 35 289 f3ww8rgva3hrs PDB: PCDRDB update /* KSXM:FLUSH COL */ sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equ ijoin_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds = nonequijoi n_preds + decode(bitand(:flag,4),0,0,1), range_preds = range_preds 32 2 ajkubg7upg9pu PDB: PCDRDB update /* KSXM:TIME_UPD */ optstat_hist_control$ set sval2 = systimestamp where sname = :param_name 31 10,149 fd4b9db6ju2ck Module: SQL Loader Conventional Path Load PDB: PCDRDB SELECT C.COLUMN_NAME FROM SYS.ALL_CONSTRAINTS A, SYS.ALL_CONS_COLUMNS C, SYS.ALL_TAB_COLS T WHER E A.CONSTRAINT_NAME = C.CONSTRAINT_NAME AND A.CONSTRAINT_TYPE = 'C' AND A ------------------------------------------------------ Key Instance Activity Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- db block changes 269,412,211 37,324.9 1,755.7 execute count 368,088 51.0 2.4 logons cumulative 30,459 4.2 0.2 opened cursors cumulative 255,253 35.4 1.7 parse count (total) 255,131 35.4 1.7 parse time elapsed 1,226 0.2 0.0 physical reads 41,937 5.8 0.3 physical writes 0 0.0 0.0 redo size 60,189,099,100 8,338,709.8 392,231.5 session cursor cache hits 21,283 3.0 0.1 session logical reads 457,263,712 63,350.2 2,979.8 user calls 642,089 89.0 4.2 user commits 153,453 21.3 1.0 user rollbacks 0 0.0 0.0 workarea executions - optimal 142,888 19.8 0.9 ------------------------------------------------------ Instance Activity Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- ASSM cbk:blocks examined 4,517,273 625.8 29.4 ASSM cbk:blocks marked full 1,809,183 250.7 11.8 ASSM gsp:L1 bitmaps examined 2,939,110 407.2 19.2 ASSM gsp:L2 bitmap full 2,153 0.3 0.0 ASSM gsp:L2 bitmaps examined 286,709 39.7 1.9 ASSM gsp:Optimized reject DB 171 0.0 0.0 ASSM gsp:Optimized reject l1 0 0.0 0.0 ASSM gsp:Search all 2,428 0.3 0.0 ASSM gsp:Search hint 6,062 0.8 0.0 ASSM gsp:Search steal 2,428 0.3 0.0 ASSM gsp:bump HWM 2,428 0.3 0.0 ASSM gsp:get free block 2,708,075 375.2 17.7 ASSM gsp:good hint 2,449,382 339.3 16.0 ASSM gsp:reject L1 0 0.0 0.0 ASSM gsp:reject db 15 0.0 0.0 ASSM rsv:alloc from reserve 0 0.0 0.0 ASSM rsv:alloc from reserve succ 0 0.0 0.0 ASSM rsv:clear reserve 0 0.0 0.0 ASSM rsv:fill reserve 0 0.0 0.0 ASSM wasted db state change 1 0.0 0.0 Batched IO (bound) vector count 0 0.0 0.0 Batched IO block miss count 0 0.0 0.0 Batched IO buffer defrag count 0 0.0 0.0 Batched IO double miss count 0 0.0 0.0 Batched IO same unit count 0 0.0 0.0 Batched IO single block count 0 0.0 0.0 Batched IO vector block count 0 0.0 0.0 Batched IO vector read count 0 0.0 0.0 Block Cleanout Optim referenced 94,251 13.1 0.6 CCursor + sql area evicted 14 0.0 0.0 CPU used by this session 239,434 33.2 1.6 CPU used when call started 238,890 33.1 1.6 CR blocks created 7,152 1.0 0.1 Cached Commit SCN referenced 0 0.0 0.0 Client Advertised Receive Window 71,043 9.8 0.5 Client Advertised Send Window 71,043 9.8 0.5 Client Path Maximum Transmission 665,114,715 92,146.2 4,334.3 Client Send Congestion Window 101,490 14.1 0.7 Client Time (usec) Last Ack Rece 2,113 0.3 0.0 Client Time (usec) Last Data Rec 2,113 0.3 0.0 Client Time (usec) Last Data Sen 2,381 0.3 0.0 Client Time (usec) Round Trip Ti 19,532,947 2,706.1 127.3 Client Time (usec) Round Trip Ti 27,515,101 3,812.0 179.3 Client Total Bytes Acked 10,788,447,199 1,494,651.6 70,304.6 Client Total Bytes Received 196,324,507 27,199.2 1,279.4 Commit SCN cached 0 0.0 0.0 DFO trees parallelized 10,149 1.4 0.1 DML statements retried 0 0.0 0.0 Effective IO time 0 0.0 0.0 HSC Heap Segment Block Changes 3,257,744 451.3 21.2 Heap Segment Array Inserts 3,247,148 449.9 21.2 Heap Segment Array Updates 5,795 0.8 0.0 Heatmap BlkLevel Flushed 0 0.0 0.0 Heatmap BlkLevel Flushed to BF 0 0.0 0.0 Heatmap BlkLevel Ranges Flushed 0 0.0 0.0 Heatmap Blklevel Flush Task Coun 0 0.0 0.0 IMU pool not allocated 153,466 21.3 1.0 IMU- failed to get a private str 153,466 21.3 1.0 KTFB alloc req 2,601 0.4 0.0 KTFB alloc space (block) 19,749,928,960 2,736,191.9 128,703.4 Instance Activity Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- KTFB alloc time (ms) 480,251 66.5 3.1 KTFB apply req 173 0.0 0.0 KTFB apply time (ms) 3,636 0.5 0.0 KTFB commit req 0 0.0 0.0 KTFB commit time (ms) 0 0.0 0.0 KTFB free req 0 0.0 0.0 KTFB free space (block) 0 0.0 0.0 KTFB free time (ms) 0 0.0 0.0 LOB table id lookup cache misses 0 0.0 0.0 Number of read IOs issued 0 0.0 0.0 PX local messages recv'd 223,278 30.9 1.5 PX local messages sent 223,278 30.9 1.5 Parallel operations not downgrad 10,149 1.4 0.1 Requests to/from client 438,975 60.8 2.9 RowCR - row contention 2 0.0 0.0 RowCR attempts 2 0.0 0.0 SQL*Net roundtrips to/from clien 438,979 60.8 2.9 TBS Extension: tasks created 0 0.0 0.0 active txn count during cleanout 1,495,572 207.2 9.8 auto extends on undo tablespace 0 0.0 0.0 blocks cleaned out using minact 10,567,023 1,464.0 68.9 branch node splits 1,845 0.3 0.0 buffer is not pinned count 5,666,850 785.1 36.9 buffer is pinned count 12,364,775 1,713.0 80.6 bytes received via SQL*Net from 10,763,089,681 1,491,138.5 70,139.3 bytes sent via SQL*Net to client 187,485,928 25,974.7 1,221.8 calls to get snapshot scn: kcmgs 44,549,138 6,171.9 290.3 calls to kcmgas 748,243 103.7 4.9 calls to kcmgcs 4,842,357 670.9 31.6 cell physical IO interconnect by 482,469,216,256 66,842,183.0 3,144,084.6 change write time 45,107 6.3 0.3 cleanout - number of ktugct call 1,934,483 268.0 12.6 cleanouts and rollbacks - consis 1 0.0 0.0 cleanouts only - consistent read 17 0.0 0.0 cluster key scan block gets 1,743,024 241.5 11.4 cluster key scans 723,229 100.2 4.7 commit batch/immediate performed 39 0.0 0.0 commit batch/immediate requested 39 0.0 0.0 commit cleanout failures: block 0 0.0 0.0 commit cleanout failures: buffer 5,376 0.7 0.0 commit cleanout failures: callba 87,644 12.1 0.6 commit cleanout failures: cannot 1 0.0 0.0 commit cleanouts 85,219,926 11,806.5 555.4 commit cleanouts successfully co 85,126,905 11,793.6 554.7 commit immediate performed 39 0.0 0.0 commit immediate requested 39 0.0 0.0 commit txn count during cleanout 637,707 88.4 4.2 consistent changes 5,953 0.8 0.0 consistent gets 9,762,204 1,352.5 63.6 consistent gets direct 0 0.0 0.0 consistent gets examination 4,527,758 627.3 29.5 consistent gets examination (fas 4,526,548 627.1 29.5 consistent gets from cache 9,762,204 1,352.5 63.6 consistent gets pin 5,234,446 725.2 34.1 consistent gets pin (fastpath) 5,185,355 718.4 33.8 cursor authentications 47 0.0 0.0 cursor reload failures 0 0.0 0.0 data blocks consistent reads - u 2 0.0 0.0 db block changes 269,412,211 37,324.9 1,755.7 db block gets 447,501,508 61,997.7 2,916.2 Instance Activity Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- db block gets direct 0 0.0 0.0 db block gets from cache 447,501,508 61,997.7 2,916.2 db block gets from cache (fastpa 321,721,023 44,571.8 2,096.5 deferred (CURRENT) block cleanou 78,503,502 10,876.0 511.6 dirty buffers inspected 18 0.0 0.0 enqueue conversions 40,596 5.6 0.3 enqueue releases 1,792,533 248.3 11.7 enqueue requests 1,792,582 248.4 11.7 enqueue timeouts 39 0.0 0.0 enqueue waits 10,346 1.4 0.1 execute count 368,088 51.0 2.4 failed probes on index block rec 0 0.0 0.0 file io service time 0 0.0 0.0 free buffer inspected 2,861,857 396.5 18.7 free buffer requested 2,855,721 395.6 18.6 global undo segment hints helped 0 0.0 0.0 global undo segment hints were s 0 0.0 0.0 heap block compress 9 0.0 0.0 hot buffers moved to head of LRU 598,587 82.9 3.9 immediate (CR) block cleanout ap 18 0.0 0.0 immediate (CURRENT) block cleano 4,625,283 640.8 30.1 index crx upgrade (positioned) 0 0.0 0.0 index fast full scans (direct re 0 0.0 0.0 index fast full scans (full) 6 0.0 0.0 index fast full scans (rowid ran 0 0.0 0.0 index fetch by key 3,083,496 427.2 20.1 index range scans 848,155 117.5 5.5 index reclamation/extension swit 6 0.0 0.0 leaf node 90-10 splits 3,598 0.5 0.0 leaf node splits 540,312 74.9 3.5 lob reads 0 0.0 0.0 lob writes 0 0.0 0.0 lob writes unaligned 0 0.0 0.0 logical read bytes from cache 3,745,904,328,704 518,964,556.0 24,410,759.8 logons cumulative 30,459 4.2 0.2 max cf enq hold time 31 0.0 0.0 messages sent 180,632 25.0 1.2 no work - consistent read gets 4,641,219 643.0 30.3 non-idle wait count 3,762,386 521.3 24.5 opened cursors cumulative 255,253 35.4 1.7 parse count (describe) 0 0.0 0.0 parse count (failures) 0 0.0 0.0 parse count (hard) 74 0.0 0.0 parse count (total) 255,131 35.4 1.7 parse time cpu 1,102 0.2 0.0 parse time elapsed 1,226 0.2 0.0 physical read IO requests 41,937 5.8 0.3 physical read bytes 343,547,904 47,595.8 2,238.8 physical read total IO requests 116,636 16.2 0.8 physical read total bytes 1,570,979,840 217,646.5 10,237.5 physical read total multi block 14 0.0 0.0 physical reads 41,937 5.8 0.3 physical reads cache 41,937 5.8 0.3 physical reads cache prefetch 0 0.0 0.0 physical reads direct 0 0.0 0.0 physical reads prefetch warmup 0 0.0 0.0 physical write IO requests 0 0.0 0.0 physical write bytes 0 0.0 0.0 physical write total IO requests 459,178 63.6 3.0 physical write total bytes 480,898,236,416 66,624,536.5 3,133,847.1 Instance Activity Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- physical write total multi block 458,612 63.5 3.0 physical writes 0 0.0 0.0 physical writes direct 0 0.0 0.0 physical writes direct temporary 0 0.0 0.0 physical writes non checkpoint 0 0.0 0.0 pinned buffers inspected 1 0.0 0.0 pinned cursors current 1 0.0 0.0 prefetch warmup blocks aged out 0 0.0 0.0 prefetched blocks aged out befor 1,011,193 140.1 6.6 process last non-idle time 792,792 109.8 5.2 queries parallelized 10,149 1.4 0.1 recursive calls 1,629,052 225.7 10.6 recursive cpu usage 15,793 2.2 0.1 redo buffer allocation retries 2,723 0.4 0.0 redo entries 138,646,102 19,208.3 903.5 redo log space requests 20,755 2.9 0.1 redo ordering marks 0 0.0 0.0 redo size 60,189,099,100 8,338,709.8 392,231.5 redo subscn max counts 2 0.0 0.0 redo synch long waits 0 0.0 0.0 redo synch time 23,481 3.3 0.2 redo synch time (usec) 235,871,603 32,678.1 1,537.1 redo synch time overhead (usec) 2,490,034 345.0 16.2 redo synch time overhead count ( 149,411 20.7 1.0 redo synch time overhead count ( 2 0.0 0.0 redo synch time overhead count ( 0 0.0 0.0 redo synch time overhead count ( 0 0.0 0.0 redo synch writes 163,614 22.7 1.1 redo write info find 149,413 20.7 1.0 rollback changes - undo records 82 0.0 0.0 rollbacks only - consistent read 1 0.0 0.0 root node splits 6 0.0 0.0 rows fetched via callback 937,277 129.9 6.1 securefile bytes non-transformed 0 0.0 0.0 securefile number of non-transfo 0 0.0 0.0 session connect time 1,613,210,909 223,497.2 10,512.7 session cursor cache hits 21,283 3.0 0.1 session logical reads 457,263,712 63,350.2 2,979.8 shared hash latch upgrades - no 56,692 7.9 0.4 shared hash latch upgrades - wai 0 0.0 0.0 sorts (memory) 132,751 18.4 0.9 sorts (rows) 691,453 95.8 4.5 sql area evicted 14 0.0 0.0 sql area purged 14 0.0 0.0 switch current caused by our pin 10,465 1.5 0.1 switch current to new buffer 10,468 1.5 0.1 table fetch by rowid 7,568,266 1,048.5 49.3 table fetch continued row 4 0.0 0.0 table scan blocks gotten 111,075 15.4 0.7 table scan disk non-IMC rows got 5,990,101 829.9 39.0 table scan rows gotten 5,990,101 829.9 39.0 table scans (direct read) 0 0.0 0.0 table scans (long tables) 0 0.0 0.0 table scans (short tables) 20,910 2.9 0.1 total cf enq hold time 229 0.0 0.0 total number of cf enq holders 70 0.0 0.0 transaction rollbacks 39 0.0 0.0 transaction tables consistent re 1 0.0 0.0 transaction tables consistent re 42 0.0 0.0 undo change vector size 17,820,432,972 2,468,875.9 116,129.6 Instance Activity Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- user calls 642,089 89.0 4.2 user commits 153,453 21.3 1.0 user logons cumulative 10,152 1.4 0.1 user logouts cumulative 10,150 1.4 0.1 user rollbacks 0 0.0 0.0 workarea executions - optimal 142,888 19.8 0.9 write clones created in foregrou 19,385 2.7 0.1 ------------------------------------------------------ Instance Activity Stats - Absolute Values DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- opened cursors current 1 9 session cursor cache count 4,066,792 4,279,969 session pga memory 2,327,760 20,401,504 session uga memory 1.393407665E+11 1.465437220E+11 session uga memory max 1.364653962E+12 1.435529913E+12 ------------------------------------------------------ IOStat by Filetype summary DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000 -> Small Read and Large Read are average service times -> Ordered by (Data Read + Write) desc Reads: Reqs Data Writes: Reqs Data Small Large Filetype Name Data per sec per sec Data per sec per sec Read Read -------------- ------- ------- ------- ------- ------- ------- -------- -------- Data File 460M 8.1 .064M 174.2G 2681.1 24.713M 119.35us Temp File 0M 0.0 0M 0M 0.0 0M 83.33us TOTAL: 460M 8.1 .064M 174.2G 2681.1 24.713M 119.34us ------------------------------------------------------ Tablespace IO Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ File IO Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Buffer Wait Statistics DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> ordered by wait time desc, waits desc Class Waits Total Wait Time (s) Avg Time (ms) ------------------ ----------- ------------------- -------------- undo header 169 5 27 data block 34 0 0 ------------------------------------------------------ Undo Segment Summary DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Undo Segment Stats DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Segments by Logical Reads DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Total Logical Reads: 457,263,712 -> Captured Segments account for 95.2% of Total -> When ** MISSING ** occurs, some of the object attributes may not be available Tablespace Owner Name -------------------- ---------- Subobject Obj. Logical Object Name Name Type Obj# Dataobj# Reads %Total -------------------- ---------- ----- ---------- ---------- ------------ ------- CDRDBUSER LT_INDEX01 HD4G_UQ 4G_04OCT20 INDEX 74672 74672 37,684,288 8.24 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_UQ 4G_08OCT20 INDEX 74700 74700 36,861,776 8.06 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_UQ 4G_10OCT20 INDEX 74714 74714 35,916,224 7.85 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_COCC_UQ CC_04OCT20 INDEX 74920 74920 19,556,448 4.28 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_COCC_UQ CC_08OCT20 INDEX 74932 74932 18,870,848 4.13 PDB: PCDRDB ------------------------------------------------------ Segments by Physical Reads DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Segments by Physical Read Requests DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Segments by UnOptimized Reads DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Segments by Optimized Reads DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Segments by Direct Physical Reads DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Segments by Physical Writes DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Total Physical Writes: 1 -> Captured Segments account for 2.0E+09% of Total -> When ** MISSING ** occurs, some of the object attributes may not be available Tablespace Owner Name -------------------- ---------- Subobject Obj. Physical Object Name Name Type Obj# Dataobj# Writes %Total -------------------- ---------- ----- ---------- ---------- ------------ ------- CDRDBUSER LT_INDEX01 HD4G_IMSI_NR_IDX 4G_04OCT20 INDEX 74669 74669 1,286,024 1.3E+08 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_IMEI_14_IDX 4G_04OCT20 INDEX 74670 74670 1,273,333 1.3E+08 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_MSISDN_NR_IDX 4G_04OCT20 INDEX 74667 74667 1,260,841 1.3E+08 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_IMSI_NR_IDX 4G_08OCT20 INDEX 74697 74697 1,234,401 1.2E+08 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_IMEI_14_IDX 4G_08OCT20 INDEX 74698 74698 1,226,351 1.2E+08 PDB: PCDRDB ------------------------------------------------------ Segments by Physical Write Requests DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Total Physical Write Requests: 1 -> Captured Segments account for 1.7E+09% of Total -> When ** MISSING ** occurs, some of the object attributes may not be available Tablespace Owner Name -------------------- ---------- Subobject Obj. Phys Write Object Name Name Type Obj# Dataobj# Requests %Total -------------------- ---------- ----- ---------- ---------- ------------ ------- CDRDBUSER LT_INDEX01 HD4G_IMEI_14_IDX 4G_04OCT20 INDEX 74670 74670 1,032,902 1.0E+08 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_IMSI_NR_IDX 4G_04OCT20 INDEX 74669 74669 1,031,429 1.0E+08 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_MSISDN_NR_IDX 4G_04OCT20 INDEX 74667 74667 1,018,357 1.0E+08 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_IMSI_NR_IDX 4G_08OCT20 INDEX 74697 74697 1,018,103 1.0E+08 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_IMEI_14_IDX 4G_08OCT20 INDEX 74698 74698 1,003,086 1.0E+08 PDB: PCDRDB ------------------------------------------------------ Segments by Direct Physical Writes DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Segments by Table Scans DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Segments by DB Blocks Changes DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> % of Capture shows % of DB Block Changes for each top segment compared -> with total DB Block Changes for all segments captured by the Snapshot -> When ** MISSING ** occurs, some of the object attributes may not be available Tablespace Owner Name -------------------- ---------- Subobject Obj. DB Block % of Object Name Name Type Obj# Dataobj# Changes Capture -------------------- ---------- ----- ---------- ---------- ------------ ------- CDRDBUSER LT_INDEX01 HD4G_UQ 4G_04OCT20 INDEX 74672 74672 7,080,144 5.19 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_UQ 4G_08OCT20 INDEX 74700 74700 6,989,872 5.13 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_COCC_UQ CC_04OCT20 INDEX 74920 74920 6,940,656 5.09 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_UQ 4G_10OCT20 INDEX 74714 74714 6,774,704 4.97 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_COCC_UQ CC_08OCT20 INDEX 74932 74932 6,719,280 4.93 PDB: PCDRDB ------------------------------------------------------ Segments by Row Lock Waits DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> % of Capture shows % of row lock waits for each top segment compared -> with total row lock waits for all segments captured by the Snapshot -> When ** MISSING ** occurs, some of the object attributes may not be available Tablespace Owner Name -------------------- ---------- Row Subobject Obj. Lock % of Object Name Name Type Obj# Dataobj# Waits Capture -------------------- ---------- ----- ---------- ---------- ------------ ------- CDRDBUSER LT_INDEX01 HD4G_UQ 4G_08OCT20 INDEX 74700 74700 25 9.51 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_UQ 4G_04OCT20 INDEX 74672 74672 24 9.13 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_UQ 4G_10OCT20 INDEX 74714 74714 18 6.84 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_COCC_UQ CC_10OCT20 INDEX 74938 74938 17 6.46 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_MSISDN_NR_IDX 4G_10OCT20 INDEX 74709 74709 15 5.70 PDB: PCDRDB ------------------------------------------------------ Segments by ITL Waits DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> % of Capture shows % of ITL waits for each top segment compared -> with total ITL waits for all segments captured by the Snapshot -> When ** MISSING ** occurs, some of the object attributes may not be available Tablespace Owner Name -------------------- ---------- Subobject Obj. ITL % of Object Name Name Type Obj# Dataobj# Waits Capture -------------------- ---------- ----- ---------- ---------- ------------ ------- CDRDBUSER LT_INDEX01 HD4G_LOCAL_SEQ_NR_ID 4G_08OCT20 INDEX 74696 74696 2 50.00 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_LOCAL_SEQ_NR_ID 4G_04OCT20 INDEX 74668 74668 1 25.00 PDB: PCDRDB CDRDBUSER LT_INDEX01 HD4G_LOCAL_SEQ_NR_ID 4G_10OCT20 INDEX 74710 74710 1 25.00 PDB: PCDRDB ------------------------------------------------------ Segments by Buffer Busy Waits DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> % of Capture shows % of Buffer Busy Waits for each top segment compared -> with total Buffer Busy Waits for all segments captured by the Snapshot -> When ** MISSING ** occurs, some of the object attributes may not be available Tablespace Owner Name -------------------- ---------- Buffer Subobject Obj. Busy % of Object Name Name Type Obj# Dataobj# Waits Capture -------------------- ---------- ----- ---------- ---------- ------------ ------- SYS SYSTEM SEG$ TABLE 14 8 28 82.35 PDB: PCDRDB SYS SYSTEM I_SCHEDULER_JOB4 INDEX 8813 8813 6 17.65 PDB: PCDRDB ------------------------------------------------------ Parameters modified by this container DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> This section shows all the modified initialization parameters that were in effect during the entire snapshot interval -> End Value is displayed only if the parameter value was modified within the snapshot interval End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- sga_target 0 PDB: PCDRDB undo_tablespace UNDOTBS1 PDB: PCDRDB ------------------------------------------------------ Parameters modified by other containers DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> This section shows all the modified initialization parameters that were in effect during the snapshot interval -> End Value is displayed only if the parameter value was changed within the snapshot interval End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- audit_file_dest /oracle/app/oracle/admin/cdrdb/ad audit_trail DB compatible 19.0.0 control_files +DATA/CDRDB/CONTROLFILE/current.2 db_block_size 8192 db_create_file_dest +DATA db_name cdrdb db_recovery_file_dest +FRA db_recovery_file_dest_size 13350469632 diagnostic_dest /oracle/app/oracle dispatchers (PROTOCOL=TCP) (SERVICE=cdrdbXDB) enable_pluggable_database TRUE local_listener LISTENER_CDRDB open_cursors 300 pga_aggregate_target 60737716224 processes 4480 remote_login_passwordfile EXCLUSIVE sga_target 182536110080 undo_tablespace UNDOTBS1 ------------------------------------------------------ Multi-Valued Parameters modified by this containerDB/Inst: CDRDB/cdrdb Snaps: No data exists for this section of the report. ------------------------------------------------------ Multi-Valued Parameters modified by other containersDB/Inst: CDRDB/cdrdb Snap -> This section only displays parameters that have more than one value ->'(NULL)' indicates a missing parameter value -> A blank in the 'End Snapshot' indicates the same value as the 'Begin Snapshot End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- control_files +DATA/CDRDB/CONTROLFILE/current.2 +FRA/CDRDB/CONTROLFILE/current.25 ------------------------------------------------------ Top SQL with Top Events DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Top SQL statements by DB Time along with the top events by DB Time for those SQLs. -> % Activity is the percentage of DB Time due to the SQL. -> % Event is the percentage of DB Time due to the event that the SQL is waiting on. -> % Row Source is the percentage of DB Time due to the row source for the SQL waiting on the event. -> Executions is the number of executions of the SQL that were sampled in ASH. SQL ID Plan Hash Executions % Activity ----------------------- -------------------- -------------------- -------------- % Row Event % Event Top Row Source Source ------------------------------ ------- --------------------------------- ------- Container Name ------------------------------------------- 85zarqwvf599k N/A 153 31.56 CPU + Wait for CPU 23.77 ** Row Source Not Available ** 23.77 INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C PCDRDB N/A 153 31.56 log file switch (checkpoint in 7.17 ** Row Source Not Available ** 7.17 INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C PCDRDB 2447725225 65 13.32 log file switch (checkpoint in 7.17 ** Row Source Not Available ** 7.17 INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C PCDRDB CPU + Wait for CPU 5.53 ** Row Source Not Available ** 5.53 0f0zjv1c0rq3q N/A 48 9.84 CPU + Wait for CPU 6.76 ** Row Source Not Available ** 6.76 INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ PCDRDB N/A 48 9.84 log file switch (checkpoint in 2.87 ** Row Source Not Available ** 2.87 INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ PCDRDB 9zg9qd9bm4spu 2447725225 37 7.58 log file switch (checkpoint in 7.58 UPDATE 7.58 update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1 PCDRDB 0f0zjv1c0rq3q 2447725225 23 4.71 log file switch (checkpoint in 3.48 ** Row Source Not Available ** 3.48 INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ PCDRDB CPU + Wait for CPU 1.02 ** Row Source Not Available ** 1.02 Top SQL with Top Events DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Top SQL statements by DB Time along with the top events by DB Time for those SQLs. -> % Activity is the percentage of DB Time due to the SQL. -> % Event is the percentage of DB Time due to the event that the SQL is waiting on. -> % Row Source is the percentage of DB Time due to the row source for the SQL waiting on the event. -> Executions is the number of executions of the SQL that were sampled in ASH. SQL ID Plan Hash Executions % Activity ----------------------- -------------------- -------------------- -------------- % Row Event % Event Top Row Source Source ------------------------------ ------- --------------------------------- ------- Container Name ------------------------------------------- ------------------------------------------------------ Top SQL with Top Row Sources DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Top SQL statements by DB Time along with the top row sources by DB Time for those SQLs. -> % Activity is the percentage of DB Time due to the SQL. -> % Row Source is the percentage of DB Time spent on the row source by that SQL. -> % Event is the percentage of DB Time spent on the event by the SQL executing the row source. -> Executions is the number of executions of the SQL that were sampled in ASH. SQL ID Plan Hash Executions % Activity ----------------------- -------------------- -------------------- -------------- % Row Row Source Source Top Event % Event ---------------------------------------- ------- ----------------------- ------- Container Name ------------------------------------------- 85zarqwvf599k N/A 153 31.56 ** Row Source Not Available ** 31.56 CPU + Wait for CPU 23.77 INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C PCDRDB 2447725225 65 13.32 ** Row Source Not Available ** 13.32 log file switch (checkp 7.17 INSERT INTO CDRDBUSER.HD4G_TB (RECORD_TYPE,RECORD_TYPE_DESCR,OPEN_DATE,IMSI_NR ,IMEI_NR,MSISDN_NR,DURATION,LOCAL_SEQ_NR,RECORD_SEQ_NR,CELL_ID,LOCATION_AREA,GW_ PLMNID_MCC,GW_PLMNID_MNC,SERV_NODE_PLMNID_MCC,SERV_NODE_PLMNID_MNC,CELL_PLMNID_M CC,CELL_PLMNID_MNC,CELL_PLMNID_MCC2,CELL_PLMNID_MNC2,CELL_PLMNID_TAC,E_CELL_ID,C PCDRDB 0f0zjv1c0rq3q N/A 48 9.84 ** Row Source Not Available ** 9.84 CPU + Wait for CPU 6.76 INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ PCDRDB 9zg9qd9bm4spu 2447725225 37 7.58 UPDATE 7.58 log file switch (checkp 7.58 update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1 PCDRDB 0f0zjv1c0rq3q 2447725225 23 4.71 ** Row Source Not Available ** 4.71 log file switch (checkp 3.48 INSERT INTO CDRDBUSER.HD4G_COCCONDITIONS_TB (COCC_DATE,COCC_LOCAL_SEQ_NR,COCC_ LINE_NR,COCC_REQ_QOS_INFO,COCC_NEG_QOS_INFO,COCC_UPL,COCC_DOWNL,COCC_CHNG_CONDIT ION,COCC_CHANGE_DATE,COCC_FAIL_HANDL_CONTIN,COCC_MCC,COCC_MNC,COCC_QCI,COCC_MAXR EQ_BANDW_UPL,COCC_MAXREQ_BANDW_DOWNL,COCC_GUAR_BIT_UPL,COCC_GUAR_BIT_DOWNL,COCC_ PCDRDB ------------------------------------------------------ Top Sessions DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> '# Samples Active' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall clock time and not total database activity. -> 'XIDs' shows the number of distinct transaction IDs sampled in ASH when the session was waiting for that particular event Sid, Serial# % Activity Event % Event --------------- ---------- ------------------------------ ---------- User Program # Samples Active XIDs -------------------- ------------------------------ ------------------ -------- 2061,52137 6.97 Data file init write 5.74 SYSTEM Toad.exe 28/722 [ 4%] 0 2,60211 4.51 Data file init write 3.28 SYS sqlplus@mtccdr...a (TNS V1-V3) 16/722 [ 2%] 0 CPU + Wait for CPU 1.02 5/722 [ 1%] 0 ------------------------------------------------------ Top Blocking Sessions DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Blocking session activity percentages are calculated with respect to waits on enqueues, latches and "buffer busy" only -> '% Activity' represents the load on the database caused by a particular blocking session -> '# Samples Active' shows the number of ASH samples in which the blocking session was found active. -> 'XIDs' shows the number of distinct transaction IDs sampled in ASH when the blocking session was found active. Blocking Sid (Inst) % Activity Event Caused % Event -------------------- ---------- ------------------------------ ---------- User Program # Samples Active XIDs -------------------- ------------------------------ ------------------ -------- 3147,42395( 1) 37.91 log file switch (checkpoint in 31.15 ** NOT FOUND ** BLOCKING SESSION NOT FOUND 0/722 [ 0%] N/A log file sync 5.74 N/A log file switch completion 1.02 N/A ------------------------------------------------------ Top PL/SQL Procedures DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Top Events DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Top Events by DB Time -> % Activity is the percentage of DB Time due to the event Event Event Class Session Type ----------------------------------- --------------- --------------- Avg Active % Activity Sessions ---------- ---------- CPU + Wait for CPU CPU FOREGROUND 47.75 0.32 log file switch (checkpoint incompl Configuration FOREGROUND 30.12 0.20 Data file init write User I/O FOREGROUND 9.02 0.06 log file sync Commit FOREGROUND 5.74 0.04 library cache lock Concurrency FOREGROUND 2.66 0.02 ------------------------------------------------------ Top Event P1/P2/P3 Values DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Top Events by DB Time and the top P1/P2/P3 values for those events. -> % Event is the percentage of DB Time due to the event -> % Activity is the percentage of DB Time due to the event with the given P1,P2,P3 Values. Event % Event P1, P2, P3 Values % Activity ------------------------------ ------- ----------------------------- ---------- Parameter 1 Parameter 2 Parameter 3 -------------------------- -------------------------- -------------------------- Data file init write 9.02 "1","256","2147483647" 9.02 count intr timeout log file sync 5.74 "13895","32373326","0" 0.20 buffer# sync scn NOT DEFINED library cache lock 2.66 "20350356448","19260269264"," 0.20 handle address lock address 100*mode+namespace ------------------------------------------------------ Top DB Objects DB/Inst: CDRDB/cdrdb Snaps: 309-311 No data exists for this section of the report. ------------------------------------------------------ Activity Over Time DB/Inst: CDRDB/cdrdb Snaps: 309-311 -> Analysis period is divided into smaller time slots as indicated in the 'Slot Time (Duration)'. -> Top 3 events are reported in each of those slots -> 'Slot Count' shows the number of ASH samples in that slot -> 'Event Count' shows the number of ASH samples waiting for that event in that slot -> '% Event' is 'Event Count' over all ASH samples in the analysis period Slot Event Slot Time (Duration) Count Event Count % Event -------------------- -------- ------------------------------ -------- ------- 12:00:25 (9.6 min) 25 CPU + Wait for CPU 12 2.46 log file switch (checkpoint in 11 2.25 db file sequential read 1 0.20 12:10:00 (10.0 min) 43 CPU + Wait for CPU 22 4.51 log file switch (checkpoint in 16 3.28 log file sync 3 0.61 12:20:00 (10.0 min) 52 CPU + Wait for CPU 31 6.35 log file switch (checkpoint in 16 3.28 SQL*Net more data from client 2 0.41 12:30:00 (10.0 min) 52 CPU + Wait for CPU 22 4.51 log file switch (checkpoint in 22 4.51 library cache lock 3 0.61 12:40:00 (10.0 min) 29 CPU + Wait for CPU 15 3.07 log file switch (checkpoint in 11 2.25 log file sync 2 0.41 12:50:00 (10.0 min) 39 CPU + Wait for CPU 13 2.66 Data file init write 11 2.25 log file switch (checkpoint in 11 2.25 13:00:00 (10.0 min) 54 CPU + Wait for CPU 15 3.07 Data file init write 15 3.07 log file switch (checkpoint in 14 2.87 13:10:00 (10.0 min) 41 CPU + Wait for CPU 23 4.71 log file switch (checkpoint in 11 2.25 Data file init write 3 0.61 13:20:00 (10.0 min) 48 CPU + Wait for CPU 22 4.51 Data file init write 13 2.66 log file switch (checkpoint in 7 1.43 13:30:00 (10.0 min) 24 CPU + Wait for CPU 15 3.07 log file switch (checkpoint in 6 1.23 log file sync 2 0.41 13:40:00 (10.0 min) 40 CPU + Wait for CPU 22 4.51 log file switch (checkpoint in 11 2.25 log file sync 5 1.02 13:50:00 (10.0 min) 35 CPU + Wait for CPU 22 4.51 log file switch (checkpoint in 12 2.46 library cache lock 1 0.20 14:00:00 (43 secs) 6 log file switch (checkpoint in 4 0.82 CPU + Wait for CPU 1 0.20 control file sequential read 1 0.20 ------------------------------------------------------ End of Report