[oracle@xjocsdb1:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin]$ cat awrrpt_1_7480_7484.html AWR Report for DB: BILLDB, Inst: billdb1, Snaps: 7480-7484

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

BILLDB 1725412641 billdb1 1 10-Sep-13 12:09 11.2.0.3.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
BILLDB	1725412641	billdb1	1	10-Sep-13 12:09	11.2.0.3.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

xjocsdb1 AIX-Based Systems (64-bit) 12 6 61.50

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
xjocsdb1	AIX-Based Systems (64-bit)	12	6		61.50

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 7480 10-Sep-13 15:00:21 65 .8

End Snap: 7484 10-Sep-13 19:00:34 527 1.0

Elapsed: 240.22 (mins)

DB Time: 61,629.23 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	7480	10-Sep-13 15:00:21	65	.8
End Snap:	7484	10-Sep-13 19:00:34	527	1.0
Elapsed:		240.22 (mins)
DB Time:		61,629.23 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 20,224M 20,224M Std Block Size: 8K

Shared Pool Size: 2,752M 2,752M Log Buffer: 22,088K

	Begin	End
Buffer Cache:	20,224M	20,224M	Std Block Size:	8K
Shared Pool Size:	2,752M	2,752M	Log Buffer:	22,088K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 256.6 169.3 21.91 12.30

DB CPU(s): 0.0 0.0 0.00 0.00

Redo size: 17,559.2 11,589.5

Logical reads: 274.4 181.1

Block changes: 33.3 22.0

Physical reads: 169.3 111.8

Physical writes: 2.7 1.8

User calls: 20.9 13.8

Parses: 3.5 2.3

Hard parses: 0.7 0.4

W/A MB processed: 0.1 0.1

Logons: 0.3 0.2

Executes: 11.7 7.7

Rollbacks: 0.0 0.0

Transactions: 1.5

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	256.6	169.3	21.91	12.30
DB CPU(s):	0.0	0.0	0.00	0.00
Redo size:	17,559.2	11,589.5
Logical reads:	274.4	181.1
Block changes:	33.3	22.0
Physical reads:	169.3	111.8
Physical writes:	2.7	1.8
User calls:	20.9	13.8
Parses:	3.5	2.3
Hard parses:	0.7	0.4
W/A MB processed:	0.1	0.1
Logons:	0.3	0.2
Executes:	11.7	7.7
Rollbacks:	0.0	0.0
Transactions:	1.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

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

Library Hit %: 90.35 Soft Parse %: 81.09

Execute to Parse %: 70.00 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 76.70 % Non-Parse CPU: 97.71

Shared Pool Statistics

Begin End

Memory Usage %: 77.53 88.14

% SQL with executions>1: 86.42 41.32

% Memory for SQL w/exec>1: 85.46 46.65

	Begin	End
Memory Usage %:	77.53	88.14
% SQL with executions>1:	86.42	41.32
% Memory for SQL w/exec>1:	85.46	46.65

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
library cache lock	892	3,695,592	4143041	99.94	Concurrency
DB CPU		537		0.01
db file scattered read	14,852	272	18	0.01	User I/O
SQL*Net more data from dblink	76,942	114	1	0.00	Network
log file sync	22,903	16	1	0.00	Commit

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

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

0.19 0.52 3.3 1.7 0.2 95.0

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.19	0.52	3.3	1.7	0.2	95.0

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

2.6 51.6 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 62,976.0 62,976.0

SGA use (MB): 23,360.0 23,360.0

PGA use (MB): 332.7 922.3

% Host Mem used for SGA+PGA: 37.62 38.56

	Begin	End
Host Mem (MB):	62,976.0	62,976.0
SGA use (MB):	23,360.0	23,360.0
PGA use (MB):	332.7	922.3
% Host Mem used for SGA+PGA:	37.62	38.56

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 2.04 1.34

Global Cache blocks served: 1.56 1.03

GCS/GES messages received: 485.17 320.22

GCS/GES messages sent: 422.28 278.72

DBWR Fusion writes: 0.24 0.16

Estd Interconnect traffic (KB) 206.04

	Per Second	Per Transaction
Global Cache blocks received:	2.04	1.34
Global Cache blocks served:	1.56	1.03
GCS/GES messages received:	485.17	320.22
GCS/GES messages sent:	422.28	278.72
DBWR Fusion writes:	0.24	0.16
Estd Interconnect traffic (KB)	206.04

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

Buffer access - local cache %: 43.74

Buffer access - remote cache %: 0.87

Buffer access - disk %: 55.39

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 642.6

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

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

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

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

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

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

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

Avg message received queue time (ms): 0.1

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.6

% of direct sent messages: 66.18

% of indirect sent messages: 33.53

% of flow controlled messages: 0.29

Cluster Interconnect

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

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
en5	169.254.30.35	N

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 3697753.9s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
connection management call elapsed time	3,696,953.53	99.98
sql execute elapsed time	733.42	0.02
DB CPU	537.38	0.01
parse time elapsed	17.78	0.00
hard parse elapsed time	11.69	0.00
PL/SQL execution elapsed time	2.88	0.00
sequence load elapsed time	1.97	0.00
PL/SQL compilation elapsed time	0.26	0.00
hard parse (sharing criteria) elapsed time	0.25	0.00
repeated bind elapsed time	0.02	0.00
failed parse elapsed time	0.00	0.00
DB time	3,697,753.89
background cpu time	3,896.02
background elapsed time	3,393.41

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
AVG_BUSY_TIME	71,005
AVG_IDLE_TIME	1,373,358
AVG_IOWAIT_TIME	2,381
AVG_SYS_TIME	23,691
AVG_USER_TIME	46,648
BUSY_TIME	859,900
IDLE_TIME	16,488,252
IOWAIT_TIME	33,821
SYS_TIME	292,195
USER_TIME	567,705
LOAD	0	1
OS_CPU_WAIT_TIME	1,271,200
VM_IN_BYTES	6,762,504
VM_OUT_BYTES	1,730,232,312
PHYSICAL_MEMORY_BYTES	66,035,122,176
NUM_CPUS	12
NUM_CPU_CORES	6
NUM_LCPUS	12
NUM_VCPUS	6
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_DEFAULT	16,384
TCP_RECEIVE_SIZE_MAX	9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	9,223,372,036,854,775,807
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
10-Sep 15:00:21	0.19
10-Sep 16:00:24	0.90	3.01	1.70	1.31	96.99	0.13
10-Sep 17:00:28	1.11	6.97	5.15	1.82	93.03	0.04
10-Sep 18:00:31	0.78	6.41	4.39	2.02	93.59	0.06
10-Sep 19:00:34	0.52	3.44	1.86	1.58	96.56	0.55

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 100.0% of Total DB time 3,697,753.89 (s)
Total FG Wait Time: 3,696,065.51 (s) DB CPU time: 537.38 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Concurrency	5,736	0	3,695,595	644281	99.94
DB CPU			537		0.01
User I/O	21,389	0	290	14	0.01
Network	352,880	0	115	0	0.00
Cluster	29,672	0	27	1	0.00
Other	6,084	47	17	3	0.00
Commit	22,903	0	16	1	0.00
Application	3,137	1	4	1	0.00
Administrative	3	33	0	57	0.00
Configuration	41	0	0	2	0.00
System I/O	36	0	0	1	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
library cache lock	892	3	3,695,592	4143041	0.04	99.94
db file scattered read	14,852	0	272	18	0.68	0.01
SQL*Net more data from dblink	76,942	0	114	1	3.52	0.00
log file sync	22,903	0	16	1	1.05	0.00
gcs drm freeze in enter server mode	42	48	13	314	0.00	0.00
gc cr multi block request	10,235	0	10	1	0.47	0.00
db file sequential read	1,455	0	9	6	0.07	0.00
direct path read	213	0	6	28	0.01	0.00
gc current block 2-way	7,793	0	5	1	0.36	0.00
gc cr block 2-way	6,417	0	4	1	0.29	0.00
enq: RO - fast object reuse	141	0	4	26	0.01	0.00
gc remaster	25	0	4	144	0.00	0.00
Disk file operations I/O	4,764	0	2	0	0.22	0.00
row cache lock	3,641	0	2	1	0.17	0.00
gc current grant busy	3,057	0	1	0	0.14	0.00
gc buffer busy acquire	349	0	1	3	0.02	0.00
SQL*Net message from dblink	342	0	1	3	0.02	0.00
name-service call wait	16	0	1	60	0.00	0.00
gc current block busy	535	0	1	2	0.02	0.00
db file parallel read	26	0	1	29	0.00	0.00
DFS lock handle	880	11	1	1	0.04	0.00
latch: ges resource hash list	243	0	1	2	0.01	0.00
gc current grant 2-way	701	0	1	1	0.03	0.00
enq: PS - contention	186	22	0	2	0.01	0.00
enq: FB - contention	148	0	0	2	0.01	0.00
enq: JQ - contention	99	100	0	3	0.00	0.00
cursor: pin S wait on X	40	0	0	8	0.00	0.00
SQL*Net break/reset to client	2,888	0	0	0	0.13	0.00
SQL*Net message to client	275,203	0	0	0	12.60	0.00
reliable message	440	0	0	1	0.02	0.00
library cache pin	189	0	0	1	0.01	0.00
CSS initialization	34	0	0	6	0.00	0.00
gc cr block busy	178	0	0	1	0.01	0.00
gc current multi block request	259	0	0	1	0.01	0.00
CSS operation: action	34	0	0	4	0.00	0.00
IPC send completion sync	340	0	0	0	0.02	0.00
library cache load lock	87	0	0	1	0.00	0.00
kksfbc child completion	2	100	0	50	0.00	0.00
JS kgl get object wait	1	100	0	100	0.00	0.00
PX Deq: Slave Session Stats	329	0	0	0	0.02	0.00
buffer busy waits	330	0	0	0	0.02	0.00
switch logfile command	2	0	0	35	0.00	0.00
enq: TX - index contention	16	0	0	3	0.00	0.00
local write wait	51	0	0	1	0.00	0.00
library cache: mutex X	445	0	0	0	0.02	0.00
read by other session	11	0	0	4	0.00	0.00
enq: HW - contention	30	0	0	1	0.00	0.00
control file sequential read	36	0	0	1	0.00	0.00
enq: TM - contention	73	51	0	0	0.00	0.00
CSS operation: query	102	0	0	0	0.00	0.00
gc cr grant 2-way	77	0	0	0	0.00	0.00
enq: KO - fast object checkpoint	29	0	0	1	0.00	0.00
PX Deq: reap credit	2,592	100	0	0	0.12	0.00
PX Deq: Signal ACK RSG	160	0	0	0	0.01	0.00
latch: gc element	99	0	0	0	0.00	0.00
enq: TX - allocate ITL entry	8	0	0	1	0.00	0.00
latch: cache buffers chains	86	0	0	0	0.00	0.00
enq: SQ - contention	2	0	0	3	0.00	0.00
gc current block congested	10	0	0	1	0.00	0.00
direct path write	16	0	0	0	0.00	0.00
log file switch completion	1	0	0	5	0.00	0.00
SQL*Net more data from client	5	0	0	1	0.00	0.00
enq: TS - contention	14	0	0	0	0.00	0.00
gc buffer busy release	24	0	0	0	0.00	0.00
enq: JS - job run lock - synchronize	10	100	0	0	0.00	0.00
gc cr block congested	5	0	0	1	0.00	0.00
PX Deq: Signal ACK EXT	160	0	0	0	0.01	0.00
rdbms ipc reply	4	0	0	1	0.00	0.00
enq: MD - contention	6	0	0	0	0.00	0.00
enq: UL - contention	4	100	0	0	0.00	0.00
SQL*Net message from client	275,160	0	266,065	967	12.60
jobq slave wait	28,005	100	13,982	499	1.28
PX Deq: Execution Msg	676	0	1	1	0.03
PX Deq: Execute Reply	160	0	1	4	0.01
PX Deq: Join ACK	160	0	0	2	0.01
PX Deq: Parse Reply	160	0	0	1	0.01
single-task message	1	0	0	40	0.00
KSV master wait	16	0	0	2	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
os thread startup	587	0	42	72	0.03	1.24
Streams AQ: qmn coordinator waiting for slave to start	3	100	18	6039	0.00	0.53
control file sequential read	40,183	0	17	0	1.84	0.51
db file sequential read	7,095	0	13	2	0.32	0.39
log file parallel write	32,820	0	11	0	1.50	0.31
ges lms sync during dynamic remastering and reconfig	132	73	9	67	0.01	0.26
DFS lock handle	2,807	18	5	2	0.13	0.15
gc current block 2-way	9,691	0	4	0	0.44	0.10
db file parallel write	10,223	0	3	0	0.47	0.09
log file sequential read	142	0	2	17	0.01	0.07
control file parallel write	5,835	0	2	0	0.27	0.07
reliable message	1,261	0	2	2	0.06	0.06
CSS operation: data query	707	0	1	2	0.03	0.04
gc cr block 2-way	3,904	0	1	0	0.18	0.04
gc cr grant 2-way	5,217	0	1	0	0.24	0.04
kjbdrmcvtq lmon drm quiesce: ping completion	14	0	1	84	0.00	0.03
enq: WF - contention	79	0	1	13	0.00	0.03
gcs log flush sync	2,795	0	1	0	0.13	0.03
CGS wait for IPC msg	131,281	100	1	0	6.01	0.03
ASM file metadata operation	4,879	0	1	0	0.22	0.02
CSS initialization	112	0	1	6	0.01	0.02
row cache lock	460	0	1	1	0.02	0.02
ADR block file read	60	0	0	8	0.00	0.01
CSS operation: action	250	0	0	2	0.01	0.01
libcache interrupt action by LCK	39,351	0	0	0	1.80	0.01
enq: FB - contention	96	0	0	3	0.00	0.01
Log archive I/O	9	0	0	31	0.00	0.01
gc current grant busy	843	0	0	0	0.04	0.01
ksxr poll remote instances	31,126	100	0	0	1.43	0.01
row cache process	57,403	0	0	0	2.63	0.01
CSS group membership query	235	0	0	1	0.01	0.01
enq: HW - contention	47	0	0	3	0.00	0.00
enq: CF - contention	87	94	0	2	0.00	0.00
Disk file operations I/O	1,248	0	0	0	0.06	0.00
enq: CR - block range reuse ckpt	49	0	0	3	0.00	0.00
row cache cleanup	45,759	0	0	0	2.10	0.00
enq: TM - contention	104	60	0	1	0.00	0.00
enq: PS - contention	62	23	0	2	0.00	0.00
gc current grant 2-way	376	0	0	0	0.02	0.00
name-service call wait	8	0	0	12	0.00	0.00
gc current multi block request	158	0	0	1	0.01	0.00
CSS operation: query	571	0	0	0	0.03	0.00
gc current block busy	66	0	0	1	0.00	0.00
SQL*Net break/reset to client	220	0	0	0	0.01	0.00
log file sync	55	0	0	1	0.00	0.00
ges generic event	7	100	0	10	0.00	0.00
LGWR wait for redo copy	407	0	0	0	0.02	0.00
enq: TA - contention	42	0	0	2	0.00	0.00
latch free	29	0	0	2	0.00	0.00
ges inquiry response	91	0	0	0	0.00	0.00
PX Deq: reap credit	6,748	100	0	0	0.31	0.00
latch: ges resource hash list	308	0	0	0	0.01	0.00
enq: TD - KTF dump entries	28	0	0	1	0.00	0.00
direct path write	55	0	0	1	0.00	0.00
enq: RO - fast object reuse	76	0	0	0	0.00	0.00
direct path read	1	0	0	22	0.00	0.00
enq: DR - contention	8	0	0	2	0.00	0.00
enq: PI - contention	8	100	0	2	0.00	0.00
enq: TX - index contention	2	0	0	7	0.00	0.00
SQL*Net message to client	11,541	0	0	0	0.53	0.00
IPC send completion sync	48	0	0	0	0.00	0.00
gc cr block busy	15	0	0	1	0.00	0.00
PX Deq: Slave Session Stats	72	0	0	0	0.00	0.00
SQL*Net more data to client	453	0	0	0	0.02	0.00
PX Deq: Signal ACK RSG	72	0	0	0	0.00	0.00
latch: call allocation	78	0	0	0	0.00	0.00
asynch descriptor resize	3,772	100	0	0	0.17	0.00
db file async I/O submit	10,223	0	0	0	0.47	0.00
gc buffer busy acquire	5	0	0	1	0.00	0.00
gc cr multi block request	12	0	0	0	0.00	0.00
enq: KO - fast object checkpoint	15	0	0	0	0.00	0.00
wait for scn ack	2	0	0	3	0.00	0.00
SQL*Net more data from client	453	0	0	0	0.02	0.00
library cache lock	3	0	0	2	0.00	0.00
ADR block file write	20	0	0	0	0.00	0.00
enq: MW - contention	8	0	0	0	0.00	0.00
buffer busy waits	18	0	0	0	0.00	0.00
KJC: Wait for msg sends to complete	29	0	0	0	0.00	0.00
PX Deq: Signal ACK EXT	72	0	0	0	0.00	0.00
log file single write	8	0	0	0	0.00	0.00
gc cr grant congested	3	0	0	0	0.00	0.00
gc current block congested	2	0	0	1	0.00	0.00
rdbms ipc message	337,379	69	345,603	1024	15.45
Space Manager: slave idle wait	7,189	95	34,745	4833	0.33
wait for unread message on broadcast channel	28,833	100	28,826	1000	1.32
gcs remote message	2,511,970	89	28,761	11	115.03
DIAG idle wait	303,142	56	28,445	94	13.88
class slave wait	938	0	19,956	21275	0.04
Streams AQ: qmn slave idle wait	514	1	14,619	28442	0.02
smon timer	114	26	14,530	127453	0.01
shared server idle wait	481	100	14,430	30001	0.02
Streams AQ: qmn coordinator idle wait	1,007	50	14,416	14316	0.05
ASM background timer	2,935	0	14,415	4911	0.13
PING	5,755	19	14,414	2505	0.26
GCR sleep	2,882	100	14,410	5000	0.13
pmon timer	4,803	100	14,406	2999	0.22
dispatcher timer	240	100	14,400	60001	0.01
PX Idle Wait	177	0	14,350	81075	0.01
ges remote message	91,141,281	96	11,485	0	4,173.71
Streams AQ: waiting for time management or cleanup tasks	223	66	9,715	43564	0.01
SQL*Net message from client	14,728	0	8	1	0.67
KSV master wait	8,942	97	0	0	0.41
PX Deq: Join ACK	72	0	0	2	0.00
PX Deq: Parse Reply	72	0	0	1	0.00
PX Deq: Execute Reply	72	0	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	1,019	100	0	0	0.05

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	60	28.3	10.0	16.7	25.0	15.0	1.7	3.3
ADR block file write	20	100.0
ADR file lock	24	100.0
ARCH wait for archivelog lock	6	100.0
ASM file metadata operation	4886	99.2	.3	.3	.1			.0
CGS wait for IPC msg	131.3K	100.0	.0
CSS group membership query	235	89.8	8.1	2.1
CSS initialization	146	50.0				47.3	2.1	.7
CSS operation: action	284	43.7	4.6	45.8	6.0
CSS operation: data query	707	2.4	88.5	8.3	.7
CSS operation: query	673	91.7	7.4	.9
DFS lock handle	3688	88.0	5.8	1.5	1.1	1.9	.8	.9
Disk file operations I/O	6013	93.9	5.7	.3	.0	.0
IPC send completion sync	388	99.0	.5	.5
JS kgl get object wait	1							100.0
KJC: Wait for msg sends to complete	140	100.0
LGWR wait for redo copy	408	99.5	.2					.2
Log archive I/O	9	22.2	11.1	11.1				55.6
PX Deq: Signal ACK EXT	232	99.6	.4
PX Deq: Signal ACK RSG	232	99.6			.4
PX Deq: Slave Session Stats	401	98.5	.5	1.0
PX Deq: reap credit	9341	100.0
SQL*Net break/reset to client	3110	98.7	.9	.3	.1			.0
SQL*Net message from dblink	342	29.2	49.4	6.4	5.8	6.1	2.0	.9
SQL*Net message to client	286.9K	100.0
SQL*Net message to dblink	341	100.0
SQL*Net more data from client	458	99.3	.4	.2
SQL*Net more data from dblink	76.9K	86.4	1.8	2.0	3.1	4.7	1.7	.2
SQL*Net more data to client	500	100.0
Streams AQ: qmn coordinator waiting for slave to start	3								100.0
asynch descriptor resize	3772	100.0
buffer busy waits	348	94.8	4.0	.3	.6	.3
buffer deadlock	10	100.0
control file parallel write	5835	97.7	1.0	.5	.3	.3	.1	.1
control file sequential read	40.2K	96.7	1.1	.6	.7	.5	.3	.0
cursor: mutex X	1	100.0
cursor: pin S	1	100.0
cursor: pin S wait on X	40	20.0	12.5	10.0	15.0	35.0	2.5	5.0
db file async I/O submit	10.2K	100.0
db file parallel read	26				3.8	19.2	53.8	23.1
db file parallel write	10.2K	98.2	1.0	.4	.2	.1	.1
db file scattered read	14.9K	.4	.0	1.1	1.9	51.8	38.7	6.1
db file sequential read	8582	61.0	3.1	8.8	20.6	5.4	.7	.3
direct path read	214			7.9	10.7	41.6	19.2	20.6
direct path write	71	94.4	1.4	4.2
direct path write temp	1	100.0
enq: CF - contention	87	94.3	1.1		1.1		2.3	1.1
enq: CR - block range reuse ckpt	49	89.8	2.0		2.0	2.0		4.1
enq: DR - contention	8	62.5	12.5		25.0
enq: FB - contention	247	83.4	2.8	3.2	1.6	3.2	3.6	2.0
enq: HW - contention	78	78.2	6.4	5.1	1.3	3.8	5.1
enq: JQ - contention	99	67.7	9.1	2.0	9.1	9.1	1.0	2.0
enq: JS - job run lock - synchronize	10	100.0
enq: KO - fast object checkpoint	44	95.5		2.3		2.3
enq: MD - contention	6	100.0
enq: MW - contention	8	87.5	12.5
enq: PI - contention	8	62.5	25.0			12.5
enq: PS - contention	248	86.7	2.8	2.0	.8	5.2	.8	1.6
enq: RO - fast object reuse	217	93.1	.9	.9				4.6	.5
enq: SQ - contention	2			100.0
enq: TA - contention	42	92.9	4.8					2.4
enq: TD - KTF dump entries	28	92.9				7.1
enq: TM - contention	177	93.8	2.3	1.1	.6	1.1	1.1
enq: TO - contention	1	100.0
enq: TS - contention	14	100.0
enq: TT - contention	3	100.0
enq: TX - allocate ITL entry	8	87.5			12.5
enq: TX - index contention	19	31.6	21.1	21.1	21.1	5.3
enq: TX - row lock contention	2	100.0
enq: UL - contention	4	100.0
enq: WF - contention	79	83.5	5.1	5.1	1.3		1.3	3.8
gc buffer busy acquire	354	54.8	31.1	6.8	4.0	.8	.6	2.0
gc buffer busy release	29	100.0
gc cr block 2-way	10.3K	97.6	1.2	.6	.3	.1	.1	.1
gc cr block busy	195	77.9	16.4	2.1	2.1	1.5
gc cr block congested	5	80.0	20.0
gc cr disk read	1	100.0
gc cr failure	1	100.0
gc cr grant 2-way	5294	99.7	.2	.1	.0
gc cr grant congested	3	100.0
gc cr multi block request	10.2K	82.6	15.2	1.5	.5	.1	.1
gc current block 2-way	17.5K	97.6	1.6	.5	.1	.1	.0	.0
gc current block busy	608	68.9	17.9	6.7	3.3	2.6	.3	.2
gc current block congested	12	100.0
gc current grant 2-way	1097	94.8	2.7	1.3	.2	.4	.5	.2
gc current grant busy	3892	97.8	1.3	.6	.2	.0		.0
gc current grant congested	1	100.0
gc current multi block request	417	97.1	1.4	.5	.7	.2
gc current retry	3	100.0
gc current split	2	100.0
gc object scan	2	100.0
gc quiesce	1	100.0
gc remaster	25	4.0						96.0
gcs drm freeze in enter server mode	41	26.8				7.3	2.4	63.4
gcs log flush sync	2806	97.5	1.4	.5	.2	.3	.0
ges generic event	7					100.0
ges inquiry response	91	98.9				1.1
ges lms sync during dynamic remastering and reconfig	132		.8	.8	25.0	.8	.8	72.0
ges2 LMON to wake up LMD - mrcvr	1	100.0
global enqueue expand wait	1	100.0
kjbdrmcvtq lmon drm quiesce: ping completion	14	42.9						57.1
kksfbc child completion	2							100.0
ksxr poll remote instances	31.1K	100.0		.0
latch free	34	76.5			23.5
latch: active service list	15	100.0
latch: cache buffers chains	108	100.0
latch: cache buffers lru chain	1	100.0
latch: call allocation	79	97.5	1.3	1.3
latch: checkpoint queue latch	1	100.0
latch: gc element	134	99.3		.7
latch: gcs resource hash	15	100.0
latch: ges resource hash list	551	69.1	11.6	6.2	12.3	.5	.2
latch: object queue header operation	14	100.0
latch: row cache objects	1	100.0
latch: shared pool	7	100.0
libcache interrupt action by LCK	39.4K	100.0	.0
library cache load lock	87	56.3	5.7	35.6	1.1	1.1
library cache lock	477	44.2	1.7	1.5	1.0	.2	.4		50.9
library cache pin	192	92.2	1.6	1.0	2.1		3.1
library cache: mutex X	445	99.1	.2			.7
local write wait	51	78.4	15.7	5.9
lock escalate retry	1	100.0
log file parallel write	32.8K	97.2	1.3	.7	.2	.3	.1	.0
log file sequential read	142	19.7	2.1	.7	24.6	19.0	12.7	21.1
log file single write	8	100.0
log file switch completion	1				100.0
log file sync	23K	93.0	3.4	2.0	.7	.5	.2	.1
name-service call wait	24	12.5		8.3	8.3	16.7	8.3	45.8
os thread startup	587							100.0
rdbms ipc reply	4	75.0	25.0
read by other session	12	50.0	8.3	8.3	16.7	16.7
reliable message	1701	88.5	8.2	1.9	.7	.4	.1	.2
row cache cleanup	45.8K	100.0
row cache lock	4105	93.7	3.2	1.0	.6	.7	.5	.2
row cache process	57.4K	100.0		.0
switch logfile command	2					50.0		50.0
wait for scn ack	2			100.0
ASM background timer	2934	1.1	.0	.1	.1	.1	.0	.4	98.3
DIAG idle wait	303.1K	42.5	.1	.1	.7	2.6	4.1	50.0
GCR sleep	2883								100.0
KSV master wait	8958	99.7	.1	.1	.0			.0
PING	5755	79.4	1.1	.0					19.5
PX Deq: Execute Reply	232	59.9	3.9	1.7	28.4	6.0
PX Deq: Execution Msg	676	79.0	13.9	2.7	2.4	1.2	.9
PX Deq: Join ACK	232	58.2	23.7	9.9	3.4	2.2	2.6
PX Deq: Parse Reply	232	81.0	11.6	6.0	.9	.4
PX Idle Wait	169	11.8	11.8	5.9	1.2	13.0	3.6	14.2	38.5
SQL*Net message from client	290K	33.9	13.3	3.9	1.2	35.9	2.2	7.0	2.6
Space Manager: slave idle wait	7194	.1		.1	.1		.1	1.9	97.6
Streams AQ: RAC qmn coordinator idle wait	1019	100.0
Streams AQ: qmn coordinator idle wait	1007	49.2	.5	.1		.1			50.1
Streams AQ: qmn slave idle wait	514								100.0
Streams AQ: waiting for time management or cleanup tasks	223	32.7						33.2	34.1
class slave wait	938	42.6	.5	17.7	3.8	4.2	1.1	2.6	27.5
dispatcher timer	240								100.0
gcs remote message	2512K	6.2	1.4	1.3	1.9	66.5	22.7	.0
ges remote message	91.1M	99.8	.0	.0	.0	.0	.0	.1
jobq slave wait	28K		.0	.0	.0	.0	.0	99.9
pmon timer	4802								100.0
rdbms ipc message	337.4K	15.3	.9	2.0	1.0	.6	.7	56.9	22.5
shared server idle wait	481								100.0
single-task message	1							100.0
smon timer	116	2.6	.9		4.3	2.6	1.7	18.1	69.8
wait for unread message on broadcast channel	28.8K					.0		100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s
		% of Total Waits
