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: 9539 21-11?-13 09:00:01 216 1.7

End Snap: 9540 21-11?-13 09:42:59 240 1.9

Elapsed: 42.97 (mins)

DB Time: 509.99 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	9539	21-11?-13 09:00:01	216	1.7
End Snap:	9540	21-11?-13 09:42:59	240	1.9
Elapsed:		42.97 (mins)
DB Time:		509.99 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 11.9 3.8 0.11 0.04

DB CPU(s): 0.7 0.2 0.01 0.00

Redo size: 29,331.2 9,329.0

Logical reads: 35,949.5 11,434.0

Block changes: 269.5 85.7

Physical reads: 19,782.1 6,291.9

Physical writes: 108.3 34.5

User calls: 304.2 96.8

Parses: 67.3 21.4

Hard parses: 32.7 10.4

W/A MB processed: 1.3 0.4

Logons: 1.2 0.4

Executes: 105.2 33.4

Rollbacks: 0.0 0.0

Transactions: 3.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	11.9	3.8	0.11	0.04
DB CPU(s):	0.7	0.2	0.01	0.00
Redo size:	29,331.2	9,329.0
Logical reads:	35,949.5	11,434.0
Block changes:	269.5	85.7
Physical reads:	19,782.1	6,291.9
Physical writes:	108.3	34.5
User calls:	304.2	96.8
Parses:	67.3	21.4
Hard parses:	32.7	10.4
W/A MB processed:	1.3	0.4
Logons:	1.2	0.4
Executes:	105.2	33.4
Rollbacks:	0.0	0.0
Transactions:	3.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.90 Redo NoWait %: 99.96

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

Library Hit %: 66.11 Soft Parse %: 51.39

Execute to Parse %: 36.00 Latch Hit %: 99.61

Parse CPU to Parse Elapsd %: 95.61 % Non-Parse CPU: 89.22

Shared Pool Statistics

Begin End

Memory Usage %: 83.23 83.21

% SQL with executions>1: 86.62 85.58

% Memory for SQL w/exec>1: 83.58 81.85

	Begin	End
Memory Usage %:	83.23	83.21
% SQL with executions>1:	86.62	85.58
% Memory for SQL w/exec>1:	83.58	81.85

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
direct path read	266,988	14,590	55	47.68	User I/O
gc buffer busy acquire	21,017	3,917	186	12.80	Cluster
log file sync	12,296	3,571	290	11.67	Commit
DB CPU		1,664		5.44
read by other session	2,649	1,234	466	4.03	User I/O

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

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

2.44 6.80 2.5 0.5 11.5 96.9

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.44	6.80	2.5	0.5	11.5	96.9

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

2.6 83.6 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
2.6	83.6	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): 832.9 961.0

% Host Mem used for SGA+PGA: 44.53 45.33

	Begin	End
Host Mem (MB):	16,026.0	16,026.0
SGA use (MB):	6,304.0	6,304.0
PGA use (MB):	832.9	961.0
% Host Mem used for SGA+PGA:	44.53	45.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: 43.86 13.95

Global Cache blocks served: 62.06 19.74

GCS/GES messages received: 157.83 50.20

GCS/GES messages sent: 95.54 30.39

DBWR Fusion writes: 2.06 0.65

Estd Interconnect traffic (KB) 896.86

	Per Second	Per Transaction
Global Cache blocks received:	43.86	13.95
Global Cache blocks served:	62.06	19.74
GCS/GES messages received:	157.83	50.20
GCS/GES messages sent:	95.54	30.39
DBWR Fusion writes:	2.06	0.65
Estd Interconnect traffic (KB)	896.86

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

Buffer access - local cache %: 99.64

Buffer access - remote cache %: 0.27

Buffer access - disk %: 0.09

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 1.0

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

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

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

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

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

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

Global cache log flushes for current blocks served %: 1.2

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

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

Avg message received queue time (ms): 0.1

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 72.52

% of indirect sent messages: 27.39

