WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
WIND	618085559	wind	1	20-Apr-12 21:04	11.2.0.2.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
ddbp_lpar1	AIX-Based Systems (64-bit)	8	4		157.75

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	4687	02-May-12 10:00:06	59	8.2
End Snap:	4688	02-May-12 11:00:08	57	8.8
Elapsed:		60.03 (mins)
DB Time:		55.20 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	12,032M	12,032M	Std Block Size:	8K
Shared Pool Size:	3,712M	3,712M	Log Buffer:	72,708K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.9	0.3	0.00	0.00
DB CPU(s):	0.8	0.3	0.00	0.00
Redo size:	62,704.6	22,246.2
Logical reads:	75,105.9	26,646.0
Block changes:	299.4	106.2
Physical reads:	1.8	0.6
Physical writes:	11.6	4.1
User calls:	1,812.4	643.0
Parses:	62.6	22.2
Hard parses:	0.1	0.0
W/A MB processed:	47.5	16.8
Logons:	0.0	0.0
Executes:	1,581.1	560.9
Rollbacks:	0.7	0.2
Transactions:	2.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.99	Soft Parse %:	99.91
Execute to Parse %:	96.04	Latch Hit %:	99.08
Parse CPU to Parse Elapsd %:	3.15	% Non-Parse CPU:	99.99

Shared Pool Statistics

	Begin	End