ADR block file read	2	96.7	1.7		1.7
ASM file metadata operation	1	100.0		.0
CSS initialization	1	99.3	.7
DFS lock handle	32	99.1	.5	.3	.1
JS kgl get object wait	1			100.0
LGWR wait for redo copy	1	99.8	.2
Log archive I/O	5	44.4	33.3	22.2
SQL*Net break/reset to client	1	100.0		.0
SQL*Net message from dblink	3	99.1	.3	.6
SQL*Net more data from dblink	181	99.8	.2	.0	.0
control file parallel write	4	99.9	.1
control file sequential read	10	100.0	.0	.0	.0
cursor: pin S wait on X	2	95.0	5.0
db file parallel read	6	76.9	15.4	7.7
db file scattered read	899	93.9	4.7	1.1	.2	.0
db file sequential read	27	99.7	.2	.0	.0
direct path read	44	79.4	10.7	6.1	3.7
enq: CF - contention	1	98.9	1.1
enq: CR - block range reuse ckpt	2	95.9	4.1
enq: FB - contention	5	98.0	2.0
enq: JQ - contention	2	98.0	2.0
enq: PS - contention	4	98.4	1.6
enq: RO - fast object reuse	11	94.9	.9	.9	.5	2.3		.5
enq: TA - contention	1	97.6	2.4
enq: WF - contention	3	96.2			1.3	2.5
gc buffer busy acquire	7	98.0	.6	.8	.6
gc cr block 2-way	8	99.9	.0	.0	.0
gc current block 2-way	8	100.0	.0	.0	.0	.0
gc current block busy	1	99.8			.2
gc current grant 2-way	2	99.8	.2
gc current grant busy	1	100.0	.0
gc remaster	24	4.0		32.0	64.0
gcs drm freeze in enter server mode	26	36.6			2.4	61.0
ges lms sync during dynamic remastering and reconfig	95	28.0	41.7	18.9	9.8	1.5
kjbdrmcvtq lmon drm quiesce: ping completion	8	42.9			57.1
kksfbc child completion	2		100.0
log file parallel write	9	100.0	.0		.0
log file sequential read	30	78.9	19.0	2.1
log file sync	26	99.9	.1	.0	.0
name-service call wait	11	54.2	12.5	33.3
os thread startup	587		.5	99.5
reliable message	3	99.8		.1	.1		.1
row cache lock	7	99.8	.2
switch logfile command	1	50.0	50.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	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
Streams AQ: qmn coordinator waiting for slave to start	3		100.0
library cache lock	64	49.1	.4	2.5	4.2	2.3	4.0	37.5

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

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

Event	Waits 4m to 1h	<2m	<4m	<8m	<1/4h	<1/2h	< 1h	>=1h
		% of Total Waits
