Oracle - AWR - 教你如何看 - 图文(9)

<>'D' c aq4js2update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2 gkfjru8 b52m6delete from RecycleBin$ where bo=:1 vduutr8j bdv0rkSELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE kssq2j'%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPF' m bsa0wjselect file# from file$ where ts#=:1 tftg3uw btzq46update obj$ set obj#=:6, type#=:7, ctime=:8, mtime=:9, stime=:10, status=:11, dataobj#=:13, flags=:14, kta67doid$=:15, spare1=:16, spare2=:17 where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or z remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and :5 is null)and(subname=:12 or subname is null and :12 is null) bu8tnqselect count(*) into :b0 from ICCIFNSACT where BORM_MEMB_CUST_AC=:b1 r3xv25q bwt0pdelete from con$ where owner#=:1 and name=:2 mxhv7qk7 chjmy0insert into ICCICCS values (:b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13) dxf9mbj cn1gtsBEGIN BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, av2d5jsys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN h xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; END; cp5duhselect CUSM_CUST_ACCT_NO from CUSM_TMP where CHGFLAG='D' csj72q0 d8z0u8insert into CUID select CUID_CUST_NO , CUID_ID_MAIN , CUID_ID_TYPE , CUID_ID_RECNO , hgj8xdCUID_ID_NUMBER , CHGDATE from CUID_TMP where CHGFLAG<>'D' y d92h3rjbegin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end; p0y217 djs2w2DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN f17nw2statspack.snap; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; z f80h0xSELECT sys.wri$_adv_seq_msggroup.nextval FROM dual b1qvbsk g00cj2update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = 85jmgs(decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, w timestamp = :time where obj# = :objn gmn2winsert into OLDNEWACT values (:b0, :b1) 09rdxn14 Back to SQL Statistics Back to Top

Instance Activity Statistics

? ? ? Instance Activity Stats Instance Activity Stats - Absolute Values Instance Activity Stats - Thread Activity Back to Top

Instance Activity Stats

Statistic CPU used by this session CPU used when call started CR blocks created Cached Commit SCN referenced Commit SCN cached DB time DBWR checkpoint buffers written DBWR checkpoints DBWR fusion writes Total 23,388 21,816 2,794 237,936 3 583,424 402,781 9 255 per Second 4.95 4.61 0.59 50.33 0.00 123.41 85.20 0.00 0.05 per Trans 4.18 3.90 0.50 42.50 0.00 104.22 71.95 0.00 0.05 DBWR object drop buffers written DBWR thread checkpoint buffers written DBWR transaction table writes DBWR undo block writes DFO trees parallelized PX local messages recv'd PX local messages sent PX remote messages recv'd PX remote messages sent Parallel operations not downgraded RowCR - row contention RowCR attempts RowCR hits SMON posted for undo segment recovery SMON posted for undo segment shrink SQL*Net roundtrips to/from client active txn count during cleanout application wait time auto extends on undo tablespace background checkpoints completed background checkpoints started background timeouts branch node splits buffer is not pinned count buffer is pinned count bytes received via SQL*Net from client bytes sent via SQL*Net to client calls to get snapshot scn: kcmgss calls to kcmgas calls to kcmgcs change write time cleanout - number of ktugct calls cleanouts and rollbacks - consistent read gets cleanouts only - consistent read gets cluster key scan block gets cluster key scans cluster wait time commit batch/immediate performed commit batch/immediate requested commit cleanout failures: block lost commit cleanout failures: callback failure commit cleanout failures: cannot pin commit cleanouts commit cleanouts successfully completed commit immediate performed commit immediate requested commit txn count during cleanout concurrency wait time consistent changes consistent gets 0 221,341 130 219,272 16 40 40 80 80 16 9 14 5 0 9 1,544,063 276,652 1,620 0 7 9 21,703 337 1,377,184 20,996,139 149,122,035 1,696,712 433,435 142,482 4,707 282,045 55 2,406 21,886 10,540 2,855 294 294 2,227 750 4 427,610 424,629 294 294 111,557 515 1,716 5,037,471 0.00 46.82 0.03 46.38 0.00 0.01 0.01 0.02 0.02 0.00 0.00 0.00 0.00 0.00 0.00 326.62 58.52 0.34 0.00 0.00 0.00 4.59 0.07 291.32 4,441.37 31,544.22 358.91 91.69 30.14 1.00 59.66 0.01 0.51 4.63 2.23 0.60 0.06 0.06 0.47 0.16 0.00 90.45 89.82 0.06 0.06 23.60 0.11 0.36 1,065.59 0.00 39.54 0.02 39.17 0.00 0.01 0.01 0.01 0.01 0.00 0.00 0.00 0.00 0.00 0.00 275.82 49.42 0.29 0.00 0.00 0.00 3.88 0.06 246.01 3,750.65 26,638.45 303.09 77.43 25.45 0.84 50.38 0.01 0.43 3.91 1.88 0.51 0.05 0.05 0.40 0.13 0.00 76.39 75.85 0.05 0.05 19.93 0.09 0.31 899.87 7,381,397,183 1,561,408.36 1,318,577.56 consistent gets - examination consistent gets direct consistent gets from cache current blocks converted for CR cursor authentications data blocks consistent reads - undo records applied db block changes db block gets db block gets direct db block gets from cache deferred (CURRENT) block cleanout applications dirty buffers inspected drop segment calls in space pressure enqueue conversions enqueue releases enqueue requests enqueue timeouts enqueue waits exchange deadlocks execute count free buffer inspected free buffer requested gc CPU used by this session gc cr block build time gc cr b …… 此处隐藏：5532字，全部文档内容请下载后查看。喜欢就下载吧 ……