% of flow controlled messages: 0.09

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): 30599.4s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	27,644.42	90.34
connection management call elapsed time	2,705.63	8.84
DB CPU	1,663.99	5.44
sequence load elapsed time	525.99	1.72
parse time elapsed	195.13	0.64
hard parse elapsed time	162.86	0.53
PL/SQL execution elapsed time	6.86	0.02
PL/SQL compilation elapsed time	1.70	0.01
hard parse (sharing criteria) elapsed time	0.63	0.00
hard parse (bind mismatch) elapsed time	0.55	0.00
repeated bind elapsed time	0.01	0.00
failed parse elapsed time	0.00	0.00
DB time	30,599.43
background elapsed time	3,904.70
background cpu time	38.69

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	203,571
IDLE_TIME	6,327,777
IOWAIT_TIME	752,932
NICE_TIME	52
SYS_TIME	32,052
USER_TIME	166,435
LOAD	2	7
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
21-11? 09:00:01	2.44
21-11? 09:42:59	6.80	3.12	2.55	0.49	96.88	11.53

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 96.8% of Total DB time 30,599.43 (s)
Total FG Wait Time: 27,962.04 (s) DB CPU time: 1,663.99 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	297,356	0	16,842	57	55.04
Cluster	118,308	0	6,172	52	20.17
Commit	12,296	0	3,571	290	11.67
DB CPU			1,664		5.44
System I/O	79,103	0	419	5	1.37
Other	14,963	58	338	23	1.11
Concurrency	16,079	0	312	19	1.02
Application	2,266	1	301	133	0.98
Configuration	50	34	5	94	0.02
Network	575,880	0	1	0	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	266,988	0	14,590	55	32.94	47.68
gc buffer busy acquire	21,017	0	3,917	186	2.59	12.80
log file sync	12,296	0	3,571	290	1.52	11.67
read by other session	2,649	0	1,234	466	0.33	4.03
gc current block busy	2,057	0	782	380	0.25	2.55
gc cr block busy	1,557	0	685	440	0.19	2.24
gc buffer busy release	966	0	577	597	0.12	1.89
db file sequential read	5,134	0	538	105	0.63	1.76
control file sequential read	79,103	0	419	5	9.76	1.37
reliable message	2,490	9	336	135	0.31	1.10
enq: KO - fast object checkpoint	2,048	0	301	147	0.25	0.98
direct path write temp	7,630	0	297	39	0.94	0.97
row cache lock	5,106	0	282	55	0.63	0.92
gc cr multi block request	11,729	0	193	16	1.45	0.63
db file scattered read	2,068	0	99	48	0.26	0.32
db file parallel read	949	0	54	56	0.12	0.18
direct path read temp	4,040	0	27	7	0.50	0.09
buffer busy waits	1,088	0	17	15	0.13	0.05
gc current block 2-way	50,159	0	12	0	6.19	0.04
library cache: mutex X	1,850	0	7	4	0.23	0.02
gc cr block 2-way	19,257	0	5	0	2.38	0.02
latch: shared pool	715	0	4	5	0.09	0.01
undo segment extension	17	100	4	230	0.00	0.01
enq: TX - index contention	32	0	2	67	0.00	0.01
direct path write	3	0	2	647	0.00	0.01
gc current grant busy	7,974	0	2	0	0.98	0.01
Disk file operations I/O	7,895	0	1	0	0.97	0.00
enq: CF - contention	2	0	1	696	0.00	0.00
log file switch completion	1	0	1	788	0.00	0.00
latch: cache buffers chains	4,943	0	1	0	0.61	0.00
SQL*Net message to client	565,845	0	0	0	69.81	0.00
enq: TX - row lock contention	6	0	0	46	0.00	0.00
ASM file metadata operation	4	0	0	67	0.00	0.00
gc current grant 2-way	1,965	0	0	0	0.24	0.00
library cache pin	1,376	0	0	0	0.17	0.00
SQL*Net more data to client	8,611	0	0	0	1.06	0.00
library cache lock	964	1	0	0	0.12	0.00
gc cr grant 2-way	1,247	0	0	0	0.15	0.00
gcs drm freeze in enter server mode	1	0	0	168	0.00	0.00
PX Deq: Slave Session Stats	972	0	0	0	0.12	0.00
ADR block file read	29	0	0	5	0.00	0.00
latch: object queue header operation	1	0	0	129	0.00	0.00
enq: PS - contention	359	7	0	0	0.04	0.00
gc current block congested	242	0	0	0	0.03	0.00
PX Deq: reap credit	7,745	100	0	0	0.96	0.00
IPC send completion sync	381	0	0	0	0.05	0.00
ADR block file write	5	0	0	7	0.00	0.00
gc cr block congested	108	0	0	0	0.01	0.00
rdbms ipc reply	681	0	0	0	0.08	0.00
PX Deq: Signal ACK RSG	634	0	0	0	0.08	0.00
os thread startup	1	0	0	23	0.00	0.00
enq: HW - contention	32	0	0	1	0.00	0.00
SQL*Net more data from client	1,424	0	0	0	0.18	0.00
SQL*Net break/reset to client	198	0	0	0	0.02	0.00
CSS initialization	2	0	0	5	0.00	0.00
cursor: pin S wait on X	1	0	0	10	0.00	0.00
PX Deq: Signal ACK EXT	634	0	0	0	0.08	0.00
DFS lock handle	19	11	0	0	0.00	0.00
enq: TT - contention	21	0	0	0	0.00	0.00
latch: gc element	192	0	0	0	0.02	0.00
CSS operation: action	2	0	0	2	0.00	0.00
gc current multi block request	10	0	0	0	0.00	0.00
enq: UL - contention	14	100	0	0	0.00	0.00
enq: FB - contention	7	0	0	0	0.00	0.00
gc current retry	8	0	0	0	0.00	0.00
enq: WF - contention	8	0	0	0	0.00	0.00
enq: JQ - contention	3	100	0	0	0.00	0.00
CSS operation: query	6	0	0	0	0.00	0.00
buffer deadlock	25	100	0	0	0.00	0.00
SQL*Net message from client	565,873	0	1,367,264	2416	69.81
wait for unread message on broadcast channel	2,720	98	2,683	986	0.34
Streams AQ: waiting for messages in the queue	546	92	2,643	4841	0.07
jobq slave wait	2,149	100	1,076	501	0.27
PX Deq: Execute Reply	634	0	7	12	0.08
PX Deq: Execution Msg	1,352	0	4	3	0.17
PX Deq: Parse Reply	634	0	1	1	0.08
PX Deq: Join ACK	634	0	0	1	0.08
PX Deq Credit: send blkd	36	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	12,604	0	1,219	97	1.55	31.23
gcs log flush sync	107,264	70	875	8	13.23	22.40
control file sequential read	7,712	0	802	104	0.95	20.55
db file parallel write	9,195	0	583	63	1.13	14.92
control file parallel write	1,180	0	127	107	0.15	3.24
Streams AQ: qmn coordinator waiting for slave to start	6	100	31	5120	0.00	0.79
log file sequential read	74	0	10	131	0.01	0.25
reliable message	240	3	7	31	0.03	0.19
gc cr block busy	23	0	6	245	0.00	0.14
ASM file metadata operation	913	0	3	3	0.11	0.08
db file sequential read	56	0	3	47	0.01	0.07
enq: CF - contention	73	88	2	23	0.01	0.04
os thread startup	54	0	1	19	0.01	0.03
kfk: async disk IO	3	0	1	182	0.00	0.01
SQL*Net more data from client	2,126	0	1	0	0.26	0.01
gc current block busy	6	0	0	81	0.00	0.01
latch free	55	0	0	7	0.01	0.01
row cache lock	2,255	0	0	0	0.28	0.01
latch: shared pool	15	0	0	24	0.00	0.01
row cache process	54,676	0	0	0	6.75	0.01
log file single write	4	0	0	59	0.00	0.01
enq: KO - fast object checkpoint	1,338	0	0	0	0.17	0.01
log file sync	2	0	0	110	0.00	0.01
ges inquiry response	833	0	0	0	0.10	0.00
ksxr poll remote instances	23,516	100	0	0	2.90	0.00
direct path write	3	0	0	50	0.00	0.00
CSS operation: data query	132	0	0	1	0.02	0.00
ges LMON to get to FTDONE	11	45	0	13	0.00	0.00
gc current block 2-way	709	0	0	0	0.09	0.00
CGS wait for IPC msg	18,731	100	0	0	2.31	0.00
ges lms sync during dynamic remastering and reconfig	24	0	0	6	0.00	0.00
gc cr block 2-way	583	0	0	0	0.07	0.00
latch: redo allocation	1	0	0	99	0.00	0.00
row cache cleanup	36,837	0	0	0	4.54	0.00
latch: redo writing	1	0	0	87	0.00	0.00
ges generic event	8	88	0	10	0.00	0.00
enq: TX - index contention	1	0	0	75	0.00	0.00
gc cr multi block request	52	0	0	1	0.01	0.00
gc current grant busy	275	0	0	0	0.03	0.00
library cache lock	219	0	0	0	0.03	0.00
library cache pin	240	0	0	0	0.03	0.00
latch: call allocation	214	0	0	0	0.03	0.00
CSS group membership query	44	0	0	1	0.01	0.00
asynch descriptor resize	2,693	100	0	0	0.33	0.00
SQL*Net more data to client	2,126	0	0	0	0.26	0.00
DFS lock handle	119	83	0	0	0.01	0.00
libcache interrupt action by LCK	27,252	0	0	0	3.36	0.00
Log archive I/O	1	0	0	13	0.00	0.00
PX Deq: reap credit	1,873	100	0	0	0.23	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	9	0	0	1	0.00	0.00
latch: cache buffers chains	51	0	0	0	0.01	0.00
gc current grant 2-way	38	0	0	0	0.00	0.00
rdbms ipc reply	129	0	0	0	0.02	0.00
enq: PS - contention	11	9	0	0	0.00	0.00
LGWR wait for redo copy	103	0	0	0	0.01	0.00
SQL*Net message to client	7,825	0	0	0	0.97	0.00
Disk file operations I/O	73	0	0	0	0.01	0.00
db file async I/O submit	4,961	0	0	0	0.61	0.00
enq: TT - contention	20	20	0	0	0.00	0.00
enq: US - contention	24	0	0	0	0.00	0.00
enq: WF - contention	13	0	0	0	0.00	0.00
gc current multi block request	10	0	0	0	0.00	0.00
PX Deq: Slave Session Stats	15	0	0	0	0.00	0.00
enq: TQ - TM contention	10	0	0	0	0.00	0.00
enq: HW - contention	9	22	0	0	0.00	0.00
enq: TA - contention	7	0	0	0	0.00	0.00
CSS operation: action	4	0	0	0	0.00	0.00
enq: CR - block range reuse ckpt	8	0	0	0	0.00	0.00
gc cr grant 2-way	10	0	0	0	0.00	0.00
rdbms ipc message	99,917	39	64,987	650	12.33
class slave wait	418	0	7,573	18116	0.05
wait for unread message on broadcast channel	5,367	90	5,365	1000	0.66
DIAG idle wait	66,819	69	5,355	80	8.24
gcs remote message	526,640	74	4,476	8	64.97
Space Manager: slave idle wait	813	97	4,007	4929	0.10
Streams AQ: qmn slave idle wait	119	6	3,097	26023	0.01
dispatcher timer	45	100	2,700	60001	0.01
pmon timer	904	98	2,684	2969	0.11
ASM background timer	572	0	2,682	4689	0.07
PING	1,025	21	2,682	2616	0.13
ges remote message	48,160	48	2,681	56	5.94
GCR sleep	538	100	2,681	4982	0.07
Streams AQ: qmn coordinator idle wait	187	48	2,675	14305	0.02
PX Idle Wait	338	0	2,674	7912	0.04
shared server idle wait	89	100	2,670	30003	0.01
Streams AQ: waiting for time management or cleanup tasks	284	90	2,668	9395	0.04
smon timer	23	22	2,544	110602	0.00
SQL*Net message from client	10,447	0	60	6	1.29
KSV master wait	1,771	93	3	2	0.22
heartbeat monitor sleep	28	0	0	1	0.00
PX Deq: Join ACK	15	0	0	1	0.00
PX Deq: Parse Reply	15	0	0	0	0.00
PX Deq: Execute Reply	15	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	29	31.0		3.4	48.3	17.2
ADR block file write	5				80.0	20.0
ADR file lock	6	100.0
ARCH wait for archivelog lock	1	100.0
ASM file metadata operation	934	98.1		.1		.1	.7	.9	.1
CGS wait for IPC msg	18.8K	100.0
CSS group membership query	45	95.6	4.4
CSS initialization	4	50.0			25.0	25.0
CSS operation: action	8	50.0		50.0
CSS operation: data query	135	11.9	88.1
CSS operation: query	57	96.5	3.5
DFS lock handle	138	100.0
Disk file operations I/O	8121	99.9				.0	.0	.0
IPC send completion sync	395	100.0
KJC: Wait for msg sends to complete	32	100.0
LGWR wait for redo copy	103	100.0
Log archive I/O	1					100.0
PX Deq: Signal ACK EXT	657	100.0
PX Deq: Signal ACK RSG	657	100.0
PX Deq: Slave Session Stats	999	99.7	.2	.1
PX Deq: reap credit	9738	100.0
SQL*Net break/reset to client	202	99.5	.5
SQL*Net message to client	583.4K	100.0
SQL*Net more data from client	3614	97.3	2.1	.5	.1
SQL*Net more data to client	11K	100.0						.0
Streams AQ: qmn coordinator waiting for slave to start	6								100.0
asynch descriptor resize	3437	100.0
buffer busy waits	1134	81.1	8.8	4.1		.3	.2	5.6
buffer deadlock	25	100.0
control file parallel write	1198	41.4	1.7	2.5	2.3	2.9	4.5	44.6	.2
control file sequential read	86.9K	90.9	1.0	.8	.6	.4	.6	5.6	.1
cursor: pin S	3	100.0
cursor: pin S wait on X	1					100.0
db file async I/O submit	5003	100.0
db file parallel read	958	21.2	12.8	8.7	11.2	20.9	7.9	17.1	.2
db file parallel write	9320	51.8	4.1	4.1	5.9	3.5	2.9	27.5	.2
db file scattered read	2099	44.5	11.4	6.7	11.8	7.1	2.0	16.2	.1
db file sequential read	5357	15.1	1.0	3.3	17.4	9.6	5.9	47.5	.2
direct path read	272.2K	11.6	7.2	13.2	21.5	21.1	5.7	19.4	.3
direct path read temp	4040	31.3	23.2	4.9	15.3	20.6	2.0	2.6
direct path write	8		12.5			12.5		75.0
direct path write temp	7517	5.4	13.2	49.0	4.2	4.5	3.3	20.3	.1
enq: AE - lock	2	100.0
enq: AF - task serialization	1	100.0
enq: CF - contention	77	94.8						1.3	3.9
enq: CR - block range reuse ckpt	8	100.0
enq: DR - contention	2	100.0
enq: FB - contention	11	100.0
enq: HW - contention	38	89.5	10.5
enq: JQ - contention	3	100.0
enq: JS - job run lock - synchronize	1	100.0
enq: KO - fast object checkpoint	3453	83.7	1.1	.4	.4	.7	.7	10.5	2.5
enq: PS - contention	374	99.2	.3	.5
enq: TA - contention	7	100.0
enq: TD - KTF dump entries	5	100.0
enq: TM - contention	4	100.0
enq: TQ - TM contention	12	100.0
enq: TT - contention	42	100.0
enq: TX - index contention	33	57.6		3.0	6.1		6.1	27.3
enq: TX - row lock contention	6					16.7	33.3	50.0
enq: UL - contention	14	100.0
enq: US - contention	24	100.0
enq: WF - contention	21	100.0
enq: WL - contention	1	100.0
gc buffer busy acquire	23.1K	44.8	3.8	.5	.7	1.4	1.1	47.0	.5
gc buffer busy release	1014	1.2	.3	1.0	1.0	1.0	1.8	84.2	9.6
gc cr block 2-way	20.1K	99.9	.1	.0	.0	.0		.0
gc cr block busy	1608	2.9	.6	1.2	1.3	1.6	2.4	83.1	7.0
gc cr block congested	112	100.0
gc cr grant 2-way	1289	99.6			.1	.3
gc cr grant congested	5	100.0
gc cr multi block request	11.9K	91.2	2.2	.3	.3	.3	.2	5.5	.1
gc current block 2-way	51.1K	99.9	.0	.0
gc current block busy	2126	1.7	1.2	1.6	2.6	5.6	3.6	78.5	5.2
gc current block congested	247	100.0
gc current grant 2-way	2014	99.9	.0		.0
gc current grant busy	8294	99.8	.0	.0	.0	.1		.0
gc current grant congested	6	100.0
gc current multi block request	14	100.0
gc current retry	8	100.0
gc current split	3	100.0
gcs drm freeze in enter server mode	1							100.0
gcs log flush sync	113.8K	14.0	4.0	4.4	5.8	71.9	.0
ges LMON to get to FTDONE	11			9.1	36.4	9.1	45.5
ges generic event	8	12.5				87.5
ges inquiry response	849	98.8	.7	.4	.1
ges lms sync during dynamic remastering and reconfig	24		8.3	29.2	41.7	20.8
kfk: async disk IO	3							100.0
kjbdrmcvtq lmon drm quiesce: ping completion	9	66.7	11.1	22.2
ksxr poll remote instances	23.9K	100.0
latch free	61	13.1			59.0	27.9
latch: active service list	1	100.0
latch: cache buffers chains	5685	99.2	.5	.3
latch: call allocation	221	98.2	.9	.9
latch: checkpoint queue latch	1	100.0
latch: gc element	219	100.0
latch: gcs resource hash	3	100.0
latch: ges resource hash list	12	100.0
latch: object queue header operation	2	50.0						50.0
latch: redo allocation	1							100.0
latch: redo writing	1							100.0
latch: shared pool	739	96.3	.4	.1			.4	2.7
libcache interrupt action by LCK	27.6K	100.0
library cache lock	1232	99.4	.2	.3
library cache pin	1715	99.7	.3	.1
library cache: mutex X	1933	75.9	.2			22.4	.9	.6
lock escalate retry	5	100.0
log file parallel write	12.7K	38.9	2.3	2.7	3.0	3.9	4.2	44.7	.2
log file sequential read	74	4.1		6.8	5.4	5.4	20.3	58.1
log file single write	4				25.0	25.0		50.0
log file switch completion	1							100.0
log file sync	12.5K	20.1	1.4	1.5	2.8	3.6	3.7	59.4	7.4
os thread startup	57					19.3	80.7
rdbms ipc reply	807	100.0
read by other session	3329	1.1	.1	.5	.9	.9	3.2	91.2	2.2
reliable message	2792	65.4	15.0	.5	.1	.2	.1	18.6
row cache cleanup	37.4K	100.0		.0
row cache lock	7479	95.2	.4	.1		.1	.1	2.9	1.3
row cache process	55.5K	100.0
undo segment extension	17	11.8				11.8	11.8	64.7
ASM background timer	581	2.8	.2			.2	.5	1.5	94.8
DIAG idle wait	68.1K	9.9	.7	.2	.1	16.0	26.7	46.4
GCR sleep	547	.4							99.6
KSV master wait	1812	99.4		.1		.1		.4	.1
PING	1043	79.3							20.7
PX Deq Credit: send blkd	36	100.0
PX Deq: Execute Reply	657	88.6	2.3	4.9	.2	.6	2.1	.9	.5
PX Deq: Execution Msg	1368	93.9	5.2	.3	.1	.1		.4	.1
PX Deq: Join ACK	657	98.8	1.2
PX Deq: Msg Fragment	36	100.0
PX Deq: Parse Reply	657	94.8	4.0	.3	.3	.2		.5
PX Idle Wait	342	37.1	28.7	9.6	1.8	3.2	.9	4.7	14.0
SQL*Net message from client	586.1K	82.8	9.7	2.1	1.8	.6	.3	1.0	1.7
Space Manager: slave idle wait	840						.4	.4	99.3
Streams AQ: RAC qmn coordinator idle wait	192	100.0
Streams AQ: qmn coordinator idle wait	189	49.7							50.3
Streams AQ: qmn slave idle wait	119								100.0
Streams AQ: waiting for messages in the queue	555						.2	1.4	98.4
Streams AQ: waiting for time management or cleanup tasks	290	10.0						48.3	41.7
class slave wait	425	34.6	1.2	4.2	1.9	1.6	1.2	12.2	43.1
dispatcher timer	45								100.0
gcs remote message	531.2K	11.4	3.7	4.0	4.8	76.1	.0
ges remote message	49.1K	32.9	2.8	2.3	1.6	1.8	2.7	55.9
heartbeat monitor sleep	28	35.7	64.3
jobq slave wait	2217							100.0
pmon timer	918	.2						.5	99.2
rdbms ipc message	100.8K	33.4	2.3	1.9	1.9	1.7	1.6	43.1	14.1
shared server idle wait	90								100.0
smon timer	20						5.0		95.0
wait for unread message on broadcast channel	8221	.3			.0	.1	.1	99.5

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
ASM file metadata operation	9	99.0		.3	.2	.2	.1	.1
Disk file operations I/O	2	100.0			.0	.0
SQL*Net more data to client	1	100.0		.0
buffer busy waits	63	94.4	.3	1.2	1.7	2.1	.3
control file parallel write	536	55.3	7.3	13.4	8.3	9.2	6.4	.2
control file sequential read	4938	94.3	.9	1.6	1.2	1.2	.8	.1	.0
db file parallel read	166	82.7	2.3	4.4	2.6	3.3	4.5	.2
db file parallel write	2585	72.3	5.5	7.8	6.0	5.1	3.2	.2
db file scattered read	344	83.6	1.6	4.2	3.0	4.2	3.2	.1
db file sequential read	2555	52.3	6.9	15.2	11.3	8.4	5.7	.2
direct path read	53.5K	80.3	3.5	5.2	4.6	3.6	2.5	.3	.0
direct path read temp	107	97.4	.6	2.0	.0
direct path write	6	25.0	25.0	12.5		12.5	25.0
direct path write temp	1529	79.7	3.7	6.6	5.2	3.4	1.4	.1
enq: CF - contention	3	94.8					1.3	2.6	1.3
enq: KO - fast object checkpoint	417	87.1	.8	2.0	2.1	2.5	3.1	1.6	.9
enq: TX - index contention	9	72.7	3.0	6.1	12.1	3.0	3.0
enq: TX - row lock contention	3	50.0	33.3	16.7
gc buffer busy acquire	11K	52.5	2.5	4.9	10.0	16.4	13.2	.5	.0
gc buffer busy release	950	6.2	5.3	8.1	10.7	17.7	42.4	9.5	.1
gc cr block 2-way	1	100.0		.0
gc cr block busy	1445	9.9	5.2	9.3	16.0	25.6	27.0	6.7	.2
gc cr multi block request	657	94.4	.5	.7	1.6	2.2	.5	.0	.0
gc current block busy	1777	16.3	4.7	10.3	15.6	25.6	22.3	5.1	.1
gc current grant busy	1	100.0			.0
gcs drm freeze in enter server mode	1				100.0
kfk: async disk IO	3			33.3	66.7
latch: object queue header operation	1	50.0		50.0
latch: redo allocation	1			100.0
latch: redo writing	1			100.0
latch: shared pool	20	97.3	.5	.9	.4	.7	.1
library cache: mutex X	12	99.4	.1	.2	.3	.1
log file parallel write	5689	55.1	7.3	14.6	11.3	7.5	3.9	.2
log file sequential read	43	41.9	10.8	8.1	24.3	12.2	2.7
log file single write	2	50.0		50.0
log file switch completion	1						100.0
log file sync	8305	33.1	6.7	11.7	12.6	14.3	14.0	7.2	.2
read by other session	3108	6.6	2.3	4.6	9.1	34.7	40.5	2.2
reliable message	520	81.4	.4	1.0	1.7	2.8	12.7
row cache lock	280	95.7	.1	.3	.7	.9	.9	.8	.5
undo segment extension	11	35.3	11.8	11.8	11.8	11.8	17.6

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
control file sequential read	1	100.0	.0
direct path read	86	100.0	.0	.0
enq: CF - contention	1	98.7	1.3
enq: KO - fast object checkpoint	30	99.1	.6	.2
gc buffer busy acquire	10	100.0	.0	.0
gc buffer busy release	1	99.9	.1
gc cr block busy	4	99.8	.1	.1
gc cr multi block request	1	100.0	.0
gc current block busy	2	99.9		.1
log file sync	28	99.8	.2
row cache lock	38	99.5	.5

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	27,312	1,582	50,399	91,837
SYS$USERS	1,142	54	410	377
SYS$BACKGROUND	0	0	0	104
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	283471	16244	12658	310	572526	1
SYS$USERS	13810	579	3305	1	3071	0
SYS$BACKGROUND	133	3	30258	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 44.7% of Total DB Time (s): 30,599
Captured PL/SQL account for 2.3% of Total DB Time (s): 30,599

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,984.73	8	248.09	6.49	0.31	33.62	9zynd5rbnpr02	w3wp.exe	select PolicyID, FromCity, ToC...
1,232.67	6	205.45	4.03	0.43	30.03	39cn676x1wsdp	w3wp.exe	select PolicyID, FromCity, ToC...
997.63	2,730	0.37	3.26	0.49	0.23	4vs91dcv7u1p6	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
957.19	2,699	0.35	3.13	0.21	0.08	f711myt0q6cma	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
664.23	3	221.41	2.17	0.25	32.80	7agy84jm4njfy	w3wp.exe	select POLICYID, AIRCOM, CABIN...
552.14	2,455	0.22	1.80	0.38	0.00	9rkx7dk6m8959	w3wp.exe	SELECT TBICS_OPERATE_LOG_SQN.N...
497.80	8	62.23	1.63	1.30	28.68	dqdyqmq1g00as	w3wp.exe	select POLICYID, AIRCOM, CABIN...
463.25	3	154.42	1.51	0.31	36.55	0ysnwzqnurd79	w3wp.exe	select POLICYID, AIRCOM, CABIN...
416.75	0		1.36	1.48	13.25	bc7gjv3ppdtbz	sqlplus@rac0101.tempus.cn (TNS V1-V3)	BEGIN dbms_workload_repository...
407.87	9	45.32	1.33	8.98	90.98	ct78468spkzrt		select count(*) from v$lock
354.28	2	177.14	1.16	0.32	36.08	f4r6ndbr8fzmu	w3wp.exe	select POLICYID, AIRCOM, CABIN...
351.91	3	117.30	1.15	0.45	32.57	9a1unjt3njs9m	w3wp.exe	select PolicyID, FromCity, ToC...
350.56	2	175.28	1.15	0.30	34.87	2qz2wt9txf2vc	w3wp.exe	select POLICYID, AIRCOM, CABIN...
348.17	2	174.09	1.14	0.27	33.56	axfds3xc99mpp	w3wp.exe	select POLICYID, AIRCOM, CABIN...

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
36.65	9	4.07	2.20	407.87	8.98	90.98	ct78468spkzrt		select count(*) from v$lock
29.71	6	4.95	1.79	272.78	10.89	83.42	0wxxrmxbwt2h4	w3wp.exe	select * from ics_order where ...
20.75	5	4.15	1.25	74.56	27.84	60.37	dw94kutvhh845	w3wp.exe	select * from ics_order where ...
18.46	4	4.61	1.11	117.45	15.71	84.10	54h3gvyvk4fkf	w3wp.exe	select * from ics_order where ...
18.33	4	4.58	1.10	109.41	16.75	78.08	3pwsz56qj4u4g	w3wp.exe	select * from ics_order where ...
16.37	236	0.07	0.98	20.24	80.87	0.00	5nwqnvv6tn881	w3wp.exe	select count(*) from ics_order...
7.62	4	1.91	0.46	202.05	3.77	92.52	0ftwm12w0nfx5	w3wp.exe	select orderId, orderfrom, ORD...
6.92	2	3.46	0.42	15.19	45.57	52.83	d1sfptpna4jrz	w3wp.exe	select * from ics_order where ...
6.46	8	0.81	0.39	497.80	1.30	28.68	dqdyqmq1g00as	w3wp.exe	select POLICYID, AIRCOM, CABIN...
6.43	541	0.01	0.39	40.86	15.73	0.02	f5tz11uhm37fs	w3wp.exe	select * from (select /*+ FIRS...

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 31.5% of Total User I/O Wait Time (s): 16,845
Captured PL/SQL account for 1.9% of Total User I/O Wait Time (s): 16,845

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
667.25	8	83.41	3.96	1,984.73	0.31	33.62	9zynd5rbnpr02	w3wp.exe	select PolicyID, FromCity, ToC...
371.07	9	41.23	2.20	407.87	8.98	90.98	ct78468spkzrt		select count(*) from v$lock
370.16	6	61.69	2.20	1,232.67	0.43	30.03	39cn676x1wsdp	w3wp.exe	select PolicyID, FromCity, ToC...
267.74	1	267.74	1.59	286.61	1.85	93.42	5dnh6xvw13j8p	w3wp.exe	begin pr_ImportHisData(intorde...
227.54	6	37.92	1.35	272.78	10.89	83.42	0wxxrmxbwt2h4	w3wp.exe	select * from ics_order where ...
217.84	3	72.61	1.29	664.23	0.25	32.80	7agy84jm4njfy	w3wp.exe	select POLICYID, AIRCOM, CABIN...
193.92	1	193.92	1.15	200.34	2.53	96.79	3vvhvgdrwxnmh	w3wp.exe	select * from ics_order where ...
186.93	4	46.73	1.11	202.05	3.77	92.52	0ftwm12w0nfx5	w3wp.exe	select orderId, orderfrom, ORD...
169.30	3	56.43	1.01	463.25	0.31	36.55	0ysnwzqnurd79	w3wp.exe	select POLICYID, AIRCOM, CABIN...
166.21	3	55.40	0.99	178.20	3.54	93.27	gzauf0b286tn3	w3wp.exe	select orderId, orderfrom, ORD...

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: 92,684,016
Captured SQL account for 16.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
5,156,528	236	21,849.69	5.56	20.24	80.9	0	5nwqnvv6tn881	w3wp.exe	select count(*) from ics_order...
596,443	5	119,288.60	0.64	92.82	6.8	87.3	c1u68tgz8y5px	w3wp.exe	SELECT COUNT(*) FROM ICS_FANDI...
520,578	6	86,763.00	0.56	272.78	10.9	83.4	0wxxrmxbwt2h4	w3wp.exe	select * from ics_order where ...
520,376	6	86,729.33	0.56	135.11	3.8	87.2	3y709bqj5x87v	w3wp.exe	select OrderId from ICS_Order ...
466,495	1	466,495.00	0.50	286.61	1.9	93.4	5dnh6xvw13j8p	w3wp.exe	begin pr_ImportHisData(intorde...
443,881	8	55,485.13	0.48	497.80	1.3	28.7	dqdyqmq1g00as	w3wp.exe	select POLICYID, AIRCOM, CABIN...
433,640	5	86,728.00	0.47	109.91	4.5	94	3bd3k79zy2w3p	w3wp.exe	SELECT COUNT(*) FROM TBICS_PAS...
433,639	5	86,727.80	0.47	74.56	27.8	60.4	dw94kutvhh845	w3wp.exe	select * from ics_order where ...
433,636	5	86,727.20	0.47	104.22	4.8	90.8	8ggqyrz3b3hu3	w3wp.exe	SELECT COUNT(*) FROM ICS_ORDER...
396,376	8	49,547.00	0.43	1,984.73	.3	33.6	9zynd5rbnpr02	w3wp.exe	select PolicyID, FromCity, ToC...

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: 51,001,722
Captured SQL account for 13.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
520,182	6	86,697.00	1.02	272.78	10.89	83.42	0wxxrmxbwt2h4	w3wp.exe	select * from ics_order where ...
520,182	6	86,697.00	1.02	135.11	3.78	87.19	3y709bqj5x87v	w3wp.exe	select OrderId from ICS_Order ...
433,486	5	86,697.20	0.85	109.91	4.53	94.02	3bd3k79zy2w3p	w3wp.exe	SELECT COUNT(*) FROM TBICS_PAS...
433,486	1	433,486.00	0.85	286.61	1.85	93.42	5dnh6xvw13j8p	w3wp.exe	begin pr_ImportHisData(intorde...
433,485	5	86,697.00	0.85	104.22	4.82	90.76	8ggqyrz3b3hu3	w3wp.exe	SELECT COUNT(*) FROM ICS_ORDER...
433,485	5	86,697.00	0.85	92.82	6.79	87.27	c1u68tgz8y5px	w3wp.exe	SELECT COUNT(*) FROM ICS_FANDI...
433,485	5	86,697.00	0.85	74.56	27.84	60.37	dw94kutvhh845	w3wp.exe	select * from ics_order where ...
346,788	4	86,697.00	0.68	109.41	16.75	78.08	3pwsz56qj4u4g	w3wp.exe	select * from ics_order where ...
346,788	4	86,697.00	0.68	117.45	15.71	84.10	54h3gvyvk4fkf	w3wp.exe	select * from ics_order where ...
346,788	4	86,697.00	0.68	134.86	2.18	92.84	c5422ddu64q8p	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: 424,039
Captured SQL account for 28.5% of Total
Total UnOptimized Read Requests: 424,039
Captured SQL account for 28.5% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
77,719	77,719	0		18.33	bc7gjv3ppdtbz	sqlplus@rac0101.tempus.cn (TNS V1-V3)	BEGIN dbms_workload_repository...
77,484	77,484	1	77,484.00	18.27	1cd2krbdzrhvq		insert into wrh$_tempstatxs (s...
4,040	4,040	9	448.89	0.95	ct78468spkzrt		select count(*) from v$lock
3,401	3,401	5	680.20	0.80	3bd3k79zy2w3p	w3wp.exe	SELECT COUNT(*) FROM TBICS_PAS...
3,401	3,401	1	3,401.00	0.80	5dnh6xvw13j8p	w3wp.exe	begin pr_ImportHisData(intorde...
3,400	3,400	5	680.00	0.80	8ggqyrz3b3hu3	w3wp.exe	SELECT COUNT(*) FROM ICS_ORDER...
3,400	3,400	5	680.00	0.80	c1u68tgz8y5px	w3wp.exe	SELECT COUNT(*) FROM ICS_FANDI...
3,400	3,400	5	680.00	0.80	dw94kutvhh845	w3wp.exe	select * from ics_order where ...
2,720	2,720	4	680.00	0.64	c5422ddu64q8p	w3wp.exe	select count(*) from ics_order...
2,040	2,040	3	680.00	0.48	0xgd8tharbz8k	w3wp.exe	select orderId, orderfrom, FLI...

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: 271,088
Captured SQL account for 19.6% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,431	1,627	0.25	1.34	87.8	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
5,543	54,244	9.79	112.85	1.7	.1	94h2a7cs7a7fc	AutoTicket.exe	select * from ICS_AutoTicketTa...
2,750	6,451	2.35	1.24	98.3	0	0k8522rmdzg4k		select privilege# from sysauth...
2,734	2,734	1.00	0.92	96.1	0	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2,734	2,733	1.00	0.80	95.7	0	459f3z9u4fb3u		select value$ from props$ wher...
2,730	2,730	1.00	997.63	.5	.2	4vs91dcv7u1p6	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
2,724	2,730	1.00	1.38	100.5	0	5ur69atw3vfhj		select decode(failover_method,...
2,705	2,705	1.00	24.37	3.7	0	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
2,699	2,699	1.00	957.19	.2	.1	f711myt0q6cma	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
2,455	2,454	1.00	552.14	.4	0	9rkx7dk6m8959	w3wp.exe	SELECT TBICS_OPERATE_LOG_SQN.N...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 173,487
Captured SQL account for 17.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,750	2,750	1.59	0k8522rmdzg4k		select privilege# from sysauth...
2,750	6,431	1.59	cm5vu20fhtnq1		select /*+ connect_by_filterin...
2,734	2,734	1.58	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2,734	2,734	1.58	459f3z9u4fb3u		select value$ from props$ wher...
2,730	2,730	1.57	4vs91dcv7u1p6	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
2,730	2,724	1.57	5ur69atw3vfhj		select decode(failover_method,...
2,699	2,699	1.56	f711myt0q6cma	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
1,018	2,705	0.59	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
990	2,455	0.57	9rkx7dk6m8959	w3wp.exe	SELECT TBICS_OPERATE_LOG_SQN.N...
725	1,410	0.42	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,842,726	40	0.05	2tkw12w5k68vd		select user#, password, datats...
1,065,705	5	0.03	21wx30xh4utxg	w3wp.exe	select * from (select replace(...
1,065,681	16	0.03	4ddw5un28xmt9	w3wp.exe	select * from (select replace(...

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): 6,179
Captured SQL account for 117.5% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,303.51	8	21.10	1,984.73	65.68	0.31	33.62	9zynd5rbnpr02	w3wp.exe	select PolicyID, FromCity, ToC...
980.63	2,730	15.87	997.63	98.30	0.49	0.23	4vs91dcv7u1p6	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
948.85	2,699	15.36	957.19	99.13	0.21	0.08	f711myt0q6cma	CollectingOtherOrder.exe	insert into sys.aud$( sessioni...
857.49	6	13.88	1,232.67	69.56	0.43	30.03	39cn676x1wsdp	w3wp.exe	select PolicyID, FromCity, ToC...
444.68	3	7.20	664.23	66.95	0.25	32.80	7agy84jm4njfy	w3wp.exe	select POLICYID, AIRCOM, CABIN...
348.82	8	5.65	497.80	70.07	1.30	28.68	dqdyqmq1g00as	w3wp.exe	select POLICYID, AIRCOM, CABIN...
292.45	3	4.73	463.25	63.13	0.31	36.55	0ysnwzqnurd79	w3wp.exe	select POLICYID, AIRCOM, CABIN...
235.64	3	3.81	351.91	66.96	0.45	32.57	9a1unjt3njs9m	w3wp.exe	select PolicyID, FromCity, ToC...
230.35	2	3.73	348.17	66.16	0.27	33.56	axfds3xc99mpp	w3wp.exe	select POLICYID, AIRCOM, CABIN...
227.22	2	3.68	350.56	64.82	0.30	34.87	2qz2wt9txf2vc	w3wp.exe	select POLICYID, AIRCOM, CABIN...
225.74	1,118	3.65	226.10	99.84	0.19	0.01	axmdf8vq7k1rh		select increment$, minvalue, m...
225.32	2	3.65	354.28	63.60	0.32	36.08	f4r6ndbr8fzmu	w3wp.exe	select POLICYID, AIRCOM, CABIN...
220.01	2,455	3.56	552.14	39.85	0.38	0.00	9rkx7dk6m8959	w3wp.exe	SELECT TBICS_OPERATE_LOG_SQN.N...
183.67	2	2.97	285.96	64.23	0.40	35.36	fc9x73fttz38u	w3wp.exe	select PolicyID, FromCity, ToC...
154.91	2	2.51	247.81	62.51	0.37	37.11	1vzp1yq17vt4r	w3wp.exe	select POLICYID, AIRCOM, CABIN...
112.89	5,543	1.83	112.85	100.03	1.66	0.07	94h2a7cs7a7fc	AutoTicket.exe	select * from ICS_AutoTicketTa...
108.99	2	1.76	174.41	62.49	0.53	36.98	03px98fk0yp5x	w3wp.exe	select POLICYID, AIRCOM, CABIN...
34.50	541	0.56	40.86	84.43	15.73	0.02	f5tz11uhm37fs	w3wp.exe	select * from (select /*+ FIRS...
29.23	238	0.47	31.79	91.96	1.11	0.98	a1xy4s4yh62hj	w3wp.exe	insert into tbics_log(userid, ...
29.23	238	0.47	31.35	93.25	0.71	0.01	4h55kwz846wz2	w3wp.exe	SELECT TBICS_LOG_ID.NEXTVAL FR...
23.50	2,705	0.38	24.37	96.43	3.75	0.00	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
10.96	192	0.18	15.20	72.07	28.10	0.01	chf20zq23a82a	w3wp.exe	select * from (select /*+ FIRS...
9.83	1,370	0.16	10.08	97.48	2.79	0.05	1gv747j5pzk2d	w3wp.exe	select * from ICS_OTHERORDER_S...
4.14	7	0.07	4.37	94.73	5.22	0.03	6t67sxtgjb39y	w3wp.exe	select PolicyID, FromCity, ToC...
3.83	236	0.06	20.24	18.93	80.87	0.00	5nwqnvv6tn881	w3wp.exe	select count(*) from ics_order...
3.51	869	0.06	3.63	96.54	3.71	0.03	20ny5g0f6g8x4	AutoReturn.exe	select * from ICS_OTHERORDER_S...
2.89	4	0.05	109.41	2.64	16.75	78.08	3pwsz56qj4u4g	w3wp.exe	select * from ics_order where ...
1.92	0	0.03	416.75	0.46	1.48	13.25	bc7gjv3ppdtbz	sqlplus@rac0101.tempus.cn (TNS V1-V3)	BEGIN dbms_workload_repository...
1.51	5	0.02	74.56	2.02	27.84	60.37	dw94kutvhh845	w3wp.exe	select * from ics_order where ...
1.14	3	0.02	157.40	0.72	4.04	91.51	0xgd8tharbz8k	w3wp.exe	select orderId, orderfrom, FLI...
1.12	6	0.02	272.78	0.41	10.89	83.42	0wxxrmxbwt2h4	w3wp.exe	select * from ics_order where ...
1.10	3	0.02	140.90	0.78	3.73	92.68	6uj2q1qvt2csk	w3wp.exe	select orderId, orderfrom, FLI...
0.99	3	0.02	159.21	0.62	1.34	94.71	4y8r9b9w28bgn	w3wp.exe	select * from tbics_passengeri...
0.87	6	0.01	135.11	0.64	3.78	87.19	3y709bqj5x87v	w3wp.exe	select OrderId from ICS_Order ...
0.48	1	0.01	17.52	2.73	24.50	57.86	175kn3t7qqrrz	w3wp.exe	select * from ics_order where ...
0.39	2	0.01	92.95	0.42	4.38	92.50	8n51rybdy4r4f	w3wp.exe	select orderId, orderfrom, ORD...
0.37	1,836	0.01	0.49	75.97	24.33	0.00	45xsf2qa56h92	w3wp.exe	select UserId, UserName, realn...
0.26	1	0.00	286.61	0.09	1.85	93.42	5dnh6xvw13j8p	w3wp.exe	begin pr_ImportHisData(intorde...
0.22	4	0.00	134.86	0.16	2.18	92.84	c5422ddu64q8p	w3wp.exe	select count(*) from ics_order...
0.18	595	0.00	0.27	64.59	36.43	1.36	486ppy6x0nxk2	w3wp.exe	select * from suspendsupplierm...
0.17	5	0.00	104.22	0.16	4.82	90.76	8ggqyrz3b3hu3	w3wp.exe	SELECT COUNT(*) FROM ICS_ORDER...
0.06	4	0.00	117.45	0.05	15.71	84.10	54h3gvyvk4fkf	w3wp.exe	select * from ics_order where ...
0.01	5	0.00	92.82	0.01	6.79	87.27	c1u68tgz8y5px	w3wp.exe	SELECT COUNT(*) FROM ICS_FANDI...
0.01	2	0.00	152.27	0.00	2.81	93.30	b0n3qqkkxrka6	w3wp.exe	select orderId, orderfrom, ORD...
0.01	165	0.00	0.99	0.53	2.13	97.36	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

03px98fk0yp5x 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, 'HFE')>0 or FROMCITY='*' ) and (instr(TOCITY, 'SZX')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '4')>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_070747, 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)

0ftwm12w0nfx5 select orderId, orderfrom, ORDERSTATE from ics_order where (PNR like '%HYPP98%' or BIGPNR like '%HYPP98%') and (ORDERSTATE!=26 and ORDERSTATE!=4) order by ORDERTIME desc

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>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')

0wxxrmxbwt2h4 select * from ics_order where pubid like '%112013112133287385%'

0xgd8tharbz8k select orderId, orderfrom, FLIGHTNO , PNR, ORDERSTATE from ics_order where (PNR like '%HYPP98%' or BIGPNR like '%HYPP98%') and (ORDERSTATE=36 or ORDERSTATE=37)

0ysnwzqnurd79 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, 'SZX')>0 or FROMCITY='*' ) and (instr(TOCITY, 'HLD')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2014-01-25', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2014-01-25', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', '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_070747, 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)

175kn3t7qqrrz select * from ics_order where pubid like '%T2013112180477%'

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)

1gv747j5pzk2d select * from ICS_OTHERORDER_SYNCH

1vzp1yq17vt4r 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, 'SZX')>0 or FROMCITY='*' ) and (instr(TOCITY, 'HLD')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-12-25', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-12-25', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', '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_070747, 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)

20ny5g0f6g8x4 select * from ICS_OTHERORDER_SYNCH where othercompanyname=:othercompanyname

21wx30xh4utxg select * from (select replace(strcat(psname), ';', '') as psname, replace(strcat(PSPIAOHAO), ';', '') as PSPIAOHAO, replace(strcat(PSPIAOJIA), ';', '') as PSPIAOJIA, replace(strcat(PSJICHANGRANYOU), ';', '') as PSJICHANGRANYOU, replace(strcat(ZIFUJIN), ';', '') as ZIFUJIN, replace(strcat(sendtime), ';', '') as sendtime, replace(strcat(applytime), ';', '') as applytime, fstate, orderid, APPLICANT, SOURCEHALL, IMGURL, BUYID, FLIGHTNO, SEGMENTINFO, toport, pnr, flightDate, fromTime, eremark, ROW_NUMBER() OVER (ORDER BY orderid) rn from (SELECT x.orderid, x.psname, x.PSPIAOHAO, x.PSPIAOJIA, x.PSJICHANGRANYOU, x.ZIFUJIN, x.APPLICANT, x.SOURCEHALL, x.sendtime, x.applytime, x.eremark, x.IMGURL, case when x.fstate=0 then '???' when x.fstate=1 then '???' when x.fstate=2 then '???' when x.fstate=3 then '???' else '????' end fstate, o.BUYID, o.FLIGHTNO, o.fromport || '-' || o.toport as SEGMENTINFO, o.toport, o.pnr, o.flightDate, o.fromTime from ics_feipiao x left join icsorder o on x.orderid = o.orderid WHERE 1 = 1 AND FSTATE=0 AND sendtime between '2013-11-21' and '2013-11-22' AND operatetype =6 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 order by x.sendtime asc) t group by orderid, APPLICANT, SOURCEHALL, IMGURL, BUYID, FLIGHTNO, SEGMENTINFO, toport, pnr, flightDate, fromTime, eremark, fstate) WHERE rn between 1 and 20 order by sendtime

2qz2wt9txf2vc 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, 'JXA')>0 or FROMCITY='*' ) and (instr(TOCITY, 'PEK')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2014-02-08', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2014-02-08', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', '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_070747, 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)

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

39cn676x1wsdp 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, 'SZX')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '5')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 AND LASTESTALTERSTATE !='D' and PASSTYPE='1' order by backpoint desc)

3bd3k79zy2w3p SELECT COUNT(*) FROM TBICS_PASSENGERINFO WHERE ORDERID=(SELECT ORDERID FROM ICS_ORDER WHERE (ORDERID=:B2 OR COUPONID=:B1 ))

3pwsz56qj4u4g select * from ics_order where pubid like '%112013112133287149%'

3vvhvgdrwxnmh select * from ics_order where pubid like '%f18588841%'

3y709bqj5x87v select OrderId from ICS_Order where COUPONID=:out_OrderId

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

45xsf2qa56h92 select UserId, UserName, realname, email, phone, sex, describe, groupid, pricture, logintime, mobile, extension, cornet from TBICS_user where userid=:userid

486ppy6x0nxk2 select * from suspendsuppliermgr

4ddw5un28xmt9 select * from (select replace(strcat(psname), ';', '') as psname, replace(strcat(PSPIAOHAO), ';', '') as PSPIAOHAO, replace(strcat(PSPIAOJIA), ';', '') as PSPIAOJIA, replace(strcat(PSJICHANGRANYOU), ';', '') as PSJICHANGRANYOU, replace(strcat(ZIFUJIN), ';', '') as ZIFUJIN, replace(strcat(sendtime), ';', '') as sendtime, replace(strcat(applytime), ';', '') as applytime, fstate, orderid, APPLICANT, SOURCEHALL, IMGURL, BUYID, FLIGHTNO, SEGMENTINFO, toport, pnr, flightDate, fromTime, eremark, ROW_NUMBER() OVER (ORDER BY orderid) rn from (SELECT x.orderid, x.psname, x.PSPIAOHAO, x.PSPIAOJIA, x.PSJICHANGRANYOU, x.ZIFUJIN, x.APPLICANT, x.SOURCEHALL, x.sendtime, x.applytime, x.eremark, x.IMGURL, case when x.fstate=0 then '???' when x.fstate=1 then '???' when x.fstate=2 then '???' when x.fstate=3 then '???' else '????' end fstate, o.BUYID, o.FLIGHTNO, o.fromport || '-' || o.toport as SEGMENTINFO, o.toport, o.pnr, o.flightDate, o.fromTime from ics_feipiao x left join icsorder o on x.orderid = o.orderid WHERE 1 = 1 AND FSTATE=0 AND sendtime between '2013-11-21' and '2013-11-22' 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 order by x.sendtime asc) t group by orderid, APPLICANT, SOURCEHALL, IMGURL, BUYID, FLIGHTNO, SEGMENTINFO, toport, pnr, flightDate, fromTime, eremark, fstate) WHERE rn between 1 and 20 order by sendtime

4h55kwz846wz2 SELECT TBICS_LOG_ID.NEXTVAL FROM DUAL

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

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)

4y8r9b9w28bgn select * from tbics_passengerinfo where orderid = (select orderid from ics_order where ordertime = (select max(ORDERTIME) from ics_order where bigpnr = 'NX60FS') and bigpnr='NX60FS')

54h3gvyvk4fkf select * from ics_order where pubid like '%112013112133286363%'

5dnh6xvw13j8p begin pr_ImportHisData(intorderid=>:intorderid, outorderid=>:outorderid); end;

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

6t67sxtgjb39y 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-21 09:20:51.000', 'yyyy-mm-dd hh24:mi:ssxff') and FLYTYPE !='6' and PASSTYPE='1' and policyid like 'SD%' order by PubTime asc) where rownum<=10000

6uj2q1qvt2csk select orderId, orderfrom, FLIGHTNO , PNR, ORDERSTATE from ics_order where (PNR like '%HYS09E%' or BIGPNR like '%HYS09E%') and (ORDERSTATE=36 or ORDERSTATE=37)

7agy84jm4njfy 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, 'CAN')>0 or FROMCITY='*' ) and (instr(TOCITY, 'NGB')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-12-01', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-12-01', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '7')>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_070747, 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)

8ggqyrz3b3hu3 SELECT COUNT(*) FROM ICS_ORDER WHERE (ORDERID=:B2 OR COUPONID=:B1 )

8n51rybdy4r4f select orderId, orderfrom, ORDERSTATE from ics_order where (PNR like '%JVQYWV%' or BIGPNR like '%JVQYWV%') and (ORDERSTATE!=26 and ORDERSTATE!=4) order by ORDERTIME desc

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

9a1unjt3njs9m 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, 'SZX')>0 or FROMCITY='*' ) and (instr(TOCITY, 'XIY')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '5')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 AND LASTESTALTERSTATE !='D' and PASSTYPE='1' order by backpoint desc)

9rkx7dk6m8959 SELECT TBICS_OPERATE_LOG_SQN.NEXTVAL FROM DUAL

9zynd5rbnpr02 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, 'XIY')>0 or FROMCITY='*' ) and (instr(TOCITY, 'SZX')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-24', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-24', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '7')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 AND LASTESTALTERSTATE !='D' and PASSTYPE='1' order by backpoint desc)

a1xy4s4yh62hj insert into tbics_log(userid, ip, operateid, remark) values(:userid, :ip, :operateid, :remark)

axfds3xc99mpp 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, 'WEF')>0 or FROMCITY='*' ) and (instr(TOCITY, 'XIY')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '5')>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_070747, 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)

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

b0n3qqkkxrka6 select orderId, orderfrom, ORDERSTATE from ics_order where (PNR like '%HNLQ4H%' or BIGPNR like '%HNLQ4H%') and (ORDERSTATE!=26 and ORDERSTATE!=4) order by ORDERTIME desc

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

bc7gjv3ppdtbz BEGIN dbms_workload_repository.create_snapshot(); END;

c1u68tgz8y5px SELECT COUNT(*) FROM ICS_FANDIAN WHERE ORDERID=(SELECT ORDERID FROM ICS_ORDER WHERE (ORDERID=:B2 OR COUPONID=:B1 ))

c5422ddu64q8p select count(*) from ics_order where 1=1 and orderfrom in('51BK', '517', '??', '19E', '??', '19E??', '??', '????', '517SZX', '??', '51BKSZX', '??SZX', '517SZX??', '517??') and orderfrom != 'SHBJDLS'

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

ct78468spkzrt select count(*) from v$lock

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

d1sfptpna4jrz select * from ics_order where pubid like '%T2013112122174%'

dqdyqmq1g00as 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, 'CTU')>0 or FROMCITY='*' ) and (instr(TOCITY, 'SZX')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '4')>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_070747, 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)

dw94kutvhh845 select * from ics_order where pubid like '%T2013112136326%'

f4r6ndbr8fzmu 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, 'CGO')>0 or FROMCITY='*' ) and (instr(TOCITY, 'UYN')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-23', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-23', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', '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_070747, 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)

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)

fc9x73fttz38u 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, 'SHE')>0 or FROMCITY='*' ) and (instr(TOCITY, 'PVG')>0 or TOCITY='*') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-30', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-30', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '6')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 AND LASTESTALTERSTATE !='D' and PASSTYPE='1' order by backpoint desc)

gzauf0b286tn3 select orderId, orderfrom, ORDERSTATE from ics_order where (PNR like '%JGMER0%' or BIGPNR like '%JGMER0%') and (ORDERSTATE!=26 and ORDERSTATE!=4) order by ORDERTIME desc

SQL Id	SQL Text
03px98fk0yp5x	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, 'HFE')>0 or FROMCITY='' ) and (instr(TOCITY, 'SZX')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '4')>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_070747, 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)
0ftwm12w0nfx5	select orderId, orderfrom, ORDERSTATE from ics_order where (PNR like '%HYPP98%' or BIGPNR like '%HYPP98%') and (ORDERSTATE!=26 and ORDERSTATE!=4) order by ORDERTIME desc
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>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')
0wxxrmxbwt2h4	select * from ics_order where pubid like '%112013112133287385%'
0xgd8tharbz8k	select orderId, orderfrom, FLIGHTNO , PNR, ORDERSTATE from ics_order where (PNR like '%HYPP98%' or BIGPNR like '%HYPP98%') and (ORDERSTATE=36 or ORDERSTATE=37)
0ysnwzqnurd79	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, 'SZX')>0 or FROMCITY='' ) and (instr(TOCITY, 'HLD')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2014-01-25', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2014-01-25', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', '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_070747, 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)
175kn3t7qqrrz	select * from ics_order where pubid like '%T2013112180477%'
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)
1gv747j5pzk2d	select * from ICS_OTHERORDER_SYNCH
1vzp1yq17vt4r	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, 'SZX')>0 or FROMCITY='' ) and (instr(TOCITY, 'HLD')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-12-25', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-12-25', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', '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_070747, 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)
20ny5g0f6g8x4	select * from ICS_OTHERORDER_SYNCH where othercompanyname=:othercompanyname
21wx30xh4utxg	select * from (select replace(strcat(psname), ';', '</BR>') as psname, replace(strcat(PSPIAOHAO), ';', '</BR>') as PSPIAOHAO, replace(strcat(PSPIAOJIA), ';', '</BR>') as PSPIAOJIA, replace(strcat(PSJICHANGRANYOU), ';', '</BR>') as PSJICHANGRANYOU, replace(strcat(ZIFUJIN), ';', '</BR>') as ZIFUJIN, replace(strcat(sendtime), ';', '</BR>') as sendtime, replace(strcat(applytime), ';', '</BR>') as applytime, fstate, orderid, APPLICANT, SOURCEHALL, IMGURL, BUYID, FLIGHTNO, SEGMENTINFO, toport, pnr, flightDate, fromTime, eremark, ROW_NUMBER() OVER (ORDER BY orderid) rn from (SELECT x.orderid, x.psname, x.PSPIAOHAO, x.PSPIAOJIA, x.PSJICHANGRANYOU, x.ZIFUJIN, x.APPLICANT, x.SOURCEHALL, x.sendtime, x.applytime, x.eremark, x.IMGURL, case when x.fstate=0 then '???' when x.fstate=1 then '???' when x.fstate=2 then '???' when x.fstate=3 then '???' else '????' end fstate, o.BUYID, o.FLIGHTNO, o.fromport \|\| '-' \|\| o.toport as SEGMENTINFO, o.toport, o.pnr, o.flightDate, o.fromTime from ics_feipiao x left join icsorder o on x.orderid = o.orderid WHERE 1 = 1 AND FSTATE=0 AND sendtime between '2013-11-21' and '2013-11-22' AND operatetype =6 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 order by x.sendtime asc) t group by orderid, APPLICANT, SOURCEHALL, IMGURL, BUYID, FLIGHTNO, SEGMENTINFO, toport, pnr, flightDate, fromTime, eremark, fstate) WHERE rn between 1 and 20 order by sendtime
2qz2wt9txf2vc	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, 'JXA')>0 or FROMCITY='' ) and (instr(TOCITY, 'PEK')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2014-02-08', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2014-02-08', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', '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_070747, 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)
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
39cn676x1wsdp	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, 'SZX')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '5')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 AND LASTESTALTERSTATE !='D' and PASSTYPE='1' order by backpoint desc)
3bd3k79zy2w3p	SELECT COUNT(*) FROM TBICS_PASSENGERINFO WHERE ORDERID=(SELECT ORDERID FROM ICS_ORDER WHERE (ORDERID=:B2 OR COUPONID=:B1 ))
3pwsz56qj4u4g	select * from ics_order where pubid like '%112013112133287149%'
3vvhvgdrwxnmh	select * from ics_order where pubid like '%f18588841%'
3y709bqj5x87v	select OrderId from ICS_Order where COUPONID=:out_OrderId
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
45xsf2qa56h92	select UserId, UserName, realname, email, phone, sex, describe, groupid, pricture, logintime, mobile, extension, cornet from TBICS_user where userid=:userid
486ppy6x0nxk2	select * from suspendsuppliermgr
4ddw5un28xmt9	select * from (select replace(strcat(psname), ';', '</BR>') as psname, replace(strcat(PSPIAOHAO), ';', '</BR>') as PSPIAOHAO, replace(strcat(PSPIAOJIA), ';', '</BR>') as PSPIAOJIA, replace(strcat(PSJICHANGRANYOU), ';', '</BR>') as PSJICHANGRANYOU, replace(strcat(ZIFUJIN), ';', '</BR>') as ZIFUJIN, replace(strcat(sendtime), ';', '</BR>') as sendtime, replace(strcat(applytime), ';', '</BR>') as applytime, fstate, orderid, APPLICANT, SOURCEHALL, IMGURL, BUYID, FLIGHTNO, SEGMENTINFO, toport, pnr, flightDate, fromTime, eremark, ROW_NUMBER() OVER (ORDER BY orderid) rn from (SELECT x.orderid, x.psname, x.PSPIAOHAO, x.PSPIAOJIA, x.PSJICHANGRANYOU, x.ZIFUJIN, x.APPLICANT, x.SOURCEHALL, x.sendtime, x.applytime, x.eremark, x.IMGURL, case when x.fstate=0 then '???' when x.fstate=1 then '???' when x.fstate=2 then '???' when x.fstate=3 then '???' else '????' end fstate, o.BUYID, o.FLIGHTNO, o.fromport \|\| '-' \|\| o.toport as SEGMENTINFO, o.toport, o.pnr, o.flightDate, o.fromTime from ics_feipiao x left join icsorder o on x.orderid = o.orderid WHERE 1 = 1 AND FSTATE=0 AND sendtime between '2013-11-21' and '2013-11-22' 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 order by x.sendtime asc) t group by orderid, APPLICANT, SOURCEHALL, IMGURL, BUYID, FLIGHTNO, SEGMENTINFO, toport, pnr, flightDate, fromTime, eremark, fstate) WHERE rn between 1 and 20 order by sendtime
4h55kwz846wz2	SELECT TBICS_LOG_ID.NEXTVAL FROM DUAL
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
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)
4y8r9b9w28bgn	select * from tbics_passengerinfo where orderid = (select orderid from ics_order where ordertime = (select max(ORDERTIME) from ics_order where bigpnr = 'NX60FS') and bigpnr='NX60FS')
54h3gvyvk4fkf	select * from ics_order where pubid like '%112013112133286363%'
5dnh6xvw13j8p	begin pr_ImportHisData(intorderid=>:intorderid, outorderid=>:outorderid); end;
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
6t67sxtgjb39y	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-21 09:20:51.000', 'yyyy-mm-dd hh24:mi:ssxff') and FLYTYPE !='6' and PASSTYPE='1' and policyid like 'SD%' order by PubTime asc) where rownum<=10000
6uj2q1qvt2csk	select orderId, orderfrom, FLIGHTNO , PNR, ORDERSTATE from ics_order where (PNR like '%HYS09E%' or BIGPNR like '%HYS09E%') and (ORDERSTATE=36 or ORDERSTATE=37)
7agy84jm4njfy	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, 'CAN')>0 or FROMCITY='' ) and (instr(TOCITY, 'NGB')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-12-01', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-12-01', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '7')>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_070747, 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)
8ggqyrz3b3hu3	SELECT COUNT(*) FROM ICS_ORDER WHERE (ORDERID=:B2 OR COUPONID=:B1 )
8n51rybdy4r4f	select orderId, orderfrom, ORDERSTATE from ics_order where (PNR like '%JVQYWV%' or BIGPNR like '%JVQYWV%') and (ORDERSTATE!=26 and ORDERSTATE!=4) order by ORDERTIME desc
94h2a7cs7a7fc	select * from ICS_AutoTicketTask where Status=4 order by InTime asc, TaskId asc
9a1unjt3njs9m	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, 'SZX')>0 or FROMCITY='' ) and (instr(TOCITY, 'XIY')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '5')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 AND LASTESTALTERSTATE !='D' and PASSTYPE='1' order by backpoint desc)
9rkx7dk6m8959	SELECT TBICS_OPERATE_LOG_SQN.NEXTVAL FROM DUAL
9zynd5rbnpr02	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, 'XIY')>0 or FROMCITY='' ) and (instr(TOCITY, 'SZX')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-24', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-24', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '7')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 AND LASTESTALTERSTATE !='D' and PASSTYPE='1' order by backpoint desc)
a1xy4s4yh62hj	insert into tbics_log(userid, ip, operateid, remark) values(:userid, :ip, :operateid, :remark)
axfds3xc99mpp	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, 'WEF')>0 or FROMCITY='' ) and (instr(TOCITY, 'XIY')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-22', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '5')>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_070747, 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)
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b0n3qqkkxrka6	select orderId, orderfrom, ORDERSTATE from ics_order where (PNR like '%HNLQ4H%' or BIGPNR like '%HNLQ4H%') and (ORDERSTATE!=26 and ORDERSTATE!=4) order by ORDERTIME desc
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
bc7gjv3ppdtbz	BEGIN dbms_workload_repository.create_snapshot(); END;
c1u68tgz8y5px	SELECT COUNT(*) FROM ICS_FANDIAN WHERE ORDERID=(SELECT ORDERID FROM ICS_ORDER WHERE (ORDERID=:B2 OR COUPONID=:B1 ))
c5422ddu64q8p	select count(*) from ics_order where 1=1 and orderfrom in('51BK', '517', '??', '19E', '??', '19E??', '??', '????', '517SZX', '??', '51BKSZX', '??SZX', '517SZX??', '517??') and orderfrom != 'SHBJDLS'
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
ct78468spkzrt	select count(*) from v$lock
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d1sfptpna4jrz	select * from ics_order where pubid like '%T2013112122174%'
dqdyqmq1g00as	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, 'CTU')>0 or FROMCITY='' ) and (instr(TOCITY, 'SZX')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '4')>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_070747, 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)
dw94kutvhh845	select * from ics_order where pubid like '%T2013112136326%'
f4r6ndbr8fzmu	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, 'CGO')>0 or FROMCITY='' ) and (instr(TOCITY, 'UYN')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-23', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-23', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', '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_070747, 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)
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)
fc9x73fttz38u	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, 'SHE')>0 or FROMCITY='' ) and (instr(TOCITY, 'PVG')>0 or TOCITY='') and instr(FLYTYPE, '1')>0 AND to_date(BEGINTIME, 'YYYY-MM-DD') <= to_date('2013-11-30', 'YYYY-MM-DD') AND to_date(ENDTIME, 'YYYY-MM-DD') >= to_date('2013-11-30', 'YYYY-MM-DD') AND to_date(TICKETSTART, 'YYYY-MM-DD') <= to_date('2013-11-21', 'YYYY-MM-DD') AND to_date(TICKETEND, 'YYYY-MM-DD') >= to_date('2013-11-21', 'YYYY-MM-DD') and (instr(WEEK, '6')>0 or WEEK is null or WEEK='') and backpoint>=3 and ISSTATUS=1 and ISCHECK=1 AND LASTESTALTERSTATE !='D' and PASSTYPE='1' order by backpoint desc)
gzauf0b286tn3	select orderId, orderfrom, ORDERSTATE from ics_order where (PNR like '%JGMER0%' or BIGPNR like '%JGMER0%') and (ORDERSTATE!=26 and ORDERSTATE!=4) order by ORDERTIME desc

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	10	0.00	0.00
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	2,983	1.16	0.37
Batched IO buffer defrag count	8	0.00	0.00
Batched IO double miss count	16	0.01	0.00
Batched IO same unit count	122	0.05	0.02
Batched IO single block count	15	0.01	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	2,860	1.11	0.35
Batched IO vector read count	31	0.01	0.00
Block Cleanout Optim referenced	525	0.20	0.06
CCursor + sql area evicted	114	0.04	0.01
CPU used by this session	156,671	60.77	19.33
CPU used when call started	154,709	60.01	19.09
CR blocks created	3,618	1.40	0.45
Cached Commit SCN referenced	240	0.09	0.03
Commit SCN cached	293	0.11	0.04
DB time	2,844,801	1,103.42	350.95
DBWR checkpoint buffers written	16,294	6.32	2.01
DBWR checkpoints	893	0.35	0.11
DBWR fusion writes	5,302	2.06	0.65
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,893	0.73	0.23
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	99	0.04	0.01
DBWR undo block writes	3,324	1.29	0.41
DFO trees parallelized	331	0.13	0.04
Effective IO time	14,715,957,217	5,707,908.02	1,815,440.07
HSC Heap Segment Block Changes	38,277	14.85	4.72
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	407	0.16	0.05
Heap Segment Array Updates	337	0.13	0.04
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	400,864	155.48	49.45
PX local messages recv'd	1,340	0.52	0.17
PX local messages sent	1,340	0.52	0.17
PX remote messages recv'd	694	0.27	0.09
PX remote messages sent	730	0.28	0.09
Parallel operations not downgraded	331	0.13	0.04
Requests to/from client	567,959	220.30	70.07
RowCR - row contention	14	0.01	0.00
RowCR attempts	397	0.15	0.05
RowCR hits	382	0.15	0.05
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	10	0.00	0.00
SQL*Net roundtrips to/from client	568,046	220.33	70.08
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,908	1.90	0.61
application wait time	30,330	11.76	3.74
background checkpoints completed	0	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	19,958	7.74	2.46
branch node splits	2	0.00	0.00
buffer is not pinned count	17,863,550	6,928.77	2,203.74
buffer is pinned count	346,254,552	134,302.45	42,715.83
bytes received via SQL*Net from client	165,975,441	64,377.23	20,475.63
bytes sent via SQL*Net to client	206,097,211	79,939.34	25,425.27
calls to get snapshot scn: kcmgss	531,476	206.14	65.57
calls to kcmgas	98,802	38.32	12.19
calls to kcmgcs	366,620	142.20	45.23
cell physical IO interconnect bytes	421,859,907,584	163,627,653.56	52,042,919.76
change write time	321	0.12	0.04
cleanout - number of ktugct calls	5,752	2.23	0.71
cleanouts and rollbacks - consistent read gets	2,618	1.02	0.32
cleanouts only - consistent read gets	289	0.11	0.04
cluster key scan block gets	6,948	2.69	0.86
cluster key scans	4,987	1.93	0.62
cluster wait time	627,985	243.58	77.47
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	23	0.01	0.00
commit batch/immediate requested	23	0.01	0.00
commit cleanout failures: block lost	66	0.03	0.01
commit cleanout failures: buffer being written	34	0.01	0.00
commit cleanout failures: callback failure	67	0.03	0.01
commit cleanout failures: cannot pin	1,393	0.54	0.17
commit cleanouts	54,642	21.19	6.74
commit cleanouts successfully completed	53,082	20.59	6.55
commit immediate performed	23	0.01	0.00
commit immediate requested	23	0.01	0.00
commit txn count during cleanout	6,294	2.44	0.78
concurrency wait time	31,719	12.30	3.91
consistent changes	266,966	103.55	32.93
consistent gets	91,349,710	35,432.00	11,269.39
consistent gets - examination	1,554,771	603.05	191.80
consistent gets direct	50,831,799	19,716.23	6,270.89
consistent gets from cache	40,517,928	15,715.77	4,998.51
consistent gets from cache (fastpath)	38,733,908	15,023.80	4,778.42
cursor authentications	26,498	10.28	3.27
data blocks consistent reads - undo records applied	53,693	20.83	6.62
db block changes	694,812	269.50	85.72
db block gets	1,334,510	517.62	164.63
db block gets direct	80	0.03	0.01
db block gets from cache	1,334,430	517.59	164.62
db block gets from cache (fastpath)	200,964	77.95	24.79
deferred (CURRENT) block cleanout applications	25,761	9.99	3.18
dirty buffers inspected	444	0.17	0.05
enqueue conversions	8,361	3.24	1.03
enqueue deadlocks	0	0.00	0.00
enqueue releases	177,147	68.71	21.85
enqueue requests	177,183	68.72	21.86
enqueue timeouts	2	0.00	0.00
enqueue waits	4,075	1.58	0.50
exchange deadlocks	30	0.01	0.00
execute count	271,088	105.15	33.44
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	4,214,099,883	1,634,531.42	519,874.15
free buffer inspected	175,841	68.20	21.69
free buffer requested	232,832	90.31	28.72
gc blocks compressed	39,024	15.14	4.81
gc blocks lost	0	0.00	0.00
gc cr block flush time	63,308	24.56	7.81
gc cr block receive time	70,106	27.19	8.65
gc cr blocks received	21,854	8.48	2.70
gc cr blocks served	25,920	10.05	3.20
gc current block flush time	58,175	22.56	7.18
gc current block pin time	2,504	0.97	0.31
gc current block receive time	126,617	49.11	15.62
gc current blocks received	91,237	35.39	11.26
gc current blocks served	134,075	52.00	16.54
gc kbytes saved	116,521	45.20	14.37
gc kbytes sent	1,163,440	451.27	143.53
gc local grants	6,226	2.41	0.77
gc read wait time	46,447	18.02	5.73
gc read wait timeouts	0	0.00	0.00
gc read waits	1,067	0.41	0.13
gc remote grants	43,105	16.72	5.32
gcs messages sent	215,142	83.45	26.54
ges messages sent	31,172	12.09	3.85
global enqueue get time	39,073	15.16	4.82
global enqueue gets async	7,207	2.80	0.89
global enqueue gets sync	377,456	146.40	46.57
global enqueue releases	373,250	144.77	46.05
heap block compress	5,630	2.18	0.69
hot buffers moved to head of LRU	17,327	6.72	2.14
immediate (CR) block cleanout applications	2,907	1.13	0.36
immediate (CURRENT) block cleanout applications	5,424	2.10	0.67
in call idle wait time	12,286,872	4,765.73	1,515.77
index crx upgrade (positioned)	4,504	1.75	0.56
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	10	0.00	0.00
index fetch by key	747,938	290.10	92.27
index scans kdiixs1	191,628	74.33	23.64
leaf node 90-10 splits	34	0.01	0.00
leaf node splits	452	0.18	0.06
lob reads	93,767	36.37	11.57
lob writes	65,674	25.47	8.10
lob writes unaligned	65,674	25.47	8.10
logical read bytes from cache	342,854,279,168	132,983,581.05	42,296,358.15
logons cumulative	3,053	1.18	0.38
max cf enq hold time	450	0.17	0.06
messages received	42,550	16.50	5.25
messages sent	42,551	16.50	5.25
min active SCN optimization applied on CR	611	0.24	0.08
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	89,334,854	34,650.49	11,020.83
non-idle wait count	1,860,535	721.65	229.53
non-idle wait time	3,206,042	1,243.53	395.51
opened cursors cumulative	271,845	105.44	33.54
parse count (describe)	40	0.02	0.00
parse count (failures)	13	0.01	0.00
parse count (hard)	84,338	32.71	10.40
parse count (total)	173,487	67.29	21.40
parse time cpu	17,943	6.96	2.21
parse time elapsed	18,766	7.28	2.32
physical read IO requests	424,039	164.47	52.31
physical read bytes	417,806,106,624	162,055,297.60	51,542,820.95
physical read total IO requests	510,929	198.18	63.03
physical read total bytes	419,290,819,584	162,631,176.22	51,725,983.17
physical read total multi block requests	402,938	156.29	49.71
physical reads	51,001,722	19,782.14	6,291.85
physical reads cache	37,692	14.62	4.65
physical reads cache prefetch	29,456	11.43	3.63
physical reads direct	50,964,030	19,767.52	6,287.20
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	125,240	48.58	15.45
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	24,412	9.47	3.01
physical write bytes	2,288,066,560	887,476.99	282,268.27
physical write total IO requests	52,847	20.50	6.52
physical write total bytes	2,569,088,000	996,477.35	316,936.59
physical write total multi block requests	8,866	3.44	1.09
physical writes	279,305	108.33	34.46
physical writes direct	259,085	100.49	31.96
physical writes direct (lob)	3	0.00	0.00
physical writes direct temporary tablespace	259,005	100.46	31.95
physical writes from cache	20,220	7.84	2.49
physical writes non checkpoint	270,513	104.92	33.37
pinned buffers inspected	30	0.01	0.00
pinned cursors current	61	0.02	0.01
prefetch clients - default	22	0.01	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	432	0.17	0.05
process last non-idle time	2,691	1.04	0.33
queries parallelized	331	0.13	0.04
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	537,812	208.60	66.35
recursive cpu usage	22,478	8.72	2.77
redo KB read	75,877	29.43	9.36
redo blocks checksummed by FG (exclusive)	26,540	10.29	3.27
redo blocks written	160,688	62.33	19.82
redo buffer allocation retries	104	0.04	0.01
redo entries	253,258	98.23	31.24
redo log space requests	112	0.04	0.01
redo log space wait time	79	0.03	0.01
redo ordering marks	3,440	1.33	0.42
redo size	75,620,752	29,331.17	9,328.98
redo size for direct writes	658,240	255.31	81.20
redo subscn max counts	3,776	1.46	0.47
redo synch long waits	542	0.21	0.07
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	361,618	140.26	44.61
redo synch time (usec)	3,616,488,773	1,402,734.80	446,149.61
redo synch writes	12,893	5.00	1.59
redo wastage	3,384,336	1,312.69	417.51
redo write broadcast ack count	3	0.00	0.00
redo write broadcast ack time	3,691	1.43	0.46
redo write broadcast lgwr post count	0	0.00	0.00
redo write time	122,877	47.66	15.16
redo writes	12,616	4.89	1.56
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	82	0.03	0.01
rollbacks only - consistent read gets	5,975	2.32	0.74
root node splits	0	0.00	0.00
rows fetched via callback	364,395	141.34	44.95
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	99,381	38.55	12.26
session logical reads	92,684,016	35,949.54	11,434.00
shared hash latch upgrades - no wait	18,838	7.31	2.32
shared hash latch upgrades - wait	32	0.01	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	193,913	75.21	23.92
sorts (rows)	3,013,523	1,168.86	371.76
sql area evicted	84,607	32.82	10.44
sql area purged	15	0.01	0.00
summed dirty queue length	1,454	0.56	0.18
switch current to new buffer	7,499	2.91	0.93
table fetch by rowid	181,725,899	70,486.39	22,418.69
table fetch continued row	15,981	6.20	1.97
table scan blocks gotten	70,323,269	27,276.43	8,675.46
table scan rows gotten	2,012,558,862	780,615.27	248,280.15
table scans (direct read)	783	0.30	0.10
table scans (long tables)	601	0.23	0.07
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	170,495	66.13	21.03
total cf enq hold time	64,700	25.10	7.98
total number of cf enq holders	127	0.05	0.02
total number of slots	36	0.01	0.00
total number of times SMON posted	14	0.01	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.01	0.00
transaction tables consistent read rollbacks	3	0.00	0.00
transaction tables consistent reads - undo records applied	427	0.17	0.05
undo change vector size	24,414,444	9,469.68	3,011.90
user I/O wait time	1,707,118	662.14	210.60
user calls	784,236	304.18	96.75
user commits	8,101	3.14	1.00
user rollbacks	5	0.00	0.00
workarea executions - onepass	4	0.00	0.00
workarea executions - optimal	32,124	12.46	3.96
write clones created in background	1	0.00	0.00
write clones created in foreground	68	0.03	0.01

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	445,773,629,408	445,718,146,896
session cursor cache count	108,785,409	108,826,112
session uga memory	369,837,977,621,624	369,924,088,136,376
opened cursors current	373	452
workarea memory allocated	40,874	45,697
logons current	216	240
session uga memory max	6,204,017,371,704	6,207,176,637,576
session pga memory	338,836,948,288	339,050,359,984

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	1	1.40

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	395.3G	159.67	157.007	0M	0.00	0M	0
Direct Writes	0M	0.00	0M	1.9G	3.19	.771477	0
Others	1.4G	33.76	.567456	112M	0.95	.043441	88.1K	16.23
Buffer Cache Reads	297M	7.50	.115197	0M	0.00	0M	8406	94.75
DBWR	0M	0.00	0M	158M	6.25	.061283	0
LGWR	0M	0.01	0M	156M	10.14	.060508	12.7K	99.18
TOTAL:	397G	200.93	157.689	2.4G	20.54	.936710	109.2K	31.91

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	396.2G	166.25	157.351	161M	6.27	.062447	53.92	83.29
Temp File	978M	1.57	.379338	2G	3.20	.774968		6.66
Control File	1.3G	33.73	.535263	37M	0.93	.014351	15.02	74.84
Log File	74M	0.03	.028702	156M	10.16	.060508	67.75	281.88
Archive Log	0M	0.00	0M	74M	0.03	.028702
TOTAL:	398.5G	201.57	158.295	2.4G	20.58	.940977	22.75	82.57

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	397.8G	160.66	157.994	0M	0.00	0M	0
Direct Reads (Data File)	397.8G	160.66	157.994	0M	0.00	0M	0
Direct Writes	0M	0.00	0M	1.9G	3.19	.771865	0
Direct Writes (Data File)	0M	0.00	0M	1.9G	3.19	.771865	0
Others	1.4G	33.76	.567456	112M	0.96	.043441	87K	15.10
Others (Control File)	1.3G	33.72	.534875	37M	0.92	.014351	86.9K	15.07
Others (Archive Log)	0M	0.00	0M	74M	0.03	.028702	0
Others (Log File)	74M	0.03	.028702	0M	0.00	0M	7	77.43
Others (Data File)	10M	0.01	.003878	1M	0.01	.000387	11	226.64
Buffer Cache Reads	298M	7.54	.115585	0M	0.00	0M	7559	102.76
Buffer Cache Reads (Data File)	298M	7.54	.115585	0M	0.00	0M	7559	102.76
DBWR	0M	0.00	0M	158M	6.27	.061283	0
DBWR (Data File)	0M	0.00	0M	158M	6.27	.061283	0
LGWR	0M	0.01	0M	156M	10.17	.060508	21	29.38
LGWR (Log File)	0M	0.00	0M	156M	10.16	.060508	8	50.63
LGWR (Control File)	0M	0.01	0M	0M	0.01	0M	13	16.31
TOTAL:	399.5G	201.97	158.677	2.4G	20.58	.937098	94.5K	22.11

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	372,051	144	0.98	120.74	13,233	5	5,302	58.41
SYSTEM	2,102	1	1.42	125.99	259	0	2,020	323.68
SYSAUX	78	0	121.15	1.00	958	0	0	0.00
UNDOTBS1	0	0	0.00	0.00	398	0	46	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)
SYSAUX	+DATA/oradb/datafile/sysaux.263.797076875	78	0	121.15	1.00	958	0	0	0.00
SYSTEM	+DATA/oradb/datafile/system.260.797076869	2,102	1	1.42	125.99	259	0	2,020	323.68
TEMPUSICS	+DATA/oradb/datafile/tempusics.502.798195487	264,404	103	0.63	125.19	8,029	3	592	99.10
TEMPUSICS	+DATA/oradb/datafile/tempusics01.dbf	107,647	42	1.82	109.79	5,204	2	4,710	53.29
UNDOTBS1	+DATA/oradb/datafile/undotbs1.265.797076881	0	0			398	0	46	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	309,878	100	41,712,060	37,656	19,930	0	0	43,888

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 279,305

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	14,398	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	1986	13310	140787	497664	140787			1
E	0	4	3270	35449	129910	497664	129910			1

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	256	0.10	30	2.24	620,913	1	1653524.00
D	512	0.20	60	1.56	432,371	1	961172.00
D	768	0.29	91	1.19	330,455	1	586922.00
D	1,024	0.39	121	1.05	290,160	1	438956.00
D	1,280	0.49	151	1.01	279,195	1	398691.00
D	1,536	0.59	181	1.00	277,276	1	391642.00
D	1,792	0.68	212	1.00	276,922	1	390341.00
D	2,048	0.78	242	1.00	276,788	1	389849.00
D	2,304	0.88	272	1.00	276,692	1	389497.00
D	2,560	0.98	302	1.00	276,621	1	389237.00
D	2,624	1.00	310	1.00	276,606	1	389181.00
D	2,816	1.07	333	1.00	276,565	1	389034.00
D	3,072	1.17	363	1.00	276,519	1	388864.00
D	3,328	1.27	393	1.00	276,480	1	388721.00
D	3,584	1.37	423	1.00	276,448	1	388603.00
D	3,840	1.46	453	1.00	276,409	1	388459.00
D	4,096	1.56	484	1.00	275,936	1	386721.00
D	4,352	1.66	514	0.99	273,822	1	378960.00
D	4,608	1.76	544	0.98	270,538	1	366900.00
D	4,864	1.85	574	0.97	267,254	1	354839.00
D	5,120	1.95	605	0.95	263,968	1	342774.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
67.24	3,584	1,746

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	29,257	29,257	0
64K	128K	578	578	0
128K	256K	448	448	0
256K	512K	344	344	0
512K	1024K	1,454	1,454	0
1M	2M	28	28	0
2M	4M	12	12	0
4M	8M	2	2	0
128M	256M	2	2	0
256M	512M	4	0	4

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,180,971.83	32,973,194.95	29.00	110,595	13,646,382,636
840	0.25	13,180,971.83	8,114,054.04	62.00	92	6,296,291,138
1,680	0.50	13,180,971.83	8,102,844.63	62.00	0	6,292,976,856
2,520	0.75	13,180,971.83	8,102,844.63	62.00	0	6,292,976,856
3,360	1.00	13,180,971.83	8,102,844.63	62.00	0	6,292,976,856
4,032	1.20	13,180,971.83	8,101,859.61	62.00	0	6,292,685,618
4,704	1.40	13,180,971.83	8,101,859.61	62.00	0	6,292,685,618
5,376	1.60	13,180,971.83	8,101,859.61	62.00	0	6,292,685,618
6,048	1.80	13,180,971.83	8,101,859.61	62.00	0	6,292,685,618
6,720	2.00	13,180,971.83	8,101,859.61	62.00	0	6,292,685,618
10,080	3.00	13,180,971.83	8,101,859.61	62.00	0	6,292,685,618
13,440	4.00	13,180,971.83	8,101,859.61	62.00	0	6,292,685,618
20,160	6.00	13,180,971.83	8,101,859.61	62.00	0	6,292,685,618
26,880	8.00	13,180,971.83	8,101,859.61	62.00	0	6,292,685,618

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,016	0.57	186	31,381	7,535,194	0.41	11,086,738	24.40	1,067,545
2,400	0.68	569	46,710	10,266,563	0.57	8,355,369	18.39	1,366,773
2,784	0.78	953	62,095	12,911,131	0.71	5,710,801	12.57	1,654,587
3,168	0.89	1,337	77,813	15,544,538	0.86	3,077,394	6.77	1,939,799
3,232	0.91	1,401	80,763	15,982,781	0.88	2,639,151	5.81	1,987,208
3,264	0.92	1,433	82,115	16,201,539	0.89	2,420,393	5.33	2,010,909
3,296	0.93	1,464	83,571	16,421,023	0.90	2,200,909	4.84	2,034,619
3,328	0.94	1,496	85,197	16,639,813	0.92	1,982,119	4.36	2,058,313
3,360	0.95	1,528	86,649	16,859,044	0.93	1,762,888	3.88	2,081,967
3,392	0.96	1,560	87,912	17,077,997	0.94	1,543,935	3.40	2,105,627
3,424	0.96	1,592	89,348	17,297,152	0.95	1,324,780	2.92	2,129,258
3,456	0.97	1,624	90,534	17,515,912	0.96	1,106,020	2.43	2,152,885
3,488	0.98	1,656	91,776	17,734,698	0.98	887,234	1.95	2,176,517
3,520	0.99	1,687	93,136	17,951,610	0.99	670,322	1.48	2,200,017
3,552	1.00	1,719	94,532	18,167,534	1.00	454,398	1.00	2,223,558
3,584	1.01	1,751	95,826	18,168,379	1.00	453,553	1.00	2,223,821
3,616	1.02	1,783	97,165	18,168,686	1.00	453,246	1.00	2,223,938
3,648	1.03	1,815	98,463	18,169,180	1.00	452,752	1.00	2,224,136
3,680	1.04	1,846	99,807	18,169,798	1.00	452,134	1.00	2,224,371
3,712	1.05	1,878	101,184	18,170,203	1.00	451,729	0.99	2,224,526
3,744	1.05	1,910	102,459	18,176,121	1.00	445,811	0.98	2,227,287
3,776	1.06	1,941	103,699	18,184,905	1.00	437,027	0.96	2,231,087
3,808	1.07	1,973	105,106	18,188,451	1.00	433,481	0.95	2,232,654
3,840	1.08	2,005	106,493	18,188,613	1.00	433,319	0.95	2,232,723
3,936	1.11	2,101	110,297	18,189,085	1.00	432,847	0.95	2,232,930
4,320	1.22	2,485	126,439	18,190,818	1.00	431,114	0.95	2,233,669
4,704	1.32	2,868	142,237	18,192,357	1.00	429,575	0.95	2,234,374
5,088	1.43	3,251	158,174	18,193,930	1.00	428,002	0.94	2,235,117
5,472	1.54	3,635	173,871	18,195,553	1.00	426,379	0.94	2,235,900
5,856	1.65	4,019	189,648	18,197,192	1.00	424,740	0.93	2,236,675
6,240	1.76	4,403	204,468	18,198,753	1.00	423,179	0.93	2,237,415
6,624	1.86	4,787	219,698	18,200,227	1.00	421,705	0.93	2,238,110
7,008	1.97	5,171	234,773	18,201,601	1.00	420,331	0.93	2,238,770
7,392	2.08	5,555	250,050	18,202,747	1.00	419,185	0.92	2,239,373

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	17,107,203	619,403,478
3,152	0.50	11,708,957	619,403,478
3,940	0.63	6,429,394	619,403,478
4,728	0.75	5,208,666	289,468,021
5,516	0.88	5,140,848	276,605,849
6,304	1.00	5,137,759	276,605,849
7,092	1.13	5,134,682	276,605,849
7,880	1.25	5,131,086	276,107,958
8,668	1.38	5,103,856	266,620,378
9,456	1.50	5,089,987	263,328,768
10,244	1.63	5,086,904	263,328,768
11,032	1.75	5,083,821	263,328,768
11,820	1.88	5,080,739	263,328,768
12,608	2.00	5,078,170	263,328,768

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	43,345	5,513	127
segment header	259	17	64
undo block	27	10	364
1st level bmb	56	1	13
undo header	57	1	10
2nd level bmb	1	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)	11,161	11,159	0	3,385	301	88.94
CF-Controlfile Transaction	5,678	5,676	2	75	3	41.20
TX-Transaction (index contention)	44	44	0	33	2	67.88
TX-Transaction (row lock contention)	6	6	0	6	0	45.00
PS-PX Process Reservation	2,306	2,306	0	373	0	0.32
HW-Segment High Water Mark	647	647	0	41	0	0.49
WF-AWR Flush	38	38	0	21	0	0.48
FB-Format Block	32	32	0	11	0	0.91
TA-Instance Undo	11	11	0	7	0	1.43
JQ-Job Queue	19	19	0	3	0	3.33
AE-Edition Lock (lock)	2,654	2,654	0	2	0	5.00
TT-Tablespace	2,782	2,782	0	41	0	0.00
US-Undo Segment	51	51	0	24	0	0.00
UL-User-defined	47	47	0	14	0	0.00
TQ-Queue table enqueue (TM contention)	138	138	0	10	0	0.00
CR-Reuse Block Range (block range reuse ckpt)	156	156	0	8	0	0.00
TD-KTF map table enqueue (KTF dump entries)	6	6	0	5	0	0.00
TM-DML	26,149	26,149	0	4	0	0.00
DR-Distributed Recovery	2	2	0	2	0	0.00
AF-Advisor Framework (task serialization)	7	7	0	1	0	0.00
JS-Job Scheduler (job run lock - synchronize)	2	2	0	1	0	0.00
WL-Being Written Redo Log	1	1	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	3.89	18,268	786	6	15/26.1	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
21-11? 09:41	799	4,802	0	5	15	0/0	0/0/0/0/0/0
21-11? 09:31	770	3,999	174	6	21	0/0	0/0/0/0/0/0
21-11? 09:21	732	3,273	784	4	26	0/0	0/0/0/0/0/0
21-11? 09:11	701	3,568	182	4	16	0/0	0/0/0/0/0/0
21-11? 09:01	883	2,626	786	3	26	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	2	0.00		0	0
AQ deq log cmt cbk chunk latch	110	0.00		0	0
AQ deq log statistics latch	40	0.00		0	0
AQ dequeue txn counter latch	2,480	0.00		0	0
AQ ht cmt cbk chunk latch	80	0.00		0	0
ASM Keyed state latch	5,335	0.04	0.00	0	0
ASM allocation	227	0.00		0	0
ASM db client latch	4,948	0.00		0	0
ASM map headers	42	0.00		0	0
ASM map load waiting list	10	0.00		0	0
ASM map operation freelist	6,049	1.02	0.00	0	0
ASM map operation hash table	1,140,503	0.00	0.00	0	0
ASM network SGA latch	3	0.00		0	0
ASM network background latch	1,281	0.00		0	0
ASM network state latch	325	0.00		0	0
ASM scan context latch	4	0.00		0	0
AWR Alerted Metric Element list	24,949	0.00		0	0
Change Notification Hash table latch	886	0.00		0	0
Consistent RBA	12,608	0.00		0	0
DML lock allocation	2,322,441	0.00	0.00	0	0
Event Group Locks	5,723	0.00		0	0
FAL Queue	72	0.00		0	0
FIB s.o chain latch	26	0.00		0	0
FOB s.o list latch	15,802	0.28	0.00	0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC other latch	23	0.00		0	0
IPC stats buffer allocation latch	11,074	0.00		0	11,210	0.00
In memory undo latch	1	0.00		0	0
JS Sh mem access	5	0.00		0	0
JS broadcast add buf latch	617	0.00		0	0
JS broadcast drop buf latch	617	0.00		0	0
JS broadcast load blnc latch	537	0.00		0	0
JS mem alloc latch	4	0.00		0	0
JS queue access latch	5	0.00		0	0
JS queue state obj latch	19,508	0.00		0	0
JS slv state obj latch	75	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KFK SGA Libload latch	102	0.00		0	0
KFMD SGA	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	18,944	0.34	0.00	0	5,731	0.00
KJCT flow control latch	277,441	0.02	0.00	0	0
KMG MMAN ready and startup request latch	894	0.00		0	0
KSXR large replies	178	0.00		0	0
KTF sga latch	21	0.00		0	875	0.00
KWQMN job cache list latch	888	0.00		0	0
KWQS pqsubs latch	105	0.00		0	0
KWQS pqueue ctx latch	175	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	35,517	0.66	0.00	0	0
MQL Tracking Latch	0			0	54	0.00
Memory Management Latch	1	0.00		0	894	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	1,838	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	10,931	0.00		0	0
OS process allocation	10,905	0.28	0.00	0	0
OS process: request allocation	5,335	0.41	0.00	0	0
PL/SQL warning settings	4,505	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	17,242	0.01	0.00	0	0
SGA IO buffer pool latch	57	0.00		0	57	0.00
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	90	0.00		0	788	0.00
SQL memory manager workarea list latch	65,812	0.00	0.00	0	0
Shared B-Tree	1,025	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	2,073	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	30,835	1.59	0.00	0	0
active service list	1,189,717	0.02	0.00	0	1,964	0.05
alert log latch	2	0.00		0	0
archive control	140	0.00		0	0
archive process latch	217	0.00		0	0
begin backup scn array	8	0.00		0	0
buffer pool	1	0.00		0	0
business card	661	0.00		0	0
cache buffer handles	3,416	0.00		0	0
cache buffers chains	84,043,441	0.54	0.01	1	5,658,834	0.01
cache buffers lru chain	190,353	0.10	0.00	0	7,026,246	0.06
cache table scan latch	2,068	0.00		0	2,068	0.00
call allocation	13,387	2.70	0.70	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	6,461	0.09	0.00	0	0
channel operations parent latch	1,607,479	0.01	0.01	0	0
checkpoint queue latch	1,153,917	0.00	0.13	0	34,941	0.00
client/application info	21,983	0.00		0	0
compile environment latch	3,042	0.00		0	0
corrupted undo seg latch	264	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	55	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	55	0.00		0	0
dml lock allocation	55	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	6,060	0.07	0.00	0	0
enqueue freelist latch	1	0.00		0	265,693	0.00
enqueue hash chains	447,545	0.06	0.00	0	674	0.00
enqueues	11	0.00		0	0
error message lists	1,640	0.00		0	0
fifth spare latch	1	0.00		0	0
file cache latch	248	0.00		0	0
flashback copy	1	0.00		0	0
fourth Audit Vault latch	1	0.00		0	0
gc element	1,153,544	0.11	0.16	0	33,721	0.03
gc persistent rm	1	0.00		0	0
gcr global ctx	30	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs opaque info freelist	188,560	0.05	0.00	0	0
gcs partitioned table hash	6,327,642	0.30	0.00	0	58,665	0.02
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs remaster request queue	459	0.44	0.00	0	0
gcs remastering latch	468,775	3.50	0.00	0	0
gcs resource freelist	23,541	0.00	0.00	0	80,419	0.00
gcs resource hash	1,460,140	0.04	0.00	0	309	0.00
gcs resource scan list	704	0.00		0	0
gcs shadows freelist	57,065	0.00	0.00	0	106,063	0.00
ges caches resource lists	222,547	0.04	0.03	0	63,240	0.13
ges deadlock list	5,872	0.00		0	0
ges domain table	737,207	0.00	0.00	0	0
ges enqueue table freelist	748,332	0.00	0.00	0	0
ges group table	750,248	0.01	0.00	0	0
ges process hash list	186,585	0.00	0.00	0	0
ges process parent latch	1,541,357	0.00	0.00	0	0
ges process table freelist	5,335	0.43	0.00	0	0
ges resource hash list	1,543,737	0.06	0.01	0	17,918	0.31
ges resource scan list	113	0.00		0	0
ges resource table freelist	26,643	0.00		0	0
ges timeout list	8,287	0.00		0	3,087	0.00
ges value block free list	9	0.00		0	0
global KZLD latch for mem in SGA	2,619	0.00		0	0
global ctx hash table latch	1	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	773	0.00		0	681,569	0.00
hash table modification latch	102	0.00		0	0
heartbeat check	1	0.00		0	760	0.00
heartbeat structure management	0			0	537	0.00
internal temp table object number allocation latch	16	0.00		0	0
interrupt manipulation	3,065	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	22	0.00		0	21	0.00
job_queue_processes free list latch	44	0.00		0	0
job_queue_processes parameter latch	604	0.00		0	0
k2q global data latch	1,790	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kokc descriptor allocation latch	736	0.00		0	0
krbmrosl	2	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	6,247	0.00		0	0
ksim membership request latch	1,606	0.00		0	2,417	0.00
kss move lock	39	0.00		0	0
ksuosstats global area	379	0.00		0	0
ksv allocation latch	130	0.00		0	0
ksv class latch	6,290	0.08	0.20	0	0
ksv instance latch	12	0.00		0	0
ksv msg queue latch	42	0.00		0	41	0.00
ksxp shared latch	5,335	0.36	0.00	0	0
ksxp so latch	5,335	0.11	0.00	0	0
ksz_so allocation latch	5,335	0.79	0.00	0	0
ktm global data	96	0.00		0	0
kwqbsn:qsga	143	0.00		0	0
lgwr LWN SCN	13,048	0.00		0	0
list of block allocation	6,421	0.03	0.00	0	0
loader state object freelist	1,568	0.38	0.00	0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	11	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	1,110	0.00		0	602	0.00
managed standby latch	71	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	10,612	0.01	0.00	0	0
messages	264,652	0.19	0.00	0	0
mostly latch-free SCN	13,262	0.10	0.00	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	82,528	0.00	0.00	0	0
name-service memory objects	14,456	0.00		0	0
name-service namespace bucket	29,090	0.00		0	0
name-service pending queue	7,402	0.00		0	0
name-service request queue	29,265	0.00		0	0
ncodef allocation latch	55	0.00		0	0
object queue header heap	28,760	0.00		0	28,517	0.00
object queue header operation	891,506	0.03	0.01	0	0
object stats modification	177	0.00		0	0
parallel query alloc buffer	7,169	0.00		0	0
parallel query stats	1,332	0.00		0	0
parallel txn reco latch	351	0.00		0	0
parameter list	25,276	0.09	0.00	0	0
parameter table management	45,182	0.04	0.11	0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	229,270	0.09	0.00	0	202,132	0.08
process allocation	16,224	0.41	0.76	0	2,675	0.19
process group creation	5,335	0.41	0.00	0	0
process queue	3,649	0.00		0	0
process queue reference	60,127	0.00		0	5,707	0.00
qmn state object latch	9	0.00		0	0
qmn task context latch	6	0.00		0	0
qmn task queue latch	434	0.23	1.00	0	0
query server freelists	2,983	0.00		0	0
query server process	325	0.00		0	0
queued dump request	9	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	39,315	0.06	0.04	0	253,209	0.12
redo copy	1	0.00		0	253,343	0.23
redo writing	61,115	0.28	0.01	0	0
resmgr group change latch	3,018	0.00		0	0
resmgr:active threads	6,096	0.00		0	0
resmgr:actses change group	3,003	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	6,059	0.71	0.00	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	117	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	10,034,309	0.08	0.00	0	1,482	0.07
rules engine aggregate statistics	25	0.00		0	0
rules engine rule set statistics	50	0.00		0	0
second Audit Vault latch	1	0.00		0	0
second spare latch	1	0.00		0	0
segmented array pool	10	0.00		0	0
sequence cache	13,452	0.02	0.00	0	0
session allocation	17,108	0.01	0.00	0	11,112	0.00
session idle bit	1,571,575	0.00	0.00	0	0
session queue latch	1	0.00		0	0
session state list latch	898	0.00		0	0
session switching	2,711	1.40	0.00	0	0
session timer	903	0.00		0	0
shared pool	5,145,972	0.10	0.14	4	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	339,243	0.00	0.00	0	0
sim partition latch	1	0.00		0	0
simulator hash latch	3,017,141	0.00	0.00	0	0
simulator lru latch	1	0.00		0	2,861,336	1.04
sort extent pool	4,345	0.12	0.00	0	0
space background state object latch	8	0.00		0	0
space background task latch	3,466	0.87	0.00	0	1,798	0.00
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	611	0.16	0.00	0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
third spare latch	1	0.00		0	0
threshold alerts latch	137	0.00		0	0
transaction allocation	567,470	0.00	0.00	0	0
undo global data	78,654	0.04	0.00	0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	84,043,441	453,325	5,458	449,058
shared pool	5,145,972	5,125	736	4,395
gc element	1,153,544	1,310	205	1,108
ges resource hash list	1,543,737	858	11	847
gcs resource hash	1,460,140	653	3	650
call allocation	13,387	362	255	150
object queue header operation	891,506	298	2	296
Lsod array latch	35,517	235	1	234
active service list	1,189,717	206	1	205
redo writing	61,115	171	1	170
ges caches resource lists	222,547	100	3	98
channel operations parent latch	1,607,479	90	1	89
process allocation	16,224	67	51	20
redo allocation	39,315	23	1	22
parameter table management	45,182	18	2	16
checkpoint queue latch	1,153,917	8	1	7
ksv class latch	6,290	5	1	4
qmn task queue latch	434	1	1	0

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
Lsod array latch	kfklsodtablCleanup	1	1
active service list	kswslogon: session logout	3	2
cache buffers chains	kcbgtcr: fast path (cr pin)	1,961	3,028
cache buffers chains	kcbgtcr_2	1,395	1,180
cache buffers chains	kcbgtcr: kslbegin excl	1,263	760
cache buffers chains	kcbzwb	693	491
cache buffers chains	kclcls_3	280	125
cache buffers chains	kcbrls_2	224	204
cache buffers chains	kcbgtcr: fast path	77	2
cache buffers chains	kcbgcur_2	25	11
cache buffers chains	kcbchg1: mod cr pin	14	7
cache buffers chains	kcl_fairness	13	0
cache buffers chains	kcbchg1: clear MS bit	10	60
cache buffers chains	kcbget: fast exchange	10	5
cache buffers chains	kcbrls: fast release	8	28
cache buffers chains	kcbgcur_4	7	4
cache buffers chains	kcbzibmlt: multi-block read: nowait	6	0
cache buffers chains	kcbrls_1	5	4
cache buffers chains	kcbzib: finish processing buffer	3	8
cache buffers chains	kcbnew: new latch again	2	0
cache buffers chains	kclrls	2	20
cache buffers chains	kcbget: fast path	1	0
cache buffers chains	kcbzibmlt: finish free bufs	1	0
cache buffers chains	kclcsr_2	1	0
call allocation	ksuxds	252	247
call allocation	ksudlp: top call	3	7
channel operations parent latch	ksrsconsume()	1	1
checkpoint queue latch	kcbkllrba: compute lowest lrba	1	0
gc element	kclnfndnewm	258	1
gc element	kclchkping	9	0
gc element	kclfwrite1	1	0
gcs resource hash	kjbassume	3	0
ges resource hash list	kjlrlr: remove lock from resource queue	4	4
ges resource hash list	kjrmas1: lookup master node	3	0
ges resource hash list	kjakcai: search for resp by resname	2	1
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	2	0
ges resource table freelist	kjchc: clean resource cache	2	0
ges resource table freelist	kjrchc2: cached obj cleanup	1	0
ksv class latch	ksvclsl: rdp - recycle	1	0
object queue header operation	kcbo_lbufcnt	1	2
object queue header operation	kcbo_link_q	1	1
object queue header operation	kcbo_switch_cq	1	0
parameter table management	ksp_param_table_free	5	0
process allocation	ksucrp:1	49	0
process allocation	ksuapc	2	50
qmn task queue latch	kwqmngettsk: get task	1	1
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
redo writing	kcrfw_post: rba scn pair	1	0
shared pool	kghalo	718	276
shared pool	kghupr1	8	237
shared pool	kghfre	6	25
shared pool	kghalp	3	184
shared pool	kgh_heap_sizes	1	11

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kgllkdl1 85	998
Library Cache	kglhdgn2 106	915
Library Cache	kglget1 1	419
Library Cache	kglpnal2 91	249
Library Cache	kgllkc1 57	133
Library Cache	kglpndl1 95	86
Library Cache	kgldtin1 42	79
Library Cache	kglhdgn1 62	77
Library Cache	kglpin1 4	70
Library Cache	kgllkal1 80	22
Library Cache	kglhdgh1 64	20
Library Cache	kglpnal1 90	20
Library Cache	kglobpn1 71	16
Library Cache	kglrfcl1 79	6
Cursor Pin	kkslce [KKSCHLPIN2]	4
Cursor Pin	kksfbc [KKSCHLFSP2]	2
Library Cache	kglget2 2	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: 92,684,016
Captured Segments account for 88.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TEMPUSICS	TEMPUSICS	ICS_ORDER	TABLE	44,930,960	48.48
TEMPUSICS	TEMPUSICS	POLICY_BASE	TABLE	11,919,776	12.86
TEMPUSICS	TEMPUSICS	ICS_AUTOTICKETTASK	TABLE	5,940,032	6.41
TEMPUSICS	TEMPUSICS	ICS_FANDIAN	TABLE	4,428,864	4.78
TEMPUSICS	TEMPUSICS	ICS_OTHERORDER	TABLE	4,032,976	4.35

Buffer Nowait %:	99.90	Redo NoWait %:	99.96
Buffer Hit %:	99.91	In-memory Sort %:	100.00
Library Hit %:	66.11	Soft Parse %:	51.39
Execute to Parse %:	36.00	Latch Hit %:	99.61
Parse CPU to Parse Elapsd %:	95.61	% Non-Parse CPU:	89.22

Buffer access - local cache %:	99.64
Buffer access - remote cache %:	0.27
Buffer access - disk %:	0.09

Avg global enqueue get time (ms):	1.0
Avg global cache cr block receive time (ms):	32.1
Avg global cache current block receive time (ms):	13.9
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 %:	7.8
Avg global cache cr block flush time (ms):	314.0
Avg global cache current block pin time (ms):	0.2
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	1.2
Avg global cache current block flush time (ms):	364.5

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	8.0
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	72.52
% of indirect sent messages:	27.39
% of flow controlled messages:	0.09

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
TEMPUSICS	TEMPUSICS	POLICY_BASE_FILEID	INDEX	1,647	0.59
TEMPUSICS	TEMPUSICS	POLICY_BASE	TABLE	1,332	0.48
TEMPUSICS	TEMPUSICS	ICS_ORDER	TABLE	1,261	0.45
TEMPUSICS	TEMPUSICS	INDEX456	INDEX	1,231	0.44
TEMPUSICS	TEMPUSICS	POLICY_BASE_ISSTATUS	INDEX	1,039	0.37

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_2550341631_9533	TABLE PARTITION	77	0.03
SYS	SYSAUX	SYS_LOB0000006331C00004$$		LOB	2	0.00

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
TEMPUSICS	TEMPUSICS	OPERATE_LOG_ID	INDEX	16	40.00
TEMPUSICS	TEMPUSICS	OPERATE_LOG_ORDERID	INDEX	14	35.00
TEMPUSICS	TEMPUSICS	ICS_AUTOTICKETTASK	TABLE	6	15.00
TEMPUSICS	TEMPUSICS	OPERATE_LOG_PNR	INDEX	3	7.50
TEMPUSICS	TEMPUSICS	ICS_ORDER_TIME	INDEX	1	2.50

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	AUD$	TABLE	622	87.24
TEMPUSICS	TEMPUSICS	ICS_ORDER	TABLE	34	4.77
TEMPUSICS	TEMPUSICS	ICS_ORDERSTATE	INDEX	12	1.68
TEMPUSICS	TEMPUSICS	OPERATE_LOG_ID	INDEX	11	1.54
TEMPUSICS	TEMPUSICS	ICS_FEIPIAO	TABLE	8	1.12

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	47	2.13	1	1
dc_files	280	0.00	0	8
dc_global_oids	4,146	0.82	0	49
dc_histogram_data	1,149,265	0.15	0	2,056
dc_histogram_defs	1,004,637	0.32	0	2,365
dc_object_grants	258	3.10	0	11
dc_objects	991,877	0.05	3	1,108
dc_profiles	2,641	0.00	0	1
dc_rollback_segments	7,639	0.00	0	42
dc_segments	610,248	0.14	13	568
dc_sequences	2,632	40.46	2,632	0
dc_tablespaces	26,420	0.00	0	8
dc_users	304,795	0.02	0	93
global database name	5,851	0.00	0	1
outstanding_alerts	54	70.37	25	7
sch_lj_oids	4	50.00	0	0

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	5,237	0.06	0		0	0
APP CONTEXT	1	0.00	7	0.00	0	0
BODY	967	2.59	10,387	0.40	15	0
CLUSTER	104	4.81	106	4.72	0	0
DBLINK	5,249	0.00	0		0	0
EDITION	2,651	0.00	5,289	0.00	0	0
INDEX	94	25.53	94	25.53	0	0
QUEUE	633	0.00	9,006	0.01	0	0
RULESET	0		25	0.00	0	0
SCHEMA	3,154	0.03	0		0	0
SQL AREA	167,802	48.71	479,942	52.22	2,400	15
SQL AREA BUILD	84,105	99.49	0		0	0
SQL AREA STATS	83,807	98.96	83,807	98.96	0	0
SUBSCRIPTION	7	14.29	7	14.29	0	0
TABLE/PROCEDURE	93,280	0.25	391,234	0.59	1,302	0
TRIGGER	5,272	0.08	11,272	0.05	2	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,624.00	2,624.00	2,400.00	2,880.00	GRO/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,552.00	3,552.00	3,296.00	3,776.00	SHR/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	670.62		3.06	5.71	43	43	219	219
B	Freeable	106.88	0.00	1.91	3.87	19		56	56
B	SQL	43.97	41.67	0.24	2.94	40	366	185	178
B	PL/SQL	11.51	3.07	0.05	0.24	2	2	217	217
E	Other	761.29		3.12	5.40	43	43	244	244
E	Freeable	104.13	0.00	1.76	3.80	19		59	59
E	SQL	87.10	84.09	0.42	2.81	40	366	209	201
E	PL/SQL	12.12	3.44	0.05	0.22	2	2	242	242

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,751,463,424
Fixed Size	2,237,048
Redo Buffers	19,619,840
Variable Size	7,314,869,640

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	35.53		-100.00
shared	KGLH0	710.39	709.84	-0.08
shared	KGLHD	145.70	145.09	-0.42
shared	SQLA	1,453.20	1,453.86	0.05
shared	free memory	595.53	596.28	0.13
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,624.00	2,624.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	2,739	0.00	100.00
D000	2,739	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)	8,836	3.43	1.09
acks for commit broadcast(logical)	9,086	3.52	1.12
broadcast msgs on commit(actual)	10,976	4.26	1.35
broadcast msgs on commit(logical)	12,490	4.84	1.54
broadcast msgs on commit(wasted)	987	0.38	0.12
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	1	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	33,929	13.16	4.19
gcs ast xid	3	0.00	0.00
gcs blocked converts	18,574	7.20	2.29
gcs blocked cr converts	23,300	9.04	2.87
gcs compatible basts	37	0.01	0.00
gcs compatible cr basts (global)	5,592	2.17	0.69
gcs compatible cr basts (local)	74,577	28.93	9.20
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	3,732	1.45	0.46
gcs dbwr write request msgs	3,417	1.33	0.42
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	1	0.00	0.00
gcs force cr block only	12	0.00	0.00
gcs force cr grant	0	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	782	0.30	0.10
gcs immediate (null) converts	3,860	1.50	0.48
gcs immediate cr (compatible) converts	72	0.03	0.01
gcs immediate cr (null) converts	7,005	2.72	0.86
gcs indirect ast	5,342	2.07	0.66
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	5,342	2.07	0.66
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	1,226	0.48	0.15
gcs msgs process time(ms)	7,383	2.86	0.91
gcs msgs received	376,321	145.96	46.42
gcs new served by master	366	0.14	0.05
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	161	0.06	0.02
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	139	0.05	0.02
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	8	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,012	3.88	1.24
gcs side channel msgs logical	120,726	46.83	14.89
gcs stale cr	0	0.00	0.00
gcs undo cr	801	0.31	0.10
gcs write notification msgs	162	0.06	0.02
gcs writes refused	45	0.02	0.01
ges msgs process time(ms)	793	0.31	0.10
ges msgs received	30,579	11.86	3.77
global posts dropped	0	0.00	0.00
global posts queue time	499	0.19	0.06
global posts queued	45	0.02	0.01
global posts requested	47	0.02	0.01
global posts sent	45	0.02	0.01
implicit batch messages received	8,488	3.29	1.05
implicit batch messages sent	2,070	0.80	0.26
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	133	0.05	0.02
messages queue sent actual	43,283	16.79	5.34
messages queue sent logical	5,056	1.96	0.62
messages received actual	186,151	72.20	22.96
messages received logical	406,918	157.83	50.20
messages sent directly	109,540	42.49	13.51
messages sent indirectly	41,372	16.05	5.10
messages sent not implicit batched	0	0.00	0.00
messages sent pbatched	109,829	42.60	13.55
msgs causing lmd to send msgs	11,022	4.28	1.36
msgs causing lms(s) to send msgs	11,618	4.51	1.43
msgs received queue time (ms)	23,381	9.07	2.88
msgs received queued	406,940	157.84	50.20
msgs sent queue time (ms)	758	0.29	0.09
msgs sent queue time on ksxp (ms)	1,413,516	548.26	174.38
msgs sent queued	46,137	17.90	5.69
msgs sent queued on ksxp	176,620	68.51	21.79
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	51,954	20.15	6.41
process batch messages sent	43,052	16.70	5.31

Statistic	Total
CR Block Requests	23,420
CURRENT Block Requests	3,131
Data Block Requests	23,425
Undo Block Requests	806
TX Block Requests	476
Current Results	24,414
Private results	11
Zero Results	1,886
Disk Read Results	0
Fail Results	0
Fairness Down Converts	11,639
Fairness Clears	919
Free GC Elements	0
Flushes	2,016
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	1,575
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	638	48.28	34.48	9.09	7.99	0.16
Flushes	1,596	3.51	5.08	20.68	61.72	9.02
Writes	5,313	7.43	16.85	25.60	42.89	7.23

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	18,895	92.28	7.16	0.57	90,368	93.11	4.45	2.43
2	Others	1,825	95.73	3.89	0.38	1,411	99.08	0.43	0.50
2	undo block	746	86.19	13.67	0.13	0
2	undo header	599	83.81	16.03	0.17	64	73.44	26.56	0.00

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

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	31.36	0.25	435.08	0.26	14.54	0.34	319.13	0.71
2	others	17.75	0.26	449.82	0.23	0.25	0.25	0.36	0.32
2	undo block	68.00	0.26	495.66	0.25
2	undo header	57.07	0.22	354.92	0.19	85.67	0.23	321.88

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	17,436	100.00	0.00	84,144	100.00	0.00
2	others	0	1,747	100.00	0.00	1,398	100.00	0.00
2	undo block	0	643	100.00	0.00	0
2	undo header	0	502	100.00	0.00	47	100.00	0.00

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.46	0.28
Parallel Query	0.00	0.00
DB Locks	0.03	0.04
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	70,482	70,482.00
replayed locks sent	0	0.00
resources cleaned	0	0.00
remaster time (s)	1.9	1.87
quiesce time (s)	0.1	0.13
freeze time (s)	0.0	0.03
cleanup time (s)	0.0	0.01
replay time (s)	0.1	0.08
fixwrite time (s)	0.0	0.02
sync time (s)	1.6	1.59
affinity objects			9	10