library cache lock	172	62.5	3.4	6.5	13.0	12.6	.6	1.5

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)
billdb	3,695,677	146	0	0
serv_taf_billdb	797	368	2,434	3,436
SYS$USERS	787	23	0	212
SYS$BACKGROUND	0	0	7	306
billdbXDB	0	0	0	0
serv_taf_billdb1	0	0	0	0
serv_taf_billdb2	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
serv_taf_billdb	20747	289	4705	3	349292	115
SYS$USERS	605	1	170	17	3133	0
SYS$BACKGROUND	8399	14	40441	43	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 0.0% of Total DB Time (s): 3,697,754
Captured PL/SQL account for 0.0% of Total DB Time (s): 3,697,754

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
156.53	1	156.53	30.72	64.24	73uh7u65w0yy5	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
150.01	1	150.01	30.72	64.00	2z1fmtmsy3ywt	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
133.71	1	133.71	14.30	0.00	9tgf9n221jjha	SQL*Plus	SELECT 'XXXX', a.acc_nbr, to_c...
119.36	1	119.36	31.06	62.81	308dns8g1xwuk	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
101.73	5	20.35	91.77	5.91	4n9qbagp365rm	JDBC Thin Client	select acc_nbr, ACCT_ID, sum(S...
19.43	4	4.86	30.62	48.76	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
11.40	53	0.22	79.30	1.58	b4qw7n9wg64mh		INSERT /*+ APPEND LEADING(@"SE...
10.97	3	3.66	10.55	80.79	47mm81hm9sggy		SELECT sum(case when a.sessio...
10.14	9,348	0.00	67.49	0.00	fbzsh1af230p6	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	select PRICING_PLAN_ID, DETAIL...
9.28	4	2.32	97.40	0.34	bunssq950snhf		insert into wrh$_sga_target_ad...

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 57.2% of Total CPU Time (s): 537
Captured PL/SQL account for 2.5% of Total CPU Time (s): 537

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
93.36	5	18.67	17.37	101.73	91.77	5.91	4n9qbagp365rm	JDBC Thin Client	select acc_nbr, ACCT_ID, sum(S...
48.09	1	48.09	8.95	156.53	30.72	64.24	73uh7u65w0yy5	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
46.08	1	46.08	8.58	150.01	30.72	64.00	2z1fmtmsy3ywt	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
37.07	1	37.07	6.90	119.36	31.06	62.81	308dns8g1xwuk	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
19.12	1	19.12	3.56	133.71	14.30	0.00	9tgf9n221jjha	SQL*Plus	SELECT 'XXXX', a.acc_nbr, to_c...
9.04	4	2.26	1.68	9.28	97.40	0.34	bunssq950snhf		insert into wrh$_sga_target_ad...
9.04	53	0.17	1.68	11.40	79.30	1.58	b4qw7n9wg64mh		INSERT /*+ APPEND LEADING(@"SE...
6.84	9,348	0.00	1.27	10.14	67.49	0.00	fbzsh1af230p6	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	select PRICING_PLAN_ID, DETAIL...
6.69	187	0.04	1.25	8.66	77.25	8.40	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
5.95	4	1.49	1.11	19.43	30.62	48.76	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
5.50	480	0.01	1.02	5.60	98.17	0.00	aykvshm7zsabd		select size_for_estimate, size...

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 97.6% of Total User I/O Wait Time (s): 304
Captured PL/SQL account for 3.4% of Total User I/O Wait Time (s): 304

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
100.55	1	100.55	33.11	156.53	30.72	64.24	73uh7u65w0yy5	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
96.01	1	96.01	31.61	150.01	30.72	64.00	2z1fmtmsy3ywt	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
74.97	1	74.97	24.69	119.36	31.06	62.81	308dns8g1xwuk	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
9.48	4	2.37	3.12	19.43	30.62	48.76	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
8.87	3	2.96	2.92	10.97	10.55	80.79	47mm81hm9sggy		SELECT sum(case when a.sessio...
6.01	5	1.20	1.98	101.73	91.77	5.91	4n9qbagp365rm	JDBC Thin Client	select acc_nbr, ACCT_ID, sum(S...
1.77	9,348	0.00	0.58	4.21	50.74	41.97	3h2pzu63d08xb	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	insert into sms_cf_mid_his(SMS...
1.52	4,556	0.00	0.50	3.26	34.20	46.73	dky3swb1whdab	JDBC Thin Client	insert into t_bss_log (id, lin...
1.45	2,768	0.00	0.48	5.77	62.59	25.18	4vs91dcv7u1p6	sqlplus@xjocsapp1 (TNS V1-V3)	insert into sys.aud$( sessioni...
0.96	9,028	0.00	0.32	2.22	53.30	43.52	grkd14sawxdj0	AM_Server_A11@xjocsapp1 (TNS V1-V3)	INSERT INTO TRANS_LOG(AGT_ACCE...

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,955,211
Captured SQL account for 91.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
692,243	1	692,243.00	17.50	156.53	30.7	64.2	73uh7u65w0yy5	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
659,422	1	659,422.00	16.67	150.01	30.7	64	2z1fmtmsy3ywt	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
574,274	5	114,854.80	14.52	101.73	91.8	5.9	4n9qbagp365rm	JDBC Thin Client	select acc_nbr, ACCT_ID, sum(S...
517,544	1	517,544.00	13.09	119.36	31.1	62.8	308dns8g1xwuk	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
280,495	9,348	30.01	7.09	10.14	67.5	0	fbzsh1af230p6	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	select PRICING_PLAN_ID, DETAIL...
167,062	9,348	17.87	4.22	4.21	50.7	42	3h2pzu63d08xb	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	insert into sms_cf_mid_his(SMS...
148,619	187	794.75	3.76	8.66	77.2	8.4	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
113,373	4	28,343.25	2.87	19.43	30.6	48.8	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
91,712	53	1,730.42	2.32	11.40	79.3	1.6	b4qw7n9wg64mh		INSERT /*+ APPEND LEADING(@"SE...
77,156	9,028	8.55	1.95	3.58	73.6	22.7	0vttswnff2ub6	AM_Server_A11@xjocsapp1 (TNS V1-V3)	INSERT INTO PAYMENT ( PAYMENT_...
68,058	9,028	7.54	1.72	2.22	53.3	43.5	grkd14sawxdj0	AM_Server_A11@xjocsapp1 (TNS V1-V3)	INSERT INTO TRANS_LOG(AGT_ACCE...
57,235	4,556	12.56	1.45	3.26	34.2	46.7	dky3swb1whdab	JDBC Thin Client	insert into t_bss_log (id, lin...
55,128	16,234	3.40	1.39	1.01	96.5	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
54,200	9,028	6.00	1.37	1.63	98.4	0	5mbcr43rdqmty	AM_Server_A11@xjocsapp1 (TNS V1-V3)	select expire_days, cash_days,...

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: 2,440,705
Captured SQL account for 99.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
687,464	1	687,464.00	28.17	156.53	30.72	64.24	73uh7u65w0yy5	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
654,835	1	654,835.00	26.83	150.01	30.72	64.00	2z1fmtmsy3ywt	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
574,017	5	114,803.40	23.52	101.73	91.77	5.91	4n9qbagp365rm	JDBC Thin Client	select acc_nbr, ACCT_ID, sum(S...
512,985	1	512,985.00	21.02	119.36	31.06	62.81	308dns8g1xwuk	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
6,538	4	1,634.50	0.27	19.43	30.62	48.76	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
6,439	3	2,146.33	0.26	10.97	10.55	80.79	47mm81hm9sggy		SELECT sum(case when a.sessio...
505	1	505.00	0.02	0.25	10.71	87.37	2ufyv4bfbjhc7	TOAD 10.1.1.8	select count(*) from Contrast_...
403	4,556	0.09	0.02	3.26	34.20	46.73	dky3swb1whdab	JDBC Thin Client	insert into t_bss_log (id, lin...
384	17	22.59	0.02	0.32	15.16	72.89	dgyz6h8s3g25z	SQL*Plus	SELECT 'XXX', nvl(flag, '0') f...
362	1	362.00	0.01	0.27	7.53	87.79	g162gqkkzyp5z	JDBC Thin Client	select msisdn, divert, brand, ...

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: 30,701
Captured SQL account for 63.4% of Total
Total UnOptimized Read Requests: 30,701
Captured SQL account for 63.4% 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
6,538	6,538	4	1,634.50	21.30	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
6,420	6,420	1	6,420.00	20.91	73uh7u65w0yy5	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
6,163	6,163	1	6,163.00	20.07	2z1fmtmsy3ywt	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
5,056	5,056	1	5,056.00	16.47	308dns8g1xwuk	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
959	959	5	191.80	3.12	4n9qbagp365rm	JDBC Thin Client	select acc_nbr, ACCT_ID, sum(S...
217	217	4,556	0.05	0.71	dky3swb1whdab	JDBC Thin Client	insert into t_bss_log (id, lin...
107	107	9,348	0.01	0.35	3h2pzu63d08xb	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	insert into sms_cf_mid_his(SMS...
95	95	187	0.51	0.31	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
89	89	11	8.09	0.29	9dhn1b8d88dpf		select OBJOID, CLSOID, RUNTIME...
86	86	3	28.67	0.28	350myuyx0t1d6		insert into wrh$_tablespace_st...

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: 168,733
Captured SQL account for 72.4% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
16,234	30,900	1.90	1.01	96.5	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
9,348	9,348	1.00	4.21	50.7	42	3h2pzu63d08xb	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	insert into sms_cf_mid_his(SMS...
9,348	9,348	1.00	10.14	67.5	0	fbzsh1af230p6	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	select PRICING_PLAN_ID, DETAIL...
9,028	9,028	1.00	3.58	73.6	22.7	0vttswnff2ub6	AM_Server_A11@xjocsapp1 (TNS V1-V3)	INSERT INTO PAYMENT ( PAYMENT_...
9,028	9,028	1.00	2.87	56.1	0	0wa3s6mskzavr	AM_Server_A11@xjocsapp1 (TNS V1-V3)	select pay_sn.nextval from dua...
9,028	9,028	1.00	1.63	98.4	0	5mbcr43rdqmty	AM_Server_A11@xjocsapp1 (TNS V1-V3)	select expire_days, cash_days,...
9,028	9,028	1.00	2.22	53.3	43.5	grkd14sawxdj0	AM_Server_A11@xjocsapp1 (TNS V1-V3)	INSERT INTO TRANS_LOG(AGT_ACCE...
5,528	5,528	1.00	1.49	96.1	2.2	02drdr02qj4t6	AM_Server_A12@xjocsapp1 (TNS V1-V3)	select substr(U_PROV_CODE, 2, ...
5,525	5,525	1.00	0.74	97.5	0	c9cf3jt9scn8p	AM_Server_A11@xjocsapp1 (TNS V1-V3)	select substr(U_PROV_CODE, 2, ...
4,556	4,556	1.00	0.55	44.1	36.2	21pub7j93z0dw	JDBC Thin Client	select count(*) from t_bss_log...
4,556	4,556	1.00	3.26	34.2	46.7	dky3swb1whdab	JDBC Thin Client	insert into t_bss_log (id, lin...
2,864	16,440	5.74	0.78	95.1	0	0k8522rmdzg4k		select privilege# from sysauth...
2,768	2,768	1.00	5.77	62.6	25.2	4vs91dcv7u1p6	sqlplus@xjocsapp1 (TNS V1-V3)	insert into sys.aud$( sessioni...
2,623	2,623	1.00	0.69	95.6	0	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2,623	2,623	1.00	0.40	91.9	0	459f3z9u4fb3u		select value$ from props$ wher...
2,621	2,621	1.00	0.18	97.1	0	5ur69atw3vfhj		select decode(failover_method,...
2,553	2,553	1.00	3.13	45.7	9.8	f711myt0q6cma	SQL*Plus	insert into sys.aud$( sessioni...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 50,625
Captured SQL account for 53.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,864	2,864	5.66	0k8522rmdzg4k		select privilege# from sysauth...
2,864	16,234	5.66	cm5vu20fhtnq1		select /*+ connect_by_filterin...
2,768	2,768	5.47	4vs91dcv7u1p6	sqlplus@xjocsapp1 (TNS V1-V3)	insert into sys.aud$( sessioni...
2,623	2,623	5.18	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2,623	2,623	5.18	459f3z9u4fb3u		select value$ from props$ wher...
2,620	2,621	5.18	5ur69atw3vfhj		select decode(failover_method,...
2,553	2,553	5.04	f711myt0q6cma	SQL*Plus	insert into sys.aud$( sessioni...
793	793	1.57	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
530	530	1.05	1uzhrfn574t12	sqlplus@xjocsapp1 (TNS V1-V3)	SELECT ATTRIBUTE, SCOPE, NUMER...
530	530	1.05	c4pc3jhzjcmc7	sqlplus@xjocsapp1 (TNS V1-V3)	SELECT CHAR_VALUE FROM SYSTEM....
530	530	1.05	d6vwqbw6r2ffk	sqlplus@xjocsapp1 (TNS V1-V3)	SELECT USER FROM DUAL
530	530	1.05	dyk4dprp70d74	SQL*Plus	SELECT DECODE('A', 'A', '1', '...
530	530	1.05	g4y6nw3tts7cc	sqlplus@xjocsapp1 (TNS V1-V3)	BEGIN DBMS_APPLICATION_INFO.SE...
529	530	1.04	5qgz1p0cut7mx	sqlplus@xjocsapp1 (TNS V1-V3)	BEGIN DBMS_OUTPUT.DISABLE; END...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

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

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
4.81	4	14.15	19.43	24.74	30.62	48.76	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
4.60	1	13.53	150.01	3.06	30.72	64.00	2z1fmtmsy3ywt	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
4.58	1	13.49	119.36	3.84	31.06	62.81	308dns8g1xwuk	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
4.44	1	13.07	156.53	2.84	30.72	64.24	73uh7u65w0yy5	SQL*Plus	INSERT INTO dd_ocs_balance_pay...
3.62	9,348	10.67	10.14	35.75	67.49	0.00	fbzsh1af230p6	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	select PRICING_PLAN_ID, DETAIL...
2.58	3	7.59	3.75	68.85	41.04	0.00	dyj1ssw8jw54f		SELECT sum(case when a.sessio...
2.26	2,768	6.65	5.77	39.15	62.59	25.18	4vs91dcv7u1p6	sqlplus@xjocsapp1 (TNS V1-V3)	insert into sys.aud$( sessioni...
1.68	2,553	4.94	3.13	53.63	45.72	9.75	f711myt0q6cma	SQL*Plus	insert into sys.aud$( sessioni...
1.29	3	3.79	10.97	11.73	10.55	80.79	47mm81hm9sggy		SELECT sum(case when a.sessio...
0.70	53	2.05	11.40	6.12	79.30	1.58	b4qw7n9wg64mh		INSERT /*+ APPEND LEADING(@"SE...
0.55	411	1.63	0.94	58.71	5.61	36.31	db78fxqxwxt7r		select /+ rule / bucket, end...
0.48	9,028	1.42	2.87	16.77	56.07	0.00	0wa3s6mskzavr	AM_Server_A11@xjocsapp1 (TNS V1-V3)	select pay_sn.nextval from dua...
0.46	187	1.35	8.66	5.31	77.25	8.40	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0.43	4,556	1.28	3.26	13.35	34.20	46.73	dky3swb1whdab	JDBC Thin Client	insert into t_bss_log (id, lin...
0.38	1	1.13	0.40	95.21	2.75	0.00	c5fmmsfz0cm07	SQL*Plus	update t_ocs_report_A_daybak s...
0.37	3	1.10	1.02	36.92	67.93	0.00	74g6ka8ncc1jb		WITH ash as (SELECT ash.event...
0.35	2	1.03	0.74	47.43	59.21	0.00	8h01dqpvft7r3		WITH awr_evts as (SELECT e.eve...
0.31	1,522	0.90	0.59	52.25	41.56	1.16	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
0.18	206	0.54	0.30	62.00	41.03	0.67	aq8yqxyyb40nn		update sys.job$ set this_date=...
0.18	5	0.54	0.50	36.78	59.70	0.77	bjstq78pprd24	SQL Loader Direct Path Load	SELECT DECODE(ELEMENT_SUBSTITU...
0.18	218	0.52	0.54	32.86	65.78	36.98	cumjq42201t37		select u1.user#, u2.user#, u3....
0.13	4,556	0.37	0.55	22.92	44.12	36.23	21pub7j93z0dw	JDBC Thin Client	select count(*) from t_bss_log...
0.09	203	0.27	0.15	62.63	40.24	7.09	axmdf8vq7k1rh		select increment$, minvalue, m...
0.09	9,348	0.26	4.21	2.11	50.74	41.97	3h2pzu63d08xb	sms_tpl_A12@xjocsapp1 (TNS V1-V3)	insert into sms_cf_mid_his(SMS...
0.08	376	0.24	0.19	42.90	59.89	0.51	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
0.07	9,028	0.20	3.58	1.90	73.62	22.74	0vttswnff2ub6	AM_Server_A11@xjocsapp1 (TNS V1-V3)	INSERT INTO PAYMENT ( PAYMENT_...
0.07	450	0.19	0.12	54.00	41.49	11.19	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
0.06	90	0.18	0.20	30.13	48.17	22.72	7vcwzqf7mgk3b	EM_PING	INSERT INTO MGMT_JOB_EXECUTION...
0.04	42	0.13	0.05	84.72	20.10	0.00	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
0.04	1,438	0.12	0.34	12.00	89.24	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
0.03	123	0.09	0.05	64.00	36.55	4.89	9tgj4g8y4rwy8		select type#, blocks, extents,...
0.03	2	0.08	0.17	15.53	17.51	0.01	g06u2yjd1mxmx	Reservation_stop_sign_A11@xjocsapp1 (TNS V1-V3)	select Msisdn, Brand, divert, ...
0.03	4	0.08	0.10	25.65	77.33	0.00	6wm3n4d7bnddg		SELECT source, (case when tim...
0.03	138	0.07	1.04	2.42	46.85	5.50	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
0.02	32	0.06	0.16	13.56	86.88	0.00	0njp59jttu2z9	Oracle Enterprise Manager.rollup	DELETE MGMT_METRICS_RAW WHERE ...
0.02	17	0.06	0.32	6.43	15.16	72.89	dgyz6h8s3g25z	SQL*Plus	SELECT 'XXX', nvl(flag, '0') f...
0.02	97	0.06	0.11	18.04	83.12	2.39	b84cknyvnyq25		update user$ set exptime=DECOD...
0.02	27	0.06	0.04	51.11	6.76	43.99	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
0.02	106	0.05	0.07	25.18	77.76	27.75	38t3pnrp90uxy		select exptime, ltime, astatus...
0.02	9,028	0.05	2.22	0.78	53.30	43.52	grkd14sawxdj0	AM_Server_A11@xjocsapp1 (TNS V1-V3)	INSERT INTO TRANS_LOG(AGT_ACCE...
0.02	4	0.05	0.09	18.18	83.34	0.00	61tn3mam0vq0b		SELECT source, (case when tim...
0.02	88	0.05	0.10	16.82	67.62	7.00	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.01	81	0.04	0.03	37.82	57.66	11.87	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
0.01	2	0.03	0.27	4.11	13.84	82.91	fnk7155mk2jq6		insert into wrh$_sysmetric_his...
0.01	85	0.03	0.04	30.33	34.41	40.60	gx4mv66pvj3xz		select con#, type#, condlength...
0.01	2	0.03	0.48	2.21	96.87	0.00	99h68qgna1qcj		WITH a as (SELECT a$.dbid, a$....
0.01	258	0.03	0.32	3.21	19.55	77.96	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
0.01	135	0.03	0.07	14.52	28.72	57.02	3ktacv9r56b51		select owner#, name, namespace...
0.01	3	0.03	0.77	1.24	77.73	19.91	84k66tf2s7y1c		insert into wrh$_bg_event_summ...
0.01	2	0.03	0.14	6.96	92.87	0.00	586b2udq6dbng		insert into wrh$_sysstat (snap...
0.01	27	0.03	0.02	48.45	10.12	43.97	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
0.01	5	0.03	0.32	2.75	89.10	0.00	cnumpcz520unc		SELECT COUNT(*) FROM ALL_OBJEC...
0.01	1	0.02	0.25	3.37	10.71	87.37	2ufyv4bfbjhc7	TOAD 10.1.1.8	select count(*) from Contrast_...
0.01	73	0.02	0.40	2.11	64.82	0.00	38spc81t7bjwy	SQL*Plus	declare TYPE attrs_cur IS REF ...
0.01	1	0.02	0.27	2.95	7.53	87.79	g162gqkkzyp5z	JDBC Thin Client	select msisdn, divert, brand, ...
0.01	2	0.02	0.01	97.91	2.95	0.00	dcstr36r0vz0d		select procedure#, procedurena...
0.01	206	0.02	0.05	14.62	81.69	0.04	47a50dvdgnxc2		update sys.job$ set failures=0...
0.01	1	0.02	0.07	10.24	78.90	0.00	72a4rwjjmhtu0	SQL*Plus	insert into b_load_field sele...
0.01	3	0.02	0.61	1.14	97.49	0.00	4dy1xm4nxc0gf		insert into wrh$_system_event ...
0.01	137	0.02	0.04	18.08	74.46	0.00	83taa7kaw59c1		select name, intcol#, segcol#,...
0.01	4	0.02	9.28	0.07	97.40	0.34	bunssq950snhf		insert into wrh$_sga_target_ad...
0.01	2	0.02	0.07	8.78	92.06	0.00	cd1dfrzuta22f		WITH awr_params as ( SELECT /*...
0.01	135	0.02	0.02	25.67	33.37	44.30	8swypbbr0m372		select order#, columns, types ...
0.01	3	0.02	0.44	1.27	96.80	0.97	7g732rx16j8jc		insert into WRH$_SERVICE_STAT ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

02drdr02qj4t6 select substr(U_PROV_CODE, 2, 2), U_LONG_CODE from city_list where long_code = '990'

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

0kkhhb2w93cx0 update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3

0njp59jttu2z9 DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1

0vttswnff2ub6 INSERT INTO PAYMENT ( PAYMENT_ID, PAYMENT_METHOD, PARTY_ROLE_ID, PAYED_METHOD, OPERATION_TYPE, OPERATED_PAYMENT_SERIAL_NBR, AMOUNT, PAYMENT_DATE, STATE, ACCT_ID, CREATED_DATE, SERV_ID, STAFF_ORG_ID, NBR_ORG_ID, STATE_DATE, OP_CODE ) VALUES (:v1, :v2, :v3, :v4, :v5, :v6, :v7, to_date(:v8, 'yyyymmddhh24miss'), :v9, :v10, to_date(:v11, 'yyyymmddhh24miss'), :v12, :v13, :v14, sysdate, :v15)

0wa3s6mskzavr select pay_sn.nextval from dual

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

18naypzfmabd6 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))

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

1uzhrfn574t12 SELECT ATTRIBUTE, SCOPE, NUMERIC_VALUE, CHAR_VALUE, DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LIKE USERID)

21pub7j93z0dw select count(*) from t_bss_log where session_id=:1 and type=:2 and line=:3

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

2ufyv4bfbjhc7 select count(*) from Contrast_to_bss

2z1fmtmsy3ywt INSERT INTO dd_ocs_balance_payout_B1_std SELECT * FROM tmp_balance_payout_B a WHERE to_char(a.oper_date, 'yyyymm')='201309' and not exists(SELECT 1 FROM ocsa11.acct_item_type_desc t where t.item_kind=10 AND t.acct_item_type_id=a.acct_item_type_id)

308dns8g1xwuk INSERT INTO dd_ocs_balance_payout_A1_std SELECT * FROM tmp_balance_payout_A a WHERE to_char(a.oper_date, 'yyyymm')='201309' and not exists(SELECT 1 FROM ocsa11.acct_item_type_desc t where t.item_kind=10 AND t.acct_item_type_id=a.acct_item_type_id)

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

350myuyx0t1d6 insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#

38spc81t7bjwy declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt varchar2(512); m_ret varchar2(3000); m_ret1 varchar2(512); m_o_stmt VARCHAR2(5120); begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select sys.dbms_standard.login_user from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; if((instr(upper(m_name), 'MDRT_')>0) and m_event='DROP') then return; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='CREATE') then m_stmt:='select sdo_geor_def.listAllGeoRasterFieldsStr(:1, :2) from dual'; execute immediate m_stmt into m_ret using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name); m_ret:=trim(m_ret); while (length(m_ret)!=0) loop if (instr(m_ret, ' $$__## ')!=0) then m_ret1:=trim(substr(m_ret, 1, instr(m_ret, ' $$__## ')-1)); m_ret:=trim(substr(m_ret, instr(m_ret, ' $$__## ')+8)); else m_ret1:=trim(m_ret); m_ret:=''; end if; m_stmt:='begin SDO_GEOR_UTL.createDMLTrigger(:1, :2); end;'; execute immediate m_stmt using m_owner||'.'||m_name, SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME(m_ret1); end loop; return; end if; if (m_name!='MDSYS' and m_type='USER' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner !='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='TRUNCATE') then m_stmt:='call sdo_geor_def.doTruncateTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='call sdo_geor_def.doAlterRenameTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='RENAME') then m_stmt:='call sdo_geor_def.doRenameTable()'; execute immediate m_stmt; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='delete from sdo_geor_ddl__table$$ where id=2'; EXECUTE IMMEDIATE m_stmt; end if; if ((m_type='USER' and m_event='DROP') or (m_type='TABLESPACE' and m_event='DROP')) then m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; end if; Exception when others then if(sqlcode= -13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''||m_stmt||''')'; execute immediate m_stmt; end if; end;

38t3pnrp90uxy select exptime, ltime, astatus, lcount from user$ where user#=:1

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)

3h2pzu63d08xb insert into sms_cf_mid_his(SMS_ID , MSISND , TMPLT_ID , INS_TIME , PROC_TIME, PROC_STAT, SND_TIME , Arg1 , Arg2 , Arg3 , Arg4 , Arg5 , Arg6 , Arg7 , Arg8 , Arg9 , Arg10) values (:v1 , :v2 , :v3 , :v4, to_char(sysdate, 'yyyymmddhh24miss') , '0000' , :v5, :v6 , :v7 , :v8 , :v9 , :v10 , :v11 , :v12 , :v13 , :v14 , :v15 )

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

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

47a50dvdgnxc2 update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4

47mm81hm9sggy SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid

4dy1xm4nxc0gf insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id

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

4n9qbagp365rm select acc_nbr, ACCT_ID, sum(SHOULD_PAY-FAVOUR_FEE-MONTH_WRTOFF_FEE-PAY_WRTOFF_FEE) fee from acct_item group by acc_nbr, ACCT_ID having(sum(SHOULD_PAY-FAVOUR_FEE-MONTH_WRTOFF_FEE-PAY_WRTOFF_FEE))>0 order by acc_nbr, ACCT_ID

4vs91dcv7u1p6 insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)

586b2udq6dbng insert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id

5mbcr43rdqmty select expire_days, cash_days, max_days from charge_expire_days where min_value<=:v1 and max_value>=:v2 and (region_code=:v3 or region_code=:v4) order by region_code asc

5ms6rbzdnq16t select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job

5qgz1p0cut7mx BEGIN DBMS_OUTPUT.DISABLE; END;

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

61tn3mam0vq0b SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_nam e = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGR OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

72a4rwjjmhtu0 insert into b_load_field select 'a2o_ACCT_BALANCE_185912[@]', COLUMN_ID , column_name, COLUMN_ID , decode(data_type, 'DATE', 14, data_length+1), decode(data_type, 'DATE', 'date', 'varchar'), '' from user_tab_columns a where table_name=upper('DD_OCS_ACCT_BALANCE_A1_STD2') and a.COLUMN_NAME not like 'PARTITION_%' order by a.COLUMN_ID

73uh7u65w0yy5 INSERT INTO dd_ocs_balance_payout_B2_std SELECT * FROM tmp_balance_payout_B a WHERE to_char(a.oper_date, 'yyyymm')='201309' and not exists(SELECT 1 FROM ocsa11.acct_item_type_desc t where t.item_kind=10 AND t.acct_item_type_id=a.acct_item_type_id)

74g6ka8ncc1jb WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count(*) as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND ash.snap_id > :bid AND ash.snap_id <= :eid AND ash.wait_time = 0 GROUP BY ash.event_id ), evts as (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt, sum(w_time) as w_time , sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg, sum(w_time_fg) as w_time_fg FROM (SELECT es.event_id as event_id, es.total_waits - nvl(bs.total_waits, 0) as w_cnt, es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS, 0) as to_cnt, es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO, 0) as w_time , es.total_waits_fg - nvl(bs.total_waits_fg, 0) as w_cnt_fg, es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG, 0) as to_cnt_fg, es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG, 0) as w_time_fg FROM WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs WHERE es.dbid = :dbid AND es.snap_id = :eid AND bs.dbid(+) = :dbid AND bs.instance_n umber(+) = es.instance_number AND bs.snap_id(+) = :bid AND es.instance_number = bs.instance_number(+) AND es.event_id = bs.event_id(+) UNION ALL SELECT x.event_hash as event_id, 0 as w_cnt, 0 as to_cnt, 0 as w_time , 0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg FROM X$KEHEVTMAP x ) GROUP BY event_id ), awr_names as (SELECT e.event_id, e.event_name, e.wait_class_id, e.parameter1, e.parameter2, e.parameter3 FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid ), named_events as (SELECT names.event_id as event_id, names.event_name as event_name, evts.w_cnt as w_cnt, evts.to_cnt as to_cnt, evts.w_time as w_time, evts.w_cnt_fg as w_cnt_fg, evts.to_cnt_fg as to_cnt_fg, evts.w_time_fg as w_time_fg, names.wait_class_id as wait_class_id, names.parameter1 as p1, names.parameter2 as p2, names.parameter3 as p3 FROM evts, awr_names names WHERE evts.event_id = names.event_id AND names.wait_class_id <> 2723168908 ), data as (SELECT e.event_id as event_id, e.event_name as event _name, e.wait_class_id as wait_class_id, e.p1 as p1, e.p2 as p2, e.p3 as p3, e.w_cnt as total_w_cnt, e.to_cnt as total_to_cnt, e.w_time as total_w_time, e.w_cnt_fg as fg_w_cnt, e.to_cnt_fg as fg_to_cnt, e.w_time_fg as fg_w_time, nvl(a.cnt_total, 0) as total_ash_cnt, nvl(a.cnt_fg, 0) as fg_ash_cnt FROM named_events e, ash a WHERE e.event_id = a.event_id(+) ), final_query as (SELECT d.event_name, d.event_id, d.p1 as p1, case when (p1 is null OR p1 = '0') then 0 else 1 end as p1valid, d.p2 as p2, case when (p2 is null OR p2 = '0') then 0 else 1 end as p2valid, d.p3 as p3, case when (p3 is null OR p3 = '0') then 0 else 1 end as p3valid, nvl(e.keh_id, 0) as keh_evt_id, c.class# as class_num, d.wait_class_id as wait_class_id, c.keh_id as keh_ecl_id, round(d.total_ash_cnt, 0) as total_ash_cnt, round(d.fg_ash_cnt, 0) as fg_ash_cnt, round(d.fg_w_cnt, 0) as fg_w_cnt, round(d.fg_to_cnt, 0) as fg_to_cnt, round(d.fg_w_time, 0) as fg_w_time, round(d.total_w_cnt, 0) as total_w_cnt, round(d.total_to_cnt, 0) as total_to_cnt, round(d.total_w_time, 0) as total_w_time from data d, X$KEHEVTMAP e , X$KEHECLMAP c where d.event_id = e.event_hash(+) and d.wait_class_id = c.class_hash ) SELECT * FROM final_query WHERE keh_evt_id > 0 OR total_w_time > 0 ORDER BY wait_class_id, fg_w_time DESC, event_id

7g732rx16j8jc insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash

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#

7vcwzqf7mgk3b INSERT INTO MGMT_JOB_EXECUTION (JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, START_TIME, TIMEZONE_REGION) VALUES (NULL, NULL, :B5 , NULL, NULL, 0, :B4 , :B3 , :B2 , NULL, NULL, NULL, :B1 , MGMT_JOB_ENGINE.SYSDATE_UTC(), 'UTC')

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

84k66tf2s7y1c insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id

8h01dqpvft7r3 WITH awr_evts as (SELECT e.event_id, e.wait_class FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid) , en as (SELECT event_id, nvl(v.wait_class, awr_evts.wait_class) as wait_class FROM awr_evts FULL OUTER JOIN V$EVENT_NAME v USING(event_id) UNION ALL SELECT 0 as event_id, 'CPU' as wait_class FROM DUAL ) SELECT * FROM ( SELECT count(*) as cnt , a.SQL_ID, sum(decode(a.wait_time, 0, 0, 1)) as on_cpu, sum(case when a.wait_time = 0 and en.wait_class = 'User I/O' then 1 else 0 end) as io_wait, sum(case when a.wait_time = 0 and en.wait_class = 'Cluster' then 1 else 0 end) as cl_wait, sum(decode(bitand(a.time_model, power(2, 4)), 0, 0, NULL, 0, 1)) as in_parse, sum(decode(bitand(a.time_model, power(2, 14)), 0, 0, NULL, 0, 1)) as in_java, sum(decode(bitand(a.time_model, power(2, 11)+power(2, 12)), NULL, 0, 0, 0, 1)) as in_pls, max(a.sql_opcode) as opcode, sum(case when a.qc_session_id <> 0 and a.qc_session_id <> a.session_id and a.qc_instance_id <> 0 and a.qc_in stance_id <> a.instance_number then 1 else 0 end) as pq_cnt, count(distinct nvl(a.sql_plan_hash_value, 0)) as plans, count(distinct decode(nvl(a.sql_plan_hash_value, 0), 0, 1, 0)) as noplan FROM WRH$_ACTIVE_SESSION_HISTORY a , en WHERE a.dbid = :dbid AND a.snap_id > :bid AND a.snap_id <= :eid AND en.event_id = decode(a.wait_time, 0, a.event_id, 0) AND a.sql_id is NOT NULL AND a.session_type = 1 AND en.wait_class <> 'Idle' GROUP BY a.SQL_ID HAVING count(*) >= :rowcnt ORDER BY count(*) DESC, a.SQL_ID ASC ) WHERE rownum <= :ret

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

99h68qgna1qcj WITH a as (SELECT a$.dbid, a$.snap_id, a$.INSTANCE_NUMBER, a$.BLOCKING_SESSION, a$.BLOCKING_SESSION_SERIAL#, nvl(a$.blocking_inst_id, a$.instance_number) as blocking_inst_id, a$.event_id FROM WRH$_ACTIVE_SESSION_HISTORY a$ WHERE a$.dbid = :dbid AND a$.instance_number = :inst AND a$.snap_id > :bid AND a$.snap_id <= :eid AND a$.session_type = 1 AND a$.wait_time = 0 AND a$.blocking_session between 1 and 65535 ) SELECT cnt , BLOCKING_SESSION, BLOCKING_SESSION_SERIAL#, BLOCKING_INST_ID FROM ( SELECT count(*) as cnt , a.BLOCKING_SESSION, a.BLOCKING_SESSION_SERIAL#, a.BLOCKING_INST_ID FROM a WHERE a.EVENT_ID IN (:event, :event_1, :event_2, :event_3, :event_4, :event_5, :event_6, :event_7, :event_8, :event_9, :event_10, :event_11) GROUP BY BLOCKING_SESSION, BLOCKING_SESSION_SERIAL#, BLOCKING_INST_ID HAVING count(*) >= :rowcnt ORDER BY 1 DESC, 2 ASC ) WHERE rownum <= :ret

9dhn1b8d88dpf select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.nex t_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.cla ss_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID

9tgf9n221jjha SELECT 'XXXX', a.acc_nbr, to_char(a.serv_id), a.cycle_state, substr(b.run_code, 2, 1) run_code, decode(a.cycle_state, '0', 'A', '1', 'A', '2', 'B', '3', 'B', 'err') cycle_state_bss FROM serv1 a, dcustmsg@link_accdb b, serv@link_accdb c where a.serv_id=b.id_no and a.serv_id=c.serv_id and c.state<>'a' and b.sm_code='os' and a.cycle_state in('1', '2', '3') and a.state<>'01' and a.state<>'03' and a.state<>'04' and (a.cycle_state<>c.BILLING_CYCLE_TYPE_ID or decode(a.cycle_state, '0', 'A', '1', 'A', '2', 'B', '3', 'B', 'err')<>substr(b.run_code, 2, 1))

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

aq8yqxyyb40nn update sys.job$ set this_date=:1 where job=:2

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

aykvshm7zsabd select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'

b4qw7n9wg64mh INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_mo del , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /*+ PARAM('_module_action_old_length', 0) */:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_s ession_serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.d elta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')

b84cknyvnyq25 update user$ set exptime=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2), ltime=DECODE(to_char(:3, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :3), astatus = :4, lcount = :5 where user#=:1

bjstq78pprd24 SELECT DECODE(ELEMENT_SUBSTITUTABLE, ' Y', 1, 0) FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

c4pc3jhzjcmc7 SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND ((UPPER(USER) LIKE USERID) OR (USERID = 'PUBLIC')) AND (UPPER(ATTRIBUTE) = 'ROLES')

c5fmmsfz0cm07 update t_ocs_report_A_daybak set end_ora_time=sysdate, flag='1', ora_count=(select count(*) from DD_OCS_ACCT_ITEM_A2_STD) where bak_date=to_char(sysdate, 'yyyymmdd') and upper(mdb_instance)=upper('BILLA32') and upper(mdb_table_name)=upper('ACCT_ITEM') and upper(ora_table_name)=upper('DD_OCS_ACCT_ITEM_A2_STD') and begin_mdb_time=to_date('20130910183348', 'yyyymmddhh24miss') and flag='0'

c9cf3jt9scn8p select substr(U_PROV_CODE, 2, 2), U_LONG_CODE from city_list where long_code = '991'

cd1dfrzuta22f WITH awr_params as ( SELECT /*+ NO_MERGE(map) USE_HASH(map) */ p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /*+ USE_HASH(xmap) */ xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_value end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)

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

cnumpcz520unc SELECT COUNT(*) FROM ALL_OBJECT_TABLES OT, ALL_XML_TABLES XT WHERE OT.OWNER = XT.OWNER AND OT.TABLE_NAME = XT.TABLE_NAME AND XT.STORAGE_TYPE = 'CLOB' AND OT.OWNER = :OWN AND OT.TABLE_NAME = :TAB

cumjq42201t37 select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name

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

d6vwqbw6r2ffk SELECT USER FROM DUAL

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

dcstr36r0vz0d select procedure#, procedurename, properties, itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc

dgyz6h8s3g25z SELECT 'XXX', nvl(flag, '0') flag from ( select * FROM t_ocs_report_A_daybak b where b.bak_date='20130910' and nvl(ora_count, 0)>0 and nvl(notes, '0') like 'export success%' and mdb_table_name='SERV' order by begin_mdb_time) where rownum<2

dky3swb1whdab insert into t_bss_log (id, line, type, resultcode, session_id, recordtype, ip, receive_date, create_date, msisdn, serv_id, acct_id, content01, content02, content03, content04, content05, content06, content07, content08, content09 ) values(t_bss_log_seq.nextval, :1, :2, :3, :4, :5, :6, :7, sysdate, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19)

dyj1ssw8jw54f SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.snap_id > :bid AND a.snap_id <= :eid

dyk4dprp70d74 SELECT DECODE('A', 'A', '1', '2') FROM DUAL

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

fbzsh1af230p6 select PRICING_PLAN_ID, DETAIL_FLAG, NOTE, MAIN_FLAG, PRODUCT_ID, trim(NAME), NET_CARD, NET_TYPE from BSS_PRICING_COMBINE where trim(PRICING_PLAN_ID) = trim(:v1)

fnk7155mk2jq6 insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime

g06u2yjd1mxmx select Msisdn, Brand, divert, to_char(eff_date, 'YYYYMMDDHH24MISS') from serv_divert where divert in ('10') and stat = 1 and to_date(to_char(eff_date-1, 'YYYYMMDD'), 'YYYYMMDD') = to_date('20130910', 'YYYYMMDD')

g162gqkkzyp5z select msisdn, divert, brand, to_char(create_date, 'yyyymmddHH24MISS'), to_char(eff_date, 'yyyymmddHH24MISS'), stat from serv_divert where divert='00' and stat=1 and to_char(eff_date, 'yyyymm')='201309'

g4y6nw3tts7cc BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1, NULL); END;

