STATSPACK report for DB Name DB Id Instance Inst Num Release OPS Host ------------ ----------- ------------ -------- ----------- --- ------------ STY_PROD 3285921907 STY_PROD 1 8.1.7.4.0 NO spaceserverE 2900 Snap Id Snap Time Sessions ------- ------------------ -------- Begin Snap: 1391 17-Dec-06 14:30:02 241 End Snap: 1392 17-Dec-06 14:45:21 241 Elapsed: 15.32 (mins) Cache Sizes ~~~~~~~~~~~ db_block_buffers: 286720 log_buffer: 1048576 db_block_size: 8192 shared_pool_size: 838860800 Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 11,092.40 2,388.45 Logical reads: 18,830.88 4,054.73 Block changes: 66.96 14.42 Physical reads: 10,416.95 2,243.01 Physical writes: 57.78 12.44 User calls: 696.52 149.98 Parses: 59.32 12.77 Hard parses: 0.77 0.17 Sorts: 22.77 4.90 Logons: 0.18 0.04 Executes: 305.91 65.87 Transactions: 4.64 % Blocks changed per Read: 0.36 Recursive Call %: 9.04 Rollback per transaction %: 1.45 Rows per Sort: 127.28 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 99.98 Redo NoWait %: 100.00 Buffer Hit %: 44.68 In-memory Sort %: 99.99 Library Hit %: 99.75 Soft Parse %: 98.70 Execute to Parse %: 80.61 Latch Hit %: 99.95 Parse CPU to Parse Elapsd %: 90.07 % Non-Parse CPU: 98.27 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 92.85 95.03 % SQL with executions>1: 47.17 46.90 % Memory for SQL w/exec>1: 36.06 35.96 Top 5 Wait Events ~~~~~~~~~~~~~~~~~ Wait % Total Event Waits Time (cs) Wt Time -------------------------------------------- ------------ ------------ ------- db file sequential read 287,607 65,666 53.64 db file scattered read 958,058 32,167 26.28 log file sync 4,291 9,700 7.92 db file parallel write 400 6,372 5.21 log file parallel write 4,345 3,206 2.62 ------------------------------------------------------------- Wait Events for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> ordered by wait time desc, waits desc (idle events last) Avg Total Wait wait Waits Event Waits Timeouts Time (cs) (ms) /txn ---------------------------- ------------ ---------- ----------- ------ ------ db file sequential read 287,607 0 65,666 2 67.4 db file scattered read 958,058 0 32,167 0 224.5 log file sync 4,291 0 9,700 23 1.0 db file parallel write 400 0 6,372 159 0.1 log file parallel write 4,345 0 3,206 7 1.0 buffer busy waits 2,820 0 1,563 6 0.7 direct path write 391 0 1,205 31 0.1 control file parallel write 296 0 703 24 0.1 latch free 504 444 414 8 0.1 direct path read 781 0 389 5 0.2 SQL*Net more data to client 85,079 0 328 0 19.9 SQL*Net message from dblink 288 0 275 10 0.1 SQL*Net break/reset to clien 64 0 80 13 0.0 local write wait 19 0 71 37 0.0 enqueue 7 0 46 66 0.0 file open 734 0 18 0 0.2 control file sequential read 97 0 14 1 0.0 SQL*Net more data from dblin 201 0 11 1 0.0 refresh controlfile command 10 0 2 2 0.0 SQL*Net message to dblink 288 0 0 0 0.1 LGWR wait for redo copy 6 0 0 0 0.0 SQL*Net message from client 643,466 0 16,121,198 251 150.8 SQL*Net more data from clien 1,571 0 564 4 0.4 SQL*Net message to client 643,476 0 136 0 150.8 ------------------------------------------------------------- Background Wait Events for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> ordered by wait time desc, waits desc (idle events last) Avg Total Wait wait Waits Event Waits Timeouts Time (cs) (ms) /txn ---------------------------- ------------ ---------- ----------- ------ ------ db file parallel write 400 0 6,372 159 0.1 log file parallel write 4,345 0 3,206 7 1.0 control file parallel write 296 0 703 24 0.1 db file scattered read 73 0 52 7 0.0 db file sequential read 84 0 37 4 0.0 control file sequential read 20 0 2 1 0.0 latch free 2 1 1 5 0.0 LGWR wait for redo copy 6 0 0 0 0.0 rdbms ipc message 13,523 836 543,820 402 3.2 smon timer 3 3 92,160 ###### 0.0 pmon timer 302 297 92,090 3049 0.1 ------------------------------------------------------------- SQL ordered by Gets for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> End Buffer Gets Threshold: 10000 -> Note that resources reported for PL/SQL includes the resources used by all SQL statements called within the PL/SQL code. As individual SQL statements are also reported, it is possible and valid for the summed total % to exceed 100 Buffer Gets Executions Gets per Exec % Total Hash Value --------------- ------------ -------------- ------- ------------ 7,035,325 405 17,371.2 40.7 663098444 select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.PRIORITY ,TO_CHAR (M1.ACTION_DATE,'YYYYMMDDHH24MISS') ,M1.GMD_MARKET_ID ,M1.SCCODE ,M1.PLCODE ,M1.SWITCH_ID ,M1.CO_ID ,M1.DATA_1 ,M1.DATA_2 ,M1.DA TA_3 from MDSRRTAB M1 where WORKER_PID=:b0 order by M1.REQUEST 1,320,915 76 17,380.5 7.6 1719834099 select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.CO_ID ,M1.CUSTOME R_ID ,GM.CLEAN_UP_LEVEL ,GA.ACTION_DES from MDSRRTAB M1 ,GMD_MP DSCTAB GM ,GMD_ACTION GA where ((M1.WORKER_PID=:b0 and GM.SCCODE =M1.SCCODE) and GA.ACTION_ID=M1.ACTION_ID) order by REQUEST 886,116 13,565 65.3 5.1 2396689924 SELECT NVL(SUM(NVL(A.OHINVAMT_DOC,0)),0) FROM MY_EN_ORDER1 A WHERE A.OHREFDATE <= :b1 AND A.CUSTOMER_ID = :b2 AND A.OHSTATU S IN ( 'FC2','IN','CO2','CM','CA','PR','AO','WR' ) 729,725 42 17,374.4 4.2 3803431912 select M1.REQUEST ,M1.STATUS ,M1.VMD_RETRY ,M1.ERROR_RETRY ,M1.S WITCH_ID ,M1.CO_ID ,M1.CUSTOMER_ID ,GA.ACTION_ID ,GA.ACTION_DES ,GM.BYPASS_IND from MDSRRTAB M1 ,GMD_ACTION GA ,GMD_MPDSCTAB GM where ((M1.WORKER_PID=:b0 and M1.ACTION_ID=GA.ACTION_ID) and M1 .SCCODE=GM.SCCODE) order by M1.REQUEST 631,398 90 7,015.5 3.6 1277915488 select FLCODE ,nvl(PLCODE,0) ,nvl(FLSLPX,'***') ,nvl(FLSQN,0) ,F LNAME ,FLIRC ,FLRRC ,FLIMT ,FLRMT ,FLSTA ,nvl(FLJOB,0) into :b0, :b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10 from MPUFCTAB M where ((FLSTA=:b11 or FLSTA=:b12) and TO_DATE(:b13,'YYYYMMDDHH24MISS') >=nvl(FLLCT,TO_DATE('40000101000000','YYYYMMDDHH24MISS'))) order 628,268 405 1,551.3 3.6 612157230 update MDSRRTAB M1 set M1.WORKER_PID=:b0,TS=SYSDATE where ((((( (M1.STATUS in (2,10) and M1.ACTION_DATE<=SYSDATE) and M1.REQUEST >:b1) and M1.WORKER_PID=0) and M1.SWITCH_ID not in (select GSS. SWITCH_ID from GMD_SWITCH_STATE GSS where (GSS.SWITCH_LOCK_STAT E='D' or GSS.SWITCH_LOCK_STATE='R'))) and ROWNUM<=:b2) and not 559,287 878 637.0 3.2 613859289 select count(REQUEST) into :b0 from VMD_QUEUE where (STATUS>0 a nd DEVICE=:b1) 378,929 13,542 28.0 2.2 742947438 SELECT MAX(OHREFNUM) FROM ORDERHDR_ALL A WHERE A.OHREFDATE <= :b1 AND A.CUSTOMER_ID = :b2 AND A.OHSTATUS IN ( 'IN','CM' ) 378,693 13,535 28.0 2.2 208369243 SELECT NVL(SUM(NVL(OHINVAMT_DOC,0)),0) FROM ORDERHDR_ALL A WH ERE A.OHREFDATE <= :b1 AND A.CUSTOMER_ID = :b2 AND A.OHSTATUS SQL ordered by Gets for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> End Buffer Gets Threshold: 10000 -> Note that resources reported for PL/SQL includes the resources used by all SQL statements called within the PL/SQL code. As individual SQL statements are also reported, it is possible and valid for the summed total % to exceed 100 Buffer Gets Executions Gets per Exec % Total Hash Value --------------- ------------ -------------- ------- ------------ IN ( 'IN','CM' ) 342,122 13,554 25.2 2.0 4153999493 SELECT NVL(SUM(CACHKAMT_PAY),0) FROM CASHRECEIPTS_ALL WHERE C USTOMER_ID = :b1 AND CATYPE IN ( 12 ) AND CACHKDATE <= :b2 341,680 13,543 25.2 2.0 1187558410 SELECT NVL(SUM(DECODE(SIGN(CACHKAMT_PAY),-1,CACHKAMT_PAY,0)),0) FROM CASHRECEIPTS_ALL WHERE CUSTOMER_ID = :b1 AND CATYPE IN ( 10 ) AND CACHKDATE <= :b2 341,237 13,530 25.2 2.0 913977543 SELECT NVL(SUM(NVL(CACHKAMT_PAY,0)),0) FROM CASHRECEIPTS_ALL WHERE CUSTOMER_ID = :b1 AND CATYPE NOT IN ( 5,10,12 ) AND CACH KDATE <= :b2 327,454 13,562 24.1 1.9 3024234896 SELECT NVL(SUM(DECODE(MY_NEWDUECLASS_1(OHREFDATE,:b1),1,NVL(OHIN VAMT_DOC,0),0)),0) GE0_L30,NVL(SUM(DECODE(MY_NEWDUECLASS_1(OHREF DATE,:b1),2,NVL(OHINVAMT_DOC,0),0)),0) GE30_L60,NVL(SUM(DECODE(M Y_NEWDUECLASS_1(OHREFDATE,:b1),3,NVL(OHINVAMT_DOC,0),0)),0) GE60 _L90,NVL(SUM(DECODE(MY_NEWDUECLASS_1(OHREFDATE,:b1),4,NVL(OHINVA 296,019 1 296,019.0 1.7 3376831664 BEGIN statspack.snap; END; 282,369 1 282,369.0 1.6 625421128 INSERT INTO STATS$SQLTEXT ( HASH_VALUE,TEXT_SUBSET,PIECE,SQL_TEX T,ADDRESS,COMMAND_TYPE,LAST_SNAP_ID ) SELECT ST1.HASH_VALUE,SS. TEXT_SUBSET,ST1.PIECE,ST1.SQL_TEXT,ST1.ADDRESS,ST1.COMMAND_TYPE, SS.SNAP_ID FROM V$SQLTEXT ST1,STATS$SQL_SUMMARY SS WHERE SS.S NAP_ID = :b1 AND SS.DBID = :b2 AND SS.INSTANCE_NUMBER = :b3 A 280,917 441 637.0 1.6 3198971203 select REQUEST ,EVENT_CODE ,SENDER ,CMD_FNAME ,MARKET ,STATUS f rom VMD_QUEUE where ((STATUS<0 and STATUS>:b0) and DEVICE=:b1) o rder by INDATE asc 211,829 3 70,609.7 1.2 2322418216 UPDATE customer_all SET cstestbillrun = NULL WHERE cstestbillr un IS NOT NULL 201,099 13,538 14.9 1.2 3291922290 SELECT COUNT(NVL(C2.CO_ID,0)) FROM CURR_CO_STATUS C2 WHERE C2 .CO_ID = :b1 AND C2.CH_STATUS IN ( 'a','s' ) 161,161 253 637.0 0.9 2350359349 select REQUEST ,EVENT_CODE ,SENDER ,CMD_FNAME ,MARKET ,STATUS f rom VMD_QUEUE where ((STATUS<0 and STATUS>:b0) and DEVICE=:b1) o rder by Priority desc ,INDATE asc SQL ordered by Gets for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> End Buffer Gets Threshold: 10000 -> Note that resources reported for PL/SQL includes the resources used by all SQL statements called within the PL/SQL code. As individual SQL statements are also reported, it is possible and valid for the summed total % to exceed 100 Buffer Gets Executions Gets per Exec % Total Hash Value --------------- ------------ -------------- ------- ------------ ------------------------------------------------------------- SQL ordered by Reads for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> End Disk Reads Threshold: 1000 Physical Reads Executions Reads per Exec % Total Hash Value --------------- ------------ -------------- ------- ------------ 6,303,827 405 15,565.0 65.8 663098444 select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.PRIORITY ,TO_CHAR (M1.ACTION_DATE,'YYYYMMDDHH24MISS') ,M1.GMD_MARKET_ID ,M1.SCCODE ,M1.PLCODE ,M1.SWITCH_ID ,M1.CO_ID ,M1.DATA_1 ,M1.DATA_2 ,M1.DA TA_3 from MDSRRTAB M1 where WORKER_PID=:b0 order by M1.REQUEST 1,181,056 76 15,540.2 12.3 1719834099 select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.CO_ID ,M1.CUSTOME R_ID ,GM.CLEAN_UP_LEVEL ,GA.ACTION_DES from MDSRRTAB M1 ,GMD_MP DSCTAB GM ,GMD_ACTION GA where ((M1.WORKER_PID=:b0 and GM.SCCODE =M1.SCCODE) and GA.ACTION_ID=M1.ACTION_ID) order by REQUEST 644,235 42 15,338.9 6.7 3803431912 select M1.REQUEST ,M1.STATUS ,M1.VMD_RETRY ,M1.ERROR_RETRY ,M1.S WITCH_ID ,M1.CO_ID ,M1.CUSTOMER_ID ,GA.ACTION_ID ,GA.ACTION_DES ,GM.BYPASS_IND from MDSRRTAB M1 ,GMD_ACTION GA ,GMD_MPDSCTAB GM where ((M1.WORKER_PID=:b0 and M1.ACTION_ID=GA.ACTION_ID) and M1 .SCCODE=GM.SCCODE) order by M1.REQUEST 582,781 90 6,475.3 6.1 1277915488 select FLCODE ,nvl(PLCODE,0) ,nvl(FLSLPX,'***') ,nvl(FLSQN,0) ,F LNAME ,FLIRC ,FLRRC ,FLIMT ,FLRMT ,FLSTA ,nvl(FLJOB,0) into :b0, :b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10 from MPUFCTAB M where ((FLSTA=:b11 or FLSTA=:b12) and TO_DATE(:b13,'YYYYMMDDHH24MISS') >=nvl(FLLCT,TO_DATE('40000101000000','YYYYMMDDHH24MISS'))) order 202,191 3 67,397.0 2.1 2322418216 UPDATE customer_all SET cstestbillrun = NULL WHERE cstestbillr un IS NOT NULL 114,652 18 6,369.6 1.2 282035397 SELECT MAX(PRINTDATE),COUNT(*) CNT FROM MY_PRINT_STATUS WHERE REPNO = :b1 AND VOUCHERNO = NVL(:b2,VOUCHERNO) AND VOUCHTYPE = :b3 84,249 4 21,062.3 0.9 562963853 SELECT MAX(CO_ID),MAX(CUSTOMER_ID) FROM CUSTTELNUM A WHERE DN _NUM = :b1 68,500 1 68,500.0 0.7 492143311 select count(*) from customer_all where cstestbillrun = 'A' 27,958 1 27,958.0 0.3 2505986860 SELECT F.DN_NUM GSM, B.CO_ID, D.PORT_NUM OLD_IMSI, C.PORT_NUM NE W_IMSI, TRUNC(B.CD_ACTIV_DATE) DATE_OF_CHANGE FROM CONTR_DEVICE S A, CONTR_DEVICES B, PORT C, PORT D, CONTR_SERVICES_CAP E, DIRE CTORY_NUMBER F WHERE SUBSTR(B.CD_SM_NUM,1,1) = '8' AND B.CD_SE QNO > 1 AND TRUNC(B.CD_ACTIV_DATE) > TO_DATE('14/12/2006','DD/M 27,531 1 27,531.0 0.3 2927264741 SELECT F.DN_NUM GSM, B.CO_ID, D.PORT_NUM OLD_IMSI, C.PORT_NUM NE W_IMSI, TRUNC(B.CD_ACTIV_DATE) DATE_OF_CHANGE FROM CONTR_DEVICE S A, CONTR_DEVICES B, PORT C, PORT D, CONTR_SERVICES_CAP E, DIRE SQL ordered by Reads for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> End Disk Reads Threshold: 1000 Physical Reads Executions Reads per Exec % Total Hash Value --------------- ------------ -------------- ------- ------------ CTORY_NUMBER F WHERE SUBSTR(B.CD_SM_NUM,1,1) = '0' AND B.CD_SE QNO > 1 AND TRUNC(B.CD_ACTIV_DATE) > TO_DATE('14/12/2006','DD/M 26,727 1 26,727.0 0.3 3725072785 SELECT F.DN_NUM GSM, B.CO_ID, D.PORT_NUM OLD_IMSI, C.PORT_NUM NE W_IMSI, TRUNC(B.CD_ACTIV_DATE) DATE_OF_CHANGE FROM CONTR_DEVICE S A, CONTR_DEVICES B, PORT C, PORT D, CONTR_SERVICES_CAP E, DIRE CTORY_NUMBER F WHERE SUBSTR(B.CD_SM_NUM,1,1) = '0' AND B.CD_SE QNO > 1 AND B.CD_ACTIV_DATE >= TO_DATE('15/12/2006','DD/MM/YYYY 26,116 1 26,116.0 0.3 3074616 SELECT F.DN_NUM GSM, B.CO_ID, D.PORT_NUM OLD_IMSI, C.PORT_NUM NE W_IMSI, TRUNC(B.CD_ACTIV_DATE) DATE_OF_CHANGE FROM CONTR_DEVICE S A, CONTR_DEVICES B, PORT C, PORT D, CONTR_SERVICES_CAP E, DIRE CTORY_NUMBER F WHERE SUBSTR(B.CD_SM_NUM,1,1) = '0' AND B.CD_SE QNO > 1 AND TRUNC(B.CD_ACTIV_DATE) >= TO_DATE('15/12/2006','DD/ 25,776 1 25,776.0 0.3 1511216563 SELECT F.DN_NUM GSM, B.CO_ID, D.PORT_NUM OLD_IMSI, C.PORT_NUM NE W_IMSI, TRUNC(B.CD_ACTIV_DATE) DATE_OF_CHANGE FROM CONTR_DEVICE S A, CONTR_DEVICES B, PORT C, PORT D, CONTR_SERVICES_CAP E, DIRE CTORY_NUMBER F WHERE SUBSTR(B.CD_SM_NUM,1,1) = '0' AND B.CD_SE QNO > 1 AND TRUNC(B.CD_ACTIV_DATE) > TO_DATE('14/12/2006','DD/M 25,596 1 25,596.0 0.3 2014874593 SELECT F.DN_NUM GSM, B.CO_ID, D.PORT_NUM OLD_IMSI, C.PORT_NUM NE W_IMSI, TRUNC(B.CD_ACTIV_DATE) DATE_OF_CHANGE FROM CONTR_DEVICE S A, CONTR_DEVICES B, PORT C, PORT D, CONTR_SERVICES_CAP E, DIRE CTORY_NUMBER F WHERE SUBSTR(B.CD_SM_NUM,1,1) = '0' AND B.CD_SE QNO > 1 AND TRUNC(B.CD_ACTIV_DATE) >= TO_DATE('14/12/2006','DD/ 24,738 2 12,369.0 0.3 106135115 SELECT status,COUNT(*) FROM mdsrrtab GROUP BY status 17,350 13,565 1.3 0.2 2396689924 SELECT NVL(SUM(NVL(A.OHINVAMT_DOC,0)),0) FROM MY_EN_ORDER1 A WHERE A.OHREFDATE <= :b1 AND A.CUSTOMER_ID = :b2 AND A.OHSTATU S IN ( 'FC2','IN','CO2','CM','CA','PR','AO','WR' ) 17,235 1 17,235.0 0.2 4076196495 update MDSRRTAB set WORKER_PID=:b0 where ((STATUS in (7,8,11,12 ,1,2,4,10,14) and WORKER_PID>0) and TS<=(SYSDATE-(3600* (1/((24* ------------------------------------------------------------- SQL ordered by Executions for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -139 -> End Executions Threshold: 100 Executions Rows Processed Rows per Exec Hash Value ------------ ---------------- ---------------- ------------ 13,565 13,565 1.0 2396689924 SELECT NVL(SUM(NVL(A.OHINVAMT_DOC,0)),0) FROM MY_EN_ORDER1 A WHERE A.OHREFDATE <= :b1 AND A.CUSTOMER_ID = :b2 AND A.OHSTATU S IN ( 'FC2','IN','CO2','CM','CA','PR','AO','WR' ) 13,563 13,563 1.0 1270009452 SELECT MIN(TRUNC(CH_VALIDFROM)) FROM CONTRACT_HISTORY WHERE C H_SEQNO = 2 AND CO_ID = :b1 13,562 13,562 1.0 3024234896 SELECT NVL(SUM(DECODE(MY_NEWDUECLASS_1(OHREFDATE,:b1),1,NVL(OHIN VAMT_DOC,0),0)),0) GE0_L30,NVL(SUM(DECODE(MY_NEWDUECLASS_1(OHREF DATE,:b1),2,NVL(OHINVAMT_DOC,0),0)),0) GE30_L60,NVL(SUM(DECODE(M Y_NEWDUECLASS_1(OHREFDATE,:b1),3,NVL(OHINVAMT_DOC,0),0)),0) GE60 _L90,NVL(SUM(DECODE(MY_NEWDUECLASS_1(OHREFDATE,:b1),4,NVL(OHINVA 13,560 13,560 1.0 3741253120 SELECT COUNT(NVL(C2.CO_ID,0)) FROM CONTRACT_HISTORY C2 WHERE C2.CO_ID = :b1 AND C2.CH_STATUS IN ( 's' ) 13,556 13,556 1.0 220356876 SELECT NVL(SUM(OHINVAMT_DOC),0) FROM ORDERHDR_ALL WHERE OHSTA TUS IN ( 'DP' ) AND OHREFDATE <= :b1 AND CUSTOMER_ID = :b2 13,555 13,555 1.0 3708069957 SELECT MAX(SUBSTR(CS_STAT_CHNG,-1,1)) FROM CONTR_SERVICES A W HERE SNCODE = 19 AND A.CO_ID = :b1 13,554 13,554 1.0 4153999493 SELECT NVL(SUM(CACHKAMT_PAY),0) FROM CASHRECEIPTS_ALL WHERE C USTOMER_ID = :b1 AND CATYPE IN ( 12 ) AND CACHKDATE <= :b2 13,543 13,543 1.0 1187558410 SELECT NVL(SUM(DECODE(SIGN(CACHKAMT_PAY),-1,CACHKAMT_PAY,0)),0) FROM CASHRECEIPTS_ALL WHERE CUSTOMER_ID = :b1 AND CATYPE IN ( 10 ) AND CACHKDATE <= :b2 13,542 13,542 1.0 742947438 SELECT MAX(OHREFNUM) FROM ORDERHDR_ALL A WHERE A.OHREFDATE <= :b1 AND A.CUSTOMER_ID = :b2 AND A.OHSTATUS IN ( 'IN','CM' ) 13,539 13,539 1.0 898196734 SELECT COUNT(NVL(CUSTOMER_ID,0)) FROM ORDERHDR_ALL WHERE OHST ATUS IN ( 'IN','CM' ) AND CUSTOMER_ID = :b1 13,538 13,538 1.0 3291922290 SELECT COUNT(NVL(C2.CO_ID,0)) FROM CURR_CO_STATUS C2 WHERE C2 .CO_ID = :b1 AND C2.CH_STATUS IN ( 'a','s' ) 13,535 13,535 1.0 208369243 SELECT NVL(SUM(NVL(OHINVAMT_DOC,0)),0) FROM ORDERHDR_ALL A WH ERE A.OHREFDATE <= :b1 AND A.CUSTOMER_ID = :b2 AND A.OHSTATUS IN ( 'IN','CM' ) 13,530 13,530 1.0 246302095 SQL ordered by Executions for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -139 -> End Executions Threshold: 100 Executions Rows Processed Rows per Exec Hash Value ------------ ---------------- ---------------- ------------ SELECT B.CUSTOMER_ID FROM CUSTOMER_ALL B WHERE B.CUSTOMER_ID = :b1 13,530 13,530 1.0 913977543 SELECT NVL(SUM(NVL(CACHKAMT_PAY,0)),0) FROM CASHRECEIPTS_ALL WHERE CUSTOMER_ID = :b1 AND CATYPE NOT IN ( 5,10,12 ) AND CACH KDATE <= :b2 8,030 3,469 0.4 4076695772 SELECT VALUE_SEQNO, PRM_VALUE_DATE, PRM_VALUE_STRING, PRM_VALUE _NUMBER, PRM_DESCRIPTION FROM PARAMETER_VALUE WHERE PRM_VALU E_ID = :1 AND PARAMETER_ID = :2 AND PRM_NO = :3 A ND PRM_SEQNO = :4 AND COMPLEX_S 6,438 6,438 1.0 226434519 SELECT CUSTCODE FROM CUSTOMER WHERE CUSTOMER_ID=:1 6,438 6,438 1.0 1063886973 SELECT TICKL_STAT_WEIGHT FROM tickler_status WHERE TICKLER_STATU S=:1 3,423 0 0.0 2955772585 SELECT COPIES, COPIES FROM CUST_IMAGES WHERE CUSTOMER_ID = :1 AND TYPE_ID = :2 2,585 8,129 3.1 4110753279 SELECT PARAMETER_ID, PRM_NO, PREDECESSOR_DEPENDENT FROM SERVICE_ PARAMETER WHERE SCCODE = :1 AND SVCODE = :2 ORDER BY 2 ASC 1,969 1,969 1.0 2091761008 select condition from cdef$ where rowid=:1 1,281 0 0.0 1423215774 SELECT SEQ_NO, VALID_FROM, EXPIRATION_DATE, REASON FROM TAX_ EXEMPT WHERE CUSTOMER_ID = :1 AND TAXTYPE_ID = :2 AND EXPIRATIO N_DATE is NULL UNION SELECT SEQ_NO, VALID_FROM, EXPIRATION_DA 1,155 2,805 2.4 664860669 SELECT MPA.ACTION FROM MKT_PARAMETER_ACTION MPA WHERE MPA.PARAMETER_ID = :1 AND MPA.SCCODE = :2 ORDER BY 1 A SC ------------------------------------------------------------- SQL ordered by Sharable Memory for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -> End Sharable Memory Threshold: 1048576 Sharable Mem (b) Executions % Total Hash Value ---------------- ------------ ------- ------------ 8,679,428 48 0.9 816330795 UPDATE CCONTACT SET REC_VERSION = :1 , CC MOD = :2 , CCNAME = :3 , CCTITLE = :4 , CCFNAME = :5 , CCMNAM E = :6 , CCLNAME = :7 , CCLNA MEMC = :8 , CCADDR1 = :9 , 1,825,576 48 0.2 3698279462 UPDATE CUSTOMER SET REC_VERSION = :1 + 1, C SCUSTTYPE = :2 , CSMOD = 'X', USER_LASTMOD = :3 , BIRTHDATE = :4 , CSNATION ALITY = :5 , CSEMPLOYER = :6 , CSREMARK_1 = :7 , CSREMARK_2 = :8 1,356,268 2 0.1 3424456422 INSERT INTO CCONTACT ( CUSTOMER_ID, CCNAME, CCTITLE, CCFNAME, CCMNAME, CCLNAME, CCLNAMEMC, CCADDR1, CCADDR2, CCADDR3, CCSTR EETNO, CCSTREET, CCCITY, CCSTATE, CCZIP, COUNTRY, CCCOUNTY, CCADDRYEARS, CCURGENT, CCFORWARD, CCJOBDESC, CCTN_AREA, CCTN , CCTN2_AREA, CCTN2, CCFAX_AREA, CCFAX, CCEMAIL, CCSMSNO, ------------------------------------------------------------- SQL ordered by Version Count for DB: STY_PROD Instance: STY_PROD Snaps: 1391 - -> End Version Count Threshold: 20 Version Count Executions Hash Value -------- ------------ ------------ 92 48 816330795 UPDATE CCONTACT SET REC_VERSION = :1 , CC MOD = :2 , CCNAME = :3 , CCTITLE = :4 , CCFNAME = :5 , CCMNAM E = :6 , CCLNAME = :7 , CCLNA MEMC = :8 , CCADDR1 = :9 , 27 6 2772789292 SELECT BI_DATE, CO_ID, BI_DATE FROM BILL_IMAGES WHERE CUSTOMER_ ID = :1 AND BI_TYPE = :2 ORDER BY 1 25 36 1464076433 SELECT BLID FROM BLACKLIST WHERE BLTAXREGNO = :sTaxRegNo OR BLNA ME = :sName OR (BLZIP = :sZip AND BLSTREET = :sStreet) 25 4 2936055752 SELECT BI_IMAGE_SIZE FROM BILL_IMAGES WHERE OHXACT = :1 A ND CUSTOMER_ID = :2 AND BI_TYPE = :3 23 4 3447972861 SELECT BI_EXTENSION, BI_IMAGE_PROCESS, BI_IMAGE FROM BILL_IMAGE S WHERE OHXACT = :1 AND CUSTOMER_ID = :2 AND BI_TYPE = :3 ------------------------------------------------------------- Instance Activity Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ CPU used by this session 97,751 106.4 22.9 CPU used when call started 98,000 106.6 23.0 CR blocks created 562 0.6 0.1 DBWR buffers scanned 33,442 36.4 7.8 DBWR checkpoint buffers written 8,288 9.0 1.9 DBWR checkpoints 0 0.0 0.0 DBWR free buffers found 33,263 36.2 7.8 DBWR lru scans 63 0.1 0.0 DBWR make free requests 63 0.1 0.0 DBWR revisited being-written buff 0 0.0 0.0 DBWR summed scan depth 33,442 36.4 7.8 DBWR transaction table writes 368 0.4 0.1 DBWR undo block writes 761 0.8 0.2 SQL*Net roundtrips to/from client 642,376 699.0 150.5 SQL*Net roundtrips to/from dblink 288 0.3 0.1 background checkpoints completed 0 0.0 0.0 background checkpoints started 0 0.0 0.0 background timeouts 890 1.0 0.2 branch node splits 0 0.0 0.0 buffer is not pinned count 15,297,160 16,645.4 3,584.2 buffer is pinned count 10,951,583 11,916.9 2,566.0 bytes received via SQL*Net from c 54,270,490 59,053.9 12,715.7 bytes received via SQL*Net from d 431,630 469.7 101.1 bytes sent via SQL*Net to client 214,979,713 233,927.9 50,370.1 bytes sent via SQL*Net to dblink 41,156 44.8 9.6 calls to get snapshot scn: kcmgss 322,409 350.8 75.5 calls to kcmgas 4,395 4.8 1.0 calls to kcmgcs 266 0.3 0.1 change write time 132 0.1 0.0 cleanouts and rollbacks - consist 108 0.1 0.0 cleanouts only - consistent read 1,973 2.2 0.5 cluster key scan block gets 34,177 37.2 8.0 cluster key scans 2,437 2.7 0.6 commit cleanout failures: block l 6 0.0 0.0 commit cleanout failures: buffer 9 0.0 0.0 commit cleanout failures: callbac 1 0.0 0.0 commit cleanout failures: cannot 2 0.0 0.0 commit cleanouts 16,430 17.9 3.9 commit cleanouts successfully com 16,412 17.9 3.9 consistent changes 1,273 1.4 0.3 consistent gets 17,077,282 18,582.5 4,001.2 current blocks converted for CR cursor authentications 205 0.2 0.1 data blocks consistent reads - un 1,206 1.3 0.3 db block changes 61,537 67.0 14.4 db block gets 228,318 248.4 53.5 deferred (CURRENT) block cleanout 7,993 8.7 1.9 dirty buffers inspected 1,007 1.1 0.2 enqueue conversions 1,806 2.0 0.4 enqueue releases 13,837 15.1 3.2 enqueue requests 13,834 15.1 3.2 enqueue timeouts 0 0.0 0.0 enqueue waits 0 0.0 0.0 execute count 281,127 305.9 65.9 free buffer inspected 2,372 2.6 0.6 free buffer requested 9,533,839 10,374.1 2,233.8 Instance Activity Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ hot buffers moved to head of LRU 97,891 106.5 22.9 immediate (CR) block cleanout app 2,081 2.3 0.5 immediate (CURRENT) block cleanou 1,552 1.7 0.4 index fast full scans (full) 18 0.0 0.0 leaf node splits 69 0.1 0.0 logons cumulative 166 0.2 0.0 messages received 5,500 6.0 1.3 messages sent 5,500 6.0 1.3 no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 15,672,457 17,053.8 3,672.1 opened cursors cumulative 5,714 6.2 1.3 parse count (hard) 711 0.8 0.2 parse count (total) 54,515 59.3 12.8 parse time cpu 1,688 1.8 0.4 parse time elapsed 1,874 2.0 0.4 physical reads 9,573,179 10,417.0 2,243.0 physical reads direct 41,234 44.9 9.7 physical writes 53,101 57.8 12.4 physical writes direct 43,597 47.4 10.2 physical writes non checkpoint 48,327 52.6 11.3 pinned buffers inspected 1,121 1.2 0.3 prefetched blocks 8,286,184 9,016.5 1,941.5 prefetched blocks aged out before 0 0.0 0.0 process last non-idle time 173,787,024,016 ############ ############ recursive calls 63,629 69.2 14.9 recursive cpu usage 1,874 2.0 0.4 redo blocks written 23,290 25.3 5.5 redo buffer allocation retries 0 0.0 0.0 redo entries 32,722 35.6 7.7 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 10,193,920 11,092.4 2,388.5 redo synch time 9,723 10.6 2.3 redo synch writes 4,264 4.6 1.0 redo wastage 1,277,492 1,390.1 299.3 redo write time 9,790 10.7 2.3 redo writer latching time 0 0.0 0.0 redo writes 4,346 4.7 1.0 rollback changes - undo records a 327 0.4 0.1 rollbacks only - consistent read 453 0.5 0.1 rows fetched via callback 76,327 83.1 17.9 session connect time 171,454,250,485 ############ ############ session logical reads 17,305,581 18,830.9 4,054.7 session pga memory 432,632,208 470,764.1 101,366.5 session pga memory max 441,409,408 480,314.9 103,423.0 session uga memory max 379,878,984 413,361.2 89,006.3 sorts (disk) 3 0.0 0.0 sorts (memory) 20,927 22.8 4.9 sorts (rows) 2,664,025 2,898.8 624.2 summed dirty queue length 1,232 1.3 0.3 switch current to new buffer table fetch by rowid 7,110,661 7,737.4 1,666.0 table fetch continued row 2,641 2.9 0.6 table scan blocks gotten 11,643,788 12,670.1 2,728.2 table scan rows gotten 91,096,066 99,125.2 21,344.0 Instance Activity Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ table scans (long tables) 653 0.7 0.2 table scans (short tables) 16,520 18.0 3.9 total file opens 731 0.8 0.2 transaction rollbacks 2 0.0 0.0 transaction tables consistent rea 0 0.0 0.0 transaction tables consistent rea 0 0.0 0.0 user calls 640,104 696.5 150.0 user commits 4,206 4.6 1.0 user rollbacks 62 0.1 0.0 write clones created in backgroun 20 0.0 0.0 write clones created in foregroun 276 0.3 0.1 ------------------------------------------------------------- Tablespace IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ N_DATA 1,033,832 1,125 0.2 7.9 114 0 507 0.2 MPU_TBS 65,656 71 0.6 8.9 1,980 2 0 0.0 CUSTOMER_LM 29,293 32 3.4 10.9 186 0 2,300 6.7 CONTR_DEVICES_LM 25,053 27 0.3 6.3 23 0 0 0.0 ORDHDR_LM 10,331 11 8.8 1.0 34 0 0 0.0 CASHREC_TBS 9,858 11 8.7 1.0 9 0 0 0.0 SPACETELDATA 9,553 10 1.5 12.0 12 0 0 0.0 DIRECTORY 9,419 10 1.6 9.0 0 0 0 0.0 MY_TBS 6,068 7 3.7 1.0 1,319 1 0 0.0 CASHDET_TBS 4,699 5 9.0 1.0 11 0 0 0.0 I_ORDHDR_LM 4,646 5 9.3 1.0 42 0 0 0.0 CASH2_TBS 4,401 5 9.2 1.0 49 0 0 0.0 PK_TBS3 3,963 4 9.1 1.0 19 0 0 0.0 I_CONTR_SERVICES_LM 3,525 4 9.5 1.0 210 0 0 0.0 CONTR_HISTORY_LM 3,540 4 9.4 1.0 1 0 0 0.0 I_CONTRACT_LM 3,416 4 9.5 1.0 0 0 0 0.0 CONTR_SERVICES_LM 2,455 3 9.4 1.0 571 1 0 0.0 SYSTEM 1,416 2 8.9 1.2 454 0 0 0.0 TEMP 1,005 1 265.7 40.6 580 1 0 0.0 TICKLER_LM 1,375 1 8.6 1.0 60 0 0 0.0 I_CONTR_DEVICES_LM 1,150 1 8.9 1.0 39 0 0 0.0 PORT_LM 1,030 1 9.4 1.0 19 0 0 0.0 RBS 1 0 0.0 1.0 1,023 1 2 0.0 I_TICKLER_LM 448 0 10.3 1.0 535 1 0 0.0 CONTRACT_LM 751 1 8.5 1.0 187 0 0 0.0 I_CONTACT_LM 418 0 9.0 1.0 517 1 0 0.0 Tablespace IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ N_I_DATA 399 0 9.6 1.0 493 1 0 0.0 I_CUSTOMER_LM 794 1 8.9 1.0 7 0 0 0.0 CONTACT_LM 625 1 8.8 1.0 121 0 0 0.0 CONTRS_TBS 693 1 9.1 1.0 8 0 0 0.0 I_PORT_LM 676 1 9.1 1.0 12 0 0 0.0 IX_TBS 197 0 9.2 1.0 371 0 0 0.0 PARAM_TBS 521 1 9.2 1.0 41 0 0 0.0 VMD_TBS 518 1 6.1 1.0 27 0 11 8.2 RATE_TBS 456 0 9.4 1.0 25 0 0 0.0 USER_TBS 245 0 4.9 1.4 224 0 0 0.0 IN_TBS 383 0 10.1 1.0 49 0 0 0.0 I_DIRECTORY 421 0 10.1 1.0 0 0 0 0.0 STORMED_LM 347 0 9.4 1.0 21 0 0 0.0 FK_TBS1 333 0 9.6 1.0 12 0 0 0.0 PK_TBS36 337 0 10.1 1.0 2 0 0 0.0 PK_TBS8 326 0 9.3 1.0 5 0 0 0.0 I_STORMED_LM 312 0 9.9 1.0 0 0 0 0.0 PK_TBS22 215 0 9.5 1.0 50 0 0 0.0 PK_TBS6 257 0 8.2 1.0 0 0 0 0.0 PK_TBS17 219 0 10.4 1.0 1 0 0 0.0 PAY_TBS 211 0 9.1 1.0 1 0 0 0.0 PK_TBS4 177 0 11.2 1.0 0 0 0 0.0 PK_TBS18 164 0 9.1 1.0 1 0 0 0.0 INFO_TBS 75 0 7.5 1.0 71 0 0 0.0 PK_TBS10 104 0 11.6 1.0 29 0 0 0.0 PK_TBS33 45 0 9.1 1.0 62 0 0 0.0 Tablespace IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ CALLSDETRBS 0 0 0.0 97 0 0 0.0 CONTR_TBS 66 0 9.7 1.0 0 0 0 0.0 GMD_TBS 4 0 7.5 1.0 54 0 0 0.0 BCH_TBS 46 0 7.0 6.0 9 0 0 0.0 PK_TBS35 54 0 8.7 1.7 0 0 0 0.0 DOCUMENT_LM 4 0 0.0 1.0 44 0 0 0.0 PK_TBS32 14 0 4.3 1.0 30 0 0 0.0 APP_TBS 4 0 12.5 1.0 34 0 0 0.0 I_DOCUMENT_LM 12 0 3.3 1.0 18 0 0 0.0 PK_TBS27 1 0 10.0 1.0 29 0 0 0.0 I_BILLIMAGE_LM 13 0 6.9 1.0 12 0 0 0.0 PK_TBS26 5 0 6.0 1.0 19 0 0 0.0 PK_TBS30 17 0 11.2 1.0 1 0 0 0.0 PK_TBS29 15 0 9.3 1.0 1 0 0 0.0 FK_TBS2 5 0 10.0 1.0 9 0 0 0.0 I_CASH_LM 1 0 10.0 1.0 9 0 0 0.0 PK_TBS31 4 0 5.0 1.0 6 0 0 0.0 PK_TBS9 10 0 10.0 1.0 0 0 0 0.0 PK_TBS28 2 0 10.0 1.0 7 0 0 0.0 PK_TBS13 1 0 10.0 1.0 7 0 0 0.0 FK_TBS11 5 0 14.0 1.0 2 0 0 0.0 BILLIMAGE 3 0 0.0 1.0 3 0 0 0.0 MPS_TBS 5 0 10.0 1.4 0 0 0 0.0 IU_TBS 2 0 10.0 1.0 2 0 0 0.0 MPD_TBS 4 0 12.5 1.0 0 0 0 0.0 NLS_TBS 4 0 5.0 1.0 0 0 0 0.0 Tablespace IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ RULE_TBS 3 0 0.0 1.3 0 0 0 0.0 SERVICE_TBS 3 0 10.0 1.3 0 0 0 0.0 ADR_TBS 2 0 10.0 1.0 0 0 0 0.0 GL_TBS 2 0 15.0 2.5 0 0 0 0.0 MKT_TBS 2 0 10.0 1.0 0 0 0 0.0 PK_TBS25 2 0 20.0 1.0 0 0 0 0.0 PK_TBS37 0 0 0.0 2 0 0 0.0 RES_TBS 2 0 10.0 1.0 0 0 0 0.0 UC_TBS 1 0 10.0 1.0 1 0 0 0.0 UDS_TBS 2 0 15.0 2.5 0 0 0 0.0 BILLCYCLE_TBS 1 0 0.0 1.0 0 0 0 0.0 CUST_TBS 1 0 0.0 1.0 0 0 0 0.0 ER_TBS 1 0 20.0 1.0 0 0 0 0.0 FK_TBS10 0 0 0.0 1 0 0 0.0 NET_TBS 1 0 10.0 1.0 0 0 0 0.0 PK_TBS11 1 0 10.0 1.0 0 0 0 0.0 PK_TBS12 1 0 10.0 1.0 0 0 0 0.0 PK_TBS14 0 0 0.0 1 0 0 0.0 PK_TBS23 1 0 20.0 1.0 0 0 0 0.0 PK_TBS41 0 0 0.0 1 0 0 0.0 PK_TBS44 1 0 10.0 3.0 0 0 0 0.0 UK_TBS 1 0 10.0 1.0 0 0 0 0.0 ------------------------------------------------------------- File IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ ADR_TBS /STY_PROD/data/ADR_TBS.dbf 2 0 10.0 1.0 0 0 0 APP_TBS /STY_PROD/data/APP_TBS.dbf 4 0 12.5 1.0 34 0 0 BCH_TBS /STY_PROD/data/BCH_TBS.dbf 46 0 7.0 6.0 9 0 0 BILLCYCLE_TBS /STY_PROD/data/BILLCYCLE_TBS.dbf 1 0 0.0 1.0 0 0 0 BILLIMAGE /STY_PROD/data/BILLIMAGE_1.dbf 3 0 0.0 1.0 3 0 0 CALLSDETRBS /STY_PROD/rbs/callsdetrbs.dbf 0 0 97 0 0 CASH2_TBS /STY_PROD/data/CASH2_TBS.dbf 4,401 5 9.2 1.0 49 0 0 CASHDET_TBS /STY_PROD/data/CASHDET_TBS.dbf 4,699 5 9.0 1.0 11 0 0 CASHREC_TBS /STY_PROD/data/CASHREC_TBS.dbf 9,858 11 8.7 1.0 9 0 0 CONTACT_LM /STY_PROD/data/CONTACT_LM.dbf 625 1 8.8 1.0 121 0 0 CONTRACT_LM /STY_PROD/data/CONTRACT.dbf 751 1 8.5 1.0 187 0 0 CONTRS_TBS /STY_PROD/data/CONTRS_TBS.dbf 693 1 9.1 1.0 8 0 0 CONTR_DEVICES_LM /STY_PROD/data/CONTR_DEVICES_LM.dbf 25,053 27 0.3 6.3 23 0 0 CONTR_HISTORY_LM /STY_PROD/data/CONTR_HISTORY_LM.dbf 3,540 4 9.4 1.0 1 0 0 CONTR_SERVICES_LM /STY_PROD/data/CONTR_SERVICES_LM.dbf 2,455 3 9.4 1.0 571 1 0 CONTR_TBS /STY_PROD/data/CONTR_TBS.dbf 66 0 9.7 1.0 0 0 0 CUSTOMER_LM /STY_PROD/data/CUSTOMER_LM.dbf 29,293 32 3.4 10.9 186 0 2,300 6.7 CUST_TBS /STY_PROD/data/CUST_TBS.dbf File IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ 1 0 0.0 1.0 0 0 0 DIRECTORY /STY_PROD/data/DIRECTORY.dbf 9,419 10 1.6 9.0 0 0 0 DOCUMENT_LM /STY_PROD/data/DOCUMENT_LM.dbf 4 0 0.0 1.0 44 0 0 ER_TBS /STY_PROD/data/ER_TBS.dbf 1 0 20.0 1.0 0 0 0 FK_TBS1 /STY_PROD/index/FK_TBS1.dbf 333 0 9.6 1.0 12 0 0 FK_TBS10 /STY_PROD/index/FK_TBS10.dbf 0 0 1 0 0 FK_TBS11 /STY_PROD/index/FK_TBS11.dbf 5 0 14.0 1.0 2 0 0 FK_TBS2 /STY_PROD/index/FK_TBS2.dbf 5 0 10.0 1.0 9 0 0 GL_TBS /STY_PROD/data/GL_TBS.dbf 2 0 15.0 2.5 0 0 0 GMD_TBS /STY_PROD/data/GMD_TBS.dbf 4 0 7.5 1.0 54 0 0 INFO_TBS /STY_PROD/data/INFO_TBS.dbf 75 0 7.5 1.0 71 0 0 IN_TBS /STY_PROD/index/IN_TBS.dbf 383 0 10.1 1.0 49 0 0 IU_TBS /STY_PROD/index/IU_TBS.dbf 2 0 10.0 1.0 2 0 0 IX_TBS /STY_PROD/index/IX_TBS.dbf 197 0 9.2 1.0 371 0 0 I_BILLIMAGE_LM /STY_PROD/index/I_BILLIMAGE_LM.dbf 13 0 6.9 1.0 12 0 0 I_CASH_LM /STY_PROD/index/I_CASH_LM.dbf 1 0 10.0 1.0 9 0 0 I_CONTACT_LM /STY_PROD/index/I_CONTACT_LM.dbf 418 0 9.0 1.0 517 1 0 I_CONTRACT_LM /STY_PROD/index/I_CONTRACT_LM.dbf 3,416 4 9.5 1.0 0 0 0 File IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ I_CONTR_DEVICES_LM /STY_PROD/index/I_CONTR_DEVICES_LM.dbf 1,150 1 8.9 1.0 39 0 0 I_CONTR_SERVICES_LM /STY_PROD/index/I_CONTR_SERVICES_LM.dbf 3,525 4 9.5 1.0 210 0 0 I_CUSTOMER_LM /STY_PROD/index/I_CUSTOMER_LM.dbf 794 1 8.9 1.0 7 0 0 I_DIRECTORY /STY_PROD/index/I_DIRECTORY.dbf 421 0 10.1 1.0 0 0 0 I_DOCUMENT_LM /STY_PROD/index/I_DOCUMENT_LM.dbf 12 0 3.3 1.0 18 0 0 I_ORDHDR_LM /STY_PROD/index/I_ORDHDR_LM.dbf 4,646 5 9.3 1.0 42 0 0 I_PORT_LM /STY_PROD/index/I_PORT_LM.dbf 676 1 9.1 1.0 12 0 0 I_STORMED_LM /STY_PROD/index/I_STORMED_LM.dbf 312 0 9.9 1.0 0 0 0 I_TICKLER_LM /STY_PROD/index/I_TICKLER_LM.dbf 448 0 10.3 1.0 535 1 0 MKT_TBS /STY_PROD/data/MKT_TBS.dbf 2 0 10.0 1.0 0 0 0 MPD_TBS /STY_PROD/data/MPD_TBS.dbf 4 0 12.5 1.0 0 0 0 MPS_TBS /STY_PROD/data/MPS_TBS.dbf 5 0 10.0 1.4 0 0 0 MPU_TBS /STY_PROD/data/MPU_TBS.dbf 65,656 71 0.6 8.9 1,980 2 0 MY_TBS /STY_PROD/data/MY_TBS.dbf 5,452 6 3.1 1.0 941 1 0 /STY_PROD/data/MY_TBS2.dbf 616 1 9.7 1.0 378 0 0 NET_TBS /STY_PROD/data/NET_TBS.dbf 1 0 10.0 1.0 0 0 0 NLS_TBS /STY_PROD/data/NLS_TBS.dbf 4 0 5.0 1.0 0 0 0 N_DATA /STY_PROD/data/N_DATA.dbf File IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ 1,033,832 1,125 0.2 7.9 114 0 507 0.2 N_I_DATA /STY_PROD/index/N_I_DATA.dbf 399 0 9.6 1.0 493 1 0 ORDHDR_LM /STY_PROD/data/ORDHDR_LM.dbf 10,331 11 8.8 1.0 34 0 0 PARAM_TBS /STY_PROD/data/PARAM_TBS.dbf 521 1 9.2 1.0 41 0 0 PAY_TBS /STY_PROD/data/PAY_TBS.dbf 211 0 9.1 1.0 1 0 0 PK_TBS10 /STY_PROD/index/PK_TBS10.dbf 104 0 11.6 1.0 29 0 0 PK_TBS11 /STY_PROD/index/PK_TBS11.dbf 1 0 10.0 1.0 0 0 0 PK_TBS12 /STY_PROD/index/PK_TBS12.dbf 1 0 10.0 1.0 0 0 0 PK_TBS13 /STY_PROD/index/PK_TBS13.dbf 1 0 10.0 1.0 7 0 0 PK_TBS14 /STY_PROD/index/PK_TBS14.dbf 0 0 1 0 0 PK_TBS17 /STY_PROD/index/PK_TBS17.dbf 219 0 10.4 1.0 1 0 0 PK_TBS18 /STY_PROD/index/PK_TBS18.dbf 164 0 9.1 1.0 1 0 0 PK_TBS22 /STY_PROD/index/PK_TBS22.dbf 215 0 9.5 1.0 50 0 0 PK_TBS23 /STY_PROD/index/PK_TBS23.dbf 1 0 20.0 1.0 0 0 0 PK_TBS25 /STY_PROD/index/PK_TBS25.dbf 2 0 20.0 1.0 0 0 0 PK_TBS26 /STY_PROD/index/PK_TBS26.dbf 5 0 6.0 1.0 19 0 0 PK_TBS27 /STY_PROD/index/PK_TBS27.dbf 1 0 10.0 1.0 29 0 0 PK_TBS28 /STY_PROD/index/PK_TBS28.dbf 2 0 10.0 1.0 7 0 0 File IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ PK_TBS29 /STY_PROD/index/PK_TBS29.dbf 15 0 9.3 1.0 1 0 0 PK_TBS3 /STY_PROD/index/PK_TBS3.dbf 3,963 4 9.1 1.0 19 0 0 PK_TBS30 /STY_PROD/index/PK_TBS30.dbf 17 0 11.2 1.0 1 0 0 PK_TBS31 /STY_PROD/index/PK_TBS31.dbf 4 0 5.0 1.0 6 0 0 PK_TBS32 /STY_PROD/index/PK_TBS32.dbf 14 0 4.3 1.0 30 0 0 PK_TBS33 /STY_PROD/index/PK_TBS33.dbf 45 0 9.1 1.0 62 0 0 PK_TBS35 /STY_PROD/index/PK_TBS35.dbf 54 0 8.7 1.7 0 0 0 PK_TBS36 /STY_PROD/index/PK_TBS36.dbf 337 0 10.1 1.0 2 0 0 PK_TBS37 /STY_PROD/index/PK_TBS37.dbf 0 0 2 0 0 PK_TBS4 /STY_PROD/index/PK_TBS4.dbf 177 0 11.2 1.0 0 0 0 PK_TBS41 /STY_PROD/index/PK_TBS41.dbf 0 0 1 0 0 PK_TBS44 /STY_PROD/index/PK_TBS44.dbf 1 0 10.0 3.0 0 0 0 PK_TBS6 /STY_PROD/index/PK_TBS6.dbf 257 0 8.2 1.0 0 0 0 PK_TBS8 /STY_PROD/index/PK_TBS8.dbf 326 0 9.3 1.0 5 0 0 PK_TBS9 /STY_PROD/index/PK_TBS9.dbf 10 0 10.0 1.0 0 0 0 PORT_LM /STY_PROD/data/PORT_LM.dbf 1,030 1 9.4 1.0 19 0 0 RATE_TBS /STY_PROD/data/RATE_TBS.dbf 456 0 9.4 1.0 25 0 0 File IO Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ RBS /STY_PROD/rbs/RBS_1.dbf 1 0 0.0 1.0 1,023 1 2 0.0 RES_TBS /STY_PROD/data/RES_TBS.dbf 2 0 10.0 1.0 0 0 0 RULE_TBS /STY_PROD/data/RULE_TBS.dbf 3 0 0.0 1.3 0 0 0 SERVICE_TBS /STY_PROD/data/SERVICE_TBS.dbf 3 0 10.0 1.3 0 0 0 SPACETELDATA /STY_PROD/data/SPACETELDATA_1.dbf 9,553 10 1.5 12.0 12 0 0 STORMED_LM /STY_PROD/data/STORMED.dbf 347 0 9.4 1.0 21 0 0 SYSTEM /STY_PROD/sys/system_1.dbf 754 1 8.5 1.2 260 0 0 /STY_PROD/sys/system_2.dbf 662 1 9.4 1.1 194 0 0 TEMP /STY_PROD/tmp/TEMP_1.dbf 1,005 1 265.7 40.6 580 1 0 TICKLER_LM /STY_PROD/data/TICKLER.dbf 1,375 1 8.6 1.0 60 0 0 UC_TBS /STY_PROD/index/UC_TBS.dbf 1 0 10.0 1.0 1 0 0 UDS_TBS /STY_PROD/data/UDS_TBS.dbf 2 0 15.0 2.5 0 0 0 UK_TBS /STY_PROD/index/UK_TBS.dbf 1 0 10.0 1.0 0 0 0 USER_TBS /STY_PROD/data/USER_TBS.dbf 245 0 4.9 1.4 224 0 0 VMD_TBS /STY_PROD/data/VMD_TBS.dbf 518 1 6.1 1.0 27 0 11 8.2 ------------------------------------------------------------- Buffer Pool Statistics for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> Pools D: default pool, K: keep pool, R: recycle pool Free Write Buffer Buffer Consistent Physical Physical Buffer Complete Busy P Gets Gets Reads Writes Waits Waits Waits - ----------- ------------- ----------- ---------- ------- -------- ---------- D 9,531,243 16,096,181 9,528,662 9,446 0 0 2,820 ------------------------------------------------------------- Buffer wait Statistics for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> ordered by wait time desc, waits desc Tot Wait Avg Class Waits Time (cs) Time (cs) ------------------ ----------- ---------- --------- data block 2,818 1,565 1 undo header 2 0 0 ------------------------------------------------------------- Rollback Segment Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->A high value for "Pct Waits" suggests more rollback segments may be required Trans Table Pct Undo Bytes RBS No Gets Waits Written Wraps Shrinks Extends ------ ------------ ------- --------------- -------- -------- -------- 0 4.0 0.00 0 0 0 0 1 4,606.0 0.00 293,802 1 0 0 2 1,289.0 0.00 631,766 1 0 0 3 1,860.0 0.00 309,322 0 0 0 4 125.0 0.00 0 0 0 0 5 7,467.0 0.00 229,076 0 0 0 6 13,785.0 0.00 252,688 1 0 0 7 1,273.0 0.00 296,366 0 0 0 8 5,067.0 0.00 279,640 1 0 0 9 1,386.0 0.00 262,768 1 0 0 10 5,819.0 0.02 272,832 1 0 0 11 1,422.0 0.00 244,106 1 0 0 47 952.0 0.00 301,834 0 0 0 ------------------------------------------------------------- Rollback Segment Storage for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->Optimal Size should be larger than Avg Active RBS No Segment Size Avg Active Optimal Size Maximum Size ------ --------------- --------------- --------------- --------------- 0 4,907,008 0 4,907,008 1 200,220,672 538,527 200,220,672 2 6,258,688 849,690 6,144,000 6,258,688 3 6,258,688 1,596,326 6,144,000 6,258,688 4 6,504,448 509,013 6,144,000 6,504,448 5 6,504,448 518,499 6,144,000 6,504,448 6 675,700,736 536,861 675,700,736 7 911,179,776 594,361 911,179,776 8 315,744,256 576,535 315,744,256 9 158,670,848 543,442 158,670,848 10 947,290,112 575,742 947,290,112 11 648,536,064 536,597 648,536,064 47 10,477,568 4,665,318 10,485,760 10,477,568 ------------------------------------------------------------- Latch Activity for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->"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 Pct Get Get Slps NoWait NoWait Latch Name Requests Miss /Miss Requests Miss ----------------------------- -------------- ------ ------ ------------ ------ Token Manager 731 0.0 72 0.0 active checkpoint queue latch 1,260 0.0 0 cache buffer handles 8,756 0.0 0 cache buffers chains 43,439,959 0.0 0.0 18,602,127 0.0 cache buffers lru chain 11,216,544 0.2 0.0 9,536,719 0.2 channel handle pool latch 341 0.0 0 channel operations parent lat 507 0.0 0 checkpoint queue latch 65,774 0.0 0.5 0 dictionary lookup 13 0.0 0 dml lock allocation 13,856 0.0 0.0 0 enqueue hash chains 29,490 0.0 0.0 0 enqueues 40,303 0.0 0.0 0 event group latch 166 0.0 0 global transaction 11,369 0.0 0 global tx free list 462 0.0 0 global tx hash mapping 2,123 0.0 0 job_queue_processes parameter 15 0.0 0 ktm global data 3 0.0 0 latch wait list 164 0.6 0.0 163 0.0 library cache 2,186,871 0.1 0.1 764 0.5 library cache load lock 222 0.0 0 list of block allocation 8,877 0.0 0.0 0 loader state object freelist 14 0.0 0 longop free list 3,244 0.0 0 messages 38,451 0.2 0.0 0 multiblock read objects 2,327,683 0.1 0.0 0 ncodef allocation latch 15 0.0 0 process allocation 166 0.0 166 0.0 process group creation 341 0.0 0 redo allocation 41,531 0.0 0.0 0 redo writing 23,598 1.4 0.0 0 row cache objects 653,309 0.0 0.0 0 sequence cache 540 0.0 0 session allocation 16,256 0.0 0.0 0 session idle bit 1,288,026 0.0 0.0 16 0.0 session switching 45 0.0 0 shared pool 91,717 0.0 0.4 0 sort extent pool 39 0.0 0 transaction allocation 14,219 0.0 0.0 0 transaction branch allocation 4,444 0.0 0 undo global data 52,266 0.0 0.0 0 user lock 664 0.0 0 ------------------------------------------------------------- Latch Sleep breakdown for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> ordered by misses desc Get Spin & Latch Name Requests Misses Sleeps Sleeps 1->4 -------------------------- -------------- ----------- ----------- ------------ cache buffers lru chain 11,216,544 21,547 233 21315/231/1/ 0/0 library cache 2,186,871 2,713 197 2557/120/31/ 5/0 multiblock read objects 2,327,683 2,023 17 2006/17/0/0/ 0 cache buffers chains 43,439,959 1,517 35 1485/29/3/0/ 0 redo writing 23,598 330 5 325/5/0/0/0 messages 38,451 82 4 78/4/0/0/0 session idle bit 1,288,026 78 2 76/2/0/0/0 shared pool 91,717 27 10 21/2/4/0/0 checkpoint queue latch 65,774 4 2 2/2/0/0/0 ------------------------------------------------------------- Latch Miss Sources for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- ------- cache buffers chains kcbrls: kslbegin 0 24 3 cache buffers chains kcbgtcr: kslbegin 0 5 27 cache buffers chains kcbgcur: kslbegin 0 2 0 cache buffers chains kcbzsc 0 2 0 cache buffers chains kcbzib: finish free bufs 0 1 3 cache buffers chains kcbzib: multi-block read: 0 1 0 cache buffers lru chain kcbzgb: multiple sets nowa 0 171 0 cache buffers lru chain kcbzar: KSLNBEGIN 0 32 217 cache buffers lru chain kcbbiop: lru scan 0 28 0 cache buffers lru chain kcbzgm 0 2 16 checkpoint queue latch kcbk0rrd: update recovery 0 2 0 library cache kglic 0 89 6 library cache kglhdgn: child: 0 49 5 library cache kglpndl: parent: purge 0 14 0 library cache kglpnal: child: alloc spac 0 7 13 library cache kgllkdl: child: cleanup 0 6 6 library cache kglupc: child 0 6 64 library cache kglhdgc: child: 0 5 10 library cache kglpnal: child: before pro 0 5 19 library cache kglpnc: child 0 3 49 library cache kglidp: parent 0 2 0 messages ksarcv: after wait 0 4 0 multiblock read objects kcbzib: MBRGET 0 12 10 multiblock read objects kcbzib: MBRFRE 0 5 7 redo writing kcrfsr 0 5 0 session idle bit kqp327i 0 1 0 session idle bit ksuxds 0 1 0 shared pool kghfrunp: clatch: nowait 0 11 0 shared pool kghfrunp: alloc: clatch no 0 8 0 shared pool kghalo 0 1 3 shared pool kghupr1 0 1 7 ------------------------------------------------------------- Dictionary Cache Stats for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->"Pct Misses" should be very low (< 2% in most cases) ->"Cache Usage" is the number of cache entries being used ->"Pct SGA" is the ratio of usage to allocated size for that cache Get Pct Scan Pct Mod Final Pct Cache Requests Miss Requests Miss Req Usage SGA ---------------------- ------------ ------ -------- ----- -------- ------ ---- dc_constraints 0 0 0 90 97 dc_database_links 108 0.9 0 0 162 99 dc_files 0 0 0 0 0 dc_free_extents 1,337 3.4 71 0.0 114 2,123 97 dc_global_oids 0 0 0 0 0 dc_histogram_data 0 0 0 0 0 dc_histogram_data_valu 0 0 0 0 0 dc_histogram_defs 23,495 0.0 0 0 5,310 100 dc_object_ids 140,755 0.0 0 0 1,820 100 dc_objects 11,679 0.6 0 16 ###### 100 dc_outlines 0 0 0 0 0 dc_profiles 238 0.0 0 0 7 88 dc_rollback_segments 288 0.0 0 0 49 94 dc_segments 24,034 0.0 0 85 1,704 99 dc_sequence_grants 0 0 0 2 67 dc_sequences 9 0.0 0 9 10 56 dc_synonyms 3,581 0.2 0 0 630 100 dc_tablespace_quotas 17 11.8 0 5 27 75 dc_tablespaces 589 0.0 0 0 196 96 dc_used_extents 114 62.3 0 114 245 22 dc_user_grants 1,030 0.0 0 0 330 92 dc_usernames 3,953 0.0 0 0 347 99 dc_users 7,267 0.0 0 0 334 99 ifs_acl_cache_entries 0 0 0 0 0 ------------------------------------------------------------- Library Cache Activity for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 ->"Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 404 0.0 404 0.0 0 0 CLUSTER 0 0 0 0 INDEX 16 0.0 16 0.0 0 0 OBJECT 0 0 0 0 PIPE 0 0 0 0 SQL AREA 54,032 1.2 594,435 0.2 82 12 TABLE/PROCEDURE 22,158 0.9 53,686 0.4 35 0 TRIGGER 543 0.0 543 0.0 0 0 ------------------------------------------------------------- SGA Memory Summary for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 SGA regions Size in Bytes ------------------------------ ---------------- Database Buffers 2,348,810,240 Fixed Size 102,076 Redo Buffers 1,064,960 Variable Size 938,811,392 ---------------- sum 3,288,788,668 ------------------------------------------------------------- SGA breakdown difference for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 Pool Name Begin value End value Difference ----------- ------------------------ -------------- -------------- ----------- java pool free memory 32,768 32,768 0 large pool free memory 20,010,528 20,010,528 0 shared pool Checkpoint queue 1,344,672 1,344,672 0 shared pool DML locks 385,728 385,728 0 shared pool KGFF heap 113,256 113,256 0 shared pool KGK heap 40,496 40,496 0 shared pool KQLS heap 8,713,312 8,763,312 50,000 shared pool PL/SQL DIANA 1,561,904 1,561,904 0 shared pool PL/SQL MPCODE 1,205,456 1,211,840 6,384 shared pool PLS non-lib hp 2,136 2,136 0 shared pool State objects 1,068,576 1,068,576 0 shared pool db_block_buffers 59,637,760 59,637,760 0 shared pool db_block_hash_buckets 9,928,880 9,928,880 0 shared pool db_files 402,328 402,328 0 shared pool db_handles 413,600 413,600 0 shared pool dictionary cache 44,032,080 44,101,896 69,816 shared pool enqueue_resources 344,864 344,864 0 shared pool event statistics per ses 1,812,384 1,812,384 0 shared pool fixed allocation callbac 4,200 4,200 0 shared pool free memory 65,652,992 45,669,920 -19,983,072 shared pool ktlbk state objects 307,664 307,664 0 shared pool library cache 202,096,992 203,850,384 1,753,392 shared pool message pool freequeue 191,192 191,192 0 shared pool miscellaneous 4,000,520 3,926,448 -74,072 shared pool processes 503,840 503,840 0 shared pool sessions 1,269,504 1,269,504 0 shared pool simulator trace entries 240,000 240,000 0 shared pool sql area 512,228,984 530,400,272 18,171,288 shared pool table columns 62,616 65,824 3,208 shared pool table definiti 14,752 16,640 1,888 shared pool transaction_branches 230,400 230,400 0 shared pool transactions 872,480 872,480 0 shared pool trigger defini 5,656 5,656 0 shared pool trigger inform 36,968 38,136 1,168 shared pool trigger source 1,088 1,088 0 db_block_buffers 2,348,810,240 2,348,810,240 0 fixed_sga 102,076 102,076 0 log_buffer 1,048,576 1,048,576 0 ------------------------------------------------------------- init.ora Parameters for DB: STY_PROD Instance: STY_PROD Snaps: 1391 -1392 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- _trace_files_public TRUE background_dump_dest /STY_PROD/sys/bdmp compatible 8.1.7.4 control_files /STY_PROD/logcntl/cntl_1.ctl, /ST core_dump_dest /STY_PROD/sys/cdmp cursor_space_for_time FALSE db_block_buffers 286720 db_block_lru_latches 12 db_block_size 8192 db_file_multiblock_read_count 16 db_files 1000 db_name STY_PROD distributed_transactions 300 ifile /oracle/product/8.1.7/dbs/configS java_pool_size 32768 large_pool_size 20010522 log_archive_dest /STY_PROD/arch log_archive_format T%TS%S.ARC log_archive_start TRUE log_buffer 1048576 log_checkpoint_interval 512 log_checkpoint_timeout 600 max_dump_file_size 10240 max_enabled_roles 32 max_rollback_segments 32 nls_date_format YYYYMMDD-HH24.MI.SS nls_language AMERICAN nls_numeric_characters . nls_territory AMERICA open_cursors 750 open_links 8 optimizer_mode CHOOSE os_authent_prefix partition_view_enabled TRUE processes 470 query_rewrite_enabled TRUE query_rewrite_integrity TRUSTED remote_login_passwordfile EXCLUSIVE resource_limit TRUE rollback_segments r01, r02, r03, r04 shared_pool_size 838860800 sort_area_retained_size 10485760 sort_area_size 10485760 sql_trace FALSE timed_statistics TRUE user_dump_dest /STY_PROD/sys/udmp utl_file_dir * ------------------------------------------------------------- End of Report