WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

COREDB 87227165 COREDB1 1 17-5月 -13 05:05 11.2.0.2.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
COREDB	87227165	COREDB1	1	17-5月 -13 05:05	11.2.0.2.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

CORE-DB1 AIX-Based Systems (64-bit) 24 12 48.25

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
CORE-DB1	AIX-Based Systems (64-bit)	24	12		48.25

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 25476 07-8月 -13 22:00:05 559 6.6

End Snap: 25477 07-8月 -13 23:00:14 818 6.4

Elapsed: 60.15 (mins)

DB Time: 4,776.06 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	25476	07-8月 -13 22:00:05	559	6.6
End Snap:	25477	07-8月 -13 23:00:14	818	6.4
Elapsed:		60.15 (mins)
DB Time:		4,776.06 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 15,616M 15,552M Std Block Size: 8K

Shared Pool Size: 8,576M 8,640M Log Buffer: 16,536K

	Begin	End
Buffer Cache:	15,616M	15,552M	Std Block Size:	8K
Shared Pool Size:	8,576M	8,640M	Log Buffer:	16,536K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 79.4 1.5 0.15 0.05

DB CPU(s): 2.6 0.1 0.00 0.00

Redo size: 91,898.6 1,767.4

Logical reads: 162,169.0 3,118.9

Block changes: 534.3 10.3

Physical reads: 5,231.3 100.6

Physical writes: 36.2 0.7

User calls: 1,536.0 29.5

Parses: 407.7 7.8

Hard parses: 50.3 1.0

W/A MB processed: 14.0 0.3

Logons: 0.7 0.0

Executes: 519.0 10.0

Rollbacks: 35.8 0.7

Transactions: 52.0

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	79.4	1.5	0.15	0.05
DB CPU(s):	2.6	0.1	0.00	0.00
Redo size:	91,898.6	1,767.4
Logical reads:	162,169.0	3,118.9
Block changes:	534.3	10.3
Physical reads:	5,231.3	100.6
Physical writes:	36.2	0.7
User calls:	1,536.0	29.5
Parses:	407.7	7.8
Hard parses:	50.3	1.0
W/A MB processed:	14.0	0.3
Logons:	0.7	0.0
Executes:	519.0	10.0
Rollbacks:	35.8	0.7
Transactions:	52.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

Buffer Hit %: 98.01 In-memory Sort %: 100.00

Library Hit %: 83.71 Soft Parse %: 87.67

Execute to Parse %: 21.45 Latch Hit %: 99.81

Parse CPU to Parse Elapsd %: 0.29 % Non-Parse CPU: 92.91

Shared Pool Statistics

Begin End

Memory Usage %: 62.18 64.21

% SQL with executions>1: 79.34 64.61

% Memory for SQL w/exec>1: 77.89 59.05

	Begin	End
Memory Usage %:	62.18	64.21
% SQL with executions>1:	79.34	64.61
% Memory for SQL w/exec>1:	77.89	59.05

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
library cache lock	8,244	181,704	22041	63.41	Concurrency
cursor: pin S wait on X	380	61,008	160548	21.29	Concurrency
DB CPU		9,196		3.21
resmgr:cpu quantum	64,336	4,831	75	1.69	Scheduler
db file sequential read	744,281	4,113	6	1.44	User I/O

Host CPU (CPUs: 24 Cores: 12 Sockets: )

Load Average Begin Load Average End %User %System %WIO %Idle

4.47 5.38 14.7 3.9 5.3 81.4

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
4.47	5.38	14.7	3.9	5.3	81.4

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

10.9 58.9 1.6

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
10.9	58.9	1.6

Begin End

Host Mem (MB): 49,408.0 49,408.0

SGA use (MB): 24,576.0 24,576.0

PGA use (MB): 3,003.4 3,885.0

% Host Mem used for SGA+PGA: 55.82 57.60

	Begin	End
Host Mem (MB):	49,408.0	49,408.0
SGA use (MB):	24,576.0	24,576.0
PGA use (MB):	3,003.4	3,885.0
% Host Mem used for SGA+PGA:	55.82	57.60

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 176.53 3.40

Global Cache blocks served: 103.85 2.00

GCS/GES messages received: 461.48 8.88

GCS/GES messages sent: 770.38 14.82

DBWR Fusion writes: 5.49 0.11

Estd Interconnect traffic (KB) 2,483.62

	Per Second	Per Transaction
Global Cache blocks received:	176.53	3.40
Global Cache blocks served:	103.85	2.00
GCS/GES messages received:	461.48	8.88
GCS/GES messages sent:	770.38	14.82
DBWR Fusion writes:	5.49	0.11
Estd Interconnect traffic (KB)	2,483.62

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

Buffer access - local cache %: 97.90

Buffer access - remote cache %: 0.11

Buffer access - disk %: 1.99

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 87.1

Avg global cache cr block receive time (ms): 7.0

Avg global cache current block receive time (ms): 3.0

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 %: 13.0

Avg global cache cr block flush time (ms): 4.0

Avg global cache current block pin time (ms): 0.1

Avg global cache current block send time (ms): 0.0

Global cache log flushes for current blocks served %: 0.7

Avg global cache current block flush time (ms): 9.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.3

Avg message sent queue time on ksxp (ms): 7.1

Avg message received queue time (ms): 0.2

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 40.80

% of indirect sent messages: 58.86

% of flow controlled messages: 0.34

Cluster Interconnect

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

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
en9	169.254.131.102	N

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): 286563.4s
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

Statistic Name	Time (s)	% of DB Time
parse time elapsed	242,484.63	84.62
hard parse elapsed time	168,858.99	58.93
sql execute elapsed time	49,755.47	17.36
PL/SQL compilation elapsed time	12,318.86	4.30
DB CPU	9,195.80	3.21
failed parse elapsed time	3,802.18	1.33
hard parse (sharing criteria) elapsed time	3,372.00	1.18
hard parse (bind mismatch) elapsed time	3,335.37	1.16
sequence load elapsed time	1,296.52	0.45
PL/SQL execution elapsed time	1,048.14	0.37
connection management call elapsed time	18.82	0.01
repeated bind elapsed time	0.24	0.00
DB time	286,563.44
background elapsed time	2,339.74
background cpu time	429.05

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

Statistic	Value	End Value
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	68,006
AVG_IDLE_TIME	298,157
AVG_IOWAIT_TIME	19,460
AVG_SYS_TIME	14,283
AVG_USER_TIME	53,609
BUSY_TIME	1,634,985
IDLE_TIME	7,158,549
IOWAIT_TIME	469,872
SYS_TIME	345,557
USER_TIME	1,289,428
LOAD	4	5
OS_CPU_WAIT_TIME	2,180,600
RSRC_MGR_CPU_WAIT_TIME	471,533
VM_IN_BYTES	1,009,983,504
VM_OUT_BYTES	4,372,574,208
PHYSICAL_MEMORY_BYTES	51,808,043,008
NUM_CPUS	24
NUM_CPU_CORES	12
GLOBAL_RECEIVE_SIZE_MAX	1,310,720
GLOBAL_SEND_SIZE_MAX	1,310,720
TCP_RECEIVE_SIZE_DEFAULT	16,384
TCP_RECEIVE_SIZE_MAX	9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	9,223,372,036,854,775,807
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
07-8月 22:00:05	4.47
07-8月 23:00:14	5.38	18.59	14.66	3.93	81.41	5.34

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 96.2% of Total DB time 286,563.44 (s)
Total FG Wait Time: 266,362.14 (s) DB CPU time: 9,195.80 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Concurrency	65,593	0	244,552	3728	85.34
DB CPU			9,196		3.21
User I/O	1,148,046	0	7,202	6	2.51
Scheduler	64,336	0	4,831	75	1.69
Cluster	699,082	0	4,222	6	1.47
Application	68,229	0	1,639	24	0.57
Configuration	387	1	1,246	3220	0.43
Commit	83,656	0	1,223	15	0.43
Other	90,169	70	1,055	12	0.37
Network	5,048,896	0	347	0	0.12
System I/O	21,477	0	45	2	0.02

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
library cache lock	8,244	1	181,704	22041	0.04	63.41
cursor: pin S wait on X	380	0	61,008	160548	0.00	21.29
resmgr:cpu quantum	64,336	0	4,831	75	0.34	1.69
db file sequential read	744,281	0	4,113	6	3.97	1.44
db file scattered read	354,655	0	2,349	7	1.89	0.82
enq: TX - row lock contention	381	0	1,619	4249	0.00	0.56
buffer busy waits	1,798	0	1,412	785	0.01	0.49
enq: SQ - contention	290	0	1,246	4296	0.00	0.43
log file sync	83,656	0	1,223	15	0.45	0.43
gc buffer busy acquire	50,887	1	941	18	0.27	0.33
DFS lock handle	6,524	6	627	96	0.03	0.22
gc current grant busy	47,179	0	609	13	0.25	0.21
gc cr block busy	19,946	0	537	27	0.11	0.19
direct path read	13,305	0	457	34	0.07	0.16
gc current block congested	408	0	365	895	0.00	0.13
enq: US - contention	110	0	327	2977	0.00	0.11
gc cr block congested	359	0	298	830	0.00	0.10
gc current block 2-way	242,098	0	264	1	1.29	0.09
gc current block busy	2,195	0	231	105	0.01	0.08
SQL*Net more data from client	6,922	0	210	30	0.04	0.07
gc cr block 2-way	138,312	0	205	1	0.74	0.07
gc cr multi block request	35,731	0	200	6	0.19	0.07
gc current grant congested	75	0	162	2161	0.00	0.06
row cache lock	16,890	0	154	9	0.09	0.05
SQL*Net message to client	5,033,319	0	137	0	26.82	0.05
gc cr grant congested	128	0	125	978	0.00	0.04
read by other session	17,662	0	120	7	0.09	0.04
library cache pin	8,706	1	110	13	0.05	0.04
gc cr grant 2-way	107,868	0	109	1	0.57	0.04
gc buffer busy release	577	0	106	184	0.00	0.04
db file parallel read	5,410	0	101	19	0.03	0.04
library cache: mutex X	15,816	0	96	6	0.08	0.03
Disk file operations I/O	10,462	0	59	6	0.06	0.02
name-service call wait	108	82	49	451	0.00	0.02
control file sequential read	21,447	0	45	2	0.11	0.02
gc current grant 2-way	12,384	0	44	4	0.07	0.02
library cache load lock	127	0	26	208	0.00	0.01
enq: TX - index contention	362	0	24	67	0.00	0.01
gc cr disk read	40,755	0	24	1	0.22	0.01
SQL*Net break/reset to client	67,656	0	19	0	0.36	0.01
ASM file metadata operation	151	0	17	113	0.00	0.01
latch: shared pool	1,840	0	13	7	0.01	0.00
buffer exterminate	652	99	7	10	0.00	0.00
reliable message	4,557	0	7	1	0.02	0.00
enq: PS - contention	963	10	4	4	0.01	0.00
PX Deq: Signal ACK RSG	1,625	0	3	2	0.01	0.00
latch: ges resource hash list	129	0	3	23	0.00	0.00
PX Deq: Slave Session Stats	2,475	0	2	1	0.01	0.00
os thread startup	12	0	2	163	0.00	0.00
latch: row cache objects	496	0	2	4	0.00	0.00
direct path write temp	86	0	2	19	0.00	0.00
enq: TX - contention	230	100	2	7	0.00	0.00
rdbms ipc reply	1,020	0	1	1	0.01	0.00
latch: cache buffers chains	10,895	0	1	0	0.06	0.00
PX Deq: reap credit	44,820	100	1	0	0.24	0.00
asynch descriptor resize	15,566	100	1	0	0.08	0.00
gc current split	28	0	1	32	0.00	0.00
direct path write	146	0	1	6	0.00	0.00
latch free	2,882	0	1	0	0.02	0.00
direct path read temp	24	0	1	30	0.00	0.00
IPC send completion sync	984	0	0	0	0.01	0.00
enq: KO - fast object checkpoint	135	0	0	3	0.00	0.00
cr request retry	45	100	0	10	0.00	0.00
buffer deadlock	638	100	0	1	0.00	0.00
external table read	212	0	0	2	0.00	0.00
enq: TM - contention	24	29	0	18	0.00	0.00
enq: WF - contention	7	0	0	59	0.00	0.00
gc cr block lost	1	0	0	409	0.00	0.00
latch: object queue header operation	123	0	0	3	0.00	0.00
PX Deq: Signal ACK EXT	1,625	0	0	0	0.01	0.00
latch: gcs resource hash	14	0	0	23	0.00	0.00
resmgr:internal state change	3	100	0	100	0.00	0.00
SQL*Net more data to client	8,655	0	0	0	0.05	0.00
CSS initialization	8	0	0	21	0.00	0.00
enq: RO - fast object reuse	33	0	0	5	0.00	0.00
enq: FB - contention	83	0	0	2	0.00	0.00
gc current multi block request	102	0	0	2	0.00	0.00
KJC: Wait for msg sends to complete	3,609	0	0	0	0.02	0.00
log file switch completion	2	0	0	72	0.00	0.00
enq: HW - contention	64	0	0	1	0.00	0.00
enq: TT - contention	79	0	0	1	0.00	0.00
latch: enqueue hash chains	143	0	0	0	0.00	0.00
enq: JQ - contention	1	100	0	52	0.00	0.00
CSS operation: action	9	0	0	5	0.00	0.00
control file parallel write	30	0	0	2	0.00	0.00
undo segment extension	5	100	0	8	0.00	0.00
enq: TO - contention	55	62	0	1	0.00	0.00
latch: cache buffers lru chain	60	0	0	1	0.00	0.00
gc cr failure	47	0	0	1	0.00	0.00
enq: TX - allocate ITL entry	26	0	0	1	0.00	0.00
enq: CR - block range reuse ckpt	7	0	0	3	0.00	0.00
enq: OD - Serializing DDLs	16	100	0	1	0.00	0.00
latch: gc element	185	0	0	0	0.00	0.00
utl_file I/O	1,775	0	0	0	0.01	0.00
enq: MD - contention	23	0	0	1	0.00	0.00
CSS operation: query	24	0	0	0	0.00	0.00
enq: SK - contention	19	100	0	1	0.00	0.00
ges inquiry response	12	0	0	1	0.00	0.00
enq: PI - contention	8	100	0	1	0.00	0.00
wait list latch free	1	0	0	6	0.00	0.00
latch: call allocation	5	0	0	1	0.00	0.00
latch: undo global data	4	0	0	1	0.00	0.00
cursor: pin S	22	0	0	0	0.00	0.00
global enqueue expand wait	7	0	0	1	0.00	0.00
PX qref latch	537	100	0	0	0.00	0.00
enq: AF - task serialization	2	0	0	1	0.00	0.00
enq: CF - contention	4	0	0	1	0.00	0.00
enq: TS - contention	4	0	0	0	0.00	0.00
lock deadlock retry	13	100	0	0	0.00	0.00
latch: session allocation	1	0	0	1	0.00	0.00
gc current retry	2	0	0	1	0.00	0.00
SQL*Net message from client	5,033,058	0	11,035,739	2193	26.82
jobq slave wait	3,332	99	1,660	498	0.02
PX Deq: Execution Msg	3,400	0	643	189	0.02
PX Deq: Parse Reply	1,625	0	288	177	0.01
PX Deq: Execute Reply	10,360	0	189	18	0.06
auto-sqltune: wait graph update	13	92	64	4894	0.00
PX Deq: Join ACK	1,625	0	19	11	0.01
PL/SQL lock timer	4	100	4	1000	0.00
PX Deq Credit: send blkd	785	0	1	1	0.00
KSV master wait	15	0	0	30	0.00
PX Deq Credit: need buffer	5	0	0	41	0.00
PX Deq: Msg Fragment	775	0	0	0	0.00

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	137,330	0	359	3	0.73	15.33
os thread startup	86	1	227	2634	0.00	9.68
db file parallel write	14,170	0	97	7	0.08	4.16
gcs log flush sync	35,349	7	80	2	0.19	3.40
gc current grant congested	3	0	71	23590	0.00	3.02
control file sequential read	14,733	0	68	5	0.08	2.93
gc current block busy	28	0	37	1332	0.00	1.59
enq: PV - syncstart	2	0	29	14561	0.00	1.24
reliable message	745	3	26	35	0.00	1.13
row cache lock	4,154	0	19	5	0.02	0.82
enq: CO - master slave det	1,132	100	19	17	0.01	0.81
process diagnostic dump	2,444	0	19	8	0.01	0.80
Streams AQ: qmn coordinator waiting for slave to start	4	75	17	4262	0.00	0.73
enq: TH - metric threshold evaluation	1	0	15	15265	0.00	0.65
db file sequential read	1,405	0	15	11	0.01	0.63
control file parallel write	4,996	0	14	3	0.03	0.59
gc cr grant congested	13	0	12	921	0.00	0.51
enq: PR - contention	2	0	11	5471	0.00	0.47
enq: CF - contention	348	100	9	25	0.00	0.37
gc current block congested	26	0	7	255	0.00	0.28
log file sequential read	193	0	6	30	0.00	0.25
library cache lock	560	22	3	6	0.00	0.15
gc current block 2-way	1,001	0	3	3	0.01	0.14
buffer busy waits	63	0	3	40	0.00	0.11
latch free	334	0	2	7	0.00	0.11
enq: TD - KTF dump entries	11	0	2	211	0.00	0.10
gc cr grant 2-way	354	0	2	6	0.00	0.09
ges lms sync during dynamic remastering and reconfig	72	78	2	30	0.00	0.09
row cache process	51,720	0	2	0	0.28	0.08
ASM file metadata operation	949	0	2	2	0.01	0.07
row cache cleanup	89,459	0	2	0	0.48	0.07
DFS lock handle	2,296	70	1	1	0.01	0.06
wait for scn ack	6	0	1	201	0.00	0.05
ADR block file write	24	0	1	40	0.00	0.04
LGWR wait for redo copy	1,696	0	1	1	0.01	0.04
gc current grant busy	105	0	1	6	0.00	0.03
ksxr poll remote instances	61,535	100	1	0	0.33	0.03
kjbdrmcvtq lmon drm quiesce: ping completion	3	67	1	196	0.00	0.03
CSS initialization	4	0	1	139	0.00	0.02
gc cr multi block request	43	0	1	12	0.00	0.02
CGS wait for IPC msg	30,365	100	0	0	0.16	0.02
latch: shared pool	57	0	0	8	0.00	0.02
gc current grant 2-way	355	0	0	1	0.00	0.02
gc cr block 2-way	259	0	0	2	0.00	0.02
name-service call wait	8	0	0	47	0.00	0.02
ADR block file read	69	0	0	5	0.00	0.01
library cache pin	655	0	0	1	0.00	0.01
Parameter File I/O	96	0	0	3	0.00	0.01
latch: cache buffers chains	73	0	0	4	0.00	0.01
libcache interrupt action by LCK	64,797	0	0	0	0.35	0.01
Log archive I/O	6	0	0	48	0.00	0.01
gc cr block busy	10	0	0	27	0.00	0.01
direct path write	9	0	0	26	0.00	0.01
resmgr:internal state change	2	100	0	104	0.00	0.01
enq: KO - fast object checkpoint	367	0	0	1	0.00	0.01
ges inquiry response	216	0	0	1	0.00	0.01
latch: ges resource hash list	547	0	0	0	0.00	0.01
latch: row cache objects	28	0	0	6	0.00	0.01
SQL*Net break/reset to client	370	0	0	0	0.00	0.01
ges LMON to get to FTDONE	6	100	0	21	0.00	0.01
latch: gc element	141	0	0	1	0.00	0.01
ADR file lock	28	14	0	4	0.00	0.00
gc cr block congested	2	0	0	57	0.00	0.00
enq: DR - contention	2	0	0	51	0.00	0.00
PX Deq: reap credit	6,696	100	0	0	0.04	0.00
Disk file operations I/O	368	0	0	0	0.00	0.00
latch: object queue header operation	466	0	0	0	0.00	0.00
SGA: allocation forcing component growth	1	0	0	59	0.00	0.00
log file sync	3	0	0	16	0.00	0.00
IPC send completion sync	15	0	0	3	0.00	0.00
CSS operation: action	16	0	0	3	0.00	0.00
CSS operation: data query	2	0	0	20	0.00	0.00
enq: TT - contention	62	58	0	1	0.00	0.00
ksdxexeotherwait	1	0	0	38	0.00	0.00
latch: messages	3	0	0	12	0.00	0.00
ges generic event	2	100	0	14	0.00	0.00
latch: gcs resource hash	21	0	0	1	0.00	0.00
enq: TX - index contention	1	0	0	26	0.00	0.00
latch: cache buffers lru chain	44	0	0	1	0.00	0.00
enq: PS - contention	21	43	0	1	0.00	0.00
rdbms ipc reply	77	0	0	0	0.00	0.00
gc buffer busy release	5	0	0	3	0.00	0.00
buffer deadlock	1	100	0	16	0.00	0.00
db file scattered read	1	0	0	16	0.00	0.00
enq: TM - contention	11	73	0	1	0.00	0.00
enq: PE - contention	6	100	0	1	0.00	0.00
enq: WF - contention	15	0	0	1	0.00	0.00
gc current multi block request	11	0	0	1	0.00	0.00
enq: PG - contention	6	100	0	1	0.00	0.00
enq: CR - block range reuse ckpt	14	0	0	1	0.00	0.00
kfk: async disk IO	3	0	0	2	0.00	0.00
db file parallel read	1	0	0	7	0.00	0.00
enq: US - contention	7	0	0	1	0.00	0.00
SQL*Net message to client	4,556	0	0	0	0.02	0.00
latch: enqueue hash chains	2	0	0	2	0.00	0.00
asynch descriptor resize	2,113	100	0	0	0.01	0.00
enq: TK - Auto Task Serialization	6	100	0	1	0.00	0.00
PX Deq: Signal ACK RSG	18	0	0	0	0.00	0.00
enq: RO - fast object reuse	10	0	0	0	0.00	0.00
CSS operation: query	12	0	0	0	0.00	0.00
enq: TA - contention	5	0	0	1	0.00	0.00
gc current split	2	0	0	2	0.00	0.00
SQL*Net more data from client	22	0	0	0	0.00	0.00
PX Deq: Slave Session Stats	18	0	0	0	0.00	0.00
library cache: mutex X	5	0	0	1	0.00	0.00
log file single write	2	0	0	1	0.00	0.00
gc current retry	1	0	0	2	0.00	0.00
enq: FB - contention	5	0	0	0	0.00	0.00
enq: HW - contention	4	0	0	1	0.00	0.00
latch: redo allocation	10	0	0	0	0.00	0.00
enq: AF - task serialization	2	0	0	1	0.00	0.00
enq: MW - contention	2	0	0	1	0.00	0.00
rdbms ipc message	337,842	23	88,252	261	1.80
PX Idle Wait	858	0	12,999	15150	0.00
class slave wait	92	0	9,638	104759	0.00
wait for unread message on broadcast channel	7,219	100	7,216	1000	0.04
DIAG idle wait	207,426	92	6,931	33	1.11
gcs remote message	1,210,653	34	6,851	6	6.45
Space Manager: slave idle wait	1,142	96	5,553	4862	0.01
Streams AQ: qmn slave idle wait	205	2	4,968	24235	0.00
ASM background timer	778	0	3,609	4639	0.00
shared server idle wait	120	100	3,600	30001	0.00
dispatcher timer	60	100	3,600	60002	0.00
pmon timer	1,466	75	3,594	2451	0.01
ges remote message	396,109	73	3,593	9	2.11
PING	1,367	21	3,585	2623	0.01
GCR sleep	710	100	3,551	5001	0.00
Streams AQ: qmn coordinator idle wait	291	42	3,539	12161	0.00
smon timer	752	0	3,520	4681	0.00
SGA: MMAN sleep for component shrink	30,968	100	315	10	0.17
SQL*Net message from client	6,188	0	9	1	0.03
KSV master wait	2,134	99	1	0	0.01
PX Deq: Parse Reply	18	0	0	6	0.00
PX Deq: Join ACK	18	0	0	3	0.00
PX Deq: Execute Reply	18	0	0	1	0.00
Streams AQ: RAC qmn coordinator idle wait	300	100	0	0	0.00

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)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	69	40.6	1.4	14.5	21.7	18.8	2.9
ADR block file write	24			12.5	8.3	29.2	20.8	29.2
ADR file lock	28	89.3					3.6	7.1
ARCH wait for archivelog lock	1	100.0
ASM file metadata operation	1099	84.8	.4	.4	.2			14.3
CGS wait for IPC msg	30.4K	99.9	.0	.0	.0	.0	.0
CSS initialization	12	50.0						50.0
CSS operation: action	25	24.0	20.0		52.0	4.0
CSS operation: data query	2						100.0
CSS operation: query	36	83.3	2.8	13.9
DFS lock handle	8891	71.0	22.0	3.5	.9	.5	.5	.8	.9
Disk file operations I/O	10.8K	93.1	4.6	1.3	.1	.0	.0	.8	.1
IPC send completion sync	996	96.2	2.5	.3	.5	.2	.1	.2
KJC: Wait for msg sends to complete	3747	99.8	.1		.0	.0	.1	.0
LGWR wait for redo copy	1698	94.5	1.2	1.5	1.3	.8	.5	.2
Log archive I/O	6	33.3				16.7		50.0
PX Deq: Signal ACK EXT	1638	96.5	1.2	1.6	.3	.2	.1
PX Deq: Signal ACK RSG	1638	90.4	2.3	1.5	.9	.5	4.0	.3
PX Deq: Slave Session Stats	2486	91.4	5.3	1.7	.8	.4	.1	.2
PX Deq: reap credit	51.4K	100.0	.0	.0	.0			.0
PX qref latch	537	100.0
Parameter File I/O	96	36.5		43.8	11.5	7.3	1.0
SGA: allocation forcing component growth	1							100.0
SQL*Net break/reset to client	68K	98.5	1.1	.2	.1	.0	.0	.0
SQL*Net message to client	5038.1K	100.0	.0	.0	.0	.0	.0	.0	.0
SQL*Net more data from client	6968	78.1	.2	.2	.3	.4	1.0	19.8
SQL*Net more data to client	7243	100.0
Streams AQ: qmn coordinator waiting for slave to start	4	25.0							75.0
asynch descriptor resize	17.7K	99.9	.0	.0	.0	.0	.0	.0
buffer busy waits	1860	45.8	4.3	7.2	2.8	2.6	4.1	19.3	13.9
buffer deadlock	639	93.7	2.2	2.0	1.3	.3	.2	.3
buffer exterminate	652			.3	.3	98.9	.5
control file parallel write	5026	.3	75.9	13.0	6.5	3.0	.6	.7
control file sequential read	36.2K	53.5	31.1	4.7	4.5	3.5	1.4	1.4
cr request retry	45					100.0
cursor: mutex S	2	100.0
cursor: pin S	22	90.9	9.1
cursor: pin S wait on X	380					29.2	.5	9.5	60.8
db file parallel read	5409	5.5	17.6	7.6	8.0	19.6	25.2	16.5
db file parallel write	14.2K	3.6	48.0	18.0	12.1	11.3	3.7	3.3
db file scattered read	354.4K	15.2	49.4	8.5	3.9	11.8	7.1	4.0
db file sequential read	746.1K	43.0	23.5	4.2	5.9	14.9	6.8	1.8	.0
direct path read	13.3K	.1	.2	.3	.4	23.0	45.0	31.0
direct path read temp	24			8.3	8.3	20.8	20.8	41.7
direct path write	155	4.5	25.8	15.5	45.2	2.6	2.6	3.9
direct path write temp	86	3.5	12.8	10.5	24.4	15.1	16.3	17.4
enq: AF - task serialization	4	75.0	25.0
enq: CF - contention	352	85.8	8.5	2.6	1.1		.3	1.1	.6
enq: CO - master slave det	1132	85.6	9.3	3.1	1.0	.4		.4	.3
enq: CR - block range reuse ckpt	22	68.2	4.5	22.7	4.5
enq: DR - contention	2	50.0						50.0
enq: FB - contention	88	78.4	11.4	2.3	4.5	2.3		1.1
enq: HW - contention	68	77.9	10.3	2.9	4.4	4.4
enq: JQ - contention	1							100.0
enq: KO - fast object checkpoint	502	91.8	4.0	1.4	.4	.8	1.0	.6
enq: MD - contention	23	91.3	4.3	4.3
enq: MW - contention	2	100.0
enq: OD - Serializing DDLs	16	75.0	12.5	6.3		6.3
enq: PE - contention	6	66.7	16.7		16.7
enq: PG - contention	6	83.3			16.7
enq: PI - contention	8	62.5	25.0	12.5
enq: PR - contention	2								100.0
enq: PS - contention	980	69.4	24.5	3.5	1.6	.4	.3	.2	.1
enq: PV - syncstart	2								100.0
enq: RO - fast object reuse	43	60.5	4.7	4.7	20.9	7.0		2.3
enq: SK - contention	19	94.7	5.3
enq: SQ - contention	290	6.2	4.1	4.5	3.4	2.4	6.9	20.3	52.1
enq: TA - contention	5	80.0	20.0
enq: TD - KTF dump entries	11	81.8		9.1					9.1
enq: TH - metric threshold evaluation	1								100.0
enq: TK - Auto Task Serialization	6	83.3	16.7
enq: TM - contention	34	94.1			2.9	2.9
enq: TO - contention	55	92.7	3.6	1.8	1.8
enq: TS - contention	4	100.0
enq: TT - contention	141	87.9	8.5	1.4	.7	1.4
enq: TX - allocate ITL entry	26	84.6	11.5		3.8
enq: TX - contention	230	81.7	7.8	3.9	1.7	3.5		1.3
enq: TX - index contention	364	36.3	3.6	2.7	5.8	6.3	9.6	35.7
enq: TX - row lock contention	381	44.1	14.4	8.1	8.7	7.3	4.7	8.7	3.9
enq: US - contention	118	24.6	3.4	1.7		2.5	3.4	31.4	33.1
enq: WF - contention	22	90.9	4.5					4.5
external table open	14	100.0
external table read	212	91.5	7.5					.9
external table seek	14	100.0
gc buffer busy acquire	50.9K	35.2	38.2	10.7	3.7	5.4	2.7	4.0	.1
gc buffer busy release	583	15.4	16.5	8.7	8.4	11.7	6.0	31.7	1.5
gc cr block 2-way	138.6K	94.8	3.2	.8	.4	.3	.2	.2	.0
gc cr block busy	19.9K	.7	49.3	31.1	9.1	5.6	2.1	2.1	.1
gc cr block congested	361	35.7	2.5	3.3	5.3	5.0	5.0	33.8	9.4
gc cr block lost	1							100.0
gc cr disk read	40.8K	96.3	2.5	.6	.3	.1	.1	.1	.0
gc cr failure	47	91.5	2.1	4.3	2.1
gc cr grant 2-way	107.7K	96.2	2.6	.7	.3	.1	.1	.1	.0
gc cr grant congested	141	65.2	5.0	2.1	3.5	5.7	2.1	12.1	4.3
gc cr multi block request	35.5K	55.4	32.6	4.6	6.2	1.0	.2	.1	.0
gc current block 2-way	243.2K	95.5	3.0	.8	.3	.2	.1	.2	.0
gc current block busy	2225	17.0	24.9	19.5	12.7	12.5	6.4	6.3	.6
gc current block congested	435	46.7	.9	2.8	3.2	3.4	1.8	29.4	11.7
gc current grant 2-way	12.8K	95.7	2.3	.7	.3	.2	.2	.4	.1
gc current grant busy	47.3K	92.6	4.7	1.0	.4	.4	.2	.6	.1
gc current grant congested	78	12.8	2.6	1.3	2.6	2.6	2.6	52.6	23.1
gc current multi block request	112	81.3	12.5		2.7	1.8	1.8
gc current retry	3	66.7		33.3
gc current split	30	73.3	10.0	3.3	6.7			6.7
gc object scan	3	100.0
gcs log flush sync	35.3K	37.7	38.5	8.7	7.2	7.5	.4	.0
ges LMON to get to FTDONE	6						100.0
ges generic event	2					50.0	50.0
ges inquiry response	228	80.3	15.4	3.1	1.3
ges lms sync during dynamic remastering and reconfig	72			1.4	18.1	5.6	25.0	50.0
global enqueue expand wait	7	100.0
kfk: async disk IO	3	33.3	33.3		33.3
kjbdrmcvtq lmon drm quiesce: ping completion	3							100.0
ksdxexeotherwait	1							100.0
ksxr poll remote instances	60.3K	100.0	.0
latch free	3213	91.1	4.9	1.4	1.2	.8	.2	.4
latch: cache buffers chains	11K	99.1	.3	.3	.1	.1	.0	.0
latch: cache buffers lru chain	104	90.4	3.8	1.9	2.9	1.0
latch: call allocation	13	92.3			7.7
latch: checkpoint queue latch	1	100.0
latch: enqueue hash chains	145	92.4	3.4	1.4	2.8
latch: gc element	323	97.2	.9	.3	.9		.3	.3
latch: gcs resource hash	35	82.9			8.6	5.7		2.9
latch: ges resource hash list	688	89.8	1.9	1.5	2.6	2.2	.9	1.2
latch: messages	3	66.7						33.3
latch: object queue header operation	589	98.5	.2	.3	.8			.2
latch: redo allocation	10	90.0	10.0
latch: row cache objects	522	71.5	5.2	3.4	4.6	5.9	7.9	1.5
latch: session allocation	1		100.0
latch: shared pool	1858	78.3	7.2	5.9	2.9	1.8	1.3	2.6
latch: undo global data	4	50.0	25.0	25.0
libcache interrupt action by LCK	63.6K	100.0		.0	.0
library cache load lock	127	3.9	5.5	1.6	1.6	13.4	1.6	72.4
library cache lock	8767	81.9	5.7	2.0	1.1	.6	.3	1.5	6.8
library cache pin	9318	92.6	4.1	1.1	.8	.4	.2	.8	.1
library cache: mutex X	15.8K	62.8	3.1	3.7	6.8	9.4	10.0	4.2
lock deadlock retry	14	100.0
lock escalate retry	2	100.0
log file parallel write	137.3K	45.0	36.6	5.5	7.0	4.1	1.3	.6
log file sequential read	193	3.1	.5		.5	16.1	63.2	16.6
log file single write	2	50.0	50.0
log file switch completion	2					50.0		50.0
log file sync	83.7K	22.7	45.1	12.3	8.9	6.1	2.5	2.4	.0
name-service call wait	116			.9		.9	.9	97.4
os thread startup	98							91.8	8.2
process diagnostic dump	2444	10.9	.1	71.9	16.3	.5	.1	.2	.0
rdbms ipc reply	1089	60.6	27.5	9.4	.9	.9	.2	.5
read by other session	17.7K	22.8	40.0	12.1	5.8	12.0	5.3	1.8	.0
reliable message	5311	92.2	3.9	2.0	.6	.2	.2	.9
resmgr:cpu quantum	64.3K	8.8	6.6	8.3	8.9	7.4	10.3	49.6	.1
resmgr:internal state change	5							100.0
row cache cleanup	87.6K	100.0	.0	.0	.0	.0	.0	.0
row cache lock	20.3K	88.6	7.4	1.7	1.0	.5	.2	.4	.2
row cache process	50.5K	100.0	.0	.0	.0	.0	.0	.0
undo segment extension	11	27.3				27.3	18.2	27.3
utl_file I/O	381	99.5	.3		.3
wait for scn ack	6				16.7			83.3
wait list latch free	1				100.0
ASM background timer	778	1.3	.1					4.6	94.0
DIAG idle wait	207.5K	5.0	.4	.5	13.0	47.9	14.2	19.0	.0
GCR sleep	710								100.0
KSV master wait	2149	99.5	.1	.1	.0			.2
PING	1367	77.7	.9	.4	.1	.1		.1	20.6
PL/SQL lock timer	4							100.0
PX Deq Credit: need buffer	5	60.0	20.0					20.0
PX Deq Credit: send blkd	785	92.6	4.6	1.3	.3	.6		.6
PX Deq: Execute Reply	10.4K	15.4	5.2	8.1	16.3	38.7	10.6	5.8	.0
PX Deq: Execution Msg	3392	42.5	27.3	11.2	5.1	3.8	3.3	4.6	2.2
PX Deq: Join ACK	1638	25.3	47.4	17.0	5.6	2.3	1.1	1.0	.2
PX Deq: Msg Fragment	775	99.5	.4			.1
PX Deq: Parse Reply	1638	31.1	38.3	14.7	3.1	2.3	2.3	7.0	1.2
PX Idle Wait	848	15.9	26.3	14.2	4.6	1.8	1.1	7.0	29.2
SGA: MMAN sleep for component shrink	31K	.0	.0	.0	.0	99.5	.3	.1
SQL*Net message from client	5039.5K	83.0	6.7	1.5	.7	.7	.8	5.2	1.4
Space Manager: slave idle wait	1145	.2		.1				1.5	98.3
Streams AQ: RAC qmn coordinator idle wait	300	100.0
Streams AQ: qmn coordinator idle wait	291	55.3	1.7	1.0				.3	41.6
Streams AQ: qmn slave idle wait	205	14.1							85.9
auto-sqltune: wait graph update	13								100.0
class slave wait	92	54.3	6.5	2.2	6.5	6.5	1.1	7.6	15.2
dispatcher timer	60								100.0
gcs remote message	1210.5K	26.0	11.1	12.5	13.0	33.8	3.6	.0	.0
ges remote message	396.1K	84.7	2.2	1.5	1.2	1.0	1.0	8.4	.0
jobq slave wait	3343							100.0
pmon timer	1467	6.5			.1	.2	.3	8.9	84.0
rdbms ipc message	336.8K	37.0	5.0	5.4	8.8	6.6	4.4	27.8	4.9
shared server idle wait	120								100.0
smon timer	754	2.3	.1					2.9	94.7
wait for unread message on broadcast channel	7219					.0		99.9	.0

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)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ADR block file write	7	70.8	12.5	12.5		4.2
ADR file lock	2	92.9	7.1
ASM file metadata operation	157	85.7		12.2	1.7	.2	.2
CSS initialization	6	50.0	41.7			8.3
DFS lock handle	71	98.4	.1	.1	.0		.6	.0	.8
Disk file operations I/O	97	99.1	.0	.1	.1	.2	.4	.1
IPC send completion sync	2	99.8	.2
KJC: Wait for msg sends to complete	1	100.0	.0
LGWR wait for redo copy	3	99.8	.1	.1
Log archive I/O	3	50.0	16.7	16.7	16.7
PX Deq: Signal ACK RSG	5	99.7	.1	.1		.1	.1
PX Deq: Slave Session Stats	6	99.8	.0	.2		.0
PX Deq: reap credit	2	100.0	.0			.0
SGA: allocation forcing component growth	1		100.0
SQL*Net break/reset to client	14	100.0	.0	.0	.0
SQL*Net message to client	19	100.0	.0	.0	.0		.0		.0
SQL*Net more data from client	1383	80.2	1.9	3.9	14.1
asynch descriptor resize	1	100.0					.0
buffer busy waits	452	66.8	4.4	3.4	.9	1.2	9.5	5.0	8.9
buffer deadlock	2	99.7		.2	.2
control file parallel write	35	99.3	.5	.1	.1
control file sequential read	519	98.6	.7	.6	.1	.0	.0
cursor: pin S wait on X	45	29.7	1.1	.3	1.3	1.3	5.5	2.4	58.4
db file parallel read	892	83.5	13.5	2.2	.6	.1	.0
db file parallel write	471	96.7	1.9	.8	.5	.0	.0
db file scattered read	14.3K	96.0	3.2	.6	.2	.0	.0
db file sequential read	13.3K	98.2	1.4	.3	.1	.0	.0	.0
direct path read	4129	69.0	22.6	5.2	2.9	.4	.0
direct path read temp	10	58.3	29.2	12.5
direct path write	6	96.1	2.6	.6	.6
direct path write temp	15	82.6	11.6	4.7	1.2
enq: CF - contention	4	98.3				.9	.3		.6
enq: CO - master slave det	4	99.4	.1		.1	.2			.3
enq: DR - contention	1	50.0		50.0
enq: FB - contention	1	98.9	1.1
enq: JQ - contention	1		100.0
enq: KO - fast object checkpoint	3	99.4	.2	.4
enq: PS - contention	2	99.7		.1	.1				.1
enq: RO - fast object reuse	1	97.7	2.3
enq: SQ - contention	67	27.6	6.6	4.1	3.8	4.1	1.7	2.8	49.3
enq: TX - contention	3	98.7				1.3
enq: TX - index contention	130	64.3	7.7	9.9	6.9	11.0	.3
enq: TX - row lock contention	34	87.4	2.1	3.4	1.6	1.3	.3	.3	3.7
enq: US - contention	39	35.6	2.5	.8	.8		27.1	1.7	31.4
enq: WF - contention	1	95.5				4.5
external table read	2	99.1			.9
gc buffer busy acquire	2054	95.9	.9	1.8	.3	.3	.7	.0	.0
gc buffer busy release	193	66.7	6.9	3.8	3.4	5.0	12.7	1.4	.2
gc cr block 2-way	353	99.7	.1	.1	.0	.0	.0	.0	.0
gc cr block busy	421	97.8	1.0	.6	.3	.1	.1	.0	.1
gc cr block congested	136	56.8	3.0	8.0	7.2	8.3	7.2	3.9	5.5
gc cr block lost	1					100.0
gc cr disk read	24	99.9	.0	.0	.0	.0			.0
gc cr grant 2-way	156	99.8	.0	.0	.0	.0	.0	.0	.0
gc cr grant congested	18	83.7	2.8	3.5	2.8	2.8		.7	3.5
gc cr multi block request	33	99.9	.1	.0	.0	.0			.0
gc current block 2-way	429	99.8	.1	.0	.0	.0	.0	.0	.0
gc current block busy	148	93.0	3.4	1.3	.9	.5	.3	.3	.3
gc current block congested	154	58.9	2.5	5.1	7.6	6.9	7.4	6.0	5.7
gc current grant 2-way	63	99.5	.1	.1	.1	.1	.1	.0	.0
gc current grant busy	328	99.3	.2	.1	.1	.2	.1	.1	.1
gc current grant congested	51	24.4	10.3	7.7	10.3	12.8	11.5	12.8	10.3
gc current split	2	93.3	3.3				3.3
gcs log flush sync	11	100.0	.0	.0	.0		.0
ges lms sync during dynamic remastering and reconfig	36	50.0	48.6	1.4
kjbdrmcvtq lmon drm quiesce: ping completion	3				100.0
ksdxexeotherwait	1		100.0
latch free	12	99.6	.2	.1	.0		.1
latch: cache buffers chains	5	100.0	.0	.0		.0
latch: gc element	1	99.7		.3
latch: gcs resource hash	1	97.1				2.9
latch: ges resource hash list	8	98.8	.3	.1		.4	.3
latch: messages	1	66.7	33.3
latch: object queue header operation	1	99.8				.2
latch: row cache objects	8	98.5	1.5
latch: shared pool	49	97.4	.9	.5	.5	.4	.4
library cache load lock	92	27.6	6.3	11.0	10.2	44.9
library cache lock	157	91.6	.3	.2	.1	.7	.2	.3	6.6
library cache pin	76	99.1	.4	.0	.0	.0	.3		.1
library cache: mutex X	657	95.8	3.7	.4	.0	.0	.0
log file parallel write	823	99.4	.4	.1	.1	.0	.0
log file sequential read	32	83.4	6.2	8.3	2.1
log file switch completion	1	50.0		50.0
log file sync	1972	97.6	1.1	.7	.4	.1	.1	.0	.0
name-service call wait	113	2.6	7.8	9.5	2.6	73.3	4.3
os thread startup	91			75.5	11.2	4.1	1.0	1.0	7.1
process diagnostic dump	4	99.8			.0	.0	.1		.0
rdbms ipc reply	5	99.5	.5
read by other session	333	98.1	1.2	.3	.2	.1	.1	.0
reliable message	50	99.1	.2	.1	.1	.1	.5
resmgr:cpu quantum	32K	50.3	17.3	16.4	8.9	5.6	1.3	.1	.0
resmgr:internal state change	5			100.0
row cache cleanup	5	100.0	.0		.0		.0
row cache lock	94	99.3	.1	.1	.0	.1	.1	.0	.2
row cache process	3	100.0		.0		.0
undo segment extension	3	72.7	9.1	9.1	9.1
wait for scn ack	5	16.7	33.3		16.7	33.3

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)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
DFS lock handle	74	99.2	.1	.4	.2	.0
SQL*Net message to client	6	100.0	.0				.0
Streams AQ: qmn coordinator waiting for slave to start	3	25.0		75.0
buffer busy waits	165	91.1	.9	7.3	.7
cursor: pin S wait on X	47	41.6	2.9	3.9	3.4	.5	.3	1.3	46.1
enq: CF - contention	2	99.4	.6
enq: CO - master slave det	3	99.7	.2		.1
enq: PR - contention	2		50.0	50.0
enq: PS - contention	1	99.9	.1
enq: PV - syncstart	2		50.0			50.0
enq: SQ - contention	143	50.7	4.8	22.1	22.4
enq: TD - KTF dump entries	1	90.9	9.1
enq: TH - metric threshold evaluation	1				100.0
enq: TX - row lock contention	10	96.3	.8	.3	1.3	.3			1.0
enq: US - contention	37	68.6	5.1	12.7	13.6
gc buffer busy acquire	24	100.0	.0	.0	.0	.0	.0
gc buffer busy release	1	99.8	.2
gc cr block 2-way	12	100.0	.0	.0
gc cr block busy	13	99.9	.0	.0	.0		.0	.0
gc cr block congested	20	94.5	1.1	1.7	1.4	1.4
gc cr disk read	1	100.0	.0
gc cr grant 2-way	8	100.0	.0
gc cr grant congested	5	96.5	.7		1.4	.7		.7
gc cr multi block request	3	100.0	.0				.0	.0
gc current block 2-way	7	100.0	.0
gc current block busy	7	99.7		.0	.0	.0	.2
gc current block congested	25	94.3	1.6	2.3	1.1	.5		.2
gc current grant 2-way	6	100.0	.0	.0
gc current grant busy	24	99.9	.0	.0	.0		.0	.0
gc current grant congested	8	89.7		6.4		1.3		2.6
library cache lock	188	93.4	.3	.8	.9	.0		.1	4.4
library cache pin	6	99.9		.0	.1
log file sync	12	100.0	.0		.0	.0	.0	.0
os thread startup	7	92.9	1.0	2.0	2.0		1.0	1.0
process diagnostic dump	1	100.0			.0
resmgr:cpu quantum	31	100.0	.0	.0
row cache lock	39	99.8	.2

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)

