/home/oracle [cc1] >cat awrrpt_1_16273_16274.html AWR Report for DB: CC, Inst: cc1, Snaps: 16273-16274

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

CC 2038674490 cc1 1 24-Nov-13 15:11 11.2.0.4.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
CC	2038674490	cc1	1	24-Nov-13 15:11	11.2.0.4.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

PRQMRAC01 Linux x86 64-bit 32 16 2 126.00

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
PRQMRAC01	Linux x86 64-bit	32	16	2	126.00

Snap Id Snap Time Sessions Cursors/Session Instances

Begin Snap: 16273 31-Aug-15 18:00:33 200 10.0 2

End Snap: 16274 31-Aug-15 19:00:06 203 11.7 2

Elapsed: 59.55 (mins)

DB Time: 234.30 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	16273	31-Aug-15 18:00:33	200	10.0	2
End Snap:	16274	31-Aug-15 19:00:06	203	11.7	2
Elapsed:		59.55 (mins)
DB Time:		234.30 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 3.9 0.1 0.01 0.01

DB CPU(s): 3.0 0.1 0.01 0.00

Redo size (bytes): 47,015.1 1,357.9

Logical read (blocks): 993,071.3 28,681.4

Block changes: 280.5 8.1

Physical read (blocks): 82,133.6 2,372.1

Physical write (blocks): 11.2 0.3

Read IO requests: 816.1 23.6

Write IO requests: 8.9 0.3

Read IO (MB): 641.7 18.5

Write IO (MB): 0.1 0.0

Global Cache blocks received: 73.6 2.1

Global Cache blocks served: 149.8 4.3

User calls: 694.3 20.1

Parses (SQL): 304.3 8.8

Hard parses (SQL): 0.7 0.0

SQL Work Area (MB): 16.6 0.5

Logons: 0.2 0.0

Executes (SQL): 558.5 16.1

Rollbacks: 0.0 0.0

Transactions: 34.6

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	3.9	0.1	0.01	0.01
DB CPU(s):	3.0	0.1	0.01	0.00
Redo size (bytes):	47,015.1	1,357.9
Logical read (blocks):	993,071.3	28,681.4
Block changes:	280.5	8.1
Physical read (blocks):	82,133.6	2,372.1
Physical write (blocks):	11.2	0.3
Read IO requests:	816.1	23.6
Write IO requests:	8.9	0.3
Read IO (MB):	641.7	18.5
Write IO (MB):	0.1	0.0
Global Cache blocks received:	73.6	2.1
Global Cache blocks served:	149.8	4.3
User calls:	694.3	20.1
Parses (SQL):	304.3	8.8
Hard parses (SQL):	0.7	0.0
SQL Work Area (MB):	16.6	0.5
Logons:	0.2	0.0
Executes (SQL):	558.5	16.1
Rollbacks:	0.0	0.0
Transactions:	34.6

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.51 Soft Parse %: 99.76

Execute to Parse %: 45.50 Latch Hit %: 99.73

Parse CPU to Parse Elapsd %: 45.09 % Non-Parse CPU: 99.80

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		10.7K		76.2
direct path read	731,398	1046.8	1	7.4	User I/O
SQL*Net message from dblink	774	866.6	1120	6.2	Network
db file sequential read	160,648	610.7	4	4.3	User I/O
log file sync	122,841	382.7	3	2.7	Commit
gc cr block busy	20,075	88.6	4	.6	Cluster
gc current block 2-way	103,470	42.6	0	.3	Cluster
db file scattered read	19,081	31.5	2	.2	User I/O
gc cr block 2-way	51,209	21.8	0	.2	Cluster
gc buffer busy acquire	18,731	21.4	1	.2	Cluster

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
DB CPU		10,712		76.2	3.0
User I/O	1,319,755	1,903	1	13.5	0.5
Network	2,391,910	869	0	6.2	0.2
Commit	122,843	383	3	2.7	0.1
System I/O	173,741	327	2	2.3	0.1
Cluster	279,520	221	1	1.6	0.1
Other	237,347	68	0	.5	0.0
Application	13,303	33	3	.2	0.0
Concurrency	50,921	5	0	.0	0.0
Configuration	74	0	3	.0	0.0

Host CPU

CPUs Cores Sockets Load Average Begin Load Average End %User %System %WIO %Idle

32 16 2 4.22 3.54 10.7 0.9 3.2 88.2

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
32	16	2	4.22	3.54	10.7	0.9	3.2	88.2

Instance CPU

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

9.7 82.3 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 917.3 819.5 97.8

Database Requests: 825.0 816.1 8.9

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 75.0 0.1 74.9

Total (MB): 645.2 641.8 3.5

Database (MB): 641.8 641.7 0.1

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 0.2 0.1 0.1

Database (blocks): 82,144.8 82,133.6 11.2

Via Buffer Cache (blocks): 89.2 78.4 10.8

Direct (blocks): 82,055.6 82,055.2 0.4

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	917.3	819.5	97.8
Database Requests:	825.0	816.1	8.9
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	75.0	0.1	74.9
Total (MB):	645.2	641.8	3.5
Database (MB):	641.8	641.7	0.1
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	0.2	0.1	0.1
Database (blocks):	82,144.8	82,133.6	11.2
Via Buffer Cache (blocks):	89.2	78.4	10.8
Direct (blocks):	82,055.6	82,055.2	0.4

Memory Statistics

Begin End

Host Mem (MB): 129,024.0 129,024.0

SGA use (MB): 3,472.6 3,472.6

PGA use (MB): 1,070.4 1,060.7

% Host Mem used for SGA+PGA: 3.52 3.51

	Begin	End
Host Mem (MB):	129,024.0	129,024.0
SGA use (MB):	3,472.6	3,472.6
PGA use (MB):	1,070.4	1,060.7
% Host Mem used for SGA+PGA:	3.52	3.51

Cache Sizes

Begin End

Buffer Cache: 1,472M 1,472M Std Block Size: 8K

Shared Pool Size: 1,208M 1,190M Log Buffer: 14,752K

	Begin	End
Buffer Cache:	1,472M	1,472M	Std Block Size:	8K
Shared Pool Size:	1,208M	1,190M	Log Buffer:	14,752K

Shared Pool Statistics

Begin End

Memory Usage %: 94.81 93.59

% SQL with executions>1: 93.57 89.69

% Memory for SQL w/exec>1: 88.20 75.17

	Begin	End
Memory Usage %:	94.81	93.59
% SQL with executions>1:	93.57	89.69
% Memory for SQL w/exec>1:	88.20	75.17

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): 14058.2s
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	13,515.73	96.14
DB CPU	10,711.56	76.19
parse time elapsed	42.89	0.31
hard parse elapsed time	16.07	0.11
PL/SQL execution elapsed time	6.69	0.05
sequence load elapsed time	2.18	0.02
hard parse (sharing criteria) elapsed time	0.99	0.01
connection management call elapsed time	0.93	0.01
repeated bind elapsed time	0.39	0.00
PL/SQL compilation elapsed time	0.26	0.00
hard parse (bind mismatch) elapsed time	0.06	0.00
failed parse elapsed time	0.01	0.00
DB time	14,058.22
background elapsed time	847.29
background cpu time	332.19

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	1,341,448
IDLE_TIME	10,059,523
IOWAIT_TIME	361,710
NICE_TIME	0
SYS_TIME	104,310
USER_TIME	1,219,507
LOAD	4	4
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	135,291,449,344
NUM_CPUS	32
NUM_CPU_CORES	16
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	262,144
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	262,144
TCP_SEND_SIZE_MAX	262,144
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
31-Aug 18:00:33	4.22
31-Aug 19:00:06	3.54	11.77	10.70	0.91	88.23	3.17

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 99.1% of Total DB time 14,058.22 (s)
Total FG Wait Time: 3,216.63 (s) DB CPU time: 10,711.56 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			10,712		76.19
User I/O	914,510	0	1,697	2	12.07
Network	2,391,311	0	869	0	6.18
Commit	122,841	0	383	3	2.72
Cluster	274,559	0	219	1	1.56
Application	10,920	0	30	3	0.21
Other	30,999	44	16	1	0.11
Concurrency	9,414	0	3	0	0.02
System I/O	964	0	1	1	0.00
Configuration	72	89	0	3	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
direct path read	731,398	0	1,047	1	5.91	7.45
SQL*Net message from dblink	774	0	867	1120	0.01	6.16
db file sequential read	160,648	0	611	4	1.30	4.34
log file sync	122,841	0	383	3	0.99	2.72
gc cr block busy	20,075	0	89	4	0.16	0.63
gc current block 2-way	103,470	0	43	0	0.84	0.30
db file scattered read	19,081	0	31	2	0.15	0.22
gc cr block 2-way	51,209	0	22	0	0.41	0.16
gc buffer busy acquire	18,731	0	21	1	0.15	0.15
enq: KO - fast object checkpoint	9,887	0	17	2	0.08	0.12
gc cr multi block request	21,902	0	14	1	0.18	0.10
enq: TX - row lock contention	271	0	12	46	0.00	0.09
gc current grant busy	21,995	0	11	0	0.18	0.08
reliable message	4,986	0	11	2	0.04	0.08
gc cr grant 2-way	22,635	0	8	0	0.18	0.05
gc current block busy	1,620	0	6	4	0.01	0.05
db file parallel read	1,095	0	5	5	0.01	0.04
read by other session	917	0	3	3	0.01	0.02
gc current grant 2-way	7,644	0	3	0	0.06	0.02
SQL*Net message to client	2,389,404	0	2	0	19.31	0.01
enq: PS - contention	599	5	1	2	0.00	0.01
row cache lock	4,875	0	1	0	0.04	0.01
library cache pin	1,579	0	1	0	0.01	0.01
name-service call wait	13	0	1	57	0.00	0.01
gc current block congested	1,636	0	1	0	0.01	0.01
enq: TX - index contention	61	0	1	12	0.00	0.01
rdbms ipc reply	5,436	0	1	0	0.04	0.00
gc cr disk read	2,041	0	1	0	0.02	0.00
enq: TQ - DDL contention	3	0	1	170	0.00	0.00
control file sequential read	917	0	0	0	0.01	0.00
DFS lock handle	717	0	0	1	0.01	0.00
gc cr block congested	835	0	0	0	0.01	0.00
PX Deq: Slave Session Stats	1,508	0	0	0	0.01	0.00
direct path write	197	0	0	2	0.00	0.00
enq: SV - contention	1,030	0	0	0	0.01	0.00
library cache lock	737	0	0	0	0.01	0.00
gc buffer busy release	123	0	0	2	0.00	0.00
kupp process wait	2	100	0	101	0.00	0.00
os thread startup	4	0	0	46	0.00	0.00
enq: IV - contention	314	12	0	1	0.00	0.00
log file switch completion	2	0	0	80	0.00	0.00
gc cr grant congested	409	0	0	0	0.00	0.00
buffer busy waits	1,208	0	0	0	0.01	0.00
IPC send completion sync	602	0	0	0	0.00	0.00
PX Deq: Signal ACK RSG	1,042	0	0	0	0.01	0.00
Disk file operations I/O	821	0	0	0	0.01	0.00
ASM file metadata operation	5	0	0	18	0.00	0.00
PX Deq: reap credit	13,548	100	0	0	0.11	0.00
gcs drm freeze in enter server mode	2	0	0	44	0.00	0.00
gc current grant congested	154	0	0	0	0.00	0.00
SQL*Net break/reset to client	722	0	0	0	0.01	0.00
enq: UL - contention	3	0	0	16	0.00	0.00
control file single write	32	0	0	1	0.00	0.00
PX Deq: Signal ACK EXT	981	0	0	0	0.01	0.00
enq: CR - block range reuse ckpt	7	0	0	5	0.00	0.00
gc current multi block request	62	0	0	1	0.00	0.00
control file parallel write	15	0	0	2	0.00	0.00
enq: HW - contention	64	100	0	0	0.00	0.00
latch: cache buffers chains	899	0	0	0	0.01	0.00
enq: RO - fast object reuse	18	0	0	1	0.00	0.00
cursor: pin S	13	0	0	2	0.00	0.00
CRS call completion	4	0	0	4	0.00	0.00
enq: PI - contention	2	100	0	7	0.00	0.00
enq: FB - contention	24	0	0	0	0.00	0.00
enq: TM - contention	19	0	0	0	0.00	0.00
gc current split	14	0	0	0	0.00	0.00
enq: TT - contention	14	0	0	0	0.00	0.00
CSS initialization	4	0	0	1	0.00	0.00
latch free	34	0	0	0	0.00	0.00
latch: ges resource hash list	21	0	0	0	0.00	0.00
SQL*Net more data to client	301	0	0	0	0.00	0.00
enq: SQ - contention	1	0	0	3	0.00	0.00
enq: TX - allocate ITL entry	5	0	0	0	0.00	0.00
CSS operation: action	4	0	0	1	0.00	0.00
SQL*Net more data from client	64	0	0	0	0.00	0.00
utl_file I/O	345	0	0	0	0.00	0.00
enq: TS - contention	6	0	0	0	0.00	0.00
global enqueue expand wait	25	0	0	0	0.00	0.00
SQL*Net message from client	2,389,400	0	266,398	111	19.31
wait for unread message on broadcast channel	958	43	558	582	0.01
jobq slave wait	720	100	361	501	0.01
PL/SQL lock timer	49	100	5	105	0.00
PX Deq: Execution Msg	2,283	0	3	1	0.02
PX Deq: Join ACK	1,069	0	1	1	0.01
PX Deq: Parse Reply	1,069	0	1	1	0.01
single-task message	5	0	0	73	0.00
PX Deq: Execute Reply	1,069	0	0	0	0.01

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	133,191	0	300	2	1.08	35.43
db file sequential read	343,577	0	139	0	2.78	16.45
direct path read	14,749	0	50	3	0.12	5.91
gcs log flush sync	24,001	1	38	2	0.19	4.49
db file parallel write	18,857	0	15	1	0.15	1.80
Datapump dump file I/O	45,584	0	11	0	0.37	1.30
Streams AQ: qmn coordinator waiting for slave to start	1	100	6	6221	0.00	0.73
control file sequential read	10,934	0	5	0	0.09	0.56
control file parallel write	1,601	0	4	2	0.01	0.46
db file scattered read	593	0	4	6	0.00	0.45
enq: KO - fast object checkpoint	2,344	0	4	2	0.02	0.43
reliable message	296	1	2	8	0.00	0.28
log file sequential read	134	0	2	13	0.00	0.21
enq: WF - contention	13	0	1	102	0.00	0.16
db file parallel read	224	0	1	6	0.00	0.15
DFS lock handle	1,025	98	1	1	0.01	0.09
gc cr grant 2-way	2,079	0	1	0	0.02	0.08
os thread startup	35	0	1	18	0.00	0.08
ASM file metadata operation	1,486	0	0	0	0.01	0.05
gc cr block 2-way	985	0	0	0	0.01	0.05
ges inquiry response	1,263	0	0	0	0.01	0.05
enq: TQ - TM contention	2	0	0	192	0.00	0.05
Log archive I/O	104	0	0	4	0.00	0.04
CGS wait for IPC msg	30,928	100	0	0	0.25	0.04
name-service call wait	6	0	0	48	0.00	0.03
library cache pin	963	0	0	0	0.01	0.03
library cache lock	806	0	0	0	0.01	0.03
direct path write	343	0	0	1	0.00	0.03
row cache process	64,548	0	0	0	0.52	0.03
gc cr multi block request	498	0	0	0	0.00	0.03
row cache lock	931	0	0	0	0.01	0.03
gc current block 2-way	576	0	0	0	0.00	0.03
gc current grant 2-way	537	0	0	0	0.00	0.03
direct path sync	2	0	0	94	0.00	0.02
ksxr poll remote instances	30,288	100	0	0	0.24	0.02
gc cr block busy	32	0	0	6	0.00	0.02
row cache cleanup	47,955	0	0	0	0.39	0.02
gc current block busy	41	0	0	3	0.00	0.02
ges lms sync during dynamic remastering and reconfig	48	0	0	2	0.00	0.01
ges generic event	8	100	0	10	0.00	0.01
gc cr disk read	106	0	0	0	0.00	0.00
enq: TX - index contention	1	0	0	34	0.00	0.00
enq: CF - contention	87	91	0	0	0.00	0.00
ADR block file read	16	0	0	2	0.00	0.00
log file single write	4	0	0	8	0.00	0.00
gc current grant busy	34	0	0	1	0.00	0.00
gc buffer busy release	16	0	0	2	0.00	0.00
libcache interrupt action by LCK	38,636	0	0	0	0.31	0.00
enq: TX - allocate ITL entry	1	0	0	25	0.00	0.00
enq: IV - contention	40	10	0	1	0.00	0.00
PX Deq: reap credit	3,309	100	0	0	0.03	0.00
enq: PS - contention	45	29	0	0	0.00	0.00
kfk: async disk IO	3	0	0	6	0.00	0.00
CRS call completion	4	0	0	4	0.00	0.00
enq: TM - contention	39	0	0	0	0.00	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	14	0	0	1	0.00	0.00
enq: TT - contention	35	51	0	0	0.00	0.00
ges LMON to get to FTDONE	5	0	0	2	0.00	0.00
gc cr grant congested	27	0	0	0	0.00	0.00
db file async I/O submit	7,962	0	0	0	0.06	0.00
Disk file operations I/O	178	0	0	0	0.00	0.00
LGWR wait for redo copy	247	0	0	0	0.00	0.00
PX Deq: Slave Session Stats	60	0	0	0	0.00	0.00
CSS operation: action	14	0	0	0	0.00	0.00
CSS initialization	4	0	0	2	0.00	0.00
PX Deq: Signal ACK RSG	60	0	0	0	0.00	0.00
gc cr block congested	12	0	0	0	0.00	0.00
IPC send completion sync	34	0	0	0	0.00	0.00
gc current multi block request	11	0	0	0	0.00	0.00
log file sync	2	0	0	2	0.00	0.00
gc current split	2	0	0	2	0.00	0.00
enq: TD - KTF dump entries	12	0	0	0	0.00	0.00
latch: ges resource hash list	56	0	0	0	0.00	0.00
gc current grant congested	8	0	0	0	0.00	0.00
rdbms ipc reply	10	0	0	0	0.00	0.00
enq: TA - contention	6	0	0	0	0.00	0.00
buffer busy waits	79	0	0	0	0.00	0.00
latch: cache buffers chains	19	0	0	0	0.00	0.00
enq: SR - contention	6	100	0	0	0.00	0.00
CSS group registration	2	0	0	1	0.00	0.00
PX Deq: Signal ACK EXT	60	0	0	0	0.00	0.00
latch free	56	0	0	0	0.00	0.00
enq: PI - contention	4	100	0	0	0.00	0.00
gc current block congested	4	0	0	0	0.00	0.00
asynch descriptor resize	238	100	0	0	0.00	0.00
enq: AE - lock	3	0	0	0	0.00	0.00
latch: messages	9	0	0	0	0.00	0.00
rdbms ipc message	379,786	22	96,208	253	3.07
gcs remote message	1,150,951	16	10,630	9	9.30
class slave wait	369	0	7,747	20995	0.00
wait for unread message on broadcast channel	7,296	88	7,149	980	0.06
DIAG idle wait	48,642	77	7,139	147	0.39
Streams AQ: qmn slave idle wait	258	1	4,928	19100	0.00
Space Manager: slave idle wait	971	99	4,815	4959	0.01
Streams AQ: waiting for time management or cleanup tasks	3	33	4,236	1412068	0.00
PX Idle Wait	577	0	3,806	6596	0.00
ASM background timer	747	0	3,574	4785	0.01
Streams AQ: qmn coordinator idle wait	327	48	3,574	10930	0.00
PING	1,514	19	3,574	2361	0.01
pmon timer	1,192	100	3,572	2997	0.01
GCR sleep	714	100	3,571	5001	0.01
ges remote message	93,627	32	3,570	38	0.76
smon timer	769	0	3,565	4637	0.01
SQL*Net message from client	796	0	1	1	0.01
KSV master wait	2,302	94	0	0	0.02
PX Deq: Parse Reply	60	0	0	1	0.00
PX Deq: Join ACK	60	0	0	1	0.00
PX Deq: Execute Reply	60	0	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	365	100	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	16	62.5	6.3	18.8	6.3	6.3
ADR block file write	5	100.0
ADR file lock	6	100.0
ARCH wait for archivelog lock	1	100.0
ASM file metadata operation	1493	99.1	.2	.1	.2	.1	.3	.1
CGS wait for IPC msg	30.9K	100.0
CRS call completion	8	50.0	12.5		12.5	25.0
CSS group membership query	2	100.0
CSS group registration	2		100.0
CSS initialization	10	50.0		50.0
CSS operation: action	20	95.0	5.0
CSS operation: query	30	100.0
DFS lock handle	1742	98.4	1.0	.2		.1		.3
Data Pump slave startup	1	100.0
Datapump dump file I/O	45.6K	99.7	.2	.0	.0	.0	.0
Disk file operations I/O	1025	98.8	.5	.1	.4	.2
IPC send completion sync	636	98.6	1.4
LGWR wait for redo copy	247	100.0
Log archive I/O	104	14.4	26.9	25.0	22.1	11.5
PX Deq: Signal ACK EXT	1041	100.0
PX Deq: Signal ACK RSG	1102	99.4	.5		.1
PX Deq: Slave Session Stats	1568	98.2	1.7	.1
PX Deq: reap credit	16.9K	100.0
PX qref latch	1	100.0
SQL*Net break/reset to client	722	99.4		.3		.3
SQL*Net message from dblink	768	4.6	21.7	22.5	12.1	10.5	2.7	12.9	12.9
SQL*Net message to client	2390.3K	100.0	.0
SQL*Net message to dblink	762	100.0
SQL*Net more data from client	65	100.0
SQL*Net more data to client	302	100.0
Streams AQ: qmn coordinator waiting for slave to start	1								100.0
asynch descriptor resize	238	100.0
buffer busy waits	1291	99.5	.1	.2	.1	.2
buffer deadlock	22	100.0
control file parallel write	1616	12.4	53.4	30.6	1.6	.9	.5	.7
control file sequential read	11.9K	97.1	1.1	.5	.8	.4	.1	.0
control file single write	32	37.5	31.3	31.3
cursor: pin S	13	84.6				15.4
db file async I/O submit	7968	100.0
db file parallel read	1319	63.8	2.4	1.3	10.2	16.4	4.2	1.7
db file parallel write	18.9K	77.2	16.1	5.4	.7	.2	.2	.2
db file scattered read	19.7K	80.2	3.3	2.1	7.5	5.6	.9	.3
db file sequential read	504.3K	83.8	1.1	1.9	8.0	4.4	.7	.2
direct path read	745.6K	55.1	25.3	14.6	3.7	.9	.3	.2
direct path sync	2					50.0		50.0
direct path write	541	57.5	25.7	15.3	.7	.6	.2
enq: AE - lock	4	100.0
enq: AF - task serialization	1	100.0
enq: AS - service activation	2	100.0
enq: CF - contention	89	100.0
enq: CR - block range reuse ckpt	7	14.3		14.3	57.1	14.3
enq: DR - contention	2	100.0
enq: FB - contention	24	95.8	4.2
enq: HW - contention	64	96.9	3.1
enq: IV - contention	354	92.1	7.6	.3
enq: KO - fast object checkpoint	12.2K	89.0	3.4	1.8	.9	2.1	2.0	.9
enq: PE - contention	2	100.0
enq: PI - contention	6	83.3				16.7
enq: PS - contention	644	91.5	3.1	.8	.9	.8	1.7	1.2
enq: RO - fast object reuse	18	66.7	22.2	5.6		5.6
enq: SQ - contention	1			100.0
enq: SR - contention	6	100.0
enq: SV - contention	1030	99.0	1.0
enq: TA - contention	6	83.3	16.7
enq: TD - KTF dump entries	12	100.0
enq: TM - contention	61	98.4		1.6
enq: TO - contention	1	100.0
enq: TQ - DDL contention	5	60.0					20.0	20.0
enq: TQ - TM contention	2							100.0
enq: TS - contention	6	100.0
enq: TT - contention	49	100.0
enq: TX - allocate ITL entry	7	85.7					14.3
enq: TX - index contention	68	50.0			4.4	8.8	23.5	13.2
enq: TX - row lock contention	271	2.6	3.0	1.8	8.1	15.1	20.7	48.7
enq: UL - contention	3	66.7						33.3
enq: WF - contention	13	84.6	7.7						7.7
enq: WL - contention	1	100.0
enq: ZH - compression analysis	2	100.0
gc buffer busy acquire	18.7K	80.9	6.7	7.9	3.3	.7	.2	.2
gc buffer busy release	140	49.3	26.4	15.7	6.4	.7	.7	.7
gc cr block 2-way	52.2K	98.7	.9	.3	.1	.0	.0
gc cr block busy	20.1K	.6	13.4	55.6	26.8	1.8	.8	1.0
gc cr block congested	848	97.9	1.5	.6
gc cr disk read	2149	99.5	.5
gc cr grant 2-way	24.8K	99.2	.7	.1	.0
gc cr grant congested	436	99.1	.7	.2
gc cr multi block request	22.4K	90.7	6.7	1.4	1.1	.0	.0	.0
gc current block 2-way	104.1K	98.7	1.0	.2	.0	.0		.0
gc current block busy	1684	16.9	21.6	38.4	17.0	3.5	1.4	1.2
gc current block congested	1642	98.5	1.3	.2	.1
gc current grant 2-way	8212	98.4	1.0	.5	.0
gc current grant busy	22.1K	98.2	1.3	.3	.1	.0	.0	.0
gc current grant congested	163	98.8	1.2
gc current multi block request	73	97.3	2.7
gc current retry	4	100.0
gc current split	22	86.4		13.6
gcs drm freeze in enter server mode	2					50.0		50.0
gcs log flush sync	24K	44.1	24.8	28.0	2.4	.4	.3
ges LMON to get to FTDONE	5		40.0	60.0
ges generic event	8					100.0
ges inquiry response	1263	99.0	.8	.2
ges lms sync during dynamic remastering and reconfig	48	22.9	39.6	29.2	8.3
global enqueue expand wait	25	100.0
kfk: async disk IO	3			33.3	33.3	33.3
kjbdrmcvtq lmon drm quiesce: ping completion	14	57.1	7.1	35.7
ksxr poll remote instances	30.4K	100.0
kupp process wait	2							100.0
latch free	90	100.0
latch: cache buffers chains	918	99.8	.2
latch: cache buffers lru chain	3	100.0
latch: enqueue hash chains	4	100.0
latch: gc element	21	100.0
latch: gcs resource hash	3	100.0
latch: ges resource hash list	77	98.7	1.3
latch: messages	9	100.0
latch: redo allocation	6	100.0
latch: redo writing	2	100.0
latch: row cache objects	10	100.0
latch: shared pool	11	100.0
libcache interrupt action by LCK	38.7K	100.0
library cache lock	1547	98.6	1.2	.1	.1
library cache pin	2547	99.2	.6	.1				.0
library cache: mutex X	54	100.0
lock deadlock retry	1	100.0
lock escalate retry	1	100.0
log file parallel write	133.2K	18.9	31.7	46.6	2.1	.4	.2	.2
log file sequential read	134	14.2	9.0	13.4	25.4	17.2	9.7	11.2
log file single write	4		50.0		25.0		25.0
log file switch completion	2							100.0
log file sync	122.8K	1.4	31.8	53.6	11.8	.7	.3	.4
name-service call wait	19				5.3	21.1	15.8	57.9
os thread startup	39					82.1	5.1	12.8
rdbms ipc reply	5446	99.5	.4	.1
read by other session	917	59.9	4.1	4.7	19.6	9.7	1.4	.5
reliable message	5281	23.9	67.6	7.7	.4	.1	.1	.1	.0
row cache cleanup	48.1K	100.0	.0
row cache lock	5846	99.2	.7	.1	.0
row cache process	64.8K	100.0
utl_file I/O	345	100.0
ASM background timer	748	2.7	.1	.1	.5	.3		.3	96.0
DIAG idle wait	48.7K	21.6	.4	.3	.0	3.1	3.1	71.5
GCR sleep	715								100.0
KSV master wait	2311	99.6	.1	.0	.1	.0		.1
PING	1514	81.1	.1			.1			18.8
PL/SQL lock timer	49							100.0
PX Deq Credit: send blkd	8	100.0
PX Deq: Execute Reply	1129	99.2	.6	.1	.1
PX Deq: Execution Msg	2283	77.2	18.1	2.1	1.2	1.0	.0	.3
PX Deq: Join ACK	1129	70.9	26.0	2.5	.2	.1	.1	.2
PX Deq: Parse Reply	1129	90.7	8.1	1.0		.1		.1
PX Idle Wait	571	4.2	20.5	18.2	4.7	2.3	4.9	28.7	16.5
SQL*Net message from client	2392.2K	62.8	27.8	5.8	.6	.2	.4	1.9	.5
Space Manager: slave idle wait	970			.1		.2		.2	99.5
Streams AQ: RAC qmn coordinator idle wait	365	100.0
Streams AQ: qmn coordinator idle wait	327	51.7							48.3
Streams AQ: qmn slave idle wait	257								100.0
Streams AQ: waiting for time management or cleanup tasks	3	33.3						33.3	33.3
class slave wait	407	43.0	.5	1.2	5.4	19.4	2.5	1.7	26.3
gcs remote message	1152.3K	31.8	9.9	11.2	12.4	11.0	23.7	.0
ges remote message	93.7K	50.0	2.8	2.1	1.7	2.3	2.9	38.3
jobq slave wait	720							100.0
pmon timer	1193							.2	99.8
rdbms ipc message	379.8K	48.5	5.3	6.9	1.6	1.9	2.5	27.7	5.5
single-task message	5							100.0
smon timer	770				.3	6.2		.5	93.0
wait for unread message on broadcast channel	8254	1.2	1.5	.3	.0	.8	.6	95.4

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	1	99.9			.1
DFS lock handle	6	99.7	.1	.2
SQL*Net message from dblink	103	74.2		.1	.8	8.6	3.4	.5	12.4
control file parallel write	11	99.3	.5	.2
control file sequential read	4	100.0	.0
db file parallel read	22	98.3	1.1	.5	.1
db file parallel write	34	99.8	.1	.0	.0
db file scattered read	56	99.7	.2	.1
db file sequential read	1109	99.8	.2	.1	.0	.0
direct path read	1211	99.8	.1	.0	.0	.0
direct path sync	1	50.0			50.0
enq: KO - fast object checkpoint	106	99.1	.8	.0	.0	.0	.0
enq: PS - contention	8	98.8	.6	.6
enq: TQ - DDL contention	1	80.0				20.0
enq: TQ - TM contention	2		50.0			50.0
enq: TX - index contention	9	86.8	11.8	1.5
enq: TX - row lock contention	132	51.3	24.4	19.9	3.7	.7
enq: UL - contention	1	66.7	33.3
enq: WF - contention	1	92.3						7.7
gc buffer busy acquire	39	99.8	.1	.1	.0	.0
gc buffer busy release	1	99.3		.7
gc cr block busy	201	99.0	.7	.3	.1	.0
gc cr multi block request	2	100.0	.0	.0
gc current block 2-way	3	100.0	.0	.0
gc current block busy	21	98.8	1.1	.1	.1
gc current grant busy	2	100.0		.0
gcs drm freeze in enter server mode	1	50.0		50.0
kupp process wait	2			100.0
library cache pin	1	100.0			.0
log file parallel write	244	99.8	.1	.0	.0
log file sequential read	15	88.8	6.0	5.2
log file switch completion	2			100.0
log file sync	469	99.6	.2	.1	.0	.0
name-service call wait	11	42.1	21.1	36.8
os thread startup	5	87.2	5.1	7.7
read by other session	5	99.5	.5
reliable message	6	99.9	.0	.0			.1		.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s
		% of Total Waits
