STATSPACK report for DB Name DB Id Instance Inst Num Release Cluster Host ------------ ----------- ------------ -------- ----------- ------- ------------ SIEB7PRD 216115013 sieb7prd 1 9.2.0.7.0 NO WBMSLONSIEDB 01 Snap Id Snap Time Sessions Curs/Sess Comment --------- ------------------ -------- --------- ------------------- Begin Snap: 217 06-May-09 10:31:02 82 118.5 End Snap: 222 06-May-09 11:46:02 77 128.4 Elapsed: 75.00 (mins) Cache Sizes (end) ~~~~~~~~~~~~~~~~~ Buffer Cache: 576M Std Block Size: 4K Shared Pool Size: 624M Log Buffer: 2,048K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 4,299.35 2,611.65 Logical reads: 5,913.07 3,591.90 Block changes: 20.88 12.68 Physical reads: 1,421.05 863.22 Physical writes: 1.69 1.03 User calls: 70.32 42.72 Parses: 8.38 5.09 Hard parses: 0.13 0.08 Sorts: 8.75 5.32 Logons: 0.04 0.02 Executes: 35.69 21.68 Transactions: 1.65 % Blocks changed per Read: 0.35 Recursive Call %: 70.02 Rollback per transaction %: 20.41 Rows per Sort: 82.07 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 99.97 Redo NoWait %: 100.00 Buffer Hit %: 75.97 In-memory Sort %: 100.00 Library Hit %: 99.37 Soft Parse %: 98.49 Execute to Parse %: 76.52 Latch Hit %: 99.98 Parse CPU to Parse Elapsd %: 87.36 % Non-Parse CPU: 99.03 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 89.58 86.29 % SQL with executions>1: 8.63 12.44 % Memory for SQL w/exec>1: 34.44 45.18 Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time -------------------------------------------- ------------ ----------- -------- db file scattered read 498,633 464 35.09 db file sequential read 335,663 413 31.23 CPU time 400 30.26 control file parallel write 1,502 18 1.33 buffer busy waits 8,651 11 .82 ------------------------------------------------------------- Wait Events for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> 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 Total Wait wait Waits Event Waits Timeouts Time (s) (ms) /txn ---------------------------- ------------ ---------- ---------- ------ -------- db file scattered read 498,633 0 464 1 67.3 db file sequential read 335,663 0 413 1 45.3 control file parallel write 1,502 0 18 12 0.2 buffer busy waits 8,651 0 11 1 1.2 log file sync 5,897 0 7 1 0.8 db file parallel write 651 0 4 7 0.1 control file sequential read 3,530 0 3 1 0.5 SQL*Net more data to client 13,525 0 1 0 1.8 log file parallel write 6,428 0 1 0 0.9 SQL*Net break/reset to clien 16 0 0 28 0.0 db file parallel read 40 0 0 9 0.0 latch free 76 71 0 1 0.0 direct path read 14 0 0 1 0.0 enqueue 1 0 0 18 0.0 direct path write 14 0 0 1 0.0 LGWR wait for redo copy 28 0 0 0 0.0 SQL*Net message from client 312,282 0 157,881 506 42.2 jobq slave wait 324 312 967 2986 0.0 SQL*Net message to client 312,277 0 0 0 42.2 SQL*Net more data from clien 11,474 0 0 0 1.5 ------------------------------------------------------------- Background Wait Events for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> ordered by wait time desc, waits desc (idle events last) Avg Total Wait wait Waits Event Waits Timeouts Time (s) (ms) /txn ---------------------------- ------------ ---------- ---------- ------ -------- control file parallel write 1,502 0 18 12 0.2 db file parallel write 651 0 4 7 0.1 control file sequential read 1,657 0 2 1 0.2 db file scattered read 339 0 1 2 0.0 log file parallel write 6,428 0 1 0 0.9 db file sequential read 244 0 0 2 0.0 direct path read 14 0 0 1 0.0 direct path write 14 0 0 1 0.0 rdbms ipc reply 10 0 0 0 0.0 LGWR wait for redo copy 28 0 0 0 0.0 buffer busy waits 1 0 0 0 0.0 rdbms ipc message 10,971 4,588 26,325 2400 1.5 smon timer 16 15 4,561 ###### 0.0 pmon timer 1,515 1,515 4,499 2970 0.2 ------------------------------------------------------------- SQL ordered by Gets for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> 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 CPU Elapsd Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- 3,912,981 75 52,173.1 14.7 80.02 428.39 821178776 Module: siebmtshmw.exe SELECT /*+ ALL_ROWS */ T29.CONFLICT_ID, T29.LAST_UPD , T29.CREATED, T29.LAST_UPD_BY, T29.CREATED_BY , T29.MODIFICATION_NUM, T29.ROW_ID, T27.NAME, T27.PR_ADDR_ID, T14.BL_CITY, T14.BL_ZIPCODE, T14.BL_STATE, T14.BL_ADDR, T27.CONTRACT_VIS_FLG 3,216,898 27 119,144.4 12.1 6.02 16.51 1790434949 Module: siebmtshmw.exe SELECT T11.CONFLICT_ID, T11.LAST_UPD, T11.CREA TED, T11.LAST_UPD_BY, T11.CREATED_BY, T11.MODI FICATION_NUM, T11.ROW_ID, T24.OU_NUM, T24.CLIE NT_FLG, T24.CMPT_FLG, T24.BASE_CURCY_CD, T24.D UNS_NUM, T24.PROD_DIST_CD, T24.DIVISION, T4.AT 3,009,954 3 1,003,318.0 11.3 58.25 166.32 3013118958 Module: siebmtshmw.exe SELECT T11.CONFLICT_ID, T11.LAST_UPD, T11.CREA TED, T11.LAST_UPD_BY, T11.CREATED_BY, T11.MODI FICATION_NUM, T11.ROW_ID, T11.ATP_MSG, T11.ATP _STATUS_CD, T11.ATP_STATUS_DT, T4.TARGET_OU_ID, T11.ACTION_CD, T11.ADJ_UNIT_PRI, T11.ASSET_INTEG_I 1,949,404 1 1,949,404.0 7.3 2.75 2.77 996794088 Module: siebmtshmw.exe SELECT T9.CONFLICT_ID, T9.LAST_UPD, T9.CREATED , T9.LAST_UPD_BY, T9.CREATED_BY, T9.MODIFICATI ON_NUM, T9.ROW_ID, T10.AGENT_FLG, T6.CURR_PRD_ OBJ_NAME, T10.EMAIL_ADDR, T10.EMP_FLG, T10.FAX _PH_NUM, T10.FST_NAME, T10.LAST_NAME, T4.LOGIN 1,696,088 7 242,298.3 6.4 6.38 9.80 856368800 Module: siebmtshmw.exe SELECT T12.CONFLICT_ID, T12.LAST_UPD, T12.CREA TED, T12.LAST_UPD_BY, T12.CREATED_BY, T12.MODI FICATION_NUM, T12.ROW_ID, T25.OU_NUM, T25.CLIE NT_FLG, T25.CMPT_FLG, T25.BASE_CURCY_CD, T25.D UNS_NUM, T25.PROD_DIST_CD, T25.DIVISION, T4.AT 1,397,820 3,494 400.1 5.3 8.11 25.04 109795310 Module: siebmtshmw.exe SELECT T9.CONFLICT_ID, T9.LAST_UPD, T9.CREATED , T9.LAST_UPD_BY, T9.CREATED_BY, T9.MODIFICATI ON_NUM, T9.ROW_ID, T9.ATP_STATUS_CD, T4.TARGET _OU_ID, T9.ACTION_CD, T9.ADJ_UNIT_PRI, T9.ASSE T_INTEG_ID, T9.AUC_ITEM_ID, T9.BASE_UNIT_PRI, 1,336,533 836 1,598.7 5.0 50.63 50.74 1263297694 Module: siebmtshmw.exe SQL ordered by Gets for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> 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 CPU Elapsd Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED , T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATI ON_NUM, T1.ROW_ID, T1.CODE, T1.NAME, T1. ORDER_BY, T1.RPLCTN_LVL_CD, T1.SUB_TYPE, T1.TY PE, T1.VAL FROM SIEBEL.S_LST_OF_VAL T1 WHERE 1,173,935 242 4,851.0 4.4 3.89 3.96 3138589117 Module: siebmtshmw.exe SELECT T7.CONFLICT_ID, T7.LAST_UPD, T7.CREATED , T7.LAST_UPD_BY, T7.CREATED_BY, T7.MODIFICATI ON_NUM, T7.ROW_ID, T4.BASE_CURCY_CD, T7.OU_ID, T3.NAME, T4.BU_ID, T1.CASE_CONV_FACTOR, T1.CASE_PACK, T7.AMT_CURCY_CD, T7.AMT_DT, T4. 1,029,559 1 1,029,559.0 3.9 4.14 28.42 2135169368 Module: siebmtshmw.exe SELECT /*+ ALL_ROWS */ T17.CONFLICT_ID, T17.LAST_UPD , T17.CREATED, T17.LAST_UPD_BY, T17.CREATED_BY , T17.MODIFICATION_NUM, T17.ROW_ID, T17.ROW_ID , T17.PROD_CD, T17.ACTIVE_FLG, T9.ACCRUE_UNIT_ FLG, T9.ALW_WAIT_LIST_FLG, T17.CAPACITY, T17.C 790,758 941 840.3 3.0 4.25 15.22 2975961164 Module: siebmtshmw.exe SELECT T9.CONFLICT_ID, T9.LAST_UPD, T9.CREATED , T9.LAST_UPD_BY, T9.CREATED_BY, T9.MODIFICATI ON_NUM, T9.ROW_ID, T9.ATP_STATUS_CD, T4.TARGET _OU_ID, T9.ACTION_CD, T9.ADJ_UNIT_PRI, T9.ASSE T_INTEG_ID, T9.AUC_ITEM_ID, T9.BASE_UNIT_PRI, 586,375 2 293,187.5 2.2 3.72 25.91 3856509688 Module: siebmtshmw.exe SELECT T6.CONFLICT_ID, T6.LAST_UPD, T6.CREATED , T6.LAST_UPD_BY, T6.CREATED_BY, T6.MODIFICATI ON_NUM, T6.ROW_ID, T6.ROW_ID, T2.PR_POSTN_ID, T2.PAR_OU_ID, T6.X_ROLLED_UP_BILLING_ADJ_FRCST, T6.X_ROLLED_UP_CATALOGUE_FORECAST, T6.X_ROLLED_UP_CATALO 497,451 2 248,725.5 1.9 9.06 30.13 2613277451 Module: siebmtshmw.exe SELECT T7.CONFLICT_ID, T7.LAST_UPD, T7.CREATED , T7.LAST_UPD_BY, T7.CREATED_BY, T7.MODIFICATI ON_NUM, T7.ROW_ID, T4.BASE_CURCY_CD, T7.OU_ID, T3.NAME, T4.BU_ID, T1.CASE_CONV_FACTOR, T1.CASE_PACK, T7.AMT_CURCY_CD, T7.AMT_DT, T4. 437,555 36 12,154.3 1.6 1.33 5.72 3547600367 Module: siebmtshmw.exe SELECT COUNT (*) FROM SIEBEL.S_VOD T1, S IEBEL.S_BU T2, SIEBEL.S_PRI_LST_ITEM T3, SIEBEL.S_ SQL ordered by Gets for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> 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 CPU Elapsd Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- PROD_INT T4 WHERE T4.CFG_MODEL_ID = T1.OBJECT_NUM AND T4.BU_ID = T2.PAR_ROW_ID AND T3.PROD_ID = T4.ROW_ID AND ------------------------------------------------------------- SQL ordered by Reads for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> End Disk Reads Threshold: 1000 CPU Elapsd Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- 2,935,286 75 39,137.1 45.9 80.02 428.39 821178776 Module: siebmtshmw.exe SELECT /*+ ALL_ROWS */ T29.CONFLICT_ID, T29.LAST_UPD , T29.CREATED, T29.LAST_UPD_BY, T29.CREATED_BY , T29.MODIFICATION_NUM, T29.ROW_ID, T27.NAME, T27.PR_ADDR_ID, T14.BL_CITY, T14.BL_ZIPCODE, T14.BL_STATE, T14.BL_ADDR, T27.CONTRACT_VIS_FLG 2,202,393 3 734,131.0 34.4 58.25 166.32 3013118958 Module: siebmtshmw.exe SELECT T11.CONFLICT_ID, T11.LAST_UPD, T11.CREA TED, T11.LAST_UPD_BY, T11.CREATED_BY, T11.MODI FICATION_NUM, T11.ROW_ID, T11.ATP_MSG, T11.ATP _STATUS_CD, T11.ATP_STATUS_DT, T4.TARGET_OU_ID, T11.ACTION_CD, T11.ADJ_UNIT_PRI, T11.ASSET_INTEG_I 345,966 2 172,983.0 5.4 9.06 30.13 2613277451 Module: siebmtshmw.exe SELECT T7.CONFLICT_ID, T7.LAST_UPD, T7.CREATED , T7.LAST_UPD_BY, T7.CREATED_BY, T7.MODIFICATI ON_NUM, T7.ROW_ID, T4.BASE_CURCY_CD, T7.OU_ID, T3.NAME, T4.BU_ID, T1.CASE_CONV_FACTOR, T1.CASE_PACK, T7.AMT_CURCY_CD, T7.AMT_DT, T4. 344,627 2 172,313.5 5.4 8.48 26.71 1892169592 Module: siebmtshmw.exe SELECT T7.CONFLICT_ID, T7.LAST_UPD, T7.CREATED , T7.LAST_UPD_BY, T7.CREATED_BY, T7.MODIFICATI ON_NUM, T7.ROW_ID, T4.BASE_CURCY_CD, T7.OU_ID, T3.NAME, T4.BU_ID, T1.CASE_CONV_FACTOR, T1.CASE_PACK, T7.AMT_CURCY_CD, T7.AMT_DT, T4. 118,012 3 39,337.3 1.8 4.25 12.54 1160692970 Module: siebmtshmw.exe SELECT T32.CONFLICT_ID, T32.LAST_UPD, T32.CREA TED, T32.LAST_UPD_BY, T32.CREATED_BY, T32.MODI FICATION_NUM, T32.ROW_ID, T30.NAME, T30.PR_ADD R_ID, T16.BL_CITY, T16.BL_ZIPCODE, T16.BL_STAT E, T16.BL_ADDR, T30.CONTRACT_VIS_FLG, T32.TARG 80,914 2 40,457.0 1.3 2.28 8.34 1681200491 Module: siebmtshmw.exe SELECT T29.CONFLICT_ID, T29.LAST_UPD, T29.CREA TED, T29.LAST_UPD_BY, T29.CREATED_BY, T29.MODI FICATION_NUM, T29.ROW_ID, T27.NAME, T27.PR_ADD R_ID, T14.BL_CITY, T14.BL_ZIPCODE, T14.BL_STAT E, T14.BL_ADDR, T27.CONTRACT_VIS_FLG, T29.TARG 74,713 2 37,356.5 1.2 2.00 12.23 2019162589 Module: siebmtshmw.exe SELECT T32.CONFLICT_ID, T32.LAST_UPD, T32.CREA TED, T32.LAST_UPD_BY, T32.CREATED_BY, T32.MODI FICATION_NUM, T32.ROW_ID, T30.NAME, T30.PR_ADD R_ID, T16.BL_CITY, T16.BL_ZIPCODE, T16.BL_STAT SQL ordered by Reads for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> End Disk Reads Threshold: 1000 CPU Elapsd Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- E, T16.BL_ADDR, T30.CONTRACT_VIS_FLG, T32.TARG 66,368 2 33,184.0 1.0 2.33 10.10 3678203694 Module: siebmtshmw.exe SELECT T3.CONFLICT_ID, T3.LAST_UPD, T3.CREATED , T3.LAST_UPD_BY, T3.CREATED_BY, T3.MODIFICATI ON_NUM, T3.ROW_ID, T3.TARGET_OU_ID, T3.BL_OU_I D, T3.BL_ADDR_ID, T3.BL_CON_ID, T3.BL_ACCT_ID, T3.PROMO_ID, T3.CMPND_PROD_NUM, T3.CON_PER_ID 44,271 1 44,271.0 0.7 50.75 118.21 642879765 Module: fgaOraAgent92_32.exe begin quest_fg_extents_check . do_extent_check ( :f_DefWarning , :f_DefCritical , :f_DefFatal , :f_SummariseLevel , :f_Debug ) ; END ; 26,034 5 5,206.8 0.4 0.28 2.52 3363995490 Module: pmdtm@wbaburp035 (TNS V1-V3) SELECT DISTINCT ROW_ID, EIM_STATUS, ERROR_DESC FROM( SELECT DISTINCT STG_ACCNT_DTL.ROW_ID, STG_ACCNT_DTL.EIM_STATUS, S TG_ACCNT_DTL.ERROR_DESC FROM STG_PRODUCTS STG_ACCNT_DTL W HERE EIM_STATUS = 'Error' UNION ALL SELECT DISTINCT STG_ ACCNT_DTL.ROW_ID, STG_ACCNT_DTL.EIM_STATUS, STG_ACCNT_DTL.ER 25,626 25,664 1.0 0.4 11.31 75.76 3217459477 Module: fgaOraAgent92_32.exe SELECT KTFBUEBLKS LAST_EXTENT_SIZE FROM X$KTFBUE WHERE KTFBUESEG TSN = :B3 AND KTFBUESEGFNO = :B2 AND KTFBUESEGBNO = :B1 ORDER BY KTFBUEEXTNO DESC 20,282 1 20,282.0 0.3 1.13 9.52 1615294852 Module: siebmtshmw.exe SELECT /*+ ALL_ROWS */ T29.CONFLICT_ID, T29.LAST_UPD , T29.CREATED, T29.LAST_UPD_BY, T29.CREATED_BY , T29.MODIFICATION_NUM, T29.ROW_ID, T27.NAME, T27.PR_ADDR_ID, T14.BL_CITY, T14.BL_ZIPCODE, T14.BL_STATE, T14.BL_ADDR, T27.CONTRACT_VIS_FLG 19,917 2 9,958.5 0.3 3.72 25.91 3856509688 Module: siebmtshmw.exe SELECT T6.CONFLICT_ID, T6.LAST_UPD, T6.CREATED , T6.LAST_UPD_BY, T6.CREATED_BY, T6.MODIFICATI ON_NUM, T6.ROW_ID, T6.ROW_ID, T2.PR_POSTN_ID, T2.PAR_OU_ID, T6.X_ROLLED_UP_BILLING_ADJ_FRCST, T6.X_ROLLED_UP_CATALOGUE_FORECAST, T6.X_ROLLED_UP_CATALO 17,589 1 17,589.0 0.3 0.16 0.84 777143536 Module: fgaOraAgent92_32.exe SELECT T.TS_NUMBER, T.HEADER_FILE, T.HEADER_BLOCK, T.OBJECT_ID F ROM SYS.SYS_OBJECTS T, QUEST_FG_EXT_DETAIL Q WHERE Q.TABLESPACE_ ID = T.TS_NUMBER AND Q.HEADER_FILE = T.HEADER_FILE AND Q.HEADER_ ------------------------------------------------------------- SQL ordered by Executions for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> End Executions Threshold: 100 CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value ------------ --------------- ---------------- ----------- ---------- ---------- 25,666 25,666 1.0 0.00 0.00 1006414593 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user# ,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N VL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 25,664 25,664 1.0 0.00 0.00 3217459477 Module: fgaOraAgent92_32.exe SELECT KTFBUEBLKS LAST_EXTENT_SIZE FROM X$KTFBUE WHERE KTFBUESEG TSN = :B3 AND KTFBUESEGFNO = :B2 AND KTFBUESEGBNO = :B1 ORDER BY KTFBUEEXTNO DESC 23,515 282,157 12.0 0.00 0.00 3311614303 Module: siebproc.exe SELECT TYPE, LOCAL_FLG, LAST_FILE_NUM, LAST_TXN_NUM, LAST_T XNS, LAST_BYTES, TOTAL_BYTES, LAST_SECS, TOTAL_SECS, TOTAL_TXNS, LAST_OPERS, TOTAL_OPERS, LAST_ATTACH_FILE S, TOTAL_ATTACH_FILES, LAST_ATTACH_BYTES, TOTAL_ATTACH_BYTES, ADDTL_INFO, ADDTL_INFO2, LAST_UPD, ROW_ID FROM SI 21,681 42,979 2.0 0.00 0.00 333125733 Module: siebmtsh.exe select LANG_ID from SIEBEL.S_NODE_LANG where NODE_ID = :V1 21,678 21,676 1.0 0.00 0.00 3629097945 Module: siebmtsh.exe select ROW_ID, CUR_NODE_PREFIX, PAR_NODE_ID, ENC_PASS, APP_ SERVER_NAME, EFF_END_DT, NODE_TYPE_CD, ROUTE_ACTIVE_F LG, EXTRCT_ON_SYNC_FLG, ROUTE_ID from SIEBEL.S_ NODE where NAME = :V1 and NODE_TYPE_CD = :V2 4,615 4,615 1.0 0.00 0.00 528673859 Module: siebproc.exe UPDATE SIEBEL.S_DOCK_STATUS SET LAST_UPD = SYSD ATE, LAST_UPD_BY = :V1, MODIFICATION_NUM = MODIFICATION_NUM + 1, LAST_FILE_NUM = :V2, LAST_TXN_NUM = :V3, LAST_TXNS = :V4, TOTAL_TXNS = :V5, LAST_BYTES = :V6, TO 3,494 128,510 36.8 0.00 0.01 109795310 Module: siebmtshmw.exe SELECT T9.CONFLICT_ID, T9.LAST_UPD, T9.CREATED , T9.LAST_UPD_BY, T9.CREATED_BY, T9.MODIFICATI ON_NUM, T9.ROW_ID, T9.ATP_STATUS_CD, T4.TARGET _OU_ID, T9.ACTION_CD, T9.ADJ_UNIT_PRI, T9.ASSE T_INTEG_ID, T9.AUC_ITEM_ID, T9.BASE_UNIT_PRI, 1,905 9,195 4.8 0.00 0.00 663338018 Module: siebproc.exe select arg.NAME, arg.DEFAULT_VALUE, arg.REQUIRED from SIEBEL.S_ACTION_ARG arg, SIEBEL.S_PROG_DEFN prog, SIEBEL.S_PROG_ARG progarg, SIEBEL.S_ACTION_D EFN actn where actn.ROW_ID = :V1 and actn.ROW_ID = a rg.ACTION_ID and actn.PROGRAM_NAME = prog.NAME and SQL ordered by Executions for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> End Executions Threshold: 100 CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value ------------ --------------- ---------------- ----------- ---------- ---------- 1,905 18,240 9.6 0.00 0.00 2473631201 Module: siebproc.exe select arg.NAME, arg.DEFAULT_VALUE, arg.REQUIRED from SIEBEL.S_PROG_ARG arg, SIEBEL.S_PROG_DEFN prog wh ere arg.PROGRAM_ID = prog.ROW_ID and prog.NAME = :V1 and prog.REPOSITORY_ID = :V2 1,563 1,563 1.0 0.00 0.00 1450641585 Module: siebproc.exe delete from SIEBEL.S_DOCK_TXN_LOG where TXN_ID = to_nu mber(:V1) 1,485 5,036 3.4 0.00 0.01 3614847742 Module: siebmtshmw.exe SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED , T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATI ON_NUM, T1.ROW_ID, T1.ATTRIB_35, T1.NAME FR OM SIEBEL.S_PROD_INT_XM T1 WHERE (T1.TYPE = 'T alent') AND (T1.PAR_ROW_ID = :1) 1,151 1,151 1.0 0.00 0.00 3665763022 update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoi n_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_pre ds = range_preds + decode(bitand(:flag,8),0,0,1), 1,139 1,139 1.0 0.00 0.00 1433558559 select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 941 59,549 63.3 0.00 0.02 2975961164 Module: siebmtshmw.exe SELECT T9.CONFLICT_ID, T9.LAST_UPD, T9.CREATED , T9.LAST_UPD_BY, T9.CREATED_BY, T9.MODIFICATI ON_NUM, T9.ROW_ID, T9.ATP_STATUS_CD, T4.TARGET _OU_ID, T9.ACTION_CD, T9.ADJ_UNIT_PRI, T9.ASSE T_INTEG_ID, T9.AUC_ITEM_ID, T9.BASE_UNIT_PRI, 899 5 0.0 0.00 0.00 1316169839 select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= n ext_date) and (next_date < :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5) ) and (this_date is null) order by next_date, job 894 894 1.0 0.00 0.00 1693927332 select count(*) from sys.job$ where (next_date > sysdate) and (n ext_date < (sysdate+5/86400)) 836 797 1.0 0.06 0.06 1263297694 Module: siebmtshmw.exe SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED , T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATI ON_NUM, T1.ROW_ID, T1.CODE, T1.NAME, T1. ORDER_BY, T1.RPLCTN_LVL_CD, T1.SUB_TYPE, T1.TY SQL ordered by Executions for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> End Executions Threshold: 100 CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value ------------ --------------- ---------------- ----------- ---------- ---------- PE, T1.VAL FROM SIEBEL.S_LST_OF_VAL T1 WHERE ------------------------------------------------------------- SQL ordered by Parse Calls for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> End Parse Calls Threshold: 1000 % Total Parse Calls Executions Parses Hash Value ------------ ------------ -------- ---------- 25,666 25,666 68.04 1006414593 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user# ,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N VL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 836 836 2.22 1263297694 Module: siebmtshmw.exe SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED , T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATI ON_NUM, T1.ROW_ID, T1.CODE, T1.NAME, T1. ORDER_BY, T1.RPLCTN_LVL_CD, T1.SUB_TYPE, T1.TY PE, T1.VAL FROM SIEBEL.S_LST_OF_VAL T1 WHERE 394 0 1.04 260339297 insert into sys.col_usage$ values ( :objn, :coln, decode(bit and(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(b itand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode (bitand(:flag,16),0,0,1), decode(bitand(:flag,32),0,0,1), :t ime) 394 394 1.04 2554034351 lock table sys.col_usage$ in exclusive mode nowait 394 1,151 1.04 3665763022 update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoi n_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_pre ds = range_preds + decode(bitand(:flag,8),0,0,1), 266 508 0.71 3051563168 Module: siebmtshmw.exe SELECT T6.CONFLICT_ID, T6.LAST_UPD, T6.CREATED , T6.LAST_UPD_BY, T6.CREATED_BY, T6.MODIFICATI ON_NUM, T6.ROW_ID, T6.ROW_ID, T2.PR_POSTN_ID, T2.PAR_OU_ID, T6.X_ROLLED_UP_BILLING_ADJ_FRCST, T6.X_ROLLED_UP_CATALOGUE_FORECAST, T6.X_ROLLED_UP_CATALO 263 263 0.70 800416496 Module: siebmtshmw.exe SELECT T11.CONFLICT_ID, T11.LAST_UPD, T11.CREA TED, T11.LAST_UPD_BY, T11.CREATED_BY, T11.MODI FICATION_NUM, T11.ROW_ID, T24.OU_NUM, T24.CLIE NT_FLG, T24.CMPT_FLG, T24.BASE_CURCY_CD, T24.D UNS_NUM, T24.PROD_DIST_CD, T24.DIVISION, T4.AT 231 231 0.61 1908793595 Module: siebmtshmw.exe SELECT T5.CONFLICT_ID, T5.LAST_UPD, T5.CREATED , T5.LAST_UPD_BY, T5.CREATED_BY, T5.MODIFICATI ON_NUM, T5.ROW_ID, T2.BASE_CURCY_CD, T2.LOC, T2.NAME, T4.NAME, T6.NAME, T6.BU_FLG, T2.PAR_BU_ID, T2.PAR_DIVN_ID, T5.PAR_PARTY_ID, SQL ordered by Parse Calls for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> End Parse Calls Threshold: 1000 % Total Parse Calls Executions Parses Hash Value ------------ ------------ -------- ---------- 230 230 0.61 269348234 Module: siebmtshmw.exe SELECT T11.CONFLICT_ID, T11.LAST_UPD, T11.CREA TED, T11.LAST_UPD_BY, T11.CREATED_BY, T11.MODI FICATION_NUM, T11.ROW_ID, T11.ATP_MSG, T11.ATP _STATUS_CD, T11.ATP_STATUS_DT, T4.TARGET_OU_ID, T11.ACTION_CD, T11.ADJ_UNIT_PRI, T11.ASSET_INTEG_I 230 230 0.61 1263863536 Module: siebmtshmw.exe SELECT T14.CONFLICT_ID, T14.LAST_UPD, T14.CREA TED, T14.LAST_UPD_BY, T14.CREATED_BY, T14.MODI FICATION_NUM, T14.ROW_ID, T14.ROW_ID, T14.PROD _CD, T6.ACCRUE_UNIT_FLG, T6.ALW_WAIT_LIST_FLG, T14.CASE_PACK, T14.CATEGORY_CD, T2.ROW_ID, T2 202 202 0.54 1086757698 Module: siebmtshmw.exe SELECT T11.CONFLICT_ID, T11.LAST_UPD, T11.CREA TED, T11.LAST_UPD_BY, T11.CREATED_BY, T11.MODI FICATION_NUM, T11.ROW_ID, T11.ATP_MSG, T11.ATP _STATUS_CD, T11.ATP_STATUS_DT, T4.TARGET_OU_ID, T11.ACTION_CD, T11.ADJ_UNIT_PRI, T11.ASSET_INTEG_I 169 169 0.45 1356713530 select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:1 or grantee#= 1) and privilege#>0 154 154 0.41 906139790 Module: siebmtshmw.exe SELECT T11.CONFLICT_ID, T11.LAST_UPD, T11.CREA TED, T11.LAST_UPD_BY, T11.CREATED_BY, T11.MODI FICATION_NUM, T11.ROW_ID, T11.ATP_MSG, T11.ATP _STATUS_CD, T11.ATP_STATUS_DT, T4.TARGET_OU_ID, T11.ACTION_CD, T11.ADJ_UNIT_PRI, T11.ASSET_INTEG_I 144 144 0.38 1139752390 Module: siebmtshmw.exe SELECT T12.CONFLICT_ID, T12.LAST_UPD, T12.CREA TED, T12.LAST_UPD_BY, T12.CREATED_BY, T12.MODI FICATION_NUM, T12.ROW_ID, T12.ATP_MSG, T12.ATP _STATUS_CD, T12.ATP_STATUS_DT, T4.TARGET_OU_ID, T12.ACTION_CD, T12.ADJ_UNIT_PRI, T12.ASSET_INTEG_I 144 144 0.38 2425456590 Module: siebmtshmw.exe UPDATE SIEBEL.S_QUOTE_ITEM SET LAST_UPD = :1, LAST_ UPD_BY = :2, MODIFICATION_NUM = :3, X_QT_HDR = :4 ------------------------------------------------------------- SQL ordered by Sharable Memory for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -> End Sharable Memory Threshold: 1048576 Sharable Mem (b) Executions % Total Hash Value ---------------- ------------ ------- ------------ 5,404,772 2 0.8 1156816394 Module: siebproc.exe select 50 , primary_table.ROW_ID from SIEBEL.S_DOC_QUO TE primary_table, SIEBEL.S_FUNC_TNT S1, SIEBEL.S _FUNC_TNT join_table where join_table.QUOTE_ID = :V1 and S1.QUOTE_ID = primary_table.ROW_ID and join_table .ROW_ID = S1.BASE_FUNCTION_ID UNION ALL select 51 , p 4,606,620 2 0.6 3896639385 Module: siebproc.exe select 0 , primary_table.ROW_ID from SIEBEL.S_CONTACT primary_table, SIEBEL.S_DOC_QUOTE join_table where jo in_table.ROW_ID = :V1 and join_table.SHIP_CON_I D = primary_table.ROW_ID UNION ALL select 1 , primar y_table.ROW_ID from SIEBEL.S_CONTACT primary_table, S 4,411,664 30 0.6 2094642933 Module: siebmtshmw.exe SELECT T29.CONFLICT_ID, T29.LAST_UPD, T29.CREA TED, T29.LAST_UPD_BY, T29.CREATED_BY, T29.MODI FICATION_NUM, T29.ROW_ID, T27.NAME, T27.PR_ADD R_ID, T14.BL_CITY, T14.BL_ZIPCODE, T14.BL_STAT E, T14.BL_ADDR, T27.CONTRACT_VIS_FLG, T29.TARG 4,013,968 1 0.6 3487957026 Module: siebmtshmw.exe SELECT T31.CONFLICT_ID, T31.LAST_UPD, T31.CREA TED, T31.LAST_UPD_BY, T31.CREATED_BY, T31.MODI FICATION_NUM, T31.ROW_ID, T29.NAME, T29.PR_ADD R_ID, T15.BL_CITY, T15.BL_ZIPCODE, T15.BL_STAT E, T15.BL_ADDR, T29.CONTRACT_VIS_FLG, T31.TARG 3,828,136 5 0.5 2859710691 Module: siebmtshmw.exe SELECT T31.CONFLICT_ID, T31.LAST_UPD, T31.CREA TED, T31.LAST_UPD_BY, T31.CREATED_BY, T31.MODI FICATION_NUM, T31.ROW_ID, T29.NAME, T29.PR_ADD R_ID, T15.BL_CITY, T15.BL_ZIPCODE, T15.BL_STAT E, T15.BL_ADDR, T29.CONTRACT_VIS_FLG, T31.TARG 2,611,598 7 0.4 3134749688 Module: siebproc.exe SELECT -1, TO_CHAR (SIEBEL.VIS_DB_MAX_TXN_ID) F ROM SIEBEL.S_DUAL UNION ALL select 1, primary_table.CREATED_BY from SIEBEL.S_DOC_QUOTE primary_table where primary_table. CREATED_BY is not null and primary_table.CREATED_BY <> 'No M atch Row Id' and primary_table.ROW_ID = :V1 U 2,014,956 1 0.3 2682321142 Module: siebproc.exe SELECT -1, TO_CHAR (SIEBEL.VIS_DB_MAX_TXN_ID) F ROM SIEBEL.S_DUAL UNION ALL select 1, J1.BU_ID from SIEBEL. S_PRI_LST_BU J1 where J1.BU_ID is not null and J1.BU_ID <> 'No Match Row Id' and J1.PRI_LST_ID = :V1 UN ION ALL select 2, T1.ROW_ID from SIEBEL.S_ACCNT_SRC T1 whe SQL ordered by Sharable Memory for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -> End Sharable Memory Threshold: 1048576 Sharable Mem (b) Executions % Total Hash Value ---------------- ------------ ------- ------------ 1,820,464 7 0.3 2137479281 Module: siebmtshmw.exe SELECT T31.CONFLICT_ID, T31.LAST_UPD, T31.CREA TED, T31.LAST_UPD_BY, T31.CREATED_BY, T31.MODI FICATION_NUM, T31.ROW_ID, T29.NAME, T29.PR_ADD R_ID, T15.BL_CITY, T15.BL_ZIPCODE, T15.BL_STAT E, T15.BL_ADDR, T29.CONTRACT_VIS_FLG, T31.TARG 1,772,752 2 0.2 2554380758 Module: siebmtshmw.exe SELECT T31.CONFLICT_ID, T31.LAST_UPD, T31.CREA TED, T31.LAST_UPD_BY, T31.CREATED_BY, T31.MODI FICATION_NUM, T31.ROW_ID, T29.NAME, T29.PR_ADD R_ID, T15.BL_CITY, T15.BL_ZIPCODE, T15.BL_STAT E, T15.BL_ADDR, T29.CONTRACT_VIS_FLG, T31.TARG 1,765,612 2 0.2 280113298 Module: siebmtshmw.exe SELECT T29.CONFLICT_ID, T29.LAST_UPD, T29.CREA TED, T29.LAST_UPD_BY, T29.CREATED_BY, T29.MODI FICATION_NUM, T29.ROW_ID, T27.NAME, T27.PR_ADD R_ID, T14.BL_CITY, T14.BL_ZIPCODE, T14.BL_STAT E, T14.BL_ADDR, T27.CONTRACT_VIS_FLG, T29.TARG 1,710,730 1 0.2 2289591005 Module: siebmtshmw.exe SELECT T31.CONFLICT_ID, T31.LAST_UPD, T31.CREA TED, T31.LAST_UPD_BY, T31.CREATED_BY, T31.MODI FICATION_NUM, T31.ROW_ID, T29.NAME, T29.PR_ADD R_ID, T15.BL_CITY, T15.BL_ZIPCODE, T15.BL_STAT E, T15.BL_ADDR, T29.CONTRACT_VIS_FLG, T31.TARG 1,684,028 2 0.2 2321866727 Module: siebproc.exe SELECT -1, TO_CHAR (SIEBEL.VIS_DB_MAX_TXN_ID) F ROM SIEBEL.S_DUAL UNION ALL select 14, J1.EMP_ID from SIEBE L.S_ACT_EMP J1 where J1.EMP_ID is not null and J1.EMP_ID < > 'No Match Row Id' and J1.ACTIVITY_ID = :V1 UNION ALL select 1, primary_table.OWNER_PER_ID from SIEBEL.S 1,654,050 3 0.2 1160692970 Module: siebmtshmw.exe SELECT T32.CONFLICT_ID, T32.LAST_UPD, T32.CREA TED, T32.LAST_UPD_BY, T32.CREATED_BY, T32.MODI FICATION_NUM, T32.ROW_ID, T30.NAME, T30.PR_ADD R_ID, T16.BL_CITY, T16.BL_ZIPCODE, T16.BL_STAT ------------------------------------------------------------- Instance Activity Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ CPU used by this session 40,002 8.9 5.4 CPU used when call started 39,513 8.8 5.3 CR blocks created 337 0.1 0.1 DBWR buffers scanned 84,620 18.8 11.4 DBWR checkpoint buffers written 2,990 0.7 0.4 DBWR checkpoints 0 0.0 0.0 DBWR free buffers found 81,969 18.2 11.1 DBWR lru scans 292 0.1 0.0 DBWR make free requests 481 0.1 0.1 DBWR revisited being-written buff 0 0.0 0.0 DBWR summed scan depth 84,620 18.8 11.4 DBWR transaction table writes 20 0.0 0.0 DBWR undo block writes 2,989 0.7 0.4 SQL*Net roundtrips to/from client 311,635 69.3 42.1 SQL*Net roundtrips to/from dblink 0 0.0 0.0 active txn count during cleanout 820 0.2 0.1 background checkpoints completed 1 0.0 0.0 background checkpoints started 0 0.0 0.0 background timeouts 5,490 1.2 0.7 branch node splits 6 0.0 0.0 buffer is not pinned count 17,167,147 3,814.9 2,317.4 buffer is pinned count 24,385,320 5,419.0 3,291.8 bytes received via SQL*Net from c 44,741,607 9,942.6 6,039.6 bytes received via SQL*Net from d 0 0.0 0.0 bytes sent via SQL*Net to client 158,941,400 35,320.3 21,455.4 bytes sent via SQL*Net to dblink 0 0.0 0.0 calls to get snapshot scn: kcmgss 204,038 45.3 27.5 calls to kcmgas 32,832 7.3 4.4 calls to kcmgcs 624 0.1 0.1 change write time 65 0.0 0.0 cleanout - number of ktugct calls 1,130 0.3 0.2 cleanouts and rollbacks - consist 124 0.0 0.0 cleanouts only - consistent read 85 0.0 0.0 cluster key scan block gets 143,745 31.9 19.4 cluster key scans 89,791 20.0 12.1 commit cleanout failures: block l 0 0.0 0.0 commit cleanout failures: buffer 0 0.0 0.0 commit cleanout failures: callbac 278 0.1 0.0 commit cleanout failures: cannot 11 0.0 0.0 commit cleanouts 20,431 4.5 2.8 commit cleanouts successfully com 20,142 4.5 2.7 commit txn count during cleanout 1,162 0.3 0.2 consistent changes 348 0.1 0.1 consistent gets 26,510,411 5,891.2 3,578.6 consistent gets - examination 10,755,138 2,390.0 1,451.8 current blocks converted for CR 0 0.0 0.0 cursor authentications 140 0.0 0.0 data blocks consistent reads - un 343 0.1 0.1 db block changes 93,966 20.9 12.7 db block gets 98,402 21.9 13.3 deferred (CURRENT) block cleanout 8,065 1.8 1.1 dirty buffers inspected 1,965 0.4 0.3 enqueue conversions 126 0.0 0.0 enqueue releases 46,039 10.2 6.2 enqueue requests 46,037 10.2 6.2 enqueue timeouts 0 0.0 0.0 Instance Activity Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ enqueue waits 1 0.0 0.0 execute count 160,620 35.7 21.7 free buffer inspected 2,437 0.5 0.3 free buffer requested 6,398,185 1,421.8 863.7 hot buffers moved to head of LRU 164,051 36.5 22.2 immediate (CR) block cleanout app 209 0.1 0.0 immediate (CURRENT) block cleanou 4,958 1.1 0.7 index fast full scans (full) 26 0.0 0.0 index fetch by key 4,982,925 1,107.3 672.6 index scans kdiixs1 15,575,282 3,461.2 2,102.5 leaf node 90-10 splits 20 0.0 0.0 leaf node splits 289 0.1 0.0 logons cumulative 184 0.0 0.0 messages received 6,990 1.6 0.9 messages sent 6,990 1.6 0.9 no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 13,792,566 3,065.0 1,861.9 number of map misses 5,865 1.3 0.8 number of map operations 35,199,724 7,822.2 4,751.6 opened cursors cumulative 36,872 8.2 5.0 parse count (failures) 2 0.0 0.0 parse count (hard) 569 0.1 0.1 parse count (total) 37,720 8.4 5.1 parse time cpu 387 0.1 0.1 parse time elapsed 443 0.1 0.1 physical reads 6,394,735 1,421.1 863.2 physical reads direct 14 0.0 0.0 physical writes 7,620 1.7 1.0 physical writes direct 14 0.0 0.0 physical writes non checkpoint 6,721 1.5 0.9 pinned buffers inspected 391 0.1 0.1 prefetch clients - default 0 0.0 0.0 prefetched blocks 5,560,382 1,235.6 750.6 prefetched blocks aged out before 1 0.0 0.0 process last non-idle time 4,499 1.0 0.6 recovery blocks read 0 0.0 0.0 recursive calls 739,176 164.3 99.8 recursive cpu usage 2,160 0.5 0.3 redo blocks written 41,442 9.2 5.6 redo buffer allocation retries 0 0.0 0.0 redo entries 51,139 11.4 6.9 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 19,347,068 4,299.4 2,611.7 redo synch time 724 0.2 0.1 redo synch writes 5,895 1.3 0.8 redo wastage 1,386,640 308.1 187.2 redo write time 529 0.1 0.1 redo writer latching time 0 0.0 0.0 redo writes 6,427 1.4 0.9 rollback changes - undo records a 1 0.0 0.0 rollbacks only - consistent read 208 0.1 0.0 rows fetched via callback 1,329,860 295.5 179.5 session connect time 0 0.0 0.0 session logical reads 26,608,813 5,913.1 3,591.9 Instance Activity Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ session pga memory 12,905,256 2,867.8 1,742.1 session pga memory max 33,753,024 7,500.7 4,556.3 session uga memory 21,473,916,968 4,771,981.6 2,898,746.9 session uga memory max 48,437,320 10,763.9 6,538.5 shared hash latch upgrades - no w 1,939,085 430.9 261.8 shared hash latch upgrades - wait 131 0.0 0.0 sorts (disk) 0 0.0 0.0 sorts (memory) 39,384 8.8 5.3 sorts (rows) 3,232,294 718.3 436.3 summed dirty queue length 4,679 1.0 0.6 switch current to new buffer 161 0.0 0.0 table fetch by rowid 5,577,534 1,239.5 752.9 table fetch continued row 2,291,594 509.2 309.3 table scan blocks gotten 7,511,180 1,669.2 1,013.9 table scan rows gotten 48,853,598 10,856.4 6,594.7 table scans (long tables) 108 0.0 0.0 table scans (short tables) 790 0.2 0.1 transaction rollbacks 1 0.0 0.0 transaction tables consistent rea 0 0.0 0.0 transaction tables consistent rea 0 0.0 0.0 user calls 316,453 70.3 42.7 user commits 5,896 1.3 0.8 user rollbacks 1,512 0.3 0.2 workarea executions - multipass 0 0.0 0.0 workarea executions - onepass 0 0.0 0.0 workarea executions - optimal 43,122 9.6 5.8 write clones created in backgroun 0 0.0 0.0 write clones created in foregroun 0 0.0 0.0 ------------------------------------------------------------- Tablespace IO Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ SIEBEL_DATA 785,738 175 1.0 8.0 745 0 8,645 1.3 SIEBEL_INDEX 42,234 9 2.5 1.1 1,957 0 0 0.0 SYSTEM 6,098 1 1.5 4.7 107 0 0 0.0 UNDOTBS01 5 0 8.0 1.0 3,015 1 6 0.0 PERFSTAT 429 0 2.9 1.1 1,791 0 0 0.0 FOG_DATA 24 0 5.0 4.1 3 0 0 0.0 DBA_MGMT 2 0 0.0 1.0 1 0 0 0.0 FOG_INDEX 2 0 20.0 1.0 1 0 0 0.0 ------------------------------------------------------------- File IO Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ DBA_MGMT E:\ORACLE\ORADATA\SIEB7PRD\DBAMGMT01.DBF 2 0 0.0 1.0 1 0 0 FOG_DATA F:\ORACLE\ORADATA\SIEB7PRD\FOGDATA01.DBF 24 0 5.0 4.1 3 0 0 FOG_INDEX F:\ORACLE\ORADATA\SIEB7PRD\FOGINDEX01.DBF 2 0 20.0 1.0 1 0 0 PERFSTAT F:\ORACLE\ORADATA\SIEB7PRD\PERFECT.DBF 429 0 2.9 1.1 1,791 0 0 SIEBEL_DATA F:\ORACLE\ORADATA\SIEB7PRD\SIEBELDATA01.DBF 446,678 99 1.0 6.8 262 0 4,270 1.5 F:\ORACLE\ORADATA\SIEB7PRD\SIEBELDATA02.DBF 182,886 41 1.0 9.9 183 0 2,453 1.1 F:\ORACLE\ORADATA\SIEB7PRD\SIEBELDATA03.DBF 83,082 18 1.0 9.8 88 0 1,041 1.1 F:\ORACLE\ORADATA\SIEB7PRD\SIEBELDATA04.DBF 73,092 16 0.9 9.0 212 0 881 0.8 SIEBEL_INDEX F:\ORACLE\ORADATA\SIEB7PRD\SIEBELINDEX01.DBF 27,455 6 2.6 1.1 401 0 0 F:\ORACLE\ORADATA\SIEB7PRD\SIEBELINDEX02.DBF 5,393 1 2.3 1.3 888 0 0 F:\ORACLE\ORADATA\SIEB7PRD\SIEBELINDEX03.DBF 5,384 1 2.6 1.3 463 0 0 F:\ORACLE\ORADATA\SIEB7PRD\SIEBELINDEX04.DBF 4,002 1 1.8 1.3 205 0 0 SYSTEM E:\ORACLE\ORADATA\SIEB7PRD\SYSTEM01.DBF 6,098 1 1.5 4.7 107 0 0 UNDOTBS01 F:\ORACLE\ORADATA\SIEB7PRD\UNDOTBS01.DBF 5 0 8.0 1.0 3,015 1 6 0.0 ------------------------------------------------------------- Buffer Pool Statistics for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> Standard block size Pools D: default, K: keep, R: recycle -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k Free Write Buffer Number of Cache Buffer Physical Physical Buffer Complete Busy P Buffers Hit % Gets Reads Writes Waits Waits Waits --- ---------- ----- ----------- ----------- ---------- ------- -------- ------ D 147,456 76.0 26,608,812 6,394,684 7,606 0 0 8,651 ------------------------------------------------------------- Instance Recovery Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> 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 96 18 2681 22892 22521 276480 22521 E 96 17 1103 16115 16042 276480 16042 ------------------------------------------------------------- Buffer wait Statistics for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> ordered by wait time desc, waits desc Tot Wait Avg Class Waits Time (s) Time (ms) ------------------ ----------- ---------- --------- data block 8,645 11 1 undo header 5 0 0 undo block 1 0 0 ------------------------------------------------------------- PGA Aggr Target Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval) -> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory -> 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 Cache Hit % W/A MB Processed Extra W/A MB Read/Written --------------- ---------------- ------------------------- 100.0 1,222 0 %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 300 232 57.1 2.5 4.4 100.0 .0 15,360 E 300 234 52.5 1.1 2.1 100.0 .0 15,360 ------------------------------------------------------------- PGA Aggr Target Histogram for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- ------------- ------------ ------------ 4K 8K 34,726 34,726 0 0 8K 16K 2,836 2,836 0 0 16K 32K 2,673 2,673 0 0 32K 64K 1,243 1,243 0 0 64K 128K 603 603 0 0 128K 256K 316 316 0 0 256K 512K 46 46 0 0 512K 1024K 513 513 0 0 1M 2M 101 101 0 0 2M 4M 46 46 0 0 4M 8M 15 15 0 0 8M 16M 4 4 0 0 ------------------------------------------------------------- PGA Memory Advisory for DB: SIEB7PRD Instance: sieb7prd End Snap: 222 -> 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 ---------- ------- ---------------- ---------------- -------- ---------- 38 0.1 144,768.4 101,283.8 59.0 5,776 75 0.3 144,768.4 51,088.0 74.0 761 150 0.5 144,768.4 32,557.7 82.0 0 225 0.8 144,768.4 11,576.3 93.0 0 300 1.0 144,768.4 10,414.4 93.0 0 360 1.2 144,768.4 9,609.1 94.0 0 420 1.4 144,768.4 9,532.9 94.0 0 480 1.6 144,768.4 9,487.5 94.0 0 540 1.8 144,768.4 9,487.5 94.0 0 600 2.0 144,768.4 9,349.4 94.0 0 900 3.0 144,768.4 8,549.7 94.0 0 1,200 4.0 144,768.4 8,295.1 95.0 0 1,800 6.0 144,768.4 7,906.8 95.0 0 2,400 8.0 144,768.4 7,906.8 95.0 0 ------------------------------------------------------------- Enqueue activity for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> Enqueue stats gathered prior to 9i should not be compared with 9i data -> ordered by Wait Time desc, Waits desc Avg Wt Wait Eq Requests Succ Gets Failed Gets Waits Time (ms) Time (s) -- ------------ ------------ ----------- ----------- ------------- ------------ SQ 103 103 0 1 16.00 0 ------------------------------------------------------------- Rollback Segment Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 ->A high value for "Pct Waits" suggests more rollback segments may be required ->RBS stats may not be accurate between begin and end snaps when using Auto Undo managment, as RBS may be dynamically created and dropped as needed Trans Table Pct Undo Bytes RBS No Gets Waits Written Wraps Shrinks Extends ------ -------------- ------- --------------- -------- -------- -------- 0 21.0 0.00 0 0 0 0 3 2,788.0 0.00 1,711,736 0 0 0 4 1,368.0 0.00 396,124 0 0 0 5 1,673.0 0.00 877,270 0 0 0 6 1,383.0 0.00 546,426 0 0 0 7 1,541.0 0.06 545,376 1 1 0 8 1,590.0 0.00 692,062 0 0 0 9 1,202.0 0.00 478,162 0 0 0 10 1,369.0 0.00 405,264 0 0 0 11 1,923.0 0.00 1,556,706 0 0 0 12 1,167.0 0.00 395,438 0 0 0 ------------------------------------------------------------- Rollback Segment Storage for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 ->Optimal Size should be larger than Avg Active RBS No Segment Size Avg Active Optimal Size Maximum Size ------ --------------- --------------- --------------- --------------- 0 389,120 6,553 389,120 3 721,547,264 72,375,751 3,624,005,632 4 3,125,932,032 491,405,921 3,125,932,032 5 671,215,616 84,359,439 2,613,178,368 6 2,523,000,832 912,123,286 2,523,000,832 7 222,425,088 60,209,526 885,125,120 8 529,657,856 87,379,290 838,987,776 9 469,889,024 112,031,480 2,751,590,400 10 268,562,432 25,758,988 2,080,501,760 11 2,533,552,128 525,167,215 2,533,552,128 12 419,557,376 38,125,195 539,095,040 ------------------------------------------------------------- Undo Segment Summary for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> Undo segment block stats: -> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed -> eS - expired Stolen, eR - expired Released, eU - expired reUsed Undo Undo Num Max Qry Max Tx Snapshot Out of uS/uR/uU/ TS# Blocks Trans Len (s) Concurcy Too Old Space eS/eR/eU ---- -------------- ---------- -------- ---------- -------- ------ ------------- 18 2,525 ########## 422 2 0 0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> ordered by Time desc Undo Num Max Qry Max Tx Snap Out of uS/uR/uU/ End Time Blocks Trans Len (s) Concy Too Old Space eS/eR/eU ------------ ------------ -------- ------- -------- ------- ------ ------------- 06-May 11:41 150 ######## 117 1 0 0 0/0/0/0/0/0 06-May 11:31 281 ######## 22 2 0 0 0/0/0/0/0/0 06-May 11:21 480 ######## 252 1 0 0 0/0/0/0/0/0 06-May 11:11 412 ######## 422 1 0 0 0/0/0/0/0/0 06-May 11:01 347 ######## 138 2 0 0 0/0/0/0/0/0 06-May 10:51 223 ######## 12 1 0 0 0/0/0/0/0/0 06-May 10:41 132 ######## 57 1 0 0 0/0/0/0/0/0 06-May 10:31 500 ######## 51 1 0 0 0/0/0/0/0/0 ------------------------------------------------------------- Latch Activity for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 ->"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 Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ Consistent RBA 6,427 0.0 0 0 FAL request queue 90 0.0 0 0 FOB s.o list latch 670 0.0 0 0 SQL memory manager latch 5 0.0 0 1,498 0.0 SQL memory manager worka 112,517 0.0 0 0 active checkpoint queue 2,390 0.0 0 0 archive control 1,421 0.0 0 0 archive process latch 120 0.0 0 0 cache buffer handles 903,372 0.0 0.0 0 0 cache buffers chains 49,106,982 0.0 0.0 0 12,569,958 0.0 cache buffers lru chain 13,216 0.1 0.0 0 13,490,401 0.0 channel handle pool latc 363 0.0 0 0 channel operations paren 3,595 0.0 0 0 checkpoint queue latch 1,643,154 0.0 0 6,040 0.0 child cursor hash table 9,203 0.0 0 0 dml lock allocation 16,881 0.1 0.0 0 0 dummy allocation 373 0.0 0 0 enqueue hash chains 92,203 0.0 0.0 0 0 enqueues 75,553 0.0 0.0 0 0 event group latch 179 0.0 0 0 hash table column usage 710 0.0 0 383,331 0.0 job workq parent latch 0 0 10 20.0 job_queue_processes para 80 0.0 0 0 ktm global data 18 0.0 0 0 lgwr LWN SCN 7,051 0.1 0.0 0 0 library cache 847,932 0.2 0.0 0 15,515 0.0 library cache load lock 1,148 0.0 0 0 library cache pin 509,228 0.1 0.0 0 0 library cache pin alloca 170,651 0.0 0 0 list of block allocation 282 0.0 0 0 loader state object free 12 0.0 0 0 longop free list parent 67 0.0 0 22 0.0 mapped buffers lru chain 5,866 0.1 0.0 0 0 messages 32,309 0.0 0.0 0 0 mostly latch-free SCN 7,046 0.1 0.0 0 0 multiblock read objects 1,426,356 0.0 0.0 0 0 ncodef allocation latch 72 0.0 0 0 post/wait queue 9,582 0.0 0 5,892 0.1 process allocation 363 0.3 0.0 0 178 0.6 process group creation 363 0.0 0 0 redo allocation 64,602 0.0 0.0 0 0 redo copy 0 0 51,154 0.1 redo writing 24,820 0.0 0 0 row cache enqueue latch 2,419,818 0.0 0.0 0 0 row cache objects 2,421,821 0.0 0 2 0.0 sequence cache 6,223 0.0 0 0 session allocation 28,646 0.0 0.0 0 0 session idle bit 646,589 0.0 0.0 0 0 session switching 72 0.0 0 0 session timer 1,515 0.0 0 0 Latch Activity for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 ->"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 Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ shared pool 376,803 0.0 0.0 0 0 sim partition latch 0 0 793 0.0 sort extent pool 88 0.0 0 0 transaction allocation 37,471 0.0 0 0 transaction branch alloc 72 0.0 0 0 undo global data 24,220 0.0 0 0 user lock 676 0.0 0 0 ------------------------------------------------------------- Latch Sleep breakdown for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> ordered by misses desc Get Spin & Latch Name Requests Misses Sleeps Sleeps 1->4 -------------------------- -------------- ----------- ----------- ------------ cache buffers chains 49,106,982 10,228 73 10162/59/7/0 /0 shared pool 376,803 100 3 97/3/0/0/0 ------------------------------------------------------------- Latch Miss Sources for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- cache buffers chains kcbgtcr: kslbegin excl 0 61 50 cache buffers chains kcbrls: kslbegin 0 6 14 cache buffers chains kcbgcur: kslbegin 0 3 0 cache buffers chains kcbchg: kslbegin: bufs not 0 2 4 cache buffers chains kcbgtcr: fast path 0 1 0 shared pool kghupr1 0 2 3 shared pool kghalo 0 1 0 ------------------------------------------------------------- Dictionary Cache Stats for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 ->"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 Cache Requests Miss Reqs Miss Reqs Usage ------------------------- ------------ ------ ------- ----- -------- ---------- dc_files 406 0.0 0 0 14 dc_histogram_defs 16,887 0.1 0 0 26,935 dc_object_ids 1,085,376 0.0 0 0 6,853 dc_objects 4,683 0.2 0 0 2,186 dc_profiles 169 0.0 0 0 1 dc_rollback_segments 942 0.0 0 0 30 dc_segments 59,385 0.0 0 5 9,348 dc_sequences 102 0.0 0 102 6 dc_tablespace_quotas 20 0.0 0 5 4 dc_tablespaces 30,027 0.0 0 0 20 dc_user_grants 1,058 0.0 0 0 31 dc_usernames 4,772 0.0 0 0 23 dc_users 7,682 0.0 0 0 33 ------------------------------------------------------------- Library Cache Activity for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 ->"Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 146 1.4 146 1.4 0 0 CLUSTER 80 0.0 66 0.0 0 0 SQL AREA 37,362 1.3 243,968 0.4 48 0 TABLE/PROCEDURE 8,425 1.6 16,452 3.5 24 0 TRIGGER 645 0.2 645 0.5 2 0 ------------------------------------------------------------- Shared Pool Advisory for DB: SIEB7PRD Instance: sieb7prd End Snap: 222 -> 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 Estd Shared Pool SP Estd Estd Estd Lib LC Time Size for Size Lib Cache Lib Cache Cache Time Saved Estd Lib Cache Estim (M) Factr Size (M) Mem Obj Saved (s) Factr Mem Obj Hits ----------- ----- ---------- ------------ ------------ ------- --------------- 368 .6 324 19,117 280,513 1.0 24,426,479 432 .7 387 30,297 280,530 1.0 24,428,338 496 .8 450 41,347 280,551 1.0 24,430,145 560 .9 513 52,795 280,570 1.0 24,431,916 624 1.0 576 64,494 280,595 1.0 24,433,715 688 1.1 639 76,115 280,601 1.0 24,435,007 752 1.2 702 87,323 280,606 1.0 24,436,204 816 1.3 765 96,253 280,609 1.0 24,437,314 880 1.4 828 103,287 280,612 1.0 24,445,757 944 1.5 891 108,482 280,617 1.0 24,461,224 1,008 1.6 954 112,902 280,620 1.0 24,471,802 1,072 1.7 1,017 118,326 280,623 1.0 24,477,969 1,136 1.8 1,080 121,655 280,626 1.0 24,485,109 1,200 1.9 1,143 124,971 280,640 1.0 24,518,775 1,264 2.0 1,263 129,168 280,660 1.0 24,574,195 ------------------------------------------------------------- SGA Memory Summary for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 SGA regions Size in Bytes ------------------------------ ---------------- Database Buffers 603,979,776 Fixed Size 455,924 Redo Buffers 2,240,512 Variable Size 864,026,624 ---------------- sum 1,470,702,836 ------------------------------------------------------------- SGA breakdown difference for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 Pool Name Begin value End value % Diff ------ ------------------------------ ---------------- ---------------- ------- java free memory 33,554,432 33,554,432 0.00 large free memory 117,440,512 117,440,512 0.00 shared 1M buffer 2,098,176 2,098,176 0.00 shared Checkpoint queue 4,516,864 4,516,864 0.00 shared DML lock 174,244 174,244 0.00 shared FileIdentificatonBlock 323,292 323,292 0.00 shared FileOpenBlock 1,130,084 1,130,084 0.00 shared KGK heap 3,756 3,756 0.00 shared KGLS heap 15,540,572 18,916,452 21.72 shared KQR M PO 18,566,228 18,567,764 0.01 shared KQR S PO 2,542,344 2,542,344 0.00 shared KQR S SO 8,504 8,504 0.00 shared KQR X PO 2,432 2,432 0.00 shared KSXR large reply queue 166,584 166,584 0.00 shared KSXR pending messages que 841,036 841,036 0.00 shared KSXR receive buffers 1,033,000 1,033,000 0.00 shared MTTR advisory 169,336 169,336 0.00 shared PL/SQL DIANA 1,404,664 1,894,160 34.85 shared PL/SQL MPCODE 2,695,828 3,338,076 23.82 shared PLS non-lib hp 3,372 3,372 0.00 shared VLM link array 1,757,184 1,757,184 0.00 shared db_block_buffers 29,491,200 29,491,200 0.00 shared db_block_hash_buckets 2,826,296 2,826,296 0.00 shared db_handles 180,000 180,000 0.00 shared dictionary cache 2,137,216 2,137,216 0.00 shared enqueue 300,832 300,832 0.00 shared errors 233,712 233,712 0.00 shared event statistics per sess 3,159,520 3,159,520 0.00 shared fixed allocation callback 388 388 0.00 shared free memory 74,329,800 97,741,428 31.50 shared joxs heap init 400 400 0.00 shared ksm_file2sga region 370,496 370,496 0.00 shared library cache 97,943,552 90,511,592 -7.59 shared message pool freequeue 665,792 665,792 0.00 shared miscellaneous 27,427,400 27,303,576 -0.45 shared parameters 159,920 238,664 49.24 shared processes 250,000 250,000 0.00 shared session param values 761,608 782,192 2.70 shared sessions 676,480 676,480 0.00 shared sim trace entries 1,572,864 1,572,864 0.00 shared sql area 416,620,220 396,150,100 -4.91 shared table definiti 9,552 12,640 32.33 shared trace buffer 753,664 753,664 0.00 shared transaction 169,248 169,248 0.00 shared trigger defini 12,204 14,652 20.06 shared trigger inform 1,716 1,968 14.69 shared trigger source 100 100 0.00 fixed_sga 455,924 455,924 0.00 log_buffer 2,229,248 2,229,248 0.00 ------------------------------------------------------------- init.ora Parameters for DB: SIEB7PRD Instance: sieb7prd Snaps: 217 -222 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- _b_tree_bitmap_plans FALSE _no_or_expansion TRUE _shared_pool_reserved_pct 10 background_dump_dest D:\oracle\admin\SIEB7PRD\bdump compatible 9.2.0.0.0 control_files e:\oracle\oradata\SIEB7PRD\contro core_dump_dest D:\oracle\admin\SIEB7PRD\cdump db_block_buffers 147456 db_block_size 4096 db_domain db_file_multiblock_read_count 32 db_name SIEB7PRD distributed_lock_timeout 150 fast_start_mttr_target 300 hash_join_enabled TRUE instance_name SIEB7PRD java_pool_size 33554432 job_queue_processes 200 large_pool_size 117440512 log_archive_dest H:\oracle\oradata\SIEB7PRD\Archiv log_archive_start TRUE log_buffer 2097152 max_enabled_roles 50 open_cursors 1500 optimizer_index_caching 100 optimizer_index_cost_adj 10 pga_aggregate_target 314572800 processes 250 query_rewrite_enabled FALSE remote_login_passwordfile EXCLUSIVE resource_limit TRUE shared_pool_size 654311424 sort_area_retained_size 2097152 sort_area_size 1572864 star_transformation_enabled TRUE timed_statistics TRUE undo_management AUTO undo_retention 14400 undo_tablespace UNDOTBS01 use_indirect_data_buffers TRUE user_dump_dest D:\oracle\admin\SIEB7PRD\udump ------------------------------------------------------------- End of Report