Event	Waits 4m to 1h	<2m	<4m	<8m	<1/4h
		% of Total Waits
cursor: pin S wait on X	175	53.9	23.9	18.2	3.9
enq: TX - row lock contention	4	99.0	.3	.8
library cache lock	388	95.6	.8	1.9	1.7

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
COREDB.	271,253	5,778	7,902	345,198
SYS$USERS	15,325	3,426	10,982	239,735
SYS$BACKGROUND	0	0	1	330
COREDBXDB	0	0	0	0

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
COREDB.	376275	3255	44056	243337	4994151	347
SYS$USERS	771731	3947	21722	1215	54902	0
SYS$BACKGROUND	1874	15	71035	253	0	0

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 19.7% of Total DB Time (s): 286,563
Captured PL/SQL account for 1.1% of Total DB Time (s): 286,563

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
4,914.25	210	23.40	1.71	0.15	0.00	95v76f5muyjjg	JDBC Thin Client	select originalorderno from or...
3,763.54	1,203	3.13	1.31	0.05	0.06	7ncnu7ud2ykhu	JDBC Thin Client	insert into ORDERS (domesticin...
3,333.34	6,868	0.49	1.16	0.14	0.00	9upvznnp7xgsj	JDBC Thin Client	SELECT BG.BANKGATEWAYNAME AS b...
3,194.68	1	3,194.68	1.11	67.23	15.33	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
3,158.50	14	225.61	1.10	0.01	0.00	fp1vatugjfuym	JDBC Thin Client	SELECT O.STATUS, P.TICKETNO FR...
2,649.89	5	529.98	0.92	0.16	0.00	9awmqbn8w5tkq	JDBC Thin Client	SELECT O.STATUS, P.TICKETNO FR...
2,573.07	328	7.84	0.90	80.20	3.42	9q7k9nbpvk8pv	DBMS_SCHEDULER	SELECT NVL(SUM(TIME_WAITED/100...
1,998.32	6	333.05	0.70	0.15	0.00	g3yjdvgd23b85	JDBC Thin Client	select p.orderno, o.bookUser f...
1,800.00	1,557	1.16	0.63	0.15	0.00	6wytwy7ry0jsb	JDBC Thin Client	UPDATE ORDERS SET TICKETOUTAGE...
1,742.44	2,100	0.83	0.61	0.05	0.00	7jk3kcjxvz83k	JDBC Thin Client	UPDATE PAYBILL SET PAYSTATUS =...

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 54.1% of Total CPU Time (s): 9,196
Captured PL/SQL account for 23.4% of Total CPU Time (s): 9,196

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,147.86	1	2,147.86	23.36	3,194.68	67.23	15.33	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
2,063.52	328	6.29	22.44	2,573.07	80.20	3.42	9q7k9nbpvk8pv	DBMS_SCHEDULER	SELECT NVL(SUM(TIME_WAITED/100...
490.55	1,495	0.33	5.33	643.87	76.19	0.58	0a1z1knkykfwz	JDBC Thin Client	select p.psgname, p.pnrno, (se...
489.05	292	1.67	5.32	621.37	78.70	2.75	bs6q10hmtbh49	JDBC Thin Client	select bs.billno, bs.bankflowi...
223.55	1,176	0.19	2.43	310.63	71.97	0.00	gyudauqxd8gqc	JDBC Thin Client	select ag.ORGAREA ORGAREA from...
195.79	116	1.69	2.13	281.73	69.50	0.00	dugh7uyrn80b4	JDBC Thin Client	select * from( select /*+ inde...
130.24	174	0.75	1.42	171.04	76.14	0.00	58z173u8h1kxc	JDBC Thin Client	select count(*) as recordscoun...
104.26	185	0.56	1.13	162.48	64.17	0.01	2ggs3r1ncmwwr	JDBC Thin Client	select count(*) as recordscoun...
80.09	216	0.37	0.87	106.61	75.12	0.00	25svbmrbjp20g	JDBC Thin Client	select g.airport from agentsal...
76.42	56	1.36	0.83	216.95	35.23	33.22	3af2rnt9q4u9b	JDBC Thin Client	select cd.CCRDNO , cd.item, cd...

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 6.1% of Total User I/O Wait Time (s): 7,217
Captured PL/SQL account for 6.8% of Total User I/O Wait Time (s): 7,217

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
489.71	1	489.71	6.79	3,194.68	67.23	15.33	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
87.95	328	0.27	1.22	2,573.07	80.20	3.42	9q7k9nbpvk8pv	DBMS_SCHEDULER	SELECT NVL(SUM(TIME_WAITED/100...
85.71	56	1.53	1.19	254.27	29.96	33.71	btrs48n39rhcd	JDBC Thin Client	select cd.CCRDNO, cd.item, cd....
72.07	56	1.29	1.00	216.95	35.23	33.22	3af2rnt9q4u9b	JDBC Thin Client	select cd.CCRDNO , cd.item, cd...
54.00	5	10.80	0.75	108.97	35.72	49.56	c6ksc6kfhjjc6	DBMS_SCHEDULER	with ash_samples as ( SELECT /...
34.38	22	1.56	0.48	118.34	55.64	29.05	73fhvwt6xvk2x	JDBC Thin Client	select distinct pi.orderno fro...
21.16	10,454	0.00	0.29	32.11	4.89	65.91	1ugz7d875p582	JDBC Thin Client	select o.paymode, pb.paystatus...
17.10	292	0.06	0.24	621.37	78.70	2.75	bs6q10hmtbh49	JDBC Thin Client	select bs.billno, bs.bankflowi...
13.08	6	2.18	0.18	63.19	59.85	20.69	3bf7cptakrtga	JDBC Thin Client	select p.orderno from passenge...
8.75	10,398	0.00	0.12	27.29	6.27	32.06	9nztpwka2vvp4	JDBC Thin Client	SELECT SP.ORDERNO, SP.SEGORDER...

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: 585,271,612
Captured SQL account for 67.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
192,797,703	1	192,797,703.00	32.94	3,194.68	67.2	15.3	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
189,334,952	328	577,240.71	32.35	2,573.07	80.2	3.4	9q7k9nbpvk8pv	DBMS_SCHEDULER	SELECT NVL(SUM(TIME_WAITED/100...
44,649,569	1,495	29,865.93	7.63	643.87	76.2	.6	0a1z1knkykfwz	JDBC Thin Client	select p.psgname, p.pnrno, (se...
25,694,766	174	147,671.07	4.39	171.04	76.1	0	58z173u8h1kxc	JDBC Thin Client	select count(*) as recordscoun...
16,350,773	185	88,382.56	2.79	162.48	64.2	0	2ggs3r1ncmwwr	JDBC Thin Client	select count(*) as recordscoun...
13,076,553	1,176	11,119.52	2.23	310.63	72	0	gyudauqxd8gqc	JDBC Thin Client	select ag.ORGAREA ORGAREA from...
9,973,943	184	54,206.21	1.70	209.18	22.9	.1	7qkh5ucsbcqk6	JDBC Thin Client	select sum(o.seatnum) from ord...
8,587,368	56	153,345.86	1.47	254.27	30	33.7	btrs48n39rhcd	JDBC Thin Client	select cd.CCRDNO, cd.item, cd....
8,583,693	56	153,280.23	1.47	216.95	35.2	33.2	3af2rnt9q4u9b	JDBC Thin Client	select cd.CCRDNO , cd.item, cd...
8,452,708	116	72,868.17	1.44	281.73	69.5	0	dugh7uyrn80b4	JDBC Thin Client	select * from( select /*+ inde...
6,990,398	184	37,991.29	1.19	60.20	63	0	9b2r0p9d97p92	JDBC Thin Client	select sum(t.seatnum) from ord...
6,494,289	174	37,323.50	1.11	40.91	76.8	.4	c5jycdptb6cj3	JDBC Thin Client	select sum(o.seatnum) from ord...
6,124,940	292	20,975.82	1.05	621.37	78.7	2.8	bs6q10hmtbh49	JDBC Thin Client	select bs.billno, bs.bankflowi...

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: 18,879,919
Captured SQL account for 1.1% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
159,277	5	31,855.40	0.84	108.97	35.72	49.56	c6ksc6kfhjjc6	DBMS_SCHEDULER	with ash_samples as ( SELECT /...
81,811	1	81,811.00	0.43	3,194.68	67.23	15.33	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
19,627	328	59.84	0.10	2,573.07	80.20	3.42	9q7k9nbpvk8pv	DBMS_SCHEDULER	SELECT NVL(SUM(TIME_WAITED/100...
12,720	22	578.18	0.07	118.34	55.64	29.05	73fhvwt6xvk2x	JDBC Thin Client	select distinct pi.orderno fro...
8,187	56	146.20	0.04	254.27	29.96	33.71	btrs48n39rhcd	JDBC Thin Client	select cd.CCRDNO, cd.item, cd....
6,532	56	116.64	0.03	216.95	35.23	33.22	3af2rnt9q4u9b	JDBC Thin Client	select cd.CCRDNO , cd.item, cd...
1,960	292	6.71	0.01	621.37	78.70	2.75	bs6q10hmtbh49	JDBC Thin Client	select bs.billno, bs.bankflowi...
1,526	10,454	0.15	0.01	32.11	4.89	65.91	1ugz7d875p582	JDBC Thin Client	select o.paymode, pb.paystatus...
686	10,398	0.07	0.00	27.29	6.27	32.06	9nztpwka2vvp4	JDBC Thin Client	SELECT SP.ORDERNO, SP.SEGORDER...
543	12,057	0.05	0.00	40.76	6.45	20.36	f4uf0u8q871js	JDBC Thin Client	select min(pt.ticketno) as min...

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,407,675
Captured SQL account for 3.5% of Total
Total UnOptimized Read Requests: 1,407,675
Captured SQL account for 3.5% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
68,963	68,963	1	68,963.00	4.90	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
19,627	19,627	328	59.84	1.39	9q7k9nbpvk8pv	DBMS_SCHEDULER	SELECT NVL(SUM(TIME_WAITED/100...
12,527	12,527	22	569.41	0.89	73fhvwt6xvk2x	JDBC Thin Client	select distinct pi.orderno fro...
8,081	8,081	56	144.30	0.57	btrs48n39rhcd	JDBC Thin Client	select cd.CCRDNO, cd.item, cd....
1,960	1,960	292	6.71	0.14	bs6q10hmtbh49	JDBC Thin Client	select bs.billno, bs.bankflowi...
1,921	1,921	5	384.20	0.14	c6ksc6kfhjjc6	DBMS_SCHEDULER	with ash_samples as ( SELECT /...
1,843	1,843	6	307.17	0.13	8kvgs3007httw	Foglight for Oracle <5.6.4.311>	select /+ rule / decode(INST...
686	686	10,398	0.07	0.05	9nztpwka2vvp4	JDBC Thin Client	SELECT SP.ORDERNO, SP.SEGORDER...
543	543	12,057	0.05	0.04	f4uf0u8q871js	JDBC Thin Client	select min(pt.ticketno) as min...
538	538	10,483	0.05	0.04	81h1tf5rjb8jr	JDBC Thin Client	select pt.segorder, p.type, co...

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: 1,873,145
Captured SQL account for 43.4% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
153,573	0	0.00	19.94	2.8	0	4yq6qwgw992zk	JDBC Thin Client	select CABINS from GENERALIZEL...
105,919	105,912	1.00	37.78	.7	0	520mkxqpf15q8	JDBC Thin Client	select 1 from dual
105,683	0	0.00	94.01	1	0	d4ggk0agny9tf	JDBC Thin Client	SET TRANSACTION READ WRITE
99,348	99,347	1.00	18.78	23.1	0	ftj9uawt4wwzb		select condition from cdef$ wh...
25,882	25,882	1.00	2.36	3.4	0	bunvx480ynf57	JDBC Thin Client	SELECT 1 FROM DUAL
24,008	24,008	1.00	36.35	2.8	15.9	09uaa1krtq5by	JDBC Thin Client	select f.agentfeereturntype fr...
16,252	0	0.00	1.93	1.6	0	4xcfs63ggs8m0	JDBC Thin Client	select CABINS from GENERALIZEL...
15,149	15,149	1.00	1.67	25.8	3.2	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
14,759	14,759	1.00	2.18	2.3	0	87tu7wk540dwq	JDBC Thin Client	select MAX_THREAD_COUNT from p...
12,990	12,989	1.00	4.05	5.4	0	2dqj3rc7b0x8q	JDBC Thin Client	select o.Isautocreate from ord...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,471,425
Captured SQL account for 52.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
153,445	153,573	10.43	4yq6qwgw992zk	JDBC Thin Client	select CABINS from GENERALIZEL...
105,907	105,919	7.20	520mkxqpf15q8	JDBC Thin Client	select 1 from dual
105,680	105,683	7.18	d4ggk0agny9tf	JDBC Thin Client	SET TRANSACTION READ WRITE
99,346	99,348	6.75	ftj9uawt4wwzb		select condition from cdef$ wh...
25,879	25,882	1.76	bunvx480ynf57	JDBC Thin Client	SELECT 1 FROM DUAL
16,240	16,252	1.10	4xcfs63ggs8m0	JDBC Thin Client	select CABINS from GENERALIZEL...
15,149	15,149	1.03	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
14,759	14,759	1.00	87tu7wk540dwq	JDBC Thin Client	select MAX_THREAD_COUNT from p...
12,959	12,990	0.88	2dqj3rc7b0x8q	JDBC Thin Client	select o.Isautocreate from ord...
12,058	12,058	0.82	5f0955qkz78g4	JDBC Thin Client	select DOMESTICINDICATE from o...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
16,063,462	55	0.18	b0d1f3vqvdca7	Foglight for Oracle <5.5.8.127>	select /+ rule / rownum, sid...
8,896,671	55	0.10	89nf3yvxk8yq7	Foglight for Oracle <5.6.4.311>	select /+ rule / rownum, sid...
2,912,279	11	0.03	21dnq66bcztyr	Foglight for Oracle <5.5.8.127>	select (jj.act_jobs_jobs + js....
1,632,209	1,122	0.02	8swypbbr0m372		select order#, columns, types ...
1,561,372	9	0.02	am19a1bvysghh	Foglight for Oracle <5.6.4.311>	select (jj.act_jobs_jobs + js....
1,075,065	32	0.01	9nz14w8x5fsfd	JDBC Thin Client	BEGIN PROCESSORDER.CallBackByB...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
109	55	b0d1f3vqvdca7	Foglight for Oracle <5.5.8.127>	select /+ rule / rownum, sid...
45	6	bt51szvfrcdpn	JDBC Thin Client	SELECT obj_type, plan_id, comp...
36	1,683	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
36	1,683	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
34	2,790	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
30	153	56h11bx91nk74		select limit# from profile$ wh...
28	55	89nf3yvxk8yq7	Foglight for Oracle <5.6.4.311>	select /+ rule / rownum, sid...
28	1,122	8swypbbr0m372		select order#, columns, types ...
24	32	9nz14w8x5fsfd	JDBC Thin Client	BEGIN PROCESSORDER.CallBackByB...
23	2,487	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...
23	4	69subccxd9b03	JDBC Thin Client	SELECT signature, inuse_featur...
23	2,369	83taa7kaw59c1		select name, intcol#, segcol#,...
21	768	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
21	768	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...

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): 4,357
Captured SQL account for 16.1% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
191.09	450	4.39	1,429.48	13.37	0.02	0.00	5ansr7r9htpq3		update undo$ set name=:2, file...
146.59	184	3.36	209.18	70.08	22.92	0.09	7qkh5ucsbcqk6	JDBC Thin Client	select sum(o.seatnum) from ord...
115.68	1	2.66	3,194.68	3.62	67.23	15.33	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
38.02	10,483	0.87	52.17	72.89	1.65	14.65	81h1tf5rjb8jr	JDBC Thin Client	select pt.segorder, p.type, co...
33.87	12,058	0.78	46.89	72.22	1.98	6.26	bhwz3x2mjy7s3	JDBC Thin Client	SELECT PL.PNRNO FROM PNRLIST P...
31.70	185	0.73	162.48	19.51	64.17	0.01	2ggs3r1ncmwwr	JDBC Thin Client	select count(*) as recordscoun...
30.09	56	0.69	254.27	11.83	29.96	33.71	btrs48n39rhcd	JDBC Thin Client	select cd.CCRDNO, cd.item, cd....
25.38	56	0.58	216.95	11.70	35.23	33.22	3af2rnt9q4u9b	JDBC Thin Client	select cd.CCRDNO , cd.item, cd...
24.05	116	0.55	281.73	8.54	69.50	0.00	dugh7uyrn80b4	JDBC Thin Client	select * from( select /*+ inde...
20.86	12,057	0.48	40.76	51.16	6.45	20.36	f4uf0u8q871js	JDBC Thin Client	select min(pt.ticketno) as min...
14.31	328	0.33	2,573.07	0.56	80.20	3.42	9q7k9nbpvk8pv	DBMS_SCHEDULER	SELECT NVL(SUM(TIME_WAITED/100...
13.27	24,008	0.30	36.35	36.52	2.81	15.93	09uaa1krtq5by	JDBC Thin Client	select f.agentfeereturntype fr...
12.71	10,437	0.29	39.39	32.27	2.95	18.68	6u1fc9nj87uhd	JDBC Thin Client	SELECT S.SEGORDER, (S.CARRIER ...
8.64	184	0.20	60.20	14.36	63.04	0.00	9b2r0p9d97p92	JDBC Thin Client	select sum(t.seatnum) from ord...
8.36	12,058	0.19	11.99	69.70	6.34	9.72	5f0955qkz78g4	JDBC Thin Client	select DOMESTICINDICATE from o...
7.90	10,398	0.18	27.29	28.96	6.27	32.06	9nztpwka2vvp4	JDBC Thin Client	SELECT SP.ORDERNO, SP.SEGORDER...
7.60	2,100	0.17	1,742.44	0.44	0.05	0.00	7jk3kcjxvz83k	JDBC Thin Client	UPDATE PAYBILL SET PAYSTATUS =...
7.34	1,495	0.17	643.87	1.14	76.19	0.58	0a1z1knkykfwz	JDBC Thin Client	select p.psgname, p.pnrno, (se...
6.93	1,203	0.16	3,763.54	0.18	0.05	0.06	7ncnu7ud2ykhu	JDBC Thin Client	insert into ORDERS (domesticin...
5.09	10,454	0.12	32.11	15.84	4.89	65.91	1ugz7d875p582	JDBC Thin Client	select o.paymode, pb.paystatus...
4.88	174	0.11	56.07	8.71	70.14	0.01	52ngpnc7n319u	JDBC Thin Client	select count(*) from orders o ...
4.74	5	0.11	108.97	4.35	35.72	49.56	c6ksc6kfhjjc6	DBMS_SCHEDULER	with ash_samples as ( SELECT /...
4.47	4	0.10	1,181.69	0.38	0.10	0.09	ckh0xnga85szg	JDBC Thin Client	select * from ( select /*+USE_...
3.53	12,058	0.08	16.90	20.85	3.25	0.06	a7pqvnr44uy38	JDBC Thin Client	SELECT HO.PAYMONEY, HO.HOTELOR...
3.47	3	0.08	1,636.55	0.21	0.13	0.10	5q9n2yy5aj6hv	JDBC Thin Client	select count(*) as orderstatus...
3.05	6	0.07	63.19	4.83	59.85	20.69	3bf7cptakrtga	JDBC Thin Client	select p.orderno from passenge...
2.99	22	0.07	118.34	2.53	55.64	29.05	73fhvwt6xvk2x	JDBC Thin Client	select distinct pi.orderno fro...
2.97	184	0.07	58.20	5.11	71.51	0.00	67jr1q3uanf6w	JDBC Thin Client	select count(*) from orders o ...
2.89	12,095	0.07	5.74	50.30	12.19	0.00	bhvwd3sbwdyga	JDBC Thin Client	select f.isautoconfirm from fl...
2.62	10,483	0.06	6.50	40.33	7.54	0.00	5s3uwrd1gxt7q	JDBC Thin Client	SELECT NVL(AG.AGENTTYPE, OU1.F...
2.60	9,201	0.06	3.84	67.68	9.10	0.00	95bdypfq2ky5g	JDBC Thin Client	select o.domesticindicate from...
2.60	174	0.06	171.04	1.52	76.14	0.00	58z173u8h1kxc	JDBC Thin Client	select count(*) as recordscoun...
2.55	10,483	0.06	4.06	62.86	12.06	0.00	9tzrcb1d5f06z	JDBC Thin Client	SELECT O.ORDERNO, O.GROUPFLAG,...
2.23	12,990	0.05	4.05	55.02	5.43	0.00	2dqj3rc7b0x8q	JDBC Thin Client	select o.Isautocreate from ord...
2.22	10,483	0.05	12.37	17.94	5.09	14.05	90yfsh8rb8gma	JDBC Thin Client	select p.TYPE from paxinsuranc...
2.21	10,483	0.05	7.57	29.12	2.90	0.00	78txh8n821266	JDBC Thin Client	select 1 from dual where exist...
1.98	3	0.05	1,291.69	0.15	0.12	0.00	7qwgyfxhnaxna	JDBC Thin Client	select originalorderno from or...
1.97	768	0.05	3.15	62.50	2.54	21.57	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
1.74	4	0.04	1,271.26	0.14	0.01	0.00	83bank242m66q	JDBC Thin Client	select o.campaignscriptid from...
1.55	8	0.04	2.43	63.88	11.09	13.76	fmbv2fxj0mwuy		DECLARE job BINARY_INTEGER := ...
1.46	10,439	0.03	2.60	56.06	12.29	0.00	8whvjha2fnk63	JDBC Thin Client	SELECT F.TOTALPRICE, F.AGENTFE...
1.44	174	0.03	40.91	3.51	76.76	0.43	c5jycdptb6cj3	JDBC Thin Client	select sum(o.seatnum) from ord...
1.40	12,057	0.03	2.60	53.68	5.76	0.00	ckg1n91hh2qkk	JDBC Thin Client	select o.pricefileno from flig...
1.18	10,483	0.03	2.43	48.64	5.77	0.00	g128myz1mz13n	JDBC Thin Client	select 1 from dual where exist...
1.05	1,719	0.02	3.20	32.63	20.60	0.83	fr6m3gyy3gwk7	JDBC Thin Client	UPDATE PNRLIST SET TICKETFLAG ...
1.02	1,532	0.02	1,666.52	0.06	0.13	0.00	ab5gtgnqyskp7	JDBC Thin Client	select o.campaignscriptid from...
0.65	1,557	0.01	1,800.00	0.04	0.15	0.00	6wytwy7ry0jsb	JDBC Thin Client	UPDATE ORDERS SET TICKETOUTAGE...
0.61	14	0.01	0.71	85.65	11.21	0.01	buzp8cfu6upry	JDBC Thin Client	SELECT C.CHANGENO, C.ORDERNO, ...
0.56	3	0.01	1,114.04	0.05	0.10	0.00	04havy07x2m26	JDBC Thin Client	select count(*) as changestatu...
0.48	8	0.01	0.73	66.20	20.68	0.00	74mb2gqrm9xb6	JDBC Thin Client	select c.refaction, c.basiccon...
0.47	1,172	0.01	0.63	75.11	0.00	11.28	87gaftwrm2h68		select o.owner#, o.name, o.nam...
0.42	15	0.01	0.79	53.30	18.94	0.01	14abfzpgc5vkt	JDBC Thin Client	select c.refaction, c.basiccon...
0.42	22	0.01	81.71	0.52	81.26	0.00	d6fwfwn6jjbsb	JDBC Thin Client	select distinct pi.orderno, o....
0.35	32	0.01	0.92	37.96	41.21	1.04	9nz14w8x5fsfd	JDBC Thin Client	BEGIN PROCESSORDER.CallBackByB...
0.33	1,683	0.01	32.97	1.01	1.76	2.00	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.28	48	0.01	0.84	32.74	11.86	0.21	8zr60wpvdvbtu	JDBC Thin Client	select /*+index(orders IDX_CR...
0.25	2,487	0.01	0.54	45.59	16.66	0.01	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...
0.23	183	0.01	3.40	6.82	45.03	0.00	az33m61ym46y4	JDBC Thin Client	SELECT NULL AS table_cat, o.ow...
0.20	1,122	0.00	1.14	17.73	9.61	57.35	8swypbbr0m372		select order#, columns, types ...
0.14	2,369	0.00	1.98	7.03	30.31	37.18	83taa7kaw59c1		select name, intcol#, segcol#,...
0.09	55	0.00	119.47	0.07	60.25	0.01	b0d1f3vqvdca7	Foglight for Oracle <5.5.8.127>	select /+ rule / rownum, sid...
0.07	11	0.00	33.81	0.21	22.60	0.01	21dnq66bcztyr	Foglight for Oracle <5.5.8.127>	select (jj.act_jobs_jobs + js....
0.03	4	0.00	332.71	0.01	0.05	0.00	5wsn90a3fjnmj	JDBC Thin Client	UPDATE batchpay b SET b.pnrval...
0.03	1,176	0.00	310.63	0.01	71.97	0.00	gyudauqxd8gqc	JDBC Thin Client	select ag.ORGAREA ORGAREA from...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

04havy07x2m26 select count(*) as changestatustotal from change c, orders o where o.orderno = c.orderno AND C.STATUS ='H' and (c.submituserid = '113907597020'or c.submituserid = '113907597020') and ROWNUM <= 100 AND to_char(c.createtime, 'yyyy-MM-dd')>=to_char(to_date('2013-05-09', 'yyyy-MM-dd'), 'yyyy-MM-dd') AND c.changetype ='F' order by c.createtime desc

09uaa1krtq5by select f.agentfeereturntype from flightpricedomestic f where f.orderno = :1

0a1z1knkykfwz select p.psgname, p.pnrno, (select sum(s.mileage) from segmentprice s where s.orderno=:1 )as mileage , e.exchangeid, e.exchangedate from passenger p, exchange e where p.orderno=e.ecsno(+) and p.pnrno=e.pnr(+) and p.orderno=:2 and p.type!=2

14abfzpgc5vkt select c.refaction, c.basiccontext from controlledaction c, (select ca.refaction, min(ca.priority) priority from (select roleid from userrolesmapping where userguid = 'urcguowp' union select orgrole.roleid from userprofile users, organizationunitprofile orgrole where users.orgunitguid = orgrole.orgunitguid and (users.userguid ='urcguowp') and orgrole.roleid is not null) ur join permissionset ps on ur.roleid = ps.roleid join controlledaction ca on ps.actionid = ca.actionid group by ca.refaction) x where c.refaction = x.refaction and c.priority = x.priority

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1ugz7d875p582 select o.paymode, pb.paystatus, bgw.bankgatewayname, pb.paydate, pb.billno, pb.batchid, pb.uppbillno, pb.batchflag, pb.paymoney, pb.currency, pb.bankcode from payment pm, paybill pb, orders o, bankgateway bgw where pm.orderno = :1 and pm.billno = pb.billno and pm.paystatus != 'D' and pm.orderno = o.orderno and pb.bankgatewaycode = bgw.BANKGATEWAYCODE

21dnq66bcztyr select (jj.act_jobs_jobs + js.act_jobs_sched) + 0 active_job_proc, greatest (wj.due_jobs + ws.due_sched - jj.act_jobs_jobs - js.act_jobs_sched, 0) + 0 jobs_waiting, greatest (tj.tot_jobs_jobs + ts.tot_jobs_sched - jj.act_jobs_jobs - js.act_jobs_sched - wj.due_jobs - ws.due_sched, 0) + 0 idle_job_procs, (tj.tot_jobs_jobs + ts.tot_jobs_sched) + 0 total_job_procs from (select /*+RULE*/ count(*) tot_jobs_jobs from SYS.dba_jobs) tj, (select /*+RULE*/ count(*) tot_jobs_sched from SYS.dba_scheduler_jobs) ts, (select /*+RULE*/ count(*) act_jobs_jobs from SYS.dba_jobs_running) jj, (select /*+RULE*/ count(*) act_jobs_sched from SYS.dba_scheduler_running_jobs) js, (select /*+RULE*/ count(*) due_jobs FROM SYS.dba_jobs WHERE next_date < sysdate) wj, (select /*+RULE*/ count(*) due_sched FROM SYS.dba_scheduler_jobs WHERE next_run_date < sysdate) ws

25svbmrbjp20g select g.airport from agentsaleairport g where g.agent in ( select c.city from cityintegration c, (select t.area from cityintegration t where t.city = (select o.code from agentarea a, ORGAREATOCODE o where a.orgunitguid = '4629' and a.ORGAREA = o.orgarea))aaa where aaa.area = c.area union select o.code from agentarea a, ORGAREATOCODE o where a.orgunitguid = '4629' and a.ORGAREA = o.orgarea)

2dqj3rc7b0x8q select o.Isautocreate from orders o where o.orderno = :1

2ggs3r1ncmwwr select count(*) as recordscount from orders t where t.bookuser='080009577652' and t.orderflag='C' and t.status in ('C', 'P') and t.createdate>=to_date('2013-02-07', 'yyyy-MM-dd')

2jfqzrxhrm93b select /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

3af2rnt9q4u9b select cd.CCRDNO , cd.item, cd.orderno, r.domesticindicate from callcenterdatarecord cd, refundorder r where cd.status='T' and cd.flag='W' and (r.status='R' or r.status='P') and cd.item=r.refundno and cd.orderno=r.orderno

3bf7cptakrtga select p.orderno from passengerinfo p , orders o where p.orderno = o.orderno and o.orderflag ='B' and o.status = 'E' and o.createdate>sysdate-2 and p.sendflag ='B' group by p.orderno union select p.orderno from passengerinfo p , orders o where p.orderno = o.orderno and o.orderflag ='B' and o.status = 'E' and o.createdate>sysdate-2 and p.sendflag is null group by p.orderno

3nkd3g3ju5ph1 select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

4xcfs63ggs8m0 select CABINS from GENERALIZELINK where MERCHANTID = 'TAOBAO'

4yq6qwgw992zk select CABINS from GENERALIZELINK where MERCHANTID = 'CZBTOC'

520mkxqpf15q8 select 1 from dual

52ngpnc7n319u select count(*) from orders o where o.bookuser='580008619967' and o.orderflag='C' and o.status='E' and o.createdate>= date'2013-08-06'

56h11bx91nk74 select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3

58z173u8h1kxc select count(*) as recordscount from orders t where t.bookuser='580008619967' and t.orderflag='C' and t.status in ('C', 'P') and t.createdate>=to_date('2013-02-07', 'yyyy-MM-dd')

5ansr7r9htpq3 update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1

5f0955qkz78g4 select DOMESTICINDICATE from orders where orderno = :1

5n1fs4m2n2y0r select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1

5q9n2yy5aj6hv select count(*) as orderstatustotail from (select od.orderno, od.domesticindicate, od.status, od.campaignscriptid, fp.totalpaymoney, to_char(od.createdate, 'yyyy-MM-dd') as createdate from orders od, flightpricedomestic fp, segment sm where (od.bookuser in ('13875098898' , '13875098898' , '' )) and od.orderno = fp.orderno and sm.orderno = od.orderno and od.enterpricetype IS NULL and od.createdate >= to_date('2013-05-09', 'yyyy-MM-dd') AND (((1 = 1 and (od.status in ('C', 'P', 'L', 'M'))) or (1=2 and (od.status in ('B', 'T'))) or (1=3 and od.status in ('O', 'R', 'E')) or (1=4 and od.status='D'))) AND od.groupflag='0' group by od.orderno, od.status, fp.totalpaymoney, od.createdate, od.domesticindicate, od.campaignscriptid order by od.createdate desc ) od where rownum < 101

5s3uwrd1gxt7q SELECT NVL(AG.AGENTTYPE, OU1.FLAG) ouType, OU1.NAME AGENTNAME, (SELECT CL.ALIASNAME FROM CITYLIST CL WHERE CL.LOCALE = 'zh' AND CL.CODE = OU1.CITY) AS CITY, (SELECT OU2.NAME FROM ORGANIZATIONUNITPROFILE OU2 WHERE OU2.ORGUNITGUID = OU1.PARENTGUID) AS PARENTNAME, AG.PURCHASAGENT AS AGENT FROM ORGANIZATIONUNITPROFILE OU1, ORDERS O, AGENTPROFILE AG WHERE O.BOOKAGENT = OU1.ORGUNITGUID AND AG.ORGUNITGUID(+) = OU1.ORGUNITGUID AND O.ORDERNO = :1

5wsn90a3fjnmj UPDATE batchpay b SET b.pnrvalid = 'N' WHERE b.orderno IN (SELECT bp.orderno FROM batchpay bp, orders o WHERE bp.orderno = o.orderno AND o.createdate < SYSDATE - 24/24 AND (bp.pnrvalid = 'Y' OR bp.pnrvalid IS NULL)GROUP BY bp.orderno)

67jr1q3uanf6w select count(*) from orders o where o.bookuser='080009577652' and o.orderflag='C' and o.status='E' and o.createdate>= date'2013-08-06'

69subccxd9b03 SELECT signature, inuse_features, flags FROM sql$ WHERE signature = :1

6mcpb06rctk0x call dbms_space.auto_space_advisor_job_proc ( )

6u1fc9nj87uhd SELECT S.SEGORDER, (S.CARRIER || S.FLIGHTNO) FLIGHTNO, S.PLANETYPE, S.CABIN, S.DEPTIME FLIGHTDATE, (select a.name from airportslist a where a.code = s.depairport and a.locale = 'zh') DEPAIRPORT, (select a.name from airportslist a where a.code = s.arrairport and a.locale = 'zh') ARRAIRPORT, to_char(s.deptime, 'HH24MI') DEPTIME, to_char(s.arrtime, 'HH24MI') ARRTIME, s.depairport DEPAIRPORTCODE, s.arrairport ARRAIRPORTCODE, (SELECT AP.OPENETICKET FROM AIRPORTSLIST AP WHERE AP.CODE = S.DEPAIRPORT AND AP.LOCALE = 'zh') AS EFLAG FROM SEGMENT S WHERE S.ORDERNO = :1 ORDER BY S.SEGORDER ASC

6wytwy7ry0jsb UPDATE ORDERS SET TICKETOUTAGENT = BOOKAGENT WHERE ORDERNO = :B1

73fhvwt6xvk2x select distinct pi.orderno from passengerinfo pi, orders o where pi.sendflag is null and pi.orderno=o.orderno and o.status='D' and o.createdate>to_date('2013-08-06', 'yyyy-mm-dd') and o.createdate<to_date('2013-08-08', 'yyyy-mm-dd')

74mb2gqrm9xb6 select c.refaction, c.basiccontext from controlledaction c, (select ca.refaction, min(ca.priority) priority from (select roleid from userrolesmapping where userguid = 'shewangh' union select orgrole.roleid from userprofile users, organizationunitprofile orgrole where users.orgunitguid = orgrole.orgunitguid and (users.userguid ='shewangh') and orgrole.roleid is not null) ur join permissionset ps on ur.roleid = ps.roleid join controlledaction ca on ps.actionid = ca.actionid group by ca.refaction) x where c.refaction = x.refaction and c.priority = x.priority

78txh8n821266 select 1 from dual where exists (select 1 from paxinsurance p where p.orderno = :1 )

7jk3kcjxvz83k UPDATE PAYBILL SET PAYSTATUS = PAYSTATUS WHERE BILLNO = :B1 RETURNING PAYSTATUS INTO :O0

7ncnu7ud2ykhu insert into ORDERS (domesticindicate, orderflag, adultnum, groupname, payreceived, paymoney, childnum, enterpricetype, campaignscriptid, transactor, bookusername, memberno, contact, originalorderno, remarkno, bookagent, seatnum, emailflag, submitpricetime, infantnum, bookagentname, paymode, createdate, deliverstatus, tickettimelimit, shipagent, refbyorder, transactorname, reforder, ticketoutagent, campaigntype, noteflag, attribute5, attribute4, refticket, attribute3, groupflag, attribute2, isautocreate, attribute1, transactorcardno, status, gxhtype, parentorderno, bookuser, orderno) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 )

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

7qkh5ucsbcqk6 select sum(o.seatnum) from orders o, segment s where o.bookuser='080009577652' and o.orderno=s.orderno and o.status='D' and s.cabin in ('R', 'O', 'X', 'N') and o.createdate>= date'2013-08-06'

7qwgyfxhnaxna select originalorderno from orders p where p.orderno='C1307090026705'

81h1tf5rjb8jr select pt.segorder, p.type, count(*) as refundnum from psgticket pt, passenger p where pt.orderno = p.orderno and pt.psgname = p.psgname and pt.orderno = p.orderno and pt.refundno is not null and pt.orderno = :1 group by pt.segorder, p.type order by pt.segorder, p.type asc

83bank242m66q select o.campaignscriptid from orders o where o.groupflag = '0' and o.domesticindicate = 1 and o.orderno = 'B1308070079473'

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

87gaftwrm2h68 select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1

87tu7wk540dwq select MAX_THREAD_COUNT from partener_interface p where p.partnerid='QQ' and p.interfaceid='AVPRICE_JAXB'

89nf3yvxk8yq7 select /*+ rule */ rownum, sid, serial, locking_sid, locking_serial, lock_type, lock_mode, lock_request_mode, object_wanted, instance, host, pid, db_user, os_user, client_machine, program, blocked_sql_hash, blocked_sql, lock_event, seconds_in_wait from (select l.sid sid, s.serial# serial, l.locking_sid locking_sid, s1.serial# locking_serial, l.lock_type lock_type, DECODE (l.lock_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_mode, DECODE (l.lock_request_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_request_mode, decode(s.p2text, 'object #', u1.name || '.' || o1.name, decode(u.name || '.' || o.name, '.', null, u.name || '.' || o.name)) object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, s.sql_hash_value blocked_sql_hash, substr(ses.sql_text, 1, 100) blocked_sql, s.event lock_event, s.seconds_in_wait seconds_in_wait from (select /*+ ordered */ l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l1.inst_id inst_id, l2.inst_id locking_inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l, sys.gv_$session s, sys.gv_$session s1, sys.gv_$instance i, SYS.obj$ o, sys.obj$ o1, SYS.user$ u, SYS.user$ u1, sys.gv_$sql ses where l.sid = s.sid and l.locking_sid = s1.sid and u.user#(+) = o.owner# and u1.user#(+) = o1.owner# and o.obj#(+) = s.row_wait_obj# and o1.obj#(+) = s.p2 and s.sql_hash_value = ses.hash_value(+) and s.inst_id = l.inst_id and i.inst_id = l.inst_id and s1.inst_id = l.locking_inst_id union select lc.locking_sid sid, s.serial# serial, null locking_sid, null locking_serial, null lock_type, null lock_mode, null lock_request_mode, null object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, null blocked_sql_hash, null blocked_sql, null lock_event, null seconds_in_wait from (select /*+ ordered */ distinct locking_sid, null, null, null, null, inst_id from ( select l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l2.inst_id inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l where not exists (select 1 from sys.gv_$lock where sid=l.locking_sid and inst_id=l.inst_id and request > 0 and type in ('TX', 'TM'))) lc, sys.gv_$session s, sys.gv_$instance i where lc.locking_sid = s.sid and s.inst_id = lc.inst_id and i.inst_id = lc.inst_id) where seconds_in_wait > :1 or locking_sid is null

8kvgs3007httw select /*+ rule */ decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, INSTR(b.NAME, '/', -1, 1)+1), substr(b.name, INSTR(b.NAME, '\', -1, 1)+1)) file_file_name, decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, 1, INSTR(b.NAME, '/', -1, 1)-1), substr(b.name, 1, INSTR(b.NAME, '\', -1, 1)-1)) file_file_path, b.NAME file_file_full_name, b.file# file_file_id, d.name file_tablespace, DECODE(d.contents$, 0, (DECODE (BITAND (d.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') file_tbs_contents, a.PHYRDS file_read_requests, a.PHYWRTS file_write_requests, a.PHYBLKRD file_physical_reads, a.PHYBLKWRT file_physical_writes, a.SINGLEBLKRDS file_single_block_reads, a.READTIM/100 file_read_time, a.WRITETIM/100 file_write_time, decode(nvl(a.PHYBLKRD, 0), 0, 0, 10*a.READTIM/a.PHYBLKRD) file_avg_read_time, decode(nvl(a.PHYBLKWRT, 0), 0, 0, 10*a.WRITETIM/a.PHYBLKWRT) file_avg_write_time, decode(nvl(a.PHYBLKRD+a.PHYBLKWRT, 0), 0, 0, 10*(a.READTIM+a.WRITETIM)/(a.PHYBLKRD+a.PHYBLKWRT)) file_avg_io_time, a.SINGLEBLKRDTIM/100 file_single_block_read_time, a.LSTIOTIM/100 file_last_io_time, a.MINIOTIM/100 file_min_single_io_time, a.MAXIORTM/100 file_max_single_read_time, a.MAXIOWTM/100 file_max_single_write_time, decode((c.total_data_io+e.total_temp_io), 0, 0, 100*nvl((a.PHYWRTS+a.PHYRDS), 0)/(c.total_data_io+e.total_temp_io)) file_physical_io_pct, decode((c.total_data_reads+e.total_temp_reads), 0, 0, 100*nvl(a.PHYBLKRD, 0)/(c.total_data_reads+e.total_temp_reads)) file_physical_reads_pct, decode((c.total_data_writes+e.total_temp_writes), 0, 0, 100*nvl(a.PHYBLKWRT, 0)/(c.total_data_writes+e.total_temp_writes)) file_physical_writes_pct from sys.v_$filestat a, sys.v_$datafile b, (select nvl(sum(PHYBLKRD), 0) total_data_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_data_io, nvl(sum(PHYBLKWRT), 0) total_data_writes from sys.V_$FILESTAT) c, (select nvl(sum(PHYBLKRD), 0) total_temp_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_temp_io, nvl(sum(PHYBLKWRT), 0) total_temp_writes from sys.V_$TEMPSTAT) e, sys.ts$ d where a.file#=b.file# and b.ts#=d.ts# and BITAND (d.flags, 16) <> 16 and nvl(b.bytes, 0) > 0 union select /*+ rule */ decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, INSTR(b.NAME, '/', -1, 1)+1), substr(b.name, INSTR(b.NAME, '\', -1, 1)+1)) file_file_name, decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, 1, INSTR(b.NAME, '/', -1, 1)-1), substr(b.name, 1, INSTR(b.NAME, '\', -1, 1)-1)) file_file_path, b.NAME file_file_full_name, b.file# file_file_id, d.name file_tablespace, DECODE(d.contents$, 0, (DECODE (BITAND (d.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') file_tbs_contents, a.PHYRDS file_read_requests, a.PHYWRTS file_write_requests, a.PHYBLKRD file_physical_reads, a.PHYBLKWRT file_physical_writes, a.SINGLEBLKRDS file_single_block_reads, a.READTIM/100 file_read_time, a.WRITETIM/100 file_write_time, decode(nvl(a.PHYBLKRD, 0), 0, 0, 10*a.READTIM/a.PHYBLKRD) file_avg_read_time, decode(nvl(a.PHYBLKWRT, 0), 0, 0, 10*a.WRITETIM/a.PHYBLKWRT) file_avg_write_time, decode(nvl(a.PHYBLKRD+a.PHYBLKWRT, 0), 0, 0, 10*(a.READTIM+a.WRITETIM)/(a.PHYBLKRD+a.PHYBLKWRT)) file_avg_io_time, a.SINGLEBLKRDTIM/100 file_single_block_read_time, a.LSTIOTIM/100 file_last_io_time, a.MINIOTIM/100 file_min_single_io_time, a.MAXIORTM/100 file_max_single_read_time, a.MAXIOWTM/100 file_max_single_write_time, decode((c.total_data_io+e.total_temp_io), 0, 0, 100*nvl((a.PHYWRTS+a.PHYRDS), 0)/(c.total_data_io+e.total_temp_io)) file_physical_io_pct, decode((c.total_data_reads+e.total_temp_reads), 0, 0, 100*nvl(a.PHYBLKRD, 0)/(c.total_data_reads+e.total_temp_reads)) file_physical_reads_pct, decode((c.total_data_writes+e.total_temp_writes), 0, 0, 100*nvl(a.PHYBLKWRT, 0)/(c.total_data_writes+e.total_temp_writes)) file_physical_writes_pct from sys.v_$tempstat a, sys.v_$tempfile b, (select nvl(sum(PHYBLKRD), 0) total_data_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_data_io, nvl(sum(PHYBLKWRT) , 0) total_data_writes from sys.V_$FILESTAT) c, (select nvl(sum(PHYBLKRD), 0) total_temp_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_temp_io, nvl(sum(PHYBLKWRT), 0) total_temp_writes from sys.V_$TEMPSTAT) e, sys.ts$ d where a.file#=b.file# and b.ts#=d.ts# and nvl(b.bytes, 0) > 0 union select /*+ rule */ decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, INSTR(b.NAME, '/', -1, 1)+1), substr(b.name, INSTR(b.NAME, '\', -1, 1)+1)) file_file_name, decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, 1, INSTR(b.NAME, '/', -1, 1)-1), substr(b.name, 1, INSTR(b.NAME, '\', -1, 1)-1)) file_file_path, b.NAME file_file_full_name, b.file# file_file_id, d.name file_tablespace, DECODE(d.contents$, 0, (DECODE (BITAND (d.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') file_tbs_contents, a.PHYRDS file_read_requests, a.PHYWRTS file_write_requests, a.PHYBLKRD file_physical_reads, a.PHYBLKWRT file_physical_writes, a.SINGLEBLKRDS file_single_block_reads, a.READTIM/100 file_read_time, a.WRITETIM/100 file_write_time, decode(nvl(a.PHYBLKRD, 0), 0, 0, 10*a.READTIM/a.PHYBLKRD) file_avg_read_time, decode(nvl(a.PHYBLKWRT, 0), 0, 0, 10*a.WRITETIM/a.PHYBLKWRT) file_avg_write_time, decode(nvl(a.PHYBLKRD+a.PHYBLKWRT, 0), 0, 0, 10*(a.READTIM+a.WRITETIM)/(a.PHYBLKRD+a.PHYBLKWRT)) file_avg_io_time, a.SINGLEBLKRDTIM/100 file_single_block_read_time, a.LSTIOTIM/100 file_last_io_time, a.MINIOTIM/100 file_min_single_io_time, a.MAXIORTM/100 file_max_single_read_time, a.MAXIOWTM/100 file_max_single_write_time, decode((c.total_data_io+e.total_temp_io), 0, 0, 100*nvl((a.PHYWRTS+a.PHYRDS), 0)/(c.total_data_io+e.total_temp_io)) file_physical_io_pct, decode((c.total_data_reads+e.total_temp_reads), 0, 0, 100*nvl(a.PHYBLKRD, 0)/(c.total_data_reads+e.total_temp_reads)) file_physical_reads_pct, decode((c.total_data_writes+e.total_temp_writes), 0, 0, 100*nvl(a.PHYBLKWRT, 0)/(c.total_data_writes+e.total_temp_writes)) file_physical_writes_pct from sys.v_$filestat a, sys.v_$datafile b, (select nvl(sum(PHYBLKRD), 0) total_data_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_data_io, nvl(sum(PHYBLKWRT), 0) total_data_writes from sys.V_$FILESTAT) c, (select nvl(sum(PHYBLKRD), 0) total_temp_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_temp_io, nvl(sum(PHYBLKWRT), 0) total_temp_writes from sys.V_$TEMPSTAT) e, sys.ts$ d, sys.v_$parameter p where a.file#=b.file# and b.ts#=d.ts# and BITAND (d.flags, 16)=16 and nvl(b.bytes, 0) > 0 and p.name = 'undo_tablespace' and upper(p.value) = upper(d.name)

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

8whvjha2fnk63 SELECT F.TOTALPRICE, F.AGENTFEE, F.AIRPORTTAX, F.PHASEAGENTFEE, F.PHASEAGENTFEESTART, F.PHASEAGENTFEEEND, F.ENDORSEMENT, F.CHENDORSEMENT, F.INENDORSEMENT, F.FUELTAX, F.FILENO, F.CHFILENO, F.INFILENO, F.ADUSECONDITION, F.CHUSECONDITION, F.INUSECONDITION, F.BIZFEE, F.BIZFEEREMARK, F.TOTALCOST, F.TOTALPAYMONEY, F.BOOKINFO, F.OTHERFEE, F.OTHERFEEREMARK, F.CONFIRMMESSAGE, F.BASISREMARK, F.TOURCODE, F.TOTALMILEAGE, (case when F.TOTALLUGGAGECHARGE is null then 0 else F.TOTALLUGGAGECHARGE end ) as TOTALLUGGAGECHARGE FROM FLIGHTPRICEDOMESTIC F WHERE F.ORDERNO = :1

8zr60wpvdvbtu select /*+index(orders IDX_CREATEDATE_STATUS)*/pnrlist.orderno, pnrlist.pnrno, orders.campaignscriptid , orders.orderflag from orders, pnrlist where orders.orderno = pnrlist.orderno and orders.orderno like '%8' and orders.status in('B', 'T') and orders.createdate>sysdate-30 and ( pnrlist.ticketflag is null or ( Ticketflag = 'P' and (TicketTime is null or (sysdate - tickettime) > 1/48)) or ( Ticketflag = 'T' and (TicketTime is null or (sysdate - tickettime) > 1/288))) and rownum <= 100

90yfsh8rb8gma select p.TYPE from paxinsurance p where p.orderno = :1

95bdypfq2ky5g select o.domesticindicate from orders o where o.orderno = :1

95v76f5muyjjg select originalorderno from orders p where p.orderno=''

9awmqbn8w5tkq SELECT O.STATUS, P.TICKETNO FROM ORDERS O, PSGTICKET P WHERE O.ORDERNO='C1308070027006' AND P.ORDERNO='C1308070027006'

9b2r0p9d97p92 select sum(t.seatnum) from orders t, segment s where t.bookuser='080009577652' and t.orderno=s.orderno and t.orderflag='C' and t.status in ('D', 'N'，'S', 'C', 'P') and t.createdate >= date'2013-08-07'

9nz14w8x5fsfd BEGIN PROCESSORDER.CallBackByBank(:1); COMMIT; END;

9nztpwka2vvp4 SELECT SP.ORDERNO, SP.SEGORDER, SP.TRANSFERINDICATE, SP.ADULTPRICE, SP.CHILDPRICE, SP.INFANTPRICE, SP.ADULTCOST, SP.CHILDCOST, SP.INFANTCOST, SP.BASICFEERATE, SP.CHBASICFEERATE, SP.INBASICFEERATE, SP.XFEERATE, SP.APPENDFEERATE, SP.PHASEFEERATE, SP.AIRPORTTAX, nvl(SP.ORIGINADULTFUELTAX, 0) ORIGINADULTFUELTAX, nvl(SP.ADULTFUELTAX, 0) ADULTFUELTAX, nvl(SP.CHILDFUELTAX, 0) CHILDFUELTAX, nvl(SP.INFANTFUELTAX, 0) INFANTFUELTAX, SP.ADULTDISPLAYPRICE, SP.CHILDDISPLAYPRICE, SP.INFANTDISPLAYPRICE, SP.ADULTFAREBASIS, SP.CHILDFAREBASIS, SP.INFANTFAREBASIS, sp.adultbaggageallow, sp.childbaggageallow, sp.infantbaggageallow, (SP.CARRIER || SP.FLIGHTNO) FLIGHTNO, (SELECT AP.OPENETICKET FROM AIRPORTSLIST AP WHERE AP.CODE = SP.DEPAIRPORT AND AP.LOCALE = 'zh') AS EFLAG, (select a.name from airportslist a where a.code = SP.DEPAIRPORT AND a.LOCALE = 'zh') DEPAIRPORT, (select a.name from airportslist a where a.code = SP.ARRAIRPORT AND a.LOCALE = 'zh') ARRAIRPORT, to_char(SP.FLIGHTDATE, 'HH24:MI') DEPTIME, to_char(SP.ARRTIME, 'HH24:MI') ARRTIME, SP.DEPAIRPORT DEPAIRPORTCODE, SP.ARRAIRPORT ARRAIRPORTCODE, SP.CABIN, SP.FLIGHTDATE FROM SEGMENTPRICE SP WHERE SP.ORDERNO = :1 ORDER BY SP.SEGORDER ASC

9q7k9nbpvk8pv SELECT NVL(SUM(TIME_WAITED/1000), 0) FROM SYS.DBA_HIST_ACTIVE_SESS_HISTORY S, SYS.WRH$_SEG_STAT_OBJ SO, SYS.WRM$_SNAPSHOT SN , SYS.OBJ$ OBJ WHERE SN.SNAP_ID = S.SNAP_ID AND SN.DBID = S.DBID AND SN.BEGIN_INTERVAL_TIME >= (CURRENT_TIMESTAMP - NUMTODSINTERVAL(30, 'day')) AND S.CURRENT_OBJ# = SO.OBJ# AND S.WAIT_CLASS = 'User I/O' AND S.WAIT_TIME = 0 AND SO.DATAOBJ# = :B1 AND OBJ.OBJ# = SO.OBJ# AND OBJ.DATAOBJ# = SO.DATAOBJ#

9tzrcb1d5f06z SELECT O.ORDERNO, O.GROUPFLAG, O.GROUPNAME, o.CAMPAIGNSCRIPTID, O.TRANSACTOR, O.CONTACT, O.BOOKAGENT, O.BOOKAGENTNAME, O.STATUS, O.CREATEDATE, O.REFORDER, O.REFBYORDER, O.REFTICKET, O.ADULTNUM, O.CHILDNUM, O.INFANTNUM, nvl(O.Isautocreate, '0') Isautocreate , O.ORIGINALORDERNO, O.ORDERFLAG, O.CAMPAIGNSCRIPTID, O.ATTRIBUTE2, O.ATTRIBUTE1 FROM ORDERS O WHERE O.ORDERNO = :1

9upvznnp7xgsj SELECT BG.BANKGATEWAYNAME AS bank, PS.LARGECLIENTID AS bigClientCode, PB.BILLNO AS billNo, OD.ORDERNO AS bookTktNum, PB.CURRENCY AS currency, case when od.groupflag='1' then 'Y' else 'N' end as GroupFlag FROM ORDERS OD , ( SELECT PT.PSGNAME AS PSGNAME, PT.ORDERNO AS ORDERNO FROM PSGTICKET PT WHERE PT.TICKETNO = :1 AND ROWNUM = 1) TICKET , PASSENGER PS , PAYMENT PY , PAYBILL PB , BANKGATEWAY BG WHERE OD.ORDERNO = TICKET.ORDERNO AND OD.ORDERNO = PS.ORDERNO AND PS.ORDERNO = TICKET.ORDERNO AND PS.PSGNAME = TICKET.PSGNAME AND OD.ORDERNO = PY.ORDERNO AND PY.BILLNO = PB.BILLNO AND PB.PAYSTATUS='P' AND BG.BANKGATEWAYCODE = PB.BANKGATEWAYCODE

a7pqvnr44uy38 SELECT HO.PAYMONEY, HO.HOTELORDERNO, HO.PAYTYPE , CASE HO.PAYTYPE WHEN 'C' THEN '前台现付' ELSE '网上支付' END AS PAYTYPEINFO , CASE WHEN HO.PAYTYPE = 'C' THEN F.TOTALPAYMONEY WHEN HO.PAYTYPE = 'E' AND O.PAYMONEY IS NULL THEN F.TOTALPAYMONEY + HO.PAYMONEY ELSE O.PAYMONEY END AS ORDERPAYMONEY FROM HOTELORDERS HO , FLIGHTPRICEDOMESTIC F , ORDERS O WHERE HO.ORDERNO = F.ORDERNO AND O.ORDERNO = HO.ORDERNO AND HO.ORDERNO = :1

ab5gtgnqyskp7 select o.campaignscriptid from orders o where o.orderno = :1

am19a1bvysghh select (jj.act_jobs_jobs + js.act_jobs_sched) + 0 active_job_proc, greatest (wj.due_jobs + ws.due_sched - jj.act_jobs_jobs - js.act_jobs_sched, 0) + 0 jobs_waiting, greatest (tj.tot_jobs_jobs + ts.tot_jobs_sched - jj.act_jobs_jobs - js.act_jobs_sched - wj.due_jobs - ws.due_sched, 0) + 0 idle_job_procs, (tj.tot_jobs_jobs + ts.tot_jobs_sched) + 0 total_job_procs from (select /*+RULE*/ count(*) tot_jobs_jobs from SYS.dba_jobs) tj, (select /*+RULE*/ count(*) tot_jobs_sched from SYS.dba_scheduler_jobs) ts, (select /*+RULE*/ count(*) act_jobs_jobs from SYS.dba_jobs_running) jj, (select /*+RULE*/ count(*) act_jobs_sched from SYS.dba_scheduler_running_jobs) js, (select /*+RULE*/ count(*) due_jobs FROM SYS.dba_jobs WHERE next_date > sysdate-365 and next_date < sysdate) wj, (select /*+RULE*/ count(*) due_sched FROM SYS.dba_scheduler_jobs WHERE next_run_date > sysdate-365 and next_run_date < sysdate) ws

az33m61ym46y4 SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name

b0d1f3vqvdca7 select /*+ rule */ rownum, sid, serial, locking_sid, locking_serial, lock_type, lock_mode, lock_request_mode, object_wanted, instance, host, pid, db_user, os_user, client_machine, program, blocked_sql_hash, blocked_sql, lock_event, seconds_in_wait from (select l.sid sid, s.serial# serial, l.locking_sid locking_sid, s1.serial# locking_serial, l.lock_type lock_type, DECODE (l.lock_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_mode, DECODE (l.lock_request_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_request_mode, decode(s.p2text, 'object #', u1.name || '.' || o1.name, decode(u.name || '.' || o.name, '.', null, u.name || '.' || o.name)) object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, s.sql_hash_value blocked_sql_hash, substr(ses.sql_text, 1, 100) blocked_sql, s.event lock_event, s.seconds_in_wait seconds_in_wait from (select /*+ ordered */ l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l1.inst_id inst_id, l2.inst_id locking_inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l, sys.gv_$session s, sys.gv_$session s1, sys.gv_$instance i, SYS.obj$ o, sys.obj$ o1, SYS.user$ u, SYS.user$ u1, sys.gv_$sql ses where l.sid = s.sid and l.locking_sid = s1.sid and u.user#(+) = o.owner# and u1.user#(+) = o1.owner# and o.obj#(+) = s.row_wait_obj# and o1.obj#(+) = s.p2 and s.sql_hash_value = ses.hash_value(+) and s.inst_id = l.inst_id and i.inst_id = l.inst_id and s1.inst_id = l.locking_inst_id union select lc.locking_sid sid, s.serial# serial, null locking_sid, null locking_serial, null lock_type, null lock_mode, null lock_request_mode, null object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, null blocked_sql_hash, null blocked_sql, null lock_event, null seconds_in_wait from (select /*+ ordered */ distinct locking_sid, null, null, null, null, inst_id from ( select l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l2.inst_id inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l where not exists (select 1 from sys.gv_$lock where sid=l.locking_sid and inst_id=l.inst_id and request > 0 and type in ('TX', 'TM'))) lc, sys.gv_$session s, sys.gv_$instance i where lc.locking_sid = s.sid and s.inst_id = lc.inst_id and i.inst_id = lc.inst_id) where seconds_in_wait > :1 or locking_sid is null

bhvwd3sbwdyga select f.isautoconfirm from flightpricedomestic f where f.orderno = :1

bhwz3x2mjy7s3 SELECT PL.PNRNO FROM PNRLIST PL WHERE PL.ORDERNO = :1

bs6q10hmtbh49 select bs.billno, bs.bankflowid, bs.paymoney, bs.bankgatewaycode, bs.bankcode, bs.orderstatus status from banksettleorder bs where bs.orderstatus in ('A', 'B', 'C') and bs.settlestatus is null and bs.bankgatewaycode ='CMB' and bs.errcount < 5 order by bs.errcount, bs.billno asc

bt51szvfrcdpn SELECT obj_type, plan_id, comp_data FROM sqlobj$data WHERE signature = :1 AND category = :2

btrs48n39rhcd select cd.CCRDNO, cd.item, cd.orderno, c.changetype from callcenterdatarecord cd, change c where cd.status='S' and cd.flag='W' and c.status='E' and cd.item=c.changeno and cd.orderno=c.orderno

bunvx480ynf57 SELECT 1 FROM DUAL

buzp8cfu6upry SELECT C.CHANGENO, C.ORDERNO, C.CHANGETYPE, C.STATUS, C.CREATETIME, C.DEALTIME, C.SUBMITUSERNAME, C.BOOKAGENTNAME FROM CHANGE C WHERE C.DOMESTICINDICATE='0' AND ROWNUM <= 500 AND ROWNUM <= 301 AND C.CREATETIME >= to_date('2013-08-06', 'yyyy-MM-dd') AND C.CREATETIME <= to_date('2013-08-07', 'yyyy-MM-dd') + 1 AND C.STATUS = ( CASE 'S' WHEN 'A' THEN 'F' ELSE 'S' END ) AND 1=1 ORDER BY C.CREATETIME DESC

c5jycdptb6cj3 select sum(o.seatnum) from orders o, segment s where o.bookuser='580008619967' and o.orderno=s.orderno and o.status='D' and s.cabin in ('R', 'O', 'X', 'N') and o.createdate>= date'2013-08-06'

c6ksc6kfhjjc6 with ash_samples as ( SELECT /*+ full(@SEL$2383FF78, ASH@SEL$2) */ sample_id, ash.instance_number instance_id, sql_id, sql_exec_id, sample_time FROM DBA_HIST_ACTIVE_SESS_HISTORY ash, V$DATABASE db, DBA_HIST_SNAPSHOT s WHERE ash.dbid = (select dbid from V$DATABASE) AND mod(ash.sample_id, :1) = 0 AND ash.snap_id = s.snap_id AND ash.dbid = s.dbid AND ash.instance_number = s.instance_number AND s.end_interval_time > (TO_TIMESTAMP(:2, 'YYYY-MM-DD HH24:MI:SS:FF6') at TIME ZONE dbtimezone) - 7 ) SELECT total_exec_count, activity_rate, activity_rate_over FROM (SELECT sum(exec_cnt)+1 total_exec_count FROM ( SELECT (case when next_exec_id>sql_exec_id then (next_exec_id - sql_exec_id) else 0 end) exec_cnt FROM ( SELECT sql_exec_id, lead(sql_exec_id, 1, 0) over (partition by instance_id order by sample_time NULLS last) next_exec_id FROM ash_samples WHERE sql_id = :3 ) ) ) sql_count_query, (SELECT sql_count/sample_total activity_rate FROM ( SELECT count(*) sample_total, sum(case when sql_id=:4 then 1 else 0 end) sql_count FROM ash_samples ) ) sql_activity_query, (SELECT over_count/ash_sample_count activity_rate_over FROM ( SELECT count(*) ash_sample_count, sum(case when total >= s.value*2 then 1 else 0 end) over_count FROM ( SELECT instance_id, count(*) total, sum(case when sql_id=:5 then 1 else 0 end) sql_count FROM ash_samples a GROUP BY a.sample_id, a.instance_id ) t, gv$osstat s where t.instance_id = s.inst_id and s.stat_name = 'NUM_CPUS' and t.sql_count > 0 ) ) sql_activity_over_2cpu_query

ckg1n91hh2qkk select o.pricefileno from flightpricedomestic o where o.orderno = :1

ckh0xnga85szg select * from ( select /*+USE_NL(orders, f)*/ orders.orderno, orders.status, orders.groupflag, f.totalcost, f.fileno, orders.contact, orders.adultnum as adultnum, orders.childnum, orders.infantnum, orders.bookagentname from orders, flightpricedomestic f where orders.orderno = f.orderno and orders.domesticindicate = '1' and orders.createdate >= to_date( '2013-08-07', 'yyyy-MM-dd') AND orders.createdate <= to_date( '2013-8-7', 'yyyy-MM-dd') + 1 and 1=1 and 1=1 and orders.bookagent in (select orgunitguid from organizationunitprofile start with orgunitguid = '7939' connect by parentguid = prior orgunitguid) order by orders.orderno desc) tem where rownum <= :1

d4ggk0agny9tf SET TRANSACTION READ WRITE

d6fwfwn6jjbsb select distinct pi.orderno, o.contact, o.campaignscriptid, o.domesticindicate, ho.paytype from passengerinfo pi, orders o, hotelorders ho where pi.sendflag is null and pi.orderno=o.orderno and o.orderno=ho.orderno(+) and o.status='E' and o.createdate>to_date('2013-08-06', 'yyyy-mm-dd') and o.createdate<to_date('2013-08-08', 'yyyy-mm-dd')

dugh7uyrn80b4 select * from( select /*+ index(c IX_CHANGE_STATUS_CHANGETYPE) */ c.changeno , c.orderno from change c where c.changetype = 'F' and ( ( substr(c.orderno, 1, 1) = 'C' and c.status = 'H' and c.changestyle = '自愿' ) or ( substr(c.orderno, 1, 1) = 'B' and ( ( c.status = 'V' and c.needpayment = 0 ) or ( c.status = 'H' and c.needpayment = 1 ) ) and c.autoPass is not null ) ) and c.createtime > sysdate - 7 order by c.createtime ) ch where rownum <= 5

f4uf0u8q871js select min(pt.ticketno) as minTicketno, max(pt.ticketno)as maxTicketno, pl.tickettime from psgticket pt, pnrlist pl where pt.orderno = :1 and pt.orderno = pl.orderno and pl.ticketflag = 'S' group by pt.carrier, pl.tickettime

fmbv2fxj0mwuy DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN session_mon; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

fp1vatugjfuym SELECT O.STATUS, P.TICKETNO FROM ORDERS O, PSGTICKET P WHERE O.ORDERNO='C1308070028285' AND P.ORDERNO='C1308070028285'

fr6m3gyy3gwk7 UPDATE PNRLIST SET TICKETFLAG = TICKETFLAG WHERE ORDERNO = :B2 AND PNRNO = :B1 RETURNING TICKETFLAG INTO :O0

ftj9uawt4wwzb select condition from cdef$ where rowid=:1

g128myz1mz13n select 1 from dual where exists (select 1 from orders o where o.orderno = :1 and o.orderflag='C' )

g3yjdvgd23b85 select p.orderno, o.bookUser from payment p, orders o where o.orderno=p.orderno and p.billno = 'CCB020130807794444' and o.bookagent='HR'

gyudauqxd8gqc select ag.ORGAREA ORGAREA from agentarea ag where ag.orgunitguid=:1

SQL Id	SQL Text
04havy07x2m26	select count(*) as changestatustotal from change c, orders o where o.orderno = c.orderno AND C.STATUS ='H' and (c.submituserid = '113907597020'or c.submituserid = '113907597020') and ROWNUM <= 100 AND to_char(c.createtime, 'yyyy-MM-dd')>=to_char(to_date('2013-05-09', 'yyyy-MM-dd'), 'yyyy-MM-dd') AND c.changetype ='F' order by c.createtime desc
09uaa1krtq5by	select f.agentfeereturntype from flightpricedomestic f where f.orderno = :1
0a1z1knkykfwz	select p.psgname, p.pnrno, (select sum(s.mileage) from segmentprice s where s.orderno=:1 )as mileage , e.exchangeid, e.exchangedate from passenger p, exchange e where p.orderno=e.ecsno(+) and p.pnrno=e.pnr(+) and p.orderno=:2 and p.type!=2
14abfzpgc5vkt	select c.refaction, c.basiccontext from controlledaction c, (select ca.refaction, min(ca.priority) priority from (select roleid from userrolesmapping where userguid = 'urcguowp' union select orgrole.roleid from userprofile users, organizationunitprofile orgrole where users.orgunitguid = orgrole.orgunitguid and (users.userguid ='urcguowp') and orgrole.roleid is not null) ur join permissionset ps on ur.roleid = ps.roleid join controlledaction ca on ps.actionid = ca.actionid group by ca.refaction) x where c.refaction = x.refaction and c.priority = x.priority
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1ugz7d875p582	select o.paymode, pb.paystatus, bgw.bankgatewayname, pb.paydate, pb.billno, pb.batchid, pb.uppbillno, pb.batchflag, pb.paymoney, pb.currency, pb.bankcode from payment pm, paybill pb, orders o, bankgateway bgw where pm.orderno = :1 and pm.billno = pb.billno and pm.paystatus != 'D' and pm.orderno = o.orderno and pb.bankgatewaycode = bgw.BANKGATEWAYCODE
21dnq66bcztyr	select (jj.act_jobs_jobs + js.act_jobs_sched) + 0 active_job_proc, greatest (wj.due_jobs + ws.due_sched - jj.act_jobs_jobs - js.act_jobs_sched, 0) + 0 jobs_waiting, greatest (tj.tot_jobs_jobs + ts.tot_jobs_sched - jj.act_jobs_jobs - js.act_jobs_sched - wj.due_jobs - ws.due_sched, 0) + 0 idle_job_procs, (tj.tot_jobs_jobs + ts.tot_jobs_sched) + 0 total_job_procs from (select /+RULE/ count() tot_jobs_jobs from SYS.dba_jobs) tj, (select /+RULE/ count() tot_jobs_sched from SYS.dba_scheduler_jobs) ts, (select /+RULE/ count() act_jobs_jobs from SYS.dba_jobs_running) jj, (select /+RULE/ count() act_jobs_sched from SYS.dba_scheduler_running_jobs) js, (select /+RULE/ count() due_jobs FROM SYS.dba_jobs WHERE next_date < sysdate) wj, (select /+RULE/ count() due_sched FROM SYS.dba_scheduler_jobs WHERE next_run_date < sysdate) ws
25svbmrbjp20g	select g.airport from agentsaleairport g where g.agent in ( select c.city from cityintegration c, (select t.area from cityintegration t where t.city = (select o.code from agentarea a, ORGAREATOCODE o where a.orgunitguid = '4629' and a.ORGAREA = o.orgarea))aaa where aaa.area = c.area union select o.code from agentarea a, ORGAREATOCODE o where a.orgunitguid = '4629' and a.ORGAREA = o.orgarea)
2dqj3rc7b0x8q	select o.Isautocreate from orders o where o.orderno = :1
2ggs3r1ncmwwr	select count(*) as recordscount from orders t where t.bookuser='080009577652' and t.orderflag='C' and t.status in ('C', 'P') and t.createdate>=to_date('2013-02-07', 'yyyy-MM-dd')
2jfqzrxhrm93b	select /+ rule / c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
3af2rnt9q4u9b	select cd.CCRDNO , cd.item, cd.orderno, r.domesticindicate from callcenterdatarecord cd, refundorder r where cd.status='T' and cd.flag='W' and (r.status='R' or r.status='P') and cd.item=r.refundno and cd.orderno=r.orderno
3bf7cptakrtga	select p.orderno from passengerinfo p , orders o where p.orderno = o.orderno and o.orderflag ='B' and o.status = 'E' and o.createdate>sysdate-2 and p.sendflag ='B' group by p.orderno union select p.orderno from passengerinfo p , orders o where p.orderno = o.orderno and o.orderflag ='B' and o.status = 'E' and o.createdate>sysdate-2 and p.sendflag is null group by p.orderno
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
4xcfs63ggs8m0	select CABINS from GENERALIZELINK where MERCHANTID = 'TAOBAO'
4yq6qwgw992zk	select CABINS from GENERALIZELINK where MERCHANTID = 'CZBTOC'
520mkxqpf15q8	select 1 from dual
52ngpnc7n319u	select count(*) from orders o where o.bookuser='580008619967' and o.orderflag='C' and o.status='E' and o.createdate>= date'2013-08-06'
56h11bx91nk74	select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3
58z173u8h1kxc	select count(*) as recordscount from orders t where t.bookuser='580008619967' and t.orderflag='C' and t.status in ('C', 'P') and t.createdate>=to_date('2013-02-07', 'yyyy-MM-dd')
5ansr7r9htpq3	update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1
5f0955qkz78g4	select DOMESTICINDICATE from orders where orderno = :1
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5q9n2yy5aj6hv	select count(*) as orderstatustotail from (select od.orderno, od.domesticindicate, od.status, od.campaignscriptid, fp.totalpaymoney, to_char(od.createdate, 'yyyy-MM-dd') as createdate from orders od, flightpricedomestic fp, segment sm where (od.bookuser in ('13875098898' , '13875098898' , '' )) and od.orderno = fp.orderno and sm.orderno = od.orderno and od.enterpricetype IS NULL and od.createdate >= to_date('2013-05-09', 'yyyy-MM-dd') AND (((1 = 1 and (od.status in ('C', 'P', 'L', 'M'))) or (1=2 and (od.status in ('B', 'T'))) or (1=3 and od.status in ('O', 'R', 'E')) or (1=4 and od.status='D'))) AND od.groupflag='0' group by od.orderno, od.status, fp.totalpaymoney, od.createdate, od.domesticindicate, od.campaignscriptid order by od.createdate desc ) od where rownum < 101
5s3uwrd1gxt7q	SELECT NVL(AG.AGENTTYPE, OU1.FLAG) ouType, OU1.NAME AGENTNAME, (SELECT CL.ALIASNAME FROM CITYLIST CL WHERE CL.LOCALE = 'zh' AND CL.CODE = OU1.CITY) AS CITY, (SELECT OU2.NAME FROM ORGANIZATIONUNITPROFILE OU2 WHERE OU2.ORGUNITGUID = OU1.PARENTGUID) AS PARENTNAME, AG.PURCHASAGENT AS AGENT FROM ORGANIZATIONUNITPROFILE OU1, ORDERS O, AGENTPROFILE AG WHERE O.BOOKAGENT = OU1.ORGUNITGUID AND AG.ORGUNITGUID(+) = OU1.ORGUNITGUID AND O.ORDERNO = :1
5wsn90a3fjnmj	UPDATE batchpay b SET b.pnrvalid = 'N' WHERE b.orderno IN (SELECT bp.orderno FROM batchpay bp, orders o WHERE bp.orderno = o.orderno AND o.createdate < SYSDATE - 24/24 AND (bp.pnrvalid = 'Y' OR bp.pnrvalid IS NULL)GROUP BY bp.orderno)
67jr1q3uanf6w	select count(*) from orders o where o.bookuser='080009577652' and o.orderflag='C' and o.status='E' and o.createdate>= date'2013-08-06'
69subccxd9b03	SELECT signature, inuse_features, flags FROM sql$ WHERE signature = :1
6mcpb06rctk0x	call dbms_space.auto_space_advisor_job_proc ( )
6u1fc9nj87uhd	SELECT S.SEGORDER, (S.CARRIER \|\| S.FLIGHTNO) FLIGHTNO, S.PLANETYPE, S.CABIN, S.DEPTIME FLIGHTDATE, (select a.name from airportslist a where a.code = s.depairport and a.locale = 'zh') DEPAIRPORT, (select a.name from airportslist a where a.code = s.arrairport and a.locale = 'zh') ARRAIRPORT, to_char(s.deptime, 'HH24MI') DEPTIME, to_char(s.arrtime, 'HH24MI') ARRTIME, s.depairport DEPAIRPORTCODE, s.arrairport ARRAIRPORTCODE, (SELECT AP.OPENETICKET FROM AIRPORTSLIST AP WHERE AP.CODE = S.DEPAIRPORT AND AP.LOCALE = 'zh') AS EFLAG FROM SEGMENT S WHERE S.ORDERNO = :1 ORDER BY S.SEGORDER ASC
6wytwy7ry0jsb	UPDATE ORDERS SET TICKETOUTAGENT = BOOKAGENT WHERE ORDERNO = :B1
73fhvwt6xvk2x	select distinct pi.orderno from passengerinfo pi, orders o where pi.sendflag is null and pi.orderno=o.orderno and o.status='D' and o.createdate>to_date('2013-08-06', 'yyyy-mm-dd') and o.createdate<to_date('2013-08-08', 'yyyy-mm-dd')
74mb2gqrm9xb6	select c.refaction, c.basiccontext from controlledaction c, (select ca.refaction, min(ca.priority) priority from (select roleid from userrolesmapping where userguid = 'shewangh' union select orgrole.roleid from userprofile users, organizationunitprofile orgrole where users.orgunitguid = orgrole.orgunitguid and (users.userguid ='shewangh') and orgrole.roleid is not null) ur join permissionset ps on ur.roleid = ps.roleid join controlledaction ca on ps.actionid = ca.actionid group by ca.refaction) x where c.refaction = x.refaction and c.priority = x.priority
78txh8n821266	select 1 from dual where exists (select 1 from paxinsurance p where p.orderno = :1 )
7jk3kcjxvz83k	UPDATE PAYBILL SET PAYSTATUS = PAYSTATUS WHERE BILLNO = :B1 RETURNING PAYSTATUS INTO :O0
7ncnu7ud2ykhu	insert into ORDERS (domesticindicate, orderflag, adultnum, groupname, payreceived, paymoney, childnum, enterpricetype, campaignscriptid, transactor, bookusername, memberno, contact, originalorderno, remarkno, bookagent, seatnum, emailflag, submitpricetime, infantnum, bookagentname, paymode, createdate, deliverstatus, tickettimelimit, shipagent, refbyorder, transactorname, reforder, ticketoutagent, campaigntype, noteflag, attribute5, attribute4, refticket, attribute3, groupflag, attribute2, isautocreate, attribute1, transactorcardno, status, gxhtype, parentorderno, bookuser, orderno) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 )
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7qkh5ucsbcqk6	select sum(o.seatnum) from orders o, segment s where o.bookuser='080009577652' and o.orderno=s.orderno and o.status='D' and s.cabin in ('R', 'O', 'X', 'N') and o.createdate>= date'2013-08-06'
7qwgyfxhnaxna	select originalorderno from orders p where p.orderno='C1307090026705'
81h1tf5rjb8jr	select pt.segorder, p.type, count(*) as refundnum from psgticket pt, passenger p where pt.orderno = p.orderno and pt.psgname = p.psgname and pt.orderno = p.orderno and pt.refundno is not null and pt.orderno = :1 group by pt.segorder, p.type order by pt.segorder, p.type asc
83bank242m66q	select o.campaignscriptid from orders o where o.groupflag = '0' and o.domesticindicate = 1 and o.orderno = 'B1308070079473'
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
87tu7wk540dwq	select MAX_THREAD_COUNT from partener_interface p where p.partnerid='QQ' and p.interfaceid='AVPRICE_JAXB'
89nf3yvxk8yq7	select /+ rule / rownum, sid, serial, locking_sid, locking_serial, lock_type, lock_mode, lock_request_mode, object_wanted, instance, host, pid, db_user, os_user, client_machine, program, blocked_sql_hash, blocked_sql, lock_event, seconds_in_wait from (select l.sid sid, s.serial# serial, l.locking_sid locking_sid, s1.serial# locking_serial, l.lock_type lock_type, DECODE (l.lock_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_mode, DECODE (l.lock_request_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_request_mode, decode(s.p2text, 'object #', u1.name \|\| '.' \|\| o1.name, decode(u.name \|\| '.' \|\| o.name, '.', null, u.name \|\| '.' \|\| o.name)) object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, s.sql_hash_value blocked_sql_hash, substr(ses.sql_text, 1, 100) blocked_sql, s.event lock_event, s.seconds_in_wait seconds_in_wait from (select /+ ordered / l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l1.inst_id inst_id, l2.inst_id locking_inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l, sys.gv_$session s, sys.gv_$session s1, sys.gv_$instance i, SYS.obj$ o, sys.obj$ o1, SYS.user$ u, SYS.user$ u1, sys.gv_$sql ses where l.sid = s.sid and l.locking_sid = s1.sid and u.user#(+) = o.owner# and u1.user#(+) = o1.owner# and o.obj#(+) = s.row_wait_obj# and o1.obj#(+) = s.p2 and s.sql_hash_value = ses.hash_value(+) and s.inst_id = l.inst_id and i.inst_id = l.inst_id and s1.inst_id = l.locking_inst_id union select lc.locking_sid sid, s.serial# serial, null locking_sid, null locking_serial, null lock_type, null lock_mode, null lock_request_mode, null object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, null blocked_sql_hash, null blocked_sql, null lock_event, null seconds_in_wait from (select /+ ordered / distinct locking_sid, null, null, null, null, inst_id from ( select l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l2.inst_id inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l where not exists (select 1 from sys.gv_$lock where sid=l.locking_sid and inst_id=l.inst_id and request > 0 and type in ('TX', 'TM'))) lc, sys.gv_$session s, sys.gv_$instance i where lc.locking_sid = s.sid and s.inst_id = lc.inst_id and i.inst_id = lc.inst_id) where seconds_in_wait > :1 or locking_sid is null
8kvgs3007httw	select /+ rule / decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, INSTR(b.NAME, '/', -1, 1)+1), substr(b.name, INSTR(b.NAME, '\', -1, 1)+1)) file_file_name, decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, 1, INSTR(b.NAME, '/', -1, 1)-1), substr(b.name, 1, INSTR(b.NAME, '\', -1, 1)-1)) file_file_path, b.NAME file_file_full_name, b.file# file_file_id, d.name file_tablespace, DECODE(d.contents$, 0, (DECODE (BITAND (d.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') file_tbs_contents, a.PHYRDS file_read_requests, a.PHYWRTS file_write_requests, a.PHYBLKRD file_physical_reads, a.PHYBLKWRT file_physical_writes, a.SINGLEBLKRDS file_single_block_reads, a.READTIM/100 file_read_time, a.WRITETIM/100 file_write_time, decode(nvl(a.PHYBLKRD, 0), 0, 0, 10a.READTIM/a.PHYBLKRD) file_avg_read_time, decode(nvl(a.PHYBLKWRT, 0), 0, 0, 10a.WRITETIM/a.PHYBLKWRT) file_avg_write_time, decode(nvl(a.PHYBLKRD+a.PHYBLKWRT, 0), 0, 0, 10(a.READTIM+a.WRITETIM)/(a.PHYBLKRD+a.PHYBLKWRT)) file_avg_io_time, a.SINGLEBLKRDTIM/100 file_single_block_read_time, a.LSTIOTIM/100 file_last_io_time, a.MINIOTIM/100 file_min_single_io_time, a.MAXIORTM/100 file_max_single_read_time, a.MAXIOWTM/100 file_max_single_write_time, decode((c.total_data_io+e.total_temp_io), 0, 0, 100nvl((a.PHYWRTS+a.PHYRDS), 0)/(c.total_data_io+e.total_temp_io)) file_physical_io_pct, decode((c.total_data_reads+e.total_temp_reads), 0, 0, 100nvl(a.PHYBLKRD, 0)/(c.total_data_reads+e.total_temp_reads)) file_physical_reads_pct, decode((c.total_data_writes+e.total_temp_writes), 0, 0, 100nvl(a.PHYBLKWRT, 0)/(c.total_data_writes+e.total_temp_writes)) file_physical_writes_pct from sys.v_$filestat a, sys.v_$datafile b, (select nvl(sum(PHYBLKRD), 0) total_data_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_data_io, nvl(sum(PHYBLKWRT), 0) total_data_writes from sys.V_$FILESTAT) c, (select nvl(sum(PHYBLKRD), 0) total_temp_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_temp_io, nvl(sum(PHYBLKWRT), 0) total_temp_writes from sys.V_$TEMPSTAT) e, sys.ts$ d where a.file#=b.file# and b.ts#=d.ts# and BITAND (d.flags, 16) <> 16 and nvl(b.bytes, 0) > 0 union select /+ rule / decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, INSTR(b.NAME, '/', -1, 1)+1), substr(b.name, INSTR(b.NAME, '\', -1, 1)+1)) file_file_name, decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, 1, INSTR(b.NAME, '/', -1, 1)-1), substr(b.name, 1, INSTR(b.NAME, '\', -1, 1)-1)) file_file_path, b.NAME file_file_full_name, b.file# file_file_id, d.name file_tablespace, DECODE(d.contents$, 0, (DECODE (BITAND (d.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') file_tbs_contents, a.PHYRDS file_read_requests, a.PHYWRTS file_write_requests, a.PHYBLKRD file_physical_reads, a.PHYBLKWRT file_physical_writes, a.SINGLEBLKRDS file_single_block_reads, a.READTIM/100 file_read_time, a.WRITETIM/100 file_write_time, decode(nvl(a.PHYBLKRD, 0), 0, 0, 10a.READTIM/a.PHYBLKRD) file_avg_read_time, decode(nvl(a.PHYBLKWRT, 0), 0, 0, 10a.WRITETIM/a.PHYBLKWRT) file_avg_write_time, decode(nvl(a.PHYBLKRD+a.PHYBLKWRT, 0), 0, 0, 10(a.READTIM+a.WRITETIM)/(a.PHYBLKRD+a.PHYBLKWRT)) file_avg_io_time, a.SINGLEBLKRDTIM/100 file_single_block_read_time, a.LSTIOTIM/100 file_last_io_time, a.MINIOTIM/100 file_min_single_io_time, a.MAXIORTM/100 file_max_single_read_time, a.MAXIOWTM/100 file_max_single_write_time, decode((c.total_data_io+e.total_temp_io), 0, 0, 100nvl((a.PHYWRTS+a.PHYRDS), 0)/(c.total_data_io+e.total_temp_io)) file_physical_io_pct, decode((c.total_data_reads+e.total_temp_reads), 0, 0, 100nvl(a.PHYBLKRD, 0)/(c.total_data_reads+e.total_temp_reads)) file_physical_reads_pct, decode((c.total_data_writes+e.total_temp_writes), 0, 0, 100nvl(a.PHYBLKWRT, 0)/(c.total_data_writes+e.total_temp_writes)) file_physical_writes_pct from sys.v_$tempstat a, sys.v_$tempfile b, (select nvl(sum(PHYBLKRD), 0) total_data_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_data_io, nvl(sum(PHYBLKWRT) , 0) total_data_writes from sys.V_$FILESTAT) c, (select nvl(sum(PHYBLKRD), 0) total_temp_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_temp_io, nvl(sum(PHYBLKWRT), 0) total_temp_writes from sys.V_$TEMPSTAT) e, sys.ts$ d where a.file#=b.file# and b.ts#=d.ts# and nvl(b.bytes, 0) > 0 union select /+ rule / decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, INSTR(b.NAME, '/', -1, 1)+1), substr(b.name, INSTR(b.NAME, '\', -1, 1)+1)) file_file_name, decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, 1, INSTR(b.NAME, '/', -1, 1)-1), substr(b.name, 1, INSTR(b.NAME, '\', -1, 1)-1)) file_file_path, b.NAME file_file_full_name, b.file# file_file_id, d.name file_tablespace, DECODE(d.contents$, 0, (DECODE (BITAND (d.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') file_tbs_contents, a.PHYRDS file_read_requests, a.PHYWRTS file_write_requests, a.PHYBLKRD file_physical_reads, a.PHYBLKWRT file_physical_writes, a.SINGLEBLKRDS file_single_block_reads, a.READTIM/100 file_read_time, a.WRITETIM/100 file_write_time, decode(nvl(a.PHYBLKRD, 0), 0, 0, 10a.READTIM/a.PHYBLKRD) file_avg_read_time, decode(nvl(a.PHYBLKWRT, 0), 0, 0, 10a.WRITETIM/a.PHYBLKWRT) file_avg_write_time, decode(nvl(a.PHYBLKRD+a.PHYBLKWRT, 0), 0, 0, 10(a.READTIM+a.WRITETIM)/(a.PHYBLKRD+a.PHYBLKWRT)) file_avg_io_time, a.SINGLEBLKRDTIM/100 file_single_block_read_time, a.LSTIOTIM/100 file_last_io_time, a.MINIOTIM/100 file_min_single_io_time, a.MAXIORTM/100 file_max_single_read_time, a.MAXIOWTM/100 file_max_single_write_time, decode((c.total_data_io+e.total_temp_io), 0, 0, 100nvl((a.PHYWRTS+a.PHYRDS), 0)/(c.total_data_io+e.total_temp_io)) file_physical_io_pct, decode((c.total_data_reads+e.total_temp_reads), 0, 0, 100nvl(a.PHYBLKRD, 0)/(c.total_data_reads+e.total_temp_reads)) file_physical_reads_pct, decode((c.total_data_writes+e.total_temp_writes), 0, 0, 100nvl(a.PHYBLKWRT, 0)/(c.total_data_writes+e.total_temp_writes)) file_physical_writes_pct from sys.v_$filestat a, sys.v_$datafile b, (select nvl(sum(PHYBLKRD), 0) total_data_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_data_io, nvl(sum(PHYBLKWRT), 0) total_data_writes from sys.V_$FILESTAT) c, (select nvl(sum(PHYBLKRD), 0) total_temp_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_temp_io, nvl(sum(PHYBLKWRT), 0) total_temp_writes from sys.V_$TEMPSTAT) e, sys.ts$ d, sys.v_$parameter p where a.file#=b.file# and b.ts#=d.ts# and BITAND (d.flags, 16)=16 and nvl(b.bytes, 0) > 0 and p.name = 'undo_tablespace' and upper(p.value) = upper(d.name)
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
8whvjha2fnk63	SELECT F.TOTALPRICE, F.AGENTFEE, F.AIRPORTTAX, F.PHASEAGENTFEE, F.PHASEAGENTFEESTART, F.PHASEAGENTFEEEND, F.ENDORSEMENT, F.CHENDORSEMENT, F.INENDORSEMENT, F.FUELTAX, F.FILENO, F.CHFILENO, F.INFILENO, F.ADUSECONDITION, F.CHUSECONDITION, F.INUSECONDITION, F.BIZFEE, F.BIZFEEREMARK, F.TOTALCOST, F.TOTALPAYMONEY, F.BOOKINFO, F.OTHERFEE, F.OTHERFEEREMARK, F.CONFIRMMESSAGE, F.BASISREMARK, F.TOURCODE, F.TOTALMILEAGE, (case when F.TOTALLUGGAGECHARGE is null then 0 else F.TOTALLUGGAGECHARGE end ) as TOTALLUGGAGECHARGE FROM FLIGHTPRICEDOMESTIC F WHERE F.ORDERNO = :1
8zr60wpvdvbtu	select /+index(orders IDX_CREATEDATE_STATUS)/pnrlist.orderno, pnrlist.pnrno, orders.campaignscriptid , orders.orderflag from orders, pnrlist where orders.orderno = pnrlist.orderno and orders.orderno like '%8' and orders.status in('B', 'T') and orders.createdate>sysdate-30 and ( pnrlist.ticketflag is null or ( Ticketflag = 'P' and (TicketTime is null or (sysdate - tickettime) > 1/48)) or ( Ticketflag = 'T' and (TicketTime is null or (sysdate - tickettime) > 1/288))) and rownum <= 100
90yfsh8rb8gma	select p.TYPE from paxinsurance p where p.orderno = :1
95bdypfq2ky5g	select o.domesticindicate from orders o where o.orderno = :1
95v76f5muyjjg	select originalorderno from orders p where p.orderno=''
9awmqbn8w5tkq	SELECT O.STATUS, P.TICKETNO FROM ORDERS O, PSGTICKET P WHERE O.ORDERNO='C1308070027006' AND P.ORDERNO='C1308070027006'
9b2r0p9d97p92	select sum(t.seatnum) from orders t, segment s where t.bookuser='080009577652' and t.orderno=s.orderno and t.orderflag='C' and t.status in ('D', 'N'，'S', 'C', 'P') and t.createdate >= date'2013-08-07'
9nz14w8x5fsfd	BEGIN PROCESSORDER.CallBackByBank(:1); COMMIT; END;
9nztpwka2vvp4	SELECT SP.ORDERNO, SP.SEGORDER, SP.TRANSFERINDICATE, SP.ADULTPRICE, SP.CHILDPRICE, SP.INFANTPRICE, SP.ADULTCOST, SP.CHILDCOST, SP.INFANTCOST, SP.BASICFEERATE, SP.CHBASICFEERATE, SP.INBASICFEERATE, SP.XFEERATE, SP.APPENDFEERATE, SP.PHASEFEERATE, SP.AIRPORTTAX, nvl(SP.ORIGINADULTFUELTAX, 0) ORIGINADULTFUELTAX, nvl(SP.ADULTFUELTAX, 0) ADULTFUELTAX, nvl(SP.CHILDFUELTAX, 0) CHILDFUELTAX, nvl(SP.INFANTFUELTAX, 0) INFANTFUELTAX, SP.ADULTDISPLAYPRICE, SP.CHILDDISPLAYPRICE, SP.INFANTDISPLAYPRICE, SP.ADULTFAREBASIS, SP.CHILDFAREBASIS, SP.INFANTFAREBASIS, sp.adultbaggageallow, sp.childbaggageallow, sp.infantbaggageallow, (SP.CARRIER \|\| SP.FLIGHTNO) FLIGHTNO, (SELECT AP.OPENETICKET FROM AIRPORTSLIST AP WHERE AP.CODE = SP.DEPAIRPORT AND AP.LOCALE = 'zh') AS EFLAG, (select a.name from airportslist a where a.code = SP.DEPAIRPORT AND a.LOCALE = 'zh') DEPAIRPORT, (select a.name from airportslist a where a.code = SP.ARRAIRPORT AND a.LOCALE = 'zh') ARRAIRPORT, to_char(SP.FLIGHTDATE, 'HH24:MI') DEPTIME, to_char(SP.ARRTIME, 'HH24:MI') ARRTIME, SP.DEPAIRPORT DEPAIRPORTCODE, SP.ARRAIRPORT ARRAIRPORTCODE, SP.CABIN, SP.FLIGHTDATE FROM SEGMENTPRICE SP WHERE SP.ORDERNO = :1 ORDER BY SP.SEGORDER ASC
9q7k9nbpvk8pv	SELECT NVL(SUM(TIME_WAITED/1000), 0) FROM SYS.DBA_HIST_ACTIVE_SESS_HISTORY S, SYS.WRH$_SEG_STAT_OBJ SO, SYS.WRM$_SNAPSHOT SN , SYS.OBJ$ OBJ WHERE SN.SNAP_ID = S.SNAP_ID AND SN.DBID = S.DBID AND SN.BEGIN_INTERVAL_TIME >= (CURRENT_TIMESTAMP - NUMTODSINTERVAL(30, 'day')) AND S.CURRENT_OBJ# = SO.OBJ# AND S.WAIT_CLASS = 'User I/O' AND S.WAIT_TIME = 0 AND SO.DATAOBJ# = :B1 AND OBJ.OBJ# = SO.OBJ# AND OBJ.DATAOBJ# = SO.DATAOBJ#
9tzrcb1d5f06z	SELECT O.ORDERNO, O.GROUPFLAG, O.GROUPNAME, o.CAMPAIGNSCRIPTID, O.TRANSACTOR, O.CONTACT, O.BOOKAGENT, O.BOOKAGENTNAME, O.STATUS, O.CREATEDATE, O.REFORDER, O.REFBYORDER, O.REFTICKET, O.ADULTNUM, O.CHILDNUM, O.INFANTNUM, nvl(O.Isautocreate, '0') Isautocreate , O.ORIGINALORDERNO, O.ORDERFLAG, O.CAMPAIGNSCRIPTID, O.ATTRIBUTE2, O.ATTRIBUTE1 FROM ORDERS O WHERE O.ORDERNO = :1
9upvznnp7xgsj	SELECT BG.BANKGATEWAYNAME AS bank, PS.LARGECLIENTID AS bigClientCode, PB.BILLNO AS billNo, OD.ORDERNO AS bookTktNum, PB.CURRENCY AS currency, case when od.groupflag='1' then 'Y' else 'N' end as GroupFlag FROM ORDERS OD , ( SELECT PT.PSGNAME AS PSGNAME, PT.ORDERNO AS ORDERNO FROM PSGTICKET PT WHERE PT.TICKETNO = :1 AND ROWNUM = 1) TICKET , PASSENGER PS , PAYMENT PY , PAYBILL PB , BANKGATEWAY BG WHERE OD.ORDERNO = TICKET.ORDERNO AND OD.ORDERNO = PS.ORDERNO AND PS.ORDERNO = TICKET.ORDERNO AND PS.PSGNAME = TICKET.PSGNAME AND OD.ORDERNO = PY.ORDERNO AND PY.BILLNO = PB.BILLNO AND PB.PAYSTATUS='P' AND BG.BANKGATEWAYCODE = PB.BANKGATEWAYCODE
a7pqvnr44uy38	SELECT HO.PAYMONEY, HO.HOTELORDERNO, HO.PAYTYPE , CASE HO.PAYTYPE WHEN 'C' THEN '前台现付' ELSE '网上支付' END AS PAYTYPEINFO , CASE WHEN HO.PAYTYPE = 'C' THEN F.TOTALPAYMONEY WHEN HO.PAYTYPE = 'E' AND O.PAYMONEY IS NULL THEN F.TOTALPAYMONEY + HO.PAYMONEY ELSE O.PAYMONEY END AS ORDERPAYMONEY FROM HOTELORDERS HO , FLIGHTPRICEDOMESTIC F , ORDERS O WHERE HO.ORDERNO = F.ORDERNO AND O.ORDERNO = HO.ORDERNO AND HO.ORDERNO = :1
ab5gtgnqyskp7	select o.campaignscriptid from orders o where o.orderno = :1
am19a1bvysghh	select (jj.act_jobs_jobs + js.act_jobs_sched) + 0 active_job_proc, greatest (wj.due_jobs + ws.due_sched - jj.act_jobs_jobs - js.act_jobs_sched, 0) + 0 jobs_waiting, greatest (tj.tot_jobs_jobs + ts.tot_jobs_sched - jj.act_jobs_jobs - js.act_jobs_sched - wj.due_jobs - ws.due_sched, 0) + 0 idle_job_procs, (tj.tot_jobs_jobs + ts.tot_jobs_sched) + 0 total_job_procs from (select /+RULE/ count() tot_jobs_jobs from SYS.dba_jobs) tj, (select /+RULE/ count() tot_jobs_sched from SYS.dba_scheduler_jobs) ts, (select /+RULE/ count() act_jobs_jobs from SYS.dba_jobs_running) jj, (select /+RULE/ count() act_jobs_sched from SYS.dba_scheduler_running_jobs) js, (select /+RULE/ count() due_jobs FROM SYS.dba_jobs WHERE next_date > sysdate-365 and next_date < sysdate) wj, (select /+RULE/ count() due_sched FROM SYS.dba_scheduler_jobs WHERE next_run_date > sysdate-365 and next_run_date < sysdate) ws
az33m61ym46y4	SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name
b0d1f3vqvdca7	select /+ rule / rownum, sid, serial, locking_sid, locking_serial, lock_type, lock_mode, lock_request_mode, object_wanted, instance, host, pid, db_user, os_user, client_machine, program, blocked_sql_hash, blocked_sql, lock_event, seconds_in_wait from (select l.sid sid, s.serial# serial, l.locking_sid locking_sid, s1.serial# locking_serial, l.lock_type lock_type, DECODE (l.lock_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_mode, DECODE (l.lock_request_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_request_mode, decode(s.p2text, 'object #', u1.name \|\| '.' \|\| o1.name, decode(u.name \|\| '.' \|\| o.name, '.', null, u.name \|\| '.' \|\| o.name)) object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, s.sql_hash_value blocked_sql_hash, substr(ses.sql_text, 1, 100) blocked_sql, s.event lock_event, s.seconds_in_wait seconds_in_wait from (select /+ ordered / l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l1.inst_id inst_id, l2.inst_id locking_inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l, sys.gv_$session s, sys.gv_$session s1, sys.gv_$instance i, SYS.obj$ o, sys.obj$ o1, SYS.user$ u, SYS.user$ u1, sys.gv_$sql ses where l.sid = s.sid and l.locking_sid = s1.sid and u.user#(+) = o.owner# and u1.user#(+) = o1.owner# and o.obj#(+) = s.row_wait_obj# and o1.obj#(+) = s.p2 and s.sql_hash_value = ses.hash_value(+) and s.inst_id = l.inst_id and i.inst_id = l.inst_id and s1.inst_id = l.locking_inst_id union select lc.locking_sid sid, s.serial# serial, null locking_sid, null locking_serial, null lock_type, null lock_mode, null lock_request_mode, null object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, null blocked_sql_hash, null blocked_sql, null lock_event, null seconds_in_wait from (select /+ ordered / distinct locking_sid, null, null, null, null, inst_id from ( select l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l2.inst_id inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l where not exists (select 1 from sys.gv_$lock where sid=l.locking_sid and inst_id=l.inst_id and request > 0 and type in ('TX', 'TM'))) lc, sys.gv_$session s, sys.gv_$instance i where lc.locking_sid = s.sid and s.inst_id = lc.inst_id and i.inst_id = lc.inst_id) where seconds_in_wait > :1 or locking_sid is null
bhvwd3sbwdyga	select f.isautoconfirm from flightpricedomestic f where f.orderno = :1
bhwz3x2mjy7s3	SELECT PL.PNRNO FROM PNRLIST PL WHERE PL.ORDERNO = :1
bs6q10hmtbh49	select bs.billno, bs.bankflowid, bs.paymoney, bs.bankgatewaycode, bs.bankcode, bs.orderstatus status from banksettleorder bs where bs.orderstatus in ('A', 'B', 'C') and bs.settlestatus is null and bs.bankgatewaycode ='CMB' and bs.errcount < 5 order by bs.errcount, bs.billno asc
bt51szvfrcdpn	SELECT obj_type, plan_id, comp_data FROM sqlobj$data WHERE signature = :1 AND category = :2
btrs48n39rhcd	select cd.CCRDNO, cd.item, cd.orderno, c.changetype from callcenterdatarecord cd, change c where cd.status='S' and cd.flag='W' and c.status='E' and cd.item=c.changeno and cd.orderno=c.orderno
bunvx480ynf57	SELECT 1 FROM DUAL
buzp8cfu6upry	SELECT C.CHANGENO, C.ORDERNO, C.CHANGETYPE, C.STATUS, C.CREATETIME, C.DEALTIME, C.SUBMITUSERNAME, C.BOOKAGENTNAME FROM CHANGE C WHERE C.DOMESTICINDICATE='0' AND ROWNUM <= 500 AND ROWNUM <= 301 AND C.CREATETIME >= to_date('2013-08-06', 'yyyy-MM-dd') AND C.CREATETIME <= to_date('2013-08-07', 'yyyy-MM-dd') + 1 AND C.STATUS = ( CASE 'S' WHEN 'A' THEN 'F' ELSE 'S' END ) AND 1=1 ORDER BY C.CREATETIME DESC
c5jycdptb6cj3	select sum(o.seatnum) from orders o, segment s where o.bookuser='580008619967' and o.orderno=s.orderno and o.status='D' and s.cabin in ('R', 'O', 'X', 'N') and o.createdate>= date'2013-08-06'
c6ksc6kfhjjc6	with ash_samples as ( SELECT /+ full(@SEL$2383FF78, ASH@SEL$2) / sample_id, ash.instance_number instance_id, sql_id, sql_exec_id, sample_time FROM DBA_HIST_ACTIVE_SESS_HISTORY ash, V$DATABASE db, DBA_HIST_SNAPSHOT s WHERE ash.dbid = (select dbid from V$DATABASE) AND mod(ash.sample_id, :1) = 0 AND ash.snap_id = s.snap_id AND ash.dbid = s.dbid AND ash.instance_number = s.instance_number AND s.end_interval_time > (TO_TIMESTAMP(:2, 'YYYY-MM-DD HH24:MI:SS:FF6') at TIME ZONE dbtimezone) - 7 ) SELECT total_exec_count, activity_rate, activity_rate_over FROM (SELECT sum(exec_cnt)+1 total_exec_count FROM ( SELECT (case when next_exec_id>sql_exec_id then (next_exec_id - sql_exec_id) else 0 end) exec_cnt FROM ( SELECT sql_exec_id, lead(sql_exec_id, 1, 0) over (partition by instance_id order by sample_time NULLS last) next_exec_id FROM ash_samples WHERE sql_id = :3 ) ) ) sql_count_query, (SELECT sql_count/sample_total activity_rate FROM ( SELECT count() sample_total, sum(case when sql_id=:4 then 1 else 0 end) sql_count FROM ash_samples ) ) sql_activity_query, (SELECT over_count/ash_sample_count activity_rate_over FROM ( SELECT count() ash_sample_count, sum(case when total >= s.value2 then 1 else 0 end) over_count FROM ( SELECT instance_id, count() total, sum(case when sql_id=:5 then 1 else 0 end) sql_count FROM ash_samples a GROUP BY a.sample_id, a.instance_id ) t, gv$osstat s where t.instance_id = s.inst_id and s.stat_name = 'NUM_CPUS' and t.sql_count > 0 ) ) sql_activity_over_2cpu_query
ckg1n91hh2qkk	select o.pricefileno from flightpricedomestic o where o.orderno = :1
ckh0xnga85szg	select * from ( select /+USE_NL(orders, f)/ orders.orderno, orders.status, orders.groupflag, f.totalcost, f.fileno, orders.contact, orders.adultnum as adultnum, orders.childnum, orders.infantnum, orders.bookagentname from orders, flightpricedomestic f where orders.orderno = f.orderno and orders.domesticindicate = '1' and orders.createdate >= to_date( '2013-08-07', 'yyyy-MM-dd') AND orders.createdate <= to_date( '2013-8-7', 'yyyy-MM-dd') + 1 and 1=1 and 1=1 and orders.bookagent in (select orgunitguid from organizationunitprofile start with orgunitguid = '7939' connect by parentguid = prior orgunitguid) order by orders.orderno desc) tem where rownum <= :1
d4ggk0agny9tf	SET TRANSACTION READ WRITE
d6fwfwn6jjbsb	select distinct pi.orderno, o.contact, o.campaignscriptid, o.domesticindicate, ho.paytype from passengerinfo pi, orders o, hotelorders ho where pi.sendflag is null and pi.orderno=o.orderno and o.orderno=ho.orderno(+) and o.status='E' and o.createdate>to_date('2013-08-06', 'yyyy-mm-dd') and o.createdate<to_date('2013-08-08', 'yyyy-mm-dd')
dugh7uyrn80b4	select * from( select /+ index(c IX_CHANGE_STATUS_CHANGETYPE) / c.changeno , c.orderno from change c where c.changetype = 'F' and ( ( substr(c.orderno, 1, 1) = 'C' and c.status = 'H' and c.changestyle = '自愿' ) or ( substr(c.orderno, 1, 1) = 'B' and ( ( c.status = 'V' and c.needpayment = 0 ) or ( c.status = 'H' and c.needpayment = 1 ) ) and c.autoPass is not null ) ) and c.createtime > sysdate - 7 order by c.createtime ) ch where rownum <= 5
f4uf0u8q871js	select min(pt.ticketno) as minTicketno, max(pt.ticketno)as maxTicketno, pl.tickettime from psgticket pt, pnrlist pl where pt.orderno = :1 and pt.orderno = pl.orderno and pl.ticketflag = 'S' group by pt.carrier, pl.tickettime
fmbv2fxj0mwuy	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN session_mon; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fp1vatugjfuym	SELECT O.STATUS, P.TICKETNO FROM ORDERS O, PSGTICKET P WHERE O.ORDERNO='C1308070028285' AND P.ORDERNO='C1308070028285'
fr6m3gyy3gwk7	UPDATE PNRLIST SET TICKETFLAG = TICKETFLAG WHERE ORDERNO = :B2 AND PNRNO = :B1 RETURNING TICKETFLAG INTO :O0
ftj9uawt4wwzb	select condition from cdef$ where rowid=:1
g128myz1mz13n	select 1 from dual where exists (select 1 from orders o where o.orderno = :1 and o.orderflag='C' )
g3yjdvgd23b85	select p.orderno, o.bookUser from payment p, orders o where o.orderno=p.orderno and p.billno = 'CCB020130807794444' and o.bookagent='HR'
gyudauqxd8gqc	select ag.ORGAREA ORGAREA from agentarea ag where ag.orgunitguid=: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

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	8,398	2.33	0.04
Batched IO (full) vector count	8,713	2.41	0.05
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	206,362	57.18	1.10
Batched IO buffer defrag count	677	0.19	0.00
Batched IO double miss count	23,564	6.53	0.13
Batched IO same unit count	49,572	13.74	0.26
Batched IO single block count	15,000	4.16	0.08
Batched IO slow jump count	4,499	1.25	0.02
Batched IO vector block count	149,656	41.47	0.80
Batched IO vector read count	4,207	1.17	0.02
Block Cleanout Optim referenced	3,161	0.88	0.02
CCursor + sql area evicted	3,233	0.90	0.02
CPU used by this session	860,457	238.42	4.59
CPU used when call started	540,454	149.75	2.88
CR blocks created	31,316	8.68	0.17
Cached Commit SCN referenced	581,589	161.15	3.10
Clusterwide global transactions	16	0.00	0.00
Clusterwide global transactions spanning RAC nodes	0	0.00	0.00
Commit SCN cached	10,260	2.84	0.05
DB time	27,813,417	7,706.64	148.22
DBWR checkpoint buffers written	61,143	16.94	0.33
DBWR checkpoints	142	0.04	0.00
DBWR fusion writes	19,830	5.49	0.11
DBWR object drop buffers written	207	0.06	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	1,737	0.48	0.01
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	1,062	0.29	0.01
DBWR undo block writes	42,121	11.67	0.22
DFO trees parallelized	798	0.22	0.00
DX/BB enqueue lock background get time	14	0.00	0.00
DX/BB enqueue lock background gets	32	0.01	0.00
DX/BB enqueue lock foreground requests	293	0.08	0.00
DX/BB enqueue lock foreground wait time	14	0.00	0.00
Effective IO time	456,636,087	126,526.27	2,433.38
GTX processes spawned by autotune	0	0.00	0.00
GTX processes stopped by autotune	0	0.00	0.00
HSC Heap Segment Block Changes	350,283	97.06	1.87
HSC IDL Compressed Blocks	10,280	2.85	0.05
Heap Segment Array Inserts	5,540	1.54	0.03
LOB table id lookup cache misses	3	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	58,504	16.21	0.31
PX local messages recv'd	7,503	2.08	0.04
PX local messages sent	7,503	2.08	0.04
PX remote messages recv'd	6,993	1.94	0.04
PX remote messages sent	2,518	0.70	0.01
Parallel operations not downgraded	832	0.23	0.00
RowCR - row contention	871	0.24	0.00
RowCR attempts	119,402	33.08	0.64
RowCR hits	175,400	48.60	0.93
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	17	0.00	0.00
SQL*Net roundtrips to/from client	5,032,219	1,394.34	26.82
SQL*Net roundtrips to/from dblink	0	0.00	0.00
active txn count during cleanout	88,679	24.57	0.47
application wait time	163,872	45.41	0.87
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	45,314	12.56	0.24
branch node splits	10	0.00	0.00
buffer is not pinned count	395,940,462	109,708.52	2,109.94
buffer is pinned count	2,626,739,530	727,825.86	13,997.71
bytes received via SQL*Net from client	399,822,877	110,784.27	2,130.63
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	575,775,729	159,537.88	3,068.27
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	1,965,949	544.73	10.48
calls to kcmgas	627,556	173.89	3.34
calls to kcmgcs	304,015	84.24	1.62
cell physical IO interconnect bytes	157,821,641,216	43,729,753.16	841,020.18
change write time	2,608	0.72	0.01
cleanout - number of ktugct calls	50,268	13.93	0.27
cleanouts and rollbacks - consistent read gets	27,702	7.68	0.15
cleanouts only - consistent read gets	10,335	2.86	0.06
cluster key scan block gets	189,386	52.48	1.01
cluster key scans	127,263	35.26	0.68
cluster wait time	435,640	120.71	2.32
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	30,304	8.40	0.16
commit batch/immediate requested	30,304	8.40	0.16
commit cleanout failures: block lost	2,427	0.67	0.01
commit cleanout failures: buffer being written	7	0.00	0.00
commit cleanout failures: callback failure	2,108	0.58	0.01
commit cleanout failures: cannot pin	405	0.11	0.00
commit cleanouts	316,321	87.65	1.69
commit cleanouts successfully completed	311,374	86.28	1.66
commit immediate performed	30,304	8.40	0.16
commit immediate requested	30,304	8.40	0.16
commit txn count during cleanout	74,874	20.75	0.40
concurrency wait time	24,480,511	6,783.14	130.45
consistent changes	189,635	52.54	1.01
consistent gets	582,807,476	161,486.26	3,105.74
consistent gets - examination	23,295,100	6,454.68	124.14
consistent gets direct	7,394,756	2,048.96	39.41
consistent gets from cache	575,412,712	159,437.30	3,066.33
consistent gets from cache (fastpath)	546,227,385	151,350.53	2,910.81
cursor authentications	29,216	8.10	0.16
data blocks consistent reads - undo records applied	86,586	23.99	0.46
db block changes	1,928,183	534.27	10.28
db block gets	2,463,964	682.72	13.13
db block gets direct	24,148	6.69	0.13
db block gets from cache	2,439,816	676.03	13.00
db block gets from cache (fastpath)	579,645	160.61	3.09
deferred (CURRENT) block cleanout applications	96,892	26.85	0.52
dirty buffers inspected	11,417	3.16	0.06
enqueue conversions	21,671	6.00	0.12
enqueue deadlocks	0	0.00	0.00
enqueue releases	1,232,526	341.51	6.57
enqueue requests	1,234,446	342.04	6.58
enqueue timeouts	1,675	0.46	0.01
enqueue waits	4,969	1.38	0.03
exchange deadlocks	791	0.22	0.00
execute count	1,873,145	519.02	9.98
failed probes on index block reclamation	3	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	7,120,899,129	1,973,082.77	37,946.76
frame signature mismatch	0	0.00	0.00
free buffer inspected	12,050,042	3,338.87	64.21
free buffer requested	12,252,949	3,395.09	65.30
gc blocks compressed	176,831	49.00	0.94
gc blocks lost	1	0.00	0.00
gc cr block flush time	7,700	2.13	0.04
gc cr block receive time	116,333	32.23	0.62
gc cr blocks received	165,682	45.91	0.88
gc cr blocks served	149,312	41.37	0.80
gc current block flush time	1,474	0.41	0.01
gc current block pin time	1,589	0.44	0.01
gc current block receive time	142,991	39.62	0.76
gc current blocks received	471,421	130.62	2.51
gc current blocks served	225,473	62.47	1.20
gc kbytes saved	526,155	145.79	2.80
gc kbytes sent	2,472,116	684.98	13.17
gc local grants	10,677,452	2,958.54	56.90
gc remote grants	900,438	249.50	4.80
gcs messages sent	2,640,237	731.57	14.07
ges messages sent	140,077	38.81	0.75
global enqueue get time	18,255,871	5,058.40	97.28
global enqueue gets async	26,733	7.41	0.14
global enqueue gets sync	2,069,190	573.34	11.03
global enqueue releases	2,065,191	572.23	11.01
heap block compress	4,937	1.37	0.03
hot buffers moved to head of LRU	3,321,922	920.45	17.70
immediate (CR) block cleanout applications	38,039	10.54	0.20
immediate (CURRENT) block cleanout applications	26,738	7.41	0.14
index crx upgrade (positioned)	177	0.05	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	5,261	1.46	0.03
index fetch by key	13,922,471	3,857.69	74.19
index scans kdiixs1	113,335,042	31,403.26	603.95
leaf node 90-10 splits	394	0.11	0.00
leaf node splits	1,772	0.49	0.01
lob reads	22,189	6.15	0.12
lob writes	21,142	5.86	0.11
lob writes unaligned	21,142	5.86	0.11
logons cumulative	2,609	0.72	0.01
max cf enq hold time	15	0.00	0.00
messages received	230,694	63.92	1.23
messages sent	230,692	63.92	1.23
min active SCN optimization applied on CR	12,964	3.59	0.07
no buffer to keep pinned count	1,292	0.36	0.01
no work - consistent read gets	557,765,121	154,547.44	2,972.29
non-idle wait count	16,809,745	4,657.70	89.58
non-idle wait time	26,755,123	7,413.40	142.58
opened cursors cumulative	1,856,187	514.32	9.89
parse count (describe)	80	0.02	0.00
parse count (failures)	2,713	0.75	0.01
parse count (hard)	181,422	50.27	0.97
parse count (total)	1,471,425	407.71	7.84
parse time cpu	65,238	18.08	0.35
parse time elapsed	22,706,043	6,291.47	121.00
physical read IO requests	1,407,675	390.04	7.50
physical read bytes	154,664,296,448	42,854,905.41	824,194.91
physical read total IO requests	1,448,535	401.36	7.72
physical read total bytes	155,749,903,360	43,155,709.04	829,980.03
physical read total multi block requests	145,453	40.30	0.78
physical reads	18,879,919	5,231.31	100.61
physical reads cache	11,484,803	3,182.25	61.20
physical reads cache prefetch	10,382,960	2,876.95	55.33
physical reads direct	7,395,116	2,049.06	39.41
physical reads direct (lob)	57	0.02	0.00
physical reads direct temporary tablespace	360	0.10	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	56,992	15.79	0.30
physical write bytes	1,068,777,472	296,140.47	5,695.44
physical write total IO requests	206,010	57.08	1.10
physical write total bytes	2,071,737,856	574,044.12	11,040.14
physical write total multi block requests	3,555	0.99	0.02
physical writes	130,466	36.15	0.70
physical writes direct	24,508	6.79	0.13
physical writes direct (lob)	63	0.02	0.00
physical writes direct temporary tablespace	14,077	3.90	0.08
physical writes from cache	105,958	29.36	0.56
physical writes non checkpoint	108,656	30.11	0.58
pinned buffers inspected	538	0.15	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	1,385,663	383.94	7.38
process last non-idle time	3,601	1.00	0.02
queries parallelized	679	0.19	0.00
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	3,251,237	900.86	17.33
recursive cpu usage	366,098	101.44	1.95
redo KB read	446,714	123.78	2.38
redo blocks checksummed by FG (exclusive)	101,011	27.99	0.54
redo blocks written	743,743	206.08	3.96
redo buffer allocation retries	4	0.00	0.00
redo entries	1,040,517	288.31	5.54
redo log space requests	5	0.00	0.00
redo log space wait time	14	0.00	0.00
redo ordering marks	41,502	11.50	0.22
redo size	331,664,036	91,898.59	1,767.41
redo size for direct writes	9,002,328	2,494.40	47.97
redo subscn max counts	8,142	2.26	0.04
redo synch long waits	25,055	6.94	0.13
redo synch time	123,381	34.19	0.66
redo synch time (usec)	1,233,929,845	341,901.45	6,575.52
redo synch writes	85,821	23.78	0.46
redo wastage	36,854,356	10,211.73	196.39
redo write broadcast ack count	67,809	18.79	0.36
redo write broadcast ack time	166,052,603	46,010.42	884.88
redo write broadcast lgwr post count	6	0.00	0.00
redo write time	37,556	10.41	0.20
redo writes	137,326	38.05	0.73
remote Oradebug requests	2	0.00	0.00
rollback changes - undo records applied	57,341	15.89	0.31
rollbacks only - consistent read gets	5,054	1.40	0.03
root node splits	0	0.00	0.00
rows fetched via callback	2,327,270	644.85	12.40
scheduler wait time	483,092	133.86	2.57
session connect time	0	0.00	0.00
session cursor cache hits	574,724	159.25	3.06
session logical reads	585,271,612	162,169.03	3,118.87
shared hash latch upgrades - no wait	1,384,504	383.62	7.38
shared hash latch upgrades - wait	1,343	0.37	0.01
sorts (disk)	0	0.00	0.00
sorts (memory)	2,121,094	587.72	11.30
sorts (rows)	247,241,831	68,506.60	1,317.53
sql area evicted	155,262	43.02	0.83
sql area purged	2,313	0.64	0.01
summed dirty queue length	13,834	3.83	0.07
switch current to new buffer	16,128	4.47	0.09
table fetch by rowid	1,446,745,530	400,869.14	7,709.60
table fetch continued row	1,123,295	311.25	5.99
table scan blocks gotten	151,893,785	42,087.24	809.43
table scan rows gotten	12,220,678,907	3,386,146.97	65,123.12
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	61	0.02	0.00
table scans (long tables)	410	0.11	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	128,222	35.53	0.68
temp space allocated (bytes)	5,242,880	1,452.71	27.94
total cf enq hold time	7,535	2.09	0.04
total number of cf enq holders	375	0.10	0.00
total number of slots	0	0.00	0.00
total number of times SMON posted	755	0.21	0.00
transaction lock background gets	450	0.12	0.00
transaction lock foreground requests	450	0.12	0.00
transaction lock foreground wait time	66	0.02	0.00
transaction rollbacks	30,135	8.35	0.16
transaction tables consistent read rollbacks	12	0.00	0.00
transaction tables consistent reads - undo records applied	298	0.08	0.00
undo change vector size	114,458,672	31,714.60	609.94
user I/O wait time	721,578	199.94	3.85
user calls	5,543,534	1,536.02	29.54
user commits	58,567	16.23	0.31
user rollbacks	129,088	35.77	0.69
workarea executions - onepass	4	0.00	0.00
workarea executions - optimal	1,513,090	419.25	8.06
write clones created in background	1	0.00	0.00
write clones created in foreground	22	0.01	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	378,553,070,208	379,508,273,712
session cursor cache count	31,506,371	31,535,369
session uga memory	279,034,938,040,344	279,206,950,168,384
opened cursors current	3,673	5,221
workarea memory allocated	3,929	2,428
logons current	559	818
session uga memory max	3,512,199,929,552	3,519,418,778,536
session pga memory	281,321,954,688	282,266,448,016

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	1	1.00

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Buffer Cache Reads	87.5G	373.71	24.8272	0M	0.00	0M	1101.4K	5.69
Direct Reads	56.4G	16.21	16.0004	1M	0.00	.000277	0
Others	1G	11.33	.287058	630M	2.98	.174562	45.5K	2.69
DBWR	0M	0.00	0M	830M	15.54	.229979	0
LGWR	0M	0.00	0M	363M	38.37	.100581	137.3K	2.26
Direct Writes	0M	0.00	0M	155M	0.20	.042947	0
TOTAL:	144.9G	401.25	41.1147	1.9G	57.09	.548348	1284.3K	5.22

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	143.7G	391.00	40.7772	914M	15.66	.253254	3.62	36.76
Log File	437M	0.12	.121085	362M	38.36	.100304	20.00	42.15
Control File	566M	10.02	.156829	157M	2.78	.043502	2.74	176.00
Archive Log	0M	0.00	0M	436M	0.12	.120808
Temp File	190M	0.09	.052645	110M	0.14	.030479	10.41	15.43
Other	0M	0.01	0M	0M	0.02	0M	0.08
TOTAL:	144.9G	401.24	41.1078	1.9G	57.09	.548348	3.59	36.75

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Buffer Cache Reads	87.5G	373.67	24.8161	0M	0.00	0M	1095.9K	5.62
Buffer Cache Reads (Data File)	87.5G	373.67	24.8161	0M	0.00	0M	1095.9K	5.62
Direct Reads	56.3G	16.17	15.9633	1M	0.00	.000277	0
Direct Reads (Data File)	56.3G	16.17	15.9633	1M	0.00	.000277	0
Others	1G	11.32	.287058	630M	2.97	.174562	40.4K	2.69
Others (Control File)	566M	10.02	.156829	157M	2.78	.043502	36.2K	2.75
Others (Archive Log)	0M	0.00	0M	436M	0.12	.120808	0
Others (Log File)	436M	0.12	.120808	0M	0.00	0M	4	29.75
Others (Data File)	34M	1.18	.009420	37M	0.07	.010252	4269	2.14
DBWR	0M	0.00	0M	830M	15.54	.229979	0
DBWR (Data File)	0M	0.00	0M	830M	15.54	.229979	0
LGWR	0M	0.00	0M	363M	38.37	.100581	19	1.58
LGWR (Log File)	0M	0.00	0M	362M	38.36	.100304	4	0.75
LGWR (Control File)	0M	0.00	0M	1M	0.01	.000277	15	1.80
Direct Writes	0M	0.00	0M	155M	0.20	.042947	0
Direct Writes (Data File)	0M	0.00	0M	155M	0.20	.042947	0
TOTAL:	144.7G	401.17	41.0665	1.9G	57.07	.548348	1136.3K	5.51

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
COREDATA	937,315	260	4.09	18.79	19,728	5	75,251	4.19
CORE_INDEX	164,226	46	6.92	1.37	16,134	4	3,503	164.10
USERS	160,301	44	5.94	3.94	8,641	2	1,131	182.51
SYSAUX	107,678	30	3.99	3.26	4,822	1	0	0.00
SYSTEM	27,176	8	2.90	1.09	1,246	0	1,939	688.61
QUEST	5,056	1	2.95	1.30	1,412	0	0	0.00
UNDOTBS1	365	0	12.79	1.00	4,522	1	106	1.51
AMSDATA	2,625	1	2.03	1.00	0	0	0	0.00
ETS_TMP	2,292	1	3.24	1.00	0	0	0	0.00
TEMP	271	0	13.47	89.23	516	0	0	0.00
UNDOTBS2	101	0	4.65	1.00	0	0	3,350	12.05
AMSINDEX	34	0	2.94	1.00	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
AMSDATA	+DATADG/COREDB/datafile/amsdata.297.786494983	2,625	1	2.03	1.00	0	0	0	0.00
AMSINDEX	+DATADG/COREDB/datafile/amsindex.298.786495075	34	0	2.94	1.00	0	0	0	0.00
COREDATA	+DATADG/COREDB/datafile/COREDATA.270.730202259	115,108	32	3.81	20.72	2,015	1	2,204	2.98
COREDATA	+DATADG/COREDB/datafile/COREDATA.271.730202435	110,347	31	4.08	21.53	2,434	1	3,473	3.27
COREDATA	+DATADG/COREDB/datafile/COREDATA.272.730202619	119,504	33	3.83	20.72	2,669	1	3,640	4.03
COREDATA	+DATADG/COREDB/datafile/COREDATA.273.730202791	108,910	30	3.82	20.94	3,018	1	2,751	3.50
COREDATA	+DATADG/COREDB/datafile/COREDATA.274.730202937	117,246	32	3.82	19.10	2,571	1	3,220	3.62
COREDATA	+DATADG/COREDB/datafile/COREDATA.283.745515419	112,568	31	3.89	20.57	1,969	1	2,964	3.06
COREDATA	+DATADG/COREDB/datafile/COREDATA.295.783256433	85,011	24	4.66	15.90	599	0	15,061	3.20
COREDATA	+DATADG/COREDB/datafile/COREDATA.296.783257507	82,222	23	4.71	16.26	1,130	0	13,958	3.39
COREDATA	+DATADG/COREDB/datafile/COREDATA.305.796495117	51,967	14	4.57	12.26	1,795	0	15,337	4.52
COREDATA	+DATADG/COREDB/datafile/COREDATA.307.803139899	34,432	10	4.71	6.30	1,528	0	12,643	6.92
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.276.730204269	14,635	4	6.58	1.32	1,068	0	314	454.43
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.277.730204109	17,027	5	6.06	1.28	1,315	0	175	42.11
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.280.730204413	14,809	4	5.96	1.28	1,820	1	438	248.90
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.281.730204551	13,054	4	6.10	1.32	1,273	0	119	153.36
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.282.730204685	16,116	4	5.40	1.28	989	0	143	642.17
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.286.745515665	14,817	4	5.60	1.31	860	0	16	233.13
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.291.771353279	14,101	4	6.51	1.40	1,925	1	59	52.71
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.292.771353509	8,914	2	7.23	1.64	565	0	215	425.12
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.293.783255523	12,967	4	7.95	1.38	1,305	0	24	15.83
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.294.783255951	11,872	3	8.12	1.38	1,423	0	914	19.65
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.302.796411061	9,196	3	9.01	1.49	832	0	237	64.68
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.303.796493979	8,990	2	9.48	1.53	1,780	0	293	45.22
CORE_INDEX	+DATADG/COREDB/datafile/CORE_index.306.803129617	7,728	2	9.66	1.50	979	0	556	108.83
ETS_TMP	+DATADG/COREDB/datafile/ets_tmp.275.730287209	2,292	1	3.24	1.00	0	0	0	0.00
QUEST	+DATADG/COREDB/datafile/quest.289.748266187	5,056	1	2.95	1.30	1,412	0	0	0.00
SYSAUX	+DATADG/COREDB/datafile/sysaux.260.729362609	91,935	25	3.70	2.86	4,425	1	0	0.00
SYSAUX	+DATADG/COREDB/datafile/sysaux.301.787835057	15,743	4	5.68	5.59	397	0	0	0.00
SYSTEM	+DATADG/COREDB/datafile/system.259.729362599	27,176	8	2.90	1.09	1,246	0	1,939	688.61
TEMP	+DATADG/COREDB/tempfile/temp.262.729362685	271	0	13.47	89.23	516	0	0
UNDOTBS1	+DATADG/COREDB/datafile/undotbs1.261.744737439	365	0	12.79	1.00	4,522	1	106	1.51
UNDOTBS2	+DATADG/COREDB/datafile/undotbs2.263.744738251	101	0	4.65	1.00	0	0	3,350	12.05
USERS	+DATADG/COREDB/datafile/users.264.730203979	21,807	6	7.03	4.16	1,242	0	230	85.61
USERS	+DATADG/COREDB/datafile/users.278.730203631	23,926	7	5.68	3.76	1,743	0	98	404.49
USERS	+DATADG/COREDB/datafile/users.279.730203813	24,125	7	5.91	3.75	1,480	0	68	67.21
USERS	+DATADG/COREDB/datafile/users.287.733311617	24,575	7	6.73	3.82	1,029	0	471	117.26
USERS	+DATADG/COREDB/datafile/users.288.733311861	21,747	6	6.85	4.59	941	0	218	390.55
USERS	+DATADG/COREDB/datafile/users.290.745515943	20,483	6	6.93	4.44	942	0	28	29.64
USERS	+DATADG/COREDB/datafile/users.300.787832331	8,091	2	2.96	4.32	614	0	1	320.00
USERS	+DATADG/COREDB/datafile/users.304.796494633	7,572	2	2.99	3.29	84	0	6	143.33
USERS	+DATADG/COREDB/datafile/users.308.803140519	7,975	2	2.32	2.09	566	0	11	12.73

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	1,833,220	98	577,545,030	11,486,185	105,958	0	0	85,302

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 130,466

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	59,406	0

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

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	3	8124	62380	355732	2488320	355732			2
E	0	2	8147	64868	284971	2488320	284971			2

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	1,536	0.10	181	52.44	96,362,713	1	644172644.00
D	3,072	0.20	363	29.53	54,270,823	1	360324790.00
D	4,608	0.30	544	16.72	30,721,060	1	201516255.00
D	6,144	0.40	726	9.34	17,167,990	1	110120743.00
D	7,680	0.49	907	5.15	9,457,025	1	58121632.00
D	9,216	0.59	1,089	2.99	5,491,581	1	31380549.00
D	10,752	0.69	1,270	1.95	3,589,452	1	18553488.00
D	12,288	0.79	1,452	1.44	2,646,158	1	12192362.00
D	13,824	0.89	1,633	1.17	2,151,213	1	8854681.00
D	15,360	0.99	1,814	1.01	1,861,445	1	6900622.00
D	15,552	1.00	1,837	1.00	1,837,686	1	6740409.00
D	16,896	1.09	1,996	0.91	1,671,378	1	5618903.00
D	18,432	1.19	2,177	0.83	1,533,534	1	4689348.00
D	19,968	1.28	2,359	0.78	1,427,792	1	3976271.00
D	21,504	1.38	2,540	0.73	1,344,369	1	3413707.00
D	23,040	1.48	2,722	0.69	1,275,180	1	2947131.00
D	24,576	1.58	2,903	0.66	1,217,463	1	2557914.00
D	26,112	1.68	3,084	0.63	1,165,254	1	2205842.00
D	27,648	1.78	3,266	0.61	1,119,152	1	1894953.00
D	29,184	1.88	3,447	0.59	1,078,687	1	1622072.00
D	30,720	1.98	3,629	0.56	1,025,249	1	1261713.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
99.96	50,534	19

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	6,144	3,548	3,003.42	1.74	0.06	100.00	0.00	629,140
E	6,144	2,989	3,885.05	2.66	0.07	100.00	0.00	629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	1,461,926	1,461,926	0
64K	128K	8,848	8,848	0
128K	256K	1,212	1,212	0
256K	512K	608	608	0
512K	1024K	18,361	18,361	0
1M	2M	22,033	22,033	0
2M	4M	40	40	0
4M	8M	36	32	4
8M	16M	31	31	0
16M	32M	23	23	0
32M	64M	4	4	0

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
768	0.13	117,155,307.52	44,019,529.25	73.00	2,439,463	158,484,161,249
1,536	0.25	117,155,307.52	41,058,806.32	74.00	2,267,102	155,572,865,047
3,072	0.50	117,155,307.52	364,238.11	100.00	1,706	115,557,657,714
4,608	0.75	117,155,307.52	343,080.02	100.00	0	115,536,852,845
6,144	1.00	117,155,307.52	250,273.50	100.00	0	115,445,595,652
7,373	1.20	117,155,307.52	245,883.02	100.00	0	115,441,278,467
8,602	1.40	117,155,307.52	245,883.02	100.00	0	115,441,278,467
9,830	1.60	117,155,307.52	245,883.02	100.00	0	115,441,278,467
11,059	1.80	117,155,307.52	245,883.02	100.00	0	115,441,278,467
12,288	2.00	117,155,307.52	245,883.02	100.00	0	115,441,278,467
18,432	3.00	117,155,307.52	245,883.02	100.00	0	115,441,278,467
24,576	4.00	117,155,307.52	245,883.02	100.00	0	115,441,278,467
36,864	6.00	117,155,307.52	245,883.02	100.00	0	115,441,278,467
49,152	8.00	117,155,307.52	245,883.02	100.00	0	115,441,278,467

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.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
8,640	1.00	459	31,205	63,226,566	1.00	2,555,950	1.00	1,940,877
9,600	1.11	1,360	86,656	63,302,747	1.00	2,479,769	0.97	3,847,851
10,496	1.21	2,255	135,731	63,426,175	1.00	2,356,341	0.92	3,868,144
11,392	1.32	3,150	185,240	63,501,120	1.00	2,281,396	0.89	3,881,581
12,288	1.42	4,046	234,472	63,543,604	1.01	2,238,912	0.88	3,890,159
13,184	1.53	4,941	283,089	63,569,579	1.01	2,212,937	0.87	3,896,087
14,080	1.63	5,837	332,127	63,586,816	1.01	2,195,700	0.86	3,900,494
14,976	1.73	6,733	381,380	63,599,292	1.01	2,183,224	0.85	3,903,955
15,872	1.84	7,628	430,389	63,609,026	1.01	2,173,490	0.85	3,906,795
16,704	1.93	8,524	478,922	63,617,179	1.01	2,165,337	0.85	3,909,228
17,664	2.04	9,420	527,765	63,624,350	1.01	2,158,166	0.84	3,911,382

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
12,288	0.50	386,558,497	54,270,884,678
15,360	0.63	136,353,081	17,168,021,984
18,432	0.75	57,613,653	5,491,554,462
21,504	0.88	38,423,391	2,646,082,813
24,576	1.00	32,972,960	1,837,685,126
27,648	1.13	30,846,205	1,533,548,238
30,720	1.25	29,570,151	1,344,450,438
33,792	1.38	28,712,854	1,217,466,396
36,864	1.50	27,855,557	1,078,721,169
39,936	1.63	27,417,017	1,025,244,532
43,008	1.75	27,149,939	1,025,244,532
46,080	1.88	27,110,371	1,025,244,532
49,152	2.00	27,097,183	1,025,244,532

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
64	0.50	0	0	0	0
128	1.00	0	0	0	0
192	1.50	0	0	0	0
256	2.00	0	0	0	0
320	2.50	0	0	0	0
384	3.00	0	0	0	0
448	3.50	0	0	0	0
512	4.00	0	0	0	0
576	4.50	0	0	0	0
640	5.00	0	0	0	0
704	5.50	0	0	0	0
768	6.00	0	0	0	0
832	6.50	0	0	0	0
896	7.00	0	0	0	0
960	7.50	0	0	0	0
1,024	8.00	0	0	0	0
1,088	8.50	0	0	0	0
1,152	9.00	0	0	0	0
1,216	9.50	0	0	0	0
1,280	10.00	0	0	0	0

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

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	81,257	2,364	29
system undo header	477	68	143
undo header	3,312	40	12
undo block	139	1	5
1st level bmb	100	0	1
2nd level bmb	2	0	30

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	409	409	0	381	1,619	4,250.21
SQ-Sequence Cache	1,952	1,952	0	290	1,246	4,296.52
US-Undo Segment	255	255	0	117	329	2,811.24
PV-KSV slave startup (syncstart)	29	29	0	2	29	14,561.00
TX-Transaction (index contention)	537	537	0	363	24	67.29
CO-KTUCLO Master Slave enq (master slave det)	1,132	0	1,132	1,132	19	16.72
TH-Threshold Chain (metric threshold evaluation)	141	141	0	1	15	15,265.00
PR-Process Startup	98	98	0	2	11	5,471.50
CF-Controlfile Transaction	10,255	10,250	5	352	9	24.89
PS-PX Process Reservation	6,253	5,788	465	984	4	3.89
TD-KTF map table enqueue (KTF dump entries)	11	11	0	11	2	211.45
TX-Transaction	97,468	97,469	1	230	2	7.84
KO-Multiple Object Checkpoint (fast object checkpoint)	1,413	1,413	0	502	1	1.35
TT-Tablespace	15,464	15,464	0	141	0	3.31
WF-AWR Flush	446	424	22	22	0	19.50
FB-Format Block	182	182	0	88	0	2.26
RO-Multiple Object Reuse (fast object reuse)	144	144	0	43	0	4.05
DR-Distributed Recovery	2	2	0	2	0	80.50
HW-Segment High Water Mark	3,639	3,639	0	68	0	1.54
JQ-Job Queue	40	36	4	1	0	53.00
TO-Temp Object	309	309	0	55	0	0.67
CR-Reuse Block Range (block range reuse ckpt)	1,069	1,069	0	21	0	1.52
TM-DML	280,486	280,441	46	34	0	0.88
TX-Transaction (allocate ITL entry)	29	29	0	26	0	0.92
OD-Online DDLs (Serializing DDLs)	31	31	0	16	0	1.44
MD-Materialized View Log DDL	46	46	0	23	0	0.70
SK-Shrink Segment	32	32	0	19	0	0.74
PI-Remote PX Process Spawn Status	16	16	0	8	0	1.25
PE-Parameter	24	24	0	6	0	1.50
PG-Global Parameter	12	12	0	6	0	1.00
TK-Auto Task Serialization (Auto Task Serialization)	6	6	0	6	0	1.00
TA-Instance Undo	23	23	0	5	0	1.00
AF-Advisor Framework (task serialization)	412	412	0	4	0	1.00
MW-MWIN Schedule	2	2	0	2	0	1.00
TS-Temporary Segment	18	18	0	4	0	0.25

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	40.94	97,275	2,739	89	180/180	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
07-8月 22:59	8,088	17,425	1,556	7	180	0/0	0/0/0/0/0/0
07-8月 22:49	7,479	18,893	2,739	89	180	0/0	0/0/0/0/0/0
07-8月 22:39	2,434	6,590	2,092	86	180	0/0	0/0/0/0/0/0
07-8月 22:29	6,468	16,485	1,471	9	180	0/0	0/0/0/0/0/0
07-8月 22:19	6,266	18,083	869	9	180	0/0	0/0/0/0/0/0
07-8月 22:09	10,200	19,799	1,026	9	180	0/0	0/0/0/0/0/0

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	5	0.00		0	0
ASM Keyed state latch	3,800	0.34	0.00	0	0
ASM allocation	833	0.00		0	0
ASM db client latch	10,602	0.00		0	0
ASM map headers	21	0.00		0	0
ASM map load waiting list	6	0.00		0	0
ASM map operation freelist	10,272	0.00		0	0
ASM map operation hash table	3,461,070	0.00	0.06	0	0
ASM network background latch	2,092	0.00		0	0
ASM network state latch	437	0.00		0	0
AWR Alerted Metric Element list	68,028	0.00		0	0
Change Notification Hash table latch	1,199	0.00		0	0
Consistent RBA	137,335	0.00	0.00	0	0
DML lock allocation	171,563,018	0.35	0.00	0	0
Event Group Locks	2,034	0.00		0	0
FAL Queue	98	0.00		0	0
FIB s.o chain latch	30	0.00		0	0
FOB s.o list latch	19,108	0.26	0.00	0	0
File State Object Pool Parent Latch	5	0.00		0	0
I/O Staticstics latch	5	0.00		0	0
IPC other latch	30	0.00		0	0
IPC stats buffer allocation latch	6,602	0.00		0	7,540	0.08
In memory undo latch	5	0.00		0	0
JS Sh mem access	13	0.00		0	0
JS broadcast add buf latch	16,891	0.00		0	0
JS broadcast drop buf latch	16,891	0.00		0	0
JS broadcast load blnc latch	16,787	0.00		0	0
JS mem alloc latch	12	0.00		0	0
JS queue access latch	17	0.00		0	0
JS queue state obj latch	604,332	0.00		0	0
JS slv state obj latch	185	0.00		0	0
KFC FX Hash Latch	5	0.00		0	0
KFC Hash Latch	5	0.00		0	0
KFCL LE Freelist	5	0.00		0	0
KFK SGA Libload latch	1,392	0.00		0	0
KFMD SGA	7	0.00		0	0
KGNFS-NFS:SHM structure	5	0.00		0	0
KGNFS-NFS:SVR LIST	5	0.00		0	0
KJC message pool free list	131,576	0.12	0.02	0	29,662	0.01
KJCT flow control latch	2,454,467	0.02	0.01	0	0
KMG MMAN ready and startup request latch	32,042	0.00		0	0
KMG resize request state object freelist	16	0.00		0	0
KSXR large replies	232	0.00		0	0
KTF sga latch	34	0.00		0	1,181	0.00
KWQMN job cache list latch	362	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	29	0.00		0	0
KWQS pqueue ctx latch	59	0.00		0	0
Locator state objects pool parent latch	5	0.00		0	0
Lsod array latch	24,486	0.24	0.00	0	0
MQL Tracking Latch	0			0	71	0.00
Memory Management Latch	31,121	0.00		0	32,041	0.00
Memory Queue	5	0.00		0	0
Memory Queue Message Subscriber #1	5	0.00		0	0
Memory Queue Message Subscriber #2	5	0.00		0	0
Memory Queue Message Subscriber #3	5	0.00		0	0
Memory Queue Message Subscriber #4	5	0.00		0	0
Memory Queue Subscriber	5	0.00		0	0
MinActiveScn Latch	1,209	0.00		0	0
Mutex	5	0.00		0	0
Mutex Stats	5	0.00		0	0
OS process	5,906	0.00		0	0
OS process allocation	11,340	0.08	0.00	0	0
OS process: request allocation	3,800	0.11	0.00	0	0
PL/SQL warning settings	53,383	0.00	0.00	0	0
PX hash array latch	5	0.00		0	0
QMT	5	0.00		0	0
Real-time plan statistics latch	22,475	0.01	0.00	0	1	0.00
Reserved Space Latch	4	0.00		0	0
Result Cache: RC Latch	11	0.00		0	0
SGA IO buffer pool latch	112	0.00		0	116	0.00
SGA blob parent	5	0.00		0	0
SGA bucket locks	5	0.00		0	0
SGA heap locks	5	0.00		0	0
SGA pool locks	5	0.00		0	0
SQL memory manager latch	5	0.00		0	3,549	0.00
SQL memory manager workarea list latch	458,302	0.00		0	0
Shared B-Tree	286	0.00		0	0
Streams Generic	5	0.00		0	0
Testing	5	0.00		0	0
Token Manager	5	0.00		0	0
WCR: sync	5	0.00		0	0
Write State Object Pool Parent Latch	5	0.00		0	0
X$KSFQP	5	0.00		0	0
XDB NFS Security Latch	5	0.00		0	0
XDB unused session pool	5	0.00		0	0
XDB used session pool	5	0.00		0	0
active checkpoint queue latch	40,694	0.84	0.00	0	0
active service list	6,315,291	0.02	0.05	0	1,040,717	0.01
alert log latch	2	0.00		0	0
archive control	352	0.00		0	0
archive process latch	295	0.00		0	0
begin backup scn array	459	0.00		0	0
buffer pool	14	0.00		0	0
business card	1,669	0.00		0	0
cache buffer handles	107,815	0.01	0.00	0	0
cache buffers chains	1,179,213,190	0.18	0.01	1	92,405,822	0.00
cache buffers lru chain	1,855,755	0.08	0.08	0	91,026,858	0.06
cache table scan latch	354,597	0.01	0.03	0	354,595	0.01
call allocation	31,068	0.11	0.37	0	0
cas latch	5	0.00		0	0
change notification client cache latch	5	0.00		0	0
channel handle pool latch	3,878	0.34	0.00	0	0
channel operations parent latch	3,658,444	0.00	0.06	0	0
checkpoint queue latch	3,029,697	0.00	0.02	0	314,770	0.00
client/application info	20,672	0.00		0	0
compile environment latch	2,618	0.00		0	0
corrupted undo seg latch	202,272	0.02	0.03	0	0
cp cmon/server latch	5	0.00		0	0
cp pool latch	5	0.00		0	0
cp server hash latch	5	0.00		0	0
cp sga latch	395	0.00		0	0
cvmap freelist lock	5	0.00		0	0
deferred cleanup latch	395	0.00		0	0
dml lock allocation	407	0.00		0	0
done queue latch	5	0.00		0	0
dummy allocation	4,982	0.00		0	0
enqueue hash chains	3,115,958	0.02	0.20	0	3,708	0.00
enqueues	1,703,617	0.04	0.01	0	0
error message lists	3,975	0.03	0.00	0	0
fifth spare latch	5	0.00		0	0
file cache latch	1,268	0.00		0	0
flashback copy	5	0.00		0	0
fourth Audit Vault latch	5	0.00		0	0
gc element	9,787,550	0.07	0.05	0	3,385,094	0.04
gcs commit scn state	5	0.00		0	0
gcs opaque info freelist	666,216	0.03	0.00	0	0
gcs partitioned table hash	29,313,981	0.11	0.00	0	10,621,521	0.00
gcs pcm hashed value bucket hash	5	0.00		0	0
gcs remaster request queue	83	0.00		0	0
gcs remastering latch	4,114,236	0.99	0.00	0	2,723	3.38
gcs resource freelist	542,806	0.02	0.00	0	81,304	0.00
gcs resource hash	25,896,480	0.01	0.01	0	423	0.00
gcs resource scan list	1,058	0.00		0	0
gcs shadows freelist	189,177	0.00	0.00	0	122,215	0.00
ges caches resource lists	934,164	0.03	0.04	0	458,928	0.02
ges deadlock list	37,130	0.00		0	53,292	0.00
ges domain table	4,287,721	0.00	0.00	0	0
ges enqueue table freelist	4,224,794	0.01	0.02	0	0
ges group table	4,151,984	0.00	0.01	0	0
ges process hash list	162,933	0.00	0.43	0	0
ges process parent latch	8,591,134	0.00	0.00	0	1	0.00
ges process table freelist	3,800	0.03	0.00	0	0
ges resource hash list	6,738,735	0.03	0.31	3	87,933	0.01
ges resource scan list	7,057	0.01	0.00	0	0
ges resource table freelist	115,385	0.00		0	0
ges timeout list	23,236	0.16	0.08	0	4,141	0.00
ges value block free list	3,441	0.00		0	0
global KZLD latch for mem in SGA	1,626	0.00		0	0
global tx hash mapping	255	0.00		0	0
granule operation	5	0.00		0	0
hash table column usage latch	2,075	0.10	0.00	0	5,813,640	0.02
hash table modification latch	300	0.00		0	0
heartbeat check	5	0.00		0	2,587	0.12
heartbeat structure management	0			0	709	0.00
internal temp table object number allocation latch	77	0.00		0	0
interrupt manipulation	7,637	0.00		0	0
intra txn parallel recovery	5	0.00		0	0
io pool granule metadata list	5	0.00		0	0
job workq parent latch	41	0.00		0	36	0.00
job_queue_processes free list latch	77	0.00		0	0
job_queue_processes parameter latch	16,878	0.00		0	0
k2q global data latch	2,475	0.00		0	0
k2q lock allocation	378	0.00		0	0
kcbtsemkid latch	1	0.00		0	0
kdlx hb parent latch	5	0.00		0	0
kgb parent	5	0.00		0	0
kgnfs mount latch	5	0.00		0	0
kokc descriptor allocation latch	79,301	0.00		0	0
krbmrosl	2	0.00		0	0
ksfv messages	5	0.00		0	0
ksim group membership cache	2,925	0.00		0	0
ksim membership request latch	368	0.00		0	3,139	0.00
kss move lock	63	0.00		0	0
ksuosstats global area	258	0.00		0	0
ksv allocation latch	508	0.00		0	0
ksv class latch	6,690	0.00		0	0
ksv instance latch	4	0.00		0	0
ksv msg queue latch	11	0.00		0	6	0.00
ksxp shared latch	3,800	0.13	0.00	0	0
ksxp so latch	3,800	0.18	0.00	0	0
ksz_so allocation latch	3,800	0.97	0.00	0	0
ktm global data	1,593	0.00		0	0
kwqbsn:qsga	124	0.00		0	0
lgwr LWN SCN	154,789	0.02	0.00	0	0
list of block allocation	2,606	0.00		0	0
loader state object freelist	666	0.00		0	0
lob segment dispenser latch	5	0.00		0	0
lob segment hash table latch	17	0.00		0	0
lob segment query latch	5	0.00		0	0
lock DBA buffer during media recovery	5	0.00		0	0
logical standby cache	5	0.00		0	0
logminer context allocation	6	0.00		0	0
logminer work area	5	0.00		0	0
longop free list parent	2,130	0.00		0	310	0.00
managed standby latch	97	0.00		0	0
mapped buffers lru chain	5	0.00		0	0
message pool operations parent latch	12,314	0.00		0	0
messages	998,450	0.09	0.00	0	0
mostly latch-free SCN	156,294	0.82	0.00	0	0
msg queue latch	5	0.00		0	0
multiblock read objects	1,290,322	0.02	0.03	0	0
name-service memory objects	26,107	0.00		0	0
name-service namespace bucket	109,464	0.00		0	0
name-service pending queue	16,022	0.00		0	0
name-service request	52	0.00		0	0
name-service request queue	50,138	0.00		0	0
ncodef allocation latch	395	0.00		0	0
object queue header heap	125,555	0.00		0	124,909	0.00
object queue header operation	26,655,765	0.01	0.25	0	112,803	0.02
object stats modification	83,521	0.01	0.22	0	1	0.00
parallel query alloc buffer	17,152	0.00		0	0
parallel query stats	3,173	0.00		0	0
parallel txn reco latch	46,033	0.00		0	0
parameter list	8,848	0.03	0.00	0	0
parameter table management	11,640	0.05	1.00	0	0
peshm	5	0.00		0	0
pesom_free_list	5	0.00		0	0
pesom_hash_node	5	0.00		0	0
post/wait queue	260,139	0.02	0.06	0	128,001	0.02
process allocation	3,899	1.90	2.20	2	2,000	1.45
process group creation	3,800	0.00		0	0
process queue	9,165	0.00		0	0
process queue reference	274,402	0.01	0.00	0	24,474	2.19
qmn state object latch	6	0.00		0	0
qmn task queue latch	837	1.91	0.63	0	0
query server freelists	7,504	0.00		0	0
query server process	8	0.00		0	9	0.00
queued dump request	12	0.00		0	0
queuing load statistics	5	0.00		0	0
recovery domain hash list	5	0.00		0	0
redo allocation	448,525	0.06	0.04	0	1,039,870	0.16
redo copy	5	0.00		0	1,040,516	0.23
redo writing	457,066	0.04	0.00	0	0
reservation so alloc latch	2	0.00		0	0
resmgr group change latch	3,628	0.00		0	0
resmgr:active threads	37,129	0.09	0.97	0	1,765	0.00
resmgr:actses change group	2,587	0.00		0	0
resmgr:actses change state	308	0.00		0	0
resmgr:free threads list	5,003	0.04	0.00	0	0
resmgr:plan CPU method	5	0.00		0	0
resmgr:resource group CPU method	6	0.00		0	0
resmgr:schema config	185,213	0.13	0.98	0	115	2.61
resmgr:session queuing	5	0.00		0	0
rm cas latch	5	0.00		0	0
row cache objects	46,324,828	0.65	0.00	2	4,971	0.68
rules engine aggregate statistics	13	0.00		0	0
rules engine rule set statistics	126	0.00		0	0
second Audit Vault latch	5	0.00		0	0
second spare latch	5	0.00		0	0
segmented array pool	6	0.00		0	0
sequence cache	119,747	0.02	0.00	0	0
session allocation	781,667	0.01	0.02	0	776,695	0.02
session idle bit	11,862,957	0.01	0.01	0	0
session queue latch	5	0.00		0	0
session state list latch	5,187	0.15	0.00	0	0
session switching	9,255	0.00		0	0
session timer	1,467	0.00		0	0
shared pool	10,891,811	0.10	0.19	14	0
shared pool sim alloc	5	0.00		0	0
shared pool simulator	1,876,583	0.01	0.21	0	0
sim partition latch	5	0.00		0	0
simulator hash latch	39,345,429	0.00	0.02	0	0
simulator lru latch	1,937	0.21	0.75	0	38,109,304	0.43
sort extent pool	1,811	0.00		0	0
space background state object latch	11	0.00		0	0
space background task latch	3,529	0.20	0.00	0	2,394	0.00
state object free list	2	0.00		0	0
statistics aggregation	1,568	0.00		0	0
tablespace key chain	5,090	0.00		0	0
temp lob duration state obj allocation	8	0.00		0	0
temporary table state object allocation	26	0.00		0	0
test excl. parent l0	5	0.00		0	0
test excl. parent2 l0	5	0.00		0	0
third spare latch	5	0.00		0	0
threshold alerts latch	220	0.00		0	0
trace latch	128	0.78	0.00	0	0
transaction allocation	43,961,861	0.13	0.01	0	0
transaction branch allocation	1,669	0.00		0	0
undo global data	629,246	0.04	0.02	0	16	0.00
virtual circuit buffers	5	0.00		0	0
virtual circuit holder	5	0.00		0	0
virtual circuit queues	5	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	1,179,213,190	2,165,628	11,428	2,154,705
DML lock allocation	171,563,018	604,524	2,066	602,516
row cache objects	46,324,828	299,994	530	299,470
transaction allocation	43,961,861	55,762	412	55,372
gcs remastering latch	4,114,236	40,731	3	40,728
shared pool	10,891,811	10,476	2,001	8,598
gc element	9,787,550	6,899	345	6,573
gcs resource hash	25,896,480	2,973	39	2,938
object queue header operation	26,655,765	2,401	607	1,814
ges resource hash list	6,738,735	2,238	686	1,563
cache buffers lru chain	1,855,755	1,406	106	1,302
active service list	6,315,291	1,341	61	1,278
mostly latch-free SCN	156,294	1,283	4	1,279
messages	998,450	869	3	866
simulator hash latch	39,345,429	834	16	819
session idle bit	11,862,957	797	5	792
enqueue hash chains	3,115,958	739	146	594
enqueues	1,703,617	641	5	636
KJCT flow control latch	2,454,467	476	5	471
ges caches resource lists	934,164	297	11	286
redo allocation	448,525	283	10	273
ges enqueue table freelist	4,224,794	275	6	269
multiblock read objects	1,290,322	260	8	252
resmgr:schema config	185,213	244	240	4
undo global data	629,246	237	4	233
ges group table	4,151,984	164	2	162
KJC message pool free list	131,576	157	3	154
shared pool simulator	1,876,583	117	25	92
process allocation	3,899	74	163	29
checkpoint queue latch	3,029,697	62	1	61
post/wait queue	260,139	54	3	51
session allocation	781,667	51	1	50
cache table scan latch	354,597	40	1	39
ges timeout list	23,236	37	3	34
call allocation	31,068	35	13	22
channel operations parent latch	3,658,444	35	2	33
resmgr:active threads	37,129	34	33	1
corrupted undo seg latch	202,272	33	1	32
ASM map operation hash table	3,461,070	17	1	16
qmn task queue latch	837	16	10	6
object stats modification	83,521	9	2	7
ges process hash list	162,933	7	3	4
parameter table management	11,640	6	6	0
simulator lru latch	1,937	4	3	1

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
ASM map operation hash table	kffmTranslate	1	1
DML lock allocation	ktadmc	2,064	2,027
DML lock allocation	ktaiam	1	27
DML lock allocation	ktaidm	1	12
KJC message pool free list	kjcsmpav: allocate a msg buffer	3	3
KJCT flow control latch	kjctcsnd: send normal message	3	3
KJCT flow control latch	kjcts_sedeqv2: dequeue a vector of msgs	2	0
active service list	kswslogon: session logout	37	1
active service list	kswsite: service iterator	22	1
active service list	kswslogon: session login	15	1
active service list	kswsgetso: get service object	7	75
active service list	kswssetsvc: PX session switch service	1	0
cache buffers chains	kcbgtcr: fast path (cr pin)	7,499	3,332
cache buffers chains	kcbgtcr_2	6,086	5,934
cache buffers chains	kcbgtcr: kslbegin excl	749	1,527
cache buffers chains	kcbrls_1	708	4,475
cache buffers chains	kcbgtcr: fast path	616	304
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	198	165
cache buffers chains	kcbzwb	181	128
cache buffers chains	kcbgcur_2	93	55
cache buffers chains	kcbzibmlt: multi-block read: nowait	52	0
cache buffers chains	kcbrls_2	39	147
cache buffers chains	kcbget: pin buffer	33	32
cache buffers chains	kclwrt	26	0
cache buffers chains	kcbchg1: kslbegin: call CR func	25	77
cache buffers chains	kclbla	16	1
cache buffers chains	kclcls_3	14	65
cache buffers chains	kcllkopesc	9	2
cache buffers chains	kcbgtcr: kslbegin shared	7	4
cache buffers chains	kcbbxsv	5	15
cache buffers chains	kcl_fairness	5	1
cache buffers chains	kcbgkcbcr	4	5
cache buffers chains	kcbzgb: scan from tail. nowait	3	0
cache buffers chains	kclcqchk	3	0
cache buffers chains	kcbbic2	2	0
cache buffers chains	kcbesc: escalate	2	1
cache buffers chains	kcbgtcr_1	2	2
cache buffers chains	kcbzibmlt: finish free bufs	2	3
cache buffers chains	kcbbic1	1	0
cache buffers chains	kcbgcur: fast path (shr)	1	0
cache buffers chains	kcbnlc	1	7
cache buffers chains	kcbxbh	1	0
cache buffers chains	kcbzib: finish processing buffer	1	9
cache buffers chains	kclevict	1	0
cache buffers chains	kcllwr_1	1	0
cache buffers chains	kclrlstp	1	1
cache buffers lru chain	kcbzgws	79	0
cache buffers lru chain	kcbzgb_2	18	8
cache buffers lru chain	kcbw_activate_granule	3	0
cache buffers lru chain	kcbzgm	3	0
cache buffers lru chain	kcbzgb	2	47
cache buffers lru chain	kcbbic2	1	21
cache table scan latch	kcbz_free_table_scan_read_buffer	1	1
call allocation	ksuxds	12	3
call allocation	ksuprc	1	1
channel operations parent latch	ksrpubwait():1	1	0
channel operations parent latch	ksrwait()	1	1
checkpoint queue latch	kcbkubc_4	1	0
corrupted undo seg latch	ktudiscorrupted	1	1
enqueue hash chains	ksqexpandres	115	0
enqueue hash chains	ksqgtl3	12	39
enqueue hash chains	ksqrcl	9	100
enqueue hash chains	ksqcmi: if lk mode not requested	6	1
enqueue hash chains	ksqcmi: if lk mode requested	2	4
enqueue hash chains	ksqexpandwait	2	1
enqueues	ksqdel	3	3
enqueues	ksqgel: create enqueue	2	2
gc element	kclbla	186	2
gc element	kclnfndnewm	90	63
gc element	kcl_fairness	41	5
gc element	kclevict	36	0
gc element	kclchkping	29	0
gc element	kclulb	28	84
gc element	kclplz	23	63
gc element	kclfwrite1	17	6
gc element	kclnfndx	15	97
gc element	KCLUNLNK	6	89
gc element	kclwrt	6	2
gc element	kclcqchk	4	28
gc element	kcl_get_le_latch	2	0
gc element	kclpto_3	2	0
gc element	kclrwrite	2	8
gc element	kclebs	1	2
gc element	kclhngcbk1	1	0
gc element	kclhngcbk1_1	1	0
gc element	kclnfndnew	1	1
gc element	kclpdc_14	1	0
gc element	kclpdcl	1	23
gc element	kclplz_1	1	11
gcs remastering latch	kjfcdrmrfg beginning	3	0
gcs resource hash	kjblocalobj_nolock	13	8
gcs resource hash	kjbconvert	8	1
gcs resource hash	kjbcropen:affinity	4	1
gcs resource hash	kjbassume	3	2
gcs resource hash	kjbcrcomplete	3	1
gcs resource hash	kjbopen	2	0
gcs resource hash	kclfwrite1	1	0
gcs resource hash	kclpdc	1	2
gcs resource hash	kclrwrite	1	2
gcs resource hash	kjbcropen	1	3
gcs resource hash	kjblpast	1	1
gcs resource hash	kjbmpcreatepi	1	1
ges enqueue table freelist	kjlalc: lock allocation	3	4
ges enqueue table freelist	kjlfr: remove lock from parent object	3	2
ges group table	kjgagll: move a lock from process lock list to group lock list	2	2
ges process hash list	kjakiqa: set inquiry response	3	0
ges resource hash list	kjrmas1: lookup master node	497	2
ges resource hash list	kjakcai: search for resp by resname	81	7
ges resource hash list	kjlrlr: remove lock from resource queue	59	183
ges resource hash list	kjucvl: lock convert request	28	467
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	21	1
ges resource hash list	kjrref: find matched resource	6	36
ges resource hash list	kjcvscn: remove from scan queue	4	0
ges resource hash list	kjuinq: inquire resource held mode	1	0
ges resource table freelist	kjruch: cached obj cleanup	4	0
ges resource table freelist	kjrm2c: move resource to cache	3	11
ges resource table freelist	kjchc: clean resource cache	2	0
ges resource table freelist	kjrchc2: cached obj cleanup	1	0
ges resource table freelist	kjrchc: cached obj cleanup	1	0
ges timeout list	kjtscn: try to lock timer queue	3	0
lgwr LWN SCN	kcs023	2	0
messages	ksaamb: after wakeup	2	1
messages	ksarcv: after wait	1	2
mostly latch-free SCN	kcslcu3	2	4
multiblock read objects	kcbzibmlt	4	2
multiblock read objects	kcbzibmlt: normal mbr free	4	6
object queue header operation	kclobj_5	539	429
object queue header operation	kclobj_1	28	27
object queue header operation	kcbo_unlink_q	22	124
object queue header operation	kcbo_link_q:reget	10	0
object queue header operation	kcbo_link_q	8	11
object queue header operation	kcbo_write_q	4	4
object queue header operation	kcbo_switch_mq_bg	3	5
object queue header operation	kcbo_unlink_q_bg	3	6
object queue header operation	kcbo_switch_q_bg	2	5
object queue header operation	kcldbufs	2	8
object queue header operation	kcbo_sw_buf	1	0
object queue header operation	kcbo_switch_cq	1	4
object queue header operation	kclbufs	1	1
object stats modification	ksolsgetchk	2	0
parameter table management	kspcpy	5	0
parameter table management	ksp_param_table_free	1	0
post/wait queue	kslpstevent:get	2	2
post/wait queue	ksliwat:remove	1	1
process allocation	ksuapc	119	162
process allocation	ksucrp:1	40	0
process allocation	ksudlp	3	0
qmn task queue latch	kwqmnmvtsks: delay to ready list	5	0
qmn task queue latch	kwqmnaddtsk: add task	2	0
qmn task queue latch	kwqmngettsk: get task	2	10
qmn task queue latch	kwqmndntsk: task done but retry	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	9	0
redo allocation	kcrfw_redo_gen: redo allocation 3	1	0
resmgr:active threads	kgsksimsetup1	32	0
resmgr:active threads	kskdynthreshact	1	0
resmgr:resource group CPU method	kgkprrpicknext	290	299
resmgr:resource group CPU method	kgkprraddtorl	23	14
resmgr:schema config	kgskgmaxdop1	150	6
resmgr:schema config	kgskgasi1	89	234
resmgr:schema config	kgskmetricupd	1	0
row cache objects	kqreqd: reget	287	11
row cache objects	kqrpre: find obj	106	429
row cache objects	kqrso	57	33
row cache objects	kqrbgl	29	2
row cache objects	kqreqd	22	24
row cache objects	kqrbtm: pop parent	9	2
row cache objects	kqrbip	4	2
row cache objects	kqrigt	4	21
row cache objects	kqrigt2	3	0
row cache objects	ksucallcbksafely: kqrhngc	3	0
row cache objects	kqrpre: init complete	2	1
row cache objects	kqrcmt: while loop	1	1
row cache objects	kqrigt3	1	0
session allocation	kspallmod	1	0
session idle bit	ksupuc: clear busy	3	2
session idle bit	ksupuc: set busy	2	4
session idle bit	ksuxds	2	1
shared pool	kghalo	1,459	774
shared pool	kghupr1	261	680
shared pool	kghalp	158	456
shared pool	kgh_heap_sizes	54	45
shared pool	kgh_next_free	47	2
shared pool	kghfrunp: alloc: wait	11	0
shared pool	kghfre	4	37
shared pool	kghasp	2	2
shared pool	kghfrh	1	1
shared pool	kghfrunp: clatch: nowait	1	0
shared pool	kghfrunp: clatch: wait	1	0
shared pool simulator	kglsim_unpin_simhp	22	6
shared pool simulator	kglsim_scan_lru: scan	2	6
shared pool simulator	kglsim_upd_newhp	1	8
simulator hash latch	kcbsacc: lookup dba	11	14
simulator hash latch	kcbsacc: insert dba	2	0
simulator hash latch	kcbsacc: remove dba	2	1
simulator hash latch	kcbs_lookup_setid: lookup dba	1	1
simulator lru latch	kcbs_shrink_pool	3	0
transaction allocation	ktcxbr	412	412
undo global data	ktudba: KSLBEGIN	2	2
undo global data	ktucof: at start	1	0
undo global data	kturdc: KSLBEGIN	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Cursor Pin	kkslce [KKSCHLPIN2]	6,024,659	821,028
Library Cache	kgllkal1 80	233,612	7,013
Library Cache	kglget1 1	114,660	2,908
Library Cache	kglhdgn1 62	68,284	1,299
Library Cache	kglget2 2	59,981	1,233
Library Cache	kglpndl1 95	59,485	1,743
Library Cache	kglobpn1 71	53,954	1,156
Library Cache	kglpin1 4	47,603	1,015
Library Cache	kgldtin1 42	40,898	683
Library Cache	kglhdgn2 106	29,348	1,141
Library Cache	kglpnal2 91	29,346	877
Library Cache	kglpnal1 90	27,586	904
Library Cache	kgllkdl1 85	23,790	692
Library Cache	kglobld1 75	1,519	22
Library Cache	kglhdgh1 64	1,205	97
Cursor Pin	kksfbc [KKSCHLFSP2]	492	4,933
Library Cache	kglrfcl1 79	337	5
Cursor Pin	kksfbc [KKSCHLPIN1]	208	2
Library Cache	kglReleaseHandleReference 125	200	3
Library Cache	kgllkc1 57	95	1
Library Cache	kglllal3 111	36	82
hash table	kkshGetNextChild [KKSHBKLOC1]	31	0
Cursor Pin	kksLockDelete [KKSCHLPIN6]	19	0
Library Cache	kgllldl2 112	11	0
Library Cache	kglnti1 46	5	0
Library Cache	kglati1 45	4	5
Library Cache	kglini1 32	2	8
Library Cache	kglUpgradeLock 119	1	0
Library Cache	kglhbh1 63	1	0
Library Cache	kglic1 49	1	0
Library Cache	kgllkal3 82	1	0
Library Cache	kglllal1 109	1	2
Library Cache	kglrdtin1 44	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 585,271,612
Captured Segments account for 87.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
ECS	COREDATA	EXCHANGE		TABLE	67,520,480	11.54
ECS	USERS	ORGANIZATIONUNITPROFILE		TABLE	57,782,240	9.87
ECS	CORE_INDEX	IDX_OUNESTLOOP		INDEX	34,678,768	5.93
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_87227165_25241	TABLE PARTITION	24,907,792	4.26
ECS	COREDATA	REPAYBILL		TABLE	22,569,488	3.86

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	98.01	In-memory Sort %:	100.00
Library Hit %:	83.71	Soft Parse %:	87.67
Execute to Parse %:	21.45	Latch Hit %:	99.81
Parse CPU to Parse Elapsd %:	0.29	% Non-Parse CPU:	92.91

Buffer access - local cache %:	97.90
Buffer access - remote cache %:	0.11
Buffer access - disk %:	1.99

Avg global enqueue get time (ms):	87.1
Avg global cache cr block receive time (ms):	7.0
Avg global cache current block receive time (ms):	3.0
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 %:	13.0
Avg global cache cr block flush time (ms):	4.0
Avg global cache current block pin time (ms):	0.1
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.7
Avg global cache current block flush time (ms):	9.0

Avg message sent queue time (ms):	0.3
Avg message sent queue time on ksxp (ms):	7.1
Avg message received queue time (ms):	0.2
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	40.80
% of indirect sent messages:	58.86
% of flow controlled messages:	0.34

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
ECS	COREDATA	REFUNDORDER		TABLE	4,968,766	26.32
ECS	COREDATA	PSGTICKET		TABLE	4,351,608	23.05
SYS	USERS	AUD$		TABLE	420,329	2.23
ECS	COREDATA	ORDERS	SYS_P2389	TABLE PARTITION	155,836	0.83
ECS	COREDATA	ORDERS	SYS_P2409	TABLE PARTITION	149,861	0.79

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
PAO	TEMP	QUEST_ADV_SEGSTAT_WIDE_PK		INDEX	4,796	3.68
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_87227165_25433	TABLE PARTITION	4,073	3.12
ECS	COREDATA	PAYBILL		TABLE	3,430	2.63
SYS	USERS	AUD$		TABLE	2,635	2.02
MISSING	USERS	** MISSING: 300054/300054	MISSING	UNDEFINED	2,434	1.87

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
ECS	CORE_INDEX	PK_ORGANIZATIONUNITPROFILE		INDEX	3,165	55.81
ECS	COREDATA	REFUNDORDER		TABLE	19	0.34
ECS	COREDATA	ORDERS	SYS_P2548	TABLE PARTITION	16	0.28
ECS	COREDATA	ORDERS	SYS_P2389	TABLE PARTITION	15	0.26
ECS	COREDATA	ORDERS	SYS_P2409	TABLE PARTITION	15	0.26

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
ECS	USERS	IDX_TRACEID	SYS_P2528	INDEX PARTITION	23	88.46
ECS	CORE_INDEX	SYS_C0049434		INDEX	3	11.54

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	UNDO$		TABLE	1,347	53.09
ECS	COREDATA	ORDERS	SYS_P2548	TABLE PARTITION	484	19.08
ECS	USERS	IDX_TRACEID	SYS_P2528	INDEX PARTITION	238	9.38
ECS	CORE_INDEX	PK_PNRLIST		INDEX	122	4.81
ECS	CORE_INDEX	SYS_C0048724		INDEX	60	2.36

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Current Blocks Received	%Total
ECS	COREDATA	CNPPHONEPAYINFO		TABLE	84,409	17.91
ECS	COREDATA	ORDERS	SYS_P2048	TABLE PARTITION	63,270	13.42
ECS	COREDATA	ORDERS	SYS_P2448	TABLE PARTITION	56,072	11.89
ECS	COREDATA	ORDERS	SYS_P2489	TABLE PARTITION	19,358	4.11
ECS	CORE_INDEX	ORDERSEGMENT_FK		INDEX	18,884	4.01

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	409	0.00	2	1
dc_constraints	507	35.11	507	1
dc_files	882	0.00	0	42
dc_global_oids	29,365	0.38	0	51
dc_histogram_data	8,194,384	0.07	2,808	7,270
dc_histogram_defs	3,137,438	0.34	2,039	4,704
dc_object_grants	54,868	0.15	0	82
dc_objects	4,944,686	0.07	261	1,745
dc_profiles	3,274	0.37	0	4
dc_rollback_segments	151,277	0.06	450	1,920
dc_segments	1,405,666	0.17	46	1,163
dc_sequences	1,673	69.64	1,673	5
dc_table_scns	46	100.00	0	0
dc_tablespaces	897,558	0.00	0	14
dc_users	2,007,024	0.00	0	72
global database name	4,504	0.00	0	1
outstanding_alerts	71	90.14	13	11
qmtmrctn_cache_entries	4	100.00	0	0
qmtmrctq_cache_entries	123	100.00	0	0
sch_lj_objs	6	50.00	0	3

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	3,067	1.01	0		0	0
BODY	11,230	1.81	98,248	0.24	12	0
CLUSTER	1,024	1.37	1,037	1.45	1	0
DBLINK	3,257	0.00	0		0	0
DIRECTORY	50	6.00	70	12.86	4	0
EDITION	1,493	0.00	2,969	0.00	0	0
HINTSET OBJECT	31	19.35	31	38.71	0	0
INDEX	135,635	0.19	135,572	0.38	0	0
OBJECT ID	49	100.00	0		0	0
QUEUE	27	7.41	179	3.35	3	0
RULESET	0		13	7.69	1	0
SCHEMA	3,979	0.00	0		0	0
SQL AREA	571,098	27.15	2,640,292	21.40	21,256	2,609
SQL AREA BUILD	177,410	94.95	0		0	0
SQL AREA STATS	171,359	95.25	171,362	95.25	1	0
SUBSCRIPTION	9	66.67	9	66.67	0	0
TABLE/PROCEDURE	408,258	0.26	1,431,191	0.80	7,012	0
TEMPORARY INDEX	121	100.00	121	100.00	0	0
TEMPORARY TABLE	316	31.01	316	100.00	218	0
TRIGGER	899	4.56	66,462	0.11	19	0
XML SCHEMA	5	20.00	6	66.67	1	0

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	15,616.00	15,552.00	15,552.00	18,304.00	8	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	6,144.00	6,144.00	6,144.00	6,144.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	24,576.00	24,576.00	24,576.00	24,576.00	0	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	64.00	64.00	64.00	64.00	0	STA/
large pool	64.00	64.00	64.00	64.00	0	STA/
shared pool	8,576.00	8,640.00	5,952.00	8,640.00	8	GRO/DEF
streams pool	128.00	128.00	64.00	128.00	0	SHR/DEF

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Target Delta	Final (M)	Sta
08/07 22:57:44	60	bufcache	SHR/DEF	15,552	0	-128	15,552	CAN
08/07 22:57:44	60	shared	GRO/DEF	8,640	0	128	8,640	CAN
08/07 22:44:14	60	bufcache	SHR/DEF	15,552	0	-128	15,552	CAN
08/07 22:44:14	60	shared	GRO/DEF	8,640	0	128	8,640	CAN
08/07 22:30:54	1	bufcache	SHR/IMM	15,616	-64		15,552	COM
08/07 22:30:54	1	shared	GRO/IMM	8,576	64		8,640	COM
08/07 22:24:43	60	bufcache	SHR/DEF	15,616	0	-128	15,616	CAN
08/07 22:24:43	60	shared	GRO/DEF	8,576	0	128	8,576	CAN
08/07 22:15:11	60	bufcache	SHR/DEF	15,616	0	-128	15,616	CAN
08/07 22:15:11	60	shared	GRO/DEF	8,576	0	128	8,576	CAN
08/07 22:06:09	60	bufcache	SHR/DEF	15,616	0	-128	15,616	CAN
08/07 22:06:09	60	shared	GRO/DEF	8,576	0	128	8,576	CAN

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	2,473.50		4.39	4.04	44	44	564	564
B	Freeable	402.56	0.00	0.87	0.67	11		464	464
B	PL/SQL	99.89	63.23	0.18	0.15	1	1	562	560
B	SQL	40.55	17.48	0.08	0.52	12	275	529	430
E	Other	3,225.48		3.92	3.58	44	44	822	822
E	Freeable	512.94	0.00	0.84	0.55	9		608	608
E	PL/SQL	113.27	79.44	0.14	0.14	1	2	820	819
E	SQL	32.77	6.66	0.04	0.06	1	275	786	684

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	16,374,562,816	16,307,453,952
Fixed Size	2,231,608
Redo Buffers	16,932,864
Variable Size	9,261,023,944	9,328,132,808

Pool	Name	Begin MB	End MB	% Diff
java	free memory	64.00	64.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	55.81	55.81	0.00
shared	KGH: NO ACCESS	801.82	801.82	0.00
shared	KGLH0	582.60	627.28	7.67
shared	KGLHD	2,762.98	2,773.19	0.37
shared	SQLA	362.65	488.81	34.79
shared	free memory	3,243.66	3,091.88	-4.68
shared	gcs resources	336.81	336.81	0.00
shared	gcs shadows	248.18	248.18	0.00
shared	kglsim object batch	125.21	125.21	0.00
streams	KGH: NO ACCESS	63.99	63.99	0.00
streams	free memory	127.95	127.95	0.00
	buffer_cache	15,616.00	15,552.00	-0.41
	fixed_sga	2.13	2.13	0.00
	log_buffer	16.15	16.15	0.00

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	0517 05:09:44	0.22	0.00	0.00
QMON Slaves	0517 05:09:44	0.22	0.00	0.00

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(12343)	13	0	100.00	0.00	42.60	0.00	0.00	4.93
SYS.AQ$_ALERT_QT_E(12342)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(49631)	34	34	0.00	0.00	0.18	0.43	0.00	0.00

Subscriber/Queue	Enqueue Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
CORE_DB1_3938_COREDB1(22)/SYS.ALERT_QUE	13	0.00	0.00	0.00
CORE_DB2_3938_COREDB2(42)/SYS.ALERT_QUE	13	0.00	0.00	0.00
HAE_SUB(1)/SYS.ALERT_QUE	0

WORKLOAD REPOSITORY report for

Report Summary

RAC Statistics

Main Report

More RAC 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

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

Instance Activity Statistics

Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

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

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Segment Statistics

Segments by Logical Reads

Segments by Physical Reads

Segments by Physical Read Requests

Segments by UnOptimized Reads

Segments by Optimized Reads

Segments by Direct Physical Reads

Segments by Physical Writes

Segments by Physical Write Requests

Segments by Direct Physical Writes

Segments by Table Scans

Name	Total Disp Time (s)	%Busy	%Idle
D000	3,608	0.09	99.91
D000	3,608	0.09	99.91
D000	3,608	0.09	99.91
D000	3,608	0.09	99.91
Sum
Avg		0.09	99.91
Std		0.00	0.00

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/app/oracle/admin/COREDB/adump
cluster_database	TRUE
compatible	11.2.0.0.0
control_files	+DATADG/COREDB/controlfile/current.256.729362595, +FLASHDG/COREDB/controlfile/current.256.729362595
db_block_size	8192
db_create_file_dest	+DATADG
db_domain
db_name	COREDB
db_recovery_file_dest	+FLASHDG
db_recovery_file_dest_size	1887436800000
diagnostic_dest	/oracle/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=COREDBXDB)
instance_number	1
job_queue_processes	1000
local_listener	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.109.10.31)(PORT=1521))))
log_archive_format	%t_%s_%r.dbf
max_dump_file_size	20480
memory_max_target	34359738368
memory_target	0
open_cursors	3000
pga_aggregate_target	6442450944
processes	2000
remote_listener	CORE-DB-cluster-scan:1521
remote_login_passwordfile	EXCLUSIVE
resource_limit	TRUE
sec_case_sensitive_logon	FALSE
service_names	COREDB.
sessions	3024
sga_max_size	25769803776
sga_target	25769803776
thread	1
undo_retention	10800
undo_tablespace	UNDOTBS1

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	50,772	14.07	0.27
acks for commit broadcast(logical)	58,633	16.25	0.31
broadcast msgs on commit(actual)	68,850	19.08	0.37
broadcast msgs on commit(logical)	120,469	33.38	0.64
broadcast msgs on commit(wasted)	16,031	4.44	0.09
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	3	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	119,324	33.06	0.64
gcs ast xid	30	0.01	0.00
gcs blocked converts	154,136	42.71	0.82
gcs blocked cr converts	179,547	49.75	0.96
gcs compatible basts	824	0.23	0.00
gcs compatible cr basts (global)	43,082	11.94	0.23
gcs compatible cr basts (local)	163,278	45.24	0.87
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	15,210	4.21	0.08
gcs dbwr write request msgs	11,569	3.21	0.06
gcs delta msgs sent	0	0.00	0.00
gcs delta push aborted by cancel	0	0.00	0.00
gcs delta push aborted by remastering	0	0.00	0.00
gcs delta push cancelled	0	0.00	0.00
gcs delta push cancelled at master	0	0.00	0.00
gcs delta push cancelled by close	0	0.00	0.00
gcs delta push cancelled by consign	0	0.00	0.00
gcs delta push cancelled by cvt ping	0	0.00	0.00
gcs delta push cancelled by dwncvt	0	0.00	0.00
gcs delta push create pi	0	0.00	0.00
gcs delta update master msgs sent	0	0.00	0.00
gcs delta wait aborted by remastering	0	0.00	0.00
gcs delta wait cancelled	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs force cr block only	137	0.04	0.00
gcs force cr grant	794	0.22	0.00
gcs force cr no current	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	12,571	3.48	0.07
gcs immediate (null) converts	20,896	5.79	0.11
gcs immediate cr (compatible) converts	1,249	0.35	0.01
gcs immediate cr (null) converts	257,327	71.30	1.37
gcs indirect ast	71,951	19.94	0.38
gcs indirect bidless ast	33	0.01	0.00
gcs indirect fg ast	71,774	19.89	0.38
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	6,883	1.91	0.04
gcs msgs process time(ms)	45,724	12.67	0.24
gcs msgs received	1,525,497	422.69	8.13
gcs new served by master	1,271	0.35	0.01
gcs out-of-order msgs	11	0.00	0.00
gcs pings refused	292	0.08	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	98	0.03	0.00
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	0	0.00	0.00
gcs reader bypass grant X on assume	0	0.00	0.00
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	0	0.00	0.00
gcs reader bypass grant immediate	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	35	0.01	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	3	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	22,379	6.20	0.12
gcs side channel msgs logical	815,484	225.96	4.35
gcs stale cr	39,292	10.89	0.21
gcs undo cr	8,171	2.26	0.04
gcs write notification msgs	1,724	0.48	0.01
gcs writes refused	56	0.02	0.00
ges msgs process time(ms)	3,299	0.91	0.02
ges msgs received	139,985	38.79	0.75
global posts dropped	0	0.00	0.00
global posts queue time	76	0.02	0.00
global posts queued	46	0.01	0.00
global posts requested	47	0.01	0.00
global posts sent	46	0.01	0.00
implicit batch messages received	34,940	9.68	0.19
implicit batch messages sent	96,710	26.80	0.52
lmd msg send time(ms)	10	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	5,856	1.62	0.03
messages queue sent actual	315,605	87.45	1.68
messages queue sent logical	848,077	234.99	4.52
messages received actual	887,977	246.04	4.73
messages received logical	1,665,577	461.50	8.88
messages sent directly	703,044	194.80	3.75
messages sent indirectly	1,014,276	281.04	5.41
messages sent not implicit batched	323	0.09	0.00
messages sent pbatched	1,136,685	314.96	6.06
msgs causing lmd to send msgs	56,365	15.62	0.30
msgs causing lms(s) to send msgs	55,565	15.40	0.30
msgs received queue time (ms)	310,829	86.13	1.66
msgs received queued	1,665,581	461.50	8.88
msgs sent queue time (ms)	267,201	74.04	1.42
msgs sent queue time on ksxp (ms)	8,113,781	2,248.19	43.24
msgs sent queued	1,065,778	295.31	5.68
msgs sent queued on ksxp	1,150,472	318.78	6.13
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	229,774	63.67	1.22
process batch messages sent	258,580	71.65	1.38
	0	0.00	0.00

Statistic	Total
CR Block Requests	133,779
CURRENT Block Requests	15,657
Data Block Requests	133,780
Undo Block Requests	3,048
TX Block Requests	11,444
Current Results	130,170
Private results	3,253
Zero Results	15,879
Disk Read Results	123
Fail Results	0
Fairness Down Converts	47,773
Fairness Clears	8,701
Free GC Elements	0
Flushes	19,440
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	2,479
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	405	26.17	38.27	33.09	1.23	1.23
Flushes	1,634	15.73	67.69	14.75	1.84	0.00
Writes	19,809	0.01	62.56	32.07	3.71	1.65

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	138,243	85.29	14.48	0.23	469,861	97.47	0.47	2.06
2	undo header	24,762	99.15	0.36	0.48	310	95.81	3.55	0.65
2	Others	829	98.79	0.12	1.09	1,230	99.59	0.08	0.33
2	undo block	1,800	96.78	3.06	0.17	24	87.50	0.00	12.50

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	7.15	1.21	30.18	758.37	2.85	1.64	119.67	33.03
2	undo header	6.98	2.77	543.98	464.68	16.78	1.37	337.22	542.48
2	others	1.22	0.99	75.53	13.41	1.81	1.79	0.81	6.57
2	undo block	1.41	0.91	6.76	193.61	3662.91	2.91		29282.91

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	117,913	100.00	0.00	457,952	100.00	0.00
2	undo header	0	24,552	100.00	0.00	297	100.00	0.00
2	others	0	819	100.00	0.00	1,225	100.00	0.00
2	undo block	0	1,742	100.00	0.00	21	100.00	0.00

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.67	1.20
Parallel Query	0.01	0.03
DB Locks	0.21	0.10
DB Streams	0.00	0.00
Other	0.00	0.01

Name	Total	per Remaster Op	Begin Snap	End Snap
remaster ops	3	1.00
remastered objects	3	1.00
replayed locks received	3,072	1,024.00
replayed locks sent	9	3.00
resources cleaned	0	0.00
remaster time (s)	58.8	19.59
quiesce time (s)	2.3	0.77
freeze time (s)	0.6	0.19
cleanup time (s)	0.9	0.30
replay time (s)	0.3	0.09
fixwrite time (s)	1.3	0.45
sync time (s)	52.2	17.39
affinity objects			186	187