grkd14sawxdj0 INSERT INTO TRANS_LOG(AGT_ACCEPT, PAY_ID, AGT_CODE, AGT_DATE, ACC_NBR, STAFF_ID, OP_CODE, OP_TIME, OP_MONEY, UNPAY_FLAG, REPAY_FLAG, COLLATE_FLAG, COLLATE_TIME, BAND_ID, PAYMENT_METHOD, ACNT_CODE) VALUES (:v1, :v2, :v3, TO_DATE(:v4, 'YYYY-MM-DD HH24:MI:SS'), :v5, :v6, :v7, sysdate, :v8, :v9, :v10, :v11, SYSDATE, :v12, :v13, :v14)

gx4mv66pvj3xz select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1

SQL Id	SQL Text
02drdr02qj4t6	select substr(U_PROV_CODE, 2, 2), U_LONG_CODE from city_list where long_code = '990'
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0kkhhb2w93cx0	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
0njp59jttu2z9	DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1
0vttswnff2ub6	INSERT INTO PAYMENT ( PAYMENT_ID, PAYMENT_METHOD, PARTY_ROLE_ID, PAYED_METHOD, OPERATION_TYPE, OPERATED_PAYMENT_SERIAL_NBR, AMOUNT, PAYMENT_DATE, STATE, ACCT_ID, CREATED_DATE, SERV_ID, STAFF_ORG_ID, NBR_ORG_ID, STATE_DATE, OP_CODE ) VALUES (:v1, :v2, :v3, :v4, :v5, :v6, :v7, to_date(:v8, 'yyyymmddhh24miss'), :v9, :v10, to_date(:v11, 'yyyymmddhh24miss'), :v12, :v13, :v14, sysdate, :v15)
0wa3s6mskzavr	select pay_sn.nextval from dual
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1uzhrfn574t12	SELECT ATTRIBUTE, SCOPE, NUMERIC_VALUE, CHAR_VALUE, DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LIKE USERID)
21pub7j93z0dw	select count(*) from t_bss_log where session_id=:1 and type=:2 and line=:3
2jfqzrxhrm93b	select /+ rule / c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
2ufyv4bfbjhc7	select count(*) from Contrast_to_bss
2z1fmtmsy3ywt	INSERT INTO dd_ocs_balance_payout_B1_std SELECT * FROM tmp_balance_payout_B a WHERE to_char(a.oper_date, 'yyyymm')='201309' and not exists(SELECT 1 FROM ocsa11.acct_item_type_desc t where t.item_kind=10 AND t.acct_item_type_id=a.acct_item_type_id)
308dns8g1xwuk	INSERT INTO dd_ocs_balance_payout_A1_std SELECT * FROM tmp_balance_payout_A a WHERE to_char(a.oper_date, 'yyyymm')='201309' and not exists(SELECT 1 FROM ocsa11.acct_item_type_desc t where t.item_kind=10 AND t.acct_item_type_id=a.acct_item_type_id)
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
38spc81t7bjwy	declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt varchar2(512); m_ret varchar2(3000); m_ret1 varchar2(512); m_o_stmt VARCHAR2(5120); begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select sys.dbms_standard.login_user from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; if((instr(upper(m_name), 'MDRT_')>0) and m_event='DROP') then return; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='CREATE') then m_stmt:='select sdo_geor_def.listAllGeoRasterFieldsStr(:1, :2) from dual'; execute immediate m_stmt into m_ret using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name); m_ret:=trim(m_ret); while (length(m_ret)!=0) loop if (instr(m_ret, ' $$__## ')!=0) then m_ret1:=trim(substr(m_ret, 1, instr(m_ret, ' $$__## ')-1)); m_ret:=trim(substr(m_ret, instr(m_ret, ' $$__## ')+8)); else m_ret1:=trim(m_ret); m_ret:=''; end if; m_stmt:='begin SDO_GEOR_UTL.createDMLTrigger(:1, :2); end;'; execute immediate m_stmt using m_owner\|\|'.'\|\|m_name, SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME(m_ret1); end loop; return; end if; if (m_name!='MDSYS' and m_type='USER' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner !='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='TRUNCATE') then m_stmt:='call sdo_geor_def.doTruncateTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='call sdo_geor_def.doAlterRenameTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='RENAME') then m_stmt:='call sdo_geor_def.doRenameTable()'; execute immediate m_stmt; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='delete from sdo_geor_ddl__table$$ where id=2'; EXECUTE IMMEDIATE m_stmt; end if; if ((m_type='USER' and m_event='DROP') or (m_type='TABLESPACE' and m_event='DROP')) then m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; end if; Exception when others then if(sqlcode= -13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''\|\|m_stmt\|\|''')'; execute immediate m_stmt; end if; end;
38t3pnrp90uxy	select exptime, ltime, astatus, lcount from user$ where user#=:1
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3h2pzu63d08xb	insert into sms_cf_mid_his(SMS_ID , MSISND , TMPLT_ID , INS_TIME , PROC_TIME, PROC_STAT, SND_TIME , Arg1 , Arg2 , Arg3 , Arg4 , Arg5 , Arg6 , Arg7 , Arg8 , Arg9 , Arg10) values (:v1 , :v2 , :v3 , :v4, to_char(sysdate, 'yyyymmddhh24miss') , '0000' , :v5, :v6 , :v7 , :v8 , :v9 , :v10 , :v11 , :v12 , :v13 , :v14 , :v15 )
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
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
47a50dvdgnxc2	update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
47mm81hm9sggy	SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid
4dy1xm4nxc0gf	insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4n9qbagp365rm	select acc_nbr, ACCT_ID, sum(SHOULD_PAY-FAVOUR_FEE-MONTH_WRTOFF_FEE-PAY_WRTOFF_FEE) fee from acct_item group by acc_nbr, ACCT_ID having(sum(SHOULD_PAY-FAVOUR_FEE-MONTH_WRTOFF_FEE-PAY_WRTOFF_FEE))>0 order by acc_nbr, ACCT_ID
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
586b2udq6dbng	insert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
5mbcr43rdqmty	select expire_days, cash_days, max_days from charge_expire_days where min_value<=:v1 and max_value>=:v2 and (region_code=:v3 or region_code=:v4) order by region_code asc
5ms6rbzdnq16t	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
5qgz1p0cut7mx	BEGIN DBMS_OUTPUT.DISABLE; END;
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
61tn3mam0vq0b	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_nam e = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGR OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
72a4rwjjmhtu0	insert into b_load_field select 'a2o_ACCT_BALANCE_185912[@]', COLUMN_ID , column_name, COLUMN_ID , decode(data_type, 'DATE', 14, data_length+1), decode(data_type, 'DATE', 'date', 'varchar'), '' from user_tab_columns a where table_name=upper('DD_OCS_ACCT_BALANCE_A1_STD2') and a.COLUMN_NAME not like 'PARTITION_%' order by a.COLUMN_ID
73uh7u65w0yy5	INSERT INTO dd_ocs_balance_payout_B2_std SELECT * FROM tmp_balance_payout_B a WHERE to_char(a.oper_date, 'yyyymm')='201309' and not exists(SELECT 1 FROM ocsa11.acct_item_type_desc t where t.item_kind=10 AND t.acct_item_type_id=a.acct_item_type_id)
74g6ka8ncc1jb	WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count() as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND ash.snap_id > :bid AND ash.snap_id <= :eid AND ash.wait_time = 0 GROUP BY ash.event_id ), evts as (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt, sum(w_time) as w_time , sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg, sum(w_time_fg) as w_time_fg FROM (SELECT es.event_id as event_id, es.total_waits - nvl(bs.total_waits, 0) as w_cnt, es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS, 0) as to_cnt, es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO, 0) as w_time , es.total_waits_fg - nvl(bs.total_waits_fg, 0) as w_cnt_fg, es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG, 0) as to_cnt_fg, es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG, 0) as w_time_fg FROM WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs WHERE es.dbid = :dbid AND es.snap_id = :eid AND bs.dbid(+) = :dbid AND bs.instance_n umber(+) = es.instance_number AND bs.snap_id(+) = :bid AND es.instance_number = bs.instance_number(+) AND es.event_id = bs.event_id(+) UNION ALL SELECT x.event_hash as event_id, 0 as w_cnt, 0 as to_cnt, 0 as w_time , 0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg FROM X$KEHEVTMAP x ) GROUP BY event_id ), awr_names as (SELECT e.event_id, e.event_name, e.wait_class_id, e.parameter1, e.parameter2, e.parameter3 FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid ), named_events as (SELECT names.event_id as event_id, names.event_name as event_name, evts.w_cnt as w_cnt, evts.to_cnt as to_cnt, evts.w_time as w_time, evts.w_cnt_fg as w_cnt_fg, evts.to_cnt_fg as to_cnt_fg, evts.w_time_fg as w_time_fg, names.wait_class_id as wait_class_id, names.parameter1 as p1, names.parameter2 as p2, names.parameter3 as p3 FROM evts, awr_names names WHERE evts.event_id = names.event_id AND names.wait_class_id <> 2723168908 ), data as (SELECT e.event_id as event_id, e.event_name as event _name, e.wait_class_id as wait_class_id, e.p1 as p1, e.p2 as p2, e.p3 as p3, e.w_cnt as total_w_cnt, e.to_cnt as total_to_cnt, e.w_time as total_w_time, e.w_cnt_fg as fg_w_cnt, e.to_cnt_fg as fg_to_cnt, e.w_time_fg as fg_w_time, nvl(a.cnt_total, 0) as total_ash_cnt, nvl(a.cnt_fg, 0) as fg_ash_cnt FROM named_events e, ash a WHERE e.event_id = a.event_id(+) ), final_query as (SELECT d.event_name, d.event_id, d.p1 as p1, case when (p1 is null OR p1 = '0') then 0 else 1 end as p1valid, d.p2 as p2, case when (p2 is null OR p2 = '0') then 0 else 1 end as p2valid, d.p3 as p3, case when (p3 is null OR p3 = '0') then 0 else 1 end as p3valid, nvl(e.keh_id, 0) as keh_evt_id, c.class# as class_num, d.wait_class_id as wait_class_id, c.keh_id as keh_ecl_id, round(d.total_ash_cnt, 0) as total_ash_cnt, round(d.fg_ash_cnt, 0) as fg_ash_cnt, round(d.fg_w_cnt, 0) as fg_w_cnt, round(d.fg_to_cnt, 0) as fg_to_cnt, round(d.fg_w_time, 0) as fg_w_time, round(d.total_w_cnt, 0) as total_w_cnt, round(d.total_to_cnt, 0) as total_to_cnt, round(d.total_w_time, 0) as total_w_time from data d, X$KEHEVTMAP e , X$KEHECLMAP c where d.event_id = e.event_hash(+) and d.wait_class_id = c.class_hash ) SELECT FROM final_query WHERE keh_evt_id > 0 OR total_w_time > 0 ORDER BY wait_class_id, fg_w_time DESC, event_id
7g732rx16j8jc	insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash
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#
7vcwzqf7mgk3b	INSERT INTO MGMT_JOB_EXECUTION (JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, START_TIME, TIMEZONE_REGION) VALUES (NULL, NULL, :B5 , NULL, NULL, 0, :B4 , :B3 , :B2 , NULL, NULL, NULL, :B1 , MGMT_JOB_ENGINE.SYSDATE_UTC(), 'UTC')
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
84k66tf2s7y1c	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
8h01dqpvft7r3	WITH awr_evts as (SELECT e.event_id, e.wait_class FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid) , en as (SELECT event_id, nvl(v.wait_class, awr_evts.wait_class) as wait_class FROM awr_evts FULL OUTER JOIN V$EVENT_NAME v USING(event_id) UNION ALL SELECT 0 as event_id, 'CPU' as wait_class FROM DUAL ) SELECT * FROM ( SELECT count() as cnt , a.SQL_ID, sum(decode(a.wait_time, 0, 0, 1)) as on_cpu, sum(case when a.wait_time = 0 and en.wait_class = 'User I/O' then 1 else 0 end) as io_wait, sum(case when a.wait_time = 0 and en.wait_class = 'Cluster' then 1 else 0 end) as cl_wait, sum(decode(bitand(a.time_model, power(2, 4)), 0, 0, NULL, 0, 1)) as in_parse, sum(decode(bitand(a.time_model, power(2, 14)), 0, 0, NULL, 0, 1)) as in_java, sum(decode(bitand(a.time_model, power(2, 11)+power(2, 12)), NULL, 0, 0, 0, 1)) as in_pls, max(a.sql_opcode) as opcode, sum(case when a.qc_session_id <> 0 and a.qc_session_id <> a.session_id and a.qc_instance_id <> 0 and a.qc_in stance_id <> a.instance_number then 1 else 0 end) as pq_cnt, count(distinct nvl(a.sql_plan_hash_value, 0)) as plans, count(distinct decode(nvl(a.sql_plan_hash_value, 0), 0, 1, 0)) as noplan FROM WRH$_ACTIVE_SESSION_HISTORY a , en WHERE a.dbid = :dbid AND a.snap_id > :bid AND a.snap_id <= :eid AND en.event_id = decode(a.wait_time, 0, a.event_id, 0) AND a.sql_id is NOT NULL AND a.session_type = 1 AND en.wait_class <> 'Idle' GROUP BY a.SQL_ID HAVING count() >= :rowcnt ORDER BY count(*) DESC, a.SQL_ID ASC ) WHERE rownum <= :ret
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
99h68qgna1qcj	WITH a as (SELECT a$.dbid, a$.snap_id, a$.INSTANCE_NUMBER, a$.BLOCKING_SESSION, a$.BLOCKING_SESSION_SERIAL#, nvl(a$.blocking_inst_id, a$.instance_number) as blocking_inst_id, a$.event_id FROM WRH$_ACTIVE_SESSION_HISTORY a$ WHERE a$.dbid = :dbid AND a$.instance_number = :inst AND a$.snap_id > :bid AND a$.snap_id <= :eid AND a$.session_type = 1 AND a$.wait_time = 0 AND a$.blocking_session between 1 and 65535 ) SELECT cnt , BLOCKING_SESSION, BLOCKING_SESSION_SERIAL#, BLOCKING_INST_ID FROM ( SELECT count() as cnt , a.BLOCKING_SESSION, a.BLOCKING_SESSION_SERIAL#, a.BLOCKING_INST_ID FROM a WHERE a.EVENT_ID IN (:event, :event_1, :event_2, :event_3, :event_4, :event_5, :event_6, :event_7, :event_8, :event_9, :event_10, :event_11) GROUP BY BLOCKING_SESSION, BLOCKING_SESSION_SERIAL#, BLOCKING_INST_ID HAVING count() >= :rowcnt ORDER BY 1 DESC, 2 ASC ) WHERE rownum <= :ret
9dhn1b8d88dpf	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.nex t_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.cla ss_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
9tgf9n221jjha	SELECT 'XXXX', a.acc_nbr, to_char(a.serv_id), a.cycle_state, substr(b.run_code, 2, 1) run_code, decode(a.cycle_state, '0', 'A', '1', 'A', '2', 'B', '3', 'B', 'err') cycle_state_bss FROM serv1 a, dcustmsg@link_accdb b, serv@link_accdb c where a.serv_id=b.id_no and a.serv_id=c.serv_id and c.state<>'a' and b.sm_code='os' and a.cycle_state in('1', '2', '3') and a.state<>'01' and a.state<>'03' and a.state<>'04' and (a.cycle_state<>c.BILLING_CYCLE_TYPE_ID or decode(a.cycle_state, '0', 'A', '1', 'A', '2', 'B', '3', 'B', 'err')<>substr(b.run_code, 2, 1))
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
b4qw7n9wg64mh	INSERT /+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_mo del , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /+ PARAM('_module_action_old_length', 0) /:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_s ession_serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.d elta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
b84cknyvnyq25	update user$ set exptime=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2), ltime=DECODE(to_char(:3, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :3), astatus = :4, lcount = :5 where user#=:1
bjstq78pprd24	SELECT DECODE(ELEMENT_SUBSTITUTABLE, ' Y', 1, 0) FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c4pc3jhzjcmc7	SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND ((UPPER(USER) LIKE USERID) OR (USERID = 'PUBLIC')) AND (UPPER(ATTRIBUTE) = 'ROLES')
c5fmmsfz0cm07	update t_ocs_report_A_daybak set end_ora_time=sysdate, flag='1', ora_count=(select count(*) from DD_OCS_ACCT_ITEM_A2_STD) where bak_date=to_char(sysdate, 'yyyymmdd') and upper(mdb_instance)=upper('BILLA32') and upper(mdb_table_name)=upper('ACCT_ITEM') and upper(ora_table_name)=upper('DD_OCS_ACCT_ITEM_A2_STD') and begin_mdb_time=to_date('20130910183348', 'yyyymmddhh24miss') and flag='0'
c9cf3jt9scn8p	select substr(U_PROV_CODE, 2, 2), U_LONG_CODE from city_list where long_code = '991'
cd1dfrzuta22f	WITH awr_params as ( SELECT /+ NO_MERGE(map) USE_HASH(map) / p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /+ USE_HASH(xmap) / xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_value end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cnumpcz520unc	SELECT COUNT(*) FROM ALL_OBJECT_TABLES OT, ALL_XML_TABLES XT WHERE OT.OWNER = XT.OWNER AND OT.TABLE_NAME = XT.TABLE_NAME AND XT.STORAGE_TYPE = 'CLOB' AND OT.OWNER = :OWN AND OT.TABLE_NAME = :TAB
cumjq42201t37	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d6vwqbw6r2ffk	SELECT USER FROM DUAL
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dcstr36r0vz0d	select procedure#, procedurename, properties, itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc
dgyz6h8s3g25z	SELECT 'XXX', nvl(flag, '0') flag from ( select * FROM t_ocs_report_A_daybak b where b.bak_date='20130910' and nvl(ora_count, 0)>0 and nvl(notes, '0') like 'export success%' and mdb_table_name='SERV' order by begin_mdb_time) where rownum<2
dky3swb1whdab	insert into t_bss_log (id, line, type, resultcode, session_id, recordtype, ip, receive_date, create_date, msisdn, serv_id, acct_id, content01, content02, content03, content04, content05, content06, content07, content08, content09 ) values(t_bss_log_seq.nextval, :1, :2, :3, :4, :5, :6, :7, sysdate, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19)
dyj1ssw8jw54f	SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.snap_id > :bid AND a.snap_id <= :eid
dyk4dprp70d74	SELECT DECODE('A', 'A', '1', '2') FROM DUAL
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fbzsh1af230p6	select PRICING_PLAN_ID, DETAIL_FLAG, NOTE, MAIN_FLAG, PRODUCT_ID, trim(NAME), NET_CARD, NET_TYPE from BSS_PRICING_COMBINE where trim(PRICING_PLAN_ID) = trim(:v1)
fnk7155mk2jq6	insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
g06u2yjd1mxmx	select Msisdn, Brand, divert, to_char(eff_date, 'YYYYMMDDHH24MISS') from serv_divert where divert in ('10') and stat = 1 and to_date(to_char(eff_date-1, 'YYYYMMDD'), 'YYYYMMDD') = to_date('20130910', 'YYYYMMDD')
g162gqkkzyp5z	select msisdn, divert, brand, to_char(create_date, 'yyyymmddHH24MISS'), to_char(eff_date, 'yyyymmddHH24MISS'), stat from serv_divert where divert='00' and stat=1 and to_char(eff_date, 'yyyymm')='201309'
g4y6nw3tts7cc	BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1, NULL); END;
grkd14sawxdj0	INSERT INTO TRANS_LOG(AGT_ACCEPT, PAY_ID, AGT_CODE, AGT_DATE, ACC_NBR, STAFF_ID, OP_CODE, OP_TIME, OP_MONEY, UNPAY_FLAG, REPAY_FLAG, COLLATE_FLAG, COLLATE_TIME, BAND_ID, PAYMENT_METHOD, ACNT_CODE) VALUES (:v1, :v2, :v3, TO_DATE(:v4, 'YYYY-MM-DD HH24:MI:SS'), :v5, :v6, :v7, sysdate, :v8, :v9, :v10, :v11, SYSDATE, :v12, :v13, :v14)
gx4mv66pvj3xz	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	250	0.02	0.01
CCursor + sql area evicted	2	0.00	0.00
CPU used by this session	410,866	28.51	18.82
CPU used when call started	33,142	2.30	1.52
CR blocks created	416	0.03	0.02
Cached Commit SCN referenced	2,515,115	174.50	115.18
Clusterwide global transactions	1	0.00	0.00
Commit SCN cached	504	0.03	0.02
DB time	10,459,161	725.68	478.97
DBWR checkpoint buffers written	23,281	1.62	1.07
DBWR checkpoints	132	0.01	0.01
DBWR fusion writes	3,423	0.24	0.16
DBWR object drop buffers written	64	0.00	0.00
DBWR tablespace checkpoint buffers written	1,007	0.07	0.05
DBWR transaction table writes	425	0.03	0.02
DBWR undo block writes	10,561	0.73	0.48
DFO trees parallelized	128	0.01	0.01
DX/BB enqueue lock background gets	2	0.00	0.00
DX/BB enqueue lock foreground requests	3,941	0.27	0.18
DX/BB enqueue lock foreground wait time	3	0.00	0.00
Effective IO time	5,985,329	415.27	274.09
HSC Heap Segment Block Changes	58,901	4.09	2.70
Heap Segment Array Inserts	2,067	0.14	0.09
Heap Segment Array Updates	1,465	0.10	0.07
Number of read IOs issued	4,622	0.32	0.21
PX local messages recv'd	416	0.03	0.02
PX local messages sent	416	0.03	0.02
PX remote messages recv'd	386	0.03	0.02
PX remote messages sent	386	0.03	0.02
Parallel operations not downgraded	128	0.01	0.01
Requests to/from client	274,752	19.06	12.58
RowCR attempts	1,249	0.09	0.06
RowCR hits	1,248	0.09	0.06
SMON posted for instance recovery	0	0.00	0.00
SQL*Net roundtrips to/from client	275,261	19.10	12.61
SQL*Net roundtrips to/from dblink	341	0.02	0.02
active txn count during cleanout	5,339	0.37	0.24
application wait time	416	0.03	0.02
background checkpoints completed	4	0.00	0.00
background checkpoints started	4	0.00	0.00
background timeouts	103,534	7.18	4.74
branch node splits	24	0.00	0.00
buffer is not pinned count	292,976	20.33	13.42
buffer is pinned count	4,462,122	309.59	204.34
bytes received via SQL*Net from client	78,621,045	5,454.89	3,600.36
bytes received via SQL*Net from dblink	154,282,035	10,704.41	7,065.17
bytes sent via SQL*Net to client	39,401,703	2,733.77	1,804.36
bytes sent via SQL*Net to dblink	7,656	0.53	0.35
calls to get snapshot scn: kcmgss	166,148	11.53	7.61
calls to kcmgas	84,454	5.86	3.87
calls to kcmgcs	161,717	11.22	7.41
cell physical IO interconnect bytes	22,674,882,560	1,573,230.35	1,038,369.86
change write time	365	0.03	0.02
cleanout - number of ktugct calls	7,748	0.54	0.35
cleanouts and rollbacks - consistent read gets	344	0.02	0.02
cleanouts only - consistent read gets	2,297	0.16	0.11
cluster key scan block gets	21,372	1.48	0.98
cluster key scans	17,035	1.18	0.78
cluster wait time	3,398	0.24	0.16
commit batch performed	1	0.00	0.00
commit batch requested	1	0.00	0.00
commit batch/immediate performed	315	0.02	0.01
commit batch/immediate requested	315	0.02	0.01
commit cleanout failures: block lost	207	0.01	0.01
commit cleanout failures: callback failure	289	0.02	0.01
commit cleanout failures: cannot pin	274	0.02	0.01
commit cleanouts	118,898	8.25	5.44
commit cleanouts successfully completed	118,128	8.20	5.41
commit immediate performed	314	0.02	0.01
commit immediate requested	314	0.02	0.01
commit txn count during cleanout	9,411	0.65	0.43
concurrency wait time	369,595,581	25,643.31	16,925.20
consistent changes	1,846	0.13	0.08
consistent gets	3,363,350	233.36	154.02
consistent gets - examination	144,690	10.04	6.63
consistent gets direct	574,769	39.88	26.32
consistent gets from cache	2,788,581	193.48	127.70
consistent gets from cache (fastpath)	2,577,828	178.86	118.05
cursor authentications	303	0.02	0.01
data blocks consistent reads - undo records applied	1,597	0.11	0.07
db block changes	479,560	33.27	21.96
db block gets	591,861	41.06	27.10
db block gets direct	11,899	0.83	0.54
db block gets from cache	579,962	40.24	26.56
db block gets from cache (fastpath)	183,588	12.74	8.41
deferred (CURRENT) block cleanout applications	87,143	6.05	3.99
enqueue conversions	4,151	0.29	0.19
enqueue releases	312,728	21.70	14.32
enqueue requests	312,887	21.71	14.33
enqueue timeouts	116	0.01	0.01
enqueue waits	1,484	0.10	0.07
exchange deadlocks	16	0.00	0.00
execute count	168,733	11.71	7.73
file io wait time	298,250,958	20,693.27	13,658.06
free buffer inspected	47	0.00	0.00
free buffer requested	1,916,473	132.97	87.76
gc blocks compressed	11,971	0.83	0.55
gc cr block flush time	70	0.00	0.00
gc cr block receive time	467	0.03	0.02
gc cr blocks received	10,678	0.74	0.49
gc cr blocks served	9,775	0.68	0.45
gc current block flush time	31	0.00	0.00
gc current block pin time	15	0.00	0.00
gc current block receive time	736	0.05	0.03
gc current blocks received	18,689	1.30	0.86
gc current blocks served	12,743	0.88	0.58
gc kbytes saved	51,036	3.54	2.34
gc kbytes sent	129,108	8.96	5.91
gc local grants	1,235,024	85.69	56.56
gc read wait time	7	0.00	0.00
gc read wait timeouts	0	0.00	0.00
gc read waits	13	0.00	0.00
gc remote grants	652,417	45.27	29.88
gcs messages sent	2,557,902	177.47	117.14
ges messages sent	3,528,462	244.81	161.58
global enqueue get time	15,951,190	1,106.73	730.47
global enqueue gets async	6,713	0.47	0.31
global enqueue gets sync	241,498	16.76	11.06
global enqueue releases	231,866	16.09	10.62
heap block compress	153	0.01	0.01
immediate (CR) block cleanout applications	2,641	0.18	0.12
immediate (CURRENT) block cleanout applications	12,738	0.88	0.58
in call idle wait time	62,273,575	4,320.67	2,851.75
index crx upgrade (positioned)	1,898	0.13	0.09
index crx upgrade (prefetch)	4	0.00	0.00
index fast full scans (full)	26	0.00	0.00
index fetch by key	66,114	4.59	3.03
index scans kdiixs1	92,042	6.39	4.21
leaf node 90-10 splits	242	0.02	0.01
leaf node splits	3,399	0.24	0.16
lob reads	6	0.00	0.00
lob writes	41	0.00	0.00
lob writes unaligned	41	0.00	0.00
logical read bytes from cache	27,594,973,184	1,914,596.44	1,263,679.68
logons cumulative	4,164	0.29	0.19
max cf enq hold time	632	0.04	0.03
messages received	54,910	3.81	2.51
messages sent	54,910	3.81	2.51
min active SCN optimization applied on CR	4	0.00	0.00
no work - consistent read gets	3,048,245	211.49	139.59
non-idle wait count	8,811,239	611.34	403.50
non-idle wait time	369,652,620	25,647.27	16,927.81
opened cursors cumulative	94,970	6.59	4.35
parse count (describe)	23	0.00	0.00
parse count (failures)	2	0.00	0.00
parse count (hard)	9,575	0.66	0.44
parse count (total)	50,625	3.51	2.32
parse time cpu	1,231	0.09	0.06
parse time elapsed	1,605	0.11	0.07
physical read IO requests	30,701	2.13	1.41
physical read bytes	19,994,255,360	1,387,242.88	915,613.65
physical read total IO requests	71,636	4.97	3.28
physical read total bytes	21,283,722,240	1,476,708.77	974,663.29
physical read total multi block requests	19,625	1.36	0.90
physical reads	2,440,705	169.34	111.77
physical reads cache	1,865,888	129.46	85.45
physical reads cache prefetch	1,842,538	127.84	84.38
physical reads direct	574,817	39.88	26.32
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	785	0.05	0.04
physical write IO requests	11,796	0.82	0.54
physical write bytes	314,556,416	21,824.58	14,404.74
physical write total IO requests	57,206	3.97	2.62
physical write total bytes	1,391,160,320	96,521.59	63,706.57
physical write total multi block requests	1,936	0.13	0.09
physical writes	38,398	2.66	1.76
physical writes direct	11,947	0.83	0.55
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	1	0.00	0.00
physical writes from cache	26,451	1.84	1.21
physical writes non checkpoint	32,145	2.23	1.47
pinned cursors current	4	0.00	0.00
process last non-idle time	19,686	1.37	0.90
queries parallelized	128	0.01	0.01
recursive calls	816,555	56.65	37.39
recursive cpu usage	5,648	0.39	0.26
redo KB read	601,665	41.74	27.55
redo blocks checksummed by FG (exclusive)	351,981	24.42	16.12
redo blocks written	525,898	36.49	24.08
redo buffer allocation retries	1	0.00	0.00
redo entries	281,503	19.53	12.89
redo log space requests	1	0.00	0.00
redo log space wait time	1	0.00	0.00
redo ordering marks	10,348	0.72	0.47
redo size	253,080,276	17,559.23	11,589.52
redo size for direct writes	97,900,264	6,792.52	4,483.23
redo subscn max counts	3,135	0.22	0.14
redo synch long waits	12	0.00	0.00
redo synch time	1,379	0.10	0.06
redo synch time (usec)	15,836,918	1,098.80	725.23
redo synch writes	25,549	1.77	1.17
redo wastage	7,673,352	532.39	351.39
redo write broadcast ack count	19,129	1.33	0.88
redo write broadcast ack time	4,934,945	342.40	225.99
redo write broadcast lgwr post count	1	0.00	0.00
redo write time	1,275	0.09	0.06
redo writes	32,835	2.28	1.50
rollback changes - undo records applied	235	0.02	0.01
rollbacks only - consistent read gets	88	0.01	0.00
root node splits	1	0.00	0.00
rows fetched via callback	18,081	1.25	0.83
session connect time	7,668	0.53	0.35
session cursor cache hits	109,981	7.63	5.04
session logical reads	3,955,211	274.42	181.12
shared hash latch upgrades - no wait	21,384	1.48	0.98
shared hash latch upgrades - wait	5	0.00	0.00
sorts (memory)	56,697	3.93	2.60
sorts (rows)	39,737,984	2,757.10	1,819.75
sql area evicted	99	0.01	0.00
sql area purged	48	0.00	0.00
switch current to new buffer	1,980	0.14	0.09
table fetch by rowid	2,301,633	159.69	105.40
table fetch continued row	82	0.01	0.00
table scan blocks gotten	2,773,058	192.40	126.99
table scan rows gotten	174,426,414	12,102.07	7,987.65
table scans (direct read)	12	0.00	0.00
table scans (long tables)	13	0.00	0.00
table scans (short tables)	31,550	2.19	1.44
total cf enq hold time	1,815	0.13	0.08
total number of cf enq holders	257	0.02	0.01
total number of times SMON posted	84	0.01	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	208	0.01	0.01
undo change vector size	56,506,708	3,920.55	2,587.66
user I/O wait time	30,391	2.11	1.39
user calls	300,682	20.86	13.77
user commits	21,677	1.50	0.99
user rollbacks	160	0.01	0.01
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	15,785	1.10	0.72
write clones created in background	51	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	569,306,720	1,823,554,288
session cursor cache count	8,498	48,861
session uga memory	279,228,525,848	1,164,269,853,928
opened cursors current	55	533
logons current	65	527
session uga memory max	585,341,832	2,550,083,464
session pga memory	537,439,168	1,765,406,800

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)	4	1.00

Back to Instance Activity Statistics
Back to Top

IO Stats

IOStat by Function summary
IOStat by Filetype summary
IOStat by Function/Filetype summary
Tablespace IO Stats
File IO Stats

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Buffer Cache Reads	14.2G	1.81	1.01138	0M	0.00	0M	23.4K	12.24
Direct Reads	4.4G	0.32	.311317	0M	0.00	0M	0
Others	1.2G	2.83	.085201	776M	0.85	.053840	46.1K	0.21
LGWR	1M	0.00	.000069	258M	2.31	.017900	33K	0.13
DBWR	0M	0.00	0M	207M	0.78	.014362	0
Direct Writes	4M	0.00	.000277	86M	0.03	.005966	0
TOTAL:	19.8G	4.97	1.40824	1.3G	3.97	.092070	102.4K	2.93

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	18.6G	2.14	1.32311	299M	0.82	.020745	2.01	19.29
Log File	588M	0.04	.040796	257M	2.30	.017831	2.85	36.33
Control File	641M	2.79	.044473	182M	0.81	.012627	0.20	18.80
Archive Log	0M	0.00	0M	588M	0.04	.040796
Temp File	0M	0.00	0M	0M	0.00	0M	0.00
TOTAL:	19.8G	4.97	1.40838	1.3G	3.97	.092000	0.61	19.80

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Buffer Cache Reads	14.2G	1.81	1.01138	0M	0.00	0M	23.3K	12.22
Buffer Cache Reads (Data File)	14.2G	1.81	1.01138	0M	0.00	0M	23.3K	12.22
Direct Reads	4.4G	0.32	.311317	0M	0.00	0M	0
Direct Reads (Data File)	4.4G	0.32	.311317	0M	0.00	0M	0
Others	640M	2.79	.044404	188M	0.81	.013043	40.3K	0.22
Others (Control File)	640M	2.79	.044404	181M	0.80	.012558	40.2K	0.21
Others (Data File)	0M	0.01	0M	7M	0.00	.000485	96	6.03
LGWR	0M	0.00	0M	257M	2.30	.017831	16	2.31
LGWR (Log File)	0M	0.00	0M	257M	2.30	.017831	16	2.31
DBWR	0M	0.00	0M	207M	0.78	.014362	0
DBWR (Data File)	0M	0.00	0M	207M	0.78	.014362	0
Direct Writes	4M	0.00	.000277	86M	0.03	.005966	0
Direct Writes (Data File)	4M	0.00	.000277	86M	0.03	.005966	0
TOTAL:	19.2G	4.92	1.36738	738M	3.92	.051203	63.6K	4.62

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
RPT	17,842	1	15.22	104.06	479	51	3.14
SYSAUX	7,030	0	1.89	1.00	7,095	0	0.00
USER_DATA	5,237	0	0.90	110.01	1,308	25	2.00
UNDOTBS1	2	0	0.00	1.00	1,543	99	0.10
SYSTEM	154	0	6.95	1.00	511	575	1.70
BNMS_DATA01	172	0	6.63	1.67	222	6	0.00
RPT_INX	92	0	10.76	1.38	298	0	0.00
USER_DATA_INX	85	0	8.00	1.34	301	0	0.00
CFG	57	0	5.26	3.68	29	0	0.00
CFG_INX	3	0	3.33	1.00	2	0	0.00
BNMS_IDX_01	2	0	0.00	1.00	2	0	0.00
UNDOTBS2	2	0	0.00	1.00	2	2	0.00
USERS	2	0	0.00	1.00	2	0	0.00
TEMP	1	0	0.00	1.00	1	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
BNMS_DATA01	+DG_BILLDB_DATA/billdb/bnms_data01_1.dbf	89	6.74	1.52	108	4	0.00
BNMS_DATA01	+DG_BILLDB_DATA/billdb/bnms_data01_2.dbf	83	6.51	1.83	114	2	0.00
BNMS_IDX_01	+DG_BILLDB_DATA/billdb/bnms_idx_01_1.dbf	2	0.00	1.00	2	0	0.00
CFG	+DG_BILLDB_DATA/billdb/cfg01.dbf	57	5.26	3.68	29	0	0.00
CFG_INX	+DG_BILLDB_DATA/billdb/cfg_inx01.dbf	3	3.33	1.00	2	0	0.00
RPT	+DG_BILLDB_DATA/billdb/rpt01.dbf	3,349	17.07	120.45	120	13	0.77
RPT	+DG_BILLDB_DATA/billdb/rpt02.dbf	6,659	12.84	86.60	206	12	11.67
RPT	+DG_BILLDB_DATA/billdb/rpt03.dbf	4,183	15.80	107.17	81	12	0.00
RPT	+DG_BILLDB_DATA/billdb/rpt04.dbf	3,651	17.18	117.31	72	14	0.71
RPT_INX	+DG_BILLDB_DATA/billdb/rpt_inx01.dbf	92	10.76	1.38	298	0	0.00
SYSAUX	+DG_BILLDB_DATA/billdb/sysaux01.dbf	7,030	1.89	1.00	7,095	0	0.00
SYSTEM	+DG_BILLDB_DATA/billdb/system01.dbf	154	6.95	1.00	511	575	1.70
TEMP	+DG_BILLDB_DATA/billdb/temp01.dbf	1	0.00	1.00	1	0
UNDOTBS1	+DG_BILLDB_DATA/billdb/undotbs01.dbf	2	0.00	1.00	1,543	99	0.10
UNDOTBS2	+DG_BILLDB_DATA/billdb/undotbs02.dbf	2	0.00	1.00	2	2	0.00
USERS	+DG_BILLDB_DATA/billdb/users01.dbf	2	0.00	1.00	2	0	0.00
USER_DATA	+DG_BILLDB_DATA/billdb/user_data01.dbf	800	1.05	109.42	243	4	2.50
USER_DATA	+DG_BILLDB_DATA/billdb/user_data02.dbf	765	0.95	110.46	222	1	10.00
USER_DATA	+DG_BILLDB_DATA/billdb/user_data03.dbf	592	0.29	118.79	105	0	0.00
USER_DATA	+DG_BILLDB_DATA/billdb/user_data04.dbf	716	0.32	119.33	54	0	0.00
USER_DATA	+DG_BILLDB_DATA/billdb/user_data05.dbf	600	0.97	107.51	114	3	0.00
USER_DATA	+DG_BILLDB_DATA/billdb/user_data06.dbf	718	1.53	99.94	193	1	0.00
USER_DATA	+DG_BILLDB_DATA/billdb/user_data07.dbf	417	1.10	105.71	95	14	2.14
USER_DATA	+DG_BILLDB_DATA/billdb/user_data08.dbf	629	0.97	108.09	282	2	0.00
USER_DATA_INX	+DG_BILLDB_DATA/billdb/user_data_inx01.dbf	85	8.00	1.34	301	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	2,388,960	45	3,368,500	1,865,848	26,451	0	0	758

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 38,398

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	22,274	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	259	1160	1330	5096034	1330			0
E	0	1	1453	51397	144367	5096034	144367			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	1,984	0.10	234	1.00	1,937	1	336.00
D	3,968	0.20	469	1.00	1,937	1	336.00
D	5,952	0.29	703	1.00	1,937	1	336.00
D	7,936	0.39	937	1.00	1,937	1	336.00
D	9,920	0.49	1,172	1.00	1,937	1	336.00
D	11,904	0.59	1,406	1.00	1,937	1	336.00
D	13,888	0.69	1,641	1.00	1,937	1	336.00
D	15,872	0.78	1,875	1.00	1,937	1	336.00
D	17,856	0.88	2,109	1.00	1,937	1	336.00
D	19,840	0.98	2,344	1.00	1,937	1	336.00
D	20,224	1.00	2,389	1.00	1,937	1	336.00
D	21,824	1.08	2,578	1.00	1,937	1	336.00
D	23,808	1.18	2,812	1.00	1,937	1	336.00
D	25,792	1.28	3,047	1.00	1,937	1	336.00
D	27,776	1.37	3,281	1.00	1,937	1	336.00
D	29,760	1.47	3,515	1.00	1,937	1	336.00
D	31,744	1.57	3,750	1.00	1,937	1	336.00
D	33,728	1.67	3,984	1.00	1,937	1	336.00
D	35,712	1.77	4,218	1.00	1,937	1	336.00
D	37,696	1.86	4,453	1.00	1,937	1	336.00
D	39,680	1.96	4,687	1.00	1,937	1	336.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	1,008	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	7,768	6,742	332.73	0.00	0.00	0.00	0.00	795,440
E	7,768	6,308	922.30	0.00	0.00	0.00	0.00	795,440

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	15,299	15,299
64K	128K	50	50
128K	256K	2	2
256K	512K	4	4
512K	1024K	377	377
1M	2M	33	33
4M	8M	8	8
32M	64M	11	11
64M	128M	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
971	0.13	1,377.86	156.25	90.00	1	86,500
1,942	0.25	1,377.86	156.25	90.00	1	86,500
3,884	0.50	1,377.86	149.76	90.00	0	86,134
5,826	0.75	1,377.86	149.76	90.00	0	86,134
7,768	1.00	1,377.86	34.20	98.00	0	79,618
9,322	1.20	1,377.86	0.00	100.00	0	77,690
10,875	1.40	1,377.86	0.00	100.00	0	77,690
12,429	1.60	1,377.86	0.00	100.00	0	77,690
13,982	1.80	1,377.86	0.00	100.00	0	77,690
15,536	2.00	1,377.86	0.00	100.00	0	77,690
23,304	3.00	1,377.86	0.00	100.00	0	77,690
31,072	4.00	1,377.86	0.00	100.00	0	77,690
46,608	6.00	1,377.86	0.00	100.00	0	77,690
62,144	8.00	1,377.86	0.00	100.00	0	77,690

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
2,752	1.00	227	19,902	3,056	1.00	35	1.00	232
2,816	1.02	231	20,131	3,057	1.00	34	0.97	232
2,880	1.05	231	20,131	3,057	1.00	34	0.97	232
2,944	1.07	231	20,131	3,057	1.00	34	0.97	232
3,008	1.09	231	20,131	3,057	1.00	34	0.97	232
3,072	1.12	231	20,131	3,057	1.00	34	0.97	232
3,136	1.14	231	20,131	3,057	1.00	34	0.97	232
3,200	1.16	231	20,131	3,057	1.00	34	0.97	232
3,264	1.19	231	20,131	3,057	1.00	34	0.97	232
3,328	1.21	231	20,131	3,057	1.00	34	0.97	232
3,392	1.23	231	20,131	3,057	1.00	34	0.97	232
3,712	1.35	231	20,131	3,057	1.00	34	0.97	232
4,032	1.47	231	20,131	3,057	1.00	34	0.97	232
4,352	1.58	231	20,131	3,057	1.00	34	0.97	232
4,672	1.70	231	20,131	3,057	1.00	34	0.97	232
4,992	1.81	231	20,131	3,057	1.00	34	0.97	232
5,312	1.93	231	20,131	3,057	1.00	34	0.97	232
5,632	2.05	231	20,131	3,057	1.00	34	0.97	232

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
5,840	0.25	3,698,071	1,936,832
8,760	0.38	3,698,501	1,936,832
11,680	0.50	3,698,571	1,936,832
14,600	0.63	3,698,571	1,936,832
17,520	0.75	3,698,571	1,936,832
20,440	0.88	3,698,571	1,936,832
23,360	1.00	3,697,907	1,936,832
26,280	1.13	3,698,571	1,936,832
29,200	1.25	3,698,571	1,936,832
32,120	1.38	3,698,571	1,936,832
35,040	1.50	3,698,571	1,936,832
37,960	1.63	3,698,571	1,936,832
40,880	1.75	3,698,701	1,936,832
43,800	1.88	3,699,423	1,936,832
46,720	2.00	3,699,983	1,936,832

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	521	1	1
segment header	72	0	5
file header block	51	0	3
1st level bmb	9	0	3
undo block	44	0	0
2nd level bmb	4	0	3
undo header	57	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse)	754	754	0	217	4	17.03
WF-AWR Flush	93	93	0	79	1	12.94
FB-Format Block	415	415	0	244	1	2.57
PS-PX Process Reservation	873	873	0	248	0	1.99
JQ-Job Queue	239	218	21	99	0	4.05
HW-Segment High Water Mark	1,260	1,260	0	77	0	2.56
TM-DML	52,274	52,235	38	177	0	0.97
CF-Controlfile Transaction	29,996	29,996	0	87	0	1.77
CR-Reuse Block Range (block range reuse ckpt)	318	318	0	49	0	2.65
TA-Instance Undo	51	51	0	42	0	1.67
TX-Transaction (index contention)	22	22	0	18	0	3.33
TD-KTF map table enqueue (KTF dump entries)	34	34	0	28	0	1.29
KO-Multiple Object Checkpoint (fast object checkpoint)	180	180	0	44	0	0.61
DR-Distributed Recovery	8	8	0	8	0	2.50
PI-Remote PX Process Spawn Status	16	16	0	8	0	1.75
TX-Transaction (allocate ITL entry)	8	8	0	8	0	1.25
SQ-Sequence Cache	689	689	0	2	0	3.50
MW-MWIN Schedule	8	8	0	8	0	0.75
JS-Job Scheduler (job run lock - synchronize)	10	8	2	10	0	0.50
TS-Temporary Segment	22	22	0	14	0	0.21
UL-User-defined	19	19	0	4	0	0.50
MD-Materialized View Log DDL	9	9	0	6	0	0.17
TT-Tablespace	713	713	0	3	0	0.00
TX-Transaction (row lock contention)	2	2	0	2	0	0.00
TO-Temp Object	27	27	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	10.41	33,953	888	7	33111.6/229775.5	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
10-Sep 18:59	769	3,913	888	5	33,112	0/0	0/0/0/0/0/0
10-Sep 18:49	785	3,378	283	7	34,683	0/0	0/0/0/0/0/0
10-Sep 18:39	651	3,022	887	3	36,666	0/0	0/0/0/0/0/0
10-Sep 18:29	800	2,858	283	3	38,314	0/0	0/0/0/0/0/0
10-Sep 18:19	673	3,379	884	3	40,961	0/0	0/0/0/0/0/0
10-Sep 18:09	882	3,490	280	3	43,434	0/0	0/0/0/0/0/0
10-Sep 17:59	1,010	4,184	884	4	47,885	0/0	0/0/0/0/0/0
10-Sep 17:49	881	3,757	279	3	54,975	0/0	0/0/0/0/0/0
10-Sep 17:39	631	1,948	882	3	63,430	0/0	0/0/0/0/0/0
10-Sep 17:29	627	591	276	3	71,113	0/0	0/0/0/0/0/0
10-Sep 17:19	318	259	880	3	81,579	0/0	0/0/0/0/0/0
10-Sep 17:09	488	503	275	3	87,038	0/0	0/0/0/0/0/0
10-Sep 16:59	308	165	881	3	99,961	0/0	0/0/0/0/0/0
10-Sep 16:49	311	212	277	4	109,487	0/0	0/0/0/0/0/0
10-Sep 16:39	319	288	880	3	122,193	0/0	0/0/0/0/0/0
10-Sep 16:29	172	209	277	3	140,405	0/0	0/0/0/0/0/0
10-Sep 16:19	273	344	882	2	150,616	0/0	0/0/0/0/0/0
10-Sep 16:09	235	343	279	3	178,215	0/0	0/0/0/0/0/0
10-Sep 15:59	112	171	883	2	212,465	0/0	0/0/0/0/0/0
10-Sep 15:49	12	94	282	3	229,776	0/0	0/0/0/0/0/0
10-Sep 15:39	21	231	887	3	222,006	0/0	0/0/0/0/0/0
10-Sep 15:29	23	264	285	3	216,371	0/0	0/0/0/0/0/0
10-Sep 15:19	20	127	0	2	210,991	0/0	0/0/0/0/0/0
10-Sep 15:09	92	223	289	3	204,482	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	4	0.00		0	0
AQ dequeue txn counter latch	3,354	0.00		0	0
ASM Keyed state latch	7,088	0.58	0.00	0	0
ASM allocation	569	0.00		0	0
ASM db client latch	10,058	0.00		0	0
ASM map headers	78	0.00		0	0
ASM map load waiting list	28	0.00		0	0
ASM map operation freelist	2,742	0.00		0	0
ASM map operation hash table	330,498	0.00	0.00	0	0
ASM network background latch	6,128	0.00		0	0
ASM network state latch	763	0.00		0	0
AWR Alerted Metric Element list	182,861	0.00		0	0
Change Notification Hash table latch	4,870	0.00		0	0
Consistent RBA	32,834	0.01	0.00	0	0
DML lock allocation	104,628	0.00		0	0
Event Group Locks	7,951	0.00		0	0
FAL Queue	393	0.00		0	0
FIB s.o chain latch	28	0.00		0	0
FOB s.o list latch	11,781	0.11	0.00	0	0
File State Object Pool Parent Latch	4	0.00		0	0
I/O Staticstics latch	4	0.00		0	0
IPC other latch	120	0.00		0	0
IPC stats buffer allocation latch	10,468	0.00		0	11,435	0.00
In memory undo latch	4	0.00		0	0
JS Sh mem access	30	0.00		0	0
JS broadcast add buf latch	3,322	0.00		0	0
JS broadcast drop buf latch	3,322	0.00		0	0
JS broadcast load blnc latch	2,884	0.00		0	0
JS mem alloc latch	24	0.00		0	0
JS queue access latch	28	0.00		0	0
JS queue state obj latch	157,410	0.00		0	0
JS slv state obj latch	903	0.00		0	0
KFC FX Hash Latch	4	0.00		0	0
KFC Hash Latch	4	0.00		0	0
KFCL LE Freelist	4	0.00		0	0
KFK SGA Libload latch	9,120	0.00		0	0
KFMD SGA	73	0.00		0	0
KGNFS-NFS:SHM structure	4	0.00		0	0
KGNFS-NFS:SVR LIST	4	0.00		0	0
KJC destination ctx free list	0			0	2	0.00
KJC message pool free list	51,639	0.03	0.06	0	13,075	0.01
KJCT flow control latch	10,928,282	0.00	0.00	0	0
KMG MMAN ready and startup request latch	4,804	0.00		0	0
KSXR large replies	970	0.00		0	0
KTF sga latch	115	0.00		0	4,546	0.00
KWQMN job cache list latch	1,416	0.00		0	0
KWQS pqsubs latch	42	0.00		0	0
KWQS pqueue ctx latch	272	0.00		0	0
Locator state objects pool parent latch	4	0.00		0	0
Lsod array latch	44,283	0.69	0.00	0	0
MQL Tracking Latch	0			0	287	0.00
Memory Management Latch	4	0.00		0	4,804	0.00
Memory Queue	4	0.00		0	0
Memory Queue Message Subscriber #1	4	0.00		0	0
Memory Queue Message Subscriber #2	4	0.00		0	0
Memory Queue Message Subscriber #3	4	0.00		0	0
Memory Queue Message Subscriber #4	4	0.00		0	0
Memory Queue Subscriber	4	0.00		0	0
MinActiveScn Latch	9,917	0.00		0	0
Mutex	4	0.00		0	0
Mutex Stats	4	0.00		0	0
OS process	16,653	0.00		0	0
OS process allocation	38,142	0.17	0.00	0	0
OS process: request allocation	7,088	0.59	0.00	0	0
PL/SQL warning settings	5,747	0.00		0	0
PX hash array latch	4	0.00		0	0
QMT	4	0.00		0	0
Real-time plan statistics latch	1,996	0.00		0	2	0.00
SGA IO buffer pool latch	28	0.00		0	28	10.71
SGA blob parent	4	0.00		0	0
SGA bucket locks	4	0.00		0	0
SGA heap locks	4	0.00		0	0
SGA pool locks	4	0.00		0	0
SQL memory manager latch	4	0.00		0	4,797	0.00
SQL memory manager workarea list latch	326,799	0.00		0	0
Shared B-Tree	1,829	0.00		0	0
Streams Generic	4	0.00		0	0
Testing	4	0.00		0	0
Token Manager	4	0.00		0	0
WCR: sync	4	0.00		0	0
Write State Object Pool Parent Latch	4	0.00		0	0
X$KSFQP	4	0.00		0	0
XDB NFS Security Latch	4	0.00		0	0
XDB unused session pool	4	0.00		0	0
XDB used session pool	4	0.00		0	0
active checkpoint queue latch	23,131	0.38	0.00	0	0
active service list	153,895	0.03	0.29	0	10,877	0.00
alert log latch	8	0.00		0	0
archive control	253	0.00		0	0
archive process latch	1,184	0.00		0	0
begin backup scn array	491	0.00		0	0
buffer pool	4	0.00		0	0
business card	260	0.00		0	0
cache buffer handles	7,087	0.01	0.00	0	0
cache buffers chains	12,662,514	0.01	0.15	0	3,885,216	0.00
cache buffers lru chain	50,910	0.06	0.03	0	3,989,060	0.13
cache table scan latch	14,646	0.10	0.00	0	14,646	0.08
call allocation	17,851	0.82	0.58	0	2	0.00
cas latch	4	0.00		0	0
change notification client cache latch	4	0.00		0	0
channel handle pool latch	7,485	0.33	0.00	0	0
channel operations parent latch	2,546,309	0.00	0.00	0	0
checkpoint queue latch	1,838,862	0.00	0.13	0	33,600	0.00
client/application info	22,669	0.00		0	0
compile environment latch	4,172	0.00		0	0
corrupted undo seg latch	913	0.00		0	0
cp cmon/server latch	4	0.00		0	0
cp pool latch	4	0.00		0	0
cp server hash latch	4	0.00		0	0
cp sga latch	229	0.00		0	0
cvmap freelist lock	4	0.00		0	0
deferred cleanup latch	229	0.00		0	0
dml lock allocation	251	0.40	0.00	0	0
done queue latch	4	0.00		0	0
dummy allocation	7,886	0.08	0.00	0	0
enqueue freelist latch	4	0.00		0	443,483	0.00
enqueue hash chains	759,877	0.01	0.00	0	16	0.00
enqueues	10,434	0.00		0	0
error message lists	592	0.00		0	0
fifth spare latch	4	0.00		0	0
file cache latch	3,597	0.00		0	0
flashback copy	4	0.00		0	0
fourth Audit Vault latch	4	0.00		0	0
gc element	3,952,602	0.12	0.03	0	9,562	0.00
gc persistent rm	20	0.00		0	0
gcs commit scn state	4	0.00		0	0
gcs opaque info freelist	23,964	0.01	0.00	0	0
gcs partitioned table hash	51,124,795	0.90	0.00	0	641,408	0.00
gcs pcm hashed value bucket hash	4	0.00		0	0
gcs remaster request queue	4,536	0.00		0	0
gcs remastering latch	6,520,366	1.77	0.00	0	151	0.66
gcs resource freelist	2,950,984	0.03	0.00	0	2,989,641	0.01
gcs resource hash	34,983,079	0.01	0.00	0	26	0.00
gcs resource scan list	60	0.00		0	0
gcs shadows freelist	1,774,382	0.00		0	1,769,930	0.00
ges DFS wait callback info	1	0.00		0	0
ges caches resource lists	102,716	0.45	0.01	0	91,213,337	0.00
ges deadlock list	1,890	0.00		0	150,346	0.00
ges domain table	1,151,229,955	0.00	0.00	0	0
ges enqueue table freelist	468,011	0.00	0.00	0	0
ges group table	462,930	0.00	0.00	0	0
ges process hash list	202,613	0.01	0.94	0	0
ges process parent latch	1,064,426	0.00	0.00	0	0
ges process table freelist	7,088	0.52	0.00	0	0
ges resource hash list	3,463,668,705	0.00	0.48	1	94,565	0.14
ges resource scan list	876	0.00		0	0
ges resource table freelist	5,130	0.00		0	16	0.00
ges timeout list	3,718	0.00		0	19,623	0.00
ges value block free list	3,680	0.00		0	0
global KZLD latch for mem in SGA	3,183	0.00		0	0
global tx hash mapping	1,643	0.00		0	0
granule operation	4	0.00		0	0
hash table column usage latch	418	0.00		0	133,584	0.08
hash table modification latch	416	0.00		0	2	0.00
heartbeat check	4	0.00		0	4,080	0.00
heartbeat structure management	0			0	2,884	0.00
internal temp table object number allocation latch	27	0.00		0	0
interrupt manipulation	1,496	0.00		0	0
intra txn parallel recovery	4	0.00		0	0
io pool granule metadata list	4	0.00		0	0
job workq parent latch	253	0.00		0	249	2.41
job_queue_processes free list latch	498	0.00		0	0
job_queue_processes parameter latch	3,357	0.00		0	0
k2q global data latch	9,612	0.00		0	0
k2q lock allocation	3,276	0.00		0	0
kcbtsemkid latch	4	0.00		0	0
kdlx hb parent latch	4	0.00		0	0
kgb parent	4	0.00		0	0
kgnfs mount latch	4	0.00		0	0
kokc descriptor allocation latch	1,406	0.00		0	0
ksfv messages	4	0.00		0	0
ksim group membership cache	2,476	0.00		0	0
ksim membership request latch	0			0	9,033	0.00
kss move lock	258	0.00		0	0
ksuosstats global area	1,453	0.00		0	0
ksv allocation latch	734	0.00		0	0
ksv class latch	29,000	0.01	0.00	0	2	0.00
ksv instance latch	20	0.00		0	0
ksv msg queue latch	19	0.00		0	15	0.00
ksxp shared latch	7,088	0.47	0.00	0	0
ksxp so latch	7,088	0.56	0.00	0	0
ksz_so allocation latch	7,088	0.85	0.00	0	0
ktm global data	426	0.00		0	0
kwqbsn:qsga	502	0.00		0	0
lgwr LWN SCN	35,334	0.02	0.00	0	0
list of block allocation	6,774	0.06	0.00	0	0
loader state object freelist	188	0.00		0	0
lob segment dispenser latch	4	0.00		0	0
lob segment hash table latch	52	0.00		0	0
lob segment query latch	4	0.00		0	0
lock DBA buffer during media recovery	4	0.00		0	0
logical standby cache	4	0.00		0	0
logminer context allocation	4	0.00		0	0
logminer work area	4	0.00		0	0
longop free list parent	12	0.00		0	8	0.00
managed standby latch	389	0.00		0	0
mapped buffers lru chain	4	0.00		0	0
message pool operations parent latch	21,253	0.00		0	0
messages	746,833	0.05	0.00	0	0
mostly latch-free SCN	35,416	0.24	0.02	0	0
msg queue latch	4	0.00		0	0
multiblock read objects	32,234	0.01	0.00	0	2	0.00
name-service memory objects	8,874	0.00		0	4	0.00
name-service namespace bucket	1,136,633,807	0.00		0	0
name-service namespace objects	16	0.00		0	0
name-service pending queue	3,004	0.00		0	0
name-service request	48	0.00		0	0
name-service request queue	135,507	0.00		0	0
ncodef allocation latch	229	0.00		0	0
object queue header heap	137,421	0.00	0.00	0	2,414	0.12
object queue header operation	2,569,554	0.01	0.05	0	0
object stats modification	1,263	0.08	0.00	0	0
parallel query alloc buffer	4,684	0.00		0	0
parallel query stats	557	0.00		0	0
parallel txn reco latch	3,621	0.00		0	0
parameter list	34,801	0.01	0.00	0	0
parameter table management	23,446	0.02	0.50	0	0
peshm	4	0.00		0	0
pesom_free_list	4	0.00		0	0
pesom_hash_node	4	0.00		0	0
post/wait queue	91,209,941	0.00	0.00	0	91,176,419	0.00
process allocation	72,807	0.11	0.10	0	3,775	0.00
process group creation	7,088	0.13	0.00	0	0
process queue	1,479	0.00		0	0
process queue reference	24,240	0.00		0	2,237	0.00
qmn state object latch	7	0.00		0	0
qmn task context latch	3	0.00		0	0
qmn task queue latch	2,068	0.00		0	0
query server freelists	1,206	0.00		0	0
query server process	112	0.00		0	8	0.00
queued dump request	48	0.00		0	0
queuing load statistics	4	0.00		0	0
recovery domain hash list	4	0.00		0	0
redo allocation	103,750	0.06	0.00	0	281,459	0.05
redo copy	4	0.00		0	281,511	0.23
redo writing	131,040	0.04	0.00	0	0
resmgr group change latch	3,342	0.00		0	0
resmgr:active threads	7,886	0.00		0	0
resmgr:actses change group	3,166	0.00		0	0
resmgr:actses change state	4	0.00		0	0
resmgr:free threads list	7,882	0.16	0.00	0	0
resmgr:plan CPU method	4	0.00		0	0
resmgr:resource group CPU method	4	0.00		0	0
resmgr:schema config	4	0.00		0	0
resmgr:session queuing	4	0.00		0	0
rm cas latch	4	0.00		0	0
row cache objects	1,159,113	0.18	0.00	0	121	1.65
rules engine aggregate statistics	19	0.00		0	0
rules engine rule set statistics	38	0.00		0	0
second Audit Vault latch	4	0.00		0	0
second spare latch	4	0.00		0	0
segmented array pool	20	0.00		0	0
sequence cache	52,595	0.02	0.00	0	0
session allocation	183,426	0.00		0	176,259	0.00
session idle bit	773,026	0.00	0.00	0	0
session queue latch	4	0.00		0	0
session state list latch	7,118	0.00		0	0
session switching	3,546	1.16	0.00	0	0
session timer	4,802	0.00		0	0
shared pool	809,773	0.14	0.01	0	29	0.00
shared pool sim alloc	821	0.00		0	0
shared pool simulator	17,608	0.00		0	0
shared server configuration	1	0.00		0	1	0.00
sim partition latch	4	0.00		0	0
simulator hash latch	703,012	0.00	0.00	0	0
simulator lru latch	4	0.00		0	466,550	0.02
sort extent pool	595	0.00		0	0
space background state object latch	57	0.00		0	0
space background task latch	24,237	0.45	0.00	0	9,677	0.00
state object free list	8	0.00		0	0
statistics aggregation	6,272	0.00		0	0
tablespace key chain	23	0.00		0	0
temp lob duration state obj allocation	8	0.00		0	0
temporary table state object allocation	28	0.00		0	0
test excl. parent l0	4	0.00		0	0
test excl. parent2 l0	4	0.00		0	0
third spare latch	4	0.00		0	0
threshold alerts latch	960	0.00		0	0
trace latch	446	0.00		0	0
transaction allocation	15,805	0.01	0.00	0	0
transaction branch allocation	4,295	0.00		0	0
undo global data	129,498	0.00	0.00	0	0
virtual circuit buffers	4	0.00		0	0
virtual circuit holder	4	0.00		0	0
virtual circuit queues	4	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
gc element	3,952,602	4,864	140	4,730
gcs resource hash	34,983,079	4,342	16	4,327
row cache objects	1,159,113	2,041	1	2,040
ges resource hash list	3,463,668,705	1,172	560	621
shared pool	809,773	1,126	7	1,119
gcs resource freelist	2,950,984	895	1	894
cache buffers chains	12,662,514	701	108	593
ges caches resource lists	102,716	460	4	456
object queue header operation	2,569,554	297	14	283
call allocation	17,851	147	85	68
mostly latch-free SCN	35,416	85	2	83
process allocation	72,807	81	8	73
active service list	153,895	52	15	37
cache buffers lru chain	50,910	31	1	30
KJC message pool free list	51,639	17	1	16
ges process hash list	202,613	17	16	1
checkpoint queue latch	1,838,862	8	1	7
parameter table management	23,446	4	2	2

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
KJC message pool free list	kjcspfmbq: free vector of msg buffers	1	0
active service list	kswslogon: session logout	24	23
active service list	kswsite: service iterator	2	0
cache buffers chains	kcbgcur_2	47	49
cache buffers chains	kcbgtcr: fast path	24	1
cache buffers chains	kcbrls_2	18	0
cache buffers chains	kcbgtcr: fast path (cr pin)	17	11
cache buffers chains	kclbla	5	0
cache buffers chains	kcbgtcr_2	3	3
cache buffers chains	kcbzwb	3	1
cache buffers chains	kcbchg1: clear MS bit	2	26
cache buffers chains	kcbgtcr: kslbegin excl	2	7
cache buffers chains	kcbchg1: mod cr pin	1	1
cache buffers chains	kcbgcur_4	1	2
cache buffers chains	kcbzgb: scan from tail. nowait	1	0
cache buffers chains	kcllkopesc	1	0
cache buffers lru chain	kcbzswcu	1	0
call allocation	ksuxds	83	82
call allocation	ksudlp: top call	2	2
checkpoint queue latch	kcbkubc_4	1	1
gc element	kclollnumiter_4	90	0
gc element	kclnfndnewm	23	50
gc element	kclchkping	21	0
gc element	kclplz	8	0
gc element	kclbla	4	0
gc element	KCLUNLNK	2	27
gc element	kclplz_1	1	0
gc element	kclulb	1	38
gcs resource freelist	kjbralc add resource	1	0
gcs resource hash	kjbmpclose	10	5
gcs resource hash	kjbrdrmcvtq_98	5	10
gcs resource hash	kjbopen	1	0
ges process hash list	kjakiqa: set inquiry response	16	0
ges resource hash list	kjakcai: search for resp by resname	189	0
ges resource hash list	kjrmas1: lookup master node	183	2
ges resource hash list	kjlrlr: remove lock from resource queue	64	76
ges resource hash list	kjakoca: search for resp by resname	48	479
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	47	0
ges resource hash list	kjddopt: check grouplock	8	23
ges resource hash list	kjddgmak	7	38
ges resource hash list	kjddopr: validate resource	7	0
ges resource hash list	kjrddgpop: set dd state	3	24
ges resource hash list	kjdggblkrdmp: get resp info	2	0
ges resource hash list	kjrref: find matched resource	1	31
ges resource hash list	kjucvl: lock convert request	1	165
ges resource table freelist	kjchc: clean resource cache	4	0
lgwr LWN SCN	kcs023	1	0
mostly latch-free SCN	kcslcu3	1	2
object queue header operation	kclobj_1	17	17
object queue header operation	kclobj_5	6	6
parameter table management	kspcpy	2	0
process allocation	ksufap: active procs	7	0
process allocation	ksucrp:1	1	0
row cache objects	kqrpre: find obj	1	0
shared pool	kghalo	3	2
shared pool	kgh_heap_sizes	1	1
shared pool	kghalp	1	1
shared pool	kghfre	1	1
shared pool	kghupr1	1	4

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Cursor Pin	kkslce [KKSCHLPIN2]	196
Library Cache	kgllkdl1 85	104
Library Cache	kglhdgn1 62	79
Library Cache	kglhdgn2 106	62
Library Cache	kgllkal1 80	47
Library Cache	kgllkc1 57	34
Library Cache	kglpnal2 91	32
Library Cache	kglpin1 4	29
Library Cache	kglpndl1 95	16
Library Cache	kglllal3 111	14
Library Cache	kglpnal1 90	12
Library Cache	kgllldl2 112	11
Library Cache	kglget2 2	10
Library Cache	kglini1 32	5
Library Cache	kglhdgh1 64	4
Library Cache	kglobpn1 71	4
Library Cache	kgldtin1 42	2
Library Cache	kglllal1 109	2
Library Cache	kglUpgradeLock 119	1
Library Cache	kgllkal3 82	1
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	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,955,211
Captured Segments account for 94.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
OCSB22	RPT	TMP_BALANCE_PAYOUT_B	TABLE	687,568	17.38
OCSB21	RPT	TMP_BALANCE_PAYOUT_B	TABLE	654,960	16.56
OCSA11	RPT	TMP_BALANCE_PAYOUT_A	TABLE	513,008	12.97
OCSA11	USER_DATA	BSS_PRICING_COMBINE	TABLE	284,560	7.19
OCSB22	USER_DATA	ACCT_ITEM	TABLE	255,664	6.46

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	44.61	In-memory Sort %:	100.00
Library Hit %:	90.35	Soft Parse %:	81.09
Execute to Parse %:	70.00	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	76.70	% Non-Parse CPU:	97.71

