WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DCPOS 3752968640 dcpos 1 13-Mar-13 20:03 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
DCPOS	3752968640	dcpos	1	13-Mar-13 20:03	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

chnap-itd101 Linux x86 64-bit 80 40 4 504.14

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
chnap-itd101	Linux x86 64-bit	80	40	4	504.14

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 2227 18-Mar-13 10:00:05 38 1.9

End Snap: 2230 18-Mar-13 13:00:13 122 1.3

Elapsed: 180.14 (mins)

DB Time: 302.21 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2227	18-Mar-13 10:00:05	38	1.9
End Snap:	2230	18-Mar-13 13:00:13	122	1.3
Elapsed:		180.14 (mins)
DB Time:		302.21 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 28,160M 28,160M Std Block Size: 8K

Shared Pool Size: 15,360M 15,360M Log Buffer: 444,868K

	Begin	End
Buffer Cache:	28,160M	28,160M	Std Block Size:	8K
Shared Pool Size:	15,360M	15,360M	Log Buffer:	444,868K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 1.7 177.8 1.18 2.15

DB CPU(s): 1.1 117.1 0.78 1.42

Redo size: 1,083.4 114,798.4

Logical reads: 23,733.4 2,514,944.7

Block changes: 3.5 373.6

Physical reads: 15,469.7 1,639,265.1

Physical writes: 60.8 6,446.2

User calls: 0.8 82.5

Parses: 0.9 92.0

Hard parses: 0.0 1.5

W/A MB processed: 0.1 6.4

Logons: 0.1 6.9

Executes: 1.4 150.0

Rollbacks: 0.0 0.0

Transactions: 0.0

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.7	177.8	1.18	2.15
DB CPU(s):	1.1	117.1	0.78	1.42
Redo size:	1,083.4	114,798.4
Logical reads:	23,733.4	2,514,944.7
Block changes:	3.5	373.6
Physical reads:	15,469.7	1,639,265.1
Physical writes:	60.8	6,446.2
User calls:	0.8	82.5
Parses:	0.9	92.0
Hard parses:	0.0	1.5
W/A MB processed:	0.1	6.4
Logons:	0.1	6.9
Executes:	1.4	150.0
Rollbacks:	0.0	0.0
Transactions:	0.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.99

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

Library Hit %: 98.63 Soft Parse %: 98.37

Execute to Parse %: 38.72 Latch Hit %: 99.98

Parse CPU to Parse Elapsd %: 6.41 % Non-Parse CPU: 99.85

Shared Pool Statistics

Begin End

Memory Usage %: 0.91 0.99

% SQL with executions>1: 98.99 98.90

% Memory for SQL w/exec>1: 95.36 94.30

	Begin	End
Memory Usage %:	0.91	0.99
% SQL with executions>1:	98.99	98.90
% Memory for SQL w/exec>1:	95.36	94.30

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		11,940		65.85
db file sequential read	2,233,356	3,415	2	18.83	User I/O
direct path read	10,973,301	3,412	0	18.82	User I/O
direct path write temp	19,058	831	44	4.59	User I/O
cursor: pin S wait on X	478	267	559	1.47	Concurrency

Host CPU (CPUs: 80 Cores: 40 Sockets: 4)

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

1.49 2.25 2.3 0.6 0.7 97.0

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.49	2.25	2.3	0.6	0.7	97.0

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

1.4 46.5 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 516,236.3 516,236.3

SGA use (MB): 49,152.0 49,152.0

PGA use (MB): 169.7 4,417.2

% Host Mem used for SGA+PGA: 9.55 10.38

	Begin	End
