WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ORADB 2550341631 oradb1 1 29-6月 -13 09:06 11.2.0.3.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORADB	2550341631	oradb1	1	29-6月 -13 09:06	11.2.0.3.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

rac0101.tempus.cn Linux x86 64-bit 24 12 2 15.65

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
rac0101.tempus.cn	Linux x86 64-bit	24	12	2	15.65

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 9515 20-11月-13 09:00:16 212 1.8

End Snap: 9516 20-11月-13 10:00:25 212 1.8

Elapsed: 60.15 (mins)

DB Time: 131.32 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	9515	20-11月-13 09:00:16	212	1.8
End Snap:	9516	20-11月-13 10:00:25	212	1.8
Elapsed:		60.15 (mins)
DB Time:		131.32 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 2,432M 2,432M Std Block Size: 8K

Shared Pool Size: 3,744M 3,744M Log Buffer: 19,160K

	Begin	End
Buffer Cache:	2,432M	2,432M	Std Block Size:	8K
Shared Pool Size:	3,744M	3,744M	Log Buffer:	19,160K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 2.2 0.8 0.02 0.01

DB CPU(s): 0.5 0.2 0.00 0.00

Redo size: 23,838.9 8,606.4

Logical reads: 31,391.2 11,333.0

Block changes: 171.8 62.0

Physical reads: 16,041.8 5,791.5

Physical writes: 137.2 49.5

User calls: 277.2 100.1

Parses: 61.6 22.3

Hard parses: 30.5 11.0

W/A MB processed: 2.1 0.8

Logons: 1.0 0.4

Executes: 97.5 35.2

Rollbacks: 0.0 0.0

Transactions: 2.8

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.2	0.8	0.02	0.01
DB CPU(s):	0.5	0.2	0.00	0.00
Redo size:	23,838.9	8,606.4
Logical reads:	31,391.2	11,333.0
Block changes:	171.8	62.0
Physical reads:	16,041.8	5,791.5
Physical writes:	137.2	49.5
User calls:	277.2	100.1
Parses:	61.6	22.3
Hard parses:	30.5	11.0
W/A MB processed:	2.1	0.8
Logons:	1.0	0.4
Executes:	97.5	35.2
Rollbacks:	0.0	0.0
Transactions:	2.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 65.13 Soft Parse %: 50.50

Execute to Parse %: 36.79 Latch Hit %: 99.82

Parse CPU to Parse Elapsd %: 97.84 % Non-Parse CPU: 87.10

Shared Pool Statistics

Begin End

Memory Usage %: 85.76 86.25

% SQL with executions>1: 86.96 88.22

% Memory for SQL w/exec>1: 84.12 85.96

	Begin	End
Memory Usage %:	85.76	86.25
% SQL with executions>1:	86.96	88.22
% Memory for SQL w/exec>1:	84.12	85.96

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
direct path read	331,795	4,519	14	57.35	User I/O
DB CPU		1,739		22.08
log file sync	14,170	1,031	73	13.09	Commit
direct path read temp	13,330	231	17	2.93	User I/O
db file sequential read	7,570	210	28	2.66	User I/O

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

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

2.52 3.33 2.1 0.4 4.3 97.4

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.52	3.33	2.1	0.4	4.3	97.4

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

2.1 81.4 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 16,026.0 16,026.0

SGA use (MB): 6,304.0 6,304.0

PGA use (MB): 789.2 801.1

% Host Mem used for SGA+PGA: 44.26 44.33

	Begin	End
Host Mem (MB):	16,026.0	16,026.0
SGA use (MB):	6,304.0	6,304.0
PGA use (MB):	789.2	801.1
% Host Mem used for SGA+PGA:	44.26	44.33

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: 16.63 6.00

Global Cache blocks served: 65.74 23.73

GCS/GES messages received: 99.95 36.09

GCS/GES messages sent: 61.21 22.10

DBWR Fusion writes: 1.77 0.64

Estd Interconnect traffic (KB) 690.43

	Per Second	Per Transaction
Global Cache blocks received:	16.63	6.00
Global Cache blocks served:	65.74	23.73
GCS/GES messages received:	99.95	36.09
GCS/GES messages sent:	61.21	22.10
DBWR Fusion writes:	1.77	0.64
Estd Interconnect traffic (KB)	690.43

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

Buffer access - local cache %: 99.87

Buffer access - remote cache %: 0.11

Buffer access - disk %: 0.03

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

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

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

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

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

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

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

Global cache log flushes for current blocks served %: 0.6

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 58.72

% of indirect sent messages: 41.23

% of flow controlled messages: 0.06

Cluster Interconnect

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

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
eth1:1	169.254.172.122	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): 7879.3s
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
sql execute elapsed time	6,756.99	85.76
DB CPU	1,739.43	22.08
connection management call elapsed time	269.31	3.42
parse time elapsed	231.87	2.94
hard parse elapsed time	195.64	2.48
sequence load elapsed time	8.20	0.10
PL/SQL execution elapsed time	4.11	0.05
PL/SQL compilation elapsed time	1.74	0.02
hard parse (sharing criteria) elapsed time	0.42	0.01
hard parse (bind mismatch) elapsed time	0.35	0.00
repeated bind elapsed time	0.01	0.00
failed parse elapsed time	0.00	0.00
DB time	7,879.29
background elapsed time	1,622.07
background cpu time	58.48

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
BUSY_TIME	220,824
IDLE_TIME	8,394,277
IOWAIT_TIME	368,732
NICE_TIME	54
SYS_TIME	35,390
USER_TIME	179,795
LOAD	3	3
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	0
VM_OUT_BYTES	0
PHYSICAL_MEMORY_BYTES	16,804,487,168
NUM_CPUS	24
NUM_CPU_CORES	12
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
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
20-11月 09:00:16	2.52
20-11月 10:00:25	3.33	2.56	2.09	0.41	97.44	4.28

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 103.3% of Total DB time 7,879.29 (s)
Total FG Wait Time: 6,401.51 (s) DB CPU time: 1,739.43 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	375,936	0	5,188	14	65.85
DB CPU			1,739		22.08
Commit	14,170	0	1,031	73	13.09
Cluster	73,586	0	85	1	1.08
Application	2,590	0	44	17	0.56
System I/O	2,063	0	27	13	0.34
Other	19,256	58	18	1	0.23
Concurrency	9,973	0	7	1	0.09
Network	719,591	0	1	0	0.01
Configuration	21	0	0	3	0.00

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
direct path read	331,795	0	4,519	14	33.19	57.35
log file sync	14,170	0	1,031	73	1.42	13.09
direct path read temp	13,330	0	231	17	1.33	2.93
db file sequential read	7,570	0	210	28	0.76	2.66
direct path write temp	13,362	0	177	13	1.34	2.24
db file parallel read	1,312	0	49	37	0.13	0.62
enq: KO - fast object checkpoint	2,331	0	43	19	0.23	0.55
gc buffer busy release	272	0	37	135	0.03	0.47
control file sequential read	2,063	0	27	13	0.21	0.34
reliable message	3,223	0	17	5	0.32	0.21
gc current block busy	876	0	15	17	0.09	0.19
gc cr block busy	681	0	12	18	0.07	0.15
gc current block 2-way	28,880	0	7	0	2.89	0.09
gc cr block 2-way	25,091	0	6	0	2.51	0.08
gc buffer busy acquire	332	0	6	17	0.03	0.07
row cache lock	5,090	0	3	1	0.51	0.04
Disk file operations I/O	8,535	0	2	0	0.85	0.03
gc current grant busy	10,400	0	2	0	1.04	0.02
library cache: mutex X	746	0	2	2	0.07	0.02
enq: TX - row lock contention	12	0	1	92	0.00	0.01
latch: shared pool	1,167	0	1	1	0.12	0.01
db file scattered read	30	0	1	24	0.00	0.01
enq: TX - index contention	44	0	1	14	0.00	0.01
SQL*Net message to client	705,824	0	1	0	70.60	0.01
gc cr grant 2-way	3,030	0	0	0	0.30	0.01
gc current grant 2-way	3,324	0	0	0	0.33	0.01
latch free	6	0	0	63	0.00	0.00
library cache pin	1,528	0	0	0	0.15	0.00
library cache lock	1,199	1	0	0	0.12	0.00
ADR block file read	35	0	0	6	0.00	0.00
PX Deq: Slave Session Stats	1,301	0	0	0	0.13	0.00
buffer busy waits	94	0	0	2	0.01	0.00
enq: PS - contention	469	5	0	0	0.05	0.00
gc cr multi block request	342	0	0	0	0.03	0.00
SQL*Net more data to client	11,763	0	0	0	1.18	0.00
read by other session	2	0	0	55	0.00	0.00
kksfbc child completion	2	100	0	51	0.00	0.00
ASM file metadata operation	4	0	0	22	0.00	0.00
PX Deq: reap credit	10,359	100	0	0	1.04	0.00
log file switch completion	1	0	0	61	0.00	0.00
IPC send completion sync	513	0	0	0	0.05	0.00
gc current block congested	135	0	0	0	0.01	0.00
gc cr block congested	131	0	0	0	0.01	0.00
PX Deq: Signal ACK RSG	849	0	0	0	0.08	0.00
ADR block file write	5	0	0	6	0.00	0.00
SQL*Net more data from client	2,004	0	0	0	0.20	0.00
rdbms ipc reply	708	0	0	0	0.07	0.00
SQL*Net break/reset to client	246	0	0	0	0.02	0.00
asynch descriptor resize	799	100	0	0	0.08	0.00
PX Deq: Signal ACK EXT	849	0	0	0	0.08	0.00
gc current multi block request	40	0	0	0	0.00	0.00
cursor: pin S wait on X	6	0	0	2	0.00	0.00
gc current split	6	0	0	2	0.00	0.00
gc current retry	9	0	0	1	0.00	0.00
CSS initialization	4	0	0	2	0.00	0.00
DFS lock handle	21	10	0	0	0.00	0.00
enq: HW - contention	20	0	0	0	0.00	0.00
CSS operation: action	4	0	0	2	0.00	0.00
enq: JQ - contention	12	100	0	0	0.00	0.00
enq: TT - contention	13	0	0	0	0.00	0.00
gc current grant congested	19	0	0	0	0.00	0.00
gc cr grant congested	17	0	0	0	0.00	0.00
latch: cache buffers chains	98	0	0	0	0.01	0.00
enq: FB - contention	7	0	0	0	0.00	0.00
CSS operation: query	12	0	0	0	0.00	0.00
SQL*Net message from client	705,824	0	844,182	1196	70.60
Streams AQ: waiting for messages in the queue	722	99	3,592	4975	0.07
wait for unread message on broadcast channel	3,596	100	3,591	999	0.36
jobq slave wait	1,919	100	961	501	0.19
PX Deq: Execution Msg	1,808	0	5	3	0.18
PX Deq: Execute Reply	849	0	3	4	0.08
PX Deq: Parse Reply	849	0	1	2	0.08
PX Deq: Join ACK	849	0	0	0	0.08
PX Deq Credit: send blkd	48	0	0	0	0.00
KSV master wait	20	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	20,348	0	627	31	2.04	38.67
control file sequential read	330,778	0	391	1	33.09	24.09
gcs log flush sync	26,293	61	192	7	2.63	11.81
db file parallel write	11,749	0	184	16	1.18	11.37
reliable message	383	17	67	175	0.04	4.14
Streams AQ: qmn coordinator waiting for slave to start	6	100	38	6288	0.00	2.33
control file parallel write	1,759	0	37	21	0.18	2.30
db file sequential read	243	0	9	38	0.02	0.57
log file sequential read	159	0	3	21	0.02	0.20
ASM file metadata operation	1,255	0	3	2	0.13	0.18
os thread startup	60	0	1	19	0.01	0.07
SQL*Net more data from client	2,329	0	1	0	0.23	0.04
row cache lock	2,873	0	1	0	0.29	0.03
latch: shared pool	16	0	0	27	0.00	0.03
row cache process	62,865	0	0	0	6.29	0.03
gc cr block busy	5	0	0	80	0.00	0.02
direct path write	10	0	0	23	0.00	0.01
CSS operation: data query	180	0	0	1	0.02	0.01
ksxr poll remote instances	26,929	100	0	0	2.69	0.01
CGS wait for IPC msg	30,036	100	0	0	3.00	0.01
enq: KO - fast object checkpoint	797	0	0	0	0.08	0.01
latch free	17	0	0	8	0.00	0.01
gc cr block 2-way	561	0	0	0	0.06	0.01
gc current block 2-way	520	0	0	0	0.05	0.01
ges lms sync during dynamic remastering and reconfig	24	0	0	4	0.00	0.01
row cache cleanup	42,476	0	0	0	4.25	0.01
ges inquiry response	494	0	0	0	0.05	0.01
log file single write	12	0	0	7	0.00	0.01
kfk: async disk IO	9	0	0	8	0.00	0.00
direct path read	6	0	0	11	0.00	0.00
library cache pin	344	0	0	0	0.03	0.00
library cache lock	324	0	0	0	0.03	0.00
ges LMON to get to FTDONE	3	67	0	18	0.00	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	8	0	0	7	0.00	0.00
gc cr multi block request	54	0	0	1	0.01	0.00
ADR block file read	15	0	0	2	0.00	0.00
log file sync	2	0	0	19	0.00	0.00
CSS group membership query	60	0	0	1	0.01	0.00
asynch descriptor resize	3,052	100	0	0	0.31	0.00
ADR block file write	5	0	0	6	0.00	0.00
enq: CF - contention	112	88	0	0	0.01	0.00
latch: object queue header operation	1	0	0	27	0.00	0.00
DFS lock handle	149	89	0	0	0.01	0.00
gc current grant busy	160	0	0	0	0.02	0.00
SQL*Net more data to client	2,329	0	0	0	0.23	0.00
Log archive I/O	3	0	0	8	0.00	0.00
undo segment extension	3	67	0	7	0.00	0.00
PX Deq: reap credit	2,493	100	0	0	0.25	0.00
libcache interrupt action by LCK	31,312	0	0	0	3.13	0.00
gc object scan	7,446	100	0	0	0.74	0.00
enq: TQ - TM contention	9	0	0	1	0.00	0.00
gc current grant 2-way	75	0	0	0	0.01	0.00
gc current block busy	1	0	0	7	0.00	0.00
Disk file operations I/O	123	0	0	0	0.01	0.00
rdbms ipc reply	148	0	0	0	0.01	0.00
db file async I/O submit	7,655	0	0	0	0.77	0.00
CSS initialization	2	0	0	3	0.00	0.00
gc cr grant 2-way	42	0	0	0	0.00	0.00
CSS operation: action	10	0	0	0	0.00	0.00
SQL*Net message to client	8,908	0	0	0	0.89	0.00
enq: US - contention	26	0	0	0	0.00	0.00
enq: TT - contention	26	46	0	0	0.00	0.00
enq: PS - contention	14	14	0	0	0.00	0.00
LGWR wait for redo copy	105	0	0	0	0.01	0.00
PX Deq: Slave Session Stats	18	0	0	0	0.00	0.00
enq: WF - contention	10	0	0	0	0.00	0.00
enq: TM - contention	9	89	0	0	0.00	0.00
enq: TD - KTF dump entries	7	0	0	0	0.00	0.00
enq: TA - contention	7	0	0	0	0.00	0.00
rdbms ipc message	142,851	41	88,639	621	14.29
class slave wait	623	0	8,674	13923	0.06
wait for unread message on broadcast channel	7,184	90	7,183	1000	0.72
DIAG idle wait	84,589	70	7,170	85	8.46
gcs remote message	799,797	77	6,975	9	80.00
Space Manager: slave idle wait	1,123	98	5,575	4964	0.11
Streams AQ: qmn slave idle wait	152	5	3,995	26282	0.02
dispatcher timer	60	100	3,600	60002	0.01
PING	1,346	21	3,599	2674	0.13
Streams AQ: waiting for time management or cleanup tasks	317	82	3,594	11337	0.03
GCR sleep	721	100	3,591	4980	0.07
ASM background timer	805	0	3,591	4461	0.08
pmon timer	1,197	100	3,590	3000	0.12
ges remote message	59,584	53	3,590	60	5.96
PX Idle Wait	452	0	3,584	7930	0.05
shared server idle wait	119	100	3,570	30003	0.01
smon timer	23	35	3,567	155077	0.00
Streams AQ: qmn coordinator idle wait	254	48	3,555	13994	0.03
SQL*Net message from client	11,876	0	42	4	1.19
KSV master wait	2,425	90	3	1	0.24
heartbeat monitor sleep	30	0	0	1	0.00
PX Deq: Join ACK	18	0	0	1	0.00
PX Deq: Parse Reply	18	0	0	0	0.00
PX Deq: Execute Reply	18	0	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	257	100	0	0	0.03

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	50	34.0	4.0	4.0	38.0	18.0		2.0
ADR block file write	10				90.0	10.0
ADR file lock	12	100.0
ARCH wait for archivelog lock	3	100.0
ASM file metadata operation	1259	97.3	.7	.2		.2	1.0	.6
CGS wait for IPC msg	30K	100.0
CSS group membership query	60	100.0
CSS initialization	6	50.0		16.7	33.3
CSS operation: action	14	57.1	28.6	14.3
CSS operation: data query	180	12.2	87.8
CSS operation: query	78	98.7	1.3
DFS lock handle	170	100.0
Disk file operations I/O	8659	100.0						.0
IPC send completion sync	525	100.0
KJC: Wait for msg sends to complete	32	100.0
LGWR wait for redo copy	106	100.0
Log archive I/O	3	33.3				66.7
PX Deq: Signal ACK EXT	867	99.9		.1
PX Deq: Signal ACK RSG	867	100.0
PX Deq: Slave Session Stats	1319	100.0
PX Deq: reap credit	12.9K	100.0
SQL*Net break/reset to client	246	99.6	.4
SQL*Net message to client	714.8K	100.0
SQL*Net more data from client	4335	96.5	1.5	2.0	.0
SQL*Net more data to client	14.1K	100.0
Streams AQ: qmn coordinator waiting for slave to start	6								100.0
asynch descriptor resize	3850	99.9	.0			.0
buffer busy waits	100	95.0	3.0	1.0				1.0
buffer deadlock	2	100.0
control file parallel write	1758	68.7	1.4	2.6	2.0	2.2	4.7	18.5
control file sequential read	332.8K	97.6	.7	.4	.1	.1	.2	1.0
cursor: pin S	1	100.0
cursor: pin S wait on X	6	16.7	33.3	50.0
db file async I/O submit	7603	100.0
db file parallel read	1312	6.8	1.5	3.6	26.4	28.4	10.4	22.8	.2
db file parallel write	11.7K	65.5	4.5	4.0	6.3	3.7	2.8	13.2
db file scattered read	30	33.3	6.7	3.3	16.7	6.7	6.7	26.7
db file sequential read	7827	9.0	1.2	8.5	40.2	15.2	5.1	20.7	.0
direct path read	331.4K	24.4	11.7	25.9	23.2	5.8	1.8	7.2	.0
direct path read temp	13.3K	14.3	12.6	4.3	19.6	34.8	4.3	10.1
direct path write	10	60.0		10.0				30.0
direct path write temp	13.4K	7.2	17.5	59.3	3.2	3.1	1.7	7.9
enq: AE - lock	2	100.0
enq: AF - task serialization	1	100.0
enq: CF - contention	115	99.1		.9
enq: CR - block range reuse ckpt	5	100.0
enq: DR - contention	2	100.0
enq: FB - contention	9	100.0
enq: HW - contention	25	100.0
enq: JQ - contention	12	100.0
enq: JS - job run lock - synchronize	1	100.0
enq: KO - fast object checkpoint	3128	83.1	3.5	.9	1.9	1.9	1.6	7.1	.1
enq: PS - contention	483	99.6	.2	.2
enq: TA - contention	7	100.0
enq: TD - KTF dump entries	7	100.0
enq: TM - contention	9	100.0
enq: TQ - TM contention	9	88.9				11.1
enq: TT - contention	39	100.0
enq: TX - index contention	44	70.5			4.5	13.6	2.3	9.1
enq: TX - row lock contention	13					38.5	15.4	46.2
enq: UL - contention	1	100.0
enq: US - contention	26	100.0
enq: WF - contention	10	100.0
enq: WL - contention	2	100.0
gc buffer busy acquire	332	79.5	4.5	1.5	.9	2.1	.6	10.8
gc buffer busy release	272	20.6	1.1	.7	2.6	1.8	4.8	68.4
gc cr block 2-way	25.7K	99.9	.1	.0	.0	.0
gc cr block busy	689	65.9	10.4	2.3	2.9	3.8	2.2	12.5
gc cr block congested	132	100.0
gc cr disk read	1	100.0
gc cr grant 2-way	3071	98.5	.7	.6	.2
gc cr grant congested	17	100.0
gc cr multi block request	396	94.7	4.3	.8	.3
gc current block 2-way	29.5K	99.9	.1	.0	.0		.0
gc current block busy	878	54.3	8.1	4.4	5.4	10.8	3.9	13.1
gc current block congested	134	99.3	.7
gc current grant 2-way	3412	100.0
gc current grant busy	10.6K	99.8	.0	.1	.0	.1
gc current grant congested	19	100.0
gc current multi block request	46	100.0
gc current retry	9	88.9				11.1
gc current split	6	83.3				16.7
gc object scan	7446	100.0
gcs log flush sync	26.3K	22.7	3.1	4.6	6.1	63.4
ges LMON to get to FTDONE	3					33.3	66.7
ges inquiry response	494	100.0
ges lms sync during dynamic remastering and reconfig	24		16.7	33.3	50.0
global enqueue expand wait	1	100.0
kfk: async disk IO	9	55.6			33.3			11.1
kjbdrmcvtq lmon drm quiesce: ping completion	8				87.5	12.5
kksfbc child completion	2							100.0
ksxr poll remote instances	26.9K	100.0
latch free	23	21.7			47.8	21.7		8.7
latch: active service list	1	100.0
latch: cache buffers chains	101	100.0
latch: cache buffers lru chain	1	100.0
latch: call allocation	17	100.0
latch: gc element	3	100.0
latch: ges resource hash list	9	100.0
latch: messages	1	100.0
latch: object queue header operation	3	66.7					33.3
latch: shared pool	1186	98.7	.8	.3			.2	.1
libcache interrupt action by LCK	31.3K	100.0
library cache lock	1523	99.6	.3	.1
library cache pin	1872	99.8	.1	.1	.1
library cache: mutex X	748	85.6				13.6	.1	.7
lock escalate retry	1	100.0
log file parallel write	20.3K	61.9	1.9	2.5	3.1	3.5	3.5	23.5
log file sequential read	159	23.9	2.5	5.0	8.8	17.6	20.8	21.4
log file single write	12	41.7			41.7	8.3		8.3
log file switch completion	1							100.0
log file sync	14.2K	43.7	2.2	2.3	4.3	4.7	4.6	38.3	.0
os thread startup	60					16.7	83.3
rdbms ipc reply	868	99.9	.1
read by other session	2	50.0						50.0
reliable message	3606	78.6	18.0	.4	.1		.1	2.9
row cache cleanup	42.4K	100.0	.0	.0
row cache lock	7940	99.3	.4	.1	.0	.0	.0	.1
row cache process	62.8K	100.0
undo segment extension	3	66.7					33.3
ASM background timer	805	6.0	.9	.4	.4	.1	1.0	1.1	90.2
DIAG idle wait	84.5K	10.6	.9	.4	.1	11.9	26.7	49.4
GCR sleep	721	.4							99.6
KSV master wait	2445	98.9	.4	.1		.1	.2	.3
PING	1342	78.8							21.2
PX Deq Credit: send blkd	48	100.0
PX Deq: Execute Reply	867	87.8	4.3	4.3	.5	.7	1.5	1.0
PX Deq: Execution Msg	1808	94.4	4.3	.3		.3		.7	.1
PX Deq: Join ACK	867	98.7	1.3
PX Deq: Msg Fragment	48	100.0
PX Deq: Parse Reply	867	95.2	3.5		.1	.1		1.2
PX Idle Wait	452	40.3	27.2	9.1	2.4	3.1	.4	5.1	12.4
SQL*Net message from client	717.9K	81.8	11.3	1.9	1.3	.5	.3	1.0	1.9
Space Manager: slave idle wait	1125			.1				.3	99.6
Streams AQ: RAC qmn coordinator idle wait	257	100.0
Streams AQ: qmn coordinator idle wait	254	49.2							50.8
Streams AQ: qmn slave idle wait	152								100.0
Streams AQ: waiting for messages in the queue	721						.1	.3	99.6
Streams AQ: waiting for time management or cleanup tasks	317	16.7						41.3	42.0
class slave wait	622	41.3	.8	8.4	3.1	1.9	1.9	12.4	30.2
dispatcher timer	60								100.0
gcs remote message	799.5K	10.5	2.6	3.4	4.7	78.8
ges remote message	59.6K	29.2	2.9	2.3	1.7	1.5	2.2	60.1
heartbeat monitor sleep	30	56.7	43.3
jobq slave wait	1919							100.0
pmon timer	1196								100.0
rdbms ipc message	142.8K	33.8	2.7	2.6	2.2	1.7	1.4	41.5	14.1
shared server idle wait	119								100.0
smon timer	26		3.8					11.5	84.6
wait for unread message on broadcast channel	10.8K				.0	.1	.0	99.9

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 read	1	98.0	2.0
ASM file metadata operation	7	99.4		.2	.1		.3
Disk file operations I/O	4	100.0			.0	.0	.0
buffer busy waits	1	99.0			1.0
control file parallel write	325	81.5	7.2	7.3	2.8	1.1
control file sequential read	3227	99.0	.3	.5	.2	.0	.0
db file parallel read	301	77.0	6.2	11.8	4.0	.7	.1	.2	.1
db file parallel write	1547	86.8	4.1	6.1	2.2	.6
db file scattered read	8	73.3	10.0	16.7
db file sequential read	1625	79.2	4.9	11.9	3.3	.6	.1	.0
direct path read	24K	92.8	1.3	3.5	1.8	.7	.1	.0	.0
direct path read temp	1348	89.9	1.9	6.6	1.2	.4
direct path write	3	70.0	10.0	20.0
direct path write temp	1058	92.1	1.4	4.3	1.6	.7	.0
enq: KO - fast object checkpoint	223	92.8	1.6	2.7	1.5	.9	.3	.0	.0
enq: TX - index contention	4	90.9	4.5	2.3		2.3
enq: TX - row lock contention	6	53.8	23.1	15.4			7.7
gc buffer busy acquire	36	89.2	4.2	2.4	2.1	2.1
gc buffer busy release	186	31.6	9.6	21.3	19.9	15.4	2.2
gc cr block busy	86	87.5	3.3	4.6	3.2	1.0	.3
gc current block busy	115	86.9	4.8	5.5	2.4	.5
kfk: async disk IO	1	88.9	11.1
kksfbc child completion	2		100.0
latch free	2	91.3	4.3			4.3
latch: shared pool	1	99.9		.1
library cache: mutex X	5	99.3	.3	.3		.1
log file parallel write	4791	76.5	5.1	11.7	5.0	1.7	.0
log file sequential read	34	78.6	14.5	6.9
log file single write	1	91.7	8.3
log file switch completion	1		100.0
log file sync	5426	61.7	7.1	12.6	10.1	6.6	1.8	.0
read by other session	1	50.0		50.0
reliable message	103	97.1	.1	.2	.1	.2	2.2
row cache lock	9	99.9	.0	.0	.0	.0

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
		% of Total Waits