Memory Usage %:	66.51	66.76
% SQL with executions>1:	98.70	98.65
% Memory for SQL w/exec>1:	93.82	93.70

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.78	0.83	11.2	1.3	0.1	87.5

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
9.5	75.7	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	161,536.0	161,536.0
SGA use (MB):	16,512.0	16,512.0
PGA use (MB):	131.3	138.7
% Host Mem used for SGA+PGA:	10.30	10.31

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): 3311.9s
• 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 83.0% of Total DB time 3,311.93 (s)
• Total FG Wait Time: 22.90 (s) DB CPU time: 2,724.63 (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 80.7% of Total DB Time (s): 3,312
• Captured PL/SQL account for 5.2% of Total DB Time (s): 3,312

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 17.7% of Total CPU Time (s): 2,725
• Captured PL/SQL account for 3.4% of Total CPU Time (s): 2,725

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

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: 270,509,715
• Captured SQL account for 97.9% 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: 6,361
• Captured SQL account for 0.2% 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: 1,571
• Captured SQL account for 0.0% of Total
• Total UnOptimized Read Requests: 1,571
• Captured SQL account for 0.0% 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: 5,694,475
• Captured SQL account for 96.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 225,465
• Captured SQL account for 65.7% 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
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)
15rbgh4d2ku4u	insert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, begin_interval_time, end_interval_time, snap_level, status, error_count, bl_moved, snap_flag, snap_timezone) values (:snap_id, :dbid, :instance_number, :startup_time, :begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1, :bind2)
1m46gkgrqd3m8	SELECT A0.classnamekeyA4, A0.idA3A4, A0.parameterName, A0.hierarchyIDB4 FROM EPMParameterMap A0 WHERE (((A0.idA3A4 IN (SELECT /*+ CARDINALITY(wtot 4900) */ * FROM TABLE(cast(:1 as LGPLM.TABLE_OF_NUMBER)) wtot WHERE (ROWNUM > 0) AND (column_value IS NOT NULL))))) AND (A0.markForDeleteA2 = 0)
1srb3qgk0txy8	SELECT 'wt.epm.workspaces.EPMWorkspace', A0.activeClientCache, A0.classnamekeyL5, A0.idA3L5, A0.classnamekeyK5, A0.idA3K5, A0.description, A0.directory, A0.classnamekeyD5, A0.idA3D5, A0.classnamekeyG5, A0.idA3G5, A0.classnamekeyE5, A0.idA3E5, A0.classnamekeyB5, A0.idA3B5, A0.name, A0.partCentricProcessing, A0.classnamekeyC5, A0.idA3C5, A0.classnamekeyH5, A0.idA3H5, A0.classnamekeyF5, A0.idA3F5, A0.populateRule, A0.classnamekeyM5, A0.idA3M5, A0.classnamekeyI5, A0.idA3I5, A0.classnamekeyA5, A0.idA3A5, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.transparent, A0.viewExplicitlySet, A0.classnamekeyJ5, A0.idA3J5 FROM EPMWorkspace A0 WHERE ((A0.name = :1 )) AND (A0.markForDeleteA2 = 0)
22dafs7fj1ds9	select a.ida3b5 from epmContainedIn a where a.ida3b5 in ( select /*+ cardinality ( b 6 ) */ b.column_value from table(cast(:1 as table_of_number)) b where (rownum > 0) ) group by a.ida3b5 having count (*) = :2
24ntnrp7gth9t	SELECT A0.idA3B5, A0.classnamekeyroleBObjectRef FROM MembershipLink A0 WHERE ((A0.idA3A5 IN (SELECT A0.idA3B4 FROM RolePrincipalMap A0 WHERE ((A0.role = :1 )))))
292rqntqm66kr	SELECT 'wt.queue.QueueEntry', A0.args, A0.blob$args, A0.classnamekeydomainRef, A0.idA3domainRef, TO_CHAR(A0.endExec, 'dd mm yyyy hh24:mi:ss'), A0.entryNumber, A0.entryOwnerIsNull, A0.classnamekeyB5, A0.idA3B5, A0.failureCount, A0.inheritedDomain, TO_CHAR(A0.datelock, 'dd mm yyyy hh24:mi:ss'), A0.classnamekeyA2lock, A0.idA3A2lock, A0.notelock, A0.classnamekeyA5, A0.idA3A5, A0.securityLabels, TO_CHAR(A0.startExec, 'dd mm yyyy hh24:mi:ss'), A0.statusInfoIsNull, A0.codeC5, A0.messageC5, TO_CHAR(A0.rescheduleTimeC5, 'dd mm yyyy hh24:mi:ss'), A0.targetClass, A0.targetMethod, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss') FROM QueueEntry A0 WHERE ((A0.idA2A2 = :1 ))
2kx5q24a98sqz	SELECT 'wt.epm.structure.EPMReferenceLink', A0.asStoredChildName, A0.depType, A0.hasIBAValues, A0.referenceType, A0.required, A0.classnamekeyroleAObjectRef, A0.idA3A5, A0.classnamekeyroleBObjectRef, A0.idA3B5, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.branchIdA2typeDefinitionRefe, A0.idA2typeDefinitionReference, A0.uniqueLinkID, A0.uniqueNDId FROM EPMReferenceLink A0 WHERE ((A0.idA3A5 = :1 )) AND (A0.markForDeleteA2 = 0)
2sb707adnyt07	SELECT 'wt.part.WTPart', A0.blob$entrySetadHocAcl, A0.checkoutInfoIsNull, A0.statecheckoutInfo, A0.classnamekeycontainerReferen, A0.idA3containerReference, A0.contractNumber, A0.classnamekeydomainRef, A0.idA3domainRef, A0.entrySetadHocAcl, A0.eventSet, A0.classnamekeyA2folderingInfo, A0.idA3A2folderingInfo, A0.classnamekeyB2folderingInfo, A0.idA3B2folderingInfo, A0.hasHangingChange, A0.hasPendingChange, A0.hasVariance, A0.indexersindexerSet, A0.inheritedDomain, A0.iopStateinteropInfo, A0.stateinteropInfo, A0.branchIditerationInfo, A0.classnamekeyD2iterationInfo, A0.idA3D2iterationInfo, A0.classnamekeyE2iterationInfo, A0.idA3E2iterationInfo, A0.iterationIdA2iterationInfo, A0.latestiterationInfo, A0.classnamekeyB2iterationInfo, A0.idA3B2iterationInfo, A0.noteiterationInfo, A0.classnamekeyC2iterationInfo, A0.idA3C2iterationInfo, A0.stateiterationInfo, A0.jobAuthorizationNumber, TO_CHAR(A0.datelock, 'dd mm yyyy hh24:mi:ss'), A0.classnamekeyA2lock, A0.idA3A2lock, A0.notelock, A0.classnamekeymasterReference, A0.idA3masterReference, A0.maximumAllowed, A0.minimumRequired, A0.oneOffVersionIdA2oneOffVersi, A0.classnamekeyA2ownership, A0.idA3A2ownership, A0.partType, A0.phase, A0.securityLabels, A0.source, A0.atGatestate, A0.classnamekeyA2state, A0.idA3A2state, A0.statestate, A0.teamIdIsNull, A0.classnamekeyteamId, A0.idA3teamId, A0.teamTemplateIdIsNull, A0.classnamekeyteamTemplateId, A0.idA3teamTemplateId, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR( A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.branchIdA2typeDefinitionRefe, A0.idA2typeDefinitionReference, A0.ptc_str_1typeInfoWTPart, A0.ptc_str_10typeInfoWTPart, A0.ptc_str_2typeInfoWTPart, A0.ptc_str_3typeInfoWTPart, A0.ptc_str_4typeInfoWTPart, A0.ptc_str_5typeInfoWTPart, A0.ptc_str_6typeInfoWTPart, A0.ptc_str_7typeInfoWTPart, A0.ptc_str_8typeInfoWTPart, A0.ptc_str_9typeInfoWTPart, A0.variation1, A0.variation2, A0.versionIdA2versionInfo, A0.versionLevelA2versionInfo, A0.versionSortIdA2versionInfo, A0.viewIsNull, A0.classnamekeyview, A0.idA3view, A0B.collapsible, A0B.classnamekeycontainerReferen, A0B.idA3containerReference, A0B.defaultTraceCode, A0B.defaultUnit, A0B.effCalculationStatus, A0B.effPropagationStop, A0B.endItem, A0B.genericType, A0B.hidePartInStructure, A0B.name, A0B.WTPartNumber, A0B.classnamekeyorganizationRefe, A0B.idA3organizationReference, A0B.phantom, A0B.series, TO_CHAR(A0B.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0B.markForDeleteA2, TO_CHAR(A0B.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0B.classnameA2A2, A0B.idA2A2, A0B.updateCountA2, TO_CHAR(A0B.updateStampA2, 'dd mm yyyy hh24:mi:ss'), 'wt.epm.build.EPMBuildHistory', A1.buildRuleID, A1.buildType, A1.classnamekeyroleAObjectRef, A1.idA3A5, A1.classnamekeyroleBObjectRef, A1.idA3B5, A1.status, TO_CHAR(A1.createStampA2, 'dd mm yyyy hh24:mi:ss'), A1.markForDeleteA2, TO_CHAR(A1.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A1.idA2A2, A1.updateCountA2, TO_CHAR(A1.updateStampA2, 'dd mm yyyy hh24:mi:ss') FROM WTPart A0, WTPartMaster A0B, EPMBuildHistory A1 WHERE (A0.idA3masterReference=A0B.idA2A2) AND ((A1.buildType = :1 )) AND ((A0.markForDeleteA2 = 0) AND (A1.markForDeleteA2 = 0)) AND ((A1.idA3B5 = A0.idA2A2) AND (A1.idA3A5 IN (SELECT /*+ CARDINALITY(wtot 1600) */ * FROM TABLE(cast(:2 as LGPLM.TABLE_OF_NUMBER)) wtot WHERE (ROWNUM > 0) AND (column_value IS NOT NULL))))
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
35hv2hrm4xr3u	SELECT 'wt.epm.structure.EPMMemberLink', A0.annotated, A0.asStoredChildName, A0.compLayerIdx, A0.compNumber, A0.compRevNumber, A0.depType, A0.fixed, A0.hasIBAValues, A0.idGroupKey, A0.identifier, A0.identifierSpaceName, A0.name, A0.placed, A0.amountC7, A0.unitC7, A0.referenceControlIsNull, A0.geomRestrB7, A0.geomRestrRecursiveB7, A0.scopeB7, A0.violRestrictionB7, A0.required, A0.classnamekeyroleAObjectRef, A0.idA3A5, A0.classnamekeyroleBObjectRef, A0.idA3B5, A0.sourceIdentifier, A0.substitute, A0.suppressed, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.transformIsNull, A0.rotation1_0A7, A0.rotation1_1A7, A0.rotation1_2A7, A0.rotation2_0A7, A0.rotation2_1A7, A0.rotation2_2A7, A0.rotation3_0A7, A0.rotation3_1A7, A0.rotation3_2A7, A0.translation_0A7, A0.translation_1A7, A0.translation_2A7, A0.branchIdA2typeDefinitionRefe, A0.idA2typeDefinitionReference, A0.uniqueLinkID, A0.uniqueNDId FROM EPMMemberLink A0 WHERE ((A0.idA3A5 = :1 )) AND (A0.markForDeleteA2 = 0)
37qk59xjhy3zy	UPDATE QueueEntry SET args=:1 , blob$args=:2 , classnamekeydomainRef=:3 , idA3domainRef=:4 , endExec=:5 , entryNumber=:6 , entryOwnerIsNull=:7 , classnamekeyB5=:8 , idA3B5=:9 , failureCount=:10 , inheritedDomain=:11 , datelock=:12 , classnamekeyA2lock=:13 , idA3A2lock=:14 , notelock=:15 , classnamekeyA5=:16 , idA3A5=:17 , securityLabels=:18 , startExec=:19 , statusInfoIsNull=:20 , codeC5=:21 , messageC5=:22 , rescheduleTimeC5=:23 , targetClass=:24 , targetMethod=:25 , markForDeleteA2=:26 , updateStampA2=:27 , modifyStampA2=:28 , updateCountA2=updateCountA2+1 WHERE ((idA2A2 = :29 ) AND (updateCountA2 = :30 ))
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
3f0brb868v3us	insert into MiscLogEvents (JVM_ID, JVM_STARTTIME, LE_ID, LE_ID_SEQNUM, LE_TIMESTAMP, LE_LOGGERNAME, LE_LEVEL, LE_THREADNAME, LE_THREADID, LE_THROWABLECLASS, LE_MDC_CONTEXTTYPE, LE_MDC_CONTEXTLABEL, LE_MDC_USER, LE_MDC_CLIENTADDR, LE_MDC_REMOTECALLID, LE_MDC_SERVLETREQUESTID, LE_MDC_WEBAPPCONTEXTPATH, LE_MDC_IECONTEXTID, LE_MDC_METHODCONTEXTID, LE_MDC_METHODCONTEXTDETAIL, LE_MESSAGE, LE_THROWABLE) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 )
3xhtaph75ddby	SELECT 'wt.epm.EPMDocument', A1.classnamekeyC10, A1.idA3C10, A1.authoringAppVersion, A1.classnamekeyB10, A1.idA3B10, A1.blob$entrySetadHocAcl, A1.boxExtentsIsNull, A1.AxD10, A1.AyD10, A1.AzD10, A1.BxD10, A1.ByD10, A1.BzD10, A1.checkoutInfoIsNull, A1.statecheckoutInfo, A1.classnamekeycontainerReferen, A1.idA3containerReference, A1.dbKeySize, A1.derived, A1.description, A1.classnamekeydomainRef, A1.idA3domainRef, A1.entrySetadHocAcl, A1.eventSet, A1.extentsValid, A1.familyTableStatus, A1.classnamekeyA2folderingInfo, A1.idA3A2folderingInfo, A1.classnamekeyB2folderingInfo, A1.idA3B2folderingInfo, A1.classnamekeyformat, A1.idA3format, A1.hasHangingChange, A1.hasPendingChange, A1.hasVariance, A1.indexersindexerSet, A1.inheritedDomain, A1.iopStateinteropInfo, A1.stateinteropInfo, A1.branchIditerationInfo, A1.classnamekeyD2iterationInfo, A1.idA3D2iterationInfo, A1.classnamekeyE2iterationInfo, A1.idA3E2iterationInfo, A1.iterationIdA2iterationInfo, A1.latestiterationInfo, A1.classnamekeyB2iterationInfo, A1.idA3B2iterationInfo, A1.noteiterationInfo, A1.classnamekeyC2iterationInfo, A1.idA3C2iterationInfo, A1.stateiterationInfo, A1.lengthScale, TO_CHAR(A1.datelock, 'dd mm yyyy hh24:mi:ss'), A1.classnamekeyA2lock, A1.idA3A2lock, A1.notelock, A1.classnamekeymasterReference, A1.idA3masterReference, A1.maximumAllowed, A1.minimumRequired, A1.missingDependents, A1.oneOffVersionIdA2oneOffVersi, A1.classnamekeyA2ownership, A1.idA3A2ownership, A1.placeHolder, A1.referenceControlIsNull, A1.geomRest rE10, A1.geomRestrRecursiveE10, A1.scopeE10, A1.violRestrictionE10, A1.revisionNumber, A1.classnamekeyrootItemReferenc, A1.idA3rootItemReference, A1.securityLabels, A1.atGatestate, A1.classnamekeyA2state, A1.idA3A2state, A1.statestate, A1.teamIdIsNull, A1.classnamekeyteamId, A1.idA3teamId, A1.teamTemplateIdIsNull, A1.classnamekeyteamTemplateId, A1.idA3teamTemplateId, A1.enabledtemplate, A1.templatedtemplate, TO_CHAR(A1.createStampA2, 'dd mm yyyy hh24:mi:ss'), A1.markForDeleteA2, TO_CHAR(A1.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A1.idA2A2, A1.updateCountA2, TO_CHAR(A1.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A1.branchIdA2typeDefinitionRefe, A1.idA2typeDefinitionReference, A1.verified, A1.versionIdA2versionInfo, A1.versionLevelA2versionInfo, A1.versionSortIdA2versionInfo, A1B.CADName, A1B.authoringApplication, A1B.collapsible, A1B.classnamekeycontainerReferen, A1B.idA3containerReference, A1B.defaultUnit, A1B.docSubType, A1B.docType, A1B.genericType, A1B.name, A1B.documentNumber, A1B.classnamekeyA6, A1B.idA3A6, A1B.classnamekeyorganizationRefe, A1B.idA3organizationReference, A1B.ownerApplication, A1B.series, TO_CHAR(A1B.createStampA2, 'dd mm yyyy hh24:mi:ss'), A1B.markForDeleteA2, TO_CHAR(A1B.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A1B.classnameA2A2, A1B.idA2A2, A1B.updateCountA2, TO_CHAR(A1B.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A1B.branchIdA2typeDefinitionRefe, A1B.idA2typeDefinitionReference FROM EPMContainedIn A0, EPMDocument A1, EPMDocumentMaster A1B WHERE (A1.idA3mas terReference=A1B.idA2A2) AND ((A0.idA3B5 = :1 ) AND (A1.idA2A2 = A0.idA3A5)) AND ((A0.markForDeleteA2 = 0) AND (A1.markForDeleteA2 = 0))
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
4u4bh9qyuxmq8	select b.ida3b5 from epmContainedIn b, epmDocument c where b.ida3b5 in (select /*+ cardinality (a 10) */ a.column_value acv from table(cast(:1 as table_of_number)) a where rownum > 0) and c.ida2a2 = b.ida3a5 and (c.IDA3CONTAINERREFERENCE = :2) union select b.ida3b5 from epmContainedIn b, epmDocument c where b.ida3b5 in (select /*+ cardinality (a 10) */ a.column_value acv from table(cast(:3 as table_of_number)) a where rownum > 0) and c.ida2a2 = b.ida3a5 and not exists ( select null from (select /*+ cardinality (d_i 1) */ d_i.column_value dcv from table(cast(:4 as table_of_varchar2)) d_i where rownum > 0) d where c.CLASSNAMEKEYCONTAINERREFEREN = d.dcv )
4wv8krft5tx7f	begin epm_family_table_utils.getFTCompatible(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 ); end;
50ygbjtv2a5v2	SELECT 0 indexAlias , A0.classnamekeyroleBObjectRef, A0.idA3B5, 'wt.filter.NavCriteriaConfigSpecLink', A0.idA2A2 FROM NavCriteriaConfigSpecLink A0 WHERE (((A0.classnamekeyroleBObjectRef = :1 ) AND (A0.idA3B5 = :2 ))) UNION ALL SELECT 1 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'wt.viewmarkup.RepresentableConfigSpecLink', A0.idA2A2 FROM RepresentableConfigSpecLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :3 ) AND (A0.idA3A5 = :4 ))) UNION ALL SELECT 2 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'wt.viewmarkup.DerivedFromConfigSpecLink', A0.idA2A2 FROM DerivedFromConfigSpecLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :5 ) AND (A0.idA3A5 = :6 ))) UNION ALL SELECT 3 indexAlias , A0.classnamekeyC5, A0.idA3C5, 'wt.epm.workspaces.WorkspacePartConfigSpec', A0.idA2A2 FROM EPMWorkspace A0 WHERE (((A0.classnamekeyC5 = :7 ) AND (A0.idA3C5 = :8 ))) UNION ALL SELECT 4 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'ext.liugong.printlist.MassPrintOrderLink', A0.idA2A2 FROM MassPrintOrderLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :9 ) AND (A0.idA3A5 = :10 ))) UNION ALL SELECT 5 indexAlias , A0.classnamekeyC9, A0.idA3C9, 'wt.annotation.AnnotationConfigSpec', A0.idA2A2 FROM StructuredAnnotationSet A0 WHERE (((A0.classnamekeyC9 = :11 ) AND (A0.idA3C9 = :12 )))
514tjv0zgpxwt	SELECT 'wt.epm.EPMDocumentMaster', A0.CADName, A0.authoringApplication, A0.collapsible, A0.classnamekeycontainerReferen, A0.idA3containerReference, A0.defaultUnit, A0.docSubType, A0.docType, A0.genericType, A0.name, A0.documentNumber, A0.classnamekeyA6, A0.idA3A6, A0.classnamekeyorganizationRefe, A0.idA3organizationReference, A0.ownerApplication, A0.series, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.branchIdA2typeDefinitionRefe, A0.idA2typeDefinitionReference FROM EPMDocumentMaster A0 WHERE ((A0.idA2A2 = :1 ))
54aryw5rx2nmg	select a.inst_id , c.ida2a2, c.name from (select a.column_value inst_id , (select b.ida3b5 from epmContainedIn b where b.ida3a5 = a.column_value and exists ( select 1 from epmSepFamilyTable d where d.ida2a2 = b.ida3b5 ) and rownum < 2 ) ftid from (select /*+ cardinality ( a_i 1 ) */ a_i.column_value from table(cast(:1 as table_of_number)) a_i where rownum > 0) a ) a , epmSepFamilyTable b , epmSepFamilyTableMaster c where b.ida2a2 = a.ftid and c.ida2a2 = b.ida3masterreference
59ktak83svwb2	select b.ida3b5 from epmContainedIn b, epmDocument c where b.ida3b5 in (select /*+ cardinality (a 6) */ a.column_value acv from table(cast(:1 as table_of_number)) a where rownum > 0) and c.ida2a2 = b.ida3a5 and (c.IDA3CONTAINERREFERENCE = :2) union select b.ida3b5 from epmContainedIn b, epmDocument c where b.ida3b5 in (select /*+ cardinality (a 6) */ a.column_value acv from table(cast(:3 as table_of_number)) a where rownum > 0) and c.ida2a2 = b.ida3a5 and not exists ( select null from (select /*+ cardinality (d_i 1) */ d_i.column_value dcv from table(cast(:4 as table_of_varchar2)) d_i where rownum > 0) d where c.CLASSNAMEKEYCONTAINERREFEREN = d.dcv )
5rygsj4dbw6jt	insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7)
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
5y97chy9az9n9	SELECT 0 indexAlias , A0.classnamekeyroleBObjectRef, A0.idA3B5, 'wt.filter.NavCriteriaConfigSpecLink', A0.idA2A2 FROM NavCriteriaConfigSpecLink A0 WHERE (((A0.classnamekeyroleBObjectRef = :1 ) AND (A0.idA3B5 = :2 ))) UNION ALL SELECT 1 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'wt.viewmarkup.RepresentableConfigSpecLink', A0.idA2A2 FROM RepresentableConfigSpecLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :3 ) AND (A0.idA3A5 = :4 ))) UNION ALL SELECT 2 indexAlias , A0.classnamekeyD5, A0.idA3D5, 'wt.epm.workspaces.WorkspaceDocConfigSpec', A0.idA2A2 FROM EPMWorkspace A0 WHERE (((A0.classnamekeyD5 = :5 ) AND (A0.idA3D5 = :6 ))) UNION ALL SELECT 3 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'wt.viewmarkup.DerivedFromConfigSpecLink', A0.idA2A2 FROM DerivedFromConfigSpecLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :7 ) AND (A0.idA3A5 = :8 ))) UNION ALL SELECT 4 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'ext.liugong.printlist.MassPrintOrderLink', A0.idA2A2 FROM MassPrintOrderLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :9 ) AND (A0.idA3A5 = :10 )))
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
6cu7nkbytqdbg	UPDATE ScheduleQueueEntry SET args=:1 , classnamekeydomainRef=:2 , idA3domainRef=:3 , endExec=:4 , entryNumber=:5 , entryOwnerIsNull=:6 , classnamekeyB5=:7 , idA3B5=:8 , failureCount=:9 , inheritedDomain=:10 , datelock=:11 , classnamekeyA2lock=:12 , idA3A2lock=:13 , notelock=:14 , classnamekeyA6=:15 , idA3A6=:16 , classnamekeyA5=:17 , idA3A5=:18 , scheduleTime=:19 , securityLabels=:20 , startExec=:21 , statusInfoIsNull=:22 , codeC5=:23 , messageC5=:24 , rescheduleTimeC5=:25 , targetClass=:26 , targetMethod=:27 , markForDeleteA2=:28 , updateStampA2=:29 , modifyStampA2=:30 , updateCountA2=updateCountA2+1 WHERE ((idA2A2 = :31 ) AND (updateCountA2 = :32 ))
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
73mhv84mqqn8w	select b.ida3b5 from epmContainedIn b, epmDocument c where b.ida3b5 in (select /*+ cardinality (a 1) */ a.column_value acv from table(cast(:1 as table_of_number)) a where rownum > 0) and c.ida2a2 = b.ida3a5 and (c.IDA3CONTAINERREFERENCE = :2) union select b.ida3b5 from epmContainedIn b, epmDocument c where b.ida3b5 in (select /*+ cardinality (a 1) */ a.column_value acv from table(cast(:3 as table_of_number)) a where rownum > 0) and c.ida2a2 = b.ida3a5 and not exists ( select null from (select /*+ cardinality (d_i 1) */ d_i.column_value dcv from table(cast(:4 as table_of_varchar2)) d_i where rownum > 0) d where c.CLASSNAMEKEYCONTAINERREFEREN = d.dcv )
7gzxf61vj6wq4	SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1
7h33jpfyx01gn	select b.ida3b5 from epmContainedIn b, epmDocument c where b.ida3b5 in (select /*+ cardinality (a 14) */ a.column_value acv from table(cast(:1 as table_of_number)) a where rownum > 0) and c.ida2a2 = b.ida3a5 and (c.IDA3CONTAINERREFERENCE = :2) union select b.ida3b5 from epmContainedIn b, epmDocument c where b.ida3b5 in (select /*+ cardinality (a 14) */ a.column_value acv from table(cast(:3 as table_of_number)) a where rownum > 0) and c.ida2a2 = b.ida3a5 and not exists ( select null from (select /*+ cardinality (d_i 1) */ d_i.column_value dcv from table(cast(:4 as table_of_varchar2)) d_i where rownum > 0) d where c.CLASSNAMEKEYCONTAINERREFEREN = d.dcv )
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 )
8n7n1mvvq9587	select d.ida3b5 from epmContainedIn d where d.ida3b5 in ( select a.ida2a2 from epmSepFamilyTable a where a.ida3masterreference = :1 ) and d.ida3a5 in ( select /*+ cardinality ( b 1 ) */ b.column_value from table(cast(:2 as table_of_number)) b where (rownum > 0) ) group by d.ida3b5 having count (*) = :3
8p03hcz4z2r9v	SELECT 'wt.content.ApplicationData', A0.authoredBy, A0.category, A0.checksum, A0.comments, A0.classnamekeyA4, A0.idA3A4, A0.description, A0.distributable, A0.fileName, A0.fileSize, A0.fileVersion, A0.classnamekeyB4, A0.idA3B4, A0.intentToChange, A0.lastAuthored, A0.lineNumber, A0.classnamekeyC4, A0.idA3C4, A0.role, A0.stale, A0.classnamekeyA5, A0.idA3A5, A0.streamId, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.toolName, A0.toolVersion, A0.uploadedFromPath, 'wt.content.HolderToContent', A1.classnamekeyroleAObjectRef, A1.idA3A5, A1.classnamekeyroleBObjectRef, A1.idA3B5, TO_CHAR(A1.createStampA2, 'dd mm yyyy hh24:mi:ss'), A1.markForDeleteA2, TO_CHAR(A1.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A1.idA2A2, A1.updateCountA2, TO_CHAR(A1.updateStampA2, 'dd mm yyyy hh24:mi:ss') FROM ApplicationData A0, HolderToContent A1 WHERE ((A1.idA3B5 = A0.idA2A2) AND (A1.idA3A5 = :1 ))
9du2a4j68qkzu	select a.column_value ida2a2, count(*) from table(cast(:1 as table_of_number)) a where rownum > 0 group by a.column_value
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
b614fx2gxtjkz	SELECT 'wt.epm.EPMDocument', A0.classnamekeyC10, A0.idA3C10, A0.authoringAppVersion, A0.classnamekeyB10, A0.idA3B10, A0.blob$entrySetadHocAcl, A0.boxExtentsIsNull, A0.AxD10, A0.AyD10, A0.AzD10, A0.BxD10, A0.ByD10, A0.BzD10, A0.checkoutInfoIsNull, A0.statecheckoutInfo, A0.classnamekeycontainerReferen, A0.idA3containerReference, A0.dbKeySize, A0.derived, A0.description, A0.classnamekeydomainRef, A0.idA3domainRef, A0.entrySetadHocAcl, A0.eventSet, A0.extentsValid, A0.familyTableStatus, A0.classnamekeyA2folderingInfo, A0.idA3A2folderingInfo, A0.classnamekeyB2folderingInfo, A0.idA3B2folderingInfo, A0.classnamekeyformat, A0.idA3format, A0.hasHangingChange, A0.hasPendingChange, A0.hasVariance, A0.indexersindexerSet, A0.inheritedDomain, A0.iopStateinteropInfo, A0.stateinteropInfo, A0.branchIditerationInfo, A0.classnamekeyD2iterationInfo, A0.idA3D2iterationInfo, A0.classnamekeyE2iterationInfo, A0.idA3E2iterationInfo, A0.iterationIdA2iterationInfo, A0.latestiterationInfo, A0.classnamekeyB2iterationInfo, A0.idA3B2iterationInfo, A0.noteiterationInfo, A0.classnamekeyC2iterationInfo, A0.idA3C2iterationInfo, A0.stateiterationInfo, A0.lengthScale, TO_CHAR(A0.datelock, 'dd mm yyyy hh24:mi:ss'), A0.classnamekeyA2lock, A0.idA3A2lock, A0.notelock, A0.classnamekeymasterReference, A0.idA3masterReference, A0.maximumAllowed, A0.minimumRequired, A0.missingDependents, A0.oneOffVersionIdA2oneOffVersi, A0.classnamekeyA2ownership, A0.idA3A2ownership, A0.placeHolder, A0.referenceControlIsNull, A0.geomRest rE10, A0.geomRestrRecursiveE10, A0.scopeE10, A0.violRestrictionE10, A0.revisionNumber, A0.classnamekeyrootItemReferenc, A0.idA3rootItemReference, A0.securityLabels, A0.atGatestate, A0.classnamekeyA2state, A0.idA3A2state, A0.statestate, A0.teamIdIsNull, A0.classnamekeyteamId, A0.idA3teamId, A0.teamTemplateIdIsNull, A0.classnamekeyteamTemplateId, A0.idA3teamTemplateId, A0.enabledtemplate, A0.templatedtemplate, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.branchIdA2typeDefinitionRefe, A0.idA2typeDefinitionReference, A0.verified, A0.versionIdA2versionInfo, A0.versionLevelA2versionInfo, A0.versionSortIdA2versionInfo, A0B.CADName, A0B.authoringApplication, A0B.collapsible, A0B.classnamekeycontainerReferen, A0B.idA3containerReference, A0B.defaultUnit, A0B.docSubType, A0B.docType, A0B.genericType, A0B.name, A0B.documentNumber, A0B.classnamekeyA6, A0B.idA3A6, A0B.classnamekeyorganizationRefe, A0B.idA3organizationReference, A0B.ownerApplication, A0B.series, TO_CHAR(A0B.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0B.markForDeleteA2, TO_CHAR(A0B.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0B.classnameA2A2, A0B.idA2A2, A0B.updateCountA2, TO_CHAR(A0B.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0B.branchIdA2typeDefinitionRefe, A0B.idA2typeDefinitionReference FROM EPMDocument A0, EPMDocumentMaster A0B, (SELECT A0_sub0.idA2A2 id, RANK() O VER ( PARTITION BY A0_sub0.idA3masterReference ORDER BY DECODE(A0_sub0.statecheckoutInfo, 'wrk', 1, 0) DESC, A0_sub0.versionSortIdA2versionInfo DESC, LPAD(COALESCE(A0_sub0.oneOffVersionIdA2oneOffVersi, ' '), 60) DESC, LPAD(A0_sub0.iterationIdA2iterationInfo, 60) DESC) rank FROM EPMDocument A0_sub0 WHERE (((A0_sub0.idA2A2 IN (SELECT K0.idA3B5 FROM EPMAsStoredMember K0 WHERE ((K0.idA3A5 = :1 )))) OR (NOT (EXISTS (SELECT NULL FROM EPMAsStoredMember K0, EPMDocument K1 WHERE ((K0.idA3A5 = :2 ) AND (K1.idA3masterReference = A0_sub0.idA3masterReference) AND (K0.idA3B5 = K1.idA2A2)))) AND (A0_sub0.latestiterationInfo = :3 ) AND (A0_sub0.oneOffVersionIdA2oneOffVersi IS NULL ))) AND (A0_sub0.idA3masterReference = :4 ))) A1 WHERE (A0.idA3masterReference=A0B.idA2A2) AND (((A0.idA2A2 = A1.id) AND (A1.rank = :5 )))
bbgd27a8rs5xa	SELECT 'wt.epm.EPMDocument', A0.classnamekeyC10, A0.idA3C10, A0.authoringAppVersion, A0.classnamekeyB10, A0.idA3B10, A0.blob$entrySetadHocAcl, A0.boxExtentsIsNull, A0.AxD10, A0.AyD10, A0.AzD10, A0.BxD10, A0.ByD10, A0.BzD10, A0.checkoutInfoIsNull, A0.statecheckoutInfo, A0.classnamekeycontainerReferen, A0.idA3containerReference, A0.dbKeySize, A0.derived, A0.description, A0.classnamekeydomainRef, A0.idA3domainRef, A0.entrySetadHocAcl, A0.eventSet, A0.extentsValid, A0.familyTableStatus, A0.classnamekeyA2folderingInfo, A0.idA3A2folderingInfo, A0.classnamekeyB2folderingInfo, A0.idA3B2folderingInfo, A0.classnamekeyformat, A0.idA3format, A0.hasHangingChange, A0.hasPendingChange, A0.hasVariance, A0.indexersindexerSet, A0.inheritedDomain, A0.iopStateinteropInfo, A0.stateinteropInfo, A0.branchIditerationInfo, A0.classnamekeyD2iterationInfo, A0.idA3D2iterationInfo, A0.classnamekeyE2iterationInfo, A0.idA3E2iterationInfo, A0.iterationIdA2iterationInfo, A0.latestiterationInfo, A0.classnamekeyB2iterationInfo, A0.idA3B2iterationInfo, A0.noteiterationInfo, A0.classnamekeyC2iterationInfo, A0.idA3C2iterationInfo, A0.stateiterationInfo, A0.lengthScale, TO_CHAR(A0.datelock, 'dd mm yyyy hh24:mi:ss'), A0.classnamekeyA2lock, A0.idA3A2lock, A0.notelock, A0.classnamekeymasterReference, A0.idA3masterReference, A0.maximumAllowed, A0.minimumRequired, A0.missingDependents, A0.oneOffVersionIdA2oneOffVersi, A0.classnamekeyA2ownership, A0.idA3A2ownership, A0.placeHolder, A0.referenceControlIsNull, A0.geomRest rE10, A0.geomRestrRecursiveE10, A0.scopeE10, A0.violRestrictionE10, A0.revisionNumber, A0.classnamekeyrootItemReferenc, A0.idA3rootItemReference, A0.securityLabels, A0.atGatestate, A0.classnamekeyA2state, A0.idA3A2state, A0.statestate, A0.teamIdIsNull, A0.classnamekeyteamId, A0.idA3teamId, A0.teamTemplateIdIsNull, A0.classnamekeyteamTemplateId, A0.idA3teamTemplateId, A0.enabledtemplate, A0.templatedtemplate, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.branchIdA2typeDefinitionRefe, A0.idA2typeDefinitionReference, A0.verified, A0.versionIdA2versionInfo, A0.versionLevelA2versionInfo, A0.versionSortIdA2versionInfo, A0B.CADName, A0B.authoringApplication, A0B.collapsible, A0B.classnamekeycontainerReferen, A0B.idA3containerReference, A0B.defaultUnit, A0B.docSubType, A0B.docType, A0B.genericType, A0B.name, A0B.documentNumber, A0B.classnamekeyA6, A0B.idA3A6, A0B.classnamekeyorganizationRefe, A0B.idA3organizationReference, A0B.ownerApplication, A0B.series, TO_CHAR(A0B.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0B.markForDeleteA2, TO_CHAR(A0B.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0B.classnameA2A2, A0B.idA2A2, A0B.updateCountA2, TO_CHAR(A0B.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0B.branchIdA2typeDefinitionRefe, A0B.idA2typeDefinitionReference FROM EPMDocument A0, EPMDocumentMaster A0B WHERE (A0.idA3masterReference=A0B.id A2A2) AND ((A0.idA2A2 = :1 ))
bg4w4k3sc4xmj	select a.ida3b5 from epmContainedIn a where a.ida3b5 in ( select /*+ cardinality ( b 1 ) */ b.column_value from table(cast(:1 as table_of_number)) b where (rownum > 0) ) group by a.ida3b5 having count (*) = :2
c8gnrhxma4tas	SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
ckh17hc0bucj1	SELECT 'wt.epm.workspaces.EPMWorkspace', A0.activeClientCache, A0.classnamekeyL5, A0.idA3L5, A0.classnamekeyK5, A0.idA3K5, A0.description, A0.directory, A0.classnamekeyD5, A0.idA3D5, A0.classnamekeyG5, A0.idA3G5, A0.classnamekeyE5, A0.idA3E5, A0.classnamekeyB5, A0.idA3B5, A0.name, A0.partCentricProcessing, A0.classnamekeyC5, A0.idA3C5, A0.classnamekeyH5, A0.idA3H5, A0.classnamekeyF5, A0.idA3F5, A0.populateRule, A0.classnamekeyM5, A0.idA3M5, A0.classnamekeyI5, A0.idA3I5, A0.classnamekeyA5, A0.idA3A5, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.transparent, A0.viewExplicitlySet, A0.classnamekeyJ5, A0.idA3J5 FROM EPMWorkspace A0 WHERE ((A0.idA3C5 = :1 )) AND (A0.markForDeleteA2 = 0)
dugp88yh7j813	SELECT 0 indexAlias , A0.classnamekeyB3, A0.idA3B3, 'wt.access.AclEntryLink', A0.idA2A2 FROM WTAclEntry A0 WHERE (((A0.classnamekeyB3 = :1 ) AND (A0.idA3B3 = :2 ))) UNION ALL SELECT 1 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'wt.folder.SubFolderLink', A0.idA2A2 FROM SubFolderLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :3 ) AND (A0.idA3A5 = :4 ))) UNION ALL SELECT 2 indexAlias , A0.classnamekeyB5, A0.idA3B5, 'wt.epm.workspaces.WorkspaceFolder', A0.idA2A2 FROM EPMWorkspace A0 WHERE (((A0.classnamekeyB5 = :5 ) AND (A0.idA3B5 = :6 ))) UNION ALL SELECT 3 indexAlias , A0.classnamekeyA4, A0.idA3A4, 'wt.folder.history.ObjectTheLocationChangeRecord', A0.idA2A2 FROM LocationChangeRecord A0 WHERE (((A0.classnamekeyA4 = :7 ) AND (A0.idA3A4 = :8 ))) UNION ALL SELECT 4 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'ext.liugong.printlist.MassPrintOrderLink', A0.idA2A2 FROM MassPrintOrderLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :9 ) AND (A0.idA3A5 = :10 ))) UNION ALL SELECT 5 indexAlias , A0.classnamekeyroleBObjectRef, A0.idA3B5, 'wt.folder.FolderMemberLink', A0.idA2A2 FROM FolderMemberLink A0 WHERE (((A0.classnamekeyroleBObjectRef = :11 ) AND (A0.idA3B5 = :12 ))) UNION ALL SELECT 6 indexAlias , A0.classnamekeyA6, A0.idA3A6, 'wt.workflow.notebook.WfBookmarkObjectLink', A0.idA2A2 FROM WfBookmark A0 WHERE (((A0.classnamekeyA6 = :13 ) AND (A0.idA3A6 = :14 ))) UNION ALL SELECT 7 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'wt.folder.IteratedFolderMe mberLink', A0.idA2A2 FROM IterFolderMemberLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :15 ) AND (A0.idA3A5 = :16 ))) UNION ALL SELECT 8 indexAlias , A0.classnamekeyB3, A0.idA3B3, 'wt.epm.workspaces.TargetFolderLink', A0.idA2A2 FROM EPMInitialCheckinData A0 WHERE (((A0.classnamekeyB3 = :17 ) AND (A0.idA3B3 = :18 ))) UNION ALL SELECT 9 indexAlias , A0.classnamekeyG5, A0.idA3G5, 'wt.epm.workspaces.WorkspaceDocFolder', A0.idA2A2 FROM EPMWorkspace A0 WHERE (((A0.classnamekeyG5 = :19 ) AND (A0.idA3G5 = :20 ))) UNION ALL SELECT 10 indexAlias , A0.classnamekeyB4, A0.idA3B4, 'wt.folder.history.OldFolderTheLocationChangeRecord', A0.idA2A2 FROM LocationChangeRecord A0 WHERE (((A0.classnamekeyB4 = :21 ) AND (A0.idA3B4 = :22 ))) UNION ALL SELECT 11 indexAlias , A0.classnamekeyroleAObjectRef, A0.idA3A5, 'wt.folder.FolderMemberLink', A0.idA2A2 FROM FolderMemberLink A0 WHERE (((A0.classnamekeyroleAObjectRef = :23 ) AND (A0.idA3A5 = :24 ))) UNION ALL SELECT 12 indexAlias , A0.classnamekeyH5, A0.idA3H5, 'wt.epm.workspaces.WorkspacePartFolder', A0.idA2A2 FROM EPMWorkspace A0 WHERE (((A0.classnamekeyH5 = :25 ) AND (A0.idA3H5 = :26 ))) UNION ALL SELECT 13 indexAlias , A0.classnamekeyroleBObjectRef, A0.idA3B5, 'wt.folder.SubFolderLink', A0.idA2A2 FROM SubFolderLink A0 WHERE (((A0.classnamekeyroleBObjectRef = :27 ) AND (A0.idA3B5 = :28 )))
f0wj261bm8snd	update wrm$_wr_control set snap_interval = :bind1, snapint_num = :bind2, retention = :bind3, retention_num = :bind4, most_recent_snap_id = :bind5, most_recent_snap_time = :bind6, mrct_snap_time_num = :bind7, status_flag = :bind8, most_recent_purge_time = :bind9, mrct_purge_time_num = :bind10, most_recent_split_id = :bind11, most_recent_split_time = :bind12, swrf_version = :bind13, registration_status = :bind14, mrct_baseline_id = :bind15, topnsql = :bind16, mrct_bltmpl_id = :bind17 where dbid = :dbid
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
g5d09tdy0qq3p	BEGIN :1 := IBAValuesPK.CopyIBAValuesMultiple(:2 ); END;
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gnq3jshqz559f	SELECT 'wt.epm.workspaces.EPMWorkspace', A0.activeClientCache, A0.classnamekeyL5, A0.idA3L5, A0.classnamekeyK5, A0.idA3K5, A0.description, A0.directory, A0.classnamekeyD5, A0.idA3D5, A0.classnamekeyG5, A0.idA3G5, A0.classnamekeyE5, A0.idA3E5, A0.classnamekeyB5, A0.idA3B5, A0.name, A0.partCentricProcessing, A0.classnamekeyC5, A0.idA3C5, A0.classnamekeyH5, A0.idA3H5, A0.classnamekeyF5, A0.idA3F5, A0.populateRule, A0.classnamekeyM5, A0.idA3M5, A0.classnamekeyI5, A0.idA3I5, A0.classnamekeyA5, A0.idA3A5, TO_CHAR(A0.createStampA2, 'dd mm yyyy hh24:mi:ss'), A0.markForDeleteA2, TO_CHAR(A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'), A0.idA2A2, A0.updateCountA2, TO_CHAR(A0.updateStampA2, 'dd mm yyyy hh24:mi:ss'), A0.transparent, A0.viewExplicitlySet, A0.classnamekeyJ5, A0.idA3J5 FROM EPMWorkspace A0 WHERE ((A0.idA3D5 = :1 )) AND (A0.markForDeleteA2 = 0)

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: 41,762

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

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

• ordered by wait time desc, waits desc

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