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: 2217 18-Mar-13 00:00:36 39 1.8

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

Elapsed: 779.62 (mins)

DB Time: 648.62 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2217	18-Mar-13 00:00:36	39	1.8
End Snap:	2230	18-Mar-13 13:00:13	122	1.3
Elapsed:		779.62 (mins)
DB Time:		648.62 (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): 0.8 70.8 0.51 0.89

DB CPU(s): 0.5 42.9 0.31 0.54

Redo size: 35,509.1 3,020,027.6

Logical reads: 17,944.4 1,526,156.1

Block changes: 119.3 10,145.3

Physical reads: 4,291.9 365,026.8

Physical writes: 62.7 5,333.7

User calls: 0.9 79.8

Parses: 1.0 82.1

Hard parses: 0.0 1.1

W/A MB processed: 0.1 9.4

Logons: 0.1 11.2

Executes: 1.6 139.5

Rollbacks: 0.0 0.0

Transactions: 0.0

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.8	70.8	0.51	0.89
DB CPU(s):	0.5	42.9	0.31	0.54
Redo size:	35,509.1	3,020,027.6
Logical reads:	17,944.4	1,526,156.1
Block changes:	119.3	10,145.3
Physical reads:	4,291.9	365,026.8
Physical writes:	62.7	5,333.7
User calls:	0.9	79.8
Parses:	1.0	82.1
Hard parses:	0.0	1.1
W/A MB processed:	0.1	9.4
Logons:	0.1	11.2
Executes:	1.6	139.5
Rollbacks:	0.0	0.0
Transactions:	0.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.99

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

Library Hit %: 98.82 Soft Parse %: 98.63

Execute to Parse %: 41.16 Latch Hit %: 99.98

Parse CPU to Parse Elapsd %: 32.87 % Non-Parse CPU: 99.45

Shared Pool Statistics

Begin End

Memory Usage %: 0.87 0.99

% SQL with executions>1: 99.04 98.90

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

	Begin	End
Memory Usage %:	0.87	0.99
% SQL with executions>1:	99.04	98.90
% Memory for SQL w/exec>1:	95.88	94.30

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		23,587		60.61
db file sequential read	16,041,669	7,911	0	20.33	User I/O
direct path read	11,159,669	3,891	0	10.00	User I/O
direct path write temp	23,469	1,213	52	3.12	User I/O
cursor: pin S wait on X	478	267	559	0.69	Concurrency

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

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

0.38 2.25 1.1 0.4 0.4 98.4

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.38	2.25	1.1	0.4	0.4	98.4

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

0.7 42.1 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.7	42.1	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): 170.5 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):	170.5	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): 38916.9s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	37,910.59	97.41
DB CPU	23,587.02	60.61
parse time elapsed	410.85	1.06
hard parse elapsed time	19.33	0.05
hard parse (sharing criteria) elapsed time	10.94	0.03
PL/SQL execution elapsed time	8.71	0.02
failed parse elapsed time	3.00	0.01
PL/SQL compilation elapsed time	0.65	0.00
repeated bind elapsed time	0.23	0.00
connection management call elapsed time	0.22	0.00
hard parse (bind mismatch) elapsed time	0.03	0.00
sequence load elapsed time	0.00	0.00
DB time	38,916.91
background elapsed time	13,447.97
background cpu time	838.90

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	5,796,174
IDLE_TIME	367,000,895
IOWAIT_TIME	1,625,435
NICE_TIME	1,475
SYS_TIME	1,346,110
USER_TIME	3,942,474
LOAD	0	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 00:00:36	0.38
18-Mar 01:00:39	0.96	0.77	0.46	0.19	99.23	0.04
18-Mar 02:00:42	4.01	0.92	0.56	0.23	99.08	0.30
18-Mar 03:00:45	2.07	1.48	0.90	0.43	98.52	1.27
18-Mar 04:00:48	3.20	2.18	1.38	0.67	97.82	1.03
18-Mar 05:00:51	0.45	0.82	0.46	0.22	99.18	0.63
18-Mar 06:00:53	0.32	1.03	0.51	0.39	98.97	0.06
18-Mar 07:00:56	0.60	0.74	0.43	0.18	99.26	0.03
18-Mar 08:00:59	0.87	0.82	0.51	0.19	99.18	0.03
18-Mar 09:00:02	0.65	1.06	0.72	0.21	98.94	0.05
18-Mar 10:00:05	1.49	1.35	0.96	0.25	98.65	0.13
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 96.1% of Total DB time 38,916.91 (s)
Total FG Wait Time: 13,792.98 (s) DB CPU time: 23,587.02 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			23,587		60.61
User I/O	27,339,554	0	13,112	0	33.69
Concurrency	37,365	0	401	11	1.03
Network	627,703	0	222	0	0.57
Other	72,213	84	51	1	0.13
Configuration	50	4	5	97	0.01
Application	20	0	1	71	0.00
Commit	130	0	0	3	0.00
System I/O	51	0	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	16,041,669	0	7,911	0	29,166.67	20.33
direct path read	11,159,669	0	3,891	0	20,290.31	10.00
direct path write temp	23,469	0	1,213	52	42.67	3.12
cursor: pin S wait on X	478	0	267	559	0.87	0.69
SQL*Net more data from dblink	552,449	0	141	0	1,004.45	0.36
library cache: mutex X	25,201	0	105	4	45.82	0.27
SQL*Net message from dblink	30,686	0	81	3	55.79	0.21
db file scattered read	15,346	0	59	4	27.90	0.15
PX Deq: Slave Session Stats	5,506	0	28	5	10.01	0.07
Disk file operations I/O	10,736	0	27	3	19.52	0.07
os thread startup	402	0	15	37	0.73	0.04
latch free	1,238	0	13	11	2.25	0.03
latch: cache buffers chains	9,854	0	12	1	17.92	0.03
direct path read temp	88,412	0	10	0	160.75	0.02
latch: parallel query alloc buffer	2,951	0	5	2	5.37	0.01
log file switch completion	46	0	5	104	0.08	0.01
enq: BF - allocation contention	110	0	2	16	0.20	0.00
read by other session	236	0	1	6	0.43	0.00
enq: KO - fast object checkpoint	9	0	1	153	0.02	0.00
enq: PS - contention	16	0	1	66	0.03	0.00
library cache lock	5	0	1	148	0.01	0.00
latch: shared pool	1,090	0	1	1	1.98	0.00
log file sync	130	0	0	3	0.24	0.00
kksfbc child completion	7	100	0	51	0.01	0.00
PX qref latch	15,137	100	0	0	27.52	0.00
asynch descriptor resize	45,337	100	0	0	82.43	0.00
wait list latch free	17	0	0	11	0.03	0.00
PX Deq: Signal ACK EXT	651	0	0	0	1.18	0.00
SQL*Net message to dblink	30,681	0	0	0	55.78	0.00
latch: object queue header operation	284	0	0	0	0.52	0.00
db file parallel read	10	0	0	13	0.02	0.00
resmgr:internal state change	1	100	0	101	0.00	0.00
latch: call allocation	24	0	0	4	0.04	0.00
latch: row cache objects	80	0	0	1	0.15	0.00
local write wait	6	0	0	14	0.01	0.00
SQL*Net message to client	13,886	0	0	0	25.25	0.00
PX Deq: Signal ACK RSG	860	53	0	0	1.56	0.00
cursor: pin S	249	0	0	0	0.45	0.00
undo segment extension	4	50	0	10	0.01	0.00
enq: RO - fast object reuse	4	0	0	10	0.01	0.00
direct path sync	1	0	0	13	0.00	0.00
reliable message	23	0	0	0	0.04	0.00
latch: cache buffers lru chain	21	0	0	0	0.04	0.00
latch: undo global data	19	0	0	0	0.03	0.00
SQL*Net break/reset to client	7	0	0	1	0.01	0.00
latch: enqueue hash chains	12	0	0	0	0.02	0.00
PX Deq Credit: send blkd	2,188,148	4	529,607	242	3,978.45
PX Deq: Execution Msg	389,760	60	472,543	1212	708.65
SQL*Net message from client	13,883	0	56,847	4095	25.24
PX Deq: Table Q Normal	1,058,676	0	10,887	10	1,924.87
jobq slave wait	12,762	100	6,393	501	23.20
PX Deq Credit: need buffer	54,433	0	968	18	98.97
PX Deq: Execute Reply	23,464	0	425	18	42.66
PX Deq: Parse Reply	3,333	0	8	3	6.06
single-task message	5	0	0	44	0.01
PX Deq: Join ACK	944	0	0	0	1.72
PX Deq: Msg Fragment	22	0	0	0	0.04

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	498,488	0	12,517	25	906.34	93.08
control file parallel write	19,100	0	321	17	34.73	2.39
Disk file operations I/O	45,109	0	89	2	82.02	0.66
db file single write	10,759	0	77	7	19.56	0.58
log file parallel write	12,640	0	38	3	22.98	0.28
os thread startup	381	0	17	44	0.69	0.13
Data file init write	359	0	9	24	0.65	0.06
latch: call allocation	1,849	0	5	3	3.36	0.03
db file sequential read	23,916	0	2	0	43.48	0.02
control file sequential read	87,352	0	2	0	158.82	0.01
latch free	1,396	0	1	1	2.54	0.01
direct path sync	15	0	1	36	0.03	0.00
reliable message	814	0	0	1	1.48	0.00
rdbms ipc reply	825	0	0	0	1.50	0.00
latch: shared pool	307	0	0	1	0.56	0.00
log file switch completion	4	0	0	51	0.01	0.00
log file single write	60	0	0	3	0.11	0.00
log file sync	27	0	0	4	0.05	0.00
db file scattered read	382	0	0	0	0.69	0.00
wait list latch free	8	0	0	11	0.01	0.00
ADR block file read	169	0	0	0	0.31	0.00
LGWR wait for redo copy	263	0	0	0	0.48	0.00
latch: cache buffers lru chain	47	0	0	1	0.09	0.00
ADR block file write	65	0	0	0	0.12	0.00
asynch descriptor resize	1,149	100	0	0	2.09	0.00
latch: object queue header operation	168	0	0	0	0.31	0.00
latch: messages	27	0	0	1	0.05	0.00
buffer busy waits	5	0	0	3	0.01	0.00
latch: cache buffers chains	7	0	0	1	0.01	0.00
direct path write	45	0	0	0	0.08	0.00
latch: parallel query alloc buffer	7	0	0	1	0.01	0.00
latch: redo writing	11	0	0	0	0.02	0.00
ADR file lock	78	0	0	0	0.14	0.00
direct path write temp	21	0	0	0	0.04	0.00
log file sequential read	60	0	0	0	0.11	0.00
rdbms ipc message	343,081	97	969,103	2825	623.78
PX Idle Wait	85,317	93	161,963	1898	155.12
DIAG idle wait	93,347	100	93,438	1001	169.72
Space Manager: slave idle wait	9,866	98	48,818	4948	17.94
dispatcher timer	780	100	46,802	60003	1.42
shared server idle wait	1,559	100	46,776	30004	2.83
Streams AQ: qmn coordinator idle wait	4,786	35	46,775	9773	8.70
Streams AQ: qmn slave idle wait	2,856	0	46,775	16378	5.19
pmon timer	15,792	99	46,760	2961	28.71
smon timer	221	68	46,654	211106	0.40
SQL*Net message from client	56	0	0	3	0.10
class slave wait	166	0	0	0	0.30

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	169	99.4	.6
ADR block file write	65	98.5	1.5
ADR file lock	78	100.0
Data file init write	359	2.5			.8	52.9	24.8	18.9
Disk file operations I/O	55.8K	.4	48.8	49.9	.9	.0	.0
LGWR wait for redo copy	263	99.2	.8
PX Deq: Signal ACK EXT	651	94.0	4.1	1.2	.6
PX Deq: Signal ACK RSG	860	99.3	.6	.1
PX Deq: Slave Session Stats	5500	7.8	15.4	26.5	41.7	5.2	2.3	1.2
PX qref latch	15.1K	99.8	.1	.0	.0	.0	.0	.0
SQL*Net break/reset to client	7	85.7			14.3
SQL*Net message from dblink	30.7K	46.8	37.6	10.6	3.4	1.1	.2	.2	.0
SQL*Net message to client	13.9K	100.0
SQL*Net message to dblink	30.7K	100.0
SQL*Net more data from dblink	552.4K	94.6	3.1	1.9	.4	.0	.0	.0	.0
SQL*Net more data to client	1	100.0
asynch descriptor resize	46.5K	100.0
buffer busy waits	5		40.0	20.0	40.0
control file parallel write	19.1K	.0	4.9	17.1	16.8	17.5	27.3	16.3
control file sequential read	87.4K	100.0	.0	.0	.0	.0	.0
cursor: mutex S	5	100.0
cursor: pin S	249	96.0	2.4	1.6
cursor: pin S wait on X	478					.2		98.5	1.3
db file async I/O submit	498.4K	.9	8.1	21.6	21.3	17.5	15.5	15.1	.2
db file parallel read	10	50.0	30.0				10.0	10.0
db file scattered read	15.7K	55.9	7.4	7.2	12.7	10.3	6.3	.1
db file sequential read	16.1M	96.3	.1	.4	1.1	1.3	.6	.2
db file single write	10.8K	13.7	18.1	17.8	15.4	21.8	12.6	.5
direct path read	11.2M	94.5	4.6	.4	.3	.0	.1	.2
direct path read temp	88.4K	99.9	.0	.0	.0	.0	.0	.0
direct path sync	16				6.3	25.0	25.0	43.8
direct path write	45	100.0
direct path write temp	23.5K	2.3	1.0	6.6	11.1	16.6	19.5	42.9
enq: BF - allocation contention	110	4.5	8.2	7.3	4.5	38.2	32.7	4.5
enq: KO - fast object checkpoint	9			22.2		33.3	11.1	33.3
enq: PS - contention	16	56.3	18.8	6.3	6.3	6.3		6.3
enq: RO - fast object reuse	4	25.0		25.0	25.0		25.0
kksfbc child completion	7							100.0
latch free	2634	68.9	11.6	6.8	4.6	2.0	3.2	2.9
latch: cache buffers chains	9860	76.7	8.8	6.1	5.0	2.9	.5	.1
latch: cache buffers lru chain	68	88.2	5.9	2.9	1.5	1.5
latch: call allocation	1873	54.5	20.3	8.6	4.1	10.4	2.0
latch: checkpoint queue latch	2	100.0
latch: enqueue hash chains	12	100.0
latch: messages	27	81.5	18.5
latch: object queue header operation	452	88.3	7.5	3.5	.7
latch: parallel query alloc buffer	2957	53.0	19.9	12.8	12.5	1.6	.2
latch: redo writing	11	100.0
latch: row cache objects	80	60.0	20.0	18.8	1.3
latch: shared pool	1397	83.0	8.5	5.9	2.4	.2
latch: undo global data	19	100.0
library cache lock	5			20.0	20.0			60.0
library cache: mutex X	25.2K	62.2	7.9	8.2	7.3	6.7	4.8	2.8
local write wait	6			16.7	33.3	33.3		16.7
log file parallel write	12.6K	68.3	9.3	4.1	8.0	6.5	2.5	1.4
log file sequential read	60	100.0
log file single write	60	51.7	23.3	6.7	5.0	11.7	1.7
log file switch completion	50					8.0	8.0	84.0
log file sync	157	40.1	38.9	6.4	5.1	3.8	3.8	1.9
os thread startup	783							100.0
rdbms ipc reply	825	96.2	3.2	.5	.1
read by other session	236	26.7	10.2	27.1	10.6	15.7	8.1	1.7
reliable message	837	92.4	5.3	1.9	.4	.1
resmgr:internal state change	1							100.0
undo segment extension	4	75.0						25.0
wait list latch free	25					96.0	4.0
DIAG idle wait	93.3K							100.0	.0
PX Deq Credit: need buffer	54.4K	45.8	11.6	11.7	9.5	6.6	5.4	9.1	.3
PX Deq Credit: send blkd	2188.2K	1.2	.5	.5	.5	.5	.5	88.9	7.4
PX Deq: Execute Reply	23.5K	70.6	4.8	4.8	4.8	4.4	4.0	6.1	.5
PX Deq: Execution Msg	389.7K	15.6	4.0	6.9	7.6	1.7	1.0	2.6	60.4
PX Deq: Join ACK	944	98.7	.3	1.0
PX Deq: Msg Fragment	22	100.0
PX Deq: Parse Reply	3333	85.6	5.3	5.9	1.9	.8	.2	.2	.1
PX Deq: Table Q Normal	1058.4K	52.4	15.1	10.9	8.7	6.2	2.2	4.4	.0
PX Idle Wait	84.7K	.4	.0	.0	.0	.0	.0	5.6	94.0
SQL*Net message from client	13.9K	42.5	7.2	1.0	1.3	.3	7.6	8.8	31.3
Space Manager: slave idle wait	9867	.3					.1	.4	99.2
Streams AQ: qmn coordinator idle wait	4786	61.7	3.4	.0					34.9
Streams AQ: qmn slave idle wait	2856	41.5							58.5
VKRM Idle	1								100.0
class slave wait	166	94.0	6.0
dispatcher timer	780								100.0
jobq slave wait	12.8K	.0						100.0
pmon timer	15.8K	1.0	.3		.0	.0	.0	.0	98.7
rdbms ipc message	343.1K	1.0	.1	.1	.1	.1	.1	14.6	83.9
shared server idle wait	1559								100.0
single-task message	5						20.0	80.0
smon timer	221	.9				.9	3.2	23.5	71.5

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
Data file init write	68	81.1	10.6	8.1		.3
PX Deq: Slave Session Stats	68	98.8	1.2
PX qref latch	1	100.0	.0
SQL*Net message from dblink	65	99.8	.1	.0	.0	.0			.0
SQL*Net more data from dblink	2	100.0	.0		.0				.0
control file parallel write	3118	83.7	16.0	.3	.0	.0
cursor: pin S wait on X	477	.2			49.0		49.6	1.3
db file async I/O submit	75.5K	84.8	9.7	4.5	.5	.2	.2	.1	.1
db file parallel read	1	90.0		10.0
db file scattered read	17	99.9	.1	.0	.0
db file sequential read	24.2K	99.8	.1	.0	.0	.0	.0
db file single write	56	99.5	.5	.1	.0
direct path read	19K	99.8	.1	.1	.0	.0	.0
direct path read temp	12	100.0	.0	.0	.0	.0
direct path sync	7	56.3	37.5	6.3
direct path write temp	10.1K	57.1	19.1	14.9	6.3	2.2	.4
enq: BF - allocation contention	5	95.5	3.6		.9
enq: KO - fast object checkpoint	3	66.7	11.1			11.1	11.1
enq: PS - contention	1	93.8					6.3
kksfbc child completion	7		100.0
latch free	76	97.1	.4	1.2	1.3
latch: cache buffers chains	6	99.9	.0	.0
library cache lock	3	40.0			60.0
library cache: mutex X	714	97.2	2.5	.3
local write wait	1	83.3	16.7
log file parallel write	179	98.6	1.2	.1	.0		.0
log file switch completion	42	16.0	24.0	36.0	18.0	6.0
log file sync	3	98.1	1.9
os thread startup	783		100.0
read by other session	4	98.3	1.7
resmgr:internal state change	1			100.0
undo segment extension	1	75.0	25.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s
		% of Total Waits
