WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
LQSI	2184274693	lqsi2	2	04-Nov-13 14:11	11.2.0.2.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
lqsb02	Linux x86 64-bit	32	32	4	125.91

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	14929	06-Nov-13 15:00:09	210	3.1
End Snap:	14930	06-Nov-13 16:00:14	215	3.6
Elapsed:		60.09 (mins)
DB Time:		265.27 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	10,368M	10,112M	Std Block Size:	8K
Shared Pool Size:	7,552M	7,552M	Log Buffer:	24,132K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	4.4	22.4	0.02	0.33
DB CPU(s):	0.1	0.5	0.00	0.01
Redo size:	6,039.7	30,583.0
Logical reads:	8,987.5	45,509.5
Block changes:	37.9	192.1
Physical reads:	400.2	2,026.2
Physical writes:	2.3	11.7
User calls:	13.5	68.4
Parses:	11.5	58.2
Hard parses:	1.3	6.6
W/A MB processed:	0.4	2.0
Logons:	0.2	1.1
Executes:	206.5	1,045.6
Rollbacks:	0.0	0.0
Transactions:	0.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.85	In-memory Sort %:	100.00
Library Hit %:	98.03	Soft Parse %:	88.63
Execute to Parse %:	94.44	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	0.31	% Non-Parse CPU:	93.56

Shared Pool Statistics

	Begin	End
Memory Usage %:	54.77	57.54
% SQL with executions>1:	95.67	95.92
% Memory for SQL w/exec>1:	95.37	94.83

Top 5 Timed Foreground Events

Host CPU (CPUs: 32 Cores: 32 Sockets: 4)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.59	0.66	0.5	0.1	0.2	99.4

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.4	62.6	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	128,934.6	128,934.6
SGA use (MB):	18,432.0	18,432.0
PGA use (MB):	559.0	608.2
% Host Mem used for SGA+PGA:	14.73	14.77

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	7.64	38.69
Global Cache blocks served:	4.56	23.09
GCS/GES messages received:	16.28	82.44
GCS/GES messages sent:	26.96	136.52
DBWR Fusion writes:	0.13	0.64
Estd Interconnect traffic (KB)	106.05

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	99.76
Buffer access - remote cache %:	0.09
Buffer access - disk %:	0.15

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	60.0
Avg global cache cr block receive time (ms):	0.4
Avg global cache current block receive time (ms):	1.4
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	59.5
Avg global cache cr block flush time (ms):	1.7
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.1
Avg global cache current block flush time (ms):	2.7

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	0.2
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	56.26
% of indirect sent messages:	43.70
% of flow controlled messages:	0.04

Cluster Interconnect

• if IP/Public/Source at End snap is different a '*' is displayed

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

More RAC Statistics

• RAC Report Summary
• Global Messaging Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats
• Interconnect Stats
• Dynamic Remastering Statistics

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): 15916.1s
• 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.1% of Total DB time 15,916.07 (s)
• Total FG Wait Time: 15,580.11 (s) DB CPU time: 351.96 (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)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % 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 min to 1 hr)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours)
• % 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

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
• SQL ordered by Cluster Wait Time
• 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 88.0% of Total DB Time (s): 15,916
• Captured PL/SQL account for 51.5% of Total DB Time (s): 15,916

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 42.3% of Total CPU Time (s): 352
• Captured PL/SQL account for 26.2% of Total CPU Time (s): 352

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 5.3% of Total User I/O Wait Time (s): 103
• Captured PL/SQL account for 78.7% of Total User I/O Wait Time (s): 103

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: 32,402,786
• Captured SQL account for 22.2% 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: 1,442,677
• Captured SQL account for 2.0% 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: 46,445
• Captured SQL account for 62.1% of Total
• Total UnOptimized Read Requests: 46,445
• Captured SQL account for 62.1% 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: 744,474
• Captured SQL account for 92.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 41,409
• Captured SQL account for 41.3% 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

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