Buffer access - local cache %:	43.74
Buffer access - remote cache %:	0.87
Buffer access - disk %:	55.39

Avg global enqueue get time (ms):	642.6
Avg global cache cr block receive time (ms):	0.4
Avg global cache current block receive time (ms):	0.4
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 %:	18.1
Avg global cache cr block flush time (ms):	0.4
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 %:	4.7
Avg global cache current block flush time (ms):	0.5

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.2
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.6
% of direct sent messages:	66.18
% of indirect sent messages:	33.53
% of flow controlled messages:	0.29

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1725412641_7476	TABLE PARTITION	11,414	29.73
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1725412641_7476	INDEX PARTITION	4,782	12.45
OCSB21	USER_DATA	SMS_2013_09		TABLE	485	1.26
OCSA12	USER_DATA	SMS_CF_MID_HIS		TABLE	450	1.17
OCSA12	RPT	BALANCE_PAYOUT_A2_20130909		TABLE	395	1.03

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_OBJ2	INDEX	3	7.69
SYSMAN	SYSAUX	MGMT_CURRENT_METRICS_PK	INDEX	2	5.13
OCSA11	USER_DATA	ACCT_ITEM	TABLE	1	2.56
OCSA12	USER_DATA	ACCT_ITEM	TABLE	1	2.56
OCSB21	USER_DATA	ACCT_ITEM	TABLE	1	2.56

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
SYS	SYSTEM	AUD$		TABLE	44,768	18.61
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_1725412641_7476	INDEX PARTITION	39,952	16.61
OMC30	BNMS_DATA01	IDX3_BSS_LOG201308011		INDEX	7,136	2.97
OCSA12	USER_DATA	TRANS_LOG		TABLE	6,688	2.78
OCSB21	USER_DATA	SMS_CF_MID_HIS		TABLE	6,256	2.60

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
OMC30	BNMS_DATA01	IDX4_BSS_LOG201308011	INDEX	9	40.91
SYS	SYSTEM	I_COL1	INDEX	6	27.27
OMC30	BNMS_DATA01	IDX3_BSS_LOG201308011	INDEX	3	13.64
SYS	SYSTEM	I_OBJ#	INDEX	2	9.09
OMC30	BNMS_DATA01	IDX2_BSS_LOG201308011	INDEX	1	4.55

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	358	0.00	8	1
dc_constraints	128	68.75	128	64
dc_files	72	0.00	0	24
dc_global_oids	3,109	0.03	0	48
dc_histogram_data	11,685	3.83	0	2,959
dc_histogram_defs	31,622	2.29	9	5,061
dc_object_grants	81	17.28	0	42
dc_objects	45,437	1.10	102	2,281
dc_profiles	3,099	0.03	0	2
dc_rollback_segments	13,316	0.00	0	73
dc_segments	30,426	0.61	1,597	1,179
dc_sequences	687	64.77	687	10
dc_tablespaces	19,365	0.01	0	15
dc_users	261,161	0.01	0	127
global database name	20,280	0.00	0	1
outstanding_alerts	322	85.40	19	5
sch_lj_oids	22	9.09	0	6

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	6,240	0.05	0		0	0
BODY	7,644	0.05	9,687	0.04	0	0
CLUSTER	142	0.70	142	0.70	0	0
DBLINK	6,427	0.03	0		0	0
EDITION	2,959	0.00	5,820	0.00	0	0
INDEX	63	12.70	71	14.08	0	0
OBJECT ID	21	100.00	0		0	0
QUEUE	3,508	0.00	4,362	0.00	0	0
RULESET	1	0.00	19	0.00	0	0
SCHEMA	3,873	0.05	0		0	0
SQL AREA	43,920	21.15	231,935	12.12	1	82
SQL AREA BUILD	9,365	98.96	0		0	0
SQL AREA STATS	9,372	99.99	9,372	99.99	0	0
SUBSCRIPTION	50	0.00	50	2.00	1	0
TABLE/PROCEDURE	16,080	1.64	132,393	0.57	21	0
TRANSFORMATION	1,438	0.00	1,438	0.00	0	0
TRIGGER	1,181	1.19	1,367	1.61	0	0

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	20,224.00	20,224.00	20,224.00	20,224.00	INI/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	7,808.00	7,808.00	7,808.00	7,808.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	23,360.00	23,360.00	23,360.00	23,360.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	192.00	192.00	192.00	192.00	STA/
large pool	64.00	64.00	64.00	64.00	STA/
shared pool	2,752.00	2,752.00	2,496.00	2,752.00	GRO/IMM
streams pool	0.00	0.00	0.00	0.00	STA/

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	306.09		4.50	6.75	42	42	68	68
B	Freeable	25.81	0.00	1.61	2.35	10		16	16
B	PL/SQL	0.48	0.33	0.01	0.02	0	0	66	65
B	SQL	0.38	0.19	0.01	0.02	0	6	33	25
E	Other	884.63		1.67	3.87	57	57	530	530
E	Freeable	35.44	0.00	1.42	2.34	10		25	25
E	PL/SQL	1.39	0.46	0.00	0.01	0	0	528	527
E	SQL	1.12	0.61	0.01	0.02	0	6	78	69

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	21,206,401,024
Fixed Size	2,232,712
Redo Buffers	22,618,112
Variable Size	3,154,120,312

