[oracle@bppfedb1 jc]$ cat bppfedb1_20140305_1030_1100.html AWR Report for DB: BPPFEDB, Inst: bppfedb1, Snaps: 23866-23867

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

BPPFEDB 1195271196 bppfedb1 1 04-Mar-14 18:03 11.2.0.3.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
BPPFEDB	1195271196	bppfedb1	1	04-Mar-14 18:03	11.2.0.3.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

bppfedb1 Linux x86 64-bit 48 24 4 125.99

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
bppfedb1	Linux x86 64-bit	48	24	4	125.99

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 23866 05-Mar-14 10:30:04 318 5.5

End Snap: 23867 05-Mar-14 11:00:10 331 4.7

Elapsed: 30.10 (mins)

DB Time: 64.89 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	23866	05-Mar-14 10:30:04	318	5.5
End Snap:	23867	05-Mar-14 11:00:10	331	4.7
Elapsed:		30.10 (mins)
DB Time:		64.89 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 49,408M 49,408M Std Block Size: 8K

Shared Pool Size: 9,472M 9,472M Log Buffer: 53,972K

	Begin	End
Buffer Cache:	49,408M	49,408M	Std Block Size:	8K
Shared Pool Size:	9,472M	9,472M	Log Buffer:	53,972K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 2.2 0.1 0.00 0.00

DB CPU(s): 1.6 0.0 0.00 0.00

Redo size: 95,432.7 2,359.0

Logical reads: 114,132.7 2,821.3

Block changes: 575.9 14.2

Physical reads: 23,931.6 591.6

Physical writes: 24.6 0.6

User calls: 2,842.6 70.3

Parses: 554.7 13.7

Hard parses: 60.0 1.5

W/A MB processed: 9.4 0.2

Logons: 0.4 0.0

Executes: 558.1 13.8

Rollbacks: 3.9 0.1

Transactions: 40.5

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.2	0.1	0.00	0.00
DB CPU(s):	1.6	0.0	0.00	0.00
Redo size:	95,432.7	2,359.0
Logical reads:	114,132.7	2,821.3
Block changes:	575.9	14.2
Physical reads:	23,931.6	591.6
Physical writes:	24.6	0.6
User calls:	2,842.6	70.3
Parses:	554.7	13.7
Hard parses:	60.0	1.5
W/A MB processed:	9.4	0.2
Logons:	0.4	0.0
Executes:	558.1	13.8
Rollbacks:	3.9	0.1
Transactions:	40.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 86.77 Soft Parse %: 89.19

Execute to Parse %: 0.60 Latch Hit %: 99.90

Parse CPU to Parse Elapsd %: 106.14 % Non-Parse CPU: 90.88

Shared Pool Statistics

Begin End

Memory Usage %: 72.30 72.14

% SQL with executions>1: 78.25 79.48

% Memory for SQL w/exec>1: 73.36 74.52

	Begin	End
Memory Usage %:	72.30	72.14
% SQL with executions>1:	78.25	79.48
% Memory for SQL w/exec>1:	73.36	74.52

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
SQL*Net break/reset to client	365	402,860	1103726	10347.92	Application
DB CPU		2,929		75.23
direct path read	189,212	395	2	10.15	User I/O
db file sequential read	38,645	214	6	5.50	User I/O
log file sync	65,228	180	3	4.64	Commit

Host CPU (CPUs: 48 Cores: 24 Sockets: 4)

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

1.98 1.79 3.4 0.6 0.6 95.9

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.98	1.79	3.4	0.6	0.6	95.9

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

3.6 87.7 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 60,160.0 60,160.0

PGA use (MB): 1,420.2 1,437.9

% Host Mem used for SGA+PGA: 47.73 47.74

	Begin	End
Host Mem (MB):	129,015.4	129,015.4
SGA use (MB):	60,160.0	60,160.0
PGA use (MB):	1,420.2	1,437.9
% Host Mem used for SGA+PGA:	47.73	47.74

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: 48.00 1.19

Global Cache blocks served: 89.06 2.20

GCS/GES messages received: 257.87 6.37

GCS/GES messages sent: 181.50 4.49

DBWR Fusion writes: 4.09 0.10

Estd Interconnect traffic (KB) 1,182.26

	Per Second	Per Transaction
Global Cache blocks received:	48.00	1.19
Global Cache blocks served:	89.06	2.20
GCS/GES messages received:	257.87	6.37
GCS/GES messages sent:	181.50	4.49
DBWR Fusion writes:	4.09	0.10
Estd Interconnect traffic (KB)	1,182.26

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

Buffer access - local cache %: 99.92

Buffer access - remote cache %: 0.05

Buffer access - disk %: 0.03

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0

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

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

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

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

Avg global cache current block pin time (ms): 1,338.0

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

Global cache log flushes for current blocks served %: 1.2

Avg global cache current block flush time (ms): 16,420.9

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.3

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 80.09

% of indirect sent messages: 19.56

% of flow controlled messages: 0.35

Cluster Interconnect

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

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
bond1:1	169.254.10.248	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): 3893.1s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	3,105.80	79.78
DB CPU	2,928.63	75.23
parse time elapsed	295.58	7.59
hard parse elapsed time	198.49	5.10
PL/SQL execution elapsed time	6.28	0.16
connection management call elapsed time	5.87	0.15
sequence load elapsed time	0.41	0.01
hard parse (sharing criteria) elapsed time	0.40	0.01
PL/SQL compilation elapsed time	0.37	0.01
hard parse (bind mismatch) elapsed time	0.36	0.01
repeated bind elapsed time	0.20	0.01
failed parse elapsed time	0.03	0.00
DB time	3,893.15
background elapsed time	335.68
background cpu time	167.29

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	352,956
IDLE_TIME	8,353,102
IOWAIT_TIME	54,055
NICE_TIME	1
SYS_TIME	51,969
USER_TIME	291,874
LOAD	2	2
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	135,282,409,472
NUM_CPUS	48
NUM_CPU_CORES	24
NUM_CPU_SOCKETS	4
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
05-Mar 10:30:04	1.98
05-Mar 11:00:10	1.79	4.05	3.35	0.60	95.95	0.62

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 10,449.4% of Total DB time 3,893.15 (s)
Total FG Wait Time: 403,880.89 (s) DB CPU time: 2,928.63 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Application	750	0	402,864	537153	10,348.03
DB CPU			2,929		75.23
User I/O	232,061	0	620	3	15.92
Commit	65,228	0	180	3	4.64
Network	3,549,514	0	115	0	2.96
Cluster	108,479	0	78	1	2.00
Other	53,257	2	15	0	0.38
Concurrency	5,807	0	8	1	0.20
System I/O	708	0	1	1	0.02
Configuration	8	0	0	12	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
SQL*Net break/reset to client	365	0	402,860	1103726	0.00	10347.92
direct path read	189,212	0	395	2	2.59	10.15
db file sequential read	38,645	0	214	6	0.53	5.50
log file sync	65,228	0	180	3	0.89	4.64
SQL*Net message from dblink	1,980	0	110	56	0.03	2.83
gc current block 2-way	45,443	0	22	0	0.62	0.58
gc cr block 2-way	29,044	0	14	0	0.40	0.35
gc current block busy	2,404	0	12	5	0.03	0.30
gc cr block busy	4,086	0	11	3	0.06	0.27
db file scattered read	1,457	0	9	6	0.02	0.23
DFS lock handle	17,873	0	7	0	0.24	0.18
gc current grant busy	12,301	0	7	1	0.17	0.17
rdbms ipc reply	31,371	0	6	0	0.43	0.17
gc buffer busy acquire	2,434	0	5	2	0.03	0.12
enq: TX - row lock contention	253	0	4	17	0.00	0.11
enq: TX - index contention	331	0	4	12	0.00	0.11
SQL*Net message to client	3,538,617	0	4	0	48.44	0.10
gc current grant 2-way	7,430	0	3	0	0.10	0.09
gc buffer busy release	184	0	2	13	0.00	0.06
library cache: mutex X	1,211	0	1	1	0.02	0.03
gc cr grant 2-way	2,949	0	1	0	0.04	0.03
db file parallel read	78	0	1	11	0.00	0.02
SQL*Net more data from dblink	418	0	1	2	0.01	0.02
control file sequential read	708	0	1	1	0.01	0.02
cursor: pin S wait on X	60	0	1	10	0.00	0.02
name-service call wait	6	0	0	83	0.00	0.01
latch: shared pool	1,638	0	0	0	0.02	0.01
buffer busy waits	719	0	0	1	0.01	0.01
gc current block congested	766	0	0	1	0.01	0.01
Disk file operations I/O	2,642	0	0	0	0.04	0.01
gc cr multi block request	463	0	0	1	0.01	0.01
row cache lock	971	0	0	0	0.01	0.01
gc cr block congested	507	0	0	0	0.01	0.01
enq: KO - fast object checkpoint	129	0	0	2	0.00	0.01
ASM file metadata operation	6	0	0	28	0.00	0.00
SQL*Net more data to client	6,390	0	0	0	0.09	0.00
os thread startup	2	0	0	78	0.00	0.00
reliable message	85	0	0	2	0.00	0.00
gc current multi block request	197	0	0	1	0.00	0.00
library cache lock	224	2	0	0	0.00	0.00
library cache pin	290	0	0	0	0.00	0.00
enq: JQ - contention	235	100	0	0	0.00	0.00
log file switch completion	3	0	0	27	0.00	0.00
gc current grant congested	162	0	0	0	0.00	0.00
read by other session	23	0	0	3	0.00	0.00
KJC: Wait for msg sends to complete	2,322	0	0	0	0.03	0.00
gc current split	43	0	0	1	0.00	0.00
gc cr grant congested	59	0	0	0	0.00	0.00
SQL*Net more data from client	143	0	0	0	0.00	0.00
cursor: pin S	9	0	0	2	0.00	0.00
IPC send completion sync	60	0	0	0	0.00	0.00
latch: cache buffers chains	297	0	0	0	0.00	0.00
CSS initialization	2	0	0	9	0.00	0.00
enq: PS - contention	32	25	0	1	0.00	0.00
latch free	36	0	0	0	0.00	0.00
enq: SQ - contention	3	0	0	5	0.00	0.00
PX Deq: Slave Session Stats	51	0	0	0	0.00	0.00
enq: FB - contention	30	0	0	0	0.00	0.00
direct path write temp	2	0	0	5	0.00	0.00
CSS operation: action	2	0	0	3	0.00	0.00
latch: row cache objects	54	0	0	0	0.00	0.00
PX Deq: reap credit	422	100	0	0	0.01	0.00
latch: ges resource hash list	42	0	0	0	0.00	0.00
PX Deq: Signal ACK RSG	24	0	0	0	0.00	0.00
direct path read temp	2	0	0	1	0.00	0.00
buffer deadlock	316	100	0	0	0.00	0.00
SQL*Net message to dblink	1,966	0	0	0	0.03	0.00
CSS operation: query	6	0	0	0	0.00	0.00
PX Deq: Signal ACK EXT	24	0	0	0	0.00	0.00
enq: TT - contention	3	0	0	0	0.00	0.00
SQL*Net message from client	3,538,605	0	826,298	234	48.44
jobq slave wait	9,211	92	4,755	516	0.13
single-task message	15	0	1	42	0.00
PX Deq: Execution Msg	108	0	0	3	0.00
PX Deq: Parse Reply	24	0	0	4	0.00
PX Deq: Execute Reply	24	0	0	2	0.00
PX Deq: Join ACK	24	0	0	1	0.00
KSV master wait	27	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	69,609	0	100	1	0.95	29.67
db file parallel write	31,587	0	22	1	0.43	6.55
gcs log flush sync	10,002	7	20	2	0.14	5.94
Streams AQ: qmn coordinator waiting for slave to start	2	100	12	6141	0.00	3.66
control file sequential read	6,267	0	10	2	0.09	2.84
reliable message	147	3	8	52	0.00	2.28
DFS lock handle	5,995	100	3	1	0.08	0.96
os thread startup	55	0	3	50	0.00	0.81
log file sequential read	255	0	2	9	0.00	0.72
db file sequential read	479	0	1	2	0.01	0.34
control file parallel write	923	0	1	1	0.01	0.33
row cache lock	3,077	0	1	0	0.04	0.28
gc cr block 2-way	2,075	0	1	0	0.03	0.23
ASM file metadata operation	749	0	0	1	0.01	0.12
latch free	34	0	0	10	0.00	0.10
gc current block 2-way	742	0	0	0	0.01	0.10
row cache process	25,217	0	0	0	0.35	0.07
CGS wait for IPC msg	15,556	100	0	0	0.21	0.06
CSS operation: data query	90	0	0	2	0.00	0.05
name-service call wait	3	0	0	39	0.00	0.04
ksxr poll remote instances	10,774	100	0	0	0.15	0.03
enq: KO - fast object checkpoint	287	0	0	0	0.00	0.03
row cache cleanup	16,491	0	0	0	0.23	0.02
library cache pin	256	0	0	0	0.00	0.02
library cache lock	243	0	0	0	0.00	0.02
ges inquiry response	159	0	0	0	0.00	0.02
db file async I/O submit	30,319	0	0	0	0.41	0.02
gc current block busy	31	0	0	2	0.00	0.01
CSS group membership query	30	0	0	1	0.00	0.01
gc current grant busy	77	0	0	0	0.00	0.01
direct path write	17	0	0	2	0.00	0.01
enq: CF - contention	59	90	0	0	0.00	0.01
gc current grant 2-way	41	0	0	0	0.00	0.01
LGWR wait for redo copy	405	0	0	0	0.01	0.01
Disk file operations I/O	520	0	0	0	0.01	0.00
kfk: async disk IO	3	0	0	5	0.00	0.00
gc cr block congested	36	0	0	0	0.00	0.00
gc cr block busy	5	0	0	3	0.00	0.00
latch: shared pool	52	0	0	0	0.00	0.00
db file parallel read	1	0	0	11	0.00	0.00
PX Deq: reap credit	1,077	100	0	0	0.01	0.00
libcache interrupt action by LCK	12,039	0	0	0	0.16	0.00
CSS initialization	2	0	0	4	0.00	0.00
db file scattered read	1	0	0	8	0.00	0.00
CSS operation: action	6	0	0	1	0.00	0.00
enq: PS - contention	12	50	0	1	0.00	0.00
gc current block congested	15	0	0	0	0.00	0.00
direct path read	3	0	0	2	0.00	0.00
enq: WF - contention	11	0	0	0	0.00	0.00
latch: call allocation	21	0	0	0	0.00	0.00
enq: TT - contention	13	92	0	0	0.00	0.00
asynch descriptor resize	372	100	0	0	0.01	0.00
gc cr grant 2-way	10	0	0	0	0.00	0.00
latch: messages	13	0	0	0	0.00	0.00
latch: ges resource hash list	72	0	0	0	0.00	0.00
buffer busy waits	35	0	0	0	0.00	0.00
latch: redo writing	7	0	0	0	0.00	0.00
gc buffer busy release	2	0	0	1	0.00	0.00
PX Deq: Slave Session Stats	9	0	0	0	0.00	0.00
enq: TA - contention	5	0	0	0	0.00	0.00
log file single write	4	0	0	0	0.00	0.00
enq: TM - contention	5	80	0	0	0.00	0.00
enq: TD - KTF dump entries	4	0	0	0	0.00	0.00
SQL*Net message to client	779	0	0	0	0.01	0.00
rdbms ipc message	215,629	15	52,467	243	2.95
class slave wait	364	0	6,113	16794	0.00
gcs remote message	754,025	55	5,541	7	10.32
wait for unread message on broadcast channel	3,632	89	3,726	1026	0.05
DIAG idle wait	41,806	83	3,710	89	0.57
Space Manager: slave idle wait	624	98	3,256	5218	0.01
PX Idle Wait	30	0	2,481	82706	0.00
Streams AQ: waiting for time management or cleanup tasks	38	61	2,267	59660	0.00
smon timer	14	21	1,979	141349	0.00
Streams AQ: qmn slave idle wait	71	6	1,966	27695	0.00
dispatcher timer	31	100	1,890	60977	0.00
PING	645	22	1,860	2883	0.01
ges remote message	78,074	11	1,859	24	1.07
GCR sleep	361	99	1,858	5146	0.00
pmon timer	619	96	1,857	3001	0.01
shared server idle wait	60	100	1,855	30909	0.00
Streams AQ: qmn coordinator idle wait	125	50	1,830	14638	0.00
ASM background timer	376	0	1,807	4805	0.01
SQL*Net message from client	1,038	0	276	266	0.01
KSV master wait	1,218	92	0	0	0.02
heartbeat monitor sleep	21	0	0	3	0.00
PX Deq: Parse Reply	9	0	0	2	0.00
PX Deq: Join ACK	9	0	0	2	0.00
PX Deq: Execute Reply	9	0	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	128	100	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ARCH wait for archivelog lock	1	100.0
ASM file metadata operation	753	97.9	.1	.5	.1	.1	.9	.3
CGS wait for IPC msg	15.6K	100.0
CSS group membership query	30	13.3	76.7	10.0
CSS initialization	6	50.0			16.7	16.7	16.7
CSS operation: action	10	30.0	30.0	40.0
CSS operation: data query	90	4.4	76.7	18.9
CSS operation: query	48	97.9	2.1
DFS lock handle	23.9K	99.4	.5	.1	.1	.0		.0
Disk file operations I/O	3181	99.0	.3	.2	.3	.2	.1	.1
IPC send completion sync	66	98.5	1.5
KJC: Wait for msg sends to complete	2327	100.0
LGWR wait for redo copy	404	100.0
Log archive I/O	1	100.0
PX Deq: Signal ACK EXT	33	100.0
PX Deq: Signal ACK RSG	33	100.0
PX Deq: Slave Session Stats	60	96.7	3.3
PX Deq: reap credit	1499	100.0
SQL*Net break/reset to client	365	97.8							2.2
SQL*Net message from dblink	1989	60.5	20.0	5.8	2.8	.6	1.3	8.4	.6
SQL*Net message to client	3537.2K	100.0	.0
SQL*Net message to dblink	1975	100.0
SQL*Net more data from client	166	100.0
SQL*Net more data from dblink	418	57.7	22.7	11.2	6.7	.7		1.0
SQL*Net more data to client	6413	100.0
Streams AQ: qmn coordinator waiting for slave to start	2								100.0
asynch descriptor resize	633	100.0
buffer busy waits	753	92.4	3.6	.5	1.2	1.5	.8
buffer deadlock	316	100.0
control file parallel write	922	85.4	6.7	2.3	2.2	2.3	.8	.4
control file sequential read	6971	83.3	8.5	3.4	1.8	1.6	.7	.8
cursor: pin S	9	77.8				22.2
cursor: pin S wait on X	60	3.3	5.0	3.3	3.3	83.3		1.7
db file async I/O submit	30.3K	100.0
db file parallel read	79	13.9	1.3	5.1	26.6	35.4	12.7	5.1
db file parallel write	31.6K	91.0	4.9	1.9	.9	.7	.4	.3
db file scattered read	1458	9.8	2.1	20.0	54.3	10.2	2.7	.9
db file sequential read	39.1K	13.8	2.8	20.1	51.5	9.3	1.8	.7
direct path read	189.2K	41.7	30.4	17.7	7.0	2.4	.6	.2
direct path read temp	2	50.0	50.0
direct path write	17	82.4	5.9	5.9			5.9
direct path write temp	3	33.3			66.7
enq: AF - task serialization	1	100.0
enq: CF - contention	59	100.0
enq: CR - block range reuse ckpt	1	100.0
enq: DR - contention	1	100.0
enq: FB - contention	33	100.0
enq: HW - contention	4	100.0
enq: JQ - contention	234	98.7	1.3
enq: JS - job run lock - synchronize	1	100.0
enq: KO - fast object checkpoint	415	92.0	1.7	2.7	1.7	1.7	.2
enq: PI - contention	1	100.0
enq: PS - contention	44	100.0
enq: SQ - contention	3	33.3		33.3		33.3
enq: TA - contention	5	100.0
enq: TD - KTF dump entries	4	100.0
enq: TM - contention	7	100.0
enq: TO - contention	2	100.0
enq: TQ - TM contention	1	100.0
enq: TT - contention	16	100.0
enq: TX - index contention	329	41.3	4.0	6.4	7.9	11.9	17.3	11.2
enq: TX - row lock contention	253	.8	1.6	4.0	11.1	32.8	45.1	4.7
enq: UL - contention	1	100.0
enq: WF - contention	11	90.9	9.1
gc buffer busy acquire	2424	69.5	11.0	6.3	5.0	7.5	.6	.0
gc buffer busy release	186	33.3	8.6	7.5	12.9	14.5	11.8	11.3
gc cr block 2-way	31.1K	99.4	.5	.0		.0
gc cr block busy	4085	2.1	74.7	14.1	3.7	3.6	1.6	.2
gc cr block congested	542	99.4	.4	.2
gc cr grant 2-way	2917	99.7	.3	.0
gc cr grant congested	58	98.3	1.7
gc cr multi block request	476	89.9	8.0	1.3	.2	.4	.2
gc current block 2-way	46.2K	99.3	.6	.0	.0	.0
gc current block busy	2416	7.3	40.4	16.8	10.2	23.3	1.6	.3
gc current block congested	788	99.4	.5			.1
gc current grant 2-way	7480	99.6	.3	.1	.0
gc current grant busy	12.4K	99.2	.4	.1	.1	.2	.0
gc current grant congested	164	100.0
gc current multi block request	198	97.5	2.5
gc current retry	7	100.0
gc current split	43	88.4	11.6
gcs log flush sync	9973	63.3	13.9	8.0	6.4	8.4
ges inquiry response	158	100.0
global enqueue expand wait	10	100.0
kfk: async disk IO	3	66.7				33.3
ksxr poll remote instances	10.8K	100.0
latch free	70	50.0	4.3	4.3	28.6	8.6	4.3
latch: active service list	2	100.0
latch: cache buffers chains	312	99.7	.3
latch: cache buffers lru chain	1	100.0
latch: call allocation	21	100.0
latch: enqueue hash chains	3	100.0
latch: gc element	31	100.0
latch: gcs resource hash	1	100.0
latch: ges resource hash list	113	100.0
latch: messages	13	100.0
latch: object queue header operation	1	100.0
latch: redo allocation	2	100.0
latch: redo writing	7	100.0
latch: row cache objects	54	100.0
latch: shared pool	1696	95.1	3.2	1.2	.4	.1
latch: undo global data	1	100.0
libcache interrupt action by LCK	12.1K	100.0
library cache load lock	1	100.0
library cache lock	457	99.1	.9
library cache pin	536	99.4	.4		.2
library cache: mutex X	1210	90.2	.2			9.1	.5
lock deadlock retry	5	100.0
lock escalate retry	3	100.0
log file parallel write	69.6K	84.9	5.4	2.0	3.0	3.0	1.2	.6
log file sequential read	255	9.8	6.7	19.6	31.0	17.6	11.0	4.3
log file single write	4	100.0
log file switch completion	3						100.0
log file sync	65.3K	64.6	17.5	6.6	4.1	4.3	1.7	1.1
name-service call wait	9						11.1	88.9
os thread startup	57							100.0
rdbms ipc reply	31.4K	98.9	1.1	.0	.0	.0		.0
read by other session	23	60.9	13.0	8.7	8.7	4.3	4.3
reliable message	232	58.6	11.2	22.0	3.4			4.7
row cache cleanup	16.6K	99.9	.0	.0
row cache lock	4038	98.8	1.1	.0	.0
row cache process	25.4K	100.0
ASM background timer	376	5.1	.8	.3			.3	.5	93.1
DIAG idle wait	41.8K	13.7	1.6	.1	.1	2.9	30.7	50.9	.0
GCR sleep	361	.3							99.7
KSV master wait	1245	99.4		.4	.1	.1		.1
PING	645	76.7				.2		.3	22.8
PX Deq: Execute Reply	33	57.6	6.1	27.3	6.1	3.0
PX Deq: Execution Msg	108	70.4	18.5	3.7	4.6		1.9	.9
PX Deq: Join ACK	33	30.3	54.5	15.2
PX Deq: Parse Reply	33	42.4	33.3	3.0	12.1	3.0	6.1
PX Idle Wait	27	7.4	11.1	7.4			3.7	29.6	40.7
SQL*Net message from client	3538.5K	91.8	4.7	.6	.3	.3	.3	1.7	.4
Space Manager: slave idle wait	623	.2						.5	99.4
Streams AQ: RAC qmn coordinator idle wait	128	100.0
Streams AQ: qmn coordinator idle wait	125	48.0							52.0
Streams AQ: qmn slave idle wait	71								100.0
Streams AQ: waiting for time management or cleanup tasks	38	28.9						31.6	39.5
class slave wait	364	33.5	2.2	2.7	16.8	3.3	2.5	3.8	35.2
dispatcher timer	31								100.0
gcs remote message	753.6K	15.0	8.2	8.5	9.6	58.7	.0		.0
ges remote message	77.2K	33.4	5.7	8.4	8.0	11.0	9.8	23.8	.0
heartbeat monitor sleep	21		19.0	76.2	4.8
jobq slave wait	9218	.1	.0	.0	.0	.1	.1	99.6	.0
pmon timer	620	.5			.5	.2	.2	2.1	96.6
rdbms ipc message	215.7K	46.8	6.7	6.5	3.7	5.8	3.5	21.6	5.4
shared server idle wait	60								100.0
single-task message	15							100.0
smon timer	13	15.4							84.6
wait for unread message on broadcast channel	3632	.1				.7		99.1	.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ASM file metadata operation	2	99.7	.1		.1
DFS lock handle	1	100.0		.0
Disk file operations I/O	2	99.9	.0	.0
SQL*Net message from dblink	178	91.0	1.4	.8	.5	.3	5.6	.5	.1
SQL*Net more data from dblink	4	99.0		1.0
control file parallel write	4	99.6	.2	.2
control file sequential read	53	99.2	.5	.2	.0
cursor: pin S wait on X	1	98.3	1.7
db file parallel read	4	94.9	3.8	1.3
db file parallel write	101	99.7	.2	.1	.0
db file scattered read	13	99.1	.6	.1	.1
db file sequential read	273	99.3	.5	.2	.0	.0
direct path read	348	99.8	.1	.0	.0	.0
enq: TX - index contention	37	88.8	9.7	.9	.6
enq: TX - row lock contention	12	95.3	4.0	.8
gc buffer busy acquire	1	100.0	.0
gc buffer busy release	21	88.7	5.9	4.8	.5
gc cr block busy	7	99.8	.1	.1
gc current block busy	8	99.7	.3	.0
log file parallel write	412	99.4	.4	.2	.0
log file sequential read	11	95.7	3.5	.8
log file sync	741	98.9	.7	.4	.0
name-service call wait	8	11.1	44.4	44.4
os thread startup	57		91.2	8.8
rdbms ipc reply	1	100.0	.0
reliable message	11	95.3	.9	.4			3.4

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Event	Waits 4s to 2m	<2s	<4s	<8s	<32s	>=2m
		% of Total Waits