Streams AQ: qmn coordinator waiting for slave to start	6			100.0
db file parallel read	1	99.9	.1
direct path read	1	100.0	.0
enq: KO - fast object checkpoint	1	100.0	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
oradb	7,215	1,657	57,037	112,566
SYS$USERS	669	85	927	656
SYS$BACKGROUND	0	0	0	125
oradbXDB	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
oradb	346768	4641	6387	6	715683	1
SYS$USERS	29223	547	3580	1	3914	0
SYS$BACKGROUND	386	10	35003	2	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 18.5% of Total DB Time (s): 7,879
Captured PL/SQL account for 0.0% of Total DB Time (s): 7,879

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
468.64	12	39.05	5.95	14.82	85.19	ct78468spkzrt		select count(*) from v$lock
114.82	1	114.82	1.46	11.52	0.00	1cd2krbdzrhvq		insert into wrh$_tempstatxs (s...
107.38	20	5.37	1.36	7.15	90.76	ffmfqt8a9vyry	w3wp.exe	select count(*) from ics_order...
75.48	2	37.74	0.96	1.17	97.69	gsfyvunsujbrw	w3wp.exe	select count(*) from ics_order...
58.49	9	6.50	0.74	5.74	94.06	0sjaskcqpdfmc	w3wp.exe	select * from (select a.*, row...
47.03	3	15.68	0.60	24.99	74.36	cswn2scb5qy25	w3wp.exe	select * from ics_order where ...
40.05	2	20.03	0.51	2.26	97.10	bk7jp5jq5k1bu	w3wp.exe	select count(*) from ics_order...
34.68	2	17.34	0.44	2.15	96.57	4g42vt1rhvbc8	w3wp.exe	select count(*) from ics_order...
30.11	3	10.04	0.38	37.45	62.08	b9nt5kjsvd5ug	w3wp.exe	select * from ics_order where ...
28.99	4	7.25	0.37	4.97	95.02	afgq31rst0z0b	w3wp.exe	select count(*) from ics_order...

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 15.4% of Total CPU Time (s): 1,739
Captured PL/SQL account for 0.0% of Total CPU Time (s): 1,739

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
69.44	12	5.79	3.99	468.64	14.82	85.19	ct78468spkzrt		select count(*) from v$lock
22.18	330	0.07	1.28	22.44	98.85	0.00	5nwqnvv6tn881	w3wp.exe	select count(*) from ics_order...
13.23	1	13.23	0.76	114.82	11.52	0.00	1cd2krbdzrhvq		insert into wrh$_tempstatxs (s...
11.75	3	3.92	0.68	47.03	24.99	74.36	cswn2scb5qy25	w3wp.exe	select * from ics_order where ...
11.27	3	3.76	0.65	30.11	37.45	62.08	b9nt5kjsvd5ug	w3wp.exe	select * from ics_order where ...
8.85	3	2.95	0.51	13.21	66.99	32.45	c85unpq0xxzty	w3wp.exe	select * from ics_order where ...
7.68	20	0.38	0.44	107.38	7.15	90.76	ffmfqt8a9vyry	w3wp.exe	select count(*) from ics_order...
6.87	164	0.04	0.39	6.98	98.38	0.00	4m0vs1ru52rks	w3wp.exe	select count(*) from ics_feipi...
6.26	164	0.04	0.36	6.35	98.53	0.01	f88j76h3cs43z	w3wp.exe	select count(count(*)) from ic...
5.26	164	0.03	0.30	5.31	99.08	0.00	4s83p6gpn8rhr	w3wp.exe	select count(count(*)) from ic...

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 19.6% of Total User I/O Wait Time (s): 5,198
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 5,198

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
399.25	12	33.27	7.68	468.64	14.82	85.19	ct78468spkzrt		select count(*) from v$lock
97.45	20	4.87	1.87	107.38	7.15	90.76	ffmfqt8a9vyry	w3wp.exe	select count(*) from ics_order...
73.74	2	36.87	1.42	75.48	1.17	97.69	gsfyvunsujbrw	w3wp.exe	select count(*) from ics_order...
55.02	9	6.11	1.06	58.49	5.74	94.06	0sjaskcqpdfmc	w3wp.exe	select * from (select a.*, row...
38.89	2	19.45	0.75	40.05	2.26	97.10	bk7jp5jq5k1bu	w3wp.exe	select count(*) from ics_order...
34.97	3	11.66	0.67	47.03	24.99	74.36	cswn2scb5qy25	w3wp.exe	select * from ics_order where ...
33.49	2	16.75	0.64	34.68	2.15	96.57	4g42vt1rhvbc8	w3wp.exe	select count(*) from ics_order...
27.55	4	6.89	0.53	28.99	4.97	95.02	afgq31rst0z0b	w3wp.exe	select count(*) from ics_order...
21.29	1	21.29	0.41	25.83	16.47	82.42	dfgut05uv2tza	w3wp.exe	select * from ics_order where ...
18.69	3	6.23	0.36	30.11	37.45	62.08	b9nt5kjsvd5ug	w3wp.exe	select * from ics_order where ...

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: 113,295,557
Captured SQL account for 17.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
7,138,978	330	21,633.27	6.30	22.44	98.9	0	5nwqnvv6tn881	w3wp.exe	select count(*) from ics_order...
2,387,843	164	14,560.02	2.11	5.31	99.1	0	4s83p6gpn8rhr	w3wp.exe	select count(count(*)) from ic...
1,968,721	164	12,004.40	1.74	6.98	98.4	0	4m0vs1ru52rks	w3wp.exe	select count(*) from ics_feipi...
1,734,261	20	86,713.05	1.53	107.38	7.2	90.8	ffmfqt8a9vyry	w3wp.exe	select count(*) from ics_order...
1,326,185	164	8,086.49	1.17	6.35	98.5	0	f88j76h3cs43z	w3wp.exe	select count(count(*)) from ic...
780,450	9	86,716.67	0.69	58.49	5.7	94.1	0sjaskcqpdfmc	w3wp.exe	select * from (select a.*, row...
346,865	4	86,716.25	0.31	28.99	5	95	afgq31rst0z0b	w3wp.exe	select count(*) from ics_order...
260,182	3	86,727.33	0.23	47.03	25	74.4	cswn2scb5qy25	w3wp.exe	select * from ics_order where ...
260,170	3	86,723.33	0.23	30.11	37.4	62.1	b9nt5kjsvd5ug	w3wp.exe	select * from ics_order where ...
260,142	3	86,714.00	0.23	13.21	67	32.4	c85unpq0xxzty	w3wp.exe	select * from ics_order where ...

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: 57,897,190
Captured SQL account for 11.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,733,940	20	86,697.00	2.99	107.38	7.15	90.76	ffmfqt8a9vyry	w3wp.exe	select count(*) from ics_order...
780,273	9	86,697.00	1.35	58.49	5.74	94.06	0sjaskcqpdfmc	w3wp.exe	select * from (select a.*, row...
410,192	12	34,182.67	0.71	468.64	14.82	85.19	ct78468spkzrt		select count(*) from v$lock
346,788	4	86,697.00	0.60	28.99	4.97	95.02	afgq31rst0z0b	w3wp.exe	select count(*) from ics_order...
260,091	3	86,697.00	0.45	30.11	37.45	62.08	b9nt5kjsvd5ug	w3wp.exe	select * from ics_order where ...
260,091	3	86,697.00	0.45	13.21	66.99	32.45	c85unpq0xxzty	w3wp.exe	select * from ics_order where ...
260,091	3	86,697.00	0.45	47.03	24.99	74.36	cswn2scb5qy25	w3wp.exe	select * from ics_order where ...
173,394	2	86,697.00	0.30	34.68	2.15	96.57	4g42vt1rhvbc8	w3wp.exe	select count(*) from ics_order...
173,394	2	86,697.00	0.30	16.01	4.75	94.52	dbx1xgv14t1cp	w3wp.exe	select * from (select a.*, row...
87,718	2	43,859.00	0.15	75.48	1.17	97.69	gsfyvunsujbrw	w3wp.exe	select count(*) from ics_order...

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: 480,742
Captured SQL account for 78.8% of Total
Total UnOptimized Read Requests: 480,742
Captured SQL account for 78.8% 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
320,008	320,008	1	320,008.00	66.57	1cd2krbdzrhvq		insert into wrh$_tempstatxs (s...
13,600	13,600	20	680.00	2.83	ffmfqt8a9vyry	w3wp.exe	select count(*) from ics_order...
13,232	13,232	12	1,102.67	2.75	ct78468spkzrt		select count(*) from v$lock
6,120	6,120	9	680.00	1.27	0sjaskcqpdfmc	w3wp.exe	select * from (select a.*, row...
2,720	2,720	4	680.00	0.57	afgq31rst0z0b	w3wp.exe	select count(*) from ics_order...
1,360	1,360	2	680.00	0.28	4g42vt1rhvbc8	w3wp.exe	select count(*) from ics_order...
1,360	1,360	2	680.00	0.28	dbx1xgv14t1cp	w3wp.exe	select * from (select a.*, row...
690	690	2	345.00	0.14	gsfyvunsujbrw	w3wp.exe	select count(*) from ics_order...
688	688	2	344.00	0.14	bk7jp5jq5k1bu	w3wp.exe	select count(*) from ics_order...
680	680	1	680.00	0.14	1gfut0jn7z3y4	w3wp.exe	select * from tbics_passengeri...

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: 351,874
Captured SQL account for 17.9% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
7,956	39,118	4.92	5.57	41.9	.9	94h2a7cs7a7fc	AutoTicket.exe	select * from ICS_AutoTicketTa...
6,334	906	0.14	0.65	103.3	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
3,202	3,202	1.00	1.29	69.9	.1	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
2,978	6,342	2.13	1.64	98.3	0	0k8522rmdzg4k		select privilege# from sysauth...
2,978	2,978	1.00	8.18	26.8	.1	9rkx7dk6m8959	w3wp.exe	SELECT TBICS_OPERATE_LOG_SQN.N...
2,969	2,969	1.00	0.86	97.8	0	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2,969	2,969	1.00	0.81	99.5	0	459f3z9u4fb3u		select value$ from props$ wher...
2,969	2,969	1.00	27.83	16.5	2.5	4vs91dcv7u1p6	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
2,969	2,969	1.00	0.70	99.9	0	5ur69atw3vfhj		select decode(failover_method,...
2,963	2,963	1.00	16.56	10.7	.3	f711myt0q6cma	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 222,423
Captured SQL account for 14.5% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,978	2,978	1.34	0k8522rmdzg4k		select privilege# from sysauth...
2,978	6,334	1.34	cm5vu20fhtnq1		select /*+ connect_by_filterin...
2,969	2,969	1.33	459f3z9u4fb3u		select value$ from props$ wher...
2,969	2,969	1.33	4vs91dcv7u1p6	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
2,969	2,969	1.33	5ur69atw3vfhj		select decode(failover_method,...
2,968	2,969	1.33	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2,963	2,963	1.33	f711myt0q6cma	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
1,122	3,202	0.50	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
1,101	2,978	0.50	9rkx7dk6m8959	w3wp.exe	SELECT TBICS_OPERATE_LOG_SQN.N...
879	1,773	0.40	ba6n0vrmtz8vu	w3wp.exe	UPDATE CHANNEL_ORDER SET ORDER...

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
1,797,582	54	0.05	2tkw12w5k68vd		select user#, password, datats...
1,422,809	12	0.04	9juw6s4yy5pzp	emagent_SQL_rac_database	/* OracleOEM */ SELECT SUM(bro...
1,383,629	10	0.04	0v6s91manuhz8	emagent_SQL_rac_database	/* OracleOEM */ SELECT blockin...
1,374,899	881	0.04	9tgj4g8y4rwy8		select type#, blocks, extents,...
1,157,540	512	0.03	3w4qs0tbpmxr6		select con#, obj#, rcon#, enab...
1,126,071	1,622	0.03	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
1,083,871	1,622	0.03	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

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

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
23.31	2,969	27.17	27.83	83.77	16.51	2.49	4vs91dcv7u1p6	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
14.85	2,963	17.30	16.56	89.66	10.65	0.29	f711myt0q6cma	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
3.40	7,956	3.96	5.57	61.11	41.86	0.89	94h2a7cs7a7fc	AutoTicket.exe	select * from ICS_AutoTicketTa...
3.36	2,978	3.92	8.18	41.12	26.82	0.09	9rkx7dk6m8959	w3wp.exe	SELECT TBICS_OPERATE_LOG_SQN.N...
3.08	1,261	3.58	3.40	90.47	12.14	0.20	axmdf8vq7k1rh		select increment$, minvalue, m...
0.68	303	0.80	1.81	37.79	65.13	0.11	chf20zq23a82a	w3wp.exe	select * from (select /*+ FIRS...
0.43	3,202	0.50	1.29	33.22	69.95	0.06	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
0.33	594	0.39	3.39	9.76	91.65	0.12	f5tz11uhm37fs	w3wp.exe	select * from (select /*+ FIRS...
0.20	330	0.23	22.44	0.90	98.85	0.00	5nwqnvv6tn881	w3wp.exe	select count(*) from ics_order...
0.10	1,510	0.12	0.37	27.67	79.30	1.63	1gv747j5pzk2d	w3wp.exe	select * from ICS_OTHERORDER_S...
0.10	8	0.12	0.27	36.70	65.71	0.39	bh7sw006tkt9k	w3wp.exe	select PolicyID, FromCity, ToC...
0.10	164	0.11	6.98	1.41	98.38	0.00	4m0vs1ru52rks	w3wp.exe	select count(*) from ics_feipi...
0.08	164	0.09	6.35	1.18	98.53	0.01	f88j76h3cs43z	w3wp.exe	select count(count(*)) from ic...
0.06	1,161	0.07	0.22	27.18	82.38	0.65	20ny5g0f6g8x4	AutoReturn.exe	select * from ICS_OTHERORDER_S...
0.04	164	0.05	5.31	0.83	99.08	0.00	4s83p6gpn8rhr	w3wp.exe	select count(count(*)) from ic...
0.02	12	0.03	3.01	0.81	99.04	0.01	gkzsc3tg5uahf	w3wp.exe	select POLICYID, AIRCOM, CABIN...
0.02	7	0.02	0.46	3.84	97.10	0.05	61wcgj1a8ktrg	w3wp.exe	select PolicyID, FromCity, ToC...
0.02	188	0.02	0.07	24.73	94.32	3.13	98985j06ajttt	w3wp.exe	select * from Bsp_Office where...
0.01	901	0.02	0.13	10.38	96.62	1.84	486ppy6x0nxk2	w3wp.exe	select * from suspendsupplierm...
0.01	20	0.01	107.38	0.01	7.15	90.76	ffmfqt8a9vyry	w3wp.exe	select count(*) from ics_order...
0.01	7	0.01	1.86	0.35	99.61	0.01	8qfcnp8dyrr1h	w3wp.exe	select POLICYID, AIRCOM, CABIN...
0.01	42	0.01	10.79	0.05	1.33	0.00	57zg6b0tm2tdq		select round(100 - (free.free/...
0.01	9	0.01	58.49	0.01	5.74	94.06	0sjaskcqpdfmc	w3wp.exe	select * from (select a.*, row...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0sjaskcqpdfmc select * from (select a.*, rownum rownumber from(select ORDERID, ORDERTIME, PNR||'-'||bigpnr PNR, SEATNUM, SEGTYPE, FROMCITY, TOCITY, OT_TYPE, orderFrom, logname from ics_order where 1=1 and PNR='JZ7C4Y' and instr(', TMCY6, TMC-X5(100123), 600047, YYX, TMCX5, TMC, TMC-X(410006), TMC-Y0(600046), TMC-Y6(80801), 600046, TMC-X4(600047), TMC-Y6(800826), ', ', '||orderfrom||', ')>0 and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票' order by ordertime desc) a) ics_order where ics_order.rownumber <=15

0v6s91manuhz8 /* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name||'-'||l.sid, 2, i.instance_name||'-'||l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

1cd2krbdzrhvq insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ftio.kcftiopyr, ftio.kcftiopyw, ftio.kcftiosbr, floor(ftio.kcftioprt / 10000), floor(ftio.kcftiopwt / 10000), floor(ftio.kcftiosbt / 10000), ftio.kcftiopbr, ftio.kcftiopbw, fw.count, fw.time from x$kcftio ftio, x$kcctf tf, x$kcbfwait fw, x$kccfn fn, x$kccts ts where ts.tstsn = tf.tftsn and ftio.kcftiofno = fn.fnfno and tf.tfnum = fn.fnfno and tf.tffnh = fn.fnnum and tf.tfdup <> 0 and fn.fntyp = 7 and fn.fnnam is not null and bitand(tf.tfsta, 32) <> 32 and fw.indx+1 = (fn.fnfno + :db_files)

1gfut0jn7z3y4 select * from tbics_passengerinfo where orderid = (select orderid from ics_order where ordertime = (select max(ORDERTIME) from ics_order where bigpnr = 'MC3Q2F') and bigpnr='MC3Q2F')

1gv747j5pzk2d select * from ICS_OTHERORDER_SYNCH

20ny5g0f6g8x4 select * from ICS_OTHERORDER_SYNCH where othercompanyname=:othercompanyname

2tkw12w5k68vd select user#, password, datats#, tempts#, type#, defrole, resource$, ptime, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1, spare4, ext_username, spare2 from user$ where name=:1

3w4qs0tbpmxr6 select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

486ppy6x0nxk2 select * from suspendsuppliermgr

4g42vt1rhvbc8 select count(*) from ics_order where 1=1 and PNR='HNQ4K7' and orderfrom in('51BK', '517', '百拓', '19E', '今日', '19E废票', '票盟', '票盟废票', '517SZX', '易行', '51BKSZX', '百拓SZX', '517SZX废票', '517废票') and orderfrom != 'SHBJDLS'

4m0vs1ru52rks select count(*) from ics_feipiao x, ( select b.orderid, max(b.passengerid) as psid from (select distinct(orderid) from ics_feipiao where fstate=0 AND operatetype =1 ) a, ics_feipiao b where a.orderid=b.orderid group by b.orderID) z, icsorder o where x.orderid = o.orderid and x.passengerid = z.psid AND fstate=0 AND operatetype =1 and o.orderfrom in('51BK', '517', '百拓', '19E', '今日', '19E废票', '票盟', '票盟废票', '517SZX', '易行', '51BKSZX', '百拓SZX', '517SZX废票', '517废票') and o.orderfrom != 'SHBJDLS'

4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1

4s83p6gpn8rhr select count(count(*)) from ics_feipiao x left join icsorder o on x.orderid = o.orderid where fstate = 0 AND operatetype = 4 and o.orderfrom!='51BK' and o.orderfrom!='517' and o.orderfrom!='百拓' and o.orderfrom!='19E' and o.orderfrom!='今日' and o.orderfrom!='19E废票' and o.orderfrom!='票盟' and o.orderfrom!='票盟废票' and o.orderfrom!='517SZX' and o.orderfrom!='易行' and o.orderfrom!='51BKSZX' and o.orderfrom!='百拓SZX' and o.orderfrom!='517SZX废票' and o.orderfrom!='517废票' and x.psname is not null group by x.orderid

4vs91dcv7u1p6 insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :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)

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

57zg6b0tm2tdq select round(100 - (free.free/tot.total)*100, 2) used_pct from (select tablespace_name, (sum(bytes)/1048576) total from sys.dba_data_files group by tablespace_name) tot, (select tablespace_name, (sum(bytes)/1048576) free from sys.dba_free_space group by tablespace_name) free where free.tablespace_name=tot.tablespace_name and tot.tablespace_name=:1 order by used_pct

5nwqnvv6tn881 select count(*) from ics_order where (orderstate='26' or orderState = '4') and to_char(ordertime, 'yyyy')=:year and to_char(ordertime, 'mm')=:month and to_char(ordertime, 'dd')=:day

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

61wcgj1a8ktrg select PolicyID, FromCity, ToCity, AirCom, FlyType, Week, FlightType, FlightNo, Cabin, BeginTime, EndTime, R_SDate, R_EDate, TicketStart, TicketEnd, TicketType, DisCount, B2BBackPoint, PassType, OfficeNo, Ei_Shengcang, BeforeDate, Ei_Gaiqian, Ei_Tuipiao, PolicyType, PolicySource, PubTime, IsStatus, Remark, WorkTime, Fei_WorkTIme, Priority, Price, LastEstalterState, IsView, AUTHORIZATIONOFFICE from (select row_number() over( order by backpoint desc , priority asc) as rowno, t.PolicyID, t.FromCity, t.ToCity, t.AirCom, t.FlyType, t.Week, t.FlightType, t.FlightNo, t.Cabin, t.BeginTime, t.EndTime, t.R_SDate, t.R_EDate, t.TicketStart, t.TicketEnd, t.TicketType, t.DisCount, t.B2BBackPoint, t.PassType, t.OfficeNo, t.Ei_Shengcang, t.BeforeDate, t.Ei_Gaiqian, t.Ei_Tuipiao, t.PolicyType, t.PolicySource, t.PubTime, t.IsStatus, t.Remark, t.WorkTime, t.Fei_WorkTIme, t.Priority, t.Price, t.LastEstalterState, t.IsView, t.AUTHORIZATIONOFFICE from policy_base t where 1=1 and (instr(FROMCITY, 'SHA')>0 or FROMCITY='*' ) and (instr(TOCITY, 'SWA')>0 or TOCITY='*') and (instr(CABIN, 'Y')>0 or CABIN='*') and ((instr(FLIGHTNO, '9299')>0 and FLIGHTTYPE=0) or (instr(FLIGHTNO, '9299')<0 and FLIGHTTYPE=1) or FLIGHTNO is null ) and instr(FLYTYPE, '1')>0 and instr(AIRCOM, 'FM')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') and (instr(WEEK, '3')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 and PASSTYPE='1' AND LASTESTALTERSTATE !='D' and policyID like 'SD%' order by backpoint desc) where rownum<2

8qfcnp8dyrr1h select POLICYID, AIRCOM, CABIN, FLIGHTTYPE, BEFOREDATE, BEGINTIME, FLIGHTNO, FROMCITY, TOCITY, WEEK, BACKPOINT, PASSTYPE, OTABACKPOINT, TMCBACKPOINT, ISGROUP, SPECIALDISCOUNTMIN, SPECIALDISCOUNTMAX from (select row_number() over( order by backpoint desc , priority asc) as rowno, t.POLICYID, t.AIRCOM, t.CABIN, t.FLIGHTTYPE, t.BEFOREDATE, t.BEGINTIME, t.FLIGHTNO, t.FROMCITY, t.TOCITY, t.WEEK, t.BACKPOINT, t.PASSTYPE, t.OTABACKPOINT, t.TMCBACKPOINT, t.ISGROUP, t.SPECIALDISCOUNTMIN, t.SPECIALDISCOUNTMAX from policy_base t where 1=1 and (instr(FROMCITY, 'CKG')>0 or FROMCITY='*' ) and (instr(TOCITY, 'HFE')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-12-07', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-12-07', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') and (instr(WEEK, '6')>0 or WEEK is null or WEEK='') and ( instr('B2B_062931, B2B_030318, B2B_042886, B2B_032247, B2B_061054, B2B_023809, B2B_050906, B2B_030319, B2B_009226, B2B_038654, B2B_027658, B2B_027855, B2B_025158, B2B_008295, B2B_024586, B2B_067142, B2B_064404, B2B_001650, B2B_025484, B2B_001541, B2B_059519, B2B_028386, B2B_067213, B2B_027721, B2B_030103, B2B_049278, B2B_011842, B2B_005153, B2B_028549, B2B_004232, B2B_063773, B2B_069403, B2B_046678, B2B_035830, B2B_006707, B2B_022713, B2B_024399, B2B_031699, B2B_062351, B2B_023623, B2B_009296, B2B_005847, B2B_064226, B2B_035374, B2B_069682, B2B_001806, B2B_003360, B2B_008272, B2B_012198, B2B_051729, B2B_010641, B2B_001826, B2B_023136, B2B_064909, B2B_024757, B2B_014451, B2B_005220, B2B_028873, B2B_059689, B2B_001814, B2B_047945, B2B_049836, B2B_069440, B2B_002649, B2B_038745, B2B_064796, B2B_030006, B2B_063330, B2B_002055, B2B_039429, B2B_014231, B2B_046938, B2B_001953, B2B_049308, B2B_043215, B2B_023614, B2B_037828, B2B_002068, B2B_055694, B2B_017255, B2B_069683, B2B_031311, B2B_050647, B2B_047007, B2B_009042, B2B_025721, B2B_001819, B2B_051121, B2B_001570, B2B_039668, B2B_051343, B2B_010891, B2B_002851, B2B_070211, B2B_024933, B2B_062329, B2B_001554, B2B_027605, B2B_037906, B2B_013494, B2B_002618, B2B_057370, B2B_067560, B2B_026841, B2B_016350, B2B_016595, B2B_051620, B2B_069386, B2B_001644, B2B_044460, B2B_058751, B2B_000113, B2B_017165, B2B_047149, B2B_029904, B2B_064331, B2B_047195, B2B_052888, B2B_027767, B2B_032209, B2B_039814, B2B_070286, B2B_069317, B2B_003395, B2B_035542, B2B_068242, B2B_001399, B2B_069770, B2B_013215, B2B_070482, B2B_070342, B2B_051186', t.agentsine)<=0 or t.agentsine is null or t.agentsine='' ) and (t.TMCBACKPOINT>=3 or t.OTABACKPOINT>=3) and ISSTATUS=1 and ISCHECK=1 AND PASSTYPE !=3 AND LASTESTALTERSTATE !='D' AND (FLIGHTTYPE is null or FLIGHTTYPE!=1) order by backpoint desc)

94h2a7cs7a7fc select * from ICS_AutoTicketTask where Status=4 order by InTime asc, TaskId asc

98985j06ajttt select * from Bsp_Office where officeid='SZX485' and bspstate=1

9juw6s4yy5pzp /* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )

9rkx7dk6m8959 SELECT TBICS_OPERATE_LOG_SQN.NEXTVAL FROM DUAL

9tgj4g8y4rwy8 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

afgq31rst0z0b select count(*) from ics_order where 1=1 and PNR='JZ7C4Y' and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票'

axmdf8vq7k1rh select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1

b9nt5kjsvd5ug select * from ics_order where pubid like '%T2013112016192%'

ba6n0vrmtz8vu UPDATE CHANNEL_ORDER SET ORDERID = :B31 , ORDERTIME = :B30 , SEATNUM = :B29 , SEGTYPE = :B28 , PNR = :B27 , ORDERSTATE = :B26 , POLICYID = :B25 , TICKETTYPE = :B24 , TOTALPRICE = :B23 , BUYID = :B22 , ORDERFROM = :B21 , SEGMENTINFO = :B20 , AIRCOM = :B19 , FROMCITY = :B18 , TOCITY = :B17 , FLIGHTDATE = :B16 , FLIGHTNO = :B15 , FROMPORT = :B14 , TOPORT = :B13 , FROMTIME = :B12 , TOTIME = :B11 , CABIN = :B10 , PAYTYPE = :B9 , PAYTIME = :B8 , COPEPRICE = :B7 , GENERATEDATE = :B6 , MONEYOFF = :B5 , HANDLETIME = :B4 , FACTDEFRAYAL = :B3 , PUBOFFICE = :B2 , POUNDAGE = :B1 WHERE ORDERID = :B32

bh7sw006tkt9k select PolicyID, FromCity, ToCity, AirCom, FlyType, Week, FlightType, FlightNo, Cabin, BeginTime, EndTime, R_SDate, R_EDate, TicketStart, TicketEnd, TicketType, DisCount, B2BBackPoint, OTABACKPOINT, PassType, OfficeNo, Ei_Shengcang, BeforeDate, Ei_Gaiqian, Ei_Tuipiao, PolicyType, PolicySource, PubTime, IsStatus, Remark, WorkTime, Fei_WorkTIme, Priority, Price, LastEstalterState, IsView, AUTHORIZATIONOFFICE, ISGROUP from (select PolicyID, FromCity, ToCity, AirCom, FlyType, Week, FlightType, FlightNo, Cabin, BeginTime, EndTime, R_SDate, R_EDate, TicketStart, TicketEnd, TicketType, DisCount, B2BBackPoint, OTABACKPOINT, PassType, OfficeNo, Ei_Shengcang, BeforeDate, Ei_Gaiqian, Ei_Tuipiao, PolicyType, PolicySource, PubTime, IsStatus, Remark, WorkTime, Fei_WorkTIme, Priority, Price, LastEstalterState, IsView, AUTHORIZATIONOFFICE, ISGROUP from Policy_Base where PubTime>to_timestamp('2013-11-20 09:41:07.000', 'yyyy-mm-dd hh24:mi:ssxff') and FLYTYPE !='6' and PASSTYPE='1' and policyid like 'SD%' order by PubTime asc) where rownum<=10000

bk7jp5jq5k1bu select count(*) from ics_order where 1=1 and EXISTS (SELECT orderid FROM Tbics_Passengerinfo WHERE ics_order.orderid=Tbics_Passengerinfo.orderid and piaohao = '880-4394754598') and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票'

c85unpq0xxzty select * from ics_order where pubid like '%T2013112095593%'

chf20zq23a82a select * from (select /*+ FIRST_ROWS(15) */ DISTINCT A.orderid, A.oldOrderID, A.ORDERTIME, A.PNR||'-'||A.bigpnr PNR, A.psgs, A.fromport||'-'||A.toport||'('||A.segtype||')' PORT, A.flightno, A.APPLICATIONSAKE, A.aircom, A.flightdate, to_char(A.TOTALPRICE, 'fm9999999990.00') As TOTALPRICE, decode(orderstate, '0', '待出票', '16', '未支付待出票', '3', '出票处理中', '35', '网购单重新出票', '44', '未调度, 自动出票失败', '45', '未支付, 自动出票失败', '52', '自动出票失败, 未入库, 未支付', '53', '自动出票失败, 已入库, 未支付', '54', '自动出票失败, 已入库, 已支付', '55', '自动出票失败', '56', '自动出票异常, 请先核实订单', '59', '自动出票贴票号失败', '47', '外采失败', '60', '自动提取票号失败') orderstate, A.commision, case A.Orderfrom when 'TEMPUSB2B' then A.Orderfrom||'-'||A.logname else A.orderfrom end orderfrom, A.logname, A.OT_TYPE, IFSORT||' '||COOPERATION||puboffice as backpoint, ISCLOSE, CLOSER from ics_order A where (A.orderstate='0' or A.orderstate='16' or A.orderstate='3' or A.orderstate='30' or A.orderstate='44' or A.orderstate='45' or A.orderstate='52' or A.orderstate='53' or A.orderstate='54' or A.orderstate='55' or A.orderstate='56' or A.orderstate='59' or A.orderstate='47' or a.orderstate='60') and (oldorderid is null or oldorderid='') and A.orderfrom!='51BK' and A.orderfrom!='517' and A.orderfrom!='百拓' and A.orderfrom!='19E' and A.orderfrom!='今日' and A.orderfrom!='19E废票' and A.orderfrom!='票盟' and A.orderfrom!='票盟废票' and A.orderfrom!='517SZX' and A.orderfrom!='易行' and A.orderfrom!='51BKSZX' and A.orderfrom!='百拓SZX' and A.orderfrom!='517SZX废票' and A.orderfrom!='517废票' and A.orderfrom != 'SHBJDLS') z, (select a.orderid, REPLACE(wmsys.wm_concat(a.PASSENGERNAME), ', ', ' ') as pgname, REPLACE(wmsys.wm_concat(a.TICKETPRICE), ', ', ' ') as pgprice, REPLACE(wmsys.wm_concat(a.UFUELTAX||'/'||a.AIRPORTTAX), ', ', ' ') as ranji from TBICS_PASSENGERINFO a, ics_order b where a.orderid=b.orderid and (b.orderstate='0' or b.orderstate='16' or b.orderstate='3' or b.orderstate='30' or b.orderstate='44' or b.orderstate='45' or b.orderstate='52' or b.orderstate='53' or b.orderstate='54' or b.orderstate='55' or b.orderstate='56' or b.orderstate='59'or b.orderstate='47' or b.orderstate='60') group by a.orderid) y where z.orderid = y.orderid order by z.ordertime

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

cswn2scb5qy25 select * from ics_order where pubid like '%112013112033243798%'

ct78468spkzrt select count(*) from v$lock

dbx1xgv14t1cp select * from (select a.*, rownum rownumber from(select ORDERID, ORDERTIME, PNR||'-'||bigpnr PNR, SEATNUM, SEGTYPE, FROMCITY, TOCITY, OT_TYPE, orderFrom, logname from ics_order where 1=1 and PNR='JZ7C4Y' and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票' order by ordertime desc) a) ics_order where ics_order.rownumber <=15

dfgut05uv2tza select * from ics_order where pubid like '%112013112033243974%'

f5tz11uhm37fs select * from (select /*+ FIRST_ROWS(15) */ DISTINCT A.orderid, A.oldOrderID, A.ORDERTIME, A.PNR||'-'||A.bigpnr PNR, A.psgs, A.fromport||'-'||A.toport||'('||A.segtype||')' PORT, A.flightno, A.APPLICATIONSAKE, A.aircom, A.flightdate, to_char(A.TOTALPRICE, 'fm9999999990.00') As TOTALPRICE, decode(orderstate, '0', '待出票', '16', '未支付待出票', '3', '出票处理中', '35', '网购单重新出票', '44', '未调度, 自动出票失败', '45', '未支付, 自动出票失败', '52', '自动出票失败, 未入库, 未支付', '53', '自动出票失败, 已入库, 未支付', '54', '自动出票失败, 已入库, 已支付', '55', '自动出票失败', '56', '自动出票异常, 请先核实订单', '59', '自动出票贴票号失败', '60', '自动提取票号失败') orderstate, A.commision, A.GENERATEDATE, case A.Orderfrom when 'TEMPUSB2B' then A.Orderfrom||'-'||A.logname else A.orderfrom end orderfrom, A.logname, A.OT_TYPE, IFSORT||' '||COOPERATION||puboffice as officeNO, ISCLOSE, CLOSER from ics_order A where (A.orderstate='0' or A.orderstate='16' or A.orderstate='3' or A.orderstate='30' or A.orderstate='44' or A.orderstate='45' or A.orderstate='52' or A.orderstate='53' or A.orderstate='54' or A.orderstate='55' or A.orderstate='56' or A.orderstate='59' or a.orderstate='60' ) and (oldorderid is null or oldorderid='') and A.orderfrom in('51BK', '517', '百拓', '19E', '今日', '19E废票', '票盟', '票盟废票', '517SZX', '易行', '51BKSZX', '百拓SZX', '517SZX废票', '517废票') and A.orderfrom != 'SHBJDLS' ) z, (select a.orderid, REPLACE(wmsys.wm_concat(a.PASSENGERNAME), ', ', ' ') as pgname, REPLACE(wmsys.wm_concat(a.TICKETPRICE), ', ', ' ') as pgprice, REPLACE(wmsys.wm_concat(a.UFUELTAX||'/'||a.AIRPORTTAX), ', ', ' ') as ranji from TBICS_PASSENGERINFO a, ics_order b where a.orderid=b.orderid and (b.orderstate='0' or b.orderstate='16' or b.orderstate='3' or b.orderstate='30' or b.orderstate='44' or b.orderstate='45' or b.orderstate='52' or b.orderstate='53' or b.orderstate='54' or b.orderstate='55' or b.orderstate='56' or b.orderstate='59' or b.orderstate='60') group by a.orderid) y where z.orderid = y.orderid order by z.ordertime

f711myt0q6cma insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)

f88j76h3cs43z select count(count(*)) from ics_feipiao x left join icsorder o on x.orderid = o.orderid where fstate = 0 AND operatetype = 1 and o.orderfrom!='51BK' and o.orderfrom!='517' and o.orderfrom!='百拓' and o.orderfrom!='19E' and o.orderfrom!='今日' and o.orderfrom!='19E废票' and o.orderfrom!='票盟' and o.orderfrom!='票盟废票' and o.orderfrom!='517SZX' and o.orderfrom!='易行' and o.orderfrom!='51BKSZX' and o.orderfrom!='百拓SZX' and o.orderfrom!='517SZX废票' and o.orderfrom!='517废票' and x.psname is not null group by x.orderid

ffmfqt8a9vyry select count(*) from ics_order where 1=1 and PNR='JZ7C4Y' and instr(', TMCY6, TMC-X5(100123), 600047, YYX, TMCX5, TMC, TMC-X(410006), TMC-Y0(600046), TMC-Y6(80801), 600046, TMC-X4(600047), TMC-Y6(800826), ', ', '||orderfrom||', ')>0 and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票'

gkzsc3tg5uahf select POLICYID, AIRCOM, CABIN, FLIGHTTYPE, BEFOREDATE, BEGINTIME, FLIGHTNO, FROMCITY, TOCITY, WEEK, BACKPOINT, PASSTYPE, OTABACKPOINT, TMCBACKPOINT, ISGROUP, SPECIALDISCOUNTMIN, SPECIALDISCOUNTMAX from (select row_number() over( order by backpoint desc , priority asc) as rowno, t.POLICYID, t.AIRCOM, t.CABIN, t.FLIGHTTYPE, t.BEFOREDATE, t.BEGINTIME, t.FLIGHTNO, t.FROMCITY, t.TOCITY, t.WEEK, t.BACKPOINT, t.PASSTYPE, t.OTABACKPOINT, t.TMCBACKPOINT, t.ISGROUP, t.SPECIALDISCOUNTMIN, t.SPECIALDISCOUNTMAX from policy_base t where 1=1 and (instr(FROMCITY, 'PEK')>0 or FROMCITY='*' ) and (instr(TOCITY, 'CTU')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') and (instr(WEEK, '3')>0 or WEEK is null or WEEK='') and ( instr('B2B_062931, B2B_030318, B2B_042886, B2B_032247, B2B_061054, B2B_023809, B2B_050906, B2B_030319, B2B_009226, B2B_038654, B2B_027658, B2B_027855, B2B_025158, B2B_008295, B2B_024586, B2B_067142, B2B_064404, B2B_001650, B2B_025484, B2B_001541, B2B_059519, B2B_028386, B2B_067213, B2B_027721, B2B_030103, B2B_049278, B2B_011842, B2B_005153, B2B_028549, B2B_004232, B2B_063773, B2B_069403, B2B_046678, B2B_035830, B2B_006707, B2B_022713, B2B_024399, B2B_031699, B2B_062351, B2B_023623, B2B_009296, B2B_005847, B2B_064226, B2B_035374, B2B_069682, B2B_001806, B2B_003360, B2B_008272, B2B_012198, B2B_051729, B2B_010641, B2B_001826, B2B_023136, B2B_064909, B2B_024757, B2B_014451, B2B_005220, B2B_028873, B2B_059689, B2B_001814, B2B_047945, B2B_049836, B2B_069440, B2B_002649, B2B_038745, B2B_064796, B2B_030006, B2B_063330, B2B_002055, B2B_039429, B2B_014231, B2B_046938, B2B_001953, B2B_049308, B2B_043215, B2B_023614, B2B_037828, B2B_002068, B2B_055694, B2B_017255, B2B_069683, B2B_031311, B2B_050647, B2B_047007, B2B_009042, B2B_025721, B2B_001819, B2B_051121, B2B_001570, B2B_039668, B2B_051343, B2B_010891, B2B_002851, B2B_070211, B2B_024933, B2B_062329, B2B_001554, B2B_027605, B2B_037906, B2B_013494, B2B_002618, B2B_057370, B2B_067560, B2B_026841, B2B_016350, B2B_016595, B2B_051620, B2B_069386, B2B_001644, B2B_044460, B2B_058751, B2B_000113, B2B_017165, B2B_047149, B2B_029904, B2B_064331, B2B_047195, B2B_052888, B2B_027767, B2B_032209, B2B_039814, B2B_070286, B2B_069317, B2B_003395, B2B_035542, B2B_068242, B2B_001399, B2B_069770, B2B_013215, B2B_070482, B2B_070342, B2B_051186', t.agentsine)<=0 or t.agentsine is null or t.agentsine='' ) and (t.TMCBACKPOINT>=3 or t.OTABACKPOINT>=3) and ISSTATUS=1 and ISCHECK=1 AND PASSTYPE !=3 AND LASTESTALTERSTATE !='D' AND (FLIGHTTYPE is null or FLIGHTTYPE!=1) order by backpoint desc)

gsfyvunsujbrw select count(*) from ics_order where 1=1 and EXISTS (SELECT orderid FROM Tbics_Passengerinfo WHERE ics_order.orderid=Tbics_Passengerinfo.orderid and piaohao = '999-4100169882') and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票'

SQL Id	SQL Text
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0sjaskcqpdfmc	select * from (select a.*, rownum rownumber from(select ORDERID, ORDERTIME, PNR\|\|'-'\|\|bigpnr PNR, SEATNUM, SEGTYPE, FROMCITY, TOCITY, OT_TYPE, orderFrom, logname from ics_order where 1=1 and PNR='JZ7C4Y' and instr(', TMCY6, TMC-X5(100123), 600047, YYX, TMCX5, TMC, TMC-X(410006), TMC-Y0(600046), TMC-Y6(80801), 600046, TMC-X4(600047), TMC-Y6(800826), ', ', '\|\|orderfrom\|\|', ')>0 and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票' order by ordertime desc) a) ics_order where ics_order.rownumber <=15
0v6s91manuhz8	/* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name\|\|'-'\|\|l.sid, 2, i.instance_name\|\|'-'\|\|l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1cd2krbdzrhvq	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ftio.kcftiopyr, ftio.kcftiopyw, ftio.kcftiosbr, floor(ftio.kcftioprt / 10000), floor(ftio.kcftiopwt / 10000), floor(ftio.kcftiosbt / 10000), ftio.kcftiopbr, ftio.kcftiopbw, fw.count, fw.time from x$kcftio ftio, x$kcctf tf, x$kcbfwait fw, x$kccfn fn, x$kccts ts where ts.tstsn = tf.tftsn and ftio.kcftiofno = fn.fnfno and tf.tfnum = fn.fnfno and tf.tffnh = fn.fnnum and tf.tfdup <> 0 and fn.fntyp = 7 and fn.fnnam is not null and bitand(tf.tfsta, 32) <> 32 and fw.indx+1 = (fn.fnfno + :db_files)
1gfut0jn7z3y4	select * from tbics_passengerinfo where orderid = (select orderid from ics_order where ordertime = (select max(ORDERTIME) from ics_order where bigpnr = 'MC3Q2F') and bigpnr='MC3Q2F')
1gv747j5pzk2d	select * from ICS_OTHERORDER_SYNCH
20ny5g0f6g8x4	select * from ICS_OTHERORDER_SYNCH where othercompanyname=:othercompanyname
2tkw12w5k68vd	select user#, password, datats#, tempts#, type#, defrole, resource$, ptime, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1, spare4, ext_username, spare2 from user$ where name=:1
3w4qs0tbpmxr6	select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
486ppy6x0nxk2	select * from suspendsuppliermgr
4g42vt1rhvbc8	select count(*) from ics_order where 1=1 and PNR='HNQ4K7' and orderfrom in('51BK', '517', '百拓', '19E', '今日', '19E废票', '票盟', '票盟废票', '517SZX', '易行', '51BKSZX', '百拓SZX', '517SZX废票', '517废票') and orderfrom != 'SHBJDLS'
4m0vs1ru52rks	select count(*) from ics_feipiao x, ( select b.orderid, max(b.passengerid) as psid from (select distinct(orderid) from ics_feipiao where fstate=0 AND operatetype =1 ) a, ics_feipiao b where a.orderid=b.orderid group by b.orderID) z, icsorder o where x.orderid = o.orderid and x.passengerid = z.psid AND fstate=0 AND operatetype =1 and o.orderfrom in('51BK', '517', '百拓', '19E', '今日', '19E废票', '票盟', '票盟废票', '517SZX', '易行', '51BKSZX', '百拓SZX', '517SZX废票', '517废票') and o.orderfrom != 'SHBJDLS'
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4s83p6gpn8rhr	select count(count(*)) from ics_feipiao x left join icsorder o on x.orderid = o.orderid where fstate = 0 AND operatetype = 4 and o.orderfrom!='51BK' and o.orderfrom!='517' and o.orderfrom!='百拓' and o.orderfrom!='19E' and o.orderfrom!='今日' and o.orderfrom!='19E废票' and o.orderfrom!='票盟' and o.orderfrom!='票盟废票' and o.orderfrom!='517SZX' and o.orderfrom!='易行' and o.orderfrom!='51BKSZX' and o.orderfrom!='百拓SZX' and o.orderfrom!='517SZX废票' and o.orderfrom!='517废票' and x.psname is not null group by x.orderid
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :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)
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
57zg6b0tm2tdq	select round(100 - (free.free/tot.total)*100, 2) used_pct from (select tablespace_name, (sum(bytes)/1048576) total from sys.dba_data_files group by tablespace_name) tot, (select tablespace_name, (sum(bytes)/1048576) free from sys.dba_free_space group by tablespace_name) free where free.tablespace_name=tot.tablespace_name and tot.tablespace_name=:1 order by used_pct
5nwqnvv6tn881	select count(*) from ics_order where (orderstate='26' or orderState = '4') and to_char(ordertime, 'yyyy')=:year and to_char(ordertime, 'mm')=:month and to_char(ordertime, 'dd')=:day
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
61wcgj1a8ktrg	select PolicyID, FromCity, ToCity, AirCom, FlyType, Week, FlightType, FlightNo, Cabin, BeginTime, EndTime, R_SDate, R_EDate, TicketStart, TicketEnd, TicketType, DisCount, B2BBackPoint, PassType, OfficeNo, Ei_Shengcang, BeforeDate, Ei_Gaiqian, Ei_Tuipiao, PolicyType, PolicySource, PubTime, IsStatus, Remark, WorkTime, Fei_WorkTIme, Priority, Price, LastEstalterState, IsView, AUTHORIZATIONOFFICE from (select row_number() over( order by backpoint desc , priority asc) as rowno, t.PolicyID, t.FromCity, t.ToCity, t.AirCom, t.FlyType, t.Week, t.FlightType, t.FlightNo, t.Cabin, t.BeginTime, t.EndTime, t.R_SDate, t.R_EDate, t.TicketStart, t.TicketEnd, t.TicketType, t.DisCount, t.B2BBackPoint, t.PassType, t.OfficeNo, t.Ei_Shengcang, t.BeforeDate, t.Ei_Gaiqian, t.Ei_Tuipiao, t.PolicyType, t.PolicySource, t.PubTime, t.IsStatus, t.Remark, t.WorkTime, t.Fei_WorkTIme, t.Priority, t.Price, t.LastEstalterState, t.IsView, t.AUTHORIZATIONOFFICE from policy_base t where 1=1 and (instr(FROMCITY, 'SHA')>0 or FROMCITY='' ) and (instr(TOCITY, 'SWA')>0 or TOCITY='') and (instr(CABIN, 'Y')>0 or CABIN='*') and ((instr(FLIGHTNO, '9299')>0 and FLIGHTTYPE=0) or (instr(FLIGHTNO, '9299')<0 and FLIGHTTYPE=1) or FLIGHTNO is null ) and instr(FLYTYPE, '1')>0 and instr(AIRCOM, 'FM')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') and (instr(WEEK, '3')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 and PASSTYPE='1' AND LASTESTALTERSTATE !='D' and policyID like 'SD%' order by backpoint desc) where rownum<2
8qfcnp8dyrr1h	select POLICYID, AIRCOM, CABIN, FLIGHTTYPE, BEFOREDATE, BEGINTIME, FLIGHTNO, FROMCITY, TOCITY, WEEK, BACKPOINT, PASSTYPE, OTABACKPOINT, TMCBACKPOINT, ISGROUP, SPECIALDISCOUNTMIN, SPECIALDISCOUNTMAX from (select row_number() over( order by backpoint desc , priority asc) as rowno, t.POLICYID, t.AIRCOM, t.CABIN, t.FLIGHTTYPE, t.BEFOREDATE, t.BEGINTIME, t.FLIGHTNO, t.FROMCITY, t.TOCITY, t.WEEK, t.BACKPOINT, t.PASSTYPE, t.OTABACKPOINT, t.TMCBACKPOINT, t.ISGROUP, t.SPECIALDISCOUNTMIN, t.SPECIALDISCOUNTMAX from policy_base t where 1=1 and (instr(FROMCITY, 'CKG')>0 or FROMCITY='' ) and (instr(TOCITY, 'HFE')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-12-07', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-12-07', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') and (instr(WEEK, '6')>0 or WEEK is null or WEEK='') and ( instr('B2B_062931, B2B_030318, B2B_042886, B2B_032247, B2B_061054, B2B_023809, B2B_050906, B2B_030319, B2B_009226, B2B_038654, B2B_027658, B2B_027855, B2B_025158, B2B_008295, B2B_024586, B2B_067142, B2B_064404, B2B_001650, B2B_025484, B2B_001541, B2B_059519, B2B_028386, B2B_067213, B2B_027721, B2B_030103, B2B_049278, B2B_011842, B2B_005153, B2B_028549, B2B_004232, B2B_063773, B2B_069403, B2B_046678, B2B_035830, B2B_006707, B2B_022713, B2B_024399, B2B_031699, B2B_062351, B2B_023623, B2B_009296, B2B_005847, B2B_064226, B2B_035374, B2B_069682, B2B_001806, B2B_003360, B2B_008272, B2B_012198, B2B_051729, B2B_010641, B2B_001826, B2B_023136, B2B_064909, B2B_024757, B2B_014451, B2B_005220, B2B_028873, B2B_059689, B2B_001814, B2B_047945, B2B_049836, B2B_069440, B2B_002649, B2B_038745, B2B_064796, B2B_030006, B2B_063330, B2B_002055, B2B_039429, B2B_014231, B2B_046938, B2B_001953, B2B_049308, B2B_043215, B2B_023614, B2B_037828, B2B_002068, B2B_055694, B2B_017255, B2B_069683, B2B_031311, B2B_050647, B2B_047007, B2B_009042, B2B_025721, B2B_001819, B2B_051121, B2B_001570, B2B_039668, B2B_051343, B2B_010891, B2B_002851, B2B_070211, B2B_024933, B2B_062329, B2B_001554, B2B_027605, B2B_037906, B2B_013494, B2B_002618, B2B_057370, B2B_067560, B2B_026841, B2B_016350, B2B_016595, B2B_051620, B2B_069386, B2B_001644, B2B_044460, B2B_058751, B2B_000113, B2B_017165, B2B_047149, B2B_029904, B2B_064331, B2B_047195, B2B_052888, B2B_027767, B2B_032209, B2B_039814, B2B_070286, B2B_069317, B2B_003395, B2B_035542, B2B_068242, B2B_001399, B2B_069770, B2B_013215, B2B_070482, B2B_070342, B2B_051186', t.agentsine)<=0 or t.agentsine is null or t.agentsine='' ) and (t.TMCBACKPOINT>=3 or t.OTABACKPOINT>=3) and ISSTATUS=1 and ISCHECK=1 AND PASSTYPE !=3 AND LASTESTALTERSTATE !='D' AND (FLIGHTTYPE is null or FLIGHTTYPE!=1) order by backpoint desc)
94h2a7cs7a7fc	select * from ICS_AutoTicketTask where Status=4 order by InTime asc, TaskId asc
98985j06ajttt	select * from Bsp_Office where officeid='SZX485' and bspstate=1
9juw6s4yy5pzp	/* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )
9rkx7dk6m8959	SELECT TBICS_OPERATE_LOG_SQN.NEXTVAL FROM DUAL
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
afgq31rst0z0b	select count(*) from ics_order where 1=1 and PNR='JZ7C4Y' and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票'
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b9nt5kjsvd5ug	select * from ics_order where pubid like '%T2013112016192%'
ba6n0vrmtz8vu	UPDATE CHANNEL_ORDER SET ORDERID = :B31 , ORDERTIME = :B30 , SEATNUM = :B29 , SEGTYPE = :B28 , PNR = :B27 , ORDERSTATE = :B26 , POLICYID = :B25 , TICKETTYPE = :B24 , TOTALPRICE = :B23 , BUYID = :B22 , ORDERFROM = :B21 , SEGMENTINFO = :B20 , AIRCOM = :B19 , FROMCITY = :B18 , TOCITY = :B17 , FLIGHTDATE = :B16 , FLIGHTNO = :B15 , FROMPORT = :B14 , TOPORT = :B13 , FROMTIME = :B12 , TOTIME = :B11 , CABIN = :B10 , PAYTYPE = :B9 , PAYTIME = :B8 , COPEPRICE = :B7 , GENERATEDATE = :B6 , MONEYOFF = :B5 , HANDLETIME = :B4 , FACTDEFRAYAL = :B3 , PUBOFFICE = :B2 , POUNDAGE = :B1 WHERE ORDERID = :B32
bh7sw006tkt9k	select PolicyID, FromCity, ToCity, AirCom, FlyType, Week, FlightType, FlightNo, Cabin, BeginTime, EndTime, R_SDate, R_EDate, TicketStart, TicketEnd, TicketType, DisCount, B2BBackPoint, OTABACKPOINT, PassType, OfficeNo, Ei_Shengcang, BeforeDate, Ei_Gaiqian, Ei_Tuipiao, PolicyType, PolicySource, PubTime, IsStatus, Remark, WorkTime, Fei_WorkTIme, Priority, Price, LastEstalterState, IsView, AUTHORIZATIONOFFICE, ISGROUP from (select PolicyID, FromCity, ToCity, AirCom, FlyType, Week, FlightType, FlightNo, Cabin, BeginTime, EndTime, R_SDate, R_EDate, TicketStart, TicketEnd, TicketType, DisCount, B2BBackPoint, OTABACKPOINT, PassType, OfficeNo, Ei_Shengcang, BeforeDate, Ei_Gaiqian, Ei_Tuipiao, PolicyType, PolicySource, PubTime, IsStatus, Remark, WorkTime, Fei_WorkTIme, Priority, Price, LastEstalterState, IsView, AUTHORIZATIONOFFICE, ISGROUP from Policy_Base where PubTime>to_timestamp('2013-11-20 09:41:07.000', 'yyyy-mm-dd hh24:mi:ssxff') and FLYTYPE !='6' and PASSTYPE='1' and policyid like 'SD%' order by PubTime asc) where rownum<=10000
bk7jp5jq5k1bu	select count(*) from ics_order where 1=1 and EXISTS (SELECT orderid FROM Tbics_Passengerinfo WHERE ics_order.orderid=Tbics_Passengerinfo.orderid and piaohao = '880-4394754598') and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票'
c85unpq0xxzty	select * from ics_order where pubid like '%T2013112095593%'
chf20zq23a82a	select * from (select /+ FIRST_ROWS(15) / DISTINCT A.orderid, A.oldOrderID, A.ORDERTIME, A.PNR\|\|'-'\|\|A.bigpnr PNR, A.psgs, A.fromport\|\|'-'\|\|A.toport\|\|'('\|\|A.segtype\|\|')' PORT, A.flightno, A.APPLICATIONSAKE, A.aircom, A.flightdate, to_char(A.TOTALPRICE, 'fm9999999990.00') As TOTALPRICE, decode(orderstate, '0', '待出票', '16', '未支付待出票', '3', '出票处理中', '35', '网购单重新出票', '44', '未调度, 自动出票失败', '45', '未支付, 自动出票失败', '52', '自动出票失败, 未入库, 未支付', '53', '自动出票失败, 已入库, 未支付', '54', '自动出票失败, 已入库, 已支付', '55', '自动出票失败', '56', '自动出票异常, 请先核实订单', '59', '自动出票贴票号失败', '47', '外采失败', '60', '自动提取票号失败') orderstate, A.commision, case A.Orderfrom when 'TEMPUSB2B' then A.Orderfrom\|\|'-'\|\|A.logname else A.orderfrom end orderfrom, A.logname, A.OT_TYPE, IFSORT\|\|'<br/>'\|\|COOPERATION\|\|puboffice as backpoint, ISCLOSE, CLOSER from ics_order A where (A.orderstate='0' or A.orderstate='16' or A.orderstate='3' or A.orderstate='30' or A.orderstate='44' or A.orderstate='45' or A.orderstate='52' or A.orderstate='53' or A.orderstate='54' or A.orderstate='55' or A.orderstate='56' or A.orderstate='59' or A.orderstate='47' or a.orderstate='60') and (oldorderid is null or oldorderid='') and A.orderfrom!='51BK' and A.orderfrom!='517' and A.orderfrom!='百拓' and A.orderfrom!='19E' and A.orderfrom!='今日' and A.orderfrom!='19E废票' and A.orderfrom!='票盟' and A.orderfrom!='票盟废票' and A.orderfrom!='517SZX' and A.orderfrom!='易行' and A.orderfrom!='51BKSZX' and A.orderfrom!='百拓SZX' and A.orderfrom!='517SZX废票' and A.orderfrom!='517废票' and A.orderfrom != 'SHBJDLS') z, (select a.orderid, REPLACE(wmsys.wm_concat(a.PASSENGERNAME), ', ', '<br>') as pgname, REPLACE(wmsys.wm_concat(a.TICKETPRICE), ', ', '<br>') as pgprice, REPLACE(wmsys.wm_concat(a.UFUELTAX\|\|'/'\|\|a.AIRPORTTAX), ', ', '<br>') as ranji from TBICS_PASSENGERINFO a, ics_order b where a.orderid=b.orderid and (b.orderstate='0' or b.orderstate='16' or b.orderstate='3' or b.orderstate='30' or b.orderstate='44' or b.orderstate='45' or b.orderstate='52' or b.orderstate='53' or b.orderstate='54' or b.orderstate='55' or b.orderstate='56' or b.orderstate='59'or b.orderstate='47' or b.orderstate='60') group by a.orderid) y where z.orderid = y.orderid order by z.ordertime
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cswn2scb5qy25	select * from ics_order where pubid like '%112013112033243798%'
ct78468spkzrt	select count(*) from v$lock
dbx1xgv14t1cp	select * from (select a.*, rownum rownumber from(select ORDERID, ORDERTIME, PNR\|\|'-'\|\|bigpnr PNR, SEATNUM, SEGTYPE, FROMCITY, TOCITY, OT_TYPE, orderFrom, logname from ics_order where 1=1 and PNR='JZ7C4Y' and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票' order by ordertime desc) a) ics_order where ics_order.rownumber <=15
dfgut05uv2tza	select * from ics_order where pubid like '%112013112033243974%'
f5tz11uhm37fs	select * from (select /+ FIRST_ROWS(15) / DISTINCT A.orderid, A.oldOrderID, A.ORDERTIME, A.PNR\|\|'-'\|\|A.bigpnr PNR, A.psgs, A.fromport\|\|'-'\|\|A.toport\|\|'('\|\|A.segtype\|\|')' PORT, A.flightno, A.APPLICATIONSAKE, A.aircom, A.flightdate, to_char(A.TOTALPRICE, 'fm9999999990.00') As TOTALPRICE, decode(orderstate, '0', '待出票', '16', '未支付待出票', '3', '出票处理中', '35', '网购单重新出票', '44', '未调度, 自动出票失败', '45', '未支付, 自动出票失败', '52', '自动出票失败, 未入库, 未支付', '53', '自动出票失败, 已入库, 未支付', '54', '自动出票失败, 已入库, 已支付', '55', '自动出票失败', '56', '自动出票异常, 请先核实订单', '59', '自动出票贴票号失败', '60', '自动提取票号失败') orderstate, A.commision, A.GENERATEDATE, case A.Orderfrom when 'TEMPUSB2B' then A.Orderfrom\|\|'-'\|\|A.logname else A.orderfrom end orderfrom, A.logname, A.OT_TYPE, IFSORT\|\|'<br/>'\|\|COOPERATION\|\|puboffice as officeNO, ISCLOSE, CLOSER from ics_order A where (A.orderstate='0' or A.orderstate='16' or A.orderstate='3' or A.orderstate='30' or A.orderstate='44' or A.orderstate='45' or A.orderstate='52' or A.orderstate='53' or A.orderstate='54' or A.orderstate='55' or A.orderstate='56' or A.orderstate='59' or a.orderstate='60' ) and (oldorderid is null or oldorderid='') and A.orderfrom in('51BK', '517', '百拓', '19E', '今日', '19E废票', '票盟', '票盟废票', '517SZX', '易行', '51BKSZX', '百拓SZX', '517SZX废票', '517废票') and A.orderfrom != 'SHBJDLS' ) z, (select a.orderid, REPLACE(wmsys.wm_concat(a.PASSENGERNAME), ', ', '<br>') as pgname, REPLACE(wmsys.wm_concat(a.TICKETPRICE), ', ', '<br>') as pgprice, REPLACE(wmsys.wm_concat(a.UFUELTAX\|\|'/'\|\|a.AIRPORTTAX), ', ', '<br>') as ranji from TBICS_PASSENGERINFO a, ics_order b where a.orderid=b.orderid and (b.orderstate='0' or b.orderstate='16' or b.orderstate='3' or b.orderstate='30' or b.orderstate='44' or b.orderstate='45' or b.orderstate='52' or b.orderstate='53' or b.orderstate='54' or b.orderstate='55' or b.orderstate='56' or b.orderstate='59' or b.orderstate='60') group by a.orderid) y where z.orderid = y.orderid order by z.ordertime
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
f88j76h3cs43z	select count(count(*)) from ics_feipiao x left join icsorder o on x.orderid = o.orderid where fstate = 0 AND operatetype = 1 and o.orderfrom!='51BK' and o.orderfrom!='517' and o.orderfrom!='百拓' and o.orderfrom!='19E' and o.orderfrom!='今日' and o.orderfrom!='19E废票' and o.orderfrom!='票盟' and o.orderfrom!='票盟废票' and o.orderfrom!='517SZX' and o.orderfrom!='易行' and o.orderfrom!='51BKSZX' and o.orderfrom!='百拓SZX' and o.orderfrom!='517SZX废票' and o.orderfrom!='517废票' and x.psname is not null group by x.orderid
ffmfqt8a9vyry	select count(*) from ics_order where 1=1 and PNR='JZ7C4Y' and instr(', TMCY6, TMC-X5(100123), 600047, YYX, TMCX5, TMC, TMC-X(410006), TMC-Y0(600046), TMC-Y6(80801), 600046, TMC-X4(600047), TMC-Y6(800826), ', ', '\|\|orderfrom\|\|', ')>0 and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票'
gkzsc3tg5uahf	select POLICYID, AIRCOM, CABIN, FLIGHTTYPE, BEFOREDATE, BEGINTIME, FLIGHTNO, FROMCITY, TOCITY, WEEK, BACKPOINT, PASSTYPE, OTABACKPOINT, TMCBACKPOINT, ISGROUP, SPECIALDISCOUNTMIN, SPECIALDISCOUNTMAX from (select row_number() over( order by backpoint desc , priority asc) as rowno, t.POLICYID, t.AIRCOM, t.CABIN, t.FLIGHTTYPE, t.BEFOREDATE, t.BEGINTIME, t.FLIGHTNO, t.FROMCITY, t.TOCITY, t.WEEK, t.BACKPOINT, t.PASSTYPE, t.OTABACKPOINT, t.TMCBACKPOINT, t.ISGROUP, t.SPECIALDISCOUNTMIN, t.SPECIALDISCOUNTMAX from policy_base t where 1=1 and (instr(FROMCITY, 'PEK')>0 or FROMCITY='' ) and (instr(TOCITY, 'CTU')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-20', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-20', 'YYYY-MM-DD') and (instr(WEEK, '3')>0 or WEEK is null or WEEK='') and ( instr('B2B_062931, B2B_030318, B2B_042886, B2B_032247, B2B_061054, B2B_023809, B2B_050906, B2B_030319, B2B_009226, B2B_038654, B2B_027658, B2B_027855, B2B_025158, B2B_008295, B2B_024586, B2B_067142, B2B_064404, B2B_001650, B2B_025484, B2B_001541, B2B_059519, B2B_028386, B2B_067213, B2B_027721, B2B_030103, B2B_049278, B2B_011842, B2B_005153, B2B_028549, B2B_004232, B2B_063773, B2B_069403, B2B_046678, B2B_035830, B2B_006707, B2B_022713, B2B_024399, B2B_031699, B2B_062351, B2B_023623, B2B_009296, B2B_005847, B2B_064226, B2B_035374, B2B_069682, B2B_001806, B2B_003360, B2B_008272, B2B_012198, B2B_051729, B2B_010641, B2B_001826, B2B_023136, B2B_064909, B2B_024757, B2B_014451, B2B_005220, B2B_028873, B2B_059689, B2B_001814, B2B_047945, B2B_049836, B2B_069440, B2B_002649, B2B_038745, B2B_064796, B2B_030006, B2B_063330, B2B_002055, B2B_039429, B2B_014231, B2B_046938, B2B_001953, B2B_049308, B2B_043215, B2B_023614, B2B_037828, B2B_002068, B2B_055694, B2B_017255, B2B_069683, B2B_031311, B2B_050647, B2B_047007, B2B_009042, B2B_025721, B2B_001819, B2B_051121, B2B_001570, B2B_039668, B2B_051343, B2B_010891, B2B_002851, B2B_070211, B2B_024933, B2B_062329, B2B_001554, B2B_027605, B2B_037906, B2B_013494, B2B_002618, B2B_057370, B2B_067560, B2B_026841, B2B_016350, B2B_016595, B2B_051620, B2B_069386, B2B_001644, B2B_044460, B2B_058751, B2B_000113, B2B_017165, B2B_047149, B2B_029904, B2B_064331, B2B_047195, B2B_052888, B2B_027767, B2B_032209, B2B_039814, B2B_070286, B2B_069317, B2B_003395, B2B_035542, B2B_068242, B2B_001399, B2B_069770, B2B_013215, B2B_070482, B2B_070342, B2B_051186', t.agentsine)<=0 or t.agentsine is null or t.agentsine='' ) and (t.TMCBACKPOINT>=3 or t.OTABACKPOINT>=3) and ISSTATUS=1 and ISCHECK=1 AND PASSTYPE !=3 AND LASTESTALTERSTATE !='D' AND (FLIGHTTYPE is null or FLIGHTTYPE!=1) order by backpoint desc)
gsfyvunsujbrw	select count(*) from ics_order where 1=1 and EXISTS (SELECT orderid FROM Tbics_Passengerinfo WHERE ics_order.orderid=Tbics_Passengerinfo.orderid and piaohao = '999-4100169882') and orderfrom!='51BK' and orderfrom!='517' and orderfrom!='百拓' and orderfrom!='19E' and orderfrom!='今日' and orderfrom!='19E废票' and orderfrom!='票盟' and orderfrom!='票盟废票' and orderfrom!='517SZX' and orderfrom!='易行' and orderfrom!='51BKSZX' and orderfrom!='百拓SZX' and orderfrom!='517SZX废票' and orderfrom!='517废票'

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	2,340	0.65	0.23
Batched IO (full) vector count	20	0.01	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	19,370	5.37	1.94
Batched IO buffer defrag count	31	0.01	0.00
Batched IO double miss count	15	0.00	0.00
Batched IO same unit count	9,500	2.63	0.95
Batched IO single block count	1,002	0.28	0.10
Batched IO slow jump count	41	0.01	0.00
Batched IO vector block count	8,888	2.46	0.89
Batched IO vector read count	1,359	0.38	0.14
Block Cleanout Optim referenced	1,180	0.33	0.12
CCursor + sql area evicted	93	0.03	0.01
CPU used by this session	170,305	47.19	17.04
CPU used when call started	167,453	46.40	16.75
CR blocks created	3,181	0.88	0.32
Cached Commit SCN referenced	919	0.25	0.09
Commit SCN cached	661	0.18	0.07
DB time	1,600,020	443.32	160.05
DBWR checkpoint buffers written	21,322	5.91	2.13
DBWR checkpoints	780	0.22	0.08
DBWR fusion writes	6,400	1.77	0.64
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	1,949	0.54	0.19
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	142	0.04	0.01
DBWR undo block writes	4,140	1.15	0.41
DFO trees parallelized	437	0.12	0.04
Effective IO time	4,518,089,830	1,251,841.80	451,944.57
HSC Heap Segment Block Changes	45,249	12.54	4.53
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	561	0.16	0.06
Heap Segment Array Updates	328	0.09	0.03
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	453,508	125.65	45.36
PX local messages recv'd	1,768	0.49	0.18
PX local messages sent	1,768	0.49	0.18
PX remote messages recv'd	918	0.25	0.09
PX remote messages sent	966	0.27	0.10
Parallel operations not downgraded	437	0.12	0.04
Requests to/from client	705,828	195.57	70.60
RowCR - row contention	3	0.00	0.00
RowCR attempts	364	0.10	0.04
RowCR hits	361	0.10	0.04
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	11	0.00	0.00
SQL*Net roundtrips to/from client	705,836	195.57	70.60
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	4,957	1.37	0.50
application wait time	4,454	1.23	0.45
background checkpoints completed	3	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	26,931	7.46	2.69
branch node splits	3	0.00	0.00
buffer is not pinned count	25,178,010	6,976.15	2,518.56
buffer is pinned count	471,638,017	130,678.27	47,177.96
bytes received via SQL*Net from client	225,362,262	62,441.85	22,542.99
bytes sent via SQL*Net to client	267,768,769	74,191.56	26,784.91
calls to get snapshot scn: kcmgss	472,065	130.80	47.22
calls to kcmgas	119,804	33.19	11.98
calls to kcmgcs	508,219	140.81	50.84
cell physical IO interconnect bytes	484,357,736,448	134,202,568.37	48,450,308.74
change write time	277	0.08	0.03
cleanout - number of ktugct calls	4,821	1.34	0.48
cleanouts and rollbacks - consistent read gets	2,473	0.69	0.25
cleanouts only - consistent read gets	412	0.11	0.04
cluster key scan block gets	7,336	2.03	0.73
cluster key scans	5,261	1.46	0.53
cluster wait time	8,580	2.38	0.86
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	22	0.01	0.00
commit batch/immediate requested	22	0.01	0.00
commit cleanout failures: block lost	55	0.02	0.01
commit cleanout failures: buffer being written	6	0.00	0.00
commit cleanout failures: callback failure	74	0.02	0.01
commit cleanout failures: cannot pin	89	0.02	0.01
commit cleanouts	67,624	18.74	6.76
commit cleanouts successfully completed	67,400	18.67	6.74
commit immediate performed	22	0.01	0.00
commit immediate requested	22	0.01	0.00
commit txn count during cleanout	6,059	1.68	0.61
concurrency wait time	836	0.23	0.08
consistent changes	116,166	32.19	11.62
consistent gets	112,299,695	31,115.24	11,233.34
consistent gets - examination	4,192,347	1,161.59	419.36
consistent gets direct	57,471,435	15,923.80	5,748.87
consistent gets from cache	54,828,253	15,191.44	5,484.47
consistent gets from cache (fastpath)	50,434,709	13,974.11	5,044.98
cursor authentications	35,868	9.94	3.59
data blocks consistent reads - undo records applied	35,826	9.93	3.58
db block changes	620,209	171.84	62.04
db block gets	995,772	275.90	99.61
db block gets direct	42	0.01	0.00
db block gets from cache	995,730	275.89	99.60
db block gets from cache (fastpath)	228,375	63.28	22.84
deferred (CURRENT) block cleanout applications	32,047	8.88	3.21
dirty buffers inspected	415	0.11	0.04
enqueue conversions	8,979	2.49	0.90
enqueue deadlocks	0	0.00	0.00
enqueue releases	223,193	61.84	22.33
enqueue requests	223,202	61.84	22.33
enqueue timeouts	8	0.00	0.00
enqueue waits	3,948	1.09	0.39
exchange deadlocks	10	0.00	0.00
execute count	351,874	97.49	35.20
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	906,422,556	251,145.44	90,669.46
free buffer inspected	46,633	12.92	4.66
free buffer requested	118,469	32.82	11.85
gc blocks compressed	47,721	13.22	4.77
gc blocks lost	0	0.00	0.00
gc cr block flush time	9,540	2.64	0.95
gc cr block receive time	1,405	0.39	0.14
gc cr blocks received	26,629	7.38	2.66
gc cr blocks served	30,030	8.32	3.00
gc current block flush time	11,819	3.27	1.18
gc current block pin time	59	0.02	0.01
gc current block receive time	1,749	0.48	0.17
gc current blocks received	33,394	9.25	3.34
gc current blocks served	207,229	57.42	20.73
gc kbytes saved	154,851	42.91	15.49
gc kbytes sent	1,743,221	483.00	174.37
gc local grants	9,931	2.75	0.99
gc read wait time	11	0.00	0.00
gc read wait timeouts	0	0.00	0.00
gc read waits	1	0.00	0.00
gc remote grants	19,261	5.34	1.93
gcs messages sent	162,673	45.07	16.27
ges messages sent	58,245	16.14	5.83
global enqueue get time	5,025	1.39	0.50
global enqueue gets async	7,967	2.21	0.80
global enqueue gets sync	461,462	127.86	46.16
global enqueue releases	456,205	126.40	45.63
heap block compress	6,743	1.87	0.67
hot buffers moved to head of LRU	4,298	1.19	0.43
immediate (CR) block cleanout applications	2,885	0.80	0.29
immediate (CURRENT) block cleanout applications	6,165	1.71	0.62
in call idle wait time	16,477,249	4,565.40	1,648.22
index crx upgrade (positioned)	5,713	1.58	0.57
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	5	0.00	0.00
index fetch by key	1,953,176	541.17	195.38
index scans kdiixs1	512,254	141.93	51.24
leaf node 90-10 splits	50	0.01	0.01
leaf node splits	449	0.12	0.04
lob reads	53,877	14.93	5.39
lob writes	27,120	7.51	2.71
lob writes unaligned	27,120	7.51	2.71
logical read bytes from cache	457,309,995,008	126,708,362.96	45,744,722.92
logons cumulative	3,489	0.97	0.35
max cf enq hold time	400	0.11	0.04
messages received	59,189	16.40	5.92
messages sent	59,189	16.40	5.92
min active SCN optimization applied on CR	14,370	3.98	1.44
no buffer to keep pinned count	64	0.02	0.01
no work - consistent read gets	107,536,515	29,795.49	10,756.88
non-idle wait count	2,084,952	577.68	208.56
non-idle wait time	795,462	220.40	79.57
opened cursors cumulative	352,041	97.54	35.21
parse count (describe)	73	0.02	0.01
parse count (failures)	16	0.00	0.00
parse count (hard)	110,091	30.50	11.01
parse count (total)	222,423	61.63	22.25
parse time cpu	22,438	6.22	2.24
parse time elapsed	22,933	6.35	2.29
physical read IO requests	480,742	133.20	48.09
physical read bytes	474,293,780,480	131,414,115.46	47,443,611.13
physical read total IO requests	813,760	225.47	81.40
physical read total bytes	479,917,064,704	132,972,177.05	48,006,108.30
physical read total multi block requests	464,121	128.60	46.43
physical reads	57,897,190	16,041.76	5,791.46
physical reads cache	14,237	3.94	1.42
physical reads cache prefetch	5,093	1.41	0.51
physical reads direct	57,882,953	16,037.82	5,790.03
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	411,662	114.06	41.18
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	36,428	10.09	3.64
physical write bytes	4,056,154,112	1,123,851.77	405,737.13
physical write total IO requests	81,125	22.48	8.11
physical write total bytes	4,440,671,744	1,230,391.32	444,200.43
physical write total multi block requests	15,592	4.32	1.56
physical writes	495,136	137.19	49.53
physical writes direct	468,171	129.72	46.83
physical writes direct (lob)	4	0.00	0.00
physical writes direct temporary tablespace	468,114	129.70	46.83
physical writes from cache	26,965	7.47	2.70
physical writes non checkpoint	483,588	133.99	48.37
pinned buffers inspected	14	0.00	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	8	0.00	0.00
process last non-idle time	3,588	0.99	0.36
queries parallelized	437	0.12	0.04
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	612,097	169.60	61.23
recursive cpu usage	23,768	6.59	2.38
redo KB read	134,724	37.33	13.48
redo blocks checksummed by FG (exclusive)	26,408	7.32	2.64
redo blocks written	184,526	51.13	18.46
redo buffer allocation retries	1	0.00	0.00
redo entries	291,182	80.68	29.13
redo log space requests	1	0.00	0.00
redo log space wait time	6	0.00	0.00
redo ordering marks	3,855	1.07	0.39
redo size	86,038,120	23,838.86	8,606.39
redo size for direct writes	337,392	93.48	33.75
redo subscn max counts	3,903	1.08	0.39
redo synch long waits	526	0.15	0.05
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	103,061	28.56	10.31
redo synch time (usec)	1,031,110,677	285,693.18	103,142.01
redo synch writes	15,625	4.33	1.56
redo wastage	5,347,340	1,481.60	534.89
redo write broadcast ack count	29	0.01	0.00
redo write broadcast ack time	31,060	8.61	3.11
redo write broadcast lgwr post count	0	0.00	0.00
redo write time	62,823	17.41	6.28
redo writes	20,340	5.64	2.03
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	63	0.02	0.01
rollbacks only - consistent read gets	2,278	0.63	0.23
root node splits	0	0.00	0.00
rows fetched via callback	840,500	232.88	84.08
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	131,271	36.37	13.13
session logical reads	113,295,557	31,391.17	11,332.96
shared hash latch upgrades - no wait	30,018	8.32	3.00
shared hash latch upgrades - wait	15	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	259,755	71.97	25.98
sorts (rows)	4,622,022	1,280.64	462.34
sql area evicted	109,344	30.30	10.94
sql area purged	19	0.01	0.00
summed dirty queue length	1,546	0.43	0.15
switch current to new buffer	8,028	2.22	0.80
table fetch by rowid	247,449,962	68,561.76	24,752.42
table fetch continued row	25,188	6.98	2.52
table scan blocks gotten	80,935,623	22,425.10	8,095.99
table scan rows gotten	2,432,272,242	673,917.56	243,300.21
table scans (direct read)	891	0.25	0.09
table scans (long tables)	594	0.16	0.06
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	236,973	65.66	23.70
temp space allocated (bytes)	2,097,152	581.06	209.78
total cf enq hold time	14,470	4.01	1.45
total number of cf enq holders	185	0.05	0.02
total number of times SMON posted	16	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction lock foreground wait time	0	0.00	0.00
transaction rollbacks	18	0.00	0.00
transaction tables consistent read rollbacks	1	0.00	0.00
transaction tables consistent reads - undo records applied	18	0.00	0.00
undo change vector size	27,398,020	7,591.26	2,740.62
user I/O wait time	519,577	143.96	51.97
user calls	1,000,547	277.22	100.08
user commits	9,996	2.77	1.00
user rollbacks	1	0.00	0.00
workarea executions - onepass	13	0.00	0.00
workarea executions - optimal	35,327	9.79	3.53
write clones created in background	0	0.00	0.00
write clones created in foreground	9	0.00	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	442,663,719,744	442,392,044,896
session cursor cache count	107,734,173	107,780,880
session uga memory	367,587,823,487,664	367,630,947,133,128
opened cursors current	379	375
logons current	212	212
session uga memory max	6,128,234,630,224	6,131,647,593,424
session pga memory	336,621,736,096	336,662,192,160

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)	3	2.99

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)
Direct Reads	441.5G	129.32	125.267	0M	0.00	0M	0
Others	5.2G	92.26	1.48511	187M	1.00	.051812	334.6K	1.18
Direct Writes	0M	0.00	0M	3.6G	4.20	1.01297	0
DBWR	0M	0.00	0M	210M	5.89	.058185	0
LGWR	1M	0.01	.000277	182M	11.40	.050427	20.4K	30.32
Buffer Cache Reads	111M	3.85	.030755	0M	0.00	0M	9159	28.75
Streams AQ	0M	0.00	0M	0M	0.00	0M	1	86.00
TOTAL:	446.9G	225.45	126.783	4.1G	22.48	1.17340	364.2K	3.51

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	438.5G	129.48	124.406	213M	5.89	.059016	21.19	23.84
Temp File	3.1G	3.69	.891344	3.6G	4.20	1.01353	66.54	16.97
Control File	5.1G	92.22	1.44909	55M	0.97	.015239	1.07	24.63
Log File	131M	0.05	.036296	181M	11.38	.050150	11.65	49.49
Archive Log	0M	0.00	0M	131M	0.04	.036296
TOTAL:	446.9G	225.45	126.783	4.1G	22.48	1.17423	2.06	23.65

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)
Direct Reads	441.5G	129.31	125.249	0M	0.00	0M	0
Direct Reads (Data File)	441.5G	129.31	125.249	0M	0.00	0M	0
Others	5.2G	92.26	1.48538	187M	1.00	.051812	332.8K	1.08
Others (Control File)	5.1G	92.21	1.44909	54M	0.96	.014961	332.8K	1.08
Others (Archive Log)	0M	0.00	0M	131M	0.04	.036296	0
Others (Log File)	131M	0.04	.036296	0M	0.00	0M	21	0.00
Others (Data File)	0M	0.00	0M	2M	0.00	.000554	12	7.67
Direct Writes	0M	0.00	0M	3.6G	4.20	1.01297	0
Direct Writes (Data File)	0M	0.00	0M	3.6G	4.20	1.01297	0
DBWR	0M	0.00	0M	210M	5.89	.058185	0
DBWR (Data File)	0M	0.00	0M	210M	5.89	.058185	0
LGWR	1M	0.01	.000277	181M	11.39	.050150	63	11.08
LGWR (Log File)	0M	0.00	0M	180M	11.38	.049873	24	18.71
LGWR (Control File)	1M	0.01	.000277	1M	0.02	.000277	39	6.38
Buffer Cache Reads	111M	3.85	.030755	0M	0.00	0M	7832	27.41
Buffer Cache Reads (Data File)	111M	3.85	.030755	0M	0.00	0M	7832	27.41
Streams AQ	0M	0.00	0M	0M	0.00	0M	1	86.00
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	1	86.00
TOTAL:	446.8G	225.42	126.765	4.1G	22.48	1.17312	340.7K	1.68

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)
TEMPUSICS	464,433	129	0.47	123.02	19,600	5	332	15.42
TEMP	13,331	4	0.00	30.88	15,152	4	0	0.00
SYSTEM	4,103	1	0.70	125.96	230	0	129	70.93
SYSAUX	221	0	41.00	1.00	718	0	0	0.00
UNDOTBS1	2	0	0.00	1.00	561	0	16	0.00
POLICY	2	0	0.00	1.00	2	0	0	0.00
UNDOTBS2	2	0	0.00	1.00	2	0	3	0.00
USERS	2	0	0.00	1.00	2	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)
POLICY	+DATA/oradb/datafile/policy.501.798195483	2	0	0.00	1.00	2	0	0	0.00
SYSAUX	+DATA/oradb/datafile/sysaux.263.797076875	221	0	41.00	1.00	718	0	0	0.00
SYSTEM	+DATA/oradb/datafile/system.260.797076869	4,103	1	0.70	125.96	230	0	129	70.93
TEMP	+DATA/oradb/tempfile/temp.261.797076883	13,331	4	0.00	30.88	15,152	4	0
TEMPUSICS	+DATA/oradb/datafile/tempusics.502.798195487	334,537	93	0.35	125.13	12,701	4	227	21.32
TEMPUSICS	+DATA/oradb/datafile/tempusics01.dbf	129,896	36	0.78	117.56	6,899	2	105	2.67
UNDOTBS1	+DATA/oradb/datafile/undotbs1.265.797076881	2	0	0.00	1.00	561	0	16	0.00
UNDOTBS2	+DATA/oradb/datafile/undotbs2.262.797076887	2	0	0.00	1.00	2	0	3	0.00
USERS	+DATA/oradb/datafile/users.257.797076889	2	0	0.00	1.00	2	0	0	0.00

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	287,204	100	55,806,399	14,225	26,965	0	0	485

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 495,136

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	19,373	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	2	1782	16720	99099	497664	99099			1
E	0	1	1675	11906	70750	497664	70750			0

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	224	0.09	26	2.38	642,798	1	1747542.00
D	448	0.18	53	1.70	458,841	1	1073422.00
D	672	0.28	79	1.28	346,681	1	662405.00
D	896	0.37	106	1.09	294,496	1	471174.00
D	1,120	0.46	132	1.02	275,943	1	403186.00
D	1,344	0.55	159	1.00	271,548	1	387077.00
D	1,568	0.64	185	1.00	270,735	1	384100.00
D	1,792	0.74	212	1.00	270,491	1	383206.00
D	2,016	0.83	238	1.00	270,368	1	382755.00
D	2,240	0.92	265	1.00	270,278	1	382422.00
D	2,432	1.00	287	1.00	270,219	1	382208.00
D	2,464	1.01	291	1.00	270,209	1	382172.00
D	2,688	1.11	317	1.00	270,156	1	381975.00
D	2,912	1.20	344	1.00	270,111	1	381812.00
D	3,136	1.29	370	1.00	270,072	1	381670.00
D	3,360	1.38	397	1.00	270,039	1	381548.00
D	3,584	1.47	423	1.00	270,011	1	381447.00
D	3,808	1.57	450	1.00	269,992	1	381375.00
D	4,032	1.66	476	1.00	269,849	1	380851.00
D	4,256	1.75	503	0.99	268,591	1	376242.00
D	4,480	1.84	529	0.98	265,749	1	365829.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
60.93	7,541	4,835

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	30,554	30,554	0
64K	128K	1,096	1,096	0
128K	256K	652	652	0
256K	512K	502	502	0
512K	1024K	2,305	2,305	0
1M	2M	192	192	0
2M	4M	1	1	0
4M	8M	2	2	0
8M	16M	18	18	0
16M	32M	3	1	2
256M	512M	11	0	11

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
420	0.13	13,015,894.64	32,474,662.54	29.00	108,342	13,365,850,018
840	0.25	13,015,894.64	7,992,088.68	62.00	69	6,172,479,997
1,680	0.50	13,015,894.64	7,981,054.04	62.00	0	6,169,237,844
2,520	0.75	13,015,894.64	7,981,054.04	62.00	0	6,169,237,844
3,360	1.00	13,015,894.64	7,981,054.04	62.00	0	6,169,237,844
4,032	1.20	13,015,894.64	7,980,069.03	62.00	0	6,168,948,432
4,704	1.40	13,015,894.64	7,980,069.03	62.00	0	6,168,948,432
5,376	1.60	13,015,894.64	7,980,069.03	62.00	0	6,168,948,432
6,048	1.80	13,015,894.64	7,980,069.03	62.00	0	6,168,948,432
6,720	2.00	13,015,894.64	7,980,069.03	62.00	0	6,168,948,432
10,080	3.00	13,015,894.64	7,980,069.03	62.00	0	6,168,948,432
13,440	4.00	13,015,894.64	7,980,069.03	62.00	0	6,168,948,432
20,160	6.00	13,015,894.64	7,980,069.03	62.00	0	6,168,948,432
26,880	8.00	13,015,894.64	7,980,069.03	62.00	0	6,168,948,432

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)
2,208	0.59	387	42,287	8,860,450	0.46	10,802,990	24.40	1,203,990
2,592	0.69	770	57,256	11,501,454	0.60	8,161,986	18.43	1,491,200
2,976	0.79	1,152	73,166	14,115,317	0.73	5,548,123	12.53	1,773,346
3,360	0.90	1,536	88,748	16,721,778	0.87	2,941,662	6.64	2,053,909
3,424	0.91	1,600	91,373	17,155,932	0.89	2,507,508	5.66	2,100,533
3,456	0.92	1,632	92,507	17,372,713	0.90	2,290,727	5.17	2,123,827
3,488	0.93	1,664	93,774	17,589,522	0.92	2,073,918	4.68	2,147,124
3,520	0.94	1,696	95,074	17,804,448	0.93	1,858,992	4.20	2,170,291
3,552	0.95	1,728	96,335	18,018,368	0.94	1,645,072	3.72	2,193,486
3,584	0.96	1,760	97,626	18,222,478	0.95	1,440,962	3.25	2,215,817
3,616	0.97	1,792	98,852	18,425,782	0.96	1,237,658	2.80	2,237,986
3,648	0.97	1,824	100,250	18,629,469	0.97	1,033,971	2.34	2,260,238
3,680	0.98	1,856	101,592	18,827,492	0.98	835,948	1.89	2,282,028
3,712	0.99	1,888	103,023	19,021,238	0.99	642,202	1.45	2,303,438
3,744	1.00	1,920	104,459	19,220,623	1.00	442,817	1.00	2,327,415
3,776	1.01	1,952	105,729	19,229,173	1.00	434,267	0.98	2,331,114
3,808	1.02	1,984	107,046	19,232,714	1.00	430,726	0.97	2,332,679
3,840	1.03	2,016	108,407	19,232,871	1.00	430,569	0.97	2,332,746
3,872	1.03	2,047	109,869	19,233,037	1.00	430,403	0.97	2,332,815
3,904	1.04	2,079	111,355	19,233,191	1.00	430,249	0.97	2,332,882
3,936	1.05	2,111	112,651	19,233,329	1.00	430,111	0.97	2,332,947
3,968	1.06	2,143	114,142	19,233,483	1.00	429,957	0.97	2,333,010
4,000	1.07	2,175	115,537	19,233,622	1.00	429,818	0.97	2,333,071
4,032	1.08	2,207	117,071	19,233,752	1.00	429,688	0.97	2,333,130
4,128	1.10	2,303	120,785	19,234,182	1.00	429,258	0.97	2,333,309
4,512	1.21	2,687	136,657	19,235,767	1.00	427,673	0.97	2,334,008
4,896	1.31	3,071	153,082	19,237,291	1.00	426,149	0.96	2,334,707
5,280	1.41	3,455	168,694	19,238,799	1.00	424,641	0.96	2,335,445
5,664	1.51	3,838	183,828	19,240,425	1.00	423,015	0.96	2,336,209
6,048	1.62	4,220	199,468	19,241,947	1.00	421,493	0.95	2,336,933
6,432	1.72	4,603	215,099	19,243,397	1.00	420,043	0.95	2,337,624
6,816	1.82	4,987	230,081	19,244,809	1.00	418,631	0.95	2,338,270
7,200	1.92	5,371	245,828	19,245,983	1.00	417,457	0.94	2,338,870
7,584	2.03	5,754	261,865	19,247,045	1.00	416,395	0.94	2,339,426

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,364	0.38	19,619,998	458,372,247
3,152	0.50	13,456,727	458,372,247
3,940	0.63	7,200,027	642,148,092
4,728	0.75	5,117,474	294,187,270
5,516	0.88	5,026,557	270,462,054
6,304	1.00	5,023,041	270,218,857
7,092	1.13	5,020,027	270,218,857
7,880	1.25	5,017,013	270,218,857
8,668	1.38	5,007,470	265,490,027
9,456	1.50	5,003,953	265,490,027
10,244	1.63	5,000,940	265,490,027
11,032	1.75	4,997,926	265,490,027
11,820	1.88	4,995,414	265,490,027
12,608	2.00	4,994,410	265,490,027

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	386	13	35
segment header	78	0	0
undo header	11	0	0
undo block	5	0	0
file header block	3	0	0
1st level bmb	2	0	0

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)
KO-Multiple Object Checkpoint (fast object checkpoint)	10,886	10,886	0	3,128	43	13.88
TX-Transaction (row lock contention)	12	12	0	12	1	92.50
TX-Transaction (index contention)	57	57	0	44	1	14.09
PS-PX Process Reservation	3,053	3,053	0	483	0	0.48
CF-Controlfile Transaction	7,953	7,952	1	115	0	0.26
TT-Tablespace	4,449	4,449	0	39	0	0.26
HW-Segment High Water Mark	549	549	0	24	0	0.42
JQ-Job Queue	16	9	7	12	0	0.83
TQ-Queue table enqueue (TM contention)	133	133	0	9	0	1.11
US-Undo Segment	52	52	0	26	0	0.00
WF-AWR Flush	23	23	0	10	0	0.00
FB-Format Block	16	16	0	9	0	0.00
TM-DML	31,056	31,056	0	9	0	0.00
TA-Instance Undo	13	13	0	7	0	0.00
TD-KTF map table enqueue (KTF dump entries)	8	8	0	7	0	0.00
CR-Reuse Block Range (block range reuse ckpt)	228	228	0	5	0	0.00
AE-Edition Lock (lock)	2,995	2,995	0	2	0	0.00
DR-Distributed Recovery	2	2	0	2	0	0.00
WL-Being Written Redo Log	3	3	0	2	0	0.00
AF-Advisor Framework (task serialization)	13	13	0	1	0	0.00
JS-Job Scheduler (job run lock - synchronize)	2	2	0	1	0	0.00
UL-User-defined	9	9	0	1	0	0.00

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	5.08	23,181	575	5	15/29.8	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
20-11月 10:01	348	3,812	0	4	20	0/0	0/0/0/0/0/0
20-11月 09:51	450	3,722	566	3	30	0/0	0/0/0/0/0/0
20-11月 09:41	551	3,485	0	5	20	0/0	0/0/0/0/0/0
20-11月 09:31	933	3,300	0	5	15	0/0	0/0/0/0/0/0
20-11月 09:21	904	3,384	0	4	20	0/0	0/0/0/0/0/0
20-11月 09:11	773	2,741	575	4	30	0/0	0/0/0/0/0/0
20-11月 09:01	1,119	2,737	0	4	20	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	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
AQ deq log cmt cbk chunk latch	14	0.00		0
AQ deq log statistics latch	7	0.00		0
AQ dequeue txn counter latch	3,248	0.00		0
AQ ht cmt cbk chunk latch	14	0.00		0
ASM Keyed state latch	6,054	0.00		0
ASM allocation	371	0.00		0
ASM db client latch	5,740	0.00		0
ASM map headers	116	0.00		0
ASM map load waiting list	20	0.00		0
ASM map operation freelist	5,545	0.11	0.00	0
ASM map operation hash table	1,835,007	0.01	0.00	0
ASM network SGA latch	9	0.00		0
ASM network background latch	1,804	0.00		0
ASM network state latch	465	0.00		0
ASM scan context latch	12	0.00		0
AWR Alerted Metric Element list	34,580	0.00		0
Change Notification Hash table latch	1,196	0.00		0
Consistent RBA	20,349	0.00	0.00	0
DML lock allocation	3,903,866	0.00	0.00	0
Event Group Locks	6,516	0.00		0
FAL Queue	101	0.00		0
FIB s.o chain latch	30	0.00		0
FOB s.o list latch	17,239	0.05	0.00	0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC other latch	31	0.00		0
IPC stats buffer allocation latch	12,609	0.00		12,617	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	7	0.00		0
JS broadcast add buf latch	826	0.00		0
JS broadcast drop buf latch	826	0.00		0
JS broadcast load blnc latch	720	0.00		0
JS mem alloc latch	5	0.00		0
JS queue access latch	6	0.00		0
JS queue state obj latch	26,058	0.00		0
JS slv state obj latch	67	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KFK SGA Libload latch	136	0.00		0
KFMD SGA	3	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	17,939	0.30	0.00	769	0.13
KJCT flow control latch	292,686	0.02	0.00	0
KMG MMAN ready and startup request latch	1,197	0.00		0
KSXR large replies	242	0.00		0
KTF sga latch	28	0.00		1,132	0.00
KWQMN job cache list latch	873	0.00		0
KWQS pqsubs latch	7	0.00		0
KWQS pqueue ctx latch	72	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	40,338	0.09	0.00	0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	1	0.00		1,197	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	2,469	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	12,411	0.00		0
OS process allocation	13,442	0.04	0.00	0
OS process: request allocation	6,054	0.03	0.00	0
PL/SQL warning settings	4,737	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	22,832	0.00		0
SGA IO buffer pool latch	38	0.00		38	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	120	0.00		1,165	0.00
SQL memory manager workarea list latch	93,961	0.00		0
Shared B-Tree	660	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	2,073	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	38,051	1.04	0.00	0
active service list	1,547,670	0.01	0.01	2,342	0.04
alert log latch	6	0.00		0
archive control	192	0.00		0
archive process latch	306	0.00		0
begin backup scn array	9	0.00		0
buffer pool	1	0.00		0
business card	875	0.00		0
cache buffer handles	5,290	0.00		0
cache buffers chains	109,536,248	0.23	0.00	998,098	0.75
cache buffers lru chain	121,556	0.01	0.06	676,974	0.00
cache table scan latch	30	0.00		30	0.00
call allocation	15,380	0.29	0.41	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	7,081	0.00		0
channel operations parent latch	1,848,791	0.00	0.00	0
checkpoint queue latch	1,615,589	0.00	0.00	44,983	0.00
client/application info	25,230	0.00		0
compile environment latch	3,489	0.00		0
corrupted undo seg latch	207	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	57	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	57	0.00		0
dml lock allocation	57	0.00		0
done queue latch	1	0.00		0
dummy allocation	6,981	0.01	0.00	0
enqueue freelist latch	1	0.00		341,682	0.00
enqueue hash chains	555,180	0.02	0.00	103	0.00
error message lists	2,171	0.00		0
fifth spare latch	1	0.00		0
file cache latch	310	0.00		0
flashback copy	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	804,284	0.01	0.03	28,933	0.01
gc persistent rm	2	0.00		0
gcr global ctx	33	0.00		0
gcs commit scn state	1	0.00		0
gcs opaque info freelist	60,596	0.25	0.00	0
gcs partitioned table hash	6,981,662	0.45	0.00	14,832	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	296	0.00		0
gcs remastering latch	146,100	4.82	0.00	1	0.00
gcs resource freelist	92,782	0.00		8,479	0.00
gcs resource hash	1,145,082	0.01	0.00	150	0.00
gcs resource scan list	344	0.00		0
gcs shadows freelist	96,261	0.00		14,338	0.01
ges caches resource lists	282,453	0.00	0.00	75,612	0.00
ges deadlock list	6,892	0.00		0
ges domain table	906,363	0.00	0.00	0
ges enqueue table freelist	920,160	0.00	0.14	0
ges group table	919,447	0.00	0.00	0
ges process hash list	121,181	0.00	0.00	0
ges process parent latch	1,885,231	0.00		0
ges process table freelist	6,054	0.08	0.00	0
ges resource hash list	1,889,917	0.02	0.02	17,524	0.01
ges resource scan list	91	0.00		0
ges resource table freelist	28,757	0.00		0
ges timeout list	8,862	0.00		1,627	0.00
ges value block free list	10	0.00		0
global KZLD latch for mem in SGA	2,966	0.00		0
global ctx hash table latch	1	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	1,114	0.00		876,895	0.01
hash table modification latch	117	0.00		0
heartbeat check	1	0.00		1,016	0.00
heartbeat structure management	0			718	0.00
internal temp table object number allocation latch	47	0.00		0
interrupt manipulation	4,057	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	19	0.00		18	0.00
job_queue_processes free list latch	38	0.00		0
job_queue_processes parameter latch	792	0.00		0
k2q global data latch	2,392	0.00		0
k2q lock allocation	1	0.00		0
kcbtsemkid latch	3	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kgnfs mount latch	1	0.00		0
kokc descriptor allocation latch	900	0.00		0
krbmrosl	2	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	7,151	0.00		0
ksim membership request latch	1,656	0.00		2,976	0.00
kss move lock	55	0.00		0
ksuosstats global area	507	0.00		0
ksv allocation latch	165	0.00		0
ksv class latch	8,678	0.03	0.00	0
ksv instance latch	16	0.00		0
ksv msg queue latch	67	0.00		66	0.00
ksxp shared latch	6,054	0.08	0.00	0
ksxp so latch	6,054	0.02	0.00	0
ksz_so allocation latch	6,054	0.18	0.00	0
ktm global data	96	0.00		0
kwqbsn:qsga	193	0.00		0
lgwr LWN SCN	20,813	0.00		0
list of block allocation	7,469	0.03	0.00	0
loader state object freelist	1,835	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	13	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	304	0.00		287	0.00
managed standby latch	98	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	12,231	0.00		0
messages	374,123	0.13	0.00	0
mostly latch-free SCN	21,256	0.16	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	9,610	0.00		0
name-service memory objects	24,100	0.00		0
name-service namespace bucket	41,539	0.00		0
name-service pending queue	11,950	0.00		0
name-service request queue	47,795	0.00		0
ncodef allocation latch	57	0.00		0
object queue header heap	13,353	0.00		13,010	0.00
object queue header operation	799,065	0.01	0.06	0
object stats modification	130	0.00		0
parallel query alloc buffer	9,521	0.00		0
parallel query stats	1,764	0.00		0
parallel txn reco latch	468	0.00		0
parameter list	28,703	0.01	0.00	0
parameter table management	50,981	0.00	0.50	0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	120,230	0.02	0.00	109,943	0.02
process allocation	22,751	0.11	0.67	3,025	0.03
process group creation	6,054	0.18	0.00	0
process queue	4,832	0.00		0
process queue reference	79,541	0.00	0.00	7,561	0.00
qmn state object latch	8	0.00		0
qmn task context latch	6	0.00		0
qmn task queue latch	560	0.18	0.00	0
query server freelists	3,950	0.00		0
query server process	430	0.00		0
queued dump request	12	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	62,216	0.02	0.00	291,137	0.04
redo copy	1	0.00		291,188	0.09
redo writing	92,976	0.14	0.00	0
resmgr group change latch	3,452	0.00		0
resmgr:active threads	7,029	0.00		0
resmgr:actses change group	3,456	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	6,980	0.07	0.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	129	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	12,842,178	0.10	0.00	1,094	0.09
second Audit Vault latch	1	0.00		0
second spare latch	1	0.00		0
segmented array pool	30	0.00		0
sequence cache	15,772	0.00		0
session allocation	19,254	0.01	0.00	12,325	0.00
session idle bit	2,009,915	0.00	0.00	0
session queue latch	1	0.00		0
session state list latch	1,099	0.00		0
session switching	3,086	0.19	0.00	0
session timer	1,197	0.00		0
shared pool	6,701,515	0.08	0.23	0
shared pool sim alloc	1	0.00		0
shared pool simulator	441,936	0.00	0.27	0
sim partition latch	1	0.00		0
simulator hash latch	3,779,962	0.00	0.00	0
simulator lru latch	1	0.00		3,779,247	0.30
sort extent pool	6,012	0.00		0
space background state object latch	14	0.00		0
space background task latch	4,673	0.62	0.00	2,398	0.00
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	566	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	141	0.00		0
transaction allocation	952,968	0.00		0
undo global data	80,398	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		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	109,536,248	247,714	102	247,613
shared pool	6,701,515	5,230	1,192	4,054
messages	374,123	488	1	487
ges resource hash list	1,889,917	398	9	389
active checkpoint queue latch	38,051	397	1	396
active service list	1,547,670	159	1	158
gc element	804,284	109	3	106
object queue header operation	799,065	47	3	44
call allocation	15,380	44	18	27
process allocation	22,751	24	16	8
cache buffers lru chain	121,556	17	1	16
ges enqueue table freelist	920,160	14	2	12
shared pool simulator	441,936	11	3	8
parameter table management	50,981	2	1	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
active checkpoint queue latch	kcbbacq: scan active checkpoints	1	1
active service list	kswslogon: session logout	3	0
active service list	kswsite: service iterator	1	0
cache buffers chains	kcbgtcr: fast path (cr pin)	85	36
cache buffers chains	kcbgcur_2	12	4
cache buffers chains	kcbgtcr: fast path	10	2
cache buffers chains	kcbgtcr: kslbegin excl	6	42
cache buffers chains	kcbget: fast exchange	3	3
cache buffers chains	kcbzwb	3	6
cache buffers chains	kclcls_3	3	2
cache buffers chains	kcbchg1: mod cr pin	1	0
cache buffers lru chain	kcbzgws	1	0
call allocation	ksuxds	18	18
gc element	kclnfndnewm	8	0
ges enqueue table freelist	kjlalc: lock allocation	2	2
ges resource hash list	kjakcai: search for resp by resname	6	0
ges resource hash list	kjrmas1: lookup master node	2	0
ges resource hash list	kjlrlr: remove lock from resource queue	1	1
messages	ksaamb: after wakeup	1	0
object queue header operation	kclobj_5	2	0
object queue header operation	kcbo_link_q	1	1
parameter table management	ksp_param_table_free	1	0
process allocation	ksucrp:1	15	0
process allocation	ksufap: active procs	1	2
shared pool	kghalo	1,160	547
shared pool	kghalp	23	279
shared pool	kghupr1	8	320
shared pool	kgh_heap_sizes	1	21
shared pool simulator	kglsim_upd_newhp	3	2

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglget1 1	349
Library Cache	kgllkdl1 85	336
Library Cache	kglhdgn2 106	98
Library Cache	kgldtin1 42	66
Library Cache	kglpnal2 91	42
Library Cache	kglpndl1 95	32
Library Cache	kglhdgn1 62	24
Library Cache	kgllkc1 57	24
Library Cache	kglobpn1 71	24
Library Cache	kglrfcl1 79	14
Cursor Pin	kkslce [KKSCHLPIN2]	13
Library Cache	kglget2 2	9
Library Cache	kgllkal1 80	9
Library Cache	kglpin1 4	9
Library Cache	kglhdgh1 64	7
Library Cache	kglpnal1 90	6
Library Cache	kglhdgc1 102	1
Cursor Pin	kksLockDelete [KKSCHLPIN6]	1

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: 113,295,557
Captured Segments account for 99.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TEMPUSICS	TEMPUSICS	ICS_ORDER	TABLE	58,934,512	52.02
TEMPUSICS	TEMPUSICS	POLICY_BASE	TABLE	14,232,416	12.56
TEMPUSICS	TEMPUSICS	ICS_AUTOTICKETTASK	TABLE	7,439,696	6.57
TEMPUSICS	TEMPUSICS	ICS_FANDIAN	TABLE	7,099,392	6.27
TEMPUSICS	TEMPUSICS	ICS_OTHERORDER	TABLE	5,169,472	4.56

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.97	In-memory Sort %:	100.00
Library Hit %:	65.13	Soft Parse %:	50.50
Execute to Parse %:	36.79	Latch Hit %:	99.82
Parse CPU to Parse Elapsd %:	97.84	% Non-Parse CPU:	87.10

Buffer access - local cache %:	99.87
Buffer access - remote cache %:	0.11
Buffer access - disk %:	0.03

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.5
Avg global cache current block receive time (ms):	0.5
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 %:	5.6
Avg global cache cr block flush time (ms):	57.2
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.6
Avg global cache current block flush time (ms):	93.5

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	4.4
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	58.72
% of indirect sent messages:	41.23
% of flow controlled messages:	0.06

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
TEMPUSICS	TEMPUSICS	POLICY_BASE_FILEID	INDEX	4,245	0.86
TEMPUSICS	TEMPUSICS	POLICY_BASE	TABLE	2,009	0.41
TEMPUSICS	TEMPUSICS	INDEX456	INDEX	1,527	0.31
TEMPUSICS	TEMPUSICS	POLICY_BASE_ISSTATUS	INDEX	1,433	0.29
TEMPUSICS	TEMPUSICS	ICS_ORDER	TABLE	1,393	0.28

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
TEMPUSICS	TEMPUSICS	OPERATE_LOG_ID	INDEX	21	33.87
TEMPUSICS	TEMPUSICS	ICS_AUTOTICKETTASK	TABLE	12	19.35
TEMPUSICS	TEMPUSICS	OPERATE_LOG_ORDERID	INDEX	12	19.35
TEMPUSICS	TEMPUSICS	POLICY_BASE_PUBTIME	INDEX	9	14.52
TEMPUSICS	TEMPUSICS	OPERATE_LOG_OPERATEID	INDEX	3	4.84

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	AUD$	TABLE	32	39.02
TEMPUSICS	TEMPUSICS	ICS_FEIPIAO	TABLE	19	23.17
TEMPUSICS	TEMPUSICS	OPERATE_LOG_ID	INDEX	11	13.41
TEMPUSICS	TEMPUSICS	POLICY_BASE_PUBTIME	INDEX	11	13.41
TEMPUSICS	TEMPUSICS	ICS_AUTOTICKETTASK	TABLE	3	3.66

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	64	0.00	2	1
dc_files	336	0.00	0	8
dc_global_oids	4,599	0.83	0	53
dc_histogram_data	1,518,579	0.11	0	2,767
dc_histogram_defs	1,373,372	0.22	2	3,060
dc_object_grants	556	1.80	0	9
dc_objects	1,207,194	0.07	6	1,329
dc_profiles	2,977	0.00	0	1
dc_rollback_segments	4,754	0.00	0	42
dc_segments	758,685	0.10	10	599
dc_sequences	3,202	39.16	3,202	4
dc_tablespaces	30,300	0.02	0	9
dc_users	377,314	0.02	0	95
global database name	7,300	0.00	0	1
outstanding_alerts	30	100.00	0	5
sch_lj_oids	4	75.00	0	1

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	5,932	0.05	0		0	0
APP CONTEXT	1	0.00	7	0.00	0	0
BODY	662	6.34	5,311	1.45	29	0
CLUSTER	137	3.65	137	3.65	0	0
DBLINK	5,934	0.00	0		0	0
EDITION	2,991	0.00	5,965	0.00	0	0
INDEX	174	13.79	174	13.79	0	0
OBJECT ID	1	100.00	0		0	0
QUEUE	461	0.00	9,109	0.01	1	0
SCHEMA	3,443	0.03	0		0	0
SQL AREA	220,815	48.68	618,948	53.04	2,600	19
SQL AREA BUILD	110,046	99.48	0		0	0
SQL AREA STATS	109,727	98.97	109,727	98.97	0	0
SUBSCRIPTION	2	50.00	2	50.00	0	0
TABLE/PROCEDURE	122,861	0.18	497,693	0.57	1,809	0
TRIGGER	6,314	0.08	14,197	0.06	3	0

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	2,432.00	2,432.00	2,400.00	2,880.00	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	3,360.00	3,360.00	3,360.00	3,360.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	6,304.00	6,304.00	6,304.00	6,304.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	32.00	32.00	32.00	32.00	STA/
large pool	32.00	32.00	32.00	32.00	STA/
shared pool	3,744.00	3,744.00	3,296.00	3,776.00	GRO/DEF
streams pool	0.00	0.00	0.00	0.00	STA/

	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	671.32		3.12	5.74	43	43	215	215
B	Freeable	100.44	0.00	1.90	3.98	19		53	53
B	PL/SQL	11.60	3.15	0.05	0.24	2	2	213	213
B	SQL	6.21	3.76	0.03	0.15	2	366	182	175
E	Other	679.95		3.18	5.74	43	43	214	214
E	Freeable	106.38	0.00	1.66	3.65	19		64	64
E	PL/SQL	9.77	1.40	0.05	0.20	2	2	211	210
E	SQL	4.07	1.67	0.02	0.02	0	366	180	172

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,550,136,832
Fixed Size	2,237,048
Redo Buffers	19,619,840
Variable Size	7,516,196,232

Pool	Name	Begin MB	End MB	% Diff
java	free memory	32.00	32.00	0.00
large	ASM map operations hashta	0.38	0.38	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	23.81	23.81	0.00
shared	ASH buffers	48.00	48.00	0.00
shared	KGLDA	39.27	39.60	0.86
shared	KGLH0	783.26	788.73	0.70
shared	KGLHD	157.25	162.20	3.14
shared	SQLA	1,617.28	1,628.13	0.67
shared	free memory	533.29	514.73	-3.48
shared	gcs resources	75.35	75.35	0.00
shared	gcs shadows	43.96	43.96	0.00
shared	kglsim object batch	47.18	47.18	0.00
	buffer_cache	2,432.00	2,432.00	0.00
	fixed_sga	2.13	2.13	0.00
	log_buffer	18.71	18.71	0.00

Name	Total Disp Time (s)	%Busy	%Idle
D000	3,589	0.00	100.00
D000	3,589	0.00	100.00
D000	3,589	0.00	100.00
D000	3,589	0.00	100.00
Sum
Avg		0.00	100.00
Std		0.00	0.00

Parameter Name	Begin value	End value (if different)
audit_file_dest	/data/oracle/admin/oradb/adump
audit_trail	DB
cluster_database	TRUE
compatible	11.2.0.0.0
control_files	+DATA/oradb/controlfile/current.256.797076867, +DATA/oradb/controlfile/current.267.797076867
db_block_size	8192
db_create_file_dest	+DATA
db_domain
db_name	oradb
db_recovery_file_dest	+DATA
db_recovery_file_dest_size	21474836480
diagnostic_dest	/data/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=oradbXDB)
instance_number	1
local_listener	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.2.42)(PORT=1521))))
log_archive_dest
log_archive_dest_1	location=+DATA/arch
memory_target	10133438464
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	300
processes	800
remote_listener	rac01cluster.tempus.cn:1521
remote_login_passwordfile	EXCLUSIVE
sessions	1224
spfile	+DATA/oradb/spfileoradb.ora
thread	1
undo_tablespace	UNDOTBS1

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	21,031	5.83	2.10
acks for commit broadcast(logical)	21,383	5.92	2.14
broadcast msgs on commit(actual)	18,778	5.20	1.88
broadcast msgs on commit(logical)	20,227	5.60	2.02
broadcast msgs on commit(wasted)	944	0.26	0.09
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	2	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	15,797	4.38	1.58
gcs ast xid	6	0.00	0.00
gcs blocked converts	17,876	4.95	1.79
gcs blocked cr converts	19,908	5.52	1.99
gcs compatible basts	38	0.01	0.00
gcs compatible cr basts (global)	4,009	1.11	0.40
gcs compatible cr basts (local)	11,833	3.28	1.18
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	5,713	1.58	0.57
gcs dbwr write request msgs	5,449	1.51	0.55
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	15	0.00	0.00
gcs force cr grant	5	0.00	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	906	0.25	0.09
gcs immediate (null) converts	7,006	1.94	0.70
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	2,774	0.77	0.28
gcs indirect ast	4,587	1.27	0.46
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	4,587	1.27	0.46
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	937	0.26	0.09
gcs msgs process time(ms)	8,773	2.43	0.88
gcs msgs received	326,911	90.58	32.70
gcs new served by master	152	0.04	0.02
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	47	0.01	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	64	0.02	0.01
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	4	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	10,653	2.95	1.07
gcs side channel msgs logical	73,492	20.36	7.35
gcs stale cr	0	0.00	0.00
gcs undo cr	72	0.02	0.01
gcs write notification msgs	101	0.03	0.01
gcs writes refused	1	0.00	0.00
ges msgs process time(ms)	602	0.17	0.06
ges msgs received	33,835	9.37	3.38
global posts dropped	0	0.00	0.00
global posts queue time	24	0.01	0.00
global posts queued	10	0.00	0.00
global posts requested	10	0.00	0.00
global posts sent	10	0.00	0.00
implicit batch messages received	2,162	0.60	0.22
implicit batch messages sent	2,228	0.62	0.22
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	99	0.03	0.01
messages queue sent actual	53,910	14.94	5.39
messages queue sent logical	4,872	1.35	0.49
messages received actual	210,224	58.25	21.03
messages received logical	360,761	99.96	36.09
messages sent directly	105,472	29.22	10.55
messages sent indirectly	74,048	20.52	7.41
messages sent not implicit batched	10	0.00	0.00
messages sent pbatched	84,478	23.41	8.45
msgs causing lmd to send msgs	13,045	3.61	1.30
msgs causing lms(s) to send msgs	16,155	4.48	1.62
msgs received queue time (ms)	16,330	4.52	1.63
msgs received queued	360,744	99.95	36.09
msgs sent queue time (ms)	1,666	0.46	0.17
msgs sent queue time on ksxp (ms)	801,309	222.02	80.15
msgs sent queued	56,531	15.66	5.65
msgs sent queued on ksxp	180,941	50.13	18.10
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	59,823	16.58	5.98
process batch messages sent	47,173	13.07	4.72

Statistic	Total
CR Block Requests	26,792
CURRENT Block Requests	3,239
Data Block Requests	26,792
Undo Block Requests	72
TX Block Requests	269
Current Results	28,219
Private results	4
Zero Results	1,807
Disk Read Results	0
Fail Results	0
Fairness Down Converts	13,350
Fairness Clears	1,047
Free GC Elements	0
Flushes	1,669
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	62
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	73	26.03	45.21	27.40	1.37	0.00
Flushes	1,264	36.08	6.09	26.74	31.09	0.00
Writes	6,400	17.34	41.77	25.06	15.30	0.53

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	23,296	96.67	2.84	0.49	31,338	96.13	2.80	1.08
2	Others	2,494	99.24	0.20	0.56	2,047	99.56	0.05	0.39
2	undo header	467	96.57	3.00	0.43	43	97.67	2.33	0.00
2	undo block	388	97.42	2.06	0.52	0

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	0.70	0.24	16.62	0.24	0.73	0.26	16.72	0.49
2	others	0.39	0.25	70.14	0.27	0.25	0.25	0.34	0.23
2	undo header	1.61	0.18	47.74	0.20	2.03	0.22	78.04
2	undo block	2.03	0.25	86.68	0.21

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

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	22,520	100.00	0.00	30,125	100.00	0.00
2	others	0	2,475	100.00	0.00	2,038	100.00	0.00
2	undo header	0	451	100.00	0.00	42	100.00	0.00
2	undo block	0	378	100.00	0.00	0

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.47	0.09
Parallel Query	0.00	0.00
DB Locks	0.02	0.03
DB Streams	0.00	0.00
Other	0.00	0.01

Name	Total	per Remaster Op	Begin Snap	End Snap
remaster ops	1	1.00
remastered objects	1	1.00
replayed locks received	0	0.00
replayed locks sent	24,412	24,412.00
resources cleaned	0	0.00
remaster time (s)	0.9	0.91
quiesce time (s)	0.1	0.09
freeze time (s)	0.0	0.01
cleanup time (s)	0.1	0.06
replay time (s)	0.0	0.04
fixwrite time (s)	0.0	0.01
sync time (s)	0.7	0.70
affinity objects			9	8