Host Mem (MB):	516,236.3	516,236.3
SGA use (MB):	49,152.0	49,152.0
PGA use (MB):	169.7	4,417.2
% Host Mem used for SGA+PGA:	9.55	10.38

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): 18132.6s
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	17,762.21	97.96
DB CPU	11,940.22	65.85
parse time elapsed	294.75	1.63
hard parse elapsed time	16.01	0.09
hard parse (sharing criteria) elapsed time	10.26	0.06
failed parse elapsed time	2.66	0.01
PL/SQL compilation elapsed time	0.65	0.00
PL/SQL execution elapsed time	0.31	0.00
connection management call elapsed time	0.16	0.00
repeated bind elapsed time	0.00	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
sequence load elapsed time	0.00	0.00
DB time	18,132.64
background elapsed time	1,594.34
background cpu time	121.93

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	2,594,216
IDLE_TIME	83,588,669
IOWAIT_TIME	600,888
NICE_TIME	258
SYS_TIME	495,327
USER_TIME	1,969,726
LOAD	1	2
PHYSICAL_MEMORY_BYTES	541,312,974,848
NUM_CPUS	80
NUM_CPU_CORES	40
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
18-Mar 10:00:05	1.49
18-Mar 11:00:08	1.94	2.42	1.73	0.53	97.58	1.57
18-Mar 12:00:10	2.12	3.37	2.59	0.64	96.63	0.36
18-Mar 13:00:13	2.25	3.24	2.54	0.56	96.76	0.17

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 109.8% of Total DB time 18,132.64 (s)
Total FG Wait Time: 7,975.03 (s) DB CPU time: 11,940.22 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			11,940		65.85
User I/O	13,317,657	0	7,677	1	42.34
Concurrency	4,357	0	287	66	1.58
Other	20,238	86	10	0	0.05
Application	9	0	1	114	0.01
Commit	33	0	0	4	0.00
Network	5,129	0	0	0	0.00
Configuration	0		0		0.00
System I/O	0		0		0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
db file sequential read	2,233,356	0	3,415	2	21,895.65	18.83
direct path read	10,973,301	0	3,412	0	107,581.38	18.82
direct path write temp	19,058	0	831	44	186.84	4.59
cursor: pin S wait on X	478	0	267	559	4.69	1.47
library cache: mutex X	3,144	0	13	4	30.82	0.07
direct path read temp	84,520	0	8	0	828.63	0.05
Disk file operations I/O	4,487	0	8	2	43.99	0.05
os thread startup	160	0	6	37	1.57	0.03
PX Deq: Slave Session Stats	424	0	3	7	4.16	0.02
latch: parallel query alloc buffer	1,568	0	3	2	15.37	0.02
enq: BF - allocation contention	110	0	2	16	1.08	0.01
read by other session	155	0	1	7	1.52	0.01
enq: PS - contention	13	0	1	81	0.13	0.01
enq: KO - fast object checkpoint	2	0	1	509	0.02	0.01
library cache lock	5	0	1	148	0.05	0.00
db file scattered read	2,774	0	1	0	27.20	0.00
kksfbc child completion	7	100	0	51	0.07	0.00
latch free	353	0	0	1	3.46	0.00
latch: cache buffers chains	332	0	0	1	3.25	0.00
latch: shared pool	199	0	0	1	1.95	0.00
db file parallel read	6	0	0	21	0.06	0.00
log file sync	33	0	0	4	0.32	0.00
PX qref latch	4,297	100	0	0	42.13	0.00
asynch descriptor resize	12,862	100	0	0	126.10	0.00
latch: call allocation	20	0	0	2	0.20	0.00
PX Deq: Signal ACK EXT	97	0	0	0	0.95	0.00
SQL*Net message to client	5,128	0	0	0	50.27	0.00
PX Deq: Signal ACK RSG	323	53	0	0	3.17	0.00
latch: row cache objects	37	0	0	0	0.36	0.00
latch: object queue header operation	128	0	0	0	1.25	0.00
latch: undo global data	19	0	0	0	0.19	0.00
SQL*Net break/reset to client	7	0	0	1	0.07	0.00
latch: enqueue hash chains	11	0	0	0	0.11	0.00
latch: cache buffers lru chain	4	0	0	0	0.04	0.00
reliable message	2	0	0	1	0.02	0.00
PX Deq: Execution Msg	208,326	81	340,209	1633	2,042.41
PX Deq Credit: send blkd	274,157	28	277,219	1011	2,687.81
SQL*Net message from client	5,125	0	18,746	3658	50.25
PX Deq: Table Q Normal	636,269	0	10,486	16	6,237.93
jobq slave wait	2,880	100	1,443	501	28.24
PX Deq: Execute Reply	9,260	1	392	42	90.78
PX Deq Credit: need buffer	41,619	0	228	5	408.03
PX Deq: Parse Reply	436	0	7	15	4.27
PX Deq: Join ACK	198	0	0	0	1.94
PX Deq: Msg Fragment	22	0	0	0	0.22

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
db file async I/O submit	2,128	0	1,425	670	20.86	89.41
control file parallel write	3,742	0	67	18	36.69	4.18
Disk file operations I/O	10,406	0	20	2	102.02	1.28
db file single write	481	0	4	8	4.72	0.26
os thread startup	89	0	4	45	0.87	0.25
log file parallel write	1,562	0	2	1	15.31	0.11
latch: call allocation	174	0	1	7	1.71	0.08
latch free	235	0	1	3	2.30	0.04
db file sequential read	2,640	0	1	0	25.88	0.04
control file sequential read	18,818	0	0	0	184.49	0.03
direct path sync	5	0	0	45	0.05	0.01
wait list latch free	8	0	0	11	0.08	0.01
latch: shared pool	74	0	0	1	0.73	0.00
log file switch completion	2	0	0	25	0.02	0.00
log file sync	6	0	0	5	0.06	0.00
latch: cache buffers lru chain	25	0	0	1	0.25	0.00
ADR block file read	39	0	0	0	0.38	0.00
latch: object queue header operation	143	0	0	0	1.40	0.00
db file scattered read	33	0	0	0	0.32	0.00
latch: cache buffers chains	5	0	0	2	0.05	0.00
LGWR wait for redo copy	40	0	0	0	0.39	0.00
asynch descriptor resize	355	100	0	0	3.48	0.00
ADR block file write	15	0	0	0	0.15	0.00
latch: parallel query alloc buffer	5	0	0	1	0.05	0.00
direct path write	26	0	0	0	0.25	0.00
log file single write	2	0	0	1	0.02	0.00
rdbms ipc message	78,112	99	225,429	2886	765.80
PX Idle Wait	40,059	98	79,569	1986	392.74
DIAG idle wait	21,565	100	21,586	1001	211.42
dispatcher timer	181	100	10,861	60003	1.77
Streams AQ: qmn coordinator idle wait	1,104	35	10,811	9792	10.82
Streams AQ: qmn slave idle wait	646	0	10,811	16735	6.33
Space Manager: slave idle wait	2,174	99	10,806	4971	21.31
pmon timer	3,670	98	10,805	2944	35.98
smon timer	43	84	10,803	251234	0.42
shared server idle wait	360	100	10,801	30004	3.53
SQL*Net message from client	40	0	0	3	0.39
class slave wait	41	0	0	0	0.40

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	39	100.0
ADR block file write	15	100.0
ADR file lock	18	100.0
Disk file operations I/O	14.9K	1.3	56.8	41.7	.2
LGWR wait for redo copy	40	97.5	2.5
PX Deq: Signal ACK EXT	97	93.8	6.2
PX Deq: Signal ACK RSG	323	100.0
PX Deq: Slave Session Stats	422	6.9	6.4	19.2	33.2	26.1	8.3
PX qref latch	4297	99.7	.2	.1	.0		.0
SQL*Net break/reset to client	7	85.7			14.3
SQL*Net message to client	5157	100.0
SQL*Net more data to client	1	100.0
asynch descriptor resize	13.2K	100.0
control file parallel write	3743		3.9	15.4	16.4	18.1	28.2	18.0
control file sequential read	18.8K	100.0		.0	.0	.0	.0
cursor: mutex S	1	100.0
cursor: pin S	1	100.0
cursor: pin S wait on X	478					.2		98.5	1.3
db file async I/O submit	2129	1.0	3.4	4.9	10.1	14.2	14.5	43.1	8.8
db file parallel read	6	16.7	50.0				16.7	16.7
db file scattered read	2807	98.2	1.4	.3	.0			.0
db file sequential read	2234.5K	87.5	.8	1.6	3.5	3.9	2.2	.5
db file single write	481	12.9	15.0	13.5	12.7	25.6	20.2	.2
direct path read	11M	95.6	4.0	.1	.0	.0	.0	.2
direct path read temp	84.5K	99.9	.0	.0	.0	.0	.0	.0
direct path sync	5					20.0	20.0	60.0
direct path write	26	100.0
direct path write temp	19.1K	.1	1.0	7.8	13.2	17.3	22.4	38.1
enq: BF - allocation contention	110	4.5	8.2	7.3	4.5	38.2	32.7	4.5
enq: KO - fast object checkpoint	2							100.0
enq: PS - contention	13	46.2	23.1	7.7	7.7	7.7		7.7
kksfbc child completion	7							100.0
latch free	588	60.2	11.2	13.1	13.6	1.9
latch: cache buffers chains	336	80.4	13.1	5.4	1.2
latch: cache buffers lru chain	29	82.8	10.3		3.4	3.4
latch: call allocation	194	30.4	3.6	2.1	11.3	52.6
latch: enqueue hash chains	11	100.0
latch: object queue header operation	271	98.9	.7	.4
latch: parallel query alloc buffer	1571	51.5	22.2	12.5	11.5	2.2	.1
latch: row cache objects	37	86.5	10.8	2.7
latch: shared pool	273	73.3	12.1	8.8	5.9
latch: undo global data	19	100.0
library cache lock	5			20.0	20.0			60.0
library cache: mutex X	3141	64.5	6.0	5.8	6.4	8.2	6.9	2.2
log file parallel write	1564	78.3	13.2	3.1	1.7	2.3	1.3	.1
log file sequential read	2	100.0
log file single write	2	50.0	50.0
log file switch completion	2						50.0	50.0
log file sync	39	43.6	28.2	7.7	10.3	2.6	5.1	2.6
os thread startup	249							100.0
read by other session	155	14.8	9.0	30.3	13.5	18.7	11.0	2.6
reliable message	2	100.0
wait list latch free	8					100.0
DIAG idle wait	21.6K							100.0	.0
PX Deq Credit: need buffer	41.6K	48.9	13.7	13.8	10.8	6.5	3.0	3.3
PX Deq Credit: send blkd	274.2K	8.1	3.0	3.4	2.9	2.4	2.1	30.6	47.4
PX Deq: Execute Reply	9260	46.6	6.9	7.4	7.9	8.1	8.2	13.7	1.2
PX Deq: Execution Msg	208.3K	9.9	3.1	2.4	1.1	.8	.5	.7	81.6
PX Deq: Join ACK	198	95.5	.5	4.0
PX Deq: Msg Fragment	22	100.0
PX Deq: Parse Reply	436	83.5	6.4	4.6	2.8	.7	.2	1.4	.5
PX Deq: Table Q Normal	636.1K	37.1	13.0	14.8	14.1	10.2	3.6	7.2	.1
PX Idle Wait	39.9K	.1	.0	.0	.0	.0	.0	.7	99.1
SQL*Net message from client	5165	22.6	7.0	2.2	3.0	.7	20.5	23.6	20.4
Space Manager: slave idle wait	2175	.2						.3	99.5
Streams AQ: qmn coordinator idle wait	1104	61.2	3.8						35.0
Streams AQ: qmn slave idle wait	646	40.2							59.8
class slave wait	41	100.0
dispatcher timer	181								100.0
jobq slave wait	2880							100.0
pmon timer	3670	1.5	.3				.0		98.1
rdbms ipc message	78.1K	.3	.0	.0	.0	.1	.1	14.3	85.2
shared server idle wait	360								100.0
smon timer	43							16.3	83.7

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
control file parallel write	675	82.0	17.4	.4	.2
cursor: pin S wait on X	477	.2			49.0		49.6	1.3
db file async I/O submit	966	48.1	13.2	9.1	9.1	7.5	4.3	2.3	6.5
db file parallel read	1	83.3		16.7
db file scattered read	1	100.0	.0
db file sequential read	10.5K	99.5	.3	.1	.0	.0	.0
db file single write	1	99.8	.2
direct path read	18.8K	99.8	.1	.1	.0	.0	.0
direct path read temp	12	100.0	.0	.0	.0	.0
direct path sync	3	40.0	40.0	20.0
direct path write temp	7271	61.9	19.2	12.2	5.0	1.7	.1
enq: BF - allocation contention	5	95.5	3.6		.9
enq: KO - fast object checkpoint	2		50.0				50.0
enq: PS - contention	1	92.3					7.7
kksfbc child completion	7		100.0
library cache lock	3	40.0			60.0
library cache: mutex X	69	97.8	2.2
log file parallel write	1	99.9	.1
log file switch completion	1	50.0	50.0
log file sync	1	97.4	2.6
os thread startup	249		100.0
read by other session	4	97.4	2.6

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
db file async I/O submit	138	93.5	1.6	1.8	3.0	.1

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)
dcpos	18,128	11,933	167,201	256,415
SYS$USERS	3	5	0	12
SYS$BACKGROUND	0	0	2	92
dcposXDB	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
dcpos	13317470	7677	4346	287	2958
SYS$USERS	140	0	5	0	2171
SYS$BACKGROUND	13599	25	94	4	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
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 98.2% of Total DB Time (s): 18,133
Captured PL/SQL account for 0.0% of Total DB Time (s): 18,133

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
7,192.26	1	7,192.26	39.66	28.90	76.40	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
5,820.35	2	2,910.17	32.10	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
3,355.17	1	3,355.17	18.50	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
665.57	1	665.57	3.67	98.17	18.21	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
663.14	1	663.14	3.66	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
78.47	1	78.47	0.43	6.67	1.49	3vq2mynvzxjjj	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
18.39	1	18.39	0.10	47.94	0.43	8nrcfxksg0b06	plsqldev.exe	select s.synonym_name object_n...
5.46	2	2.73	0.03	51.91	0.00	c5za69x5y4p34	PL/SQL Developer	begin -- Call the procedure pr...
5.32	2	2.66	0.03	96.40	0.07	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
2.97	3	0.99	0.02	100.00	94.60	350myuyx0t1d6		insert into wrh$_tablespace_st...

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
5,194.67	2	2,597.33	43.51	5,820.35	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
3,248.06	1	3,248.06	27.20	3,355.17	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
2,078.90	1	2,078.90	17.41	7,192.26	28.90	76.40	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
653.38	1	653.38	5.47	665.57	98.17	18.21	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
462.28	1	462.28	3.87	663.14	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
8.82	1	8.82	0.07	18.39	47.94	0.43	8nrcfxksg0b06	plsqldev.exe	select s.synonym_name object_n...
5.24	1	5.24	0.04	78.47	6.67	1.49	3vq2mynvzxjjj	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
5.13	2	2.57	0.04	5.32	96.40	0.07	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
2.97	3	0.99	0.02	2.97	100.00	94.60	350myuyx0t1d6		insert into wrh$_tablespace_st...
2.83	2	1.42	0.02	5.46	51.91	0.00	c5za69x5y4p34	PL/SQL Developer	begin -- Call the procedure pr...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 97.8% of Total User I/O Wait Time (s): 7,702
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 7,702

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
5,495.06	1	5,495.06	71.34	7,192.26	28.90	76.40	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
1,189.74	2	594.87	15.45	5,820.35	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
420.62	1	420.62	5.46	3,355.17	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
301.35	1	301.35	3.91	663.14	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
121.19	1	121.19	1.57	665.57	98.17	18.21	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
2.81	3	0.94	0.04	2.97	100.00	94.60	350myuyx0t1d6		insert into wrh$_tablespace_st...
1.17	1	1.17	0.02	78.47	6.67	1.49	3vq2mynvzxjjj	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
0.25	2	0.13	0.00	0.29	17.34	85.68	0nzpqf9ad90ky	PL/SQL Developer	begin htp.flush; :line := htp....
0.19	16	0.01	0.00	0.19	7.25	96.36	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
0.18	3	0.06	0.00	0.50	69.72	36.76	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...

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: 256,524,358
Captured SQL account for 94.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
94,152,644	2	47,076,322.00	36.70	5,820.35	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
57,835,500	1	57,835,500.00	22.55	3,355.17	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
53,822,877	1	53,822,877.00	20.98	7,192.26	28.90	76.40	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
18,622,924	1	18,622,924.00	7.26	663.14	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
17,523,613	1	17,523,613.00	6.83	665.57	98.17	18.21	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
98,395	2	49,197.50	0.04	5.32	96.40	0.07	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
50,136	1	50,136.00	0.02	18.39	47.94	0.43	8nrcfxksg0b06	plsqldev.exe	select s.synonym_name object_n...
12,834	8	1,604.25	0.01	0.30	99.79	0.00	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
6,480	2,160	3.00	0.00	0.70	67.39	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
4,608	36	128.00	0.00	0.03	108.46	0.00	chsyr0gssbuqf		select f.file#, f.block#, f.ts...

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: 167,205,043
Captured SQL account for 91.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
59,933,592	2	29,966,796.00	35.84	5,820.35	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
34,946,814	1	34,946,814.00	20.90	3,355.17	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
25,940,331	1	25,940,331.00	15.51	7,192.26	28.90	76.40	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
16,653,265	1	16,653,265.00	9.96	663.14	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
16,105,581	1	16,105,581.00	9.63	665.57	98.17	18.21	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
947	1	947.00	0.00	78.47	6.67	1.49	3vq2mynvzxjjj	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
923	1	923.00	0.00	0.06	99.32	14.12	2w2w2x51dk89q		select o.name from obj$ o wher...
919	1	919.00	0.00	18.39	47.94	0.43	8nrcfxksg0b06	plsqldev.exe	select s.synonym_name object_n...
69	51	1.35	0.00	0.20	30.17	75.74	gpwhsyjufj328	OGG-REP_DC-OPEN_DATA_SOURCE	INSERT INTO "POS"."YS_GOODS" (...
51	2	25.50	0.00	0.11	83.24	28.57	fnk7155mk2jq6		insert into wrh$_sysmetric_his...

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: 13,295,351
Captured SQL account for 12.7% of Total
Total UnOptimized Read Requests: 13,295,351
Captured SQL account for 12.7% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
1,172,843	1,172,843	1	1,172,843.00	8.82	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
263,208	263,208	2	131,604.00	1.98	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
134,445	134,445	1	134,445.00	1.01	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
114,906	114,906	1	114,906.00	0.86	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
3,207	3,207	1	3,207.00	0.02	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
740	740	1	740.00	0.01	8nrcfxksg0b06	plsqldev.exe	select s.synonym_name object_n...
112	112	1	112.00	0.00	3vq2mynvzxjjj	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
35	35	2	17.50	0.00	0nzpqf9ad90ky	PL/SQL Developer	begin htp.flush; :line := htp....
32	32	4	8.00	0.00	3kh7qt86ykkmu	PL/SQL Developer	begin if owa.num_cgi_vars is n...
4	4	2	2.00	0.00	5h91zx386wbht		WITH awr_params as ( SELECT /*...

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: 15,304
Captured SQL account for 76.5% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,160	18	0.01	0.70	67.39	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
2,160	2,160	1.00	0.24	75.31	0.00	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
2,160	0	0.00	0.17	97.28	0.00	csnp95dz2r8ss		select file#, block# from recy...
999	43	0.04	0.06	147.27	0.14	gvjxjrrx385ah	OGG-REP_DC-OPEN_DATA_SOURCE	UPDATE "POS"."PRODUCT_INF" SET...
915	1,747	1.91	0.16	109.17	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
360	7,200	20.00	0.93	100.16	0.00	aykvshm7zsabd		select size_for_estimate, size...
360	3,960	11.00	0.21	116.19	0.00	fvkynu9xgck8h		select PGA_TARGET_FOR_ESTIMATE...
334	321	0.96	0.09	103.78	0.89	g00cj285jmgsw		update sys.mon_mods$ set inser...
240	3,120	13.00	0.11	112.18	0.00	772s25v1y0x8k		select shared_pool_size_for_es...
240	4,800	20.00	0.07	133.07	0.00	g6gu1n3x0h1h4		select streams_pool_size_for_e...
182	178	0.98	0.06	95.69	15.78	3c1kubcdjnppq		update sys.col_usage$ set equa...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 9,379
Captured SQL account for 78.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,160	2,160	23.03	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
2,160	2,160	23.03	csnp95dz2r8ss		select file#, block# from recy...
915	915	9.76	cm5vu20fhtnq1		select /*+ connect_by_filterin...
334	334	3.56	g00cj285jmgsw		update sys.mon_mods$ set inser...
162	2	1.73	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
103	103	1.10	bsa0wjtftg3uw		select file# from file$ where ...
100	100	1.07	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
84	84	0.90	f80h0xb1qvbsk		SELECT sys.wri$_adv_seq_msggro...
83	182	0.88	3c1kubcdjnppq		update sys.col_usage$ set equa...
82	82	0.87	grwydz59pu6mc		select text from view$ where r...

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 Text
2,139,170	8	0.01	ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME...
1,654,186	3	0.01	6wm3n4d7bnddg	SELECT source, (case when tim...
1,348,715	2	0.01	6cp74g22fzahf	WITH ash as (SELECT ash.event...
1,200,456	40	0.01	bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(...

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
30	103	bsa0wjtftg3uw		select file# from file$ where ...
30	103	bsa0wjtftg3uw		select file# from file$ where ...
26	17	4yyb4104skrwj	DBMS_SCHEDULER	update obj$ set obj#=:4, type#...
23	23	1gfaj4z5hn1kf		delete from dependency$ where ...
23	23	1gfaj4z5hn1kf		delete from dependency$ where ...
21	19	9wncfacx0nj9h		insert into smon_scn_time (thr...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0nzpqf9ad90ky begin htp.flush; :line := htp.get_line(:rows); end;

1gfaj4z5hn1kf delete from dependency$ where d_obj#=:1

2w2w2x51dk89q select o.name from obj$ o where o.type# = 9 and bitand(o.flags, 2048) = 2048 and o.name like 'SYSFN%' and (sysdate-o.ctime) > 0.0007

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

3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln

3kh7qt86ykkmu begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;

3m8smr0v7v1m6 INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)

3vq2mynvzxjjj WITH TB AS ( SELECT D.MANAGENTCLIENTID CLIENTID, M.CLIENTDESC CLIENTDESC, F.NAME STYLENO, H.DESCRIPTION STYLESET, J.DESCRIPTION STYLECATEGORY, F.DESCRIPTION STYLEDESC, K.DESCRIPTION STYLESORT, FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/7) AS WEEKS, MAX(F.STANDUNITPRICE) UNITPRICE, COUNT(DISTINCT C.BRANCHCODE) SHOPS , SUM(B.QUANTITY) QUANTITY, SUM(B.AMT) AMT, CASE WHEN SUM(B.QUANTITY)*MAX(F.STANDUNITPRICE)=0 THEN 0 ELSE ROUND(SUM(B.AMT)/(SUM(B.QUANTITY)*MAX(F.STANDUNITPRICE)), 2) END DISCOUNT FROM YS_SALE A INNER JOIN YS_SALEDETAIL B ON A.SALEID=B.SALEID INNER JOIN YS_BRANCH C ON A.BRANCHID=C.BRANCHID INNER JOIN YS_CLIENT D ON C.KEEPERCLIENTID=D.CLIENTID INNER JOIN YS_GOODS E ON B.BARCODE=E.BARCODE INNER JOIN YS_GOODSSTYLE F ON E.STYLEID=F.STYLEID INNER JOIN YS_GOODSSTYLESET H ON F.STYLESETID=H.STYLESETID INNER JOIN YS_GOODSSTYLECATEGORY J ON J.STYLECATEGORYID=F.STYLECATEGORYID INNER JOIN YS_GOODSSTYLESORT K ON K.STYLESORTID=F.STYLESORTID INNER JOIN YS_AGENT M ON M.MANAGENTCLIENTID=D.MANAGENTCLIENTID WHERE A.WORKDATE BETWEEN TO_DATE(:B1 , 'yyyy-mm-dd') AND TO_DATE(:B2 , 'yyyy-mm-dd') AND A.SALETYPE<>1 AND SUBSTR(F.NAME, 2, 2)='31' AND LENGTH(F.NAME)>8 AND A.BRANCHID NOT IN(SELECT BRANCHID FROM YS_BRANCH19) GROUP BY D.MANAGENTCLIENTID, M.CLIENTDESC, F.NAME, F.DESCRIPTION, H.DESCRIPTION, J.DESCRIPTION, K.DESCRIPTION , FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/7) ) SELECT CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT, MAX(UNITPRICE) , MAX(SHOPS) , SUM(QUANTITY) "�ۻ��", SUM(AMT) "�ۻ��" , CASE WHEN SUM(QUANTITY)*MAX(UNITPRICE)=0 THEN 0 ELSE ROUND(SUM(AMT)/(SUM(QUANTITY)*MAX(UNITPRICE)), 2) END "�ۿ�" , SUM(CASE WHEN WEEKS=0 THEN QUANTITY END) "1sl", SUM(CASE WHEN WEEKS=0 THEN AMT END) "1je", SUM(CASE WHEN WEEKS=0 THEN DISCOUNT END) "1zk" , SUM(CASE WHEN WEEKS=1 THEN QUANTITY END) "2sl", SUM(CASE WHEN WEEKS=1 THEN AMT END) "2je", SUM(CASE WHEN WEEKS=1 THEN DISCOUNT END) "2zk" , SUM(CASE WHEN WEEKS=2 THEN QUANTITY END) "3sl", SUM(CASE WHEN WEEKS=2 THEN AMT END) "3je", SUM(CASE WHEN WEEKS=2 THEN DISCOUNT END) "3zk" , SUM(CASE WHEN WEEKS=3 THEN QUANTITY END) "4sl", SUM(CASE WHEN WEEKS=3 THEN AMT END) "4je", SUM(CASE WHEN WEEKS=3 THEN DISCOUNT END) "4zk" , SUM(CASE WHEN WEEKS=4 THEN QUANTITY END) "5sl", SUM(CASE WHEN WEEKS=4 THEN AMT END) "5je", SUM(CASE WHEN WEEKS=4 THEN DISCOUNT END) "5zk" , SUM(CASE WHEN WEEKS=5 THEN QUANTITY END) "6sl", SUM(CASE WHEN WEEKS=5 THEN AMT END) "6je", SUM(CASE WHEN WEEKS=5 THEN DISCOUNT END) "6zk" , SUM(CASE WHEN WEEKS=6 THEN QUANTITY END) "7sl", SUM(CASE WHEN WEEKS=6 THEN AMT END) "7je", SUM(CASE WHEN WEEKS=6 THEN DISCOUNT END) "7zk" , SUM(CASE WHEN WEEKS=7 THEN QUANTITY END) "8sl", SUM(CASE WHEN WEEKS=7 THEN AMT END) "8 je", SUM(CASE WHEN WEEKS=7 THEN DISCOUNT END) "8zk" , SUM(CASE WHEN WEEKS=8 THEN QUANTITY END) "9sl", SUM(CASE WHEN WEEKS=8 THEN AMT END) "9je", SUM(CASE WHEN WEEKS=8 THEN DISCOUNT END) "9zk" , SUM(CASE WHEN WEEKS=9 THEN QUANTITY END) "10sl", SUM(CASE WHEN WEEKS=9 THEN AMT END) "10je", SUM(CASE WHEN WEEKS=9 THEN DISCOUNT END) "10zk" , SUM(CASE WHEN WEEKS=10 THEN QUANTITY END) "11sl", SUM(CASE WHEN WEEKS=10 THEN AMT END) "11je", SUM(CASE WHEN WEEKS=10 THEN DISCOUNT END) "11zk" , SUM(CASE WHEN WEEKS=11 THEN QUANTITY END) "12sl", SUM(CASE WHEN WEEKS=11 THEN AMT END) "12je" , SUM(CASE WHEN WEEKS=11 THEN DISCOUNT END) "12zk" , SUM(CASE WHEN WEEKS=12 THEN QUANTITY END) "13sl", SUM(CASE WHEN WEEKS=12 THEN AMT END) "13je", SUM(CASE WHEN WEEKS=12 THEN DISCOUNT END) "13zk" , SUM(CASE WHEN WEEKS=13 THEN QUANTITY END) "14sl", SUM(CASE WHEN WEEKS=13 THEN AMT END) "14je", SUM(CASE WHEN WEEKS=13 THEN DISCOUNT END) "14zk" FROM TB GROUP BY CLIENTID, CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT ORDER BY CLIENTID ASC, STYLENO ASC

4yyb4104skrwj update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

50rfmcah65kr0 WITH TB AS ( SELECT D.MANAGENTCLIENTID CLIENTID, M.CLIENTDESC CLIENTDESC, F.NAME STYLENO, H.DESCRIPTION STYLESET, J.DESCRIPTION STYLECATEGORY, F.DESCRIPTION STYLEDESC, K.DESCRIPTION STYLESORT, FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/14) AS WEEKS, MAX(F.STANDUNITPRICE) UNITPRICE, COUNT(DISTINCT C.BRANCHCODE) SHOPS , SUM(B.QUANTITY) QUANTITY, SUM(B.AMT) AMT, CASE WHEN SUM(B.QUANTITY)*MAX(F.STANDUNITPRICE)=0 THEN 0 ELSE ROUND(SUM(B.AMT)/(SUM(B.QUANTITY)*MAX(F.STANDUNITPRICE)), 2) END DISCOUNT FROM YS_SALE A INNER JOIN YS_SALEDETAIL B ON A.SALEID=B.SALEID INNER JOIN YS_BRANCH C ON A.BRANCHID=C.BRANCHID INNER JOIN YS_CLIENT D ON C.KEEPERCLIENTID=D.CLIENTID INNER JOIN YS_GOODS E ON B.BARCODE=E.BARCODE INNER JOIN YS_GOODSSTYLE F ON E.STYLEID=F.STYLEID INNER JOIN YS_GOODSSTYLESET H ON F.STYLESETID=H.STYLESETID INNER JOIN YS_GOODSSTYLECATEGORY J ON J.STYLECATEGORYID=F.STYLECATEGORYID INNER JOIN YS_GOODSSTYLESORT K ON K.STYLESORTID=F.STYLESORTID INNER JOIN YS_AGENT M ON M.MANAGENTCLIENTID=D.MANAGENTCLIENTID WHERE A.WORKDATE BETWEEN TO_DATE(:B1 , 'yyyy-mm-dd') AND TO_DATE(:B2 , 'yyyy-mm-dd') AND A.SALETYPE<>1 AND SUBSTR(F.NAME, 2, 2)='32' AND LENGTH(F.NAME)>8 AND A.BRANCHID NOT IN(SELECT BRANCHID FROM YS_BRANCH19) GROUP BY D.MANAGENTCLIENTID, M.CLIENTDESC, F.NAME, F.DESCRIPTION, H.DESCRIPTION, J.DESCRIPTION, K.DESCRIPTION , FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/14) ) SELECT CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT, MAX(UNITPRIC E), MAX(SHOPS) , SUM(QUANTITY) "�ۻ��", SUM(AMT) "�ۻ��" , CASE WHEN SUM(QUANTITY)*MAX(UNITPRICE)=0 THEN 0 ELSE ROUND(SUM(AMT)/(SUM(QUANTITY)*MAX(UNITPRICE)), 2) END "�ۿ�" , SUM(CASE WHEN WEEKS=0 THEN QUANTITY END) "1sl", SUM(CASE WHEN WEEKS=0 THEN AMT END) "1je", SUM(CASE WHEN WEEKS=0 THEN DISCOUNT END) "1zk" , SUM(CASE WHEN WEEKS=1 THEN QUANTITY END) "2sl", SUM(CASE WHEN WEEKS=1 THEN AMT END) "2je", SUM(CASE WHEN WEEKS=1 THEN DISCOUNT END) "2zk" , SUM(CASE WHEN WEEKS=2 THEN QUANTITY END) "3sl", SUM(CASE WHEN WEEKS=2 THEN AMT END) "3je", SUM(CASE WHEN WEEKS=2 THEN DISCOUNT END) "3zk" , SUM(CASE WHEN WEEKS=3 THEN QUANTITY END) "4sl", SUM(CASE WHEN WEEKS=3 THEN AMT END) "4je", SUM(CASE WHEN WEEKS=3 THEN DISCOUNT END) "4zk" , SUM(CASE WHEN WEEKS=4 THEN QUANTITY END) "5sl", SUM(CASE WHEN WEEKS=4 THEN AMT END) "5je", SUM(CASE WHEN WEEKS=4 THEN DISCOUNT END) "5zk" , SUM(CASE WHEN WEEKS=5 THEN QUANTITY END) "6sl", SUM(CASE WHEN WEEKS=5 THEN AMT END) "6je", SUM(CASE WHEN WEEKS=5 THEN DISCOUNT END) "6zk" , SUM(CASE WHEN WEEKS=6 THEN QUANTITY END) "7sl", SUM(CASE WHEN WEEKS=6 THEN AMT END) "7je", SUM(CASE WHEN WEEKS=6 THEN DISCOUNT END) "7zk" , SUM(CASE WHEN WEEKS=7 THEN QUANTITY END) "8sl", SUM(CASE WHEN WEEKS=7 THEN AMT END) " ;8je" , SUM(CASE WHEN WEEKS=7 THEN DISCOUNT END) "8zk" , SUM(CASE WHEN WEEKS=8 THEN QUANTITY END) "9sl", SUM(CASE WHEN WEEKS=8 THEN AMT END) "9je", SUM(CASE WHEN WEEKS=8 THEN DISCOUNT END) "9zk" , SUM(CASE WHEN WEEKS=9 THEN QUANTITY END) "10sl", SUM(CASE WHEN WEEKS=9 THEN AMT END) "10je", SUM(CASE WHEN WEEKS=9 THEN DISCOUNT END) "10zk" , SUM(CASE WHEN WEEKS=10 THEN QUANTITY END) "11sl", SUM(CASE WHEN WEEKS=10 THEN AMT END) "11je", SUM(CASE WHEN WEEKS=10 THEN DISCOUNT END) "11zk" , SUM(CASE WHEN WEEKS=11 THEN QUANTITY END) "12sl", SUM(CASE WHEN WEEKS=11 THEN AMT END) "12je" , SUM(CASE WHEN WEEKS=11 THEN DISCOUNT END) "12zk" , SUM(CASE WHEN WEEKS=12 THEN QUANTITY END) "13sl", SUM(CASE WHEN WEEKS=12 THEN AMT END) "13je", SUM(CASE WHEN WEEKS=12 THEN DISCOUNT END) "13zk" , SUM(CASE WHEN WEEKS=13 THEN QUANTITY END) "14sl", SUM(CASE WHEN WEEKS=13 THEN AMT END) "14je", SUM(CASE WHEN WEEKS=13 THEN DISCOUNT END) "14zk" , SUM(CASE WHEN WEEKS=14 THEN QUANTITY END) "15sl", SUM(CASE WHEN WEEKS=14 THEN AMT END) "15je", SUM(CASE WHEN WEEKS=14 THEN DISCOUNT END) "15zk" FROM TB GROUP BY CLIENTID, CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT ORDER BY CLIENTID ASC, STYLENO ASC

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

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

5srtgtkcbvkdc WITH TB AS ( SELECT D.MANAGENTCLIENTID CLIENTID, M.CLIENTDESC CLIENTDESC, F.NAME STYLENO, H.DESCRIPTION STYLESET, J.DESCRIPTION STYLECATEGORY, F.DESCRIPTION STYLEDESC, K.DESCRIPTION STYLESORT, FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/7) AS WEEKS, MAX(F.STANDUNITPRICE) UNITPRICE, COUNT(DISTINCT C.BRANCHCODE) SHOPS , SUM(B.QUANTITY) QUANTITY, SUM(B.AMT) AMT, CASE WHEN SUM(B.QUANTITY)*MAX(F.STANDUNITPRICE)=0 THEN 0 ELSE ROUND(SUM(B.AMT)/(SUM(B.QUANTITY)*MAX(F.STANDUNITPRICE)), 2) END DISCOUNT FROM YS_SALE A INNER JOIN YS_SALEDETAIL B ON A.SALEID=B.SALEID INNER JOIN YS_BRANCH C ON A.BRANCHID=C.BRANCHID INNER JOIN YS_CLIENT D ON C.KEEPERCLIENTID=D.CLIENTID INNER JOIN YS_GOODS E ON B.BARCODE=E.BARCODE INNER JOIN YS_GOODSSTYLE F ON E.STYLEID=F.STYLEID INNER JOIN YS_GOODSSTYLESET H ON F.STYLESETID=H.STYLESETID INNER JOIN YS_GOODSSTYLECATEGORY J ON J.STYLECATEGORYID=F.STYLECATEGORYID INNER JOIN YS_GOODSSTYLESORT K ON K.STYLESORTID=F.STYLESORTID INNER JOIN YS_AGENT M ON M.MANAGENTCLIENTID=D.MANAGENTCLIENTID WHERE A.WORKDATE BETWEEN TO_DATE(:B1 , 'yyyy-mm-dd') AND TO_DATE(:B2 , 'yyyy-mm-dd') AND A.SALETYPE<>1 AND SUBSTR(F.NAME, 2, 2)='31' AND LENGTH(F.NAME)>8 AND A.BRANCHID NOT IN(SELECT BRANCHID FROM YS_BRANCH19) GROUP BY D.MANAGENTCLIENTID, M.CLIENTDESC, F.NAME, F.DESCRIPTION, H.DESCRIPTION, J.DESCRIPTION, K.DESCRIPTION , FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/7) ) SELECT CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT, MAX(UNITPRICE) , MAX(SHOPS) , SUM(QUANTITY) "�ۻ��", SUM(AMT) "�ۻ��" , CASE WHEN SUM(QUANTITY)*MAX(UNITPRICE)=0 THEN 0 ELSE ROUND(SUM(AMT)/(SUM(QUANTITY)*MAX(UNITPRICE)), 2) END "�ۿ�" , SUM(CASE WHEN WEEKS=0 THEN QUANTITY END) "1sl", SUM(CASE WHEN WEEKS=0 THEN AMT END) "1je", SUM(CASE WHEN WEEKS=0 THEN DISCOUNT END) "1zk" , SUM(CASE WHEN WEEKS=1 THEN QUANTITY END) "2sl", SUM(CASE WHEN WEEKS=1 THEN AMT END) "2je", SUM(CASE WHEN WEEKS=1 THEN DISCOUNT END) "2zk" , SUM(CASE WHEN WEEKS=2 THEN QUANTITY END) "3sl", SUM(CASE WHEN WEEKS=2 THEN AMT END) "3je", SUM(CASE WHEN WEEKS=2 THEN DISCOUNT END) "3zk" , SUM(CASE WHEN WEEKS=3 THEN QUANTITY END) "4sl", SUM(CASE WHEN WEEKS=3 THEN AMT END) "4je", SUM(CASE WHEN WEEKS=3 THEN DISCOUNT END) "4zk" , SUM(CASE WHEN WEEKS=4 THEN QUANTITY END) "5sl", SUM(CASE WHEN WEEKS=4 THEN AMT END) "5je", SUM(CASE WHEN WEEKS=4 THEN DISCOUNT END) "5zk" , SUM(CASE WHEN WEEKS=5 THEN QUANTITY END) "6sl", SUM(CASE WHEN WEEKS=5 THEN AMT END) "6je", SUM(CASE WHEN WEEKS=5 THEN DISCOUNT END) "6zk" , SUM(CASE WHEN WEEKS=6 THEN QUANTITY END) "7sl", SUM(CASE WHEN WEEKS=6 THEN AMT END) "7je", SUM(CASE WHEN WEEKS=6 THEN DISCOUNT END) "7zk" , SUM(CASE WHEN WEEKS=7 THEN QUANTITY END) "8sl", SUM(CASE WHEN WEEKS=7 THEN AMT END) "8 je", SUM(CASE WHEN WEEKS=7 THEN DISCOUNT END) "8zk" , SUM(CASE WHEN WEEKS=8 THEN QUANTITY END) "9sl", SUM(CASE WHEN WEEKS=8 THEN AMT END) "9je", SUM(CASE WHEN WEEKS=8 THEN DISCOUNT END) "9zk" , SUM(CASE WHEN WEEKS=9 THEN QUANTITY END) "10sl", SUM(CASE WHEN WEEKS=9 THEN AMT END) "10je", SUM(CASE WHEN WEEKS=9 THEN DISCOUNT END) "10zk" , SUM(CASE WHEN WEEKS=10 THEN QUANTITY END) "11sl", SUM(CASE WHEN WEEKS=10 THEN AMT END) "11je", SUM(CASE WHEN WEEKS=10 THEN DISCOUNT END) "11zk" , SUM(CASE WHEN WEEKS=11 THEN QUANTITY END) "12sl", SUM(CASE WHEN WEEKS=11 THEN AMT END) "12je" , SUM(CASE WHEN WEEKS=11 THEN DISCOUNT END) "12zk" , SUM(CASE WHEN WEEKS=12 THEN QUANTITY END) "13sl", SUM(CASE WHEN WEEKS=12 THEN AMT END) "13je", SUM(CASE WHEN WEEKS=12 THEN DISCOUNT END) "13zk" , SUM(CASE WHEN WEEKS=13 THEN QUANTITY END) "14sl", SUM(CASE WHEN WEEKS=13 THEN AMT END) "14je", SUM(CASE WHEN WEEKS=13 THEN DISCOUNT END) "14zk" , SUM(CASE WHEN WEEKS=14 THEN QUANTITY END) "15sl", SUM(CASE WHEN WEEKS=14 THEN AMT END) "15je", SUM(CASE WHEN WEEKS=14 THEN DISCOUNT END) "15zk" FROM TB GROUP BY CLIENTID, CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT ORDER BY CLIENTID ASC, STYLENO ASC

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

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

6xvp6nxs4a9n4 select nvl(sum(space), 0) from recyclebin$ where ts# = :1

772s25v1y0x8k select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice

7sz1kxn37kaph select m.clientdesc clientdesc, e.styleno, e.sizedesc, sum(b.quantity) quantity, sum(b.amt) amt from ys_sale a inner join ys_saledetail b on a.saleid=b.saleid inner join ys_branch c on a.branchid=c.branchid inner join ys_client D on c.KEEPERCLIENTID=D.CLIENTID inner join product_inf e on e.productid=b.productid inner join ys_agent m on m.managentclientid=d.managentclientid where a.workdate between to_date('2012-12-03', 'yyyy-mm-dd') and to_date('2013-03-17', 'yyyy-mm-dd') and a.saletype<>1 and substr(e.styleno, 2, 2)='31' and length(e.styleno)>8 and a.branchid not in(select branchid from ys_branch19) group by m.clientdesc, e.styleno, e.sizedesc

8nrcfxksg0b06 select s.synonym_name 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')

9wncfacx0nj9h insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)

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

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

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

bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1

bsa0wjtftg3uw select file# from file$ where ts#=:1

c5za69x5y4p34 begin -- Call the procedure proc_sale_week(rq1 => :rq1, rq2 => :rq2, sp_result => :sp_result); end;

chsyr0gssbuqf select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0

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

csnp95dz2r8ss select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0

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

d83wuwxj37spw select m.clientdesc clientdesc, e.styleno, e.colordesc, sum(b.quantity) quantity, sum(b.amt) amt from ys_sale a inner join ys_saledetail b on a.saleid=b.saleid inner join ys_branch c on a.branchid=c.branchid inner join ys_client D on c.KEEPERCLIENTID=D.CLIENTID inner join product_inf e on e.productid=b.productid inner join ys_agent m on m.managentclientid=d.managentclientid where a.workdate between to_date('2012-12-03', 'yyyy-mm-dd') and to_date('2013-03-17', 'yyyy-mm-dd') and a.saletype<>1 and substr(e.styleno, 2, 2)='31' and length(e.styleno)>8 and a.branchid not in(select branchid from ys_branch19) group by m.clientdesc, e.styleno, e.colordesc

f2vs2dt4yhfpa select m.clientdesc clientdesc, e.styleno, e.colordesc, sum(b.quantity) quantity, sum(b.amt) amt from ys_sale a inner join ys_saledetail b on a.saleid=b.saleid inner join ys_branch c on a.branchid=c.branchid inner join ys_client D on c.KEEPERCLIENTID=D.CLIENTID inner join product_inf e on e.productid=b.productid inner join ys_agent m on m.managentclientid=d.managentclientid where a.workdate between to_date('2013-01-14', 'yyyy-mm-dd') and to_date('2013-03-17', 'yyyy-mm-dd') and a.saletype<>1 and substr(e.styleno, 2, 2)='32' and length(e.styleno)>8 and a.branchid not in(select branchid from ys_branch19) group by m.clientdesc, e.styleno, e.colordesc

f80h0xb1qvbsk SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual

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

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

fvkynu9xgck8h select PGA_TARGET_FOR_ESTIMATE s, PGA_TARGET_FACTOR * 100 f, ESTD_TIME t, BYTES_PROCESSED b from v$pga_target_advice order by PGA_TARGET_FOR_ESTIMATE

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

g6gu1n3x0h1h4 select streams_pool_size_for_estimate s, streams_pool_size_factor * 100 f, estd_spill_time + estd_unspill_time, 0 from v$streams_pool_advice

gpwhsyjufj328 INSERT INTO "POS"."YS_GOODS" ("GOODSID", "ISACTIVE", "BARCODE", "BRANDID", "SIZEID", "COLORID", "STYLEID", "CREATEUSERID", "CREATEDATE", "UPDATEUSERID", "UPDATEDATE", "VERSIONID", "ISSYNC") VALUES (:a0, :a1, :a2, :a3, :a4, :a5, :a6, :a7, :a8, :a9, :a10, :a11, :a12)

grwydz59pu6mc select text from view$ where rowid=:1

gvjxjrrx385ah UPDATE "POS"."PRODUCT_INF" SET "VERSIONID" = :a1 WHERE "PRODUCTID" = :b0

SQL Id	SQL Text
0nzpqf9ad90ky	begin htp.flush; :line := htp.get_line(:rows); end;
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
2w2w2x51dk89q	select o.name from obj$ o where o.type# = 9 and bitand(o.flags, 2048) = 2048 and o.name like 'SYSFN%' and (sysdate-o.ctime) > 0.0007
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3kh7qt86ykkmu	begin if owa.num_cgi_vars is null then owa.num_cgi_vars := 0; end if; end;
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3vq2mynvzxjjj	WITH TB AS ( SELECT D.MANAGENTCLIENTID CLIENTID, M.CLIENTDESC CLIENTDESC, F.NAME STYLENO, H.DESCRIPTION STYLESET, J.DESCRIPTION STYLECATEGORY, F.DESCRIPTION STYLEDESC, K.DESCRIPTION STYLESORT, FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/7) AS WEEKS, MAX(F.STANDUNITPRICE) UNITPRICE, COUNT(DISTINCT C.BRANCHCODE) SHOPS , SUM(B.QUANTITY) QUANTITY, SUM(B.AMT) AMT, CASE WHEN SUM(B.QUANTITY)MAX(F.STANDUNITPRICE)=0 THEN 0 ELSE ROUND(SUM(B.AMT)/(SUM(B.QUANTITY)MAX(F.STANDUNITPRICE)), 2) END DISCOUNT FROM YS_SALE A INNER JOIN YS_SALEDETAIL B ON A.SALEID=B.SALEID INNER JOIN YS_BRANCH C ON A.BRANCHID=C.BRANCHID INNER JOIN YS_CLIENT D ON C.KEEPERCLIENTID=D.CLIENTID INNER JOIN YS_GOODS E ON B.BARCODE=E.BARCODE INNER JOIN YS_GOODSSTYLE F ON E.STYLEID=F.STYLEID INNER JOIN YS_GOODSSTYLESET H ON F.STYLESETID=H.STYLESETID INNER JOIN YS_GOODSSTYLECATEGORY J ON J.STYLECATEGORYID=F.STYLECATEGORYID INNER JOIN YS_GOODSSTYLESORT K ON K.STYLESORTID=F.STYLESORTID INNER JOIN YS_AGENT M ON M.MANAGENTCLIENTID=D.MANAGENTCLIENTID WHERE A.WORKDATE BETWEEN TO_DATE(:B1 , 'yyyy-mm-dd') AND TO_DATE(:B2 , 'yyyy-mm-dd') AND A.SALETYPE<>1 AND SUBSTR(F.NAME, 2, 2)='31' AND LENGTH(F.NAME)>8 AND A.BRANCHID NOT IN(SELECT BRANCHID FROM YS_BRANCH19) GROUP BY D.MANAGENTCLIENTID, M.CLIENTDESC, F.NAME, F.DESCRIPTION, H.DESCRIPTION, J.DESCRIPTION, K.DESCRIPTION , FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/7) ) SELECT CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT, MAX(UNITPRICE) , MAX(SHOPS) , SUM(QUANTITY) "�ۻ��", SUM(AMT) "�ۻ��" , CASE WHEN SUM(QUANTITY)MAX(UNITPRICE)=0 THEN 0 ELSE ROUND(SUM(AMT)/(SUM(QUANTITY)MAX(UNITPRICE)), 2) END "�ۿ�" , SUM(CASE WHEN WEEKS=0 THEN QUANTITY END) "1sl", SUM(CASE WHEN WEEKS=0 THEN AMT END) "1je", SUM(CASE WHEN WEEKS=0 THEN DISCOUNT END) "1zk" , SUM(CASE WHEN WEEKS=1 THEN QUANTITY END) "2sl", SUM(CASE WHEN WEEKS=1 THEN AMT END) "2je", SUM(CASE WHEN WEEKS=1 THEN DISCOUNT END) "2zk" , SUM(CASE WHEN WEEKS=2 THEN QUANTITY END) "3sl", SUM(CASE WHEN WEEKS=2 THEN AMT END) "3je", SUM(CASE WHEN WEEKS=2 THEN DISCOUNT END) "3zk" , SUM(CASE WHEN WEEKS=3 THEN QUANTITY END) "4sl", SUM(CASE WHEN WEEKS=3 THEN AMT END) "4je", SUM(CASE WHEN WEEKS=3 THEN DISCOUNT END) "4zk" , SUM(CASE WHEN WEEKS=4 THEN QUANTITY END) "5sl", SUM(CASE WHEN WEEKS=4 THEN AMT END) "5je", SUM(CASE WHEN WEEKS=4 THEN DISCOUNT END) "5zk" , SUM(CASE WHEN WEEKS=5 THEN QUANTITY END) "6sl", SUM(CASE WHEN WEEKS=5 THEN AMT END) "6je", SUM(CASE WHEN WEEKS=5 THEN DISCOUNT END) "6zk" , SUM(CASE WHEN WEEKS=6 THEN QUANTITY END) "7sl", SUM(CASE WHEN WEEKS=6 THEN AMT END) "7je", SUM(CASE WHEN WEEKS=6 THEN DISCOUNT END) "7zk" , SUM(CASE WHEN WEEKS=7 THEN QUANTITY END) "8sl", SUM(CASE WHEN WEEKS=7 THEN AMT END) "8 je", SUM(CASE WHEN WEEKS=7 THEN DISCOUNT END) "8zk" , SUM(CASE WHEN WEEKS=8 THEN QUANTITY END) "9sl", SUM(CASE WHEN WEEKS=8 THEN AMT END) "9je", SUM(CASE WHEN WEEKS=8 THEN DISCOUNT END) "9zk" , SUM(CASE WHEN WEEKS=9 THEN QUANTITY END) "10sl", SUM(CASE WHEN WEEKS=9 THEN AMT END) "10je", SUM(CASE WHEN WEEKS=9 THEN DISCOUNT END) "10zk" , SUM(CASE WHEN WEEKS=10 THEN QUANTITY END) "11sl", SUM(CASE WHEN WEEKS=10 THEN AMT END) "11je", SUM(CASE WHEN WEEKS=10 THEN DISCOUNT END) "11zk" , SUM(CASE WHEN WEEKS=11 THEN QUANTITY END) "12sl", SUM(CASE WHEN WEEKS=11 THEN AMT END) "12je" , SUM(CASE WHEN WEEKS=11 THEN DISCOUNT END) "12zk" , SUM(CASE WHEN WEEKS=12 THEN QUANTITY END) "13sl", SUM(CASE WHEN WEEKS=12 THEN AMT END) "13je", SUM(CASE WHEN WEEKS=12 THEN DISCOUNT END) "13zk" , SUM(CASE WHEN WEEKS=13 THEN QUANTITY END) "14sl", SUM(CASE WHEN WEEKS=13 THEN AMT END) "14je", SUM(CASE WHEN WEEKS=13 THEN DISCOUNT END) "14zk" FROM TB GROUP BY CLIENTID, CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT ORDER BY CLIENTID ASC, STYLENO ASC
4yyb4104skrwj	update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
50rfmcah65kr0	WITH TB AS ( SELECT D.MANAGENTCLIENTID CLIENTID, M.CLIENTDESC CLIENTDESC, F.NAME STYLENO, H.DESCRIPTION STYLESET, J.DESCRIPTION STYLECATEGORY, F.DESCRIPTION STYLEDESC, K.DESCRIPTION STYLESORT, FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/14) AS WEEKS, MAX(F.STANDUNITPRICE) UNITPRICE, COUNT(DISTINCT C.BRANCHCODE) SHOPS , SUM(B.QUANTITY) QUANTITY, SUM(B.AMT) AMT, CASE WHEN SUM(B.QUANTITY)MAX(F.STANDUNITPRICE)=0 THEN 0 ELSE ROUND(SUM(B.AMT)/(SUM(B.QUANTITY)MAX(F.STANDUNITPRICE)), 2) END DISCOUNT FROM YS_SALE A INNER JOIN YS_SALEDETAIL B ON A.SALEID=B.SALEID INNER JOIN YS_BRANCH C ON A.BRANCHID=C.BRANCHID INNER JOIN YS_CLIENT D ON C.KEEPERCLIENTID=D.CLIENTID INNER JOIN YS_GOODS E ON B.BARCODE=E.BARCODE INNER JOIN YS_GOODSSTYLE F ON E.STYLEID=F.STYLEID INNER JOIN YS_GOODSSTYLESET H ON F.STYLESETID=H.STYLESETID INNER JOIN YS_GOODSSTYLECATEGORY J ON J.STYLECATEGORYID=F.STYLECATEGORYID INNER JOIN YS_GOODSSTYLESORT K ON K.STYLESORTID=F.STYLESORTID INNER JOIN YS_AGENT M ON M.MANAGENTCLIENTID=D.MANAGENTCLIENTID WHERE A.WORKDATE BETWEEN TO_DATE(:B1 , 'yyyy-mm-dd') AND TO_DATE(:B2 , 'yyyy-mm-dd') AND A.SALETYPE<>1 AND SUBSTR(F.NAME, 2, 2)='32' AND LENGTH(F.NAME)>8 AND A.BRANCHID NOT IN(SELECT BRANCHID FROM YS_BRANCH19) GROUP BY D.MANAGENTCLIENTID, M.CLIENTDESC, F.NAME, F.DESCRIPTION, H.DESCRIPTION, J.DESCRIPTION, K.DESCRIPTION , FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/14) ) SELECT CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT, MAX(UNITPRIC E), MAX(SHOPS) , SUM(QUANTITY) "�ۻ��", SUM(AMT) "�ۻ��" , CASE WHEN SUM(QUANTITY)MAX(UNITPRICE)=0 THEN 0 ELSE ROUND(SUM(AMT)/(SUM(QUANTITY)MAX(UNITPRICE)), 2) END "�ۿ�" , SUM(CASE WHEN WEEKS=0 THEN QUANTITY END) "1sl", SUM(CASE WHEN WEEKS=0 THEN AMT END) "1je", SUM(CASE WHEN WEEKS=0 THEN DISCOUNT END) "1zk" , SUM(CASE WHEN WEEKS=1 THEN QUANTITY END) "2sl", SUM(CASE WHEN WEEKS=1 THEN AMT END) "2je", SUM(CASE WHEN WEEKS=1 THEN DISCOUNT END) "2zk" , SUM(CASE WHEN WEEKS=2 THEN QUANTITY END) "3sl", SUM(CASE WHEN WEEKS=2 THEN AMT END) "3je", SUM(CASE WHEN WEEKS=2 THEN DISCOUNT END) "3zk" , SUM(CASE WHEN WEEKS=3 THEN QUANTITY END) "4sl", SUM(CASE WHEN WEEKS=3 THEN AMT END) "4je", SUM(CASE WHEN WEEKS=3 THEN DISCOUNT END) "4zk" , SUM(CASE WHEN WEEKS=4 THEN QUANTITY END) "5sl", SUM(CASE WHEN WEEKS=4 THEN AMT END) "5je", SUM(CASE WHEN WEEKS=4 THEN DISCOUNT END) "5zk" , SUM(CASE WHEN WEEKS=5 THEN QUANTITY END) "6sl", SUM(CASE WHEN WEEKS=5 THEN AMT END) "6je", SUM(CASE WHEN WEEKS=5 THEN DISCOUNT END) "6zk" , SUM(CASE WHEN WEEKS=6 THEN QUANTITY END) "7sl", SUM(CASE WHEN WEEKS=6 THEN AMT END) "7je", SUM(CASE WHEN WEEKS=6 THEN DISCOUNT END) "7zk" , SUM(CASE WHEN WEEKS=7 THEN QUANTITY END) "8sl", SUM(CASE WHEN WEEKS=7 THEN AMT END) " ;8je" , SUM(CASE WHEN WEEKS=7 THEN DISCOUNT END) "8zk" , SUM(CASE WHEN WEEKS=8 THEN QUANTITY END) "9sl", SUM(CASE WHEN WEEKS=8 THEN AMT END) "9je", SUM(CASE WHEN WEEKS=8 THEN DISCOUNT END) "9zk" , SUM(CASE WHEN WEEKS=9 THEN QUANTITY END) "10sl", SUM(CASE WHEN WEEKS=9 THEN AMT END) "10je", SUM(CASE WHEN WEEKS=9 THEN DISCOUNT END) "10zk" , SUM(CASE WHEN WEEKS=10 THEN QUANTITY END) "11sl", SUM(CASE WHEN WEEKS=10 THEN AMT END) "11je", SUM(CASE WHEN WEEKS=10 THEN DISCOUNT END) "11zk" , SUM(CASE WHEN WEEKS=11 THEN QUANTITY END) "12sl", SUM(CASE WHEN WEEKS=11 THEN AMT END) "12je" , SUM(CASE WHEN WEEKS=11 THEN DISCOUNT END) "12zk" , SUM(CASE WHEN WEEKS=12 THEN QUANTITY END) "13sl", SUM(CASE WHEN WEEKS=12 THEN AMT END) "13je", SUM(CASE WHEN WEEKS=12 THEN DISCOUNT END) "13zk" , SUM(CASE WHEN WEEKS=13 THEN QUANTITY END) "14sl", SUM(CASE WHEN WEEKS=13 THEN AMT END) "14je", SUM(CASE WHEN WEEKS=13 THEN DISCOUNT END) "14zk" , SUM(CASE WHEN WEEKS=14 THEN QUANTITY END) "15sl", SUM(CASE WHEN WEEKS=14 THEN AMT END) "15je", SUM(CASE WHEN WEEKS=14 THEN DISCOUNT END) "15zk" FROM TB GROUP BY CLIENTID, CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT ORDER BY CLIENTID ASC, STYLENO ASC
5h91zx386wbht	WITH awr_params as ( SELECT /+ NO_MERGE(map) USE_HASH(map) / p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /+ USE_HASH(xmap) / xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.instance_number = :inst AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.par ameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_value end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)
5ms6rbzdnq16t	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
5srtgtkcbvkdc	WITH TB AS ( SELECT D.MANAGENTCLIENTID CLIENTID, M.CLIENTDESC CLIENTDESC, F.NAME STYLENO, H.DESCRIPTION STYLESET, J.DESCRIPTION STYLECATEGORY, F.DESCRIPTION STYLEDESC, K.DESCRIPTION STYLESORT, FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/7) AS WEEKS, MAX(F.STANDUNITPRICE) UNITPRICE, COUNT(DISTINCT C.BRANCHCODE) SHOPS , SUM(B.QUANTITY) QUANTITY, SUM(B.AMT) AMT, CASE WHEN SUM(B.QUANTITY)MAX(F.STANDUNITPRICE)=0 THEN 0 ELSE ROUND(SUM(B.AMT)/(SUM(B.QUANTITY)MAX(F.STANDUNITPRICE)), 2) END DISCOUNT FROM YS_SALE A INNER JOIN YS_SALEDETAIL B ON A.SALEID=B.SALEID INNER JOIN YS_BRANCH C ON A.BRANCHID=C.BRANCHID INNER JOIN YS_CLIENT D ON C.KEEPERCLIENTID=D.CLIENTID INNER JOIN YS_GOODS E ON B.BARCODE=E.BARCODE INNER JOIN YS_GOODSSTYLE F ON E.STYLEID=F.STYLEID INNER JOIN YS_GOODSSTYLESET H ON F.STYLESETID=H.STYLESETID INNER JOIN YS_GOODSSTYLECATEGORY J ON J.STYLECATEGORYID=F.STYLECATEGORYID INNER JOIN YS_GOODSSTYLESORT K ON K.STYLESORTID=F.STYLESORTID INNER JOIN YS_AGENT M ON M.MANAGENTCLIENTID=D.MANAGENTCLIENTID WHERE A.WORKDATE BETWEEN TO_DATE(:B1 , 'yyyy-mm-dd') AND TO_DATE(:B2 , 'yyyy-mm-dd') AND A.SALETYPE<>1 AND SUBSTR(F.NAME, 2, 2)='31' AND LENGTH(F.NAME)>8 AND A.BRANCHID NOT IN(SELECT BRANCHID FROM YS_BRANCH19) GROUP BY D.MANAGENTCLIENTID, M.CLIENTDESC, F.NAME, F.DESCRIPTION, H.DESCRIPTION, J.DESCRIPTION, K.DESCRIPTION , FLOOR((A.WORKDATE -TO_DATE(:B1 , 'yyyy-mm-dd'))/7) ) SELECT CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT, MAX(UNITPRICE) , MAX(SHOPS) , SUM(QUANTITY) "�ۻ��", SUM(AMT) "�ۻ��" , CASE WHEN SUM(QUANTITY)MAX(UNITPRICE)=0 THEN 0 ELSE ROUND(SUM(AMT)/(SUM(QUANTITY)MAX(UNITPRICE)), 2) END "�ۿ�" , SUM(CASE WHEN WEEKS=0 THEN QUANTITY END) "1sl", SUM(CASE WHEN WEEKS=0 THEN AMT END) "1je", SUM(CASE WHEN WEEKS=0 THEN DISCOUNT END) "1zk" , SUM(CASE WHEN WEEKS=1 THEN QUANTITY END) "2sl", SUM(CASE WHEN WEEKS=1 THEN AMT END) "2je", SUM(CASE WHEN WEEKS=1 THEN DISCOUNT END) "2zk" , SUM(CASE WHEN WEEKS=2 THEN QUANTITY END) "3sl", SUM(CASE WHEN WEEKS=2 THEN AMT END) "3je", SUM(CASE WHEN WEEKS=2 THEN DISCOUNT END) "3zk" , SUM(CASE WHEN WEEKS=3 THEN QUANTITY END) "4sl", SUM(CASE WHEN WEEKS=3 THEN AMT END) "4je", SUM(CASE WHEN WEEKS=3 THEN DISCOUNT END) "4zk" , SUM(CASE WHEN WEEKS=4 THEN QUANTITY END) "5sl", SUM(CASE WHEN WEEKS=4 THEN AMT END) "5je", SUM(CASE WHEN WEEKS=4 THEN DISCOUNT END) "5zk" , SUM(CASE WHEN WEEKS=5 THEN QUANTITY END) "6sl", SUM(CASE WHEN WEEKS=5 THEN AMT END) "6je", SUM(CASE WHEN WEEKS=5 THEN DISCOUNT END) "6zk" , SUM(CASE WHEN WEEKS=6 THEN QUANTITY END) "7sl", SUM(CASE WHEN WEEKS=6 THEN AMT END) "7je", SUM(CASE WHEN WEEKS=6 THEN DISCOUNT END) "7zk" , SUM(CASE WHEN WEEKS=7 THEN QUANTITY END) "8sl", SUM(CASE WHEN WEEKS=7 THEN AMT END) "8 je", SUM(CASE WHEN WEEKS=7 THEN DISCOUNT END) "8zk" , SUM(CASE WHEN WEEKS=8 THEN QUANTITY END) "9sl", SUM(CASE WHEN WEEKS=8 THEN AMT END) "9je", SUM(CASE WHEN WEEKS=8 THEN DISCOUNT END) "9zk" , SUM(CASE WHEN WEEKS=9 THEN QUANTITY END) "10sl", SUM(CASE WHEN WEEKS=9 THEN AMT END) "10je", SUM(CASE WHEN WEEKS=9 THEN DISCOUNT END) "10zk" , SUM(CASE WHEN WEEKS=10 THEN QUANTITY END) "11sl", SUM(CASE WHEN WEEKS=10 THEN AMT END) "11je", SUM(CASE WHEN WEEKS=10 THEN DISCOUNT END) "11zk" , SUM(CASE WHEN WEEKS=11 THEN QUANTITY END) "12sl", SUM(CASE WHEN WEEKS=11 THEN AMT END) "12je" , SUM(CASE WHEN WEEKS=11 THEN DISCOUNT END) "12zk" , SUM(CASE WHEN WEEKS=12 THEN QUANTITY END) "13sl", SUM(CASE WHEN WEEKS=12 THEN AMT END) "13je", SUM(CASE WHEN WEEKS=12 THEN DISCOUNT END) "13zk" , SUM(CASE WHEN WEEKS=13 THEN QUANTITY END) "14sl", SUM(CASE WHEN WEEKS=13 THEN AMT END) "14je", SUM(CASE WHEN WEEKS=13 THEN DISCOUNT END) "14zk" , SUM(CASE WHEN WEEKS=14 THEN QUANTITY END) "15sl", SUM(CASE WHEN WEEKS=14 THEN AMT END) "15je", SUM(CASE WHEN WEEKS=14 THEN DISCOUNT END) "15zk" FROM TB GROUP BY CLIENTID, CLIENTDESC, STYLENO, STYLESET, STYLECATEGORY, STYLEDESC, STYLESORT ORDER BY CLIENTID ASC, STYLENO ASC
6cp74g22fzahf	WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count() as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND ash.instance_number = :inst AND ash.snap_id > :bid AND ash.snap_id <= :eid AND ash.wait_time = 0 GROUP BY ash.event_id ), evts as (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt, sum(w_time) as w_time , sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg, sum(w_time_fg) as w_time_fg FROM (SELECT es.event_id as event_id, es.total_waits - nvl(bs.total_waits, 0) as w_cnt, es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS, 0) as to_cnt, es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO, 0) as w_time , es.total_waits_fg - nvl(bs.total_waits_fg, 0) as w_cnt_fg, es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG, 0) as to_cnt_fg, es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG, 0) as w_time_fg FROM WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs WHERE es.dbid = :dbid AND es.instance_number = :inst AND es.snap_id = :eid AND bs.dbid(+) = :dbid AND bs.instance_number(+) = es.instance_number AND bs.snap_id(+) = :bid AND es.instance_number = bs.instance_number(+) AND es.event_id = bs.event_id(+) UNION ALL SELECT x.event_hash as event_id, 0 as w_cnt, 0 as to_cnt, 0 as w_time , 0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg FROM X$KEHEVTMAP x ) GROUP BY event_id ), awr_names as (SELECT e.event_id, e.event_name, e.wait_class_id, e.param eter1, e.parameter2, e.parameter3 FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid ), named_events as (SELECT names.event_id as event_id, names.event_name as event_name, evts.w_cnt as w_cnt, evts.to_cnt as to_cnt, evts.w_time as w_time, evts.w_cnt_fg as w_cnt_fg, evts.to_cnt_fg as to_cnt_fg, evts.w_time_fg as w_time_fg, names.wait_class_id as wait_class_id, names.parameter1 as p1, names.parameter2 as p2, names.parameter3 as p3 FROM evts, awr_names names WHERE evts.event_id = names.event_id AND names.wait_class_id <> 2723168908 ), data as (SELECT e.event_id as event_id, e.event_name as event_name, e.wait_class_id as wait_class_id, e.p1 as p1, e.p2 as p2, e.p3 as p3, e.w_cnt as total_w_cnt, e.to_cnt as total_to_cnt, e.w_time as total_w_time, e.w_cnt_fg as fg_w_cnt, e.to_cnt_fg as fg_to_cnt, e.w_time_fg as fg_w_time, nvl(a.cnt_total, 0) as total_ash_cnt, nvl(a.cnt_fg, 0) as fg_ash_cnt FROM named_events e, ash a WHERE e.event_id = a.event_id(+) ), final_query as (SELECT d.event_name, d.event_id, d.p1 as p1, case when (p1 is null OR p1 = '0') then 0 else 1 end as p1valid, d.p2 as p2, case when (p2 is null OR p2 = '0') then 0 else 1 end as p2valid, d.p3 as p3, case when (p3 is null OR p3 = '0') then 0 else 1 end as p3valid, nvl(e.keh_id, 0) as keh_evt_id, c.class# as class_num, d.wait_class_id as wait_class_id, c.keh_id as keh_ecl_id, round(d.total_ash_cnt, 0) as total_ash_cnt , round(d.fg_ash_cnt, 0) as fg_ash_cnt, round(d.fg_w_cnt, 0) as fg_w_cnt, round(d.fg_to_cnt, 0) as fg_to_cnt, round(d.fg_w_time, 0) as fg_w_time, round(d.total_w_cnt, 0) as total_w_cnt, round(d.total_to_cnt, 0) as total_to_cnt, round(d.total_w_time, 0) as total_w_time from data d, X$KEHEVTMAP e , X$KEHECLMAP c where d.event_id = e.event_hash(+) and d.wait_class_id = c.class_hash ) SELECT FROM final_query WHERE keh_evt_id > 0 OR total_w_time > 0 ORDER BY wait_class_id, fg_w_time DESC, event_id
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
772s25v1y0x8k	select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7sz1kxn37kaph	select m.clientdesc clientdesc, e.styleno, e.sizedesc, sum(b.quantity) quantity, sum(b.amt) amt from ys_sale a inner join ys_saledetail b on a.saleid=b.saleid inner join ys_branch c on a.branchid=c.branchid inner join ys_client D on c.KEEPERCLIENTID=D.CLIENTID inner join product_inf e on e.productid=b.productid inner join ys_agent m on m.managentclientid=d.managentclientid where a.workdate between to_date('2012-12-03', 'yyyy-mm-dd') and to_date('2013-03-17', 'yyyy-mm-dd') and a.saletype<>1 and substr(e.styleno, 2, 2)='31' and length(e.styleno)>8 and a.branchid not in(select branchid from ys_branch19) group by m.clientdesc, e.styleno, e.sizedesc
8nrcfxksg0b06	select s.synonym_name 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')
9wncfacx0nj9h	insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)
ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bsa0wjtftg3uw	select file# from file$ where ts#=:1
c5za69x5y4p34	begin -- Call the procedure proc_sale_week(rq1 => :rq1, rq2 => :rq2, sp_result => :sp_result); end;
chsyr0gssbuqf	select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d83wuwxj37spw	select m.clientdesc clientdesc, e.styleno, e.colordesc, sum(b.quantity) quantity, sum(b.amt) amt from ys_sale a inner join ys_saledetail b on a.saleid=b.saleid inner join ys_branch c on a.branchid=c.branchid inner join ys_client D on c.KEEPERCLIENTID=D.CLIENTID inner join product_inf e on e.productid=b.productid inner join ys_agent m on m.managentclientid=d.managentclientid where a.workdate between to_date('2012-12-03', 'yyyy-mm-dd') and to_date('2013-03-17', 'yyyy-mm-dd') and a.saletype<>1 and substr(e.styleno, 2, 2)='31' and length(e.styleno)>8 and a.branchid not in(select branchid from ys_branch19) group by m.clientdesc, e.styleno, e.colordesc
f2vs2dt4yhfpa	select m.clientdesc clientdesc, e.styleno, e.colordesc, sum(b.quantity) quantity, sum(b.amt) amt from ys_sale a inner join ys_saledetail b on a.saleid=b.saleid inner join ys_branch c on a.branchid=c.branchid inner join ys_client D on c.KEEPERCLIENTID=D.CLIENTID inner join product_inf e on e.productid=b.productid inner join ys_agent m on m.managentclientid=d.managentclientid where a.workdate between to_date('2013-01-14', 'yyyy-mm-dd') and to_date('2013-03-17', 'yyyy-mm-dd') and a.saletype<>1 and substr(e.styleno, 2, 2)='32' and length(e.styleno)>8 and a.branchid not in(select branchid from ys_branch19) group by m.clientdesc, e.styleno, e.colordesc
f80h0xb1qvbsk	SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual
fdjtrdaz8hpvg	INSERT /+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a. flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
fnk7155mk2jq6	insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
fvkynu9xgck8h	select PGA_TARGET_FOR_ESTIMATE s, PGA_TARGET_FACTOR * 100 f, ESTD_TIME t, BYTES_PROCESSED b from v$pga_target_advice order by PGA_TARGET_FOR_ESTIMATE
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g6gu1n3x0h1h4	select streams_pool_size_for_estimate s, streams_pool_size_factor * 100 f, estd_spill_time + estd_unspill_time, 0 from v$streams_pool_advice
gpwhsyjufj328	INSERT INTO "POS"."YS_GOODS" ("GOODSID", "ISACTIVE", "BARCODE", "BRANDID", "SIZEID", "COLORID", "STYLEID", "CREATEUSERID", "CREATEDATE", "UPDATEUSERID", "UPDATEDATE", "VERSIONID", "ISSYNC") VALUES (:a0, :a1, :a2, :a3, :a4, :a5, :a6, :a7, :a8, :a9, :a10, :a11, :a12)
grwydz59pu6mc	select text from view$ where rowid=:1
gvjxjrrx385ah	UPDATE "POS"."PRODUCT_INF" SET "VERSIONID" = :a1 WHERE "PRODUCTID" = :b0

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	0	0.00	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	926,681	85.74	9,085.11
CPU used when call started	868,872	80.39	8,518.35
CR blocks created	0	0.00	0.00
Cached Commit SCN referenced	49,054,401	4,538.47	480,925.50
Commit SCN cached	5,256	0.49	51.53
DB time	23,189,778	2,145.50	227,350.76
DBWR checkpoint buffers written	18,333	1.70	179.74
DBWR checkpoints	3	0.00	0.03
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	5,157	0.48	50.56
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	570	0.05	5.59
DBWR undo block writes	978	0.09	9.59
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	11	0.00	0.11
HSC Heap Segment Block Changes	3,433	0.32	33.66
Heap Segment Array Inserts	358	0.03	3.51
Heap Segment Array Updates	21	0.00	0.21
IMU pool not allocated	4,391	0.41	43.05
IMU- failed to get a private strand	4,391	0.41	43.05
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	10,973,716	1,015.28	107,585.45
PX local messages recv'd	1,392,649	128.85	13,653.42
PX local messages sent	1,392,927	128.87	13,656.15
Parallel operations downgraded 1 to 25 pct	0	0.00	0.00
Parallel operations downgraded 25 to 50 pct	4	0.00	0.04
Parallel operations downgraded 50 to 75 pct	3	0.00	0.03
Parallel operations downgraded to serial	10,074,598	932.09	98,770.57
Parallel operations not downgraded	4	0.00	0.04
RowCR - row contention	0	0.00	0.00
RowCR attempts	1	0.00	0.01
RowCR hits	1	0.00	0.01
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	5,128	0.47	50.27
SQL*Net roundtrips to/from dblink	0	0.00	0.00
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	7	0.00	0.07
TBS Extension: tasks executed	7	0.00	0.07
active txn count during cleanout	219	0.02	2.15
application wait time	103	0.01	1.01
background checkpoints completed	1	0.00	0.01
background checkpoints started	1	0.00	0.01
background timeouts	77,323	7.15	758.07
branch node splits	0	0.00	0.00
buffer is not pinned count	4,529,056	419.02	44,402.51
buffer is pinned count	14,833,607	1,372.39	145,427.52
bytes received via SQL*Net from client	352,905	32.65	3,459.85
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	8,888,599	822.37	87,143.13
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	14,895	1.38	146.03
calls to kcmgas	1,494	0.14	14.65
calls to kcmgcs	60,638,888	5,610.25	594,498.90
cell physical IO interconnect bytes	1,375,582,813,184	127,267,660.13	13,486,106,011.61
change write time	107	0.01	1.05
cleanout - number of ktugct calls	7,859,540	727.16	77,054.31
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	7,859,316	727.14	77,052.12
cluster key scan block gets	2,190	0.20	21.47
cluster key scans	2,129	0.20	20.87
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	11	0.00	0.11
commit batch/immediate requested	11	0.00	0.11
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	10	0.00	0.10
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	2,226	0.21	21.82
commit cleanouts successfully completed	2,216	0.21	21.73
commit immediate performed	11	0.00	0.11
commit immediate requested	11	0.00	0.11
commit nowait performed	7	0.00	0.07
commit nowait requested	7	0.00	0.07
commit txn count during cleanout	7,860,834	727.28	77,067.00
commit wait/nowait performed	7	0.00	0.07
commit wait/nowait requested	7	0.00	0.07
concurrency wait time	29,121	2.69	285.50
consistent changes	57	0.01	0.56
consistent gets	256,496,010	23,730.78	2,514,666.76
consistent gets - examination	26,557,486	2,457.07	260,367.51
consistent gets direct	164,506,262	15,219.97	1,612,806.49
consistent gets from cache	91,989,748	8,510.81	901,860.27
consistent gets from cache (fastpath)	64,771,512	5,992.60	635,014.82
cursor authentications	71	0.01	0.70
data blocks consistent reads - undo records applied	0	0.00	0.00
db block changes	38,107	3.53	373.60
db block gets	28,370	2.62	278.14
db block gets direct	123	0.01	1.21
db block gets from cache	28,247	2.61	276.93
db block gets from cache (fastpath)	5,591	0.52	54.81
deferred (CURRENT) block cleanout applications	1,221	0.11	11.97
dirty buffers inspected	188,103	17.40	1,844.15
enqueue conversions	3,276	0.30	32.12
enqueue releases	117,802	10.90	1,154.92
enqueue requests	118,280	10.94	1,159.61
enqueue timeouts	234	0.02	2.29
enqueue waits	125	0.01	1.23
exchange deadlocks	0	0.00	0.00
execute count	15,304	1.42	150.04
failed probes on index block reclamation	0	0.00	0.00
file io service time	598,137	55.34	5,864.09
file io wait time	4,840,183,011	447,809.29	47,452,774.62
free buffer inspected	3,277,750	303.25	32,134.80
free buffer requested	2,288,647	211.74	22,437.72
heap block compress	163	0.02	1.60
hot buffers moved to head of LRU	2,288,575	211.74	22,437.01
immediate (CR) block cleanout applications	7,859,316	727.14	77,052.12
immediate (CURRENT) block cleanout applications	525	0.05	5.15
index crx upgrade (positioned)	181	0.02	1.77
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	37	0.00	0.36
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	6,284,050	581.39	61,608.33
index scans kdiixs1	128,471	11.89	1,259.52
leaf node 90-10 splits	84	0.01	0.82
leaf node splits	101	0.01	0.99
lob reads	0	0.00	0.00
lob writes	79	0.01	0.77
lob writes unaligned	79	0.01	0.77
logons cumulative	700	0.06	6.86
max cf enq hold time	0	0.00	0.00
messages received	17,501	1.62	171.58
messages sent	17,501	1.62	171.58
min active SCN optimization applied on CR	1,309,244	121.13	12,835.73
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	161,434,914	14,935.81	1,582,695.24
non-idle wait count	13,449,755	1,244.36	131,860.34
non-idle wait time	949,887	87.88	9,312.62
opened cursors cumulative	9,875	0.91	96.81
parse count (describe)	4	0.00	0.04
parse count (failures)	3	0.00	0.03
parse count (hard)	153	0.01	1.50
parse count (total)	9,379	0.87	91.95
parse time cpu	1,810	0.17	17.75
parse time elapsed	28,233	2.61	276.79
physical read IO requests	13,295,351	1,230.07	130,346.58
physical read bytes	1,369,743,753,216	126,727,435.66	13,428,860,325.65
physical read total IO requests	13,316,053	1,231.99	130,549.54
physical read total bytes	1,370,057,589,760	126,756,471.53	13,431,937,154.51
physical read total multi block requests	904,520	83.69	8,867.84
physical reads	167,205,043	15,469.66	1,639,265.13
physical reads cache	2,287,886	211.67	22,430.25
physical reads cache prefetch	50,996	4.72	499.96
physical reads direct	164,917,162	15,257.98	1,616,834.92
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	410,892	38.02	4,028.35
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	217,694	20.14	2,134.25
physical write bytes	5,386,338,304	498,339.08	52,807,238.27
physical write total IO requests	226,484	20.95	2,220.43
physical write total bytes	5,525,223,424	511,188.60	54,168,857.10
physical write total multi block requests	10,583	0.98	103.75
physical writes	657,512	60.83	6,446.20
physical writes direct	444,681	41.14	4,359.62
physical writes direct (lob)	18	0.00	0.18
physical writes direct temporary tablespace	444,568	41.13	4,358.51
physical writes from cache	212,831	19.69	2,086.58
physical writes non checkpoint	470,823	43.56	4,615.91
pinned buffers inspected	2	0.00	0.02
pinned cursors current	82	0.01	0.80
prefetch clients - default	17	0.00	0.17
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	64,062	5.93	628.06
process last non-idle time	156,086	14.44	1,530.25
queries parallelized	9	0.00	0.09
recursive calls	111,738	10.34	1,095.47
recursive cpu usage	452,646	41.88	4,437.71
redo blocks checksummed by FG (exclusive)	13,912	1.29	136.39
redo blocks written	24,074	2.23	236.02
redo buffer allocation retries	2	0.00	0.02
redo entries	31,517	2.92	308.99
redo log space requests	2	0.00	0.02
redo log space wait time	5	0.00	0.05
redo ordering marks	465	0.04	4.56
redo size	11,709,436	1,083.35	114,798.39
redo size for direct writes	1,352	0.13	13.25
redo subscn max counts	20,932	1.94	205.22
redo synch time	11	0.00	0.11
redo synch writes	50	0.00	0.49
redo wastage	227,352	21.03	2,228.94
redo write time	177	0.02	1.74
redo writes	781	0.07	7.66
rollback changes - undo records applied	22	0.00	0.22
rollbacks only - consistent read gets	0	0.00	0.00
root node splits	0	0.00	0.00
rows fetched via callback	42,929	3.97	420.87
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	7,364	0.68	72.20
session logical reads	256,524,358	23,733.40	2,514,944.69
shared hash latch upgrades - no wait	1,674,290	154.90	16,414.61
shared hash latch upgrades - wait	13	0.00	0.13
sorts (disk)	1	0.00	0.01
sorts (memory)	6,747	0.62	66.15
sorts (rows)	12,689,288	1,174.00	124,404.78
sql area evicted	0	0.00	0.00
sql area purged	14	0.00	0.14
summed dirty queue length	762,017	70.50	7,470.75
switch current to new buffer	108	0.01	1.06
table fetch by rowid	6,477,780	599.32	63,507.65
table fetch continued row	41,273	3.82	404.64
table scan blocks gotten	164,687,616	15,236.75	1,614,584.47
table scan rows gotten	2,856,015,555	264,235.94	28,000,152.50
table scans (cache partitions)	4,702	0.44	46.10
table scans (direct read)	10,079,663	932.56	98,820.23
table scans (long tables)	10,081,886	932.77	98,842.02
table scans (rowid ranges)	11,998	1.11	117.63
table scans (short tables)	3,305	0.31	32.40
temp space allocated (bytes)	461,373,440	42,685.85	4,523,269.02
total cf enq hold time	6,910	0.64	67.75
total number of cf enq holders	36	0.00	0.35
total number of times SMON posted	7	0.00	0.07
transaction rollbacks	11	0.00	0.11
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	2,349,280	217.35	23,032.16
user I/O wait time	770,238	71.26	7,551.35
user calls	8,418	0.78	82.53
user commits	102	0.01	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	2	0.00	0.02
workarea executions - optimal	4,116	0.38	40.35
write clones created in background	0	0.00	0.00
write clones created in foreground	0	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 uga memory max	146,094,827,744	162,401,257,936
session pga memory	1,505,192,216	2,846,069,688
session pga memory max	2,914,481,048	7,735,244,664
session cursor cache count	54,733	56,260
session uga memory	4,025,756,544,416	4,130,062,567,416
opened cursors current	72	161
workarea memory allocated	809	457,024
logons current	38	122

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	0.33

Back to Instance Activity Statistics
Back to Top

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	1.2T	1023.31	119.143	14M	0.01	.001295	11.1M	0.22
Buffer Cache Reads	17.4G	206.51	1.65054	0M	0.00	0M	2235.7K	1.43
Direct Writes	0M	0.00	0M	3.4G	1.76	.320023	19.1K	43.04
DBWR	0M	0.00	0M	1.6G	18.36	.153766	2129	668.95
Others	310M	1.92	.028680	121M	0.74	.011194	28.7K	4.66
LGWR	1M	0.00	.000092	12M	0.08	.001110	825	1.67
TOTAL:	1.2T	1231.74	120.822	5.1G	20.94	.487390	13.3M	0.60

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	1.2T	1222.69	120.572	1.6G	18.42	.153674	0.26	2.72
Temp File	3.1G	7.82	.296153	3.4G	1.76	.320948	0.03	0.02
Control File	294M	1.74	.027200	117M	0.69	.010824	0.00
Log File	0M	0.00	0M	12M	0.08	.001110	0.00
TOTAL:	1.2T	1232.25	120.895	5.1G	20.95	.486557	0.26	2.70

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	1.2T	1023.32	119.144	14M	0.01	.001295	0
Direct Reads (Data File)	1.2T	1023.32	119.144	14M	0.01	.001295	0
Buffer Cache Reads	17.4G	206.51	1.65054	0M	0.00	0M	2235.7K	1.43
Buffer Cache Reads (Data File)	17.4G	206.51	1.65054	0M	0.00	0M	2235.7K	1.43
Direct Writes	0M	0.00	0M	3.4G	1.76	.320023	0
Direct Writes (Data File)	0M	0.00	0M	3.4G	1.76	.320023	0
DBWR	0M	0.00	0M	1.6G	18.36	.153766	0
DBWR (Data File)	0M	0.00	0M	1.6G	18.36	.153766	0
Others	309M	1.92	.028588	121M	0.74	.011194	21.2K	0.19
Others (Control File)	293M	1.74	.027108	117M	0.69	.010824	18.8K	0.00
Others (Data File)	16M	0.18	.001480	4M	0.04	.000370	2414	1.63
LGWR	1M	0.00	.000092	12M	0.08	.001110	22	0.05
LGWR (Log File)	0M	0.00	0M	12M	0.08	.001110	4	0.25
LGWR (Control File)	1M	0.00	.000092	0M	0.00	0M	18	0.00
TOTAL:	1.2T	1231.75	120.823	5.1G	20.94	.487390	2256.9K	1.42

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)
POS_DATA	10,105,164	935	0.02	4.99	334	0	135	5.93
POS_SALE_IX	1,666,042	154	0.27	1.00	18,415	2	9	11.11
POS_SALE_201302	250,483	23	8.22	6.44	11	0	24	5.83
POS_SALE_201301	190,662	18	3.43	7.30	8	0	12	8.33
POS_SALEDETAIL_IX	0	0	0.00	0.00	176,892	16	0	0.00
POS_SALE_201303	106,288	10	0.61	4.72	10	0	0	0.00
TEMP	84,526	8	0.00	4.86	19,064	2	0	0.00
POS_SALEDETAIL_201209	91,628	8	0.00	127.40	0	0	0	0.00
POS_SALEDETAIL_201207	66,554	6	0.00	127.37	0	0	0	0.00
POS_SALEDETAIL_201210	59,354	5	0.00	127.50	0	0	0	0.00
POS_SALEDETAIL_201212	39,937	4	0.00	127.37	0	0	0	0.00
POS_SALEDETAIL_201201	36,127	3	0.00	127.37	0	0	0	0.00
POS_SALEDETAIL_201302	35,383	3	0.00	127.14	0	0	0	0.00
POS_SALEDETAIL_201301	32,215	3	0.00	127.27	0	0	0	0.00
POS_SALEDETAIL_201208	29,437	3	0.00	127.41	0	0	0	0.00
POS_SALEDETAIL_201204	25,759	2	0.00	127.40	0	0	0	0.00
POS_SALEDETAIL_201205	24,787	2	0.00	127.28	0	0	0	0.00
POS_SALEDETAIL_201211	24,709	2	0.00	127.28	0	0	0	0.00
POS_SALEDETAIL_201007	23,839	2	0.00	127.32	0	0	0	0.00
POS_SALEDETAIL_201008	23,053	2	0.00	127.26	0	0	0	0.00
POS_SALEDETAIL_201005	23,047	2	0.00	127.34	0	0	0	0.00
POS_SALEDETAIL_201206	22,717	2	0.00	127.32	0	0	0	0.00
POS_SALEDETAIL_201006	22,693	2	0.00	127.22	0	0	0	0.00
POS_SALE_201212	21,430	2	0.02	34.43	8	0	0	0.00
POS_SALEDETAIL_201203	18,721	2	0.00	127.21	0	0	0	0.00
POS_SALEDETAIL_201101	17,095	2	0.00	127.16	0	0	0	0.00
POS_SALEDETAIL_201202	15,307	1	0.00	127.21	0	0	0	0.00
POS_SALEDETAIL_201110	14,779	1	0.00	127.15	0	0	0	0.00
POS_SALEDETAIL_201112	14,347	1	0.00	127.20	0	0	0	0.00
POS_SALEDETAIL_201109	13,879	1	0.00	127.16	0	0	0	0.00
POS_SALEDETAIL_201108	13,873	1	0.00	127.18	0	0	0	0.00
POS_SALEDETAIL_201105	12,325	1	0.00	127.03	0	0	0	0.00
POS_SALEDETAIL_201010	12,319	1	0.00	127.08	0	0	0	0.00
POS_SALEDETAIL_201001	11,917	1	0.00	127.09	0	0	0	0.00
POS_SALEDETAIL_201107	11,881	1	0.00	127.09	0	0	0	0.00
POS_SALEDETAIL_201011	11,581	1	0.00	126.99	0	0	0	0.00
POS_SALEDETAIL_201002	11,557	1	0.00	127.02	0	0	0	0.00
POS_SALEDETAIL_201004	11,539	1	0.00	127.04	0	0	0	0.00
POS_SALEDETAIL_201003	11,527	1	0.00	127.01	0	0	0	0.00
POS_SALEDETAIL_201012	11,527	1	0.00	127.05	0	0	0	0.00
POS_SALEDETAIL_201009	11,521	1	0.00	127.08	0	0	0	0.00
POS_SALEDETAIL_201104	11,515	1	0.00	127.04	0	0	0	0.00
POS_SALEDETAIL_201303	10,745	1	0.00	125.29	411	0	0	0.00
POS_SALEDETAIL_201111	11,143	1	0.00	127.03	0	0	0	0.00
POS_SALEDETAIL_201106	10,747	1	0.00	126.94	0	0	0	0.00
POS_SALEDETAIL_201102	8,461	1	0.00	126.67	0	0	0	0.00
POS_SALEDETAIL_201103	8,317	1	0.00	126.77	0	0	0	0.00
SYSAUX	657	0	0.79	1.03	1,097	0	0	0.00
SYSTEM	1,109	0	0.75	1.95	200	0	0	0.00
UNDOTBS1	36	0	0.00	1.00	1,218	0	0	0.00
POS_SALEDETAIL_2013	79	0	0.00	29.78	0	0	0	0.00
OGG	0	0	0.00	0.00	2	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
OGG	/u06/oradata/dcpos/ogg01.dbf	0	0			2	0	0	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA01.DBF	1,720	0	0.05	1.66	3	0	2	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA02.DBF	4,045	0	0.10	7.02	5	0	39	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA03.DBF	11,395	1	10.14	1.96	250	0	33	9.70
POS_DATA	/u06/oradata/dcpos/POS_DATA04.DBF	1,098	0	0.21	11.63	20	0	31	9.68
POS_DATA	/u06/oradata/dcpos/POS_DATA05.DBF	10,080,500	933	0.01	5.00	43	0	23	7.83
POS_DATA	/u06/oradata/dcpos/POS_DATA06.DBF	6,402	1	0.04	1.08	9	0	7	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA07.DBF	4	0	5.00	1.00	4	0	0	0.00
POS_SALEDETAIL_201001	/u07/oradata/dcpos/POS_SALEDETAIL_201001.DBF	2,748	0	0.00	127.40	0	0	0	0.00
POS_SALEDETAIL_201001	/u07/oradata/dcpos/POS_SALEDETAIL_2010011.DBF	2,689	0	0.00	125.05	0	0	0	0.00
POS_SALEDETAIL_201001	/u07/oradata/dcpos/POS_SALEDETAIL_2010012.DBF	2,496	0	0.00	127.80	0	0	0	0.00
POS_SALEDETAIL_201001	/u07/oradata/dcpos/POS_SALEDETAIL_2010013.DBF	2,832	0	0.00	127.81	0	0	0	0.00
POS_SALEDETAIL_201001	/u07/oradata/dcpos/POS_SALEDETAIL_2010014.DBF	1,152	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201002	/u07/oradata/dcpos/POS_SALEDETAIL_201002.DBF	3,024	0	0.00	126.55	0	0	0	0.00
POS_SALEDETAIL_201002	/u07/oradata/dcpos/POS_SALEDETAIL_2010021.DBF	2,917	0	0.00	125.95	0	0	0	0.00
POS_SALEDETAIL_201002	/u07/oradata/dcpos/POS_SALEDETAIL_2010022.DBF	1,392	0	0.00	127.82	0	0	0	0.00
POS_SALEDETAIL_201002	/u07/oradata/dcpos/POS_SALEDETAIL_2010023.DBF	1,728	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201002	/u07/oradata/dcpos/POS_SALEDETAIL_2010024.DBF	1,728	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201002	/u07/oradata/dcpos/POS_SALEDETAIL_2010025.DBF	768	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201003	/u07/oradata/dcpos/POS_SALEDETAIL_201003.DBF	3,391	0	0.00	126.34	0	0	0	0.00
POS_SALEDETAIL_201003	/u07/oradata/dcpos/POS_SALEDETAIL_2010031.DBF	2,520	0	0.00	126.05	0	0	0	0.00
POS_SALEDETAIL_201003	/u07/oradata/dcpos/POS_SALEDETAIL_2010032.DBF	960	0	0.00	127.82	0	0	0	0.00
POS_SALEDETAIL_201003	/u07/oradata/dcpos/POS_SALEDETAIL_2010033.DBF	1,296	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201003	/u07/oradata/dcpos/POS_SALEDETAIL_2010034.DBF	1,296	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201003	/u07/oradata/dcpos/POS_SALEDETAIL_2010035.DBF	1,296	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201003	/u07/oradata/dcpos/POS_SALEDETAIL_2010036.DBF	768	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201004	/u07/oradata/dcpos/POS_SALEDETAIL_201004.DBF	2,257	0	0.00	124.75	0	0	0	0.00
POS_SALEDETAIL_201004	/u07/oradata/dcpos/POS_SALEDETAIL_2010041.DBF	3,168	0	0.00	127.34	0	0	0	0.00
POS_SALEDETAIL_201004	/u07/oradata/dcpos/POS_SALEDETAIL_2010042.DBF	1,920	0	0.00	127.80	0	0	0	0.00
POS_SALEDETAIL_201004	/u07/oradata/dcpos/POS_SALEDETAIL_2010043.DBF	1,890	0	0.00	127.54	0	0	0	0.00
POS_SALEDETAIL_201004	/u07/oradata/dcpos/POS_SALEDETAIL_2010044.DBF	1,536	0	0.00	127.78	0	0	0	0.00
POS_SALEDETAIL_201004	/u07/oradata/dcpos/POS_SALEDETAIL_2010045.DBF	768	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201005	/u07/oradata/dcpos/POS_SALEDETAIL_2010052.DBF	2,395	0	0.00	125.07	0	0	0	0.00
POS_SALEDETAIL_201005	/u07/oradata/dcpos/POS_SALEDETAIL_2010053.DBF	9,192	1	0.00	127.36	0	0	0	0.00
POS_SALEDETAIL_201005	/u07/oradata/dcpos/POS_SALEDETAIL_2010054.DBF	3,840	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201005	/u07/oradata/dcpos/POS_SALEDETAIL_2010055.DBF	3,840	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201005	/u07/oradata/dcpos/POS_SALEDETAIL_2010056.DBF	3,780	0	0.00	127.66	0	0	0	0.00
POS_SALEDETAIL_201006	/u07/oradata/dcpos/POS_SALEDETAIL_2010061.DBF	49	0	0.00	10.55	0	0	0	0.00
POS_SALEDETAIL_201006	/u07/oradata/dcpos/POS_SALEDETAIL_2010062.DBF	11,160	1	0.00	127.29	0	0	0	0.00
POS_SALEDETAIL_201006	/u07/oradata/dcpos/POS_SALEDETAIL_2010063.DBF	3,462	0	0.00	127.65	0	0	0	0.00
POS_SALEDETAIL_201006	/u07/oradata/dcpos/POS_SALEDETAIL_2010064.DBF	3,462	0	0.00	127.65	0	0	0	0.00
POS_SALEDETAIL_201006	/u07/oradata/dcpos/POS_SALEDETAIL_2010065.DBF	3,408	0	0.00	127.53	0	0	0	0.00
POS_SALEDETAIL_201006	/u07/oradata/dcpos/POS_SALEDETAIL_2010066.DBF	1,152	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201007	/u07/oradata/dcpos/POS_SALEDETAIL_201007.DBF	384	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201007	/u07/oradata/dcpos/POS_SALEDETAIL_2010071.DBF	361	0	0.00	119.12	0	0	0	0.00
POS_SALEDETAIL_201007	/u07/oradata/dcpos/POS_SALEDETAIL_2010072.DBF	10,038	1	0.00	126.87	0	0	0	0.00
POS_SALEDETAIL_201007	/u07/oradata/dcpos/POS_SALEDETAIL_2010073.DBF	3,840	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201007	/u07/oradata/dcpos/POS_SALEDETAIL_2010074.DBF	3,840	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201007	/u07/oradata/dcpos/POS_SALEDETAIL_2010075.DBF	3,840	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201007	/u07/oradata/dcpos/POS_SALEDETAIL_2010076.DBF	1,536	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201008	/u07/oradata/dcpos/POS_SALEDETAIL_201008.DBF	18	0	0.00	12.67	0	0	0	0.00
POS_SALEDETAIL_201008	/u07/oradata/dcpos/POS_SALEDETAIL_2010081.DBF	13	0	0.00	5.62	0	0	0	0.00
POS_SALEDETAIL_201008	/u07/oradata/dcpos/POS_SALEDETAIL_2010082.DBF	11,190	1	0.00	126.97	0	0	0	0.00
POS_SALEDETAIL_201008	/u07/oradata/dcpos/POS_SALEDETAIL_2010083.DBF	3,072	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201008	/u07/oradata/dcpos/POS_SALEDETAIL_2010084.DBF	3,072	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201008	/u07/oradata/dcpos/POS_SALEDETAIL_2010085.DBF	3,000	0	0.00	127.72	0	0	0	0.00
POS_SALEDETAIL_201008	/u07/oradata/dcpos/POS_SALEDETAIL_2010086.DBF	2,688	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201009	/u07/oradata/dcpos/POS_SALEDETAIL_201009.DBF	2,389	0	0.00	125.59	0	0	0	0.00
POS_SALEDETAIL_201009	/u07/oradata/dcpos/POS_SALEDETAIL_2010091.DBF	3,228	0	0.00	126.79	0	0	0	0.00
POS_SALEDETAIL_201009	/u07/oradata/dcpos/POS_SALEDETAIL_2010092.DBF	1,728	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201009	/u07/oradata/dcpos/POS_SALEDETAIL_2010093.DBF	1,728	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201009	/u07/oradata/dcpos/POS_SALEDETAIL_2010094.DBF	1,680	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201009	/u07/oradata/dcpos/POS_SALEDETAIL_2010095.DBF	384	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201009	/u07/oradata/dcpos/POS_SALEDETAIL_2010096.DBF	384	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201010	/u07/oradata/dcpos/POS_SALEDETAIL_201010.DBF	2,431	0	0.00	124.73	0	0	0	0.00
POS_SALEDETAIL_201010	/u07/oradata/dcpos/POS_SALEDETAIL_2010101.DBF	2,496	0	0.00	127.24	0	0	0	0.00
POS_SALEDETAIL_201010	/u07/oradata/dcpos/POS_SALEDETAIL_2010102.DBF	1,728	0	0.00	127.76	0	0	0	0.00
POS_SALEDETAIL_201010	/u07/oradata/dcpos/POS_SALEDETAIL_2010103.DBF	2,064	0	0.00	127.78	0	0	0	0.00
POS_SALEDETAIL_201010	/u07/oradata/dcpos/POS_SALEDETAIL_2010104.DBF	2,064	0	0.00	127.78	0	0	0	0.00
POS_SALEDETAIL_201010	/u07/oradata/dcpos/POS_SALEDETAIL_2010105.DBF	768	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201010	/u07/oradata/dcpos/POS_SALEDETAIL_2010106.DBF	768	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201011	/u07/oradata/dcpos/POS_SALEDETAIL_201011.DBF	2,611	0	0.00	126.01	0	0	0	0.00
POS_SALEDETAIL_201011	/u07/oradata/dcpos/POS_SALEDETAIL_2010111.DBF	3,006	0	0.00	126.25	0	0	0	0.00
POS_SALEDETAIL_201011	/u07/oradata/dcpos/POS_SALEDETAIL_2010112.DBF	1,344	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201011	/u07/oradata/dcpos/POS_SALEDETAIL_2010113.DBF	1,680	0	0.00	127.84	0	0	0	0.00
POS_SALEDETAIL_201011	/u07/oradata/dcpos/POS_SALEDETAIL_2010114.DBF	1,644	0	0.00	127.69	0	0	0	0.00
POS_SALEDETAIL_201011	/u07/oradata/dcpos/POS_SALEDETAIL_2010115.DBF	1,296	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201012	/u07/oradata/dcpos/POS_SALEDETAIL_201012.DBF	2,719	0	0.00	126.19	0	0	0	0.00
POS_SALEDETAIL_201012	/u07/oradata/dcpos/POS_SALEDETAIL_2010121.DBF	3,192	0	0.00	126.39	0	0	0	0.00
POS_SALEDETAIL_201012	/u07/oradata/dcpos/POS_SALEDETAIL_2010122.DBF	1,392	0	0.00	127.82	0	0	0	0.00
POS_SALEDETAIL_201012	/u07/oradata/dcpos/POS_SALEDETAIL_2010123.DBF	1,728	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201012	/u07/oradata/dcpos/POS_SALEDETAIL_2010124.DBF	1,728	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201012	/u07/oradata/dcpos/POS_SALEDETAIL_2010125.DBF	768	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201101	/u07/oradata/dcpos/POS_SALEDETAIL_201101.DBF	1,171	0	0.00	125.90	0	0	0	0.00
POS_SALEDETAIL_201101	/u07/oradata/dcpos/POS_SALEDETAIL_2011011.DBF	1,164	0	0.00	126.72	0	0	0	0.00
POS_SALEDETAIL_201101	/u07/oradata/dcpos/POS_SALEDETAIL_2011012.DBF	4,194	0	0.00	126.43	0	0	0	0.00
POS_SALEDETAIL_201101	/u07/oradata/dcpos/POS_SALEDETAIL_2011013.DBF	4,806	0	0.00	127.46	0	0	0	0.00
POS_SALEDETAIL_201101	/u07/oradata/dcpos/POS_SALEDETAIL_2011014.DBF	2,880	0	0.00	127.80	0	0	0	0.00
POS_SALEDETAIL_201101	/u07/oradata/dcpos/POS_SALEDETAIL_2011015.DBF	2,880	0	0.00	127.81	0	0	0	0.00
POS_SALEDETAIL_201102	/u07/oradata/dcpos/POS_SALEDETAIL_201102.DBF	1,621	0	0.00	124.66	0	0	0	0.00
POS_SALEDETAIL_201102	/u07/oradata/dcpos/POS_SALEDETAIL_2011021.DBF	1,602	0	0.00	125.61	0	0	0	0.00
POS_SALEDETAIL_201102	/u07/oradata/dcpos/POS_SALEDETAIL_2011022.DBF	1,248	0	0.00	127.63	0	0	0	0.00
POS_SALEDETAIL_201102	/u07/oradata/dcpos/POS_SALEDETAIL_2011023.DBF	1,584	0	0.00	127.68	0	0	0	0.00
POS_SALEDETAIL_201102	/u07/oradata/dcpos/POS_SALEDETAIL_2011024.DBF	1,542	0	0.00	127.49	0	0	0	0.00
POS_SALEDETAIL_201102	/u07/oradata/dcpos/POS_SALEDETAIL_2011025.DBF	864	0	0.00	127.67	0	0	0	0.00
POS_SALEDETAIL_201103	/u07/oradata/dcpos/POS_SALEDETAIL_201103.DBF	1,453	0	0.00	126.22	0	0	0	0.00
POS_SALEDETAIL_201103	/u07/oradata/dcpos/POS_SALEDETAIL_2011031.DBF	1,524	0	0.00	124.22	0	0	0	0.00
POS_SALEDETAIL_201103	/u07/oradata/dcpos/POS_SALEDETAIL_2011032.DBF	1,344	0	0.00	127.62	0	0	0	0.00
POS_SALEDETAIL_201103	/u07/oradata/dcpos/POS_SALEDETAIL_2011033.DBF	1,680	0	0.00	127.67	0	0	0	0.00
POS_SALEDETAIL_201103	/u07/oradata/dcpos/POS_SALEDETAIL_2011034.DBF	1,500	0	0.00	127.61	0	0	0	0.00
POS_SALEDETAIL_201103	/u07/oradata/dcpos/POS_SALEDETAIL_2011035.DBF	816	0	0.00	127.68	0	0	0	0.00
POS_SALEDETAIL_201104	/u07/oradata/dcpos/POS_SALEDETAIL_201104.DBF	2,137	0	0.00	126.00	0	0	0	0.00
POS_SALEDETAIL_201104	/u07/oradata/dcpos/POS_SALEDETAIL_2011041.DBF	1,896	0	0.00	125.57	0	0	0	0.00
POS_SALEDETAIL_201104	/u07/oradata/dcpos/POS_SALEDETAIL_2011042.DBF	1,872	0	0.00	127.74	0	0	0	0.00
POS_SALEDETAIL_201104	/u07/oradata/dcpos/POS_SALEDETAIL_2011043.DBF	2,208	0	0.00	127.76	0	0	0	0.00
POS_SALEDETAIL_201104	/u07/oradata/dcpos/POS_SALEDETAIL_2011044.DBF	2,154	0	0.00	127.53	0	0	0	0.00
POS_SALEDETAIL_201104	/u07/oradata/dcpos/POS_SALEDETAIL_2011045.DBF	1,248	0	0.00	127.85	0	0	0	0.00
POS_SALEDETAIL_201105	/u07/oradata/dcpos/POS_SALEDETAIL_201105.DBF	2,094	0	0.00	125.73	0	0	0	0.00
POS_SALEDETAIL_201105	/u07/oradata/dcpos/POS_SALEDETAIL_2011051.DBF	2,281	0	0.00	125.78	0	0	0	0.00
POS_SALEDETAIL_201105	/u07/oradata/dcpos/POS_SALEDETAIL_2011052.DBF	1,536	0	0.00	127.78	0	0	0	0.00
POS_SALEDETAIL_201105	/u07/oradata/dcpos/POS_SALEDETAIL_2011053.DBF	1,536	0	0.00	127.78	0	0	0	0.00
POS_SALEDETAIL_201105	/u07/oradata/dcpos/POS_SALEDETAIL_2011054.DBF	1,536	0	0.00	127.79	0	0	0	0.00
POS_SALEDETAIL_201105	/u07/oradata/dcpos/POS_SALEDETAIL_2011055.DBF	1,854	0	0.00	127.58	0	0	0	0.00
POS_SALEDETAIL_201105	/u07/oradata/dcpos/POS_SALEDETAIL_2011056.DBF	1,488	0	0.00	127.79	0	0	0	0.00
POS_SALEDETAIL_201106	/u07/oradata/dcpos/POS_SALEDETAIL_201106.DBF	1,861	0	0.00	125.02	0	0	0	0.00
POS_SALEDETAIL_201106	/u07/oradata/dcpos/POS_SALEDETAIL_2011061.DBF	1,890	0	0.00	125.90	0	0	0	0.00
POS_SALEDETAIL_201106	/u07/oradata/dcpos/POS_SALEDETAIL_2011062.DBF	1,920	0	0.00	127.73	0	0	0	0.00
POS_SALEDETAIL_201106	/u07/oradata/dcpos/POS_SALEDETAIL_2011063.DBF	1,920	0	0.00	127.73	0	0	0	0.00
POS_SALEDETAIL_201106	/u07/oradata/dcpos/POS_SALEDETAIL_2011064.DBF	1,920	0	0.00	127.73	0	0	0	0.00
POS_SALEDETAIL_201106	/u07/oradata/dcpos/POS_SALEDETAIL_2011065.DBF	1,236	0	0.00	127.79	0	0	0	0.00
POS_SALEDETAIL_201107	/u07/oradata/dcpos/POS_SALEDETAIL_2011071.DBF	2,100	0	0.00	125.44	0	0	0	0.00
POS_SALEDETAIL_201107	/u07/oradata/dcpos/POS_SALEDETAIL_2011072.DBF	1,632	0	0.00	127.76	0	0	0	0.00
POS_SALEDETAIL_201107	/u07/oradata/dcpos/POS_SALEDETAIL_2011073.DBF	2,581	0	0.00	126.50	0	0	0	0.00
POS_SALEDETAIL_201107	/u07/oradata/dcpos/POS_SALEDETAIL_2011074.DBF	1,632	0	0.00	127.78	0	0	0	0.00
POS_SALEDETAIL_201107	/u07/oradata/dcpos/POS_SALEDETAIL_2011075.DBF	1,968	0	0.00	127.79	0	0	0	0.00
POS_SALEDETAIL_201107	/u07/oradata/dcpos/POS_SALEDETAIL_2011076.DBF	1,968	0	0.00	127.79	0	0	0	0.00
POS_SALEDETAIL_201108	/u07/oradata/dcpos/POS_SALEDETAIL_201108.DBF	1,741	0	0.00	125.88	0	0	0	0.00
POS_SALEDETAIL_201108	/u07/oradata/dcpos/POS_SALEDETAIL_2011081.DBF	2,388	0	0.00	125.69	0	0	0	0.00
POS_SALEDETAIL_201108	/u07/oradata/dcpos/POS_SALEDETAIL_2011082.DBF	2,736	0	0.00	127.76	0	0	0	0.00
POS_SALEDETAIL_201108	/u07/oradata/dcpos/POS_SALEDETAIL_2011083.DBF	2,736	0	0.00	127.76	0	0	0	0.00
POS_SALEDETAIL_201108	/u07/oradata/dcpos/POS_SALEDETAIL_2011084.DBF	2,736	0	0.00	127.77	0	0	0	0.00
POS_SALEDETAIL_201108	/u07/oradata/dcpos/POS_SALEDETAIL_2011085.DBF	1,536	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201109	/u07/oradata/dcpos/POS_SALEDETAIL_201109.DBF	1,339	0	0.00	122.94	0	0	0	0.00
POS_SALEDETAIL_201109	/u07/oradata/dcpos/POS_SALEDETAIL_2011091.DBF	1,404	0	0.00	126.41	0	0	0	0.00
POS_SALEDETAIL_201109	/u07/oradata/dcpos/POS_SALEDETAIL_2011092.DBF	3,072	0	0.00	127.73	0	0	0	0.00
POS_SALEDETAIL_201109	/u07/oradata/dcpos/POS_SALEDETAIL_2011093.DBF	3,072	0	0.00	127.73	0	0	0	0.00
POS_SALEDETAIL_201109	/u07/oradata/dcpos/POS_SALEDETAIL_2011094.DBF	3,072	0	0.00	127.74	0	0	0	0.00
POS_SALEDETAIL_201109	/u07/oradata/dcpos/POS_SALEDETAIL_2011095.DBF	1,920	0	0.00	127.87	0	0	0	0.00
POS_SALEDETAIL_201110	/u07/oradata/dcpos/POS_SALEDETAIL_201110.DBF	1,363	0	0.00	125.71	0	0	0	0.00
POS_SALEDETAIL_201110	/u07/oradata/dcpos/POS_SALEDETAIL_2011101.DBF	1,176	0	0.00	122.62	0	0	0	0.00
POS_SALEDETAIL_201110	/u07/oradata/dcpos/POS_SALEDETAIL_2011102.DBF	2,976	0	0.00	127.74	0	0	0	0.00
POS_SALEDETAIL_201110	/u07/oradata/dcpos/POS_SALEDETAIL_2011103.DBF	2,976	0	0.00	127.74	0	0	0	0.00
POS_SALEDETAIL_201110	/u07/oradata/dcpos/POS_SALEDETAIL_2011104.DBF	2,976	0	0.00	127.75	0	0	0	0.00
POS_SALEDETAIL_201110	/u07/oradata/dcpos/POS_SALEDETAIL_2011105.DBF	3,312	0	0.00	127.76	0	0	0	0.00
POS_SALEDETAIL_201111	/u07/oradata/dcpos/POS_SALEDETAIL_201111.DBF	1,146	0	0.00	122.51	0	0	0	0.00
POS_SALEDETAIL_201111	/u07/oradata/dcpos/POS_SALEDETAIL_2011111.DBF	1,159	0	0.00	126.51	0	0	0	0.00
POS_SALEDETAIL_201111	/u07/oradata/dcpos/POS_SALEDETAIL_2011112.DBF	2,400	0	0.00	127.68	0	0	0	0.00
POS_SALEDETAIL_201111	/u07/oradata/dcpos/POS_SALEDETAIL_2011113.DBF	2,400	0	0.00	127.68	0	0	0	0.00
POS_SALEDETAIL_201111	/u07/oradata/dcpos/POS_SALEDETAIL_2011114.DBF	2,400	0	0.00	127.69	0	0	0	0.00
POS_SALEDETAIL_201111	/u07/oradata/dcpos/POS_SALEDETAIL_2011115.DBF	1,638	0	0.00	127.73	0	0	0	0.00
POS_SALEDETAIL_201112	/u07/oradata/dcpos/POS_SALEDETAIL_201112.DBF	1,597	0	0.00	126.33	0	0	0	0.00
POS_SALEDETAIL_201112	/u07/oradata/dcpos/POS_SALEDETAIL_2011121.DBF	1,476	0	0.00	124.11	0	0	0	0.00
POS_SALEDETAIL_201112	/u07/oradata/dcpos/POS_SALEDETAIL_2011122.DBF	2,352	0	0.00	127.75	0	0	0	0.00
POS_SALEDETAIL_201112	/u07/oradata/dcpos/POS_SALEDETAIL_2011123.DBF	2,688	0	0.00	127.77	0	0	0	0.00
POS_SALEDETAIL_201112	/u07/oradata/dcpos/POS_SALEDETAIL_2011124.DBF	2,394	0	0.00	127.56	0	0	0	0.00
POS_SALEDETAIL_201112	/u07/oradata/dcpos/POS_SALEDETAIL_2011125.DBF	2,304	0	0.00	127.75	0	0	0	0.00
POS_SALEDETAIL_201112	/u07/oradata/dcpos/POS_SALEDETAIL_2011126.DBF	1,536	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201201	/u07/oradata/dcpos/POS_SALEDETAIL_201201.DBF	1,939	0	0.00	126.68	0	0	0	0.00
POS_SALEDETAIL_201201	/u07/oradata/dcpos/POS_SALEDETAIL_2012011.DBF	1,920	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201201	/u07/oradata/dcpos/POS_SALEDETAIL_2012012.DBF	4,986	0	0.00	126.42	0	0	0	0.00
POS_SALEDETAIL_201201	/u07/oradata/dcpos/POS_SALEDETAIL_2012013.DBF	7,602	1	0.00	127.52	0	0	0	0.00
POS_SALEDETAIL_201201	/u07/oradata/dcpos/POS_SALEDETAIL_2012014.DBF	7,530	1	0.00	127.45	0	0	0	0.00
POS_SALEDETAIL_201201	/u07/oradata/dcpos/POS_SALEDETAIL_2012015.DBF	7,542	1	0.00	127.52	0	0	0	0.00
POS_SALEDETAIL_201201	/u07/oradata/dcpos/POS_SALEDETAIL_2012016.DBF	4,608	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201202	/u07/oradata/dcpos/POS_SALEDETAIL_201202.DBF	2,052	0	0.00	125.25	0	0	0	0.00
POS_SALEDETAIL_201202	/u07/oradata/dcpos/POS_SALEDETAIL_2012021.DBF	1,891	0	0.00	126.36	0	0	0	0.00
POS_SALEDETAIL_201202	/u07/oradata/dcpos/POS_SALEDETAIL_2012022.DBF	3,252	0	0.00	127.65	0	0	0	0.00
POS_SALEDETAIL_201202	/u07/oradata/dcpos/POS_SALEDETAIL_2012023.DBF	2,976	0	0.00	127.69	0	0	0	0.00
POS_SALEDETAIL_201202	/u07/oradata/dcpos/POS_SALEDETAIL_2012024.DBF	2,976	0	0.00	127.70	0	0	0	0.00
POS_SALEDETAIL_201202	/u07/oradata/dcpos/POS_SALEDETAIL_2012025.DBF	2,160	0	0.00	127.83	0	0	0	0.00
POS_SALEDETAIL_201203	/u07/oradata/dcpos/POS_SALEDETAIL_201203.DBF	2,646	0	0.00	127.36	0	0	0	0.00
POS_SALEDETAIL_201203	/u07/oradata/dcpos/POS_SALEDETAIL_2012031.DBF	2,683	0	0.00	125.51	0	0	0	0.00
POS_SALEDETAIL_201203	/u07/oradata/dcpos/POS_SALEDETAIL_2012032.DBF	5,268	0	0.00	127.39	0	0	0	0.00
POS_SALEDETAIL_201203	/u07/oradata/dcpos/POS_SALEDETAIL_2012033.DBF	5,052	0	0.00	127.43	0	0	0	0.00
POS_SALEDETAIL_201203	/u07/oradata/dcpos/POS_SALEDETAIL_2012034.DBF	3,072	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201204	/u07/oradata/dcpos/POS_SALEDETAIL_201204.DBF	1,998	0	0.00	125.86	0	0	0	0.00
POS_SALEDETAIL_201204	/u07/oradata/dcpos/POS_SALEDETAIL_2012041.DBF	1,993	0	0.00	125.74	0	0	0	0.00
POS_SALEDETAIL_201204	/u07/oradata/dcpos/POS_SALEDETAIL_2012042.DBF	3,024	0	0.00	127.79	0	0	0	0.00
POS_SALEDETAIL_201204	/u07/oradata/dcpos/POS_SALEDETAIL_2012043.DBF	3,024	0	0.00	127.79	0	0	0	0.00
POS_SALEDETAIL_201204	/u07/oradata/dcpos/POS_SALEDETAIL_2012044.DBF	3,366	0	0.00	127.57	0	0	0	0.00
POS_SALEDETAIL_201204	/u07/oradata/dcpos/POS_SALEDETAIL_2012045.DBF	3,366	0	0.00	127.57	0	0	0	0.00
POS_SALEDETAIL_201204	/u07/oradata/dcpos/POS_SALEDETAIL_2012046.DBF	3,228	0	0.00	127.57	0	0	0	0.00
POS_SALEDETAIL_201204	/u07/oradata/dcpos/POS_SALEDETAIL_2012047.DBF	2,880	0	0.00	127.80	0	0	0	0.00
POS_SALEDETAIL_201204	/u07/oradata/dcpos/POS_SALEDETAIL_2012048.DBF	2,880	0	0.00	127.80	0	0	0	0.00
POS_SALEDETAIL_201205	/u07/oradata/dcpos/POS_SALEDETAIL_201205.DBF	2,509	0	0.00	126.99	0	0	0	0.00
POS_SALEDETAIL_201205	/u07/oradata/dcpos/POS_SALEDETAIL_2012051.DBF	2,682	0	0.00	125.57	0	0	0	0.00
POS_SALEDETAIL_201205	/u07/oradata/dcpos/POS_SALEDETAIL_2012052.DBF	5,244	0	0.00	127.49	0	0	0	0.00
POS_SALEDETAIL_201205	/u07/oradata/dcpos/POS_SALEDETAIL_2012053.DBF	5,580	1	0.00	127.51	0	0	0	0.00
POS_SALEDETAIL_201205	/u07/oradata/dcpos/POS_SALEDETAIL_2012054.DBF	5,580	1	0.00	127.51	0	0	0	0.00
POS_SALEDETAIL_201205	/u07/oradata/dcpos/POS_SALEDETAIL_2012055.DBF	3,192	0	0.00	127.84	0	0	0	0.00
POS_SALEDETAIL_201206	/u07/oradata/dcpos/POS_SALEDETAIL_201206.DBF	3,199	0	0.00	126.51	0	0	0	0.00
POS_SALEDETAIL_201206	/u07/oradata/dcpos/POS_SALEDETAIL_2012061.DBF	3,030	0	0.00	126.63	0	0	0	0.00
POS_SALEDETAIL_201206	/u07/oradata/dcpos/POS_SALEDETAIL_2012062.DBF	6,156	1	0.00	127.51	0	0	0	0.00
POS_SALEDETAIL_201206	/u07/oradata/dcpos/POS_SALEDETAIL_2012063.DBF	6,492	1	0.00	127.53	0	0	0	0.00
POS_SALEDETAIL_201206	/u07/oradata/dcpos/POS_SALEDETAIL_2012064.DBF	3,840	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_201207.DBF	6,600	1	0.00	127.05	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012071.DBF	6,649	1	0.00	127.02	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012072.DBF	14,976	1	0.00	127.42	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012073.DBF	7,176	1	0.00	127.48	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012074.DBF	14,203	1	0.00	127.44	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012075.DBF	16,950	2	0.00	127.47	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_201208.DBF	1,152	0	0.01	127.88	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_20120802.DBF	1,188	0	0.00	127.02	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_20120803.DBF	2,587	0	0.00	126.98	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_20120804.DBF	2,610	0	0.00	126.04	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_2012081.DBF	942	0	0.00	127.12	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_2012082.DBF	768	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_2012085.DBF	4,038	0	0.00	127.63	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_2012086.DBF	4,038	0	0.00	127.63	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_2012087.DBF	4,038	0	0.00	127.63	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_2012088.DBF	4,038	0	0.00	127.63	0	0	0	0.00
POS_SALEDETAIL_201208	/u07/oradata/dcpos/POS_SALEDETAIL_2012089.DBF	4,038	0	0.00	127.64	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_201209.DBF	8,887	1	0.00	127.05	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012091.DBF	9,810	1	0.00	127.11	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012092.DBF	17,766	2	0.00	127.45	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012093.DBF	17,383	2	0.00	127.44	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012094.DBF	17,766	2	0.00	127.45	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012095.DBF	20,016	2	0.00	127.57	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_201210.DBF	3,534	0	0.00	127.53	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_2012101.DBF	3,840	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_20121010.DBF	7,422	1	0.00	126.95	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_20121011.DBF	7,776	1	0.00	127.50	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_20121012.DBF	7,008	1	0.00	127.46	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_2012102.DBF	3,462	0	0.00	127.65	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_2012103.DBF	3,072	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_2012104.DBF	3,072	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_2012105.DBF	3,072	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_2012106.DBF	3,462	0	0.00	127.65	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_2012107.DBF	3,462	0	0.00	127.65	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_2012108.DBF	5,082	0	0.00	127.46	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_2012109.DBF	5,090	0	0.00	127.12	0	0	0	0.00
POS_SALEDETAIL_201211	/u07/oradata/dcpos/POS_SALEDETAIL_201211.DBF	1,957	0	0.00	125.04	0	0	0	0.00
POS_SALEDETAIL_201211	/u07/oradata/dcpos/POS_SALEDETAIL_2012111.DBF	2,268	0	0.00	126.97	0	0	0	0.00
POS_SALEDETAIL_201211	/u07/oradata/dcpos/POS_SALEDETAIL_2012112.DBF	5,628	1	0.00	127.51	0	0	0	0.00
POS_SALEDETAIL_201211	/u07/oradata/dcpos/POS_SALEDETAIL_2012113.DBF	5,286	0	0.00	127.46	0	0	0	0.00
POS_SALEDETAIL_201211	/u07/oradata/dcpos/POS_SALEDETAIL_2012114.DBF	5,244	0	0.00	127.49	0	0	0	0.00
POS_SALEDETAIL_201211	/u07/oradata/dcpos/POS_SALEDETAIL_2012115.DBF	4,326	0	0.00	127.69	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_201212.DBF	768	0	0.00	127.88	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012121.DBF	799	0	0.00	123.16	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012122.DBF	5,460	1	0.00	127.49	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012123.DBF	5,868	1	0.00	127.08	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012124.DBF	6,234	1	0.00	127.54	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012125.DBF	5,466	1	0.00	127.49	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012126.DBF	4,692	0	0.00	127.59	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012127.DBF	10,650	1	0.00	127.49	0	0	0	0.00
POS_SALEDETAIL_2013	/u07/oradata/dcpos/POS_SALEDETAIL_2013.DBF	79	0	0.00	29.78	0	0	0	0.00
POS_SALEDETAIL_201301	/u06/oradata/dcpos/POS_SALE_201301.DBF	9,337	1	0.00	126.70	0	0	0	0.00
POS_SALEDETAIL_201301	/u06/oradata/dcpos/POS_SALE_2013011.DBF	7,698	1	0.00	127.52	0	0	0	0.00
POS_SALEDETAIL_201301	/u06/oradata/dcpos/POS_SALE_2013012.DBF	7,530	1	0.00	127.48	0	0	0	0.00
POS_SALEDETAIL_201301	/u06/oradata/dcpos/POS_SALE_2013013.DBF	7,650	1	0.00	127.52	0	0	0	0.00
POS_SALEDETAIL_201302	/u06/oradata/dcpos/POS_SALE_201302.DBF	35,383	3	0.00	127.14	0	0	0	0.00
POS_SALEDETAIL_201303	/u06/oradata/dcpos/POS_SALE_201303.DBF	10,745	1	0.00	125.29	411	0	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX.DBF	0	0			65,679	6	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX01.DBF	0	0			65,447	6	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX02.DBF	0	0			7,636	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX03.DBF	0	0			7,623	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX04.DBF	0	0			7,671	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX05.DBF	0	0			7,737	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX06.DBF	0	0			7,729	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX07.DBF	0	0			7,370	1	0	0.00
POS_SALE_201212	/u06/oradata/dcpos/POS_SALE_201212.DBF	4,475	0	0.02	34.64	0	0	0	0.00
POS_SALE_201212	/u06/oradata/dcpos/POS_SALE_2012121.DBF	4,513	0	0.02	34.43	1	0	0	0.00
POS_SALE_201212	/u06/oradata/dcpos/POS_SALE_2012122.DBF	3,328	0	0.02	38.98	0	0	0	0.00
POS_SALE_201212	/u06/oradata/dcpos/POS_SALE_2012123.DBF	4,750	0	0.03	30.08	5	0	0	0.00
POS_SALE_201212	/u06/oradata/dcpos/POS_SALE_2012124.DBF	4,364	0	0.02	35.46	2	0	0	0.00
POS_SALE_201301	/u06/oradata/dcpos/POS_SALE_20131.DBF	190,662	18	3.43	7.30	8	0	12	8.33
POS_SALE_201302	/u06/oradata/dcpos/POS_SALE_20132.DBF	250,483	23	8.22	6.44	11	0	24	5.83
POS_SALE_201303	/u06/oradata/dcpos/POS_SALE_20133.DBF	106,288	10	0.61	4.72	10	0	0	0.00
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX.DBF	437,408	40	0.26	1.00	4,692	0	6	11.67
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX01.DBF	438,560	41	0.28	1.00	5,323	0	1	0.00
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX02.DBF	263,243	24	0.28	1.00	2,827	0	1	0.00
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX03.DBF	263,664	24	0.27	1.00	2,813	0	1	30.00
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX04.DBF	263,167	24	0.25	1.00	2,760	0	0	0.00
SYSAUX	/u06/oradata/dcpos/sysaux01.dbf	657	0	0.79	1.03	1,097	0	0	0.00
SYSTEM	/u06/oradata/dcpos/system01.dbf	1,107	0	0.75	1.95	200	0	0	0.00
SYSTEM	/u06/oradata/dcpos/system02.dbf	2	0	0.00	1.00	0	0	0	0.00
TEMP	/u06/oradata/dcpos/temp01.dbf	8,441	1	0.00	22.15	9,039	1	0
TEMP	/u06/oradata/dcpos/temp02.dbf	921	0	0.00	22.68	1,004	0	0
TEMP	/u06/oradata/dcpos/temp03.dbf	738	0	0.00	22.28	792	0	0
TEMP	/u06/oradata/dcpos/temp04.dbf	1,265	0	0.00	22.50	1,346	0	0
TEMP	/u06/oradata/dcpos/temp05.dbf	70,007	6	0.00	1.23	3,513	0	0
TEMP	/u06/oradata/dcpos/temp06.dbf	1,238	0	0.00	22.74	1,319	0	0
TEMP	/u06/oradata/dcpos/temp07.dbf	637	0	0.00	23.63	691	0	0
TEMP	/u06/oradata/dcpos/temp08.dbf	1,279	0	0.00	22.42	1,360	0	0
UNDOTBS1	/u06/oradata/dcpos/undotbs01.dbf	14	0	0.00	1.00	797	0	0	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs02.dbf	8	0	0.00	1.00	146	0	0	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs03.dbf	7	0	0.00	1.00	145	0	0	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs04.dbf	2	0	0.00	1.00	44	0	0	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs05.dbf	3	0	0.00	1.00	35	0	0	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs06.dbf	1	0	0.00	1.00	15	0	0	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs11.dbf	0	0			1	0	0	0.00
UNDOTBS1	/u07/oradata/dcpos/undotbs07.dbf	1	0	0.00	1.00	18	0	0	0.00
UNDOTBS1	/u07/oradata/dcpos/undotbs08.dbf	0	0			7	0	0	0.00
UNDOTBS1	/u07/oradata/dcpos/undotbs09.dbf	0	0			6	0	0	0.00
UNDOTBS1	/u07/oradata/dcpos/undotbs10.dbf	0	0			4	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	3,472,072	98	92,007,760	2,287,859	212,831	0	0	180

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 657,512

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	13,176	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	132	295	1034	2868	9289728	2868
E	0	132	334	1334	1462	9289728	1462

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	2,560	0.09	316	3.89	458,453	1	834627.00
D	5,120	0.18	631	3.12	367,163	1	656348.00
D	7,680	0.27	947	2.70	317,920	1	560183.00
D	10,240	0.36	1,263	2.34	275,167	1	476690.00
D	12,800	0.45	1,578	1.99	234,498	1	397268.00
D	15,360	0.55	1,894	1.66	195,117	1	320361.00
D	17,920	0.64	2,210	1.47	173,495	1	278135.00
D	20,480	0.73	2,525	1.33	157,239	1	246390.00
D	23,040	0.82	2,841	1.21	142,621	1	217843.00
D	25,600	0.91	3,156	1.10	129,421	1	192064.00
D	28,160	1.00	3,472	1.00	117,835	1	169438.00
D	30,720	1.09	3,788	0.91	107,177	1	148624.00
D	33,280	1.18	4,103	0.87	102,865	1	140202.00
D	35,840	1.27	4,419	0.84	98,990	1	132635.00
D	38,400	1.36	4,735	0.81	95,852	1	126507.00
D	40,960	1.45	5,050	0.79	93,209	1	121346.00
D	43,520	1.55	5,366	0.77	90,476	1	116008.00
D	46,080	1.64	5,682	0.75	88,017	1	111207.00
D	48,640	1.73	5,997	0.73	86,418	1	108084.00
D	51,200	1.82	6,313	0.72	84,534	1	104403.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
98.12	10,916	209

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	2,902	2,902	0
64K	128K	71	71	0
256K	512K	18	18	0
512K	1024K	229	229	0
1M	2M	495	495	0
2M	4M	29	29	0
4M	8M	87	87	0
8M	16M	124	124	0
32M	64M	160	160	0
64M	128M	2	0	2

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
10,304	0.13	17,150.31	100.00	50,591,170
20,608	0.25	17,150.31	100.00	50,591,170
41,216	0.50	17,150.31	100.00	50,591,170
61,824	0.75	17,150.31	100.00	50,591,170
82,432	1.00	17,150.31	100.00	50,591,170
98,918	1.20	17,150.31	100.00	50,591,170
115,405	1.40	17,150.31	100.00	50,591,170
131,891	1.60	17,150.31	100.00	50,591,170
148,378	1.80	17,150.31	100.00	50,591,170
164,864	2.00	17,150.31	100.00	50,591,170
247,296	3.00	17,150.31	100.00	50,591,170

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)
12,800	0.81	731	33,288	9,388	1.00	1,113	1.00	1,282
14,336	0.90	1,169	39,202	9,389	1.00	1,112	1.00	1,455
15,872	1.00	1,215	39,392	9,389	1.00	1,112	1.00	1,455
17,408	1.10	1,215	39,392	9,389	1.00	1,112	1.00	1,455
18,944	1.19	1,215	39,392	9,389	1.00	1,112	1.00	1,455
20,480	1.29	1,215	39,392	9,389	1.00	1,112	1.00	1,455
22,016	1.39	1,215	39,392	9,389	1.00	1,112	1.00	1,455
23,552	1.48	1,215	39,392	9,389	1.00	1,112	1.00	1,455
25,088	1.58	1,215	39,392	9,389	1.00	1,112	1.00	1,455
26,624	1.68	1,215	39,392	9,389	1.00	1,112	1.00	1,455
28,160	1.77	1,215	39,392	9,389	1.00	1,112	1.00	1,455
29,696	1.87	1,215	39,392	9,389	1.00	1,112	1.00	1,455
31,232	1.97	1,215	39,392	9,389	1.00	1,112	1.00	1,455

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
24,576	0.50	958,279	403,679,804
30,720	0.63	685,831	257,823,402
36,864	0.75	560,556	190,751,610
43,008	0.88	470,037	142,285,996
49,152	1.00	424,374	117,835,193
55,296	1.13	401,118	105,380,013
61,440	1.25	390,085	99,476,470
67,584	1.38	377,863	92,936,617
73,728	1.50	377,863	92,936,617
79,872	1.63	377,863	92,936,617
86,016	1.75	377,863	92,936,617
92,160	1.88	377,863	92,936,617
98,304	2.00	377,863	92,936,617

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)
512	1.00	0	0	0	0
1,024	2.00	0	0	0	0
1,536	3.00	0	0	0	0
2,048	4.00	0	0	0	0
2,560	5.00	0	0	0	0
3,072	6.00	0	0	0	0
3,584	7.00	0	0	0	0
4,096	8.00	0	0	0	0
4,608	9.00	0	0	0	0
5,120	10.00	0	0	0	0
5,632	11.00	0	0	0	0
6,144	12.00	0	0	0	0
6,656	13.00	0	0	0	0
7,168	14.00	0	0	0	0
7,680	15.00	0	0	0	0
8,192	16.00	0	0	0	0
8,704	17.00	0	0	0	0
9,216	18.00	0	0	0	0
9,728	19.00	0	0	0	0
10,240	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	180	1	6

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)
BF-BLOOM FILTER (allocation contention)	765	531	234	110	2	15.18
PS-PX Process Reservation	2,304	2,304	0	13	1	81.54
KO-Multiple Object Checkpoint (fast object checkpoint)	18	18	0	2	1	505.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	0.42	830	2,468	4	120/120	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
18-Mar 12:50	0	4	1,708	1	120	0/0	0/0/0/0/0/0
18-Mar 12:40	0	30	1,108	1	120	0/0	0/0/0/0/0/0
18-Mar 12:30	1	6	656	2	120	0/0	0/0/0/0/0/0
18-Mar 12:20	0	97	1,259	1	120	0/0	0/0/0/0/0/0
18-Mar 12:10	0	6	2,468	1	120	0/0	0/0/0/0/0/0
18-Mar 12:00	120	111	1,866	4	120	0/0	0/0/0/0/0/0
18-Mar 11:50	30	16	1,265	3	120	0/0	0/0/0/0/0/0
18-Mar 11:40	1	20	1,260	2	120	0/0	0/0/0/0/0/0
18-Mar 11:30	0	5	660	1	120	0/0	0/0/0/0/0/0
18-Mar 11:20	1	113	1,262	2	120	0/0	0/0/0/0/0/0
18-Mar 11:10	6	10	1,720	2	120	0/0	0/0/0/0/0/0
18-Mar 11:00	148	166	1,114	4	120	0/0	0/0/0/0/0/0
18-Mar 10:50	2	4	664	2	120	0/0	0/0/0/0/0/0
18-Mar 10:40	7	30	62	2	120	0/0	0/0/0/0/0/0
18-Mar 10:30	0	44	664	1	120	0/0	0/0/0/0/0/0
18-Mar 10:20	0	5	1,267	1	120	0/0	0/0/0/0/0/0
18-Mar 10:10	4	88	665	2	120	0/0	0/0/0/0/0/0
18-Mar 10:00	100	75	1,268	4	120	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	3	0.00		0	0
ASM db client latch	7,157	0.00		0	0
ASM map operation hash table	3	0.00		0	0
ASM network state latch	175	0.00		0	0
AWR Alerted Metric Element list	143,976	0.00		0	0
Bloom filter list latch	17	0.00		0	0
Change Notification Hash table latch	3,609	0.00		0	0
Consistent RBA	782	0.00		0	0
DML lock allocation	2,396	0.00		0	0
Event Group Locks	263	0.00		0	0
FOB s.o list latch	25,433	0.33	0.12	0	0
File State Object Pool Parent Latch	3	0.00		0	0
IPC stats buffer allocation latch	3	0.00		0	0
In memory undo latch	886,548,699	0.00	0.00	0	4,391	0.07
JS Sh mem access	21	0.00		0	0
JS mem alloc latch	16	0.00		0	0
JS queue access latch	19	0.00		0	0
JS queue state obj latch	78,402	0.00		0	0
JS slv state obj latch	99	0.00		0	0
KFC FX Hash Latch	3	0.00		0	0
KFC Hash Latch	3	0.00		0	0
KFCL LE Freelist	3	0.00		0	0
KGNFS-NFS:SHM structure	3	0.00		0	0
KGNFS-NFS:SVR LIST	3	0.00		0	0
KJC message pool free list	3	0.00		0	0
KJCT flow control latch	3	0.00		0	0
KMG MMAN ready and startup request latch	3,602	0.00		0	0
KTF sga latch	56	0.00		0	3,547	0.00
KWQP Prop Status	6	0.00		0	0
KWQS pqueue ctx latch	6	0.00		0	0
Locator state objects pool parent latch	3	0.00		0	0
Lsod array latch	3	0.00		0	0
MQL Tracking Latch	0			0	216	0.00
Memory Management Latch	3	0.00		0	3,602	0.00
Memory Queue	3	0.00		0	0
Memory Queue Message Subscriber #1	3	0.00		0	0
Memory Queue Message Subscriber #2	3	0.00		0	0
Memory Queue Message Subscriber #3	3	0.00		0	0
Memory Queue Message Subscriber #4	3	0.00		0	0
Memory Queue Subscriber	3	0.00		0	0
Mutex	3	0.00		0	0
Mutex Stats	3	0.00		0	0
OS process	2,025	0.00		0	0
OS process allocation	5,034	0.00		0	0
OS process: request allocation	436	0.23	0.00	0	0
PL/SQL warning settings	918	0.22	0.00	0	0
PX hash array latch	3	0.00		0	0
QMT	3	0.00		0	0
Real-time plan statistics latch	214,642	0.14	0.67	0	0
SGA IO buffer pool latch	77	1.30	0.00	0	100	2.00
SGA blob parent	3	0.00		0	0
SGA bucket locks	3	0.00		0	0
SGA heap locks	3	0.00		0	0
SGA pool locks	3	0.00		0	0
SQL memory manager latch	363	0.00		0	3,576	0.00
SQL memory manager workarea list latch	301,276	0.04	0.00	0	0
Shared B-Tree	404	0.00		0	0
Statement queuing latch	10	0.00		0	0
Streams Generic	3	0.00		0	0
Testing	3	0.00		0	0
Token Manager	3	0.00		0	0
WCR: sync	3	0.00		0	0
Write State Object Pool Parent Latch	3	0.00		0	0
X$KSFQP	3	0.00		0	0
XDB NFS Security Latch	3	0.00		0	0
XDB unused session pool	3	0.00		0	0
XDB used session pool	3	0.00		0	0
active checkpoint queue latch	52,412	1.58	0.00	0	0
active service list	25,481	3.19	0.52	1	7,197	0.00
begin backup scn array	26	0.00		0	0
buffer pool	3	0.00		0	0
business card	3	0.00		0	0
cache buffer handles	2,068	0.68	0.00	0	0
cache buffers chains	162,368,052	0.33	0.00	0	2,389,789	0.00
cache buffers lru chain	218,973	0.10	0.16	0	2,669,224	1.66
cache table scan latch	2,711	2.29	0.02	0	2,727	2.93
call allocation	4,519	14.67	0.35	1	0
cas latch	3	0.00		0	0
change notification client cache latch	3	0.00		0	0
channel handle pool latch	442	0.45	0.00	0	0
channel operations parent latch	51,244	0.00	0.00	0	0
checkpoint queue latch	6,342,542	0.00	0.00	0	23,084	0.00
client/application info	3,773	0.00		0	0
compile environment latch	780	0.00		0	0
corrupted undo seg latch	77	0.00		0	0
cp cmon/server latch	3	0.00		0	0
cp pool latch	3	0.00		0	0
cp server hash latch	3	0.00		0	0
cp sga latch	175	0.00		0	0
cvmap freelist lock	3	0.00		0	0
deferred cleanup latch	175	0.00		0	0
dml lock allocation	175	0.00		0	0
done queue latch	3	0.00		0	0
dummy allocation	1,479	8.59	0.02	0	0
enqueue hash chains	239,782	0.12	0.04	0	2	0.00
enqueues	230,978	0.14	0.01	0	0
error message lists	842	19.48	0.07	0	0
fifth spare latch	3	0.00		0	0
file cache latch	7,964	0.00		0	0
flashback copy	3	0.00		0	0
gc element	3	0.00		0	0
gcs commit scn state	3	0.00		0	0
gcs partitioned table hash	3	0.00		0	0
gcs pcm hashed value bucket hash	3	0.00		0	0
gcs resource freelist	3	0.00		0	0
gcs resource hash	3	0.00		0	0
gcs resource scan list	3	0.00		0	0
gcs shadows freelist	3	0.00		0	0
ges domain table	3	0.00		0	0
ges enqueue table freelist	3	0.00		0	0
ges group table	3	0.00		0	0
ges process hash list	3	0.00		0	0
ges process parent latch	3	0.00		0	0
ges resource hash list	3	0.00		0	0
ges resource scan list	3	0.00		0	0
ges resource table freelist	3	0.00		0	0
ges value block free list	3	0.00		0	0
global KZLD latch for mem in SGA	11	0.00		0	0
global tx hash mapping	3	0.00		0	0
granule operation	3	0.00		0	0
hash table column usage latch	171	0.00		0	318,266	0.00
hash table modification latch	258	0.00		0	0
heartbeat check	3	0.00		0	0
internal temp table object number allocation latch	250	0.00		0	0
intra txn parallel recovery	3	0.00		0	0
io pool granule metadata list	3	0.00		0	0
job workq parent latch	27	0.00		0	24	0.00
job_queue_processes free list latch	60	0.00		0	0
job_queue_processes parameter latch	2,373	0.00		0	0
k2q lock allocation	3	0.00		0	0
kcbtsemkid latch	1	0.00		0	0
kdlx hb parent latch	3	0.00		0	0
kgb parent	3	0.00		0	0
kks stats	248	0.00		0	0
kokc descriptor allocation latch	12	0.00		0	0
ksfv messages	3	0.00		0	0
kss move lock	85	0.00		0	0
ksuosstats global area	729	0.00		0	0
ksv allocation latch	339	0.00		0	0
ksv class latch	167	0.60	0.00	0	0
ksv msg queue latch	3	0.00		0	0
ksz_so allocation latch	436	0.00		0	0
ktm global data	69	0.00		0	0
kwqbsn:qsga	392	0.00		0	0
lgwr LWN SCN	3,995	0.00		0	0
list of block allocation	165	0.00		0	0
loader state object freelist	20,159,037	0.00	0.00	0	0
lob segment dispenser latch	3	0.00		0	0
lob segment hash table latch	39	0.00		0	0
lob segment query latch	3	0.00		0	0
lock DBA buffer during media recovery	3	0.00		0	0
logical standby cache	3	0.00		0	0
logminer context allocation	6	0.00		0	0
logminer work area	3	0.00		0	0
longop free list parent	66,118	0.00		0	399	0.00
mapped buffers lru chain	3	0.00		0	0
message pool operations parent latch	9	0.00		0	0
messages	190,704	0.92	0.00	0	0
mostly latch-free SCN	4,018	0.20	0.00	0	0
msg queue latch	3	0.00		0	0
multiblock read objects	5,964	4.11	0.00	0	0
name-service namespace bucket	3	0.00		0	0
ncodef allocation latch	175	0.00		0	0
object queue header heap	420,618	0.00		0	2,160	0.00
object queue header operation	1,622,150,750	0.00	0.03	0	0
object stats modification	123	0.00		0	0
parallel query alloc buffer	62,251	42.35	0.06	3	0
parallel query stats	10,074,941	0.00	0.07	0	0
parameter list	261	0.00		0	0
parameter table management	3,190	2.19	0.00	0	0
peshm	3	0.00		0	0
pesom_free_list	3	0.00		0	0
pesom_hash_node	3	0.00		0	0
post/wait queue	75	0.00		0	44	0.00
process allocation	706	0.00		0	260	0.00
process group creation	436	0.23	0.00	0	0
process queue	20,189,190	0.00	0.00	0	0
process queue reference	118,258,538	0.02	0.03	0	1,707,022	0.25
qmn task queue latch	2,603	0.38	0.00	0	0
query server freelists	30,264,125	0.00	0.00	0	0
query server process	160	0.00		0	79	1.27
queued dump request	36	0.00		0	0
queuing load statistics	22	0.00		0	0
recovery domain hash list	3	0.00		0	0
redo allocation	20,997	0.04	0.00	0	31,502	0.10
redo copy	3	0.00		0	31,507	0.38
redo writing	62,214	0.89	0.00	0	0
resmgr group change latch	643	0.00		0	0
resmgr:active threads	1,479	0.00		0	0
resmgr:actses change group	655	0.00		0	0
resmgr:actses change state	3	0.00		0	0
resmgr:free threads list	1,476	6.50	0.05	0	0
resmgr:plan CPU method	3	0.00		0	0
resmgr:resource group CPU method	3	0.00		0	0
resmgr:schema config	729	0.41	0.00	0	0
resmgr:session queuing	3	0.00		0	0
rm cas latch	3	0.00		0	0
row cache objects	606,867	0.19	0.03	0	0
rules engine rule set statistics	300	0.00		0	0
second spare latch	3	0.00		0	0
sequence cache	433	0.00		0	0
session allocation	6,421	0.17	0.00	0	2,222	0.00
session idle bit	18,360	0.00		0	0
session queue latch	3	0.00		0	0
session state list latch	1,698	5.54	0.00	0	0
session switching	1,058	0.19	0.00	0	0
session timer	3,670	0.00		0	0
shared pool	66,505	8.60	0.05	0	0
shared pool sim alloc	14	0.00		0	0
shared pool simulator	342	0.00		0	0
sim partition latch	3	0.00		0	0
simulator hash latch	1,782,366	0.00	0.00	0	0
simulator lru latch	22,555	0.02	0.00	0	1,592,745	0.05
sort extent pool	131,407	0.09	0.12	0	0
space background state object latch	16	0.00		0	0
space background task latch	8,036	0.10	0.00	0	7,204	0.00
state object free list	6	0.00		0	0
statistics aggregation	1,680	0.00		0	0
tablespace key chain	3	0.00		0	0
temp lob duration state obj allocation	6	0.00		0	0
temporary table state object allocation	4	0.00		0	0
test excl. parent l0	3	0.00		0	0
test excl. parent2 l0	3	0.00		0	0
third spare latch	3	0.00		0	0
threshold alerts latch	4,486	0.00		0	0
transaction allocation	180	0.00		0	0
transaction branch allocation	3,670	0.00		0	0
undo global data	7,873,627	0.81	0.00	0	0
virtual circuit buffers	3	0.00		0	0
virtual circuit holder	3	0.00		0	0
virtual circuit queues	3	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	162,368,052	535,938	364	535,664
undo global data	7,873,627	63,496	19	63,477
parallel query alloc buffer	62,251	26,363	1,712	24,950
process queue reference	118,258,538	21,784	641	1,063
object queue header operation	1,622,150,750	10,662	277	10,393
shared pool	66,505	5,718	279	5,468
row cache objects	606,867	1,136	37	1,102
active service list	25,481	813	424	486
call allocation	4,519	663	232	485
query server freelists	30,264,125	436	2	434
enqueues	230,978	317	2	315
Real-time plan statistics latch	214,642	293	195	146
enqueue hash chains	239,782	283	11	273
cache buffers lru chain	218,973	228	36	199
error message lists	842	164	11	154
parallel query stats	10,074,941	141	10	135
dummy allocation	1,479	127	3	125
sort extent pool	131,407	116	14	103
resmgr:free threads list	1,476	96	5	91
FOB s.o list latch	25,433	85	10	75
cache table scan latch	2,711	62	1	61

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
FOB s.o list latch	ksfd_allfob	10	10
Real-time plan statistics latch	keswxAddNewPlanEntry	195	195
active service list	kswslogon: session logout	259	244
active service list	kswssetsvc: PX session switch service	212	63
active service list	kswsgsnp: get service name ptr	18	70
active service list	kswsigsn: get service name	4	35
active service list	kswslogon: session login	4	87
active service list	kswsite: service iterator	2	0
cache buffers chains	kcbgtcr: fast path (cr pin)	304	88
cache buffers chains	kcbgtcr: kslbegin shared	38	6
cache buffers chains	kcbrls_1	34	255
cache buffers chains	kcbzwb	25	23
cache buffers chains	kcbgtcr: fast path	22	32
cache buffers chains	kcbgtcr_2	20	18
cache buffers chains	kcbbxsv	3	1
cache buffers chains	kcbzgb: scan from tail. nowait	3	0
cache buffers lru chain	kcbzgws	34	0
cache buffers lru chain	kcbzar: KSLNBEGIN	2	0
cache table scan latch	kcbz_free_table_scan_read_buffer	1	1
call allocation	ksuxds	182	199
call allocation	ksursi0	31	20
call allocation	ksudlp: top call	18	6
call allocation	kxfpRecvSessStats	1	1
channel operations parent latch	ksrchdelete_sub()	1	1
dummy allocation	ktcscnfy	2	3
dummy allocation	ktcdod	1	0
enqueue hash chains	ksqrcl	7	7
enqueue hash chains	ksqgtl3	3	3
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	1
enqueues	ksqdel	1	1
enqueues	ksqgel: create enqueue	1	1
error message lists	kxfpqsnd	8	8
error message lists	kxfpqidqr: KSLBEGIN	3	3
object queue header operation	kcbo_unlink_q	220	4
object queue header operation	kcbo_ivbo	159	158
object queue header operation	kcbo_link_q	27	2
object queue header operation	kcbo_switch_cq	19	14
object queue header operation	kcbo_switch_mq_bg	8	64
object queue header operation	kcbo_write_q	4	3
object queue header operation	kcbo_lbufcnt	3	44
object queue header operation	kcbo_check_flist	2	4
object queue header operation	kcbo_switch_q_bg	2	151
parallel query alloc buffer	kxfpbalo	1,229	1,242
parallel query alloc buffer	kxfpbfre	481	468
parallel query stats	kxfprst: KSLBEGIN:1	10	10
parameter table management	kspptval	1	1
process queue reference	kxfpqrsnd	1	0
query server freelists	kxfpobadf	2	2
resmgr:free threads list	kskthrcreate	5	5
row cache objects	kqreqd: reget	18	3
row cache objects	kqrpre: find obj	15	18
row cache objects	kqreqd	4	16
shared pool	kghalo	243	240
shared pool	kghfre	36	39
sort extent pool	ktstdt: dealloc sort extent	8	1
sort extent pool	ktstdt: return extent	5	12
sort extent pool	ktst dump	1	1
undo global data	ktudba: KSLBEGIN	19	19

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Cursor Pin	kkslce [KKSCHLPIN2]	24,487	254
Library Cache	kglget2 2	9,081	-0
Library Cache	kglpin1 4	6,346	-0
Library Cache	kglpnal1 90	5,855	-0
Library Cache	kgllkdl1 85	4,663	-0
Library Cache	kglpndl1 95	4,623	-0
Library Cache	kgllkc1 57	367	0
Library Cache	kglhdgn2 106	341	-1
Library Cache	kglhdgn1 62	25	-0
Library Cache	kgldtin1 42	19	-0
Library Cache	kglini1 32	1	-4
Library Cache	kglobld1 75	1	-0
Cursor Parent	kksLoadChild [KKSPRTLOC4]	1	0
Cursor Pin	kksLockDelete [KKSCHLPIN6]	1	0

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 Logical Reads

Total Logical Reads: 256,524,358
Captured Segments account for 89.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	110,812,448	43.20
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	18,627,424	7.26
POS	POS_SALEDETAIL_201209	YS_SALEDETAIL	SYS_SUBP54	TABLE SUBPARTITION	11,671,776	4.55
POS	POS_SALEDETAIL_201207	YS_SALEDETAIL	SYS_SUBP52	TABLE SUBPARTITION	8,474,688	3.30
POS	POS_SALEDETAIL_201210	YS_SALEDETAIL	SYS_SUBP55	TABLE SUBPARTITION	7,562,544	2.95

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 167,205,043
Captured Segments account for 89.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	50,369,291	30.12
POS	POS_SALEDETAIL_201209	YS_SALEDETAIL	SYS_SUBP54	TABLE SUBPARTITION	11,672,400	6.98
POS	POS_SALEDETAIL_201207	YS_SALEDETAIL	SYS_SUBP52	TABLE SUBPARTITION	8,476,162	5.07
POS	POS_SALEDETAIL_201210	YS_SALEDETAIL	SYS_SUBP55	TABLE SUBPARTITION	7,566,819	4.53
POS	POS_SALEDETAIL_201212	YS_SALEDETAIL	SYS_SUBP57	TABLE SUBPARTITION	5,086,691	3.04

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 13,295,351
Captured Segments account for 98.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	10,073,859	75.77
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	1,664,171	12.52
POS	POS_SALE_201302	YS_SALE	SYS_SUBP99	TABLE SUBPARTITION	243,313	1.83
POS	POS_SALE_201301	YS_SALE	SYS_SUBP98	TABLE SUBPARTITION	184,087	1.38
POS	POS_SALE_201303	YS_SALE	SYS_SUBP100	TABLE SUBPARTITION	98,607	0.74

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 13,295,351
Captured Segments account for 98.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	10,073,859	75.77
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	1,664,171	12.52
POS	POS_SALE_201302	YS_SALE	SYS_SUBP99	TABLE SUBPARTITION	243,313	1.83
POS	POS_SALE_201301	YS_SALE	SYS_SUBP98	TABLE SUBPARTITION	184,087	1.38
POS	POS_SALE_201303	YS_SALE	SYS_SUBP100	TABLE SUBPARTITION	98,607	0.74

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 164,917,162
Captured Segments account for 88.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	50,369,290	30.54
POS	POS_SALEDETAIL_201209	YS_SALEDETAIL	SYS_SUBP54	TABLE SUBPARTITION	11,672,526	7.08
POS	POS_SALEDETAIL_201207	YS_SALEDETAIL	SYS_SUBP52	TABLE SUBPARTITION	8,475,644	5.14
POS	POS_SALEDETAIL_201210	YS_SALEDETAIL	SYS_SUBP55	TABLE SUBPARTITION	7,565,922	4.59
POS	POS_SALEDETAIL_201212	YS_SALEDETAIL	SYS_SUBP57	TABLE SUBPARTITION	5,086,818	3.08

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 657,512
Captured Segments account for 3.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	19,278	2.93
POS	POS_DATA	IX_YS_GOODS_ABCD		INDEX	333	0.05
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_3752968640_2218	TABLE PARTITION	107	0.02
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	54	0.01
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY		TABLE	33	0.01

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 217,694
Captured Segments account for 8.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
POS	POS_SALE_IX	PK_YS_SALE_N	INDEX	18,414	8.46
POS	POS_DATA	IX_YS_GOODS_ABCD	INDEX	146	0.07
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	47	0.02
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	32	0.01
SYS	SYSAUX	SYS_LOB0000006213C00038$$	LOB	29	0.01

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 444,681
Captured Segments account for 0.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_3752968640_2218	TABLE PARTITION	95	0.02
SYS	SYSAUX	SYS_LOB0000006213C00038$$		LOB	16	0.00
SYS	SYSAUX	SYS_LOB0000006207C00004$$		LOB	2	0.00

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 10,081,923
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	10,073,859	99.92
POS	POS_DATA	PRODUCT_INF		TABLE	1,031	0.01
POS	POS_SALE_201302	YS_SALE	SYS_SUBP99	TABLE SUBPARTITION	435	0.00
POS	POS_SALE_201301	YS_SALE	SYS_SUBP98	TABLE SUBPARTITION	380	0.00
POS	POS_SALEDETAIL_201209	YS_SALEDETAIL	SYS_SUBP54	TABLE SUBPARTITION	312	0.00

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
POS	POS_SALE_IX	PK_YS_SALE_N	INDEX	19,472	81.13
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	1,184	4.93
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	448	1.87
POS	POS_DATA	IX_YS_GOODS_ABCD	INDEX	416	1.73
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX	INDEX	272	1.13

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	195	0.00	6	1
dc_global_oids	21	0.00	0	358
dc_histogram_data	3,425	0.00	0	7,458
dc_histogram_defs	3,814	0.16	0	9,392
dc_object_grants	279	16.49	0	544
dc_objects	6,916	1.00	17	5,655
dc_profiles	41	0.00	0	1
dc_rollback_segments	19,266	0.00	0	165
dc_segments	995	0.00	19	2,339
dc_sequences	11	0.00	11	17
dc_tablespaces	80,588	0.00	0	120
dc_users	80,956	0.00	0	292
global database name	7,276	0.00	0	2
outstanding_alerts	2,112	0.00	0	118
sch_lj_oids	14	0.00	0	16

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	277	1.81	2,917	0.17	0	0
CLUSTER	132	0.00	12	0.00	0	0
DBLINK	28	0.00	0		0	0
EDITION	68	0.00	103	0.00	0	0
INDEX	141	7.09	139	7.19	0	0
JAVA DATA	17	52.94	15	60.00	0	0
JAVA RESOURCE	17	52.94	17	52.94	0	0
JAVA SOURCE	17	52.94	17	52.94	0	0
SCHEMA	140	1.43	0		0	0
SQL AREA	2,640	5.27	18,199	1.73	55	16
TABLE/PROCEDURE	3,103	0.93	10,132	0.65	17	0
TRIGGER	35	28.57	35	28.57	0	0

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

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	28,160.00	28,160.00	28,160.00	31,744.00	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	82,432.00	82,432.00	78,848.00	82,944.00	GRO/MAN
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	49,152.00	49,152.00	48,640.00	52,736.00	SHR/DEF
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	512.00	512.00	512.00	512.00	STA/
large pool	2,048.00	2,048.00	2,048.00	2,048.00	STA/
shared pool	16,896.00	16,896.00	13,824.00	16,896.00	GRO/IMM
streams pool	512.00	512.00	512.00	1,024.00	SHR/DEF

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

B: Begin Snap E: End Snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	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	126.44		3.16	2.96	12	12	40	40
	Freeable	41.31	0.00	1.65	1.23	4		25	25
	SQL	1.27	1.12	0.07	0.15	1	28	19	15
	PL/SQL	0.74	0.63	0.02	0.04	0	0	38	38
E	Freeable	3,019.94	0.00	28.22	35.11	74		107	107
	SQL	1,106.53	1,078.69	10.74	70.06	713	876	103	99
	Other	289.61		2.34	4.05	42	51	124	124
	PL/SQL	1.24	0.79	0.01	0.03	0	0	122	122

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	29,527,900,160
Fixed Size	2,220,240
Redo Buffers	455,544,832
Variable Size	107,374,186,288

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	512.00	512.00	0.00
large	PX msg pool		80.31
large	free memory	2,040.19	1,903.68	-6.69
large	qesblFilter_seg		64.01
shared	SQLA	651.11	657.22	0.94
shared	db_block_hash_buckets	178.00	178.00	0.00
shared	free memory	15,219.78	15,207.30	-0.08
streams	free memory	512.00	512.00	0.00
	buffer_cache	28,160.00	28,160.00	0.00
	fixed_sga	2.12	2.12	0.00
	log_buffer	434.44	434.44	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Capture Rate
Streams Apply
Streams Apply Rate
Buffered Queues
Buffered Queue Subscribers
Rule Set
Persistent Queues
Persistent Queues Rate
Persistent Queue Subscribers

Streams CPU/IO Usage

Streams processes ordered by Foreground CPU Time, descending

Session Type	First Logon	Foreground CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0313 20:32:15	0.28	0.00	0.00
QMON Coordinator	0313 20:32:05	0.11	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
10,807	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	10,807	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/dcpos/adump
audit_trail	DB
compatible	11.2.0.0.0
control_files	/u06/oradata/dcpos/control01.ctl, /u06/oradata/dcpos/control02.ctl
db_block_size	8192
db_domain
db_files	1000
db_name	dcpos
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=dcposXDB)
local_listener	LISTENER_DCPOS
memory_target	137975824384
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	300
open_links	20
open_links_per_instance	20
optimizer_features_enable	10.2.0.5
parallel_degree_policy	AUTO
parallel_max_servers	80
processes	500
remote_login_passwordfile	EXCLUSIVE
star_transformation_enabled	TRUE
undo_retention	7200
undo_tablespace	UNDOTBS1

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	99.99
Buffer Hit %:	97.51	In-memory Sort %:	99.99
Library Hit %:	98.63	Soft Parse %:	98.37
Execute to Parse %:	38.72	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	6.41	% Non-Parse CPU:	99.85