g 0yv9t4select CUID_CUST_NO , CUID_ID_TYPE , CUID_ID_RECNO from CUID_TMP where CHGFLAG='D' qb1zb2b 104pd9select blocks, maxblocks, grantor#, priv1, priv2, priv3 from tsq$ where ts#=:1 and user#=:2 mm3fh9p 1crajpbINSERT INTO STATS$SGA_TARGET_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , SGA_SIZE , 7j5tyz SGA_SIZE_FACTOR , ESTD_DB_TIME , ESTD_DB_TIME_FACTOR , ESTD_PHYSICAL_READS ) SELECT :B3 , :B2 , :B1 , SGA_SIZE , SGA_SIZE_FACTOR , ESTD_DB_TIME , ESTD_DB_TIME_FACTOR , ESTD_PHYSICAL_READS FROM V$SGA_TARGET_ADVICE 1dm3binsert into iccifnsact values (:b0, :b1, :b2, null , null , :b3, :b4, GREATEST(:b5, :b6), null , :b7, :b8, q36vu3null , :b9, :b10, :b6, null , null , null , null , null , :b12, null , null , null , :b13, :b14, null , null , :b15, :b16, :b17) g8 1gu8t9select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, 6d0bdt.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, mu t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) 1uk5mBEGIN dbms_workload_repository.create_snapshot; END; 5qbzj1vt 2ym6hselect type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, haq30r65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and 73 block#=:3 350f5yrlock table sys.mon_mods$ in exclusive mode nowait nnmshs 38apjgrupdate ICCICCS set CCSMAXOVERDUE=GREATEST(:b0, CCSMAXOVERDUE) where FNSACTNO=:b1 0p55ns 38gak8select count(*) from CUSVAA_TMP u2qm11w 3m8smINSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) r0v7v1VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13) m6 44au3vinsert into ICCICURMMAST values (:b0, :b1, :b2) 5mzpc1c 49ms6insert into ICCIRPYV values 9srnax(:b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :bzj 21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51) 4vja2kinsert into ICCICCS values (:b0, '////////////////////////', 0, 0, 0, 0, 0, ' ', 0, 0, 0, ' ', '0', null ) 2gdtyup 501v41update ICCIFNSACT set BORM_FACILITY_NO=:b0 where BORM_MEMB_CUST_AC=:b1 2s13r4m 53saa2select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1 zkr6wc3 569r5kinsert into CUMI select CUSV_CUST_NO , CUSV_EDUCATION_CODE , CHGDATE from CUMI_TMP where 05drsj7 CHGFLAG<>'D' 5c4qu2select * from ICCIPRODCODE where PRODCODE=to_char(:b0) zmj3gux 5ngzsfselect o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from stg8tmobj$ o where o.obj#=:1 y 6769wselect pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1 yy3yf66f 6z06gcSELECT F.TABLESPACE_NAME, TO_CHAR ((T.TOTAL_SPACE - F.FREE_SPACE), '999, 999') \fw39pk(MB)\d \FROM ( SELECT TABLESPACE_NAME, ROUND (SUM (BLOCKS*(SELECT VALUE/1024 FROM V$PARAMETER WHERE NAME = 'db_block_size')/1024) ) FREE_SPACE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME ) F, ( SELECT TABLESPACE_NAME, ROUND (SUM (BYTES/1048576)) TOTAL_SPACE FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME ) T WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME 78m9rySELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND ygp65vV.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND 5 V.FUNCTION = :B1 7gtztzvselect c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and 329wgc.owner# = u.user# 0 7ng34rselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, uy5awi.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), xq nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# 7v9dyfselect NEWACTNO into :b0 from OLDNEWACT where OLDACTNO=:b1 5r424yh 7wwv1update ICCIFNSACT set BORM_ADV_DATE=:b0, BOIS_MATURITY_DATE=:b1, BOIS_UNPD_BAL=:b2, ybs9zgBOIS_UNPD_INT=:b3, BOIS_BAL_FINE=:b4, BOIS_INT_FINE=:b5, BOIS_FINE_FINE=:b6, uz BORM_LOAN_TRM=:b7, BORM_FIVE_STAT=:b8, BOIS_ARREARS_CTR=:b9, BOIS_ARREARS_SUM=:b10 where BORM_MEMB_CUST_AC=:b11 83taa7select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, kaw59-127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), c1 null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol# 84qubbinsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, rsr0kfn immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash 9qgtwhupdate seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, 66xg6niniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, z hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3 9vtm7gselect con# from con$ where owner#=:1 and name=:2 y4fr2ny a2any0select owner#, name from con$ where con#=:1 35u1qz1 a7nh7jselect CUSV_CUST_NO from CUMI_TMP where CHGFLAG='D' 8zmfrzw ackxqhinsert into CUSM select CUSM_CUST_ACCT_NO , CUSM_STAT_POST_ADD_NO , CHGDATE from nktxnbCUSM_TMP where CHGFLAG<>'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 block flush time gc cr block receive time gc cr block send time gc cr blocks received gc cr blocks served gc current block flush time gc current block pin time gc current block receive time gc current block send time gc current blocks received gc current blocks served gc local grants gc remote grants gcs messages sent ges messages sent global enqueue get time global enqueue gets async global enqueue gets sync global enqueue releases global undo segment hints helped global undo segment hints were stale heap block compress hot buffers moved to head of LRU immediate (CR) block cleanout applications immediate (CURRENT) block cleanout applications index crx upgrade (positioned) 2,902,016 0 5,037,471 0 434 1,519 8,594,158 11,611,321 1,167,830 10,443,491 20,786 25,007 0 6,734 595,149 595,158 9 7,901 1 1,675,112 536,832 746,999 9,099 13 143 474 36 4,142 10,675 23 34 1,212 52 15,502 17,534 405,329 318,630 1,129,094 90,695 1,707 12,731 190,492 190,328 0 0 108,758 18,652 2,462 325,184 4,663 613.87 0.00 1,065.59 0.00 0.09 0.32 1,817.95 2,456.18 247.03 2,209.14 4.40 5.29 0.00 1.42 125.89 125.90 0.00 1.67 0.00 354.34 113.56 158.01 1.92 0.00 0.03 0.10 0.01 0.88 2.26 0.00 0.01 0.26 0.01 3.28 3.71 85.74 67.40 238.84 19.18 0.36 2.69 40.30 40.26 0.00 0.00 23.01 3.95 0.52 68.79 0.99 518.40 0.00 899.87 0.00 0.08 0.27 1,535.22 2,074.19 208.62 1,865.58 3.71 4.47 0.00 1.20 106.31 106.32 0.00 1.41 0.00 299.23 95.90 133.44 1.63 0.00 0.03 0.08 0.01 0.74 1.91 0.00 0.01 0.22 0.01 2.77 3.13 72.41 56.92 201.70 16.20 0.30 2.27 34.03 34.00 0.00 0.00 19.43 3.33 0.44 58.09 0.83