Pool	Name	Begin MB	End MB	% Diff
java	free memory	192.00	192.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	55.81	55.81	0.00
shared	FileOpenBlock	60.80	60.80	0.00
shared	KGLH0		135.71
shared	SQLA	34.58	154.26	346.15
shared	db_block_hash_buckets	178.00	178.00	0.00
shared	dbktb: trace buffer	78.13	78.13	0.00
shared	event statistics per sess	93.91	93.91	0.00
shared	free memory	618.26	326.47	-47.19
shared	gc name table	48.00	48.00	0.00
shared	gcs resources	536.00	536.00	0.00
shared	gcs shadows	312.66	312.66	0.00
shared	ges big msg buffers	60.79	60.79	0.00
shared	ges enqueues	96.44	96.44	0.00
shared	ges resource	47.27	47.96	1.48
shared	ksunfy : SSO free list	87.54	87.54	0.00
	buffer_cache	20,224.00	20,224.00	0.00
	fixed_sga	2.13	2.13	0.00
	log_buffer	21.57	21.57	0.00

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/billdb/adump
audit_trail	DB
cluster_database	TRUE
compatible	11.2.0.0.0
control_files	+DG_BILLDB_DATA/billdb/control01.ctl, +DG_BILLDB_DATA/billdb/control02.ctl
db_block_size	8192
db_domain
db_files	2000
db_name	billdb
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=billdbXDB)
instance_number	1
local_listener	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=136.24.2.27)(PORT=1521))))
log_archive_dest_1	location=/ocs_arch1/billdb1
log_archive_dest_2
log_archive_format	billdb%t_%s_%r.dbf
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	600
pga_aggregate_target	8145338368
processes	5000
remote_listener	scan-xjocsdb:1521
remote_login_passwordfile	EXCLUSIVE
service_names	serv_taf_billdb2, serv_taf_billdb, serv_taf_billdb1
sessions	7524
sga_target	24494735360
spfile	+DG_BILLDB_DATA/billdb/spfilebilldb.ora
thread	1
undo_tablespace	UNDOTBS1

