STATSPACK report for DB Name DB Id Instance Inst Num Release Cluster Host ------------ ----------- ------------ -------- ----------- ------- ------------ UATIMNG 593576851 uatimng 1 9.2.0.6.0 NO gecfsdev08 Snap Id Snap Time Sessions Curs/Sess Comment --------- ------------------ -------- --------- ------------------- Begin Snap: 2468 06-Oct-06 13:00:01 130 15.6 End Snap: 2469 06-Oct-06 14:00:04 137 17.1 Elapsed: 60.05 (mins) Cache Sizes (end) ~~~~~~~~~~~~~~~~~ Buffer Cache: 868M Std Block Size: 16K Shared Pool Size: 1,008M Log Buffer: 46,080K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 16,734.74 89,858.81 Logical reads: 2,328.33 12,502.21 Block changes: 106.55 572.12 Physical reads: 263.83 1,416.64 Physical writes: 0.53 2.82 User calls: 23.12 124.12 Parses: 7.48 40.18 Hard parses: 0.12 0.64 Sorts: 3.49 18.73 Logons: 0.02 0.10 Executes: 15.15 81.33 Transactions: 0.19 % Blocks changed per Read: 4.58 Recursive Call %: 49.48 Rollback per transaction %: 0.15 Rows per Sort: 943.75 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 96.31 In-memory Sort %: 100.00 Library Hit %: 99.45 Soft Parse %: 98.41 Execute to Parse %: 50.60 Latch Hit %: 99.99 Parse CPU to Parse Elapsd %: 19.19 % Non-Parse CPU: 93.25 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 38.07 40.46 % SQL with executions>1: 72.08 71.21 % Memory for SQL w/exec>1: 50.58 49.88 Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time -------------------------------------------- ------------ ----------- -------- PX Deq Credit: send blkd 604,570 15,475 78.62 PX qref latch 44,033 953 4.84 library cache pin 301 666 3.38 CPU time 625 3.18 direct path read 80,838 516 2.62 ------------------------------------------------------------- Wait Events for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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 ---------------------------- ------------ ---------- ---------- ------ -------- PX Deq Credit: send blkd 604,570 1,759 15,475 26 901.0 PX qref latch 44,033 43,940 953 22 65.6 library cache pin 301 219 666 2213 0.4 direct path read 80,838 0 516 6 120.5 PX Deq: Execute Reply 1,949 7 445 229 2.9 PX Deq Credit: need buffer 25,781 116 386 15 38.4 db file scattered read 40,410 0 346 9 60.2 SQL*Net break/reset to clien 142 0 54 382 0.2 latch free 544 88 50 92 0.8 db file sequential read 7,844 0 47 6 11.7 log file parallel write 2,086 0 31 15 3.1 control file parallel write 1,186 0 30 25 1.8 log file sync 574 0 20 34 0.9 LGWR wait for redo copy 824 622 13 15 1.2 db file parallel write 161 0 11 68 0.2 library cache lock 3 2 6 2129 0.0 process startup 13 2 4 289 0.0 SQL*Net more data to client 1,920 0 2 1 2.9 PX Deq: Signal ACK 39 15 1 34 0.1 control file sequential read 406 0 1 2 0.6 enqueue 10 0 1 51 0.0 PX Deq: Parse Reply 35 0 0 14 0.1 PX Deq: Msg Fragment 33 0 0 12 0.0 PX Deq: Join ACK 36 0 0 5 0.1 SQL*Net message from dblink 24 0 0 8 0.0 single-task message 1 0 0 100 0.0 SQL*Net more data from dblin 18 0 0 0 0.0 SQL*Net message to dblink 24 0 0 0 0.0 buffer busy waits 1 0 0 0 0.0 SQL*Net message from client 87,572 0 165,342 1888 130.5 PX Deq: Execution Msg 11,237 8,984 17,716 1577 16.7 PX Idle Wait 2,801 2,749 5,431 1939 4.2 pipe get 5,721 425 2,063 361 8.5 PX Deq: Table Q Normal 106,068 213 1,225 12 158.1 jobq slave wait 66 63 192 2906 0.1 SQL*Net more data from clien 1,180 0 43 37 1.8 SQL*Net message to client 87,582 0 1 0 130.5 ------------------------------------------------------------- Background Wait Events for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> ordered by wait time desc, waits desc (idle events last) Avg Total Wait wait Waits Event Waits Timeouts Time (s) (ms) /txn ---------------------------- ------------ ---------- ---------- ------ -------- log file parallel write 2,086 0 31 15 3.1 control file parallel write 1,187 0 30 25 1.8 LGWR wait for redo copy 824 622 13 15 1.2 db file parallel write 161 0 11 68 0.2 latch free 12 7 2 154 0.0 control file sequential read 357 0 1 2 0.5 db file sequential read 3 0 0 16 0.0 db file scattered read 1 0 0 24 0.0 rdbms ipc message 4,340 3,567 13,975 3220 6.5 smon timer 13 13 3,654 ###### 0.0 pmon timer 1,238 1,236 3,509 2835 1.8 ------------------------------------------------------------- SQL ordered by Gets for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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 --------------- ------------ -------------- ------ -------- --------- ---------- 396,766 6 66,127.7 4.7 144.85 841.90 1438501810 Module: PL/SQL Developer SELECT /*+ Q645000 NO_EXPAND ROWID(A1) */ A1."SUPL_QUAL_ID" C0 F ROM "IMANAGE"."IMANAGE_F_COST" PX_GRANULE(0, BLOCK_RANGE, DYNAMI C) A1 188,932 660 286.3 2.3 28.03 792.23 642206150 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.Sp_Img_Get_Tf_Ctc_Data(:1,:2,:3,:4,:5,: 6); END; 172,387 14 12,313.4 2.1 43.63 252.13 3247664323 insert into source$(obj#,line,source) values (:1,:2,:3) 137,611 2 68,805.5 1.6 46.06 277.89 2578354377 Module: PL/SQL Developer SELECT /*+ Q641000 NO_EXPAND ROWID(A1) */ A1."INS_GRP" C0 FROM " IMANAGE"."IMANAGE_F_INVTRY_MONTHLY" PX_GRANULE(0, BLOCK_RANGE, D YNAMIC) A1 107,256 6 17,876.0 1.3 2.10 7.53 3310443653 Module: PLSQLDev.exe select s.synonym_name object_name, o.object_type from sys.all_sy nonyms s, sys.all_objects o where s.owner in ('PUBLIC', use r) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCED URE', 'FUNCTION', 'SEQUENCE') 105,315 118 892.5 1.3 28.62 171.76 2825547595 Module: JDBC Thin Client call Imanage_Pkg_Dboard.SP_IMG_WRAP_L2_ANALYSIS_DATA(:1,:2,:3,:4 ,:5,:6,:7,:8,:9,:10) 96,632 1,175 82.2 1.2 11.50 519.14 2350047460 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_img_get_fleet(:1,:2,:3,:4,:5,:6); EN D; 88,090 2 44,045.0 1.1 31.98 210.95 560661386 Module: PL/SQL Developer SELECT /*+ Q638000 NO_EXPAND ROWID(A1) */ A1."COUNTRY_CD",A1."EN TITY_CD",A1."INVC_ID",A1."INVC_LINE_ID",A1."SEQ_NUM",A1."VEHICLE _FLT_NUM",A1."CUST_HIER_ID",A1."MONTH_ID",A1."MAKE_ID",A1."MAKE_ NAME",A1."MODEL_ID",A1."MODEL_NAME",A1."OEM_GRP_ID",A1."OEM_GRP_ NAME",A1."PRODUCT_CD",A1."PRODUCT_NAME",A1."PRODUCT_TYPE_CD",A1. 88,040 1 88,040.0 1.0 26.58 149.39 2950628864 Module: JDBC Thin Client SELECT 0 ID,0 NAME,999999999 VALUE,1 COLOR_GE,0 NON_GE_VALUE,0 C OLOR_NONGE, NULL MIN,NULL MAX,NULL TARGET,NULL UNITS,0 MINIMUM, SQL ordered by Gets for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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 --------------- ------------ -------------- ------ -------- --------- ---------- 0 MAXIMUM,'N' EXPIRED FROM DUAL UNION ALL SELECT BUCKET ID,BUCKE T NAME,SUM(VALUE) VALUE,MOD((BUCKET+1),2) COLOR_GE,0 NON_GE_VALU E,0 COLOR_NONGE,NULL L_VAL,NULL U_VAL,NULL TARGET,COUNT(*) UNITS 88,038 1 88,038.0 1.0 26.23 148.62 1132754514 Module: JDBC Thin Client SELECT '0' ID,0 NAME,0 VALUE,1 COLOR,0 NON_GE_VALUE,0 NON_GE_COL OR_CODE ,0 MIN ,0 MAX , 0 TARGET,0 UNITS,0 SEQ,'0' U OM FROM DUAL UNION ALL SELECT ID, SEQ NAME,VALUE, MOD(ROWNUM+1,2) COLOR,0 NON_GE_VALUE, 0 NON_GE_COLOR_CODE,0 MIN,0 MAX,0 TARGET,UNITS, SEQ, 'DAYS' UOM 88,036 1 88,036.0 1.0 26.81 163.62 3295613036 Module: JDBC Thin Client SELECT SUM(VALUE) FROM ( SELECT VEHICLE_SEQ_NUM ,VALUE,CEIL(ROWN UM/UNITS) BUCKET, COLOR_GE,0 NON_GE_VALUE,0 COLOR_NONGE,NULL L_V AL,NULL U_VAL,UNITS FROM ( SELECT VEHICLE_SEQ_NUM, CTC_ VAL VALUE, 0 COLOR_GE,0 NON_GE_VALUE,0 COLOR_NONGE,0 L_VAL, 0 U_VAL,CEIL(SUM(1) OVER (PARTITION BY 1)/5) UNITS FROM 72,307 37 1,954.2 0.9 16.31 73.58 1736230682 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_LEVEL3_DATA(:1,:2,:3,:4,:5,: 6,:7,:8,:9,:10,:11,:12,:13); END; 68,637 1,185 57.9 0.8 8.14 304.17 779345195 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_BREADCRUM(:1,:2,:3,:4,:5,:6, :7); END; 67,640 2 33,820.0 0.8 2.32 9.73 2586824080 Module: JDBC Thin Client SELECT * FROM (SELECT DATA_SET.*,ROWNUM RNUM FROM (SELECT rs.COU NTRY_CD,rs.VEHICLE_FLT_NUM,rs.VEHICLE_REG_NUM,NVL(NVL(CREF3.LANG _VAL,(SELECT IMANAGE_TARGET_CD_TRANS_REF.LANG_VAL FROM IMANAGE_T ARGET_CD_TRANS_REF WHERE TARGET_CD =OEM_GRP_ID AND LANG_CD = 'E' AND CROSS_REF_TYPE = 'OEM_GROUP')),'Value Not Available'),NVL(N 59,431 14 4,245.1 0.7 12.77 83.21 3098922061 delete from source$ where obj#=:1 48,267 1 48,267.0 0.6 13.56 91.02 3527260041 Module: PL/SQL Developer select distinct i.vehicle_ncap_rating from imanage_f_invtry_mont hly i 46,844 491 95.4 0.6 6.14 60.12 868372637 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_INV_NEXT_LEVEL_OEM(:1,:2,:3, :4,:5,:6); END; SQL ordered by Gets for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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 --------------- ------------ -------------- ------ -------- --------- ---------- 43,735 7,754 5.6 0.5 10.71 3616.77 2672765485 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.Sp_Img_Get_Localization(:1,:2,:3,:4,:5, :6,:7,:8); END; 41,880 1,511 27.7 0.5 8.89 277.49 649400624 Module: JDBC Thin Client call Imanage_Pkg_Dboard.SP_IMG_GET_TREND_ANALYSIS_DATA(:1,:2,:3, :4,:5,:6,:7,:8,:9) 39,161 9 4,351.2 0.5 23.18 135.61 3072235254 Module: JDBC Thin Client BEGIN IMANAGE_IREPORT_PKG.SP_IMG_GET_LEVEL3_DATA_ORG(:1,:2,:3,:4 ,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15); END; 37,260 4 9,315.0 0.4 0.38 0.93 1854826745 Module: JDBC Thin Client SELECT '0' ID,0 NAME,0 VALUE,1 COLOR,0 NON_GE_VALUE,0 NON_GE_COL OR_CODE ,0 MIN ,0 MAX , 0 TARGET,0 UNITS, 0 SEQ,'0' UOM FROM DUAL UNION ALL SELECT ID,SEQ NAME,VALUE, MOD(ROWNUM+1,2) COLOR,0 NON_GE_VALUE, 0 NON_GE_COLOR_CODE,0 MIN,0 MAX,0 TARGET,1 UNITS, SEQ, 'G/KM' UO 33,595 1 33,595.0 0.4 1.33 5.03 2813279703 Module: JDBC Thin Client SELECT * FROM (SELECT DATA_SET.*,ROWNUM RNUM FROM (SELECT rs.COU ------------------------------------------------------------- SQL ordered by Reads for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> End Disk Reads Threshold: 1000 CPU Elapsd Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- 395,637 6 65,939.5 41.6 144.85 841.90 1438501810 Module: PL/SQL Developer SELECT /*+ Q645000 NO_EXPAND ROWID(A1) */ A1."SUPL_QUAL_ID" C0 F ROM "IMANAGE"."IMANAGE_F_COST" PX_GRANULE(0, BLOCK_RANGE, DYNAMI C) A1 137,176 2 68,588.0 14.4 46.06 277.89 2578354377 Module: PL/SQL Developer SELECT /*+ Q641000 NO_EXPAND ROWID(A1) */ A1."INS_GRP" C0 FROM " IMANAGE"."IMANAGE_F_INVTRY_MONTHLY" PX_GRANULE(0, BLOCK_RANGE, D YNAMIC) A1 87,850 2 43,925.0 9.2 31.98 210.95 560661386 Module: PL/SQL Developer SELECT /*+ Q638000 NO_EXPAND ROWID(A1) */ A1."COUNTRY_CD",A1."EN TITY_CD",A1."INVC_ID",A1."INVC_LINE_ID",A1."SEQ_NUM",A1."VEHICLE _FLT_NUM",A1."CUST_HIER_ID",A1."MONTH_ID",A1."MAKE_ID",A1."MAKE_ NAME",A1."MODEL_ID",A1."MODEL_NAME",A1."OEM_GRP_ID",A1."OEM_GRP_ NAME",A1."PRODUCT_CD",A1."PRODUCT_NAME",A1."PRODUCT_TYPE_CD",A1. 83,570 660 126.6 8.8 28.03 792.23 642206150 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.Sp_Img_Get_Tf_Ctc_Data(:1,:2,:3,:4,:5,: 6); END; 80,721 118 684.1 8.5 28.62 171.76 2825547595 Module: JDBC Thin Client call Imanage_Pkg_Dboard.SP_IMG_WRAP_L2_ANALYSIS_DATA(:1,:2,:3,:4 ,:5,:6,:7,:8,:9,:10) 80,717 1 80,717.0 8.5 26.81 163.62 3295613036 Module: JDBC Thin Client SELECT SUM(VALUE) FROM ( SELECT VEHICLE_SEQ_NUM ,VALUE,CEIL(ROWN UM/UNITS) BUCKET, COLOR_GE,0 NON_GE_VALUE,0 COLOR_NONGE,NULL L_V AL,NULL U_VAL,UNITS FROM ( SELECT VEHICLE_SEQ_NUM, CTC_ VAL VALUE, 0 COLOR_GE,0 NON_GE_VALUE,0 COLOR_NONGE,0 L_VAL, 0 U_VAL,CEIL(SUM(1) OVER (PARTITION BY 1)/5) UNITS FROM 80,715 1 80,715.0 8.5 26.58 149.39 2950628864 Module: JDBC Thin Client SELECT 0 ID,0 NAME,999999999 VALUE,1 COLOR_GE,0 NON_GE_VALUE,0 C OLOR_NONGE, NULL MIN,NULL MAX,NULL TARGET,NULL UNITS,0 MINIMUM, 0 MAXIMUM,'N' EXPIRED FROM DUAL UNION ALL SELECT BUCKET ID,BUCKE T NAME,SUM(VALUE) VALUE,MOD((BUCKET+1),2) COLOR_GE,0 NON_GE_VALU E,0 COLOR_NONGE,NULL L_VAL,NULL U_VAL,NULL TARGET,COUNT(*) UNITS 79,668 1 79,668.0 8.4 26.23 148.62 1132754514 Module: JDBC Thin Client SELECT '0' ID,0 NAME,0 VALUE,1 COLOR,0 NON_GE_VALUE,0 NON_GE_COL OR_CODE ,0 MIN ,0 MAX , 0 TARGET,0 UNITS,0 SEQ,'0' U OM FROM DUAL UNION ALL SELECT ID, SEQ NAME,VALUE, MOD(ROWNUM+1,2) COLOR,0 NON_GE_VALUE, 0 NON_GE_COLOR_CODE,0 MIN,0 MAX,0 TARGET,UNITS, SEQ, 'DAYS' UOM SQL ordered by Reads for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> End Disk Reads Threshold: 1000 CPU Elapsd Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- 48,228 1 48,228.0 5.1 13.56 91.02 3527260041 Module: PL/SQL Developer select distinct i.vehicle_ncap_rating from imanage_f_invtry_mont hly i 10,784 6 1,797.3 1.1 3.94 21.17 4072673112 Module: PL/SQL Developer SELECT /*+ Q640000 NO_EXPAND ROWID(A1) */ A1."VEHICLE_NCAP_RATIN G" FROM "IMANAGE"."IMANAGE_F_INVTRY_MONTHLY" PX_GRANULE(0, BLOCK _RANGE, DYNAMIC) A1 5,344 1 5,344.0 0.6 1.65 5.93 1697670914 Module: PL/SQL Developer select distinct d.cust_acc_id from imanage_d_cust_hier d,imanage _user_cust_hier_acc_mv u where u.user_id='244' and u.child_cust_ hier_id=d.cust_hier_id 5,342 1 5,342.0 0.6 4.87 24.63 557241982 Module: PL/SQL Developer select distinct cust_acc_id, entity_cd from imanage_d_cust_hier where cust_acc_id in( 10008420, 10015200, 4294860, 4297410, 421 4859, 4271278, 4313555, 64237, 75405, 88491, 88492, 91364, 1346, 88123) 3,430 1 3,430.0 0.4 1.44 7.58 4108336649 Module: PL/SQL Developer select * from imanage_user_cust_hier_acc_mv where parent_cust_hi er_id='64237' 3,397 1 3,397.0 0.4 1.04 4.40 3559248997 Module: PL/SQL Developer select d.cust_acc_id from imanage_d_cust_hier d,imanage_user_cus t_hier_acc_mv u where u.user_id='244' and u.child_cust_hier_id=d .cust_hier_id 1,028 1,175 0.9 0.1 11.50 519.14 2350047460 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_img_get_fleet(:1,:2,:3,:4,:5,:6); EN D; 387 1,185 0.3 0.0 8.14 304.17 779345195 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_BREADCRUM(:1,:2,:3,:4,:5,:6, :7); END; 240 4 60.0 0.0 0.46 1.82 1458953812 Module: JDBC Thin Client select max(type) type, instrument, variant, sum(sample_sz) m y_size, round(sum(counter)/sum(sample_sz), 2) cost, max(crea t_dt) my_date from instrument where instrument like '%TIME%' and variant!='n/a' and SYSDATE-TO_DATE(creat_dt)<7 group by i nstrument, variant order by instrument, type desc, variant 174 1 174.0 0.0 2.97 17.40 333476733 SQL ordered by Reads for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> End Disk Reads Threshold: 1000 CPU Elapsd Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_d ate; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 93 217 0.4 0.0 1.52 5.88 4053949783 Module: JDBC Thin Client SELECT TRUNC(MAX(CREATION_DATE)) FROM IMANAGE_F_USER_L1_AGG WHER E CTC_ID = :B2 AND USER_ID = :B1 92 82 1.1 0.0 0.92 16.06 1213654564 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.sp_img_save_temp_table(:1,:2,:3,:4,:5,: 6); END; 76 37 2.1 0.0 16.31 73.58 1736230682 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_LEVEL3_DATA(:1,:2,:3,:4,:5,: ------------------------------------------------------------- SQL ordered by Executions for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> End Executions Threshold: 100 CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value ------------ --------------- ---------------- ----------- ---------- ---------- 7,754 7,750 1.0 0.00 0.47 2672765485 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.Sp_Img_Get_Localization(:1,:2,:3,:4,:5, :6,:7,:8); END; 4,287 4,287 1.0 0.00 0.00 2746462422 Module: JDBC Thin Client SELECT SETTINGS FROM IMANAGE_LOCALE_SET_FOR_CHARTS WHERE LOCALE_ TYPE = :B2 AND LOCALE_CD = :B1 3,582 0 0.0 0.00 0.00 1175024512 Module: JDBC Thin Client SELECT * FROM AdTransactionsRegister WHERE timestamp>1155891 143449 order by timestamp asc ,trans_id 3,582 0 0.0 0.00 0.00 1212947864 Module: JDBC Thin Client SELECT * FROM AdTransactionsRegister WHERE timestamp>1156859 292932 order by timestamp asc ,trans_id 2,250 2,250 1.0 0.00 0.00 1307778841 select condition from cdef$ where rowid=:1 1,572 1,572 1.0 0.00 0.01 363903461 insert into argument$( obj#,procedure$,procedure#,overload#,posi tion#,sequence#,level#,argument,type#,default#,in_out,length,pre cision#,scale,radix,charsetid,charsetform,properties,type_owner, type_name,type_subname,type_linkname,pls_type) values (:1,:2,:3, :4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:2 1,539 0 0.0 0.00 0.00 3033577820 update object_usage set flags=flags+1 where obj#=:1 and bitand(f lags, 1)=0 1,511 0 0.0 0.01 0.18 649400624 Module: JDBC Thin Client call Imanage_Pkg_Dboard.SP_IMG_GET_TREND_ANALYSIS_DATA(:1,:2,:3, :4,:5,:6,:7,:8,:9) 1,426 1,426 1.0 0.00 0.00 2698345333 Module: JDBC Thin Client SELECT CURRENCY, DATE_FORMAT, NUM_VAL_FORMAT, COUNTRY_CD FROM IM ANAGE_USR_PROFILE WHERE SINGLE_SIGN_ON_ID = :B1 1,426 1,426 1.0 0.00 0.00 3580715423 Module: JDBC Thin Client SELECT B.LOCALE_LANG_CD FROM IMANAGE_USR_PROFILE A, IMANAGE_LANG UAGE B WHERE B.LANG_CD = A.SCREEN_LANG_CD AND SINGLE_SIGN_ON_ID = :B1 1,424 1,424 1.0 0.00 0.02 3651845221 Module: JDBC Thin Client BEGIN Sp_Img_Get_Locale_Settings(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10, :11); END; SQL ordered by Executions for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> End Executions Threshold: 100 CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value ------------ --------------- ---------------- ----------- ---------- ---------- 1,197 1,197 1.0 0.00 0.29 3330132191 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.sp_img_pop_all_DBOARD(:1,:2,:3,:4,:5,:6 ,:7,:8,:9); END; 1,196 1,196 1.0 0.00 0.48 2659396290 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_FUNCTIONAL(:1,:2,:3,:4,:5,:6 ,:7,:8,:9,:10,:11); END; 1,185 1,186 1.0 0.01 0.26 779345195 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_BREADCRUM(:1,:2,:3,:4,:5,:6, :7); END; 1,175 1,175 1.0 0.00 0.37 460769906 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_PRODUCT_LIST(:1,:2,:3,:4,:5, :6,:7); END; 1,175 1,175 1.0 0.01 0.44 2350047460 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_img_get_fleet(:1,:2,:3,:4,:5,:6); EN D; 999 999 1.0 0.00 0.00 1857249856 Module: JDBC Thin Client SELECT IUP.DATA_LANG_CD FROM IMANAGE_USR_PROFILE IUP WHERE USER_ ID= TRIM(:B1 ) 747 747 1.0 0.00 0.00 3147293336 Module: JDBC Thin Client SELECT COUNT(1) FROM (SELECT IDR.DROPD_CD FROM IMANAGE_TRANS_REF ITR ,IMANAGE_DROPDOWN_REF IDR WHERE IDR.DROPD_TYPE= :B2 AND ITR .BASE_VAL(+)=IDR.DROPD_VALUE AND ITR.LANG_CD(+)=:B1 AND ITR.TRAN SLATION_TYPE(+)='TYP_OTH' AND ROWNUM = 1 ) 744 2,728 3.7 0.00 0.00 341861971 Module: JDBC Thin Client SELECT IDR.DROPD_CD ,DECODE(ITR.LANG_VAL,NULL,IDR.DROPD_VALUE,IT R.LANG_VAL) DROPDOWN_VALUE FROM IMANAGE_TRANS_REF ITR ,IMANAGE_D ROPDOWN_REF IDR WHERE IDR.DROPD_TYPE= :B2 AND ITR.BASE_VAL(+)=ID R.DROPD_VALUE AND ITR.LANG_CD(+)=:B1 AND ITR.TRANSLATION_TYPE(+) ='TYP_OTH' 718 1 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 717 717 1.0 0.00 0.00 1693927332 select count(*) from sys.job$ where (next_date > sysdate) and (n SQL ordered by Executions for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> End Executions Threshold: 100 CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value ------------ --------------- ---------------- ----------- ---------- ---------- ext_date < (sysdate+5/86400)) 660 660 1.0 0.04 1.20 642206150 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.Sp_Img_Get_Tf_Ctc_Data(:1,:2,:3,:4,:5,: 6); END; 660 0 0.0 0.00 0.00 1053795750 Module: JDBC Thin Client COMMIT 502 502 1.0 0.01 0.82 4183530633 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_COST_CTC_DATA(:1,:2,:3,:4,:5 ,:6); END; 491 491 1.0 0.01 0.12 868372637 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_INV_NEXT_LEVEL_OEM(:1,:2,:3, :4,:5,:6); END; 484 484 1.0 0.01 0.11 3485899899 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_INV_CTC_DATA(:1,:2,:3,:4,:5) ; END; 482 48 0.1 0.00 0.00 1645094912 Module: JDBC Thin Client SELECT LANG_VAL FROM IMANAGE_TRANS_REF ITR WHERE ITR.BASE_VAL = 'ALL COMBINED' AND ITR.LANG_CD = :B1 AND TRANSLATION_TYPE = 'TYP _OTH' ------------------------------------------------------------- SQL ordered by Parse Calls for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> End Parse Calls Threshold: 1000 % Total Parse Calls Executions Parses Hash Value ------------ ------------ -------- ---------- 7,754 7,754 28.76 2672765485 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.Sp_Img_Get_Localization(:1,:2,:3,:4,:5, :6,:7,:8); END; 3,582 3,582 13.29 1175024512 Module: JDBC Thin Client SELECT * FROM AdTransactionsRegister WHERE timestamp>1155891 143449 order by timestamp asc ,trans_id 3,582 3,582 13.29 1212947864 Module: JDBC Thin Client SELECT * FROM AdTransactionsRegister WHERE timestamp>1156859 292932 order by timestamp asc ,trans_id 2,250 2,250 8.35 1307778841 select condition from cdef$ where rowid=:1 1,539 1,539 5.71 3033577820 update object_usage set flags=flags+1 where obj#=:1 and bitand(f lags, 1)=0 1,511 1,511 5.61 649400624 Module: JDBC Thin Client call Imanage_Pkg_Dboard.SP_IMG_GET_TREND_ANALYSIS_DATA(:1,:2,:3, :4,:5,:6,:7,:8,:9) 1,424 1,424 5.28 3651845221 Module: JDBC Thin Client BEGIN Sp_Img_Get_Locale_Settings(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10, :11); END; 1,197 1,197 4.44 3330132191 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.sp_img_pop_all_DBOARD(:1,:2,:3,:4,:5,:6 ,:7,:8,:9); END; 1,196 1,196 4.44 2659396290 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_FUNCTIONAL(:1,:2,:3,:4,:5,:6 ,:7,:8,:9,:10,:11); END; 1,185 1,185 4.40 779345195 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_BREADCRUM(:1,:2,:3,:4,:5,:6, :7); END; 1,175 1,175 4.36 460769906 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_PRODUCT_LIST(:1,:2,:3,:4,:5, :6,:7); END; 1,175 1,175 4.36 2350047460 Module: JDBC Thin Client SQL ordered by Parse Calls for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> End Parse Calls Threshold: 1000 % Total Parse Calls Executions Parses Hash Value ------------ ------------ -------- ---------- BEGIN Imanage_Pkg_Dboard.SP_img_get_fleet(:1,:2,:3,:4,:5,:6); EN D; 744 744 2.76 341861971 Module: JDBC Thin Client SELECT IDR.DROPD_CD ,DECODE(ITR.LANG_VAL,NULL,IDR.DROPD_VALUE,IT R.LANG_VAL) DROPDOWN_VALUE FROM IMANAGE_TRANS_REF ITR ,IMANAGE_D ROPDOWN_REF IDR WHERE IDR.DROPD_TYPE= :B2 AND ITR.BASE_VAL(+)=ID R.DROPD_VALUE AND ITR.LANG_CD(+)=:B1 AND ITR.TRANSLATION_TYPE(+) ='TYP_OTH' 660 660 2.45 642206150 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.Sp_Img_Get_Tf_Ctc_Data(:1,:2,:3,:4,:5,: 6); END; 502 502 1.86 4183530633 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_COST_CTC_DATA(:1,:2,:3,:4,:5 ,:6); END; 491 491 1.82 868372637 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_INV_NEXT_LEVEL_OEM(:1,:2,:3, :4,:5,:6); END; 484 484 1.80 3485899899 Module: JDBC Thin Client BEGIN Imanage_Pkg_Dboard.SP_IMG_GET_INV_CTC_DATA(:1,:2,:3,:4,:5) ; END; 372 372 1.38 2707513792 Module: PL/SQL Developer begin :id := sys.dbms_transaction.local_transaction_id; end; 248 248 0.92 2697590481 Module: JDBC Thin Client SELECT IDR.DROPD_CD ,DECODE(ITR.LANG_VAL,NULL,INITCAP(IDR.DROPD_ VALUE),ITR.LANG_VAL) DROPDOWN_VALUE FROM IMANAGE_TRANS_REF ITR , IMANAGE_DROPDOWN_REF IDR WHERE IDR.DROPD_TYPE= :B3 AND ITR.BASE_ VAL(+)=IDR.DROPD_VALUE AND ITR.LANG_CD(+)=:B2 AND ITR.TRANSLATIO N_TYPE(+)=:B1 ORDER BY 2 ASC 175 175 0.65 1715689858 Module: PL/SQL Developer begin sys.dbms_output.get_lines(lines => :lines, numlines => : numlines); end; 150 150 0.56 4098155192 Module: PL/SQL Developer declare ret binary_integer; begin ret := PBSDE.DEBUG_LOOP; end; 140 140 0.52 3293499221 Module: PL/SQL Developer SQL ordered by Parse Calls for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> End Parse Calls Threshold: 1000 % Total Parse Calls Executions Parses Hash Value ------------ ------------ -------- ---------- select 'x' from dual 137 137 0.51 915064226 Module: PL/SQL Developer begin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end; 118 118 0.44 2825547595 Module: JDBC Thin Client call Imanage_Pkg_Dboard.SP_IMG_WRAP_L2_ANALYSIS_DATA(:1,:2,:3,:4 ,:5,:6,:7,:8,:9,:10) 115 115 0.43 523165058 Module: JDBC Thin Client SELECT RS.ANALID,DECODE(ITR1.LANG_VAL,NULL,INITCAP(RS.ANALNAME), ITR1.LANG_VAL) ANALNAME, DECODE(ITR2.LANG_VAL,NULL,INITCAP(RS.AN ALTYPE),ITR2.LANG_VAL) ANALTYPE FROM (SELECT ILA.L2_ANAL_ID ANAL ID ,UPPER(ILA.L2_ANAL_NAME) ANALNAME ,ILA.L2_ANAL_TYPE ANALTYPE ,ILA.GRP_DISPL_SEQ GDS ,ILA.AN_DISPL_SEQ ADS FROM IMANAGE_L2_ANA 109 109 0.40 1335151445 Module: JDBC Thin Client SELECT RS.PRODUCT_CD , NVL(TR.LANG_VAL, NVL( (SELE CT LANG_VAL FROM IMANAGE_TARGET_CD_TRANS_REF WHERE C ROSS_REF_TYPE = 'PRODUCT' AND TARGET_CD = RS.PRODUCT _CD AND LANG_CD = 'E'), 'Value Not Available' )) PRODUC T FROM IMANAGE_TARGET_CD_TRANS_REF TR,(SELECT PRODUCT_CD 104 104 0.39 1184094708 Module: JDBC Thin Client SELECT 0 CTCID,'0' CTCNAME ,0 CTCSUM,'0' MIN,'0' MAX,0 DS,0 LSL, 0 USL FROM DUAL UNION SELECT CTC_SUM.CTCID,NVL(ITR.LANG_VAL,CTC _SUM.CTCNAME),CTC_SUM.CTCSUM ,(SELECT 'Y' FROM DU AL WHERE CTC_SUM.CTCSUM < LSL_VAL) MIN ,(SELECT ------------------------------------------------------------- Instance Activity Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ active txn count during cleanout 3,449 1.0 5.1 background checkpoints completed 0 0.0 0.0 background checkpoints started 0 0.0 0.0 background timeouts 4,290 1.2 6.4 branch node splits 0 0.0 0.0 buffer is not pinned count 4,112,700 1,141.5 6,129.2 buffer is pinned count 37,664,337 10,453.6 56,131.7 bytes received via SQL*Net from c 7,033,167 1,952.0 10,481.6 bytes received via SQL*Net from d 57,298 15.9 85.4 bytes sent via SQL*Net to client 11,578,028 3,213.4 17,254.9 bytes sent via SQL*Net to dblink 8,132 2.3 12.1 Cached Commit SCN referenced 53,494 14.9 79.7 calls to get snapshot scn: kcmgss 4,345,265 1,206.0 6,475.8 calls to kcmgas 4,329 1.2 6.5 calls to kcmgcs 389 0.1 0.6 change write time 30,378 8.4 45.3 cleanout - number of ktugct calls 3,481 1.0 5.2 cleanouts and rollbacks - consist 3,163 0.9 4.7 cleanouts only - consistent read 29 0.0 0.0 cluster key scan block gets 5,874 1.6 8.8 cluster key scans 1,363 0.4 2.0 commit cleanout failures: block l 0 0.0 0.0 commit cleanout failures: buffer 0 0.0 0.0 commit cleanout failures: callbac 1 0.0 0.0 commit cleanout failures: cannot 0 0.0 0.0 commit cleanouts 2,103 0.6 3.1 commit cleanouts successfully com 2,102 0.6 3.1 Commit SCN cached 13 0.0 0.0 commit txn count during cleanout 52 0.0 0.1 consistent changes 3,405 1.0 5.1 consistent gets 8,759,408 2,431.1 13,054.3 consistent gets - examination 522,237 145.0 778.3 CPU used by this session 62,511 17.4 93.2 CPU used when call started 62,257 17.3 92.8 CR blocks created 3,174 0.9 4.7 cursor authentications 166 0.1 0.3 data blocks consistent reads - un 3,401 0.9 5.1 db block changes 383,891 106.6 572.1 db block gets 261,954 72.7 390.4 DBWR buffers scanned 27 0.0 0.0 DBWR checkpoint buffers written 1,891 0.5 2.8 DBWR checkpoints 0 0.0 0.0 DBWR free buffers found 27 0.0 0.0 DBWR lru scans 1 0.0 0.0 DBWR make free requests 1 0.0 0.0 DBWR revisited being-written buff 0 0.0 0.0 DBWR summed scan depth 27 0.0 0.0 DBWR transaction table writes 17 0.0 0.0 DBWR undo block writes 969 0.3 1.4 deferred (CURRENT) block cleanout 1,449 0.4 2.2 DFO trees parallelized 12 0.0 0.0 dirty buffers inspected 1 0.0 0.0 enqueue conversions 173 0.1 0.3 enqueue releases 6,856 1.9 10.2 enqueue requests 7,062 2.0 10.5 enqueue timeouts 207 0.1 0.3 Instance Activity Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ enqueue waits 10 0.0 0.0 exchange deadlocks 0 0.0 0.0 execute count 54,574 15.2 81.3 free buffer inspected 16 0.0 0.0 free buffer requested 314,131 87.2 468.2 hot buffers moved to head of LRU 3,078 0.9 4.6 immediate (CR) block cleanout app 3,192 0.9 4.8 immediate (CURRENT) block cleanou 272 0.1 0.4 index fast full scans (full) 1,478 0.4 2.2 index fetch by key 285,067 79.1 424.8 index scans kdiixs1 197,957 54.9 295.0 leaf node splits 22 0.0 0.0 leaf node 90-10 splits 1 0.0 0.0 logons cumulative 67 0.0 0.1 messages received 944 0.3 1.4 messages sent 944 0.3 1.4 no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 3,740,653 1,038.2 5,574.7 opened cursors cumulative 26,878 7.5 40.1 Parallel operations downgraded to 1 0.0 0.0 Parallel operations downgraded 1 2 0.0 0.0 Parallel operations downgraded 25 5 0.0 0.0 Parallel operations downgraded 50 4 0.0 0.0 Parallel operations not downgrade 1 0.0 0.0 parse count (failures) 77 0.0 0.1 parse count (hard) 429 0.1 0.6 parse count (total) 26,958 7.5 40.2 parse time cpu 4,222 1.2 6.3 parse time elapsed 21,999 6.1 32.8 physical reads 950,563 263.8 1,416.6 physical reads direct 641,296 178.0 955.7 physical reads direct (lob) 0 0.0 0.0 physical writes 1,892 0.5 2.8 physical writes direct 0 0.0 0.0 physical writes non checkpoint 1,478 0.4 2.2 pinned buffers inspected 0 0.0 0.0 prefetch clients - default 0 0.0 0.0 prefetched blocks 261,013 72.4 389.0 prefetched blocks aged out before 2 0.0 0.0 PX local messages recv'd 909,598 252.5 1,355.6 PX local messages sent 909,632 252.5 1,355.6 queries parallelized 12 0.0 0.0 recursive calls 81,577 22.6 121.6 recursive cpu usage 15,709 4.4 23.4 redo blocks written 122,295 33.9 182.3 redo buffer allocation retries 0 0.0 0.0 redo entries 193,585 53.7 288.5 redo log space requests 0 0.0 0.0 redo log space wait time 0 0.0 0.0 redo ordering marks 210 0.1 0.3 redo size 60,295,264 16,734.7 89,858.8 redo synch time 2,037 0.6 3.0 redo synch writes 688 0.2 1.0 redo wastage 327,396 90.9 487.9 redo write time 3,112 0.9 4.6 redo writer latching time 1,269 0.4 1.9 Instance Activity Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ redo writes 1,045 0.3 1.6 rollback changes - undo records a 1 0.0 0.0 rollbacks only - consistent read 11 0.0 0.0 rows fetched via callback 205,624 57.1 306.4 session connect time 0 0.0 0.0 session cursor cache count 154 0.0 0.2 session cursor cache hits 21,158 5.9 31.5 session logical reads 8,388,984 2,328.3 12,502.2 session pga memory 64,164,336 17,808.6 95,624.9 session pga memory max 144,494,992 40,104.1 215,342.8 session uga memory 4,319,246,712 1,198,791.8 6,437,029.4 session uga memory max 81,360,112 22,581.2 121,252.0 shared hash latch upgrades - no w 197,450 54.8 294.3 shared hash latch upgrades - wait 7 0.0 0.0 sorts (disk) 0 0.0 0.0 sorts (memory) 12,570 3.5 18.7 sorts (rows) 11,862,984 3,292.5 17,679.6 SQL*Net roundtrips to/from client 87,436 24.3 130.3 SQL*Net roundtrips to/from dblink 24 0.0 0.0 summed dirty queue length 1 0.0 0.0 switch current to new buffer 69 0.0 0.1 table fetch by rowid 19,088,349 5,297.9 28,447.6 table fetch continued row 45 0.0 0.1 table scan blocks gotten 3,166,169 878.8 4,718.6 table scan rows gotten 44,796,765 12,433.2 66,761.2 table scans (direct read) 1,911 0.5 2.9 table scans (long tables) 1,921 0.5 2.9 table scans (rowid ranges) 1,911 0.5 2.9 table scans (short tables) 2,142,362 594.6 3,192.8 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 83,285 23.1 124.1 user commits 670 0.2 1.0 user rollbacks 1 0.0 0.0 workarea executions - multipass 0 0.0 0.0 workarea executions - onepass 0 0.0 0.0 workarea executions - optimal 9,118 2.5 13.6 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: UATIMNG Instance: uatimng Snaps: 2468 -2469 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ IMANAGE_TBL_LARGE 123,205 34 57.9 7.5 0 0 0 0.0 IMANAGE_TBL_MEDIUM 2,994 1 4.7 4.8 0 0 0 0.0 TEMP 1,218 0 ###### 7.0 0 0 0 0.0 IMANAGE_IDX_LARGE 768 0 14.3 1.0 292 0 0 0.0 UNDOTBS 0 0 0.0 1,007 0 1 0.0 IMANAGE_MV_TBL_MEDIUM 476 0 9.3 7.2 1 0 0 0.0 SYSTEM 141 0 38.9 1.0 322 0 0 0.0 STATPACK 100 0 16.7 1.0 192 0 0 0.0 IMANAGE_TBL_SMALL 106 0 22.1 1.7 44 0 0 0.0 IMANAGE_IDX_SMALL 31 0 17.7 1.6 34 0 0 0.0 PORTAL 44 0 6.6 5.7 0 0 0 0.0 IMANAGE_IDX_MEDIUM 7 0 20.0 1.0 0 0 0 0.0 IMANAGE 1 0 30.0 1.0 0 0 0 0.0 ------------------------------------------------------------- File IO Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ IMANAGE /imngdata1/oradata/uatimng/IMANAGE02.dbf 1 0 30.0 1.0 0 0 0 IMANAGE_IDX_LARGE /imngdata2/oradata/uatimng/IMANAGE_IDX_LARGE01.dbf 357 0 13.9 1.0 130 0 0 /imngdata2/oradata/uatimng/IMANAGE_IDX_LARGE02.dbf 411 0 14.5 1.0 162 0 0 IMANAGE_IDX_MEDIUM /imngdata1/oradata/uatimng/IMANAGE_IDX_MEDIUM01.dbf 7 0 20.0 1.0 0 0 0 IMANAGE_IDX_SMALL /imngdata1/oradata/uatimng/IMANAGE_IDX_SMALL01.dbf 31 0 17.7 1.6 34 0 0 IMANAGE_MV_TBL_MEDIUM /imngbkp/oradata/uatimng/IMANAGE_MV_TBL_MEDIUM01.dbf 252 0 8.7 7.1 1 0 0 /imngbkp/oradata/uatimng/IMANAGE_MV_TBL_MEDIUM02.dbf 224 0 10.0 7.3 0 0 0 IMANAGE_TBL_LARGE /imngbkp/oradata/uatimng/IMANAGE_TBL_LARGE01.dbf 21,203 6 38.2 7.2 0 0 0 /imngbkp/oradata/uatimng/IMANAGE_TBL_LARGE02.dbf 20,204 6 37.0 7.5 0 0 0 /imngbkp/oradata/uatimng/IMANAGE_TBL_LARGE03.dbf 20,014 6 78.2 7.5 0 0 0 /imngbkp/oradata/uatimng/IMANAGE_TBL_LARGE04.dbf 20,318 6 87.7 7.5 0 0 0 /imngbkp/oradata/uatimng/IMANAGE_TBL_LARGE05.dbf 21,256 6 46.4 7.6 0 0 0 /imngdata5/oradata/uatimng/IMANAGE_TBL_LARGE06.dbf 20,210 6 61.4 7.6 0 0 0 IMANAGE_TBL_MEDIUM /u02/miles/oradata/uatimng/IMANAGE_TBL_MEDIUM01.dbf 2,994 1 4.7 4.8 0 0 0 IMANAGE_TBL_SMALL /u02/miles/oradata/uatimng/IMANAGE_TBL_SMALL01.dbf 106 0 22.1 1.7 44 0 0 PORTAL /u02/miles/oradata/uatimng/PORTAL01.dbf 44 0 6.6 5.7 0 0 0 STATPACK /imngdata4/oradata/uatimng/STATPACK01.dbf 100 0 16.7 1.0 192 0 0 SYSTEM /imngdata4/oradata/uatimng/SYSTEM01.dbf 141 0 38.9 1.0 322 0 0 TEMP /imngbkp/oradata/uatimng/TEMP04.dbf 289 0 ###### 7.0 0 0 0 /imngdata1/oradata/uatimng/TEMP03.dbf 332 0 ###### 7.0 0 0 0 /imngdata4/oradata/uatimng/TEMP01.dbf File IO Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ 198 0 ###### 7.0 0 0 0 TEMP /u02/miles/oradata/uatimng/TEMP02.dbf 399 0 ###### 7.0 0 0 0 UNDOTBS /imngbkp/oradata/uatimng/UNDOTBS0.dbf4 0 0 134 0 0 /imngbkp/oradata/uatimng/UNDOTBS02.dbf 0 0 374 0 0 /imngbkp/oradata/uatimng/UNDOTBS03.dbf 0 0 207 0 0 /imngdata1/oradata/uatimng/UNDOTBS05.dbf 0 0 147 0 0 /imngdata3/oradata/uatimng/UNDOTBS01.dbf 0 0 145 0 1 0.0 ------------------------------------------------------------- Buffer Pool Statistics for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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 55,552 96.3 8,385,423 309,266 1,892 0 0 1 ------------------------------------------------------------- Instance Recovery Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> B: Begin snapshot, E: End snapshot Targt Estd Log File Log Ckpt Log Ckpt MTTR MTTR Recovery Actual Target Size Timeout Interval (s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks - ----- ----- ---------- ---------- ---------- ---------- ---------- ---------- B 0 19 560 4475 3640 221184 3640 E 0 29 1046 54620 54618 221184 54618 ------------------------------------------------------------- Buffer wait Statistics for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> ordered by wait time desc, waits desc Tot Wait Avg Class Waits Time (s) Time (ms) ------------------ ----------- ---------- --------- undo header 1 0 0 ------------------------------------------------------------- PGA Aggr Target Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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 426 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 1,500 1,278 349.7 116.4 33.3 100.0 .0 76,800 E 1,500 1,270 402.4 131.4 32.6 100.0 .0 76,800 ------------------------------------------------------------- PGA Aggr Target Histogram for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- ------------- ------------ ------------ 16K 32K 8,615 8,615 0 0 32K 64K 71 71 0 0 64K 128K 80 80 0 0 128K 256K 70 70 0 0 256K 512K 28 28 0 0 512K 1024K 235 235 0 0 1M 2M 21 21 0 0 2M 4M 10 10 0 0 4M 8M 1 1 0 0 8M 16M 1 1 0 0 ------------------------------------------------------------- PGA Memory Advisory for DB: UATIMNG Instance: uatimng End Snap: 2469 -> 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 ---------- ------- ---------------- ---------------- -------- ---------- 188 0.1 79,764.6 209,833.8 28.0 11 375 0.3 79,764.6 179,975.5 31.0 0 750 0.5 79,764.6 85,739.8 48.0 0 1,125 0.8 79,764.6 55,273.7 59.0 0 1,500 1.0 79,764.6 51,697.6 61.0 0 1,800 1.2 79,764.6 50,457.9 61.0 0 2,100 1.4 79,764.6 50,457.9 61.0 0 2,400 1.6 79,764.6 50,457.9 61.0 0 2,700 1.8 79,764.6 50,457.9 61.0 0 3,000 2.0 79,764.6 50,457.9 61.0 0 4,500 3.0 79,764.6 50,457.9 61.0 0 6,000 4.0 79,764.6 50,457.9 61.0 0 9,000 6.0 79,764.6 50,457.9 61.0 0 12,000 8.0 79,764.6 50,457.9 61.0 0 ------------------------------------------------------------- Enqueue activity for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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) -- ------------ ------------ ----------- ----------- ------------- ------------ PS 416 209 207 10 52.70 1 ------------------------------------------------------------- Rollback Segment Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 ->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 13.0 0.00 0 0 0 0 1 206.0 0.00 369,982 2 0 1 2 214.0 0.00 201,454 2 0 1 3 357.0 0.00 1,101,876 3 0 2 4 83.0 0.00 5,314 0 0 0 5 724.0 0.00 5,505,494 7 0 6 6 206.0 0.00 557,868 0 0 0 7 311.0 0.00 1,507,150 1 0 1 8 621.0 0.00 4,955,896 6 0 5 9 403.0 0.00 4,585,558 6 0 5 10 824.0 0.00 5,979,644 8 0 7 ------------------------------------------------------------- Rollback Segment Storage for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 ->Optimal Size should be larger than Avg Active RBS No Segment Size Avg Active Optimal Size Maximum Size ------ --------------- --------------- --------------- --------------- 0 442,368 0 442,368 1 9,551,872 7,811,645 285,327,360 2 9,551,872 7,140,550 243,253,248 3 10,600,448 6,121,471 150,978,560 4 16,891,904 4,559,105 369,213,440 5 14,794,752 5,731,729 345,096,192 6 9,551,872 11,080,698 671,203,328 7 84,000,768 10,922,936 360,890,368 8 13,746,176 68,286,133 570,540,032 9 13,746,176 64,459,731 704,757,760 10 15,843,328 5,591,367 229,752,832 ------------------------------------------------------------- Undo Segment Summary for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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 ---- -------------- ---------- -------- ---------- -------- ------ ------------- 1 1,657 805,591 321 4 0 0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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-Oct 14:03 238 115,454 169 4 0 0 0/0/0/0/0/0 06-Oct 13:53 494 115,369 50 2 0 0 0/0/0/0/0/0 06-Oct 13:43 2 115,228 24 2 0 0 0/0/0/0/0/0 06-Oct 13:33 357 115,050 321 3 0 0 0/0/0/0/0/0 06-Oct 13:23 190 115,047 142 3 0 0 0/0/0/0/0/0 06-Oct 13:13 225 114,801 152 3 0 0 0/0/0/0/0/0 06-Oct 13:03 151 114,642 128 3 0 0 0/0/0/0/0/0 ------------------------------------------------------------- Latch Activity for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 ->"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 ------------------------ -------------- ------ ------ ------ ------------ ------ active checkpoint queue 1,355 0.0 0 0 archive control 1 0.0 0 0 cache buffer handles 19,236 0.0 0 0 cache buffers chains 17,286,274 0.0 0.5 0 582,555 0.0 cache buffers lru chain 1,964 0.0 0 634,469 0.0 channel handle pool latc 131 0.0 0 0 channel operations paren 2,590 0.0 0 0 checkpoint queue latch 128,941 0.0 1.0 0 2,369 0.0 child cursor hash table 3,520 0.0 0 0 Consistent RBA 1,046 0.0 0 0 dml lock allocation 5,489 0.0 0 0 dummy allocation 231 0.0 0 0 enqueue hash chains 14,139 0.0 0.0 0 0 enqueues 10,128 0.0 0.3 0 0 error message lists 89 1.1 0.0 0 0 event group latch 68 0.0 0 0 FOB s.o list latch 264 0.0 0 0 global tx hash mapping 44 0.0 0 0 hash table column usage 177 0.0 0 555,536 0.0 job workq parent latch 0 0 2 0.0 job_queue_processes para 61 0.0 0 0 ktm global data 13 0.0 0 0 lgwr LWN SCN 1,540 0.0 0 0 library cache 462,831 0.1 0.3 23 7 0.0 library cache load lock 32 0.0 0 0 library cache pin 312,271 0.0 0.2 0 0 library cache pin alloca 105,021 0.0 0.1 0 0 list of block allocation 108 0.0 0 0 loader state object free 3,822 0.0 0.0 0 0 longop free list parent 2,482 0.0 0 5 0.0 messages 11,334 0.0 0.0 0 0 mostly latch-free SCN 1,543 0.1 0.0 0 0 multiblock read objects 92,326 0.0 0 0 ncodef allocation latch 60 0.0 0 0 parallel query alloc buf 1,102 0.7 0.0 0 0 parallel query stats 85 7.1 0.0 0 0 post/wait queue 870 0.0 0 575 0.0 process allocation 84 0.0 0 68 0.0 process group creation 131 0.0 0 0 process queue 244 0.0 0 0 process queue reference 23,701,320 0.0 0.1 2 1,538,847 89.5 query server freelists 345 0.0 0 0 query server process 15 0.0 0 14 0.0 redo allocation 196,174 0.0 0.5 2 0 redo copy 0 0 193,708 0.4 redo writing 6,985 0.0 0 0 row cache enqueue latch 441,916 0.0 1.0 0 0 row cache objects 443,898 0.0 0.3 0 0 sequence cache 192 0.0 0 0 session allocation 7,368 0.3 0.2 0 0 Latch Activity for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 ->"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 ------------------------ -------------- ------ ------ ------ ------------ ------ session idle bit 169,669 0.0 0.0 0 0 session switching 60 0.0 0 0 session timer 1,239 0.0 0 0 shared pool 84,236 0.1 0.4 21 0 sort extent pool 73 0.0 0 0 SQL memory manager latch 1 0.0 0 1,186 0.0 SQL memory manager worka 83,329 0.0 0 0 transaction allocation 56 0.0 0 0 transaction branch alloc 102 0.0 0 0 undo global data 10,146 0.0 0 0 user lock 200 0.0 0 0 ------------------------------------------------------------- Latch Sleep breakdown for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> ordered by misses desc Get Spin & Latch Name Requests Misses Sleeps Sleeps 1->4 -------------------------- -------------- ----------- ----------- ------------ process queue reference 23,701,320 3,018 292 2729/286/3/0 /0 library cache 462,831 412 108 305/106/1/0/ 0 cache buffers chains 17,286,274 175 90 0/0/0/0/0 shared pool 84,236 79 28 51/28/0/0/0 library cache pin 312,271 54 9 45/9/0/0/0 session allocation 7,368 24 5 19/5/0/0/0 redo allocation 196,174 14 7 7/7/0/0/0 library cache pin allocati 105,021 9 1 8/1/0/0/0 enqueues 10,128 4 1 3/1/0/0/0 row cache objects 443,898 3 1 2/1/0/0/0 checkpoint queue latch 128,941 1 1 0/1/0/0/0 row cache enqueue latch 441,916 1 1 0/1/0/0/0 ------------------------------------------------------------- Latch Miss Sources for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 -> 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 31 53 cache buffers chains kcbgtcr: fast path 0 22 10 cache buffers chains kcbchg: kslbegin: call CR 0 12 3 cache buffers chains kcbrls: kslbegin 0 10 8 cache buffers chains kcbchg: kslbegin: bufs not 0 7 1 cache buffers chains kcbzib: finish free bufs 0 5 2 cache buffers chains kcbget: exchange 0 3 0 checkpoint queue latch kcbkllrba: compute lowest 0 1 0 enqueues ksqdel 0 1 1 library cache kglpndl: child: before pro 0 25 4 library cache kglupc: child 0 14 12 library cache kglic 0 10 0 library cache kgllkdl: child: cleanup 0 10 1 library cache kglhdgn: child: 0 9 12 library cache kglpin: child: heap proces 0 9 23 library cache kglpnc: child 0 9 25 library cache kglpnp: child 0 8 17 library cache kglobpn: child: 0 5 2 library cache kglrtl 0 4 2 library cache kglget: child: KGLDSBRD 0 2 7 library cache kgldti: 2child 0 1 2 library cache kglhdgc: child: 0 1 0 library cache kglhfr: child 0 1 0 library cache pin kglpndl 0 6 1 library cache pin kglpnal: child: alloc spac 0 1 7 library cache pin kglpnp: child 0 1 0 library cache pin kglupc 0 1 1 library cache pin alloca kglpnal 0 1 0 query server freelists kxfpqrsnd 0 291 0 query server freelists kxfprigdb: KSLBEGIN 0 1 2 redo allocation kcrfwr 0 7 4 row cache enqueue latch kqreqa 0 1 1 row cache objects kqrpre: find obj 0 1 1 session allocation ksuxds: KSUSFCLC not set 0 4 3 session allocation kxfpqidqr 0 1 2 shared pool kghupr1 0 17 24 shared pool kghalo 0 9 3 shared pool kghfre 0 2 0 ------------------------------------------------------------- Dictionary Cache Stats for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 ->"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_database_links 70 12.9 0 0 11 dc_free_extents 12 0.0 0 0 2 dc_global_oids 36 0.0 0 0 17 dc_histogram_defs 11,870 0.0 0 0 4,306 dc_object_ids 29,215 0.0 0 0 896 dc_objects 5,277 0.2 0 23 1,692 dc_profiles 107 0.0 0 0 2 dc_rollback_segments 263 0.0 0 0 12 dc_segments 6,628 0.0 0 0 972 dc_sequences 15 0.0 0 15 7 dc_table_scns 11 0.0 0 0 24 dc_tablespaces 80,995 0.0 0 0 22 dc_user_grants 846 0.0 0 0 9 dc_usernames 929 0.0 0 0 29 dc_users 85,579 0.0 0 0 11 ------------------------------------------------------------- Library Cache Activity for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 ->"Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 593 0.0 600 1.7 9 0 CLUSTER 9 0.0 10 0.0 0 0 INDEX 3,290 0.0 1,645 0.0 0 0 PIPE 11,234 0.2 16,526 0.1 0 0 SQL AREA 5,608 6.3 101,300 0.8 115 35 TABLE/PROCEDURE 17,123 0.1 37,993 0.1 10 0 ------------------------------------------------------------- Shared Pool Advisory for DB: UATIMNG Instance: uatimng End Snap: 2469 -> 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 ----------- ----- ---------- ------------ ------------ ------- --------------- 560 .6 567 33,132 349,715 1.0 2,405,294 672 .7 678 40,559 349,716 1.0 2,405,385 784 .8 789 46,938 349,716 1.0 2,405,409 896 .9 811 49,049 349,716 1.0 2,405,409 1,008 1.0 811 49,049 349,716 1.0 2,405,409 1,120 1.1 811 49,049 349,716 1.0 2,405,409 1,232 1.2 811 49,049 349,716 1.0 2,405,409 1,344 1.3 811 49,049 349,716 1.0 2,405,409 1,456 1.4 811 49,049 349,716 1.0 2,405,409 1,568 1.6 811 49,049 349,716 1.0 2,405,409 1,680 1.7 811 49,049 349,716 1.0 2,405,409 1,792 1.8 811 49,049 349,716 1.0 2,405,409 1,904 1.9 811 49,049 349,716 1.0 2,405,409 2,016 2.0 811 49,049 349,716 1.0 2,405,409 ------------------------------------------------------------- SGA Memory Summary for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 SGA regions Size in Bytes ------------------------------ ---------------- Database Buffers 910,163,968 Fixed Size 737,368 Redo Buffers 47,472,640 Variable Size 3,321,888,768 ---------------- sum 4,280,262,744 ------------------------------------------------------------- SGA breakdown difference for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 Pool Name Begin value End value % Diff ------ ------------------------------ ---------------- ---------------- ------- java free memory 67,108,864 67,108,864 0.00 large free memory 65,142,784 65,142,784 0.00 large PX msg pool 1,966,080 1,966,080 0.00 shared Checkpoint queue 1,026,560 1,026,560 0.00 shared db_block_buffers 14,665,728 14,665,728 0.00 shared dictionary cache 3,229,952 3,229,952 0.00 shared errors 576,704 481,168 -16.57 shared event statistics per sess 1,923,040 1,923,040 0.00 shared FileOpenBlock 1,191,104 1,191,104 0.00 shared fixed allocation callback 552 552 0.00 shared free memory 685,771,808 659,298,632 -3.86 shared joxs heap init 4,240 4,240 0.00 shared KGK heap 7,000 7,000 0.00 shared KGLS heap 5,829,536 5,830,976 0.02 shared KQR L PO 2,642,152 2,651,368 0.35 shared KQR M PO 2,797,784 2,797,784 0.00 shared KQR S SO 2,304 2,304 0.00 shared KQR X PO 5,152 28,336 450.00 shared KSXR pending messages que 853,952 853,952 0.00 shared KSXR receive buffers 1,034,000 1,034,000 0.00 shared library cache 85,700,376 88,454,040 3.21 shared log_buffer 1,482,784 1,482,784 0.00 shared message pool freequeue 771,984 771,984 0.00 shared miscellaneous 32,958,616 33,371,864 1.25 shared parameters 157,720 149,864 -4.98 shared partitioning d 294,976 294,976 0.00 shared PLS non-lib hp 2,088 2,088 0.00 shared PL/SQL DIANA 3,813,320 3,813,056 -0.01 shared PL/SQL MPCODE 4,220,736 4,161,320 -1.41 shared PL/SQL PPCODE 1,667,416 1,688,536 1.27 shared PL/SQL SOURCE 1,133,960 1,680,656 48.21 shared pl/sql source 870,896 330,280 -62.08 shared PX subheap 177,176 177,176 0.00 shared sql area 250,288,096 273,696,392 9.35 shared table definiti 10,072 10,072 0.00 shared trigger defini 272 272 0.00 shared trigger inform 344 344 0.00 shared trigger source 152 152 0.00 shared type object de 85,528 85,528 0.00 shared 1M buffer 2,098,176 2,098,176 0.00 fixed_sga 737,368 737,368 0.00 log_buffer 47,449,088 47,449,088 0.00 ------------------------------------------------------------- Resource Limit Stats for DB: UATIMNG Instance: uatimng End Snap: 2469 -> only rows with Current or Maximum Utilization > 80% of Limit are shown -> ordered by resource name Current Maximum Initial Resource Name Utilization Utilization Allocation Limit ------------------------------ ------------ ------------ ---------- ---------- parallel_max_servers 13 40 41 41 processes 145 150 150 150 sessions 139 153 170 170 ------------------------------------------------------------- init.ora Parameters for DB: UATIMNG Instance: uatimng Snaps: 2468 -2469 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- background_dump_dest /u02/miles/oracle/admin/uatimng/b compatible 9.2.0.0.0 control_files /u02/miles/oradata/uatimng/contro core_dump_dest /u02/miles/oracle/admin/uatimng/c db_block_buffers 55552 db_block_size 16384 db_name uatimng instance_name uatimng java_pool_size 67108864 job_queue_processes 10 large_pool_size 67108864 log_buffer 47185920 max_dump_file_size 10240 open_cursors 1000 os_authent_prefix parallel_automatic_tuning TRUE pga_aggregate_target 1572864000 processes 150 remote_login_passwordfile EXCLUSIVE session_cached_cursors 100 sga_max_size 4280262744 shared_pool_reserved_size 7764320 shared_pool_size 1056964608 sort_area_size 1048576 timed_statistics TRUE undo_management AUTO undo_retention 54000 undo_tablespace UNDOTBS user_dump_dest /u02/miles/oracle/admin/uatimng/u ------------------------------------------------------------- End of Report