SQL*Net break/reset to client	1	97.8			.3	1.9
SQL*Net message from dblink	1	99.9	.1
Streams AQ: qmn coordinator waiting for slave to start	2			100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
bppfedb	3,858	2,899	43,218	205,290
SYS$USERS	34	30	0	696
SYS$BACKGROUND	0	0	1	150
bppfedbXDB	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
bppfedb	230626	617	5206	7	3548470	115
SYS$USERS	1445	2	565	1	782	0
SYS$BACKGROUND	1021	1	15623	4	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 39.3% of Total DB Time (s): 3,893
Captured PL/SQL account for 0.2% of Total DB Time (s): 3,893

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
555.70	30	18.52	14.27	53.07	47.18	6sn1ujjjymknw	python@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) COUNTING, TO_C...
119.17	6	19.86	3.06	52.60	47.67	csqmhq6dk66s6	python@BPPF_EAS1 (TNS V1-V3)	SELECT PDM.ACTION_NAME, COUNT(...
94.26	120	0.79	2.42	0.12	0.00	4m81j4p2kdz0w	Hibernate with C3P0	update T_INF_ORDERCTL set TMNN...
60.33	5	12.07	1.55	0.67	0.00	b98hm9c06hgvc	tmservice@BPPF_BIS1 (TNS V1-V3)	select info.*, TO_CHAR(info.EF...
46.41	11	4.22	1.19	99.87	0.00	cq4va5130p8sh	Hibernate with C3P0	select * from (select rownum a...
41.52	11	3.77	1.07	99.88	0.00	53u07hu2mu21y	Hibernate with C3P0	select count(1) from (with M a...
36.89	1	36.89	0.95	42.56	57.52	5ntntd4c0f8qh	Hibernate with C3P0	select t.actlist_id, t.action_...
34.65	693	0.05	0.89	96.66	0.01	5urzmwn0d4t64	AutoPayReward@BPPF_EAS1 (TNS V1-V3)	SELECT * FROM (SELECT T2.DISC_...
34.57	23	1.50	0.89	99.71	0.00	681zrwjq2914w		select DISTINCT BATCH_CODE fro...
32.08	9	3.56	0.82	6.50	94.28	6vw1gvbbz0p4v	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...

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 27.8% of Total CPU Time (s): 2,929
Captured PL/SQL account for 0.3% of Total CPU Time (s): 2,929

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
294.94	30	9.83	10.07	555.70	53.07	47.18	6sn1ujjjymknw	python@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) COUNTING, TO_C...
62.68	6	10.45	2.14	119.17	52.60	47.67	csqmhq6dk66s6	python@BPPF_EAS1 (TNS V1-V3)	SELECT PDM.ACTION_NAME, COUNT(...
46.35	11	4.21	1.58	46.41	99.87	0.00	cq4va5130p8sh	Hibernate with C3P0	select * from (select rownum a...
41.47	11	3.77	1.42	41.52	99.88	0.00	53u07hu2mu21y	Hibernate with C3P0	select count(1) from (with M a...
34.46	23	1.50	1.18	34.57	99.71	0.00	681zrwjq2914w		select DISTINCT BATCH_CODE fro...
33.49	693	0.05	1.14	34.65	96.66	0.01	5urzmwn0d4t64	AutoPayReward@BPPF_EAS1 (TNS V1-V3)	SELECT * FROM (SELECT T2.DISC_...
31.60	54	0.59	1.08	31.74	99.54	0.00	133uk3sy9sm19	Hibernate with C3P0	SELECT T.PRTN_ID, T.PRTN_NAME ...
15.70	1	15.70	0.54	36.89	42.56	57.52	5ntntd4c0f8qh	Hibernate with C3P0	select t.actlist_id, t.action_...
14.81	1	14.81	0.51	19.01	77.93	22.30	bf9gbpqjwy4u0	Hibernate with C3P0	select t.actlist_id, t.action_...
14.36	6	2.39	0.49	14.40	99.69	0.00	5htg4qmxfjh4u	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT * FROM (SELECT ROW_.*, ...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
262.16	30	8.74	42.23	555.70	53.07	47.18	6sn1ujjjymknw	python@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) COUNTING, TO_C...
56.81	6	9.47	9.15	119.17	52.60	47.67	csqmhq6dk66s6	python@BPPF_EAS1 (TNS V1-V3)	SELECT PDM.ACTION_NAME, COUNT(...
30.24	9	3.36	4.87	32.08	6.50	94.28	6vw1gvbbz0p4v	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
24.26	2	12.13	3.91	25.21	4.78	96.24	0masfyw5jmkas	tmservice@BPPF_EAS3 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
21.22	1	21.22	3.42	36.89	42.56	57.52	5ntntd4c0f8qh	Hibernate with C3P0	select t.actlist_id, t.action_...
20.20	4	5.05	3.25	21.03	4.78	96.05	a731jcvrzjdf2	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
17.94	10,463	0.00	2.89	26.43	18.66	67.91	1ddkpcc6s63jx	tmservice@BPPF_EAS2 (TNS V1-V3)	INSERT INTO T_SCS_ACT_ATTR (A...
13.46	2,632	0.01	2.17	24.16	20.56	55.70	23gz1n4vudn3n	tmservice@BPPF_EAS2 (TNS V1-V3)	INSERT INTO T_SCS_ORDER (ORDE...
12.66	1	12.66	2.04	17.26	27.16	73.35	0sstbk1rg9xxa	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT INVOICE_ID, CUST_ID, O...
12.58	2,632	0.00	2.03	17.78	15.50	70.78	52g7t0n7yzq6c	tmservice@BPPF_EAS2 (TNS V1-V3)	INSERT INTO T_SCS_PAYMENT (PA...
12.43	1	12.43	2.00	12.91	4.89	96.30	4vwxmbx4m76yh	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
10.78	1	10.78	1.74	15.10	29.07	71.37	5ub2zgw60mh4z	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT INVOICE_ID, CUST_ID, O...
7.57	3,708	0.00	1.22	15.96	26.60	47.46	2d4q4c5ubp9k8	tmservice@BPPF_EAS2 (TNS V1-V3)	Insert into T_EBK_DEALLOG (LOG...
6.78	3,496	0.00	1.09	8.98	12.80	75.49	4x6bpjkhyguk8	tmservice@BPPF_EAS2 (TNS V1-V3)	select VALUE1 , VALUE3 from T_...

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: 206,117,285
Captured SQL account for 43.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
32,262,364	30	1,075,412.13	15.65	555.70	53.1	47.2	6sn1ujjjymknw	python@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) COUNTING, TO_C...
10,345,089	11	940,462.64	5.02	46.41	99.9	0	cq4va5130p8sh	Hibernate with C3P0	select * from (select rownum a...
9,464,387	11	860,398.82	4.59	41.52	99.9	0	53u07hu2mu21y	Hibernate with C3P0	select count(1) from (with M a...
9,143,629	693	13,194.27	4.44	34.65	96.7	0	5urzmwn0d4t64	AutoPayReward@BPPF_EAS1 (TNS V1-V3)	SELECT * FROM (SELECT T2.DISC_...
6,453,377	6	1,075,562.83	3.13	119.17	52.6	47.7	csqmhq6dk66s6	python@BPPF_EAS1 (TNS V1-V3)	SELECT PDM.ACTION_NAME, COUNT(...
2,754,150	8	344,268.75	1.34	14.40	99.4	0	b16m9ng3yquz0	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
2,680,549	23	116,545.61	1.30	34.57	99.7	0	681zrwjq2914w		select DISTINCT BATCH_CODE fro...
2,267,847	6	377,974.50	1.10	14.40	99.7	0	5htg4qmxfjh4u	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT * FROM (SELECT ROW_.*, ...
1,343,484	6	223,914.00	0.65	7.89	99.7	0	fj0a5xg65pzcy	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
998,841	10	99,884.10	0.48	6.79	99.7	0	6t5vubr5sz91m	Hibernate with C3P0	select count(*) as y0_ from T_...

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: 43,219,087
Captured SQL account for 95.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
32,127,180	30	1,070,906.00	74.34	555.70	53.07	47.18	6sn1ujjjymknw	python@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) COUNTING, TO_C...
6,425,436	6	1,070,906.00	14.87	119.17	52.60	47.67	csqmhq6dk66s6	python@BPPF_EAS1 (TNS V1-V3)	SELECT PDM.ACTION_NAME, COUNT(...
824,480	1	824,480.00	1.91	36.89	42.56	57.52	5ntntd4c0f8qh	Hibernate with C3P0	select t.actlist_id, t.action_...
824,480	1	824,480.00	1.91	19.01	77.93	22.30	bf9gbpqjwy4u0	Hibernate with C3P0	select t.actlist_id, t.action_...
594,202	1	594,202.00	1.37	17.26	27.16	73.35	0sstbk1rg9xxa	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT INVOICE_ID, CUST_ID, O...
594,202	1	594,202.00	1.37	15.10	29.07	71.37	5ub2zgw60mh4z	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT INVOICE_ID, CUST_ID, O...
6,173	9	685.89	0.01	32.08	6.50	94.28	6vw1gvbbz0p4v	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
5,855	2	2,927.50	0.01	25.21	4.78	96.24	0masfyw5jmkas	tmservice@BPPF_EAS3 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
4,573	4	1,143.25	0.01	21.03	4.78	96.05	a731jcvrzjdf2	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
3,728	1	3,728.00	0.01	12.91	4.89	96.30	4vwxmbx4m76yh	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...

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: 384,038
Captured SQL account for 92.6% of Total
Total UnOptimized Read Requests: 384,038
Captured SQL account for 92.6% 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
254,970	254,970	30	8,499.00	66.39	6sn1ujjjymknw	python@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) COUNTING, TO_C...
50,994	50,994	6	8,499.00	13.28	csqmhq6dk66s6	python@BPPF_EAS1 (TNS V1-V3)	SELECT PDM.ACTION_NAME, COUNT(...
6,537	6,537	1	6,537.00	1.70	5ntntd4c0f8qh	Hibernate with C3P0	select t.actlist_id, t.action_...
6,537	6,537	1	6,537.00	1.70	bf9gbpqjwy4u0	Hibernate with C3P0	select t.actlist_id, t.action_...
5,302	5,302	9	589.11	1.38	6vw1gvbbz0p4v	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
5,072	5,072	2	2,536.00	1.32	0masfyw5jmkas	tmservice@BPPF_EAS3 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
4,734	4,734	1	4,734.00	1.23	0sstbk1rg9xxa	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT INVOICE_ID, CUST_ID, O...
4,734	4,734	1	4,734.00	1.23	5ub2zgw60mh4z	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT INVOICE_ID, CUST_ID, O...
3,938	3,938	4	984.50	1.03	a731jcvrzjdf2	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
3,247	3,247	1	3,247.00	0.85	4vwxmbx4m76yh	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 1,007,824
Captured SQL account for 30.5% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
39,454	39,454	1.00	8.41	87	0	02hsnb7xtghfp	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT sq_scs_stepinst.NEXTVAL...
22,645	72	0.00	11.45	98.9	0	84th238k1m4ha	oracle@bppfbdb1 (TNS V1-V3)	SELECT "PARENT_ID", "PRTN_ID",...
15,986	0	0.00	1.42	99.1	0	059md8mr237hf	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT ACTION_NAME FROM T_PDM...
15,985	0	0.00	1.42	96.5	0	79vnx2tsr8mhs	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT ACTION_CODE FROM T_PDM...
15,979	0	0.00	1.40	97.1	0	ab2cqsptaqytu	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT PROD_NAME FROM T_PDM_P...
15,979	0	0.00	1.44	96.9	0	dnan8kdpy6yck	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT PROD_CODE FROM T_PDM_P...
11,675	11,675	1.00	8.48	87.9	0	6jbqatwrgbamp	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT PRTN_CODE, PRTN_NAME FR...
10,975	10,975	1.00	1.21	98.8	0	7y5q05wqf50g5	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...
10,970	0	0.00	1.10	97.8	0	c6xvugn8bnxmt	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...
10,969	0	0.00	1.14	100	0	9r30k0h2f4sd6	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...
10,463	10,463	1.00	26.43	18.7	67.9	1ddkpcc6s63jx	tmservice@BPPF_EAS2 (TNS V1-V3)	INSERT INTO T_SCS_ACT_ATTR (A...
10,212	0	0.00	1.03	95.2	0	1k2q65ps3427z	tmservice@BPPF_BIS1 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,001,750
Captured SQL account for 23.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
10,866	11,675	1.08	6jbqatwrgbamp	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT PRTN_CODE, PRTN_NAME FR...
8,894	7,365	0.89	d9xfggh4tc5ab	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT DISTINCT I.OBJ_ID, I.PR...
8,330	8,032	0.83	3m8quzddcths6	tmservice@BPPF_BIS1 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...
7,931	10,212	0.79	1k2q65ps3427z	tmservice@BPPF_BIS1 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...
7,916	10,970	0.79	c6xvugn8bnxmt	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...
7,897	10,975	0.79	7y5q05wqf50g5	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...
7,590	8,271	0.76	cb1ddfqamyx8c	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT PWD_ERRTIMES, PWD_ERRTI...
7,453	10,969	0.74	9r30k0h2f4sd6	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...
7,445	8,287	0.74	7vd74jxxamcpk	tmservice@BPPF_BIS2 (TNS V1-V3)	SELECT SQ_SYM_SCRAND.NEXTVAL A...
7,345	8,784	0.73	aj7w13s2jmuhs	tmservice@BPPF_BIS1 (TNS V1-V3)	SELECT DICT_ID, DICT_TYPEID, D...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
150,111,336	11,675	1.51	6jbqatwrgbamp	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT PRTN_CODE, PRTN_NAME FR...
37,582,537	672	0.38	8bsppxkpc1dm1	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT * FROM T_CUM_CUSTOM WHE...
28,143,874	3,496	0.28	4x6bpjkhyguk8	tmservice@BPPF_EAS2 (TNS V1-V3)	select VALUE1 , VALUE3 from T_...
15,996,952	635	0.16	30uvjcd56583v	tmservice@BPPF_EAS1 (TNS V1-V3)	select tcc.th, ted.end_bal fro...
15,932,352	635	0.16	4kgprupqky1dz	CleaningStateSync@BPPF_EAS1 (TNS V1-V3)	select tcc.th, ted.end_bal fro...
9,934,100	357	0.10	447ku4suqwzcw	tmservice@BPPF_EAS4 (TNS V1-V3)	SELECT * FROM (SELECT PRTN_ID,...
5,504,393	357	0.06	5htj25pp01mbd	tmservice@BPPF_EAS4 (TNS V1-V3)	SELECT CUST_ID, CUST_CODE, CUS...
4,827,915	300	0.05	68368kpu6b3yc	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT CUST_ID, CUST_CODE, CUS...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
88	635	30uvjcd56583v	tmservice@BPPF_EAS1 (TNS V1-V3)	select tcc.th, ted.end_bal fro...
85	635	4kgprupqky1dz	CleaningStateSync@BPPF_EAS1 (TNS V1-V3)	select tcc.th, ted.end_bal fro...
78	11,675	6jbqatwrgbamp	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT PRTN_CODE, PRTN_NAME FR...
75	357	5htj25pp01mbd	tmservice@BPPF_EAS4 (TNS V1-V3)	SELECT CUST_ID, CUST_CODE, CUS...
74	357	447ku4suqwzcw	tmservice@BPPF_EAS4 (TNS V1-V3)	SELECT * FROM (SELECT PRTN_ID,...
55	3	8ta1c19zayct0	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT TH FROM T_CUM_CUSTOM WH...
50	3,496	4x6bpjkhyguk8	tmservice@BPPF_EAS2 (TNS V1-V3)	select VALUE1 , VALUE3 from T_...
36	13	fr18sbu3zk4sr	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT COUNT(*) AS CON FROM T_...
34	13	363am73y9dwpj	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT GRP_ID, ACTION_ID, MEMO...
25	672	8bsppxkpc1dm1	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT * FROM T_CUM_CUSTOM WHE...

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

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
6.06	2,632	7.64	24.16	25.06	20.56	55.70	23gz1n4vudn3n	tmservice@BPPF_EAS2 (TNS V1-V3)	INSERT INTO T_SCS_ORDER (ORDE...
4.48	3,708	5.66	15.96	28.09	26.60	47.46	2d4q4c5ubp9k8	tmservice@BPPF_EAS2 (TNS V1-V3)	Insert into T_EBK_DEALLOG (LOG...
3.51	10,463	4.43	26.43	13.27	18.66	67.91	1ddkpcc6s63jx	tmservice@BPPF_EAS2 (TNS V1-V3)	INSERT INTO T_SCS_ACT_ATTR (A...
3.46	3,172	4.37	12.16	28.47	21.96	45.92	7gh2xdvx3r5s0	tmservice@BPPF_EAS2 (TNS V1-V3)	INSERT INTO T_SCS_OPERLOG (LO...
2.39	2,632	3.02	17.78	13.47	15.50	70.78	52g7t0n7yzq6c	tmservice@BPPF_EAS2 (TNS V1-V3)	INSERT INTO T_SCS_PAYMENT (PA...
1.02	3,496	1.28	8.98	11.31	12.80	75.49	4x6bpjkhyguk8	tmservice@BPPF_EAS2 (TNS V1-V3)	select VALUE1 , VALUE3 from T_...
0.94	693	1.18	34.65	2.71	96.66	0.01	5urzmwn0d4t64	AutoPayReward@BPPF_EAS1 (TNS V1-V3)	SELECT * FROM (SELECT T2.DISC_...
0.36	2	0.46	13.76	2.65	68.59	28.69	8ucs3qd2rdp7b	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT * FROM (SELECT ROW_.*, ...
0.10	1	0.13	6.10	1.64	64.44	34.24	5jvf84zg4c49n	plsqldev.exe	select s.synonym_name as obje...
0.07	15	0.09	0.48	15.40	87.99	0.00	g799f803fk442	Fixstat@BPPF_EAS1 (TNS V1-V3)	SELECT ORD.ORDER_ID, ORD.ORDER...
0.07	23	0.08	34.57	0.19	99.71	0.00	681zrwjq2914w		select DISTINCT BATCH_CODE fro...
0.06	5	0.07	1.56	3.62	95.48	1.16	6tgt63zv6fjqf		DECLARE job BINARY_INTEGER := ...
0.05	8	0.06	14.40	0.35	99.43	0.00	b16m9ng3yquz0	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
0.04	3	0.06	0.97	4.57	95.97	0.07	97yqr984x14q7		SELECT ORD.SRC_ORDER_ID ORDER_...
0.03	6	0.04	119.17	0.02	52.60	47.67	csqmhq6dk66s6	python@BPPF_EAS1 (TNS V1-V3)	SELECT PDM.ACTION_NAME, COUNT(...
0.03	6	0.03	14.40	0.18	99.69	0.00	5htg4qmxfjh4u	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT * FROM (SELECT ROW_.*, ...
0.02	39,454	0.03	8.41	0.30	86.96	0.00	02hsnb7xtghfp	tmservice@BPPF_EAS2 (TNS V1-V3)	SELECT sq_scs_stepinst.NEXTVAL...
0.01	4	0.02	0.15	9.27	92.91	0.03	1kjv68qx3pnkm		DECLARE job BINARY_INTEGER := ...
0.01	11	0.02	46.41	0.03	99.87	0.00	cq4va5130p8sh	Hibernate with C3P0	select * from (select rownum a...
0.01	3	0.02	0.99	1.37	98.72	0.01	7rvm5cg2ph2vg		DECLARE job BINARY_INTEGER := ...
0.01	164	0.02	0.11	12.27	50.85	35.33	3ktacv9r56b51		select owner#, name, namespace...
0.01	1	0.01	12.91	0.08	4.89	96.30	4vwxmbx4m76yh	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
0.01	18	0.01	10.58	0.09	99.47	0.00	aa06zmyaruqwr	Hibernate with C3P0	select count(1) from (select b...
0.01	164	0.01	0.05	21.14	74.01	16.80	8swypbbr0m372		select order#, columns, types ...
0.01	2	0.01	25.21	0.04	4.78	96.24	0masfyw5jmkas	tmservice@BPPF_EAS3 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...
0.01	5	0.01	4.96	0.19	99.45	0.00	arxvujrybgtvj	Hibernate with C3P0	select count(*) as y0_ from T_...
0.01	11	0.01	41.52	0.02	99.88	0.00	53u07hu2mu21y	Hibernate with C3P0	select count(1) from (with M a...
0.01	15	0.01	8.86	0.08	99.11	0.00	cy6dgzmu84g2r	Hibernate with C3P0	select * from (select rownum a...
0.01	17	0.01	10.56	0.06	99.61	0.00	110455u7sfpgn	Hibernate with C3P0	select count(1) from (select b...
0.01	6	0.01	7.89	0.07	99.74	0.00	fj0a5xg65pzcy	tmservice@BPPF_EAS1 (TNS V1-V3)	SELECT COUNT(1) AS COUNT_RECOR...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

02hsnb7xtghfp SELECT sq_scs_stepinst.NEXTVAL as seq FROM DUAL

059md8mr237hf SELECT ACTION_NAME FROM T_PDM_ACTION WHERE STAT = 'S0A' AND ACTION_ID = 0

0masfyw5jmkas SELECT COUNT(1) AS COUNT_RECORD FROM T_EBK_DEALLOG where 1 = 1 AND CAAC_CODE <> '100600000000000001' AND CAAC_CODE = '110440201000009705' AND RECORD_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND RECORD_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND LOAN_FLAG = '+'

0sstbk1rg9xxa SELECT INVOICE_ID, CUST_ID, ORDER_ID, ACTLIST_ID, OBJ_CODE, TERM_ID, IS_ENCRY, INVOICE_INFO, PRINT_COUNT, TO_CHAR(CREATE_DATE, 'YYYYMMDDHH24MISS') as CREATE_DATE, TO_CHAR(PRINT_DATE, 'YYYYMMDDHH24MISS') as PRINT_DATE, PRINT_STAT , ACT_PAY_MONEY, PAY_TYPE, PAY_ORG, ACCT_CODE, EVENT_SEQ FROM T_SCS_INVOICE where TERM_ID = '441221003709' and obj_code = '07586293242' and print_count = 0 order by CREATE_DATE desc

110455u7sfpgn select count(1) from (select b.*, (select to_char(wmsys.wm_concat(ti.term_code)) from (select t.*, cc.cust_id from t_tmn_info t, t_cum_channel cc where cc.term_id = t.term_id and cc.stat='S0A' and t.stat='S0A') ti where ti.cust_id = b.cust_id group by ti.cust_id) term_code from (SELECT DISTINCT M.*, O.LASTAPPR_STAT, O.APPLY_STAFF, O.APPR_STAFF, O.LAST_APPR_STAFF FROM (SELECT I.CUST_ID, P.* FROM T_PNM_PARTNER P, T_CUM_INFO I WHERE P.PRTN_ID = I.PRTN_ID) M LEFT JOIN T_CUM_OBJ_APPROVE O ON O.OBJ_ID = M.CUST_ID WHERE 1=1 AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND O.APPR_TYPE='1011' and m.prtn_id !=12040 and m.prtn_name like '%??%' AND M.PRTN_TYPE in('PT101', 'PT201', 'PT403') and exists (select * from t_cum_attr a where a.attr_id = 4224 and a.cust_id = m.cust_id and a.value1 like '%, 100, %') ORDER BY M.CUST_ID DESC ) b order by b.PRTN_CODE) TmpTable

133uk3sy9sm19 SELECT T.PRTN_ID, T.PRTN_NAME FROM T_PNM_PARTNER T WHERE T.PRTN_TYPE ='PT403' START WITH T.PRTN_ID=12040 CONNECT BY PRIOR T.PRTN_ID=T.PARENT_ID

1ddkpcc6s63jx INSERT INTO T_SCS_ACT_ATTR (ACTLIST_ID, ACTION_ID, ATTR_ID, VALUE1, VALUE2, VALUE3, VALUE4, STAT) VALUES (:ACTLIST_ID, :ACTION_ID, :ATTR_ID, :VALUE1, :VALUE2, :VALUE3, :VALUE4, :STAT)

1k2q65ps3427z SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'SYM_CERTTYPE' AND dict_id = 'C02'

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

23gz1n4vudn3n INSERT INTO T_SCS_ORDER (ORDER_ID, ORDER_CODE, CUST_ID, ORDER_TYPE, AREA_CODE, TERM_ID, ACCT_DATE, BEGIN_DATE, END_DATE, EFF_DATE, LOGIN_TYPE, STAT, PAY_STAT, ACT_STAT, MEMO, TERM_SEQ, OPER_ORIG, OPER_STAT, CHANNEL_TYPE, EXT_ORDER_ID, SRC_ORDER_ID, OLD_STAT, OLD_PAYSTAT, OLD_ACTSTAT, EXT_VALUE1, EXT_VALUE2, EXT_VALUE3, EXT_VALUE4, TRADE_ORG) VALUES (:ORDER_ID, :ORDER_CODE, :CUST_ID, :ORDER_TYPE, :AREA_CODE, :TERM_ID, sysdate, TO_DATE(:BEGIN_DATE, 'YYYYMMDDHH24MISS'), TO_DATE(:END_DATE, 'YYYYMMDDHH24MISS'), TO_DATE(:EFF_DATE, 'YYYYMMDDHH24MISS'), :LOGIN_TYPE, :STAT, :PAY_STAT, :ACT_STAT, :MEMO, :TERM_SEQ, :OPER_ORIG, :OPER_STAT, :CHANNEL_TYPE, :EXT_ORDER_ID, :SRC_ORDER_ID, :OLD_STAT, :OLD_PAYSTAT, :OLD_ACTSTAT, :EXT_VALUE1, :EXT_VALUE2, :EXT_VALUE3, :EXT_VALUE4, :TRADE_ORG)

2d4q4c5ubp9k8 Insert into T_EBK_DEALLOG (LOG_SEQ, EVENT_SEQ, CAAC_CODE, ACCT_CODE, DEAL_CODE, DEAL_TYPE, LOAN_FLAG, DEAL_AMOUNT, END_BAL, CHANNEL_TYPE, DEAL_SRC, DEAL_STAFF, DEAL_ORG, DEAL_MEDTYPE, DEAL_MEDSN, DEAL_DATE, DEAL_TIME, RECORD_DATE, RESULT_CODE, RESULT_INFO, MEMO, SRC_LOG_SEQ, CUTOFF_DATE, TERM_SEQ, SRC_EVENT_SEQ, ORDER_CODE) Values (:LOG_SEQ, :EVENT_SEQ, :CAAC_CODE, :ACCT_CODE, :DEAL_CODE, :DEAL_TYPE, :LOAN_FLAG, :DEAL_AMOUNT, :END_BAL, :CHANNEL_TYPE, :DEAL_SRC, :DEAL_STAFF, :DEAL_ORG, :DEAL_MEDTYPE, :DEAL_MEDSN, :DEAL_DATE, :DEAL_TIME, sysdate, :RESULT_CODE, :RESULT_INFO, :MEMO, :SRC_LOG_SEQ, :CUTOFF_DATE, :TERM_SEQ, :SRC_EVENT_SEQ, :ORDER_CODE)

30uvjcd56583v select tcc.th, ted.end_bal from t_cum_custom tcc, t_cum_acct tca, t_ebk_deallog ted where tca.cust_id = tcc.cust_id and tca.cust_id = :cust_id and tcc.th_type = 'TH001' and ted.src_event_seq = :src_event_seq and ted.caac_code = tca.acct_code

363am73y9dwpj SELECT GRP_ID, ACTION_ID, MEMO, STAT FROM T_PDM_ACTGRP_RELA WHERE GRP_ID = :GRP_ID

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#

3m8quzddcths6 SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'SYM_CERTTYPE' AND dict_id = '99'

447ku4suqwzcw SELECT * FROM (SELECT PRTN_ID, PRTN_TYPE FROM T_PNM_PARTNER START WITH PRTN_ID = :PRTN_ID CONNECT BY PRIOR PARENT_ID = PRTN_ID) WHERE PRTN_TYPE = 'PT403'

4kgprupqky1dz select tcc.th, ted.end_bal from t_cum_custom tcc, t_cum_acct tca, t_ebk_deallog ted where tca.cust_id = tcc.cust_id and tca.cust_id = :cust_id and tcc.th_type = 'TH001' and ted.event_seq = :event_seq and ted.caac_code = tca.acct_code

4m81j4p2kdz0w update T_INF_ORDERCTL set TMNNUM=:1, ORDER_CODE=:2, OPER_INFO=:3, OPER_DATE=:4, ORDER_STAT=:5, STAT=:6, REMARK=:7 where KEEP=:8

4vwxmbx4m76yh SELECT COUNT(1) AS COUNT_RECORD FROM T_EBK_DEALLOG where 1 = 1 AND CAAC_CODE <> '100600000000000001' AND CAAC_CODE = '110442001000066235' AND RECORD_DATE >= TO_DATE('20140201000000', 'YYYYMMDDHH24MISS') AND RECORD_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND LOAN_FLAG = '+'

4x6bpjkhyguk8 select VALUE1 , VALUE3 from T_SCS_ORDATTR where STAT='S0A' AND ATTR_ID = :ATTR_ID AND ORDER_ID = :ORDER_ID

52g7t0n7yzq6c INSERT INTO T_SCS_PAYMENT (PAYMENT_ID, ORDER_ID, PAY_TYPE, PAY_ORG, ACCTTYPE_CODE, ACCT_NAME, ACCT_CODE, ACCT_PWD, PAY_SEQ, CURRENCY_CODE, PAY_MONEY, MEDIA_TYPE, MEDIA_ID, TRACK_NO2, TRACK_NO3, NET_CODE, CREATE_DATE, BEGIN_DATE, END_DATE, STAT, RET_ID, RET_DATE, RET_CODE, RET_MSG, EVENT_SEQ, SEND_ID, CARD_TYPE, SRC_EVENTSEQ, INF_PAY_ORG, TERM_SEQ, EXT_ORDER_ID) VALUES (:PAYMENT_ID, :ORDER_ID, :PAY_TYPE, :PAY_ORG, :ACCTTYPE_CODE, :ACCT_NAME, :ACCT_CODE, :ACCT_PWD, :PAY_SEQ, :CURRENCY_CODE, :PAY_MONEY, :MEDIA_TYPE, :MEDIA_ID, :TRACK_NO2, :TRACK_NO3, :NET_CODE, sysdate, TO_DATE(:BEGIN_DATE, 'YYYYMMDDHH24MISS'), TO_DATE(:END_DATE, 'YYYYMMDDHH24MISS'), :STAT, :RET_ID, TO_DATE(:RET_DATE, 'YYYYMMDDHH24MISS'), :RET_CODE, :RET_MSG, :EVENT_SEQ, :SEND_ID, :CARD_TYPE, :SRC_EVENTSEQ, :INF_PAY_ORG, :TERM_SEQ, :EXT_ORDER_ID)

53u07hu2mu21y select count(1) from (with M as (SELECT r.cust_id, r.acct_code, r.bingcard_bank, r.bingcard_flag, r.stat FROM (SELECT tt.*, row_number() over(PARTITION BY tt.cust_id ORDER BY tt.stat) AS rn FROM (SELECT ca.cust_id, ca.acct_code, (SELECT b.bank_name FROM t_sym_bank b WHERE b.bank_id = ca.bank_id) bingcard_bank, 'S0C' AS bingcard_flag, ca.stat FROM t_cum_acct ca WHERE ca.acct_type = 'ACCT001' UNION SELECT (SELECT a.cust_id FROM t_cum_info a WHERE a.cust_code = r.cust_code) cust_id, r.bank_acct AS acct_code, (SELECT MIN(b.bank_name) FROM t_sym_bank b WHERE b.bank_code = r.bank_code) bingcard_bank, r.bind_state AS bingcard_flag, r.stat FROM t_cum_regbindcard r WHERE r.stat = 'S0A' UNION SELECT t2.cust_id, t2.acct_code, t2.bingcard_bank, t2.bingcard_flag, t2.stat FROM (SELECT t1.*, row_number() over(PARTITION BY t1.cust_id ORDER BY t1.bind_date DESC) AS rn FROM (SELECT (SELECT a.cust_id FROM t_cum_info a WHERE a.cust_code = cr.cust_code) cust_id, cr.bank_acct AS acct_code, (SELECT MIN(b.bank_name) FROM t_sym_bank b WHERE b.bank_code = cr.bank_code) bingcard_bank, cr.bind_state AS bingcard_flag, cr.bind_date, cr.stat FROM t_cum_regbindcard cr WHERE cr.stat = 'S0X' ) t1) t2 WHERE t2.rn = 1 ) tt) r WHERE 1 = 1 AND r.rn = 1) SELECT T.*, M.ACCT_CODE, M.BINGCARD_BANK, M.BINGCARD_FLAG FROM (SELECT M.*, R.PRTN_NAME, R.PRTN_TYPE, (SELECT P.PRTN_NAME FROM T_PNM_PARTNER P WHERE P.PRTN_ID = R.PARENT_ID) PARENT_NAME FROM (SELECT /*+driving_site(T)*/T.CUST_ID, T.PRTN_ID, T.CUST_CODE, T.CUST_NAME, T.CUST_TYPE, T.EFF_DATE, T.STAT, T.OPER_FLAG, T.AREA_CODE, A.APPLY_STAFF, A.APPR_STAFF, A.LASTAPPR_STAT FROM T_CUM_INFO T LEFT JOIN T_CUM_OBJ_APPROVE A ON T.CUST_ID = A.OBJ_ID AND A.APPR_TYPE = '1002' WHERE T.CUST_TYPE = 'C02') M, T_PNM_PARTNER R, T_CUM_ACCT CA WHERE M.PRTN_ID = R.PRTN_ID AND CA.ACCT_TYPE = 'ACCT002' AND M.CUST_ID = CA.CUST_ID AND R.PRTN_TYPE IN ('PT301', 'PT401', 'PT901', 'PT404') AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND EXISTS (SELECT 1 FROM T_CUM_ATTR A WHERE A.ATTR_ID =(SELECT A.ATTR_ID FROM T_SYM_ATTR A WHERE A.ATTR_CODE = 'CUM_PDLINEID' AND A.ATTR_TYPE = 'CUST' AND A.STAT='S0A') AND A.CUST_ID = M.CUST_ID AND A.VALUE1 LIKE '%, 100, %') ORDER BY M.CUST_ID DESC) T LEFT JOIN M M ON M.CUST_ID = T.CUST_ID) TmpTable

5htg4qmxfjh4u SELECT * FROM (SELECT ROW_.*, ROWNUM ROWNUM_ FROM(SELECT o.ORDER_ID, o.EXT_VALUE1, o.EXT_VALUE2, o.EXT_VALUE3, o.EXT_VALUE4, (SELECT CUST_CODE FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_CODE, (SELECT CUST_NAME FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_NAME, (SELECT CUST_TYPE FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_TYPE, (SELECT TF1.DUE_MOENY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS DUE_MOENY, (SELECT TF1.PAY_MONEY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS PAY_MONEY, (SELECT TF1.PREMIUM_MONEY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS PREMIUM_MONEY, o.STAT STAT, o.PAY_STAT, o.ACT_STAT, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_ORDERSTAT' AND DICT_ID = o.STAT) AS STATEN, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_PAYSTAT' AND DICT_ID = o.PAY_STAT) AS PAY_STATEN, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_ACTSTAT' AND DICT_ID = o.ACT_STAT) AS ACT_STATEN, TO_CHAR(o.ACCT_DATE, 'YYYYMMDDHH24MISS') AS ACCT_DATE, TO_CHAR(o.END_DATE, 'YYYYMMDDHH24MISS') AS END_DATE, o.RET_MSG, (SELECT F2.AREA_NAME FROM T_SYM_AREA F2 WHERE F2.AREA_CODE = o.AREA_CODE) AREA_NAME, o.TERM_ID, o.TERM_SEQ, o.ORDER_TYPE, o.EXT_ORDER_ID, o.MEMO, TO_CHAR(o.OPER_TIME, 'YYYYMMDDHH24MISS') AS OPER_TIME, o.HDL_WAY, (SELECT t.DICT_NAME FROM T_SYM_DICT t WHERE t.DICT_TYPEID = 'SCS_HDLWAY' AND t.DICT_ID = o.HDL_WAY) AS HDL_WAYCN, (SELECT T.DICT_NAME FROM T_SYM_DICT T WHERE T.DICT_TYPEID = 'SCS_ORDERTYPE' AND T.DICT_ID = o.ORDER_TYPE) ORDER_TYPENAME, 'OAS01' AS ORDER_ARC_STAT FROM T_SCS_ORDER o WHERE 1=1 AND o.ACCT_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND o.ACCT_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND o.CUST_ID IN (SELECT c.CUST_ID FROM T_CUM_INFO c WHERE 1=1 AND c.STAT = 'S0A' AND c.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER START WITH PRTN_ID = 12040 CONNECT BY PRIOR PRTN_ID = PARENT_ID)) ORDER BY ACCT_DATE DESC) ROW_ WHERE ROWNUM <= 10) WHERE ROWNUM_ >= 1

5htj25pp01mbd SELECT CUST_ID, CUST_CODE, CUST_TYPE, CUST_NAME, PRTN_ID, STAT FROM T_CUM_INFO WHERE CUST_TYPE = 'C02' AND PRTN_ID = :PRTN_ID

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

5ntntd4c0f8qh select t.actlist_id, t.action_id, t.end_date, t.event_seq from t_scs_actlist t where order_id =140305069024035

5ub2zgw60mh4z SELECT INVOICE_ID, CUST_ID, ORDER_ID, ACTLIST_ID, OBJ_CODE, TERM_ID, IS_ENCRY, INVOICE_INFO, PRINT_COUNT, TO_CHAR(CREATE_DATE, 'YYYYMMDDHH24MISS') as CREATE_DATE, TO_CHAR(PRINT_DATE, 'YYYYMMDDHH24MISS') as PRINT_DATE, PRINT_STAT , ACT_PAY_MONEY, PAY_TYPE, PAY_ORG, ACCT_CODE, EVENT_SEQ FROM T_SCS_INVOICE where TERM_ID = '441221003709' and obj_code = '075856293242' and print_count = 0 order by CREATE_DATE desc

5urzmwn0d4t64 SELECT * FROM (SELECT T2.DISC_INFO_ID, T2.ORDER_ID, T1.CUST_ID, T1.TERM_SEQ, T2.DISC_ID, T2.DISC_VALUE, T2.DEAL_RET FROM T_SCS_ORDER T1, T_SCS_DISC_INFO T2 WHERE T1.ORDER_ID = T2.ORDER_ID AND T1.STAT = 'S0C' AND T1.PAY_STAT = 'S0S' AND T1.ACT_STAT = 'S0S' AND T2.DEAL_RET = 'S0A' ORDER BY T2.CREATE_DATE ASC) WHERE ROWNUM <= 100

681zrwjq2914w select DISTINCT BATCH_CODE from t_opp_preorder where STAT='S0C' and ACCT_DATE <= (SYSDATE - 1/1440*5) ORDER BY BATCH_CODE

68368kpu6b3yc SELECT CUST_ID, CUST_CODE, CUST_TYPE, CUST_NAME, PRTN_ID, STAT FROM T_CUM_INFO WHERE CUST_ID = :CUST_ID

6jbqatwrgbamp SELECT PRTN_CODE, PRTN_NAME FROM T_PNM_PARTNER WHERE PRTN_TYPE = 'PT403' AND PRTN_ID IN (SELECT PRTN_ID FROM T_PNM_PARTNER PNM CONNECT BY PNM.PRTN_ID = PRIOR PNM.PARENT_ID START WITH PRTN_ID = :PRTN_ID)

6sn1ujjjymknw SELECT COUNT(1) COUNTING, TO_CHAR(SYSDATE, 'HH24MISS') EXP_TIME FROM BPPF_EAS.T_SCS_ORDER T WHERE T.BEGIN_DATE BETWEEN SYSDATE - INTERVAL '1' MINUTE AND SYSDATE

6t5vubr5sz91m select count(*) as y0_ from T_SYM_OPERLOG this_ where this_.OBJ_TYPE in (:1) order by this_.OPER_DATE desc

6tgt63zv6fjqf DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN P_SCS_REFUND_MESSAGE(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6vw1gvbbz0p4v SELECT COUNT(1) AS COUNT_RECORD FROM T_EBK_DEALLOG where 1 = 1 AND CAAC_CODE <> '100600000000000001' AND CAAC_CODE = '110442001000011329' AND RECORD_DATE >= TO_DATE('20140304000000', 'YYYYMMDDHH24MISS') AND RECORD_DATE <= TO_DATE('20140304235959', 'YYYYMMDDHH24MISS') AND LOAN_FLAG = '+'

79vnx2tsr8mhs SELECT ACTION_CODE FROM T_PDM_ACTION WHERE STAT = 'S0A' AND ACTION_ID = 0

7gh2xdvx3r5s0 INSERT INTO T_SCS_OPERLOG (LOG_SEQ, ORDER_ID, OPER_TYPE, OPER_INFO, CHANNEL_TYPE, OPER_SRC, OPER_STAFF, OPER_ORG, RECORD_DATE, RESULT_CODE, RESULT_INFO, MEMO) VALUES (:LOG_SEQ, :ORDER_ID, :OPER_TYPE, :OPER_INFO, :CHANNEL_TYPE, :OPER_SRC, :OPER_STAFF, :OPER_ORG, sysdate, :RESULT_CODE, :RESULT_INFO, :MEMO)

7rvm5cg2ph2vg DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN P_SCS_WRONG_ORDER_COLLECT(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

7vd74jxxamcpk SELECT SQ_SYM_SCRAND.NEXTVAL AS ID FROM DUAL

7y5q05wqf50g5 SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'CUM_PERIODTYPE' AND dict_id = 'PR000'

84th238k1m4ha SELECT "PARENT_ID", "PRTN_ID", PRIOR "PRTN_ID" FROM "BPPF_BIS"."T_PNM_PARTNER" "A6" WHERE "PRTN_ID"=:1 START WITH ("PRTN_ID"=:2) CONNECT BY ("PARENT_ID"=PRIOR "PRTN_ID")

8bsppxkpc1dm1 SELECT * FROM T_CUM_CUSTOM WHERE CUSTOM_TYPE IN('T08', 'T09', 'T11', 'T12') AND STAT = 'S0A' AND CUST_ID = :CUST_ID

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

8ta1c19zayct0 SELECT TH FROM T_CUM_CUSTOM WHERE SYSDATE > EFF_DATE AND STAT = 'S0A' AND CUSTOM_TYPE = 'T13' AND CUST_ID = :CUST_ID

8ucs3qd2rdp7b SELECT * FROM (SELECT ROW_.*, ROWNUM ROWNUM_ FROM(SELECT o.ORDER_ID, o.EXT_VALUE1, o.EXT_VALUE2, o.EXT_VALUE3, o.EXT_VALUE4, (SELECT CUST_CODE FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_CODE, (SELECT CUST_NAME FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_NAME, (SELECT CUST_TYPE FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_TYPE, (SELECT TF1.DUE_MOENY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS DUE_MOENY, (SELECT TF1.PAY_MONEY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS PAY_MONEY, (SELECT TF1.PREMIUM_MONEY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS PREMIUM_MONEY, o.STAT STAT, o.PAY_STAT, o.ACT_STAT, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_ORDERSTAT' AND DICT_ID = o.STAT) AS STATEN, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_PAYSTAT' AND DICT_ID = o.PAY_STAT) AS PAY_STATEN, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_ACTSTAT' AND DICT_ID = o.ACT_STAT) AS ACT_STATEN, TO_CHAR(o.ACCT_DATE, 'YYYYMMDDHH24MISS') AS ACCT_DATE, TO_CHAR(o.END_DATE, 'YYYYMMDDHH24MISS') AS END_DATE, o.RET_MSG, (SELECT F2.AREA_NAME FROM T_SYM_AREA F2 WHERE F2.AREA_CODE = o.AREA_CODE) AREA_NAME, o.TERM_ID, o.TERM_SEQ, o.ORDER_TYPE, o.EXT_ORDER_ID, o.MEMO, TO_CHAR(o.OPER_TIME, 'YYYYMMDDHH24MISS') AS OPER_TIME, o.HDL_WAY, (SELECT t.DICT_NAME FROM T_SYM_DICT t WHERE t.DICT_TYPEID = 'SCS_HDLWAY' AND t.DICT_ID = o.HDL_WAY) AS HDL_WAYCN, (SELECT T.DICT_NAME FROM T_SYM_DICT T WHERE T.DICT_TYPEID = 'SCS_ORDERTYPE' AND T.DICT_ID = o.ORDER_TYPE) ORDER_TYPENAME, 'OAS01' AS ORDER_ARC_STAT FROM T_SCS_ORDER o WHERE 1=1 AND o.ACCT_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND o.ACCT_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND o.CUST_ID IN (SELECT c.CUST_ID FROM T_CUM_INFO c WHERE 1=1 AND c.STAT = 'S0A' AND c.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER START WITH PRTN_ID = 94139 CONNECT BY PRIOR PRTN_ID = PARENT_ID)) ORDER BY ACCT_DATE DESC) ROW_ WHERE ROWNUM <= 10) WHERE ROWNUM_ >= 1

97yqr984x14q7 SELECT ORD.SRC_ORDER_ID ORDER_ID, STAFF.MOBILE PHONE, FEE.DUE_MOENY MONEY, TO_CHAR(ORD.BEGIN_DATE, 'MM"?"DD"?"') PAY_DATE FROM BPPF_BIS.T_SYM_STAFF STAFF, BPPF_EAS.T_SCS_ORDER ORD, BPPF_EAS.T_SCS_PAYMENT PAY, BPPF_EAS.T_SCS_ACTLIST ACT, BPPF_EAS.T_SCS_ACTFEE FEE WHERE (ORD.ORDER_TYPE = 'OT101' OR ORD.ORDER_TYPE = 'OT201') AND ORD.ORDER_ID = PAY.ORDER_ID AND ORD.ORDER_ID = ACT.ORDER_ID AND ORD.ORDER_ID = FEE.ORDER_ID AND ACT.ACTLIST_ID = FEE.ACTLIST_ID AND ORD.PAY_STAT = 'S0S' AND PAY.STAT = 'S0S' AND ORD.END_DATE BETWEEN SYSDATE - INTERVAL '5' MINUTE AND SYSDATE AND STAFF.ORG_ID IN (SELECT PRIV.ORG_ID FROM BPPF_BIS.T_CUM_PRIV PRIV, BPPF_BIS.T_CUM_INFO CUM WHERE PRIV.PRTN_ID = CUM.PRTN_ID AND CUM.CUST_ID = ORD.CUST_ID) AND STAFF.EXT_FLAG = 'DEF'

9r30k0h2f4sd6 SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'CUM_CUSTOMTYPE' AND dict_id = 'T13'

a731jcvrzjdf2 SELECT COUNT(1) AS COUNT_RECORD FROM T_EBK_DEALLOG where 1 = 1 AND CAAC_CODE <> '100600000000000001' AND CAAC_CODE = '110440601000029601' AND RECORD_DATE >= TO_DATE('20140228000000', 'YYYYMMDDHH24MISS') AND RECORD_DATE <= TO_DATE('20140228235959', 'YYYYMMDDHH24MISS') AND LOAN_FLAG = '+'

aa06zmyaruqwr select count(1) from (select b.*, (select to_char(wmsys.wm_concat(ti.term_code)) from (select t.*, cc.cust_id from t_tmn_info t, t_cum_channel cc where cc.term_id = t.term_id and cc.stat='S0A' and t.stat='S0A') ti where ti.cust_id = b.cust_id group by ti.cust_id) term_code from (SELECT DISTINCT M.*, O.LASTAPPR_STAT, O.APPLY_STAFF, O.APPR_STAFF, O.LAST_APPR_STAFF FROM (SELECT I.CUST_ID, P.* FROM T_PNM_PARTNER P, T_CUM_INFO I WHERE P.PRTN_ID = I.PRTN_ID) M LEFT JOIN T_CUM_OBJ_APPROVE O ON O.OBJ_ID = M.CUST_ID WHERE 1=1 AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND O.APPR_TYPE='1011' and m.prtn_id !=12040 and m.area_code in (select area_code from t_sym_area where stat = 'S0A' connect by prior area_code = parent_area start with area_code = '440000') AND M.PRTN_TYPE in('PT101', 'PT201', 'PT403') and exists (select * from t_cum_attr a where a.attr_id = 4224 and a.cust_id = m.cust_id and a.value1 like '%, 100, %') ORDER BY M.CUST_ID DESC ) b order by b.PRTN_CODE) TmpTable

ab2cqsptaqytu SELECT PROD_NAME FROM T_PDM_PRODUCT WHERE STAT = 'S0A' AND PROD_ID = 0

aj7w13s2jmuhs SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'CUM_VIPLEV' AND dict_id = 'COM'

arxvujrybgtvj select count(*) as y0_ from T_SYM_OPERLOG this_ where this_.OPER_TYPE in (:1) order by this_.OPER_DATE desc

b16m9ng3yquz0 SELECT COUNT(1) AS COUNT_RECORD FROM T_SCS_ORDER o where 1=1 AND o.ACCT_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND o.ACCT_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND o.CUST_ID IN (SELECT c.CUST_ID FROM T_CUM_INFO c WHERE 1=1 AND c.STAT = 'S0A' AND c.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER START WITH PRTN_ID = 12040 CONNECT BY PRIOR PRTN_ID = PARENT_ID)) AND o.ORDER_ID IN (SELECT a.ORDER_ID FROM T_SCS_ACTLIST a WHERE 1=1 AND a.ACTION_ID = '58')

b98hm9c06hgvc select info.*, TO_CHAR(info.EFF_DATE, 'YYYYMMDDHH24MISS') AS EFF_DATE1, to_char(info.EXP_DATE, 'YYYYMMDDHH24MISS') AS EXP_DATE1 from t_cum_acct acct, t_cum_acct_attr attr, t_cum_info info where acct.acct_id = attr.acct_id and info.cust_id = acct.cust_id and info.stat = 'S0A' AND attr.VALUE1 = '51500001000284604'

bf9gbpqjwy4u0 select t.actlist_id, t.action_id, t.end_date, t.event_seq from t_scs_actlist t where order_id =140305069024529

c6xvugn8bnxmt SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'CUM_THTYPE' AND dict_id = 'TH003'

cb1ddfqamyx8c SELECT PWD_ERRTIMES, PWD_ERRTIMES_PAY FROM T_SYM_STAFF WHERE STAFF_ID = :STAFF_ID

cq4va5130p8sh select * from (select rownum as WHO_KNOW_THIS_TAG_BAFNIQ_NUM, a.* from (with M as (SELECT r.cust_id, r.acct_code, r.bingcard_bank, r.bingcard_flag, r.stat FROM (SELECT tt.*, row_number() over(PARTITION BY tt.cust_id ORDER BY tt.stat) AS rn FROM (SELECT ca.cust_id, ca.acct_code, (SELECT b.bank_name FROM t_sym_bank b WHERE b.bank_id = ca.bank_id) bingcard_bank, 'S0C' AS bingcard_flag, ca.stat FROM t_cum_acct ca WHERE ca.acct_type = 'ACCT001' UNION SELECT (SELECT a.cust_id FROM t_cum_info a WHERE a.cust_code = r.cust_code) cust_id, r.bank_acct AS acct_code, (SELECT MIN(b.bank_name) FROM t_sym_bank b WHERE b.bank_code = r.bank_code) bingcard_bank, r.bind_state AS bingcard_flag, r.stat FROM t_cum_regbindcard r WHERE r.stat = 'S0A' UNION SELECT t2.cust_id, t2.acct_code, t2.bingcard_bank, t2.bingcard_flag, t2.stat FROM (SELECT t1.*, row_number() over(PARTITION BY t1.cust_id ORDER BY t1.bind_date DESC) AS rn FROM (SELECT (SELECT a.cust_id FROM t_cum_info a WHERE a.cust_code = cr.cust_code) cust_id, cr.bank_acct AS acct_code, (SELECT MIN(b.bank_name) FROM t_sym_bank b WHERE b.bank_code = cr.bank_code) bingcard_bank, cr.bind_state AS bingcard_flag, cr.bind_date, cr.stat FROM t_cum_regbindcard cr WHERE cr.stat = 'S0X' ) t1) t2 WHERE t2.rn = 1 ) tt) r WHERE 1 = 1 AND r.rn = 1) SELECT T.*, M.ACCT_CODE, M.BINGCARD_BANK, M.BINGCARD_FLAG FROM (SELECT M.*, R.PRTN_NAME, R.PRTN_TYPE, (SELECT P.PRTN_NAME FROM T_PNM_PARTNER P WHERE P.PRTN_ID = R.PARENT_ID) PARENT_NAME FROM (SELECT /*+driving_site(T)*/T.CUST_ID, T.PRTN_ID, T.CUST_CODE, T.CUST_NAME, T.CUST_TYPE, T.EFF_DATE, T.STAT, T.OPER_FLAG, T.AREA_CODE, A.APPLY_STAFF, A.APPR_STAFF, A.LASTAPPR_STAT FROM T_CUM_INFO T LEFT JOIN T_CUM_OBJ_APPROVE A ON T.CUST_ID = A.OBJ_ID AND A.APPR_TYPE = '1002' WHERE T.CUST_TYPE = 'C02') M, T_PNM_PARTNER R, T_CUM_ACCT CA WHERE M.PRTN_ID = R.PRTN_ID AND CA.ACCT_TYPE = 'ACCT002' AND M.CUST_ID = CA.CUST_ID AND R.PRTN_TYPE IN ('PT301', 'PT401', 'PT901', 'PT404') AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND EXISTS (SELECT 1 FROM T_CUM_ATTR A WHERE A.ATTR_ID =(SELECT A.ATTR_ID FROM T_SYM_ATTR A WHERE A.ATTR_CODE = 'CUM_PDLINEID' AND A.ATTR_TYPE = 'CUST' AND A.STAT='S0A') AND A.CUST_ID = M.CUST_ID AND A.VALUE1 LIKE '%, 100, %') ORDER BY M.CUST_ID DESC) T LEFT JOIN M M ON M.CUST_ID = T.CUST_ID) a) b where b.WHO_KNOW_THIS_TAG_BAFNIQ_NUM<=10 and b.WHO_KNOW_THIS_TAG_BAFNIQ_NUM>=1

csqmhq6dk66s6 SELECT PDM.ACTION_NAME, COUNT(1) COUNTING, 10 TIME_RANGE, 30 EXPECT FROM BPPF_EAS.T_SCS_ORDER O, BPPF_EAS.T_SCS_ACTLIST A, BPPF_BIS.T_PDM_ACTION PDM WHERE O.ORDER_ID = A.ORDER_ID AND O.ORDER_TYPE = 'OT001' AND A.ACTION_ID = PDM.ACTION_ID AND O.BEGIN_DATE BETWEEN SYSDATE - INTERVAL '10' MINUTE AND SYSDATE AND PDM.ACTION_TYPE = 'PAY' AND TRUNC((O.END_DATE - O.ACCT_DATE) * 24 * 60 * 60) > 30 GROUP BY PDM.ACTION_NAME

cy6dgzmu84g2r select * from (select rownum as WHO_KNOW_THIS_TAG_BAFNIQ_NUM, a.* from (select b.*, (select to_char(wmsys.wm_concat(ti.term_code)) from (select t.*, cc.cust_id from t_tmn_info t, t_cum_channel cc where cc.term_id = t.term_id and cc.stat='S0A' and t.stat='S0A') ti where ti.cust_id = b.cust_id group by ti.cust_id) term_code from (SELECT DISTINCT M.*, O.LASTAPPR_STAT, O.APPLY_STAFF, O.APPR_STAFF, O.LAST_APPR_STAFF FROM (SELECT I.CUST_ID, P.* FROM T_PNM_PARTNER P, T_CUM_INFO I WHERE P.PRTN_ID = I.PRTN_ID) M LEFT JOIN T_CUM_OBJ_APPROVE O ON O.OBJ_ID = M.CUST_ID WHERE 1=1 AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND O.APPR_TYPE='1011' and m.prtn_id !=12040 and m.prtn_name like '%??%' AND M.PRTN_TYPE in('PT101', 'PT201', 'PT403') and exists (select * from t_cum_attr a where a.attr_id = 4224 and a.cust_id = m.cust_id and a.value1 like '%, 100, %') ORDER BY M.CUST_ID DESC ) b order by b.PRTN_CODE) a) b where b.WHO_KNOW_THIS_TAG_BAFNIQ_NUM<=10 and b.WHO_KNOW_THIS_TAG_BAFNIQ_NUM>=1

d9xfggh4tc5ab SELECT DISTINCT I.OBJ_ID, I.PRIO_LEVEL FROM T_PDM_INCLUDE I WHERE I.OBJ_TYPE = 'BANK_CODE' AND I.APPLY_OBJ_TYPE = 'ACTION_CODE' AND I.APPLY_OBJ_ID = :APPLY_OBJ_ID AND I.APPLY_OBJ_TYPE2 = 'PRTN_CODE' AND I.APPLY_OBJ_ID2 = :APPLY_OBJ_ID2 AND I.APPLY_OBJ_TYPE3 = 'BANK_ID' AND I.APPLY_OBJ_ID3 = (SELECT B.BANK_ID FROM t_sym_bank B WHERE B.bank_code = :BANK_CODE AND B.bank_type = :BANK_TYPE AND B.stat = 'S0A') AND I.STAT = 'S0A' order by PRIO_LEVEL asc

dnan8kdpy6yck SELECT PROD_CODE FROM T_PDM_PRODUCT WHERE STAT = 'S0A' AND PROD_ID = 0

fj0a5xg65pzcy SELECT COUNT(1) AS COUNT_RECORD FROM T_SCS_ORDER o where 1=1 AND o.ACCT_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND o.ACCT_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND o.CUST_ID IN (SELECT c.CUST_ID FROM T_CUM_INFO c WHERE 1=1 AND c.STAT = 'S0A' AND c.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER START WITH PRTN_ID = 12040 CONNECT BY PRIOR PRTN_ID = PARENT_ID))

fr18sbu3zk4sr SELECT COUNT(*) AS CON FROM T_PDM_ACTGRP_RELA WHERE GRP_ID = :GRP_ID

g799f803fk442 SELECT ORD.ORDER_ID, ORD.ORDER_TYPE, TO_CHAR(ORD.ACCT_DATE, 'YYYYMMDDHH24MISS') AS ACCT_DATE, PDM.ACTION_CODE, ORD.CHANNEL_TYPE, PAY.PAY_TYPE, ORD.AREA_CODE, ACT.EVENT_SEQ, PROD.PROD_CODE, ORD.TERM_ID, ORD.CUST_ID, WR.DEAL_TIMES FROM T_SCS_ORDER ORD, T_PDM_ACTION PDM, T_SCS_PAYMENT PAY, T_SCS_ACTLIST ACT, T_PDM_PRODUCT PROD, T_SCS_WRONG_ORDER WR WHERE ORD.ORDER_ID = ACT.ORDER_ID AND ORD.ORDER_ID = WR.ORDER_ID AND ACT.ORDER_ID = WR.ORDER_ID AND ORD.ORDER_ID = PAY.ORDER_ID AND PROD.PROD_ID = ACT.PROD_ID AND (ORD.STAT = 'S0C' OR ORD.STAT = 'S0D') AND WR.STAT = 'S0A' AND ACT.ACTION_ID IN (SELECT ACTION_ID FROM T_PDM_ACTION WHERE ACTION_CODE IN ('04010001', '05010001', '05010002', '05010003', '16010001', '05010005', '03010008', '04010003')) AND PDM.ACTION_ID = ACT.ACTION_ID AND ORD.ACT_STAT = 'S0E' AND (ACT.RET_CODE = '0031' or ACT.RET_CODE = '0034' OR act.ret_code = '9090') AND ACT.STAT = 'S0E' AND ORD.ORDER_TYPE = 'OT001' AND TO_CHAR(ORD.ACCT_DATE, 'YYYYMMDD') = TO_CHAR(SYSDATE, 'YYYYMMDD')

SQL Id	SQL Text
02hsnb7xtghfp	SELECT sq_scs_stepinst.NEXTVAL as seq FROM DUAL
059md8mr237hf	SELECT ACTION_NAME FROM T_PDM_ACTION WHERE STAT = 'S0A' AND ACTION_ID = 0
0masfyw5jmkas	SELECT COUNT(1) AS COUNT_RECORD FROM T_EBK_DEALLOG where 1 = 1 AND CAAC_CODE <> '100600000000000001' AND CAAC_CODE = '110440201000009705' AND RECORD_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND RECORD_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND LOAN_FLAG = '+'
0sstbk1rg9xxa	SELECT INVOICE_ID, CUST_ID, ORDER_ID, ACTLIST_ID, OBJ_CODE, TERM_ID, IS_ENCRY, INVOICE_INFO, PRINT_COUNT, TO_CHAR(CREATE_DATE, 'YYYYMMDDHH24MISS') as CREATE_DATE, TO_CHAR(PRINT_DATE, 'YYYYMMDDHH24MISS') as PRINT_DATE, PRINT_STAT , ACT_PAY_MONEY, PAY_TYPE, PAY_ORG, ACCT_CODE, EVENT_SEQ FROM T_SCS_INVOICE where TERM_ID = '441221003709' and obj_code = '07586293242' and print_count = 0 order by CREATE_DATE desc
110455u7sfpgn	select count(1) from (select b., (select to_char(wmsys.wm_concat(ti.term_code)) from (select t., cc.cust_id from t_tmn_info t, t_cum_channel cc where cc.term_id = t.term_id and cc.stat='S0A' and t.stat='S0A') ti where ti.cust_id = b.cust_id group by ti.cust_id) term_code from (SELECT DISTINCT M., O.LASTAPPR_STAT, O.APPLY_STAFF, O.APPR_STAFF, O.LAST_APPR_STAFF FROM (SELECT I.CUST_ID, P. FROM T_PNM_PARTNER P, T_CUM_INFO I WHERE P.PRTN_ID = I.PRTN_ID) M LEFT JOIN T_CUM_OBJ_APPROVE O ON O.OBJ_ID = M.CUST_ID WHERE 1=1 AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND O.APPR_TYPE='1011' and m.prtn_id !=12040 and m.prtn_name like '%??%' AND M.PRTN_TYPE in('PT101', 'PT201', 'PT403') and exists (select * from t_cum_attr a where a.attr_id = 4224 and a.cust_id = m.cust_id and a.value1 like '%, 100, %') ORDER BY M.CUST_ID DESC ) b order by b.PRTN_CODE) TmpTable
133uk3sy9sm19	SELECT T.PRTN_ID, T.PRTN_NAME FROM T_PNM_PARTNER T WHERE T.PRTN_TYPE ='PT403' START WITH T.PRTN_ID=12040 CONNECT BY PRIOR T.PRTN_ID=T.PARENT_ID
1ddkpcc6s63jx	INSERT INTO T_SCS_ACT_ATTR (ACTLIST_ID, ACTION_ID, ATTR_ID, VALUE1, VALUE2, VALUE3, VALUE4, STAT) VALUES (:ACTLIST_ID, :ACTION_ID, :ATTR_ID, :VALUE1, :VALUE2, :VALUE3, :VALUE4, :STAT)
1k2q65ps3427z	SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'SYM_CERTTYPE' AND dict_id = 'C02'
1kjv68qx3pnkm	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN P_SCS_AUTH; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
23gz1n4vudn3n	INSERT INTO T_SCS_ORDER (ORDER_ID, ORDER_CODE, CUST_ID, ORDER_TYPE, AREA_CODE, TERM_ID, ACCT_DATE, BEGIN_DATE, END_DATE, EFF_DATE, LOGIN_TYPE, STAT, PAY_STAT, ACT_STAT, MEMO, TERM_SEQ, OPER_ORIG, OPER_STAT, CHANNEL_TYPE, EXT_ORDER_ID, SRC_ORDER_ID, OLD_STAT, OLD_PAYSTAT, OLD_ACTSTAT, EXT_VALUE1, EXT_VALUE2, EXT_VALUE3, EXT_VALUE4, TRADE_ORG) VALUES (:ORDER_ID, :ORDER_CODE, :CUST_ID, :ORDER_TYPE, :AREA_CODE, :TERM_ID, sysdate, TO_DATE(:BEGIN_DATE, 'YYYYMMDDHH24MISS'), TO_DATE(:END_DATE, 'YYYYMMDDHH24MISS'), TO_DATE(:EFF_DATE, 'YYYYMMDDHH24MISS'), :LOGIN_TYPE, :STAT, :PAY_STAT, :ACT_STAT, :MEMO, :TERM_SEQ, :OPER_ORIG, :OPER_STAT, :CHANNEL_TYPE, :EXT_ORDER_ID, :SRC_ORDER_ID, :OLD_STAT, :OLD_PAYSTAT, :OLD_ACTSTAT, :EXT_VALUE1, :EXT_VALUE2, :EXT_VALUE3, :EXT_VALUE4, :TRADE_ORG)
2d4q4c5ubp9k8	Insert into T_EBK_DEALLOG (LOG_SEQ, EVENT_SEQ, CAAC_CODE, ACCT_CODE, DEAL_CODE, DEAL_TYPE, LOAN_FLAG, DEAL_AMOUNT, END_BAL, CHANNEL_TYPE, DEAL_SRC, DEAL_STAFF, DEAL_ORG, DEAL_MEDTYPE, DEAL_MEDSN, DEAL_DATE, DEAL_TIME, RECORD_DATE, RESULT_CODE, RESULT_INFO, MEMO, SRC_LOG_SEQ, CUTOFF_DATE, TERM_SEQ, SRC_EVENT_SEQ, ORDER_CODE) Values (:LOG_SEQ, :EVENT_SEQ, :CAAC_CODE, :ACCT_CODE, :DEAL_CODE, :DEAL_TYPE, :LOAN_FLAG, :DEAL_AMOUNT, :END_BAL, :CHANNEL_TYPE, :DEAL_SRC, :DEAL_STAFF, :DEAL_ORG, :DEAL_MEDTYPE, :DEAL_MEDSN, :DEAL_DATE, :DEAL_TIME, sysdate, :RESULT_CODE, :RESULT_INFO, :MEMO, :SRC_LOG_SEQ, :CUTOFF_DATE, :TERM_SEQ, :SRC_EVENT_SEQ, :ORDER_CODE)
30uvjcd56583v	select tcc.th, ted.end_bal from t_cum_custom tcc, t_cum_acct tca, t_ebk_deallog ted where tca.cust_id = tcc.cust_id and tca.cust_id = :cust_id and tcc.th_type = 'TH001' and ted.src_event_seq = :src_event_seq and ted.caac_code = tca.acct_code
363am73y9dwpj	SELECT GRP_ID, ACTION_ID, MEMO, STAT FROM T_PDM_ACTGRP_RELA WHERE GRP_ID = :GRP_ID
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#
3m8quzddcths6	SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'SYM_CERTTYPE' AND dict_id = '99'
447ku4suqwzcw	SELECT * FROM (SELECT PRTN_ID, PRTN_TYPE FROM T_PNM_PARTNER START WITH PRTN_ID = :PRTN_ID CONNECT BY PRIOR PARENT_ID = PRTN_ID) WHERE PRTN_TYPE = 'PT403'
4kgprupqky1dz	select tcc.th, ted.end_bal from t_cum_custom tcc, t_cum_acct tca, t_ebk_deallog ted where tca.cust_id = tcc.cust_id and tca.cust_id = :cust_id and tcc.th_type = 'TH001' and ted.event_seq = :event_seq and ted.caac_code = tca.acct_code
4m81j4p2kdz0w	update T_INF_ORDERCTL set TMNNUM=:1, ORDER_CODE=:2, OPER_INFO=:3, OPER_DATE=:4, ORDER_STAT=:5, STAT=:6, REMARK=:7 where KEEP=:8
4vwxmbx4m76yh	SELECT COUNT(1) AS COUNT_RECORD FROM T_EBK_DEALLOG where 1 = 1 AND CAAC_CODE <> '100600000000000001' AND CAAC_CODE = '110442001000066235' AND RECORD_DATE >= TO_DATE('20140201000000', 'YYYYMMDDHH24MISS') AND RECORD_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND LOAN_FLAG = '+'
4x6bpjkhyguk8	select VALUE1 , VALUE3 from T_SCS_ORDATTR where STAT='S0A' AND ATTR_ID = :ATTR_ID AND ORDER_ID = :ORDER_ID
52g7t0n7yzq6c	INSERT INTO T_SCS_PAYMENT (PAYMENT_ID, ORDER_ID, PAY_TYPE, PAY_ORG, ACCTTYPE_CODE, ACCT_NAME, ACCT_CODE, ACCT_PWD, PAY_SEQ, CURRENCY_CODE, PAY_MONEY, MEDIA_TYPE, MEDIA_ID, TRACK_NO2, TRACK_NO3, NET_CODE, CREATE_DATE, BEGIN_DATE, END_DATE, STAT, RET_ID, RET_DATE, RET_CODE, RET_MSG, EVENT_SEQ, SEND_ID, CARD_TYPE, SRC_EVENTSEQ, INF_PAY_ORG, TERM_SEQ, EXT_ORDER_ID) VALUES (:PAYMENT_ID, :ORDER_ID, :PAY_TYPE, :PAY_ORG, :ACCTTYPE_CODE, :ACCT_NAME, :ACCT_CODE, :ACCT_PWD, :PAY_SEQ, :CURRENCY_CODE, :PAY_MONEY, :MEDIA_TYPE, :MEDIA_ID, :TRACK_NO2, :TRACK_NO3, :NET_CODE, sysdate, TO_DATE(:BEGIN_DATE, 'YYYYMMDDHH24MISS'), TO_DATE(:END_DATE, 'YYYYMMDDHH24MISS'), :STAT, :RET_ID, TO_DATE(:RET_DATE, 'YYYYMMDDHH24MISS'), :RET_CODE, :RET_MSG, :EVENT_SEQ, :SEND_ID, :CARD_TYPE, :SRC_EVENTSEQ, :INF_PAY_ORG, :TERM_SEQ, :EXT_ORDER_ID)
53u07hu2mu21y	select count(1) from (with M as (SELECT r.cust_id, r.acct_code, r.bingcard_bank, r.bingcard_flag, r.stat FROM (SELECT tt., row_number() over(PARTITION BY tt.cust_id ORDER BY tt.stat) AS rn FROM (SELECT ca.cust_id, ca.acct_code, (SELECT b.bank_name FROM t_sym_bank b WHERE b.bank_id = ca.bank_id) bingcard_bank, 'S0C' AS bingcard_flag, ca.stat FROM t_cum_acct ca WHERE ca.acct_type = 'ACCT001' UNION SELECT (SELECT a.cust_id FROM t_cum_info a WHERE a.cust_code = r.cust_code) cust_id, r.bank_acct AS acct_code, (SELECT MIN(b.bank_name) FROM t_sym_bank b WHERE b.bank_code = r.bank_code) bingcard_bank, r.bind_state AS bingcard_flag, r.stat FROM t_cum_regbindcard r WHERE r.stat = 'S0A' UNION SELECT t2.cust_id, t2.acct_code, t2.bingcard_bank, t2.bingcard_flag, t2.stat FROM (SELECT t1., row_number() over(PARTITION BY t1.cust_id ORDER BY t1.bind_date DESC) AS rn FROM (SELECT (SELECT a.cust_id FROM t_cum_info a WHERE a.cust_code = cr.cust_code) cust_id, cr.bank_acct AS acct_code, (SELECT MIN(b.bank_name) FROM t_sym_bank b WHERE b.bank_code = cr.bank_code) bingcard_bank, cr.bind_state AS bingcard_flag, cr.bind_date, cr.stat FROM t_cum_regbindcard cr WHERE cr.stat = 'S0X' ) t1) t2 WHERE t2.rn = 1 ) tt) r WHERE 1 = 1 AND r.rn = 1) SELECT T., M.ACCT_CODE, M.BINGCARD_BANK, M.BINGCARD_FLAG FROM (SELECT M., R.PRTN_NAME, R.PRTN_TYPE, (SELECT P.PRTN_NAME FROM T_PNM_PARTNER P WHERE P.PRTN_ID = R.PARENT_ID) PARENT_NAME FROM (SELECT /+driving_site(T)/T.CUST_ID, T.PRTN_ID, T.CUST_CODE, T.CUST_NAME, T.CUST_TYPE, T.EFF_DATE, T.STAT, T.OPER_FLAG, T.AREA_CODE, A.APPLY_STAFF, A.APPR_STAFF, A.LASTAPPR_STAT FROM T_CUM_INFO T LEFT JOIN T_CUM_OBJ_APPROVE A ON T.CUST_ID = A.OBJ_ID AND A.APPR_TYPE = '1002' WHERE T.CUST_TYPE = 'C02') M, T_PNM_PARTNER R, T_CUM_ACCT CA WHERE M.PRTN_ID = R.PRTN_ID AND CA.ACCT_TYPE = 'ACCT002' AND M.CUST_ID = CA.CUST_ID AND R.PRTN_TYPE IN ('PT301', 'PT401', 'PT901', 'PT404') AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND EXISTS (SELECT 1 FROM T_CUM_ATTR A WHERE A.ATTR_ID =(SELECT A.ATTR_ID FROM T_SYM_ATTR A WHERE A.ATTR_CODE = 'CUM_PDLINEID' AND A.ATTR_TYPE = 'CUST' AND A.STAT='S0A') AND A.CUST_ID = M.CUST_ID AND A.VALUE1 LIKE '%, 100, %') ORDER BY M.CUST_ID DESC) T LEFT JOIN M M ON M.CUST_ID = T.CUST_ID) TmpTable
5htg4qmxfjh4u	SELECT * FROM (SELECT ROW_.*, ROWNUM ROWNUM_ FROM(SELECT o.ORDER_ID, o.EXT_VALUE1, o.EXT_VALUE2, o.EXT_VALUE3, o.EXT_VALUE4, (SELECT CUST_CODE FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_CODE, (SELECT CUST_NAME FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_NAME, (SELECT CUST_TYPE FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_TYPE, (SELECT TF1.DUE_MOENY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS DUE_MOENY, (SELECT TF1.PAY_MONEY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS PAY_MONEY, (SELECT TF1.PREMIUM_MONEY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS PREMIUM_MONEY, o.STAT STAT, o.PAY_STAT, o.ACT_STAT, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_ORDERSTAT' AND DICT_ID = o.STAT) AS STATEN, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_PAYSTAT' AND DICT_ID = o.PAY_STAT) AS PAY_STATEN, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_ACTSTAT' AND DICT_ID = o.ACT_STAT) AS ACT_STATEN, TO_CHAR(o.ACCT_DATE, 'YYYYMMDDHH24MISS') AS ACCT_DATE, TO_CHAR(o.END_DATE, 'YYYYMMDDHH24MISS') AS END_DATE, o.RET_MSG, (SELECT F2.AREA_NAME FROM T_SYM_AREA F2 WHERE F2.AREA_CODE = o.AREA_CODE) AREA_NAME, o.TERM_ID, o.TERM_SEQ, o.ORDER_TYPE, o.EXT_ORDER_ID, o.MEMO, TO_CHAR(o.OPER_TIME, 'YYYYMMDDHH24MISS') AS OPER_TIME, o.HDL_WAY, (SELECT t.DICT_NAME FROM T_SYM_DICT t WHERE t.DICT_TYPEID = 'SCS_HDLWAY' AND t.DICT_ID = o.HDL_WAY) AS HDL_WAYCN, (SELECT T.DICT_NAME FROM T_SYM_DICT T WHERE T.DICT_TYPEID = 'SCS_ORDERTYPE' AND T.DICT_ID = o.ORDER_TYPE) ORDER_TYPENAME, 'OAS01' AS ORDER_ARC_STAT FROM T_SCS_ORDER o WHERE 1=1 AND o.ACCT_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND o.ACCT_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND o.CUST_ID IN (SELECT c.CUST_ID FROM T_CUM_INFO c WHERE 1=1 AND c.STAT = 'S0A' AND c.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER START WITH PRTN_ID = 12040 CONNECT BY PRIOR PRTN_ID = PARENT_ID)) ORDER BY ACCT_DATE DESC) ROW_ WHERE ROWNUM <= 10) WHERE ROWNUM_ >= 1
5htj25pp01mbd	SELECT CUST_ID, CUST_CODE, CUST_TYPE, CUST_NAME, PRTN_ID, STAT FROM T_CUM_INFO WHERE CUST_TYPE = 'C02' AND PRTN_ID = :PRTN_ID
5jvf84zg4c49n	select s.synonym_name as object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
5ntntd4c0f8qh	select t.actlist_id, t.action_id, t.end_date, t.event_seq from t_scs_actlist t where order_id =140305069024035
5ub2zgw60mh4z	SELECT INVOICE_ID, CUST_ID, ORDER_ID, ACTLIST_ID, OBJ_CODE, TERM_ID, IS_ENCRY, INVOICE_INFO, PRINT_COUNT, TO_CHAR(CREATE_DATE, 'YYYYMMDDHH24MISS') as CREATE_DATE, TO_CHAR(PRINT_DATE, 'YYYYMMDDHH24MISS') as PRINT_DATE, PRINT_STAT , ACT_PAY_MONEY, PAY_TYPE, PAY_ORG, ACCT_CODE, EVENT_SEQ FROM T_SCS_INVOICE where TERM_ID = '441221003709' and obj_code = '075856293242' and print_count = 0 order by CREATE_DATE desc
5urzmwn0d4t64	SELECT * FROM (SELECT T2.DISC_INFO_ID, T2.ORDER_ID, T1.CUST_ID, T1.TERM_SEQ, T2.DISC_ID, T2.DISC_VALUE, T2.DEAL_RET FROM T_SCS_ORDER T1, T_SCS_DISC_INFO T2 WHERE T1.ORDER_ID = T2.ORDER_ID AND T1.STAT = 'S0C' AND T1.PAY_STAT = 'S0S' AND T1.ACT_STAT = 'S0S' AND T2.DEAL_RET = 'S0A' ORDER BY T2.CREATE_DATE ASC) WHERE ROWNUM <= 100
681zrwjq2914w	select DISTINCT BATCH_CODE from t_opp_preorder where STAT='S0C' and ACCT_DATE <= (SYSDATE - 1/1440*5) ORDER BY BATCH_CODE
68368kpu6b3yc	SELECT CUST_ID, CUST_CODE, CUST_TYPE, CUST_NAME, PRTN_ID, STAT FROM T_CUM_INFO WHERE CUST_ID = :CUST_ID
6jbqatwrgbamp	SELECT PRTN_CODE, PRTN_NAME FROM T_PNM_PARTNER WHERE PRTN_TYPE = 'PT403' AND PRTN_ID IN (SELECT PRTN_ID FROM T_PNM_PARTNER PNM CONNECT BY PNM.PRTN_ID = PRIOR PNM.PARENT_ID START WITH PRTN_ID = :PRTN_ID)
6sn1ujjjymknw	SELECT COUNT(1) COUNTING, TO_CHAR(SYSDATE, 'HH24MISS') EXP_TIME FROM BPPF_EAS.T_SCS_ORDER T WHERE T.BEGIN_DATE BETWEEN SYSDATE - INTERVAL '1' MINUTE AND SYSDATE
6t5vubr5sz91m	select count(*) as y0_ from T_SYM_OPERLOG this_ where this_.OBJ_TYPE in (:1) order by this_.OPER_DATE desc
6tgt63zv6fjqf	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN P_SCS_REFUND_MESSAGE(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6vw1gvbbz0p4v	SELECT COUNT(1) AS COUNT_RECORD FROM T_EBK_DEALLOG where 1 = 1 AND CAAC_CODE <> '100600000000000001' AND CAAC_CODE = '110442001000011329' AND RECORD_DATE >= TO_DATE('20140304000000', 'YYYYMMDDHH24MISS') AND RECORD_DATE <= TO_DATE('20140304235959', 'YYYYMMDDHH24MISS') AND LOAN_FLAG = '+'
79vnx2tsr8mhs	SELECT ACTION_CODE FROM T_PDM_ACTION WHERE STAT = 'S0A' AND ACTION_ID = 0
7gh2xdvx3r5s0	INSERT INTO T_SCS_OPERLOG (LOG_SEQ, ORDER_ID, OPER_TYPE, OPER_INFO, CHANNEL_TYPE, OPER_SRC, OPER_STAFF, OPER_ORG, RECORD_DATE, RESULT_CODE, RESULT_INFO, MEMO) VALUES (:LOG_SEQ, :ORDER_ID, :OPER_TYPE, :OPER_INFO, :CHANNEL_TYPE, :OPER_SRC, :OPER_STAFF, :OPER_ORG, sysdate, :RESULT_CODE, :RESULT_INFO, :MEMO)
7rvm5cg2ph2vg	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN P_SCS_WRONG_ORDER_COLLECT(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7vd74jxxamcpk	SELECT SQ_SYM_SCRAND.NEXTVAL AS ID FROM DUAL
7y5q05wqf50g5	SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'CUM_PERIODTYPE' AND dict_id = 'PR000'
84th238k1m4ha	SELECT "PARENT_ID", "PRTN_ID", PRIOR "PRTN_ID" FROM "BPPF_BIS"."T_PNM_PARTNER" "A6" WHERE "PRTN_ID"=:1 START WITH ("PRTN_ID"=:2) CONNECT BY ("PARENT_ID"=PRIOR "PRTN_ID")
8bsppxkpc1dm1	SELECT * FROM T_CUM_CUSTOM WHERE CUSTOM_TYPE IN('T08', 'T09', 'T11', 'T12') AND STAT = 'S0A' AND CUST_ID = :CUST_ID
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
8ta1c19zayct0	SELECT TH FROM T_CUM_CUSTOM WHERE SYSDATE > EFF_DATE AND STAT = 'S0A' AND CUSTOM_TYPE = 'T13' AND CUST_ID = :CUST_ID
8ucs3qd2rdp7b	SELECT * FROM (SELECT ROW_.*, ROWNUM ROWNUM_ FROM(SELECT o.ORDER_ID, o.EXT_VALUE1, o.EXT_VALUE2, o.EXT_VALUE3, o.EXT_VALUE4, (SELECT CUST_CODE FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_CODE, (SELECT CUST_NAME FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_NAME, (SELECT CUST_TYPE FROM T_CUM_INFO WHERE CUST_ID = o.CUST_ID AND STAT = 'S0A') AS CUST_TYPE, (SELECT TF1.DUE_MOENY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS DUE_MOENY, (SELECT TF1.PAY_MONEY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS PAY_MONEY, (SELECT TF1.PREMIUM_MONEY FROM T_SCS_ORDFEE TF1 WHERE TF1.ORDER_ID = o.ORDER_ID) AS PREMIUM_MONEY, o.STAT STAT, o.PAY_STAT, o.ACT_STAT, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_ORDERSTAT' AND DICT_ID = o.STAT) AS STATEN, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_PAYSTAT' AND DICT_ID = o.PAY_STAT) AS PAY_STATEN, (SELECT DICT_NAME FROM T_SYM_DICT WHERE DICT_TYPEID = 'SCS_ACTSTAT' AND DICT_ID = o.ACT_STAT) AS ACT_STATEN, TO_CHAR(o.ACCT_DATE, 'YYYYMMDDHH24MISS') AS ACCT_DATE, TO_CHAR(o.END_DATE, 'YYYYMMDDHH24MISS') AS END_DATE, o.RET_MSG, (SELECT F2.AREA_NAME FROM T_SYM_AREA F2 WHERE F2.AREA_CODE = o.AREA_CODE) AREA_NAME, o.TERM_ID, o.TERM_SEQ, o.ORDER_TYPE, o.EXT_ORDER_ID, o.MEMO, TO_CHAR(o.OPER_TIME, 'YYYYMMDDHH24MISS') AS OPER_TIME, o.HDL_WAY, (SELECT t.DICT_NAME FROM T_SYM_DICT t WHERE t.DICT_TYPEID = 'SCS_HDLWAY' AND t.DICT_ID = o.HDL_WAY) AS HDL_WAYCN, (SELECT T.DICT_NAME FROM T_SYM_DICT T WHERE T.DICT_TYPEID = 'SCS_ORDERTYPE' AND T.DICT_ID = o.ORDER_TYPE) ORDER_TYPENAME, 'OAS01' AS ORDER_ARC_STAT FROM T_SCS_ORDER o WHERE 1=1 AND o.ACCT_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND o.ACCT_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND o.CUST_ID IN (SELECT c.CUST_ID FROM T_CUM_INFO c WHERE 1=1 AND c.STAT = 'S0A' AND c.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER START WITH PRTN_ID = 94139 CONNECT BY PRIOR PRTN_ID = PARENT_ID)) ORDER BY ACCT_DATE DESC) ROW_ WHERE ROWNUM <= 10) WHERE ROWNUM_ >= 1
97yqr984x14q7	SELECT ORD.SRC_ORDER_ID ORDER_ID, STAFF.MOBILE PHONE, FEE.DUE_MOENY MONEY, TO_CHAR(ORD.BEGIN_DATE, 'MM"?"DD"?"') PAY_DATE FROM BPPF_BIS.T_SYM_STAFF STAFF, BPPF_EAS.T_SCS_ORDER ORD, BPPF_EAS.T_SCS_PAYMENT PAY, BPPF_EAS.T_SCS_ACTLIST ACT, BPPF_EAS.T_SCS_ACTFEE FEE WHERE (ORD.ORDER_TYPE = 'OT101' OR ORD.ORDER_TYPE = 'OT201') AND ORD.ORDER_ID = PAY.ORDER_ID AND ORD.ORDER_ID = ACT.ORDER_ID AND ORD.ORDER_ID = FEE.ORDER_ID AND ACT.ACTLIST_ID = FEE.ACTLIST_ID AND ORD.PAY_STAT = 'S0S' AND PAY.STAT = 'S0S' AND ORD.END_DATE BETWEEN SYSDATE - INTERVAL '5' MINUTE AND SYSDATE AND STAFF.ORG_ID IN (SELECT PRIV.ORG_ID FROM BPPF_BIS.T_CUM_PRIV PRIV, BPPF_BIS.T_CUM_INFO CUM WHERE PRIV.PRTN_ID = CUM.PRTN_ID AND CUM.CUST_ID = ORD.CUST_ID) AND STAFF.EXT_FLAG = 'DEF'
9r30k0h2f4sd6	SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'CUM_CUSTOMTYPE' AND dict_id = 'T13'
a731jcvrzjdf2	SELECT COUNT(1) AS COUNT_RECORD FROM T_EBK_DEALLOG where 1 = 1 AND CAAC_CODE <> '100600000000000001' AND CAAC_CODE = '110440601000029601' AND RECORD_DATE >= TO_DATE('20140228000000', 'YYYYMMDDHH24MISS') AND RECORD_DATE <= TO_DATE('20140228235959', 'YYYYMMDDHH24MISS') AND LOAN_FLAG = '+'
aa06zmyaruqwr	select count(1) from (select b., (select to_char(wmsys.wm_concat(ti.term_code)) from (select t., cc.cust_id from t_tmn_info t, t_cum_channel cc where cc.term_id = t.term_id and cc.stat='S0A' and t.stat='S0A') ti where ti.cust_id = b.cust_id group by ti.cust_id) term_code from (SELECT DISTINCT M., O.LASTAPPR_STAT, O.APPLY_STAFF, O.APPR_STAFF, O.LAST_APPR_STAFF FROM (SELECT I.CUST_ID, P. FROM T_PNM_PARTNER P, T_CUM_INFO I WHERE P.PRTN_ID = I.PRTN_ID) M LEFT JOIN T_CUM_OBJ_APPROVE O ON O.OBJ_ID = M.CUST_ID WHERE 1=1 AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND O.APPR_TYPE='1011' and m.prtn_id !=12040 and m.area_code in (select area_code from t_sym_area where stat = 'S0A' connect by prior area_code = parent_area start with area_code = '440000') AND M.PRTN_TYPE in('PT101', 'PT201', 'PT403') and exists (select * from t_cum_attr a where a.attr_id = 4224 and a.cust_id = m.cust_id and a.value1 like '%, 100, %') ORDER BY M.CUST_ID DESC ) b order by b.PRTN_CODE) TmpTable
ab2cqsptaqytu	SELECT PROD_NAME FROM T_PDM_PRODUCT WHERE STAT = 'S0A' AND PROD_ID = 0
aj7w13s2jmuhs	SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'CUM_VIPLEV' AND dict_id = 'COM'
arxvujrybgtvj	select count(*) as y0_ from T_SYM_OPERLOG this_ where this_.OPER_TYPE in (:1) order by this_.OPER_DATE desc
b16m9ng3yquz0	SELECT COUNT(1) AS COUNT_RECORD FROM T_SCS_ORDER o where 1=1 AND o.ACCT_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND o.ACCT_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND o.CUST_ID IN (SELECT c.CUST_ID FROM T_CUM_INFO c WHERE 1=1 AND c.STAT = 'S0A' AND c.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER START WITH PRTN_ID = 12040 CONNECT BY PRIOR PRTN_ID = PARENT_ID)) AND o.ORDER_ID IN (SELECT a.ORDER_ID FROM T_SCS_ACTLIST a WHERE 1=1 AND a.ACTION_ID = '58')
b98hm9c06hgvc	select info.*, TO_CHAR(info.EFF_DATE, 'YYYYMMDDHH24MISS') AS EFF_DATE1, to_char(info.EXP_DATE, 'YYYYMMDDHH24MISS') AS EXP_DATE1 from t_cum_acct acct, t_cum_acct_attr attr, t_cum_info info where acct.acct_id = attr.acct_id and info.cust_id = acct.cust_id and info.stat = 'S0A' AND attr.VALUE1 = '51500001000284604'
bf9gbpqjwy4u0	select t.actlist_id, t.action_id, t.end_date, t.event_seq from t_scs_actlist t where order_id =140305069024529
c6xvugn8bnxmt	SELECT DICT_ID, DICT_TYPEID, DICT_NAME, STAT, DICT_DESC, SHOW_SEQ, IS_DEFAULT, CAN_MODIFY FROM T_SYM_DICT WHERE dict_typeid = 'CUM_THTYPE' AND dict_id = 'TH003'
cb1ddfqamyx8c	SELECT PWD_ERRTIMES, PWD_ERRTIMES_PAY FROM T_SYM_STAFF WHERE STAFF_ID = :STAFF_ID
cq4va5130p8sh	select * from (select rownum as WHO_KNOW_THIS_TAG_BAFNIQ_NUM, a.* from (with M as (SELECT r.cust_id, r.acct_code, r.bingcard_bank, r.bingcard_flag, r.stat FROM (SELECT tt., row_number() over(PARTITION BY tt.cust_id ORDER BY tt.stat) AS rn FROM (SELECT ca.cust_id, ca.acct_code, (SELECT b.bank_name FROM t_sym_bank b WHERE b.bank_id = ca.bank_id) bingcard_bank, 'S0C' AS bingcard_flag, ca.stat FROM t_cum_acct ca WHERE ca.acct_type = 'ACCT001' UNION SELECT (SELECT a.cust_id FROM t_cum_info a WHERE a.cust_code = r.cust_code) cust_id, r.bank_acct AS acct_code, (SELECT MIN(b.bank_name) FROM t_sym_bank b WHERE b.bank_code = r.bank_code) bingcard_bank, r.bind_state AS bingcard_flag, r.stat FROM t_cum_regbindcard r WHERE r.stat = 'S0A' UNION SELECT t2.cust_id, t2.acct_code, t2.bingcard_bank, t2.bingcard_flag, t2.stat FROM (SELECT t1., row_number() over(PARTITION BY t1.cust_id ORDER BY t1.bind_date DESC) AS rn FROM (SELECT (SELECT a.cust_id FROM t_cum_info a WHERE a.cust_code = cr.cust_code) cust_id, cr.bank_acct AS acct_code, (SELECT MIN(b.bank_name) FROM t_sym_bank b WHERE b.bank_code = cr.bank_code) bingcard_bank, cr.bind_state AS bingcard_flag, cr.bind_date, cr.stat FROM t_cum_regbindcard cr WHERE cr.stat = 'S0X' ) t1) t2 WHERE t2.rn = 1 ) tt) r WHERE 1 = 1 AND r.rn = 1) SELECT T., M.ACCT_CODE, M.BINGCARD_BANK, M.BINGCARD_FLAG FROM (SELECT M., R.PRTN_NAME, R.PRTN_TYPE, (SELECT P.PRTN_NAME FROM T_PNM_PARTNER P WHERE P.PRTN_ID = R.PARENT_ID) PARENT_NAME FROM (SELECT /+driving_site(T)/T.CUST_ID, T.PRTN_ID, T.CUST_CODE, T.CUST_NAME, T.CUST_TYPE, T.EFF_DATE, T.STAT, T.OPER_FLAG, T.AREA_CODE, A.APPLY_STAFF, A.APPR_STAFF, A.LASTAPPR_STAT FROM T_CUM_INFO T LEFT JOIN T_CUM_OBJ_APPROVE A ON T.CUST_ID = A.OBJ_ID AND A.APPR_TYPE = '1002' WHERE T.CUST_TYPE = 'C02') M, T_PNM_PARTNER R, T_CUM_ACCT CA WHERE M.PRTN_ID = R.PRTN_ID AND CA.ACCT_TYPE = 'ACCT002' AND M.CUST_ID = CA.CUST_ID AND R.PRTN_TYPE IN ('PT301', 'PT401', 'PT901', 'PT404') AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND EXISTS (SELECT 1 FROM T_CUM_ATTR A WHERE A.ATTR_ID =(SELECT A.ATTR_ID FROM T_SYM_ATTR A WHERE A.ATTR_CODE = 'CUM_PDLINEID' AND A.ATTR_TYPE = 'CUST' AND A.STAT='S0A') AND A.CUST_ID = M.CUST_ID AND A.VALUE1 LIKE '%, 100, %') ORDER BY M.CUST_ID DESC) T LEFT JOIN M M ON M.CUST_ID = T.CUST_ID) a) b where b.WHO_KNOW_THIS_TAG_BAFNIQ_NUM<=10 and b.WHO_KNOW_THIS_TAG_BAFNIQ_NUM>=1
csqmhq6dk66s6	SELECT PDM.ACTION_NAME, COUNT(1) COUNTING, 10 TIME_RANGE, 30 EXPECT FROM BPPF_EAS.T_SCS_ORDER O, BPPF_EAS.T_SCS_ACTLIST A, BPPF_BIS.T_PDM_ACTION PDM WHERE O.ORDER_ID = A.ORDER_ID AND O.ORDER_TYPE = 'OT001' AND A.ACTION_ID = PDM.ACTION_ID AND O.BEGIN_DATE BETWEEN SYSDATE - INTERVAL '10' MINUTE AND SYSDATE AND PDM.ACTION_TYPE = 'PAY' AND TRUNC((O.END_DATE - O.ACCT_DATE) * 24 * 60 * 60) > 30 GROUP BY PDM.ACTION_NAME
cy6dgzmu84g2r	select * from (select rownum as WHO_KNOW_THIS_TAG_BAFNIQ_NUM, a.* from (select b., (select to_char(wmsys.wm_concat(ti.term_code)) from (select t., cc.cust_id from t_tmn_info t, t_cum_channel cc where cc.term_id = t.term_id and cc.stat='S0A' and t.stat='S0A') ti where ti.cust_id = b.cust_id group by ti.cust_id) term_code from (SELECT DISTINCT M., O.LASTAPPR_STAT, O.APPLY_STAFF, O.APPR_STAFF, O.LAST_APPR_STAFF FROM (SELECT I.CUST_ID, P. FROM T_PNM_PARTNER P, T_CUM_INFO I WHERE P.PRTN_ID = I.PRTN_ID) M LEFT JOIN T_CUM_OBJ_APPROVE O ON O.OBJ_ID = M.CUST_ID WHERE 1=1 AND M.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER T CONNECT BY PRIOR T.PRTN_ID = T.PARENT_ID START WITH T.PRTN_ID = 12040) AND O.APPR_TYPE='1011' and m.prtn_id !=12040 and m.prtn_name like '%??%' AND M.PRTN_TYPE in('PT101', 'PT201', 'PT403') and exists (select * from t_cum_attr a where a.attr_id = 4224 and a.cust_id = m.cust_id and a.value1 like '%, 100, %') ORDER BY M.CUST_ID DESC ) b order by b.PRTN_CODE) a) b where b.WHO_KNOW_THIS_TAG_BAFNIQ_NUM<=10 and b.WHO_KNOW_THIS_TAG_BAFNIQ_NUM>=1
d9xfggh4tc5ab	SELECT DISTINCT I.OBJ_ID, I.PRIO_LEVEL FROM T_PDM_INCLUDE I WHERE I.OBJ_TYPE = 'BANK_CODE' AND I.APPLY_OBJ_TYPE = 'ACTION_CODE' AND I.APPLY_OBJ_ID = :APPLY_OBJ_ID AND I.APPLY_OBJ_TYPE2 = 'PRTN_CODE' AND I.APPLY_OBJ_ID2 = :APPLY_OBJ_ID2 AND I.APPLY_OBJ_TYPE3 = 'BANK_ID' AND I.APPLY_OBJ_ID3 = (SELECT B.BANK_ID FROM t_sym_bank B WHERE B.bank_code = :BANK_CODE AND B.bank_type = :BANK_TYPE AND B.stat = 'S0A') AND I.STAT = 'S0A' order by PRIO_LEVEL asc
dnan8kdpy6yck	SELECT PROD_CODE FROM T_PDM_PRODUCT WHERE STAT = 'S0A' AND PROD_ID = 0
fj0a5xg65pzcy	SELECT COUNT(1) AS COUNT_RECORD FROM T_SCS_ORDER o where 1=1 AND o.ACCT_DATE >= TO_DATE('20140305000000', 'YYYYMMDDHH24MISS') AND o.ACCT_DATE <= TO_DATE('20140305235959', 'YYYYMMDDHH24MISS') AND o.CUST_ID IN (SELECT c.CUST_ID FROM T_CUM_INFO c WHERE 1=1 AND c.STAT = 'S0A' AND c.PRTN_ID IN(SELECT PRTN_ID FROM T_PNM_PARTNER START WITH PRTN_ID = 12040 CONNECT BY PRIOR PRTN_ID = PARENT_ID))
fr18sbu3zk4sr	SELECT COUNT(*) AS CON FROM T_PDM_ACTGRP_RELA WHERE GRP_ID = :GRP_ID
g799f803fk442	SELECT ORD.ORDER_ID, ORD.ORDER_TYPE, TO_CHAR(ORD.ACCT_DATE, 'YYYYMMDDHH24MISS') AS ACCT_DATE, PDM.ACTION_CODE, ORD.CHANNEL_TYPE, PAY.PAY_TYPE, ORD.AREA_CODE, ACT.EVENT_SEQ, PROD.PROD_CODE, ORD.TERM_ID, ORD.CUST_ID, WR.DEAL_TIMES FROM T_SCS_ORDER ORD, T_PDM_ACTION PDM, T_SCS_PAYMENT PAY, T_SCS_ACTLIST ACT, T_PDM_PRODUCT PROD, T_SCS_WRONG_ORDER WR WHERE ORD.ORDER_ID = ACT.ORDER_ID AND ORD.ORDER_ID = WR.ORDER_ID AND ACT.ORDER_ID = WR.ORDER_ID AND ORD.ORDER_ID = PAY.ORDER_ID AND PROD.PROD_ID = ACT.PROD_ID AND (ORD.STAT = 'S0C' OR ORD.STAT = 'S0D') AND WR.STAT = 'S0A' AND ACT.ACTION_ID IN (SELECT ACTION_ID FROM T_PDM_ACTION WHERE ACTION_CODE IN ('04010001', '05010001', '05010002', '05010003', '16010001', '05010005', '03010008', '04010003')) AND PDM.ACTION_ID = ACT.ACTION_ID AND ORD.ACT_STAT = 'S0E' AND (ACT.RET_CODE = '0031' or ACT.RET_CODE = '0034' OR act.ret_code = '9090') AND ACT.STAT = 'S0E' AND ORD.ORDER_TYPE = 'OT001' AND TO_CHAR(ORD.ACCT_DATE, 'YYYYMMDD') = TO_CHAR(SYSDATE, 'YYYYMMDD')

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	581	0.32	0.01
Batched IO (full) vector count	6	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	4,217	2.34	0.06
Batched IO buffer defrag count	12	0.01	0.00
Batched IO double miss count	217	0.12	0.00
Batched IO same unit count	1,912	1.06	0.03
Batched IO single block count	476	0.26	0.01
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	1,785	0.99	0.02
Batched IO vector read count	322	0.18	0.00
Block Cleanout Optim referenced	3,539	1.96	0.05
CCursor + sql area evicted	784	0.43	0.01
CPU used by this session	282,708	156.54	3.87
CPU used when call started	437,039	242.00	5.98
CR blocks created	7,121	3.94	0.10
Cached Commit SCN referenced	13,787	7.63	0.19
Clusterwide global transactions	7,879	4.36	0.11
Commit SCN cached	79,819	44.20	1.09
DB time	816,918	452.35	11.18
DBWR checkpoint buffers written	38,610	21.38	0.53
DBWR checkpoints	175	0.10	0.00
DBWR fusion writes	7,382	4.09	0.10
DBWR object drop buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	890	0.49	0.01
DBWR transaction table writes	191	0.11	0.00
DBWR undo block writes	7,775	4.31	0.11
DFO trees parallelized	18	0.01	0.00
DX/BB enqueue lock background get time	295	0.16	0.00
DX/BB enqueue lock background gets	15,758	8.73	0.22
DX/BB enqueue lock foreground requests	831,084	460.19	11.38
DX/BB enqueue lock foreground wait time	1,807	1.00	0.02
Effective IO time	395,047,614	218,748.42	5,407.31
GTX processes spawned by autotune	1	0.00	0.00
GTX processes stopped by autotune	0	0.00	0.00
HSC Heap Segment Block Changes	127,689	70.70	1.75
Heap Segment Array Inserts	2,617	1.45	0.04
Heap Segment Array Updates	331	0.18	0.00
Number of read IOs issued	342,714	189.77	4.69
PX local messages recv'd	60	0.03	0.00
PX local messages sent	60	0.03	0.00
PX remote messages recv'd	60	0.03	0.00
PX remote messages sent	60	0.03	0.00
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	18	0.01	0.00
Requests to/from client	3,538,655	1,959.45	48.44
RowCR - row contention	1,221	0.68	0.02
RowCR attempts	15,035	8.33	0.21
RowCR hits	13,736	7.61	0.19
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment recovery	4	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	3,538,775	1,959.51	48.44
SQL*Net roundtrips to/from dblink	1,969	1.09	0.03
active txn count during cleanout	15,066	8.34	0.21
application wait time	40,286,454	22,307.69	551.43
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	15,528	8.60	0.21
branch node splits	6	0.00	0.00
buffer is not pinned count	68,829,267	38,112.60	942.12
buffer is pinned count	181,104,486	100,282.39	2,478.91
bytes received via SQL*Net from client	1,152,352,703	638,088.48	15,773.12
bytes received via SQL*Net from dblink	4,489,763	2,486.10	61.45
bytes sent via SQL*Net to client	1,575,756,280	872,538.36	21,568.57
bytes sent via SQL*Net to dblink	437,932	242.49	5.99
calls to get snapshot scn: kcmgss	1,049,821	581.31	14.37
calls to kcmgas	206,291	114.23	2.82
calls to kcmgcs	292,330	161.87	4.00
cell physical IO interconnect bytes	355,829,904,384	197,032,525.57	4,870,512.53
change write time	713	0.39	0.01
cleanout - number of ktugct calls	240,732	133.30	3.30
cleanouts and rollbacks - consistent read gets	6,470	3.58	0.09
cleanouts only - consistent read gets	222,670	123.30	3.05
cluster key scan block gets	5,674	3.14	0.08
cluster key scans	5,375	2.98	0.07
cluster wait time	7,929	4.39	0.11
commit batch performed	30	0.02	0.00
commit batch requested	30	0.02	0.00
commit batch/immediate performed	167	0.09	0.00
commit batch/immediate requested	167	0.09	0.00
commit cleanout failures: block lost	4,113	2.28	0.06
commit cleanout failures: buffer being written	7	0.00	0.00
commit cleanout failures: callback failure	10,440	5.78	0.14
commit cleanout failures: cannot pin	226	0.13	0.00
commit cleanouts	338,854	187.63	4.64
commit cleanouts successfully completed	324,068	179.45	4.44
commit immediate performed	137	0.08	0.00
commit immediate requested	137	0.08	0.00
commit txn count during cleanout	304,834	168.79	4.17
concurrency wait time	1,140	0.63	0.02
consistent changes	29,290	16.22	0.40
consistent gets	204,594,940	113,289.68	2,800.45
consistent gets - examination	28,366,635	15,707.36	388.28
consistent gets direct	43,172,614	23,905.83	590.94
consistent gets from cache	161,422,367	89,383.88	2,209.51
consistent gets from cache (fastpath)	131,451,488	72,788.20	1,799.28
cursor authentications	59,177	32.77	0.81
data blocks consistent reads - undo records applied	12,292	6.81	0.17
db block changes	1,040,092	575.93	14.24
db block gets	1,523,351	843.52	20.85
db block gets direct	229	0.13	0.00
db block gets from cache	1,523,122	843.39	20.85
db block gets from cache (fastpath)	385,498	213.46	5.28
deferred (CURRENT) block cleanout applications	87,818	48.63	1.20
dirty buffers inspected	940	0.52	0.01
enqueue conversions	1,019	0.56	0.01
enqueue releases	315,871	174.91	4.32
enqueue requests	315,882	174.91	4.32
enqueue timeouts	2	0.00	0.00
enqueue waits	1,427	0.79	0.02
exchange deadlocks	386	0.21	0.01
execute count	1,007,824	558.06	13.79
failed probes on index block reclamation	12	0.01	0.00
file io wait time	259,899,237	143,913.15	3,557.44
free buffer inspected	122,878	68.04	1.68
free buffer requested	170,046	94.16	2.33
gc blocks compressed	45,447	25.17	0.62
gc cr block flush time	1,352	0.75	0.02
gc cr block receive time	2,559	1.42	0.04
gc cr blocks received	36,598	20.27	0.50
gc cr blocks served	38,014	21.05	0.52
gc current block flush time	2,466,413	1,365.72	33.76
gc current block pin time	16,432,941	9,099.36	224.93
gc current block receive time	3,545	1.96	0.05
gc current blocks received	50,083	27.73	0.69
gc current blocks served	122,821	68.01	1.68
gc kbytes saved	122,321	67.73	1.67
gc kbytes sent	1,164,360	644.74	15.94
gc local grants	46,629	25.82	0.64
gc read wait time	0	0.00	0.00
gc read wait timeouts	0	0.00	0.00
gc read waits	1	0.00	0.00
gc remote grants	24,831	13.75	0.34
gcs messages sent	247,165	136.86	3.38
ges messages sent	80,610	44.64	1.10
global enqueue get time	5,204	2.88	0.07
global enqueue gets async	4,193	2.32	0.06
global enqueue gets sync	1,804,595	999.25	24.70
global enqueue releases	1,614,314	893.89	22.10
heap block compress	2,113	1.17	0.03
hot buffers moved to head of LRU	5,244	2.90	0.07
immediate (CR) block cleanout applications	229,143	126.88	3.14
immediate (CURRENT) block cleanout applications	33,898	18.77	0.46
in call idle wait time	9,673,537	5,356.50	132.41
index crx upgrade (positioned)	283	0.16	0.00
index crx upgrade (prefetch)	1	0.00	0.00
index fast full scans (full)	3,072	1.70	0.04
index fetch by key	8,842,459	4,896.31	121.03
index scans kdiixs1	51,150,150	28,323.20	700.13
leaf node 90-10 splits	421	0.23	0.01
leaf node splits	1,331	0.74	0.02
lob reads	2,374	1.31	0.03
lob writes	2,448	1.36	0.03
lob writes unaligned	2,448	1.36	0.03
logical read bytes from cache	1,334,847,094,784	739,140,502.50	18,271,059.91
logons cumulative	734	0.41	0.01
max cf enq hold time	170	0.09	0.00
messages received	147,258	81.54	2.02
messages sent	147,258	81.54	2.02
min active SCN optimization applied on CR	66	0.04	0.00
no buffer to keep pinned count	528	0.29	0.01
no work - consistent read gets	174,844,871	96,816.28	2,393.23
non-idle wait count	4,583,561	2,538.04	62.74
non-idle wait time	40,406,694	22,374.27	553.08
opened cursors cumulative	1,421,172	786.94	19.45
parse count (describe)	54	0.03	0.00
parse count (failures)	3	0.00	0.00
parse count (hard)	108,316	59.98	1.48
parse count (total)	1,001,750	554.70	13.71
parse time cpu	26,701	14.79	0.37
parse time elapsed	25,157	13.93	0.34
physical read IO requests	384,038	212.65	5.26
physical read bytes	354,050,760,704	196,047,366.17	4,846,160.05
physical read total IO requests	391,916	217.01	5.36
physical read total bytes	354,605,830,656	196,354,723.24	4,853,757.71
physical read total multi block requests	343,047	189.95	4.70
physical reads	43,219,087	23,931.56	591.57
physical reads cache	46,096	25.52	0.63
physical reads cache prefetch	5,970	3.31	0.08
physical reads direct	43,172,991	23,906.04	590.94
physical reads direct (lob)	6	0.00	0.00
physical reads direct temporary tablespace	62	0.03	0.00
physical reads prefetch warmup	5,128	2.84	0.07
physical write IO requests	34,188	18.93	0.47
physical write bytes	364,314,624	201,730.74	4,986.65
physical write total IO requests	178,694	98.95	2.45
physical write total bytes	1,224,073,728	677,802.33	16,754.82
physical write total multi block requests	932	0.52	0.01
physical writes	44,472	24.63	0.61
physical writes direct	410	0.23	0.01
physical writes direct (lob)	25	0.01	0.00
physical writes direct temporary tablespace	62	0.03	0.00
physical writes from cache	44,062	24.40	0.60
physical writes non checkpoint	29,153	16.14	0.40
pinned buffers inspected	15	0.01	0.00
pinned cursors current	26	0.01	0.00
prefetch clients - default	14	0.01	0.00
prefetch warmup blocks aged out before use	146	0.08	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	1,813	1.00	0.02
queries parallelized	18	0.01	0.00
recovery blocks read	0	0.00	0.00
recursive calls	439,104	243.14	6.01
recursive cpu usage	23,501	13.01	0.32
redo KB read	424,979	235.32	5.82
redo blocks checksummed by FG (exclusive)	60,444	33.47	0.83
redo blocks written	385,098	213.24	5.27
redo buffer allocation retries	3	0.00	0.00
redo entries	577,132	319.57	7.90
redo log space requests	3	0.00	0.00
redo log space wait time	7	0.00	0.00
redo ordering marks	8,022	4.44	0.11
redo size	172,346,176	95,432.68	2,359.03
redo size for direct writes	1,884,300	1,043.39	25.79
redo subscn max counts	3,358	1.86	0.05
redo synch long waits	134	0.07	0.00
redo synch time	18,067	10.00	0.25
redo synch time (usec)	181,073,700	100,265.35	2,478.49
redo synch writes	65,335	36.18	0.89
redo wastage	18,272,480	10,117.96	250.11
redo write broadcast ack count	3,843	2.13	0.05
redo write broadcast ack time	133,265,973,726	73,792,930.42	1,824,111.99
redo write broadcast lgwr post count	2	0.00	0.00
redo write time	14,140	7.83	0.19
redo writes	69,611	38.55	0.95
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	530	0.29	0.01
rollbacks only - consistent read gets	1,509	0.84	0.02
rows fetched via callback	6,161,805	3,411.96	84.34
session connect time	0	0.00	0.00
session cursor cache hits	438,275	242.68	6.00
session logical reads	206,117,285	114,132.65	2,821.28
shared hash latch upgrades - no wait	869,273	481.34	11.90
shared hash latch upgrades - wait	195	0.11	0.00
sorts (memory)	334,688	185.33	4.58
sorts (rows)	102,155,954	56,566.48	1,398.29
sql area evicted	109,365	60.56	1.50
sql area purged	5	0.00	0.00
summed dirty queue length	5,042	2.79	0.07
switch current to new buffer	7,382	4.09	0.10
table fetch by rowid	117,057,665	64,817.96	1,602.26
table fetch continued row	2,527	1.40	0.03
table scan blocks gotten	110,089,413	60,959.45	1,506.88
table scan rows gotten	5,981,840,672	3,312,305.01	81,877.97
table scans (direct read)	43	0.02	0.00
table scans (long tables)	43	0.02	0.00
table scans (short tables)	72,059	39.90	0.99
temp space allocated (bytes)	2,097,152	1,161.25	28.71
total cf enq hold time	950	0.53	0.01
total number of cf enq holders	115	0.06	0.00
total number of times SMON posted	10	0.01	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	166	0.09	0.00
transaction tables consistent read rollbacks	9	0.00	0.00
transaction tables consistent reads - undo records applied	296	0.16	0.00
undo change vector size	59,700,784	33,057.92	817.17
user I/O wait time	62,061	34.36	0.85
user calls	5,133,581	2,842.60	70.27
user commits	65,962	36.52	0.90
user rollbacks	7,096	3.93	0.10
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	319,714	177.03	4.38
write clones created in background	0	0.00	0.00
write clones created in foreground	3	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	24,289,735,984	25,382,742,272
session pga memory max	46,747,853,936	48,916,271,872
session cursor cache count	354,110	372,540
session uga memory	38,702,974,106,920	40,390,941,024,928
opened cursors current	1,761	1,544
workarea memory allocated	0	1,770
logons current	318	331
session uga memory max	24,543,494,304	25,666,045,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)	1	1.99

Back to Instance Activity Statistics
Back to Top

IO Stats

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

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	329.4G	189.95	186.765	0M	0.02	0M	0
Others	529M	4.36	.292921	444M	1.25	.245854	8377	1.27
LGWR	0M	0.01	0M	377M	78.80	.208754	69.7K	1.46
Buffer Cache Reads	361M	22.71	.199895	0M	0.00	0M	40.1K	5.13
DBWR	0M	0.00	0M	344M	18.84	.190481	0
Direct Writes	0M	0.00	0M	3M	0.06	.001661	0
TOTAL:	330.3G	217.03	187.258	1.1G	98.96	.646752	118.2K	2.69

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	329.7G	212.94	186.966	350M	18.93	.193804	5.02	4.46
Log File	415M	0.24	.229796	377M	78.81	.208754	1.08	12.23
Archive Log	0M	0.00	0M	415M	0.23	.229796
Control File	110M	3.86	.060909	29M	1.02	.016058	1.09	26.00
Temp File	1M	0.00	.000553	1M	0.00	.000553		27.00
TOTAL:	330.3G	217.04	187.258	1.1G	99.00	.648967	4.46	4.47

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	329.4G	189.95	186.765	0M	0.02	0M	0
Direct Reads (Data File)	329.4G	189.95	186.765	0M	0.02	0M	0
Others	529M	4.36	.292921	444M	1.25	.245854	7465	1.28
Others (Archive Log)	0M	0.00	0M	415M	0.23	.229796	0
Others (Log File)	415M	0.23	.229796	0M	0.00	0M	7	0.14
Others (Control File)	110M	3.85	.060909	29M	1.01	.016058	6960	1.09
Others (Data File)	4M	0.28	.002214	0M	0.01	0M	498	3.86
LGWR	0M	0.01	0M	378M	78.84	.209308	23	1.09
LGWR (Log File)	0M	0.00	0M	377M	78.83	.208754	8	1.50
LGWR (Control File)	0M	0.01	0M	1M	0.01	.000553	15	0.87
Buffer Cache Reads	363M	22.73	.201002	0M	0.00	0M	40.1K	5.17
Buffer Cache Reads (Data File)	363M	22.73	.201002	0M	0.00	0M	40.1K	5.17
DBWR	0M	0.00	0M	344M	18.84	.190481	0
DBWR (Data File)	0M	0.00	0M	344M	18.84	.190481	0
Direct Writes	0M	0.00	0M	3M	0.06	.001661	0
Direct Writes (Data File)	0M	0.00	0M	3M	0.06	.001661	0
TOTAL:	330.3G	217.05	187.259	1.1G	99.01	.647306	47.6K	4.56

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
BPPF_EAS_DAT_B01	365,420	202	0.28	118.22	3,095	2	234	1.07
BPPF_EAS_IDX_B01	17,022	9	6.63	1.08	25,892	14	1,993	2.38
BPPF_BIS_DAT_A01	34	0	5.59	1.21	2,710	2	384	0.47
SYSAUX	362	0	2.98	1.04	810	0	0	0.00
SYSTEM	696	0	3.56	1.19	66	0	39	0.77
UNDOTBS1	3	0	0.00	1.00	751	0	80	0.00
BPPF_BIS_DAT_B01	200	0	4.45	1.35	533	0	13	3.08
BPPF_BIS_IDX_B01	192	0	3.85	1.17	198	0	194	3.51
BPPF_BIS_IDX_A01	28	0	7.50	1.07	53	0	117	0.09
USERS	57	0	6.67	1.00	8	0	0	0.00
BPPF_EAS_DAT_C01	38	0	0.00	1.00	10	0	0	0.00
BPPF_EAS_IDX_C01	19	0	0.00	1.00	5	0	0	0.00
BPPF_GOS_DAT_B01	2	0	0.00	1.00	14	0	0	0.00
BPPF_GOS_IDX_B01	6	0	5.00	1.00	7	0	0	0.00
BPPF_BAK_DAT	8	0	0.00	1.00	2	0	0	0.00
UNDOTBS2	3	0	0.00	1.00	3	0	259	1.16
TEMP	2	0	0.00	31.00	2	0	0	0.00
TS_MAINTAIN_DATA	2	0	0.00	1.00	1	0	0	0.00
BPPF_BIS_DAT_C01	1	0	0.00	1.00	1	0	0	0.00
BPPF_BIS_IDX_C01	1	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_A01	1	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_IDX_A01	1	0	0.00	1.00	1	0	0	0.00
BPPF_GOS_DAT_A01	1	0	0.00	1.00	1	0	0	0.00
BPPF_GOS_DAT_C01	1	0	0.00	1.00	1	0	0	0.00
BPPF_GOS_IDX_A01	1	0	0.00	1.00	1	0	0	0.00
BPPF_GOS_IDX_C01	1	0	0.00	1.00	1	0	0	0.00
BPPF_PGW_DAT	1	0	0.00	1.00	1	0	0	0.00
BPPF_PGW_IDX	1	0	0.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
BPPF_BAK_DAT	+DATA/bppfedb/datafile/bppf_bak_dat.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_BAK_DAT	+DATA/bppfedb/datafile/bppf_bak_dat_02.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_BIS_DAT_A01	+DATA/bppfedb/datafile/bppf_bis_dat_a01.270.785362165	34	0	5.59	1.21	2,710	2	384	0.47
BPPF_BIS_DAT_B01	+DATA/bppfedb/datafile/bppf_bis_dat_b01.272.785362187	7	0	10.00	3.43	28	0	7	1.43
BPPF_BIS_DAT_B01	+DATA/bppfedb/datafile/bppf_bis_dat_b02.dbf	87	0	4.25	1.29	159	0	1	10.00
BPPF_BIS_DAT_B01	+DATA/bppfedb/datafile/bppf_bis_dat_b03.dbf	29	0	4.48	1.00	107	0	0	0.00
BPPF_BIS_DAT_B01	+DATA/bppfedb/datafile/bppf_bis_dat_b04.dbf	77	0	4.16	1.36	239	0	5	4.00
BPPF_BIS_DAT_C01	+DATA/bppfedb/datafile/bppf_bis_dat_c01.274.785362353	1	0	0.00	1.00	1	0	0	0.00
BPPF_BIS_IDX_A01	+DATA/bppfedb/datafile/bppf_bis_idx_a01.271.785362175	28	0	7.50	1.07	53	0	117	0.09
BPPF_BIS_IDX_B01	+DATA/bppfedb/datafile/bppf_bis_idx_b01.273.785362309	192	0	3.85	1.17	198	0	194	3.51
BPPF_BIS_IDX_C01	+DATA/bppfedb/datafile/bppf_bis_idx_c01.275.785362493	1	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_A01	+DATA/bppfedb/datafile/bppf_eas_dat_a01.276.785362623	1	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b01.278.785362659	22,801	13	0.07	125.25	516	0	1	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b02.dbf	35,570	20	0.22	121.76	141	0	105	0.95
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b03.dbf	33,653	19	0.23	121.69	202	0	108	1.11
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b04.dbf	39,132	22	0.27	120.03	645	0	3	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b05.dbf	41,421	23	0.26	120.28	388	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b06.dbf	41,668	23	0.29	119.69	586	0	2	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b07.dbf	33,966	19	0.25	111.59	361	0	6	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b08.dbf	21,918	12	0.29	118.91	45	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b09.dbf	20,505	11	0.37	118.92	1	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b10.dbf	21,807	12	0.36	119.42	1	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b11.dbf	11,202	6	0.44	116.99	6	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b12.dbf	11,181	6	0.36	117.21	9	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b13.dbf	11,109	6	0.40	116.50	43	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b14.dbf	11,040	6	0.39	117.22	26	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b15.dbf	3,423	2	0.52	98.75	7	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b16.dbf	4,495	2	0.39	58.53	1	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b17.dbf	138	0	4.28	1.09	1	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b18.dbf	79	0	4.18	1.14	1	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b19.dbf	111	0	4.32	1.25	4	0	0	0.00
BPPF_EAS_DAT_B01	+DATA/bppfedb/datafile/bppf_eas_dat_b20.dbf	201	0	4.63	1.20	111	0	9	3.33
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01.280.785362683	1	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01_02.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01_03.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01_04.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01_05.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01_06.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01_08.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01_09.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01_10.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_DAT_C01	+DATA/bppfedb/datafile/bppf_eas_dat_c01_11.dbf	5	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_IDX_A01	+DATA/bppfedb/datafile/bppf_eas_idx_a01.277.785362641	1	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_bis_idx_b02.dbf	779	0	6.20	1.07	704	0	31	2.58
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01.279.785362673	233	0	8.15	1.02	284	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_02.dbf	213	0	7.56	1.05	226	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_03.dbf	198	0	7.07	1.04	196	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_04.dbf	204	0	6.37	1.06	201	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_05.dbf	108	0	9.81	1.05	88	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_06.dbf	124	0	8.15	1.00	72	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_07.dbf	399	0	7.09	1.01	382	0	39	2.82
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_08.dbf	514	0	7.59	1.06	533	0	34	1.76
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_09.dbf	665	0	6.83	1.09	711	0	76	4.08
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_10.dbf	1,068	1	6.31	1.09	1,476	1	150	1.60
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_11.dbf	872	0	6.64	1.09	1,084	1	148	3.58
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_12.dbf	1,266	1	6.71	1.09	2,010	1	115	2.78
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_13.dbf	1,211	1	6.41	1.09	2,190	1	138	1.96
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_14.dbf	1,242	1	5.78	1.10	1,454	1	96	2.81
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_15.dbf	790	0	6.94	1.09	1,876	1	116	2.24
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_16.dbf	885	0	7.04	1.14	1,594	1	150	1.47
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_17.dbf	1,241	1	6.70	1.11	2,220	1	226	2.70
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_18.dbf	469	0	6.87	1.06	757	0	66	1.52
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_19.dbf	315	0	6.70	1.05	456	0	47	1.06
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_20.dbf	296	0	7.36	1.07	407	0	45	1.56
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_21.dbf	523	0	7.40	1.14	790	0	142	2.82
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_22.dbf	257	0	8.13	1.02	316	0	87	4.37
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_23.dbf	277	0	7.04	1.04	336	0	9	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_24.dbf	312	0	7.31	1.09	660	0	25	1.20
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_25.dbf	307	0	5.34	1.08	735	0	5	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_26.dbf	202	0	6.68	1.05	277	0	14	1.43
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_27.dbf	603	0	3.85	1.12	868	0	6	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_28.dbf	187	0	7.01	1.06	380	0	1	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_29.dbf	212	0	6.13	1.08	589	0	81	2.96
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_30.dbf	88	0	6.02	1.08	150	0	1	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_31.dbf	116	0	7.41	1.06	200	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_32.dbf	121	0	7.27	1.10	183	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_33.dbf	111	0	6.04	1.07	139	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_34.dbf	77	0	5.06	1.00	158	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_35.dbf	64	0	8.13	1.08	98	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_36.dbf	57	0	7.02	1.00	62	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_37.dbf	59	0	7.29	1.02	71	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_38.dbf	58	0	6.72	1.09	65	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_39.dbf	54	0	5.74	1.07	101	0	49	0.41
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_40.dbf	59	0	6.95	1.07	169	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_41.dbf	83	0	7.35	1.02	336	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_42.dbf	14	0	3.57	1.00	79	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_43.dbf	5	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_44.dbf	9	0	5.56	1.00	3	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_45.dbf	5	0	0.00	1.00	5	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_46.dbf	5	0	0.00	1.00	2	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_47.dbf	9	0	2.22	1.00	5	0	0	0.00
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_48.dbf	49	0	6.53	1.08	190	0	96	1.67
BPPF_EAS_IDX_B01	+DATA/bppfedb/datafile/bppf_eas_idx_b01_49.dbf	7	0	1.43	1.00	3	0	0	0.00
BPPF_EAS_IDX_C01	+DATA/bppfedb/datafile/bppf_eas_idx_c01.281.785362693	1	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_IDX_C01	+DATA/bppfedb/datafile/bppf_eas_idx_c01_02.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_IDX_C01	+DATA/bppfedb/datafile/bppf_eas_idx_c01_03.dbf	4	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_IDX_C01	+DATA/bppfedb/datafile/bppf_eas_idx_c01_04.dbf	5	0	0.00	1.00	1	0	0	0.00
BPPF_EAS_IDX_C01	+DATA/bppfedb/datafile/bppf_eas_idx_c01_05.dbf	5	0	0.00	1.00	1	0	0	0.00
BPPF_GOS_DAT_A01	+DATA/bppfedb/datafile/bppf_gos_dat_a01.282.785362703	1	0	0.00	1.00	1	0	0	0.00
BPPF_GOS_DAT_B01	+DATA/bppfedb/datafile/bppf_gos_dat_b01.284.785362723	2	0	0.00	1.00	14	0	0	0.00
BPPF_GOS_DAT_C01	+DATA/bppfedb/datafile/bppf_gos_dat_c01.286.785362757	1	0	0.00	1.00	1	0	0	0.00
BPPF_GOS_IDX_A01	+DATA/bppfedb/datafile/bppf_gos_idx_a01.283.785362713	1	0	0.00	1.00	1	0	0	0.00
BPPF_GOS_IDX_B01	+DATA/bppfedb/datafile/bppf_gos_idx_b01.285.785362733	6	0	5.00	1.00	7	0	0	0.00
BPPF_GOS_IDX_C01	+DATA/bppfedb/datafile/bppf_gos_idx_c01.287.785362767	1	0	0.00	1.00	1	0	0	0.00
BPPF_PGW_DAT	+DATA/bppfedb/datafile/bppf_pgw_dat	1	0	0.00	1.00	1	0	0	0.00
BPPF_PGW_IDX	+DATA/bppfedb/datafile/bppf_pgw_idx	1	0	0.00	1.00	1	0	0	0.00
SYSAUX	+DATA/bppfedb/datafile/sysaux.261.785359287	50	0	5.80	1.26	439	0	0	0.00
SYSAUX	+DATA/bppfedb/datafile/sysaux01.dbf	286	0	1.99	1.00	233	0	0	0.00
SYSAUX	+DATA/bppfedb/datafile/sysaux02.dbf	26	0	8.46	1.12	138	0	0	0.00
SYSTEM	+DATA/bppfedb/datafile/system.260.785359279	691	0	3.56	1.19	61	0	39	0.77
SYSTEM	+DATA/bppfedb/datafile/system01.dbf	5	0	4.00	1.00	5	0	0	0.00
TEMP	+DATA/bppfedb/tempfile/temp.263.785359309	2	0	0.00	31.00	2	0	0
TS_MAINTAIN_DATA	+DATA/bppfedb/datafile/ts_maintain_data01.dbf	2	0	0.00	1.00	1	0	0	0.00
UNDOTBS1	+DATA/bppfedb/datafile/undotbs1.262.785359293	1	0	0.00	1.00	749	0	80	0.00
UNDOTBS1	+DATA/bppfedb/datafile/undotbs1_01.dbf	1	0	0.00	1.00	1	0	0	0.00
UNDOTBS1	+DATA/bppfedb/datafile/undotbs1_02.dbf	1	0	0.00	1.00	1	0	0	0.00
UNDOTBS2	+DATA/bppfedb/datafile/undotbs2.264.785359321	1	0	0.00	1.00	1	0	190	1.00
UNDOTBS2	+DATA/bppfedb/datafile/undotbs2_01.dbf	1	0	0.00	1.00	1	0	17	1.18
UNDOTBS2	+DATA/bppfedb/datafile/undotbs2_02.dbf	1	0	0.00	1.00	1	0	52	1.73
USERS	+DATA/bppfedb/datafile/users.265.785359339	57	0	6.67	1.00	8	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	5,837,671	100	162,858,075	46,101	44,046	0	0	3,315

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 44,472

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	37,704	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	2	8948	68710	370993	1698651	370993			1
E	0	4	14590	111120	384884	1698651	384884			2

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	4,864	0.10	575	7.02	42,150	1	126103.00
D	9,728	0.20	1,149	3.24	19,444	1	53702.00
D	14,592	0.30	1,724	1.10	6,581	1	12687.00
D	19,456	0.39	2,299	1.03	6,211	1	11509.00
D	24,320	0.49	2,873	1.02	6,138	1	11275.00
D	29,184	0.59	3,448	1.02	6,101	1	11156.00
D	34,048	0.69	4,023	1.00	6,031	1	10935.00
D	38,912	0.79	4,598	1.00	6,008	1	10862.00
D	43,776	0.89	5,172	1.00	6,008	1	10860.00
D	48,640	0.98	5,747	1.00	6,008	1	10860.00
D	49,408	1.00	5,838	1.00	6,008	1	10860.00
D	53,504	1.08	6,322	1.00	6,008	1	10860.00
D	58,368	1.18	6,896	1.00	6,008	1	10860.00
D	63,232	1.28	7,471	1.00	6,008	1	10860.00
D	68,096	1.38	8,046	1.00	6,008	1	10860.00
D	72,960	1.48	8,620	1.00	6,008	1	10860.00
D	77,824	1.58	9,195	1.00	6,008	1	10860.00
D	82,688	1.67	9,770	1.00	6,008	1	10860.00
D	87,552	1.77	10,344	1.00	6,008	1	10860.00
D	92,416	1.87	10,919	1.00	6,008	1	10860.00
D	97,280	1.97	11,494	0.97	5,825	1	10278.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
99.96	17,025	7

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	308,939	308,939	0
64K	128K	1,141	1,141	0
128K	256K	899	899	0
256K	512K	3,318	3,318	0
512K	1024K	2,666	2,666	0
1M	2M	849	849	0
2M	4M	426	424	2
4M	8M	1,114	1,114	0
8M	16M	357	357	0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd PGA Cache Hit %	Estd Time
5,280	0.13	141,538.04	100.00	45,656,679
10,560	0.25	141,538.04	100.00	45,656,679
21,120	0.50	141,538.04	100.00	45,656,679
31,680	0.75	141,538.04	100.00	45,656,679
42,240	1.00	141,538.04	100.00	45,656,679
50,688	1.20	141,538.04	100.00	45,656,679
59,136	1.40	141,538.04	100.00	45,656,679
67,584	1.60	141,538.04	100.00	45,656,679
76,032	1.80	141,538.04	100.00	45,656,679
84,480	2.00	141,538.04	100.00	45,656,679
126,720	3.00	141,538.04	100.00	45,656,679
168,960	4.00	141,538.04	100.00	45,656,679
253,440	6.00	141,538.04	100.00	45,656,679

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)
7,424	0.78	336	53,016	109,402	0.96	8,811	1.83	22,389
7,680	0.81	591	68,023	110,329	0.97	7,884	1.64	22,729
7,936	0.84	846	82,628	110,811	0.98	7,402	1.54	22,957
8,192	0.86	1,101	97,414	111,249	0.98	6,964	1.45	23,164
8,448	0.89	1,356	112,697	111,652	0.98	6,561	1.36	23,362
8,704	0.92	1,611	128,575	112,042	0.99	6,171	1.28	23,556
8,960	0.95	1,866	143,840	112,417	0.99	5,796	1.21	23,745
9,216	0.97	2,121	161,455	112,791	0.99	5,422	1.13	23,932
9,472	1.00	2,376	178,853	113,403	1.00	4,810	1.00	24,251
9,728	1.03	2,631	194,334	113,522	1.00	4,691	0.98	24,319
9,984	1.05	2,886	209,867	113,539	1.00	4,674	0.97	24,327
10,240	1.08	3,139	225,093	113,550	1.00	4,663	0.97	24,334
10,496	1.11	3,394	240,718	113,559	1.00	4,654	0.97	24,341
10,752	1.14	3,649	256,140	113,572	1.00	4,641	0.96	24,348
11,008	1.16	3,904	271,698	113,580	1.00	4,633	0.96	24,354
11,264	1.19	4,159	287,481	113,589	1.00	4,624	0.96	24,359
11,520	1.22	4,414	303,005	113,597	1.00	4,616	0.96	24,365
11,776	1.24	4,669	318,162	113,604	1.00	4,609	0.96	24,370
12,544	1.32	5,435	364,911	113,630	1.00	4,583	0.95	24,386
13,568	1.43	6,458	427,072	113,664	1.00	4,549	0.95	24,408
14,592	1.54	7,481	490,592	113,703	1.00	4,510	0.94	24,431
15,616	1.65	8,504	553,812	113,729	1.00	4,484	0.93	24,448
16,640	1.76	9,527	615,905	113,769	1.00	4,444	0.92	24,467
17,664	1.86	10,550	680,149	113,811	1.00	4,402	0.92	24,487
18,688	1.97	11,573	744,805	113,835	1.00	4,378	0.91	24,502
19,712	2.08	12,593	807,909	113,859	1.00	4,354	0.91	24,513

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
15,040	0.25	201,915	42,145,278
22,560	0.38	90,931	6,580,149
30,080	0.50	85,574	6,210,681
37,600	0.63	85,261	6,137,388
45,120	0.75	84,948	6,030,452
52,640	0.88	84,720	6,030,452
60,160	1.00	84,618	6,007,623
67,680	1.13	84,619	6,007,022
75,200	1.25	84,619	6,007,022
82,720	1.38	84,619	6,007,022
90,240	1.50	84,619	6,007,022
97,760	1.63	84,619	6,007,022
105,280	1.75	84,289	5,824,390
112,800	1.88	84,035	5,824,390
120,320	2.00	84,035	5,824,390

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
256	1.00	0	0	0	0
512	2.00	0	0	0	0
768	3.00	0	0	0	0
1,024	4.00	0	0	0	0
1,280	5.00	0	0	0	0
1,536	6.00	0	0	0	0
1,792	7.00	0	0	0	0
2,048	8.00	0	0	0	0
2,304	9.00	0	0	0	0
2,560	10.00	0	0	0	0
2,816	11.00	0	0	0	0
3,072	12.00	0	0	0	0
3,328	13.00	0	0	0	0
3,584	14.00	0	0	0	0
3,840	15.00	0	0	0	0
4,096	16.00	0	0	0	0
4,352	17.00	0	0	0	0
4,608	18.00	0	0	0	0
4,864	19.00	0	0	0	0
5,120	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	2,587	6	2
segment header	374	0	1
undo header	203	0	1
undo block	136	0	1
1st level bmb	12	0	0
2nd level bmb	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	323	323	0	253	4	17.27
TX-Transaction (index contention)	433	433	0	331	4	12.39
KO-Multiple Object Checkpoint (fast object checkpoint)	1,066	1,066	0	416	0	0.79
JQ-Job Queue	394	394	0	235	0	0.38
CF-Controlfile Transaction	4,092	4,092	0	59	0	0.51
FB-Format Block	67	67	0	33	0	0.61
TT-Tablespace	2,646	2,646	0	16	0	1.25
PS-PX Process Reservation	130	129	1	44	0	0.23
TM-DML	107,696	107,689	0	7	0	1.43
SQ-Sequence Cache	221	221	0	3	0	3.33
WF-AWR Flush	22	22	0	11	0	0.00
TA-Instance Undo	7	7	0	5	0	0.00
HW-Segment High Water Mark	1,393	1,393	0	4	0	0.00
TD-KTF map table enqueue (KTF dump entries)	5	5	0	4	0	0.00
AF-Advisor Framework (task serialization)	13	13	0	1	0	0.00
CR-Reuse Block Range (block range reuse ckpt)	6	6	0	1	0	0.00
DR-Distributed Recovery	1	1	0	1	0	0.00
JS-Job Scheduler (job run lock - synchronize)	1	1	0	1	0	0.00
PI-Remote PX Process Spawn Status	3	3	0	1	0	0.00
TO-Temp Object	14	14	0	1	0	0.00
TQ-Queue table enqueue (TM contention)	11	11	0	1	0	0.00
UL-User-defined	1	1	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	7.50	64,409	1,237	18	30698.6/31495.4	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
05-Mar 10:56	4,313	28,320	1,215	18	30,699	0/0	0/0/0/0/0/0
05-Mar 10:46	582	18,665	610	18	31,495	0/0	0/0/0/0/0/0
05-Mar 10:36	2,607	17,424	1,237	18	31,328	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
AQ dequeue txn counter latch	410	0.00		0
ASM Keyed state latch	620	0.16	0.00	0
ASM allocation	199	0.00		0
ASM db client latch	1,747	0.00		0
ASM map headers	39	0.00		0
ASM map load waiting list	10	0.00		0
ASM map operation freelist	1,439	3.54	0.00	0
ASM map operation hash table	1,161,585	0.00	0.00	0
ASM network background latch	875	0.00		0
ASM network state latch	295	0.00		0
AWR Alerted Metric Element list	23,281	0.00		0
Change Notification Hash table latch	601	0.00		0
Consistent RBA	69,620	0.00	0.00	0
DML lock allocation	10,382,222	0.00	0.00	0
Event Group Locks	1,055	0.00		0
FAL Queue	50	0.00		0
FIB s.o chain latch	10	0.00		0
FOB s.o list latch	5,823	1.00	0.00	0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC other latch	16	0.00		0
IPC stats buffer allocation latch	1,066	0.00		1,088	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	5	0.00		0
JS broadcast add buf latch	416	0.00		0
JS broadcast autostart latch	87	0.00		0
JS broadcast drop buf latch	416	0.00		0
JS broadcast load blnc latch	362	0.00		0
JS mem alloc latch	1	0.00		0
JS queue access latch	2	0.00		0
JS queue state obj latch	13,156	0.00		0
JS slv state obj latch	78	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KFK SGA Libload latch	580	0.00		0
KFMD SGA	2	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	18,056	0.22	0.00	10,394	0.00
KJCT flow control latch	523,865	0.01	0.00	0
KMG MMAN ready and startup request latch	601	0.00		0
KSXR large replies	122	0.00		0
KTF sga latch	16	0.00		587	0.00
KWQMN job cache list latch	193	0.00		0
KWQP Prop Status	2	0.00		0
KWQS pqsubs latch	3	0.00		0
KWQS pqueue ctx latch	46	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	4,391	0.66	0.00	0
MQL Tracking Latch	0			35	0.00
Memory Management Latch	1	0.00		601	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	1,241	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	1,514	0.00		0
OS process allocation	4,442	0.00		0
OS process: request allocation	620	0.00		0
PL/SQL warning settings	1,932	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	22,612	0.00		0
Reserved Space Latch	4	0.00		0
SGA IO buffer pool latch	1	0.00		1	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	61	0.00		600	0.00
SQL memory manager workarea list latch	203,248	0.00	0.00	0
Shared B-Tree	259	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	45,740	0.91	0.00	0
active service list	2,390,193	0.02	0.00	17,004	0.00
alert log latch	2	0.00		0
archive control	33	0.00		0
archive process latch	151	0.00		0
begin backup scn array	32	0.00		0
buffer pool	1	0.00		0
business card	37	0.00		0
cache buffer handles	9,654	0.00		0
cache buffers chains	300,241,983	0.11	0.00	443,941	0.01
cache buffers lru chain	176,481	0.01	0.08	536,725	0.01
cache table scan latch	25	0.00		25	0.00
call allocation	4,298	1.02	0.61	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	665	0.00		0
channel operations parent latch	707,871	0.00	0.00	0
checkpoint queue latch	1,885,121	0.00	0.00	87,985	0.00
client/application info	4,413	0.00		0
compile environment latch	738	0.00		0
corrupted undo seg latch	1,756	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	55	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	55	0.00		0
dml lock allocation	55	0.00		0
done queue latch	1	0.00		0
dummy allocation	1,465	0.82	0.00	0
enqueue freelist latch	1	0.00		274,301	0.00
enqueue hash chains	864,348	0.05	0.01	7	0.00
enqueues	98	0.00		0
error message lists	84	0.00		0
fifth spare latch	1	0.00		0
file cache latch	2,196	0.00		0
flashback copy	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	691,029	0.04	0.12	32,657	0.01
gcr global ctx	21	0.00		0
gcs commit scn state	1	0.00		0
gcs opaque info freelist	140,302	0.03	0.02	0
gcs partitioned table hash	3,728,172	0.01	0.00	75,590	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	16	0.00		0
gcs resource freelist	5,705	0.00		9,228	0.00
gcs resource hash	793,222	0.04	0.00	67	0.00
gcs resource scan list	159	0.00		0
gcs shadows freelist	71,899	0.01	0.00	32,260	0.00
ges caches resource lists	525,088	0.03	0.02	113,928	0.02
ges deadlock list	3,186	0.00		0
ges domain table	1,747,941	0.00	0.00	0
ges enqueue table freelist	3,256,651	0.01	0.00	0
ges group table	3,427,485	0.03	0.00	0
ges process hash list	97,363	0.00	0.25	0
ges process parent latch	6,658,058	0.00		0
ges process table freelist	620	0.00		0
ges resource hash list	6,902,127	0.03	0.06	36,849	0.00
ges resource scan list	1,705	0.00		0
ges resource table freelist	71,687	0.00	0.00	0
ges timeout list	11,560	0.00		249	0.00
ges value block free list	1,309,405	0.10	0.01	0
global KZLD latch for mem in SGA	224	0.00		0
global tx hash mapping	663,628	0.00	0.00	0
granule operation	1	0.00		0
hash table column usage latch	772	0.00		1,262,367	0.00
hash table modification latch	46	0.00		0
heartbeat check	1	0.00		591	0.00
heartbeat structure management	0			360	0.00
instance information	2,612	0.00		0
internal temp table object number allocation latch	79	0.00		0
interrupt manipulation	240	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	396	0.00		396	4.29
job_queue_processes free list latch	790	0.00		0
job_queue_processes parameter latch	789	0.00		0
k2q global data latch	33,592	0.00		0
k2q lock allocation	1,264,484	0.00	0.00	0
kcbtsemkid latch	1	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kgnfs mount latch	1	0.00		0
kokc descriptor allocation latch	276	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	1,125	0.00		0
ksim membership request latch	0			1,096	0.00
kss move lock	29	0.00		0
ksuosstats global area	183	0.00		0
ksv allocation latch	109	0.00		0
ksv class latch	4,622	0.00		0
ksv instance latch	94	0.00		0
ksv msg queue latch	29	0.00		28	0.00
ksxp shared latch	620	0.00		0
ksxp so latch	620	0.00		0
ksz_so allocation latch	620	0.32	0.00	0
ktm global data	56	0.00		0
kwqbsn:qsga	63	0.00		0
lgwr LWN SCN	70,145	0.02	0.00	0
list of block allocation	9,261	0.00		0
loader state object freelist	290	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	7	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	2	0.00		0
logminer work area	1	0.00		0
longop free list parent	43	0.00		42	0.00
managed standby latch	49	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	3,423	0.00		0
messages	716,285	0.18	0.01	0
mostly latch-free SCN	70,576	0.56	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	14,889	0.00		0
name-service memory objects	21,133	0.00		0
name-service namespace bucket	21,135	0.00		0
name-service namespace objects	2	0.00		0
name-service pending queue	11,474	0.00		0
name-service request	18	0.00		0
name-service request queue	31,632	0.00		0
ncodef allocation latch	55	0.00		0
object queue header heap	367,157	0.00		11,651	0.00
object queue header operation	1,278,766	0.01	0.01	0
object stats modification	113	0.00		0
parallel query alloc buffer	1,141	0.00		0
parallel query stats	82	0.00		0
parallel txn reco latch	10,933	0.00		0
parameter list	2,274	0.75	0.00	0
parameter table management	6,754	0.10	0.00	0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
policy information	14,366	0.04	0.00	0
post/wait queue	193,962	0.02	0.00	154,622	0.02
process allocation	9,403	0.31	1.41	316	0.00
process group creation	620	0.00		0
process queue	223	0.00		0
process queue reference	3,675	0.00		333	0.00
qmn state object latch	3	0.00		0
qmn task context latch	1	0.00		0
qmn task queue latch	265	0.00		0
query server freelists	181	0.00		0
query server process	19	0.00		3	0.00
queued dump request	6	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	282,072	0.06	0.01	576,490	0.24
redo copy	1	0.00		577,050	0.10
redo writing	256,016	0.08	0.04	0
reservation so alloc latch	2	0.00		0
resmgr group change latch	748	0.00		0
resmgr:active threads	1,465	0.00		0
resmgr:actses change group	696	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	1,464	0.75	0.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	11	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	25,459,044	0.26	0.00	722	0.69
rules engine rule set statistics	100	0.00		0
second Audit Vault latch	1	0.00		0
second spare latch	1	0.00		0
segmented array pool	10	0.00		0
sequence cache	416,095	0.09	0.01	0
session allocation	125,721	0.00	0.00	124,297	0.00
session idle bit	10,390,752	0.00	0.00	0
session queue latch	1	0.00		0
session state list latch	3,875	0.54	0.19	0
session switching	359	0.28	0.00	0
session timer	621	0.00		0
shared pool	6,368,785	0.14	0.20	0
shared pool sim alloc	1	0.00		0
shared pool simulator	424,348	0.01	0.39	0
sim partition latch	1	0.00		0
simulator hash latch	9,331,870	0.00	0.00	0
simulator lru latch	1	0.00		9,323,171	0.16
sort extent pool	195	0.00		0
space background state object latch	6	0.00		0
space background task latch	2,465	0.20	0.00	1,205	0.00
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	17	0.00		0
temporary table state object allocation	3	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	195	0.00		0
trace latch	16	0.00		0
transaction allocation	2,471,243	0.00	0.00	0
transaction branch allocation	640,545	0.02	0.00	0
undo global data	537,040	0.00	0.18	0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	300,241,983	334,393	322	334,075
row cache objects	25,459,044	67,390	55	67,336
shared pool	6,368,785	8,821	1,765	7,148
ges resource hash list	6,902,127	1,915	114	1,801
ges value block free list	1,309,405	1,363	15	1,348
messages	716,285	1,301	13	1,288
active service list	2,390,193	467	2	465
enqueue hash chains	864,348	440	3	437
active checkpoint queue latch	45,740	418	1	417
mostly latch-free SCN	70,576	396	1	395
sequence cache	416,095	391	2	389
gcs resource hash	793,222	326	1	325
gc element	691,029	256	31	225
redo writing	256,016	199	7	192
redo allocation	282,072	169	2	167
ges caches resource lists	525,088	139	3	136
object queue header operation	1,278,766	72	1	71
gcs opaque info freelist	140,302	45	1	44
call allocation	4,298	44	27	25
shared pool simulator	424,348	41	16	28
process allocation	9,403	29	41	1
session state list latch	3,875	21	4	17
cache buffers lru chain	176,481	12	1	11
undo global data	537,040	11	2	10
ges process hash list	97,363	4	1	3

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
active checkpoint queue latch	kcbbacq: scan active checkpoints	1	1
active service list	kswsite: service iterator	4	0
active service list	kswslogon: session logout	1	0
cache buffers chains	kcbgtcr: fast path (cr pin)	98	25
cache buffers chains	kcbgtcr: fast path	94	24
cache buffers chains	kcbget: fast exchange	57	45
cache buffers chains	kcbgcur_2	26	8
cache buffers chains	kcbchg1: mod cr pin	25	16
cache buffers chains	kcbzwb	23	37
cache buffers chains	kcbrls: fast release	18	14
cache buffers chains	kcbget: pin buffer	7	5
cache buffers chains	kcbgcur_4	6	9
cache buffers chains	kcbgtcr_2	5	42
cache buffers chains	kclbla	5	2
cache buffers chains	kcbget: fast path	4	3
cache buffers chains	kcbgtcr: kslbegin shared	4	4
cache buffers chains	kclcls_3	3	11
cache buffers chains	kcllkopesc	3	1
cache buffers chains	kcbchg1: clear MS bit	2	27
cache buffers chains	kcbnlc	2	6
cache buffers chains	kcbchg1: aux pin	1	0
cache buffers chains	kcbrls_2	1	33
cache buffers chains	kcbso1: set no access	1	6
cache buffers chains	kclwrt	1	0
cache buffers lru chain	kcbzgws	1	0
call allocation	ksuxds	24	23
call allocation	ksudlp: top call	3	4
enqueue hash chains	ksqcmi: if lk mode not requested	3	2
gc element	kclnfndnewm	33	5
gc element	kclbla	5	0
gc element	kclchkping	2	0
gc element	kclhngcbk1	2	0
gc element	kclnfnds	1	29
gc element	kclrwrite	1	1
gcs opaque info freelist	kjbrinfofree free opaque info	1	1
gcs resource hash	kjbopen	1	0
ges process hash list	kjakiqa: set inquiry response	1	0
ges resource hash list	kjakcai: search for resp by resname	62	2
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	27	2
ges resource hash list	kjrmas1: lookup master node	17	2
ges resource hash list	kjlrlr: remove lock from resource queue	5	54
ges resource hash list	kjakoca: search for resp by resname	3	44
ges resource table freelist	kjruch: cached obj cleanup	2	0
ges resource table freelist	kjchc: clean resource cache	1	0
ges value block free list	kjvblkgrow: allocation	8	8
ges value block free list	kjvblkfr: free	7	7
messages	ksarcv	9	2
messages	ksarcv: after wait	3	4
messages	ksaamb: after wakeup	1	7
mostly latch-free SCN	kcslcu3	1	1
object queue header operation	kcbo_link_q	1	0
process allocation	ksucrp:1	29	0
process allocation	ksuapc	11	41
process allocation	ksufap: active procs	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	2	0
redo writing	kcrfwcr	5	7
redo writing	kcrfw_cal_target_rba	1	1
redo writing	kcrfw_post: rba scn pair	1	0
row cache objects	kqreqd: reget	23	0
row cache objects	kqrpre: find obj	18	40
row cache objects	kqrso	8	4
row cache objects	kqreqd	4	11
sequence cache	kdnnxt: cached seq	1	0
sequence cache	kdnssd	1	0
session state list latch	kpseqd	3	0
session state list latch	kpscad	1	3
shared pool	kghalo	1,473	784
shared pool	kghalp	225	384
shared pool	kghupr1	31	518
shared pool	kgh_heap_sizes	12	46
shared pool	kghfre	12	19
shared pool	kghasp	10	13
shared pool	kghfrunp: alloc: wait	2	0
shared pool	kghfrunp: clatch: nowait	2	0
shared pool simulator	kglsim_upd_newhp	16	5
undo global data	ktudba: KSLBEGIN	2	2

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglget1 1	247
Library Cache	kglhdgn2 106	227
Library Cache	kgllkdl1 85	208
Cursor Pin	kkslce [KKSCHLPIN2]	183
Library Cache	kglpnal2 91	176
Library Cache	kglpin1 4	121
Library Cache	kglpndl1 95	91
Library Cache	kgldtin1 42	88
Library Cache	kglhdgn1 62	71
Library Cache	kgllkal1 80	53
Library Cache	kglobpn1 71	49
Library Cache	kglpnal1 90	35
Library Cache	kglhdgh1 64	34
Library Cache	kgllkc1 57	34
Library Cache	kglget2 2	33
Library Cache	kglrfcl1 79	13
Cursor Pin	kksLockDelete [KKSCHLPIN6]	5
Cursor Pin	kksfbc [KKSCHLFSP2]	1
Cursor Pin	kksfbc [KKSCHLPIN1]	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: 206,117,285
Captured Segments account for 97.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
BPPF_EAS	BPPF_EAS_DAT_B01	T_SCS_ORDER	TABLE	54,427,712	26.41
BPPF_BIS	BPPF_BIS_DAT_A01	T_SYM_OPERLOG	TABLE	45,149,776	21.90
BPPF_EAS	BPPF_EAS_DAT_B01	T_EBK_DEALLOG	TABLE	15,565,232	7.55
BPPF_BIS	BPPF_BIS_DAT_B01	T_CUM_INFO	TABLE	11,006,880	5.34
BPPF_BIS	BPPF_BIS_IDX_B01	IX_CUM_INFO_ORGID	INDEX	9,661,632	4.69

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.97	In-memory Sort %:	100.00
Library Hit %:	86.77	Soft Parse %:	89.19
Execute to Parse %:	0.60	Latch Hit %:	99.90
Parse CPU to Parse Elapsd %:	106.14	% Non-Parse CPU:	90.88

Buffer access - local cache %:	99.92
Buffer access - remote cache %:	0.05
Buffer access - disk %:	0.03

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.7
Avg global cache current block receive time (ms):	0.7
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 %:	9.5
Avg global cache cr block flush time (ms):	3.7
Avg global cache current block pin time (ms):	1,338.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	1.2
Avg global cache current block flush time (ms):	16,420.9

Avg message sent queue time (ms):	0.3
Avg message sent queue time on ksxp (ms):	0.7
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	80.09
% of indirect sent messages:	19.56
% of flow controlled messages:	0.35

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
BPPF_EAS	BPPF_EAS_IDX_B01	IX_SCS_ORDER_FULLQUERY	INDEX	3,149	7.08
BPPF_BIS	BPPF_BIS_DAT_A01	T_SYM_STAFF	TABLE	2,390	5.37
BPPF_EAS	BPPF_EAS_IDX_B01	IX_SCS_ACTATTR_REVORD	INDEX	2,301	5.17
BPPF_EAS	BPPF_EAS_IDX_B01	IX_EBK_DEALLOG_ACCTCODE	INDEX	1,989	4.47
BPPF_EAS	BPPF_EAS_DAT_B01	T_EBK_ACCTINFO	TABLE	1,317	2.96

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
BPPF_BIS	BPPF_BIS_IDX_A01	T_SYM_SCRAND_PK	INDEX	23,152	6.52
BPPF_EAS	BPPF_EAS_DAT_B01	T_SCS_ORDER	TABLE	21,712	6.11
BPPF_EAS	BPPF_EAS_IDX_B01	IX_SCS_ORDER_FULLQUERY	INDEX	18,624	5.24
BPPF_EAS	BPPF_EAS_IDX_B01	IX_SCS_ORDER_STAT	INDEX	13,520	3.81
BPPF_EAS	BPPF_EAS_IDX_B01	IX_SCS_ACTATTR_ACTLISTID	INDEX	13,312	3.75

Owner	Tablespace Name	Object Name	Obj. Type	GC Buffer Busy	% of Capture
BPPF_BIS	BPPF_BIS_DAT_A01	T_SYM_CER	TABLE	332	15.31
BPPF_EAS	BPPF_EAS_IDX_B01	PK_T_SCS_ORDER	INDEX	211	9.73
BPPF_EAS	BPPF_EAS_DAT_B01	T_EBK_ACCTINFO	TABLE	178	8.21
BPPF_BIS	BPPF_BIS_IDX_B01	PK_T_INF_DCOPERLOG	INDEX	114	5.26
BPPF_EAS	BPPF_EAS_IDX_B01	IX_SCS_ACTFEE_ORDERID	INDEX	85	3.92

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	34	0.00	2	1
dc_files	714	0.00	0	119
dc_global_oids	3,605	0.11	0	34
dc_histogram_data	2,361,492	0.04	0	2,950
dc_histogram_defs	3,287,716	0.09	4	2,630
dc_object_grants	109	0.00	0	9
dc_objects	2,297,908	0.09	3	1,580
dc_profiles	1,236	0.00	0	3
dc_rollback_segments	251,361	0.00	0	843
dc_segments	964,595	0.07	4	884
dc_sequences	218	38.99	218	19
dc_tablespaces	228,626	0.00	0	29
dc_users	655,606	0.00	1	105
global database name	2,991	0.00	0	1
outstanding_alerts	77	100.00	0	25
sch_lj_oids	1	100.00	0	0

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	448	1.34	0		0	0
APP CONTEXT	653	0.00	2,034	0.00	0	0
BODY	5,626	0.50	6,575	0.50	3	0
CLUSTER	58	1.72	58	1.72	0	0
DBLINK	2,258	0.49	0		0	0
EDITION	661	0.00	1,279	0.00	0	0
INDEX	135	17.78	135	17.78	0	0
OBJECT ID	1	100.00	0		0	0
QUEUE	445	0.00	556	0.18	1	0
SCHEMA	1,082	0.09	0		0	0
SQL AREA	557,410	17.52	2,144,780	14.72	5,688	6
SQL AREA BUILD	108,398	94.83	0		0	0
SQL AREA STATS	107,985	93.15	107,985	93.15	0	0
SUBSCRIPTION	8	12.50	8	12.50	0	0
TABLE/PROCEDURE	166,780	0.13	896,481	0.18	897	0
TRANSFORMATION	175	0.00	175	0.00	0	0
TRIGGER	142	11.27	166	10.24	1	0

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
ACCOUNT_STATUS	448	0	0
BODY	0	6,517	6,517
CLUSTER	58	58	58
DBLINK	2,258	0	0
EDITION	661	661	661
INDEX	135	135	135
QUEUE	211	556	556
SCHEMA	619	0	0
SUBSCRIPTION	0	8	8
TABLE/PROCEDURE	247,286	496,778	496,778
TRANSFORMATION	175	175	175
TRIGGER	0	166	166

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	49,408.00	49,408.00	49,408.00	49,408.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	42,240.00	42,240.00	42,240.00	42,240.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	60,160.00	60,160.00	60,160.00	60,160.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	256.00	256.00	256.00	256.00	STA/
large pool	256.00	256.00	256.00	256.00	STA/
shared pool	9,472.00	9,472.00	9,472.00	9,472.00	STA/
streams pool	256.00	256.00	256.00	256.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	1,208.74		3.75	4.84	44	44	322	322
B	Freeable	179.44	0.00	0.75	0.80	10		239	239
B	PL/SQL	26.65	15.98	0.08	0.04	0	2	320	318
B	SQL	4.68	0.63	0.02	0.02	0	663	285	275
E	Other	1,223.03		3.65	4.78	44	44	335	335
E	Freeable	179.56	0.00	0.76	0.81	10		237	237
E	PL/SQL	27.98	16.50	0.08	0.04	0	0	333	331
E	SQL	7.78	4.17	0.03	0.21	4	201	295	285

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	51,808,043,008
Fixed Size	2,240,984
Redo Buffers	55,267,328
Variable Size	55,029,272,104

Pool	Name	Begin MB	End MB	% Diff
java	free memory	256.00	256.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	247.81	247.81	0.00
shared	ASH buffers	96.00	96.00	0.00
shared	KGLH0	1,342.28	1,325.71	-1.23
shared	KGLHD	195.44	191.11	-2.21
shared	SQLA	1,802.52	1,808.63	0.34
shared	db_block_hash_buckets	356.00	356.00	0.00
shared	free memory	2,623.91	2,639.25	0.58
shared	gc name table	144.00	144.00	0.00
shared	gcs resources	1,293.39	1,293.39	0.00
shared	gcs shadows	754.48	754.48	0.00
shared	kglsim object batch	97.51	97.51	0.00
streams	free memory	256.00	256.00	0.00
	buffer_cache	49,408.00	49,408.00	0.00
	fixed_sga	2.14	2.14	0.00
	log_buffer	52.71	52.71	0.00

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	0304 18:07:39	0.08	0.00	0.00
QMON Slaves	0304 18:07:40	0.07	-0.00	0.00

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(12733)	0	0			0.00	0.00
SYS.AQ$_ALERT_QT_E(12732)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(69070)	34	34	0.00	0.00	0.02	0.03	0.00	0.00

Subscriber/Queue	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
BPPFEDB1_3938_BPPFEDB1(22)/SYS.ALERT_QUE	0.00	0.00	0.00
BPPFEDB2_3938_BPPFEDB2(42)/SYS.ALERT_QUE	0.00	0.00	0.00
HAE_SUB(1)/SYS.ALERT_QUE

Name	Total Disp Time (s)	%Busy	%Idle
D000	1,805	0.00	100.00
D000	1,805	0.00	100.00
D000	1,805	0.00	100.00
D000	1,805	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	/oracle/app/oracle/admin/bppfedb/adump
audit_trail	NONE
cluster_database	TRUE
compatible	11.2.0.0.0
control_files	+DATA/bppfedb/controlfile/current.256.785359263, +FRA/bppfedb/controlfile/current.256.785359265
db_block_size	8192
db_create_file_dest	+DATA
db_domain
db_name	bppfedb
db_recovery_file_dest	+FRA
db_recovery_file_dest_size	161061273600
diagnostic_dest	/oracle/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=bppfedbXDB)
instance_number	1
job_queue_processes	1000
local_listener	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=132.97.122.3)(PORT=1521))))
memory_max_target	107374182400
memory_target	107374182400
open_cursors	300
processes	2000
remote_listener	(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=132.97.122.5)(PORT=1523)))
remote_login_passwordfile	NONE
sessions	3024
spfile	+DATA/bppfedb/spfilebppfedb.ora
thread	1
undo_tablespace	UNDOTBS1

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	26,461	14.65	0.36
acks for commit broadcast(logical)	28,927	16.02	0.40
broadcast msgs on commit(actual)	67,484	37.37	0.92
broadcast msgs on commit(logical)	69,594	38.54	0.95
broadcast msgs on commit(wasted)	2,020	1.12	0.03
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	35,874	19.86	0.49
gcs ast xid	43	0.02	0.00
gcs blocked converts	60,924	33.74	0.83
gcs blocked cr converts	38,770	21.47	0.53
gcs compatible basts	818	0.45	0.01
gcs compatible cr basts (global)	5,985	3.31	0.08
gcs compatible cr basts (local)	11,196	6.20	0.15
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	5,103	2.83	0.07
gcs dbwr write request msgs	3,498	1.94	0.05
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	87	0.05	0.00
gcs force cr grant	460	0.25	0.01
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	2,291	1.27	0.03
gcs immediate (null) converts	10,148	5.62	0.14
gcs immediate cr (compatible) converts	9,422	5.22	0.13
gcs immediate cr (null) converts	2,757	1.53	0.04
gcs indirect ast	13,038	7.22	0.18
gcs indirect bidless ast	367	0.20	0.01
gcs indirect fg ast	12,671	7.02	0.17
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	1,828	1.01	0.03
gcs msgs process time(ms)	16,029	8.88	0.22
gcs msgs received	381,667	211.34	5.22
gcs new served by master	532	0.29	0.01
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	115	0.06	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	79	0.04	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	44	0.02	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	10,282	5.69	0.14
gcs side channel msgs logical	99,371	55.02	1.36
gcs stale cr	1	0.00	0.00
gcs undo cr	1,690	0.94	0.02
gcs write notification msgs	609	0.34	0.01
gcs writes refused	185	0.10	0.00
ges msgs process time(ms)	1,880	1.04	0.03
ges msgs received	84,033	46.53	1.15
global posts dropped	0	0.00	0.00
global posts queue time	57	0.03	0.00
global posts queued	33	0.02	0.00
global posts requested	34	0.02	0.00
global posts sent	33	0.02	0.00
implicit batch messages received	16,827	9.32	0.23
implicit batch messages sent	2,269	1.26	0.03
lmd msg send time(ms)	464	0.26	0.01
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	939	0.52	0.01
messages queue sent actual	58,302	32.28	0.80
messages queue sent logical	15,965	8.84	0.22
messages received actual	404,979	224.25	5.54
messages received logical	465,704	257.87	6.37
messages sent directly	217,140	120.24	2.97
messages sent indirectly	53,043	29.37	0.73
messages sent not implicit batched	14	0.01	0.00
messages sent pbatched	68,290	37.81	0.93
msgs causing lmd to send msgs	41,028	22.72	0.56
msgs causing lms(s) to send msgs	10,703	5.93	0.15
msgs received queue time (ms)	6,254	3.46	0.09
msgs received queued	465,703	257.87	6.37
msgs sent queue time (ms)	19,198	10.63	0.26
msgs sent queue time on ksxp (ms)	220,476	122.08	3.02
msgs sent queued	70,818	39.21	0.97
msgs sent queued on ksxp	303,306	167.95	4.15
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	93,975	52.04	1.29
process batch messages sent	56,382	31.22	0.77

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

Statistic	Total
CR Block Requests	28,149
CURRENT Block Requests	9,869
Data Block Requests	28,149
Undo Block Requests	838
TX Block Requests	4,705
Current Results	35,083
Private results	1,179
Zero Results	1,755
Disk Read Results	1
Fail Results	0
Fairness Down Converts	12,285
Fairness Clears	3,813
Free GC Elements	0
Flushes	3,623
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	2,183
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	989	2.63	68.25	29.12	0.00	0.00
Flushes	1,502	45.54	40.68	13.12	0.67	0.00
Writes	4,971	47.60	45.50	1.77	0.30	4.83

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	22,724	82.40	15.95	1.65	47,299	92.95	5.12	1.93
2	undo header	8,456	96.11	2.25	1.64	396	97.22	0.51	2.27
2	Others	4,623	98.14	0.00	1.86	2,391	97.99	0.42	1.59
2	undo block	862	64.27	34.57	1.16	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.83	0.50	2.57	0.55	0.73	0.50	4.85	0.82
2	undo header	0.44	0.38	3.09	0.38	0.49	0.48	1.73	0.51
2	others	0.49	0.49		0.50	0.45	0.45	1.81	0.47
2	undo block	1.16	0.45	2.50	0.47

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	18,725	100.00	0.00	43,966	100.00	0.00
2	undo header	0	8,127	100.00	0.00	385	100.00	0.00
2	others	0	4,537	100.00	0.00	2,343	100.00	0.00
2	undo block	0	554	100.00	0.00	0

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.63	0.30
Parallel Query	0.00	0.00
DB Locks	0.04	0.06
DB Streams	0.00	0.00
Other	0.00	0.01