WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
UPRR	1058789863	uprr	1	11-Jan-13 15:01	11.2.0.1.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
cnsctdevdb101	Linux x86 64-bit	8	4	1	7.79

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	18518	18-Feb-13 20:00:11	77	2.0
End Snap:	18520	18-Feb-13 22:00:15	61	1.7
Elapsed:		120.06 (mins)
DB Time:		15.02 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	800M	800M	Std Block Size:	8K
Shared Pool Size:	1,216M	1,216M	Log Buffer:	15,960K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.1	0.1	0.07	0.03
DB CPU(s):	0.1	0.1	0.07	0.03
Redo size:	1,000.1	659.5
Logical reads:	71,529.1	47,168.3
Block changes:	4.4	2.9
Physical reads:	36.0	23.7
Physical writes:	0.5	0.3
User calls:	4.3	2.9
Parses:	1.0	0.6
Hard parses:	0.0	0.0
W/A MB processed:	0.0	0.0
Logons:	0.0	0.0
Executes:	1.8	1.2
Rollbacks:	1.5	1.0
Transactions:	1.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.95	In-memory Sort %:	100.00
Library Hit %:	97.42	Soft Parse %:	97.72
Execute to Parse %:	47.63	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	87.16	% Non-Parse CPU:	99.75

Shared Pool Statistics

	Begin	End
Memory Usage %:	79.50	79.39
% SQL with executions>1:	97.17	98.11
% Memory for SQL w/exec>1:	96.24	96.91

Top 5 Timed Foreground Events