Parameter Name	Begin value	End value (if different)
control_files	+DG_BILLDB_DATA/billdb/control01.ctl
control_files	+DG_BILLDB_DATA/billdb/control02.ctl
service_names	serv_taf_billdb
service_names	serv_taf_billdb1
service_names	serv_taf_billdb2

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	46,684	3.24	2.14
acks for commit broadcast(logical)	48,001	3.33	2.20
broadcast msgs on commit(actual)	31,952	2.22	1.46
broadcast msgs on commit(logical)	32,742	2.27	1.50
broadcast msgs on commit(wasted)	624	0.04	0.03
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	2	0.00	0.00
flow control messages sent	8	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	4,873	0.34	0.22
gcs ast xid	3	0.00	0.00
gcs blocked converts	8,505	0.59	0.39
gcs blocked cr converts	6,078	0.42	0.28
gcs compatible basts	105	0.01	0.00
gcs compatible cr basts (global)	1,120	0.08	0.05
gcs compatible cr basts (local)	3,434	0.24	0.16
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	2,929	0.20	0.13
gcs dbwr write request msgs	2,250	0.16	0.10
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	8	0.00	0.00
gcs force cr grant	1	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	1,468	0.10	0.07
gcs immediate (null) converts	17,188	1.19	0.79
gcs immediate cr (compatible) converts	7	0.00	0.00
gcs immediate cr (null) converts	2,342,998	162.56	107.29
gcs indirect ast	8,376	0.58	0.38
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	8,376	0.58	0.38
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	397	0.03	0.02
gcs msgs process time(ms)	19,490	1.35	0.89
gcs msgs received	3,464,177	240.35	158.64
gcs new served by master	9,121	0.63	0.42
gcs out-of-order msgs	1	0.00	0.00
gcs pings refused	19	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	17	0.00	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	3	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	6	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	5,736	0.40	0.26
gcs side channel msgs logical	38,566	2.68	1.77
gcs stale cr	61	0.00	0.00
gcs undo cr	102	0.01	0.00
gcs write notification msgs	103	0.01	0.00
gcs writes refused	12	0.00	0.00
ges msgs process time(ms)	2,237,351	155.23	102.46
ges msgs received	3,528,532	244.82	161.59
global posts dropped	0	0.00	0.00
global posts queue time	25,950	1.80	1.19
global posts queued	270	0.02	0.01
global posts requested	270	0.02	0.01
global posts sent	271	0.02	0.01
implicit batch messages received	42,648	2.96	1.95
implicit batch messages sent	20,410	1.42	0.93
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	370	0.03	0.02
messages queue sent actual	3,519,241	244.17	161.16
messages queue sent logical	59,657	4.14	2.73
messages received actual	3,818,308	264.92	174.85
messages received logical	6,992,657	485.17	320.22
messages sent directly	84,683	5.88	3.88
messages sent indirectly	42,913	2.98	1.97
messages sent not implicit batched	15	0.00	0.00
messages sent pbatched	5,966,710	413.98	273.24
msgs causing lmd to send msgs	3,422,444	237.46	156.73
msgs causing lms(s) to send msgs	117,325	8.14	5.37
msgs received queue time (ms)	439,178	30.47	20.11
msgs received queued	6,992,706	485.17	320.22
msgs sent queue time (ms)	8,113	0.56	0.37
msgs sent queue time on ksxp (ms)	910,048	63.14	41.67
msgs sent queued	3,556,731	246.77	162.88
msgs sent queued on ksxp	3,791,379	263.05	173.62
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	3,663,492	254.18	167.77
process batch messages sent	3,709,807	257.39	169.89