• %Total - Cluster Time as a percentage of Total Cluster Wait Time
• %Clu - Cluster Time as a percentage of Elapsed Time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 8
• Captured SQL account for 29.0% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0ajd0gaga7s0q	UPDATE AC01 A SET A.AAC013 = (SELECT AAC013 FROM AC01 WHERE AAC001=:B2 ) WHERE AAC001 = :B1
0d5uau8pjgfqh	BEGIN tbcbcheck(:1, :2, :3) ; END;
0vm5ju1vzcycd	SELECT UPPER(RTRIM(:B2 )||RTRIM(:B1 )) FROM DUAL
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1vv4nxc05y5yp	BEGIN SYS.KUPM$MCP.MAIN('SYS_EXPORT_TABLE_01', 'LQSI', 0, 0); END;
2j9uuvnvjh4c6	insert into AC02 (AAC030, EAC020, AAC032, EAC017, AAC031, EAC018, AAA040, AAE011, AAE036, AAE035, AAB033, AAC001, AAE140) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
2syvqzbxp4k9z	select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner#
2xyb5d6xg9srh	select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2
35m78h1ywpcju	SELECT SUBSTR(:B2 , 1, 6)||'19'||SUBSTR(:B1 , 7, 9) FROM DUAL
39m4sx9k63ba2	select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
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
3huk444dnag6r	BEGIN sys.kupc$que_int.create_queues(:1, :2, :3, :4, :5); END;
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3m27b94mh7gdp	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', 'ÏÕÖÖÔö¼Ó', '1', 'ÏÕÖÖÖжÏ', '2', 'ÏÕÖÖÖÕÖ¹', '3', 'ÏÕÖÖת³ö', '4', 'ÏÕÖÖÐÅÏ¢±ä¸ü', 'ÆäËû') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020265706' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
4cr5buq5p23ny	BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_TABLE_01', 'LQSI', 0); END;
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4yu8rhan7b7fa	update AC01 set AAB001=:1, EAC012=:2, EAC109=:3, AAC002=:4, AAC003=:5, AAC004=:6, AAC006=:7, AAC009=:8, AAC012=:9, AAC013=:10, AAC020=:11, EAB009=:12, EAB010=:13, EAC013=:14, EAC014=:15, EKC002=:16, AAE116=:17, EAC019=:18, ELC001=:19, EJC001=:20, EAC015=:21, EAC016=:22, AAC008=:23, AAE036=:24, AAE011=:25, AAE035=:26 where AAC001=:27
53n4zdzgx5rta	SELECT COUNT(1) FROM ACB6 WHERE AAC001=:B3 AND EAE003=:B2 AND AAE140=:B1 AND EAC029>0
56wfq198y16kr	select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0000068982' order by aae036
5822cq509c859	SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('CONSTRAINT_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.NAME , KU$.NAME , 'CONSTRAINT' , KU$.OWNER_NAME FROM SYS.KU$_CONSTRAINT_VIEW KU$ WHERE NOT (KU$.CON1.CONTYPE=3 AND KU$.CON1.INTCOLS=1 AND KU$.CON1.OID_OR_SETID!=0) AND NOT (KU$.CON1.CONTYPE=2 AND BITAND(KU$.CON1.PROPERTY, 64+4096)!=0) AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND (KU$.CON1.CONTYPE NOT IN (5) OR KU$.CON1.IND.TYPE_NUM NOT IN (4, 8, 9)) AND KU$.OWNER_NAME IN (SELECT UNIQUE object_schema FROM "LQSI"."SYS_EXPORT_TABLE_01" WHERE process_order = -55 AND duplicate BETWEEN 1 AND 1)
5a2mcq15h4h8h	DELETE FROM TEMP_AC02_IN
5ufbf5v4shvh7	SELECT MOD(12 - MOD((SUBSTR(:B1 , 1, 1)*7+ SUBSTR(:B1 , 2, 1)*9+ SUBSTR(:B1 , 3, 1)*10+ SUBSTR(:B1 , 4, 1)*5+ SUBSTR(:B1 , 5, 1)*8+ SUBSTR(:B1 , 6, 1)*4+ SUBSTR(:B1 , 7, 1)*2+ SUBSTR(:B1 , 8, 1)*1+ SUBSTR(:B1 , 9, 1)*6+ SUBSTR(:B1 , 10, 1)*3+ SUBSTR(:B1 , 11, 1)*7+ SUBSTR(:B1 , 12, 1)*9+ SUBSTR(:B1 , 13, 1)*10+ SUBSTR(:B1 , 14, 1)*5+ SUBSTR(:B1 , 15, 1)*8+ SUBSTR(:B1 , 16, 1)*4+ SUBSTR(:B1 , 17, 1)*2), 11), 11) FROM DUAL
6naa7r5qjq33v	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', 'ÏÕÖÖÔö¼Ó', '1', 'ÏÕÖÖÖжÏ', '2', 'ÏÕÖÖÖÕÖ¹', '3', 'ÏÕÖÖת³ö', '4', 'ÏÕÖÖÐÅÏ¢±ä¸ü', 'ÆäËû') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020207076' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
6zdjq2cdqb8tb	SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT (KU$.TYPE_NUM=1 AND KU$.INTCOLS=1 AND KU$.OID_OR_SETID!=0) AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.SCHEMA_OBJ.OWNER_NAME IN (SELECT UNIQUE object_schema FROM "LQSI"."SYS_EXPORT_TABLE_01" WHERE process_order = -55 AND duplicate BETWEEN 1 AND 1) AND KU$.TYPE_NUM NOT IN (2, 4, 8, 9) AND BITAND(KU$.PROPERTY, 16)!=16 ORDER BY KU$.SCHEMA_OBJ.OWNER_NUM, KU$.SCHEMA_OBJ.DATAOBJ_NUM
8c0syt8yv0qvn	BEGIN SYS.DBMS_DATAPUMP.GET_STATUS( handle => :JOBHNDL, mask => :MASK, timeout => :TIMEOUT, job_state => :JOB_STATE, status => :STATUS); END;
8rqjzu3ymdqs3	INSERT INTO F_AC01_ERR@YLBXDB VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :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 , :B52 , :B53 , :B54 , :B55 , :B56 , :B57 , :B58 , :B59 , :B60 , :B61 , :B62 , :B63 )
8s9z9d2dwuawk	update sbds_log set ordnum = abs(ordnum) + 1 where userflag = 'ORA$PIPE$077000190002'
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
9690wqnb8v5n5	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', 'ÏÕÖÖÔö¼Ó', '1', 'ÏÕÖÖÖжÏ', '2', 'ÏÕÖÖÖÕÖ¹', '3', 'ÏÕÖÖת³ö', '4', 'ÏÕÖÖÐÅÏ¢±ä¸ü', 'ÆäËû') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020259704' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
972qfjmxbd2pq	select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0020207076' order by aae036
97xqgqgwyjhk3	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', 'ÏÕÖÖÔö¼Ó', '1', 'ÏÕÖÖÖжÏ', '2', 'ÏÕÖÖÖÕÖ¹', '3', 'ÏÕÖÖת³ö', '4', 'ÏÕÖÖÐÅÏ¢±ä¸ü', 'ÆäËû') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020278829' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
98h9y8qdznwqs	BEGIN PKG_YBJK.p_Ac01(:1, :2, :3, :4, :5, :6, :7); END;
a24fwcw8duxxm	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', 'ÏÕÖÖÔö¼Ó', '1', 'ÏÕÖÖÖжÏ', '2', 'ÏÕÖÖÖÕÖ¹', '3', 'ÏÕÖÖת³ö', '4', 'ÏÕÖÖÐÅÏ¢±ä¸ü', 'ÆäËû') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020211816' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
a8w0vp4s8r32k	select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0020259704' order by aae036
azk6a54d1831z	SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'TABLE' , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG FROM SYS.KU$_HTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, 8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND (BITAND(KU$.FLAGS, 536870912)=0)
c01a5ph16g37p	BEGIN P_MEREMP(:1, :2, :3, :4, :5, :6, :7, :8) ; END;
c60x45yknsbnu	select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$0A6A031F0002'
c6awqs517jpj0	select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
ccgnz4nxhfy7d	SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , 'TABLE' , to_char(KU$.BYTES_ALLOC) , KU$.DATAOBJ_NUM , to_char(KU$.ET_PARALLEL) , KU$.FGAC , KU$.LONGCOL , KU$.NONSCOPED_REF , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.NAME , KU$.NAME , 'TABLE_DATA' , KU$.PART_NAME , KU$.PARTTYPE , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.SCHEMA_OBJ.NAME , KU$.TRIGFLAG , decode(KU$.SCHEMA_OBJ.TYPE_NUM, 2, decode(bitand(KU$.PROPERTY, 8224), 8224, 'NESTED PARTITION', 8192, 'NESTED TABLE', 'TABLE'), 19, decode(bitand(KU$.PROPERTY, 8224), 8224, 'NESTED PARTITION', 'PARTITION'), 20, 'PARTITION', 'SUBPARTITION') , to_char(KU$.UNLOAD_METHOD) , KU$.XMLTYPE_FMTS FROM SYS.KU$_TABLE_DATA_VIEW KU$ WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT (BITAND (KU$.BASE_OBJ.FLAGS, 16)=16) AND NOT XML_OUTOFLINE='Y' AND KU$.BASE_OBJ.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(100001)))
cj99gs2g7g8ph	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', 'ÏÕÖÖÔö¼Ó', '1', 'ÏÕÖÖÖжÏ', '2', 'ÏÕÖÖÖÕÖ¹', '3', 'ÏÕÖÖת³ö', '4', 'ÏÕÖÖÐÅÏ¢±ä¸ü', 'ÆäËû') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020222025' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d5cbbqhhcp9bg	DECLARE JOBHNDL NUMBER; BEGIN :JOBHNDL := SYS.DBMS_DATAPUMP.OPEN( operation =>:OPERATION, job_mode => :JOB_MODE, remote_link => :REMOTE_LINK, job_name => :JOB_NAME, version => :VERSION); END;
d5dc6cjympmn4	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', 'ÏÕÖÖÔö¼Ó', '1', 'ÏÕÖÖÖжÏ', '2', 'ÏÕÖÖÖÕÖ¹', '3', 'ÏÕÖÖת³ö', '4', 'ÏÕÖÖÐÅÏ¢±ä¸ü', 'ÆäËû') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020317417' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
d5pfxagb5v6uy	SELECT COUNT(*) FROM ( SELECT ISCODE FROM LQTB_SBDB_GDARCH WHERE UPISCODE(DOWNISCODE1(ISCODE))=:B1 AND STATUS IN(1, 2, 6) UNION ALL SELECT ISCODE FROM LQTB2_SBDB_GDARCH WHERE UPISCODE(DOWNISCODE1(ISCODE))=:B1 AND STATUS IN(1, 2, 6))
d7agdxycg1x8u	SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.SCHEMA_OBJ.OWNER_NAME IN (SELECT UNIQUE object_schema FROM "LQSI"."SYS_EXPORT_TABLE_01" WHERE process_order = -55 AND duplicate BETWEEN 1 AND 1) AND ((BITAND(KU$.PROPERTY, 16)=16 OR KU$.TYPE_NUM=2) AND KU$.TYPE_NUM!=9) ORDER BY KU$.SCHEMA_OBJ.OWNER_NUM, KU$.SCHEMA_OBJ.DATAOBJ_NUM
dba9v5vbg92cy	update sbds_log set ordnum = abs(ordnum) + 1 where userflag = 'ORA$PIPE$0A6A031F0002'
f6b6b3d6b15sg	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', 'ÏÕÖÖÔö¼Ó', '1', 'ÏÕÖÖÖжÏ', '2', 'ÏÕÖÖÖÕÖ¹', '3', 'ÏÕÖÖת³ö', '4', 'ÏÕÖÖÐÅÏ¢±ä¸ü', 'ÆäËû') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020265701' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
fhw2qjm168nwy	SELECT SB_PRSENO.NEXTVAL FROM DUAL
ftj9uawt4wwzb	select condition from cdef$ where rowid=:1
ftqkfkkxxa145	select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$077000190002'
ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gf883g2au84d2	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', 'ÏÕÖÖÔö¼Ó', '1', 'ÏÕÖÖÖжÏ', '2', 'ÏÕÖÖÖÕÖ¹', '3', 'ÏÕÖÖת³ö', '4', 'ÏÕÖÖÐÅÏ¢±ä¸ü', 'ÆäËû') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0000068982' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
gnkrt49h24x8a	select pctfree_stg, pctused_stg, size_stg, initial_stg, next_stg, minext_stg, maxext_stg, maxsiz_stg, lobret_stg, mintim_stg, pctinc_stg, initra_stg, maxtra_stg, optimal_stg, maxins_stg, frlins_stg, flags_stg, bfp_stg, enc_stg, cmpflag_stg, cmplvl_stg from deferred_stg$ where obj# =:1
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