Host CPU (CPUs: 8 Cores: 4 Sockets: 1)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.85	0.00	1.5	0.1	0.0	98.4

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
1.6	98.4	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	7,977.0	7,977.0
SGA use (MB):	2,080.0	2,080.0
PGA use (MB):	530.5	483.1
% Host Mem used for SGA+PGA:	32.73	32.13

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 901.2s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 100.0% of Total DB time 901.19 (s)
• Total FG Wait Time: 2.89 (s) DB CPU time: 898.12 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 99.5% of Total DB Time (s): 901
• Captured PL/SQL account for 2.3% of Total DB Time (s): 901

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 99.5% of Total CPU Time (s): 898
• Captured PL/SQL account for 2.1% of Total CPU Time (s): 898

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 45.4% of Total User I/O Wait Time (s): 5
• Captured PL/SQL account for 31.2% of Total User I/O Wait Time (s): 5

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 515,266,582
• Captured SQL account for 100.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 258,969
• Captured SQL account for 64.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 27,584
• Captured SQL account for 81.7% of Total
• Total UnOptimized Read Requests: 27,584
• Captured SQL account for 81.7% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 12,999
• Captured SQL account for 58.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 6,808
• Captured SQL account for 66.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0u2fu2bfh8uwy	select 'A', d.explanation, --金融机构标识码 c.account_no, --交易账号 to_date(a.batchentrydate, 'yyyy-mm-dd'), --发生日期 c.currencycode, --币种 SUM(decode(A.Creditdebit, 'C', a.transactionamount, 0)), --当日贷方发生额 SUM(decode(A.Creditdebit, 'D', a.transactionamount, 0)), --当日借方发生额 case when C.Currencycode = 'JPY' Then Round(c.Ccyledgerbalance, 0) else c.ccyledgerbalance End Balance, --账户余额 --b.instcode instcode, --系统虚拟机构代号 1 datastatus, --前台对应的数据状态 c.account_no || c.currencycode || '2013-01-04', to_date('2013-01-04', 'yyyy-mm-dd') from df_cust C left join /*(select distinct ACCOUNTBRANCH, DESCRIPTION, MASTERNO, CURRENCYCODE, ACCOUNT_NUMBER, SEQNO, ACCT_CLASS_CODE, PRODUCTCODE, VALUEDT_YYYY, VALUEDT_MM, VALUEDT_DD, BATCHENTRYDATE, VALUEDT_YYYYMMDD, NARRATIONPOST, TRANSACTIONAMOUNT, C REDITDEBIT, ACCOUNTBRANCH1, SEGMENTCODE, REFERENCENUMBER, NARRATIONTRAN, BATCHNUMBER, GLDEPTID, ARMCODE, EXTREFNO, MAKERID, CHECKERID, CHANNELID, TRANSACTION_AMT_IN_USD, ACCSHORTNAME, ARMNAME, SEGNAME, TXNCODE, REVERSALFLAG, EBBSREFERENCE, TRANSTYPECODE, CUSTOMERRATE, ADVTREASURYFLAG, VA_FLAG from df_acmov_today where Creditdebit in ('C', 'D'))*/df_acmov_today a on a.account_number = c.account_no Left Join Da_Mid_Acc_Gl_Dic D On D.Source = A.Accountbranch Where exists (select 1 from acc.t_base_account b where b.account = c.account_no and b.currence_code = c.currencycode) and a.account_numb er is not null and c.account_no like '0%' group by d.explanation, --金融机构标识码 c.account_no, --交易账号 a.batchentrydate, --发生日期 c.currencycode, --币种 C.Ccyledgerbalance
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(: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), :time)
131z8c0t4ckmu	select STATUS from etl_logger where task_code in('ETL_SF042M') and data_date='2013-01-31'
1fyh4t68h7pd6	SELECT * FROM u_base_login_ip WHERE login_id='Emerg13'
1xq5pqgjt9pj5	select column_id, table_id, column_name, "order", position, data_type, dictionary_type_id, cons_rule, txt_id, txt_column_id, is_show, tag_type, can_modify, data_type_desc, cons_desc, log_column_id, can_input from t_rpt_column_info where is_enabled = '1' and table_id = :1 order by to_number(position) asc
2wrsdkzngpz2h	/* SQL Analyze(0) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("CCYLEDGERBALANCE")), to_char(substrb(dump(min("CCYLEDGERBALANCE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CCYLEDGERBALANCE"), 16, 0, 32), 1, 120)), to_char(count("BCYLEDGERBALANCE")), to_char(substrb(dump(min("BCYLEDGERBALANCE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BCYLEDGERBALANCE"), 16, 0, 32), 1, 120)), to_char(count("CCYYAVGAVAILBAL")), to_char(substrb(dump(min("CCYYAVGAVAILBAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CCYYAVGAVAILBAL"), 16, 0, 32), 1, 120)), to_char(count("BCYYAVGAVAILBAL")), to_char(substrb(dump(min("BCYYAVGAVAILBAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BCYYAVGAVAILBAL"), 16, 0, 32), 1, 120)), to_char(count("GLDEPTID")), to_char(substrb(dump(min("GLDEPTID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("GLDEPTID"), 16, 0, 32), 1, 120)), to_char(count("DATA_DATE")), to_char(substrb(dump(min("DATA_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DATA_DATE"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNTBRANCH")), to_char(substrb(dump(min("ACCOUNTBRANCH"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNTBRANC H"), 16, 0, 32), 1, 120)), to_char(count("NAME")), to_char(substrb(dump(min("NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NAME"), 16, 0, 32), 1, 120)), to_char(count("RELATIONSHIPNO")), to_char(substrb(dump(min("RELATIONSHIPNO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RELATIONSHIPNO"), 16, 0, 32), 1, 120)), to_char(count("MASTERNO")), to_char(substrb(dump(min("MASTERNO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MASTERNO"), 16, 0, 32), 1, 120)), to_char(count("SHORTNAME")), to_char(substrb(dump(min("SHORTNAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SHORTNAME"), 16, 0, 32), 1, 120)), to_char(count("PRODUCTCODE")), to_char(substrb(dump(min("PRODUCTCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PRODUCTCODE"), 16, 0, 32), 1, 120)), to_char(count("CURRENCYCODE")), to_char(substrb(dump(min("CURRENCYCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CURRENCYCODE"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNT_NO")), to_char(substrb(dump(min("ACCOUNT_NO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT_NO"), 16, 0, 32), 1, 120)), to_char(count("ACCLASS_DESCRIPTION")), to_char(substrb(dump(min("ACCLASS_DESCRIPTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCLASS_DESCRIPTION" ), 16, 0, 32), 1, 120)), to_char(count("MMKDEALTYPE")), to_char(substrb(dump(min("MMKDEALTYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MMKDEALTYPE"), 16, 0, 32), 1, 120)), to_char(count("ACCLASSCODE")), to_char(substrb(dump(min("ACCLASSCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCLASSCODE"), 16, 0, 32), 1, 120)), to_char(count("SEGMENTCODE")), to_char(substrb(dump(min("SEGMENTCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SEGMENTCODE"), 16, 0, 32), 1, 120)), to_char(count("CUSTSEGMTCODE")), to_char(substrb(dump(min("CUSTSEGMTCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CUSTSEGMTCODE"), 16, 0, 32), 1, 120)), to_char(count("ARMCODE")), to_char(substrb(dump(min("ARMCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ARMCODE"), 16, 0, 32), 1, 120)), to_char(count("UNITHEAD")), to_char(substrb(dump(min("UNITHEAD"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("UNITHEAD"), 16, 0, 32), 1, 120)), to_char(count("ISRESIDENT")), to_char(substrb(dump(min("ISRESIDENT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ISRESIDENT"), 16, 0, 32), 1, 120)), to_char(count("CITYCODE")), to_char(substrb(dump(min("CITYCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CITYCODE"), 16, 0, 32), 1, 120)), to_cha r(count("COUNTRYCODE")), to_char(substrb(dump(min("COUNTRYCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("COUNTRYCODE"), 16, 0, 32), 1, 120)), to_char(count("CUSTTYPECODE")), to_char(substrb(dump(min("CUSTTYPECODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CUSTTYPECODE"), 16, 0, 32), 1, 120)), to_char(count("ISICCODE")), to_char(substrb(dump(min("ISICCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ISICCODE"), 16, 0, 32), 1, 120)), to_char(count("CRGCODE")), to_char(substrb(dump(min("CRGCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CRGCODE"), 16, 0, 32), 1, 120)), to_char(count("CCYMAVGAVAILBAL")), to_char(substrb(dump(min("CCYMAVGAVAILBAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CCYMAVGAVAILBAL"), 16, 0, 32), 1, 120)), to_char(count("BCYMAVGAVAILBAL")), to_char(substrb(dump(min("BCYMAVGAVAILBAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BCYMAVGAVAILBAL"), 16, 0, 32), 1, 120)), to_char(count("RISKCODE")), to_char(substrb(dump(min("RISKCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RISKCODE"), 16, 0, 32), 1, 120)), to_char(count("CUSTOMER_FULL_NAME")), to_char(substrb(dump(min("CUSTOMER_FULL_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CUSTOMER_FULL_NAME"), 16, 0, 32), 1, 120)), to_char(count("CUSTOMER_FULL_NAME_IN_CHINESE")), to_char(substrb(dump(min("CUSTOMER_FULL_NAME_IN_CHINESE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CUSTOMER_FULL_NAME_IN_CHINESE"), 16, 0, 32), 1, 120)), to_char(count("CUSTOMER_ADDRESS")), to_char(substrb(dump(min("CUSTOMER_ADDRESS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CUSTOMER_ADDRESS"), 16, 0, 32), 1, 120)), to_char(count("CUSTOMER_ADDRESS_IN_CHINESE")), to_char(substrb(dump(min("CUSTOMER_ADDRESS_IN_CHINESE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CUSTOMER_ADDRESS_IN_CHINESE"), 16, 0, 32), 1, 120)), to_char(count("UNIQUEID1")), to_char(substrb(dump(min("UNIQUEID1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("UNIQUEID1"), 16, 0, 32), 1, 120)), to_char(count("UNIQUEID2")), to_char(substrb(dump(min("UNIQUEID2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("UNIQUEID2"), 16, 0, 32), 1, 120)), to_char(count("PRODUCT_DESCRIPTION")), to_char(substrb(dump(min("PRODUCT_DESCRIPTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PRODUCT_DESCRIPTION"), 16, 0, 32), 1, 120)), to_char(count("INFOCODE")), to_char(substrb(dump(min("INFOCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INFOCODE"), 16, 0, 32), 1, 120)), to_char(count("COUNTRYOFRESIDENCE")), to_char(substrb (dump(min("COUNTRYOFRESIDENCE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("COUNTRYOFRESIDENCE"), 16, 0, 32), 1, 120)), to_char(count("RESIDENTSTATUS")), to_char(substrb(dump(min("RESIDENTSTATUS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RESIDENTSTATUS"), 16, 0, 32), 1, 120)), to_char(count("SERVICEINDICATOR")), to_char(substrb(dump(min("SERVICEINDICATOR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SERVICEINDICATOR"), 16, 0, 32), 1, 120)), to_char(count("KYCCOMPLETE")), to_char(substrb(dump(min("KYCCOMPLETE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("KYCCOMPLETE"), 16, 0, 32), 1, 120)), to_char(count("NATIONALITYCODE")), to_char(substrb(dump(min("NATIONALITYCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NATIONALITYCODE"), 16, 0, 32), 1, 120)), to_char(count("REFERREDBYREL")), to_char(substrb(dump(min("REFERREDBYREL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REFERREDBYREL"), 16, 0, 32), 1, 120)), to_char(count("REFERREDBYNAME")), to_char(substrb(dump(min("REFERREDBYNAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REFERREDBYNAME"), 16, 0, 32), 1, 120)), to_char(count("CONTACTEMR")), to_char(substrb(dump(min("CONTACTEMR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CONTACTEMR"), 16, 0, 32), 1, 120)) , to_char(count("CONTACTEMO")), to_char(substrb(dump(min("CONTACTEMO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CONTACTEMO"), 16, 0, 32), 1, 120)), to_char(count("DEBITCARDNO")), to_char(substrb(dump(min("DEBITCARDNO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DEBITCARDNO"), 16, 0, 32), 1, 120)), to_char(count("CARDSTATUS")), to_char(substrb(dump(min("CARDSTATUS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CARDSTATUS"), 16, 0, 32), 1, 120)), to_char(count("ACQUISITIONCODE")), to_char(substrb(dump(min("ACQUISITIONCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACQUISITIONCODE"), 16, 0, 32), 1, 120)), to_char(count("ZIPCODE")), to_char(substrb(dump(min("ZIPCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ZIPCODE"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNTOPENDATE")), to_char(substrb(dump(min("ACCOUNTOPENDATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNTOPENDATE"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNTSTATUS")), to_char(substrb(dump(min("ACCOUNTSTATUS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNTSTATUS"), 16, 0, 32), 1, 120)), to_char(count("STAFFFLAG")), to_char(substrb(dump(min("STAFFFLAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("STAFFFLAG"), 16, 0, 32), 1, 120 )), to_char(count("EARMARKCRBALANCE")), to_char(substrb(dump(min("EARMARKCRBALANCE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EARMARKCRBALANCE"), 16, 0, 32), 1, 120)), to_char(count("EARMARKDRBALANCE")), to_char(substrb(dump(min("EARMARKDRBALANCE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EARMARKDRBALANCE"), 16, 0, 32), 1, 120)), to_char(count("ALLOWINTERNETBANKING")), to_char(substrb(dump(min("ALLOWINTERNETBANKING"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ALLOWINTERNETBANKING"), 16, 0, 32), 1, 120)), to_char(count("SEX")), to_char(substrb(dump(min("SEX"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SEX"), 16, 0, 32), 1, 120)), to_char(count("DATEOFBIRTH")), to_char(substrb(dump(min("DATEOFBIRTH"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DATEOFBIRTH"), 16, 0, 32), 1, 120)), to_char(count("FORMRCPTDATE")), to_char(substrb(dump(min("FORMRCPTDATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FORMRCPTDATE"), 16, 0, 32), 1, 120)), to_char(count("MASTEROPENDATE")), to_char(substrb(dump(min("MASTEROPENDATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MASTEROPENDATE"), 16, 0, 32), 1, 120)), to_char(count("DEPARTMENT")), to_char(substrb(dump(min("DEPARTMENT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "DEPARTMENT"), 16, 0, 32), 1, 120)), to_char(count("LINK_RELATIONSHIP_NO1")), to_char(substrb(dump(min("LINK_RELATIONSHIP_NO1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LINK_RELATIONSHIP_NO1"), 16, 0, 32), 1, 120)), to_char(count("RELATIONSHIP_TYPE_CODE1")), to_char(substrb(dump(min("RELATIONSHIP_TYPE_CODE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RELATIONSHIP_TYPE_CODE1"), 16, 0, 32), 1, 120)), to_char(count("LINK_RELATIONSHIP_NO2")), to_char(substrb(dump(min("LINK_RELATIONSHIP_NO2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LINK_RELATIONSHIP_NO2"), 16, 0, 32), 1, 120)), to_char(count("RELATIONSHIP_TYPE_CODE2")), to_char(substrb(dump(min("RELATIONSHIP_TYPE_CODE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RELATIONSHIP_TYPE_CODE2"), 16, 0, 32), 1, 120)), to_char(count("ACCTITLE")), to_char(substrb(dump(min("ACCTITLE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCTITLE"), 16, 0, 32), 1, 120)), to_char(count("USRDEFINEDCODE8")), to_char(substrb(dump(min("USRDEFINEDCODE8"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USRDEFINEDCODE8"), 16, 0, 32), 1, 120)), to_char(count("INFODETCODE")), to_char(substrb(dump(min("INFODETCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INFODETCODE"), 16, 0, 32), 1, 120)) from "DATACORE"."DF_CUST" t /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3nz260v5dwqnv	select value from v$sesstat where sid = :sid order by statistic#
3x1mfwvhcyz1p	/* SQL Analyze(0) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("DATA_DATE")), to_char(substrb(dump(min("DATA_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DATA_DATE"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNTBRANCH")), to_char(substrb(dump(min("ACCOUNTBRANCH"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNTBRANCH"), 16, 0, 32), 1, 120)), to_char(count("DESCRIPTION")), to_char(substrb(dump(min("DESCRIPTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DESCRIPTION"), 16, 0, 32), 1, 120)), to_char(count("MASTERNO")), to_char(substrb(dump(min("MASTERNO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MASTERNO"), 16, 0, 32), 1, 120)), to_char(count("CURRENCYCODE")), to_char(substrb(dump(min("CURRENCYCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CURRENCYCODE"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNT_NUMBER")), to_char(substrb(dump(min("ACCOUNT_NUMBER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT_NUMBER"), 16, 0, 32), 1, 120)), to_char(count("SEQNO")), to_char(substrb(dump(min("SEQNO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SEQNO"), 16, 0, 32), 1, 120)), to_char(count("ACCT_CLA SS_CODE")), to_char(substrb(dump(min("ACCT_CLASS_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCT_CLASS_CODE"), 16, 0, 32), 1, 120)), to_char(count("PRODUCTCODE")), to_char(substrb(dump(min("PRODUCTCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PRODUCTCODE"), 16, 0, 32), 1, 120)), to_char(count("VALUEDT_YYYY")), to_char(substrb(dump(min("VALUEDT_YYYY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("VALUEDT_YYYY"), 16, 0, 32), 1, 120)), to_char(count("VALUEDT_MM")), to_char(substrb(dump(min("VALUEDT_MM"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("VALUEDT_MM"), 16, 0, 32), 1, 120)), to_char(count("VALUEDT_DD")), to_char(substrb(dump(min("VALUEDT_DD"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("VALUEDT_DD"), 16, 0, 32), 1, 120)), to_char(count("BATCHENTRYDATE")), to_char(substrb(dump(min("BATCHENTRYDATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BATCHENTRYDATE"), 16, 0, 32), 1, 120)), to_char(count("VALUEDT_YYYYMMDD")), to_char(substrb(dump(min("VALUEDT_YYYYMMDD"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("VALUEDT_YYYYMMDD"), 16, 0, 32), 1, 120)), to_char(count("NARRATIONPOST")), to_char(substrb(dump(min("NARRATIONPOST"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NARRATIONPOST"), 16, 0, 32), 1, 120)), to_char(count("TRANSACTIONAMOUNT")), to_char(substrb(dump(min("TRANSACTIONAMOUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TRANSACTIONAMOUNT"), 16, 0, 32), 1, 120)), to_char(count("CREDITDEBIT")), to_char(substrb(dump(min("CREDITDEBIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CREDITDEBIT"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNTBRANCH1")), to_char(substrb(dump(min("ACCOUNTBRANCH1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNTBRANCH1"), 16, 0, 32), 1, 120)), to_char(count("SEGMENTCODE")), to_char(substrb(dump(min("SEGMENTCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SEGMENTCODE"), 16, 0, 32), 1, 120)), to_char(count("REFERENCENUMBER")), to_char(substrb(dump(min("REFERENCENUMBER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REFERENCENUMBER"), 16, 0, 32), 1, 120)), to_char(count("NARRATIONTRAN")), to_char(substrb(dump(min("NARRATIONTRAN"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NARRATIONTRAN"), 16, 0, 32), 1, 120)), to_char(count("BATCHNUMBER")), to_char(substrb(dump(min("BATCHNUMBER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BATCHNUMBER"), 16, 0, 32), 1, 120)), to_char(count("GLDEPTID")), to_char(substrb(dump(min("GLDEPTID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max(" GLDEPTID"), 16, 0, 32), 1, 120)), to_char(count("ARMCODE")), to_char(substrb(dump(min("ARMCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ARMCODE"), 16, 0, 32), 1, 120)), to_char(count("EXTREFNO")), to_char(substrb(dump(min("EXTREFNO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTREFNO"), 16, 0, 32), 1, 120)), to_char(count("MAKERID")), to_char(substrb(dump(min("MAKERID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MAKERID"), 16, 0, 32), 1, 120)), to_char(count("CHECKERID")), to_char(substrb(dump(min("CHECKERID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CHECKERID"), 16, 0, 32), 1, 120)), to_char(count("ERRORACCOUNTNO")), to_char(substrb(dump(min("ERRORACCOUNTNO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ERRORACCOUNTNO"), 16, 0, 32), 1, 120)), to_char(count("CHANNELID")), to_char(substrb(dump(min("CHANNELID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CHANNELID"), 16, 0, 32), 1, 120)), to_char(count("NARRATIONTRAN2")), to_char(substrb(dump(min("NARRATIONTRAN2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NARRATIONTRAN2"), 16, 0, 32), 1, 120)), to_char(count("NARRATIONTRAN3")), to_char(substrb(dump(min("NARRATIONTRAN3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NARRATIONTRAN3"), 16, 0 , 32), 1, 120)), to_char(count("NARRATIONTRAN4")), to_char(substrb(dump(min("NARRATIONTRAN4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NARRATIONTRAN4"), 16, 0, 32), 1, 120)), to_char(count("NARRATIONTRAN5")), to_char(substrb(dump(min("NARRATIONTRAN5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NARRATIONTRAN5"), 16, 0, 32), 1, 120)), to_char(count("NARRATIONTRAN6")), to_char(substrb(dump(min("NARRATIONTRAN6"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NARRATIONTRAN6"), 16, 0, 32), 1, 120)), to_char(count("TRANSACTION_AMT_IN_USD")), to_char(substrb(dump(min("TRANSACTION_AMT_IN_USD"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TRANSACTION_AMT_IN_USD"), 16, 0, 32), 1, 120)), to_char(count("ACCSHORTNAME")), to_char(substrb(dump(min("ACCSHORTNAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCSHORTNAME"), 16, 0, 32), 1, 120)), to_char(count("ARMNAME")), to_char(substrb(dump(min("ARMNAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ARMNAME"), 16, 0, 32), 1, 120)), to_char(count("SEGNAME")), to_char(substrb(dump(min("SEGNAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SEGNAME"), 16, 0, 32), 1, 120)), to_char(count("TXNCODE")), to_char(substrb(dump(min("TXNCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "TXNCODE"), 16, 0, 32), 1, 120)), to_char(count("REVERSALFLAG")), to_char(substrb(dump(min("REVERSALFLAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REVERSALFLAG"), 16, 0, 32), 1, 120)), to_char(count("EBBSREFERENCE")), to_char(substrb(dump(min("EBBSREFERENCE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EBBSREFERENCE"), 16, 0, 32), 1, 120)), to_char(count("TRANSTYPECODE")), to_char(substrb(dump(min("TRANSTYPECODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TRANSTYPECODE"), 16, 0, 32), 1, 120)), to_char(count("CUSTOMERRATE")), to_char(substrb(dump(min("CUSTOMERRATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CUSTOMERRATE"), 16, 0, 32), 1, 120)), to_char(count("ADVTREASURYFLAG")), to_char(substrb(dump(min("ADVTREASURYFLAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ADVTREASURYFLAG"), 16, 0, 32), 1, 120)), to_char(count("DEALNO")), to_char(substrb(dump(min("DEALNO"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DEALNO"), 16, 0, 32), 1, 120)), to_char(count("VA_FLAG")), to_char(substrb(dump(min("VA_FLAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("VA_FLAG"), 16, 0, 32), 1, 120)), to_char(count("VA_NUMBER")), to_char(substrb(dump(min("VA_NUMBER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("VA_ NUMBER"), 16, 0, 32), 1, 120)) from "DATACORE"."DF_ACMOV_TODAY" t /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
42cfrr6x5t75c	SELECT MAX(DB_NAME), MAX(VERSION) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME = (SELECT MAX(STARTUP_TIME) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME <= :B2 )
43ruajmwv9fus	insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7)
49s332uhbnsma	declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;
4jsqz2txmvamg	SELECT (:B3 +COUNT(1)) FROM UPRR.U_BASE_HOLIDAY HD WHERE HD.HOLIDAY_TYPE = :B2 AND GETDATE(HD.HOLIDAY_VALUE) = :B1
4tg8mr2bvy6gr	select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax
4ztxg53pb0ks1	SELECT distinct S.SID SESSION_ID, S.STATUS, S.USERNAME, DECODE(LMODE, 0, ' None ', 1, ' Null ', 2, ' Row-S(SS) ', 3, ' Row-X(SX) ', 4, ' Share', 5, 'S/Row-X (SSX) ', 6, 'Exclusive ', TO_CHAR(LMODE)) MODE_HELD, DECODE(REQUEST, 0, ' None ', 1, ' Null ', 2, ' Row-S(SS) ', 3, ' Row-X(SX) ', 4, ' Share', 5, 'S/Row-X (SSX) ', 6, 'Exclusive ', TO_CHAR(REQUEST)) MODE_REQUESTED, O.OWNER || ' . ' || O.OBJECT_NAME || ' ( ' || O.OBJECT_TYPE || ' ) ' AS OBJECT_NAME, S.TYPE LOCK_TYPE, L.ID1 LOCK_ID1, L.ID2 LOCK_ID2, S2.SQL_TEXT FROM V$LOCK L, SYS.DBA_OBJECTS O, V$SESSION S, V$ACCESS A, V$SQL S2 WHERE L.SID = S. SID AND L.ID1 = O.OBJECT_ID AND S.SID = A.SID AND S2.HASH_VALUE = S.SQL_HASH_VALUE -- AND A.OBJECT = 'PROC_VALIDATE_RULE_V3'
5mf0dy2urh9uf	select reasion from t_refuse_resion where 1=1 and busi_table_id = :1 and businessid = :2 and busi_type = :3
5s34t44u10q4g	SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1
63kf3an2j0pkc	insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
67yn721y75qk1	select STATUS from etl_logger where task_code in('SF046_056_057_060_061M_PROCESS') and data_date='2013-01-31'
69k5bhm12sz98	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
7dm72ffn3qdxt	select /*+ no_parallel_index(t, "DF_CUST_INDEX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad no_expand index_ffs(t, "DF_CUST_INDEX") */ count(*) as nrw, count(distinct sys_op_lbid(127878, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "DATACORE"."DF_CUST" sample block ( 24.3379237288, 1) t where "ACCOUNT_NO" is not null
7wwd9zjbvggmh	INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, VERSION, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, SYSDATE, :B4 , 0, :B3 , PRVT_ADVISOR.GET_DB_VERSION, NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )
8fzcxxk8rcpzr	begin dbms_stats.gather_table_stats(user, 'DF_CUST', cascade=>true); end;
9gcdqqnykad28	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.ACCOUNT as c4, t.DEAL_DATE as c5, t.CURRENCE_CODE as c6, t.CREDIT as c7, t.DEBT as c8, t.BALANCE as c9, t.REMARK as c10, '' as c11, '' as c12, '' as c13, '' as c14, '' as c15, '' as c16, '' as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35, t.instcode from t_base_changes t where t.instCode in ( :1 , :2 , :3 ) and t.datastatus in (5) order by t.instCode asc
9m7787camwh4m	begin :id := sys.dbms_transaction.local_transaction_id; end;
aktbxfjwnzgmu	update WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 )
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
b306sbh0pwwuk	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35, t.instcode from t_base_account t where t.instCode in ( :1 , :2 , :3 ) and t.datastatus in (5) and businessid in (select min(businessid) from t_base_account where datastatus in (5) group by branch_code, account, currence_code) order by t.instCode asc
bt9rk63hx7vya	select object from v$access where rownum < 10
c6nsvk8cbrx97	select uauthroler0_.OBJECT_ID as col_0_0_, uauthroler0_.RES_ID as col_1_0_, uauthroler0_.RES_DETAIL_VALUE as col_2_0_, uauthroler0_.RES_DETAIL_NAME as col_3_0_, uauthroler0_.SYSTEM_ID as col_4_0_ from U_AUTH_ROLE_RESOURCE uauthroler0_, U_AUTH_RES_MAP uauthresma1_ where uauthroler0_.RES_ID=uauthresma1_.RES_ID(+) and (uauthroler0_.OBJECT_ID in (select ubaseuserd2_.USER_ID from U_BASE_USER ubaseuserd2_ where ubaseuserd2_.USER_ENAME='Emerg13') or uauthroler0_.OBJECT_ID in (select uauthroleu3_.ROLE_ID from U_AUTH_ROLE_USER uauthroleu3_, U_AUTH_ROLE uauthroled4_ where uauthroleu3_.ROLE_ID=uauthroled4_.ROLE_ID and uauthroled4_.ENABLED='1' and uauthroleu3_.USER_ID='Emerg13')) and (uauthresma1_.RES_TYPE in ('PUB')) and uauthroler0_.SYSTEM_ID<>'00003'
c8gnrhxma4tas	SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
c9xfv3csk1vp0	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35, t.instcode from t_base_account t where t.instCode in ( :1 , :2 , :3 , :4 , :5 , :6 ) and t.datastatus in (5) and businessid in (select min(businessid) from t_base_account where datastatus in (5) group by branch_code, account, currence_code) order by t.instCode asc
cf06fwacdmgfk	select 'x' from dual
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
dh7h8nxgbnk8s	select t.tableId as tableId, t.businessId as businessId, t.packName as packName, t.fileName as fileName, t.is_receive as isReceive, t.is_sendmts as isSendMts from T_RPT_SEND_COMMIT t where 1=1 and packName = :1
dz7s6f90jcrq3	begin dbms_stats.gather_table_stats(user, 'DF_ACMOV_TODAY', cascade=>true); end;
f3223cb4ng6hq	select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and ((p.instance_id is not null and (to_char(p.instance_id) = :1)) or (p.instance_id is null and p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where bitand(b.flags, :2) <> 0 and lower(b.affinity) = lower(:3)))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and ((q.instance_id is not null and (to_char(q.instance_id) = :4)) or (q.instance_id is null and q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_c lass c where bitand(c.flags, :5) <> 0 and lower(c.affinity) = lower(:6)))) UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), j.field1, 0 from sys.job$ j where j.field1 is not null and j.field1 > 0 and j.field1 = :7 and j.this_date is null) a order by 1) where rownum = 1
fnk7155mk2jq6	insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g4njja2zp3n91	select * from V$ACCESS A
gahvm6u0m6v2c	select /*+ no_parallel_index(t, "DF_ACMOV_INDEX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad no_expand index_ffs(t, "DF_ACMOV_INDEX") */ count(*) as nrw, count(distinct sys_op_lbid(127877, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "DATACORE"."DF_ACMOV_TODAY" sample block ( 22.8198251887, 1) t where "ACCOUNT_NUMBER" is not null
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gkm5s73mcc6f7	select 'A', d.explanation, --金融机构标识码 c.account_no, --交易账号 to_date(a.batchentrydate, 'yyyy-mm-dd'), --发生日期 c.currencycode, --币种 --- SUM(decode(A.Creditdebit, 'C', a.transactionamount, 0)), --当日贷方发生额 SUM(case when A.Creditdebit='C'then a.transactionamount else 0 end), SUM(case when A.Creditdebit='D'then a.transactionamount else 0 end), --- SUM(decode(A.Creditdebit, 'D', a.transactionamount, 0)), --当日借方发生额 case when C.Currencycode = 'JPY' Then Round(c.Ccyledgerbalance, 0) else c.ccyledgerbalance End Balance, --账户余额 --b.instcode instcode, --系统虚拟机构代号 1 datastatus, --前台对应的数据状态 c.account_no || c.currencycode || '2013-01-04', to_date('2013-01-04', 'yyyy-mm-dd') from df_cust C left join /*(select distinct ACCOUNTBRANCH, DESCRIPTION, MASTERNO, CURRENCYCODE, ACCOUNT_NUMBER, SEQNO, ACCT_CLASS_CODE, PRODUCTCODE, VALUEDT_YYYY, VALUEDT_MM, VALUEDT_DD, BATCHENTRYDATE, VALUEDT_YYYYMMDD, NARRATIONPOST, TRANSACTIONAMOUNT, CREDITDEBIT, ACCOUNTBRANCH1, SEGMENTCODE, REFERENCENUMBER, NARRATIONTRAN, BATCHNUMBER, GLDEPTID, ARMCODE, EXTREFNO, MAKERID, CHECKERID, CHANNELID, TRANSACTION_AMT_IN_USD, ACCSHORTNAME, ARMNAME, SEGNAME, TXNCODE, REVERSALFLAG, EBBSREFERENCE, TRANSTYPECODE, CUSTOMERRATE, ADVTREASURYFLAG, VA_FLAG from df_acmov_today where Creditdebit in ('C', 'D'))*/df_acmov_today a on a.account_number = c.account_no Left Join Da_Mid_Acc_Gl_Dic D On D.Source = A.Accountbranch Where e xists (select 1 from acc.t_base_account b where b.account = c.account_no and b.currence_code = c.currencycode) and a.account_number is not null and c.account_no like '0%' group by d.explanation, --金融机构标识码 c.account_no, --交易账号 a.batchentrydate, --发生日期 c.currencycode, --币种 C.Ccyledgerbalance
grwydz59pu6mc	select text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Buffer Pool Statistics
• Checkpoint Activity

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 3,641

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin Snapshot, E: End Snapshot

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• 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.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

• Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
• STO - Snapshot Too Old count, OOS - Out of Space count
• Undo segment block stats:
• uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
• eS - expired Stolen, eR - expired Released, eU - expired reUsed

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

Back to Undo Statistics
Back to Top

Latch Statistics

• Latch Activity
• Latch Sleep Breakdown
• Latch Miss Sources
• Mutex Sleep Summary
• Parent Latch Statistics
• Child Latch Statistics

Latch Activity

• "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

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Latch Miss Sources

• only latches with sleeps are shown
• ordered by name, sleeps desc

Back to Latch Statistics
Back to Top

Mutex Sleep Summary