SQL*Net message from dblink	95	87.6	.7	5.3	6.3	.1
Streams AQ: qmn coordinator waiting for slave to start	1			100.0
reliable message	1	100.0	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
cc	14,055	10,712	290,427	3,539,519
SYS$USERS	12	3	3,117	11,826
SYS$BACKGROUND	0	0	11	166

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
cc	912410	1693	8858	2	2390474	869
SYS$USERS	2106	4	555	1	752	0
SYS$BACKGROUND	405225	206	41503	1	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 73.1% of Total DB Time (s): 14,058
Captured PL/SQL account for 2.0% of Total DB Time (s): 14,058

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
4,404.88	6,867	0.64	31.33	87.19	10.61	4ys3bk35us8fb	mdbFlushFromOra@GRQMOLC02 (TNS V1-V3)	select A.PROD_ID, A.PROD_STATE...
1,183.80	6,779	0.17	8.42	94.06	4.42	9z2bgzb3f3w0t	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_IDENTIFY_ID, A.S...
862.19	0		6.13	0.03	0.52	8xn095s9s3wa9	PL/SQL Developer	select 'D'\|\|'\|'\|\|a.session_id\|...
410.62	3,612	0.11	2.92	98.27	0.07	11hz27mtq38v6	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	SELECT A.SUBS_ID, A.CONTRACT_I...
280.19	1	280.19	1.99	36.47	68.23	fna89152yus9t		BEGIN SYS.KUPW$WORKER.MAIN('S...
262.92	6,796	0.04	1.87	88.49	8.23	0f8kn3gzxt22r	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_ID, A.PREFIX \|\| ...
204.33	221	0.92	1.45	47.11	51.04	1d7cpg658cgu5	oracle@PRQMRAC01 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
197.59	221	0.89	1.41	45.67	52.88	du23z1k3mjhmq	oracle@PRQMRAC01 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...
191.40	6,779	0.03	1.36	94.67	0.00	g53t4d0hcrp7f	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select count(1) COUNTS from o...
180.02	199	0.90	1.28	47.39	50.69	5z6tmnc9tgx7r	oracle@PRQMRAC02 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
175.28	199	0.88	1.25	45.49	53.12	32qcsvb5ztykv	oracle@PRQMRAC02 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...

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 74.7% of Total CPU Time (s): 10,712
Captured PL/SQL account for 1.0% of Total CPU Time (s): 10,712

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,840.61	6,867	0.56	35.85	4,404.88	87.19	10.61	4ys3bk35us8fb	mdbFlushFromOra@GRQMOLC02 (TNS V1-V3)	select A.PROD_ID, A.PROD_STATE...
1,113.52	6,779	0.16	10.40	1,183.80	94.06	4.42	9z2bgzb3f3w0t	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_IDENTIFY_ID, A.S...
403.51	3,612	0.11	3.77	410.62	98.27	0.07	11hz27mtq38v6	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	SELECT A.SUBS_ID, A.CONTRACT_I...
232.67	6,796	0.03	2.17	262.92	88.49	8.23	0f8kn3gzxt22r	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_ID, A.PREFIX \|\| ...
181.19	6,779	0.03	1.69	191.40	94.67	0.00	g53t4d0hcrp7f	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select count(1) COUNTS from o...
102.18	1	102.18	0.95	280.19	36.47	68.23	fna89152yus9t		BEGIN SYS.KUPW$WORKER.MAIN('S...
100.05	6,778	0.01	0.93	108.32	92.37	0.00	49t3f8bfvyjxq	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
99.82	6,778	0.01	0.93	108.21	92.24	0.00	6bw3s3a1599qq	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
99.64	6,778	0.01	0.93	108.08	92.19	0.00	fqqjvv2d4tcdm	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
99.63	6,778	0.01	0.93	108.06	92.20	0.00	1v9n0p75gxcby	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...

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 56.4% of Total User I/O Wait Time (s): 1,903
Captured PL/SQL account for 10.0% of Total User I/O Wait Time (s): 1,903

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
467.46	6,867	0.07	24.56	4,404.88	87.19	10.61	4ys3bk35us8fb	mdbFlushFromOra@GRQMOLC02 (TNS V1-V3)	select A.PROD_ID, A.PROD_STATE...
191.16	1	191.16	10.04	280.19	36.47	68.23	fna89152yus9t		BEGIN SYS.KUPW$WORKER.MAIN('S...
104.48	221	0.47	5.49	197.59	45.67	52.88	du23z1k3mjhmq	oracle@PRQMRAC01 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...
104.28	221	0.47	5.48	204.33	47.11	51.04	1d7cpg658cgu5	oracle@PRQMRAC01 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
93.11	199	0.47	4.89	175.28	45.49	53.12	32qcsvb5ztykv	oracle@PRQMRAC02 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...
91.25	199	0.46	4.79	180.02	47.39	50.69	5z6tmnc9tgx7r	oracle@PRQMRAC02 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
90.89	412	0.22	4.78	97.62	3.02	93.11	0kdq6cb0u1jxp	mdbOraRep@PRQMOCS01 (TNS V1-V3)	insert into IMSI_ACCT_ACM_DAIL...
52.33	6,779	0.01	2.75	1,183.80	94.06	4.42	9z2bgzb3f3w0t	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_IDENTIFY_ID, A.S...
29.98	70	0.43	1.58	46.90	31.75	63.92	7prhx66jtpypx	JDBC Thin Client	SELECT NODE_INST_ID, WF_NODE_I...
21.64	6,796	0.00	1.14	262.92	88.49	8.23	0f8kn3gzxt22r	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_ID, A.PREFIX \|\| ...

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: 3,548,456,310
Captured SQL account for 46.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
173,914,941	6,867	25,326.19	4.90	4,404.88	87.2	10.6	4ys3bk35us8fb	mdbFlushFromOra@GRQMOLC02 (TNS V1-V3)	select A.PROD_ID, A.PROD_STATE...
88,650,828	6,779	13,077.27	2.50	191.40	94.7	0	g53t4d0hcrp7f	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select count(1) COUNTS from o...
65,034,164	1,998	32,549.63	1.83	76.01	95.6	0	6fsv3z9s263sz	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,034,083	1,998	32,549.59	1.83	75.88	95.6	0	ffzx77pz0pa4g	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,034,080	1,998	32,549.59	1.83	76.06	95.6	0	bh6f7thha16um	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,034,069	1,998	32,549.58	1.83	75.88	95.7	0	4dub9ujxd8057	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,034,064	1,997	32,565.88	1.83	75.86	95.7	0	bh6hcvvvqydqy	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,034,037	1,998	32,549.57	1.83	75.80	95.7	0	fv2xbczcmsmvv	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,034,008	1,998	32,549.55	1.83	75.85	95.7	0	6fauwdayyw0t8	mdbFlushFromOra@PRQMOCS02 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,033,984	1,998	32,549.54	1.83	75.85	95.7	0	dcyhma7vw93xd	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,033,961	1,998	32,549.53	1.83	75.90	95.6	0	7kuxswuvfja1b	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,001,784	1,997	32,549.72	1.83	76.79	96.1	0	c3cf0fm3qbmuc	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
65,001,442	1,997	32,549.55	1.83	75.85	95.7	0	gtv5j365jyuwu	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
64,969,085	1,996	32,549.64	1.83	76.19	96	0	11c8zb3zn369r	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
51,159,383	6,778	7,547.86	1.44	106.81	92.3	0	274vay09ksus8	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
51,159,308	6,778	7,547.85	1.44	108.06	92.2	0	1v9n0p75gxcby	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
51,144,318	6,778	7,545.64	1.44	108.32	92.4	0	49t3f8bfvyjxq	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
51,144,248	6,778	7,545.63	1.44	107.41	92.3	0	2xyr6pbvjdaj1	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
51,129,208	6,778	7,543.41	1.44	107.33	92.2	0	8dsqhv3r3b3uf	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
51,106,485	6,778	7,540.05	1.44	107.28	92.3	0	8qajgd2m8bb0v	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
51,091,468	6,778	7,537.84	1.44	108.21	92.2	0	6bw3s3a1599qq	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
51,083,911	6,778	7,536.72	1.44	107.18	92.2	0	b7hxpn8tr2qq7	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
51,076,389	6,778	7,535.61	1.44	108.08	92.2	0	fqqjvv2d4tcdm	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
39,533,013	6,779	5,831.69	1.11	1,183.80	94.1	4.4	9z2bgzb3f3w0t	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_IDENTIFY_ID, A.S...

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: 293,480,968
Captured SQL account for 94.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
175,313,188	6,867	25,529.81	59.74	4,404.88	87.19	10.61	4ys3bk35us8fb	mdbFlushFromOra@GRQMOLC02 (TNS V1-V3)	select A.PROD_ID, A.PROD_STATE...
39,414,168	6,779	5,814.16	13.43	1,183.80	94.06	4.42	9z2bgzb3f3w0t	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_IDENTIFY_ID, A.S...
14,206,936	221	64,284.78	4.84	197.59	45.67	52.88	du23z1k3mjhmq	oracle@PRQMRAC01 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...
14,206,322	221	64,282.00	4.84	204.33	47.11	51.04	1d7cpg658cgu5	oracle@PRQMRAC01 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
12,792,785	199	64,285.35	4.36	175.28	45.49	53.12	32qcsvb5ztykv	oracle@PRQMRAC02 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...
12,792,118	199	64,282.00	4.36	180.02	47.39	50.69	5z6tmnc9tgx7r	oracle@PRQMRAC02 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
8,633,384	6,796	1,270.36	2.94	262.92	88.49	8.23	0f8kn3gzxt22r	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_ID, A.PREFIX \|\| ...
3,107,252	1	3,107,252.00	1.06	280.19	36.47	68.23	fna89152yus9t		BEGIN SYS.KUPW$WORKER.MAIN('S...
22,391	70	319.87	0.01	46.90	31.75	63.92	7prhx66jtpypx	JDBC Thin Client	SELECT NODE_INST_ID, WF_NODE_I...
14,658	412	35.58	0.00	97.62	3.02	93.11	0kdq6cb0u1jxp	mdbOraRep@PRQMOCS01 (TNS V1-V3)	insert into IMSI_ACCT_ACM_DAIL...

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: 2,916,124
Captured SQL account for 77.8% of Total
Total UnOptimized Read Requests: 2,916,124
Captured SQL account for 77.8% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
1,394,670	1,394,670	6,867	203.10	47.83	4ys3bk35us8fb	mdbFlushFromOra@GRQMOLC02 (TNS V1-V3)	select A.PROD_ID, A.PROD_STATE...
382,412	382,412	1	382,412.00	13.11	fna89152yus9t		BEGIN SYS.KUPW$WORKER.MAIN('S...
321,548	321,548	6,779	47.43	11.03	9z2bgzb3f3w0t	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_IDENTIFY_ID, A.S...
115,534	115,534	221	522.78	3.96	du23z1k3mjhmq	oracle@PRQMRAC01 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...
114,920	114,920	221	520.00	3.94	1d7cpg658cgu5	oracle@PRQMRAC01 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
104,147	104,147	199	523.35	3.57	32qcsvb5ztykv	oracle@PRQMRAC02 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...
103,480	103,480	199	520.00	3.55	5z6tmnc9tgx7r	oracle@PRQMRAC02 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
76,517	76,517	6,796	11.26	2.62	0f8kn3gzxt22r	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_ID, A.PREFIX \|\| ...
22,391	22,391	70	319.87	0.77	7prhx66jtpypx	JDBC Thin Client	SELECT NODE_INST_ID, WF_NODE_I...
14,658	14,658	412	35.58	0.50	0kdq6cb0u1jxp	mdbOraRep@PRQMOCS01 (TNS V1-V3)	insert into IMSI_ACCT_ACM_DAIL...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 1,995,505
Captured SQL account for 31.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
192,447	810	0.00	36.29	10.8	.8	08r5ykvtcd7h4	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	SELECT /+ FIRST_ROWS ORDERED...
192,426	0	0.00	29.88	7.9	0	7vyp6n0sbbb9q	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select key1, key2, TABLE_SEQUE...
9,930	514	0.05	77.87	90.9	.7	42urju17mx6ux	JDBC Thin Client	SELECT A.CUBS_ACC_NBR_ID, A.SU...
8,775	8,773	1.00	0.38	16.3	0	bunvx480ynf57	RuleCache@PRQMOCS02 (TNS V1-V3)	SELECT 1 FROM DUAL
6,867	12,336	1.80	4,404.88	87.2	10.6	4ys3bk35us8fb	mdbFlushFromOra@GRQMOLC02 (TNS V1-V3)	select A.PROD_ID, A.PROD_STATE...
6,796	1,028	0.15	262.92	88.5	8.2	0f8kn3gzxt22r	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_ID, A.PREFIX \|\| ...
6,786	0	0.00	0.74	12.3	0	a9c3bscw69zjm	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select key1, TABLE_SEQUENCE, U...
6,779	3,308	0.49	1,183.80	94.1	4.4	9z2bgzb3f3w0t	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_IDENTIFY_ID, A.S...
6,779	6,768	1.00	191.40	94.7	0	g53t4d0hcrp7f	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select count(1) COUNTS from o...
6,778	0	0.00	0.50	19.8	0	02v9yqq5d6xc6	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.ROUTING_ID, A.C_SERVE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,087,475
Captured SQL account for 55.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
192,434	192,447	17.70	08r5ykvtcd7h4	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	SELECT /+ FIRST_ROWS ORDERED...
192,403	192,426	17.69	7vyp6n0sbbb9q	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select key1, key2, TABLE_SEQUE...
8,774	8,775	0.81	bunvx480ynf57	RuleCache@PRQMOCS02 (TNS V1-V3)	SELECT 1 FROM DUAL
6,864	6,867	0.63	4ys3bk35us8fb	mdbFlushFromOra@GRQMOLC02 (TNS V1-V3)	select A.PROD_ID, A.PROD_STATE...
6,794	6,796	0.62	0f8kn3gzxt22r	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_ID, A.PREFIX \|\| ...
6,785	6,786	0.62	a9c3bscw69zjm	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select key1, TABLE_SEQUENCE, U...
6,779	6,779	0.62	g53t4d0hcrp7f	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select count(1) COUNTS from o...
6,778	6,778	0.62	2xyr6pbvjdaj1	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
6,778	6,778	0.62	46ytbs5571add	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select key1, key2, TABLE_SEQUE...
6,778	6,778	0.62	6bw3s3a1599qq	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
16,449,698	1	1.32	62jfzru1s1mz1	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
8,270,750	1	0.66	dgdfxu9ram2mj	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
5,334,353	1	0.43	5y20dfyav3thr	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
3,740,235	1	0.30	1fzj71h9hfw0c	Data Pump Worker	SELECT /+rule/ SYS_XMLGEN(VA...
3,088,307	1	0.25	89wvk8xxw6zjg	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
2,992,382	9	0.24	6z0a62u2d26r3	JDBC Thin Client	update SA_WO A set A.STATE = :...
2,740,334	2	0.22	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
2,238,204	1	0.18	5v07w9mp91u5j	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
2,208,427	1	0.18	dvyrmgz9nstyw	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
2,208,385	1	0.18	5gvzpfp2401u8	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
2,064,215	11	0.17	8f1sjvfxuup9w	PL/SQL Developer	select t., o., m.comments fr...
1,806,065	1	0.14	f5yun5dynkskv	plsqldev.exe	select s.synonym_name as obje...
1,799,703	1	0.14	fqmpmkfr6pqyk	plsqldev.exe	select s.synonym_name object_n...
1,713,711	13	0.14	5rc7m6j70rqyk	JDBC Thin Client	DELETE FROM SA_WO A WHERE A.NO...
1,691,707	23	0.14	cn5c671309z76	JDBC Thin Client	UPDATE ADVICE set SUBS_ID=SUBS...
1,599,789	58	0.13	0t69j2wm3r53x	JDBC Thin Client	UPDATE ADVICE_HIS T SET T.STAT...
1,559,040	58	0.12	77ukmybk0rupt	JDBC Thin Client	SELECT T.ADVICE_ID FROM ADVICE...
1,532,406	68	0.12	8qqd0n8a1sdr0	JDBC Thin Client	INSERT INTO ADVICE_HIS (ADVICE...
1,530,573	12	0.12	a8p7pcdm1698t	JDBC Thin Client	SELECT T.ORDER_ITEM_ID FROM OR...
1,526,540	7	0.12	9u69phdvyw5f1	JDBC Thin Client	SELECT B.ATTR_VALUE FROM SIM_C...
1,514,405	70	0.12	7prhx66jtpypx	JDBC Thin Client	SELECT NODE_INST_ID, WF_NODE_I...
1,481,770	13	0.12	fkquwm6vm5paa	JDBC Thin Client	SELECT NODE_INST_ID, WF_NODE_I...
1,469,963	10	0.12	8vfcun9f1azzy	JDBC Thin Client	SELECT WO_ID, ORDER_ID, SEQ, N...
1,457,363	70	0.12	2x24yfx8w017y	JDBC Thin Client	UPDATE SA_NODE_INST T SET T.ST...
1,449,228	7	0.12	1jrryyv292ssu	JDBC Thin Client	SELECT C.MAIN_FLAG, D.IMSI, C....
1,436,900	60	0.12	fxpfgmak9zj88	JDBC Thin Client	SELECT A.NODE_INST_ID FROM SA_...
1,416,522	10	0.11	47fturma9kh52	JDBC Thin Client	SELECT ORDER_ID, SYN_ORDER_ID,...
1,306,798	2	0.10	91k4w10zgrg4m	plsqldev.exe	select object_name, object_typ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
86	0	2wf9jj138a1h8		SELECT /*+ OPT_PARAM('_fix_con...
86	0	2wf9jj138a1h8		SELECT /*+ OPT_PARAM('_fix_con...
83	3,612	11hz27mtq38v6	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	SELECT A.SUBS_ID, A.CONTRACT_I...

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): 221
Captured SQL account for 35.3% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
21.32	192,447	9.65	36.29	58.74	10.78	0.82	08r5ykvtcd7h4	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	SELECT /+ FIRST_ROWS ORDERED...
20.35	192,426	9.22	29.88	68.11	7.90	0.00	7vyp6n0sbbb9q	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select key1, key2, TABLE_SEQUE...
4.77	412	2.16	97.62	4.88	3.02	93.11	0kdq6cb0u1jxp	mdbOraRep@PRQMOCS01 (TNS V1-V3)	insert into IMSI_ACCT_ACM_DAIL...
2.80	6,779	1.27	191.40	1.46	94.67	0.00	g53t4d0hcrp7f	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select count(1) COUNTS from o...
2.63	70	1.19	46.90	5.60	31.75	63.92	7prhx66jtpypx	JDBC Thin Client	SELECT NODE_INST_ID, WF_NODE_I...
1.64	6,778	0.74	106.81	1.54	92.26	0.00	274vay09ksus8	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
1.57	6,867	0.71	4,404.88	0.04	87.19	10.61	4ys3bk35us8fb	mdbFlushFromOra@GRQMOLC02 (TNS V1-V3)	select A.PROD_ID, A.PROD_STATE...
1.57	6,778	0.71	108.06	1.45	92.20	0.00	1v9n0p75gxcby	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
1.51	6,778	0.68	108.08	1.40	92.19	0.00	fqqjvv2d4tcdm	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
1.44	6,778	0.65	107.33	1.35	92.25	0.00	8dsqhv3r3b3uf	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
1.41	6,778	0.64	108.21	1.31	92.24	0.00	6bw3s3a1599qq	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
1.40	6,778	0.63	107.18	1.30	92.19	0.00	b7hxpn8tr2qq7	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
1.39	6,778	0.63	108.32	1.28	92.37	0.00	49t3f8bfvyjxq	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
1.35	6,778	0.61	107.41	1.26	92.27	0.00	2xyr6pbvjdaj1	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
1.33	6,778	0.60	107.28	1.24	92.29	0.00	8qajgd2m8bb0v	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
1.18	6,778	0.53	1.59	74.14	8.22	0.00	f3q1qqk988yau	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select key1, TABLE_SEQUENCE, U...
1.03	1	0.47	280.19	0.37	36.47	68.23	fna89152yus9t		BEGIN SYS.KUPW$WORKER.MAIN('S...
0.71	1,998	0.32	76.01	0.94	95.59	0.00	6fsv3z9s263sz	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.66	1,998	0.30	75.90	0.86	95.60	0.00	7kuxswuvfja1b	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.63	1,998	0.29	76.06	0.83	95.60	0.00	bh6f7thha16um	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.59	1,998	0.27	75.85	0.78	95.68	0.00	dcyhma7vw93xd	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.58	1,998	0.26	75.88	0.77	95.60	0.00	ffzx77pz0pa4g	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.57	1,996	0.26	76.19	0.74	95.97	0.00	11c8zb3zn369r	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.55	1,998	0.25	75.85	0.72	95.75	0.00	6fauwdayyw0t8	mdbFlushFromOra@PRQMOCS02 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.53	1,998	0.24	75.80	0.71	95.72	0.00	fv2xbczcmsmvv	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.53	1,998	0.24	75.88	0.70	95.65	0.00	4dub9ujxd8057	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.53	1,997	0.24	75.85	0.69	95.68	0.00	gtv5j365jyuwu	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.51	3,612	0.23	410.62	0.12	98.27	0.07	11hz27mtq38v6	mdbFlushFromOra@PRQMOCS01 (TNS V1-V3)	SELECT A.SUBS_ID, A.CONTRACT_I...
0.50	1,997	0.23	75.86	0.66	95.69	0.00	bh6hcvvvqydqy	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.50	6,796	0.23	262.92	0.19	88.49	8.23	0f8kn3gzxt22r	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_ID, A.PREFIX \|\| ...
0.41	1,997	0.19	76.79	0.54	96.10	0.00	c3cf0fm3qbmuc	mdbFlushFromOra@GRQMOCS01 (TNS V1-V3)	select nvl(max(TABLE_SEQUENCE)...
0.38	6,779	0.17	1,183.80	0.03	94.06	4.42	9z2bgzb3f3w0t	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select A.SUBS_IDENTIFY_ID, A.S...
0.37	6,786	0.17	0.74	49.65	12.30	0.00	a9c3bscw69zjm	mdbFlushFromOra@GRQMOLC01 (TNS V1-V3)	select key1, TABLE_SEQUENCE, U...
0.21	2	0.10	0.49	43.47	23.92	33.45	91k4w10zgrg4m	plsqldev.exe	select object_name, object_typ...
0.18	2	0.08	1.55	11.89	36.72	50.80	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
0.18	1	0.08	1.34	13.52	31.03	55.11	f5yun5dynkskv	plsqldev.exe	select s.synonym_name as obje...
0.17	478	0.08	0.68	24.88	9.10	63.30	4nwa12k996apm	JDBC Thin Client	INSERT INTO DP_OFFER_ORDER(DP_...
0.11	1	0.05	1.90	5.88	43.19	51.52	5v07w9mp91u5j	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
0.11	1	0.05	3.08	3.58	14.17	82.24	fqmpmkfr6pqyk	plsqldev.exe	select s.synonym_name object_n...
0.08	68	0.04	0.41	20.04	9.86	70.60	8qqd0n8a1sdr0	JDBC Thin Client	INSERT INTO ADVICE_HIS (ADVICE...
0.06	1	0.03	1.20	5.07	72.97	19.89	89wvk8xxw6zjg	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
0.05	394	0.02	1.15	4.24	6.01	89.32	3ktacv9r56b51		select owner#, name, namespace...
0.04	9,930	0.02	77.87	0.06	90.89	0.67	42urju17mx6ux	JDBC Thin Client	SELECT A.CUBS_ACC_NBR_ID, A.SU...
0.04	272	0.02	1.25	3.47	7.39	89.48	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.04	1	0.02	3.60	1.11	80.47	15.75	dgdfxu9ram2mj	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
0.04	58	0.02	0.05	75.53	27.51	0.00	77ukmybk0rupt	JDBC Thin Client	SELECT T.ADVICE_ID FROM ADVICE...
0.03	1	0.02	1.92	1.75	38.32	58.43	1fzj71h9hfw0c	Data Pump Worker	SELECT /+rule/ SYS_XMLGEN(VA...
0.03	58	0.01	0.07	44.13	33.16	25.61	0t69j2wm3r53x	JDBC Thin Client	UPDATE ADVICE_HIS T SET T.STAT...
0.03	1,124	0.01	0.87	3.65	3.34	89.56	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
0.02	12	0.01	0.03	88.91	11.60	0.00	a8p7pcdm1698t	JDBC Thin Client	SELECT T.ORDER_ITEM_ID FROM OR...
0.02	199	0.01	175.28	0.01	45.49	53.12	32qcsvb5ztykv	oracle@PRQMRAC02 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...
0.02	199	0.01	180.02	0.01	47.39	50.69	5z6tmnc9tgx7r	oracle@PRQMRAC02 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
0.02	13	0.01	0.03	69.75	24.36	2.59	5rc7m6j70rqyk	JDBC Thin Client	DELETE FROM SA_WO A WHERE A.NO...
0.02	221	0.01	197.59	0.01	45.67	52.88	du23z1k3mjhmq	oracle@PRQMRAC01 (TNS V1-V3)	SELECT NVL("A1"."SUBS_ID", (-1...
0.02	1	0.01	2.30	0.81	71.50	26.04	5y20dfyav3thr	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
0.02	474	0.01	0.37	4.37	8.76	86.24	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...
0.02	60	0.01	0.02	77.72	24.90	0.00	fxpfgmak9zj88	JDBC Thin Client	SELECT A.NODE_INST_ID FROM SA_...
0.01	1	0.01	7.68	0.19	94.63	4.21	62jfzru1s1mz1	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
0.01	0	0.01	862.19	0.00	0.03	0.52	8xn095s9s3wa9	PL/SQL Developer	select 'D'\|\|'\|'\|\|a.session_id\|...
0.01	23	0.01	0.02	56.07	24.65	0.00	cn5c671309z76	JDBC Thin Client	UPDATE ADVICE set SUBS_ID=SUBS...
0.01	221	0.00	204.33	0.01	47.11	51.04	1d7cpg658cgu5	oracle@PRQMRAC01 (TNS V1-V3)	SELECT "A1"."SUBS_ID", "A1"."R...
0.01	9	0.00	0.03	36.72	25.10	38.97	6z0a62u2d26r3	JDBC Thin Client	update SA_WO A set A.STATE = :...
0.01	13	0.00	0.01	81.40	15.92	4.83	fkquwm6vm5paa	JDBC Thin Client	SELECT NODE_INST_ID, WF_NODE_I...
0.01	26	0.00	0.20	4.70	5.60	91.47	a9u0s3g93f47z		select decode(u.type#, 2, u.ex...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

02v9yqq5d6xc6 select A.ROUTING_ID, A.C_SERVER_ID, B.TABLE_SEQUENCE, B.ACTION_TYPE, B.UPDATE_TIME from OLC_ROUTING A, olc_MDB_CHANGE_NOTIF B where B.TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and B.TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(B.table_name) = upper('OLC_ROUTING') and A.ROUTING_ID=B.key1 order by table_sequence

08r5ykvtcd7h4 SELECT /*+ FIRST_ROWS ORDERED*/ A.SUBS_ID, 0, A.CUST_ID, USER_ID, NVL(A.DEF_LANG_ID, -1), ACCT_ID, NVL(AGENT_ID, -1), NVL(AREA_ID, -1), NVL(A.ROUTING_ID, 0), NVL(A.SP_ID, 0) , PREFIX, ACC_NBR, 'a', to_char(B.CREATED_DATE , 'YYYYMMDDHH24MISS'), to_char(A.UPDATE_DATE, 'YYYYMMDDHH24MISS'), B.STATE, to_char(B.STATE_DATE , 'YYYYMMDDHH24MISS') , to_char(B.COMPLETED_DATE, 'YYYYMMDDHH24MISS'), to_char(TO_DATE('20360102000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS'), PPS_PWD, 'N', B.PROD_STATE, PREFIX||ACC_NBR, PREFIX||'a', C.TABLE_SEQUENCE TABLE_SEQUENCE, C.UPDATE_TIME UPDATE_TIME, C.ACTION_TYPE ACTION_TYPE FROM CC_MDB_CHANGE_NOTIF C, SUBS A, PROD B WHERE C.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND C.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND C.TABLE_NAME='SUBS' AND A.SUBS_ID=C.KEY1 AND A.SUBS_ID=B.PROD_ID AND C.CHILD_TABLE_NAME = 'SUBS' UNION ALL SELECT /*+ FIRST_ROWS ORDERED*/ A.SUBS_ID , A.SEQ, A.CUST_ID, A.USER_ID, NVL(A.DEF_LANG_ID, -1), ACCT_ID, NVL(A.AGENT_ID, -1), NVL(A.AREA_ID , -1), 0, NVL(A.SP_ID, 0), A.PREFIX, A.ACC_NBR, 'a' , to_char(TO_DATE('19700102000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS'), to_char(A.UPDATE_DATE , 'YYYYMMDDHH24MISS'), A.STATE, to_char(A.STATE_DATE, 'YYYYMMDDHH24MISS') , to_char(A.EFF_DATE , 'YYYYMMDDHH24MISS'), to_char(A.EXP_DATE, 'YYYYMMDDHH24MISS'), '', 'N' , 'A', PREFIX||ACC_NBR, PREFIX||'a', C.TABLE_SEQUENCE TABLE_SEQUENCE, C.UPDATE_TIME UPDATE_TIME, C.ACTION_TYPE ACTION_TYPE FROM CC_MDB_CHANGE_NOTIF C, SUBS_HIS A WHERE C.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND C.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND C.TABLE_NAME='SUBS' AND A.SUBS_ID=C.KEY1 AND A.SEQ=C.KEY2 AND C.CHILD_TABLE_NAME = 'SUBS_HIS'

0f8kn3gzxt22r select A.SUBS_ID, A.PREFIX || A.ACC_NBR SUBS_DATA, A.ACC_NBR, A.ROUTING_ID, B.TABLE_SEQUENCE, B.ACTION_TYPE, B.UPDATE_TIME from SUBS A, OLC_MDB_CHANGE_NOTIF B where B.TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and B.TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(B.table_name) = upper('SUBS') and to_char(A.SUBS_ID) = B.key1 order by table_sequence

0kdq6cb0u1jxp insert into IMSI_ACCT_ACM_DAILY ( IMSI, ACCT_ID, RESOURCE_ID, DATE_STAMP, VALUE)values( :IMSI, :ACCT_ID, :RESOURCE_ID, :DATE_STAMP, :VALUE)

0t69j2wm3r53x UPDATE ADVICE_HIS T SET T.STATE = :1 , COMMENTS = :2 , STATE_DATE = SYSDATE WHERE T.MESSAGE_ID = :3

11c8zb3zn369r select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('PROD')

11hz27mtq38v6 SELECT A.SUBS_ID, A.CONTRACT_ITEM_ID, GREATEST(A.EFF_DATE, B.EFF_DATE, C.EFF_DATE) EFF_DATE, LEAST(NVL(A.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(B.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(C.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS'))) EXP_DATE, D.PRICE_PLAN_ID , D.PRICE_BOOK_PRICE_PLAN_ID, A.CONTRACT_ITEM_SUBS_ID, C.PRICE_BOOK_VER_ID, E.TABLE_SEQUENCE TABLE_SEQUENCE, E.UPDATE_TIME UPDATE_TIME, E.ACTION_TYPE ACTION_TYPE FROM CUST_CONTRACT_ITEM_SUBS A, CUST_CONTRACT_ITEM B, CUST_PRICE_BOOK_VER C, CUST_PRICE_BOOK_PRICE_PLAN D, CC_MDB_CHANGE_NOTIF E WHERE A.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND C.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND D.PRICE_BOOK_VER_ID = C.PRICE_BOOK_VER_ID AND B.STATE = 'A' AND E.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND E.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND E.TABLE_NAME='CUST_PRICE_BOOK' AND E.KEY1=D.PRICE_BOOK_PRICE_PLAN_ID AND E.CHILD_TABLE_NAME='CUST_PRICE_BOOK_PRICE_PLAN' UNION ALL SELECT A.SUBS_ID, A.CONTRACT_ITEM_ID, GREATEST(A.EFF_DATE, B.EFF_DATE, C.EFF_DATE) EFF_DATE, LEAST(NVL(A.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(B.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(C.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS'))) EXP_DATE, D.PRICE_PLAN_ID , D.PRICE_BOOK_PRICE_PLAN_ID, A.CONTRACT_ITEM_SUBS_ID, C.PRICE_BOOK_VER_ID, E.TABLE_SEQUENCE TABLE_SEQUENCE, E.UPDATE_TIME UPDATE_TIME, E.ACTION_TYPE ACTION_TYPE FROM CUST_CONTRACT_ITEM_SUBS A, CUST_CONTRACT_ITEM B, CUST_PRICE_BOOK_VER C, CUST_PRICE_BOOK_PRICE_PLAN D, CC_MDB_CHANGE_NOTIF E WHERE A.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND C.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND D.PRICE_BOOK_VER_ID = C.PRICE_BOOK_VER_ID AND B.STATE = 'A' AND E.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND E.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND E.TABLE_NAME='CUST_PRICE_BOOK' AND E.KEY2=A.CONTRACT_ITEM_SUBS_ID AND E.CHILD_TABLE_NAME='CUST_CONTRACT_ITEM_SU BS' UNION ALL SELECT A.SUBS_ID, A.CONTRACT_ITEM_ID, GREATEST(A.EFF_DATE, B.EFF_DATE, C.EFF_DATE) EFF_DATE, LEAST(NVL(A.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(B.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(C.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS'))) EXP_DATE, D.PRICE_PLAN_ID , D.PRICE_BOOK_PRICE_PLAN_ID, A.CONTRACT_ITEM_SUBS_ID, C.PRICE_BOOK_VER_ID, E.TABLE_SEQUENCE TABLE_SEQUENCE, E.UPDATE_TIME UPDATE_TIME, E.ACTION_TYPE ACTION_TYPE FROM CUST_CONTRACT_ITEM_SUBS A, CUST_CONTRACT_ITEM B, CUST_PRICE_BOOK_VER C, CUST_PRICE_BOOK_PRICE_PLAN D, CC_MDB_CHANGE_NOTIF E WHERE A.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND C.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND D.PRICE_BOOK_VER_ID = C.PRICE_BOOK_VER_ID AND B.STATE = 'A' AND E.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND E.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND E.TABLE_NAME='CUST_PRICE_BOOK' AND E.KEY3=C.PRICE_BOOK_VER_ID AND E.CHILD_TABLE_NAME='CUST_PRICE_BOOK_VER'

1d7cpg658cgu5 SELECT "A1"."SUBS_ID", "A1"."RERATING_TYPE", "A1"."SELF_FLAG", "A1"."EXT_ATTR", "A1"."RTQM_RERATING_SUBS_ID" FROM "RTQM_RERATING_SUBS" "A1" WHERE "A1"."CREATE_DATE"+300/24/60/60<=SYSDATE@! AND "A1"."STATE"='A' AND MOD("A1"."SUBS_ID", 3)=1 ORDER BY "A1"."CREATE_DATE"

1fzj71h9hfw0c SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , 'TABLE' , to_char(KU$.BYTES_ALLOC) , KU$.SCHEMA_OBJ.CTIME , KU$.DATAOBJ_NUM , to_char(KU$.ET_PARALLEL) , KU$.FGAC , KU$.LONGCOL , KU$.NONSCOPED_REF , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.NAME , KU$.NAME , 'TABLE_DATA' , KU$.PART_NAME , KU$.PARTTYPE , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.SCHEMA_OBJ.NAME , NULL , KU$.TRIGFLAG , decode(KU$.SCHEMA_OBJ.TYPE_NUM, 2, decode(bitand(KU$.PROPERTY, 8224), 8224, 'NESTED PARTITION', 8192, 'NESTED TABLE', 'TABLE'), 19, decode(bitand(KU$.PROPERTY, 8224), 8224, 'NESTED PARTITION', 'PARTITION'), 20, 'PARTITION', 'SUBPARTITION') , to_char(KU$.UNLOAD_METHOD) , KU$.XMLTYPE_FMTS FROM SYS.KU$_TABLE_DATA_VIEW KU$ WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT (BITAND (KU$.BASE_OBJ.FLAGS, 16)=16) AND NOT XML_OUTOFLINE='Y' AND KU$.BASE_OBJ.OBJ_NUM IN (SELECT * FROM TABL E(DBMS_METADATA.FETCH_OBJNUMS(100001)))

1jrryyv292ssu SELECT C.MAIN_FLAG, D.IMSI, C.ACC_NBR, C.STATE, A.HLR_ID, D.ICCID, D.KI FROM ACC_NBR A, ORDER_ITEM B, EBS_SUBS_ACC_NBR C, SIM_CARD D WHERE A.ACC_NBR = C.ACC_NBR AND B.SUBS_ID = C.SUBS_ID AND C.STATE <> 'X' AND C.SIM_CARD_ID = D.SIM_CARD_ID AND B.ORDER_ITEM_ID = :1

1v9n0p75gxcby select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('PROD')

274vay09ksus8 select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('ROUTING')

2wf9jj138a1h8 SELECT /*+ OPT_PARAM('_fix_control' '9088510:0') NO_XML_QUERY_REWRITE cursor_sharing_exact */ count(*) FROM "SYS"."KUPC$DATAPUMP_QUETAB_1" TAB, SYS.DUAL WHERE tab.corrid='MCP' OR tab.corrid=' '

2x24yfx8w017y UPDATE SA_NODE_INST T SET T.STATE_DATE = SYSDATE, T.CHECK_OUT_DATE = SYSDATE, T.STATE = :1 , T.CHECK_OUT_COMMENTS = :2 WHERE T.NODE_INST_ID = :3

2xyr6pbvjdaj1 select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('C_SERVER')

32qcsvb5ztykv SELECT NVL("A1"."SUBS_ID", (-1)), NVL("A1"."RTQM_RERATING_SUBS_ID", (-1)), NVL("A1"."STATE", ''), NVL("A1"."RERATING_TYPE", ''), NVL("A1"."EXT_ATTR", ''), NVL("A1"."SELF_FLAG", ''), NVL("A1"."UPDATE_DATE", ''), NVL("A1"."CREATE_DATE", '') FROM "RTQM_RERATING_SUBS" "A1" WHERE "A1"."SUBS_ID"= (SELECT "A2"."SUBS_ID" FROM (SELECT "A3"."SUBS_ID" "SUBS_ID", "A3"."RERATING_TYPE" "RERATING_TYPE", "A3"."STATE" "STATE", "A3"."UPDATE_DATE" "UPDATE_DATE", "A3"."CREATE_DATE" "CREATE_DATE", "A3"."SELF_FLAG" "SELF_FLAG", "A3"."EXT_ATTR" "EXT_ATTR", "A3"."RTQM_RERA TING_SUBS_ID" "RTQM_RERATING_SUBS_ID" FROM "RTQM_RERATING_SUBS" "A3" WHERE "A3"."STATE"='B' AND "A3"."CREATE_DATE"+1/24/60/60<SYSDATE@! ORDER BY "A3"."CREATE_DATE") "A2" WHERE ROWNUM=1 AND MOD("A2"."SUBS_ID", 3)=2) AND "A1"."STATE"='B' AND ROWNUM=1 ORDER BY NVL("A1"."CREATE_DATE", '')

3ktacv9r56b51 select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

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

42urju17mx6ux SELECT A.CUBS_ACC_NBR_ID, A.SUBS_ID, A.ACC_NBR, A.MAIN_FLAG, A.SIM_CARD_ID, A.ICCID, A.STATE, B.IMSI, B.HLR_ID, H.HLR_NAME, A.CREATED_DATE, A.STATE_DATE FROM EBS_SUBS_ACC_NBR A, SIM_CARD B, HLR H WHERE A.SIM_CARD_ID = B.SIM_CARD_ID AND A.SUBS_ID = :1 AND B.HLR_ID=H.HLR_ID(+) AND A.STATE <> 'X' ORDER BY A.MAIN_FLAG DESC

46ytbs5571add select key1, key2, TABLE_SEQUENCE, UPDATE_TIME, ACTION_TYPE from olc_MDB_CHANGE_NOTIF where TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(table_name) = upper('ROUTING_TABLE_SEG') and ACTION_TYPE = 'D' order by TABLE_SEQUENCE

47fturma9kh52 SELECT ORDER_ID, SYN_ORDER_ID, RELA_TYPE FROM SA_ORDER_SYN WHERE SYN_ORDER_ID=:1

49t3f8bfvyjxq select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('OLC_ROUTING')

4dub9ujxd8057 select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('NP_DB')

4nwa12k996apm INSERT INTO DP_OFFER_ORDER(DP_ORDER_ID, ORDER_ITEM_ID, OFFER_INST_ID, OFFER_ID, OFFER_PKG_ID, OLD_OFFER_PKG_ID, ABS_EFF_DATE, ABS_EXP_DATE, REL_EFF_OFFSET, REL_EFF_UNIT, REL_EXP_OFFSET, REL_EXP_UNIT, OPERATION_TYPE, AGM_EXP_DATE, OLD_AGM_EXP_DATE, OLD_EFF_DATE, OLD_EXP_DATE, SP_ID, REL_AGM_UNIT, REL_AGM_OFFSET, EFF_TYPE) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 )

4ys3bk35us8fb select A.PROD_ID, A.PROD_STATE, B.TABLE_SEQUENCE, B.ACTION_TYPE, B.UPDATE_TIME from PROD A, OLC_MDB_CHANGE_NOTIF B where B.TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and B.TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(B.table_name) = upper('PROD') and to_char(A.PROD_ID) = B.key1 order by table_sequence

5gvzpfp2401u8 SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) , decode(cardinality(KU$.COL_LIST), 0, '1', '0') FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND KU$.TYPE_NUM =2 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001)))

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

5rc7m6j70rqyk DELETE FROM SA_WO A WHERE A.NODE_INST_ID = :1

5v07w9mp91u5j SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) , decode(cardinality(KU$.COL_LIST), 0, '1', '0') FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT (KU$.TYPE_NUM=1 AND KU$.INTCOLS=1 AND KU$.OID_OR_SETID!=0) AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND KU$.TYPE_NUM NOT IN (2, 4, 8, 9) AND BITAND(KU$.PROPERTY, 16)!=16

5y20dfyav3thr SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'TABLE' , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG FROM SYS.KU$_HTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, 8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND (BITAND(KU$.FLAGS, 536870912)=0)

5z6tmnc9tgx7r SELECT "A1"."SUBS_ID", "A1"."RERATING_TYPE", "A1"."SELF_FLAG", "A1"."EXT_ATTR", "A1"."RTQM_RERATING_SUBS_ID" FROM "RTQM_RERATING_SUBS" "A1" WHERE "A1"."CREATE_DATE"+300/24/60/60<=SYSDATE@! AND "A1"."STATE"='A' AND MOD("A1"."SUBS_ID", 3)=2 ORDER BY "A1"."CREATE_DATE"

62jfzru1s1mz1 SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'TABLE' , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG FROM SYS.KU$_FHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, 8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND (BITAND(KU$.FLAGS, 536870912)=0)

6bw3s3a1599qq select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('OLC_ROUTING_TABLE_SEG')

6fauwdayyw0t8 select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('BC_MEMBER')

6fsv3z9s263sz select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('CUST')

6z0a62u2d26r3 update SA_WO A set A.STATE = :1 , A.STATE_DATE = sysdate where A.node_inst_id = :2

77ukmybk0rupt SELECT T.ADVICE_ID FROM ADVICE_HIS T WHERE T.STATE = 'C' AND T.MESSAGE_ID = :1

7kuxswuvfja1b select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('CUST_PRICE_BOOK')

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

7prhx66jtpypx SELECT NODE_INST_ID, WF_NODE_ID, ORDER_ID, STATE, STATE_DATE, CHECK_OUT_DATE, CHECK_IN_DATE, CHECK_OUT_COMMENTS, CHECK_IN_COMMENTS, CREATED_DATE FROM SA_NODE_INST WHERE ORDER_ID = :1 ORDER BY NODE_INST_ID

7vyp6n0sbbb9q select key1, key2, TABLE_SEQUENCE, UPDATE_TIME, ACTION_TYPE from cc_MDB_CHANGE_NOTIF where TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(table_name) = upper('SUBS') and ACTION_TYPE = 'D' order by TABLE_SEQUENCE

89wvk8xxw6zjg SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('CONSTRAINT_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.NAME , KU$.NAME , 'CONSTRAINT' , KU$.OWNER_NAME FROM SYS.KU$_CONSTRAINT_VIEW KU$ WHERE NOT (KU$.CON1.CONTYPE=3 AND KU$.CON1.INTCOLS=1 AND KU$.CON1.OID_OR_SETID!=0) AND NOT (KU$.CON1.CONTYPE=2 AND BITAND(KU$.CON1.PROPERTY, 64+4096)!=0) AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.OWNER_NAME IN ('MDB') AND (KU$.CON1.CONTYPE NOT IN (5) OR KU$.CON1.IND.TYPE_NUM NOT IN (4, 8, 9))

8dsqhv3r3b3uf select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_IDENTIFY')

8f1sjvfxuup9w select t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null

8qajgd2m8bb0v select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('ROUTING_TABLE_SEG')

8qqd0n8a1sdr0 INSERT INTO ADVICE_HIS (ADVICE_ID, ADVICE_TYPE, SUBS_ID, PREFIX, ACC_NBR, MSG, CREATED_DATE, STATE, STATE_DATE, COMMENTS, MSG_PARAM, SENDER_PARAM, SP_ID, EXP_DATE, MESSAGE_ID) SELECT A.ADVICE_ID, A.ADVICE_TYPE, A.SUBS_ID, A.PREFIX, A.ACC_NBR, A.MSG, A.CREATED_DATE, 'C', SYSDATE, A.COMMENTS, A.MSG_PARAM, A.SENDER_PARAM, NVL(A.SP_ID, :1 ), A.EXP_DATE, :2 FROM ADVICE A WHERE A.ADVICE_ID = :3

8vfcun9f1azzy SELECT WO_ID, ORDER_ID, SEQ, NODE_INST_ID, WS_ID, NE_ID, EVENT_TYPE, STATE, STATE_DATE, CHECK_OUT_DATE, CHECK_IN_DATE, CHECK_OUT_COMMENTS, CHECK_IN_COMMENTS, CREATED_DATE, BACKFILL_PARAM, INPUT_PARAM, IS_BLOCK, PRIORITY, COMPLETED_DATE, REQ_DATE, SP_ID, IS_ROLLBACK, IN_STAFF_JOB_ID, OUT_STAFF_JOB_ID FROM SA_WO_HIS A WHERE A.ORDER_ID = :1 AND A.STATE='C' UNION SELECT WO_ID, ORDER_ID, SEQ, NODE_INST_ID, WS_ID, NE_ID, EVENT_TYPE, STATE, STATE_DATE, CHECK_OUT_DATE, CHECK_IN_DATE, CHECK_OUT_COMMENTS, CHECK_IN_COMMENTS, CREATED_DATE, BACKFILL_PARAM, INPUT_PARAM, IS_BLOCK, PRIORITY, COMPLETED_DATE, REQ_DATE, SP_ID, IS_ROLLBACK, IN_STAFF_JOB_ID, OUT_STAFF_JOB_ID FROM SA_WO B WHERE B.ORDER_ID = :2 AND B.STATE='C'

8xn095s9s3wa9 select 'D'||'|'||a.session_id||'|'||a.event_inst_id||'|'||a.billing_nbr||'|'||a.billing_nbr||'|'||a.billing_sim||'|'||to_char(a.start_time, 'yyyymmddhh24miss')||'|'|| to_char((a.start_time+a.duration/(24*60*60)), 'yyyymmddhh24miss')||'|'||a.duration||'|'||a.byte_up||'|'||a.byte_down||'|'||(a.byte_up+a.byte_down)||'|'||a.rating_group_id||'|'||a.service_identifier||'|'||case when a.partner_code is null then '0' else '1' end||'|'||null||'|'||null||'|'||null||'|'||null||'|'||n.MCC||'|'||n.MNC||'|'|| null||'|'||null||'|'||null||'|'||null||'|'||substr(a.ext_attr, instr(a.ext_attr, '334=')+4, instr(substr(a.ext_attr, instr(a.ext_attr, '334=')+4, 16), '|')-1)||'|'||null||'|'||null||'|'||null||'|'||null||'|'||null||'|'||null||'|'||a.reserve_attr6||'|'||null||'|'||'1'||'|'||a.re_id||'|'||b.re_name||'|'||l.siebel_offer_code||'|'||d.offer_name||'|'||null||'|'||a.charge1*0||'|'||a.charge2*0||'|'||a.charge3*0||'|'|| a.charge4*0||'|'||a.charge5*0||'|'||a.charge6*0||'|'||a.charge7*0||'|'||a.charge8* 0||'|'||a.charge9*0||'|'||a.charge9*0||'|'||e.acct_res_id*0||'|'||f.acct_res_id*0||'|'||g.acct_res_id*0||'|'||null||'|'||null||'|'||null||'|'||null||'|'||null||'|'||null||'|'||null||'|'||a.acct_item_type_id1*0||'|'||a.acct_item_type_id2*0||'|'|| a.acct_item_type_id3*0||'|'||a.acct_item_type_id4*0||'|'||a.acct_item_type_id5*0||'|'||a.acct_item_type_id6*0||'|'||a.acct_item_type_id7*0||'|'||a.acct_item_type_id8*0||'|'||a.acct_item_type_id9*0||'|'||a.acct_item_type_id9*0||'|'||(a.rerating_count+1)||'|'||e.acct_res_id||'|'||f.acct_res_id||'|'||g.acct_res_id||'|'||null||'|'||null||'|'||null||'|'||null||'|'||null||'|'||null||'|'||null||'|'|| a.acct_item_type_id1||'|'||a.acct_item_type_id2||'|'||a.acct_item_type_id3||'|'||a.acct_item_type_id4||'|'||a.acct_item_type_id5||'|'||a.acct_item_type_id6||'|'||a.acct_item_type_id7||'|'||a.acct_item_type_id8||'|'||a.acct_item_type_id9||'|'||a.acct_item_type_id9||'|'|| -o.refund1||'|'||(a.charge2*-1)||'|'||(a.charge3*-1)||'|'||(a.charge4*-1)||'|'||(a.cha rge5*-1)||'|'||(a.charge6*-1)||'|'||(a.charge7*-1)||'|'||(a.charge8*-1)||'|'||(a.charge9*-1)||'|'||0||'|'|| case j.attr_value when '3' then 'A' else 'B' end||'|'||case k.attr_value when 'S' then 'B' else 'A' end||'|'||null||'|'||a.partner_code||'|'||i.acct_nbr||'|'||c.offer_id ||'|'||a.ps_create_cdr_seq||'|'|| 0||'|'|| 0||'|'|| 0||'|'|| -o.refund1||'|'|| 0 from event_usage_c_1208@link_rb a, re b, prod c, offer d, acct_item_type e, acct_item_type f, acct_item_type g, subs h, acct i, cust_attr_value j, cust_attr_value k, rtqm_siebel_offer_mapping l, prod_attr_value m, sh_rtqm_mcc_mnc n, zzw_accumulation_recover1 o where a.subs_id=o.subs_id and a.event_inst_id=o.event_inst_id /*a.state='X'*/ /*and a.re_id in (6610, 6611) and a.ACCT_ITEM_TYPE_ID1=241*/ and a.re_id = b.re_id and a.subs_id = c.prod_id and c.subs_plan_id = d.offer_id and a.acct_item_Type_id1 = e.acct_item_type_id and a.acct_item_Type_id2 = f.acct_item_type_id(+) and a.acct_item_Type_id2 = g.acct_item_type_id(+) a nd a.subs_id = h.subs_id and h.acct_id = i.acct_id and i.cust_id = j.cust_id(+) and j.attr_id = 200000 and i.cust_id = k.cust_id(+) and k.attr_id = 2150 and k.attr_value='S' and c.subs_plan_id =l.offer_id and m.prod_id=a.subs_id and m.attr_id =2155 and m.value =l.network_type and n.plmncode = a.partner_code and n.status =1

91k4w10zgrg4m select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

9u69phdvyw5f1 SELECT B.ATTR_VALUE FROM SIM_CARD A, SIM_CARD_ATTR_VALUE B, ATTR C WHERE A.SIM_CARD_ID = B.SIM_CARD_ID AND C.ATTR_ID = B.ATTR_ID AND C.ATTR_CODE = :1 AND A.IMSI = :2

9z2bgzb3f3w0t select A.SUBS_IDENTIFY_ID, A.SUBS_ID, A.IDENTIFY_VALUE IMSI, A.IDENTIFY_TYPE, B.TABLE_SEQUENCE, B.ACTION_TYPE, B.UPDATE_TIME from SUBS_IDENTIFY A, OLC_MDB_CHANGE_NOTIF B where B.TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and B.TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(B.table_name) = upper('SUBS_IDENTIFY') and to_char(A.SUBS_IDENTIFY_ID) = B.key1 order by table_sequence

a8p7pcdm1698t SELECT T.ORDER_ITEM_ID FROM ORDER_ITEM T WHERE T.ORDER_STATE NOT IN ('C', 'E') AND T.SUBS_EVENT_ID = 153 AND T.SUBS_ID = :1

a9c3bscw69zjm select key1, TABLE_SEQUENCE, UPDATE_TIME, ACTION_TYPE from olc_MDB_CHANGE_NOTIF where TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(table_name) = upper('SUBS') and ACTION_TYPE = 'D' order by TABLE_SEQUENCE

a9u0s3g93f47z select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj#

b7hxpn8tr2qq7 select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS')

bd502nbh9abbs select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

bh6f7thha16um select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_RELA')

bh6hcvvvqydqy select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('CC_ACCT')

bunvx480ynf57 SELECT 1 FROM DUAL

c3cf0fm3qbmuc select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_CREDIT')

cn5c671309z76 UPDATE ADVICE set SUBS_ID=SUBS_ID , STATE=:1 , MSG_PARAM=:2 , MSG=:3 , STATE_DATE=SYSDATE WHERE ADVICE_ID=:4

dcyhma7vw93xd select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('BAL_SHARE_ITEM')

dgdfxu9ram2mj SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'TABLE' , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.PART_OBJ.PARTOBJ.DEFTS_NAME , KU$.TRIGFLAG FROM SYS.KU$_PHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, 8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND (BITAND(KU$.FLAGS, 536870912)=0)

du23z1k3mjhmq SELECT NVL("A1"."SUBS_ID", (-1)), NVL("A1"."RTQM_RERATING_SUBS_ID", (-1)), NVL("A1"."STATE", ''), NVL("A1"."RERATING_TYPE", ''), NVL("A1"."EXT_ATTR", ''), NVL("A1"."SELF_FLAG", ''), NVL("A1"."UPDATE_DATE", ''), NVL("A1"."CREATE_DATE", '') FROM "RTQM_RERATING_SUBS" "A1" WHERE "A1"."SUBS_ID"= (SELECT "A2"."SUBS_ID" FROM (SELECT "A3"."SUBS_ID" "SUBS_ID", "A3"."RERATING_TYPE" "RERATING_TYPE", "A3"."STATE" "STATE", "A3"."UPDATE_DATE" "UPDATE_DATE", "A3"."CREATE_DATE" "CREATE_DATE", "A3"."SELF_FLAG" "SELF_FLAG", "A3"."EXT_ATTR" "EXT_ATTR", "A3"."RTQM_RERA TING_SUBS_ID" "RTQM_RERATING_SUBS_ID" FROM "RTQM_RERATING_SUBS" "A3" WHERE "A3"."STATE"='B' AND "A3"."CREATE_DATE"+1/24/60/60<SYSDATE@! ORDER BY "A3"."CREATE_DATE") "A2" WHERE ROWNUM=1 AND MOD("A2"."SUBS_ID", 3)=1) AND "A1"."STATE"='B' AND ROWNUM=1 ORDER BY NVL("A1"."CREATE_DATE", '')

dvyrmgz9nstyw SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) , decode(cardinality(KU$.COL_LIST), 0, '1', '0') FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND KU$.TYPE_NUM NOT IN (2, 9) AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND BITAND(KU$.PROPERTY, 16)=16

f3q1qqk988yau select key1, TABLE_SEQUENCE, UPDATE_TIME, ACTION_TYPE from olc_MDB_CHANGE_NOTIF where TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(table_name) = upper('PROD') and ACTION_TYPE = 'D' order by TABLE_SEQUENCE

f5yun5dynkskv select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

ffzx77pz0pa4g select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('BAL_ACCT_ITEM_TYPE')

fkquwm6vm5paa SELECT NODE_INST_ID, WF_NODE_ID, ORDER_ID, STATE, STATE_DATE, CHECK_OUT_DATE, CHECK_IN_DATE, CHECK_OUT_COMMENTS, CHECK_IN_COMMENTS, CREATED_DATE, IS_LOCK, SP_ID FROM SA_NODE_INST WHERE NODE_INST_ID=:1

fna89152yus9t BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_58', 'MDB', 0); END;

fqmpmkfr6pqyk select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

fqqjvv2d4tcdm select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('OLC_DIAMETER_SERVER')

fv2xbczcmsmvv select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_IDENTIFY')

fxpfgmak9zj88 SELECT A.NODE_INST_ID FROM SA_NODE_INST A WHERE A.ORDER_ID = :1 AND A.WF_NODE_ID = :2

g53t4d0hcrp7f select count(1) COUNTS from olc_MDB_CHANGE_NOTIF A, (select nvl(max(update_time), TO_DATE('19700102000000', 'YYYYMMDDHH24MISS')) max_update_time from olc_MDB_CHANGE_NOTIF) B where B.max_update_time >= (sysdate - :P_DELAY_TIME/(24*3600))

gtv5j365jyuwu select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_RELA_ATTR_VALUE')

SQL Id	SQL Text
02v9yqq5d6xc6	select A.ROUTING_ID, A.C_SERVER_ID, B.TABLE_SEQUENCE, B.ACTION_TYPE, B.UPDATE_TIME from OLC_ROUTING A, olc_MDB_CHANGE_NOTIF B where B.TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and B.TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(B.table_name) = upper('OLC_ROUTING') and A.ROUTING_ID=B.key1 order by table_sequence
08r5ykvtcd7h4	SELECT /+ FIRST_ROWS ORDERED/ A.SUBS_ID, 0, A.CUST_ID, USER_ID, NVL(A.DEF_LANG_ID, -1), ACCT_ID, NVL(AGENT_ID, -1), NVL(AREA_ID, -1), NVL(A.ROUTING_ID, 0), NVL(A.SP_ID, 0) , PREFIX, ACC_NBR, 'a', to_char(B.CREATED_DATE , 'YYYYMMDDHH24MISS'), to_char(A.UPDATE_DATE, 'YYYYMMDDHH24MISS'), B.STATE, to_char(B.STATE_DATE , 'YYYYMMDDHH24MISS') , to_char(B.COMPLETED_DATE, 'YYYYMMDDHH24MISS'), to_char(TO_DATE('20360102000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS'), PPS_PWD, 'N', B.PROD_STATE, PREFIX\|\|ACC_NBR, PREFIX\|\|'a', C.TABLE_SEQUENCE TABLE_SEQUENCE, C.UPDATE_TIME UPDATE_TIME, C.ACTION_TYPE ACTION_TYPE FROM CC_MDB_CHANGE_NOTIF C, SUBS A, PROD B WHERE C.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND C.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND C.TABLE_NAME='SUBS' AND A.SUBS_ID=C.KEY1 AND A.SUBS_ID=B.PROD_ID AND C.CHILD_TABLE_NAME = 'SUBS' UNION ALL SELECT /+ FIRST_ROWS ORDERED/ A.SUBS_ID , A.SEQ, A.CUST_ID, A.USER_ID, NVL(A.DEF_LANG_ID, -1), ACCT_ID, NVL(A.AGENT_ID, -1), NVL(A.AREA_ID , -1), 0, NVL(A.SP_ID, 0), A.PREFIX, A.ACC_NBR, 'a' , to_char(TO_DATE('19700102000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS'), to_char(A.UPDATE_DATE , 'YYYYMMDDHH24MISS'), A.STATE, to_char(A.STATE_DATE, 'YYYYMMDDHH24MISS') , to_char(A.EFF_DATE , 'YYYYMMDDHH24MISS'), to_char(A.EXP_DATE, 'YYYYMMDDHH24MISS'), '', 'N' , 'A', PREFIX\|\|ACC_NBR, PREFIX\|\|'a', C.TABLE_SEQUENCE TABLE_SEQUENCE, C.UPDATE_TIME UPDATE_TIME, C.ACTION_TYPE ACTION_TYPE FROM CC_MDB_CHANGE_NOTIF C, SUBS_HIS A WHERE C.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND C.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND C.TABLE_NAME='SUBS' AND A.SUBS_ID=C.KEY1 AND A.SEQ=C.KEY2 AND C.CHILD_TABLE_NAME = 'SUBS_HIS'
0f8kn3gzxt22r	select A.SUBS_ID, A.PREFIX \|\| A.ACC_NBR SUBS_DATA, A.ACC_NBR, A.ROUTING_ID, B.TABLE_SEQUENCE, B.ACTION_TYPE, B.UPDATE_TIME from SUBS A, OLC_MDB_CHANGE_NOTIF B where B.TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and B.TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(B.table_name) = upper('SUBS') and to_char(A.SUBS_ID) = B.key1 order by table_sequence
0kdq6cb0u1jxp	insert into IMSI_ACCT_ACM_DAILY ( IMSI, ACCT_ID, RESOURCE_ID, DATE_STAMP, VALUE)values( :IMSI, :ACCT_ID, :RESOURCE_ID, :DATE_STAMP, :VALUE)
0t69j2wm3r53x	UPDATE ADVICE_HIS T SET T.STATE = :1 , COMMENTS = :2 , STATE_DATE = SYSDATE WHERE T.MESSAGE_ID = :3
11c8zb3zn369r	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('PROD')
11hz27mtq38v6	SELECT A.SUBS_ID, A.CONTRACT_ITEM_ID, GREATEST(A.EFF_DATE, B.EFF_DATE, C.EFF_DATE) EFF_DATE, LEAST(NVL(A.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(B.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(C.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS'))) EXP_DATE, D.PRICE_PLAN_ID , D.PRICE_BOOK_PRICE_PLAN_ID, A.CONTRACT_ITEM_SUBS_ID, C.PRICE_BOOK_VER_ID, E.TABLE_SEQUENCE TABLE_SEQUENCE, E.UPDATE_TIME UPDATE_TIME, E.ACTION_TYPE ACTION_TYPE FROM CUST_CONTRACT_ITEM_SUBS A, CUST_CONTRACT_ITEM B, CUST_PRICE_BOOK_VER C, CUST_PRICE_BOOK_PRICE_PLAN D, CC_MDB_CHANGE_NOTIF E WHERE A.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND C.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND D.PRICE_BOOK_VER_ID = C.PRICE_BOOK_VER_ID AND B.STATE = 'A' AND E.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND E.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND E.TABLE_NAME='CUST_PRICE_BOOK' AND E.KEY1=D.PRICE_BOOK_PRICE_PLAN_ID AND E.CHILD_TABLE_NAME='CUST_PRICE_BOOK_PRICE_PLAN' UNION ALL SELECT A.SUBS_ID, A.CONTRACT_ITEM_ID, GREATEST(A.EFF_DATE, B.EFF_DATE, C.EFF_DATE) EFF_DATE, LEAST(NVL(A.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(B.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(C.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS'))) EXP_DATE, D.PRICE_PLAN_ID , D.PRICE_BOOK_PRICE_PLAN_ID, A.CONTRACT_ITEM_SUBS_ID, C.PRICE_BOOK_VER_ID, E.TABLE_SEQUENCE TABLE_SEQUENCE, E.UPDATE_TIME UPDATE_TIME, E.ACTION_TYPE ACTION_TYPE FROM CUST_CONTRACT_ITEM_SUBS A, CUST_CONTRACT_ITEM B, CUST_PRICE_BOOK_VER C, CUST_PRICE_BOOK_PRICE_PLAN D, CC_MDB_CHANGE_NOTIF E WHERE A.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND C.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND D.PRICE_BOOK_VER_ID = C.PRICE_BOOK_VER_ID AND B.STATE = 'A' AND E.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND E.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND E.TABLE_NAME='CUST_PRICE_BOOK' AND E.KEY2=A.CONTRACT_ITEM_SUBS_ID AND E.CHILD_TABLE_NAME='CUST_CONTRACT_ITEM_SU BS' UNION ALL SELECT A.SUBS_ID, A.CONTRACT_ITEM_ID, GREATEST(A.EFF_DATE, B.EFF_DATE, C.EFF_DATE) EFF_DATE, LEAST(NVL(A.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(B.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS')), NVL(C.EXP_DATE, TO_DATE('20360102000000', 'YYYYMMDDHH24MISS'))) EXP_DATE, D.PRICE_PLAN_ID , D.PRICE_BOOK_PRICE_PLAN_ID, A.CONTRACT_ITEM_SUBS_ID, C.PRICE_BOOK_VER_ID, E.TABLE_SEQUENCE TABLE_SEQUENCE, E.UPDATE_TIME UPDATE_TIME, E.ACTION_TYPE ACTION_TYPE FROM CUST_CONTRACT_ITEM_SUBS A, CUST_CONTRACT_ITEM B, CUST_PRICE_BOOK_VER C, CUST_PRICE_BOOK_PRICE_PLAN D, CC_MDB_CHANGE_NOTIF E WHERE A.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND C.CONTRACT_ITEM_ID = B.CONTRACT_ITEM_ID AND D.PRICE_BOOK_VER_ID = C.PRICE_BOOK_VER_ID AND B.STATE = 'A' AND E.TABLE_SEQUENCE>=:P_MIN_TABLE_SEQUANCE AND E.TABLE_SEQUENCE<=:P_MAX_TABLE_SEQUANCE AND E.TABLE_NAME='CUST_PRICE_BOOK' AND E.KEY3=C.PRICE_BOOK_VER_ID AND E.CHILD_TABLE_NAME='CUST_PRICE_BOOK_VER'
1d7cpg658cgu5	SELECT "A1"."SUBS_ID", "A1"."RERATING_TYPE", "A1"."SELF_FLAG", "A1"."EXT_ATTR", "A1"."RTQM_RERATING_SUBS_ID" FROM "RTQM_RERATING_SUBS" "A1" WHERE "A1"."CREATE_DATE"+300/24/60/60<=SYSDATE@! AND "A1"."STATE"='A' AND MOD("A1"."SUBS_ID", 3)=1 ORDER BY "A1"."CREATE_DATE"
1fzj71h9hfw0c	SELECT /+rule/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , 'TABLE' , to_char(KU$.BYTES_ALLOC) , KU$.SCHEMA_OBJ.CTIME , KU$.DATAOBJ_NUM , to_char(KU$.ET_PARALLEL) , KU$.FGAC , KU$.LONGCOL , KU$.NONSCOPED_REF , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.NAME , KU$.NAME , 'TABLE_DATA' , KU$.PART_NAME , KU$.PARTTYPE , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.SCHEMA_OBJ.NAME , NULL , KU$.TRIGFLAG , decode(KU$.SCHEMA_OBJ.TYPE_NUM, 2, decode(bitand(KU$.PROPERTY, 8224), 8224, 'NESTED PARTITION', 8192, 'NESTED TABLE', 'TABLE'), 19, decode(bitand(KU$.PROPERTY, 8224), 8224, 'NESTED PARTITION', 'PARTITION'), 20, 'PARTITION', 'SUBPARTITION') , to_char(KU$.UNLOAD_METHOD) , KU$.XMLTYPE_FMTS FROM SYS.KU$_TABLE_DATA_VIEW KU$ WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT (BITAND (KU$.BASE_OBJ.FLAGS, 16)=16) AND NOT XML_OUTOFLINE='Y' AND KU$.BASE_OBJ.OBJ_NUM IN (SELECT * FROM TABL E(DBMS_METADATA.FETCH_OBJNUMS(100001)))
1jrryyv292ssu	SELECT C.MAIN_FLAG, D.IMSI, C.ACC_NBR, C.STATE, A.HLR_ID, D.ICCID, D.KI FROM ACC_NBR A, ORDER_ITEM B, EBS_SUBS_ACC_NBR C, SIM_CARD D WHERE A.ACC_NBR = C.ACC_NBR AND B.SUBS_ID = C.SUBS_ID AND C.STATE <> 'X' AND C.SIM_CARD_ID = D.SIM_CARD_ID AND B.ORDER_ITEM_ID = :1
1v9n0p75gxcby	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('PROD')
274vay09ksus8	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('ROUTING')
2wf9jj138a1h8	SELECT /+ OPT_PARAM('_fix_control' '9088510:0') NO_XML_QUERY_REWRITE cursor_sharing_exact / count(*) FROM "SYS"."KUPC$DATAPUMP_QUETAB_1" TAB, SYS.DUAL WHERE tab.corrid='MCP' OR tab.corrid=' '
2x24yfx8w017y	UPDATE SA_NODE_INST T SET T.STATE_DATE = SYSDATE, T.CHECK_OUT_DATE = SYSDATE, T.STATE = :1 , T.CHECK_OUT_COMMENTS = :2 WHERE T.NODE_INST_ID = :3
2xyr6pbvjdaj1	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('C_SERVER')
32qcsvb5ztykv	SELECT NVL("A1"."SUBS_ID", (-1)), NVL("A1"."RTQM_RERATING_SUBS_ID", (-1)), NVL("A1"."STATE", ''), NVL("A1"."RERATING_TYPE", ''), NVL("A1"."EXT_ATTR", ''), NVL("A1"."SELF_FLAG", ''), NVL("A1"."UPDATE_DATE", ''), NVL("A1"."CREATE_DATE", '') FROM "RTQM_RERATING_SUBS" "A1" WHERE "A1"."SUBS_ID"= (SELECT "A2"."SUBS_ID" FROM (SELECT "A3"."SUBS_ID" "SUBS_ID", "A3"."RERATING_TYPE" "RERATING_TYPE", "A3"."STATE" "STATE", "A3"."UPDATE_DATE" "UPDATE_DATE", "A3"."CREATE_DATE" "CREATE_DATE", "A3"."SELF_FLAG" "SELF_FLAG", "A3"."EXT_ATTR" "EXT_ATTR", "A3"."RTQM_RERA TING_SUBS_ID" "RTQM_RERATING_SUBS_ID" FROM "RTQM_RERATING_SUBS" "A3" WHERE "A3"."STATE"='B' AND "A3"."CREATE_DATE"+1/24/60/60<SYSDATE@! ORDER BY "A3"."CREATE_DATE") "A2" WHERE ROWNUM=1 AND MOD("A2"."SUBS_ID", 3)=2) AND "A1"."STATE"='B' AND ROWNUM=1 ORDER BY NVL("A1"."CREATE_DATE", '')
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
42urju17mx6ux	SELECT A.CUBS_ACC_NBR_ID, A.SUBS_ID, A.ACC_NBR, A.MAIN_FLAG, A.SIM_CARD_ID, A.ICCID, A.STATE, B.IMSI, B.HLR_ID, H.HLR_NAME, A.CREATED_DATE, A.STATE_DATE FROM EBS_SUBS_ACC_NBR A, SIM_CARD B, HLR H WHERE A.SIM_CARD_ID = B.SIM_CARD_ID AND A.SUBS_ID = :1 AND B.HLR_ID=H.HLR_ID(+) AND A.STATE <> 'X' ORDER BY A.MAIN_FLAG DESC
46ytbs5571add	select key1, key2, TABLE_SEQUENCE, UPDATE_TIME, ACTION_TYPE from olc_MDB_CHANGE_NOTIF where TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(table_name) = upper('ROUTING_TABLE_SEG') and ACTION_TYPE = 'D' order by TABLE_SEQUENCE
47fturma9kh52	SELECT ORDER_ID, SYN_ORDER_ID, RELA_TYPE FROM SA_ORDER_SYN WHERE SYN_ORDER_ID=:1
49t3f8bfvyjxq	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('OLC_ROUTING')
4dub9ujxd8057	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('NP_DB')
4nwa12k996apm	INSERT INTO DP_OFFER_ORDER(DP_ORDER_ID, ORDER_ITEM_ID, OFFER_INST_ID, OFFER_ID, OFFER_PKG_ID, OLD_OFFER_PKG_ID, ABS_EFF_DATE, ABS_EXP_DATE, REL_EFF_OFFSET, REL_EFF_UNIT, REL_EXP_OFFSET, REL_EXP_UNIT, OPERATION_TYPE, AGM_EXP_DATE, OLD_AGM_EXP_DATE, OLD_EFF_DATE, OLD_EXP_DATE, SP_ID, REL_AGM_UNIT, REL_AGM_OFFSET, EFF_TYPE) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 )
4ys3bk35us8fb	select A.PROD_ID, A.PROD_STATE, B.TABLE_SEQUENCE, B.ACTION_TYPE, B.UPDATE_TIME from PROD A, OLC_MDB_CHANGE_NOTIF B where B.TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and B.TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(B.table_name) = upper('PROD') and to_char(A.PROD_ID) = B.key1 order by table_sequence
5gvzpfp2401u8	SELECT /+all_rows/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) , decode(cardinality(KU$.COL_LIST), 0, '1', '0') FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND KU$.TYPE_NUM =2 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001)))
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5rc7m6j70rqyk	DELETE FROM SA_WO A WHERE A.NODE_INST_ID = :1
5v07w9mp91u5j	SELECT /+all_rows/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) , decode(cardinality(KU$.COL_LIST), 0, '1', '0') FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT (KU$.TYPE_NUM=1 AND KU$.INTCOLS=1 AND KU$.OID_OR_SETID!=0) AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND KU$.TYPE_NUM NOT IN (2, 4, 8, 9) AND BITAND(KU$.PROPERTY, 16)!=16
5y20dfyav3thr	SELECT /+all_rows/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'TABLE' , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG FROM SYS.KU$_HTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, 8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND (BITAND(KU$.FLAGS, 536870912)=0)
5z6tmnc9tgx7r	SELECT "A1"."SUBS_ID", "A1"."RERATING_TYPE", "A1"."SELF_FLAG", "A1"."EXT_ATTR", "A1"."RTQM_RERATING_SUBS_ID" FROM "RTQM_RERATING_SUBS" "A1" WHERE "A1"."CREATE_DATE"+300/24/60/60<=SYSDATE@! AND "A1"."STATE"='A' AND MOD("A1"."SUBS_ID", 3)=2 ORDER BY "A1"."CREATE_DATE"
62jfzru1s1mz1	SELECT /+all_rows/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'TABLE' , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG FROM SYS.KU$_FHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, 8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND (BITAND(KU$.FLAGS, 536870912)=0)
6bw3s3a1599qq	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('OLC_ROUTING_TABLE_SEG')
6fauwdayyw0t8	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('BC_MEMBER')
6fsv3z9s263sz	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('CUST')
6z0a62u2d26r3	update SA_WO A set A.STATE = :1 , A.STATE_DATE = sysdate where A.node_inst_id = :2
77ukmybk0rupt	SELECT T.ADVICE_ID FROM ADVICE_HIS T WHERE T.STATE = 'C' AND T.MESSAGE_ID = :1
7kuxswuvfja1b	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('CUST_PRICE_BOOK')
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7prhx66jtpypx	SELECT NODE_INST_ID, WF_NODE_ID, ORDER_ID, STATE, STATE_DATE, CHECK_OUT_DATE, CHECK_IN_DATE, CHECK_OUT_COMMENTS, CHECK_IN_COMMENTS, CREATED_DATE FROM SA_NODE_INST WHERE ORDER_ID = :1 ORDER BY NODE_INST_ID
7vyp6n0sbbb9q	select key1, key2, TABLE_SEQUENCE, UPDATE_TIME, ACTION_TYPE from cc_MDB_CHANGE_NOTIF where TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(table_name) = upper('SUBS') and ACTION_TYPE = 'D' order by TABLE_SEQUENCE
89wvk8xxw6zjg	SELECT /+all_rows/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('CONSTRAINT_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.NAME , KU$.NAME , 'CONSTRAINT' , KU$.OWNER_NAME FROM SYS.KU$_CONSTRAINT_VIEW KU$ WHERE NOT (KU$.CON1.CONTYPE=3 AND KU$.CON1.INTCOLS=1 AND KU$.CON1.OID_OR_SETID!=0) AND NOT (KU$.CON1.CONTYPE=2 AND BITAND(KU$.CON1.PROPERTY, 64+4096)!=0) AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.OWNER_NAME IN ('MDB') AND (KU$.CON1.CONTYPE NOT IN (5) OR KU$.CON1.IND.TYPE_NUM NOT IN (4, 8, 9))
8dsqhv3r3b3uf	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_IDENTIFY')
8f1sjvfxuup9w	select t., o., m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null
8qajgd2m8bb0v	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('ROUTING_TABLE_SEG')
8qqd0n8a1sdr0	INSERT INTO ADVICE_HIS (ADVICE_ID, ADVICE_TYPE, SUBS_ID, PREFIX, ACC_NBR, MSG, CREATED_DATE, STATE, STATE_DATE, COMMENTS, MSG_PARAM, SENDER_PARAM, SP_ID, EXP_DATE, MESSAGE_ID) SELECT A.ADVICE_ID, A.ADVICE_TYPE, A.SUBS_ID, A.PREFIX, A.ACC_NBR, A.MSG, A.CREATED_DATE, 'C', SYSDATE, A.COMMENTS, A.MSG_PARAM, A.SENDER_PARAM, NVL(A.SP_ID, :1 ), A.EXP_DATE, :2 FROM ADVICE A WHERE A.ADVICE_ID = :3
8vfcun9f1azzy	SELECT WO_ID, ORDER_ID, SEQ, NODE_INST_ID, WS_ID, NE_ID, EVENT_TYPE, STATE, STATE_DATE, CHECK_OUT_DATE, CHECK_IN_DATE, CHECK_OUT_COMMENTS, CHECK_IN_COMMENTS, CREATED_DATE, BACKFILL_PARAM, INPUT_PARAM, IS_BLOCK, PRIORITY, COMPLETED_DATE, REQ_DATE, SP_ID, IS_ROLLBACK, IN_STAFF_JOB_ID, OUT_STAFF_JOB_ID FROM SA_WO_HIS A WHERE A.ORDER_ID = :1 AND A.STATE='C' UNION SELECT WO_ID, ORDER_ID, SEQ, NODE_INST_ID, WS_ID, NE_ID, EVENT_TYPE, STATE, STATE_DATE, CHECK_OUT_DATE, CHECK_IN_DATE, CHECK_OUT_COMMENTS, CHECK_IN_COMMENTS, CREATED_DATE, BACKFILL_PARAM, INPUT_PARAM, IS_BLOCK, PRIORITY, COMPLETED_DATE, REQ_DATE, SP_ID, IS_ROLLBACK, IN_STAFF_JOB_ID, OUT_STAFF_JOB_ID FROM SA_WO B WHERE B.ORDER_ID = :2 AND B.STATE='C'
8xn095s9s3wa9	select 'D'\|\|'\|'\|\|a.session_id\|\|'\|'\|\|a.event_inst_id\|\|'\|'\|\|a.billing_nbr\|\|'\|'\|\|a.billing_nbr\|\|'\|'\|\|a.billing_sim\|\|'\|'\|\|to_char(a.start_time, 'yyyymmddhh24miss')\|\|'\|'\|\| to_char((a.start_time+a.duration/(246060)), 'yyyymmddhh24miss')\|\|'\|'\|\|a.duration\|\|'\|'\|\|a.byte_up\|\|'\|'\|\|a.byte_down\|\|'\|'\|\|(a.byte_up+a.byte_down)\|\|'\|'\|\|a.rating_group_id\|\|'\|'\|\|a.service_identifier\|\|'\|'\|\|case when a.partner_code is null then '0' else '1' end\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|n.MCC\|\|'\|'\|\|n.MNC\|\|'\|'\|\| null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|substr(a.ext_attr, instr(a.ext_attr, '334=')+4, instr(substr(a.ext_attr, instr(a.ext_attr, '334=')+4, 16), '\|')-1)\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|a.reserve_attr6\|\|'\|'\|\|null\|\|'\|'\|\|'1'\|\|'\|'\|\|a.re_id\|\|'\|'\|\|b.re_name\|\|'\|'\|\|l.siebel_offer_code\|\|'\|'\|\|d.offer_name\|\|'\|'\|\|null\|\|'\|'\|\|a.charge10\|\|'\|'\|\|a.charge20\|\|'\|'\|\|a.charge30\|\|'\|'\|\| a.charge40\|\|'\|'\|\|a.charge50\|\|'\|'\|\|a.charge60\|\|'\|'\|\|a.charge70\|\|'\|'\|\|a.charge8 0\|\|'\|'\|\|a.charge90\|\|'\|'\|\|a.charge90\|\|'\|'\|\|e.acct_res_id0\|\|'\|'\|\|f.acct_res_id0\|\|'\|'\|\|g.acct_res_id0\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|a.acct_item_type_id10\|\|'\|'\|\|a.acct_item_type_id20\|\|'\|'\|\| a.acct_item_type_id30\|\|'\|'\|\|a.acct_item_type_id40\|\|'\|'\|\|a.acct_item_type_id50\|\|'\|'\|\|a.acct_item_type_id60\|\|'\|'\|\|a.acct_item_type_id70\|\|'\|'\|\|a.acct_item_type_id80\|\|'\|'\|\|a.acct_item_type_id90\|\|'\|'\|\|a.acct_item_type_id90\|\|'\|'\|\|(a.rerating_count+1)\|\|'\|'\|\|e.acct_res_id\|\|'\|'\|\|f.acct_res_id\|\|'\|'\|\|g.acct_res_id\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\|null\|\|'\|'\|\| a.acct_item_type_id1\|\|'\|'\|\|a.acct_item_type_id2\|\|'\|'\|\|a.acct_item_type_id3\|\|'\|'\|\|a.acct_item_type_id4\|\|'\|'\|\|a.acct_item_type_id5\|\|'\|'\|\|a.acct_item_type_id6\|\|'\|'\|\|a.acct_item_type_id7\|\|'\|'\|\|a.acct_item_type_id8\|\|'\|'\|\|a.acct_item_type_id9\|\|'\|'\|\|a.acct_item_type_id9\|\|'\|'\|\| -o.refund1\|\|'\|'\|\|(a.charge2-1)\|\|'\|'\|\|(a.charge3-1)\|\|'\|'\|\|(a.charge4-1)\|\|'\|'\|\|(a.cha rge5-1)\|\|'\|'\|\|(a.charge6-1)\|\|'\|'\|\|(a.charge7-1)\|\|'\|'\|\|(a.charge8-1)\|\|'\|'\|\|(a.charge9-1)\|\|'\|'\|\|0\|\|'\|'\|\| case j.attr_value when '3' then 'A' else 'B' end\|\|'\|'\|\|case k.attr_value when 'S' then 'B' else 'A' end\|\|'\|'\|\|null\|\|'\|'\|\|a.partner_code\|\|'\|'\|\|i.acct_nbr\|\|'\|'\|\|c.offer_id \|\|'\|'\|\|a.ps_create_cdr_seq\|\|'\|'\|\| 0\|\|'\|'\|\| 0\|\|'\|'\|\| 0\|\|'\|'\|\| -o.refund1\|\|'\|'\|\| 0 from event_usage_c_1208@link_rb a, re b, prod c, offer d, acct_item_type e, acct_item_type f, acct_item_type g, subs h, acct i, cust_attr_value j, cust_attr_value k, rtqm_siebel_offer_mapping l, prod_attr_value m, sh_rtqm_mcc_mnc n, zzw_accumulation_recover1 o where a.subs_id=o.subs_id and a.event_inst_id=o.event_inst_id /a.state='X'/ /and a.re_id in (6610, 6611) and a.ACCT_ITEM_TYPE_ID1=241*/ and a.re_id = b.re_id and a.subs_id = c.prod_id and c.subs_plan_id = d.offer_id and a.acct_item_Type_id1 = e.acct_item_type_id and a.acct_item_Type_id2 = f.acct_item_type_id(+) and a.acct_item_Type_id2 = g.acct_item_type_id(+) a nd a.subs_id = h.subs_id and h.acct_id = i.acct_id and i.cust_id = j.cust_id(+) and j.attr_id = 200000 and i.cust_id = k.cust_id(+) and k.attr_id = 2150 and k.attr_value='S' and c.subs_plan_id =l.offer_id and m.prod_id=a.subs_id and m.attr_id =2155 and m.value =l.network_type and n.plmncode = a.partner_code and n.status =1
91k4w10zgrg4m	select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
9u69phdvyw5f1	SELECT B.ATTR_VALUE FROM SIM_CARD A, SIM_CARD_ATTR_VALUE B, ATTR C WHERE A.SIM_CARD_ID = B.SIM_CARD_ID AND C.ATTR_ID = B.ATTR_ID AND C.ATTR_CODE = :1 AND A.IMSI = :2
9z2bgzb3f3w0t	select A.SUBS_IDENTIFY_ID, A.SUBS_ID, A.IDENTIFY_VALUE IMSI, A.IDENTIFY_TYPE, B.TABLE_SEQUENCE, B.ACTION_TYPE, B.UPDATE_TIME from SUBS_IDENTIFY A, OLC_MDB_CHANGE_NOTIF B where B.TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and B.TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(B.table_name) = upper('SUBS_IDENTIFY') and to_char(A.SUBS_IDENTIFY_ID) = B.key1 order by table_sequence
a8p7pcdm1698t	SELECT T.ORDER_ITEM_ID FROM ORDER_ITEM T WHERE T.ORDER_STATE NOT IN ('C', 'E') AND T.SUBS_EVENT_ID = 153 AND T.SUBS_ID = :1
a9c3bscw69zjm	select key1, TABLE_SEQUENCE, UPDATE_TIME, ACTION_TYPE from olc_MDB_CHANGE_NOTIF where TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(table_name) = upper('SUBS') and ACTION_TYPE = 'D' order by TABLE_SEQUENCE
a9u0s3g93f47z	select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj#
b7hxpn8tr2qq7	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS')
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
bh6f7thha16um	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_RELA')
bh6hcvvvqydqy	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('CC_ACCT')
bunvx480ynf57	SELECT 1 FROM DUAL
c3cf0fm3qbmuc	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_CREDIT')
cn5c671309z76	UPDATE ADVICE set SUBS_ID=SUBS_ID , STATE=:1 , MSG_PARAM=:2 , MSG=:3 , STATE_DATE=SYSDATE WHERE ADVICE_ID=:4
dcyhma7vw93xd	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('BAL_SHARE_ITEM')
dgdfxu9ram2mj	SELECT /+all_rows/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'TABLE' , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.PART_OBJ.PARTOBJ.DEFTS_NAME , KU$.TRIGFLAG FROM SYS.KU$_PHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, 8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND (BITAND(KU$.FLAGS, 536870912)=0)
du23z1k3mjhmq	SELECT NVL("A1"."SUBS_ID", (-1)), NVL("A1"."RTQM_RERATING_SUBS_ID", (-1)), NVL("A1"."STATE", ''), NVL("A1"."RERATING_TYPE", ''), NVL("A1"."EXT_ATTR", ''), NVL("A1"."SELF_FLAG", ''), NVL("A1"."UPDATE_DATE", ''), NVL("A1"."CREATE_DATE", '') FROM "RTQM_RERATING_SUBS" "A1" WHERE "A1"."SUBS_ID"= (SELECT "A2"."SUBS_ID" FROM (SELECT "A3"."SUBS_ID" "SUBS_ID", "A3"."RERATING_TYPE" "RERATING_TYPE", "A3"."STATE" "STATE", "A3"."UPDATE_DATE" "UPDATE_DATE", "A3"."CREATE_DATE" "CREATE_DATE", "A3"."SELF_FLAG" "SELF_FLAG", "A3"."EXT_ATTR" "EXT_ATTR", "A3"."RTQM_RERA TING_SUBS_ID" "RTQM_RERATING_SUBS_ID" FROM "RTQM_RERATING_SUBS" "A3" WHERE "A3"."STATE"='B' AND "A3"."CREATE_DATE"+1/24/60/60<SYSDATE@! ORDER BY "A3"."CREATE_DATE") "A2" WHERE ROWNUM=1 AND MOD("A2"."SUBS_ID", 3)=1) AND "A1"."STATE"='B' AND ROWNUM=1 ORDER BY NVL("A1"."CREATE_DATE", '')
dvyrmgz9nstyw	SELECT /+all_rows/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) , decode(cardinality(KU$.COL_LIST), 0, '1', '0') FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND KU$.TYPE_NUM NOT IN (2, 9) AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND BITAND(KU$.PROPERTY, 16)=16
f3q1qqk988yau	select key1, TABLE_SEQUENCE, UPDATE_TIME, ACTION_TYPE from olc_MDB_CHANGE_NOTIF where TABLE_SEQUENCE >= :P_MIN_TABLE_SEQUANCE and TABLE_SEQUENCE <= :P_MAX_TABLE_SEQUANCE and upper(table_name) = upper('PROD') and ACTION_TYPE = 'D' order by TABLE_SEQUENCE
f5yun5dynkskv	select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
ffzx77pz0pa4g	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('BAL_ACCT_ITEM_TYPE')
fkquwm6vm5paa	SELECT NODE_INST_ID, WF_NODE_ID, ORDER_ID, STATE, STATE_DATE, CHECK_OUT_DATE, CHECK_IN_DATE, CHECK_OUT_COMMENTS, CHECK_IN_COMMENTS, CREATED_DATE, IS_LOCK, SP_ID FROM SA_NODE_INST WHERE NODE_INST_ID=:1
fna89152yus9t	BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_58', 'MDB', 0); END;
fqmpmkfr6pqyk	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
fqqjvv2d4tcdm	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from olc_MDB_CHANGE_NOTIF where lower(table_name) = lower('OLC_DIAMETER_SERVER')
fv2xbczcmsmvv	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_IDENTIFY')
fxpfgmak9zj88	SELECT A.NODE_INST_ID FROM SA_NODE_INST A WHERE A.ORDER_ID = :1 AND A.WF_NODE_ID = :2
g53t4d0hcrp7f	select count(1) COUNTS from olc_MDB_CHANGE_NOTIF A, (select nvl(max(update_time), TO_DATE('19700102000000', 'YYYYMMDDHH24MISS')) max_update_time from olc_MDB_CHANGE_NOTIF) B where B.max_update_time >= (sysdate - :P_DELAY_TIME/(24*3600))
gtv5j365jyuwu	select nvl(max(TABLE_SEQUENCE), -1) MAX_TABLE_SEQUENCE, nvl(min(TABLE_SEQUENCE), -1) MIN_TABLE_SEQUENCE from cc_MDB_CHANGE_NOTIF where lower(table_name) = lower('SUBS_RELA_ATTR_VALUE')

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats
Other Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	1,002,299	280.50	8.10
execute count	1,995,505	558.46	16.13
gc cr block receive time	11,146	3.12	0.09
gc cr blocks received	73,366	20.53	0.59
gc current block receive time	15,803	4.42	0.13
gc current blocks received	189,455	53.02	1.53
logons cumulative	809	0.23	0.01
opened cursors cumulative	164,999	46.18	1.33
parse count (total)	1,087,475	304.34	8.79
parse time elapsed	4,713	1.32	0.04
physical reads	293,480,968	82,133.61	2,372.14
physical writes	39,969	11.19	0.32
redo size	167,994,904	47,015.07	1,357.86
session cursor cache hits	119,522	33.45	0.97
session logical reads	3,548,456,310	993,071.31	28,681.35
user calls	2,480,952	694.32	20.05
user commits	123,709	34.62	1.00
user rollbacks	11	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	175,294	49.06	1.42

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	400	0.11	0.00
Batched IO (full) vector count	4	0.00	0.00
Batched IO (space) vector count	2	0.00	0.00
Batched IO block miss count	5,066	1.42	0.04
Batched IO buffer defrag count	52	0.01	0.00
Batched IO double miss count	587	0.16	0.00
Batched IO same unit count	1,751	0.49	0.01
Batched IO single block count	301	0.08	0.00
Batched IO slow jump count	284	0.08	0.00
Batched IO vector block count	3,082	0.86	0.02
Batched IO vector read count	371	0.10	0.00
Block Cleanout Optim referenced	0	0.00	0.00
CCursor + sql area evicted	14	0.00	0.00
CPU used by this session	1,063,042	297.50	8.59
CPU used when call started	1,037,693	290.41	8.39
CR blocks created	36,227	10.14	0.29
Cached Commit SCN referenced	6,270	1.75	0.05
Clusterwide global transactions	1,380	0.39	0.01
Clusterwide global transactions spanning RAC nodes	0	0.00	0.00
Commit SCN cached	132,403	37.05	1.07
DBWR checkpoint buffers written	7,354	2.06	0.06
DBWR checkpoints	1,332	0.37	0.01
DBWR fusion writes	6,428	1.80	0.05
DBWR object drop buffers written	29	0.01	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	2,015	0.56	0.02
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	298	0.08	0.00
DBWR undo block writes	7,049	1.97	0.06
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	581	0.16	0.00
DML statements parallelized	0	0.00	0.00
DX/BB enqueue lock background get time	50	0.01	0.00
DX/BB enqueue lock background gets	2,760	0.77	0.02
DX/BB enqueue lock foreground requests	14,613	4.09	0.12
Effective IO time	1,096,646,175	306,907.50	8,863.94
GTX processes spawned by autotune	0	0.00	0.00
GTX processes stopped by autotune	0	0.00	0.00
HSC Heap Segment Block Changes	175,175	49.02	1.42
Heap Segment Array Inserts	2,303	0.64	0.02
Heap Segment Array Updates	113,808	31.85	0.92
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	2,379,457	665.92	19.23
PX local messages recv'd	2,192	0.61	0.02
PX local messages sent	2,192	0.61	0.02
PX remote messages recv'd	1,208	0.34	0.01
PX remote messages sent	1,216	0.34	0.01
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	581	0.16	0.00
Requests to/from client	2,391,106	669.18	19.33
RowCR - row contention	161	0.05	0.00
RowCR attempts	11,061	3.10	0.09
RowCR hits	10,995	3.08	0.09
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	2,391,118	669.18	19.33
SQL*Net roundtrips to/from dblink	762	0.21	0.01
active txn count during cleanout	40,588	11.36	0.33
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	46,473	13.01	0.38
branch node splits	2	0.00	0.00
buffer is not pinned count	18,058,103	5,053.74	145.96
buffer is pinned count	103,877,250	29,071.10	839.62
bytes received via SQL*Net from client	1,047,620,259	293,187.10	8,467.67
bytes received via SQL*Net from dblink	474,292	132.74	3.83
bytes sent via SQL*Net to client	1,152,425,293	322,517.85	9,314.79
bytes sent via SQL*Net to dblink	131,750	36.87	1.06
calls to get snapshot scn: kcmgss	2,173,620	608.31	17.57
calls to kcmgas	252,691	70.72	2.04
calls to kcmgcs	3,479,999	973.91	28.13
cell physical IO interconnect bytes	2,417,580,610,560	676,584,332.92	19,540,742.08
change write time	618	0.17	0.00
cleanout - number of ktugct calls	1,417,639	396.74	11.46
cleanouts and rollbacks - consistent read gets	39,941	11.18	0.32
cleanouts only - consistent read gets	1,358,266	380.12	10.98
cluster key scan block gets	123,322	34.51	1.00
cluster key scans	89,951	25.17	0.73
commit batch performed	15	0.00	0.00
commit batch requested	15	0.00	0.00
commit batch/immediate performed	72	0.02	0.00
commit batch/immediate requested	72	0.02	0.00
commit cleanout failures: block lost	545	0.15	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	1,535	0.43	0.01
commit cleanout failures: cannot pin	326	0.09	0.00
commit cleanouts	222,664	62.31	1.80
commit cleanouts successfully completed	220,258	61.64	1.78
commit immediate performed	57	0.02	0.00
commit immediate requested	57	0.02	0.00
commit txn count during cleanout	10,852,414	3,037.16	87.72
consistent changes	222,902	62.38	1.80
consistent gets	3,547,494,048	992,802.01	28,673.57
consistent gets - examination	12,864,700	3,600.32	103.98
consistent gets direct	293,579,495	82,161.18	2,372.93
consistent gets from cache	3,253,914,559	910,640.83	26,300.63
consistent gets from cache (fastpath)	3,240,187,936	906,799.29	26,189.69
cursor authentications	508	0.14	0.00
data blocks consistent reads - undo records applied	211,667	59.24	1.71
db block gets	962,526	269.37	7.78
db block gets direct	1,479	0.41	0.01
db block gets from cache	961,047	268.96	7.77
db block gets from cache (fastpath)	183,274	51.29	1.48
deferred (CURRENT) block cleanout applications	42,929	12.01	0.35
dirty buffers inspected	15,408	4.31	0.12
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	46,850	13.11	0.38
enqueue deadlocks	0	0.00	0.00
enqueue releases	918,327	257.00	7.42
enqueue requests	918,373	257.02	7.42
enqueue timeouts	44	0.01	0.00
enqueue waits	13,601	3.81	0.11
exchange deadlocks	69	0.02	0.00
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	963,723	269.71	7.79
free buffer requested	639,527	178.98	5.17
gc blocks compressed	110,634	30.96	0.89
gc blocks lost	0	0.00	0.00
gc cr block flush time	3,600	1.01	0.03
gc cr blocks served	52,264	14.63	0.42
gc current block flush time	330	0.09	0.00
gc current block pin time	5	0.00	0.00
gc current blocks served	482,997	135.17	3.90
gc force cr disk read	4,312	1.21	0.03
gc kbytes saved	468,102	131.00	3.78
gc kbytes sent	3,813,985	1,067.38	30.83
gc local grants	192,602	53.90	1.56
gc read wait failures	0	0.00	0.00
gc read wait timeouts	0	0.00	0.00
gc read waits	66	0.02	0.00
gc remote grants	110,675	30.97	0.89
gcs messages sent	850,717	238.08	6.88
ges messages sent	92,354	25.85	0.75
global enqueue get time	4,898	1.37	0.04
global enqueue gets async	6,205	1.74	0.05
global enqueue gets sync	496,680	139.00	4.01
global enqueue releases	472,077	132.12	3.82
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	1,674	0.47	0.01
hot buffers moved to head of LRU	1,872,945	524.16	15.14
immediate (CR) block cleanout applications	1,398,210	391.30	11.30
immediate (CURRENT) block cleanout applications	32,649	9.14	0.26
index crx upgrade (positioned)	3,849	1.08	0.03
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	74,812	20.94	0.60
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	799,760,868	223,821.15	6,464.28
index scans kdiixs1	1,746,421	488.75	14.12
leaf node 90-10 splits	114	0.03	0.00
leaf node splits	385	0.11	0.00
lob reads	1,221,518	341.85	9.87
lob writes	8,432	2.36	0.07
lob writes unaligned	8,346	2.34	0.07
local undo segment hints helped	0	0.00	0.00
local undo segment hints were stale	0	0.00	0.00
logical read bytes from cache	26,663,940,562,944	7,462,172,868.16	215,518,433.26
max cf enq hold time	20	0.01	0.00
messages received	190,654	53.36	1.54
messages sent	190,654	53.36	1.54
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	1,673	0.47	0.01
no work - consistent read gets	3,529,513,775	987,770.05	28,528.24
non-idle wait count	5,259,692	1,471.98	42.51
parse count (describe)	2	0.00	0.00
parse count (failures)	19	0.01	0.00
parse count (hard)	2,649	0.74	0.02
parse time cpu	2,125	0.59	0.02
physical read IO requests	2,916,124	816.11	23.57
physical read bytes	2,404,196,089,856	672,838,539.72	19,432,558.11
physical read total IO requests	2,928,230	819.49	23.67
physical read total bytes	2,404,658,454,016	672,967,936.99	19,436,295.30
physical read total multi block requests	2,306,784	645.58	18.65
physical reads cache	280,244	78.43	2.27
physical reads cache prefetch	92,947	26.01	0.75
physical reads direct	293,200,724	82,055.18	2,369.87
physical reads direct (lob)	20,798	5.82	0.17
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	31,647	8.86	0.26
physical write bytes	327,426,048	91,633.48	2,646.51
physical write total IO requests	349,559	97.83	2.83
physical write total bytes	12,922,156,544	3,616,395.92	104,446.79
physical write total multi block requests	45,654	12.78	0.37
physical writes direct	1,502	0.42	0.01
physical writes direct (lob)	1,200	0.34	0.01
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	38,467	10.77	0.31
physical writes non checkpoint	37,104	10.38	0.30
pinned buffers inspected	241	0.07	0.00
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	139	0.04	0.00
process last non-idle time	3,583	1.00	0.03
queries parallelized	529	0.15	0.00
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	435,888	121.99	3.52
recursive cpu usage	13,158	3.68	0.11
redo KB read	234,264	65.56	1.89
redo blocks checksummed by FG (exclusive)	49,379	13.82	0.40
redo blocks read for recovery	0	0.00	0.00
redo blocks written	430,827	120.57	3.48
redo buffer allocation retries	2	0.00	0.00
redo entries	557,617	156.05	4.51
redo k-bytes read for recovery	0	0.00	0.00
redo log space requests	2	0.00	0.00
redo ordering marks	6,893	1.93	0.06
redo size for direct writes	12,170,268	3,405.97	98.37
redo subscn max counts	2,613	0.73	0.02
redo synch long waits	7	0.00	0.00
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	38,338	10.73	0.31
redo synch time (usec)	383,516,663	107,331.01	3,099.88
redo synch time overhead (usec)	10,607,538	2,968.63	85.74
redo synch time overhead count (<128 msec)	1	0.00	0.00
redo synch time overhead count (<2 msec)	122,851	34.38	0.99
redo synch time overhead count (<32 msec)	0	0.00	0.00
redo synch time overhead count (<8 msec)	18	0.01	0.00
redo synch time overhead count (>=128 msec)	2	0.00	0.00
redo synch writes	122,877	34.39	0.99
redo wastage	45,574,616	12,754.52	368.37
redo write broadcast ack count	302	0.08	0.00
redo write broadcast ack time	266,954	74.71	2.16
redo write broadcast lgwr post count	0	0.00	0.00
redo write info find	122,874	34.39	0.99
redo write info find fail	2	0.00	0.00
redo write time	34,564	9.67	0.28
redo writes	133,209	37.28	1.08
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	446	0.12	0.00
rollbacks only - consistent read gets	5,520	1.54	0.04
root node splits	0	0.00	0.00
rows fetched via callback	976,772	273.36	7.90
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	238,031	66.62	1.92
shared hash latch upgrades - wait	345	0.10	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	574,451	160.77	4.64
sorts (rows)	451,298,608	126,300.47	3,647.74
space was found by tune down	0	0.00	0.00
space was not found by tune down	0	0.00	0.00
sql area evicted	4,181	1.17	0.03
sql area purged	23	0.01	0.00
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	62,329	17.44	0.50
switch current to new buffer	43,246	12.10	0.35
table fetch by rowid	57,157,109	15,995.99	461.99
table fetch continued row	37,038	10.37	0.30
table scan blocks gotten	2,919,299,626	816,995.46	23,596.02
table scan rows gotten	204,796,545,067	57,314,380.01	1,655,322.87
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	4,018	1.12	0.03
table scans (long tables)	3,033	0.85	0.02
table scans (rowid ranges)	96	0.03	0.00
table scans (short tables)	228,000	63.81	1.84
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	1,340	0.38	0.01
total number of cf enq holders	110	0.03	0.00
total number of times SMON posted	770	0.22	0.01
transaction lock background get time	0	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	71	0.02	0.00
transaction tables consistent read rollbacks	100	0.03	0.00
transaction tables consistent reads - undo records applied	11,899	3.33	0.10
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	51,211,660	14,332.10	413.93
user logons cumulative	199	0.06	0.00
user logouts cumulative	195	0.05	0.00
write clones created in background	0	0.00	0.00
write clones created in foreground	20	0.01	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
logons current	200	203
opened cursors current	1,994	2,380
session cursor cache count	45,229,966	45,233,432
session pga memory	171,041,921,008	171,038,655,872
session pga memory max	2,960,965,810,032	2,960,980,912,032
session uga memory	710,005,460,600	710,032,297,776
session uga memory max	10,343,832,589,192	10,344,245,344,608
workarea memory allocated	493,050	480,755

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.01

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	2.2T	654.36	633.962	0M	0.00	0M	0
Data Pump	23.5G	106.56	6.742M	11G	12.94	3.155M	385.4K	0.13
Buffer Cache Reads	2.1G	54.75	.601M	0M	0.00	0M	185K	3.24
Others	444M	3.45	.124M	325M	1.48	.091M	13.7K	0.49
LGWR	0M	0.01	0M	422M	74.89	.118M	133.3K	2.12
DBWR	0M	0.00	0M	300M	8.52	.084M	0
Direct Writes	0M	0.00	0M	2M	0.01	.001M	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	8	5.88
TOTAL:	2.2T	819.12	641.429	12G	97.84	3.449M	717.4K	1.31

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	2.2T	815.90	641.452	310M	8.83	.087M	1.87	3.16
Data Pump Dump File	0M	0.00	0M	11G	12.67	3.153M
Log File	229M	0.07	.064M	421M	74.88	.118M	1.36	15.76
Control File	211M	3.32	.059M	96M	1.37	.027M	0.15	3.35
Archive Log	0M	0.00	0M	229M	0.06	.064M
Temp File	1M	0.02	0M	1M	0.02	0M	5.01
TOTAL:	2.2T	819.31	641.575	12G	97.84	3.449M	1.84	3.16

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	2.2T	654.36	633.962	0M	0.00	0M	0
Direct Reads (Data File)	2.2T	654.36	633.962	0M	0.00	0M	0
Data Pump	23.5G	106.56	6.742M	11G	12.94	3.155M	340K	0.14
Data Pump (Data File)	23.5G	106.56	6.742M	8M	0.26	.002M	340K	0.14
Data Pump (Data Pump Dump File)	0M	0.00	0M	11G	12.67	3.153M	0
Data Pump (Control File)	0M	0.00	0M	0M	0.00	0M	14	0.00
Buffer Cache Reads	2.1G	54.75	.601M	0M	0.00	0M	183.8K	3.23
Buffer Cache Reads (Data File)	2.1G	54.75	.601M	0M	0.00	0M	183.8K	3.23
Others	445M	3.44	.125M	325M	1.48	.091M	12.1K	0.25
Others (Control File)	212M	3.31	.059M	95M	1.36	.027M	11.9K	0.16
Others (Archive Log)	0M	0.00	0M	229M	0.06	.064M	0
Others (Log File)	229M	0.07	.064M	0M	0.00	0M	7	0.29
Others (Data File)	4M	0.07	.001M	1M	0.06	0M	232	4.99
LGWR	0M	0.01	0M	422M	74.90	.118M	23	2.00
LGWR (Log File)	0M	0.00	0M	421M	74.89	.118M	8	5.13
LGWR (Control File)	0M	0.00	0M	1M	0.01	0M	15	0.33
DBWR	0M	0.00	0M	300M	8.52	.084M	0
DBWR (Data File)	0M	0.00	0M	300M	8.52	.084M	0
Direct Writes	0M	0.00	0M	2M	0.01	.001M	0
Direct Writes (Data File)	0M	0.00	0M	2M	0.01	.001M	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	8	5.88
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	8	5.88
TOTAL:	2.2T	819.12	641.429	12G	97.84	3.449M	535.9K	1.20

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
TAB_CC	2,470,680	691	0.11	117.53	11,211	31.52	2	3	29,254	0.69
TAB_MDB	380,086	106	0.33	8.16	2,281	99.76	0	1	2,607	0.90
IDX_CC	37,777	11	6.30	1.00	6,746	10.57	6	2	1,154	1.72
IDX_MDB	16,109	5	6.09	1.00	9,152	4.51	6	3	0	0.00
SYSTEM	8,889	2	3.63	1.63	273	2.38	3	0	2	0.00
SYSAUX	2,259	1	4.08	4.50	747	0.55	4	0	0	0.00
UNDOTBS1	585	0	5.85	1.00	1,113	0.16	6	0	193	0.00
TAB_DEF	223	0	9.60	1.00	120	0.06	10	0	0	0.00
TEMP	88	0	5.34	1.00	58	0.02	5	0	0	0.00
UNDOTBS2	119	0	6.64	1.00	3	0.03	7	0	202	0.59
USERS	7	0	1.43	1.00	1	0.00	1	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
IDX_CC	+CCDATA/cc/datafile/idx_cc.288.827290787	27,838	8	6.39	1.00	8	6.39	3,616	1	750	1.84
IDX_CC	+CCDATA/cc/datafile/idx_cc.303.863480949	9,939	3	6.04	1.00	3	6.04	3,130	1	404	1.51
IDX_MDB	+CCDATA/cc/datafile/idx_mdb.287.827290715	16,109	5	6.09	1.00	5	6.09	9,152	3	0	0.00
SYSAUX	+CCDATA/cc/datafile/sysaux.262.827177095	2,259	1	4.08	4.50	1	3.64	747	0	0	0.00
SYSTEM	+CCDATA/cc/datafile/system.261.827177089	8,889	2	3.63	1.63	2	3.49	273	0	2	0.00
TAB_CC	+CCDATA/cc/datafile/tab_cc.283.827290385	363,496	102	0.13	115.10	4	2.63	2,121	1	4,406	1.22
TAB_CC	+CCDATA/cc/datafile/tab_cc.284.827290419	353,040	99	0.12	115.05	5	2.38	1,167	0	1,952	0.32
TAB_CC	+CCDATA/cc/datafile/tab_cc.289.832417847	341,162	95	0.10	119.42	4	2.06	1,347	0	3,479	0.62
TAB_CC	+CCDATA/cc/datafile/tab_cc.290.832418099	335,975	94	0.10	119.33	4	1.96	1,116	0	3,647	0.50
TAB_CC	+CCDATA/cc/datafile/tab_cc.291.832418381	341,711	96	0.10	118.82	4	2.02	975	0	6,455	1.01
TAB_CC	+CCDATA/cc/datafile/tab_cc.292.832418601	342,484	96	0.10	118.51	4	2.07	1,403	0	3,309	0.39
TAB_CC	+CCDATA/cc/datafile/tab_cc.297.842570797	198,422	56	0.13	114.58	3	2.07	2,392	1	3,141	0.43
TAB_CC	+CCDATA/cc/datafile/tab_cc.298.842570883	194,390	54	0.13	119.16	3	1.91	690	0	2,865	0.37
TAB_DEF	+CCDATA/cc/datafile/tab_def.282.827290295	223	0	9.60	1.00	0	9.60	120	0	0	0.00
TAB_MDB	+CCDATA/cc/datafile/tab_mdb.285.827290631	178,766	50	0.35	8.66	47	0.37	1,176	0	2,607	0.90
TAB_MDB	+CCDATA/cc/datafile/tab_mdb.286.827290665	201,320	56	0.32	7.72	53	0.34	1,105	0	0	0.00
TEMP	+CCDATA/cc/tempfile/temp.264.827187331	88	0	5.34	1.00	0	5.45	58	0	0
UNDOTBS1	+CCDATA/cc/datafile/undotbs1.263.827177101	522	0	6.02	1.00	0	6.02	627	0	144	0.00
UNDOTBS1	+CCDATA/cc/datafile/undotbs1.299.842575589	21	0	3.33	1.00	0	2.86	187	0	19	0.00
UNDOTBS1	+CCDATA/cc/datafile/undotbs1.300.842577267	42	0	5.00	1.00	0	5.00	299	0	30	0.00
UNDOTBS2	+CCDATA/cc/datafile/undotbs2.265.827177121	38	0	7.63	1.00	0	7.89	1	0	183	0.49
UNDOTBS2	+CCDATA/cc/datafile/undotbs2.301.842577449	26	0	6.15	1.00	0	5.77	1	0	12	2.50
UNDOTBS2	+CCDATA/cc/datafile/undotbs2.302.842577561	55	0	6.18	1.00	0	6.00	1	0	7	0.00
USERS	+CCDATA/cc/datafile/users.266.827177135	7	0	1.43	1.00	0	1.43	1	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	172,224	100	3,223,015,647	280,225	38,466	0	0	33,417

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 39,969

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	5,336	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	0	644	41045	251289	5096034	251289			0
E	0	0	2207	40473	204617	5096034	204617			0

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	144	0.10	17	175.23	1,657,908,964	1	3932205892.00
D	288	0.19	34	48.62	460,032,662	1	2272752369.00
D	432	0.29	51	8.93	84,496,507	1	406031746.00
D	576	0.39	67	4.36	41,240,017	1	191011751.00
D	720	0.48	84	2.90	27,416,955	1	122299891.00
D	864	0.58	101	2.10	19,909,363	1	84981026.00
D	1,008	0.68	118	1.57	14,893,603	1	60048613.00
D	1,152	0.77	135	1.27	12,007,842	1	45704042.00
D	1,296	0.87	152	1.11	10,526,329	1	38339705.00
D	1,440	0.97	168	1.02	9,628,471	1	33876621.00
D	1,488	1.00	174	1.00	9,461,333	1	33045811.00
D	1,584	1.06	185	0.95	8,997,231	1	30738845.00
D	1,728	1.16	202	0.90	8,530,102	1	28416834.00
D	1,872	1.26	219	0.87	8,185,070	1	26701746.00
D	2,016	1.35	236	0.84	7,922,329	1	25395706.00
D	2,160	1.45	253	0.82	7,711,205	1	24346247.00
D	2,304	1.55	270	0.80	7,539,396	1	23492216.00
D	2,448	1.65	286	0.78	7,393,256	1	22765783.00
D	2,592	1.74	303	0.77	7,263,806	1	22122308.00
D	2,736	1.84	320	0.75	7,139,618	1	21504996.00
D	2,880	1.94	337	0.71	6,742,154	1	19529272.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
100.00	59,953	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	2,048	1,225	1,070.40	58.25	5.44	100.00	0.00	209,710
E	2,048	1,227	1,060.68	46.24	4.36	100.00	0.00	209,710

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
2K	4K	155,359	155,359
64K	128K	242	242
128K	256K	226	226
256K	512K	9	9
512K	1024K	901	901
1M	2M	6,926	6,926
2M	4M	8	8
4M	8M	11,626	11,626
8M	16M	1	1

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
256	0.13	90,084,484.66	4,759,505.86	95.00	163,374	36,659,937,656
512	0.25	90,084,484.66	4,325,986.48	95.00	148,118	36,492,369,912
1,024	0.50	90,084,484.66	284,001.58	100.00	7	34,930,026,179
1,536	0.75	90,084,484.66	262,036.26	100.00	0	34,921,535,948
2,048	1.00	90,084,484.66	164,800.41	100.00	0	34,883,951,487
2,458	1.20	90,084,484.66	123,649.46	100.00	0	34,868,045,460
2,867	1.40	90,084,484.66	123,649.46	100.00	0	34,868,045,460
3,277	1.60	90,084,484.66	123,649.46	100.00	0	34,868,045,460
3,686	1.80	90,084,484.66	123,649.46	100.00	0	34,868,045,460
4,096	2.00	90,084,484.66	123,649.46	100.00	0	34,868,045,460
6,144	3.00	90,084,484.66	123,649.46	100.00	0	34,868,045,460
8,192	4.00	90,084,484.66	123,649.46	100.00	0	34,868,045,460
12,288	6.00	90,084,484.66	123,649.46	100.00	0	34,868,045,460
16,384	8.00	90,084,484.66	123,649.46	100.00	0	34,868,045,460

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)
1,008	0.68	94	11,134	143,343,289	0.97	4,800,680	8.52	3,077,620
1,168	0.78	253	18,049	147,518,655	1.00	625,314	1.11	3,280,276
1,328	0.89	413	26,880	147,556,900	1.00	587,069	1.04	3,283,806
1,344	0.90	429	27,840	147,558,596	1.00	585,373	1.04	3,284,042
1,360	0.91	445	28,811	147,559,968	1.00	584,001	1.04	3,284,234
1,376	0.92	460	29,786	147,561,395	1.00	582,574	1.03	3,284,433
1,392	0.94	475	30,761	147,562,463	1.00	581,506	1.03	3,284,595
1,408	0.95	490	31,736	147,563,433	1.00	580,536	1.03	3,284,749
1,424	0.96	506	32,623	147,564,897	1.00	579,072	1.03	3,284,985
1,440	0.97	522	33,447	147,566,225	1.00	577,744	1.03	3,285,247
1,456	0.98	538	34,271	147,566,992	1.00	576,977	1.02	3,285,382
1,472	0.99	554	35,095	147,567,957	1.00	576,012	1.02	3,285,536
1,488	1.00	570	35,918	147,580,790	1.00	563,179	1.00	3,286,507
1,504	1.01	586	36,741	147,587,693	1.00	556,276	0.99	3,287,580
1,520	1.02	602	37,650	147,588,231	1.00	555,738	0.99	3,287,717
1,536	1.03	618	38,717	147,588,738	1.00	555,231	0.99	3,287,849
1,552	1.04	634	39,784	147,589,261	1.00	554,708	0.99	3,287,977
1,568	1.05	650	40,851	147,589,740	1.00	554,229	0.98	3,288,101
1,584	1.06	666	41,915	147,590,184	1.00	553,785	0.98	3,288,222
1,600	1.08	682	42,979	147,590,645	1.00	553,324	0.98	3,288,339
1,616	1.09	698	44,043	147,591,083	1.00	552,886	0.98	3,288,456
1,632	1.10	714	45,098	147,591,512	1.00	552,457	0.98	3,288,574
1,648	1.11	730	46,148	147,591,960	1.00	552,009	0.98	3,288,689
1,808	1.22	890	56,326	147,596,029	1.00	547,940	0.97	3,289,872
1,968	1.32	1,050	67,569	147,600,304	1.00	543,665	0.97	3,291,064
2,128	1.43	1,210	83,947	147,604,170	1.00	539,799	0.96	3,292,164
2,288	1.54	1,370	98,334	147,607,644	1.00	536,325	0.95	3,293,078
2,448	1.65	1,530	112,888	147,610,478	1.00	533,491	0.95	3,293,818
2,608	1.75	1,690	123,001	147,612,978	1.00	530,991	0.94	3,294,448
2,768	1.86	1,850	130,694	147,614,834	1.00	529,135	0.94	3,294,942
2,928	1.97	2,010	138,635	147,616,594	1.00	527,375	0.94	3,295,418
3,088	2.08	2,170	147,760	147,618,316	1.00	525,653	0.93	3,295,883

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	0.14	0	0	0	0
32	0.29	0	0	0	0
48	0.43	0	0	0	0
64	0.57	0	0	0	0
80	0.71	0	0	0	0
96	0.86	0	0	0	0
112	1.00	0	0	0	0
128	1.14	0	0	0	0
144	1.29	0	0	0	0
160	1.43	0	0	0	0
176	1.57	0	0	0	0
192	1.71	0	0	0	0
208	1.86	0	0	0	0
224	2.00	0	0	0	0
240	2.14	0	0	0	0
256	2.29	0	0	0	0
272	2.43	0	0	0	0
288	2.57	0	0	0	0
304	2.71	0	0	0	0
320	2.86	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	33,018	25	1
undo header	290	0	0
undo block	105	0	0
1st level bmb	3	0	3

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)	45,234	45,237	0	12,231	21	1.74
TX-Transaction (row lock contention)	272	272	0	271	12	46.05
PS-PX Process Reservation	4,007	3,964	43	644	1	2.07
WF-AWR Flush	22	22	0	13	1	101.54
TX-Transaction (index contention)	67	67	0	63	1	12.38
TQ-Queue table enqueue (DDL contention)	18	18	0	5	1	102.00
TQ-Queue table enqueue (TM contention)	2	2	0	2	0	190.00
UL-User-defined	6	6	0	3	0	20.00
CR-Reuse Block Range (block range reuse ckpt)	60	60	0	7	0	7.14
CF-Controlfile Transaction	7,908	7,908	0	89	0	0.45
TM-DML	166,777	166,768	1	58	0	0.69
TX-Transaction (allocate ITL entry)	6	6	0	6	0	6.67
HW-Segment High Water Mark	838	838	0	64	0	0.31
PI-Remote PX Process Spawn Status	12	12	0	6	0	3.33
RO-Multiple Object Reuse (fast object reuse)	60	60	0	18	0	0.56
SR-Synchronized Replication	67	67	0	6	0	1.67
TT-Tablespace	8,641	8,641	0	50	0	0.00
FB-Format Block	83	83	0	24	0	0.00
TD-KTF map table enqueue (KTF dump entries)	12	12	0	12	0	0.00
TA-Instance Undo	23	23	0	6	0	0.00
TS-Temporary Segment	18	18	0	6	0	0.00
AE-Edition Lock (lock)	236	236	0	4	0	0.00
AS-Service Operations (service activation)	8	8	0	2	0	0.00
PE-Parameter	8	8	0	2	0	0.00
ZH-Compression Analyzer (compression analysis)	4	4	0	2	0	0.00
DR-Distributed Recovery	2	2	0	2	0	0.00
SQ-Sequence Cache	126	126	0	1	0	0.00
AF-Advisor Framework (task serialization)	7	7	0	1	0	0.00
TO-Temp Object	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	7.01	129,984	4,641	23	12630.2/12786	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
31-Aug 18:58	1,010	21,222	939	18	12,786	0/0	0/0/0/0/0/0
31-Aug 18:48	1,165	21,758	338	19	12,752	0/0	0/0/0/0/0/0
31-Aug 18:38	1,046	21,260	1,484	19	12,722	0/0	0/0/0/0/0/0
31-Aug 18:28	1,069	21,451	883	20	12,688	0/0	0/0/0/0/0/0
31-Aug 18:18	1,136	22,061	4,641	20	12,662	0/0	0/0/0/0/0/0
31-Aug 18:08	1,579	22,232	4,041	23	12,630	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
AQ dequeue txn counter latch	958	0.00		0
ASM Keyed state latch	473	0.00		0
ASM allocation	382	0.00		0
ASM db client latch	13,533	0.00		0
ASM map headers	39	0.00		0
ASM map load waiting list	10	0.00		0
ASM map operation freelist	2,985	0.00		0
ASM map operation hash table	6,489,036	0.00	0.01	0
ASM network SGA latch	3	0.00		0
ASM network background latch	1,609	0.00		0
ASM network state latch	289	0.00		0
ASM scan context latch	4	0.00		0
AWR Alerted Metric Element list	36,342	0.00		0
Change Notification Hash table latch	1,190	0.00		0
Consistent RBA	133,195	0.00	0.00	0
DML lock allocation	589,690	0.00		0
Event Group Locks	1,054	0.00		0
FAL Queue	147	0.00		0
FIB s.o chain latch	50	0.00		0
FOB s.o list latch	1,906	0.00		0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC other latch	30	0.00		0
IPC stats buffer allocation latch	1,690	0.00		1,695	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	9	0.00		0
JS broadcast add buf latch	17,976	0.00		0
JS broadcast autostart latch	2	0.00		0
JS broadcast drop buf latch	17,976	0.00		0
JS broadcast load blnc latch	17,868	0.00		0
JS mem alloc latch	8	0.00		0
JS queue access latch	5	0.00		0
JS queue state obj latch	553,196	0.00		0
JS slv state obj latch	25	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KFK SGA Libload latch	240	0.00		0
KFMD SGA	4	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	295,457	0.06	0.01	14,137	0.04
KJCT flow control latch	1,532,785	0.01	0.00	0
KMG MMAN ready and startup request latch	1,191	0.00		0
KSXR large replies	248	0.00		0
KTF sga latch	36	0.00		1,203	0.00
KWQMN job cache list latch	380	0.00		0
KWQP Prop Status	41	0.00		0
KWQS pqsubs latch	5	0.00		0
KWQS pqueue ctx latch	7	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	332	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	1	0.00		1,191	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	869	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	2,458	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	1,139	0.00		0
OS process allocation	7,741	0.00		0
OS process: request allocation	473	0.00		0
PL/SQL warning settings	3,355	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	33,168	0.59	0.03	0
SGA IO buffer pool latch	14	0.00		14	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	1	0.00		1,189	0.00
SQL memory manager workarea list latch	230,702	0.00	0.00	0
STREAMS Pool Advisor	0			15	0.00
Shared B-Tree	447	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	21,492	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	74,708	2.32	0.00	0
active service list	191,270	0.00	0.00	720,760	0.00
alert log latch	2	0.00		0
archive control	63	0.00		0
archive process latch	443	0.00		0
begin backup scn array	1,161	0.00		0
bq:time manger info latch	20	0.00		0
buffer pool	1	0.00		0
bufq statistics	1,496	0.00		0
business card	1,163	0.00		0
cache buffer handles	16,629	0.00		0
cache buffers chains	6,450,303,917	0.29	0.00	12,549,101	0.00
cache buffers lru chain	356,144	0.00	0.18	12,824,151	0.01
cache table scan latch	19,676	0.00		19,676	0.00
call allocation	5,157	0.06	0.00	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	568	0.00		0
channel operations parent latch	2,647,275	0.01	0.01	0
checkpoint queue latch	2,350,808	0.00	0.00	72,146	0.00
client/application info	5,602	0.00		0
compile environment latch	815	0.00		0
corrupted undo seg latch	1,409	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	59	0.00		0
cvmap freelist lock	1	0.00		0
datapump attach fixed tables latch	565	0.00		0
datapump job fixed tables latch	567	0.00		0
deferred cleanup latch	59	0.00		0
dml lock allocation	71	0.00		0
done queue latch	1	0.00		0
dummy allocation	1,628	0.00		0
eighth spare latch - X parent	1	0.00		0
eleventh spare latch - children	1	0.00		0
enqueue freelist latch	1	0.00		1,243,136	0.00
enqueue hash chains	2,308,266	0.05	0.00	78	0.00
enqueue sob latch	9	0.00		0
enqueues	1	0.00		0
error message lists	2,611	0.00		0
fifteenth spare latch - children	1	0.00		0
file cache latch	461	0.00		0
first Audit Vault latch	193	0.00		0
flashback copy	1	0.00		0
fourteenth spare latch - children	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	3,177,782	0.04	0.02	40,944	0.01
gc persistent rm	3	0.00		0
gcs commit scn state	1	0.00		0
gcs opaque info freelist	432,796	0.36	0.00	0
gcs partitioned table hash	9,686,916	0.08	0.00	248,099	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	324	0.00		0
gcs remastering latch	308	0.00		34	0.00
gcs resource freelist	326,732	0.00	0.00	245,726	0.00
gcs resource hash	3,669,886	0.02	0.00	26	0.00
gcs resource scan list	60	0.00		0
gcs resource validate list	1	0.00		0
gcs shadows freelist	254,753	0.00	0.00	255,387	0.00
ges caches resource lists	329,038	0.03	0.00	120,800	0.01
ges deadlock list	8,978	0.00		7	0.00
ges domain table	875,131	0.00	0.00	0
ges enqueue table freelist	924,068	0.00	0.00	0
ges group table	964,786	0.00	0.00	0
ges process hash list	167,605	0.00	0.25	0
ges process parent latch	1,944,829	0.00	0.94	0
ges process table freelist	473	0.00		0
ges resource hash list	1,838,314	0.08	0.05	33,395	0.01
ges resource scan list	296	0.00		0
ges resource table freelist	42,488	0.02	0.00	0
ges timeout list	14,656	0.00		6,398	0.00
ges value block free list	24,247	0.00		0
global KZLD latch for mem in SGA	187	0.00		0
global tx hash mapping	14,277	0.00		0
granule operation	1	0.00		0
hash table column usage latch	510	0.00		224,118	0.00
hash table modification latch	149	0.00		0
heartbeat check	1	0.00		1,191	0.00
heartbeat structure management	0			714	0.00
image handles of buffered messages latch	868	0.00		0
interrupt manipulation	5,153	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	7	0.00		6	0.00
job_queue_processes free list latch	12	0.00		0
job_queue_processes parameter latch	17,933	0.00		0
k2q global data latch	10,854	0.00		0
k2q lock allocation	17,528	0.00		0
kcbtsemkid latch	1	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kgnfs mount latch	1	0.00		0
kokc descriptor allocation latch	240,914	0.01	0.05	0
krbmrosl	2	0.00		0
ksbxic instance latch	21	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	1,178	0.00		0
ksim membership request latch	24	0.00		2,919	0.00
kss move lock	41	0.00		0
ksuosstats global area	360	0.00		0
ksv allocation latch	140	0.00		0
ksv class latch	7,718	0.03	0.00	0
ksv instance latch	6	0.00		0
ksv msg queue latch	9	0.00		8	0.00
ksxp shared latch	473	0.00		0
ksxp so latch	473	0.00		0
ksz_so allocation latch	473	0.00		0
ktm global data	1,584	0.00		0
kupp process latch	27	0.00		0
kwqbsgn:msghdr	1,302	0.15	0.00	0
kwqbsn:qsga	377	0.27	0.00	15	0.00
kwqbsn:qxl	22	0.00		0
kwqi:kchunk latch	2	0.00		0
lgwr LWN SCN	137,438	0.00	0.00	0
list of block allocation	1,580	0.00		0
loader state object freelist	18,129	0.01	0.00	0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	13	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	2	0.00		0
logminer local	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	13	0.00		11	0.00
managed standby latch	146	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	24,851	0.00		0
messages	1,021,609	0.31	0.00	0
mostly latch-free SCN	139,499	0.50	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	192,250	0.00	0.00	0
name-service memory objects	30,264	0.00		0
name-service namespace bucket	36,870	0.00		0
name-service namespace objects	8	0.00		0
name-service pending queue	8,178	0.00		0
name-service request	36	0.00		0
name-service request queue	53,754	0.00		0
ncodef allocation latch	59	0.00		0
nineth spare latch - X parent	1	0.00		0
object queue header heap	60,719	0.00		58,737	0.00
object queue header operation	2,756,910	0.00	0.00	0
object stats modification	2,543	0.00		0
parallel query alloc buffer	12,217	0.00		0
parallel query stats	2,193	0.00		0
parallel txn reco latch	3,680	0.00		0
parameter list	2,033	0.00		0
parameter table management	4,111	0.00		0
pass worker exception to master	9	0.00		0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	310,140	0.01	0.00	243,176	0.08
process allocation	17,817	0.00		238	0.00
process group creation	473	0.00		0
process queue	6,221	0.00		0
process queue reference	102,315	0.01	0.00	9,353	0.01
qmn state object latch	3	0.00		0
qmn task queue latch	1,071	0.93	0.00	0
query server freelists	5,156	0.00		0
query server process	554	0.00		6	0.00
queue sender's info. latch	1,572	0.06	0.00	0
queued dump request	12	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	408,874	0.04	0.03	557,260	0.13
redo copy	1	0.00		557,546	0.05
redo writing	445,060	0.21	0.00	0
resmgr group change latch	801	0.00		0
resmgr:active threads	1,628	0.00		0
resmgr:actses change group	797	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	1,627	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	81	0.00		0
resmgr:session queuing	1	0.00		0
resumable state object	492	0.00		0
rm cas latch	1	0.00		0
row cache objects	11,253,499	0.01	0.01	1,631	0.00
rules engine aggregate statistics	965	0.00		0
rules engine evaluation context statistics	4	0.00		0
rules engine rule set statistics	2,480	0.04	0.00	0
rules engine rule statistics	438	0.00		0
second Audit Vault latch	1	0.00		0
segmented array pool	10	0.00		0
sequence cache	58,691	0.02	0.00	0
session allocation	137,440	0.00	0.00	135,723	0.00
session idle bit	5,095,828	0.00	0.00	0
session queue latch	1	0.00		0
session state list latch	1,355	0.00		0
session switching	295	0.00		0
session timer	1,192	0.00		0
seventh spare latch - X parent	1	0.00		0
shared pool	457,978	0.04	0.06	6	0.00
shared pool sim alloc	1	0.00		0
shared pool simulator	18,081	0.00		0
shared server configuration	12	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	189,751,908	0.00	0.01	0
simulator lru latch	1	0.00		189,738,370	7.49
sixth spare latch - X parent	1	0.00		0
sort extent pool	904	0.00		0
space background state object latch	14	0.00		0
space background task latch	4,357	0.30	0.23	2,387	0.00
spilled messages latch	6	0.00		0
state object free list	2	0.00		0
statistics aggregation	10,841	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	8	0.00		0
temporary table state object allocation	2	0.00		0
tenth spare latch - X parent	1	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
thirteenth spare latch - children	1	0.00		0
threshold alerts latch	178	0.00		0
transaction allocation	41,680	0.00		0
transaction branch allocation	11,321	0.00		0
twelfth spare latch - children	1	0.00		0
twenty-fifth spare latch - S par	1	0.00		0
twenty-first spare latch - S par	1	0.00		0
twenty-fourth spare latch - S par	1	0.00		0
twenty-second spare latch - S par	1	0.00		0
twenty-third spare latch - S par	1	0.00		0
undo global data	8,114,954	0.00	0.00	0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0
write info latch	0			133,562	0.02

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	6,450,303,917	18,389,040	953	18,389,206
messages	1,021,609	3,154	9	3,145
simulator hash latch	189,751,908	2,797	23	2,775
active checkpoint queue latch	74,708	1,735	6	1,729
ges resource hash list	1,838,314	1,445	77	1,368
gc element	3,177,782	1,362	23	1,341
row cache objects	11,253,499	1,342	11	1,332
enqueue hash chains	2,308,266	1,263	4	1,259
redo writing	445,060	942	2	940
gcs resource hash	3,669,886	758	2	756
mostly latch-free SCN	139,499	691	3	688
channel operations parent latch	2,647,275	245	3	242
Real-time plan statistics latch	33,168	195	5	190
shared pool	457,978	181	11	170
redo allocation	408,874	179	6	173
KJC message pool free list	295,457	174	1	173
ASM map operation hash table	6,489,036	67	1	66
ges process parent latch	1,944,829	47	44	3
kokc descriptor allocation latch	240,914	20	1	19
cache buffers lru chain	356,144	17	3	14
space background task latch	4,357	13	3	10
ges process hash list	167,605	4	1	3

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
ASM map operation hash table	kffmTranslate	1	0
KJC message pool free list	kjcspfmbq: free vector of msg buffers	1	0
Real-time plan statistics latch	keswxAddNewPlanEntry	5	5
active checkpoint queue latch	kcbbacq: scan active checkpoints	5	5
active checkpoint queue latch	kcbkcpa: Checkpoint post-processing	1	1
cache buffers chains	kcbgtcr: fast path (cr pin)	599	727
cache buffers chains	kcbgtcr_2	210	136
cache buffers chains	kcbchg1: mod cr pin	135	90
cache buffers chains	kcbgtcr: kslbegin excl	104	161
cache buffers chains	kcbgcur_2	53	17
cache buffers chains	kcbzibmlt: multi-block read: nowait	49	0
cache buffers chains	kcbzwb	45	7
cache buffers chains	kcbgtcr: fast path	18	12
cache buffers chains	kcbgtcr: kslbegin shared	9	3
cache buffers chains	kcbrls_2	9	11
cache buffers chains	kcbget: fast exchange	6	1
cache buffers chains	kcbzgb: scan from tail. nowait	6	0
cache buffers chains	kclbla	6	0
cache buffers chains	kcbbic2	5	0
cache buffers chains	kcllkopesc	5	0
cache buffers chains	kcbbxsv	3	0
cache buffers chains	kcbchg1: clear MS bit	3	9
cache buffers chains	kcbnew: new latch again	3	0
cache buffers chains	kcbnlc	3	8
cache buffers chains	kclcls_3	3	17
cache buffers chains	kcbget: fast path	2	3
cache buffers chains	kcbget: pin buffer	2	0
cache buffers chains	kcbzib: finish processing buffer	2	1
cache buffers chains	kcbchg1: mod cur pin	1	3
cache buffers chains	kcbesc: escalate	1	0
cache buffers chains	kcbgcur_4	1	2
cache buffers chains	kcl_fairness	1	0
cache buffers chains	kclcqchk	1	0
cache buffers chains	kclwrt	1	0
cache buffers lru chain	kcbzgws	3	0
channel operations parent latch	ksrsconsume()	2	0
channel operations parent latch	ksrwait()	2	1
enqueue hash chains	ksqcmi: if lk mode not requested	2	1
enqueue hash chains	ksqcmi: if lk mode requested	1	1
enqueue hash chains	ksqrcl	1	1
gc element	kclnfndnewm	23	1
gc element	KCLUNLNK	2	0
gc element	kclchkping	1	0
gc element	kclfwrite1	1	0
gc element	kclulb	1	1
gcs resource hash	kjbassume	1	0
gcs resource hash	kjbcrcomplete	1	0
gcs resource hash	kjbcropen	1	0
ges process hash list	kjakiqa: set inquiry response	1	0
ges process parent latch	kjata_fg	44	0
ges resource hash list	kjlrlr: remove lock from resource queue	40	0
ges resource hash list	kjrmas1: lookup master node	16	1
ges resource hash list	kjakcai: search for resp by resname	10	24
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	5	11
ges resource hash list	kjrref: find matched resource	5	8
ges resource hash list	kjakoca: search for resp by resname	1	19
kokc descriptor allocation latch	kokcdlt: regular free	1	0
lgwr LWN SCN	kcs023	1	0
messages	ksarcv	6	5
messages	ksaamb: after wakeup	2	3
messages	ksarcr: inside loop	1	0
mostly latch-free SCN	kcslcu3	2	3
redo allocation	kcrfw_redo_gen: redo allocation 1	4	0
redo allocation	kcrfw_post: more space	1	1
redo allocation	kcrfw_redo_write: before write	1	0
redo writing	kcrfwcr	2	2
row cache objects	kqreqd: reget	5	0
row cache objects	kqrpre: find obj	5	10
row cache objects	kqreqd	1	1
shared pool	kghalo	10	5
shared pool	kghfre	1	3
simulator hash latch	kcbsacc: lookup dba	23	23
space background task latch	ktsj_grab_task	3	3

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglhdgn2 106	22
Library Cache	kglpnal2 91	21
Cursor Pin	kksfbc [KKSCHLPIN1]	8
Cursor Pin	kksfbc [KKSCHLFSP2]	6
Cursor Pin	kksLockDelete [KKSCHLPIN6]	4
Library Cache	kgllkal1 80	3
Library Cache	kgllkc1 57	3
Library Cache	kgllkdl1 85	3
Library Cache	kglpnal1 90	2
Library Cache	kglhdgn1 62	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: 3,548,456,310
Captured Segments account for 99.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
CC	TAB_CC	CC_MDB_CHANGE_NOTIF	TABLE	2,600,260,624	73.28
CC	TAB_CC	IDX_OLC_SEQUENCE_TNAME	INDEX	513,092,528	14.46
CC	TAB_CC	PROD	TABLE	182,243,728	5.14
CC	TAB_CC	RTQM_RERATING_SUBS	TABLE	54,773,824	1.54
CC	TAB_CC	IDX_OLC_UPDATE_TIME	INDEX	52,805,824	1.49

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.51	Soft Parse %:	99.76
Execute to Parse %:	45.50	Latch Hit %:	99.73
Parse CPU to Parse Elapsd %:	45.09	% Non-Parse CPU:	99.80

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
CC	TAB_CC	IDX_OLC_KEYI1	INDEX	1,054	2.64
CC	TAB_CC	RTQM_RERATING_SUBS	TABLE	955	2.39
CC	TAB_CC	PROD	TABLE	532	1.33
CC	TAB_CC	OLC_MDB_CHANGE_NOTIF	TABLE	314	0.79
CC	TAB_CC	SUBS_IDENTIFY	TABLE	303	0.76

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
CC	TAB_CC	IDX_CC_TNAME_SEQUENCE	INDEX	103,760	25.28
CC	TAB_CC	CC_MDB_CHANGE_NOTIF	TABLE	99,760	24.30
CC	TAB_CC	OLC_MDB_SEQUENCE	TABLE	55,856	13.61
CC	TAB_CC	CC_MDB_SEQUENCE	TABLE	33,536	8.17
MDB	TAB_MDB	TT_MDB_SEQUENCE	TABLE	25,984	6.33

Owner	Tablespace Name	Object Name	Obj. Type	ITL Waits	% of Capture
CC	IDX_CC	PK_RTQM_QUERY_DATA_USAGE_HIS	INDEX	3	60.00
CC	IDX_CC	PK_WF_WORK_ORDER	INDEX	1	20.00
CC	IDX_CC	PK_WF_WORK_ORDER_ATTR	INDEX	1	20.00

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
CC	TAB_CC	ORDER_ITEM	TABLE	86,473	45.64
CC	TAB_CC	IDX_CC_TNAME_SEQUENCE	INDEX	17,517	9.25
MDB	TAB_MDB	TT_MDB_SEQUENCE	TABLE	7,035	3.71
CC	TAB_CC	PROD_ATTR_VALUE	TABLE	6,783	3.58
CC	TAB_CC	CC_MDB_SEQUENCE	TABLE	4,604	2.43

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	64	1.56	1	1
dc_constraints	15	46.67	15	120
dc_files	92	0.00	0	23
dc_global_oids	123,008	0.03	4	256
dc_histogram_data	72,423	0.57	0	5,403
dc_histogram_defs	110,389	0.65	0	6,806
dc_object_grants	274	12.77	0	138
dc_objects	220,284	0.54	96	29,281
dc_profiles	386	0.00	0	2
dc_rollback_segments	2,961,454	0.00	0	162
dc_segments	24,624	1.03	37	6,948
dc_sequences	3,604	17.18	3,604	44
dc_table_scns	1	100.00	0	0
dc_tablespaces	94,744	0.00	0	11
dc_users	161,075	0.01	0	5,423
global database name	4,572	0.00	0	2
outstanding_alerts	48	100.00	0	8
rule_info	8	100.00	0	0

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	567	0.35	0		0	0
APP CONTEXT	1	100.00	2	50.00	0	0
BODY	748	6.02	5,300	0.98	6	0
CLUSTER	330	0.30	333	0.30	0	0
DBLINK	1,039	0.00	0		0	0
DIRECTORY	1	100.00	2	100.00	0	0
EDITION	218	0.00	413	0.00	0	0
INDEX	20	55.00	20	65.00	2	0
JAVA DATA	4	50.00	4	50.00	0	0
JAVA RESOURCE	4	50.00	4	50.00	0	0
JAVA SOURCE	4	50.00	4	50.00	0	0
OBJECT ID	20	100.00	0		0	0
QUEUE	912	0.22	3,430	0.23	2	0
RULE	11	36.36	11	36.36	0	0
RULESET	32	25.00	1,004	1.20	0	0
SCHEMA	1,168	0.17	0		0	0
SQL AREA	367,216	0.73	2,028,398	0.33	500	140
SQL AREA BUILD	2,453	91.11	0		0	0
SQL AREA STATS	2,394	97.83	2,394	97.83	0	0
SUBSCRIPTION	5	80.00	5	80.00	0	0
TABLE/PROCEDURE	116,449	0.66	177,325	1.01	411	0
TRANSFORMATION	357	0.00	357	0.00	0	0
TRIGGER	45	4.44	7,107	0.06	2	0

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
ACCOUNT_STATUS	567	0	0
BODY	0	5,199	5,199
CLUSTER	333	333	333
DBLINK	1,039	0	0
DIRECTORY	0	2	2
EDITION	218	218	218
INDEX	20	20	20
JAVA DATA	4	4	4
JAVA RESOURCE	4	4	4
JAVA SOURCE	4	4	4
QUEUE	2,132	3,419	3,419
RULE	11	11	11
RULESET	35	1,000	1,000
SCHEMA	211	0	0
SUBSCRIPTION	0	5	5
TABLE/PROCEDURE	14,966	165,580	165,580
TRANSFORMATION	357	357	357
TRIGGER	4	7,107	7,107

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	1,472.00	1,472.00	1,472.00	2,048.00	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	2,048.00	2,048.00	2,048.00	2,048.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	0.00	0.00	0.00	0.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	128.00	128.00	128.00	128.00	STA/
large pool	256.00	256.00	256.00	256.00	STA/
shared pool	1,488.00	1,488.00	1,024.00	1,488.00	GRO/IMM
streams pool	112.00	112.00	0.00	112.00	GRO/IMM

	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	793.60		3.95	6.45	44	137	201	201
B	Freeable	202.19	0.00	1.66	4.50	30		122	122
B	SQL	70.84	65.01	0.42	3.34	41	207	168	121
B	PL/SQL	3.86	2.87	0.02	0.03	0	0	201	200
E	Other	795.13		3.90	6.41	44	137	204	204
E	Freeable	207.00	0.00	1.60	4.38	30		129	129
E	SQL	54.78	47.97	0.32	3.13	41	207	171	123
E	PL/SQL	3.85	2.85	0.02	0.03	0	0	204	203

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,543,503,872
Fixed Size	2,258,480
Redo Buffers	15,106,048
Variable Size	2,080,377,296

Pool	Name	Begin MB	End MB	% Diff
java	free memory	128.00	128.00	0.00
large	free memory	255.63	255.63	0.00
shared	ASH buffers	51.20	51.20	0.00
shared	KGLH0	384.27	363.49	-5.41
shared	KGLHD	59.66	55.52	-6.94
shared	KGLNA	27.14	22.91	-15.59
shared	KGLS	17.17	20.44	19.03
shared	KQR L PO	25.58		-100.00
shared	KQR X PO	37.26	38.49	3.31
shared	SQLA	197.91	277.82	40.37
shared	SQLP	76.57	16.10	-78.97
shared	dbwriter coalesce buffer	16.02	16.02	0.00
shared	dirty object counts array	16.00	16.00	0.00
shared	free memory	62.70	76.30	21.69
shared	gcs resources	57.51	57.51	0.00
shared	gcs shadows	39.82	39.82	0.00
shared	ges enqueues	25.73	25.73	0.00
shared	ges resource	56.74	56.05	-1.21
shared	kglsim heap	20.99	20.99	0.00
shared	kglsim object batch	36.05	36.05	0.00
streams	free memory	111.94	111.94	0.00
	buffer_cache	1,472.00	1,472.00	0.00
	fixed_sga	2.15	2.15	0.00
	log_buffer	14.41	14.41	0.00

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	1124 15:58:37	0.12	0.00	0.00
QMON Slaves	0227 10:01:02	-0.48	-0.55	0.00

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/app/admin/cc/adump
audit_trail	NONE
cluster_database	TRUE
compatible	11.2.0.0.0
control_files	+CCDATA/cc/controlfile/current.293.831683181, +CCDATA/cc/controlfile/current.294.831683181, +CCDATA/cc/controlfile/current.295.831683181
db_block_size	8192
db_cache_size	1543503872
db_create_file_dest	+CCDATA
db_domain
db_name	cc
diagnostic_dest	/oracle/app
event
instance_number	1
java_pool_size	134217728
large_pool_size	268435456
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.205.6.133)(PORT=1521))
log_archive_dest_1	LOCATION=+CCARCH
log_archive_format	%t_%s_%r.arc
open_cursors	300
pga_aggregate_target	2147483648
plsql_warnings	DISABLE:ALL
processes	500
remote_listener	PRQMRAC-scan:1521
remote_login_passwordfile	EXCLUSIVE
resource_limit	TRUE
service_names	cc
sessions	800
shared_pool_size	1560281088
spfile	+CCDATA/cc/spfilecc.ora
thread	1
undo_tablespace	UNDOTBS1

	Per Second	Per Transaction
Global Cache blocks received:	73.55	2.12
Global Cache blocks served:	149.80	4.33
GCS/GES messages received:	359.27	10.38
GCS/GES messages sent:	263.93	7.62
DBWR Fusion writes:	1.80	0.05
Estd Interconnect traffic (KB)	1,908.53

Buffer access - local cache %:	99.98
Buffer access - remote cache %:	0.01
Buffer access - disk %:	0.01

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	1.5
Avg global cache current block receive time (ms):	0.8
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 %:	22.8
Avg global cache cr block flush time (ms):	3.0
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.2
Avg global cache current block flush time (ms):	3.0

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	1.0
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	19.45
% of indirect sent messages:	51.73
% of flow controlled messages:	28.81

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	67,916	19.01	0.55
acks for commit broadcast(logical)	70,615	19.76	0.57
broadcast msgs on commit(actual)	128,063	35.84	1.04
broadcast msgs on commit(logical)	132,816	37.17	1.07
broadcast msgs on commit(wasted)	4,193	1.17	0.03
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	123,885	34.67	1.00
gcs ast xid	22	0.01	0.00
gcs blocked converts	59,540	16.66	0.48
gcs blocked cr converts	87,543	24.50	0.71
gcs compatible basts	3,160	0.88	0.03
gcs compatible cr basts (global)	16,663	4.66	0.13
gcs compatible cr basts (local)	146,160	40.90	1.18
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	5,178	1.45	0.04
gcs dbwr write request msgs	3,340	0.93	0.03
gcs delta msgs sent	0	0.00	0.00
gcs delta push aborted by cancel	0	0.00	0.00
gcs delta push aborted by remastering	0	0.00	0.00
gcs delta push cancelled	0	0.00	0.00
gcs delta push cancelled at master	0	0.00	0.00
gcs delta push cancelled by close	0	0.00	0.00
gcs delta push cancelled by consign	0	0.00	0.00
gcs delta push cancelled by cvt ping	0	0.00	0.00
gcs delta push cancelled by dwncvt	0	0.00	0.00
gcs delta push create pi	0	0.00	0.00
gcs delta update master msgs sent	0	0.00	0.00
gcs delta wait aborted by remastering	0	0.00	0.00
gcs delta wait cancelled	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs force cr block only	0	0.00	0.00
gcs force cr grant	3	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	6,525	1.83	0.05
gcs immediate (null) converts	90,060	25.20	0.73
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	142,067	39.76	1.15
gcs indirect ast	123,965	34.69	1.00
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	123,965	34.69	1.00
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	4,047	1.13	0.03
gcs msgs process time(ms)	25,470	7.13	0.21
gcs msgs received	1,234,402	345.46	9.98
gcs new served by master	1,929	0.54	0.02
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	72	0.02	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	20	0.01	0.00
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	0	0.00	0.00
gcs reader bypass grant X on assume	0	0.00	0.00
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	0	0.00	0.00
gcs reader bypass grant immediate	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	13	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	38	0.01	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	20,536	5.75	0.17
gcs side channel msgs logical	298,413	83.51	2.41
gcs stale cr	2,221	0.62	0.02
gcs undo cr	336	0.09	0.00
gcs write notification msgs	266	0.07	0.00
gcs writes refused	54	0.02	0.00
ges msgs process time(ms)	796	0.22	0.01
ges msgs received	49,330	13.81	0.40
global posts dropped	0	0.00	0.00
global posts queue time	691	0.19	0.01
global posts queued	348	0.10	0.00
global posts requested	436	0.12	0.00
global posts sent	348	0.10	0.00
implicit batch messages received	60,328	16.88	0.49
implicit batch messages sent	77,445	21.67	0.63
lmd msg send time(ms)	25	0.01	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	198,189	55.47	1.60
messages queue sent actual	408,994	114.46	3.31
messages queue sent logical	279,148	78.12	2.26
messages received actual	748,126	209.37	6.05
messages received logical	1,283,732	359.27	10.38
messages sent directly	133,800	37.45	1.08
messages sent indirectly	355,852	99.59	2.88
messages sent not implicit batched	1,878	0.53	0.02
messages sent pbatched	330,861	92.59	2.67
msgs causing lmd to send msgs	21,798	6.10	0.18
msgs causing lms(s) to send msgs	21,081	5.90	0.17
msgs received queue time (ms)	17,829	4.99	0.14
msgs received queued	1,283,747	359.27	10.38
msgs sent queue time (ms)	21,723	6.08	0.18
msgs sent queue time on ksxp (ms)	579,894	162.29	4.69
msgs sent queued	563,492	157.70	4.55
msgs sent queued on ksxp	607,474	170.01	4.91
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	216,887	60.70	1.75
process batch messages sent	149,646	41.88	1.21

Statistic	Total
CR Block Requests	49,880
CURRENT Block Requests	2,414
Data Block Requests	49,880
Undo Block Requests	290
TX Block Requests	2,050
Current Results	41,293
Private results	58
Zero Results	10,934
Disk Read Results	9
Fail Results	0
Fairness Down Converts	13,639
Fairness Clears	1,573
Free GC Elements	0
Flushes	11,899
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	536
Errors	0

WORKLOAD REPOSITORY report for

Report Summary

Main Report

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

Key Instance Activity Stats

Other 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

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	24	79.17	20.83	0.00	0.00	0.00
Flushes	1,100	9.00	89.91	1.00	0.09	0.00
Writes	6,425	0.87	85.77	13.09	0.19	0.08

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	67,987	69.61	29.25	1.14	187,471	89.10	1.30	9.60
2	undo header	3,729	93.70	4.77	1.53	82	81.71	17.07	1.22
2	Others	443	97.07	1.35	1.58	1,926	97.56	0.16	2.28
2	undo block	1,223	93.30	5.15	1.55	0

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	1.60	0.43	4.41	0.46	0.84	0.62	9.32	1.78
2	undo header	0.60	0.37	5.19	0.36	2.11	0.44	10.26	0.33
2	others	0.47	0.43	4.02	0.41	0.39	0.38	4.98	0.46
2	undo block	0.58	0.43	3.35	0.43

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	47,329	100.00	0.00	167,042	100.00	0.00
2	undo header	0	3,494	100.00	0.00	67	100.00	0.00
2	others	0	430	100.00	0.00	1,879	100.00	0.00
2	undo block	0	1,141	100.00	0.00	0

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	1.06	0.46
Parallel Query	0.00	0.00
DB Locks	0.07	0.10
DB Streams	0.00	0.00
Other	0.00	0.01

Name	Total	per Remaster Op	Begin Snap	End Snap
remaster ops	2	1.00
remastered objects	2	1.00
replayed locks received	3,702	1,851.00
replayed locks sent	31,816	15,908.00
resources cleaned	0	0.00
remaster time (s)	1.2	0.58
quiesce time (s)	0.2	0.09
freeze time (s)	0.0	0.02
cleanup time (s)	0.1	0.03
replay time (s)	0.1	0.04
fixwrite time (s)	0.0	0.01
sync time (s)	0.8	0.41
affinity objects			149	149