Statistic	Total
CR Block Requests	3,835
CURRENT Block Requests	6,002
Data Block Requests	3,835
Undo Block Requests	84
TX Block Requests	387
Current Results	9,738
Private results	20
Zero Results	23
Disk Read Results	55
Fail Results	1
Fairness Down Converts	4,939
Fairness Clears	102
Free GC Elements	0
Flushes	1,767
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	14,050
Light Works	62
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <10s
Pins	128	76.56	21.09	2.34	0.00
Flushes	597	94.47	5.03	0.50	0.00
Writes	3,423	87.35	8.71	0.61	3.33

WORKLOAD REPOSITORY report for

Report Summary

RAC Statistics

Main Report

More RAC Statistics

Wait Events Statistics

Time Model Statistics

Operating System Statistics

Operating System Statistics - Detail

Foreground Wait Class

Foreground Wait Events

Background Wait Events

Wait Event Histogram

Wait Event Histogram Detail (64 msec to 2 sec)

Wait Event Histogram Detail (4 sec to 2 min)

Wait Event Histogram Detail (4 min to 1 hr)

Service Statistics

Service Wait Class Stats

SQL Statistics

SQL ordered by Elapsed Time

SQL ordered by CPU Time

SQL ordered by User I/O Wait Time

SQL ordered by Gets

SQL ordered by Reads

SQL ordered by Physical Reads (UnOptimized)

SQL ordered by Executions

SQL ordered by Parse Calls

SQL ordered by Sharable Memory

SQL ordered by Version Count

SQL ordered by Cluster Wait Time

Complete List of SQL Text

Instance Activity Statistics

Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

Advisory Statistics

Instance Recovery Stats

MTTR Advisory

Buffer Pool Advisory

PGA Aggr Summary

PGA Aggr Target Stats

PGA Aggr Target Histogram

PGA Memory Advisory

Shared Pool Advisory

SGA Target Advisory

Streams Pool Advisory

Java Pool Advisory

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Segment Statistics

Segments by Logical Reads

Segments by Physical Reads

Segments by Physical Read Requests

Segments by UnOptimized Reads

Segments by Optimized Reads

Segments by Direct Physical Reads

Segments by Physical Writes

Segments by Physical Write Requests

Segments by Direct Physical Writes

Segments by Table Scans

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	4,621	96.65	3.31	0.04	14,886	96.84	3.08	0.08
2	Others	4,971	99.88	0.06	0.06	3,711	95.80	4.07	0.13
2	undo header	1,066	97.28	2.72	0.00	104	94.23	4.81	0.96
2	undo block	34	70.59	29.41	0.00	0

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	0.55	0.53	1.12	1.08	0.56	0.52	1.87	0.68
2	others	0.58	0.58	0.77	0.48	0.51	0.48	1.18	0.47
2	undo header	0.36	0.34	1.08		0.61	0.57	1.45	0.33
2	undo block	0.43	0.35	0.64

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	4,466	100.00	0.00	14,415	100.00	0.00
2	others	0	4,965	100.00	0.00	3,555	100.00	0.00
2	undo header	0	1,037	100.00	0.00	98	100.00	0.00
2	undo block	0	24	100.00	0.00	0

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

Name	Total	per Remaster Op	Begin Snap	End Snap
remaster ops	9	1.00
remastered objects	14	1.56
replayed locks received	0	0.00
replayed locks sent	60	6.67
resources cleaned	0	0.00
remaster time (s)	23.5	2.61
quiesce time (s)	4.9	0.55
freeze time (s)	0.3	0.03
cleanup time (s)	3.2	0.35
replay time (s)	2.2	0.25
fixwrite time (s)	3.4	0.37
sync time (s)	9.2	1.03
affinity objects			14	17