WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Release RAC Host ------------ ----------- ------------ -------- ----------- --- ------------ LIPPDB 1523350277 LIPPDB 1 10.2.0.3.0 NO MLXIPRUATLAS Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 10302 28-Jul-08 13:30:40 309 76.6 End Snap: 10303 28-Jul-08 14:30:52 311 80.4 Elapsed: 60.20 (mins) DB Time: 32.99 (mins) Cache Sizes ~~~~~~~~~~~ Begin End ---------- ---------- Buffer Cache: 608M 608M Std Block Size: 8K Shared Pool Size: 608M 608M Log Buffer: 14,392K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 4,586.72 2,347.26 Logical reads: 4,678.38 2,394.17 Block changes: 51.22 26.21 Physical reads: 296.58 151.77 Physical writes: 5.72 2.93 User calls: 220.33 112.75 Parses: 30.67 15.70 Hard parses: 0.19 0.10 Sorts: 10.45 5.35 Logons: 0.30 0.16 Executes: 116.61 59.67 Transactions: 1.95 % Blocks changed per Read: 1.09 Recursive Call %: 41.49 Rollback per transaction %: 0.09 Rows per Sort: 2276.91 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 99.99 Redo NoWait %: 100.00 Buffer Hit %: 93.75 In-memory Sort %: 100.00 Library Hit %: 99.72 Soft Parse %: 99.37 Execute to Parse %: 73.70 Latch Hit %: 99.95 Parse CPU to Parse Elapsd %: 3.77 % Non-Parse CPU: 99.22 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 92.36 91.95 % SQL with executions>1: 96.97 96.29 % Memory for SQL w/exec>1: 94.00 93.63 Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- CPU time 1,102 55.7 db file sequential read 207,435 299 1 15.1 User I/O enq: TX - row lock contention 86 244 2838 12.3 Applicatio log file sync 5,693 209 37 10.6 Commit log file parallel write 6,395 149 23 7.5 System I/O ------------------------------------------------------------- Time Model Statistics DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Total time in database user-calls (DB Time): 1979.7s -> 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 1,830.2 92.4 DB CPU 1,102.1 55.7 parse time elapsed 35.8 1.8 PL/SQL execution elapsed time 11.3 .6 hard parse elapsed time 8.0 .4 sequence load elapsed time 2.1 .1 PL/SQL compilation elapsed time 0.7 .0 connection management call elapsed time 0.6 .0 repeated bind elapsed time 0.3 .0 failed parse elapsed time 0.2 .0 hard parse (sharing criteria) elapsed time 0.1 .0 DB time 1,979.7 N/A background elapsed time 233.7 N/A background cpu time 18.3 N/A ------------------------------------------------------------- Wait Class DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 -------------------- ---------------- ------ ---------------- ------- --------- User I/O 236,935 .0 437 2 33.6 Application 250 33.2 245 981 0.0 System I/O 41,379 .0 220 5 5.9 Commit 5,693 .1 209 37 0.8 Network 874,295 .0 11 0 123.9 Concurrency 849 .0 0 1 0.1 Other 181 .0 0 0 0.0 ------------------------------------------------------------- Wait Events DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 ---------------------------- -------------- ------ ----------- ------- --------- db file sequential read 207,435 .0 299 1 29.4 enq: TX - row lock contentio 86 96.5 244 2838 0.0 log file sync 5,693 .1 209 37 0.8 log file parallel write 6,395 .0 149 23 0.9 db file scattered read 27,428 .0 135 5 3.9 db file parallel write 897 .0 42 47 0.1 control file parallel write 1,192 .0 26 22 0.2 SQL*Net more data from dblin 24,096 .0 9 0 3.4 read by other session 83 .0 3 35 0.0 control file sequential read 32,895 .0 3 0 4.7 SQL*Net break/reset to clien 164 .0 1 7 0.0 SQL*Net more data to client 41,106 .0 1 0 5.8 SQL*Net message to client 792,695 .0 1 0 112.3 SQL*Net more data from clien 189 .0 0 2 0.0 buffer busy waits 771 .0 0 0 0.1 os thread startup 2 .0 0 77 0.0 row cache lock 12 .0 0 8 0.0 enq: TX - contention 1 .0 0 41 0.0 SQL*Net message to dblink 16,205 .0 0 0 2.3 latch free 1 .0 0 12 0.0 LGWR wait for redo copy 179 .0 0 0 0.0 direct path write temp 992 .0 0 0 0.1 latch: cache buffers chains 64 .0 0 0 0.0 direct path read temp 992 .0 0 0 0.1 SQL*Net more data to dblink 4 .0 0 0 0.0 direct path write 5 .0 0 0 0.0 SQL*Net message from client 792,693 .0 987,778 1246 112.3 jobq slave wait 6,001 82.0 17,233 2872 0.9 Streams AQ: qmn slave idle w 128 .0 3,518 27484 0.0 Streams AQ: qmn coordinator 263 51.3 3,518 13376 0.0 Streams AQ: waiting for time 2 100.0 1,998 999158 0.0 SQL*Net message from dblink 16,205 .0 197 12 2.3 single-task message 811 .0 105 129 0.1 class slave wait 2 .0 0 0 0.0 ------------------------------------------------------------- Background Wait Events DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 6,394 .0 149 23 0.9 db file parallel write 897 .0 42 47 0.1 control file parallel write 1,193 .0 26 22 0.2 os thread startup 2 .0 0 77 0.0 db file sequential read 210 .0 0 0 0.0 control file sequential read 3,896 .0 0 0 0.6 log file sync 2 .0 0 24 0.0 events in waitclass Other 179 .0 0 0 0.0 rdbms ipc message 17,631 65.1 37,956 2153 2.5 pmon timer 1,200 100.0 3,526 2938 0.2 Streams AQ: qmn slave idle w 128 .0 3,518 27484 0.0 Streams AQ: qmn coordinator 263 51.3 3,518 13376 0.0 smon timer 14 78.6 3,484 248839 0.0 Streams AQ: waiting for time 2 100.0 1,998 999158 0.0 ------------------------------------------------------------- Operating System Statistics DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 Statistic Total -------------------------------- -------------------- AVG_BUSY_TIME 24,638 AVG_IDLE_TIME 336,375 AVG_IOWAIT_TIME 15,395 AVG_SYS_TIME 3,657 AVG_USER_TIME 20,872 BUSY_TIME 197,928 IDLE_TIME 2,691,848 IOWAIT_TIME 124,033 SYS_TIME 30,122 USER_TIME 167,806 LOAD 1 OS_CPU_WAIT_TIME 1,900 RSRC_MGR_CPU_WAIT_TIME 0 VM_IN_BYTES 294,912 VM_OUT_BYTES 0 PHYSICAL_MEMORY_BYTES 16,751,017,984 NUM_CPUS 8 ------------------------------------------------------------- Service Statistics DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads Reads -------------------------------- ------------ ------------ ---------- ---------- SYS$USERS 1,980.3 1,102.7 1,069,953 ########## LIPPDB.iciciprulife.com 0.0 0.0 0 0 SYS$BACKGROUND 0.0 0.0 1,267 39,382 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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$USERS 235512 43645 847 33 0 0 873892 1137 SYS$BACKGROUND 1423 75 2 15 0 0 0 0 ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 ---------- ---------- ------------ ---------- ------- ------------- 321 320 2,316 0.1 16.2 1xcqx1nruubps Module: JDBC Thin Client select count (opp.OPPORTUNITY_ID) logins from TS_OPPORTUNITY_DETAILS opp,ts_bpt_ leads bpt where bpt.BPT_ID=opp.BPT_ID and bpt.anhfsc_id=:1 and bpt.docto r_id =:2 and opp.STATUS_CODE_STAGE_3=:3 and opp.REASON_CODE_STAGE_3=:4 and opp.DATE_STAGE_3 >= to_date(to_char(add_months(sysdate,to_numb 188 0 4 47.0 9.5 b12wcm3py7hn6 Module: TOAD background query session update adm_users set is_locked = 'N' where is_active = 1 and is_locked = 'Y' and user_id in (select user_id from adm_profile_master where operation_id in (1,2)) 176 66 7,580 0.0 8.9 dhdsqa1pntv2r Module: JDBC Thin Client SELECT TO_CHAR(UPDATED_DATE,'DD-MON-YYYY HH24:MI:SS') UPDATIONDATE, GE T_STATUS_REASON_DESC(STATUS_CODE) CURRENTSTATUS, GET_STATUS_REASON_DESC(REA SON_CODE) CURRENTREASON, TO_CHAR(NEXT_CONTACT_DATE,'DD-MON-YYYY HH24:MI:SS' ) NEXTACTIONDATE, A.LAST_UPDATED_BY|| '-'|| B.FIRST_NAME||' '||B.LAST_NAME 134 93 9,035 0.0 6.8 763wftt4ujvsp Module: JDBC Thin Client SELECT A.OPPORTUNITY_ID OPPORTUNITYID,A.FSC_OPPORTUNITY_ID FSCOPPORTUNITYID,A.OP PORTUNITY_TYPE_ID, A.CUSTOMER_ID CUSTOMERID, B.FIRST_NAME||' '|| B.MIDDLE_N AME||' '||B.LAST_NAME CUSTOMERNAME, TO_CHAR(DATE_OF_BIRTH,'DD-MON-YYYY') DO B, B.GENDER GENDER, B.GROSS_ANNUAL_INCOME INCOME, A.LEAD_TYPE LEADTYPE 106 54 1 105.8 5.3 gk441f6355r7x Module: oracleCMSPROD@PMASUNV49001 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */ "CLIENT_ID","AGENT_ID","FIRST_NAME","LAST_NAME"," AGENT_TYPE","ADDRESS1","ADDRESS2","ADDRESS3","ADDRESS4","ADDRESS5","PINCODE","LA NDMARK","MOBILE","EMAIL_ID","TELEPHONE","AREA_CODE","TERMINATION_DATE","TERMINAT ION_CODE" FROM "VW_CMS" "VW_CMS" WHERE ("AGENT_TYPE"='AG' OR "AGENT_TYPE"='RA' O 104 53 1 103.7 5.2 2fyfpg9a33vp4 Module: oracleCMSPROD@PMASUNV49001 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */ "CLIENT_ID","AGENT_ID","FIRST_NAME","LAST_NAME"," AGENT_TYPE","ADDRESS1","ADDRESS2","ADDRESS3","ADDRESS4","ADDRESS5","PINCODE","LA NDMARK","MOBILE","EMAIL_ID","TELEPHONE","AREA_CODE","TERMINATION_DATE","TERMINAT ION_CODE" FROM "VW_CMS" "VW_CMS" WHERE ("AGENT_TYPE"='AG' OR "AGENT_TYPE"='RA' O 82 82 206 0.4 4.2 45sdrm1vtam7z Module: JDBC Thin Client select count(distinct(dm.doctor_id )) as oppDocCount fr om ts_doctor_master dm,TS_OPPORTUNITY_DETAILS opp where upper(dm.anhfsc_id)=upper(:1) and dm.docto r_flag=:2 and opp.referer_id=dm.doctor_id 77 77 18,050 0.0 3.9 9tn9pgfu52jm1 Module: JDBC Thin Client SELECT CLUSTER_NAME FROM ADM_CLUSTER_MASTER WHERE CLUSTER_ID IN ( SELECT CLUSTER _ID FROM ADM_CLUSTER_PINCODE WHERE PINCODE_ID IN ( SELECT PINCODE_ID FROM ADM_PI NCODE_MASTER WHERE PINCODE=:B1 ) ) AND OPERATION_TYPE_ID=1 58 0 34 1.7 2.9 fa6rx4tm0xwt1 Module: JDBC Thin Client INSERT INTO DM_OPPORTUNITY_DETAILS_FSC (FSC_OPPORTUNITY_ID,OPPORTUNITY_ID ,CUSTOMER_ID,OPPORTUNITY_DATE,PRODUCT_ID,ANH_FSC_CODE,FRM_FILLED_BY,LEAD_TYPE, CHANNEL_TYPE,MODE_TYPE,SOURCE_TYPE,CAMPAIGN_TYPE,MEETING_PLACE,MEETING_CITY , MEETING_PIN,REFERER_ID,REFERER_DATE,TELE_CALLER_CODE, STATUS_CODE_ SQL ordered by Elapsed Time DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 ---------- ---------- ------------ ---------- ------- ------------- 57 1 90 0.6 2.9 2ch0vbhj33kr2 Module: JDBC Thin Client SELECT OPPORTUNITY_ID value from (SELECT OPPORTUNITY_ID,ANH_FSC_CODE ,A.TELECAL LER_APPT_FIXED_DATE DATE1 FROM DM_OPPORTUNITY_DETAILS_FSC A,DM_CUSTOMER_D ETAILS B, ADM_USERS C WHERE A.CUSTOMER_ID = B.CUSTOMER_ID AND C.US ER_ID=A.ANH_FSC_CODE AND A.LEAD_STATUS = :1 AND C.USER_ID = :2 AND (TRUNC(A.TELE 54 54 8 6.8 2.7 95u9m1q9mfc99 Module: JDBC Thin Client select max(a.visit_date) as visitDate, decode(max(a.visit_date),null,GET_ DOE(b.doctor_id),max(a.visit_date)) as visitDate, b.doctor_id as docId, b.doctor_name as doctorName, b.DOCTOR_MOBILE as mobileNo,b.DOCTOR_CL_PHON E as clinicNo,GET_TOLERANCE_LOGINS(b.doctor_id,:1,:2,:3)as logins, Get_TS 54 54 208 0.3 2.7 cw9npfctnsu61 Module: JDBC Thin Client SELECT COUNT(OPP.OPPORTUNITY_ID) FROM TS_OPPORTUNITY_DETAILS OPP,TS_BPT_LEADS BP T WHERE BPT.BPT_ID=OPP.BPT_ID AND BPT.DOCTOR_ID=:B4 AND UPPER(BPT.ANHFSC_ID)=UPP ER(:B3 ) AND OPP.STATUS_CODE_STAGE_3=:B2 AND OPP.REASON_CODE_STAGE_3=:B1 AND TO_ CHAR(OPP.DATE_STAGE_3 ,'Mon-YYYY')=TO_CHAR(SYSDATE,'Mon-YYYY') 45 42 22 2.0 2.2 546bvn1xa05td Module: TOAD background query session DECLARE Bytez Number; ArchStr CHAR(7); CURSOR TempVLogCursor IS SELECT GRO UP# FROM v$log WHERE status = 'CURRENT'; CURSOR GVDBArchLogCursor IS SELECT DE CODE(log_mode,'NOARCHIVELOG',0,1) FROM V$DATABASE; BEGIN SELECT COUNT(*) INTO : RedoLogGroupCount FROM V$LOG; OPEN TempVLogCursor; FETCH TempVLogCursor INTO :Re 38 38 10 3.8 1.9 1yz918mkw7y5r Module: JDBC Thin Client SELECT DISTINCT ga.COMPANY_ID companyId,ga.COMPANY_NAME AS companyName,cm. DESCN AS category,ga.CONTACT_NO AS contactNos,ga.DATABASE AS databas eName,ga.YR_OF_INCORPORATION AS yearIncorporation,ga.ANNUAL_WAGE_BILL AS annualWage, ausers.FIRST_NAME ||' '|| ausers.LAST_NAME AS rmName,' '|| ga.B 29 29 5 5.8 1.5 820dcnv1pkv3n Module: JDBC Thin Client SELECT DISTINCT ga.COMPANY_ID companyId,ga.COMPANY_NAME AS companyName,cm. DESCN AS category,ga.CONTACT_NO AS contactNos,ga.DATABASE AS databas eName,ga.YR_OF_INCORPORATION AS yearIncorporation,ga.ANNUAL_WAGE_BILL AS annualWage, ausers.FIRST_NAME ||' '|| ausers.LAST_NAME AS rmName,' '|| ga.B 28 28 22 1.3 1.4 7gzyydpxjx9s7 Module: TOAD background query session DECLARE CURSOR RedoLogBufferCur IS SELECT UPPER(name) name, ROUND(value) valu e FROM v$sysstat WHERE UPPER(name) in ('REDO BUFFER ALLOCATION RETRIES', 'REDO L OG SPACE WAIT TIME'); CURSOR VParamCur IS SELECT name, value FROM V$PARAMETER WHERE name IN ('pre_page_sga', 'cursor_space_for_time', 'session_cached_cursors 22 4 440 0.1 1.1 9krng5772mjyd Module: JDBC Thin Client SELECT TO_CHAR(CREATION_DATE,'DD-MON-YYYY HH12:MI:SS AM') VALUE FROM ADM_L OGIN_AUDIT WHERE CREATION_DATE >= (SELECT LAST_LOGIN_DT FROM ADM_USERS WHER E ACTION <> :1 AND USER_ID = :2) AND LOGIN_NAME = :3 ------------------------------------------------------------- SQL ordered by CPU Time DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 ---------- ---------- ------------ ----------- ------- ------------- 320 321 2,316 0.14 16.2 1xcqx1nruubps Module: JDBC Thin Client select count (opp.OPPORTUNITY_ID) logins from TS_OPPORTUNITY_DETAILS opp,ts_bpt_ leads bpt where bpt.BPT_ID=opp.BPT_ID and bpt.anhfsc_id=:1 and bpt.docto r_id =:2 and opp.STATUS_CODE_STAGE_3=:3 and opp.REASON_CODE_STAGE_3=:4 and opp.DATE_STAGE_3 >= to_date(to_char(add_months(sysdate,to_numb 93 134 9,035 0.01 6.8 763wftt4ujvsp Module: JDBC Thin Client SELECT A.OPPORTUNITY_ID OPPORTUNITYID,A.FSC_OPPORTUNITY_ID FSCOPPORTUNITYID,A.OP PORTUNITY_TYPE_ID, A.CUSTOMER_ID CUSTOMERID, B.FIRST_NAME||' '|| B.MIDDLE_N AME||' '||B.LAST_NAME CUSTOMERNAME, TO_CHAR(DATE_OF_BIRTH,'DD-MON-YYYY') DO B, B.GENDER GENDER, B.GROSS_ANNUAL_INCOME INCOME, A.LEAD_TYPE LEADTYPE 82 82 206 0.40 4.2 45sdrm1vtam7z Module: JDBC Thin Client select count(distinct(dm.doctor_id )) as oppDocCount fr om ts_doctor_master dm,TS_OPPORTUNITY_DETAILS opp where upper(dm.anhfsc_id)=upper(:1) and dm.docto r_flag=:2 and opp.referer_id=dm.doctor_id 77 77 18,050 0.00 3.9 9tn9pgfu52jm1 Module: JDBC Thin Client SELECT CLUSTER_NAME FROM ADM_CLUSTER_MASTER WHERE CLUSTER_ID IN ( SELECT CLUSTER _ID FROM ADM_CLUSTER_PINCODE WHERE PINCODE_ID IN ( SELECT PINCODE_ID FROM ADM_PI NCODE_MASTER WHERE PINCODE=:B1 ) ) AND OPERATION_TYPE_ID=1 66 176 7,580 0.01 8.9 dhdsqa1pntv2r Module: JDBC Thin Client SELECT TO_CHAR(UPDATED_DATE,'DD-MON-YYYY HH24:MI:SS') UPDATIONDATE, GE T_STATUS_REASON_DESC(STATUS_CODE) CURRENTSTATUS, GET_STATUS_REASON_DESC(REA SON_CODE) CURRENTREASON, TO_CHAR(NEXT_CONTACT_DATE,'DD-MON-YYYY HH24:MI:SS' ) NEXTACTIONDATE, A.LAST_UPDATED_BY|| '-'|| B.FIRST_NAME||' '||B.LAST_NAME 54 54 8 6.78 2.7 95u9m1q9mfc99 Module: JDBC Thin Client select max(a.visit_date) as visitDate, decode(max(a.visit_date),null,GET_ DOE(b.doctor_id),max(a.visit_date)) as visitDate, b.doctor_id as docId, b.doctor_name as doctorName, b.DOCTOR_MOBILE as mobileNo,b.DOCTOR_CL_PHON E as clinicNo,GET_TOLERANCE_LOGINS(b.doctor_id,:1,:2,:3)as logins, Get_TS 54 106 1 53.88 5.3 gk441f6355r7x Module: oracleCMSPROD@PMASUNV49001 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */ "CLIENT_ID","AGENT_ID","FIRST_NAME","LAST_NAME"," AGENT_TYPE","ADDRESS1","ADDRESS2","ADDRESS3","ADDRESS4","ADDRESS5","PINCODE","LA NDMARK","MOBILE","EMAIL_ID","TELEPHONE","AREA_CODE","TERMINATION_DATE","TERMINAT ION_CODE" FROM "VW_CMS" "VW_CMS" WHERE ("AGENT_TYPE"='AG' OR "AGENT_TYPE"='RA' O 54 54 208 0.26 2.7 cw9npfctnsu61 Module: JDBC Thin Client SELECT COUNT(OPP.OPPORTUNITY_ID) FROM TS_OPPORTUNITY_DETAILS OPP,TS_BPT_LEADS BP T WHERE BPT.BPT_ID=OPP.BPT_ID AND BPT.DOCTOR_ID=:B4 AND UPPER(BPT.ANHFSC_ID)=UPP ER(:B3 ) AND OPP.STATUS_CODE_STAGE_3=:B2 AND OPP.REASON_CODE_STAGE_3=:B1 AND TO_ CHAR(OPP.DATE_STAGE_3 ,'Mon-YYYY')=TO_CHAR(SYSDATE,'Mon-YYYY') 53 104 1 52.97 5.2 2fyfpg9a33vp4 Module: oracleCMSPROD@PMASUNV49001 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */ "CLIENT_ID","AGENT_ID","FIRST_NAME","LAST_NAME"," AGENT_TYPE","ADDRESS1","ADDRESS2","ADDRESS3","ADDRESS4","ADDRESS5","PINCODE","LA NDMARK","MOBILE","EMAIL_ID","TELEPHONE","AREA_CODE","TERMINATION_DATE","TERMINAT SQL ordered by CPU Time DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 ---------- ---------- ------------ ----------- ------- ------------- ION_CODE" FROM "VW_CMS" "VW_CMS" WHERE ("AGENT_TYPE"='AG' OR "AGENT_TYPE"='RA' O 42 45 22 1.91 2.2 546bvn1xa05td Module: TOAD background query session DECLARE Bytez Number; ArchStr CHAR(7); CURSOR TempVLogCursor IS SELECT GRO UP# FROM v$log WHERE status = 'CURRENT'; CURSOR GVDBArchLogCursor IS SELECT DE CODE(log_mode,'NOARCHIVELOG',0,1) FROM V$DATABASE; BEGIN SELECT COUNT(*) INTO : RedoLogGroupCount FROM V$LOG; OPEN TempVLogCursor; FETCH TempVLogCursor INTO :Re 38 38 10 3.81 1.9 1yz918mkw7y5r Module: JDBC Thin Client SELECT DISTINCT ga.COMPANY_ID companyId,ga.COMPANY_NAME AS companyName,cm. DESCN AS category,ga.CONTACT_NO AS contactNos,ga.DATABASE AS databas eName,ga.YR_OF_INCORPORATION AS yearIncorporation,ga.ANNUAL_WAGE_BILL AS annualWage, ausers.FIRST_NAME ||' '|| ausers.LAST_NAME AS rmName,' '|| ga.B 29 29 5 5.80 1.5 820dcnv1pkv3n Module: JDBC Thin Client SELECT DISTINCT ga.COMPANY_ID companyId,ga.COMPANY_NAME AS companyName,cm. DESCN AS category,ga.CONTACT_NO AS contactNos,ga.DATABASE AS databas eName,ga.YR_OF_INCORPORATION AS yearIncorporation,ga.ANNUAL_WAGE_BILL AS annualWage, ausers.FIRST_NAME ||' '|| ausers.LAST_NAME AS rmName,' '|| ga.B 28 28 22 1.28 1.4 7gzyydpxjx9s7 Module: TOAD background query session DECLARE CURSOR RedoLogBufferCur IS SELECT UPPER(name) name, ROUND(value) valu e FROM v$sysstat WHERE UPPER(name) in ('REDO BUFFER ALLOCATION RETRIES', 'REDO L OG SPACE WAIT TIME'); CURSOR VParamCur IS SELECT name, value FROM V$PARAMETER WHERE name IN ('pre_page_sga', 'cursor_space_for_time', 'session_cached_cursors 4 22 440 0.01 1.1 9krng5772mjyd Module: JDBC Thin Client SELECT TO_CHAR(CREATION_DATE,'DD-MON-YYYY HH12:MI:SS AM') VALUE FROM ADM_L OGIN_AUDIT WHERE CREATION_DATE >= (SELECT LAST_LOGIN_DT FROM ADM_USERS WHER E ACTION <> :1 AND USER_ID = :2) AND LOGIN_NAME = :3 1 57 90 0.01 2.9 2ch0vbhj33kr2 Module: JDBC Thin Client SELECT OPPORTUNITY_ID value from (SELECT OPPORTUNITY_ID,ANH_FSC_CODE ,A.TELECAL LER_APPT_FIXED_DATE DATE1 FROM DM_OPPORTUNITY_DETAILS_FSC A,DM_CUSTOMER_D ETAILS B, ADM_USERS C WHERE A.CUSTOMER_ID = B.CUSTOMER_ID AND C.US ER_ID=A.ANH_FSC_CODE AND A.LEAD_STATUS = :1 AND C.USER_ID = :2 AND (TRUNC(A.TELE 0 58 34 0.00 2.9 fa6rx4tm0xwt1 Module: JDBC Thin Client INSERT INTO DM_OPPORTUNITY_DETAILS_FSC (FSC_OPPORTUNITY_ID,OPPORTUNITY_ID ,CUSTOMER_ID,OPPORTUNITY_DATE,PRODUCT_ID,ANH_FSC_CODE,FRM_FILLED_BY,LEAD_TYPE, CHANNEL_TYPE,MODE_TYPE,SOURCE_TYPE,CAMPAIGN_TYPE,MEETING_PLACE,MEETING_CITY , MEETING_PIN,REFERER_ID,REFERER_DATE,TELE_CALLER_CODE, STATUS_CODE_ 0 188 4 0.02 9.5 b12wcm3py7hn6 Module: TOAD background query session update adm_users set is_locked = 'N' where is_active = 1 and is_locked = 'Y' and user_id in (select user_id from adm_profile_master where operation_id in (1,2)) ------------------------------------------------------------- SQL ordered by Gets DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 16,898,042 -> Captured SQL account for 86.2% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- 3,538,390 7,580 466.8 20.9 66.14 175.82 dhdsqa1pntv2r Module: JDBC Thin Client SELECT TO_CHAR(UPDATED_DATE,'DD-MON-YYYY HH24:MI:SS') UPDATIONDATE, GE T_STATUS_REASON_DESC(STATUS_CODE) CURRENTSTATUS, GET_STATUS_REASON_DESC(REA SON_CODE) CURRENTREASON, TO_CHAR(NEXT_CONTACT_DATE,'DD-MON-YYYY HH24:MI:SS' ) NEXTACTIONDATE, A.LAST_UPDATED_BY|| '-'|| B.FIRST_NAME||' '||B.LAST_NAME 2,350,373 206 11,409.6 13.9 82.26 82.29 45sdrm1vtam7z Module: JDBC Thin Client select count(distinct(dm.doctor_id )) as oppDocCount fr om ts_doctor_master dm,TS_OPPORTUNITY_DETAILS opp where upper(dm.anhfsc_id)=upper(:1) and dm.docto r_flag=:2 and opp.referer_id=dm.doctor_id 1,968,932 9,035 217.9 11.7 93.14 133.88 763wftt4ujvsp Module: JDBC Thin Client SELECT A.OPPORTUNITY_ID OPPORTUNITYID,A.FSC_OPPORTUNITY_ID FSCOPPORTUNITYID,A.OP PORTUNITY_TYPE_ID, A.CUSTOMER_ID CUSTOMERID, B.FIRST_NAME||' '|| B.MIDDLE_N AME||' '||B.LAST_NAME CUSTOMERNAME, TO_CHAR(DATE_OF_BIRTH,'DD-MON-YYYY') DO B, B.GENDER GENDER, B.GROSS_ANNUAL_INCOME INCOME, A.LEAD_TYPE LEADTYPE 1,689,374 18,050 93.6 10.0 77.39 77.39 9tn9pgfu52jm1 Module: JDBC Thin Client SELECT CLUSTER_NAME FROM ADM_CLUSTER_MASTER WHERE CLUSTER_ID IN ( SELECT CLUSTER _ID FROM ADM_CLUSTER_PINCODE WHERE PINCODE_ID IN ( SELECT PINCODE_ID FROM ADM_PI NCODE_MASTER WHERE PINCODE=:B1 ) ) AND OPERATION_TYPE_ID=1 645,978 8 80,747.3 3.8 54.24 54.27 95u9m1q9mfc99 Module: JDBC Thin Client select max(a.visit_date) as visitDate, decode(max(a.visit_date),null,GET_ DOE(b.doctor_id),max(a.visit_date)) as visitDate, b.doctor_id as docId, b.doctor_name as doctorName, b.DOCTOR_MOBILE as mobileNo,b.DOCTOR_CL_PHON E as clinicNo,GET_TOLERANCE_LOGINS(b.doctor_id,:1,:2,:3)as logins, Get_TS 636,918 208 3,062.1 3.8 53.76 53.83 cw9npfctnsu61 Module: JDBC Thin Client SELECT COUNT(OPP.OPPORTUNITY_ID) FROM TS_OPPORTUNITY_DETAILS OPP,TS_BPT_LEADS BP T WHERE BPT.BPT_ID=OPP.BPT_ID AND BPT.DOCTOR_ID=:B4 AND UPPER(BPT.ANHFSC_ID)=UPP ER(:B3 ) AND OPP.STATUS_CODE_STAGE_3=:B2 AND OPP.REASON_CODE_STAGE_3=:B1 AND TO_ CHAR(OPP.DATE_STAGE_3 ,'Mon-YYYY')=TO_CHAR(SYSDATE,'Mon-YYYY') 511,717 9 56,857.4 3.0 3.79 15.10 6fvmv0jzvwnma Module: JDBC Thin Client select opportunity_id value from DM_OPPORTUNITY_DETAILS_FSC where lead_stat us = :1 and meeting_pin in (select pincode from adm_pincode_master whe re pincode_id in (select pincode_id from adm_cluster_pincode where cluster_ id = :2)) and (anh_fsc_code is null) 484,207 123 3,936.6 2.9 10.96 12.90 f00un9w2xq9y5 Module: JDBC Thin Client SELECT a.opportunity_id opportunityid,a.customer_id customerId, b.first_nam e||' '|| b.middle_name||' '||b.last_name customername, to_char(date_of_birt h,'DD-MON-YYYY') dob, b.gender gender, b.gross_annual_income income, a .lead_type leadtype, a.channel_type channeltype, a.mode_type modetype, a.so 480,930 123 3,910.0 2.8 10.66 12.51 12wg6kktqmc0j Module: JDBC Thin Client SELECT ADVISOR_NAME FROM PC_ADVISOR_REPORTING_DETAILS WHERE ADVISOR_CODE = :B1 405,428 1 405,428.0 2.4 52.97 103.67 2fyfpg9a33vp4 SQL ordered by Gets DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 16,898,042 -> Captured SQL account for 86.2% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- Module: oracleCMSPROD@PMASUNV49001 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */ "CLIENT_ID","AGENT_ID","FIRST_NAME","LAST_NAME"," AGENT_TYPE","ADDRESS1","ADDRESS2","ADDRESS3","ADDRESS4","ADDRESS5","PINCODE","LA NDMARK","MOBILE","EMAIL_ID","TELEPHONE","AREA_CODE","TERMINATION_DATE","TERMINAT ION_CODE" FROM "VW_CMS" "VW_CMS" WHERE ("AGENT_TYPE"='AG' OR "AGENT_TYPE"='RA' O 405,426 1 405,426.0 2.4 53.88 105.84 gk441f6355r7x Module: oracleCMSPROD@PMASUNV49001 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */ "CLIENT_ID","AGENT_ID","FIRST_NAME","LAST_NAME"," AGENT_TYPE","ADDRESS1","ADDRESS2","ADDRESS3","ADDRESS4","ADDRESS5","PINCODE","LA NDMARK","MOBILE","EMAIL_ID","TELEPHONE","AREA_CODE","TERMINATION_DATE","TERMINAT ION_CODE" FROM "VW_CMS" "VW_CMS" WHERE ("AGENT_TYPE"='AG' OR "AGENT_TYPE"='RA' O 303,276 2,316 130.9 1.8 319.87 320.52 1xcqx1nruubps Module: JDBC Thin Client select count (opp.OPPORTUNITY_ID) logins from TS_OPPORTUNITY_DETAILS opp,ts_bpt_ leads bpt where bpt.BPT_ID=opp.BPT_ID and bpt.anhfsc_id=:1 and bpt.docto r_id =:2 and opp.STATUS_CODE_STAGE_3=:3 and opp.REASON_CODE_STAGE_3=:4 and opp.DATE_STAGE_3 >= to_date(to_char(add_months(sysdate,to_numb 238,209 440 541.4 1.4 3.89 22.10 9krng5772mjyd Module: JDBC Thin Client SELECT TO_CHAR(CREATION_DATE,'DD-MON-YYYY HH12:MI:SS AM') VALUE FROM ADM_L OGIN_AUDIT WHERE CREATION_DATE >= (SELECT LAST_LOGIN_DT FROM ADM_USERS WHER E ACTION <> :1 AND USER_ID = :2) AND LOGIN_NAME = :3 226,897 548 414.0 1.3 5.83 6.48 dtg6x4f3xygjk Module: JDBC Thin Client SELECT USER_ID value FROM ADM_USERS WHERE UPPER(USER_ID)=UPPER(:1) AND IS_L OCKED='Y' 199,186 22 9,053.9 1.2 42.09 44.54 546bvn1xa05td Module: TOAD background query session DECLARE Bytez Number; ArchStr CHAR(7); CURSOR TempVLogCursor IS SELECT GRO UP# FROM v$log WHERE status = 'CURRENT'; CURSOR GVDBArchLogCursor IS SELECT DE CODE(log_mode,'NOARCHIVELOG',0,1) FROM V$DATABASE; BEGIN SELECT COUNT(*) INTO : RedoLogGroupCount FROM V$LOG; OPEN TempVLogCursor; FETCH TempVLogCursor INTO :Re ------------------------------------------------------------- SQL ordered by Reads DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Total Disk Reads: 1,071,221 -> Captured SQL account for 95.9% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- 412,898 1 412,898.0 38.5 53.88 105.84 gk441f6355r7x Module: oracleCMSPROD@PMASUNV49001 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */ "CLIENT_ID","AGENT_ID","FIRST_NAME","LAST_NAME"," AGENT_TYPE","ADDRESS1","ADDRESS2","ADDRESS3","ADDRESS4","ADDRESS5","PINCODE","LA NDMARK","MOBILE","EMAIL_ID","TELEPHONE","AREA_CODE","TERMINATION_DATE","TERMINAT ION_CODE" FROM "VW_CMS" "VW_CMS" WHERE ("AGENT_TYPE"='AG' OR "AGENT_TYPE"='RA' O 412,476 1 412,476.0 38.5 52.97 103.67 2fyfpg9a33vp4 Module: oracleCMSPROD@PMASUNV49001 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */ "CLIENT_ID","AGENT_ID","FIRST_NAME","LAST_NAME"," AGENT_TYPE","ADDRESS1","ADDRESS2","ADDRESS3","ADDRESS4","ADDRESS5","PINCODE","LA NDMARK","MOBILE","EMAIL_ID","TELEPHONE","AREA_CODE","TERMINATION_DATE","TERMINAT ION_CODE" FROM "VW_CMS" "VW_CMS" WHERE ("AGENT_TYPE"='AG' OR "AGENT_TYPE"='RA' O 75,871 22 3,448.7 7.1 42.09 44.54 546bvn1xa05td Module: TOAD background query session DECLARE Bytez Number; ArchStr CHAR(7); CURSOR TempVLogCursor IS SELECT GRO UP# FROM v$log WHERE status = 'CURRENT'; CURSOR GVDBArchLogCursor IS SELECT DE CODE(log_mode,'NOARCHIVELOG',0,1) FROM V$DATABASE; BEGIN SELECT COUNT(*) INTO : RedoLogGroupCount FROM V$LOG; OPEN TempVLogCursor; FETCH TempVLogCursor INTO :Re 75,654 22 3,438.8 7.1 9.44 10.11 b1j3urgvujytx Module: TOAD background query session SELECT ROUND(SUM(BYTES)/1048576) FROM DBA_SEGMENTS 22,751 440 51.7 2.1 3.89 22.10 9krng5772mjyd Module: JDBC Thin Client SELECT TO_CHAR(CREATION_DATE,'DD-MON-YYYY HH12:MI:SS AM') VALUE FROM ADM_L OGIN_AUDIT WHERE CREATION_DATE >= (SELECT LAST_LOGIN_DT FROM ADM_USERS WHER E ACTION <> :1 AND USER_ID = :2) AND LOGIN_NAME = :3 22,709 7,580 3.0 2.1 66.14 175.82 dhdsqa1pntv2r Module: JDBC Thin Client SELECT TO_CHAR(UPDATED_DATE,'DD-MON-YYYY HH24:MI:SS') UPDATIONDATE, GE T_STATUS_REASON_DESC(STATUS_CODE) CURRENTSTATUS, GET_STATUS_REASON_DESC(REA SON_CODE) CURRENTREASON, TO_CHAR(NEXT_CONTACT_DATE,'DD-MON-YYYY HH24:MI:SS' ) NEXTACTIONDATE, A.LAST_UPDATED_BY|| '-'|| B.FIRST_NAME||' '||B.LAST_NAME 20,878 4 5,219.5 1.9 2.03 4.34 29f5fn90kbnpj Module: JDBC Thin Client SELECT A.CALL_TYPE,A.POLICY_NO,A.CLIENT_ID,A.CAMPAIGN_ID,A.FORM_NO,A.WAPI, A.NB AP,A.AGENT_TYPE, B.SALUTATION,INITCAP(B.FIRST_NAME) AS FIRST_NAME, INITCAP(B.LA ST_NAME) AS LAST_NAME,B.RES_STD1,B.RES_STD2,B.OFF_STD,B.RES_TEL1, B.RES_TEL2,B.O FF_TEL1,B.OFF_TEL2,B.MOBILE,B.EMAIL_ID,B.HNI_INDICATOR,TO_CHAR(C.RCDDATE,'DD-MON 11,378 123 92.5 1.1 10.96 12.90 f00un9w2xq9y5 Module: JDBC Thin Client SELECT a.opportunity_id opportunityid,a.customer_id customerId, b.first_nam e||' '|| b.middle_name||' '||b.last_name customername, to_char(date_of_birt h,'DD-MON-YYYY') dob, b.gender gender, b.gross_annual_income income, a .lead_type leadtype, a.channel_type channeltype, a.mode_type modetype, a.so 11,320 123 92.0 1.1 10.66 12.51 12wg6kktqmc0j Module: JDBC Thin Client SELECT ADVISOR_NAME FROM PC_ADVISOR_REPORTING_DETAILS WHERE ADVISOR_CODE = :B1 9,631 9,035 1.1 0.9 93.14 133.88 763wftt4ujvsp Module: JDBC Thin Client SELECT A.OPPORTUNITY_ID OPPORTUNITYID,A.FSC_OPPORTUNITY_ID FSCOPPORTUNITYID,A.OP PORTUNITY_TYPE_ID, A.CUSTOMER_ID CUSTOMERID, B.FIRST_NAME||' '|| B.MIDDLE_N SQL ordered by Reads DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Total Disk Reads: 1,071,221 -> Captured SQL account for 95.9% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- AME||' '||B.LAST_NAME CUSTOMERNAME, TO_CHAR(DATE_OF_BIRTH,'DD-MON-YYYY') DO B, B.GENDER GENDER, B.GROSS_ANNUAL_INCOME INCOME, A.LEAD_TYPE LEADTYPE ------------------------------------------------------------- SQL ordered by Executions DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Total Executions: 421,185 -> Captured SQL account for 35.5% of Total CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- 84,912 84,912 1.0 0.00 0.00 4m94ckmu16f9k Module: JDBC Thin Client select count(*) from dual 18,050 18,030 1.0 0.00 0.00 9tn9pgfu52jm1 Module: JDBC Thin Client SELECT CLUSTER_NAME FROM ADM_CLUSTER_MASTER WHERE CLUSTER_ID IN ( SELECT CLUSTER _ID FROM ADM_CLUSTER_PINCODE WHERE PINCODE_ID IN ( SELECT PINCODE_ID FROM ADM_PI NCODE_MASTER WHERE PINCODE=:B1 ) ) AND OPERATION_TYPE_ID=1 9,723 9,723 1.0 0.00 0.00 685jdx1fpumas Module: JDBC Thin Client SELECT DISTINCT MAX_FOLLOWUP_DAYS FROM ADM_PROFILE_MASTER WHERE USER_ID = :B1 9,035 9,036 1.0 0.01 0.01 763wftt4ujvsp Module: JDBC Thin Client SELECT A.OPPORTUNITY_ID OPPORTUNITYID,A.FSC_OPPORTUNITY_ID FSCOPPORTUNITYID,A.OP PORTUNITY_TYPE_ID, A.CUSTOMER_ID CUSTOMERID, B.FIRST_NAME||' '|| B.MIDDLE_N AME||' '||B.LAST_NAME CUSTOMERNAME, TO_CHAR(DATE_OF_BIRTH,'DD-MON-YYYY') DO B, B.GENDER GENDER, B.GROSS_ANNUAL_INCOME INCOME, A.LEAD_TYPE LEADTYPE 7,580 46,882 6.2 0.01 0.02 dhdsqa1pntv2r Module: JDBC Thin Client SELECT TO_CHAR(UPDATED_DATE,'DD-MON-YYYY HH24:MI:SS') UPDATIONDATE, GE T_STATUS_REASON_DESC(STATUS_CODE) CURRENTSTATUS, GET_STATUS_REASON_DESC(REA SON_CODE) CURRENTREASON, TO_CHAR(NEXT_CONTACT_DATE,'DD-MON-YYYY HH24:MI:SS' ) NEXTACTIONDATE, A.LAST_UPDATED_BY|| '-'|| B.FIRST_NAME||' '||B.LAST_NAME 3,188 1,043 0.3 0.00 0.00 0h6b2sajwb74n select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p rivilege#>0 start with grantee#=:1 and privilege#>0 2,316 2,316 1.0 0.14 0.14 1xcqx1nruubps Module: JDBC Thin Client select count (opp.OPPORTUNITY_ID) logins from TS_OPPORTUNITY_DETAILS opp,ts_bpt_ leads bpt where bpt.BPT_ID=opp.BPT_ID and bpt.anhfsc_id=:1 and bpt.docto r_id =:2 and opp.STATUS_CODE_STAGE_3=:3 and opp.REASON_CODE_STAGE_3=:4 and opp.DATE_STAGE_3 >= to_date(to_char(add_months(sysdate,to_numb 2,141 2,141 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 1,573 1,573 1.0 0.00 0.00 7qmzv5hwvfa7b INSERT INTO PROCESS_LOG (PROCESS_ID,ACTION,SUB_ACTION,ACTION_STATUS,DETAILS) VAL UES (RM_SEQ_PROCESS_ID.NEXTVAL,:B4 ,:B3 ,:B2 ,:B1 ) 1,090 3,180 2.9 0.00 0.00 0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege# >0 ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Total Parse Calls: 110,786 -> Captured SQL account for 89.7% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 84,911 84,912 76.64 4m94ckmu16f9k Module: JDBC Thin Client select count(*) from dual 3,204 3,188 2.89 0h6b2sajwb74n select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p rivilege#>0 start with grantee#=:1 and privilege#>0 2,141 2,141 1.93 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 1,091 1,090 0.98 0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege# >0 887 963 0.80 aq8yqxyyb40nn update sys.job$ set this_date=:1 where job=:2 877 864 0.79 a1mbfp580hw3k select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where j ob=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u 2.name and cowner = u3.name 835 835 0.75 459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME' 827 963 0.75 47a50dvdgnxc2 update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_dat e = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date,sysdate)) where j ob=:4 822 956 0.74 57yaut88axtf5 select SYSDATE+30/86400 from dual 481 1,573 0.43 7qmzv5hwvfa7b INSERT INTO PROCESS_LOG (PROCESS_ID,ACTION,SUB_ACTION,ACTION_STATUS,DETAILS) VAL UES (RM_SEQ_PROCESS_ID.NEXTVAL,:B4 ,:B3 ,:B2 ,:B1 ) ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 No data exists for this section of the report. ------------------------------------------------------------- Instance Activity Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- CPU used by this session 112,576 31.2 16.0 CPU used when call started 110,511 30.6 15.7 CR blocks created 117,967 32.7 16.7 Cached Commit SCN referenced 810,640 224.4 114.9 Commit SCN cached 26 0.0 0.0 DB time 1,996,237 552.7 282.8 DBWR checkpoint buffers written 4,583 1.3 0.7 DBWR checkpoints 0 0.0 0.0 DBWR object drop buffers written 0 0.0 0.0 DBWR revisited being-written buf 0 0.0 0.0 DBWR tablespace checkpoint buffe 0 0.0 0.0 DBWR thread checkpoint buffers w 0 0.0 0.0 DBWR transaction table writes 171 0.1 0.0 DBWR undo block writes 986 0.3 0.1 Misses for writing mapping 0 0.0 0.0 SMON posted for undo segment rec 0 0.0 0.0 SMON posted for undo segment shr 0 0.0 0.0 SQL*Net roundtrips to/from clien 792,253 219.3 112.3 SQL*Net roundtrips to/from dblin 16,205 4.5 2.3 active txn count during cleanout 114,813 31.8 16.3 application wait time 24,515 6.8 3.5 background checkpoints completed 0 0.0 0.0 background checkpoints started 0 0.0 0.0 background timeouts 11,546 3.2 1.6 branch node splits 0 0.0 0.0 buffer is not pinned count 4,914,914 1,360.7 696.4 buffer is pinned count 7,763,705 2,149.5 1,100.0 bytes received via SQL*Net from 31,840,102 8,815.2 4,511.2 bytes received via SQL*Net from 57,353,298 15,878.8 8,126.0 bytes sent via SQL*Net to client 135,146,543 37,416.6 19,148.0 bytes sent via SQL*Net to dblink 3,378,932 935.5 478.7 calls to get snapshot scn: kcmgs 658,717 182.4 93.3 calls to kcmgas 203,531 56.4 28.8 calls to kcmgcs 152 0.0 0.0 change write time 129 0.0 0.0 cleanout - number of ktugct call 115,375 31.9 16.4 cleanouts and rollbacks - consis 114,453 31.7 16.2 cleanouts only - consistent read 252 0.1 0.0 cluster key scan block gets 33,118 9.2 4.7 cluster key scans 13,385 3.7 1.9 commit batch performed 360 0.1 0.1 commit batch requested 360 0.1 0.1 commit batch/immediate performed 361 0.1 0.1 commit batch/immediate requested 361 0.1 0.1 commit cleanout failures: block 5 0.0 0.0 commit cleanout failures: buffer 0 0.0 0.0 commit cleanout failures: callba 154 0.0 0.0 commit cleanout failures: cannot 690 0.2 0.1 commit cleanouts 15,531 4.3 2.2 commit cleanouts successfully co 14,682 4.1 2.1 commit immediate performed 1 0.0 0.0 commit immediate requested 1 0.0 0.0 commit txn count during cleanout 2,384 0.7 0.3 concurrency wait time 48 0.0 0.0 consistent changes 324,957 90.0 46.0 consistent gets 16,822,757 4,657.5 2,383.5 consistent gets - examination 2,937,688 813.3 416.2 consistent gets direct 5 0.0 0.0 consistent gets from cache 16,822,752 4,657.5 2,383.5 current blocks converted for CR 0 0.0 0.0 Instance Activity Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- cursor authentications 196 0.1 0.0 data blocks consistent reads - u 323,949 89.7 45.9 db block changes 184,995 51.2 26.2 db block gets 75,285 20.8 10.7 db block gets direct 11 0.0 0.0 db block gets from cache 75,274 20.8 10.7 deferred (CURRENT) block cleanou 7,720 2.1 1.1 dirty buffers inspected 994 0.3 0.1 enqueue conversions 21,918 6.1 3.1 enqueue releases 89,530 24.8 12.7 enqueue requests 89,537 24.8 12.7 enqueue timeouts 0 0.0 0.0 enqueue waits 5 0.0 0.0 exchange deadlocks 0 0.0 0.0 execute count 421,185 116.6 59.7 failed probes on index block rec 0 0.0 0.0 free buffer inspected 1,088,409 301.3 154.2 free buffer requested 1,175,440 325.4 166.5 heap block compress 497 0.1 0.1 hot buffers moved to head of LRU 178,346 49.4 25.3 immediate (CR) block cleanout ap 114,705 31.8 16.3 immediate (CURRENT) block cleano 435 0.1 0.1 index crx upgrade (found) 478 0.1 0.1 index crx upgrade (positioned) 7,664 2.1 1.1 index fast full scans (full) 0 0.0 0.0 index fetch by key 1,300,192 360.0 184.2 index scans kdiixs1 2,490,742 689.6 352.9 leaf node 90-10 splits 10 0.0 0.0 leaf node splits 38 0.0 0.0 lob reads 15 0.0 0.0 lob writes 135 0.0 0.0 lob writes unaligned 135 0.0 0.0 logons cumulative 1,098 0.3 0.2 messages received 7,271 2.0 1.0 messages sent 7,271 2.0 1.0 no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 13,519,719 3,743.1 1,915.5 opened cursors cumulative 112,951 31.3 16.0 parse count (failures) 77 0.0 0.0 parse count (hard) 696 0.2 0.1 parse count (total) 110,786 30.7 15.7 parse time cpu 864 0.2 0.1 parse time elapsed 22,939 6.4 3.3 physical read IO requests 235,671 65.3 33.4 physical read bytes 8,775,442,432 2,429,562.8 1,243,332.7 physical read total IO requests 268,756 74.4 38.1 physical read total bytes 9,142,714,368 2,531,245.5 1,295,369.0 physical read total multi block 28,552 7.9 4.1 physical reads 1,071,221 296.6 151.8 physical reads cache 1,056,336 292.5 149.7 physical reads cache prefetch 821,662 227.5 116.4 physical reads direct 14,885 4.1 2.1 physical reads direct (lob) 0 0.0 0.0 physical reads direct temporary 14,880 4.1 2.1 physical reads prefetch warmup 0 0.0 0.0 physical write IO requests 4,969 1.4 0.7 physical write bytes 169,304,064 46,873.4 23,987.5 physical write total IO requests 20,145 5.6 2.9 physical write total bytes 227,095,552 62,873.5 32,175.6 physical write total multi block 13,104 3.6 1.9 Instance Activity Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- physical writes 20,667 5.7 2.9 physical writes direct 14,891 4.1 2.1 physical writes direct (lob) 5 0.0 0.0 physical writes direct temporary 14,880 4.1 2.1 physical writes from cache 5,776 1.6 0.8 physical writes non checkpoint 17,931 5.0 2.5 pinned buffers inspected 2 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 3,869 1.1 0.6 recursive calls 564,322 156.2 80.0 recursive cpu usage 27,196 7.5 3.9 redo blocks written 37,349 10.3 5.3 redo buffer allocation retries 0 0.0 0.0 redo entries 151,462 41.9 21.5 redo log space requests 0 0.0 0.0 redo log space wait time 0 0.0 0.0 redo ordering marks 0 0.0 0.0 redo size 16,566,960 4,586.7 2,347.3 redo synch time 21,363 5.9 3.0 redo synch writes 109,372 30.3 15.5 redo wastage 1,950,956 540.1 276.4 redo write time 15,182 4.2 2.2 redo writer latching time 0 0.0 0.0 redo writes 6,394 1.8 0.9 rollback changes - undo records 1 0.0 0.0 rollbacks only - consistent read 3,463 1.0 0.5 rows fetched via callback 944,323 261.4 133.8 session connect time 0 0.0 0.0 session cursor cache hits 90,923 25.2 12.9 session logical reads 16,898,042 4,678.4 2,394.2 session pga memory 1,060,999,088 293,747.5 150,325.7 session pga memory max 246,990,033,488 68,381,487.1 34,994,337.4 session uga memory 4,123,218,871,600 ############## ############# session uga memory max 1,023,131,728 283,263.5 144,960.6 shared hash latch upgrades - no 28,961 8.0 4.1 shared hash latch upgrades - wai 478 0.1 0.1 sorts (disk) 0 0.0 0.0 sorts (memory) 37,759 10.5 5.4 sorts (rows) 85,973,688 23,802.6 12,181.0 sql area evicted 30 0.0 0.0 sql area purged 77 0.0 0.0 summed dirty queue length 1,022 0.3 0.1 switch current to new buffer 236 0.1 0.0 table fetch by rowid 4,293,628 1,188.7 608.3 table fetch continued row 13,820 3.8 2.0 table scan blocks gotten 7,394,601 2,047.3 1,047.7 table scan rows gotten 575,589,514 159,357.3 81,551.4 table scans (cache partitions) 0 0.0 0.0 table scans (long tables) 10 0.0 0.0 table scans (short tables) 69,134 19.1 9.8 total number of times SMON poste 3 0.0 0.0 transaction rollbacks 361 0.1 0.1 transaction tables consistent re 0 0.0 0.0 transaction tables consistent re 0 0.0 0.0 undo change vector size 3,457,088 957.1 489.8 user I/O wait time 43,717 12.1 6.2 user calls 795,821 220.3 112.8 user commits 7,052 2.0 1.0 user rollbacks 6 0.0 0.0 Instance Activity Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- workarea executions - multipass 0 0.0 0.0 workarea executions - onepass 4 0.0 0.0 workarea executions - optimal 45,311 12.5 6.4 write clones created in backgrou 0 0.0 0.0 write clones created in foregrou 79 0.0 0.0 ------------------------------------------------------------- Instance Activity Stats - Absolute ValuesDB/Inst: LIPPDB/LIPPDB Snaps: 10302 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- session cursor cache count 2,391,759 2,409,515 opened cursors current 23,663 25,003 logons current 309 311 ------------------------------------------------------------- Instance Activity Stats - Thread ActivityDB/Inst: LIPPDB/LIPPDB Snaps: 10302- -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 0 .00 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ LIVEAPNATBS 58,181 16 3.0 14.9 785 0 1 170.0 ATLAS_DM 37,362 10 4.9 1.0 268 0 79 34.2 ATLAS_TS 32,654 9 0.8 1.0 198 0 0 0.0 SYSTEM 26,344 7 0.2 1.0 72 0 713 0.0 SYSAUX 25,724 7 0.0 1.0 311 0 0 0.0 LIVEAPNAINDX 24,414 7 0.6 1.0 1,209 0 2 65.0 ATLAS_ADMIN 23,623 7 0.8 1.0 724 0 22 0.0 CORPORATE_AGENT 2,817 1 0.0 1.0 0 0 0 0.0 TEMP 992 0 0.3 15.0 992 0 0 0.0 ATLAS_PC 1,633 0 2.7 7.9 9 0 0 0.0 TOOLS_NEW 710 0 0.1 1.1 0 0 0 0.0 ATLAS_RT 685 0 0.0 1.0 0 0 0 0.0 ATLAS_GS 528 0 2.3 4.5 8 0 0 0.0 UNDO_TBS 3 0 0.0 1.0 400 0 37 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ ATLAS_ADMIN /lippdata3/oradata/data/LIPPDB_ATLAS_ADMIN_01.dbf 23,623 7 0.8 1.0 724 0 22 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_01.dbf 766 0 7.2 1.0 0 0 1 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_02.dbf 707 0 6.3 1.0 0 0 1 100.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_03.dbf 939 0 5.4 1.0 0 0 2 40.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_04.dbf 929 0 5.0 1.0 70 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_05.dbf 874 0 4.2 1.0 0 0 3 16.7 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_06.dbf 833 0 3.2 1.0 0 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_07.dbf 861 0 3.6 1.0 0 0 7 22.9 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_08.dbf 888 0 5.5 1.0 1 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_09.dbf 752 0 6.6 1.0 1 0 3 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_10.dbf 740 0 4.5 1.0 1 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_11.dbf 828 0 4.9 1.0 0 0 3 23.3 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_12.dbf 756 0 4.5 1.0 3 0 1 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_13.dbf 557 0 5.7 1.0 0 0 1 60.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_14.dbf 816 0 5.0 1.0 34 0 9 48.9 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_15.dbf 987 0 4.6 1.0 0 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_16.dbf 933 0 3.5 1.0 3 0 1 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_17.dbf 727 0 6.9 1.0 1 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_18.dbf 843 0 4.1 1.0 2 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_19.dbf 811 0 4.9 1.0 9 0 1 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_20.dbf 673 0 6.0 1.0 2 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_21.dbf 715 0 4.8 1.0 8 0 3 26.7 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_22.dbf 824 0 5.1 1.0 4 0 4 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_23.dbf 902 0 3.5 1.0 19 0 3 46.7 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_24.dbf 858 0 4.4 1.0 1 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_25.dbf 683 0 5.1 1.0 4 0 5 60.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_26.dbf 710 0 4.7 1.0 2 0 2 35.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_27.dbf 744 0 5.7 1.0 36 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_28.dbf 704 0 6.2 1.0 10 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_29.dbf 894 0 3.1 1.0 4 0 0 0.0 File IO Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_30.dbf 659 0 5.5 1.0 0 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_31.dbf 703 0 7.5 1.0 5 0 1 90.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_32.dbf 693 0 6.6 1.0 1 0 3 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_33.dbf 891 0 4.7 1.0 1 0 1 120.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_34.dbf 877 0 5.2 1.0 1 0 3 36.7 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_35.dbf 997 0 4.8 1.0 1 0 6 48.3 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_36.dbf 1,059 0 3.7 1.0 6 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_37.dbf 1,069 0 4.6 1.0 23 0 3 50.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_38.dbf 908 0 4.4 1.0 1 0 2 80.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_39.dbf 784 0 5.6 1.0 0 0 1 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_40.dbf 782 0 4.8 1.0 0 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_41.dbf 920 0 4.4 1.0 1 0 4 22.5 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_42.dbf 915 0 5.0 1.0 9 0 1 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_43.dbf 1,055 0 4.8 1.0 1 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_44.dbf 949 0 5.1 1.0 1 0 0 0.0 ATLAS_DM /lippdata7/oradata/LIPPDB_ATLAS_DM_45.dbf 847 0 5.2 1.0 2 0 4 35.0 ATLAS_GS /lippdata2/oradata/data/LIPPDB_ATLAS_GS_01.dbf 528 0 2.3 4.5 8 0 0 0.0 ATLAS_PC /lippdata3/oradata/data/LIPPDB_ATLAS_PC_01.dbf 1,633 0 2.7 7.9 9 0 0 0.0 ATLAS_RT /lippdata8/oradata/data/LIPPDB_ATLAS_RT_01.dbf 683 0 0.0 1.0 0 0 0 0.0 ATLAS_RT /lippdata8/oradata/data/LIPPDB_ATLAS_RT_02.dbf 1 0 0.0 1.0 0 0 0 0.0 ATLAS_RT /lippdata8/oradata/data/LIPPDB_ATLAS_RT_03.dbf 1 0 0.0 1.0 0 0 0 0.0 ATLAS_TS /lippdata2/oradata/data/LIPPDB_ATLAS_TS_02.dbf 10,568 3 1.0 1.0 73 0 0 0.0 ATLAS_TS /lippdata3/oradata/data/LIPPDB_ATLAS_TS_01.dbf 22,086 6 0.7 1.0 125 0 0 0.0 CORPORATE_AGENT /lippdata8/oradata/data/LIPPDB_CORPORATE_AGENT_01.db 2,817 1 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_01.dbf 631 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_02.dbf 2,575 1 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_03.dbf 2,119 1 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_04.dbf 13 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_05.dbf 5 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_06.dbf 467 0 0.0 1.0 0 0 0 0.0 File IO Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_07.dbf 67 0 0.1 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_08.dbf 10 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_09.dbf 11 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_10.dbf 1 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_11.dbf 1 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata1/oradata/data/LIPPDB_liveapnaindx_33.dbf 15 0 0.7 1.0 1 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_14.dbf 1 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_15.dbf 2 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_16.dbf 6 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_17.dbf 23 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_18.dbf 5 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_19.dbf 1 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_20.dbf 57 0 1.1 1.0 5 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_21.dbf 5 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_22.dbf 3 0 3.3 1.0 1 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_23.dbf 2 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_24.dbf 27 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_25.dbf 1 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_26.dbf 2 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_27.dbf 23 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_28.dbf 1 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_29.dbf 1 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata2/oradata/data/LIPPDB_liveapnaindx_36.dbf 65 0 0.6 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_12.dbf 5 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_13.dbf 1 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_30.dbf 74 0 1.5 1.0 2 0 0 0.0 LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_31.dbf 18 0 2.2 1.0 6 0 0 0.0 LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_32.dbf 17 0 1.2 1.0 2 0 0 0.0 LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_34.dbf 42 0 3.1 1.0 4 0 0 0.0 LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_35.dbf 136 0 0.4 1.0 0 0 0 0.0 File IO Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_37.dbf 32 0 1.9 1.0 1 0 0 0.0 LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_46.dbf 45 0 1.3 1.0 1 0 0 0.0 LIVEAPNAINDX /lippdata3/oradata/data/LIPPDB_liveapnaindx_47.dbf 63 0 0.5 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata4/oradata/data/LIPPDB_liveapnaindx_41.dbf 24 0 0.0 1.0 1 0 0 0.0 LIVEAPNAINDX /lippdata4/oradata/data/LIPPDB_liveapnaindx_42.dbf 21 0 0.0 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata4/oradata/data/LIPPDB_liveapnaindx_43.dbf 18 0 0.6 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata4/oradata/data/LIPPDB_liveapnaindx_44.dbf 72 0 2.9 1.0 2 0 0 0.0 LIVEAPNAINDX /lippdata4/oradata/data/LIPPDB_liveapnaindx_45.dbf 51 0 2.9 1.0 2 0 0 0.0 LIVEAPNAINDX /lippdata5/oradata/data/LIPPDB_liveapnaindx_38.dbf 37 0 1.6 1.0 26 0 0 0.0 LIVEAPNAINDX /lippdata5/oradata/data/LIPPDB_liveapnaindx_39.dbf 65 0 1.1 1.0 12 0 0 0.0 LIVEAPNAINDX /lippdata5/oradata/data/LIPPDB_liveapnaindx_40.dbf 63 0 2.2 1.0 12 0 0 0.0 LIVEAPNAINDX /lippdata5/oradata/data/LIPPDB_liveapnaindx_48.dbf 81 0 0.5 1.0 0 0 0 0.0 LIVEAPNAINDX /lippdata5/oradata/data/LIPPDB_liveapnaindx_49.dbf 138 0 0.4 1.0 2 0 0 0.0 LIVEAPNAINDX /lippdata6/oradata/data/LIPPDB_liveapnaindx_50.dbf 30 0 1.7 1.0 1 0 0 0.0 LIVEAPNAINDX /lippdata6/oradata/data/LIPPDB_liveapnaindx_51.dbf 29 0 1.0 1.0 2 0 0 0.0 LIVEAPNAINDX /lippdata6/oradata/data/LIPPDB_liveapnaindx_52.dbf 227 0 1.6 1.0 22 0 0 0.0 LIVEAPNAINDX /lippdata6/oradata/data/LIPPDB_liveapnaindx_53.dbf 233 0 2.1 1.0 16 0 0 0.0 LIVEAPNAINDX /lippdata6/oradata/data/LIPPDB_liveapnaindx_54.dbf 498 0 1.7 1.0 18 0 0 0.0 LIVEAPNAINDX /lippdata6/oradata/data/LIPPDB_liveapnaindx_55.dbf 206 0 0.3 1.0 14 0 0 0.0 LIVEAPNAINDX /lippdata6/oradata/data/LIPPDB_liveapnaindx_56.dbf 42 0 0.7 1.0 1 0 0 0.0 LIVEAPNAINDX /lippdata7/oradata/data/LIPPDB_liveapnaindx_57.dbf 67 0 1.0 1.0 8 0 0 0.0 LIVEAPNAINDX /lippdata7/oradata/data/LIPPDB_liveapnaindx_58.dbf 20 0 0.0 1.0 1 0 0 0.0 LIVEAPNAINDX /lippdata8/oradata/data/LIPPDB_liveapnaindx_59.dbf 1,191 0 1.2 1.0 48 0 0 0.0 LIVEAPNAINDX /lippdata8/oradata/data/LIPPDB_liveapnaindx_60.dbf 2,450 1 0.7 1.0 227 0 0 0.0 LIVEAPNAINDX /lippdata8/oradata/data/LIPPDB_liveapnaindx_61.dbf 2,471 1 0.7 1.0 194 0 0 0.0 LIVEAPNAINDX /lippdata8/oradata/data/LIPPDB_liveapnaindx_62.dbf 2,307 1 0.7 1.0 149 0 2 65.0 LIVEAPNAINDX /lippdata8/oradata/data/LIPPDB_liveapnaindx_63.dbf 2,539 1 0.7 1.0 141 0 0 0.0 LIVEAPNAINDX /lippdata8/oradata/data/LIPPDB_liveapnaindx_64.dbf 2,460 1 0.8 1.0 108 0 0 0.0 LIVEAPNAINDX /lippdata8/oradata/data/LIPPDB_liveapnaindx_65.dbf 2,501 1 0.5 1.0 179 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_01.dbf 3,639 1 0.3 1.9 2 0 0 0.0 File IO Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_02.dbf 807 0 2.8 16.1 1 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_03.dbf 4,219 1 0.3 2.4 13 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_04.dbf 757 0 2.8 17.7 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_05.dbf 595 0 3.5 21.0 2 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_06.dbf 605 0 3.8 20.7 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_07.dbf 593 0 3.1 21.1 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_08.dbf 561 0 3.0 22.2 2 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_09.dbf 601 0 2.9 20.8 1 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_10.dbf 970 0 2.0 13.6 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_11.dbf 546 0 3.7 21.9 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_12.dbf 719 0 2.6 18.2 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_13.dbf 600 0 3.3 20.8 1 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_14.dbf 779 0 2.5 16.9 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_15.dbf 917 0 1.7 14.5 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_16.dbf 853 0 2.3 16.7 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_17.dbf 1,137 0 2.0 12.8 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_18.dbf 961 0 2.1 14.9 23 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_19.dbf 622 0 2.9 22.5 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_20.dbf 832 0 2.3 17.1 0 0 0 0.0 LIVEAPNATBS /lippdata1/oradata/data/LIPPDB_LIVEAPNATBS_21.dbf 619 0 3.3 21.8 0 0 0 0.0 LIVEAPNATBS /lippdata2/oradata/data/LIPPDB_LIVEAPNATBS_22.dbf 885 0 2.7 7.3 17 0 0 0.0 LIVEAPNATBS /lippdata2/oradata/data/LIPPDB_LIVEAPNATBS_23.dbf 609 0 4.9 11.6 18 0 0 0.0 LIVEAPNATBS /lippdata2/oradata/data/LIPPDB_LIVEAPNATBS_24.dbf 383 0 2.0 7.5 2 0 0 0.0 LIVEAPNATBS /lippdata2/oradata/data/LIPPDB_LIVEAPNATBS_25.dbf 977 0 4.8 13.7 2 0 0 0.0 LIVEAPNATBS /lippdata3/oradata/data/LIPPDB_LIVEAPNATBS_26.dbf 668 0 3.3 22.6 2 0 0 0.0 LIVEAPNATBS /lippdata3/oradata/data/LIPPDB_LIVEAPNATBS_27.dbf 592 0 3.5 24.5 29 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_28.dbf 747 0 3.1 18.3 0 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_29.dbf 624 0 3.6 20.9 0 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_30.dbf 668 0 3.2 19.6 2 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_31.dbf 520 0 3.7 23.9 2 0 0 0.0 File IO Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_32.dbf 574 0 3.8 21.7 1 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_33.dbf 629 0 3.4 19.9 1 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_34.dbf 513 0 4.2 24.2 5 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_35.dbf 589 0 3.0 21.2 8 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_36.dbf 628 0 2.9 20.0 2 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_37.dbf 590 0 3.2 21.2 1 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_38.dbf 640 0 3.6 19.6 1 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_39.dbf 770 0 2.7 16.5 23 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_40.dbf 643 0 3.3 19.5 2 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_41.dbf 798 0 2.9 17.8 16 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_42.dbf 762 0 3.1 17.9 0 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_43.dbf 438 0 4.8 30.4 2 0 0 0.0 LIVEAPNATBS /lippdata4/oradata/data/LIPPDB_LIVEAPNATBS_48.dbf 637 0 3.7 22.0 13 0 0 0.0 LIVEAPNATBS /lippdata5/oradata/data/LIPPDB_LIVEAPNATBS_44.dbf 483 0 5.0 27.7 0 0 0 0.0 LIVEAPNATBS /lippdata5/oradata/data/LIPPDB_LIVEAPNATBS_45.dbf 534 0 4.6 25.1 3 0 0 0.0 LIVEAPNATBS /lippdata5/oradata/data/LIPPDB_LIVEAPNATBS_46.dbf 667 0 3.6 21.1 0 0 0 0.0 LIVEAPNATBS /lippdata5/oradata/data/LIPPDB_LIVEAPNATBS_47.dbf 690 0 4.2 20.4 5 0 0 0.0 LIVEAPNATBS /lippdata6/oradata/data/LIPPDB_LIVEAPNATBS_49.dbf 733 0 2.6 17.2 3 0 0 0.0 LIVEAPNATBS /lippdata6/oradata/data/LIPPDB_LIVEAPNATBS_50.dbf 2,146 1 1.1 6.5 12 0 0 0.0 LIVEAPNATBS /lippdata6/oradata/data/LIPPDB_LIVEAPNATBS_51.dbf 1,684 0 1.2 8.1 3 0 0 0.0 LIVEAPNATBS /lippdata6/oradata/data/LIPPDB_LIVEAPNATBS_52.dbf 742 0 2.1 17.0 9 0 0 0.0 LIVEAPNATBS /lippdata6/oradata/data/LIPPDB_LIVEAPNATBS_53.dbf 709 0 2.2 11.5 8 0 0 0.0 LIVEAPNATBS /lippdata7/oradata/data/LIPPDB_LIVEAPNATBS_54.dbf 129 0 6.5 31.8 0 0 0 0.0 LIVEAPNATBS /lippdata8/oradata/data/LIPPDB_LIVEAPNATBS_55.dbf 2,338 1 3.6 14.6 175 0 0 0.0 LIVEAPNATBS /lippdata8/oradata/data/LIPPDB_LIVEAPNATBS_56.dbf 1,651 0 4.5 19.9 40 0 0 0.0 LIVEAPNATBS /lippdata8/oradata/data/LIPPDB_LIVEAPNATBS_57.dbf 2,439 1 3.6 13.4 112 0 0 0.0 LIVEAPNATBS /lippdata8/oradata/data/LIPPDB_LIVEAPNATBS_58.dbf 774 0 4.5 18.9 38 0 0 0.0 LIVEAPNATBS /lippdata8/oradata/data/LIPPDB_LIVEAPNATBS_59.dbf 1,294 0 4.4 15.9 42 0 0 0.0 LIVEAPNATBS /lippdata9/oradata/data/LIPPDB_LIVEAPNATBS_60.dbf 1,363 0 7.7 15.2 26 0 0 0.0 LIVEAPNATBS /lippdata9/oradata/data/LIPPDB_LIVEAPNATBS_61.dbf 1,381 0 8.1 15.0 33 0 0 0.0 File IO Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ LIVEAPNATBS /lippdata9/oradata/data/LIPPDB_LIVEAPNATBS_62.dbf 1,608 0 6.8 13.0 82 0 1 170.0 SYSAUX /lippdata7/oradata/LIPPDB_sysaux_01.dbf 25,724 7 0.0 1.0 311 0 0 0.0 SYSTEM /lippdata1/oradata/data/LIPPDB_system_01.dbf 26,344 7 0.2 1.0 72 0 713 0.0 TEMP /lippdata3/oradata/tempfile/LIPPDB_TEMP_02.dbf 992 0 0.3 15.0 992 0 0 N/A TOOLS_NEW /lippdata1/oradata/data/LIPPDB_TOOLSNEW_01.dbf 710 0 0.1 1.1 0 0 0 0.0 UNDO_TBS /lippdata3/oradata/data/LIPPDB_undo_tbs_01.dbf 0 0 N/A N/A 179 0 37 0.0 UNDO_TBS /lippdata3/oradata/data/LIPPDB_undo_tbs_03.dbf 1 0 0.0 1.0 108 0 0 0.0 UNDO_TBS /lippdata6/oradata/data/LIPPDB_undo_tbs_04.dbf 1 0 0.0 1.0 9 0 0 0.0 UNDO_TBS /lippdata7/oradata/data/LIPPDB_undo_tbs_05.dbf 1 0 0.0 1.0 49 0 0 0.0 UNDO_TBS /lippdata8/oradata/data/LIPPDB_undo_tbs_06.dbf 0 0 N/A N/A 55 0 0 0.0 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 75,202 94 16,895,047 1,056,330 5,776 0 0 854 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 28 528 2344 13231 1658880 13231 N/A E 0 27 413 2394 25085 1658880 25085 N/A ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: LIPPDB/LIPPDB Snap: 10303 -> 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 48 .1 5,937 4.0 405,332,439 D 96 .2 11,874 1.6 157,042,882 D 144 .2 17,811 1.4 145,159,481 D 192 .3 23,748 1.4 138,045,944 D 240 .4 29,685 1.3 133,007,863 D 288 .5 35,622 1.3 129,049,750 D 336 .6 41,559 1.2 125,644,117 D 384 .6 47,496 1.2 120,637,580 D 432 .7 53,433 1.1 115,265,337 D 480 .8 59,370 1.1 108,481,769 D 528 .9 65,307 1.0 104,796,281 D 576 .9 71,244 1.0 102,169,765 D 608 1.0 75,202 1.0 100,679,225 D 624 1.0 77,181 1.0 100,016,348 D 672 1.1 83,118 1.0 98,232,599 D 720 1.2 89,055 1.0 96,767,381 D 768 1.3 94,992 0.9 95,469,144 D 816 1.3 100,929 0.9 93,232,863 D 864 1.4 106,866 0.9 91,213,778 D 912 1.5 112,803 0.9 89,854,087 D 960 1.6 118,740 0.9 88,214,045 ------------------------------------------------------------- PGA Aggr Summary DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 --------------- ------------------ -------------------------- 95.7 5,868 262 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 500 138 488.3 1.6 .3 100.0 .0 102,400 E 500 120 504.4 0.0 .0 .0 .0 102,400 ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 36,839 36,839 0 0 64K 128K 122 122 0 0 128K 256K 70 70 0 0 256K 512K 5,329 5,329 0 0 512K 1024K 1,607 1,607 0 0 1M 2M 1,153 1,153 0 0 2M 4M 88 88 0 0 8M 16M 12 12 0 0 16M 32M 6 6 0 0 32M 64M 2 0 2 0 64M 128M 2 0 2 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: LIPPDB/LIPPDB Snap: 10303 -> 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 ---------- ------- ---------------- ---------------- -------- ---------- 63 0.1 595,040.3 292,462.9 67.0 12,460 125 0.3 595,040.3 292,365.4 67.0 12,448 250 0.5 595,040.3 291,656.8 67.0 12,233 375 0.8 595,040.3 245,306.1 71.0 3,796 500 1.0 595,040.3 113,455.3 84.0 339 600 1.2 595,040.3 90,862.0 87.0 187 700 1.4 595,040.3 61,932.1 91.0 143 800 1.6 595,040.3 61,496.7 91.0 89 900 1.8 595,040.3 57,748.1 91.0 19 1,000 2.0 595,040.3 50,545.8 92.0 0 1,500 3.0 595,040.3 50,545.8 92.0 0 2,000 4.0 595,040.3 50,545.8 92.0 0 3,000 6.0 595,040.3 50,545.8 92.0 0 4,000 8.0 595,040.3 50,545.8 92.0 0 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: LIPPDB/LIPPDB Snap: 10303 -> 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 ---------- ----- -------- ------------ ------- ------ ------- ------ ----------- 224 .4 66 10,083 ####### .9 69,380 12.0 92,024,139 288 .5 129 12,319 ####### 1.0 22,388 3.9 92,043,931 352 .6 192 16,017 ####### 1.0 20,601 3.6 92,046,889 416 .7 255 19,795 ####### 1.0 20,572 3.6 92,048,219 480 .8 318 23,621 ####### 1.0 20,552 3.6 92,049,293 544 .9 381 27,207 ####### 1.0 17,789 3.1 92,051,367 608 1.0 444 30,046 ####### 1.0 5,761 1.0 92,053,180 672 1.1 507 32,835 ####### 1.0 5,746 1.0 92,053,779 736 1.2 570 36,348 ####### 1.0 3,020 .5 92,054,865 800 1.3 633 39,501 ####### 1.0 3,014 .5 92,055,372 864 1.4 696 42,570 ####### 1.0 3,010 .5 92,055,799 928 1.5 759 45,725 ####### 1.0 3,005 .5 92,056,284 992 1.6 822 49,150 ####### 1.0 187 .0 92,056,714 1,056 1.7 885 52,734 ####### 1.0 1 .0 92,057,064 1,120 1.8 948 56,493 ####### 1.0 1 .0 92,057,229 1,184 1.9 1,011 60,122 ####### 1.0 1 .0 92,057,395 1,248 2.1 1,074 63,969 ####### 1.0 1 .0 92,057,576 ------------------------------------------------------------- SGA Target Advisory DB/Inst: LIPPDB/LIPPDB Snap: 10303 No data exists for this section of the report. ------------------------------------------------------------- Streams Pool Advisory DB/Inst: LIPPDB/LIPPDB Snap: 10303 Size for Size Est Spill Est Spill Est Unspill Est Unspill Est (MB) Factor Count Time (s) Count Time (s) ---------- --------- ----------- ----------- ----------- ----------- 16 1.0 0 0 0 0 32 2.0 0 0 0 0 48 3.0 0 0 0 0 64 4.0 0 0 0 0 80 5.0 0 0 0 0 96 6.0 0 0 0 0 112 7.0 0 0 0 0 128 8.0 0 0 0 0 144 9.0 0 0 0 0 160 10.0 0 0 0 0 176 11.0 0 0 0 0 192 12.0 0 0 0 0 208 13.0 0 0 0 0 224 14.0 0 0 0 0 240 15.0 0 0 0 0 256 16.0 0 0 0 0 272 17.0 0 0 0 0 288 18.0 0 0 0 0 304 19.0 0 0 0 0 320 20.0 0 0 0 0 ------------------------------------------------------------- Java Pool Advisory DB/Inst: LIPPDB/LIPPDB Snap: 10303 No data exists for this section of the report. ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> ordered by wait time desc, waits desc Class Waits Total Wait Time (s) Avg Time (ms) ------------------ ----------- ------------------- -------------- data block 817 3 4 undo header 37 0 0 ------------------------------------------------------------- Enqueue Activity DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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) ------------ ------------ ----------- ----------- ------------ -------------- TX-Transaction (row lock contention) 4 2 0 4 250 62,484.50 TX-Transaction 9,879 9,879 0 1 0 43.00 ------------------------------------------------------------- Undo Segment Summary DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 ---- ---------- --------------- -------- -------- --------- ----- -------------- 1 .8 9,885 290 6 5760/5760 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 ------------ ----------- ------------ ------- ------- ------- ----- ------------ 28-Jul 14:27 113 1,568 115 6 5,760 0/0 0/0/0/0/0/0 28-Jul 14:17 123 1,509 83 6 5,760 0/0 0/0/0/0/0/0 28-Jul 14:07 148 2,577 144 6 5,760 0/0 0/0/0/0/0/0 28-Jul 13:57 102 1,333 62 6 5,760 0/0 0/0/0/0/0/0 28-Jul 13:47 101 1,362 76 5 5,760 0/0 0/0/0/0/0/0 28-Jul 13:37 166 1,536 290 6 5,760 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Latch Activity DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> "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 db client latch 2,386 0.0 N/A 0 0 N/A AWR Alerted Metric Eleme 42,852 0.0 N/A 0 0 N/A Consistent RBA 6,394 0.0 N/A 0 0 N/A FAL request queue 73 0.0 N/A 0 0 N/A FAL subheap alocation 73 0.0 N/A 0 0 N/A FOB s.o list latch 3,438 0.0 N/A 0 0 N/A JS queue state obj latch 21,630 0.0 N/A 0 0 N/A KMG MMAN ready and start 1,200 0.0 N/A 0 0 N/A KTF sga latch 8 0.0 N/A 0 995 0.0 KWQMN job cache list lat 4 0.0 N/A 0 0 N/A KWQP Prop Status 2 0.0 N/A 0 0 N/A MQL Tracking Latch 0 N/A N/A 0 72 0.0 Memory Management Latch 0 N/A N/A 0 1,200 0.0 OS process 420 0.0 N/A 0 0 N/A OS process allocation 1,481 0.0 N/A 0 0 N/A OS process: request allo 273 0.0 N/A 0 0 N/A PL/SQL warning settings 2,363 0.0 N/A 0 0 N/A SGA IO buffer pool latch 26,413 0.0 N/A 0 26,413 0.0 SQL memory manager latch 1 0.0 N/A 0 1,193 0.0 SQL memory manager worka 204,577 0.0 0.0 0 0 N/A Shared B-Tree 131 0.0 N/A 0 0 N/A active checkpoint queue 2,087 0.0 N/A 0 0 N/A active service list 10,925 0.0 0.0 0 1,199 0.1 archive control 83 0.0 N/A 0 0 N/A archive process latch 1,926 0.0 N/A 0 0 N/A begin backup scn array 5 0.0 N/A 0 0 N/A cache buffer handles 5,374 0.0 N/A 0 0 N/A cache buffers chains 33,078,521 0.0 0.0 0 1,997,181 0.0 cache buffers lru chain 36,813 0.0 0.0 0 2,173,312 0.0 cache table scan latch 0 N/A N/A 0 27,427 0.0 channel handle pool latc 279 0.0 N/A 0 0 N/A channel operations paren 17,221 0.0 N/A 0 0 N/A checkpoint queue latch 115,938 0.0 N/A 0 5,646 0.0 client/application info 5,500 0.0 N/A 0 0 N/A commit callback allocati 4 0.0 N/A 0 0 N/A compile environment latc 111,503 0.0 N/A 0 0 N/A dml lock allocation 58,373 0.4 0.0 0 0 N/A dummy allocation 2,193 0.0 N/A 0 0 N/A enqueue hash chains 201,155 0.1 0.0 0 418 0.0 enqueues 210,352 0.1 0.0 0 0 N/A event group latch 137 0.0 N/A 0 0 N/A file cache latch 309 0.0 N/A 0 0 N/A global KZLD latch for me 127 0.0 N/A 0 0 N/A global tx hash mapping 19,204 0.0 N/A 0 1 0.0 hash table column usage 139 0.0 N/A 0 80,440 0.0 hash table modification 85 0.0 N/A 0 0 N/A job workq parent latch 1 0.0 N/A 0 1,682 6.3 job_queue_processes para 300 0.0 N/A 0 0 N/A kks stats 4,592 0.0 N/A 0 0 N/A ksuosstats global area 243 0.0 N/A 0 0 N/A ktm global data 14 0.0 N/A 0 0 N/A kwqbsn:qsga 130 0.0 N/A 0 0 N/A lgwr LWN SCN 6,493 0.0 0.0 0 0 N/A library cache 1,524,621 0.2 0.0 0 3,445 0.0 library cache load lock 658 0.0 N/A 0 0 N/A library cache lock 93,651 1.1 0.0 0 0 N/A library cache lock alloc 8,580 0.0 N/A 0 0 N/A library cache pin 202,380 0.1 0.0 0 0 N/A library cache pin alloca 345 0.0 N/A 0 0 N/A list of block allocation 2,507 0.0 N/A 0 0 N/A Latch Activity DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ loader state object free 24 0.0 N/A 0 0 N/A logminer context allocat 1 0.0 N/A 0 0 N/A longop free list parent 2 0.0 N/A 0 2 0.0 message pool operations 6 0.0 N/A 0 0 N/A messages 44,655 0.0 0.0 0 0 N/A mostly latch-free SCN 6,494 0.0 0.0 0 0 N/A multiblock read objects 55,274 0.0 N/A 0 0 N/A ncodef allocation latch 57 0.0 N/A 0 0 N/A object queue header heap 32,858 0.0 N/A 0 11,033 0.0 object queue header oper 2,168,802 0.0 0.0 0 0 N/A object stats modificatio 10 0.0 N/A 0 0 N/A parallel query alloc buf 480 0.0 N/A 0 0 N/A parameter list 12 0.0 N/A 0 0 N/A parameter table allocati 1,122 0.1 0.0 0 0 N/A post/wait queue 17,329 0.7 0.0 0 5,688 0.0 process allocation 273 0.0 N/A 0 137 0.0 process group creation 273 0.0 N/A 0 0 N/A qmn task queue latch 512 0.0 N/A 0 0 N/A redo allocation 164,352 0.0 0.0 0 0 N/A redo copy 0 N/A N/A 0 151,466 0.1 redo writing 23,795 0.0 N/A 0 0 N/A resmgr group change latc 1,108 0.0 N/A 0 0 N/A resmgr:actses active lis 2,190 0.0 N/A 0 0 N/A resmgr:actses change gro 1,094 0.0 N/A 0 0 N/A resmgr:free threads list 2,189 0.0 N/A 0 0 N/A resmgr:schema config 1 0.0 N/A 0 0 N/A row cache objects 805,638 0.7 0.0 0 6 0.0 rules engine aggregate s 2 0.0 N/A 0 0 N/A rules engine rule set st 104 0.0 N/A 0 0 N/A sequence cache 5,035 0.0 N/A 0 0 N/A session allocation 293,965 0.1 0.0 0 0 N/A session idle bit 1,702,147 0.0 0.0 0 0 N/A session state list latch 2,196 0.0 N/A 0 0 N/A session switching 57 0.0 N/A 0 0 N/A session timer 1,200 0.0 N/A 0 0 N/A shared pool 130,238 0.4 0.0 0 0 N/A shared pool sim alloc 11 0.0 N/A 0 0 N/A shared pool simulator 44,197 0.0 N/A 0 0 N/A simulator hash latch 1,263,961 0.0 0.0 0 0 N/A simulator lru latch 1,075,691 0.0 0.0 0 81,268 0.0 slave class 2 0.0 N/A 0 0 N/A slave class create 8 12.5 1.0 0 0 N/A sort extent pool 232 0.0 N/A 0 0 N/A state object free list 2 0.0 N/A 0 0 N/A statistics aggregation 112 0.0 N/A 0 0 N/A temp lob duration state 2 0.0 N/A 0 0 N/A threshold alerts latch 440 0.0 N/A 0 0 N/A transaction allocation 64,053 0.0 0.0 0 0 N/A transaction branch alloc 11,638 0.0 0.0 0 0 N/A undo global data 596,461 0.0 0.0 0 0 N/A user lock 2,426 0.0 0.0 0 0 N/A ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> ordered by misses desc Latch Name ---------------------------------------- Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3 -------------- ----------- ----------- ---------- -------- -------- -------- cache buffers chains 33,078,521 9,437 64 9,378 0 0 0 slave class create 8 1 1 0 0 0 0 ------------------------------------------------------------- Latch Miss Sources DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- cache buffers chains kcbchg: kslbegin: bufs not 0 286 196 cache buffers chains kcbgtcr: kslbegin excl 0 110 25 cache buffers chains kcbgcur: kslbegin 0 47 20 cache buffers chains kcbgtcr: fast path 0 3 4 cache buffers chains kcbrls: kslbegin 0 3 47 cache buffers chains kcbchg: kslbegin: call CR 0 2 143 cache buffers chains kcbzwb 0 1 2 slave class create ksvcreate 0 1 0 ------------------------------------------------------------- Parent Latch Statistics DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Total Logical Reads: 16,898,042 -> Captured Segments account for 91.9% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- LIVEALUSER ATLAS_ADMI ADM_USERS TABLE 3,643,328 21.56 LIVEALUSER LIVEAPNATB APR_PROFILE_REGION_C INDEX 2,056,448 12.17 LIVEALUSER ATLAS_TS TS_OPPORTUNITY_DETAI TABLE 1,783,488 10.55 LIVEALUSER ATLAS_ADMI ADM_PINCODE_MASTER TABLE 1,085,696 6.42 LIVEALUSER LIVEAPNATB TS_DOCTOR_MASTER TABLE 923,488 5.47 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Total Physical Reads: 1,071,221 -> Captured Segments account for 85.8% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- LIVEALUSER LIVEAPNATB IN_REACH_CUSTOMER_DT TABLE 790,916 73.83 LIVEALUSER ATLAS_TS TS_OPPORTUNITY_DETAI TABLE 30,188 2.82 LIVEALUSER ATLAS_ADMI ADM_LOGIN_AUDIT TABLE 21,828 2.04 LIVEALUSER LIVEAPNATB IN_REACH_APPLICATION TABLE 20,888 1.95 LIVEALUSER ATLAS_DM DM_OPPORTUNITY_DETAI TABLE 18,878 1.76 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- LIVEALUSER ATLAS_DM PK_DM_OPPORTUNITY_DE INDEX 5 26.32 LIVEALUSER ATLAS_ADMI ADM_USERS TABLE 4 21.05 LIVEALUSER LIVEAPNATB SYS_C002789 INDEX 4 21.05 LIVEALUSER LIVEAPNATB GL_INT_USER TABLE 2 10.53 LIVEALUSER ATLAS_ADMI IDX_USER_SESSION INDEX 2 10.53 ------------------------------------------------------------- Segments by ITL Waits DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 No data exists for this section of the report. ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> % of Capture shows % of Buffer Busy Waits for each top segment compared -> with total Buffer Busy Waits for all segments captured by the Snapshot Buffer Tablespace Subobject Obj. Busy % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM JOB$ TABLE 705 96.97 LIVEALUSER ATLAS_ADMI ADM_USERS TABLE 22 3.03 ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> "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 66 0.0 0 N/A 2 1 dc_database_links 5,072 0.0 0 N/A 0 5 dc_files 8,360 0.0 0 N/A 0 190 dc_global_oids 28 0.0 0 N/A 0 16 dc_histogram_data 474 0.0 0 N/A 0 225 dc_histogram_defs 11,935 1.4 0 N/A 0 1,547 dc_object_grants 18 33.3 0 N/A 0 21 dc_object_ids 26,900 0.1 0 N/A 0 949 dc_objects 2,453 3.8 0 N/A 0 741 dc_profiles 1,087 0.0 0 N/A 0 2 dc_rollback_segments 2,489 0.0 0 N/A 0 75 dc_segments 8,188 0.2 0 N/A 0 708 dc_sequences 2,138 0.3 0 N/A 2,138 38 dc_tablespaces 118,570 0.0 0 N/A 0 14 dc_usernames 355 0.0 0 N/A 0 5 dc_users 81,822 0.0 0 N/A 0 27 outstanding_alerts 187 0.5 0 N/A 2 29 ------------------------------------------------------------- Library Cache Activity DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 28 0.0 11,996 0.0 0 0 CLUSTER 27 0.0 38 0.0 0 0 INDEX 1 0.0 15 0.0 0 0 SQL AREA 357 97.5 437,741 0.3 154 31 TABLE/PROCEDURE 2,059 5.0 88,903 0.4 66 0 ------------------------------------------------------------- Process Memory Summary DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 Other 351.1 N/A 1.1 2.1 22 321 309 309 SQL 68.4 30.1 .2 .2 2 13 301 292 Freeable 59.9 .0 .5 .4 2 N/A 123 123 PL/SQL 8.9 5.9 .0 .0 0 299 309 309 E Other 360.8 N/A 1.2 2.1 22 321 311 311 SQL 70.6 30.0 .2 .2 1 22 303 294 Freeable 63.4 .0 .5 .4 2 N/A 126 126 PL/SQL 9.2 6.0 .0 .0 0 299 311 311 ------------------------------------------------------------- SGA Memory Summary DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 637,534,208 Fixed Size 2,032,448 Redo Buffers 14,737,408 Variable Size 1,979,718,848 ------------------- sum 2,634,022,912 ------------------------------------------------------------- SGA breakdown difference DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> 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 free memory 144.0 144.0 0.00 shared ASH buffers 15.5 15.5 0.00 shared CCursor 63.5 62.3 -1.90 shared FileOpenBlock 6.1 6.1 0.00 shared PCursor 43.8 43.1 -1.59 shared event statistics per sess 6.8 6.8 0.00 shared free memory 46.5 49.0 5.36 shared kglsim object batch 9.0 9.1 0.37 shared library cache 48.9 48.7 -0.58 shared row cache 7.2 7.2 0.00 shared sql area 272.0 269.7 -0.87 stream free memory 16.0 16.0 0.00 buffer_cache 608.0 608.0 0.00 fixed_sga 1.9 1.9 0.00 log_buffer 14.1 14.1 0.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Streams processes ordered by CPU usage -> CPU and I/O Time in micro seconds Session Type CPU Time User I/O Time Sys I/O Time ------------------------- -------------- -------------- -------------- QMON Coordinator 29,988 0 0 QMON Slaves 24,816 0 0 ------------------------------------------------------------- Streams Capture DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 No data exists for this section of the report. ------------------------------------------------------------- Buffered Subscribers DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 -> Rule Sets ordered by Evaluations Fast SQL CPU Elapsed Ruleset Name Evals Evals Execs Time Time ------------------------- -------- -------- -------- -------- -------- SYS.ALERT_QUE_R 2 0 0 0 0 ------------------------------------------------------------- Resource Limit Stats DB/Inst: LIPPDB/LIPPDB Snap: 10303 No data exists for this section of the report. ------------------------------------------------------------- init.ora Parameters DB/Inst: LIPPDB/LIPPDB Snaps: 10302-10303 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- O7_DICTIONARY_ACCESSIBILITY FALSE _fast_full_scan_enabled FALSE _kgl_large_heap_warning_thres 8388608 audit_sys_operations TRUE audit_trail TRUE background_dump_dest /lippdata1/oradata/dump/bdump blank_trimming TRUE compatible 9.2.0.5 control_files /lippdata1/oradata/cntrl/LIPPDB_0 core_dump_dest /lippdata1/oradata/dump/cdump db_block_size 8192 db_cache_size 637534208 db_domain iciciprulife.com db_file_multiblock_read_count 32 db_files 200 db_name LIPPDB disk_asynch_io FALSE dml_locks 200 ifile /lippdata1/oradata/pfile/configLI instance_name LIPPDB java_pool_size 167772160 job_queue_processes 5 large_pool_size 150994944 log_archive_dest_1 LOCATION=/lipparch/LIPPDB log_archive_dest_state_2 defer log_archive_format LIPPDB_%t_%s.arc log_archive_min_succeed_dest 1 log_archive_trace 255 log_buffer 14290432 log_checkpoints_to_alert TRUE max_dump_file_size 10485760 open_cursors 500 optimizer_index_caching 20 optimizer_mode CHOOSE pga_aggregate_target 524288000 processes 700 remote_login_passwordfile NONE resource_limit FALSE session_cached_cursors 300 session_max_open_files 20 sessions 775 sga_max_size 2634022912 shared_pool_size 637534208 streams_pool_size 16777216 timed_statistics TRUE undo_management AUTO undo_retention 5036 undo_tablespace UNDO_TBS user_dump_dest /lippdata1/oradata/dump/udump utl_file_dir /lippdata1/oradata/dump/utl ------------------------------------------------------------- End of Report