SQL*Net message from dblink	2	100.0	.0			.0
SQL*Net more data from dblink	1	100.0				.0
db file async I/O submit	425	99.9	.0	.0	.0	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	20,787	11,651	33,548	582,573
dcpos	18,128	11,934	167,201	256,416
SYS$BACKGROUND	0	0	13	391
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	Network Wt Time
SYS$USERS	14021998	5435	32973	114	624718	222
dcpos	13317509	7677	4346	287	2985	0
SYS$BACKGROUND	80608	178	393	17	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 73.0% of Total DB Time (s): 38,917
Captured PL/SQL account for 22.9% of Total DB Time (s): 38,917

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
8,769.39	1	8,769.39	22.53	51.07	51.08	3a1ysypz2dxkw	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
7,192.26	1	7,192.26	18.48	28.90	76.40	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
5,820.35	2	2,910.17	14.96	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
3,355.17	1	3,355.17	8.62	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
2,467.16	1	2,467.16	6.34	34.21	72.73	06k5gndz8x7b6	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL SELE...
1,931.25	1	1,931.25	4.96	32.40	71.95	av6ft5k1vgh02	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...
1,350.99	1	1,350.99	3.47	105.75	1.53	3aayj798wtrtj	DBMS_SCHEDULER	insert into TMP_SALRTRAND_DCEN...
790.54	1	790.54	2.03	113.06	5.40	2ckhyhvrp80tz	DBMS_SCHEDULER	INSERT INTO YS_SALE SELECT * F...
779.51	1	779.51	2.00	76.39	45.64	6f95d6964jnct	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL_SUM ...
772.19	1	772.19	1.98	55.65	47.99	c6vmymh9nk30b	DBMS_SCHEDULER	INSERT INTO YS_SALE_SUM (SALEI...
665.57	1	665.57	1.71	98.17	18.21	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
663.14	1	663.14	1.70	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
544.94	1	544.94	1.40	115.97	3.07	5um301rsu2xd0	DBMS_SCHEDULER	insert into TMP_SALRTRAN_DCENT...
440.04	1	440.04	1.13	28.11	73.29	d1f9wynry2f6h	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...

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 76.4% of Total CPU Time (s): 23,587
Captured PL/SQL account for 19.3% of Total CPU Time (s): 23,587

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	22.02	5,820.35	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
4,478.18	1	4,478.18	18.99	8,769.39	51.07	51.08	3a1ysypz2dxkw	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
3,248.06	1	3,248.06	13.77	3,355.17	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
2,078.90	1	2,078.90	8.81	7,192.26	28.90	76.40	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
1,428.69	1	1,428.69	6.06	1,350.99	105.75	1.53	3aayj798wtrtj	DBMS_SCHEDULER	insert into TMP_SALRTRAND_DCEN...
893.79	1	893.79	3.79	790.54	113.06	5.40	2ckhyhvrp80tz	DBMS_SCHEDULER	INSERT INTO YS_SALE SELECT * F...
844.10	1	844.10	3.58	2,467.16	34.21	72.73	06k5gndz8x7b6	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL SELE...
653.38	1	653.38	2.77	665.57	98.17	18.21	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
631.99	1	631.99	2.68	544.94	115.97	3.07	5um301rsu2xd0	DBMS_SCHEDULER	insert into TMP_SALRTRAN_DCENT...
625.64	1	625.64	2.65	1,931.25	32.40	71.95	av6ft5k1vgh02	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...
595.47	1	595.47	2.52	779.51	76.39	45.64	6f95d6964jnct	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL_SUM ...
462.28	1	462.28	1.96	663.14	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
429.71	1	429.71	1.82	772.19	55.65	47.99	c6vmymh9nk30b	DBMS_SCHEDULER	INSERT INTO YS_SALE_SUM (SALEI...
250.02	1	250.02	1.06	293.20	85.27	17.23	10p1sn457y11s	DBMS_SCHEDULER	INSERT INTO YS_SALE(AGEBRACKET...

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 94.9% of Total User I/O Wait Time (s): 13,290
Captured PL/SQL account for 34.2% of Total User I/O Wait Time (s): 13,290

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	41.35	7,192.26	28.90	76.40	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
4,479.64	1	4,479.64	33.71	8,769.39	51.07	51.08	3a1ysypz2dxkw	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
1,794.43	1	1,794.43	13.50	2,467.16	34.21	72.73	06k5gndz8x7b6	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL SELE...
1,389.48	1	1,389.48	10.46	1,931.25	32.40	71.95	av6ft5k1vgh02	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...
1,189.74	2	594.87	8.95	5,820.35	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
420.62	1	420.62	3.17	3,355.17	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
370.55	1	370.55	2.79	772.19	55.65	47.99	c6vmymh9nk30b	DBMS_SCHEDULER	INSERT INTO YS_SALE_SUM (SALEI...
355.77	1	355.77	2.68	779.51	76.39	45.64	6f95d6964jnct	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL_SUM ...
322.51	1	322.51	2.43	440.04	28.11	73.29	d1f9wynry2f6h	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...
301.35	1	301.35	2.27	663.14	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
263.04	1	263.04	1.98	344.87	29.98	76.27	f2g1zdk2m7czz	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...
160.69	1	160.69	1.21	292.29	22.72	54.98	akr7pb0jr4bzk	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...
136.11	1	136.11	1.02	193.20	30.76	70.45	0jtv9yq6u8cjb	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...

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: 839,385,862
Captured SQL account for 97.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
571,291,948	1	571,291,948.00	68.06	8,769.39	51.07	51.08	3a1ysypz2dxkw	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
241,520,015	1	241,520,015.00	28.77	1,350.99	105.75	1.53	3aayj798wtrtj	DBMS_SCHEDULER	insert into TMP_SALRTRAND_DCEN...
124,557,468	1	124,557,468.00	14.84	790.54	113.06	5.40	2ckhyhvrp80tz	DBMS_SCHEDULER	INSERT INTO YS_SALE SELECT * F...
94,152,644	2	47,076,322.00	11.22	5,820.35	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
63,336,942	1	63,336,942.00	7.55	2,467.16	34.21	72.73	06k5gndz8x7b6	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL SELE...
62,136,132	1	62,136,132.00	7.40	544.94	115.97	3.07	5um301rsu2xd0	DBMS_SCHEDULER	insert into TMP_SALRTRAN_DCENT...
57,835,500	1	57,835,500.00	6.89	3,355.17	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
53,822,877	1	53,822,877.00	6.41	7,192.26	28.90	76.40	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
35,444,859	1	35,444,859.00	4.22	1,931.25	32.40	71.95	av6ft5k1vgh02	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...
18,622,924	1	18,622,924.00	2.22	663.14	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
17,770,999	1	17,770,999.00	2.12	293.20	85.27	17.23	10p1sn457y11s	DBMS_SCHEDULER	INSERT INTO YS_SALE(AGEBRACKET...
17,523,613	1	17,523,613.00	2.09	665.57	98.17	18.21	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...

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: 200,764,749
Captured SQL account for 88.6% 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	29.85	5,820.35	89.25	20.44	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
34,946,814	1	34,946,814.00	17.41	3,355.17	96.81	12.54	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
25,940,331	1	25,940,331.00	12.92	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	8.29	663.14	69.71	45.44	50rfmcah65kr0	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
16,105,581	1	16,105,581.00	8.02	665.57	98.17	18.21	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
13,636,878	1	13,636,878.00	6.79	8,769.39	51.07	51.08	3a1ysypz2dxkw	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
6,337,678	1	6,337,678.00	3.16	2,467.16	34.21	72.73	06k5gndz8x7b6	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL SELE...
4,189,447	1	4,189,447.00	2.09	1,931.25	32.40	71.95	av6ft5k1vgh02	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL(AMT,...
2,492,234	1	2,492,234.00	1.24	779.51	76.39	45.64	6f95d6964jnct	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL_SUM ...
1,674,823	1	1,674,823.00	0.83	790.54	113.06	5.40	2ckhyhvrp80tz	DBMS_SCHEDULER	INSERT INTO YS_SALE SELECT * F...

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: 27,313,051
Captured SQL account for 9.8% of Total
Total UnOptimized Read Requests: 27,313,051
Captured SQL account for 9.8% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
1,172,843	1,172,843	1	1,172,843.00	4.29	5srtgtkcbvkdc	PL/SQL Developer	WITH TB AS ( SELECT D.MANAGENT...
425,730	425,730	1	425,730.00	1.56	3aayj798wtrtj	DBMS_SCHEDULER	insert into TMP_SALRTRAND_DCEN...
263,208	263,208	2	131,604.00	0.96	d83wuwxj37spw	PL/SQL Developer	select m.clientdesc clientdesc...
239,418	239,418	1	239,418.00	0.88	9tqzma1j0kcz0	DBMS_SCHEDULER	INSERT INTO YS_SALE(AGEBRACKET...
181,424	181,424	1	181,424.00	0.66	5um301rsu2xd0	DBMS_SCHEDULER	insert into TMP_SALRTRAN_DCENT...
134,445	134,445	1	134,445.00	0.49	7sz1kxn37kaph	PL/SQL Developer	select m.clientdesc clientdesc...
114,906	114,906	1	114,906.00	0.42	f2vs2dt4yhfpa	PL/SQL Developer	select m.clientdesc clientdesc...
99,781	99,781	1	99,781.00	0.37	c6vmymh9nk30b	DBMS_SCHEDULER	INSERT INTO YS_SALE_SUM (SALEI...
25,411	25,411	1	25,411.00	0.09	6f95d6964jnct	DBMS_SCHEDULER	INSERT INTO YS_SALEDETAIL_SUM ...
3,209	3,209	1	3,209.00	0.01	b2f36qhccu7ny	DBMS_SCHEDULER	insert /+ append / into sys....

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: 76,726
Captured SQL account for 66.9% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
9,360	9,360	1.00	1.06	74.66	0.56	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
9,360	0	0.00	0.73	107.04	0.00	csnp95dz2r8ss		select file#, block# from recy...
8,629	72	0.01	2.69	69.23	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
4,995	127	0.03	0.27	147.24	0.11	gvjxjrrx385ah	OGG-REP_DC-OPEN_DATA_SOURCE	UPDATE "POS"."PRODUCT_INF" SET...
3,968	6,416	1.62	0.67	100.45	4.92	cm5vu20fhtnq1		select /*+ connect_by_filterin...
1,438	28,760	20.00	3.39	100.89	0.00	aykvshm7zsabd		select size_for_estimate, size...
1,438	15,818	11.00	0.74	114.85	0.00	fvkynu9xgck8h		select PGA_TARGET_FOR_ESTIMATE...
1,373	1,318	0.96	0.56	76.32	1.85	g00cj285jmgsw		update sys.mon_mods$ set inser...
1,318	17,134	13.00	0.57	108.52	0.00	772s25v1y0x8k		select shared_pool_size_for_es...
1,078	21,560	20.00	0.29	103.21	0.00	g6gu1n3x0h1h4		select streams_pool_size_for_e...
940	10,339	11.00	0.39	89.35	0.00	bsa0wjtftg3uw		select file# from file$ where ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 45,143
Captured SQL account for 70.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
9,360	9,360	20.73	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
9,360	9,360	20.73	csnp95dz2r8ss		select file#, block# from recy...
3,968	3,968	8.79	cm5vu20fhtnq1		select /*+ connect_by_filterin...
1,373	1,373	3.04	g00cj285jmgsw		update sys.mon_mods$ set inser...
940	940	2.08	bsa0wjtftg3uw		select file# from file$ where ...
364	364	0.81	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
323	323	0.72	f80h0xb1qvbsk		SELECT sys.wri$_adv_seq_msggro...
222	222	0.49	bcv9qynmu1nv9	MMON_SLAVE	select sys.dbms_standard.dicti...
219	219	0.49	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
196	196	0.43	12kw3xcxv1qpg	MMON_SLAVE	select sys.dbms_standard.sysev...

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	34	0.01	ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME...
1,654,186	13	0.01	6wm3n4d7bnddg	SELECT source, (case when tim...
1,348,715	7	0.01	6cp74g22fzahf	WITH ash as (SELECT ash.event...
1,200,456	160	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	940	bsa0wjtftg3uw		select file# from file$ where ...
30	940	bsa0wjtftg3uw		select file# from file$ where ...
26	93	4yyb4104skrwj	DBMS_SCHEDULER	update obj$ set obj#=:4, type#...
23	103	1gfaj4z5hn1kf		delete from dependency$ where ...
23	103	1gfaj4z5hn1kf		delete from dependency$ where ...
21	80	9wncfacx0nj9h		insert into smon_scn_time (thr...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

06k5gndz8x7b6 INSERT INTO YS_SALEDETAIL SELECT DETAILID, SALEID, GOODSID, PRODUCTID, BARCODE, STANDUNITPRICE, DISCOUNTUNITPRICE, QUANTITY, AMT, AMTA, CREATEDATE, NULL, STAFFID, NULL, NULL, UPDATEDATE, NULL, BRANCHID, NULL, CREATEBRANCHID, NULL, BUSINESSDATE, NULL, NULL, GOODSDESCRIPTION, NULL, NULL, NULL, NULL FROM YS_SALEDETAIL_SUM A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID = B.DETAILID) AND A.UPDATEDATE >= TO_DATE ('2012-12-01', 'YYYY-MM-DD')

0jtv9yq6u8cjb INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) SELECT AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID FROM YS_SALEDETAIL@GBPOSHEN A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID=B.DETAILID) AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')

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

10p1sn457y11s INSERT INTO YS_SALE(AGEBRACKETID, AMTTAX, APPROVESTAFFID, BRANCHID, BUSINESSDATE, CASHREGISTERID, COUNTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DISCOUNTPRICE, FREQUENCYID, ISNORETURNFLAG, ISSYNC, ITEMNO, PAYPRICE, RELATIONSALEID, REMARK, SALEID, SALESDATE, SALETYPE, SEXTYPE, SYNCTIME, SYSTIME, UPDATEDATE, UPDATEUSERID, VIPID, WORKDATE) SELECT AGEBRACKETID, AMTTAX, APPROVESTAFFID, BRANCHID, BUSINESSDATE, CASHREGISTERID, COUNTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DISCOUNTPRICE, FREQUENCYID, ISNORETURNFLAG, ISSYNC, ITEMNO, PAYPRICE, RELATIONSALEID, REMARK, SALEID, SALESDATE, SALETYPE, SEXTYPE, SYNCTIME, SYSTIME, UPDATEDATE, UPDATEUSERID, VIPID, WORKDATE FROM YS_SALE@DCRAC A WHERE NOT EXISTS (SELECT A.SALEID FROM YS_SALE B WHERE A.SALEID=B.SALEID) AND A.WORKDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.WORKDATE<=TRUNC(SYSDATE-1, 'DD')

12kw3xcxv1qpg select sys.dbms_standard.sysevent from dual

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

2ckhyhvrp80tz INSERT INTO YS_SALE SELECT * FROM YS_SALE_SUM A WHERE NOT EXISTS (SELECT A.RTNO FROM YS_SALE B WHERE A.RTNO = B.RTNO)

3a1ysypz2dxkw DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; BEGIN begin sp_chq_pg_sync_saledata; sp_gd_pg_sync_saledata; sp_hen_pg_sync_saledata; sp_hub_pg_sync_saledata; sp_sch_pg_sync_saledata; pro_sync_saledata_16; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

3aayj798wtrtj insert into TMP_SALRTRAND_DCENTRE_SUM select * from SALRTRAND_DCENTRESUM_MOVE SDM where not exists(select sdm.detailid from YS_SALEDETAIL_SUM ys where sdm.detailid=ys.detailid)

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)

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

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

5um301rsu2xd0 insert into TMP_SALRTRAN_DCENTRE_SUM select * from SALRTRAN_DCENTRESUM_MOVE SDM where not exists(select sdm.rtno from YS_SALE_SUM ys where sdm.rtno=ys.rtno)

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

6f95d6964jnct INSERT INTO YS_SALEDETAIL_SUM (DETAILID, SALEID, STAFFID, GOODSID, BARCODE, STANDUNITPRICE, DISCOUNTUNITPRICE, QUANTITY, GOODSDESCRIPTION, CREATEDATE, UPDATEDATE, BRANCHID, AMT, AMTA, CREATEBRANCHID, BUSINESSDATE, PRODUCTID, RTNO) SELECT SDN.DETAILID DETAILID, SN.SALEID SALEID, YS.STAFFID STAFFID, YS_GOODS.GOODSID GOODSID, YS_GOODS.BARCODE BARCODE, SDN.UNITPRICE STANDUNITPRICE, SDN.DISCOUNTUNITPRICE DISCOUNTUNITPRICE, SDN.QUANTITY QUANTITY, YS_GOODSSTYLE.NAME || ', ' || YS_GOODSCOLOR.NAME || ', ' || YS_GOODSSIZE.NAME AS GOODSDESCRIPTION, SN.SALESDATE CREATEDATE, SN.SALESDATE UPDATEDATE, SN.BRANCHID BRANCHID, SDN.AMT AMT, SDN.AMT AMTA, SN.CREATEBRANCHID CREATEBRANCHID, SN.BUSINESSDATE BUSINESSDATE, NVL (PI.PRODUCTID, 0) PRODUCTID, SDN.RTNO FROM TMP_SALRTRAND_DCENTRE_SUM SDN INNER JOIN YS_BRAND ON SDN.GIDA = TRIM(YS_BRAND.BRANDCODE) INNER JOIN YS_GOODSSTYLE ON UPPER (TRIM(SDN.GIDB)) = UPPER(TRIM(YS_GOODSSTYLE.NAME)) AND YS_GOODSSTYLE.BRANDID = YS_BRAND.BRANDID INNER JOIN YS_GOODSCOLOR ON UPPER (SDN.GIDC) = UPPER (YS_GOODSCOLOR.CODE) INNER JOIN YS_GOODSSIZE ON SDN.GIDD = YS_GOODSSIZE.CODE AND YS_GOODSSTYLE.SIZECATEGORYID = YS_GOODSSIZE.SIZECATEGORYID INNER JOIN YS_GOODS ON ( YS_GOODSSTYLE.BRANDID = YS_GOODS.BRANDID AND YS_GOODSSTYLE.STYLEID = YS_GOODS.STYLEID AND YS_GOODSCOLOR.COLORID = YS_GOODS.COLORID AND YS_GOODSSIZE.SIZEID = YS_GOODS.SIZEID AND YS_GOODS.ISACTIVE = 1 ) INNER JOIN YS_SALE_SUM SN ON SDN.RTNO = SN.RTNO LEFT JOIN SALRTRAN_DCENTR ESUM_MOVE SRN ON SDN.RTNO = SRN.RTNO LEFT JOIN YS_STAFF YS ON SRN.SALESSTAFFID = YS.CODE AND YS.BRANCHID = SN.BRANCHID LEFT JOIN PRODUCT_INF PI ON YS_GOODS.BARCODE = PI.BARCODE AND YS_GOODS.STYLEID = YS_GOODSSTYLE.STYLEID AND PI.STYLENO = YS_GOODSSTYLE.NAME

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

9tqzma1j0kcz0 INSERT INTO YS_SALE(AGEBRACKETID, AMTTAX, APPROVESTAFFID, BRANCHID, BUSINESSDATE, CASHREGISTERID, COUNTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DISCOUNTPRICE, FREQUENCYID, ISNORETURNFLAG, ISSYNC, ITEMNO, PAYPRICE, RELATIONSALEID, REMARK, SALEID, SALESDATE, SALETYPE, SEXTYPE, SYNCTIME, SYSTIME, UPDATEDATE, UPDATEUSERID, VIPID, WORKDATE) SELECT AGEBRACKETID, AMTTAX, APPROVESTAFFID, BRANCHID, BUSINESSDATE, CASHREGISTERID, COUNTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DISCOUNTPRICE, FREQUENCYID, ISNORETURNFLAG, ISSYNC, ITEMNO, PAYPRICE, RELATIONSALEID, REMARK, SALEID, SALESDATE, SALETYPE, SEXTYPE, SYNCTIME, SYSTIME, UPDATEDATE, UPDATEUSERID, VIPID, WORKDATE FROM YS_SALE@GBPOSHEN A WHERE NOT EXISTS (SELECT A.SALEID FROM YS_SALE B WHERE A.SALEID=B.SALEID) AND A.WORKDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.WORKDATE<=TRUNC(SYSDATE-1, 'DD')

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

akr7pb0jr4bzk INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) WITH SALEDETAIL AS (SELECT A.AMT, A.AMTA, A.BARCODE, A.BRANCHID, A.BUSINESSDATE, A.COSTPRICE, A.CREATEBRANCHID, A.CREATEDATE, A.CREATEUSERID, A.DETAILID, A.DISCOUNTSTAFFID, A.DISCOUNTUNITPRICE, A.FLOORID, A.GOODSDESCRIPTION, A.GOODSID, A.ISSYNC, A.LOCATIONID, A.PRODUCTID, A.PROMOTIONDESCNO, A.PROMOTIONDESCRIPTION, A.PROMOTIONID, A.QUANTITY, A.REMARK, A.SALEID, A.STAFFID, A.STANDUNITPRICE, A.SYSTIME, A.UPDATEDATE, A.UPDATEUSERID FROM YS_SALEDETAIL@GBPOSHUB A INNER JOIN YS_SALE@GBPOSHUB B ON A.SALEID=B.SALEID INNER JOIN YS_BRANCH C ON B.BRANCHID=C.BRANCHID INNER JOIN YS_CLIENT D ON C.KEEPERCLIENTID=D.CLIENTID WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL E WHERE A.DETAILID=E.DETAILID) AND D.MANAGENTCLIENTID='AHUB' AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')) SELECT * FROM SALEDETAIL

av6ft5k1vgh02 INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) SELECT AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID FROM YS_SALEDETAIL@DCRAC A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID=B.DETAILID) AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')

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

b2f36qhccu7ny insert /*+ append */ into sys.ora_temp_1_ds_50601 SELECT /*+ parallel(t, 160) parallel_index(t, 160) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"SALEID", "BRANCHID", "ITEMNO", "SALESDATE", "SALETYPE", "WORKDATE", "DISCOUNTPRICE", "PAYPRICE", "CASHREGISTERID", "COUNTPRICE", "SYSTIME", "SYNCTIME", "ISNORETURNFLAG", "AMTTAX", "ISSYNC", "SEXTYPE", "BUSINESSDATE", "RTNO", "FREQUENCYID", "VIPID", "CREATEUSERID", "CREATEDATE", "UPDATEUSERID", "UPDATEDATE", "RELATIONSALEID", "CREATEBRANCHID", "AGEBRACKETID", "APPROVESTAFFID", "REMARK" from "POS"."YS_SALE_SUM" sample ( .0649350649) t WHERE TBL$OR$IDX$PART$NUM("POS"."YS_SALE_SUM", 0, 4, 0, "ROWID") = :objn UNION ALL SELECT * FROM sys.ora_temp_1_ds_50601 WHERE 1 = 0

bcv9qynmu1nv9 select sys.dbms_standard.dictionary_obj_type from dual

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

c6vmymh9nk30b INSERT INTO YS_SALE_SUM (SALEID, BRANCHID, ITEMNO, SALESDATE, SALETYPE, VIPID, COUNTPRICE, DISCOUNTPRICE, REMARK, CREATEDATE, UPDATEDATE, PAYPRICE, CASHREGISTERID, ISNORETURNFLAG, RTNO, CREATEBRANCHID, AGEBRACKETID, WORKDATE, SYSTIME, APPROVESTAFFID, BUSINESSDATE) SELECT ST.SALEID, B.BRANCHID, ST.DESCNO, ST.SALESDATE, ST.SALETYPE, YV.VIPID, SD.COUNTPRICE, SD.DISCOUNTPRICE, ST.REMARK, ST.CREATEDATE, ST.UPDATEDATE, ST.CPAYAMT, ST.CASHREGISTERID, ST.ISNORETURNFLAG, ST.RTNO, B.BRANCHID CREATEBRANCHID, NULL, ST.WORKDATE, ST.SYSTIME, YS.STAFFID APPROVESTAFFID, ST.WORKDATE BUSINESSDATE FROM TMP_SALRTRAN_DCENTRE_SUM ST INNER JOIN YS_BRANCH B ON TRIM (B.OLDBRANCHDESCID) = ST.BRANCHID LEFT JOIN YS_VIP YV ON YV.CARDNO = ST.CUSTOMERID AND YV.BRANCHID = B.BRANCHID LEFT JOIN YS_STAFF YS ON ST.APPROVEUSERID = YS.CODE AND YS.BRANCHID = B.BRANCHID INNER JOIN (SELECT RTNO, SUM (SD.AMT) AS DISCOUNTPRICE, SUM (COUNTPRICE) AS COUNTPRICE FROM SALRTRAND_DCENTRESUM_MOVE SD GROUP BY RTNO) SD ON ST.RTNO = SD.RTNO

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

d1f9wynry2f6h INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) SELECT AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID FROM YS_SALEDETAIL@GBPOSSCH A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID=B.DETAILID) AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')

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

f2g1zdk2m7czz INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) SELECT AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID FROM YS_SALEDETAIL@GBPOSCHQ A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID=B.DETAILID) AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')

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

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

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

SQL Id	SQL Text
06k5gndz8x7b6	INSERT INTO YS_SALEDETAIL SELECT DETAILID, SALEID, GOODSID, PRODUCTID, BARCODE, STANDUNITPRICE, DISCOUNTUNITPRICE, QUANTITY, AMT, AMTA, CREATEDATE, NULL, STAFFID, NULL, NULL, UPDATEDATE, NULL, BRANCHID, NULL, CREATEBRANCHID, NULL, BUSINESSDATE, NULL, NULL, GOODSDESCRIPTION, NULL, NULL, NULL, NULL FROM YS_SALEDETAIL_SUM A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID = B.DETAILID) AND A.UPDATEDATE >= TO_DATE ('2012-12-01', 'YYYY-MM-DD')
0jtv9yq6u8cjb	INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) SELECT AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID FROM YS_SALEDETAIL@GBPOSHEN A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID=B.DETAILID) AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')
0kkhhb2w93cx0	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
10p1sn457y11s	INSERT INTO YS_SALE(AGEBRACKETID, AMTTAX, APPROVESTAFFID, BRANCHID, BUSINESSDATE, CASHREGISTERID, COUNTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DISCOUNTPRICE, FREQUENCYID, ISNORETURNFLAG, ISSYNC, ITEMNO, PAYPRICE, RELATIONSALEID, REMARK, SALEID, SALESDATE, SALETYPE, SEXTYPE, SYNCTIME, SYSTIME, UPDATEDATE, UPDATEUSERID, VIPID, WORKDATE) SELECT AGEBRACKETID, AMTTAX, APPROVESTAFFID, BRANCHID, BUSINESSDATE, CASHREGISTERID, COUNTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DISCOUNTPRICE, FREQUENCYID, ISNORETURNFLAG, ISSYNC, ITEMNO, PAYPRICE, RELATIONSALEID, REMARK, SALEID, SALESDATE, SALETYPE, SEXTYPE, SYNCTIME, SYSTIME, UPDATEDATE, UPDATEUSERID, VIPID, WORKDATE FROM YS_SALE@DCRAC A WHERE NOT EXISTS (SELECT A.SALEID FROM YS_SALE B WHERE A.SALEID=B.SALEID) AND A.WORKDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.WORKDATE<=TRUNC(SYSDATE-1, 'DD')
12kw3xcxv1qpg	select sys.dbms_standard.sysevent from dual
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
2ckhyhvrp80tz	INSERT INTO YS_SALE SELECT * FROM YS_SALE_SUM A WHERE NOT EXISTS (SELECT A.RTNO FROM YS_SALE B WHERE A.RTNO = B.RTNO)
3a1ysypz2dxkw	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; BEGIN begin sp_chq_pg_sync_saledata; sp_gd_pg_sync_saledata; sp_hen_pg_sync_saledata; sp_hub_pg_sync_saledata; sp_sch_pg_sync_saledata; pro_sync_saledata_16; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
3aayj798wtrtj	insert into TMP_SALRTRAND_DCENTRE_SUM select * from SALRTRAND_DCENTRESUM_MOVE SDM where not exists(select sdm.detailid from YS_SALEDETAIL_SUM ys where sdm.detailid=ys.detailid)
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)
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
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
5um301rsu2xd0	insert into TMP_SALRTRAN_DCENTRE_SUM select * from SALRTRAN_DCENTRESUM_MOVE SDM where not exists(select sdm.rtno from YS_SALE_SUM ys where sdm.rtno=ys.rtno)
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
6f95d6964jnct	INSERT INTO YS_SALEDETAIL_SUM (DETAILID, SALEID, STAFFID, GOODSID, BARCODE, STANDUNITPRICE, DISCOUNTUNITPRICE, QUANTITY, GOODSDESCRIPTION, CREATEDATE, UPDATEDATE, BRANCHID, AMT, AMTA, CREATEBRANCHID, BUSINESSDATE, PRODUCTID, RTNO) SELECT SDN.DETAILID DETAILID, SN.SALEID SALEID, YS.STAFFID STAFFID, YS_GOODS.GOODSID GOODSID, YS_GOODS.BARCODE BARCODE, SDN.UNITPRICE STANDUNITPRICE, SDN.DISCOUNTUNITPRICE DISCOUNTUNITPRICE, SDN.QUANTITY QUANTITY, YS_GOODSSTYLE.NAME \|\| ', ' \|\| YS_GOODSCOLOR.NAME \|\| ', ' \|\| YS_GOODSSIZE.NAME AS GOODSDESCRIPTION, SN.SALESDATE CREATEDATE, SN.SALESDATE UPDATEDATE, SN.BRANCHID BRANCHID, SDN.AMT AMT, SDN.AMT AMTA, SN.CREATEBRANCHID CREATEBRANCHID, SN.BUSINESSDATE BUSINESSDATE, NVL (PI.PRODUCTID, 0) PRODUCTID, SDN.RTNO FROM TMP_SALRTRAND_DCENTRE_SUM SDN INNER JOIN YS_BRAND ON SDN.GIDA = TRIM(YS_BRAND.BRANDCODE) INNER JOIN YS_GOODSSTYLE ON UPPER (TRIM(SDN.GIDB)) = UPPER(TRIM(YS_GOODSSTYLE.NAME)) AND YS_GOODSSTYLE.BRANDID = YS_BRAND.BRANDID INNER JOIN YS_GOODSCOLOR ON UPPER (SDN.GIDC) = UPPER (YS_GOODSCOLOR.CODE) INNER JOIN YS_GOODSSIZE ON SDN.GIDD = YS_GOODSSIZE.CODE AND YS_GOODSSTYLE.SIZECATEGORYID = YS_GOODSSIZE.SIZECATEGORYID INNER JOIN YS_GOODS ON ( YS_GOODSSTYLE.BRANDID = YS_GOODS.BRANDID AND YS_GOODSSTYLE.STYLEID = YS_GOODS.STYLEID AND YS_GOODSCOLOR.COLORID = YS_GOODS.COLORID AND YS_GOODSSIZE.SIZEID = YS_GOODS.SIZEID AND YS_GOODS.ISACTIVE = 1 ) INNER JOIN YS_SALE_SUM SN ON SDN.RTNO = SN.RTNO LEFT JOIN SALRTRAN_DCENTR ESUM_MOVE SRN ON SDN.RTNO = SRN.RTNO LEFT JOIN YS_STAFF YS ON SRN.SALESSTAFFID = YS.CODE AND YS.BRANCHID = SN.BRANCHID LEFT JOIN PRODUCT_INF PI ON YS_GOODS.BARCODE = PI.BARCODE AND YS_GOODS.STYLEID = YS_GOODSSTYLE.STYLEID AND PI.STYLENO = YS_GOODSSTYLE.NAME
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
9tqzma1j0kcz0	INSERT INTO YS_SALE(AGEBRACKETID, AMTTAX, APPROVESTAFFID, BRANCHID, BUSINESSDATE, CASHREGISTERID, COUNTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DISCOUNTPRICE, FREQUENCYID, ISNORETURNFLAG, ISSYNC, ITEMNO, PAYPRICE, RELATIONSALEID, REMARK, SALEID, SALESDATE, SALETYPE, SEXTYPE, SYNCTIME, SYSTIME, UPDATEDATE, UPDATEUSERID, VIPID, WORKDATE) SELECT AGEBRACKETID, AMTTAX, APPROVESTAFFID, BRANCHID, BUSINESSDATE, CASHREGISTERID, COUNTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DISCOUNTPRICE, FREQUENCYID, ISNORETURNFLAG, ISSYNC, ITEMNO, PAYPRICE, RELATIONSALEID, REMARK, SALEID, SALESDATE, SALETYPE, SEXTYPE, SYNCTIME, SYSTIME, UPDATEDATE, UPDATEUSERID, VIPID, WORKDATE FROM YS_SALE@GBPOSHEN A WHERE NOT EXISTS (SELECT A.SALEID FROM YS_SALE B WHERE A.SALEID=B.SALEID) AND A.WORKDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.WORKDATE<=TRUNC(SYSDATE-1, 'DD')
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
akr7pb0jr4bzk	INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) WITH SALEDETAIL AS (SELECT A.AMT, A.AMTA, A.BARCODE, A.BRANCHID, A.BUSINESSDATE, A.COSTPRICE, A.CREATEBRANCHID, A.CREATEDATE, A.CREATEUSERID, A.DETAILID, A.DISCOUNTSTAFFID, A.DISCOUNTUNITPRICE, A.FLOORID, A.GOODSDESCRIPTION, A.GOODSID, A.ISSYNC, A.LOCATIONID, A.PRODUCTID, A.PROMOTIONDESCNO, A.PROMOTIONDESCRIPTION, A.PROMOTIONID, A.QUANTITY, A.REMARK, A.SALEID, A.STAFFID, A.STANDUNITPRICE, A.SYSTIME, A.UPDATEDATE, A.UPDATEUSERID FROM YS_SALEDETAIL@GBPOSHUB A INNER JOIN YS_SALE@GBPOSHUB B ON A.SALEID=B.SALEID INNER JOIN YS_BRANCH C ON B.BRANCHID=C.BRANCHID INNER JOIN YS_CLIENT D ON C.KEEPERCLIENTID=D.CLIENTID WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL E WHERE A.DETAILID=E.DETAILID) AND D.MANAGENTCLIENTID='AHUB' AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')) SELECT * FROM SALEDETAIL
av6ft5k1vgh02	INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) SELECT AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID FROM YS_SALEDETAIL@DCRAC A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID=B.DETAILID) AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
b2f36qhccu7ny	insert /+ append / into sys.ora_temp_1_ds_50601 SELECT /+ parallel(t, 160) parallel_index(t, 160) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"SALEID", "BRANCHID", "ITEMNO", "SALESDATE", "SALETYPE", "WORKDATE", "DISCOUNTPRICE", "PAYPRICE", "CASHREGISTERID", "COUNTPRICE", "SYSTIME", "SYNCTIME", "ISNORETURNFLAG", "AMTTAX", "ISSYNC", "SEXTYPE", "BUSINESSDATE", "RTNO", "FREQUENCYID", "VIPID", "CREATEUSERID", "CREATEDATE", "UPDATEUSERID", "UPDATEDATE", "RELATIONSALEID", "CREATEBRANCHID", "AGEBRACKETID", "APPROVESTAFFID", "REMARK" from "POS"."YS_SALE_SUM" sample ( .0649350649) t WHERE TBL$OR$IDX$PART$NUM("POS"."YS_SALE_SUM", 0, 4, 0, "ROWID") = :objn UNION ALL SELECT * FROM sys.ora_temp_1_ds_50601 WHERE 1 = 0
bcv9qynmu1nv9	select sys.dbms_standard.dictionary_obj_type from dual
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
c6vmymh9nk30b	INSERT INTO YS_SALE_SUM (SALEID, BRANCHID, ITEMNO, SALESDATE, SALETYPE, VIPID, COUNTPRICE, DISCOUNTPRICE, REMARK, CREATEDATE, UPDATEDATE, PAYPRICE, CASHREGISTERID, ISNORETURNFLAG, RTNO, CREATEBRANCHID, AGEBRACKETID, WORKDATE, SYSTIME, APPROVESTAFFID, BUSINESSDATE) SELECT ST.SALEID, B.BRANCHID, ST.DESCNO, ST.SALESDATE, ST.SALETYPE, YV.VIPID, SD.COUNTPRICE, SD.DISCOUNTPRICE, ST.REMARK, ST.CREATEDATE, ST.UPDATEDATE, ST.CPAYAMT, ST.CASHREGISTERID, ST.ISNORETURNFLAG, ST.RTNO, B.BRANCHID CREATEBRANCHID, NULL, ST.WORKDATE, ST.SYSTIME, YS.STAFFID APPROVESTAFFID, ST.WORKDATE BUSINESSDATE FROM TMP_SALRTRAN_DCENTRE_SUM ST INNER JOIN YS_BRANCH B ON TRIM (B.OLDBRANCHDESCID) = ST.BRANCHID LEFT JOIN YS_VIP YV ON YV.CARDNO = ST.CUSTOMERID AND YV.BRANCHID = B.BRANCHID LEFT JOIN YS_STAFF YS ON ST.APPROVEUSERID = YS.CODE AND YS.BRANCHID = B.BRANCHID INNER JOIN (SELECT RTNO, SUM (SD.AMT) AS DISCOUNTPRICE, SUM (COUNTPRICE) AS COUNTPRICE FROM SALRTRAND_DCENTRESUM_MOVE SD GROUP BY RTNO) SD ON ST.RTNO = SD.RTNO
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
d1f9wynry2f6h	INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) SELECT AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID FROM YS_SALEDETAIL@GBPOSSCH A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID=B.DETAILID) AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')
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
f2g1zdk2m7czz	INSERT INTO YS_SALEDETAIL(AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID ) SELECT AMT, AMTA, BARCODE, BRANCHID, BUSINESSDATE, COSTPRICE, CREATEBRANCHID, CREATEDATE, CREATEUSERID, DETAILID, DISCOUNTSTAFFID, DISCOUNTUNITPRICE, FLOORID, GOODSDESCRIPTION, GOODSID, ISSYNC, LOCATIONID, PRODUCTID, PROMOTIONDESCNO, PROMOTIONDESCRIPTION, PROMOTIONID, QUANTITY, REMARK, SALEID, STAFFID, STANDUNITPRICE, SYSTIME, UPDATEDATE, UPDATEUSERID FROM YS_SALEDETAIL@GBPOSCHQ A WHERE NOT EXISTS (SELECT A.DETAILID FROM YS_SALEDETAIL B WHERE A.DETAILID=B.DETAILID) AND A.BUSINESSDATE>=TO_DATE('2013-01-15', 'yyyy-mm-dd') AND A.BUSINESSDATE<=TRUNC(SYSDATE-1, 'DD')
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
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
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	72,557	1.55	131.92
CCursor + sql area evicted	81	0.00	0.15
CPU used by this session	1,654,213	35.36	3,007.66
CPU used when call started	1,133,741	24.24	2,061.35
CR blocks created	38,639	0.83	70.25
Cached Commit SCN referenced	54,591,583	1,167.06	99,257.42
Commit SCN cached	14,162	0.30	25.75
DB time	50,368,858	1,076.78	91,579.74
DBWR checkpoint buffers written	1,585,435	33.89	2,882.61
DBWR checkpoints	43	0.00	0.08
DBWR object drop buffers written	8	0.00	0.01
DBWR parallel query checkpoint buffers written	9,094	0.19	16.53
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	2,535	0.05	4.61
DBWR undo block writes	93,418	2.00	169.85
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	75	0.00	0.14
HSC Heap Segment Block Changes	111,745	2.39	203.17
Heap Segment Array Inserts	86,921	1.86	158.04
Heap Segment Array Updates	261	0.01	0.47
IMU pool not allocated	19,081	0.41	34.69
IMU- failed to get a private strand	19,081	0.41	34.69
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	11,138,490	238.12	20,251.80
PX local messages recv'd	4,210,166	90.00	7,654.85
PX local messages sent	4,210,444	90.01	7,655.35
Parallel operations downgraded 1 to 25 pct	0	0.00	0.00
Parallel operations downgraded 25 to 50 pct	62	0.00	0.11
Parallel operations downgraded 50 to 75 pct	5	0.00	0.01
Parallel operations downgraded to serial	10,074,598	215.37	18,317.45
Parallel operations not downgraded	8	0.00	0.01
RowCR - row contention	7	0.00	0.01
RowCR attempts	44,127	0.94	80.23
RowCR hits	48,071	1.03	87.40
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment shrink	4	0.00	0.01
SQL*Net roundtrips to/from client	13,886	0.30	25.25
SQL*Net roundtrips to/from dblink	30,681	0.66	55.78
TBS Extension: bytes extended	358,809,600	7,670.61	652,381.09
TBS Extension: files extended	9	0.00	0.02
TBS Extension: tasks created	67	0.00	0.12
TBS Extension: tasks executed	67	0.00	0.12
active txn count during cleanout	61,102	1.31	111.09
application wait time	142	0.00	0.26
background checkpoints completed	30	0.00	0.05
background checkpoints started	30	0.00	0.05
background timeouts	335,044	7.16	609.17
branch node splits	18	0.00	0.03
buffer is not pinned count	133,897,064	2,862.44	243,449.21
buffer is pinned count	14,985,407	320.36	27,246.19
bytes received via SQL*Net from client	870,299	18.61	1,582.36
bytes received via SQL*Net from dblink	4,598,989,875	98,316.96	8,361,799.77
bytes sent via SQL*Net to client	9,771,749	208.90	17,766.82
bytes sent via SQL*Net to dblink	620,803	13.27	1,128.73
calls to get snapshot scn: kcmgss	447,717	9.57	814.03
calls to kcmgas	162,698	3.48	295.81
calls to kcmgcs	61,545,767	1,315.72	111,901.39
cell physical IO interconnect bytes	1,673,048,956,928	35,766,350.78	3,041,907,194.41
change write time	5,342	0.11	9.71
cleanout - number of ktugct calls	7,936,136	169.66	14,429.34
cleanouts and rollbacks - consistent read gets	7,865	0.17	14.30
cleanouts only - consistent read gets	7,872,795	168.30	14,314.17
cluster key scan block gets	11,252	0.24	20.46
cluster key scans	10,309	0.22	18.74
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	126	0.00	0.23
commit batch/immediate requested	126	0.00	0.23
commit cleanout failures: block lost	1,324	0.03	2.41
commit cleanout failures: buffer being written	19	0.00	0.03
commit cleanout failures: callback failure	4,406	0.09	8.01
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	1,531,809	32.75	2,785.11
commit cleanouts successfully completed	1,526,060	32.62	2,774.65
commit immediate performed	126	0.00	0.23
commit immediate requested	126	0.00	0.23
commit nowait performed	14	0.00	0.03
commit nowait requested	14	0.00	0.03
commit txn count during cleanout	7,883,942	168.54	14,334.44
commit wait/nowait performed	14	0.00	0.03
commit wait/nowait requested	14	0.00	0.03
concurrency wait time	41,763	0.89	75.93
consistent changes	40,229	0.86	73.14
consistent gets	828,666,795	17,715.19	1,506,666.90
consistent gets - examination	390,975,621	8,358.26	710,864.77
consistent gets direct	174,609,074	3,732.78	317,471.04
consistent gets from cache	654,057,721	13,982.41	1,189,195.86
consistent gets from cache (fastpath)	252,844,519	5,405.30	459,717.31
cursor authentications	172	0.00	0.31
data blocks consistent reads - undo records applied	39,084	0.84	71.06
db block changes	5,579,935	119.29	10,145.34
db block gets	10,719,089	229.15	19,489.25
db block gets direct	15,639	0.33	28.43
db block gets from cache	10,703,450	228.82	19,460.82
db block gets from cache (fastpath)	2,520,782	53.89	4,583.24
deferred (CURRENT) block cleanout applications	914,434	19.55	1,662.61
dirty buffers inspected	691,070	14.77	1,256.49
enqueue conversions	84,750	1.81	154.09
enqueue releases	533,259	11.40	969.56
enqueue requests	533,736	11.41	970.43
enqueue timeouts	234	0.01	0.43
enqueue waits	139	0.00	0.25
exchange deadlocks	0	0.00	0.00
execute count	76,726	1.64	139.50
failed probes on index block reclamation	0	0.00	0.00
file io service time	50,777,960	1,085.53	92,323.56
file io wait time	20,422,228,781	436,585.31	37,131,325.06
free buffer inspected	18,272,952	390.64	33,223.55
free buffer requested	16,347,484	349.48	29,722.70
heap block compress	692	0.01	1.26
hot buffers moved to head of LRU	13,601,357	290.77	24,729.74
immediate (CR) block cleanout applications	7,880,660	168.47	14,328.47
immediate (CURRENT) block cleanout applications	80,696	1.73	146.72
index crx upgrade (positioned)	343,426	7.34	624.41
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	136	0.00	0.25
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	149,193,388	3,189.45	271,260.71
index scans kdiixs1	27,063,670	578.57	49,206.67
leaf node 90-10 splits	355	0.01	0.65
leaf node splits	23,154	0.49	42.10
lob reads	0	0.00	0.00
lob writes	310	0.01	0.56
lob writes unaligned	310	0.01	0.56
logons cumulative	6,148	0.13	11.18
max cf enq hold time	150	0.00	0.27
messages received	523,304	11.19	951.46
messages sent	523,304	11.19	951.46
min active SCN optimization applied on CR	3,180,663	68.00	5,783.02
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	367,874,219	7,864.40	668,862.22
non-idle wait count	29,016,401	620.31	52,757.09
non-idle wait time	2,686,650	57.44	4,884.82
opened cursors cumulative	49,537	1.06	90.07
parse count (describe)	38	0.00	0.07
parse count (failures)	11	0.00	0.02
parse count (hard)	617	0.01	1.12
parse count (total)	45,143	0.97	82.08
parse time cpu	12,997	0.28	23.63
parse time elapsed	39,538	0.85	71.89
physical read IO requests	27,313,051	583.90	49,660.09
physical read bytes	1,644,664,864,768	35,159,557.18	2,990,299,754.12
physical read total IO requests	27,417,493	586.13	49,849.99
physical read total bytes	1,646,226,102,272	35,192,933.23	2,993,138,367.77
physical read total multi block requests	1,088,387	23.27	1,978.89
physical reads	200,764,749	4,291.94	365,026.82
physical reads cache	16,146,509	345.18	29,357.29
physical reads cache prefetch	249,233	5.33	453.15
physical reads direct	184,618,245	3,946.76	335,669.54
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	528,936	11.31	961.70
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	1,993,118	42.61	3,623.85
physical write bytes	24,031,510,528	513,744.34	43,693,655.51
physical write total IO requests	2,051,086	43.85	3,729.25
physical write total bytes	26,822,854,656	573,417.55	48,768,826.65
physical write total multi block requests	27,129	0.58	49.33
physical writes	2,933,534	62.71	5,333.70
physical writes direct	578,241	12.36	1,051.35
physical writes direct (lob)	21	0.00	0.04
physical writes direct temporary tablespace	578,033	12.36	1,050.97
physical writes from cache	2,355,293	50.35	4,282.35
physical writes non checkpoint	2,220,484	47.47	4,037.24
pinned buffers inspected	5	0.00	0.01
pinned cursors current	82	0.00	0.15
prefetch clients - default	17	0.00	0.03
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	64,080	1.37	116.51
process last non-idle time	156,086	3.34	283.79
queries parallelized	73	0.00	0.13
recursive calls	557,978	11.93	1,014.51
recursive cpu usage	1,158,971	24.78	2,107.22
redo blocks checksummed by FG (exclusive)	1,444,138	30.87	2,625.71
redo blocks written	3,356,440	71.75	6,102.62
redo buffer allocation retries	374	0.01	0.68
redo entries	3,510,372	75.04	6,382.49
redo log space requests	424	0.01	0.77
redo log space wait time	500	0.01	0.91
redo ordering marks	95,413	2.04	173.48
redo size	1,661,015,200	35,509.09	3,020,027.64
redo size for direct writes	2,340	0.05	4.25
redo subscn max counts	472,857	10.11	859.74
redo synch time	52	0.00	0.09
redo synch writes	174	0.00	0.32
redo wastage	2,133,100	45.60	3,878.36
redo write time	3,776	0.08	6.87
redo writes	6,320	0.14	11.49
rollback changes - undo records applied	428	0.01	0.78
rollbacks only - consistent read gets	30,773	0.66	55.95
root node splits	0	0.00	0.00
rows fetched via callback	59,638	1.27	108.43
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	35,291	0.75	64.17
session logical reads	839,385,862	17,944.35	1,526,156.11
shared hash latch upgrades - no wait	5,829,116	124.61	10,598.39
shared hash latch upgrades - wait	13	0.00	0.02
sorts (disk)	1	0.00	0.00
sorts (memory)	29,113	0.62	52.93
sorts (rows)	86,389,852	1,846.84	157,072.46
sql area evicted	81	0.00	0.15
sql area purged	168	0.00	0.31
summed dirty queue length	2,113,545	45.18	3,842.81
switch current to new buffer	995	0.02	1.81
table fetch by rowid	6,565,990	140.37	11,938.16
table fetch continued row	51,565	1.10	93.75
table scan blocks gotten	175,082,910	3,742.91	318,332.56
table scan rows gotten	3,199,780,480	68,404.74	5,817,782.69
table scans (cache partitions)	7,027	0.15	12.78
table scans (direct read)	10,152,837	217.05	18,459.70
table scans (long tables)	10,158,273	217.16	18,469.59
table scans (rowid ranges)	90,710	1.94	164.93
table scans (short tables)	13,894	0.30	25.26
temp space allocated (bytes)	462,422,016	9,885.63	840,767.30
total cf enq hold time	130,260	2.78	236.84
total number of cf enq holders	808	0.02	1.47
total number of times SMON posted	70	0.00	0.13
transaction rollbacks	126	0.00	0.23
transaction tables consistent read rollbacks	1	0.00	0.00
transaction tables consistent reads - undo records applied	456	0.01	0.83
undo change vector size	547,979,976	11,714.69	996,327.23
user I/O wait time	1,328,979	28.41	2,416.33
user calls	43,907	0.94	79.83
user commits	550	0.01	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	8	0.00	0.01
workarea executions - optimal	15,568	0.33	28.31
write clones created in background	7	0.00	0.01
write clones created in foreground	14	0.00	0.03

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	132,897,733,992	162,401,257,936
session pga memory	1,376,507,360	2,846,069,688
session pga memory max	2,466,504,800	7,735,244,664
session cursor cache count	46,755	56,260
session uga memory	3,664,694,219,736	4,130,062,567,416
opened cursors current	72	161
workarea memory allocated	809	457,024
logons current	39	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)	30	2.31

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.4T	240.51	30.7877	14M	0.00	.000299	11.3M	0.25
Buffer Cache Reads	123.2G	339.75	2.69599	0M	0.00	0M	15.9M	0.46
DBWR	1M	0.00	.000021	18G	42.09	.393268	498.5K	24.58
Direct Writes	0M	0.00	0M	4.4G	0.50	.096200	23.5K	51.05
Others	2.7G	5.64	.058596	1013M	1.04	.021655	315.1K	2.21
LGWR	9M	0.01	.000192	1.6G	0.20	.035230	7585	5.54
Streams AQ	0M	0.00	0M	0M	0.00	0M	17	6.41
TOTAL:	1.5T	585.91	33.5425	25G	43.84	.546655	28M	0.87

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.5T	582.40	33.4436	18G	42.33	.394252	0.28	2.63
Temp File	4.1G	1.89	.090749	4.4G	0.50	.096500	0.03	0.03
Control File	1.3G	1.87	.029202	597M	0.82	.012762	0.00
Log File	0M	0.00	0M	1.6G	0.19	.035038	0.00
TOTAL:	1.5T	586.16	33.5635	24.6G	43.84	.538553	0.28	2.60

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.4T	240.51	30.7878	14M	0.00	.000299	0
Direct Reads (Data File)	1.4T	240.51	30.7878	14M	0.00	.000299	0
Buffer Cache Reads	123.2G	339.75	2.69599	0M	0.00	0M	15.9M	0.46
Buffer Cache Reads (Data File)	123.2G	339.75	2.69599	0M	0.00	0M	15.9M	0.46
DBWR	1M	0.00	.000021	18G	42.09	.393268	53	0.00
DBWR (Data File)	0M	0.00	0M	18G	42.09	.393268	0
DBWR (Control File)	1M	0.00	.000021	0M	0.00	0M	53	0.00
Direct Writes	0M	0.00	0M	4.4G	0.50	.096200	0
Direct Writes (Data File)	0M	0.00	0M	4.4G	0.50	.096200	0
Others	2.7G	5.64	.058575	1013M	1.04	.021655	277.1K	0.26
Others (Control File)	1.3G	1.86	.028988	587M	0.80	.012548	86.8K	0.00
Others (Data File)	1.4G	3.78	.029587	426M	0.24	.009107	190.3K	0.38
LGWR	9M	0.01	.000192	1.6G	0.20	.035230	663	0.23
LGWR (Log File)	0M	0.00	0M	1.6G	0.19	.035038	120	1.25
LGWR (Control File)	9M	0.01	.000192	9M	0.01	.000192	543	0.00
Streams AQ	0M	0.00	0M	0M	0.00	0M	17	6.41
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	17	6.41
TOTAL:	1.5T	585.92	33.5426	25G	43.84	.546655	16.2M	0.45

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	11,100,305	237	0.05	4.65	223,884	5	247	4.21
POS_SALEDETAIL_IX	9,704,939	207	0.42	1.00	1,449,528	31	0	0.00
POS_SALE_IX	4,594,103	98	0.12	1.00	264,935	6	9	11.11
POS_SALE_201302	250,483	5	8.22	6.44	11	0	24	5.83
POS_SALE_201301	190,662	4	3.43	7.30	8	0	12	8.33
TEMP	88,611	2	0.00	6.14	23,490	1	0	0.00
POS_SALE_201303	108,994	2	0.60	4.63	2,495	0	0	0.00
POS_SALEDETAIL_201209	91,628	2	0.00	127.40	0	0	0	0.00
POS_SALEDETAIL_201207	66,554	1	0.00	127.37	0	0	0	0.00
POS_SALEDETAIL_201210	59,354	1	0.00	127.50	0	0	0	0.00
POS_SALEDETAIL_201303	31,915	1	0.02	42.84	8,809	0	0	0.00
POS_SALEDETAIL_201212	39,937	1	0.00	127.37	0	0	0	0.00
SALRTRAN_SUM12	38,428	1	0.01	85.66	0	0	0	0.00
POS_SALEDETAIL_201201	36,127	1	0.00	127.37	0	0	0	0.00
POS_SALEDETAIL_201302	35,383	1	0.00	127.14	0	0	0	0.00
POS_SALEDETAIL_201301	32,215	1	0.00	127.27	0	0	0	0.00
POS_SALEDETAIL_201208	29,437	1	0.00	127.41	0	0	0	0.00
YS_SALE_SUM1203	26,636	1	0.02	43.39	0	0	0	0.00
YS_SALE_SUM1202	26,466	1	0.02	43.61	0	0	0	0.00
YS_SALE_SUM1201	26,257	1	0.01	41.89	0	0	0	0.00
POS_SALEDETAIL_201204	25,759	1	0.00	127.40	0	0	0	0.00
YS_SALE_SUM1204	25,065	1	0.02	38.28	0	0	0	0.00
POS_SALEDETAIL_201205	24,787	1	0.00	127.28	0	0	0	0.00
POS_SALEDETAIL_201211	24,709	1	0.00	127.28	0	0	0	0.00
YS_SALE_SUM1301	23,841	1	0.02	41.71	348	0	0	0.00
POS_SALEDETAIL_201007	23,839	1	0.00	127.32	0	0	0	0.00
YS_SALEDETAIL_SUM1202	23,242	0	0.01	67.02	0	0	0	0.00
POS_SALEDETAIL_201008	23,053	0	0.00	127.26	0	0	0	0.00
POS_SALEDETAIL_201005	23,047	0	0.00	127.34	0	0	0	0.00
POS_SALEDETAIL_201206	22,717	0	0.00	127.32	0	0	0	0.00
POS_SALEDETAIL_201006	22,693	0	0.00	127.22	0	0	0	0.00
YS_SALEDETAIL_SUM1201	22,156	0	0.01	65.66	0	0	0	0.00
YS_SALEDETAIL_SUM1301	20,850	0	0.01	66.18	615	0	0	0.00
POS_SALE_201212	21,430	0	0.02	34.43	8	0	0	0.00
YS_SALEDETAIL_SUM1204	20,108	0	0.01	63.71	0	0	0	0.00
POS_SALEDETAIL_201203	18,721	0	0.00	127.21	0	0	0	0.00
YS_SALEDETAIL_SUM1203	18,407	0	0.01	59.16	0	0	0	0.00
POS_SALEDETAIL_201101	17,095	0	0.00	127.16	0	0	0	0.00
SALRTRAND_SUM3	16,220	0	0.01	52.54	57	0	0	0.00
SALRTRAND_SUM2	16,222	0	0.01	52.48	52	0	0	0.00
SALRTRAND_SUM4	16,228	0	0.01	52.11	41	0	0	0.00
SALRTRAND_SUM1	16,198	0	0.01	52.73	37	0	0	0.00
POS_SALEDETAIL_201202	15,307	0	0.00	127.21	0	0	0	0.00
POS_SALEDETAIL_201110	14,779	0	0.00	127.15	0	0	0	0.00
POS_SALEDETAIL_201112	14,347	0	0.00	127.20	0	0	0	0.00
SALRTRAN_SUM13	14,155	0	0.01	53.39	74	0	0	0.00
POS_SALEDETAIL_201109	13,879	0	0.00	127.16	0	0	0	0.00
POS_SALEDETAIL_201108	13,873	0	0.00	127.18	0	0	0	0.00
UNDOTBS1	594	0	0.13	1.00	13,250	0	6	3.33
POS_SALEDETAIL_201105	12,325	0	0.00	127.03	0	0	0	0.00
POS_SALEDETAIL_201010	12,319	0	0.00	127.08	0	0	0	0.00
POS_SALEDETAIL_201001	11,917	0	0.00	127.09	0	0	0	0.00
POS_SALEDETAIL_201107	11,881	0	0.00	127.09	0	0	0	0.00
POS_SALEDETAIL_201011	11,581	0	0.00	126.99	0	0	0	0.00
POS_SALEDETAIL_201002	11,557	0	0.00	127.02	0	0	0	0.00
POS_SALEDETAIL_201004	11,539	0	0.00	127.04	0	0	0	0.00
POS_SALEDETAIL_201003	11,527	0	0.00	127.01	0	0	0	0.00
POS_SALEDETAIL_201012	11,527	0	0.00	127.05	0	0	0	0.00
POS_SALEDETAIL_201009	11,521	0	0.00	127.08	0	0	0	0.00
POS_SALEDETAIL_201104	11,515	0	0.00	127.04	0	0	0	0.00
POS_SALEDETAIL_201111	11,143	0	0.00	127.03	0	0	0	0.00
POS_SALEDETAIL_201106	10,747	0	0.00	126.94	0	0	0	0.00
POS_SALEDETAIL_201102	8,461	0	0.00	126.67	0	0	0	0.00
SYSAUX	3,883	0	0.60	1.20	4,562	0	0	0.00
POS_SALEDETAIL_201103	8,317	0	0.00	126.77	0	0	0	0.00
SYSTEM	4,824	0	0.28	2.05	767	0	0	0.00
YS_SALEDETAIL_SUM1304	105	0	0.00	4.32	1	0	0	0.00
POS_SALEDETAIL_2013	79	0	0.00	29.78	0	0	0	0.00
YS_SALE_SUM1304	55	0	0.00	2.45	2	0	0	0.00
OGG	2	0	0.00	1.00	8	0	0	0.00
YS_SALEDETAIL_SUM1302	2	0	0.00	1.00	0	0	0	0.00
YS_SALEDETAIL_SUM1303	2	0	0.00	1.00	0	0	0	0.00
YS_SALE_SUM1302	2	0	0.00	1.00	0	0	0	0.00
YS_SALE_SUM1303	2	0	0.00	1.00	0	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	2	0	0.00	1.00	8	0	0	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA01.DBF	176,364	4	0.43	1.22	42,665	1	2	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA02.DBF	180,443	4	0.43	1.48	43,970	1	39	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA03.DBF	189,990	4	1.08	1.19	48,219	1	74	5.54
POS_DATA	/u06/oradata/dcpos/POS_DATA04.DBF	168,614	4	0.46	1.22	44,317	1	102	4.41
POS_DATA	/u06/oradata/dcpos/POS_DATA05.DBF	10,247,721	219	0.01	4.93	43,058	1	23	7.83
POS_DATA	/u06/oradata/dcpos/POS_DATA06.DBF	11,628	0	0.09	1.63	228	0	7	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA07.DBF	4,797	0	0.05	1.00	51	0	0	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA08.DBF	5,106	0	0.04	1.00	56	0	0	0.00
POS_DATA	/u06/oradata/dcpos/POS_DATA09.DBF	5,493	0	0.05	1.00	64	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA10.DBF	4,902	0	0.03	1.00	56	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA11.DBF	7,366	0	0.03	1.00	57	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA12.DBF	6,027	0	0.05	1.00	54	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA13.DBF	10,016	0	0.03	1.00	65	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA14.DBF	6,246	0	0.04	1.00	56	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA15.DBF	5,308	0	0.05	1.00	55	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA16.DBF	7,514	0	0.05	1.00	67	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA17.DBF	7,131	0	0.05	1.00	56	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA18.DBF	4,599	0	0.03	1.00	26	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA19.DBF	4,164	0	0.03	1.00	37	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA20.DBF	6,905	0	0.03	1.00	58	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA21.DBF	9,598	0	0.04	1.00	63	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA22.DBF	9,362	0	0.04	1.00	60	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA23.DBF	10,442	0	0.10	1.00	274	0	0	0.00
POS_DATA	/u07/oradata/dcpos/POS_DATA24.DBF	10,569	0	0.12	1.00	272	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	0	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	0	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	0	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	0	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	0	0.00	127.52	0	0	0	0.00
POS_SALEDETAIL_201201	/u07/oradata/dcpos/POS_SALEDETAIL_2012014.DBF	7,530	0	0.00	127.45	0	0	0	0.00
POS_SALEDETAIL_201201	/u07/oradata/dcpos/POS_SALEDETAIL_2012015.DBF	7,542	0	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	0	0.00	127.51	0	0	0	0.00
POS_SALEDETAIL_201205	/u07/oradata/dcpos/POS_SALEDETAIL_2012054.DBF	5,580	0	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	0	0.00	127.51	0	0	0	0.00
POS_SALEDETAIL_201206	/u07/oradata/dcpos/POS_SALEDETAIL_2012063.DBF	6,492	0	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	0	0.00	127.05	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012071.DBF	6,649	0	0.00	127.02	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012072.DBF	14,976	0	0.00	127.42	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012073.DBF	7,176	0	0.00	127.48	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012074.DBF	14,203	0	0.00	127.44	0	0	0	0.00
POS_SALEDETAIL_201207	/u07/oradata/dcpos/POS_SALEDETAIL_2012075.DBF	16,950	0	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	0	0.00	127.05	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012091.DBF	9,810	0	0.00	127.11	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012092.DBF	17,766	0	0.00	127.45	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012093.DBF	17,383	0	0.00	127.44	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012094.DBF	17,766	0	0.00	127.45	0	0	0	0.00
POS_SALEDETAIL_201209	/u07/oradata/dcpos/POS_SALEDETAIL_2012095.DBF	20,016	0	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	0	0.00	126.95	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_20121011.DBF	7,776	0	0.00	127.50	0	0	0	0.00
POS_SALEDETAIL_201210	/u07/oradata/dcpos/POS_SALEDETAIL_20121012.DBF	7,008	0	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	0	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	0	0.00	127.49	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012123.DBF	5,868	0	0.00	127.08	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012124.DBF	6,234	0	0.00	127.54	0	0	0	0.00
POS_SALEDETAIL_201212	/u07/oradata/dcpos/POS_SALEDETAIL_2012125.DBF	5,466	0	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	0	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	0	0.00	126.70	0	0	0	0.00
POS_SALEDETAIL_201301	/u06/oradata/dcpos/POS_SALE_2013011.DBF	7,698	0	0.00	127.52	0	0	0	0.00
POS_SALEDETAIL_201301	/u06/oradata/dcpos/POS_SALE_2013012.DBF	7,530	0	0.00	127.48	0	0	0	0.00
POS_SALEDETAIL_201301	/u06/oradata/dcpos/POS_SALE_2013013.DBF	7,650	0	0.00	127.52	0	0	0	0.00
POS_SALEDETAIL_201302	/u06/oradata/dcpos/POS_SALE_201302.DBF	35,383	1	0.00	127.14	0	0	0	0.00
POS_SALEDETAIL_201303	/u06/oradata/dcpos/POS_SALE_201303.DBF	31,915	1	0.02	42.84	8,809	0	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX.DBF	2,720,940	58	0.67	1.00	543,055	12	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX01.DBF	2,756,786	59	0.68	1.00	544,174	12	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX02.DBF	698,407	15	0.08	1.00	60,442	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX03.DBF	699,180	15	0.08	1.00	60,356	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX04.DBF	700,024	15	0.08	1.00	60,598	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX05.DBF	703,455	15	0.08	1.00	62,414	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX06.DBF	698,646	15	0.08	1.00	60,359	1	0	0.00
POS_SALEDETAIL_IX	/u07/oradata/dcpos/POS_SALEDETAIL_IX07.DBF	727,501	16	0.08	1.00	58,130	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	4	3.43	7.30	8	0	12	8.33
POS_SALE_201302	/u06/oradata/dcpos/POS_SALE_20132.DBF	250,483	5	8.22	6.44	11	0	24	5.83
POS_SALE_201303	/u06/oradata/dcpos/POS_SALE_20133.DBF	108,994	2	0.60	4.63	2,495	0	0	0.00
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX.DBF	1,206,207	26	0.12	1.00	69,421	1	6	11.67
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX01.DBF	1,208,203	26	0.13	1.00	70,330	2	1	0.00
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX02.DBF	726,216	16	0.12	1.00	41,638	1	1	0.00
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX03.DBF	726,698	16	0.12	1.00	41,741	1	1	30.00
POS_SALE_IX	/u06/oradata/dcpos/POS_SALE_IX04.DBF	726,779	16	0.11	1.00	41,805	1	0	0.00
SALRTRAND_SUM1	/u06/oradata/dcpos/salrtrand_sum101.dbf	3,781	0	0.02	52.55	0	0	0	0.00
SALRTRAND_SUM1	/u06/oradata/dcpos/salrtrand_sum102.dbf	4,181	0	0.02	53.30	36	0	0	0.00
SALRTRAND_SUM1	/u06/oradata/dcpos/salrtrand_sum103.dbf	3,993	0	0.01	50.55	0	0	0	0.00
SALRTRAND_SUM1	/u06/oradata/dcpos/salrtrand_sum104.dbf	4,243	0	0.01	54.38	1	0	0	0.00
SALRTRAND_SUM2	/u06/oradata/dcpos/salrtrand_sum201.dbf	3,747	0	0.01	53.52	0	0	0	0.00
SALRTRAND_SUM2	/u06/oradata/dcpos/salrtrand_sum202.dbf	4,271	0	0.01	52.76	51	0	0	0.00
SALRTRAND_SUM2	/u06/oradata/dcpos/salrtrand_sum203.dbf	3,943	0	0.01	49.83	0	0	0	0.00
SALRTRAND_SUM2	/u06/oradata/dcpos/salrtrand_sum204.dbf	4,261	0	0.01	53.72	1	0	0	0.00
SALRTRAND_SUM3	/u06/oradata/dcpos/salrtrand_sum301.dbf	3,719	0	0.01	53.51	0	0	0	0.00
SALRTRAND_SUM3	/u06/oradata/dcpos/salrtrand_sum302.dbf	4,252	0	0.01	53.39	56	0	0	0.00
SALRTRAND_SUM3	/u06/oradata/dcpos/salrtrand_sum303.dbf	3,950	0	0.01	50.69	0	0	0	0.00
SALRTRAND_SUM3	/u06/oradata/dcpos/salrtrand_sum304.dbf	4,299	0	0.01	52.56	1	0	0	0.00
SALRTRAND_SUM4	/u06/oradata/dcpos/salrtrand_sum401.dbf	3,749	0	0.01	52.68	0	0	0	0.00
SALRTRAND_SUM4	/u06/oradata/dcpos/salrtrand_sum402.dbf	4,227	0	0.01	53.43	40	0	0	0.00
SALRTRAND_SUM4	/u06/oradata/dcpos/salrtrand_sum403.dbf	3,954	0	0.01	49.35	0	0	0	0.00
SALRTRAND_SUM4	/u06/oradata/dcpos/salrtrand_sum404.dbf	4,298	0	0.01	52.84	1	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum1201.dbf	3,924	0	0.01	88.56	0	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum12010.dbf	3,785	0	0.01	91.77	0	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum1202.dbf	3,910	0	0.01	83.21	0	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum1203.dbf	3,715	0	0.01	84.75	0	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum1204.dbf	3,803	0	0.01	82.93	0	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum1205.dbf	3,772	0	0.01	83.61	0	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum1206.dbf	3,769	0	0.01	83.68	0	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum1207.dbf	3,758	0	0.01	83.93	0	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum1208.dbf	3,929	0	0.01	88.45	0	0	0	0.00
SALRTRAN_SUM12	/u06/oradata/dcpos/salrtran_sum1209.dbf	4,063	0	0.01	85.57	0	0	0	0.00
SALRTRAN_SUM13	/u06/oradata/dcpos/salrtran_sum1301.dbf	4,546	0	0.02	53.94	1	0	0	0.00
SALRTRAN_SUM13	/u06/oradata/dcpos/salrtran_sum1302.dbf	4,955	0	0.01	53.50	73	0	0	0.00
SALRTRAN_SUM13	/u06/oradata/dcpos/salrtran_sum1303.dbf	4,654	0	0.01	52.74	0	0	0	0.00
SYSAUX	/u06/oradata/dcpos/sysaux01.dbf	3,883	0	0.60	1.20	4,562	0	0	0.00
SYSTEM	/u06/oradata/dcpos/system01.dbf	4,759	0	0.28	2.06	729	0	0	0.00
SYSTEM	/u06/oradata/dcpos/system02.dbf	65	0	0.00	1.42	38	0	0	0.00
TEMP	/u06/oradata/dcpos/temp01.dbf	10,726	0	0.01	24.74	11,679	0	0
TEMP	/u06/oradata/dcpos/temp02.dbf	1,189	0	0.00	24.53	1,271	0	0
TEMP	/u06/oradata/dcpos/temp03.dbf	933	0	0.01	23.98	986	0	0
TEMP	/u06/oradata/dcpos/temp04.dbf	1,544	0	0.01	24.02	1,624	0	0
TEMP	/u06/oradata/dcpos/temp05.dbf	70,198	2	0.00	1.31	3,703	0	0
TEMP	/u06/oradata/dcpos/temp06.dbf	1,612	0	0.00	24.64	1,692	0	0
TEMP	/u06/oradata/dcpos/temp07.dbf	824	0	0.00	25.16	877	0	0
TEMP	/u06/oradata/dcpos/temp08.dbf	1,578	0	0.01	24.03	1,658	0	0
TEMP	/u06/oradata/dcpos/temp09.dbf	1	0	10.00	1.00	0	0	0
TEMP	/u06/oradata/dcpos/temp10.dbf	1	0	10.00	1.00	0	0	0
TEMP	/u06/oradata/dcpos/temp11.dbf	1	0	10.00	1.00	0	0	0
TEMP	/u06/oradata/dcpos/temp12.dbf	1	0	20.00	1.00	0	0	0
TEMP	/u06/oradata/dcpos/temp13.dbf	1	0	20.00	1.00	0	0	0
TEMP	/u06/oradata/dcpos/temp14.dbf	1	0	10.00	1.00	0	0	0
TEMP	/u06/oradata/dcpos/temp15.dbf	1	0	10.00	1.00	0	0	0
UNDOTBS1	/u06/oradata/dcpos/undotbs01.dbf	158	0	0.06	1.00	4,199	0	2	5.00
UNDOTBS1	/u06/oradata/dcpos/undotbs02.dbf	136	0	0.07	1.00	1,625	0	0	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs03.dbf	151	0	0.40	1.00	1,531	0	0	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs04.dbf	41	0	0.00	1.00	961	0	1	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs05.dbf	31	0	0.00	1.00	850	0	2	5.00
UNDOTBS1	/u06/oradata/dcpos/undotbs06.dbf	15	0	0.00	1.00	725	0	1	0.00
UNDOTBS1	/u06/oradata/dcpos/undotbs11.dbf	8	0	0.00	1.00	756	0	0	0.00
UNDOTBS1	/u07/oradata/dcpos/undotbs07.dbf	26	0	0.00	1.00	715	0	0	0.00
UNDOTBS1	/u07/oradata/dcpos/undotbs08.dbf	10	0	0.00	1.00	546	0	0	0.00
UNDOTBS1	/u07/oradata/dcpos/undotbs09.dbf	10	0	0.00	1.00	554	0	0	0.00
UNDOTBS1	/u07/oradata/dcpos/undotbs10.dbf	8	0	0.00	1.00	788	0	0	0.00
YS_SALEDETAIL_SUM1201	/u06/oradata/dcpos/ys_saledetail_sum1201.dbf	11,166	0	0.01	65.68	0	0	0	0.00
YS_SALEDETAIL_SUM1201	/u06/oradata/dcpos/ys_saledetail_sum12011.dbf	10,990	0	0.01	65.63	0	0	0	0.00
YS_SALEDETAIL_SUM1202	/u06/oradata/dcpos/ys_saledetail_sum1202.dbf	11,676	0	0.01	67.18	0	0	0	0.00
YS_SALEDETAIL_SUM1202	/u06/oradata/dcpos/ys_saledetail_sum12021.dbf	11,566	0	0.01	66.87	0	0	0	0.00
YS_SALEDETAIL_SUM1203	/u06/oradata/dcpos/ys_saledetail_sum1203.dbf	9,310	0	0.02	58.81	0	0	0	0.00
YS_SALEDETAIL_SUM1203	/u06/oradata/dcpos/ys_saledetail_sum12031.dbf	9,097	0	0.01	59.52	0	0	0	0.00
YS_SALEDETAIL_SUM1204	/u06/oradata/dcpos/ys_saledetail_sum1204.dbf	10,173	0	0.01	64.04	0	0	0	0.00
YS_SALEDETAIL_SUM1204	/u06/oradata/dcpos/ys_saledetail_sum12041.dbf	9,935	0	0.01	63.36	0	0	0	0.00
YS_SALEDETAIL_SUM1301	/u06/oradata/dcpos/ys_saledetail_sum1301.dbf	20,850	0	0.01	66.18	615	0	0	0.00
YS_SALEDETAIL_SUM1302	/u06/oradata/dcpos/ys_saledetail_sum1302.dbf	2	0	0.00	1.00	0	0	0	0.00
YS_SALEDETAIL_SUM1303	/u06/oradata/dcpos/ys_saledetail_sum1303.dbf	2	0	0.00	1.00	0	0	0	0.00
YS_SALEDETAIL_SUM1304	/u06/oradata/dcpos/ys_saledetail_sum1304.dbf	105	0	0.00	4.32	1	0	0	0.00
YS_SALE_SUM1201	/u06/oradata/dcpos/ys_sale_sum120101.dbf	12,948	0	0.01	41.24	0	0	0	0.00
YS_SALE_SUM1201	/u06/oradata/dcpos/ys_sale_sum120102.dbf	13,309	0	0.01	42.53	0	0	0	0.00
YS_SALE_SUM1202	/u06/oradata/dcpos/ys_sale_sum120201.dbf	13,262	0	0.02	44.19	0	0	0	0.00
YS_SALE_SUM1202	/u06/oradata/dcpos/ys_sale_sum120202.dbf	13,204	0	0.02	43.04	0	0	0	0.00
YS_SALE_SUM1203	/u06/oradata/dcpos/ys_sale_sum120301.dbf	13,412	0	0.02	43.88	0	0	0	0.00
YS_SALE_SUM1203	/u06/oradata/dcpos/ys_sale_sum120302.dbf	13,224	0	0.02	42.88	0	0	0	0.00
YS_SALE_SUM1204	/u06/oradata/dcpos/ys_sale_sum120401.dbf	12,287	0	0.02	39.94	0	0	0	0.00
YS_SALE_SUM1204	/u06/oradata/dcpos/ys_sale_sum120402.dbf	12,778	0	0.02	36.68	0	0	0	0.00
YS_SALE_SUM1301	/u06/oradata/dcpos/ys_sale_sum130101.dbf	23,841	1	0.02	41.71	348	0	0	0.00
YS_SALE_SUM1302	/u06/oradata/dcpos/ys_sale_sum130201.dbf	2	0	0.00	1.00	0	0	0	0.00
YS_SALE_SUM1303	/u06/oradata/dcpos/ys_sale_sum130301.dbf	2	0	0.00	1.00	0	0	0	0.00
YS_SALE_SUM1304	/u06/oradata/dcpos/ys_sale_sum130401.dbf	55	0	0.00	2.45	2	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	664,749,486	16,146,790	2,355,293	0	0	298

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 2,933,534

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	1,576,248	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	286	1166	1289	9289728	1289
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.64	19,790	272

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	12,688	12,688	0
64K	128K	221	221	0
128K	256K	28	28	0
256K	512K	186	186	0
512K	1024K	870	870	0
1M	2M	870	870	0
2M	4M	136	136	0
4M	8M	175	173	2
8M	16M	150	146	4
16M	32M	7	7	0
32M	64M	160	160	0
64M	128M	82	80	2
128M	256M	2	2	0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd PGA Cache Hit %	Estd Time
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	292	1	5
file header block	4	0	3
undo header	2	0	5

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
KO-Multiple Object Checkpoint (fast object checkpoint)	81	81	0	9	1	152.22
PS-PX Process Reservation	22,818	22,812	0	16	1	66.25
RO-Multiple Object Reuse (fast object reuse)	36	36	0	4	0	10.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	90.89	26,971	2,468	5	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
18-Mar 09:50	51	31	667	3	120	0/0	0/0/0/0/0/0
18-Mar 09:40	2	20	1,271	2	120	0/0	0/0/0/0/0/0
18-Mar 09:30	1	5	669	2	120	0/0	0/0/0/0/0/0
18-Mar 09:20	4	80	1,272	2	120	0/0	0/0/0/0/0/0
18-Mar 09:10	0	5	671	1	120	0/0	0/0/0/0/0/0
18-Mar 09:00	180	292	69	4	120	0/0	0/0/0/0/0/0
18-Mar 08:50	24	14	672	3	120	0/0	0/0/0/0/0/0
18-Mar 08:40	0	24	71	1	120	0/0	0/0/0/0/0/0
18-Mar 08:30	0	13	674	1	120	0/0	0/0/0/0/0/0
18-Mar 08:20	0	4	1,278	1	120	0/0	0/0/0/0/0/0
18-Mar 08:10	95	154	676	4	120	0/0	0/0/0/0/0/0
18-Mar 08:00	0	5	1,279	1	120	0/0	0/0/0/0/0/0
18-Mar 07:50	1	18	678	2	120	0/0	0/0/0/0/0/0
18-Mar 07:40	1	16	1,281	2	120	0/0	0/0/0/0/0/0
18-Mar 07:30	0	5	680	1	120	0/0	0/0/0/0/0/0
18-Mar 07:20	2	75	1,283	2	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	13	0.00		0	0
ASM db client latch	32,642	0.00		0	0
ASM map operation hash table	13	0.00		0	0
ASM network state latch	755	0.00		0	0
AWR Alerted Metric Element list	579,938	0.00		0	0
Bloom filter list latch	17	0.00		0	0
Change Notification Hash table latch	15,668	0.00		0	0
Consistent RBA	6,351	0.02	0.00	0	0
DML lock allocation	11,524	0.00		0	0
Event Group Locks	811	0.00		0	0
FIB s.o chain latch	18	0.00		0	0
FOB s.o list latch	107,302	1.14	0.01	0	0
File State Object Pool Parent Latch	13	0.00		0	0
IPC stats buffer allocation latch	13	0.00		0	0
In memory undo latch	886,554,165	0.00	0.00	0	19,081	0.02
JS Sh mem access	95	0.00		0	0
JS mem alloc latch	103	0.00		0	0
JS queue access latch	116	0.00		0	0
JS queue state obj latch	339,594	0.00		0	0
JS slv state obj latch	1,467	0.00		0	0
KFC FX Hash Latch	13	0.00		0	0
KFC Hash Latch	13	0.00		0	0
KFCL LE Freelist	13	0.00		0	0
KGNFS-NFS:SHM structure	13	0.00		0	0
KGNFS-NFS:SVR LIST	13	0.00		0	0
KJC message pool free list	13	0.00		0	0
KJCT flow control latch	13	0.00		0	0
KMG MMAN ready and startup request latch	15,587	0.00		0	0
KTF sga latch	242	0.00		0	15,186	0.00
KWQP Prop Status	26	0.00		0	0
KWQS pqueue ctx latch	26	0.00		0	0
Locator state objects pool parent latch	13	0.00		0	0
Lsod array latch	13	0.00		0	0
MQL Tracking Latch	0			0	934	0.00
Memory Management Latch	13	0.00		0	15,587	0.00
Memory Queue	13	0.00		0	0
Memory Queue Message Subscriber #1	13	0.00		0	0
Memory Queue Message Subscriber #2	13	0.00		0	0
Memory Queue Message Subscriber #3	13	0.00		0	0
Memory Queue Message Subscriber #4	13	0.00		0	0
Memory Queue Subscriber	13	0.00		0	0
Mutex	13	0.00		0	0
Mutex Stats	13	0.00		0	0
OS process	6,856	0.00		0	0
OS process allocation	20,232	0.02	0.00	0	0
OS process: request allocation	1,513	0.20	0.00	0	0
PL/SQL warning settings	7,159	0.42	0.00	0	0
PX hash array latch	13	0.00		0	0
QMT	13	0.00		0	0
Real-time plan statistics latch	871,540	0.25	0.46	13	0
SGA IO buffer pool latch	437	0.69	0.00	0	547	2.74
SGA blob parent	13	0.00		0	0
SGA bucket locks	13	0.00		0	0
SGA heap locks	13	0.00		0	0
SGA pool locks	13	0.00		0	0
SQL memory manager latch	1,571	0.00		0	15,448	0.00
SQL memory manager workarea list latch	1,292,686	0.02	0.01	0	0
Shared B-Tree	1,748	0.00		0	0
Statement queuing latch	20	0.00		0	0
Streams Generic	13	0.00		0	0
Testing	13	0.00		0	0
Token Manager	13	0.00		0	0
WCR: sync	13	0.00		0	0
Write State Object Pool Parent Latch	13	0.00		0	0
X$KSFQP	13	0.00		0	0
XDB NFS Security Latch	13	0.00		0	0
XDB unused session pool	13	0.00		0	0
XDB used session pool	13	0.00		0	0
active checkpoint queue latch	671,999	0.73	0.00	0	0
active service list	126,070	4.07	0.34	1	29,746	0.00
begin backup scn array	45	0.00		0	0
buffer pool	13	0.00		0	0
business card	13	0.00		0	0
cache buffer handles	97,330	0.01	0.00	0	0
cache buffers chains	986,341,359	0.07	0.01	12	16,715,166	0.00
cache buffers lru chain	2,427,274	0.03	0.11	0	19,060,687	0.39
cache table scan latch	15,336	1.01	0.01	0	15,524	1.31
call allocation	48,590	13.55	0.31	5	0
cas latch	13	0.00		0	0
change notification client cache latch	13	0.00		0	0
channel handle pool latch	1,537	0.39	0.00	0	0
channel operations parent latch	231,879	0.00	0.00	0	0
checkpoint queue latch	41,227,347	0.00	0.01	0	2,318,740	0.00
client/application info	35,017	0.02	0.00	0	0
compile environment latch	6,451	0.43	0.00	0	0
corrupted undo seg latch	1,410	0.00		0	0
cp cmon/server latch	13	0.00		0	0
cp pool latch	13	0.00		0	0
cp server hash latch	13	0.00		0	0
cp sga latch	755	0.00		0	0
cvmap freelist lock	13	0.00		0	0
database property service latch	6	0.00		0	0
deferred cleanup latch	755	0.00		0	0
dml lock allocation	755	0.00		0	0
done queue latch	13	0.00		0	0
dummy allocation	12,870	7.75	0.02	0	0
enqueue hash chains	1,152,669	0.05	0.02	0	2	0.00
enqueues	990,020	0.17	0.00	0	0
error message lists	11,042	15.94	0.02	0	0
fifth spare latch	13	0.00		0	0
file cache latch	35,903	0.00	0.00	0	0
flashback copy	13	0.00		0	0
gc element	13	0.00		0	0
gcs commit scn state	13	0.00		0	0
gcs partitioned table hash	13	0.00		0	0
gcs pcm hashed value bucket hash	13	0.00		0	0
gcs resource freelist	13	0.00		0	0
gcs resource hash	13	0.00		0	0
gcs resource scan list	13	0.00		0	0
gcs shadows freelist	13	0.00		0	0
ges domain table	13	0.00		0	0
ges enqueue table freelist	13	0.00		0	0
ges group table	13	0.00		0	0
ges process hash list	13	0.00		0	0
ges process parent latch	13	0.00		0	0
ges resource hash list	13	0.00		0	0
ges resource scan list	13	0.00		0	0
ges resource table freelist	13	0.00		0	0
ges value block free list	13	0.00		0	0
global KZLD latch for mem in SGA	15	0.00		0	0
global tx hash mapping	64	0.00		0	0
granule operation	13	0.00		0	0
hash table column usage latch	379	0.00		0	333,702	0.00
hash table modification latch	1,091	0.00		0	0
heartbeat check	13	0.00		0	0
internal temp table object number allocation latch	825	0.00		0	0
intra txn parallel recovery	13	0.00		0	0
io pool granule metadata list	13	0.00		0	0
job workq parent latch	121	0.00		0	108	0.00
job_queue_processes free list latch	276	0.00		0	0
job_queue_processes parameter latch	10,279	0.00		0	0
k2q lock allocation	13	0.00		0	0
kcbtsemkid latch	30	0.00		0	0
kdlx hb parent latch	13	0.00		0	0
kgb parent	13	0.00		0	0
kks stats	1,345	0.00		0	0
kmcptab latch	3	0.00		0	0
kmcpvec latch	0			0	1	0.00
kokc descriptor allocation latch	52	0.00		0	0
ksfv messages	13	0.00		0	0
kss move lock	345	0.00		0	0
ksuosstats global area	3,157	0.00		0	0
ksv allocation latch	1,419	0.00		0	0
ksv class latch	677	0.30	0.00	0	0
ksv msg queue latch	13	0.00		0	0
ksz_so allocation latch	1,513	0.00		0	0
ktm global data	374	0.00		0	0
kwqbsn:qsga	1,696	0.00		0	0
lgwr LWN SCN	18,308	0.00		0	0
list of block allocation	146,013	0.00		0	0
loader state object freelist	20,305,561	0.02	0.00	0	0
lob segment dispenser latch	13	0.00		0	0
lob segment hash table latch	169	0.00		0	0
lob segment query latch	13	0.00		0	0
lock DBA buffer during media recovery	13	0.00		0	0
logical standby cache	13	0.00		0	0
logminer context allocation	26	0.00		0	0
logminer work area	13	0.00		0	0
longop free list parent	66,249	0.00		0	520	0.00
mapped buffers lru chain	13	0.00		0	0
message pool operations parent latch	2,492	0.00		0	0
messages	1,729,534	0.41	0.00	0	0
mostly latch-free SCN	18,364	0.12	0.00	0	0
msg queue latch	13	0.00		0	0
multiblock read objects	32,320	1.86	0.00	0	0
name-service namespace bucket	13	0.00		0	0
ncodef allocation latch	755	0.00		0	0
object queue header heap	5,386,498	0.00		0	16,339	0.00
object queue header operation	1,662,173,599	0.00	0.03	0	0
object stats modification	383	0.00		0	0
parallel query alloc buffer	156,089	31.34	0.06	5	0
parallel query stats	10,080,211	0.01	0.03	0	0
parameter list	560	0.00		0	0
parameter table management	19,652	2.10	0.00	0	0
peshm	13	0.00		0	0
pesom_free_list	13	0.00		0	0
pesom_hash_node	13	0.00		0	0
post/wait queue	430	0.00		0	267	0.00
process allocation	2,391	0.04	0.00	0	798	0.00
process group creation	1,513	0.33	0.00	0	0
process queue	20,246,022	0.01	0.01	0	0
process queue reference	202,088,083	0.01	0.03	0	6,493,900	0.23
qmn task queue latch	11,323	0.25	0.00	0	0
query server freelists	30,310,683	0.00	0.00	0	0
query server process	402	0.00		0	319	0.94
queued dump request	156	0.00		0	0
queuing load statistics	52	0.00		0	0
recovery domain hash list	13	0.00		0	0
redo allocation	106,035	0.05	0.00	0	3,510,447	0.06
redo copy	13	0.00		0	3,510,670	0.01
redo writing	725,379	0.44	0.00	0	0
resmgr group change latch	5,969	0.32	0.00	0	0
resmgr:active threads	14,423	0.00		0	1,204	0.00
resmgr:actses change group	6,009	0.00		0	0
resmgr:actses change state	34	0.00		0	0
resmgr:free threads list	12,899	7.55	0.02	0	0
resmgr:method mem alloc latch	4	0.00		0	0
resmgr:resource group CPU method	2,813	0.00		0	0
resmgr:schema config	7,814	2.92	0.00	0	120	0.00
rm cas latch	13	0.00		0	0
row cache objects	1,106,737	0.17	0.04	0	0
rules engine aggregate statistics	1	0.00		0	0
rules engine rule set statistics	1,302	0.00		0	0
second spare latch	13	0.00		0	0
sequence cache	1,865	0.00		0	0
session allocation	35,575	0.30	0.00	0	11,909	0.00
session idle bit	93,830	0.03	0.00	0	0
session queue latch	13	0.00		0	0
session state list latch	13,478	7.81	0.00	0	0
session switching	4,343	0.69	0.00	0	0
session timer	15,792	0.00		0	0
shared pool	342,536	13.71	0.03	1	0
shared pool sim alloc	37	0.00		0	0
shared pool simulator	1,659	0.00		0	0
sim partition latch	13	0.00		0	0
simulator hash latch	108,854,858	0.00	0.01	0	0
simulator lru latch	828,371	0.00	0.00	0	107,223,039	0.00
sort extent pool	135,617	0.26	0.05	0	0
space background state object latch	42	0.00		0	0
space background task latch	35,845	0.08	0.04	0	31,174	0.00
state object free list	26	0.00		0	0
statistics aggregation	7,280	0.00		0	0
tablespace key chain	13	0.00		0	0
temp lob duration state obj allocation	26	0.00		0	0
temporary table state object allocation	16	0.00		0	0
test excl. parent l0	13	0.00		0	0
test excl. parent2 l0	13	0.00		0	0
third spare latch	13	0.00		0	0
threshold alerts latch	19,435	0.00		0	0
transaction allocation	829	0.00		0	0
transaction branch allocation	15,810	0.00		0	0
undo global data	9,163,051	0.69	0.00	0	0
virtual circuit buffers	13	0.00		0	0
virtual circuit holder	13	0.00		0	0
virtual circuit queues	13	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	986,341,359	718,305	10,232	708,342
undo global data	9,163,051	63,534	19	63,515
parallel query alloc buffer	156,089	48,916	3,152	46,319
shared pool	342,536	46,950	1,420	45,689
process queue reference	202,088,083	24,066	647	3,340
object queue header operation	1,662,173,599	16,149	472	15,702
messages	1,729,534	7,060	27	7,033
call allocation	48,590	6,586	2,017	5,121
active service list	126,070	5,134	1,766	3,765
active checkpoint queue latch	671,999	4,934	24	4,910
loader state object freelist	20,305,561	3,883	7	3,876
redo writing	725,379	3,170	12	3,159
Real-time plan statistics latch	871,540	2,156	999	1,347
row cache objects	1,106,737	1,875	80	1,801
error message lists	11,042	1,760	35	1,726
process queue	20,246,022	1,702	16	1,686
enqueues	990,020	1,655	3	1,652
parallel query stats	10,080,211	1,239	37	1,209
FOB s.o list latch	107,302	1,220	14	1,206
session state list latch	13,478	1,053	1	1,052
query server freelists	30,310,683	1,046	3	1,043
dummy allocation	12,870	997	22	976
resmgr:free threads list	12,899	974	15	959
cache buffers lru chain	2,427,274	713	77	651
multiblock read objects	32,320	600	1	599
enqueue hash chains	1,152,669	530	12	519
sort extent pool	135,617	349	18	332
checkpoint queue latch	41,227,347	295	2	293
SQL memory manager workarea list latch	1,292,686	195	2	193
cache table scan latch	15,336	155	1	154
simulator hash latch	108,854,858	87	1	86
space background task latch	35,845	27	1	26

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	14	14
Real-time plan statistics latch	keswxAddNewPlanEntry	999	999
SQL memory manager workarea list latch	qesmmIRegisterWorkArea:1	1	1
SQL memory manager workarea list latch	qesmmIRegisterWorkArea:2	1	1
active checkpoint queue latch	kcbbacq: scan active checkpoints	24	24
active service list	kswslogon: session logout	1,813	1,792
active service list	kswssetsvc: PX session switch service	218	93
active service list	kswsgsnp: get service name ptr	35	76
active service list	kswslogon: session login	29	113
active service list	kswsigsn: get service name	15	38
active service list	kswsite: service iterator	3	0
cache buffers chains	kcbgtcr: fast path (cr pin)	10,096	2,198
cache buffers chains	kcbrls_1	3,926	11,808
cache buffers chains	kcbgtcr: kslbegin shared	38	6
cache buffers chains	kcbzwb	28	27
cache buffers chains	kcbgtcr: fast path	27	34
cache buffers chains	kcbgtcr_2	21	19
cache buffers chains	kcbzibmlt: multi-block read: nowait	9	0
cache buffers chains	kcbbxsv	5	3
cache buffers chains	kcbzgb: scan from tail. nowait	3	0
cache buffers chains	kcbgcur_2	1	0
cache buffers chains	kcbrls_2	1	7
cache buffers lru chain	kcbzgws	70	0
cache buffers lru chain	kcbzar: KSLNBEGIN	4	0
cache buffers lru chain	kcbbic2	1	41
cache buffers lru chain	kcbbwlru	1	12
cache buffers lru chain	kcbzfw	1	0
cache table scan latch	kcbz_free_table_scan_read_buffer	1	1
call allocation	ksuxds	1,872	1,914
call allocation	ksursi0	94	63
call allocation	ksudlp: top call	35	31
call allocation	ksudlc : rec call	15	2
call allocation	kxfpRecvSessStats	1	1
channel operations parent latch	ksrchdelete_sub()	1	1
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	1	1
checkpoint queue latch	kcbkubc_4	1	0
dummy allocation	ktcscnfy	21	22
dummy allocation	ktcdod	1	0
enqueue hash chains	ksqrcl	7	7
enqueue hash chains	ksqgtl3	4	4
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	1
enqueues	ksqgel: create enqueue	2	2
enqueues	ksqdel	1	1
error message lists	kxfpqsnd	28	30
error message lists	kxfpqidqr: KSLBEGIN	6	5
loader state object freelist	kcblfs	4	2
loader state object freelist	kcblgs	3	5
messages	ksarcv	22	4
messages	ksaamb: after wakeup	5	23
multiblock read objects	kcbzibmlt	1	1
object queue header operation	kcbo_ivbo	389	388
object queue header operation	kcbo_unlink_q	239	10
object queue header operation	kcbo_link_q	35	2
object queue header operation	kcbo_switch_cq	20	14
object queue header operation	kcbo_switch_mq_bg	17	74
object queue header operation	kcbo_switch_q_bg	8	164
object queue header operation	kcbo_write_q	7	7
object queue header operation	kcbo_check_flist	3	17
object queue header operation	kcbo_lbufcnt	3	44
parallel query alloc buffer	kxfpbalo	2,072	2,092
parallel query alloc buffer	kxfpbfre	1,078	1,058
parallel query stats	kxfprst: KSLBEGIN:1	37	37
parameter table management	kspptval	4	4
process queue	kxfpqsnd: KSLBEGIN	15	14
process queue	kxfpqidqr: KSLBEGIN	1	2
process queue reference	kxfpqrsnd	7	0
query server freelists	kxfpobadf	2	2
query server freelists	kxfpobrmf	1	1
redo writing	kcrfwcr	12	12
resmgr:free threads list	kskthrcreate	15	15
row cache objects	kqreqd: reget	42	6
row cache objects	kqrpre: find obj	29	39
row cache objects	kqreqd	9	35
session idle bit	ksupuc: set busy	1	0
session state list latch	kpseqa	1	0
shared pool	kghalo	1,144	1,140
shared pool	kghfre	276	280
simulator hash latch	kcbs_lookup_setid: lookup dba	1	1
sort extent pool	ktstdt: dealloc sort extent	8	1
sort extent pool	ktstdt: return extent	5	12
sort extent pool	ktstallobj1	3	1
sort extent pool	ktst dump	1	2
sort extent pool	ktstaddextent1	1	0
space background task latch	ktsj_grab_task	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)
Library Cache	kglget2 2	50,655	-0
Library Cache	kglpin1 4	38,029	-0
Library Cache	kglpnal1 90	33,596	-0
Library Cache	kglpndl1 95	27,577	-0
Cursor Pin	kkslce [KKSCHLPIN2]	24,961	254
Library Cache	kgllkdl1 85	24,915	-0
Library Cache	kgllkc1 57	5,623	0
Library Cache	kglhdgn2 106	5,506	-0
Library Cache	kglhdgn1 62	1,150	-2
Library Cache	kgldtin1 42	19	-0
Cursor Pin	kksLockDelete [KKSCHLPIN6]	4	0
hash table	kkscsSearchChildList [KKSHBKLOC2]	2	0
hash table	kkshGetNextChild [KKSHBKLOC1]	2	0
Library Cache	kglini1 32	1	-4
Library Cache	kglobld1 75	1	-0
Cursor Parent	kksLoadChild [KKSPRTLOC4]	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: 839,385,862
Captured Segments account for 96.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	241,955,504	28.83
POS	POS_DATA	IX_YS_SALE_RTNO_N_1		INDEX	123,078,064	14.66
POS	POS_DATA	YS_BRANCH19		TABLE	110,812,448	13.20
POS	POS_SALEDETAIL_IX	PK_YS_SALEDETAIL_NEW_1		INDEX	107,871,776	12.85
POS	POS_DATA	IDX_YS_SALE_SUM_NEW		INDEX	62,166,320	7.41

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 200,764,749
Captured Segments account for 90.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	50,369,291	25.09
POS	POS_SALEDETAIL_201209	YS_SALEDETAIL	SYS_SUBP54	TABLE SUBPARTITION	11,672,400	5.81
POS	POS_SALEDETAIL_IX	PK_YS_SALEDETAIL_NEW_1		INDEX	9,135,130	4.55
POS	POS_SALEDETAIL_201207	YS_SALEDETAIL	SYS_SUBP52	TABLE SUBPARTITION	8,476,162	4.22
POS	POS_SALEDETAIL_201210	YS_SALEDETAIL	SYS_SUBP55	TABLE SUBPARTITION	7,566,819	3.77

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 27,313,051
Captured Segments account for 98.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	10,073,859	36.88
POS	POS_SALEDETAIL_IX	PK_YS_SALEDETAIL_NEW_1		INDEX	9,135,130	33.45
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	4,592,232	16.81
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	417,340	1.53
POS	POS_DATA	IX_YS_SALE_RTNO_N_1		INDEX	297,867	1.09

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 27,313,051
Captured Segments account for 98.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	10,073,859	36.88
POS	POS_SALEDETAIL_IX	PK_YS_SALEDETAIL_NEW_1		INDEX	9,135,130	33.45
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	4,592,232	16.81
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	417,340	1.53
POS	POS_DATA	IX_YS_SALE_RTNO_N_1		INDEX	297,867	1.09

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: 184,618,245
Captured Segments account for 89.9% of Total

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

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 2,933,534
Captured Segments account for 67.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
POS	POS_SALEDETAIL_IX	PK_YS_SALEDETAIL_NEW_1		INDEX	561,089	19.13
POS	POS_SALEDETAIL_IX	IDX_YS_SALEDETAIL_SALEID_F		INDEX	397,721	13.56
POS	POS_SALEDETAIL_IX	IDX_YS_SALEDETAIL_SALEID_N		INDEX	387,014	13.19
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	283,426	9.66
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	140,380	4.79

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 1,993,118
Captured Segments account for 85.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
POS	POS_SALEDETAIL_IX	PK_YS_SALEDETAIL_NEW_1		INDEX	533,581	26.77
POS	POS_SALEDETAIL_IX	IDX_YS_SALEDETAIL_SALEID_F		INDEX	372,052	18.67
POS	POS_SALEDETAIL_IX	IDX_YS_SALEDETAIL_SALEID_N		INDEX	361,631	18.14
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	264,850	13.29
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	93,059	4.67

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 578,241
Captured Segments account for 2.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	5,868	1.01
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	4,693	0.81
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	2,449	0.42
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	1,368	0.24
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_3752968640_2218	TABLE PARTITION	187	0.03

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 10,158,409
Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
POS	POS_DATA	YS_BRANCH19		TABLE	10,073,859	99.17
POS	YS_SALE_SUM1204	YS_SALE_SUM	YS_SALE_SUM1204	TABLE PARTITION	6,744	0.07
POS	YS_SALE_SUM1203	YS_SALE_SUM	YS_SALE_SUM1203	TABLE PARTITION	5,613	0.06
POS	YS_SALE_SUM1202	YS_SALE_SUM	YS_SALE_SUM1202	TABLE PARTITION	5,599	0.06
POS	YS_SALE_SUM1201	YS_SALE_SUM	YS_SALE_SUM1201	TABLE PARTITION	5,382	0.05

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	Subobject Name	Obj. Type	DB Block Changes	% of Capture
POS	POS_SALEDETAIL_IX	PK_YS_SALEDETAIL_NEW_1		INDEX	694,624	22.96
POS	POS_SALEDETAIL_IX	IDX_YS_SALEDETAIL_SALEID_F		INDEX	412,784	13.65
POS	POS_SALEDETAIL_IX	IDX_YS_SALEDETAIL_SALEID_N		INDEX	412,240	13.63
POS	POS_SALEDETAIL_201303	BIX_YS_SALEDETAIL_GI_N	SYS_SUBP60	INDEX SUBPARTITION	355,024	11.74
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	306,912	10.15

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
POS	POS_SALE_201303	BIX_YS_SALE_BRANCHID_N_1	SYS_SUBP100	INDEX SUBPARTITION	18	66.67
POS	POS_SALE_IX	PK_YS_SALE_N		INDEX	7	25.93
POS	POS_SALE_201303	BIX_YS_SALE_WORKDATE_N_1	SYS_SUBP100	INDEX SUBPARTITION	2	7.41

Back to Segment Statistics
Back to Top

Segments by ITL Waits

% of Capture shows % of ITL waits for each top segment compared
with total ITL waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
POS	POS_SALE_201303	BIX_YS_SALE_BRANCHID_N_1	SYS_SUBP100	INDEX SUBPARTITION	6	100.00

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	845	0.00	26	1
dc_constraints	204	33.33	204	3
dc_global_oids	113	0.00	0	358
dc_histogram_data	7,854	0.00	755	7,458
dc_histogram_defs	15,457	1.51	840	9,392
dc_object_grants	279	16.49	0	544
dc_objects	17,427	1.10	163	5,655
dc_profiles	152	0.00	0	1
dc_rollback_segments	83,548	0.00	0	165
dc_segments	2,977	0.00	249	2,339
dc_sequences	43	0.00	43	17
dc_table_scns	13	100.00	0	0
dc_tablespaces	105,503	0.00	0	120
dc_users	98,234	0.02	0	292
global database name	31,461	0.00	0	2
outstanding_alerts	9,152	0.00	1	118
sch_lj_oids	69	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	2,911	0.17	13,217	0.04	0	0
CLUSTER	132	0.00	12	0.00	0	0
DBLINK	961	0.00	0		0	0
EDITION	268	0.00	391	0.00	0	0
INDEX	374	2.67	329	3.04	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
OBJECT ID	19	100.00	0		0	0
QUEUE	2	0.00	2	0.00	0	0
RULESET	1	0.00	1	0.00	0	0
SCHEMA	338	0.59	0		0	0
SQL AREA	14,284	4.87	89,004	1.67	252	309
TABLE/PROCEDURE	5,957	1.24	40,622	0.43	27	0
TRIGGER	680	1.47	680	1.47	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	127.52		3.11	2.95	12	12	41	41
	Freeable	41.00	0.00	1.71	1.21	4		24	24
	SQL	1.28	1.12	0.07	0.15	1	28	19	15
	PL/SQL	0.74	0.63	0.02	0.04	0	0	39	39
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	647.08	657.22	1.57
shared	db_block_hash_buckets	178.00	178.00	0.00
shared	free memory	15,226.24	15,207.30	-0.12
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.99	0.12	0.00
QMON Coordinator	0313 20:32:05	0.53	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

Rule Sets ordered by Evaluations
* indicates Rule Set activity (re)started between Begin/End snaps
SQL per Eval - average # of SQL statements executed for non-SQL free evals
CPU(s),Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals

Rule	Evals	No-SQL Eval%	SQL Execs	CPU(s)	Ela(s)	Eval /Sec	SQL per Eval	Ela(s) per Eval	CPU(s) per Eval	Reloads
SYS.ALERT_QUE_R	1	0.00	0	0.00	0.00	0.00	0.00	0.00	0.00	0

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 %
46,770	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	46,770	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
resource_manager_plan	SCHEDULER[0x3009]:DEFAULT_MAINTENANCE_PLAN
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.57	In-memory Sort %:	100.00
Library Hit %:	98.82	Soft Parse %:	98.63
Execute to Parse %:	41.16	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	32.87	% Non-Parse CPU:	99.45