WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Release RAC Host ------------ ----------- ------------ -------- ----------- --- ------------ UDAS2PDB 4123595889 udas2p2 2 10.2.0.4.0 YES sipd207 Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 1053 04-Apr-11 18:00:02 59 7.4 End Snap: 1055 04-Apr-11 20:00:35 56 7.5 Elapsed: 120.55 (mins) DB Time: 233.08 (mins) Cache Sizes ~~~~~~~~~~~ Begin End ---------- ---------- Buffer Cache: 3,728M 3,728M Std Block Size: 8K Shared Pool Size: 4,080M 4,080M Log Buffer: 14,332K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 245,392.33 10,042.66 Logical reads: 9,080.80 371.63 Block changes: 1,518.12 62.13 Physical reads: 7.50 0.31 Physical writes: 44.00 1.80 User calls: 36.44 1.49 Parses: 25.84 1.06 Hard parses: 0.59 0.02 Sorts: 12.06 0.49 Logons: 0.05 0.00 Executes: 295.91 12.11 Transactions: 24.43 % Blocks changed per Read: 16.72 Recursive Call %: 94.18 Rollback per transaction %: 4.15 Rows per Sort: 53.31 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 99.99 Redo NoWait %: 100.00 Buffer Hit %: 99.92 In-memory Sort %: 100.00 Library Hit %: 99.83 Soft Parse %: 97.71 Execute to Parse %: 91.27 Latch Hit %: 99.79 Parse CPU to Parse Elapsd %: 15.69 % Non-Parse CPU: 99.95 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 83.60 84.67 % SQL with executions>1: 97.49 97.19 % Memory for SQL w/exec>1: 97.10 96.67 Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- CPU time 4,503 32.2 RFS ping 168 4,275 25449 30.6 Other log file sequential read 183,537 4,173 23 29.8 System I/O SQL*Net more data from client 21,371 1,009 47 7.2 Network RFS write 25,438 343 13 2.5 System I/O ------------------------------------------------------------- RAC Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Begin End ----- ----- Number of Instances: 3 3 Global Cache Load Profile ~~~~~~~~~~~~~~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Global Cache blocks received: 0.78 0.03 Global Cache blocks served: 1.18 0.05 GCS/GES messages received: 131.69 5.39 GCS/GES messages sent: 139.26 5.70 DBWR Fusion writes: 0.06 0.00 Estd Interconnect traffic (KB) 68.60 Global Cache Efficiency Percentages (Target local+remote 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer access - local cache %: 99.91 Buffer access - remote cache %: 0.01 Buffer access - disk %: 0.08 Global Cache and Enqueue Services - Workload Characteristics ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg global enqueue get time (ms): 0.5 Avg global cache cr block receive time (ms): 0.9 Avg global cache current block receive time (ms): 1.0 Avg global cache cr block build time (ms): 0.0 Avg global cache cr block send time (ms): 0.1 Global cache log flushes for cr blocks served %: 2.9 Avg global cache cr block flush time (ms): 4.6 Avg global cache current block pin time (ms): 0.0 Avg global cache current block send time (ms): 0.1 Global cache log flushes for current blocks served %: 0.1 Avg global cache current block flush time (ms): 5.0 Global Cache and Enqueue Services - Messaging Statistics ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg message sent queue time (ms): 0.1 Avg message sent queue time on ksxp (ms): 0.6 Avg message received queue time (ms): 0.0 Avg GCS message process time (ms): 0.0 Avg GES message process time (ms): 0.1 % of direct sent messages: 31.57 % of indirect sent messages: 5.17 % of flow controlled messages: 63.26 ------------------------------------------------------------- Time Model Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total time in database user-calls (DB Time): 13984.6s -> Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic -> Ordered by % or DB time desc, Statistic name Statistic Name Time (s) % of DB Time ------------------------------------------ ------------------ ------------ sql execute elapsed time 7,270.6 52.0 DB CPU 4,503.1 32.2 parse time elapsed 506.7 3.6 hard parse elapsed time 497.8 3.6 sequence load elapsed time 152.4 1.1 failed parse elapsed time 19.5 .1 repeated bind elapsed time 3.4 .0 PL/SQL execution elapsed time 0.7 .0 hard parse (sharing criteria) elapsed time 0.3 .0 connection management call elapsed time 0.3 .0 hard parse (bind mismatch) elapsed time 0.0 .0 DB time 13,984.6 N/A background elapsed time 869.1 N/A background cpu time 276.6 N/A ------------------------------------------------------------- Wait Class DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc Avg %Time Total Wait wait Waits Wait Class Waits -outs Time (s) (ms) /txn -------------------- ---------------- ------ ---------------- ------- --------- System I/O 529,934 .0 4,980 9 3.0 Other 582,349 37.4 4,611 8 3.3 Network 279,858 .0 1,009 4 1.6 User I/O 54,899 .0 317 6 0.3 Concurrency 136,907 .1 58 0 0.8 Cluster 60,300 .0 41 1 0.3 Commit 80 .0 10 130 0.0 Application 6,707 .0 3 0 0.0 Configuration 17,528 98.5 1 0 0.1 ------------------------------------------------------------- Wait Events DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ------ ----------- ------- --------- RFS ping 168 .0 4,275 25449 0.0 log file sequential read 183,537 .0 4,173 23 1.0 SQL*Net more data from clien 21,371 .0 1,009 47 0.1 RFS write 25,438 .0 343 13 0.1 db file sequential read 54,680 .0 316 6 0.3 DFS lock handle 97,149 .0 214 2 0.5 log file parallel write 104,808 .0 157 2 0.6 db file parallel write 143,905 .0 149 1 0.8 RFS random i/o 25,438 .0 86 3 0.1 RFS dispatch 25,610 .0 56 2 0.1 control file sequential read 39,309 .0 55 1 0.2 row cache lock 130,665 .0 47 0 0.7 gc current grant 2-way 35,498 .0 23 1 0.2 wait for scn ack 50,872 .0 20 0 0.3 enq: WL - contention 6,156 .0 14 2 0.0 gc cr grant 2-way 16,917 .0 11 1 0.1 log file sync 80 .0 10 130 0.0 Log archive I/O 3,986 .0 9 2 0.0 control file parallel write 3,493 .0 8 2 0.0 latch free 2,356 .0 6 2 0.0 ksxr poll remote instances 278,473 49.4 6 0 1.6 enq: XR - database force log 2,890 .0 4 1 0.0 enq: TX - index contention 325 .0 3 11 0.0 buffer busy waits 4,371 .0 3 1 0.0 gc current block 2-way 3,002 .0 3 1 0.0 LGWR wait for redo copy 9,601 .2 2 0 0.1 SQL*Net break/reset to clien 6,438 .0 2 0 0.0 latch: ges resource hash lis 23,223 .0 2 0 0.1 enq: WF - contention 32 6.3 2 62 0.0 enq: FB - contention 660 .0 2 2 0.0 enq: PS - contention 1,088 .0 2 1 0.0 library cache lock 869 .0 1 2 0.0 enq: CF - contention 671 .1 1 2 0.0 gc current grant busy 1,488 .0 1 1 0.0 gc current multi block reque 1,072 .0 1 1 0.0 reliable message 618 .0 1 2 0.0 CGS wait for IPC msg 62,402 100.0 1 0 0.4 gc current block 3-way 998 .0 1 1 0.0 name-service call wait 18 .0 1 57 0.0 cursor: pin S wait on X 78 100.0 1 11 0.0 os thread startup 16 .0 1 53 0.0 enq: RO - fast object reuse 193 .0 1 3 0.0 IPC send completion sync 652 99.2 1 1 0.0 local write wait 194 .0 1 3 0.0 gc cr block 2-way 534 .0 0 1 0.0 log file switch completion 17 .0 0 20 0.0 SQL*Net message to client 258,483 .0 0 0 1.5 undo segment extension 17,282 99.9 0 0 0.1 gc cr block 3-way 286 .7 0 1 0.0 enq: TM - contention 76 .0 0 4 0.0 PX Deq: reap credit 15,246 95.6 0 0 0.1 kksfbc child completion 5 100.0 0 49 0.0 enq: TT - contention 141 .0 0 2 0.0 enq: HW - contention 203 .0 0 1 0.0 RFS create 2 .0 0 115 0.0 rdbms ipc reply 339 .0 0 1 0.0 PX Deq Credit: send blkd 452 20.1 0 0 0.0 gcs log flush sync 128 32.8 0 2 0.0 latch: cache buffers chains 128 .0 0 1 0.0 library cache pin 441 .0 0 0 0.0 Wait Events DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ------ ----------- ------- --------- PX Deq: Signal ACK 547 40.4 0 0 0.0 gc current block busy 98 .0 0 1 0.0 RFS close 2 .0 0 59 0.0 gc cr multi block request 384 .0 0 0 0.0 latch: messages 106 .0 0 1 0.0 read by other session 21 .0 0 3 0.0 enq: TS - contention 17 .0 0 4 0.0 enq: MN - contention 24 .0 0 2 0.0 enq: TA - contention 50 .0 0 1 0.0 latch: enqueue hash chains 12 .0 0 4 0.0 global enqueue expand wait 5 80.0 0 8 0.0 gc buffer busy 8 .0 0 4 0.0 enq: TO - contention 24 .0 0 1 0.0 latch: shared pool 6 .0 0 5 0.0 enq: US - contention 15 .0 0 2 0.0 gc cr block busy 9 .0 0 3 0.0 log buffer space 25 .0 0 1 0.0 enq: TD - KTF dump entries 26 .0 0 1 0.0 log file single write 20 .0 0 1 0.0 KJC: Wait for msg sends to c 77 .0 0 0 0.0 PX qref latch 1,937 99.9 0 0 0.0 ges inquiry response 13 .0 0 1 0.0 enq: IR - contention 21 .0 0 1 0.0 enq: TX - contention 5 .0 0 2 0.0 latch: redo allocation 13 .0 0 1 0.0 latch: KCL gc element parent 16 .0 0 1 0.0 enq: PI - contention 12 .0 0 1 0.0 latch: library cache 5 .0 0 1 0.0 enq: MW - contention 4 .0 0 1 0.0 buffer deadlock 145 100.7 0 0 0.0 cursor: pin S 291 .0 0 0 0.0 direct path write 4 .0 0 1 0.0 latch: object queue header o 9 .0 0 0 0.0 gc cr disk read 3 .0 0 1 0.0 enq: DR - contention 4 .0 0 1 0.0 enq: RS - file delete 2 .0 0 1 0.0 gc current grant congested 1 .0 0 2 0.0 latch: cache buffers lru cha 8 .0 0 0 0.0 latch: row cache objects 3 .0 0 0 0.0 enq: AF - task serialization 1 .0 0 1 0.0 enq: DD - contention 9 .0 0 0 0.0 gc quiesce 2 .0 0 0 0.0 SQL*Net more data to client 4 .0 0 0 0.0 latch: redo writing 1 .0 0 0 0.0 latch: checkpoint queue latc 2 .0 0 0 0.0 SQL*Net message from client 258,484 .0 64,695 250 1.5 LogMiner: wakeup event for p 143,742 65.9 20,841 145 0.8 PX Idle Wait 6,044 93.2 14,376 2379 0.0 gcs remote message 764,912 80.7 14,091 18 4.3 class slave wait 4,172 .2 12,091 2898 0.0 Streams AQ: qmn slave idle w 279 8.6 7,061 25310 0.0 Streams AQ: qmn coordinator 516 50.6 7,061 13685 0.0 DIAG idle wait 36,015 .0 7,060 196 0.2 ASM background timer 82,547 .0 7,050 85 0.5 virtual circuit status 241 100.0 7,047 29240 0.0 LogMiner: client waiting for 125,348 2.3 6,986 56 0.7 LogMiner: wakeup event for b 528,143 4.0 6,969 13 3.0 ges remote message 813,363 78.6 6,964 9 4.6 Streams AQ: waiting for time 24 100.0 6,955 289808 0.0 LogMiner: reader waiting for 3,074 99.5 1,514 493 0.0 Wait Events DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ------ ----------- ------- --------- LogMiner: wakeup event for r 20,698 1.3 94 5 0.1 PX Deq: Execution Msg 1,875 21.8 28 15 0.0 KSV master wait 4,164 .1 12 3 0.0 Streams fetch slave: waiting 6 100.0 6 977 0.0 PX Deq: Join ACK 648 39.0 1 1 0.0 PX Deq: Parse Reply 560 33.4 0 1 0.0 PX Deq: Msg Fragment 783 20.3 0 1 0.0 PX Deq: Execute Reply 387 24.0 0 0 0.0 PX Deq Credit: need buffer 92 7.6 0 0 0.0 Streams AQ: RAC qmn coordina 516 100.0 0 0 0.0 ------------------------------------------------------------- Background Wait Events DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by wait time desc, waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ------ ----------- ------- --------- log file parallel write 104,808 .0 157 2 0.6 db file parallel write 143,904 .0 149 1 0.8 log file sequential read 4,022 .0 78 19 0.0 events in waitclass Other 423,256 47.5 40 0 2.4 control file sequential read 21,175 .0 37 2 0.1 Log archive I/O 3,986 .0 9 2 0.0 control file parallel write 3,451 .0 8 2 0.0 row cache lock 194 .0 1 3 0.0 os thread startup 7 .0 0 40 0.0 gc current block 3-way 82 .0 0 1 0.0 gc cr block 2-way 77 .0 0 1 0.0 gc current block 2-way 100 .0 0 1 0.0 enq: TM - contention 14 .0 0 4 0.0 enq: RO - fast object reuse 42 .0 0 1 0.0 gc cr block 3-way 28 .0 0 2 0.0 gc current grant busy 44 .0 0 1 0.0 enq: HW - contention 14 .0 0 2 0.0 log buffer space 25 .0 0 1 0.0 buffer busy waits 39 .0 0 1 0.0 log file single write 8 .0 0 1 0.0 gc current block busy 4 .0 0 1 0.0 latch: shared pool 1 .0 0 4 0.0 latch: row cache objects 1 .0 0 1 0.0 latch: redo writing 1 .0 0 0 0.0 latch: cache buffers chains 1 .0 0 0 0.0 direct path write 1 .0 -0 -1 0.0 rdbms ipc message 1,445,971 10.3 132,850 92 8.2 gcs remote message 764,918 80.7 14,091 18 4.3 Streams AQ: qmn slave idle w 279 8.6 7,061 25310 0.0 Streams AQ: qmn coordinator 516 50.6 7,061 13685 0.0 pmon timer 2,455 100.0 7,061 2876 0.0 DIAG idle wait 36,015 .0 7,060 196 0.2 smon timer 1,926 76.4 7,054 3663 0.0 ASM background timer 82,546 .0 7,050 85 0.5 ges remote message 813,350 78.6 6,964 9 4.6 Streams AQ: waiting for time 24 100.0 6,955 289808 0.0 class slave wait 3,978 -.1 5,934 1492 0.0 KSV master wait 84 .0 1 16 0.0 PX Deq: Join ACK 79 41.8 0 1 0.0 PX Deq: Parse Reply 80 37.5 0 1 0.0 PX Deq: Execute Reply 47 34.0 0 0 0.0 Streams AQ: RAC qmn coordina 516 100.0 0 0 0.0 ------------------------------------------------------------- Operating System Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Statistic Total -------------------------------- -------------------- NUM_LCPUS 0 NUM_VCPUS 0 AVG_BUSY_TIME 121,690 AVG_IDLE_TIME 601,076 AVG_IOWAIT_TIME 26,647 AVG_SYS_TIME 60,686 AVG_USER_TIME 60,790 BUSY_TIME 1,219,031 IDLE_TIME 6,012,950 IOWAIT_TIME 268,647 SYS_TIME 608,969 USER_TIME 610,062 LOAD 0 OS_CPU_WAIT_TIME 2,057,600 RSRC_MGR_CPU_WAIT_TIME 0 PHYSICAL_MEMORY_BYTES 42,949,660,672 NUM_CPUS 10 NUM_CPU_CORES 5 ------------------------------------------------------------- Service Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads Reads -------------------------------- ------------ ------------ ---------- ---------- SYS$BACKGROUND 7,859.5 2,817.7 54,309 ########## udas2pdb_dg5.sbc.com 4,613.9 492.4 0 45,153 codiesd_yellow_srv 1,502.5 1,188.6 10 ########## SYS$USERS 8.1 4.2 0 0 udas2pXDB 0.0 0.0 0 0 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> 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 centisecond (100th of a second) 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 --------- --------- --------- --------- --------- --------- --------- --------- SYS$BACKGROUND 54895 31668 136478 5687 0 0 0 0 udas2pdb_dg5.sbc.com 0 0 4 8 0 0 46977 100853 codiesd_yellow_srv 10 9 372 76 0 0 225326 25 SYS$USERS 0 0 72 9 0 0 7489 2 ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> 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 Elapsed CPU Elap per % Total Time (s) Time (s) Executions Exec (s) DB Time SQL Id ---------- ---------- ------------ ---------- ------- ------------- 4,235 362 501 8.5 30.3 bgcntumz7118r select block_size, la_resetid , la_seq# , la_time, la_srlseq#, la_used, m a_scn, ma_time from (select block_size, la_resetid, la_seq#, last_seq la_srlseq #, (case when last_time is null then la_ntime else last_time end) la_time, (select nvl(max(used),0) fro 478 451 884,560 0.0 3.4 5bzzzm444tuxt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_FILE_EVENT_ASSOC" p where (:1="FK_EPG_EVENT_ID")and (:2="FK_EPG_FILE_ID") and rownum < 2 166 137 70,091 0.0 1.2 6834g5h4vu5zt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT" p where decod e(:1,'N','Y',decode(:2,"BASE_LINE_FILE_DATE",'Y'))='Y'and decode(:3,'N','Y',deco de(:4,"BK_EPG_PRGM_ID",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"BK_EVENT_START_ TS_GMT",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"BK_STATION_ID",'Y'))='Y'and de 115 106 195,276 0.0 0.8 5hp0972tj965n insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_AUDIT_TRAIL" p("ADULT _CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID","BF_A UDIT_ID","BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDE R_ID","CSF_SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT 109 104 163,594 0.0 0.8 7pk947fdpcpx9 update /*+ streams restrict_all_ref_cons */ "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p set "ADULT_CONTENT_IND"=decode(:1,'N',"ADULT_CONTENT_IND",:2), "ASSET_BILLING_E VENT_ID"=decode(:3,'N',"ASSET_BILLING_EVENT_ID",:4), "ASSET_DEPLOYMENT_ID"=decod e(:5,'N',"ASSET_DEPLOYMENT_ID",:6), "BE_STATE_ID"=decode(:7,'N',"BE_STATE_ID",:8 107 63 36,727 0.0 0.8 04junka693mns insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p("A DULT_CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID"," BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDER_ID","CSF _SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT_TS","LAST 82 29 22,368 0.0 0.6 cwryykbvf04sy insert /*+ restrict_all_ref_cons */ into "CODIE_TRANS"."CODIE_TRANSACTION_LOG" p("CODIE_CLIENT_APP","CODIE_CLIENT_REQUEST_TIME","CODIE_END_TIME","CODIE_METHOD_ ID","CODIE_START_TIME","CODIE_TRANS_DESCRIPTION","CODIE_TRANS_ID","CODIE_TRANS_S TATUS","FAILURE_SYSTEM","HOST_NAME","METHOD_VERSION","REQUEST_PARAMETER","RESPON 68 50 118 0.6 0.5 a3t2dv56rvvuj Module: JDBC Thin Client SELECT DISTINCT TUNER_POSITION,CHANNEL_NAME,ELCTRNC_PRGRM_GUIDE_GUID,CALL_LETTER S,MAP_NAME,MAP_AREA_NAME,VHO_CODE,DMA_NAME,CONTENT_TYPE,RESOLUTION,HD_FEE_RQRD FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PAC KAGE_BILLING_CODE IN ('U200') and not exists (select 1 from UDAS_CHMAP_SER_DETAI 60 36 75,406 0.0 0.4 b8b6jw88armvd delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT_CHANGE_HISTORY " p where decode(:1,'N','Y',decode(:2,"ATTRIBUTE_STATE",'Y'))='Y'and decode(:3,' N','Y',decode(:4,"FILE_DATE",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"FK_EPG_EV ENT_ID",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"MOD_ATTR_NAME",'Y'))='Y'and de 54 39 118 0.5 0.4 f8jra2wc6r5x7 Module: JDBC Thin Client SELECT TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID,COUNT(TUNER_POSITION) AS TUNERPO SITION FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U200') and not exi sts (select package_billing_code from ref_filter_package rbasic, ref_filter_cha ------------------------------------------------------------- SQL ordered by CPU Time DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> 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 CPU Elapsed CPU per % Total Time (s) Time (s) Executions Exec (s) DB Time SQL Id ---------- ---------- ------------ ----------- ------- ------------- 451 478 884,560 0.00 3.4 5bzzzm444tuxt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_FILE_EVENT_ASSOC" p where (:1="FK_EPG_EVENT_ID")and (:2="FK_EPG_FILE_ID") and rownum < 2 362 4,235 501 0.72 30.3 bgcntumz7118r select block_size, la_resetid , la_seq# , la_time, la_srlseq#, la_used, m a_scn, ma_time from (select block_size, la_resetid, la_seq#, last_seq la_srlseq #, (case when last_time is null then la_ntime else last_time end) la_time, (select nvl(max(used),0) fro 137 166 70,091 0.00 1.2 6834g5h4vu5zt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT" p where decod e(:1,'N','Y',decode(:2,"BASE_LINE_FILE_DATE",'Y'))='Y'and decode(:3,'N','Y',deco de(:4,"BK_EPG_PRGM_ID",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"BK_EVENT_START_ TS_GMT",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"BK_STATION_ID",'Y'))='Y'and de 106 115 195,276 0.00 0.8 5hp0972tj965n insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_AUDIT_TRAIL" p("ADULT _CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID","BF_A UDIT_ID","BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDE R_ID","CSF_SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT 104 109 163,594 0.00 0.8 7pk947fdpcpx9 update /*+ streams restrict_all_ref_cons */ "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p set "ADULT_CONTENT_IND"=decode(:1,'N',"ADULT_CONTENT_IND",:2), "ASSET_BILLING_E VENT_ID"=decode(:3,'N',"ASSET_BILLING_EVENT_ID",:4), "ASSET_DEPLOYMENT_ID"=decod e(:5,'N',"ASSET_DEPLOYMENT_ID",:6), "BE_STATE_ID"=decode(:7,'N',"BE_STATE_ID",:8 63 107 36,727 0.00 0.8 04junka693mns insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p("A DULT_CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID"," BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDER_ID","CSF _SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT_TS","LAST 50 68 118 0.42 0.5 a3t2dv56rvvuj Module: JDBC Thin Client SELECT DISTINCT TUNER_POSITION,CHANNEL_NAME,ELCTRNC_PRGRM_GUIDE_GUID,CALL_LETTER S,MAP_NAME,MAP_AREA_NAME,VHO_CODE,DMA_NAME,CONTENT_TYPE,RESOLUTION,HD_FEE_RQRD FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PAC KAGE_BILLING_CODE IN ('U200') and not exists (select 1 from UDAS_CHMAP_SER_DETAI 47 47 138,052 0.00 0.3 4m7m0t6fjcs5x update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= :7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 41 53 118 0.34 0.4 01mfzbszdmf0u Module: JDBC Thin Client SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_ GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME,SERVICE_TYPE FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN (' 39 54 118 0.33 0.4 f8jra2wc6r5x7 Module: JDBC Thin Client SELECT TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID,COUNT(TUNER_POSITION) AS TUNERPO SITION FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U200') and not exi sts (select package_billing_code from ref_filter_package rbasic, ref_filter_cha ------------------------------------------------------------- SQL ordered by Gets DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 65,681,712 -> Captured SQL account for 53.7% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- 8,030,087 884,560 9.1 12.2 451.42 477.83 5bzzzm444tuxt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_FILE_EVENT_ASSOC" p where (:1="FK_EPG_EVENT_ID")and (:2="FK_EPG_FILE_ID") and rownum < 2 2,580,775 70,091 36.8 3.9 137.45 166.40 6834g5h4vu5zt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT" p where decod e(:1,'N','Y',decode(:2,"BASE_LINE_FILE_DATE",'Y'))='Y'and decode(:3,'N','Y',deco de(:4,"BK_EPG_PRGM_ID",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"BK_EVENT_START_ TS_GMT",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"BK_STATION_ID",'Y'))='Y'and de 2,529,598 118 21,437.3 3.9 40.59 52.94 01mfzbszdmf0u Module: JDBC Thin Client SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_ GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME,SERVICE_TYPE FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN (' 2,529,598 118 21,437.3 3.9 50.03 67.78 a3t2dv56rvvuj Module: JDBC Thin Client SELECT DISTINCT TUNER_POSITION,CHANNEL_NAME,ELCTRNC_PRGRM_GUIDE_GUID,CALL_LETTER S,MAP_NAME,MAP_AREA_NAME,VHO_CODE,DMA_NAME,CONTENT_TYPE,RESOLUTION,HD_FEE_RQRD FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PAC KAGE_BILLING_CODE IN ('U200') and not exists (select 1 from UDAS_CHMAP_SER_DETAI 2,528,732 195,276 12.9 3.8 105.84 114.54 5hp0972tj965n insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_AUDIT_TRAIL" p("ADULT _CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID","BF_A UDIT_ID","BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDE R_ID","CSF_SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT 2,485,348 118 21,062.3 3.8 39.49 54.30 f8jra2wc6r5x7 Module: JDBC Thin Client SELECT TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID,COUNT(TUNER_POSITION) AS TUNERPO SITION FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U200') and not exi sts (select package_billing_code from ref_filter_package rbasic, ref_filter_cha 1,755,432 404 4,345.1 2.7 20.23 26.94 6yduvbd2j842m Module: JDBC Thin Client SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_ GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHANNELMAP_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND P ACKAGE_BILLING_CODE IN ('ENCORE','FLIX','HBO','HBOCIN','MAX','MOVIE','SHO','SHUN 1,457,220 163,594 8.9 2.2 104.47 108.67 7pk947fdpcpx9 update /*+ streams restrict_all_ref_cons */ "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p set "ADULT_CONTENT_IND"=decode(:1,'N',"ADULT_CONTENT_IND",:2), "ASSET_BILLING_E VENT_ID"=decode(:3,'N',"ASSET_BILLING_EVENT_ID",:4), "ASSET_DEPLOYMENT_ID"=decod e(:5,'N',"ASSET_DEPLOYMENT_ID",:6), "BE_STATE_ID"=decode(:7,'N',"BE_STATE_ID",:8 984,794 282 3,492.2 1.5 12.13 16.25 a40c657jd68jb Module: JDBC Thin Client SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_ GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHANNELMAP_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND P ACKAGE_BILLING_CODE IN ('ENCORE','FLIX','MOVIE','SHO','SHUNLD','STARZ','TMC','U3 904,187 334 2,707.1 1.4 12.02 16.84 9w4k19n7t49w2 Module: JDBC Thin Client SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_ SQL ordered by Gets DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 65,681,712 -> Captured SQL account for 53.7% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHANNELMAP_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND P ACKAGE_BILLING_CODE IN ('U200','UTVFMO') and not exists (select 1 from UDAS_CHAN 866,997 403 2,151.4 1.3 10.57 15.00 77tubv9f1jzsw Module: JDBC Thin Client SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_ GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHANNELMAP_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND P ACKAGE_BILLING_CODE IN ('U200') and not exists (select 1 from UDAS_CHANNELMAP_DE 781,193 37,662 20.7 1.2 32.53 33.02 02u3nfx78f82k delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."BF_STG_PRCH_HSTRY" p whe re (:1="ASSET_BILLING_EVENT_ID")and (:2="ASSET_DEPLOYMENT_ID")and decode(:3,'N', 'Y',decode(:4,"BE_STATE_ID",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"INSERT_TS" ,'Y'))='Y'and decode(:7,'N','Y',decode(:8,"IPTV_UPD_FAILURE_COUNT",'Y'))='Y'and 754,776 36,987 20.4 1.1 31.38 34.52 1y57yjg1yufch insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_STG_PRCH_HSTRY" p("AS SET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID","INSERT_TS","IPTV_UPD_ FAILURE_COUNT","IPTV_UPD_STATUS","LAST_UPDATE_TS","MDT_API_FAILURE_COUNT","MDT_D B_FAILURE_COUNT","PPV_ASSET_END_DT","PPV_ASSET_START_DT","PRICE","PRINCIPAL_EXTE 663,246 79 8,395.5 1.0 11.67 15.37 92cnrsm3kn8m9 Module: JDBC Thin Client SELECT PACKAGE_BILLING_CODE, PACKAGE_NAME, MAP_AREA_TYPE, MAP_AREA_NAME, CALL_LE TTERS, CHANNEL_NAME, CHANNEL_CATEGORY, RESOLUTION, TUNER_POSITION, PACKAGE_CATEG ORY, CHANNEL_ID,PACKAGE_TYPE, PACKAGE_CATALOG_ID FROM UDAS_PACKAGEDETAILS_BY_ARE A_V where ZIP_CODE=:1 AND MAP_AREA_TYPE=:2 AND UPPER(PACKAGE_BILLING_CODE) NOT I ------------------------------------------------------------- SQL ordered by Reads DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total Disk Reads: 54,246 -> Captured SQL account for 92.6% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- 9,714 70,091 0.1 17.9 137.45 166.40 6834g5h4vu5zt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT" p where decod e(:1,'N','Y',decode(:2,"BASE_LINE_FILE_DATE",'Y'))='Y'and decode(:3,'N','Y',deco de(:4,"BK_EPG_PRGM_ID",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"BK_EVENT_START_ TS_GMT",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"BK_STATION_ID",'Y'))='Y'and de 9,442 36,727 0.3 17.4 63.42 106.58 04junka693mns insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p("A DULT_CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID"," BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDER_ID","CSF _SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT_TS","LAST 7,265 884,560 0.0 13.4 451.42 477.83 5bzzzm444tuxt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_FILE_EVENT_ASSOC" p where (:1="FK_EPG_EVENT_ID")and (:2="FK_EPG_FILE_ID") and rownum < 2 4,623 3,737 1.2 8.5 10.49 37.26 8z3c84jwtfnx6 update /*+ streams restrict_all_ref_cons */ "UDAS_CODIE"."CLR_STG_CSF" p set "A GGREGATE_PRICE"=decode(:1,'N',"AGGREGATE_PRICE",:2), "BAN"=decode(:3,'N',"BAN",: 4), "BILL_ROUND_DATE"=decode(:5,'N',"BILL_ROUND_DATE",:6), "CREDIT_RISK_CLASS"=d ecode(:7,'N',"CREDIT_RISK_CLASS",:8), "DATE_SINCE_CUST_AVAIL"=decode(:9,'N',"DAT 4,274 75,406 0.1 7.9 35.67 60.06 b8b6jw88armvd delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT_CHANGE_HISTORY " p where decode(:1,'N','Y',decode(:2,"ATTRIBUTE_STATE",'Y'))='Y'and decode(:3,' N','Y',decode(:4,"FILE_DATE",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"FK_EPG_EV ENT_ID",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"MOD_ATTR_NAME",'Y'))='Y'and de 3,862 22,368 0.2 7.1 29.07 82.28 cwryykbvf04sy insert /*+ restrict_all_ref_cons */ into "CODIE_TRANS"."CODIE_TRANSACTION_LOG" p("CODIE_CLIENT_APP","CODIE_CLIENT_REQUEST_TIME","CODIE_END_TIME","CODIE_METHOD_ ID","CODIE_START_TIME","CODIE_TRANS_DESCRIPTION","CODIE_TRANS_ID","CODIE_TRANS_S TATUS","FAILURE_SYSTEM","HOST_NAME","METHOD_VERSION","REQUEST_PARAMETER","RESPON 3,294 97,009 0.0 6.1 33.91 39.61 b3mhvd205rwdy update /*+ streams restrict_all_ref_cons */ "VSDACCSM"."CM_PKG_PGA_COL_ASSOC" p set "BK_PRNCPL_GRP_HD_FEE_RQRD"=decode(:1,'N',"BK_PRNCPL_GRP_HD_FEE_RQRD",:2), "FREE_PRVW_IND"=decode(:3,'N',"FREE_PRVW_IND",:4), "GRANT_EFFECTIVE_TS"=decode(: 5,'N',"GRANT_EFFECTIVE_TS",:6), "GRANT_EXPIRY_TS"=decode(:7,'N',"GRANT_EXPIRY_TS 2,060 7,013 0.3 3.8 7.28 10.51 2ayzrpy102cbu delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_PROGRAM_VALUE" p whe re (:1="EPG_PRGM_VALUE_ID")and (:2="FK_EPG_PRGM_ID")and decode(:3,'N','Y',decode (:4,"PRGM_VALUE_DISP_NAME",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"PROGRAM_VAL UE",'Y'))='Y' 1,726 4,273 0.4 3.2 5.54 8.07 b6q2tjkcr2gsk delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_PROGRAM_ROLE" p wher e decode(:1,'N','Y',decode(:2,"EPG_ROLE_TITLE",'Y'))='Y'and (:3="FK_EPG_PRGM_ID" )and decode(:4,'N','Y',decode(:5,"NAME",'Y'))='Y'and decode(:6,'N','Y',decode(:7 ,"ROLE_ID",'Y'))='Y'and (:8="ROLE_ORDER") 1,461 1,868 0.8 2.7 3.96 8.16 9sb7u35bu8070 delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_PROGRAM" p where dec ode(:1,'N','Y',decode(:2,"EPG_PRGM_DESC",'Y'))='Y'and decode(:3,'N','Y',decode(: 4,"EPG_PRGM_EPISODE_TITLE",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"EPG_PRGM_RE DUCED_DESC",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"EPG_PRGM_REDUCED_TITLE",'Y 927 75,059 0.0 1.7 32.64 36.88 fbghutcr95x9v delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT_FLAG" p where SQL ordered by Reads DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total Disk Reads: 54,246 -> Captured SQL account for 92.6% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- decode(:1,'N','Y',decode(:2,"SCHDULE_FLAG_DISP_NAME",'Y'))='Y'and (:3="SCHEDULE_ FLAG_ID")and decode(:4,'N','Y',decode(:5,"SCHEDULE_FLAG_NAME",'Y'))='Y'and (:6=" SK_EPG_EVENT_ID") 771 195,276 0.0 1.4 105.84 114.54 5hp0972tj965n insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_AUDIT_TRAIL" p("ADULT _CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID","BF_A UDIT_ID","BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDE R_ID","CSF_SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT ------------------------------------------------------------- SQL ordered by Executions DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total Executions: 2,140,301 -> Captured SQL account for 90.1% of Total CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- 884,560 884,560 1.0 0.00 0.00 5bzzzm444tuxt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_FILE_EVENT_ASSOC" p where (:1="FK_EPG_EVENT_ID")and (:2="FK_EPG_FILE_ID") and rownum < 2 195,276 195,255 1.0 0.00 0.00 5hp0972tj965n insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_AUDIT_TRAIL" p("ADULT _CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID","BF_A UDIT_ID","BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDE R_ID","CSF_SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT 163,594 163,591 1.0 0.00 0.00 7pk947fdpcpx9 update /*+ streams restrict_all_ref_cons */ "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p set "ADULT_CONTENT_IND"=decode(:1,'N',"ADULT_CONTENT_IND",:2), "ASSET_BILLING_E VENT_ID"=decode(:3,'N',"ASSET_BILLING_EVENT_ID",:4), "ASSET_DEPLOYMENT_ID"=decod e(:5,'N',"ASSET_DEPLOYMENT_ID",:6), "BE_STATE_ID"=decode(:7,'N',"BE_STATE_ID",:8 138,052 138,051 1.0 0.00 0.00 4m7m0t6fjcs5x update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= :7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 97,009 97,009 1.0 0.00 0.00 b3mhvd205rwdy update /*+ streams restrict_all_ref_cons */ "VSDACCSM"."CM_PKG_PGA_COL_ASSOC" p set "BK_PRNCPL_GRP_HD_FEE_RQRD"=decode(:1,'N',"BK_PRNCPL_GRP_HD_FEE_RQRD",:2), "FREE_PRVW_IND"=decode(:3,'N',"FREE_PRVW_IND",:4), "GRANT_EFFECTIVE_TS"=decode(: 5,'N',"GRANT_EFFECTIVE_TS",:6), "GRANT_EXPIRY_TS"=decode(:7,'N',"GRANT_EXPIRY_TS 75,406 75,406 1.0 0.00 0.00 b8b6jw88armvd delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT_CHANGE_HISTORY " p where decode(:1,'N','Y',decode(:2,"ATTRIBUTE_STATE",'Y'))='Y'and decode(:3,' N','Y',decode(:4,"FILE_DATE",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"FK_EPG_EV ENT_ID",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"MOD_ATTR_NAME",'Y'))='Y'and de 75,059 75,059 1.0 0.00 0.00 fbghutcr95x9v delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT_FLAG" p where decode(:1,'N','Y',decode(:2,"SCHDULE_FLAG_DISP_NAME",'Y'))='Y'and (:3="SCHEDULE_ FLAG_ID")and decode(:4,'N','Y',decode(:5,"SCHEDULE_FLAG_NAME",'Y'))='Y'and (:6=" SK_EPG_EVENT_ID") 70,091 70,091 1.0 0.00 0.00 6834g5h4vu5zt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT" p where decod e(:1,'N','Y',decode(:2,"BASE_LINE_FILE_DATE",'Y'))='Y'and decode(:3,'N','Y',deco de(:4,"BK_EPG_PRGM_ID",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"BK_EVENT_START_ TS_GMT",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"BK_STATION_ID",'Y'))='Y'and de 37,662 37,655 1.0 0.00 0.00 02u3nfx78f82k delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."BF_STG_PRCH_HSTRY" p whe re (:1="ASSET_BILLING_EVENT_ID")and (:2="ASSET_DEPLOYMENT_ID")and decode(:3,'N', 'Y',decode(:4,"BE_STATE_ID",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"INSERT_TS" ,'Y'))='Y'and decode(:7,'N','Y',decode(:8,"IPTV_UPD_FAILURE_COUNT",'Y'))='Y'and 37,186 37,183 1.0 0.00 0.00 1vr7pb6d3yyux update /*+ streams restrict_all_ref_cons */ "UDAS_CODIE"."BF_STG_PRCH_HSTRY" p set "ASSET_BILLING_EVENT_ID"=decode(:1,'N',"ASSET_BILLING_EVENT_ID",:2), "ASSET_ DEPLOYMENT_ID"=decode(:3,'N',"ASSET_DEPLOYMENT_ID",:4), "BE_STATE_ID"=decode(:5, 'N',"BE_STATE_ID",:6), "INSERT_TS"=decode(:7,'N',"INSERT_TS",:8), "IPTV_UPD_FAIL 36,987 36,970 1.0 0.00 0.00 1y57yjg1yufch insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_STG_PRCH_HSTRY" p("AS SET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID","INSERT_TS","IPTV_UPD_ FAILURE_COUNT","IPTV_UPD_STATUS","LAST_UPDATE_TS","MDT_API_FAILURE_COUNT","MDT_D SQL ordered by Executions DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total Executions: 2,140,301 -> Captured SQL account for 90.1% of Total CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- B_FAILURE_COUNT","PPV_ASSET_END_DT","PPV_ASSET_START_DT","PRICE","PRINCIPAL_EXTE 36,727 36,725 1.0 0.00 0.00 04junka693mns insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p("A DULT_CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID"," BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDER_ID","CSF _SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT_TS","LAST 22,368 22,368 1.0 0.00 0.00 cwryykbvf04sy insert /*+ restrict_all_ref_cons */ into "CODIE_TRANS"."CODIE_TRANSACTION_LOG" p("CODIE_CLIENT_APP","CODIE_CLIENT_REQUEST_TIME","CODIE_END_TIME","CODIE_METHOD_ ID","CODIE_START_TIME","CODIE_TRANS_DESCRIPTION","CODIE_TRANS_ID","CODIE_TRANS_S TATUS","FAILURE_SYSTEM","HOST_NAME","METHOD_VERSION","REQUEST_PARAMETER","RESPON ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total Parse Calls: 186,924 -> Captured SQL account for 92.9% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 138,053 138,052 73.86 4m7m0t6fjcs5x update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= :7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 6,158 6,158 3.29 grwydz59pu6mc select text from view$ where rowid=:1 3,501 3,501 1.87 c0c2yafuncjnv select sequence#, first_change# from system.logmnr_log$ where session# = :1 and db_id = :2 and resetlogs_change# = :3 and 1,831 1,831 0.98 0fwgf46fun8jx DELETE SYSTEM.LOGMNR_DICTSTATE$ WHERE LOGMNR_UID = :B2 AND REDO_THREAD = :B1 AND ((END_SCNWRP * 4294967296 + END_SCNBAS) < (SELECT MAX (END_SCNWRP * 4294967296 + END_SCNBAS) FROM SYSTEM.LOGMNR_DICTSTATE$ WHERE LOGMNR_UID = :B2 AND REDO_THRE AD = :B1 )) 1,831 1,831 0.98 0na0jhwrs24wr DECLARE KRVX_STATUS_DICT_INTERNERR EXCEPTION; PRAGMA EXCEPTION_INIT(KRVX_STA TUS_DICT_INTERNERR, -1332); loc_logmnruid NUMBER; loc_endscnbas NUMBER; loc_endscnwrp NUMBER; loc_redothrd NUMBER; loc_rbasqn NUMBER; loc_rbablk NUMBER; loc_rbabyte NUMBER; BEGIN loc_logmnruid := : 1,831 1,831 0.98 5mtgrjn7p89vg select o.obj#, (select segcol# from system.logmnr_col$ tc where tc.n ame = 'OBJ#' and tc.logmnr_uid = o.logmnr_uid and tc.obj#= o.obj#) obj#_col, (select segcol# from system.logmnr_col$ tc where t c.name = 'TYPE#' and tc.logmnr_uid = o.logmnr_uid and tc.o 1,831 1,831 0.98 bjwxsk192yrzv INSERT INTO SYSTEM.LOGMNR_DICTSTATE$ (LOGMNR_UID, START_SCNBAS, START_SCNWRP, EN D_SCNBAS, END_SCNWRP, REDO_THREAD, RBASQN, RBABLK, RBABYTE) SELECT :B1 , START_S CNBAS, START_SCNWRP, :B7 , :B6 , :B5 , :B4 , :B3 , :B2 FROM SYSTEM.LOGMNR_DICTST ATE$ WHERE LOGMNR_UID = :B1 AND ROWNUM = 1 1,831 1,831 0.98 gcqvrzzs3jqd0 DECLARE logmnr_uid NUMBER := :1; ScnBas NUMBER := :2; ScnWrp NUMBER := :3; RedoThrd NUMBER := :4; loc_rbasqn NUMBER := :5; loc_ rbablk NUMBER := :6; loc_rbabyte NUMBER := :7; Apply NUMBER := 0; BEGIN sys.logmnr_krvrda_test_apply(logmnr_uid, ScnBas, ScnWrp, RedoThrd, 1,167 1,167 0.62 1xs8jj898abvt select min(next_change#) from system.logmnr_log$ where session#=:1 and db_id =: 2 and resetlogs_change#=:3 and reset_timestamp=:4 1,167 1,167 0.62 3h9zxfbdq6bvj begin sys.logmnr_dict_cache.purge_scn(:logmnruid, :lcscn); end; ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Only Statements with Version Count greater than 20 are displayed Version Count Executions SQL Id -------- ------------ ------------- 38 22,368 cwryykbvf04sy insert /*+ restrict_all_ref_cons */ into "CODIE_TRANS"."CODIE_TRANSACTION_LOG" p("CODIE_CLIENT_APP","CODIE_CLIENT_REQUEST_TIME","CODIE_END_TIME","CODIE_METHOD_ ID","CODIE_START_TIME","CODIE_TRANS_DESCRIPTION","CODIE_TRANS_ID","CODIE_TRANS_S TATUS","FAILURE_SYSTEM","HOST_NAME","METHOD_VERSION","REQUEST_PARAMETER","RESPON ------------------------------------------------------------- SQL ordered by Cluster Wait Time DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Cluster CWT % of Elapsed CPU Wait Time (s) Elapsd Tim Time(s) Time(s) Executions SQL Id ------------- ---------- ----------- ----------- -------------- ------------- 6.48 3.9 166.40 137.45 70,091 6834g5h4vu5zt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT" p where decod e(:1,'N','Y',decode(:2,"BASE_LINE_FILE_DATE",'Y'))='Y'and decode(:3,'N','Y',deco de(:4,"BK_EPG_PRGM_ID",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"BK_EVENT_START_ TS_GMT",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"BK_STATION_ID",'Y'))='Y'and de 4.80 8.0 60.06 35.67 75,406 b8b6jw88armvd delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT_CHANGE_HISTORY " p where decode(:1,'N','Y',decode(:2,"ATTRIBUTE_STATE",'Y'))='Y'and decode(:3,' N','Y',decode(:4,"FILE_DATE",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"FK_EPG_EV ENT_ID",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"MOD_ATTR_NAME",'Y'))='Y'and de 4.68 1.0 477.83 451.42 884,560 5bzzzm444tuxt delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_FILE_EVENT_ASSOC" p where (:1="FK_EPG_EVENT_ID")and (:2="FK_EPG_FILE_ID") and rownum < 2 4.42 5.4 82.28 29.07 22,368 cwryykbvf04sy insert /*+ restrict_all_ref_cons */ into "CODIE_TRANS"."CODIE_TRANSACTION_LOG" p("CODIE_CLIENT_APP","CODIE_CLIENT_REQUEST_TIME","CODIE_END_TIME","CODIE_METHOD_ ID","CODIE_START_TIME","CODIE_TRANS_DESCRIPTION","CODIE_TRANS_ID","CODIE_TRANS_S TATUS","FAILURE_SYSTEM","HOST_NAME","METHOD_VERSION","REQUEST_PARAMETER","RESPON 3.11 8.4 37.26 10.49 3,737 8z3c84jwtfnx6 update /*+ streams restrict_all_ref_cons */ "UDAS_CODIE"."CLR_STG_CSF" p set "A GGREGATE_PRICE"=decode(:1,'N',"AGGREGATE_PRICE",:2), "BAN"=decode(:3,'N',"BAN",: 4), "BILL_ROUND_DATE"=decode(:5,'N',"BILL_ROUND_DATE",:6), "CREDIT_RISK_CLASS"=d ecode(:7,'N',"CREDIT_RISK_CLASS",:8), "DATE_SINCE_CUST_AVAIL"=decode(:9,'N',"DAT 2.47 6.2 39.61 33.91 97,009 b3mhvd205rwdy update /*+ streams restrict_all_ref_cons */ "VSDACCSM"."CM_PKG_PGA_COL_ASSOC" p set "BK_PRNCPL_GRP_HD_FEE_RQRD"=decode(:1,'N',"BK_PRNCPL_GRP_HD_FEE_RQRD",:2), "FREE_PRVW_IND"=decode(:3,'N',"FREE_PRVW_IND",:4), "GRANT_EFFECTIVE_TS"=decode(: 5,'N',"GRANT_EFFECTIVE_TS",:6), "GRANT_EXPIRY_TS"=decode(:7,'N',"GRANT_EXPIRY_TS 1.60 15.3 10.51 7.28 7,013 2ayzrpy102cbu delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_PROGRAM_VALUE" p whe re (:1="EPG_PRGM_VALUE_ID")and (:2="FK_EPG_PRGM_ID")and decode(:3,'N','Y',decode (:4,"PRGM_VALUE_DISP_NAME",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"PROGRAM_VAL UE",'Y'))='Y' 1.55 1.4 114.54 105.84 195,276 5hp0972tj965n insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_AUDIT_TRAIL" p("ADULT _CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID","BF_A UDIT_ID","BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDE R_ID","CSF_SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT 1.09 1.0 106.58 63.42 36,727 04junka693mns insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p("A DULT_CONTENT_IND","ASSET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID"," BILLED_AMOUNT","BILLED_ASSET_TITLE","BILLING_FILE_ID","CONTENT_PROVIDER_ID","CSF _SRC_STATUS","CURRENCY","DISCOUNT_AMOUNT","EVENT_TYPE","GENRE","INSERT_TS","LAST 1.08 13.3 8.16 3.96 1,868 9sb7u35bu8070 delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_PROGRAM" p where dec ode(:1,'N','Y',decode(:2,"EPG_PRGM_DESC",'Y'))='Y'and decode(:3,'N','Y',decode(: 4,"EPG_PRGM_EPISODE_TITLE",'Y'))='Y'and decode(:5,'N','Y',decode(:6,"EPG_PRGM_RE DUCED_DESC",'Y'))='Y'and decode(:7,'N','Y',decode(:8,"EPG_PRGM_REDUCED_TITLE",'Y 1.08 13.4 8.07 5.54 4,273 b6q2tjkcr2gsk delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_PROGRAM_ROLE" p wher SQL ordered by Cluster Wait Time DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Cluster CWT % of Elapsed CPU Wait Time (s) Elapsd Tim Time(s) Time(s) Executions SQL Id ------------- ---------- ----------- ----------- -------------- ------------- e decode(:1,'N','Y',decode(:2,"EPG_ROLE_TITLE",'Y'))='Y'and (:3="FK_EPG_PRGM_ID" )and decode(:4,'N','Y',decode(:5,"NAME",'Y'))='Y'and decode(:6,'N','Y',decode(:7 ,"ROLE_ID",'Y'))='Y'and (:8="ROLE_ORDER") 1.02 2.8 36.88 32.64 75,059 fbghutcr95x9v delete /*+ restrict_all_ref_cons */ from "UDAS_CODIE"."EPG_EVENT_FLAG" p where decode(:1,'N','Y',decode(:2,"SCHDULE_FLAG_DISP_NAME",'Y'))='Y'and (:3="SCHEDULE_ FLAG_ID")and decode(:4,'N','Y',decode(:5,"SCHEDULE_FLAG_NAME",'Y'))='Y'and (:6=" SK_EPG_EVENT_ID") .63 4.7 13.43 12.74 3,174 9cc2u12mg7vsu Module: JDBC Thin Client SELECT DISTINCT(a.BOUNDARY_ZIP_CODE_DIGITS),COUNT(DISTINCT b.MAP_AREA_NAME) from SERVICE_AREA_BOUNDARY a,CHANNEL_MAP_DETAILS b WHERE a.SK_CHANNEL_MAP=b.SK_CHANN EL_MAP AND a.BOUNDARY_ZIP_CODE_DIGITS like :1 GROUP BY a.BOUNDARY_ZIP_CODE_DIGIT S .48 0.4 108.67 104.47 163,594 7pk947fdpcpx9 update /*+ streams restrict_all_ref_cons */ "UDAS_CODIE"."BF_MART_PRCH_HSTRY" p set "ADULT_CONTENT_IND"=decode(:1,'N',"ADULT_CONTENT_IND",:2), "ASSET_BILLING_E VENT_ID"=decode(:3,'N',"ASSET_BILLING_EVENT_ID",:4), "ASSET_DEPLOYMENT_ID"=decod e(:5,'N',"ASSET_DEPLOYMENT_ID",:6), "BE_STATE_ID"=decode(:7,'N',"BE_STATE_ID",:8 .43 2.8 15.37 11.67 79 92cnrsm3kn8m9 Module: JDBC Thin Client SELECT PACKAGE_BILLING_CODE, PACKAGE_NAME, MAP_AREA_TYPE, MAP_AREA_NAME, CALL_LE TTERS, CHANNEL_NAME, CHANNEL_CATEGORY, RESOLUTION, TUNER_POSITION, PACKAGE_CATEG ORY, CHANNEL_ID,PACKAGE_TYPE, PACKAGE_CATALOG_ID FROM UDAS_PACKAGEDETAILS_BY_ARE A_V where ZIP_CODE=:1 AND MAP_AREA_TYPE=:2 AND UPPER(PACKAGE_BILLING_CODE) NOT I .27 21.7 1.26 0.32 1 20jfw15bd7ux2 Module: JDBC Thin Client SELECT a.tablespace_name,ROUND (a.bytes_alloc / 1024 / 1024) megs_alloc,ROUND ( NVL (b.bytes_free, 0) / 1024 / 1024) megs_free, ROUND (maxbytes / 1048576) MAX F ROM (SELECT f.tablespace_name, SUM (f.bytes) bytes_alloc,SUM (DECODE (f.autoex tensible,'YES', f.maxbytes,'NO', f.bytes )) maxbytes FROM dba_data_files f GROUP .25 43.4 0.58 0.31 1 1qw9jpxutv9cf Module: JDBC Thin Client select owner,round(sum(bytes/1024/1024)) from dba_segments group by owner .16 4.5 3.63 0.72 216 at3pc0zccu5t0 insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_MART_MDT" p("ADULT_CO NTENT_IND","ASSET_DEPLOYMENT_ID","CHARGE","CONTENT_PROVIDER_ID","CURRENCY","EVEN T_TYPE","FILTER_COUNT","GENRE","INSERT_TS","LAST_UPDATE_TS","LOAD_ID","LOAD_MECH ","PPV_ASSET_END_DT","PPV_ASSET_START_DT","PROVIDER_ASSET_ID","RATING","RESOURCE .12 2.6 4.50 3.89 1 d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end; .10 0.3 34.52 31.38 36,987 1y57yjg1yufch insert /*+ restrict_all_ref_cons */ into "UDAS_CODIE"."BF_STG_PRCH_HSTRY" p("AS SET_BILLING_EVENT_ID","ASSET_DEPLOYMENT_ID","BE_STATE_ID","INSERT_TS","IPTV_UPD_ FAILURE_COUNT","IPTV_UPD_STATUS","LAST_UPDATE_TS","MDT_API_FAILURE_COUNT","MDT_D B_FAILURE_COUNT","PPV_ASSET_END_DT","PPV_ASSET_START_DT","PRICE","PRINCIPAL_EXTE .02 4.7 0.38 0.30 3,501 5vywdt5htuv3y select file_name, sequence#, next_change#, prev_resetlogs_change#, prev_reset_timestamp from system.logmnr_log$ where session# = :1 and SQL ordered by Cluster Wait Time DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Cluster CWT % of Elapsed CPU Wait Time (s) Elapsd Tim Time(s) Time(s) Executions SQL Id ------------- ---------- ----------- ----------- -------------- ------------- db_id = :2 and .02 2.8 0.62 0.56 3,501 c0c2yafuncjnv select sequence#, first_change# from system.logmnr_log$ where session# = :1 and db_id = :2 and resetlogs_change# = :3 and .02 3.7 0.43 0.43 1,055 g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob j# = :objn .01 4.9 0.23 0.14 2 0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, s d_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHE N (sd_xe_ash_nm.parameter1 is NULL OR sd_x e_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) .01 17.7 0.06 0.04 1 bdf1678djndby select sum(extra_latency) as impact, sum(case when extra_latency >= :sig_ time then 1 else 0 end) as slow_files, sum(case when read_time >= :sig_read_time or reads >= :sig_reads then 1 else 0 end) as sig_files from ( select sb_reads + mb_reads as reads, read_time, case whe .01 0.4 2.36 0.41 11 4dxyvxm331xb3 Module: JDBC Thin Client SELECT a.inst_id,SUM (DECODE (NAME, 'db block changes', VALUE, 0)),SUM (DECODE ( NAME, 'db block gets', VALUE, 0)),SUM (DECODE (NAME, 'consistent gets', VALUE, 0 )),SUM (DECODE (NAME, 'physical reads', VALUE, 0)),SUM (DECODE (NAME, 'physical writes', VALUE, 0)),SUM (DECODE (NAME, 'redo writes', VALUE, 0)),SUM (DECODE (NA .01 0.0 13.25 9.64 23 431ukanuxc5uj Module: JDBC Thin Client SELECT DISTINCT TUNER_POSITION,CHANNEL_NAME,ELCTRNC_PRGRM_GUIDE_GUID,CALL_LETTER S,MAP_NAME,MAP_AREA_NAME,VHO_CODE,DMA_NAME,CONTENT_TYPE,RESOLUTION,HD_FEE_RQRD FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PAC KAGE_BILLING_CODE IN ('U100') and not exists (select 1 from UDAS_CHMAP_SER_DETAI .01 12.6 0.04 0.04 2 ady1kf66yq0p8 select sum(blk_read) as blk_read, sum(read_time) as read_time, sum(blk_write) as blk_write, sum(write_time) as write_time, sum(tot_reads) as reads, sum(tot_writes) as writes, sum(sb _reads) as sreads, sum(sb_read_time) as srds_time, count(*) ------------------------------------------------------------- Instance Activity Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- CPU used by this session 418,830 57.9 2.4 CPU used when call started 157,141 21.7 0.9 CR blocks created 2,227 0.3 0.0 Cached Commit SCN referenced 901 0.1 0.0 Commit SCN cached 2 0.0 0.0 DB time 628,757 86.9 3.6 DBWR checkpoint buffers written 316,074 43.7 1.8 DBWR checkpoints 71 0.0 0.0 DBWR fusion writes 404 0.1 0.0 DBWR object drop buffers written 1,034 0.1 0.0 DBWR revisited being-written buf 0 0.0 0.0 DBWR tablespace checkpoint buffe 0 0.0 0.0 DBWR transaction table writes 265 0.0 0.0 DBWR undo block writes 98,363 13.6 0.6 DFO trees parallelized 167 0.0 0.0 Misses for writing mapping 0 0.0 0.0 PX local messages recv'd 918 0.1 0.0 PX local messages sent 918 0.1 0.0 PX remote messages recv'd 1,563 0.2 0.0 PX remote messages sent 1,812 0.3 0.0 Parallel operations downgraded 2 0 0.0 0.0 Parallel operations downgraded t 0 0.0 0.0 Parallel operations not downgrad 167 0.0 0.0 RowCR attempts 0 0.0 0.0 RowCR hits 0 0.0 0.0 SMON posted for instance recover 0 0.0 0.0 SMON posted for undo segment shr 26 0.0 0.0 SQL*Net roundtrips to/from clien 258,364 35.7 1.5 active txn count during cleanout 28,824 4.0 0.2 application wait time 331 0.1 0.0 background checkpoints completed 2 0.0 0.0 background checkpoints started 1 0.0 0.0 background timeouts 31,436 4.4 0.2 branch node splits 11 0.0 0.0 buffer is not pinned count 11,885,220 1,643.2 67.3 buffer is pinned count 9,842,301 1,360.7 55.7 bytes received via SQL*Net from 2,814,886,802 389,171.2 15,926.8 bytes sent via SQL*Net to client 171,465,270 23,705.9 970.2 calls to get snapshot scn: kcmgs 2,570,419 355.4 14.5 calls to kcmgas 430,829 59.6 2.4 calls to kcmgcs 21,160 2.9 0.1 change write time 78,082 10.8 0.4 cleanout - number of ktugct call 32,148 4.4 0.2 cleanouts and rollbacks - consis 1,109 0.2 0.0 cleanouts only - consistent read 2,280 0.3 0.0 cluster key scan block gets 23,112 3.2 0.1 cluster key scans 5,718 0.8 0.0 cluster wait time 4,117 0.6 0.0 commit batch performed 169,370 23.4 1.0 commit batch requested 169,370 23.4 1.0 commit batch/immediate performed 169,489 23.4 1.0 commit batch/immediate requested 169,489 23.4 1.0 commit cleanout failures: block 311 0.0 0.0 commit cleanout failures: buffer 0 0.0 0.0 commit cleanout failures: callba 473 0.1 0.0 commit cleanout failures: cannot 894 0.1 0.0 commit cleanouts 697,860 96.5 4.0 commit cleanouts successfully co 696,182 96.3 3.9 commit immediate performed 119 0.0 0.0 commit immediate requested 119 0.0 0.0 Instance Activity Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- commit nowait performed 169,370 23.4 1.0 commit nowait requested 169,370 23.4 1.0 commit txn count during cleanout 38,022 5.3 0.2 commit wait/nowait performed 169,370 23.4 1.0 commit wait/nowait requested 169,370 23.4 1.0 concurrency wait time 5,775 0.8 0.0 consistent changes 8,104 1.1 0.1 consistent gets 51,781,889 7,159.1 293.0 consistent gets - examination 10,368,258 1,433.5 58.7 consistent gets direct 0 0.0 0.0 consistent gets from cache 51,782,375 7,159.2 293.0 current blocks converted for CR 0 0.0 0.0 cursor authentications 412 0.1 0.0 data blocks consistent reads - u 5,459 0.8 0.0 db block changes 10,980,587 1,518.1 62.1 db block gets 13,899,823 1,921.7 78.7 db block gets direct 36 0.0 0.0 db block gets from cache 13,899,787 1,921.7 78.7 deferred (CURRENT) block cleanou 256,613 35.5 1.5 dirty buffers inspected 535 0.1 0.0 enqueue conversions 26,450 3.7 0.2 enqueue releases 1,077,192 148.9 6.1 enqueue requests 1,086,494 150.2 6.2 enqueue timeouts 9,312 1.3 0.1 enqueue waits 11,811 1.6 0.1 exchange deadlocks 147 0.0 0.0 execute count 2,140,301 295.9 12.1 failed probes on index block rec 5 0.0 0.0 frame signature mismatch 0 0.0 0.0 free buffer inspected 109,729 15.2 0.6 free buffer requested 140,884 19.5 0.8 gc CPU used by this session 9,975 1.4 0.1 gc blocks lost 0 0.0 0.0 gc cr block build time 4 0.0 0.0 gc cr block flush time 17 0.0 0.0 gc cr block receive time 75 0.0 0.0 gc cr block send time 7 0.0 0.0 gc cr blocks received 858 0.1 0.0 gc cr blocks served 1,296 0.2 0.0 gc current block flush time 5 0.0 0.0 gc current block pin time 23 0.0 0.0 gc current block receive time 494 0.1 0.0 gc current block send time 50 0.0 0.0 gc current blocks received 4,791 0.7 0.0 gc current blocks served 7,234 1.0 0.0 gc local grants 79,438 11.0 0.5 gc remote grants 63,224 8.7 0.4 gcs messages sent 308,382 42.6 1.7 ges messages sent 698,877 96.6 4.0 global enqueue get time 65,007 9.0 0.4 global enqueue gets async 454,720 62.9 2.6 global enqueue gets sync 874,592 120.9 5.0 global enqueue releases 859,997 118.9 4.9 heap block compress 44,377 6.1 0.3 hot buffers moved to head of LRU 111,222 15.4 0.6 immediate (CR) block cleanout ap 3,389 0.5 0.0 immediate (CURRENT) block cleano 114,957 15.9 0.7 index crx upgrade (found) 2 0.0 0.0 index crx upgrade (positioned) 8,007 1.1 0.1 index fast full scans (full) 0 0.0 0.0 Instance Activity Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- index fetch by key 5,964,951 824.7 33.8 index scans kdiixs1 539,653 74.6 3.1 leaf node 90-10 splits 658 0.1 0.0 leaf node splits 4,408 0.6 0.0 lob reads 170 0.0 0.0 lob writes 735 0.1 0.0 lob writes unaligned 735 0.1 0.0 logons cumulative 391 0.1 0.0 messages received 1,635,930 226.2 9.3 messages sent 1,635,930 226.2 9.3 no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 41,028,886 5,672.4 232.1 opened cursors cumulative 183,497 25.4 1.0 parse count (failures) 3,219 0.5 0.0 parse count (hard) 4,275 0.6 0.0 parse count (total) 186,924 25.8 1.1 parse time cpu 222 0.0 0.0 parse time elapsed 1,415 0.2 0.0 physical read IO requests 54,246 7.5 0.3 physical read bytes 444,383,232 61,438.1 2,514.4 physical read total IO requests 280,790 38.8 1.6 physical read total bytes 308,035,067,904 42,587,285.1 1,742,881.1 physical read total multi block 166,192 23.0 0.9 physical reads 54,246 7.5 0.3 physical reads cache 54,246 7.5 0.3 physical reads cache prefetch 0 0.0 0.0 physical reads direct 0 0.0 0.0 physical reads direct (lob) 0 0.0 0.0 physical reads direct temporary 0 0.0 0.0 physical reads prefetch warmup 0 0.0 0.0 physical write IO requests 145,002 20.1 0.8 physical write bytes 2,607,349,760 360,478.3 14,752.5 physical write total IO requests 429,275 59.4 2.4 physical write total bytes 16,183,983,616 2,237,511.2 91,570.0 physical write total multi block 313,332 43.3 1.8 physical writes 318,280 44.0 1.8 physical writes direct 36 0.0 0.0 physical writes direct (lob) 0 0.0 0.0 physical writes from cache 318,244 44.0 1.8 physical writes non checkpoint 126,182 17.5 0.7 pinned buffers inspected 1 0.0 0.0 prefetch clients - default 0 0.0 0.0 prefetch warmup blocks aged out 0 0.0 0.0 prefetched blocks aged out befor 0 0.0 0.0 process last non-idle time 4,064 0.6 0.0 queries parallelized 156 0.0 0.0 recovery blocks read 0 0.0 0.0 recursive aborts on index block 0 0.0 0.0 recursive calls 4,266,045 589.8 24.1 recursive cpu usage 169,296 23.4 1.0 redo blocks read for recovery 0 0.0 0.0 redo blocks written 3,612,342 499.4 20.4 redo buffer allocation retries 4 0.0 0.0 redo entries 5,708,572 789.2 32.3 redo log space requests 13 0.0 0.0 redo log space wait time 21 0.0 0.0 redo ordering marks 100,129 13.8 0.6 redo size 1,774,929,808 245,392.3 10,042.7 redo subscn max counts 76,171 10.5 0.4 redo synch time 1,064 0.2 0.0 Instance Activity Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- redo synch writes 183 0.0 0.0 redo wastage 15,153,352 2,095.0 85.7 redo write time 20,717 2.9 0.1 redo writer latching time 258 0.0 0.0 redo writes 104,844 14.5 0.6 rollback changes - undo records 476 0.1 0.0 rollbacks only - consistent read 587 0.1 0.0 rows fetched via callback 2,383,174 329.5 13.5 session connect time 0 0.0 0.0 session cursor cache hits 171,738 23.7 1.0 session logical reads 65,681,712 9,080.8 371.6 session pga memory 936,843,864 129,523.0 5,300.7 session pga memory max 2,705,660,504 374,070.2 15,308.8 session uga memory 10,941,568 1,512.7 61.9 session uga memory max 140,321,248 19,400.1 794.0 shared hash latch upgrades - no 1,060,394 146.6 6.0 shared hash latch upgrades - wai 2 0.0 0.0 sorts (memory) 87,203 12.1 0.5 sorts (rows) 4,648,584 642.7 26.3 sql area evicted 542 0.1 0.0 sql area purged 3,373 0.5 0.0 summed dirty queue length 574 0.1 0.0 switch current to new buffer 7,203 1.0 0.0 table fetch by rowid 8,309,440 1,148.8 47.0 table fetch continued row 40,454 5.6 0.2 table scan blocks gotten 32,850,699 4,541.8 185.9 table scan rows gotten 1,111,891,026 153,724.1 6,291.2 table scans (long tables) 0 0.0 0.0 table scans (short tables) 38,279 5.3 0.2 total number of times SMON poste 460 0.1 0.0 transaction lock background gets 0 0.0 0.0 transaction lock foreground requ 0 0.0 0.0 transaction lock foreground wait 0 0.0 0.0 transaction rollbacks 119 0.0 0.0 transaction tables consistent re 0 0.0 0.0 transaction tables consistent re 0 0.0 0.0 undo change vector size 736,929,600 101,884.0 4,169.6 user I/O wait time 31,630 4.4 0.2 user calls 263,602 36.4 1.5 user commits 169,407 23.4 1.0 user rollbacks 7,332 1.0 0.0 workarea executions - optimal 106,610 14.7 0.6 write clones created in backgrou 206 0.0 0.0 write clones created in foregrou 32 0.0 0.0 ------------------------------------------------------------- Instance Activity Stats - Absolute ValuesDB/Inst: UDAS2PDB/udas2p2 Snaps: 10 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- session cursor cache count 101,471 102,036 opened cursors current 439 421 workarea memory allocated 1,233 1,233 logons current 59 56 ------------------------------------------------------------- Instance Activity Stats - Thread ActivityDB/Inst: UDAS2PDB/udas2p2 Snaps: 105 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 1 .50 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by IOs (Reads + Writes) desc Tablespace ------------------------------ Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ UDAS_DAT 25,861 4 6.6 1.0 88,256 12 1,374 0.9 UDAS_IDX 19,801 3 3.9 1.0 23,634 3 872 0.8 CODIE_TRANS_DAT 3,864 1 13.5 1.0 21,922 3 1,336 0.9 UNDOTBS2 0 0 0.0 .0 7,425 1 282 0.2 VSDA_DAT 3,294 0 2.6 1.0 556 0 0 0.0 SYSAUX 1,138 0 6.0 1.0 2,266 0 531 0.5 TOOLS 352 0 1.6 1.0 472 0 0 0.0 SYSTEM 8 0 12.5 1.0 449 0 2 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg5/datafile/codie_trans_dat.326.74 780 0 14.2 1.0 4,485 1 1 0.0 CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg5/datafile/codie_trans_dat.329.74 664 0 13.0 1.0 3,661 1 180 0.6 CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg5/datafile/codie_trans_dat.330.74 907 0 13.0 1.0 4,770 1 1,149 1.0 CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg5/datafile/codie_trans_dat.332.74 780 0 13.2 1.0 4,208 1 0 0.0 CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg5/datafile/codie_trans_dat.375.74 733 0 13.9 1.0 4,798 1 6 1.7 SYSAUX +DBGRP1/udas2pdb_dg5/datafile/sysaux.325.742841519 1,138 0 6.0 1.0 2,266 0 531 0.5 SYSTEM +DBGRP1/udas2pdb_dg5/datafile/system.338.742842779 8 0 12.5 1.0 449 0 2 0.0 TOOLS +DBGRP1/udas2pdb_dg5/datafile/tools.337.742842629 110 0 1.6 1.0 170 0 0 0.0 TOOLS +DBGRP1/udas2pdb_dg5/datafile/tools.339.742842785 242 0 1.6 1.0 302 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.260.742833181 195 0 8.1 1.0 609 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.261.742833183 216 0 8.2 1.0 610 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.262.742833183 207 0 6.9 1.0 723 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.263.742833185 225 0 8.0 1.0 857 0 30 1.3 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.264.742833187 237 0 6.6 1.0 851 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.265.742833187 285 0 7.9 1.0 1,098 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.266.742833189 329 0 7.1 1.0 927 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.267.742833189 306 0 7.3 1.0 897 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.268.742833191 376 0 7.1 1.0 994 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.269.742833191 399 0 6.9 1.0 1,033 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.270.742833193 340 0 7.3 1.0 923 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.271.742833193 522 0 5.9 1.0 1,014 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.285.742835615 609 0 4.1 1.0 931 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.289.742835633 690 0 4.2 1.0 999 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.290.742836759 465 0 6.2 1.0 1,310 0 5 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.291.742836795 413 0 6.1 1.0 1,519 0 28 1.8 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.292.742836823 403 0 6.2 1.0 1,352 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.293.742836847 556 0 6.1 1.0 1,631 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.294.742836897 314 0 6.2 1.0 1,301 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.295.742836925 349 0 7.3 1.0 1,725 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.296.742836969 275 0 8.8 1.0 1,452 0 0 0.0 File IO Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.297.742836973 253 0 7.5 1.0 1,145 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.298.742837007 363 0 7.4 1.0 1,555 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.299.742837009 302 0 8.1 1.0 1,422 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.300.742837041 278 0 8.2 1.0 1,450 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.301.742837057 280 0 8.0 1.0 1,418 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.302.742837951 295 0 7.4 1.0 1,356 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.303.742838167 289 0 8.0 1.0 1,445 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.304.742838309 321 0 7.0 1.0 1,399 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.305.742839417 275 0 8.3 1.0 1,356 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.306.742839425 113 0 7.2 1.0 782 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.307.742839463 118 0 7.7 1.0 865 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.308.742839477 154 0 9.2 1.0 1,006 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.309.742839529 164 0 7.5 1.0 895 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.310.742839533 659 0 4.2 1.0 1,691 0 53 1.7 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.311.742839549 105 0 8.1 1.0 896 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.312.742839569 112 0 8.2 1.0 871 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.313.742839593 452 0 4.5 1.0 1,333 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.314.742839617 112 0 8.7 1.0 854 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.315.742839635 105 0 9.4 1.0 865 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.316.742839683 349 0 6.6 1.0 1,535 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.317.742839955 0 0 N/A N/A 472 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.320.742841203 103 0 5.5 1.0 1,408 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.321.742841271 0 0 N/A N/A 434 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.341.742843041 241 0 8.5 1.0 643 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.342.742843043 230 0 7.2 1.0 679 0 28 0.4 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.343.742843045 225 0 8.1 1.0 1,053 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.344.742843047 326 0 8.1 1.0 1,078 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.345.742843049 306 0 6.6 1.0 918 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.346.742843051 376 0 7.2 1.0 912 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.356.742846635 561 0 4.9 1.0 1,707 0 0 0.0 File IO Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.357.742846661 428 0 5.7 1.0 1,501 0 4 5.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.358.742846717 375 0 6.5 1.0 1,526 0 5 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.359.742846787 265 0 6.8 1.0 1,359 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.360.742846829 294 0 7.2 1.0 1,490 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.361.742846863 757 0 5.8 1.0 2,152 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.362.742846897 274 0 8.7 1.0 1,472 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.363.742847963 308 0 6.5 1.0 1,437 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.364.742849369 344 0 8.9 1.0 1,450 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.365.742849391 167 0 8.1 1.0 923 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.366.742849411 96 0 8.9 1.0 867 0 1 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.367.742849463 115 0 8.6 1.0 910 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.368.742849521 116 0 9.5 1.0 1,006 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.369.742849531 109 0 8.5 1.0 1,003 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.370.742849551 5 0 2.0 1.0 1,330 0 4 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.400.743346603 1 0 10.0 1.0 491 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.401.743346623 0 0 N/A N/A 481 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.402.743346645 1 0 10.0 1.0 441 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.403.743346669 0 0 N/A N/A 463 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.404.743346691 412 0 5.6 1.0 1,321 0 845 0.8 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.405.743519269 2 0 10.0 1.0 456 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.406.743519317 1 0 10.0 1.0 471 0 3 3.3 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.407.743519363 1 0 10.0 1.0 452 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.408.743519411 0 0 N/A N/A 576 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.409.743519461 296 0 6.5 1.0 3,054 0 368 0.8 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.410.743519503 0 0 N/A N/A 390 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.416.743519767 383 0 4.3 1.0 105 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.417.743519813 83 0 5.8 1.0 50 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.418.743519865 139 0 8.0 1.0 180 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.419.743519915 158 0 7.5 1.0 189 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.420.743519973 138 0 9.3 1.0 126 0 0 0.0 File IO Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.421.743520021 97 0 8.1 1.0 93 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.422.743520063 113 0 9.6 1.0 129 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.423.743520111 232 0 6.0 1.0 191 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.424.743520157 132 0 7.7 1.0 144 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.425.743520203 240 0 6.3 1.0 207 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.426.743520255 112 0 7.0 1.0 91 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.427.743520307 207 0 6.5 1.0 169 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.428.743520355 247 0 6.2 1.0 194 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.429.743520401 169 0 5.8 1.0 144 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.430.743520443 142 0 6.5 1.0 129 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.431.743520475 284 0 5.8 1.0 238 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.432.743520503 112 0 7.1 1.0 108 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.433.743520531 236 0 4.9 1.0 171 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.434.743520557 141 0 7.8 1.0 135 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.435.743520585 131 0 6.3 1.0 114 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.436.743520609 281 0 6.2 1.0 194 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.437.743520633 53 0 8.3 1.0 62 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.438.743520655 355 0 5.3 1.0 260 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.439.743520677 144 0 6.5 1.0 123 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.440.743520699 373 0 5.7 1.0 281 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.441.743520721 69 0 6.4 1.0 72 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.442.743520747 385 0 5.4 1.0 211 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.443.743520785 170 0 5.2 1.0 123 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.444.743520825 266 0 5.9 1.0 206 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.445.743520855 44 0 8.2 1.0 35 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.446.743520879 167 0 5.2 1.0 128 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.448.743520935 178 0 5.5 1.0 167 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.449.743520955 35 0 6.9 1.0 30 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.450.743520977 25 0 7.2 1.0 33 0 0 0.0 UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.451.743520999 151 0 5.0 1.0 111 0 0 0.0 File IO Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ UDAS_DAT +DBGRP1/udas2pdb_dg5/datafile/udas_dat.453.743521041 124 0 5.0 1.0 92 0 0 0.0 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.328.742841659 1,796 0 3.9 1.0 2,236 0 127 0.8 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.331.742841729 1,050 0 3.9 1.0 2,210 0 41 1.0 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.333.742842281 2,776 0 4.0 1.0 2,628 0 29 0.7 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.334.742842379 2,827 0 3.9 1.0 2,505 0 42 0.5 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.335.742842397 1,222 0 4.0 1.0 1,963 0 212 1.5 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.336.742842567 998 0 3.9 1.0 1,926 0 115 0.3 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.376.742851481 1,426 0 4.1 1.0 2,048 0 21 1.0 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.377.742851823 1,123 0 3.8 1.0 1,884 0 99 0.5 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.378.742852125 974 0 3.7 1.0 1,756 0 185 0.5 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.455.743521083 1,067 0 3.7 1.0 1,164 0 1 0.0 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.456.743521105 2,617 0 4.1 1.0 1,744 0 0 0.0 UDAS_IDX +DBGRP1/udas2pdb_dg5/datafile/udas_idx.457.743521127 1,925 0 3.6 1.0 1,570 0 0 0.0 UNDOTBS2 +DBGRP1/udas2pdb_dg5/datafile/undotbs2.258.742833169 0 0 N/A N/A 1,058 0 261 0.2 UNDOTBS2 +DBGRP1/udas2pdb_dg5/datafile/undotbs2.319.742840833 0 0 N/A N/A 1,841 0 10 0.0 UNDOTBS2 +DBGRP1/udas2pdb_dg5/datafile/undotbs2.324.742841509 0 0 N/A N/A 1,262 0 7 0.0 UNDOTBS2 +DBGRP1/udas2pdb_dg5/datafile/undotbs2.372.742850913 0 0 N/A N/A 949 0 0 0.0 UNDOTBS2 +DBGRP1/udas2pdb_dg5/datafile/undotbs2.465.745749045 0 0 N/A N/A 1,394 0 1 0.0 UNDOTBS2 +DBGRP1/udas2pdb_dg5/datafile/undotbs2.466.745749073 0 0 N/A N/A 921 0 3 3.3 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.272.742833197 91 0 2.6 1.0 11 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.273.742833197 27 0 3.0 1.0 21 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.274.742834283 100 0 2.3 1.0 11 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.275.742834297 101 0 1.6 1.0 10 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.276.742835439 94 0 2.2 1.0 10 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.277.742835473 84 0 3.5 1.0 13 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.278.742835591 190 0 2.7 1.0 23 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.279.742835599 215 0 2.7 1.0 25 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.280.742835601 179 0 2.5 1.0 38 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.281.742835605 173 0 3.0 1.0 33 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.282.742835611 107 0 2.6 1.0 16 0 0 0.0 File IO Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.283.742835611 190 0 2.2 1.0 44 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.284.742835615 161 0 2.7 1.0 23 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.286.742835619 197 0 2.6 1.0 28 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.287.742835625 155 0 2.8 1.0 30 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.288.742835629 56 0 2.1 1.0 12 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.347.742843053 108 0 1.8 1.0 21 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.348.742844157 76 0 3.3 1.0 24 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.349.742845345 86 0 2.3 1.0 11 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.350.742845415 90 0 3.2 1.0 25 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.351.742845421 145 0 2.2 1.0 26 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.352.742845423 223 0 2.9 1.0 25 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.353.742845427 176 0 2.6 1.0 20 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.354.742845431 145 0 3.1 1.0 41 0 0 0.0 VSDA_DAT +DBGRP1/udas2pdb_dg5/datafile/vsda_dat.355.742845437 125 0 2.9 1.0 15 0 0 0.0 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Standard block size Pools D: default, K: keep, R: recycle -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k Free Writ Buffer Number of Pool Buffer Physical Physical Buff Comp Busy P Buffers Hit% Gets Reads Writes Wait Wait Waits --- ---------- ---- -------------- ------------ ----------- ---- ---- ---------- D 447,009 100 65,677,146 54,250 318,246 0 0 4,400 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> B: Begin snapshot, E: End snapshot Targt Estd Log File Log Ckpt Log Ckpt MTTR MTTR Recovery Actual Target Size Timeout Interval (s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks - ----- ----- ---------- --------- --------- ---------- --------- ------------ B 0 4 8201 69962 666948 3686400 666948 N/A E 0 3 5538 39425 563891 3686400 563891 N/A ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: UDAS2PDB/udas2p2 Snap: 1055 -> Only rows with estimated physical reads >0 are displayed -> ordered by Block Size, Buffers For Estimate Est Phys Size for Size Buffers for Read Estimated P Est (M) Factor Estimate Factor Physical Reads --- -------- ------ ---------------- ------ ------------------ D 368 .1 44,137 2.7 136,769,224 D 736 .2 88,274 2.4 119,344,648 D 1,104 .3 132,411 2.1 104,503,061 D 1,472 .4 176,548 1.8 91,993,453 D 1,840 .5 220,685 1.6 81,595,326 D 2,208 .6 264,822 1.4 73,006,021 D 2,576 .7 308,959 1.3 65,918,758 D 2,944 .8 353,096 1.2 60,060,655 D 3,312 .9 397,233 1.1 55,202,751 D 3,680 1.0 441,370 1.0 51,162,719 D 3,728 1.0 447,127 1.0 50,676,058 D 4,048 1.1 485,507 0.9 47,797,305 D 4,416 1.2 529,644 0.9 44,989,427 D 4,784 1.3 573,781 0.8 42,642,286 D 5,152 1.4 617,918 0.8 40,674,425 D 5,520 1.5 662,055 0.8 39,017,897 D 5,888 1.6 706,192 0.7 37,615,205 D 6,256 1.7 750,329 0.7 36,418,044 D 6,624 1.8 794,466 0.7 35,385,327 D 6,992 1.9 838,603 0.7 34,481,880 D 7,360 2.0 882,740 0.7 33,680,012 ------------------------------------------------------------- PGA Aggr Summary DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written --------------- ------------------ -------------------------- 100.0 14,772 0 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval) -> Auto PGA Target - actual workarea memory target -> W/A PGA Used - amount of memory used for all Workareas (manual + auto) -> %PGA W/A Mem - percentage of PGA memory allocated to workareas -> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt -> %Man W/A Mem - percentage of workarea memory under manual control %PGA %Auto %Man PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K) - ---------- ---------- ---------- ---------- ------ ------ ------ ---------- B 3,000 2,230 1,859.9 0.0 .0 .0 .0 307,200 E 3,000 2,236 2,063.2 0.0 .0 .0 .0 307,200 ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 89,040 89,040 0 0 64K 128K 14 14 0 0 512K 1024K 14,003 14,003 0 0 1M 2M 3,559 3,559 0 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: UDAS2PDB/udas2p2 Snap: 1055 -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0 Estd Extra Estd PGA Estd PGA PGA Target Size W/A MB W/A MB Read/ Cache Overalloc Est (MB) Factr Processed Written to Disk Hit % Count ---------- ------- ---------------- ---------------- -------- ---------- 375 0.1 6,828,799.2 422,832.3 94.0 47,294 750 0.3 6,828,799.2 4,608.4 100.0 499 1,500 0.5 6,828,799.2 0.0 100.0 0 2,250 0.8 6,828,799.2 0.0 100.0 0 3,000 1.0 6,828,799.2 0.0 100.0 0 3,600 1.2 6,828,799.2 0.0 100.0 0 4,200 1.4 6,828,799.2 0.0 100.0 0 4,800 1.6 6,828,799.2 0.0 100.0 0 5,400 1.8 6,828,799.2 0.0 100.0 0 6,000 2.0 6,828,799.2 0.0 100.0 0 9,000 3.0 6,828,799.2 0.0 100.0 0 12,000 4.0 6,828,799.2 0.0 100.0 0 18,000 6.0 6,828,799.2 0.0 100.0 0 24,000 8.0 6,828,799.2 0.0 100.0 0 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: UDAS2PDB/udas2p2 Snap: 1055 -> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor -> Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid. Est LC Est LC Est LC Est LC Shared SP Est LC Time Time Load Load Est LC Pool Size Size Est LC Saved Saved Time Time Mem Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits ---------- ----- -------- ------------ ------- ------ ------- ------ ----------- 1,600 .4 499 18,216 ####### 1.0 ####### 3.0 ########### 2,016 .5 907 24,959 ####### 1.0 ####### 2.5 ########### 2,432 .6 1,319 30,511 ####### 1.0 ####### 2.1 ########### 2,848 .7 1,732 39,433 ####### 1.0 ####### 1.7 ########### 3,264 .8 2,146 46,479 ####### 1.0 ####### 1.4 ########### 3,680 .9 2,561 53,113 ####### 1.0 ####### 1.2 ########### 4,096 1.0 2,976 60,477 ####### 1.0 ####### 1.0 ########### 4,512 1.1 3,390 68,369 ####### 1.0 ####### .8 ########### 4,928 1.2 3,805 77,010 ####### 1.0 ####### .7 ########### 5,344 1.3 4,220 84,600 ####### 1.0 ####### .6 ########### 5,760 1.4 4,635 93,594 ####### 1.0 ####### .5 ########### 6,176 1.5 5,050 100,566 ####### 1.0 ####### .4 ########### 6,592 1.6 5,465 107,339 ####### 1.0 ####### .3 ########### 7,008 1.7 5,880 114,414 ####### 1.0 75,445 .3 ########### 7,424 1.8 6,294 122,867 ####### 1.0 50,530 .2 ########### 7,840 1.9 6,709 128,848 ####### 1.0 25,641 .1 ########### 8,256 2.0 7,124 135,290 ####### 1.0 767 .0 ########### ------------------------------------------------------------- SGA Target Advisory DB/Inst: UDAS2PDB/udas2p2 Snap: 1055 SGA Target SGA Size Est DB Est Physical Size (M) Factor Time (s) Reads ---------- ---------- ------------ ---------------- 2,000 0.3 3,175,917 94,936,473 4,000 0.5 2,660,123 72,537,668 6,000 0.8 2,352,571 63,856,864 8,000 1.0 2,187,421 50,676,029 10,000 1.3 2,055,957 50,676,029 12,000 1.5 1,957,534 35,174,232 14,000 1.8 1,914,879 26,108,290 16,000 2.0 1,901,973 23,376,852 ------------------------------------------------------------- Streams Pool Advisory DB/Inst: UDAS2PDB/udas2p2 Snap: 1055 No data exists for this section of the report. ------------------------------------------------------------- Java Pool Advisory DB/Inst: UDAS2PDB/udas2p2 Snap: 1055 No data exists for this section of the report. ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by wait time desc, waits desc Class Waits Total Wait Time (s) Avg Time (ms) ------------------ ----------- ------------------- -------------- data block 4,099 3 1 undo header 261 0 0 2nd level bmb 1 0 40 undo block 21 0 0 1st level bmb 14 0 1 segment header 1 0 0 ------------------------------------------------------------- Enqueue Activity DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> only enqueues with waits are shown -> Enqueue stats gathered prior to 10g should not be compared with 10g data -> ordered by Wait Time desc, Waits desc Enqueue Type (Request Reason) ------------------------------------------------------------------------------ Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms) ------------ ------------ ----------- ----------- ------------ -------------- WL-Being Written Redo Log 9,258 11 9,247 6,027 16 2.63 XR-Quiesce / Force Logging (database force logging) 2,403 2,403 0 2,403 4 1.65 TX-Transaction (index contention) 327 324 0 320 4 11.21 WF-AWR Flush 39 39 0 24 2 85.08 FB-Format Block 949 949 0 636 2 2.75 PS-PX Process Reservation 1,879 1,843 36 1,022 2 1.64 CF-Controlfile Transaction 23,057 23,053 4 602 2 2.60 RO-Multiple Object Reuse (fast object reuse) 603 603 0 176 1 3.65 TM-DML 537,131 537,111 22 64 0 4.80 HW-Segment High Water Mark 2,332 2,332 0 190 0 1.45 TT-Tablespace 1,007 1,007 0 130 0 1.98 TS-Temporary Segment 42 42 0 14 0 4.57 MN-LogMiner 1,825 1,825 0 24 0 2.33 TA-Instance Undo 47 47 0 45 0 1.18 TO-Temp Object 143 143 0 23 0 1.48 US-Undo Segment 44 44 0 14 0 2.00 TD-KTF map table enqueue (KTF dump entries) 24 24 0 24 0 1.04 IR-Instance Recovery 362 362 0 21 0 .57 TX-Transaction 317,658 317,841 0 5 0 2.40 PI-Remote PX Process Spawn Status 23 23 0 12 0 .83 MW-MWIN Schedule 4 4 0 4 0 1.25 DR-Distributed Recovery 4 4 0 4 0 .50 RS-Reclaimable Space (file delete) 2 2 0 2 0 1.00 DD-ASM Local Disk Group 70,025 70,025 0 9 0 .11 AF-Advisor Framework (task serialization) 14 14 0 1 0 1.00 ------------------------------------------------------------- Undo Segment Summary DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Min/Max TR (mins) - Min and Max Tuned Retention (minutes) -> STO - Snapshot Too Old count, OOS - Out of Space count -> Undo segment block stats: -> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed -> eS - expired Stolen, eR - expired Released, eU - expired reUsed Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/ TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU ---- ---------- --------------- -------- -------- --------- ----- -------------- 5 100.6 324,643 173 12 60/60 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Most recent 35 Undostat rows, ordered by Time desc Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/ End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU ------------ ----------- ------------ ------- ------- ------- ----- ------------ 04-Apr 20:00 2,377 3,311 0 9 60 0/0 0/0/0/0/0/0 04-Apr 19:50 3,697 27,038 17 10 60 0/0 0/0/0/0/0/0 04-Apr 19:40 6,717 117,602 106 9 60 0/0 0/0/0/0/0/0 04-Apr 19:30 2,505 5,513 0 11 60 0/0 0/0/0/0/0/0 04-Apr 19:20 3,355 4,046 0 9 60 0/0 0/0/0/0/0/0 04-Apr 19:10 3,466 3,379 135 12 60 0/0 0/0/0/0/0/0 04-Apr 19:00 5,272 3,475 0 10 60 0/0 0/0/0/0/0/0 04-Apr 18:50 3,456 3,115 0 9 60 0/0 0/0/0/0/0/0 04-Apr 18:40 8,553 141,985 0 7 60 0/0 0/0/0/0/0/0 04-Apr 18:30 10,922 3,655 0 10 60 0/0 0/0/0/0/0/0 04-Apr 18:20 24,487 3,720 132 8 60 0/0 0/0/0/0/0/0 04-Apr 18:10 22,529 3,712 173 8 60 0/0 0/0/0/0/0/0 04-Apr 18:00 3,242 4,092 0 11 60 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Latch Activity DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ ASM allocation 140,056 0.0 0.0 0 0 N/A ASM db client latch 352,919 0.0 N/A 0 0 N/A ASM map headers 144,053 0.0 0.0 0 0 N/A ASM map load waiting lis 41,162 0.0 N/A 0 0 N/A ASM map operation freeli 92 0.0 N/A 0 0 N/A ASM map operation hash t 69,148,927 0.0 0.0 0 0 N/A ASM network background l 202,103 0.0 0.0 0 0 N/A AWR Alerted Metric Eleme 45,632 0.0 N/A 0 0 N/A Consistent RBA 104,825 0.0 0.0 0 0 N/A FAL request queue 222 0.0 N/A 0 0 N/A FAL subheap alocation 222 0.0 N/A 0 0 N/A FIB s.o chain latch 41,146 0.0 0.3 0 0 N/A FOB s.o list latch 42,682 0.0 N/A 0 0 N/A KCL gc element parent la 656,967 0.0 0.1 0 159 0.0 KFK SGA context latch 3,640 0.0 N/A 0 0 N/A KFMD SGA 53 0.0 N/A 0 0 N/A KJC message pool free li 384,912 0.0 0.0 0 15,781 0.0 KJCT flow control latch 1,922,288 0.0 0.0 0 0 N/A KMG MMAN ready and start 2,410 0.0 N/A 0 0 N/A KSXR large replies 3 0.0 N/A 0 0 N/A KTF sga latch 48 0.0 N/A 0 2,051 0.0 KWQMN job cache list lat 540 0.0 N/A 0 0 N/A MQL Tracking Latch 0 N/A N/A 0 144 0.0 Managed Standby Recovery 2 0.0 N/A 0 0 N/A Memory Management Latch 0 N/A N/A 0 2,410 0.0 OS process 162 0.0 N/A 0 0 N/A OS process allocation 2,516 0.0 N/A 0 0 N/A OS process: request allo 58 0.0 N/A 0 0 N/A PL/SQL warning settings 5,542 0.0 N/A 0 0 N/A Real time apply boundary 109,590 0.0 N/A 0 0 N/A Reserved Space Latch 7 0.0 N/A 0 0 N/A SGA IO buffer pool latch 20,033 0.0 N/A 0 20,070 0.0 SGA kcrrlatmscnl latch 30,003 0.0 0.0 0 0 N/A SGA kcrrssncpl latch 168 0.0 N/A 0 0 N/A SQL memory manager latch 2 0.0 N/A 0 2,403 0.0 SQL memory manager worka 194,885 0.0 N/A 0 0 N/A Shared B-Tree 255 0.0 N/A 0 0 N/A active checkpoint queue 153,350 0.2 0.0 0 0 N/A active service list 5,151 0.0 N/A 0 2,455 0.0 alert log latch 4 0.0 N/A 0 0 N/A archive control 495 0.0 N/A 0 0 N/A archive process latch 2,859 0.1 0.0 0 0 N/A begin backup scn array 6 0.0 N/A 0 0 N/A business card 334 0.0 N/A 0 0 N/A cache buffer handles 79,538 0.0 0.0 0 0 N/A cache buffers chains 147,666,903 0.2 0.0 0 145,271 0.0 cache buffers lru chain 679,491 0.0 0.0 0 196,067 0.0 channel handle pool latc 932 0.0 N/A 0 0 N/A channel operations paren 9,113,142 0.0 0.0 0 0 N/A checkpoint queue latch 1,708,931 0.0 0.0 0 314,590 0.0 client/application info 1,624 0.0 N/A 0 0 N/A commit callback allocati 376 0.0 N/A 0 0 N/A compile environment latc 397 0.0 N/A 0 0 N/A dictionary lookup 84 0.0 N/A 0 0 N/A dml lock allocation 1,074,693 0.2 0.0 0 0 N/A dummy allocation 797 0.0 N/A 0 0 N/A enqueue hash chains 3,302,074 0.1 0.0 0 5,177 0.0 enqueues 197,209 0.0 0.0 0 0 N/A error message lists 1,134 0.0 N/A 0 0 N/A event group latch 28 0.0 N/A 0 0 N/A Latch Activity DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ file cache latch 10,287 0.0 N/A 0 0 N/A gcs opaque info freelist 17,398 0.0 N/A 0 0 N/A gcs partitioned table ha 437,994 0.0 N/A 0 0 N/A gcs remaster request que 63 0.0 N/A 0 0 N/A gcs remastering latch 7,281 0.0 N/A 0 0 N/A gcs resource freelist 21,156 0.0 0.0 0 101 0.0 gcs resource hash 646,728 0.0 0.0 0 0 N/A gcs shadows freelist 8,396 0.0 N/A 0 7,092 0.0 ges caches resource list 665,406 0.0 0.0 0 91,276 0.0 ges deadlock list 2,304 0.0 N/A 0 4 0.0 ges domain table 1,210,048 0.0 0.0 0 0 N/A ges enqueue table freeli 1,743,641 0.0 0.0 0 0 N/A ges group table 1,797,375 0.0 0.0 0 0 N/A ges process hash list 5,988 0.0 N/A 0 0 N/A ges process parent latch 4,289,469 0.0 N/A 0 0 N/A ges process table freeli 58 0.0 N/A 0 0 N/A ges resource hash list 3,236,277 1.4 0.5 2 34,352 0.1 ges resource scan list 51,878 0.0 N/A 0 0 N/A ges resource table freel 12,310 0.0 0.0 0 0 N/A ges timeout list 2,194 0.0 N/A 0 2,029 0.0 global KZLD latch for me 16 0.0 N/A 0 0 N/A hash table column usage 240 0.0 N/A 0 13,263,580 0.0 hash table modification 179 0.0 N/A 0 0 N/A kks stats 5,667 0.0 N/A 0 0 N/A kokc descriptor allocati 4 0.0 N/A 0 0 N/A ksuosstats global area 486 0.0 N/A 0 0 N/A ktm global data 1,986 0.0 N/A 0 0 N/A kwqbsn:qsga 255 0.0 N/A 0 0 N/A lgwr LWN SCN 104,835 0.0 0.0 0 0 N/A library cache 17,737,208 0.0 0.0 0 1,479 0.0 library cache load lock 364 0.0 N/A 0 0 N/A library cache lock 3,902,324 0.0 0.0 0 0 N/A library cache lock alloc 787 0.0 N/A 0 0 N/A library cache pin 12,175,469 0.0 0.0 0 0 N/A library cache pin alloca 7,507 0.0 N/A 0 0 N/A list of block allocation 24,655 0.0 N/A 0 0 N/A loader state object free 296 0.0 N/A 0 0 N/A logical standby cache 62 0.0 N/A 0 0 N/A logminer context allocat 2,533 0.1 0.0 0 0 N/A logminer work area 14,940,608 2.7 0.0 5 0 N/A managed standby latch 1,520 0.4 0.0 0 0 N/A message pool operations 4,655 0.0 N/A 0 0 N/A messages 6,046,368 0.4 0.0 0 0 N/A mostly latch-free SCN 105,008 0.2 0.0 0 0 N/A msg queue 4,153 0.0 0.0 0 4,152 0.0 multiblock read objects 466 0.0 N/A 0 0 N/A name-service memory obje 42,650 0.0 N/A 0 0 N/A name-service namespace b 101,087 0.0 N/A 0 0 N/A name-service pending que 5,488 0.0 N/A 0 0 N/A name-service request 36 0.0 N/A 0 0 N/A name-service request que 87,763 0.0 N/A 0 0 N/A ncodef allocation latch 117 0.0 N/A 0 0 N/A object queue header heap 1,605 0.0 N/A 0 1,297 0.0 object queue header oper 1,291,568 0.0 0.0 0 0 N/A object stats modificatio 654 0.0 N/A 0 0 N/A parallel query alloc buf 6,864 0.0 N/A 0 0 N/A parallel query stats 860 0.0 N/A 0 0 N/A parallel txn reco latch 9,494 0.0 N/A 0 0 N/A parameter list 321 0.0 N/A 0 0 N/A parameter table allocati 1,798 0.0 N/A 0 0 N/A Latch Activity DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ post/wait queue 368 0.0 N/A 0 290 0.0 process allocation 77,872 0.0 N/A 0 28 0.0 process group creation 58 0.0 N/A 0 0 N/A process queue 2,921 0.0 N/A 0 0 N/A process queue reference 110,898 0.0 0.0 0 32,009 6.1 qmn task queue latch 1,044 0.0 N/A 0 0 N/A query server freelists 2,230 0.0 N/A 0 0 N/A query server process 6 0.0 N/A 0 6 0.0 queued dump request 36,014 0.0 N/A 0 0 N/A redo allocation 321,413 0.2 0.0 0 5,708,115 0.1 redo copy 0 N/A N/A 0 5,709,349 0.2 redo writing 478,765 0.1 0.0 0 0 N/A reservation so alloc lat 4 0.0 N/A 0 0 N/A resmgr group change latc 712 0.0 N/A 0 0 N/A resmgr:active threads 786 0.0 N/A 0 0 N/A resmgr:actses change gro 385 0.0 N/A 0 0 N/A resmgr:free threads list 784 0.0 N/A 0 0 N/A resmgr:schema config 2 0.0 N/A 0 0 N/A row cache objects 18,191,588 0.1 0.0 0 208 0.0 segmented array pool 41,146 0.0 N/A 0 0 N/A sequence cache 9,129,566 0.0 0.0 0 0 N/A session allocation 77,228 0.1 0.0 0 0 N/A session idle bit 538,294 0.0 0.0 0 0 N/A session state list latch 806 0.0 N/A 0 0 N/A session switching 117 0.0 N/A 0 0 N/A session timer 2,455 0.0 N/A 0 0 N/A shared pool 985,272 0.0 0.0 0 0 N/A shared pool simulator 4,809,661 0.0 0.0 0 0 N/A simulator hash latch 3,622,230 0.0 0.0 0 0 N/A simulator lru latch 0 N/A N/A 0 3,607,916 0.3 slave class 12,511 0.0 0.0 0 0 N/A slave class create 8,337 0.1 0.6 0 0 N/A sort extent pool 3,940 0.0 N/A 0 0 N/A state object free list 4 0.0 N/A 0 0 N/A statistics aggregation 1,680 0.0 N/A 0 0 N/A threshold alerts latch 669 0.0 N/A 0 0 N/A transaction allocation 1,770 0.0 N/A 0 0 N/A transaction branch alloc 2,455 0.0 N/A 0 0 N/A undo global data 1,046,675 0.0 0.0 0 0 N/A user lock 66 0.0 N/A 0 0 N/A ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by misses desc Latch Name ---------------------------------------- Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3 -------------- ----------- ----------- ---------- -------- -------- -------- logminer work area 14,940,608 403,624 2,321 401,491 0 0 0 cache buffers chains 147,666,903 238,500 128 238,378 0 0 0 ges resource hash list 3,236,277 43,821 23,223 20,606 0 0 0 messages 6,046,368 24,299 106 24,194 0 0 0 row cache objects 18,191,588 11,853 3 11,850 0 0 0 library cache 17,737,208 6,207 5 6,202 0 0 0 enqueue hash chains 3,302,074 3,296 12 3,284 0 0 0 dml lock allocation 1,074,693 2,671 18 2,654 0 0 0 ASM map operation hash table 69,148,927 2,233 2 2,231 0 0 0 redo allocation 321,413 507 13 495 0 0 0 shared pool 985,272 423 6 417 0 0 0 object queue header operation 1,291,568 359 9 351 0 0 0 active checkpoint queue latch 153,350 303 2 301 0 0 0 redo writing 478,765 259 1 258 0 0 0 cache buffers lru chain 679,491 184 8 176 0 0 0 mostly latch-free SCN 105,008 162 2 160 0 0 0 shared pool simulator 4,809,661 148 1 147 0 0 0 KCL gc element parent latch 656,967 119 16 103 0 0 0 checkpoint queue latch 1,708,931 105 2 103 0 0 0 ges caches resource lists 665,406 90 2 88 0 0 0 channel operations parent latch 9,113,142 75 1 74 0 0 0 KJCT flow control latch 1,922,288 57 1 56 0 0 0 slave class create 8,337 8 5 3 0 0 0 FIB s.o chain latch 41,146 3 1 2 0 0 0 ------------------------------------------------------------- Latch Miss Sources DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- ASM map operation hash t kffmTranslate 0 1 1 ASM map operation hash t kffmUnidentify 0 1 0 FIB s.o chain latch ksfd_allfib 0 1 0 KCL gc element parent la kclrwrite 0 14 7 KCL gc element parent la kclnfndnewm 0 2 0 KJCT flow control latch kjcts_sqenq: queue a messa 0 1 0 active checkpoint queue kcbbacq: scan active check 0 2 2 cache buffers chains kcbgtcr: kslbegin excl 0 226 199 cache buffers chains kcbgcur: kslbegin 0 24 35 cache buffers chains kcbrls: kslbegin 0 15 46 cache buffers chains kcbgtcr: fast path 0 10 0 cache buffers chains kcbget: exchange rls 0 7 0 cache buffers chains kcbget: pin buffer 0 6 7 cache buffers chains kcbbxsv 0 5 5 cache buffers chains kcbchg: kslbegin: bufs not 0 5 3 cache buffers chains kcbnlc 0 5 0 cache buffers chains kcbget: exchange 0 2 0 cache buffers lru chain kcbkflb : age buffer out 0 4 0 cache buffers lru chain kcbbxsv: move to being wri 0 2 1 cache buffers lru chain kcbzgws 0 2 0 channel operations paren ksrwait() 0 1 1 checkpoint queue latch kcbkubc 0 2 0 dml lock allocation ktaiam 0 9 18 dml lock allocation ktaidm 0 9 0 enqueue hash chains ksqcmi: if lk mode not req 0 9 0 enqueue hash chains ksqcmi: if lk mode request 0 1 0 enqueue hash chains ksqgtl3 0 1 11 enqueue hash chains ksqrcl 0 1 1 ges resource hash list kjakcai: search for resp b 0 8,453 15 ges resource hash list kjcvscn: remove from scan 0 6,250 0 ges resource hash list kjlmfnd: search for lockp 0 4,753 5 ges resource hash list kjrmas1: lookup master nod 0 3,702 0 ges resource hash list kjlrlr: remove lock from r 0 41 15,163 ges resource hash list kjucvl: lock convert reque 0 22 5,239 ges resource hash list kjrref: find matched resou 0 5 2,804 ges resource table freel kjrm2c: move resource to c 0 2 2 lgwr LWN SCN kcs023 0 1 0 library cache kglpndl: child: before pro 0 3 2 library cache kglhdgn: child: 0 1 2 library cache kglobpn: child: 0 1 0 logminer work area krvuarm 0 898 572 logminer work area krvxasr 0 574 437 logminer work area krvxbuild 0 290 619 logminer work area krvxrgr 0 228 151 logminer work area krvxprep 0 93 105 logminer work area krvxrarwq 0 58 2 logminer work area krvuftl 0 46 227 logminer work area krvxbgpr 0 44 88 logminer work area krvxbrta 0 24 11 logminer work area krvxpin 0 16 20 logminer work area krvxrptl 0 14 10 logminer work area krvxbtpp 0 13 1 logminer work area krvxunpin 0 10 16 logminer work area krvxrti 0 4 1 logminer work area krvxspdsu 0 4 0 logminer work area krvurlcrs 0 3 30 logminer work area krvtadc 0 1 3 logminer work area krvxgti 0 1 27 messages ksarcv 0 51 15 messages ksarcv: after wait 0 35 61 Latch Miss Sources DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- messages ksaamb: after wakeup 0 20 30 mostly latch-free SCN kcslcu3 0 1 2 object queue header oper kcbo_switch_q_bg 0 2 0 object queue header oper kcbw_link_q 0 2 0 object queue header oper kcbw_unlink_q_bg 0 2 0 object queue header oper kcbo_service_ockpt 0 1 0 object queue header oper kcbo_write_q 0 1 0 object queue header oper kcbw_unlink_q 0 1 0 redo allocation kcrfw_redo_gen: redo alloc 0 13 0 redo writing kcrfwcr 0 1 1 row cache objects kqrbgl 0 2 1 row cache objects kqreqd: reget 0 1 1 shared pool kghfre 0 5 4 shared pool kghalo 0 1 2 shared pool simulator kglsim_unpin_simhp 0 1 0 slave class create ksvcreate 0 2 0 slave class create ksvsubmit 0 2 1 slave class create ksvgetwork1 0 1 2 ------------------------------------------------------------- Parent Latch Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total Logical Reads: 65,681,712 -> Captured Segments account for 97.2% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- UDAS_CODIE UDAS_DAT MART_SERVICE TABLE 30,994,656 47.19 UDAS_CODIE UDAS_IDX EPG_FILE_EVENT_ASSOC INDEX 7,080,896 10.78 UDAS_CODIE UDAS_DAT SERVICE_AREA_MAP_CHA TABLE 3,555,344 5.41 UDAS_CODIE UDAS_DAT SERVICE_AREA_PRINCIP TABLE 2,275,184 3.46 UDAS_CODIE UDAS_DAT CHANNELS TABLE 2,254,880 3.43 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total Physical Reads: 54,246 -> Captured Segments account for 84.6% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- UDAS_CODIE UDAS_DAT PRN_ASSET_BILL_DEP_P INDEX 7,601 14.01 UDAS_CODIE UDAS_IDX EPG_EVENT_X2 INDEX 4,894 9.02 UDAS_CODIE UDAS_IDX EPG_FILE_EVENT_ASSOC INDEX 4,642 8.56 UDAS_CODIE UDAS_IDX EPG_EVENT_X3 INDEX 4,231 7.80 CODIE_TRAN CODIE_TRAN SYS_C0032134 INDEX 3,609 6.65 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- ** UNAVAIL ** UNAVAIL ** UNAVAILABLE ** AILABLE ** UNDEF 600 64.79 CODIE_TRAN CODIE_TRAN CODIE_START_TIME_IDX INDEX 141 15.23 UDAS_CODIE UDAS_DAT PK_BF_AUDIT_ID INDEX 73 7.88 UDAS_CODIE UDAS_IDX IX_STG_PURCHASE_DT INDEX 45 4.86 UDAS_CODIE UDAS_DAT IX_AUDIT_PURCHASE_DT INDEX 42 4.54 ------------------------------------------------------------- Segments by ITL Waits DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> % 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 SYSAUX WRH$_FILESTATXS_PK 95889_1031 INDEX 1 50.00 SYS SYSAUX WRH$_SERVICE_STAT_PK 95889_1031 INDEX 1 50.00 ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- CODIE_TRAN CODIE_TRAN CODIE_START_TIME_IDX INDEX 1,316 37.03 UDAS_CODIE UDAS_DAT PK_BF_AUDIT_ID INDEX 845 23.78 UDAS_CODIE UDAS_IDX IX_STG_PURCHASE_DT INDEX 633 17.81 UDAS_CODIE UDAS_DAT IX_AUDIT_PURCHASE_DT INDEX 371 10.44 UDAS_CODIE UDAS_IDX IX_PURCHASE_DT INDEX 118 3.32 ------------------------------------------------------------- Segments by Global Cache Buffer BusyDB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-105 -> % of Capture shows % of GC Buffer Busy for each top segment compared -> with GC Buffer Busy for all segments captured by the Snapshot GC Tablespace Subobject Obj. Buffer % of Owner Name Object Name Name Type Busy Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- UDAS_CODIE UDAS_DAT BF_MART_PRCH_HSTRY TABLE 8 100.00 ------------------------------------------------------------- Segments by CR Blocks Received DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total CR Blocks Received: 858 -> Captured Segments account for 66.3% of Total CR Tablespace Subobject Obj. Blocks Owner Name Object Name Name Type Received %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSAUX WRH$_SQL_BIND_METADA INDEX 117 13.64 SYS SYSTEM SMON_SCN_TIME TABLE 83 9.67 SYS SYSAUX WRH$_SQLTEXT_PK INDEX 69 8.04 SYS SYSTEM SMON_SCN_TIME_SCN_ID INDEX 48 5.59 SYS SYSAUX WRH$_SQL_PLAN_PK INDEX 48 5.59 ------------------------------------------------------------- Segments by Current Blocks ReceivedDB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Total Current Blocks Received: 4,791 -> Captured Segments account for 82.9% of Total Current Tablespace Subobject Obj. Blocks Owner Name Object Name Name Type Received %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- UDAS_CODIE UDAS_DAT EPG_EVENT TABLE 966 20.16 SYS SYSTEM OBJ$ TABLE 829 17.30 UDAS_CODIE UDAS_DAT IDX_SERVICE_AREA_BOU INDEX 594 12.40 UDAS_CODIE UDAS_DAT SERVICE_AREA_MAP_CHA TABLE 326 6.80 UDAS_CODIE UDAS_DAT EPG_EVENT_X6 INDEX 265 5.53 ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> "Pct Misses" should be very low (< 2% in most cases) -> "Final Usage" is the number of cache entries being used Get Pct Scan Pct Mod Final Cache Requests Miss Reqs Miss Reqs Usage ------------------------- ------------ ------ ------- ----- -------- ---------- dc_awr_control 127 1.6 0 N/A 2 1 dc_database_links 36 0.0 0 N/A 0 1 dc_files 185 0.0 0 N/A 0 185 dc_global_oids 12 0.0 0 N/A 0 18 dc_histogram_data 613,751 0.0 0 N/A 0 4,157 dc_histogram_defs 147,345 0.0 0 N/A 0 3,276 dc_object_ids 369,962 0.0 0 N/A 21 1,391 dc_objects 48,427 0.1 0 N/A 119 1,118 dc_profiles 32 0.0 0 N/A 0 2 dc_rollback_segments 15,452 0.0 0 N/A 0 204 dc_segments 142,222 0.0 0 N/A 297 1,595 dc_sequences 138,055 0.0 0 N/A 138,055 54 dc_tablespace_quotas 237 0.0 0 N/A 117 10 dc_tablespaces 2,120,298 0.0 0 N/A 0 12 dc_usernames 13,456 0.0 0 N/A 0 11 dc_users 2,274,470 0.0 0 N/A 0 36 outstanding_alerts 264 81.8 0 N/A 0 2 ------------------------------------------------------------- Dictionary Cache Stats (RAC) DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 GES GES GES Cache Requests Conflicts Releases ------------------------- ------------ ------------ ------------ dc_awr_control 6 2 0 dc_object_ids 468 0 2 dc_objects 398 0 22 dc_segments 605 12 3 dc_sequences 264,162 3 0 dc_tablespace_quotas 330 0 0 outstanding_alerts 528 216 0 ------------------------------------------------------------- Library Cache Activity DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 13 0.0 1,185 0.0 0 0 CLUSTER 1 0.0 1 0.0 0 0 INDEX 67 1.5 190 6.3 11 0 SQL AREA 11,846 25.1 2,304,805 0.4 2,767 228 TABLE/PROCEDURE 4,667 0.0 3,210,968 0.0 47 0 TRIGGER 135 0.0 276,781 0.0 0 0 ------------------------------------------------------------- Library Cache Activity (RAC) DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 GES Lock GES Pin GES Pin GES Inval GES Invali- Namespace Requests Requests Releases Requests dations --------------- ------------ ------------ ------------ ----------- ----------- CLUSTER 1 0 0 0 0 INDEX 190 164 0 39 0 TABLE/PROCEDURE 45,126 535 14 195 0 ------------------------------------------------------------- Process Memory Summary DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> B: Begin snap E: End snap -> All rows below contain absolute values (i.e. not diffed over the interval) -> Max Alloc is Maximum PGA Allocation size at snapshot time -> Hist Max Alloc is the Historical Max Allocation for still-connected processes -> ordered by Begin/End snapshot, Alloc (MB) desc Hist Avg Std Dev Max Max Alloc Used Alloc Alloc Alloc Alloc Num Num Category (MB) (MB) (MB) (MB) (MB) (MB) Proc Alloc - -------- --------- --------- -------- -------- ------- ------- ------ ------ B Freeable 1,055.3 .0 25.1 77.2 474 N/A 42 42 Other 776.0 N/A 12.5 17.8 119 1,062 62 62 SQL 28.0 21.0 .7 3.8 25 145 43 39 PL/SQL .7 .5 .0 .0 0 0 60 59 E Freeable 1,269.4 .0 31.0 80.4 474 N/A 41 41 Other 765.1 N/A 12.8 17.6 119 993 60 60 SQL 28.0 21.0 .7 3.9 25 145 42 37 PL/SQL .7 .5 .0 .0 0 0 58 57 ------------------------------------------------------------- SGA Memory Summary DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 3,909,091,328 Fixed Size 2,097,408 Redo Buffers 14,675,968 Variable Size 4,462,743,296 ------------------- sum 8,388,608,000 ------------------------------------------------------------- SGA breakdown difference DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> ordered by Pool, Name -> N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot Pool Name Begin MB End MB % Diff ------ ------------------------------ -------------- -------------- ------- java free memory 160.0 160.0 0.00 large ASM map operations hashta .4 .4 0.00 large PX msg pool 1.0 1.0 0.00 large free memory 14.6 14.6 0.00 shared CCursor 236.8 240.7 1.68 shared KGH: NO ACCESS 335.1 335.1 0.00 shared Logminer LCR c 840.8 840.8 0.00 shared PCursor 47.3 48.1 1.69 shared free memory 669.1 625.6 -6.51 shared gcs resources 90.0 90.0 0.00 shared gcs shadows 59.4 59.4 0.00 shared library cache 97.9 100.0 2.12 shared sql area 1,768.5 1,805.4 2.09 buffer_cache 3,728.0 3,728.0 0.00 fixed_sga 2.0 2.0 0.00 log_buffer 14.0 14.0 0.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 No data exists for this section of the report. ------------------------------------------------------------- Streams Capture DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 No data exists for this section of the report. ------------------------------------------------------------- Buffered Subscribers DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 No data exists for this section of the report. ------------------------------------------------------------- Resource Limit Stats DB/Inst: UDAS2PDB/udas2p2 Snap: 1055 -> only rows with Current or Maximum Utilization > 80% of Limit are shown -> ordered by resource name Current Maximum Initial Resource Name Utilization Utilization Allocation Limit ------------------------------ ------------ ------------ ---------- ---------- gcs_resources 423,480 475,945 502245 502245 gcs_shadows 482,890 513,472 502245 502245 ------------------------------------------------------------- init.ora Parameters DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- O7_DICTIONARY_ACCESSIBILITY TRUE archive_lag_target 0 audit_file_dest /usr/local/opt/oracle/admin/udas2 audit_trail DB background_dump_dest /usr/local/opt/oracle/admin/udas2 cluster_database TRUE cluster_database_instances 3 compatible 10.2.0.4.0 control_files +DBGRP1/udas2pdb_dg5/controlfile/ core_dump_dest /usr/local/opt/oracle/admin/udas2 db_block_checking full db_block_checksum full db_block_size 8192 db_create_file_dest +DBGRP1 db_domain sbc.com db_file_multiblock_read_count 16 db_name UDAS2PDB db_recovery_file_dest +RECOVERY db_recovery_file_dest_size 800647710720 db_unique_name udas2pdb_dg5 dispatchers (PROTOCOL=TCP) (SERVICE=udas2pXDB dml_locks 2924 event 10793 trace name context forever, fal_client udas2pdb_dg5 fal_server udas2pdb_dg4 instance_number 2 java_pool_size 167772160 job_queue_processes 10 local_listener LISTENER_UDAS2P2 log_archive_config DG_CONFIG=(udas2pdb_dg2,udas2pdb_ log_archive_dest_1 LOCATION=USE_DB_RECOVERY_FILE_DES log_archive_dest_2 SERVICE=udas2pdb_dg4.sbc.com LGWR log_archive_dest_3 LOCATION=+RECOVERY/udas2pdb_dg5/S log_archive_dest_state_2 ENABLE log_archive_dest_state_3 ENABLE log_archive_dest_state_4 ENABLE log_archive_max_processes 5 open_cursors 300 pga_aggregate_target 3145728000 processes 600 remote_listener LISTENERS_UDAS2PDB remote_login_passwordfile EXCLUSIVE service_names udas2pdb_dg5.sbc.com, codiesd_yel sessions 665 sga_max_size 8388608000 sga_target 8388608000 shared_pool_size 167772160 spfile +DBGRP1/udas2pdb_dg5/spfileudas2p standby_archive_dest +RECOVERY/udas2pdb_dg5/STDBYARC standby_file_management AUTO thread 2 transactions 731 undo_management AUTO undo_retention 3600 undo_tablespace UNDOTBS2 user_dump_dest /usr/local/opt/oracle/admin/udas2 ------------------------------------------------------------- Global Enqueue Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ acks for commit broadcast(actual) 3,090 0.4 0.0 acks for commit broadcast(logical 3,171 0.4 0.0 broadcast msgs on commit(actual) 209,322 28.9 1.2 broadcast msgs on commit(logical) 209,688 29.0 1.2 broadcast msgs on commit(wasted) 2,971 0.4 0.0 broadcast on commit wait time(ms) 91,912 12.7 0.5 broadcast on commit waits 53,653 7.4 0.3 dynamically allocated gcs resourc 0 0.0 0.0 dynamically allocated gcs shadows 0 0.0 0.0 false posts waiting for scn acks 2 0.0 0.0 flow control messages received 27 0.0 0.0 flow control messages sent 0 0.0 0.0 gcs assume cvt gcs assume no cvt 6,907 1.0 0.0 gcs ast xid 0 0.0 0.0 gcs blocked converts 1,176 0.2 0.0 gcs blocked cr converts 636 0.1 0.0 gcs compatible basts 467 0.1 0.0 gcs compatible cr basts (global) 69 0.0 0.0 gcs compatible cr basts (local) 7,522 1.0 0.0 gcs cr basts to PIs 0 0.0 0.0 gcs cr serve without current lock 0 0.0 0.0 gcs dbwr flush pi msgs 387 0.1 0.0 gcs dbwr write request msgs 229 0.0 0.0 gcs error msgs 0 0.0 0.0 gcs forward cr to pinged instance 0 0.0 0.0 gcs immediate (compatible) conver 6,351 0.9 0.0 gcs immediate (null) converts 10,264 1.4 0.1 gcs immediate cr (compatible) con 13 0.0 0.0 gcs immediate cr (null) converts 6,395 0.9 0.0 gcs indirect ast 3,934 0.5 0.0 gcs lms flush pi msgs 42 0.0 0.0 gcs lms write request msgs 58 0.0 0.0 gcs msgs process time(ms) 2,545 0.4 0.0 gcs msgs received 256,521 35.5 1.5 gcs out-of-order msgs 3 0.0 0.0 gcs pings refused 0 0.0 0.0 gcs pkey conflicts retry 0 0.0 0.0 gcs queued converts 0 0.0 0.0 gcs recovery claim msgs 0 0.0 0.0 gcs refuse xid 0 0.0 0.0 gcs regular cr 129 0.0 0.0 gcs retry convert request 85 0.0 0.0 gcs side channel msgs actual 17,121 2.4 0.1 gcs side channel msgs logical 58,767 8.1 0.3 gcs stale cr 0 0.0 0.0 gcs undo cr 42 0.0 0.0 gcs write notification msgs 9 0.0 0.0 gcs writes refused 9 0.0 0.0 ges msgs process time(ms) 48,783 6.7 0.3 ges msgs received 695,992 96.2 3.9 global posts dropped 0 0.0 0.0 global posts queue time 0 0.0 0.0 global posts queued 0 0.0 0.0 global posts requested 0 0.0 0.0 global posts sent 0 0.0 0.0 implicit batch messages received 69,768 9.6 0.4 implicit batch messages sent 18,992 2.6 0.1 lmd msg send time(ms) 0 0.0 0.0 lms(s) msg send time(ms) 0 0.0 0.0 Global Enqueue Statistics DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ messages flow controlled 378,455 52.3 2.1 messages queue sent actual 781,588 108.1 4.4 messages queue sent logical 802,109 110.9 4.5 messages received actual 871,265 120.5 4.9 messages received logical 952,515 131.7 5.4 messages sent directly 188,841 26.1 1.1 messages sent indirectly 30,913 4.3 0.2 messages sent not implicit batche 762,602 105.4 4.3 messages sent pbatched 411,213 56.9 2.3 msgs causing lmd to send msgs 369,099 51.0 2.1 msgs causing lms(s) to send msgs 894 0.1 0.0 msgs received queue time (ms) 13,649 1.9 0.1 msgs received queued 952,507 131.7 5.4 msgs sent queue time (ms) 45,595 6.3 0.3 msgs sent queue time on ksxp (ms) 555,932 76.9 3.1 msgs sent queued 801,764 110.8 4.5 msgs sent queued on ksxp 975,081 134.8 5.5 process batch messages received 484,288 67.0 2.7 process batch messages sent 399,315 55.2 2.3 ------------------------------------------------------------- Global CR Served Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 Statistic Total ------------------------------ ------------------ CR Block Requests 1,104 CURRENT Block Requests 206 Data Block Requests 1,104 Undo Block Requests 0 TX Block Requests 126 Current Results 1,310 Private results 0 Zero Results 0 Disk Read Results 0 Fail Results 0 Fairness Down Converts 236 Fairness Clears 0 Free GC Elements 0 Flushes 37 Flushes Queued 0 Flush Queue Full 0 Flush Max Time (us) 0 Light Works 19 Errors 0 ------------------------------------------------------------- Global CURRENT Served Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Pins = CURRENT Block Pin Operations -> Flushes = Redo Flush before CURRENT Block Served Operations -> Writes = CURRENT Block Fusion Write Operations Statistic Total % <1ms % <10ms % <100ms % <1s % <10s ---------- ------------ -------- -------- -------- -------- -------- Pins 7,254 100.00 0.00 0.00 0.00 0.00 Flushes 10 0.00 90.00 10.00 0.00 0.00 Writes 404 17.82 77.72 4.46 0.00 0.00 ------------------------------------------------------------- Global Cache Transfer Stats DB/Inst: UDAS2PDB/udas2p2 Snaps: 1053-1055 -> Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays -> Busy (Busy) - Block Transfer impacted by Remote Contention -> Congested (Congst) - Block Transfer impacted by Remote System Load -> ordered by CR + Current Blocks Received desc CR Current ----------------------------- ----------------------------- Inst Block Blocks % % % Blocks % % % No Class Received Immed Busy Congst Received Immed Busy Congst ---- ----------- -------- ------ ------ ------ -------- ------ ------ ------ 1 data block 163 96.9 3.1 .0 2,245 98.5 .6 .9 3 data block 401 99.8 .2 .0 1,841 95.1 4.3 .6 3 Others 132 100.0 .0 .0 443 99.5 .5 .0 1 Others 6 100.0 .0 .0 190 98.9 1.1 .0 1 undo header 73 100.0 .0 .0 49 95.9 4.1 .0 3 undo header 89 95.5 4.5 .0 9 88.9 11.1 .0 ------------------------------------------------------------- End of Report