WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

XNJT 1872282062 xnjt 1 20-Jun-13 00:06 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
XNJT	1872282062	xnjt	1	20-Jun-13 00:06	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

localhost.localdomain Linux x86 64-bit 8 8 2 11.72

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
localhost.localdomain	Linux x86 64-bit	8	8	2	11.72

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 4413 27-Jun-13 16:21:41 449 .7

End Snap: 4421 27-Jun-13 18:00:43 438 .8

Elapsed: 99.04 (mins)

DB Time: 9,187.88 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	4413	27-Jun-13 16:21:41	449	.7
End Snap:	4421	27-Jun-13 18:00:43	438	.8
Elapsed:		99.04 (mins)
DB Time:		9,187.88 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,904M 2,048M Std Block Size: 8K

Shared Pool Size: 1,616M 1,472M Log Buffer: 14,116K

	Begin	End
Buffer Cache:	1,904M	2,048M	Std Block Size:	8K
Shared Pool Size:	1,616M	1,472M	Log Buffer:	14,116K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 92.8 9.2 0.64 0.45

DB CPU(s): 1.2 0.1 0.01 0.01

Redo size: 74,978.3 7,439.2

Logical reads: 17,875.1 1,773.5

Block changes: 472.6 46.9

Physical reads: 4,969.1 493.0

Physical writes: 30.5 3.0

User calls: 206.2 20.5

Parses: 44.3 4.4

Hard parses: 5.5 0.5

W/A MB processed: 0.8 0.1

Logons: 5.2 0.5

Executes: 145.5 14.4

Rollbacks: 0.0 0.0

Transactions: 10.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	92.8	9.2	0.64	0.45
DB CPU(s):	1.2	0.1	0.01	0.01
Redo size:	74,978.3	7,439.2
Logical reads:	17,875.1	1,773.5
Block changes:	472.6	46.9
Physical reads:	4,969.1	493.0
Physical writes:	30.5	3.0
User calls:	206.2	20.5
Parses:	44.3	4.4
Hard parses:	5.5	0.5
W/A MB processed:	0.8	0.1
Logons:	5.2	0.5
Executes:	145.5	14.4
Rollbacks:	0.0	0.0
Transactions:	10.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.46 Redo NoWait %: 99.68

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

Library Hit %: 96.07 Soft Parse %: 87.70

Execute to Parse %: 69.54 Latch Hit %: 98.87

Parse CPU to Parse Elapsd %: 0.21 % Non-Parse CPU: 98.53

Shared Pool Statistics

Begin End

Memory Usage %: 73.85 53.11

% SQL with executions>1: 98.27 73.92

% Memory for SQL w/exec>1: 92.88 66.35

	Begin	End
Memory Usage %:	73.85	53.11
% SQL with executions>1:	98.27	73.92
% Memory for SQL w/exec>1:	92.88	66.35

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
latch: shared pool	33,096	160,322	4844	29.08	Concurrency
latch free	5,392	103,734	19239	18.82	Other
enq: TX - index contention	53,004	46,832	884	8.50	Concurrency
library cache: mutex X	21,244	42,328	1992	7.68	Concurrency
enq: SQ - contention	13,709	26,305	1919	4.77	Configuration

Host CPU (CPUs: 8 Cores: 8 Sockets: 2)

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

1.30 11.44 19.2 5.4 19.4 75.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.30	11.44	19.2	5.4	19.4	75.1

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

15.2 60.8 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 12,000.9 12,000.9

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

PGA use (MB): 763.0 805.7

% Host Mem used for SGA+PGA: 36.36 36.71

	Begin	End
Host Mem (MB):	12,000.9	12,000.9
SGA use (MB):	3,600.0	3,600.0
PGA use (MB):	763.0	805.7
% Host Mem used for SGA+PGA:	36.36	36.71

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): 551272.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	168,051.78	30.48
parse time elapsed	51,932.77	9.42
connection management call elapsed time	46,993.66	8.52
sequence load elapsed time	27,490.67	4.99
hard parse elapsed time	13,635.66	2.47
failed parse elapsed time	8,250.63	1.50
DB CPU	7,276.23	1.32
hard parse (sharing criteria) elapsed time	798.79	0.14
PL/SQL compilation elapsed time	533.50	0.10
PL/SQL execution elapsed time	450.25	0.08
hard parse (bind mismatch) elapsed time	305.43	0.06
repeated bind elapsed time	0.10	0.00
DB time	551,272.86
background elapsed time	8,607.81
background cpu time	82.70

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	1,210,159
IDLE_TIME	3,644,739
IOWAIT_TIME	942,248
NICE_TIME	122
SYS_TIME	259,750
USER_TIME	932,637
LOAD	1	11
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	1,660,792,832
VM_OUT_BYTES	1,441,205,248
PHYSICAL_MEMORY_BYTES	12,583,804,928
NUM_CPUS	8
NUM_CPU_CORES	8
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,586
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
27-Jun 16:21:41	1.30
27-Jun 16:24:32	0.93	10.53	7.67	2.72	89.47	0.22
27-Jun 16:24:44	0.94	21.06	18.33	2.60	78.94	0.31
27-Jun 16:24:54	0.95	21.24	18.81	2.32	78.76	0.49
27-Jun 16:26:08	1.85	22.02	18.86	2.97	77.98	0.40
27-Jun 16:27:07	1.55	17.75	14.71	2.89	82.25	0.38
27-Jun 16:42:13	2.32	25.54	22.35	3.00	74.46	0.87
27-Jun 16:52:29	6.71	21.00	17.59	3.18	79.00	5.63
27-Jun 18:00:43	11.44	26.15	19.32	6.39	73.85	27.00

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 87.7% of Total DB time 551,272.86 (s)
Total FG Wait Time: 475,934.86 (s) DB CPU time: 7,276.23 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Concurrency	196,691	0	295,836	1504	53.66
Other	34,859	80	104,204	2989	18.90
Configuration	16,539	15	29,233	1768	5.30
Commit	58,620	0	25,754	439	4.67
User I/O	1,554,340	0	19,110	12	3.47
DB CPU			7,276		1.32
Application	38,929	0	1,791	46	0.32
Network	963,753	0	6	0	0.00
System I/O	2,433	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
latch: shared pool	33,096	0	160,322	4844	0.55	29.08
latch free	5,392	0	103,734	19239	0.09	18.82
enq: TX - index contention	53,004	0	46,832	884	0.89	8.50
library cache: mutex X	21,244	0	42,328	1992	0.35	7.68
enq: SQ - contention	13,709	0	26,305	1919	0.23	4.77
log file sync	58,620	0	25,754	439	0.98	4.67
buffer busy waits	75,739	0	24,841	328	1.26	4.51
direct path read	915,073	0	10,205	11	15.28	1.85
latch: row cache objects	3,395	0	8,933	2631	0.06	1.62
cursor: pin S wait on X	980	0	7,618	7774	0.02	1.38
db file sequential read	336,018	0	6,215	18	5.61	1.13
library cache lock	1,457	0	3,142	2157	0.02	0.57
enq: TX - allocate ITL entry	2,754	87	2,593	942	0.05	0.47
read by other session	283,627	0	2,592	9	4.74	0.47
enq: TX - row lock contention	195	0	1,038	5325	0.00	0.19
latch: cache buffers chains	5,701	0	582	102	0.10	0.11
cursor: pin S	193	0	557	2885	0.00	0.10
library cache load lock	132	0	550	4165	0.00	0.10
enq: KO - fast object checkpoint	70	0	522	7463	0.00	0.09
log file switch (private strand flush incomplete)	44	0	327	7422	0.00	0.06
SQL*Net break/reset to client	38,664	0	231	6	0.65	0.04
buffer exterminate	19,898	99	218	11	0.33	0.04
latch: session allocation	35	0	107	3057	0.00	0.02
latch: In memory undo latch	1,615	0	86	53	0.03	0.02
latch: enqueue hash chains	948	0	52	55	0.02	0.01
cursor: mutex X	118	0	42	359	0.00	0.01
kksfbc child completion	803	100	41	51	0.01	0.01
Disk file operations I/O	13,254	0	28	2	0.22	0.01
db file scattered read	3,759	0	28	7	0.06	0.01
direct path write temp	1,263	0	22	18	0.02	0.00
db file parallel read	66	0	14	210	0.00	0.00
wait list latch free	75	0	13	172	0.00	0.00
reliable message	69	12	12	169	0.00	0.00
buffer deadlock	5,383	100	8	1	0.09	0.00
log file switch completion	22	0	7	319	0.00	0.00
latch: redo allocation	106	0	7	65	0.00	0.00
latch: cache buffer handles	48	0	6	122	0.00	0.00
SQL*Net message to client	926,236	0	4	0	15.47	0.00
direct path sync	2	0	3	1296	0.00	0.00
latch: object queue header operation	41	0	3	61	0.00	0.00
direct path read temp	1,264	0	2	2	0.02	0.00
cursor: mutex S	12	0	2	193	0.00	0.00
SQL*Net more data to client	34,362	0	2	0	0.57	0.00
latch: call allocation	17	0	2	107	0.00	0.00
row cache lock	5	0	1	120	0.00	0.00
latch: messages	29	0	1	20	0.00	0.00
latch: redo copy	4	0	1	146	0.00	0.00
latch: cache buffers lru chain	5	0	1	108	0.00	0.00
control file sequential read	2,433	0	0	0	0.04	0.00
latch: active service list	12	0	0	21	0.00	0.00
SQL*Net message from dblink	1,202	0	0	0	0.02	0.00
SQL*Net more data from client	424	0	0	0	0.01	0.00
latch: redo writing	6	0	0	16	0.00	0.00
direct path write	14	0	0	6	0.00	0.00
latch: undo global data	16	0	0	4	0.00	0.00
asynch descriptor resize	1,982	100	0	0	0.03	0.00
SQL*Net more data from dblink	328	0	0	0	0.01	0.00
SQL*Net message to dblink	1,201	0	0	0	0.02	0.00
SQL*Net message from client	926,117	0	2,719,016	2936	15.46
jobq slave wait	10,021	100	5,016	501	0.17
single-task message	1	0	1	807	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
latch: shared pool	12,375	0	106,512	8607	0.21	1237.39
latch: call allocation	967	0	26,444	27346	0.02	307.21
latch free	2,932	0	3,891	1327	0.05	45.20
log file parallel write	69,031	0	1,474	21	1.15	17.12
db file async I/O submit	3,156	0	1,284	407	0.05	14.92
os thread startup	195	1	534	2738	0.00	6.20
control file parallel write	2,982	0	315	106	0.05	3.66
process diagnostic dump	1,547	0	192	124	0.03	2.23
latch: row cache objects	127	0	171	1346	0.00	1.99
enq: TH - metric threshold evaluation	2	0	138	68914	0.00	1.60
control file sequential read	7,457	0	130	17	0.12	1.51
db file sequential read	1,692	0	79	47	0.03	0.92
latch: session allocation	15	0	73	4894	0.00	0.85
enq: PR - contention	1	0	64	64396	0.00	0.75
log file sequential read	539	0	59	109	0.01	0.68
wait list latch free	87	0	38	439	0.00	0.44
library cache: mutex X	25	0	31	1247	0.00	0.36
enq: CF - contention	1	0	11	11487	0.00	0.13
Disk file operations I/O	275	0	9	32	0.00	0.10
SQL*Net break/reset to client	242	0	9	36	0.00	0.10
SQL*Net message to client	119,971	0	5	0	2.00	0.06
Log archive I/O	489	0	4	8	0.01	0.04
LGWR wait for redo copy	647	0	3	5	0.01	0.04
log file single write	16	0	2	126	0.00	0.02
latch: cache buffers chains	21	0	1	64	0.00	0.02
reliable message	9	11	1	120	0.00	0.01
latch: messages	35	0	1	22	0.00	0.01
Parameter File I/O	64	0	1	11	0.00	0.01
latch: redo allocation	54	0	1	12	0.00	0.01
db file single write	84	0	1	7	0.00	0.01
db file scattered read	61	0	1	9	0.00	0.01
ADR block file read	44	0	0	11	0.00	0.01
latch: object queue header operation	12	0	0	38	0.00	0.01
latch: checkpoint queue latch	9	0	0	48	0.00	0.01
library cache lock	2	0	0	210	0.00	0.00
cursor: pin S wait on X	3	0	0	136	0.00	0.00
asynch descriptor resize	30,702	100	0	0	0.51	0.00
cursor: pin S	2	0	0	173	0.00	0.00
library cache load lock	1	0	0	337	0.00	0.00
latch: enqueue hash chains	3	0	0	89	0.00	0.00
latch: cache buffers lru chain	3	0	0	87	0.00	0.00
latch: active service list	14	0	0	13	0.00	0.00
direct path write	8	0	0	11	0.00	0.00
direct path sync	1	0	0	79	0.00	0.00
ADR file lock	22	18	0	1	0.00	0.00
ADR block file write	20	0	0	0	0.00	0.00
rdbms ipc message	92,843	29	90,681	977	1.55
Space Manager: slave idle wait	2,828	95	13,720	4851	0.05
DIAG idle wait	11,979	100	12,008	1002	0.20
shared server idle wait	202	100	6,061	30003	0.00
dispatcher timer	101	100	6,060	60004	0.00
Streams AQ: qmn coordinator idle wait	432	50	6,050	14004	0.01
Streams AQ: qmn slave idle wait	216	0	6,039	27960	0.00
pmon timer	2,042	95	5,956	2917	0.03
smon timer	56	27	5,642	100747	0.00
SQL*Net message from client	150,464	0	4,589	30	2.51
SGA: MMAN sleep for component shrink	1,003	100	11	11	0.02
class slave wait	35	0	0	5	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	44	38.6	2.3	9.1	13.6	11.4	20.5	4.5
ADR block file write	20	95.0	5.0
ADR file lock	22	90.9				4.5	4.5
ARCH wait for archivelog lock	18	100.0
Disk file operations I/O	13.8K	98.0	.9	.2	.2	.1	.1	.7	.0
LGWR wait for redo copy	662	94.0	.8	.9	1.1	.8	.8	1.8
Log archive I/O	489	2.5	22.7	68.1	2.5	.8	2.2	1.2
Parameter File I/O	64	84.4	1.6		1.6	1.6		10.9
SQL*Net break/reset to client	39.3K	79.7	1.6	11.8	2.6	1.1	.5	2.8	.1
SQL*Net message from dblink	1202	99.0	.6	.2	.2
SQL*Net message to client	1049.6K	100.0	.0	.0	.0	.0	.0	.0
SQL*Net message to dblink	1201	100.0
SQL*Net more data from client	424	99.5			.2			.2
SQL*Net more data from dblink	328	100.0
SQL*Net more data to client	34.5K	100.0	.0	.0	.0	.0		.0
asynch descriptor resize	32.8K	100.0	.0	.0			.0
buffer busy waits	76.5K	13.2	3.7	4.9	5.3	4.9	5.2	58.0	4.8
buffer deadlock	5384	80.7	8.8	3.6	2.1	2.4	1.8	.5
buffer exterminate	19.9K	.3	.0	.1	.0	99.5	.0
control file parallel write	2990	64.5	1.7	1.1	1.1	2.0	2.2	25.2	2.1
control file sequential read	9907	93.8	.0	.1	.4	.5	.6	4.4	.2
cursor: mutex S	12	25.0						75.0
cursor: mutex X	118	80.5		1.7	.8	.8		15.3	.8
cursor: pin S	195	17.4	4.1	2.1	1.0	6.2	3.1	32.3	33.8
cursor: pin S wait on X	983	1.7	.9	1.2	1.0	4.7	2.8	33.6	54.0
db file async I/O submit	3165	19.0	8.7	18.5	4.6	5.5	5.0	31.5	7.2
db file parallel read	66	7.6		1.5	1.5	12.1	22.7	47.0	7.6
db file scattered read	3839	69.1	1.7	3.7	10.6	7.7	3.2	4.0	.0
db file sequential read	339.6K	70.9	1.2	3.2	8.3	6.4	3.3	6.6	.2
db file single write	84	91.7				1.2	1.2	6.0
direct path read	915.1K	37.2	36.2	10.1	5.9	4.1	1.9	4.6	.0
direct path read temp	1264	96.9	.2		.1	.6	.6	1.7
direct path sync	3		33.3					33.3	33.3
direct path write	22	81.8			4.5	4.5		9.1
direct path write temp	1263	72.7	9.8	.5	.9	1.3	1.3	13.5
enq: CF - contention	1								100.0
enq: KO - fast object checkpoint	70	5.7	7.1	1.4	14.3	8.6	2.9	14.3	45.7
enq: PR - contention	1								100.0
enq: SQ - contention	13.7K	1.5	.5	1.0	1.7	2.4	4.0	61.2	27.5
enq: TH - metric threshold evaluation	2								100.0
enq: TX - allocate ITL entry	2754	.1	.0	.1	.1	.1	.0	98.7	.9
enq: TX - index contention	53.1K	1.7	1.4	2.2	3.0	4.1	4.1	60.8	22.8
enq: TX - row lock contention	195	4.1	6.7	3.6	2.6	1.5	2.6	23.6	55.4
kksfbc child completion	803							100.0
latch free	8332	.9	.5	.9	5.3	5.8	6.2	43.3	37.2
latch: In memory undo latch	1637	73.8	4.6	2.0	2.0	2.0	2.4	11.4	1.8
latch: active service list	26	34.6	3.8	26.9	3.8	3.8		26.9
latch: cache buffer handles	48						6.3	93.8
latch: cache buffers chains	5732	58.1	4.0	2.8	2.2	2.0	1.8	27.8	1.3
latch: cache buffers lru chain	8	37.5		12.5	12.5			37.5
latch: call allocation	985	32.4	3.1	2.5	4.9	2.6	2.9	11.6	39.9
latch: checkpoint queue latch	9						22.2	77.8
latch: enqueue hash chains	951	41.1	5.4	5.7	7.5	4.9	12.4	23.0
latch: messages	64	1.6	6.3	12.5	15.6	21.9	25.0	17.2
latch: object queue header operation	53	18.9	3.8	9.4	3.8	13.2	9.4	41.5
latch: redo allocation	161	20.5	5.6	3.7	8.1	11.2	14.9	36.0
latch: redo copy	4							100.0
latch: redo writing	6	50.0					33.3	16.7
latch: row cache objects	3522	2.7	.9	1.7	3.5	4.7	6.5	52.1	27.9
latch: session allocation	50	12.0			4.0			12.0	72.0
latch: shared pool	45.5K	2.2	.5	.9	1.1	2.3	3.3	41.1	48.6
latch: undo global data	16	25.0	31.3	18.8	6.3	12.5	6.3
library cache load lock	133	2.3	3.8	1.5	3.8	6.8	18.0	31.6	32.3
library cache lock	1459	53.3	3.4	3.6	2.6	3.8	2.8	13.2	17.3
library cache: mutex X	21.3K	18.8	3.2	2.4	1.6	19.6	9.1	29.3	16.0
log file parallel write	70.1K	81.9	1.9	.9	1.7	2.8	1.7	8.9	.2
log file sequential read	539	44.9	3.7	17.4	4.1	8.0	3.7	14.7	3.5
log file single write	16	43.8		18.8	12.5	6.3		12.5	6.3
log file switch (private strand flush incomplete)	44							40.9	59.1
log file switch completion	22					9.1	4.5	72.7	13.6
log file sync	59.6K	44.7	2.7	1.2	2.4	3.7	3.1	29.9	12.3
os thread startup	195					12.3	63.6	14.4	9.7
process diagnostic dump	1547	8.7	63.7	25.9	.6	.1	.1	.6	.5
read by other session	283.7K	66.0	1.7	4.7	12.6	9.6	3.1	2.3	.1
reliable message	78	47.4	5.1	1.3	6.4	2.6	6.4	30.8
row cache lock	5	20.0	20.0	20.0				40.0
wait list latch free	162	4.9	5.6	6.2	9.3	8.0	1.2	63.6	1.2
DIAG idle wait	12K							99.7	.3
SGA: MMAN sleep for component shrink	1003			.1	.1	99.8
SQL*Net message from client	1080.2K	82.0	1.9	2.7	1.5	.6	.3	4.6	6.5
Space Manager: slave idle wait	2832		.1		.1	.4	.1	.7	98.6
Streams AQ: qmn coordinator idle wait	434	48.4	.7	.5	.2	.2			50.0
Streams AQ: qmn slave idle wait	217								100.0
class slave wait	35	82.9		2.9	2.9		8.6	2.9
dispatcher timer	101								100.0
jobq slave wait	10.1K	.0						100.0
pmon timer	2047	.4				.0	.0	1.7	97.8
rdbms ipc message	94K	19.3	11.9	5.8	5.2	6.8	6.9	28.3	15.8
shared server idle wait	202								100.0
single-task message	1							100.0
smon timer	58	1.7	1.7	1.7		5.2		20.7	69.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ADR block file read	2	95.5	2.3	2.3
Disk file operations I/O	94	99.3	.1	.1	.1	.3	.0	.0	.0
LGWR wait for redo copy	12	98.2	.3	.6	.3	.3	.3
Log archive I/O	6	98.8	.2			.8	.2
Parameter File I/O	7	89.1	1.6	7.8	1.6
SQL*Net break/reset to client	1101	97.2	.3	2.1	.1	.1	.1	.0	.0
SQL*Net message to client	34	100.0	.0	.0	.0	.0	.0
SQL*Net more data from client	1	99.8			.2
SQL*Net more data to client	5	100.0		.0	.0		.0
buffer busy waits	47.8K	37.1	5.6	5.8	10.9	16.0	19.7	4.5	.3
buffer deadlock	29	99.5	.5	.0	.0
control file parallel write	804	72.7	3.2	4.8	7.9	5.8	3.6	1.7	.4
control file sequential read	452	95.4	.7	1.2	1.1	1.1	.3	.2	.0
cursor: mutex S	9	25.0		8.3	50.0	8.3	8.3
cursor: mutex X	18	83.9	1.7	4.2	2.5	2.5	4.2		.8
cursor: pin S	65	33.8	4.1	3.6	5.1	14.9	4.6	1.0	32.8
cursor: pin S wait on X	485	12.4	2.5	5.1	3.6	8.9	13.5	15.8	38.3
db file async I/O submit	1093	61.3	5.8	7.6	6.8	6.2	5.2	3.0	4.2
db file parallel read	35	45.5	12.1	9.1	18.2	6.1	1.5	6.1	1.5
db file scattered read	153	96.0	1.2	2.1	.5	.2	.1	.0
db file sequential read	23.2K	93.2	1.6	2.4	1.1	.8	.7	.2	.0
db file single write	5	94.0		4.8	1.2
direct path read	42.3K	95.4	.9	1.4	1.3	.9	.1	.0	.0
direct path read temp	21	98.3	.6	.9	.2	.1
direct path sync	1	33.3		33.3					33.3
direct path write	2	90.9		9.1
direct path write temp	171	86.5	2.4	7.3	3.3	.5	.1
enq: KO - fast object checkpoint	14	40.0	1.4		4.3	4.3	4.3	5.7	40.0
enq: SQ - contention	9793	11.3	4.9	8.9	14.2	17.2	16.0	10.2	17.3
enq: TX - allocate ITL entry	2741	.4	.6	.8	1.8	3.5	92.0	.8	.1
enq: TX - index contention	38.2K	16.4	4.1	7.6	15.5	18.4	15.3	11.2	11.6
enq: TX - row lock contention	65	21.0	2.1	1.0	5.6	8.7	6.2	9.7	45.6
kksfbc child completion	803		99.9	.1
latch free	4101	19.5	7.7	9.5	9.4	10.2	6.4	5.9	31.3
latch: In memory undo latch	216	86.8	2.0	3.5	3.0	1.2	1.7	1.8
latch: active service list	7	73.1	23.1	3.8
latch: cache buffer handles	45	6.3		68.8	20.8	4.2
latch: cache buffers chains	1617	70.9	3.0	5.8	8.0	8.7	2.2	.4	.9
latch: cache buffers lru chain	3	62.5			25.0	12.5
latch: call allocation	135	48.5	3.0	1.4	3.9	2.3	.9	2.1	37.8
latch: checkpoint queue latch	7	22.2	66.7	11.1
latch: enqueue hash chains	219	77.0	4.7	6.5	5.6	4.0	2.2
latch: messages	11	82.8	7.8	9.4
latch: object queue header operation	22	58.5	22.6	9.4	5.7		3.8
latch: redo allocation	58	64.0	19.9	5.0	8.7	2.5
latch: redo copy	4		25.0	25.0	50.0
latch: redo writing	1	83.3	16.7
latch: row cache objects	2161	20.0	9.8	10.7	10.0	9.9	11.7	9.2	18.7
latch: session allocation	6	16.0	2.0	8.0	2.0				72.0
latch: shared pool	22.3K	10.3	5.8	8.7	7.7	8.9	10.1	7.9	40.7
library cache load lock	55	36.1	4.5	4.5	13.5	5.3	3.8	9.8	22.6
library cache lock	214	69.5	1.5	2.9	5.5	1.9	1.4	1.4	15.8
library cache: mutex X	7295	54.7	5.5	5.3	5.5	7.0	6.0	5.0	11.0
log file parallel write	6347	90.9	1.7	2.8	2.6	1.3	.4	.2	.1
log file sequential read	94	81.8	1.5	1.1	4.3	6.1	1.7	2.8	.7
log file single write	3	81.3			6.3	6.3		6.3
log file switch (private strand flush incomplete)	19			6.8	6.8	27.3		2.3	56.8
log file switch completion	19	13.6	9.1	13.6	50.0			13.6
log file sync	21.1K	57.8	3.9	5.1	7.0	9.2	4.8	5.5	6.8
os thread startup	29	75.9	3.1	3.1	4.1	3.6	.5	.5	9.2
process diagnostic dump	9	98.9	.1	.2	.1	.1	.1		.5
read by other session	6764	97.6	.6	.6	.4	.4	.3	.0	.0
reliable message	24	69.2		10.3	2.6	3.8	14.1
row cache lock	2	60.0		20.0		20.0
wait list latch free	105	35.2	4.9	6.2		35.8	16.7	1.2

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
Disk file operations I/O	1	100.0		.0
SQL*Net break/reset to client	6	100.0	.0	.0
buffer busy waits	260	99.7	.1	.1	.1
control file parallel write	12	99.6	.4	.0
control file sequential read	1	100.0	.0
cursor: mutex X	1	99.2					.8
cursor: pin S	64	67.2	.5	30.8	.5	.5	.5
cursor: pin S wait on X	376	61.7	8.5	9.3	7.1	2.6	9.4	1.3
db file async I/O submit	133	95.8	1.9	1.3	.8	.3
db file parallel read	1	98.5	1.5
db file sequential read	40	100.0	.0	.0
direct path read	55	100.0	.0	.0	.0
direct path sync	1	66.7	33.3
enq: CF - contention	1				100.0
enq: KO - fast object checkpoint	28	60.0	12.9	7.1	2.9	10.0	7.1
enq: PR - contention	1						100.0
enq: SQ - contention	2376	82.7	5.4	7.9	2.8	.4	.8	.1
enq: TH - metric threshold evaluation	2						50.0	50.0
enq: TX - allocate ITL entry	2	99.9	.1
enq: TX - index contention	6153	88.4	8.9	1.9	.2	.6
enq: TX - row lock contention	89	54.4	7.7	15.4	10.8	11.8
latch free	2394	68.7	3.9	2.2	5.3	7.2	5.9	4.3	2.5
latch: cache buffers chains	50	99.1	.9
latch: call allocation	372	62.2	1.6	2.0	.3	.9	8.5	24.4
latch: row cache objects	657	81.3	4.6	4.2	3.6	6.0	.3
latch: session allocation	36	28.0	44.0	22.0	6.0
latch: shared pool	18.5K	59.3	9.7	15.3	6.5	2.4	6.7	.1
library cache load lock	30	77.4	6.8	3.0	8.3	.8	3.0	.8
library cache lock	230	84.2	1.4	9.7	1.7	1.3	1.4	.2	.1
library cache: mutex X	2293	89.0	3.3	3.5	2.6	.6	.6	.2	.3
log file parallel write	41	99.9	.1	.0
log file sequential read	4	99.3	.7
log file switch (private strand flush incomplete)	25	43.2		4.5	52.3
log file sync	4040	93.2	5.0	1.6	.2
os thread startup	18	90.8	1.5	.5	1.0	3.1	2.6	.5
process diagnostic dump	8	99.5	.1		.1	.4
read by other session	17	100.0	.0	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

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

Event	Waits 4m to 1h	<2m	<4m	<8m
		% of Total Waits
latch free	212	97.5	2.5
library cache lock	1	99.9	.1
library cache: mutex X	61	99.7	.3	.0

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	550,692	7,252	29,523	105,820
xnjt.localdomain	8	5	0	10
SYS$BACKGROUND	0	0	2	67
xnjtXDB	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	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	1553563	19096	195248	293648	0	0	957492	6
SYS$BACKGROUND	2161	90	1172	3176	0	0	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 27.0% of Total DB Time (s): 551,273
Captured PL/SQL account for 22.7% of Total DB Time (s): 551,273

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Text
124,016.19	32,843	3.78	22.50	0.12	1.74	7aasjymn5pxan	BEGIN PRO_POSITION_GPSONE(:1, ...
60,295.67	55,675	1.08	10.94	0.07	2.45	048yn4y8agaa8	INSERT INTO T_POSITION_GPSONE(...
26,382.10	55,667	0.47	4.79	0.22	0.84	0cdwrd0vfxcc2	INSERT INTO T_LAST_POSITION(ID...
26,199.72	39,709	0.66	4.75	0.15	0.55	3b118t9jb2njq	INSERT INTO HIS_POS_GPSONE(ID,...
6,974.02	39,702	0.18	1.27	0.23	3.61	8u8zr6jjjqd1p	UPDATE HIS_POS_GPSONE SET ZGUI...
5,374.28	16	335.89	0.97	4.65	95.92	80s6yudxwmdw1	SELECT * FROM V_POSITION_GPSON...
2,693.38	55,664	0.05	0.49	0.59	3.80	1adzp3p7pjrst	UPDATE T_LAST_POSITION SET ZGU...
2,433.67	95,430	0.03	0.44	0.33	0.00	2jfqzrxhrm93b	select /+ rule / c.name, u.n...
2,063.41	93,662	0.02	0.37	1.28	0.01	cm5vu20fhtnq1	select /*+ connect_by_filterin...
2,062.77	314	6.57	0.37	0.01	7.42	5ansr7r9htpq3	update undo$ set name=:2, file...

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 64.1% of Total CPU Time (s): 7,276
Captured PL/SQL account for 2.3% of Total CPU Time (s): 7,276

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
830.54	7	118.65	11.41	842.45	98.59	0.00	dkfzha68m2y9z	select distinct cus.ID, cus.CU...
439.52	3	146.51	6.04	453.78	96.86	0.00	c19qz4566s2k3	select distinct cus.ID, cus.CU...
422.63	3	140.88	5.81	433.64	97.46	0.00	9wdg5t3d29w70	select distinct cus.ID, cus.CU...
397.09	3	132.36	5.46	398.63	99.61	0.00	6j3c2jkby5x2s	select distinct cus.ID, cus.CU...
383.51	5	76.70	5.27	406.65	94.31	0.00	ftu2691pk5qfd	SELECT DISTINCT CUS.ID, CUS.CU...
375.30	5	75.06	5.16	386.96	96.99	0.09	6hc21shf4w2fh	select distinct cus.ID, cus.CU...
273.51	2	136.75	3.76	283.61	96.44	2.35	bhazmvp8fktcd	SELECT DISTINCT CUS.ID, CUS.CU...
249.64	16	15.60	3.43	5,374.28	4.65	95.92	80s6yudxwmdw1	SELECT * FROM V_POSITION_GPSON...
149.75	32,843	0.00	2.06	124,016.19	0.12	1.74	7aasjymn5pxan	BEGIN PRO_POSITION_GPSONE(:1, ...
144.41	991	0.15	1.98	166.99	86.47	0.00	cpwvzptnn61df	select * from (select rownum a...
130.89	893	0.15	1.80	156.44	83.67	0.49	038m07jabh932	select * from (select rownum a...
128.54	1	128.54	1.77	129.12	99.56	0.00	3r0pqnq2dt662	SELECT DISTINCT CUS.ID, CUS.CU...
121.00	1	121.00	1.66	121.54	99.56	0.00	aq9pu8bprkhv1	select distinct cus.ID, cus.CU...

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 51.7% of Total User I/O Wait Time (s): 19,200
Captured PL/SQL account for 11.8% of Total User I/O Wait Time (s): 19,200

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
5,154.95	16	322.18	26.85	5,374.28	4.65	95.92	80s6yudxwmdw1	SELECT * FROM V_POSITION_GPSON...
2,155.64	32,843	0.07	11.23	124,016.19	0.12	1.74	7aasjymn5pxan	BEGIN PRO_POSITION_GPSONE(:1, ...
1,480.09	55,675	0.03	7.71	60,295.67	0.07	2.45	048yn4y8agaa8	INSERT INTO T_POSITION_GPSONE(...
893.37	7	127.62	4.65	1,130.65	1.23	79.01	0hbnh4a219uhs	SELECT GUID FROM T_KQDETAIL WH...
310.27	5	62.05	1.62	380.66	1.45	81.51	bkybytgkvfcyc	select count(*) num, count(cas...
251.51	39,702	0.01	1.31	6,974.02	0.23	3.61	8u8zr6jjjqd1p	UPDATE HIS_POS_GPSONE SET ZGUI...
227.83	3	75.94	1.19	701.97	0.65	32.46	522j2jskq9asf	SELECT SJHM, ZDMC, TO_CHAR(ADD...
222.30	55,667	0.00	1.16	26,382.10	0.22	0.84	0cdwrd0vfxcc2	INSERT INTO T_LAST_POSITION(ID...
221.68	2	110.84	1.15	229.48	7.91	96.60	c07c4vfxz35z0	SELECT LON, LAT FROM V_POSITIO...
195.26	1,174	0.17	1.02	233.82	0.37	83.51	5mqtgw89fts3v	SELECT OFFSTATE, ONSTATE FROM ...

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: 106,217,934
Captured SQL account for 36.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
14,948,659	16	934,291.19	14.07	5,374.28	4.6	95.9	80s6yudxwmdw1		SELECT * FROM V_POSITION_GPSON...
4,928,828	32,843	150.07	4.64	124,016.19	.1	1.7	7aasjymn5pxan		BEGIN PRO_POSITION_GPSONE(:1, ...
2,844,342	39,709	71.63	2.68	26,199.72	.1	.6	3b118t9jb2njq		INSERT INTO HIS_POS_GPSONE(ID,...
1,637,713	2	818,856.50	1.54	229.48	7.9	96.6	c07c4vfxz35z0		SELECT LON, LAT FROM V_POSITIO...
1,280,424	55,675	23.00	1.21	60,295.67	.1	2.5	048yn4y8agaa8		INSERT INTO T_POSITION_GPSONE(...
1,076,043	39,702	27.10	1.01	6,974.02	.2	3.6	8u8zr6jjjqd1p		UPDATE HIS_POS_GPSONE SET ZGUI...
1,000,911	991	1,010.00	0.94	166.99	86.5	0	cpwvzptnn61df		select * from (select rownum a...
934,970	55,667	16.80	0.88	26,382.10	.2	.8	0cdwrd0vfxcc2		INSERT INTO T_LAST_POSITION(ID...
912,677	1	912,677.00	0.86	80.17	16.4	62.4	572fbaj0fdw2b	sqlplus@localhost.localdomain (TNS V1-V3)	select output from table(dbms_...
912,358	893	1,021.68	0.86	156.44	83.7	.5	038m07jabh932		select * from (select rownum a...

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: 29,527,398
Captured SQL account for 62.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
14,924,609	16	932,788.06	50.54	5,374.28	4.65	95.92	80s6yudxwmdw1		SELECT * FROM V_POSITION_GPSON...
1,635,288	2	817,644.00	5.54	229.48	7.91	96.60	c07c4vfxz35z0		SELECT LON, LAT FROM V_POSITIO...
739,718	7	105,674.00	2.51	1,130.65	1.23	79.01	0hbnh4a219uhs		SELECT GUID FROM T_KQDETAIL WH...
528,370	5	105,674.00	1.79	380.66	1.45	81.51	bkybytgkvfcyc		select count(*) num, count(cas...
106,272	1	106,272.00	0.36	9.14	10.86	94.66	farr31080jj0u		select count(*) num, count(cas...
106,075	1	106,075.00	0.36	8.53	12.09	94.37	81amk84pu7z9v		select count(*) num, count(cas...
105,796	2	52,898.00	0.36	38.64	34.69	69.27	418392w8hgujg		SELECT SJHM, ZDMC, TO_CHAR(ADD...
105,674	1	105,674.00	0.36	37.94	8.66	90.34	9zw1dj97z7shs		select * from t_kqdetail where...
40,598	2	20,299.00	0.14	37.96	17.19	84.38	6ywkn9crpcjqx	SQL Developer	Select Segment_Name, Sum(bytes...
21,926	1	21,926.00	0.07	10.26	51.94	50.13	5d7f5tu7t810g		SELECT SJHM, ZDMC, TO_CHAR(ADD...

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: 1,260,418
Captured SQL account for 20.8% of Total
Total UnOptimized Read Requests: 1,260,418
Captured SQL account for 20.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 Text
105,796	105,796	2	52,898.00	8.39	418392w8hgujg	SELECT SJHM, ZDMC, TO_CHAR(ADD...
51,355	51,355	2	25,677.50	4.07	c07c4vfxz35z0	SELECT LON, LAT FROM V_POSITIO...
21,926	21,926	1	21,926.00	1.74	5d7f5tu7t810g	SELECT SJHM, ZDMC, TO_CHAR(ADD...
16,370	16,370	16	1,023.13	1.30	80s6yudxwmdw1	SELECT * FROM V_POSITION_GPSON...
13,534	13,534	55,675	0.24	1.07	048yn4y8agaa8	INSERT INTO T_POSITION_GPSONE(...
13,368	13,368	7	1,909.71	1.06	0hbnh4a219uhs	SELECT GUID FROM T_KQDETAIL WH...
6,196	6,196	1	6,196.00	0.49	djfzjnvg07yx4	SELECT SJHM, ZDMC, TO_CHAR(ADD...
5,330	5,330	1	5,330.00	0.42	616xrwhvf0a33	SELECT SJHM, ZDMC, TO_CHAR(ADD...
4,429	4,429	32,843	0.13	0.35	7aasjymn5pxan	BEGIN PRO_POSITION_GPSONE(:1, ...
3,935	3,935	1	3,935.00	0.31	bxyf0qf0sy931	SELECT SJHM, ZDMC, TO_CHAR(ADD...

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: 864,341
Captured SQL account for 77.7% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
95,430	39,777	0.42	2,433.67	.3	0	2jfqzrxhrm93b	select /+ rule / c.name, u.n...
93,662	1,211,204	12.93	2,063.41	1.3	0	cm5vu20fhtnq1	select /*+ connect_by_filterin...
55,675	55,673	1.00	60,295.67	.1	2.5	048yn4y8agaa8	INSERT INTO T_POSITION_GPSONE(...
55,667	7	0.00	26,382.10	.2	.8	0cdwrd0vfxcc2	INSERT INTO T_LAST_POSITION(ID...
55,664	55,659	1.00	2,693.38	.6	3.8	1adzp3p7pjrst	UPDATE T_LAST_POSITION SET ZGU...
55,658	55,664	1.00	1,346.87	.4	0	2skwhauh2cwky	select o.name, u.name from obj...
39,709	8	0.00	26,199.72	.1	.6	3b118t9jb2njq	INSERT INTO HIS_POS_GPSONE(ID,...
39,702	39,702	1.00	6,974.02	.2	3.6	8u8zr6jjjqd1p	UPDATE HIS_POS_GPSONE SET ZGUI...
32,843	32,838	1.00	124,016.19	.1	1.7	7aasjymn5pxan	BEGIN PRO_POSITION_GPSONE(:1, ...
30,676	30,676	1.00	23.70	9.2	.2	7h35uxf5uhmm1	select sysdate from dual
29,595	93,862	3.17	113.87	13.4	0	0k8522rmdzg4k	select privilege# from sysauth...
29,364	29,363	1.00	18.69	59.7	0	0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', ...
29,364	29,364	1.00	22.96	40.7	0	459f3z9u4fb3u	select value$ from props$ wher...
29,339	29,336	1.00	366.54	1.7	0	5ur69atw3vfhj	select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 263,249
Captured SQL account for 75.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
29,576	29,595	11.23	0k8522rmdzg4k	select privilege# from sysauth...
29,489	93,662	11.20	cm5vu20fhtnq1	select /*+ connect_by_filterin...
29,366	29,364	11.16	459f3z9u4fb3u	select value$ from props$ wher...
29,365	29,364	11.15	0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', ...
29,332	29,339	11.14	5ur69atw3vfhj	select decode(failover_method,...
4,807	95,430	1.83	2jfqzrxhrm93b	select /+ rule / c.name, u.n...
4,727	55,667	1.80	0cdwrd0vfxcc2	INSERT INTO T_LAST_POSITION(ID...
4,726	55,675	1.80	048yn4y8agaa8	INSERT INTO T_POSITION_GPSONE(...
4,723	55,658	1.79	2skwhauh2cwky	select o.name, u.name from obj...
4,721	55,664	1.79	1adzp3p7pjrst	UPDATE T_LAST_POSITION SET ZGU...
4,449	39,709	1.69	3b118t9jb2njq	INSERT INTO HIS_POS_GPSONE(ID,...
4,446	39,702	1.69	8u8zr6jjjqd1p	UPDATE HIS_POS_GPSONE SET ZGUI...
3,106	32,843	1.18	7aasjymn5pxan	BEGIN PRO_POSITION_GPSONE(:1, ...
2,739	7,856	1.04	4m7m0t6fjcs5x	update seq$ set increment$=:2,...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,597,103	27	0.10	58kz178ugwm87	SQL Developer	SELECT /*OracleDictionaryQueri...
1,403,112	406	0.09	c78r0nu1v3gn5		SELECT distinct TC.id, TC.all_...
1,092,387	8	0.07	5mvkd770wgn1g	SQL Developer	with pri_cols as ( select colu...

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 Text
56	406	c78r0nu1v3gn5	SELECT distinct TC.id, TC.all_...
56	406	c78r0nu1v3gn5	SELECT distinct TC.id, TC.all_...
28	93,662	cm5vu20fhtnq1	select /*+ connect_by_filterin...
24	13	1gfaj4z5hn1kf	delete from dependency$ where ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

038m07jabh932 select * from (select rownum as rn, tj.* from t_jhdw tj where nowstat='1' and substr(dwtel, 1, 3) in (134, 135, 136, 137, 138, 139, 147, 150, 151, 152, 157, 158, 159, 187, 188, 182)) where rn >=1 and rn<1001

048yn4y8agaa8 INSERT INTO T_POSITION_GPSONE(ID, ZGUID, SJHM, ZDMC, LON, LAT, CONTENT, SUCESS, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, JHDW_ID, JHDWMX_ID, RADUIS, DSSBSJJG, GGUID, ADDTIME) VALUES(SEQ_POSITION_GPSONE.NEXTVAL, :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

0cdwrd0vfxcc2 INSERT INTO T_LAST_POSITION(ID, ZGUID, SJHM, ZDMC, LON, LAT, ADDTIME, CONTENT, SUCESS, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, JHDW_ID, JHDWMX_ID, RADUIS, GGUID) VALUES(SEQ_LAST_POSITION.NEXTVAL, :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

0hbnh4a219uhs SELECT GUID FROM T_KQDETAIL WHERE WORKMODE='1' AND (guid in ('E2387F14-323C-B5A2-5EA1-D91CE28EC79', '7A5B60D5-B7A9-1F71-A035-F5777423D57A', 'CF7137AE-C223-3783-82D3-B0BBACDF23E6', '3DCE3DEF-0F35-9645-C60F-72DFF5DB5E9', '213CDFA5-1C78-5C33-CB56-EAAD1A7778A', '2FB1F3DA-2526-302A-5055-18CD7E9B4845', '7370CFE8-89C8-7378-E6C4-A66FCE2F8B99', '8F4A5470-19DA-D8A7-842D-307FBEAFB8C9', '41838AFB-6871-BB38-CE15-6551DBDE4B', '10587427-8A36-3C1D-18D8-C1BFF775C5F', 'C14DFC90-C3B4-9D95-A16D-A1101514BE6F', 'AD22E44D-53BA-53A6-F8FE-832894C5DA', '69EE32F7-DE83-35AD-AA14-C7549A5CDA', 'EB7C15DE-174B-F43A-6AC5-A96A9658A33', '5A77471E-ACF2-B646-B618-38EC24BAD78', '8EA5DC15-BF7C-6E6B-99D3-AFEF3279B', '78BE4FE1-DB49-66AF-DA41-F399297FBD0', '5DE56C56-511D-249F-9186-18387D0230')) AND SIGNDAY='2013-06-27' AND OFFSTATE!=1

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

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

1adzp3p7pjrst UPDATE T_LAST_POSITION SET ZGUID=:B1 , SJHM=:B16 , ZDMC=:B15 , LON=:B14 , LAT=:B13 , ADDTIME=:B12 , CONTENT=:B11 , SUCESS=:B10 , PROVINCE=:B9 , CITY=:B8 , COUNTY=:B7 , DW_MODE=:B6 , DW_TYPE=:B5 , JHDW_ID=:B4 , JHDWMX_ID=:B3 , RADUIS=:B2 WHERE ZGUID=:B1

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

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

2skwhauh2cwky select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#

3b118t9jb2njq INSERT INTO HIS_POS_GPSONE(ID, ZGUID, SJHM, ZDMC, LON, LAT, ADDTIME, CONTENT, SUCESS, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, JHDW_ID, JHDWMX_ID, RADUIS, GGUID) VALUES(SEQ_HIS_POS_GPSONE.NEXTVAL, :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

3r0pqnq2dt662 SELECT DISTINCT CUS.ID, CUS.CUSTOMERID, CUS.ALL_NAME, CUS.KH_BELONG, CUS.KH_STATE, CUGROUP.KHNAME, CUS.ADDTIME AS ADDTIME, CUS.CJRGUID FROM T_CUSTOMER CUS, T_CUSTOMER_ASSIGN ASSIGN, T_CUSTOMER_GROUP CUGROUP WHERE CUS.GGUID='9252A7AF-0178-D9E1-5947-122982251' AND CUGROUP.COGUID=CUS.GGUID AND CUGROUP.KID=CUS.GROUPID AND CUS.ID NOT IN (SELECT CUSTOMERID FROM T_CUSTOMER_ASSIGN WHERE YG_GUID='1E7C9A19-8698-1733-18D3-64D1359B472') AND CUS.KH_BELONG='1' ORDER BY ADDTIME DESC

418392w8hgujg SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd HH24:mi:ss') ADDTIME, LON, LAT, CONTENT, PROVINCE, CITY, COUNTY, DW_MODE, SUCESS, DSSBSJJG FROM V_POSITION_GPSONE WHERE 1=1 AND ADDTIME>=TO_DATE('2013-05-27 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND SUCESS=0 AND ZGUID='389C4B23-719B-D69D-C959-189AF73D3E8' ORDER BY ADDTIME ASC

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

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

522j2jskq9asf SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd HH24:mi:ss') ADDTIME, LON, LAT, CONTENT, PROVINCE, CITY, COUNTY, DW_MODE, SUCESS, DSSBSJJG FROM V_POSITION_GPSONE WHERE 1=1 AND ADDTIME>=TO_DATE('2013-06-20 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND SUCESS=0 AND ZGUID='4C8F3DFF-1972-103F-77F0-3C5EBEE5F6E' ORDER BY ADDTIME ASC

572fbaj0fdw2b select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))

58kz178ugwm87 SELECT /*OracleDictionaryQueries.ALL_TABLE_ORACLE_QUERY*/ X.TABLE_NAME , 'TABLE' OBJECT_TYPE , (SELECT O.OBJECT_ID FROM ALL_OBJECTS O WHERE O.OWNER = X.OWNER AND O.OBJECT_TYPE = 'TABLE' AND O.OBJECT_NAME = X.TABLE_NAME) OBJECT_ID FROM ( SELECT T.TABLE_NAME, T.OWNER FROM ALL_TABLES T WHERE T.OWNER = :1 AND T.NESTED = 'NO' AND T.TABLE_NAME LIKE :2 AND T.IOT_NAME IS NULL AND T.SECONDARY = 'N' AND T.DROPPED = 'NO' MINUS SELECT QT.QUEUE_TABLE, QT.OWNER FROM ALL_QUEUE_TABLES QT WHERE QT.OWNER = :3 AND QT.QUEUE_TABLE LIKE :4 MINUS SELECT MV.MVIEW_NAME, MV.OWNER FROM ALL_MVIEWS MV WHERE MV.OWNER = :5 AND MV.MVIEW_NAME LIKE :6 MINUS SELECT MVL.LOG_TABLE, MVL.LOG_OWNER FROM ALL_SNAPSHOT_LOGS MVL WHERE MVL.LOG_OWNER = :7 AND MVL.LOG_TABLE LIKE :8 MINUS SELECT RU.TABLE_NAME, RU.OWNER FROM ALL_TABLES RU WHERE RU.TABLE_NAME LIKE 'RUPD%' AND RU.TEMPORARY = 'Y' AND RU.OWNER = :9 AND EXISTS (SELECT 1 FROM ALL_TAB_COLUMNS ATC WHERE ATC.OWNER = RU.OWNER AND ATC.TABLE_NAME = RU.TABLE_NAME AND ATC.COLUMN_NAME = 'CHANGE_VECTOR$$') ) X UNION ALL SELECT T.TABLE_NAME , 'TABLE' OBJECT_TYPE , (SELECT O.OBJECT_ID FROM ALL_OBJECTS O WHERE O.OWNER = T.OWNER AND O.OBJECT_TYPE = 'TABLE' AND O.OBJECT_NAME = T.TABLE_NAME) OBJECT_ID FROM ALL_OBJECT_TABLES T WHERE T.OWNER = :10 AND T.TABLE_NAME LIKE :11 AND T.IOT_NAME IS NULL AND T.NESTED = 'NO' AND T.SECONDARY = 'N' AND T.DROPPED = 'NO'

5ansr7r9htpq3 update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1

5d7f5tu7t810g SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd HH24:mi:ss') ADDTIME, LON, LAT, CONTENT, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, SUCESS FROM V_POSITION_GPSONE WHERE 1=1 and ADDTIME>=TO_DATE('2013-05-27 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND ZGUID='389C4B23-719B-D69D-C959-189AF73D3E8' ORDER BY ADDTIME ASC

5mqtgw89fts3v SELECT OFFSTATE, ONSTATE FROM T_KQDETAIL PARTITION(ADDTIME_1306) WHERE COSIM=:1 AND REGSIM=:2 AND SIGNDAY=:3

5mvkd770wgn1g with pri_cols as ( select column_name, column_position from sys.all_ind_columns where (index_owner, index_name) = (select owner, index_name from sys.all_constraints where owner =:OBJECT_OWNER and table_name = :OBJECT_NAME and constraint_type = 'P') ) select c.column_name, case when data_type = 'CHAR' then data_type||'('||c.char_length||decode(char_used, 'B', ' Bytes', 'C', ' Char', null)||')' when data_type = 'VARCHAR' then data_type||'('||c.char_length||decode(char_used, 'B', ' Bytes', 'C', ' Char', null)||')' when data_type = 'VARCHAR2' then data_type||'('||c.char_length||decode(char_used, 'B', ' Bytes', 'C', ' Char', null)||')' when data_type = 'NCHAR' then data_type||'('||c.char_length||decode(char_used, 'B', ' Bytes', 'C', ' Char', null)||')' when data_type = 'NUMBER' then case when c.data_precision is null then 'NUMBER' else data_type||'('||c.data_precision||', '||c.data_SCALE||')' end when data_type = 'NVARCHAR' then data_type||'('||c.char_length||decode(char_used, 'B', ' Bytes', 'C', ' Char', null)||')' when data_type = 'NVARCHAR2' then data_type||'('||c.char_length||decode(char_used, 'B', ' Bytes', 'C', ' Char', null)||')' else data_type end data_type, decode(nullable, 'Y', 'Yes', 'No') nullable, c.DATA_DEFAULT, column_id, sub.column_position pk, com.comments from sys.all_tab_Columns c, sys.all_col_comments com, pri_cols sub where c.column_name = sub.column_name(+) and c.owner = :OBJECT_OWNER and c.table_name = :OBJECT_NAME and c.table_name = com.table_name and c.owner = com.owner and c.column_name = com.column_name order by sub.column_position, column_id

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

616xrwhvf0a33 SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd hh24:mi:ss') ADDTIME, PROVINCE, CITY, COUNTY, CONTENT, DW_MODE FROM V_POSITION_GPSONE WHERE SUCESS=0 AND ADDTIME>=TO_DATE('2013-06-20 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND ZGUID='9185F699-F7C7-11FA-46BE-9DA31ED4' ORDER BY ADDTIME

6hc21shf4w2fh select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='D6EC8890-2ADC-FDD9-1231-4A62FEF2B') and cus.kh_belong='1' order by cus.ADDTIME desc

6j3c2jkby5x2s select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='4D17AB28-E188-AE18-E892-F6AB6634A') and cus.kh_belong='1' order by cus.ADDTIME desc

6ywkn9crpcjqx Select Segment_Name, Sum(bytes)/1024/1024 From User_Extents group By Segment_Name order by Sum(bytes)/1024/1024 desc

7aasjymn5pxan BEGIN PRO_POSITION_GPSONE(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19) ; END;

7h35uxf5uhmm1 select sysdate from dual

80s6yudxwmdw1 SELECT * FROM V_POSITION_GPSONE WHERE ID=:1

81amk84pu7z9v select count(*) num, count(case when QDISNORMAL = '1' then QDISNORMAL else null end) kqqdRight, count(case when QDISNORMAL = '3' or QDISNORMAL = '2' then QDISNORMAL else null end) kqqdWrong, count(case when QTISNORMAL = '1' then QTISNORMAL else null end) kqqtRight, count(case offstate when 1 then offstate else null end) kqqtNo, count(case when QTISNORMAL='3' or QTISNORMAL='2' then QTISNORMAL else null end) kqqtWrong from t_kqdetail where (guid in ('39E7783F-9BF9-8CD3-DC33-7E18FB3DB98', '898F9E83-151D-CE2F-02D5-BCA42C128C', '8339AE28-AA37-EEB2-905D-F939623A5822', '533D80D9-721A-98F5-6C2F-CD2B1C5B41B8', '8E6AAA6B-D25E-9923-3949-E0A24355C8C2', '91E96892-F654-03B3-5EE1-4B4CC1E081', '10CC4EEF-A776-EB2B-606C-C6BF6DD0A2', 'A93ABD41-A67B-551D-C3F6-D466E760DC71', 'AE6E6AB2-E327-DF9F-BAB1-9483358EFF', '6D4FD1EA-726F-91B4-5669-1AD0F7A83E17', '7E05BEE7-4279-3E8E-15A9-FC86AD03934', 'F73B554B-FE5E-EA17-0B57-48C2A576', '24171356-ABD4-AE11-7D17-21B70EF46AE', '21E01B5D-DF94-8F8C-5AD1-CAA388B58F', 'D182455E-B5EB-F619-4B25-4C5D32554C1', 'AC4554B0-E7D0-2314-1A80-2D4F1E5EA9D4', '5864F97E-8223-7414-77F1-28CB18C61', 'E8C54DF2-D829-9A1E-CACF-B4E8C9C4DF7F', '9E5EFEA6-5DF2-9911-6C64-FFAB3E40CA19', '1A3C4B88-17A6-4C4B-9F64-1FBDBA2C7415', 'D47984DD-3CAB-1CFC-4DE8-053B1E6631D', '342848F0-53D9-6BBE-82FB-EF8163FEE55', '4192AA9F-D38E-9577-481A-CB9A974CD')) and workmode='1' and SIGNDAY='2013-06-26'

8u8zr6jjjqd1p UPDATE HIS_POS_GPSONE SET ZGUID=:B1 , SJHM=:B16 , ZDMC=:B15 , LON=:B14 , LAT=:B13 , ADDTIME=:B12 , CONTENT=:B11 , SUCESS=:B10 , PROVINCE=:B9 , CITY=:B8 , COUNTY=:B7 , DW_MODE=:B6 , DW_TYPE=:B5 , JHDW_ID=:B4 , JHDWMX_ID=:B3 , RADUIS=:B2 WHERE ZGUID=:B1

9wdg5t3d29w70 select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='465A9983-C51F-CA38-F58C-AEAAF63D15D') and cus.kh_belong='1' order by cus.ADDTIME desc

9zw1dj97z7shs select * from t_kqdetail where spid='QD201306204250797'

aq9pu8bprkhv1 select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='5DB6A6BC-D713-D8B8-2617-B55DF262B55') and cus.kh_belong='1' order by cus.ADDTIME desc

bhazmvp8fktcd SELECT DISTINCT CUS.ID, CUS.CUSTOMERID, CUS.ALL_NAME, CUS.KH_BELONG, CUS.KH_STATE, CUGROUP.KHNAME, CUS.ADDTIME AS ADDTIME, CUS.CJRGUID FROM T_CUSTOMER CUS, T_CUSTOMER_ASSIGN ASSIGN, T_CUSTOMER_GROUP CUGROUP WHERE CUS.GGUID='9252A7AF-0178-D9E1-5947-122982251' AND CUGROUP.COGUID=CUS.GGUID AND CUGROUP.KID=CUS.GROUPID AND CUS.ID NOT IN (SELECT CUSTOMERID FROM T_CUSTOMER_ASSIGN WHERE YG_GUID='5DB6A6BC-D713-D8B8-2617-B55DF262B55') AND CUS.KH_BELONG='1' ORDER BY ADDTIME DESC

bkybytgkvfcyc select count(*) num, count(case when QDISNORMAL = '1' then QDISNORMAL else null end) kqqdRight, count(case when QDISNORMAL = '3' or QDISNORMAL = '2' then QDISNORMAL else null end) kqqdWrong, count(case when QTISNORMAL = '1' then QTISNORMAL else null end) kqqtRight, count(case offstate when 1 then offstate else null end) kqqtNo, count(case when QTISNORMAL='3' or QTISNORMAL='2' then QTISNORMAL else null end) kqqtWrong from t_kqdetail where (guid in ('E2387F14-323C-B5A2-5EA1-D91CE28EC79', '7A5B60D5-B7A9-1F71-A035-F5777423D57A', 'CF7137AE-C223-3783-82D3-B0BBACDF23E6', '3DCE3DEF-0F35-9645-C60F-72DFF5DB5E9', '213CDFA5-1C78-5C33-CB56-EAAD1A7778A', '2FB1F3DA-2526-302A-5055-18CD7E9B4845', '7370CFE8-89C8-7378-E6C4-A66FCE2F8B99', '8F4A5470-19DA-D8A7-842D-307FBEAFB8C9', '41838AFB-6871-BB38-CE15-6551DBDE4B', '10587427-8A36-3C1D-18D8-C1BFF775C5F', 'C14DFC90-C3B4-9D95-A16D-A1101514BE6F', 'AD22E44D-53BA-53A6-F8FE-832894C5DA', '69EE32F7-DE83-35AD-AA14-C7549A5CDA', 'EB7C15DE-174B-F43A-6AC5-A96A9658A33', '5A77471E-ACF2-B646-B618-38EC24BAD78', '8EA5DC15-BF7C-6E6B-99D3-AFEF3279B', '78BE4FE1-DB49-66AF-DA41-F399297FBD0', '5DE56C56-511D-249F-9186-18387D0230')) and workmode='1' and SIGNDAY='2013-06-27'

bxyf0qf0sy931 SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd hh24:mi:ss') ADDTIME, PROVINCE, CITY, COUNTY, CONTENT, DW_MODE FROM V_POSITION_GPSONE WHERE SUCESS=0 AND ADDTIME>=TO_DATE('2013-06-18 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND ZGUID='B28EDD24-749F-822E-87B2-6AE2465E869B' ORDER BY ADDTIME

c07c4vfxz35z0 SELECT LON, LAT FROM V_POSITION_GPSONE WHERE ID=:1

c19qz4566s2k3 select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='98EB2D74-677E-84FC-7E55-A5E46A2B94') and cus.kh_belong='1' order by cus.ADDTIME desc

c78r0nu1v3gn5 SELECT distinct TC.id, TC.all_name, TC.address, TC.linkman, TC.telephone, TC.short_name, TC.qy_type, TC.addtime, TC.lon, TC.lat, TC.kh_state, TC.kh_belong, TC.groupid, TC.link_sim, TC.clon, TC.clat FROM T_CUSTOMER TC, T_CUSTOMER_ASSIGN TCA WHERE TC.ID=TCA.CUSTOMERID AND TCA.YG_GUID=:1 AND TCA.GGUID=:2

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

cpwvzptnn61df select * from (select rownum as rn, tj.* from t_jhdw tj where nowstat='1' and substr(dwtel, 1, 3) in (134, 135, 136, 137, 138, 139, 147, 150, 151, 152, 157, 158, 159, 187, 188, 182)) where rn >=1001 and rn<2001

djfzjnvg07yx4 SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd HH24:mi:ss') ADDTIME, LON, LAT, CONTENT, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, SUCESS FROM V_POSITION_GPSONE WHERE 1=1 and ADDTIME>=TO_DATE('2013-06-24 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND ZGUID='A74CC567-C6F7-C614-5B1D-770DE9B9932' ORDER BY ADDTIME ASC

dkfzha68m2y9z select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='1E7C9A19-8698-1733-18D3-64D1359B472') and cus.kh_belong='1' order by cus.ADDTIME desc

farr31080jj0u select count(*) num, count(case when QDISNORMAL = '1' and onstate = 2 then onstate else null end) kqqdRight, count(case when onstate = 3 and QDISNORMAL = '1' then onstate else null end) zccd, count(case when onstate = 3 and (QDISNORMAL = '3' or QDISNORMAL = '2') then onstate else null end) fzccd, count(case onstate when 1 then onstate else null end) kqqdNo, count(case when (QDISNORMAL = '3' or QDISNORMAL = '2') and onstate = 2 then QDISNORMAL else null end) kqqdWrong, count(case when QTISNORMAL='1' and offstate=2 then offstate else null end) kqqtRight, count(case when offstate = 3 and QTISNORMAL = '1' then offstate else null end) zczt, count(case when offstate = 3 and (QTISNORMAL = '3' or QTISNORMAL = '2') then offstate else null end) fzczt, count(case offstate when 1 then offstate else null end) kqqtNo, count(case when (QTISNORMAL = '3' or QTISNORMAL = '2') and offstate=2 then QTISNORMAL else null end) kqqtWrong from t_kqdetail where (guid in ('653DD925-B4A5-BB12-68DA-E6B8BF04DCA', 'A9DD8C73-5B0B-7E0E-F536-2B6EC0FC', '4AAB13E0-23B7-42F2-5181-4F43DF8C985F', 'A6D0761A-CC8E-8C15-3491-7585288AE377', 'C95C6662-2927-C22D-6385-C8C83B328EF8', 'E84BBC10-92BB-10A9-7EF8-6F472D51166E', '94839F41-935C-D64B-B261-D2BE4FE3137B', '3FA549F0-255A-5785-0FA8-5C6162AF6A', '327AF688-4740-C5F2-EDA2-30C42B5BEE3', 'F937B12A-81F0-C732-52AD-21C4DBF3C35', '949E51C3-8BE8-5EDB-925F-52CB7CF6DC', 'AA86D26B-1894-7337-CBC1-9F324EF71D', 'CEA7581C-4158-AD2E-6EBB-9F6C3296764', '101A25DE-413C-E7CC-979E-144CE6228CA5', 'E1F5BA81-FE2B-9A24-5D31-1263DE7D64', 'B9F71698-DC13-3B21-4F1B-99B799E485C3', '936F8BB5-DAD5-C5FC-2B5B-AF53FC87C0', 'FB5A8D2B-BDD4-987B-EE48-B341EF0D65D', 'D37D4D83-24CE-51AF-42A4-C7E38086EF5', 'AD63B44F-E2D4-3AB3-54F0-17DD7B33CF1A', '62937CAA-F455-EBAB-AE76-C4B9D0D326A1', '61F75E4C-5609-F8AA-BFD3-214203258AC', '819911D2-9315-AD45-0609-F404F5572D2', '3CDF9AF7-D113-FB5F-94AF-70DF93E2DC', '567C79A1-85D1-6B62-A3A7-4D482BA08D8E', '2699E6DA-FAF4-497E-74D9-7CE32CEB33E', 'E97A3D90-65E6-D120-D81C-C1526E55268A', '842787B0-C939-41EA-FFC7-D9CCA7152CF', '229EBC77-1A82-FE06-64DB-A2CB7CB417F', '6D415293-68C7-BE59-7D72-0FCC564524B', '1B8DA7B1-3117-42A3-525C-EC54F8DDFB30', '50B2BD6D-10BF-33D3-E96F-EB13F82D5A0')) and workmode='2' and SIGNDAY='2013-06-20'

ftu2691pk5qfd SELECT DISTINCT CUS.ID, CUS.CUSTOMERID, CUS.ALL_NAME, CUS.KH_BELONG, CUS.KH_STATE, CUGROUP.KHNAME, CUS.ADDTIME AS ADDTIME, CUS.CJRGUID FROM T_CUSTOMER CUS, T_CUSTOMER_ASSIGN ASSIGN, T_CUSTOMER_GROUP CUGROUP WHERE CUS.GGUID='9252A7AF-0178-D9E1-5947-122982251' AND CUGROUP.COGUID=CUS.GGUID AND CUGROUP.KID=CUS.GROUPID AND CUS.ID NOT IN (SELECT CUSTOMERID FROM T_CUSTOMER_ASSIGN WHERE YG_GUID='D6EC8890-2ADC-FDD9-1231-4A62FEF2B') AND CUS.KH_BELONG='1' ORDER BY ADDTIME DESC

SQL Id	SQL Text
038m07jabh932	select * from (select rownum as rn, tj.* from t_jhdw tj where nowstat='1' and substr(dwtel, 1, 3) in (134, 135, 136, 137, 138, 139, 147, 150, 151, 152, 157, 158, 159, 187, 188, 182)) where rn >=1 and rn<1001
048yn4y8agaa8	INSERT INTO T_POSITION_GPSONE(ID, ZGUID, SJHM, ZDMC, LON, LAT, CONTENT, SUCESS, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, JHDW_ID, JHDWMX_ID, RADUIS, DSSBSJJG, GGUID, ADDTIME) VALUES(SEQ_POSITION_GPSONE.NEXTVAL, :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
0cdwrd0vfxcc2	INSERT INTO T_LAST_POSITION(ID, ZGUID, SJHM, ZDMC, LON, LAT, ADDTIME, CONTENT, SUCESS, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, JHDW_ID, JHDWMX_ID, RADUIS, GGUID) VALUES(SEQ_LAST_POSITION.NEXTVAL, :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
0hbnh4a219uhs	SELECT GUID FROM T_KQDETAIL WHERE WORKMODE='1' AND (guid in ('E2387F14-323C-B5A2-5EA1-D91CE28EC79', '7A5B60D5-B7A9-1F71-A035-F5777423D57A', 'CF7137AE-C223-3783-82D3-B0BBACDF23E6', '3DCE3DEF-0F35-9645-C60F-72DFF5DB5E9', '213CDFA5-1C78-5C33-CB56-EAAD1A7778A', '2FB1F3DA-2526-302A-5055-18CD7E9B4845', '7370CFE8-89C8-7378-E6C4-A66FCE2F8B99', '8F4A5470-19DA-D8A7-842D-307FBEAFB8C9', '41838AFB-6871-BB38-CE15-6551DBDE4B', '10587427-8A36-3C1D-18D8-C1BFF775C5F', 'C14DFC90-C3B4-9D95-A16D-A1101514BE6F', 'AD22E44D-53BA-53A6-F8FE-832894C5DA', '69EE32F7-DE83-35AD-AA14-C7549A5CDA', 'EB7C15DE-174B-F43A-6AC5-A96A9658A33', '5A77471E-ACF2-B646-B618-38EC24BAD78', '8EA5DC15-BF7C-6E6B-99D3-AFEF3279B', '78BE4FE1-DB49-66AF-DA41-F399297FBD0', '5DE56C56-511D-249F-9186-18387D0230')) AND SIGNDAY='2013-06-27' AND OFFSTATE!=1
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1adzp3p7pjrst	UPDATE T_LAST_POSITION SET ZGUID=:B1 , SJHM=:B16 , ZDMC=:B15 , LON=:B14 , LAT=:B13 , ADDTIME=:B12 , CONTENT=:B11 , SUCESS=:B10 , PROVINCE=:B9 , CITY=:B8 , COUNTY=:B7 , DW_MODE=:B6 , DW_TYPE=:B5 , JHDW_ID=:B4 , JHDWMX_ID=:B3 , RADUIS=:B2 WHERE ZGUID=:B1
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
2jfqzrxhrm93b	select /+ rule / c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
2skwhauh2cwky	select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
3b118t9jb2njq	INSERT INTO HIS_POS_GPSONE(ID, ZGUID, SJHM, ZDMC, LON, LAT, ADDTIME, CONTENT, SUCESS, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, JHDW_ID, JHDWMX_ID, RADUIS, GGUID) VALUES(SEQ_HIS_POS_GPSONE.NEXTVAL, :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
3r0pqnq2dt662	SELECT DISTINCT CUS.ID, CUS.CUSTOMERID, CUS.ALL_NAME, CUS.KH_BELONG, CUS.KH_STATE, CUGROUP.KHNAME, CUS.ADDTIME AS ADDTIME, CUS.CJRGUID FROM T_CUSTOMER CUS, T_CUSTOMER_ASSIGN ASSIGN, T_CUSTOMER_GROUP CUGROUP WHERE CUS.GGUID='9252A7AF-0178-D9E1-5947-122982251' AND CUGROUP.COGUID=CUS.GGUID AND CUGROUP.KID=CUS.GROUPID AND CUS.ID NOT IN (SELECT CUSTOMERID FROM T_CUSTOMER_ASSIGN WHERE YG_GUID='1E7C9A19-8698-1733-18D3-64D1359B472') AND CUS.KH_BELONG='1' ORDER BY ADDTIME DESC
418392w8hgujg	SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd HH24:mi:ss') ADDTIME, LON, LAT, CONTENT, PROVINCE, CITY, COUNTY, DW_MODE, SUCESS, DSSBSJJG FROM V_POSITION_GPSONE WHERE 1=1 AND ADDTIME>=TO_DATE('2013-05-27 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND SUCESS=0 AND ZGUID='389C4B23-719B-D69D-C959-189AF73D3E8' ORDER BY ADDTIME ASC
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
522j2jskq9asf	SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd HH24:mi:ss') ADDTIME, LON, LAT, CONTENT, PROVINCE, CITY, COUNTY, DW_MODE, SUCESS, DSSBSJJG FROM V_POSITION_GPSONE WHERE 1=1 AND ADDTIME>=TO_DATE('2013-06-20 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND SUCESS=0 AND ZGUID='4C8F3DFF-1972-103F-77F0-3C5EBEE5F6E' ORDER BY ADDTIME ASC
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
58kz178ugwm87	SELECT /OracleDictionaryQueries.ALL_TABLE_ORACLE_QUERY/ X.TABLE_NAME , 'TABLE' OBJECT_TYPE , (SELECT O.OBJECT_ID FROM ALL_OBJECTS O WHERE O.OWNER = X.OWNER AND O.OBJECT_TYPE = 'TABLE' AND O.OBJECT_NAME = X.TABLE_NAME) OBJECT_ID FROM ( SELECT T.TABLE_NAME, T.OWNER FROM ALL_TABLES T WHERE T.OWNER = :1 AND T.NESTED = 'NO' AND T.TABLE_NAME LIKE :2 AND T.IOT_NAME IS NULL AND T.SECONDARY = 'N' AND T.DROPPED = 'NO' MINUS SELECT QT.QUEUE_TABLE, QT.OWNER FROM ALL_QUEUE_TABLES QT WHERE QT.OWNER = :3 AND QT.QUEUE_TABLE LIKE :4 MINUS SELECT MV.MVIEW_NAME, MV.OWNER FROM ALL_MVIEWS MV WHERE MV.OWNER = :5 AND MV.MVIEW_NAME LIKE :6 MINUS SELECT MVL.LOG_TABLE, MVL.LOG_OWNER FROM ALL_SNAPSHOT_LOGS MVL WHERE MVL.LOG_OWNER = :7 AND MVL.LOG_TABLE LIKE :8 MINUS SELECT RU.TABLE_NAME, RU.OWNER FROM ALL_TABLES RU WHERE RU.TABLE_NAME LIKE 'RUPD%' AND RU.TEMPORARY = 'Y' AND RU.OWNER = :9 AND EXISTS (SELECT 1 FROM ALL_TAB_COLUMNS ATC WHERE ATC.OWNER = RU.OWNER AND ATC.TABLE_NAME = RU.TABLE_NAME AND ATC.COLUMN_NAME = 'CHANGE_VECTOR$$') ) X UNION ALL SELECT T.TABLE_NAME , 'TABLE' OBJECT_TYPE , (SELECT O.OBJECT_ID FROM ALL_OBJECTS O WHERE O.OWNER = T.OWNER AND O.OBJECT_TYPE = 'TABLE' AND O.OBJECT_NAME = T.TABLE_NAME) OBJECT_ID FROM ALL_OBJECT_TABLES T WHERE T.OWNER = :10 AND T.TABLE_NAME LIKE :11 AND T.IOT_NAME IS NULL AND T.NESTED = 'NO' AND T.SECONDARY = 'N' AND T.DROPPED = 'NO'
5ansr7r9htpq3	update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1
5d7f5tu7t810g	SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd HH24:mi:ss') ADDTIME, LON, LAT, CONTENT, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, SUCESS FROM V_POSITION_GPSONE WHERE 1=1 and ADDTIME>=TO_DATE('2013-05-27 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND ZGUID='389C4B23-719B-D69D-C959-189AF73D3E8' ORDER BY ADDTIME ASC
5mqtgw89fts3v	SELECT OFFSTATE, ONSTATE FROM T_KQDETAIL PARTITION(ADDTIME_1306) WHERE COSIM=:1 AND REGSIM=:2 AND SIGNDAY=:3
5mvkd770wgn1g	with pri_cols as ( select column_name, column_position from sys.all_ind_columns where (index_owner, index_name) = (select owner, index_name from sys.all_constraints where owner =:OBJECT_OWNER and table_name = :OBJECT_NAME and constraint_type = 'P') ) select c.column_name, case when data_type = 'CHAR' then data_type\|\|'('\|\|c.char_length\|\|decode(char_used, 'B', ' Bytes', 'C', ' Char', null)\|\|')' when data_type = 'VARCHAR' then data_type\|\|'('\|\|c.char_length\|\|decode(char_used, 'B', ' Bytes', 'C', ' Char', null)\|\|')' when data_type = 'VARCHAR2' then data_type\|\|'('\|\|c.char_length\|\|decode(char_used, 'B', ' Bytes', 'C', ' Char', null)\|\|')' when data_type = 'NCHAR' then data_type\|\|'('\|\|c.char_length\|\|decode(char_used, 'B', ' Bytes', 'C', ' Char', null)\|\|')' when data_type = 'NUMBER' then case when c.data_precision is null then 'NUMBER' else data_type\|\|'('\|\|c.data_precision\|\|', '\|\|c.data_SCALE\|\|')' end when data_type = 'NVARCHAR' then data_type\|\|'('\|\|c.char_length\|\|decode(char_used, 'B', ' Bytes', 'C', ' Char', null)\|\|')' when data_type = 'NVARCHAR2' then data_type\|\|'('\|\|c.char_length\|\|decode(char_used, 'B', ' Bytes', 'C', ' Char', null)\|\|')' else data_type end data_type, decode(nullable, 'Y', 'Yes', 'No') nullable, c.DATA_DEFAULT, column_id, sub.column_position pk, com.comments from sys.all_tab_Columns c, sys.all_col_comments com, pri_cols sub where c.column_name = sub.column_name(+) and c.owner = :OBJECT_OWNER and c.table_name = :OBJECT_NAME and c.table_name = com.table_name and c.owner = com.owner and c.column_name = com.column_name order by sub.column_position, column_id
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
616xrwhvf0a33	SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd hh24:mi:ss') ADDTIME, PROVINCE, CITY, COUNTY, CONTENT, DW_MODE FROM V_POSITION_GPSONE WHERE SUCESS=0 AND ADDTIME>=TO_DATE('2013-06-20 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND ZGUID='9185F699-F7C7-11FA-46BE-9DA31ED4' ORDER BY ADDTIME
6hc21shf4w2fh	select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='D6EC8890-2ADC-FDD9-1231-4A62FEF2B') and cus.kh_belong='1' order by cus.ADDTIME desc
6j3c2jkby5x2s	select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='4D17AB28-E188-AE18-E892-F6AB6634A') and cus.kh_belong='1' order by cus.ADDTIME desc
6ywkn9crpcjqx	Select Segment_Name, Sum(bytes)/1024/1024 From User_Extents group By Segment_Name order by Sum(bytes)/1024/1024 desc
7aasjymn5pxan	BEGIN PRO_POSITION_GPSONE(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19) ; END;
7h35uxf5uhmm1	select sysdate from dual
80s6yudxwmdw1	SELECT * FROM V_POSITION_GPSONE WHERE ID=:1
81amk84pu7z9v	select count(*) num, count(case when QDISNORMAL = '1' then QDISNORMAL else null end) kqqdRight, count(case when QDISNORMAL = '3' or QDISNORMAL = '2' then QDISNORMAL else null end) kqqdWrong, count(case when QTISNORMAL = '1' then QTISNORMAL else null end) kqqtRight, count(case offstate when 1 then offstate else null end) kqqtNo, count(case when QTISNORMAL='3' or QTISNORMAL='2' then QTISNORMAL else null end) kqqtWrong from t_kqdetail where (guid in ('39E7783F-9BF9-8CD3-DC33-7E18FB3DB98', '898F9E83-151D-CE2F-02D5-BCA42C128C', '8339AE28-AA37-EEB2-905D-F939623A5822', '533D80D9-721A-98F5-6C2F-CD2B1C5B41B8', '8E6AAA6B-D25E-9923-3949-E0A24355C8C2', '91E96892-F654-03B3-5EE1-4B4CC1E081', '10CC4EEF-A776-EB2B-606C-C6BF6DD0A2', 'A93ABD41-A67B-551D-C3F6-D466E760DC71', 'AE6E6AB2-E327-DF9F-BAB1-9483358EFF', '6D4FD1EA-726F-91B4-5669-1AD0F7A83E17', '7E05BEE7-4279-3E8E-15A9-FC86AD03934', 'F73B554B-FE5E-EA17-0B57-48C2A576', '24171356-ABD4-AE11-7D17-21B70EF46AE', '21E01B5D-DF94-8F8C-5AD1-CAA388B58F', 'D182455E-B5EB-F619-4B25-4C5D32554C1', 'AC4554B0-E7D0-2314-1A80-2D4F1E5EA9D4', '5864F97E-8223-7414-77F1-28CB18C61', 'E8C54DF2-D829-9A1E-CACF-B4E8C9C4DF7F', '9E5EFEA6-5DF2-9911-6C64-FFAB3E40CA19', '1A3C4B88-17A6-4C4B-9F64-1FBDBA2C7415', 'D47984DD-3CAB-1CFC-4DE8-053B1E6631D', '342848F0-53D9-6BBE-82FB-EF8163FEE55', '4192AA9F-D38E-9577-481A-CB9A974CD')) and workmode='1' and SIGNDAY='2013-06-26'
8u8zr6jjjqd1p	UPDATE HIS_POS_GPSONE SET ZGUID=:B1 , SJHM=:B16 , ZDMC=:B15 , LON=:B14 , LAT=:B13 , ADDTIME=:B12 , CONTENT=:B11 , SUCESS=:B10 , PROVINCE=:B9 , CITY=:B8 , COUNTY=:B7 , DW_MODE=:B6 , DW_TYPE=:B5 , JHDW_ID=:B4 , JHDWMX_ID=:B3 , RADUIS=:B2 WHERE ZGUID=:B1
9wdg5t3d29w70	select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='465A9983-C51F-CA38-F58C-AEAAF63D15D') and cus.kh_belong='1' order by cus.ADDTIME desc
9zw1dj97z7shs	select * from t_kqdetail where spid='QD201306204250797'
aq9pu8bprkhv1	select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='5DB6A6BC-D713-D8B8-2617-B55DF262B55') and cus.kh_belong='1' order by cus.ADDTIME desc
bhazmvp8fktcd	SELECT DISTINCT CUS.ID, CUS.CUSTOMERID, CUS.ALL_NAME, CUS.KH_BELONG, CUS.KH_STATE, CUGROUP.KHNAME, CUS.ADDTIME AS ADDTIME, CUS.CJRGUID FROM T_CUSTOMER CUS, T_CUSTOMER_ASSIGN ASSIGN, T_CUSTOMER_GROUP CUGROUP WHERE CUS.GGUID='9252A7AF-0178-D9E1-5947-122982251' AND CUGROUP.COGUID=CUS.GGUID AND CUGROUP.KID=CUS.GROUPID AND CUS.ID NOT IN (SELECT CUSTOMERID FROM T_CUSTOMER_ASSIGN WHERE YG_GUID='5DB6A6BC-D713-D8B8-2617-B55DF262B55') AND CUS.KH_BELONG='1' ORDER BY ADDTIME DESC
bkybytgkvfcyc	select count(*) num, count(case when QDISNORMAL = '1' then QDISNORMAL else null end) kqqdRight, count(case when QDISNORMAL = '3' or QDISNORMAL = '2' then QDISNORMAL else null end) kqqdWrong, count(case when QTISNORMAL = '1' then QTISNORMAL else null end) kqqtRight, count(case offstate when 1 then offstate else null end) kqqtNo, count(case when QTISNORMAL='3' or QTISNORMAL='2' then QTISNORMAL else null end) kqqtWrong from t_kqdetail where (guid in ('E2387F14-323C-B5A2-5EA1-D91CE28EC79', '7A5B60D5-B7A9-1F71-A035-F5777423D57A', 'CF7137AE-C223-3783-82D3-B0BBACDF23E6', '3DCE3DEF-0F35-9645-C60F-72DFF5DB5E9', '213CDFA5-1C78-5C33-CB56-EAAD1A7778A', '2FB1F3DA-2526-302A-5055-18CD7E9B4845', '7370CFE8-89C8-7378-E6C4-A66FCE2F8B99', '8F4A5470-19DA-D8A7-842D-307FBEAFB8C9', '41838AFB-6871-BB38-CE15-6551DBDE4B', '10587427-8A36-3C1D-18D8-C1BFF775C5F', 'C14DFC90-C3B4-9D95-A16D-A1101514BE6F', 'AD22E44D-53BA-53A6-F8FE-832894C5DA', '69EE32F7-DE83-35AD-AA14-C7549A5CDA', 'EB7C15DE-174B-F43A-6AC5-A96A9658A33', '5A77471E-ACF2-B646-B618-38EC24BAD78', '8EA5DC15-BF7C-6E6B-99D3-AFEF3279B', '78BE4FE1-DB49-66AF-DA41-F399297FBD0', '5DE56C56-511D-249F-9186-18387D0230')) and workmode='1' and SIGNDAY='2013-06-27'
bxyf0qf0sy931	SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd hh24:mi:ss') ADDTIME, PROVINCE, CITY, COUNTY, CONTENT, DW_MODE FROM V_POSITION_GPSONE WHERE SUCESS=0 AND ADDTIME>=TO_DATE('2013-06-18 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND ZGUID='B28EDD24-749F-822E-87B2-6AE2465E869B' ORDER BY ADDTIME
c07c4vfxz35z0	SELECT LON, LAT FROM V_POSITION_GPSONE WHERE ID=:1
c19qz4566s2k3	select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='98EB2D74-677E-84FC-7E55-A5E46A2B94') and cus.kh_belong='1' order by cus.ADDTIME desc
c78r0nu1v3gn5	SELECT distinct TC.id, TC.all_name, TC.address, TC.linkman, TC.telephone, TC.short_name, TC.qy_type, TC.addtime, TC.lon, TC.lat, TC.kh_state, TC.kh_belong, TC.groupid, TC.link_sim, TC.clon, TC.clat FROM T_CUSTOMER TC, T_CUSTOMER_ASSIGN TCA WHERE TC.ID=TCA.CUSTOMERID AND TCA.YG_GUID=:1 AND TCA.GGUID=:2
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cpwvzptnn61df	select * from (select rownum as rn, tj.* from t_jhdw tj where nowstat='1' and substr(dwtel, 1, 3) in (134, 135, 136, 137, 138, 139, 147, 150, 151, 152, 157, 158, 159, 187, 188, 182)) where rn >=1001 and rn<2001
djfzjnvg07yx4	SELECT SJHM, ZDMC, TO_CHAR(ADDTIME, 'yyyy-MM-dd HH24:mi:ss') ADDTIME, LON, LAT, CONTENT, PROVINCE, CITY, COUNTY, DW_MODE, DW_TYPE, SUCESS FROM V_POSITION_GPSONE WHERE 1=1 and ADDTIME>=TO_DATE('2013-06-24 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND ADDTIME<=TO_DATE('2013-06-27 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND ZGUID='A74CC567-C6F7-C614-5B1D-770DE9B9932' ORDER BY ADDTIME ASC
dkfzha68m2y9z	select distinct cus.ID, cus.CUSTOMERID, cus.ALL_NAME, cus.KH_BELONG, cus.KH_STATE, cugroup.KHNAME, cus.ADDTIME from T_CUSTOMER cus, T_CUSTOMER_ASSIGN assign, T_CUSTOMER_GROUP cugroup where cus.GGUID='9252A7AF-0178-D9E1-5947-122982251' and cugroup.COGUID=cus.GGUID and cugroup.KID=cus.GROUPID and cus.id not in (select CUSTOMERID from T_CUSTOMER_ASSIGN where YG_GUID='1E7C9A19-8698-1733-18D3-64D1359B472') and cus.kh_belong='1' order by cus.ADDTIME desc
farr31080jj0u	select count(*) num, count(case when QDISNORMAL = '1' and onstate = 2 then onstate else null end) kqqdRight, count(case when onstate = 3 and QDISNORMAL = '1' then onstate else null end) zccd, count(case when onstate = 3 and (QDISNORMAL = '3' or QDISNORMAL = '2') then onstate else null end) fzccd, count(case onstate when 1 then onstate else null end) kqqdNo, count(case when (QDISNORMAL = '3' or QDISNORMAL = '2') and onstate = 2 then QDISNORMAL else null end) kqqdWrong, count(case when QTISNORMAL='1' and offstate=2 then offstate else null end) kqqtRight, count(case when offstate = 3 and QTISNORMAL = '1' then offstate else null end) zczt, count(case when offstate = 3 and (QTISNORMAL = '3' or QTISNORMAL = '2') then offstate else null end) fzczt, count(case offstate when 1 then offstate else null end) kqqtNo, count(case when (QTISNORMAL = '3' or QTISNORMAL = '2') and offstate=2 then QTISNORMAL else null end) kqqtWrong from t_kqdetail where (guid in ('653DD925-B4A5-BB12-68DA-E6B8BF04DCA', 'A9DD8C73-5B0B-7E0E-F536-2B6EC0FC', '4AAB13E0-23B7-42F2-5181-4F43DF8C985F', 'A6D0761A-CC8E-8C15-3491-7585288AE377', 'C95C6662-2927-C22D-6385-C8C83B328EF8', 'E84BBC10-92BB-10A9-7EF8-6F472D51166E', '94839F41-935C-D64B-B261-D2BE4FE3137B', '3FA549F0-255A-5785-0FA8-5C6162AF6A', '327AF688-4740-C5F2-EDA2-30C42B5BEE3', 'F937B12A-81F0-C732-52AD-21C4DBF3C35', '949E51C3-8BE8-5EDB-925F-52CB7CF6DC', 'AA86D26B-1894-7337-CBC1-9F324EF71D', 'CEA7581C-4158-AD2E-6EBB-9F6C3296764', '101A25DE-413C-E7CC-979E-144CE6228CA5', 'E1F5BA81-FE2B-9A24-5D31-1263DE7D64', 'B9F71698-DC13-3B21-4F1B-99B799E485C3', '936F8BB5-DAD5-C5FC-2B5B-AF53FC87C0', 'FB5A8D2B-BDD4-987B-EE48-B341EF0D65D', 'D37D4D83-24CE-51AF-42A4-C7E38086EF5', 'AD63B44F-E2D4-3AB3-54F0-17DD7B33CF1A', '62937CAA-F455-EBAB-AE76-C4B9D0D326A1', '61F75E4C-5609-F8AA-BFD3-214203258AC', '819911D2-9315-AD45-0609-F404F5572D2', '3CDF9AF7-D113-FB5F-94AF-70DF93E2DC', '567C79A1-85D1-6B62-A3A7-4D482BA08D8E', '2699E6DA-FAF4-497E-74D9-7CE32CEB33E', 'E97A3D90-65E6-D120-D81C-C1526E55268A', '842787B0-C939-41EA-FFC7-D9CCA7152CF', '229EBC77-1A82-FE06-64DB-A2CB7CB417F', '6D415293-68C7-BE59-7D72-0FCC564524B', '1B8DA7B1-3117-42A3-525C-EC54F8DDFB30', '50B2BD6D-10BF-33D3-E96F-EB13F82D5A0')) and workmode='2' and SIGNDAY='2013-06-20'
ftu2691pk5qfd	SELECT DISTINCT CUS.ID, CUS.CUSTOMERID, CUS.ALL_NAME, CUS.KH_BELONG, CUS.KH_STATE, CUGROUP.KHNAME, CUS.ADDTIME AS ADDTIME, CUS.CJRGUID FROM T_CUSTOMER CUS, T_CUSTOMER_ASSIGN ASSIGN, T_CUSTOMER_GROUP CUGROUP WHERE CUS.GGUID='9252A7AF-0178-D9E1-5947-122982251' AND CUGROUP.COGUID=CUS.GGUID AND CUGROUP.KID=CUS.GROUPID AND CUS.ID NOT IN (SELECT CUSTOMERID FROM T_CUSTOMER_ASSIGN WHERE YG_GUID='D6EC8890-2ADC-FDD9-1231-4A62FEF2B') AND CUS.KH_BELONG='1' ORDER BY ADDTIME DESC

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	61	0.01	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	681	0.11	0.01
Batched IO buffer defrag count	4	0.00	0.00
Batched IO double miss count	25	0.00	0.00
Batched IO same unit count	319	0.05	0.01
Batched IO single block count	41	0.01	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	316	0.05	0.01
Batched IO vector read count	41	0.01	0.00
Block Cleanout Optim referenced	2,299	0.39	0.04
CCursor + sql area evicted	450	0.08	0.01
CPU used by this session	644,534	108.47	10.76
CPU used when call started	638,811	107.50	10.67
CR blocks created	2,283	0.38	0.04
Cached Commit SCN referenced	150	0.03	0.00
Commit SCN cached	5,055	0.85	0.08
DB time	28,354,049	4,771.61	473.43
DBWR checkpoint buffers written	130,998	22.05	2.19
DBWR checkpoints	78	0.01	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	2,092	0.35	0.03
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	5,476	0.92	0.09
DBWR undo block writes	63,018	10.61	1.05
HSC Heap Segment Block Changes	268,316	45.15	4.48
Heap Segment Array Inserts	918	0.15	0.02
Heap Segment Array Updates	627	0.11	0.01
IMU CR rollbacks	145	0.02	0.00
IMU Flushes	84,599	14.24	1.41
IMU Redo allocation size	244,971,244	41,225.42	4,090.28
IMU commits	13,360	2.25	0.22
IMU contention	5,095	0.86	0.09
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	16,823	2.83	0.28
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	235,429,792	39,619.72	3,930.97
IMU- failed to get a private strand	16,823	2.83	0.28
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	915,050	153.99	15.28
OS Involuntary context switches	0	0.00	0.00
OS Maximum resident set size	0	0.00	0.00
OS Page faults	0	0.00	0.00
OS Page reclaims	0	0.00	0.00
OS System time used	0	0.00	0.00
OS User time used	0	0.00	0.00
OS Voluntary context switches	0	0.00	0.00
Requests to/from client	927,205	156.04	15.48
RowCR - row contention	0	0.00	0.00
RowCR attempts	155	0.03	0.00
RowCR hits	155	0.03	0.00
SMON posted for undo segment shrink	8	0.00	0.00
SQL*Net roundtrips to/from client	927,950	156.16	15.49
SQL*Net roundtrips to/from dblink	1,201	0.20	0.02
active txn count during cleanout	2,372,993	399.34	39.62
application wait time	179,158	30.15	2.99
background checkpoints completed	7	0.00	0.00
background checkpoints started	8	0.00	0.00
background timeouts	27,617	4.65	0.46
branch node splits	16	0.00	0.00
buffer is not pinned count	2,338,989	393.62	39.05
buffer is pinned count	1,964,590	330.61	32.80
bytes received via SQL*Net from client	84,082,224	14,149.93	1,403.92
bytes received via SQL*Net from dblink	3,005,602	505.80	50.18
bytes sent via SQL*Net to client	803,021,544	135,137.92	13,408.05
bytes sent via SQL*Net to dblink	194,490	32.73	3.25
calls to get snapshot scn: kcmgss	1,230,335	207.05	20.54
calls to kcmgas	176,745	29.74	2.95
calls to kcmgcs	450,067	75.74	7.51
cell physical IO interconnect bytes	245,124,733,440	41,251,254.95	4,092,847.56
change write time	5,863	0.99	0.10
cleanout - number of ktugct calls	201,010	33.83	3.36
cleanouts and rollbacks - consistent read gets	1,141	0.19	0.02
cleanouts only - consistent read gets	37,693	6.34	0.63
cluster key scan block gets	149,028	25.08	2.49
cluster key scans	138,878	23.37	2.32
commit batch performed	1	0.00	0.00
commit batch requested	1	0.00	0.00
commit batch/immediate performed	55,623	9.36	0.93
commit batch/immediate requested	55,623	9.36	0.93
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	105	0.02	0.00
commit cleanout failures: callback failure	2,103	0.35	0.04
commit cleanout failures: cannot pin	6,965	1.17	0.12
commit cleanouts	427,201	71.89	7.13
commit cleanouts successfully completed	418,028	70.35	6.98
commit immediate performed	55,622	9.36	0.93
commit immediate requested	55,622	9.36	0.93
commit txn count during cleanout	74,089	12.47	1.24
concurrency wait time	29,697,713	4,997.73	495.86
consistent changes	253,060	42.59	4.23
consistent gets	102,148,056	17,190.17	1,705.57
consistent gets - examination	3,708,587	624.11	61.92
consistent gets direct	29,125,892	4,901.50	486.32
consistent gets from cache	73,022,164	12,288.67	1,219.25
consistent gets from cache (fastpath)	68,660,771	11,554.70	1,146.43
cursor authentications	3,856	0.65	0.06
data blocks consistent reads - undo records applied	8,920	1.50	0.15
db block changes	2,808,054	472.56	46.89
db block gets	4,070,029	684.93	67.96
db block gets direct	263	0.04	0.00
db block gets from cache	4,069,766	684.89	67.95
db block gets from cache (fastpath)	1,041,627	175.29	17.39
deferred (CURRENT) block cleanout applications	111,021	18.68	1.85
dirty buffers inspected	3,640	0.61	0.06
enqueue conversions	3,936	0.66	0.07
enqueue releases	623,569	104.94	10.41
enqueue requests	625,987	105.35	10.45
enqueue timeouts	2,424	0.41	0.04
enqueue waits	69,788	11.74	1.17
exchange deadlocks	5,384	0.91	0.09
execute count	864,341	145.46	14.43
failed probes on index block reclamation	8	0.00	0.00
file io service time	318	0.05	0.01
file io wait time	7,638,191,957	1,285,406.82	127,534.89
frame signature mismatch	0	0.00	0.00
free buffer inspected	465,171	78.28	7.77
free buffer requested	490,455	82.54	8.19
heap block compress	18,085	3.04	0.30
hot buffers moved to head of LRU	560,553	94.33	9.36
immediate (CR) block cleanout applications	38,834	6.54	0.65
immediate (CURRENT) block cleanout applications	23,335	3.93	0.39
in call idle wait time	14,528,246	2,444.91	242.58
index crx upgrade (positioned)	18	0.00	0.00
index crx upgrade (prefetch)	1	0.00	0.00
index fast full scans (full)	150	0.03	0.00
index fetch by key	533,406	89.77	8.91
index scans kdiixs1	2,767,752	465.78	46.21
leaf node 90-10 splits	437	0.07	0.01
leaf node splits	2,109	0.35	0.04
lob reads	86,525	14.56	1.44
lob writes	70,205	11.81	1.17
lob writes unaligned	70,205	11.81	1.17
logical read bytes from cache	631,506,976,768	106,274,283.03	10,544,271.71
logons cumulative	30,851	5.19	0.52
max cf enq hold time	43,610	7.34	0.73
messages received	74,012	12.46	1.24
messages sent	74,012	12.46	1.24
min active SCN optimization applied on CR	716	0.12	0.01
no buffer to keep pinned count	9,639	1.62	0.16
no work - consistent read gets	97,871,284	16,470.44	1,634.16
non-idle wait count	7,930,458	1,334.59	132.41
non-idle wait time	48,104,838	8,095.41	803.21
opened cursors cumulative	856,539	144.14	14.30
parse count (describe)	8	0.00	0.00
parse count (failures)	19,538	3.29	0.33
parse count (hard)	32,382	5.45	0.54
parse count (total)	263,249	44.30	4.40
parse time cpu	10,723	1.80	0.18
parse time elapsed	5,204,417	875.83	86.90
physical read IO requests	1,260,418	212.11	21.05
physical read bytes	241,888,444,416	40,706,630.25	4,038,811.25
physical read total IO requests	1,271,058	213.90	21.22
physical read total bytes	242,566,862,336	40,820,799.03	4,050,138.79
physical read total multi block requests	915,746	154.11	15.29
physical reads	29,527,398	4,969.07	493.02
physical reads cache	361,337	60.81	6.03
physical reads cache prefetch	18,527	3.12	0.31
physical reads direct	29,166,061	4,908.26	486.99
physical reads direct (lob)	5	0.00	0.00
physical reads direct temporary tablespace	39,184	6.59	0.65
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	49,061	8.26	0.82
physical write bytes	1,483,898,880	249,720.58	24,776.66
physical write total IO requests	127,699	21.49	2.13
physical write total bytes	2,557,871,104	430,455.92	42,708.77
physical write total multi block requests	4,448	0.75	0.07
physical writes	181,140	30.48	3.02
physical writes direct	39,385	6.63	0.66
physical writes direct (lob)	12	0.00	0.00
physical writes direct temporary tablespace	39,123	6.58	0.65
physical writes from cache	141,755	23.86	2.37
physical writes non checkpoint	125,580	21.13	2.10
pinned buffers inspected	119	0.02	0.00
pinned cursors current	8	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	3	0.00	0.00
process last non-idle time	6,067	1.02	0.10
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	4,666,189	785.26	77.91
recursive cpu usage	38,318	6.45	0.64
redo KB read	487,819	82.09	8.15
redo blocks checksummed by FG (exclusive)	339,764	57.18	5.67
redo blocks written	929,568	156.43	15.52
redo buffer allocation retries	75	0.01	0.00
redo entries	1,038,950	174.84	17.35
redo log space requests	3,365	0.57	0.06
redo log space wait time	33,361	5.61	0.56
redo ordering marks	40,838	6.87	0.68
redo size	445,538,532	74,978.25	7,439.16
redo size for direct writes	2,155,868	362.80	36.00
redo subscn max counts	66,514	11.19	1.11
redo synch long waits	3,160	0.53	0.05
redo synch poll writes	5,212	0.88	0.09
redo synch polls	13,451	2.26	0.22
redo synch time	2,577,858	433.82	43.04
redo synch time (usec)	25,779,333,317	4,338,321.29	430,437.52
redo synch writes	59,481	10.01	0.99
redo wastage	15,051,992	2,533.05	251.32
redo write time	147,474	24.82	2.46
redo writes	69,607	11.71	1.16
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	331,986	55.87	5.54
rollbacks only - consistent read gets	1,775	0.30	0.03
root node splits	1	0.00	0.00
rows fetched via callback	225,143	37.89	3.76
scheduler wait time	0	0.00	0.00
session connect time	4,565	0.77	0.08
session cursor cache hits	627,923	105.67	10.48
session logical reads	106,217,934	17,875.08	1,773.52
shared hash latch upgrades - no wait	47,741	8.03	0.80
shared hash latch upgrades - wait	82	0.01	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	355,880	59.89	5.94
sorts (rows)	8,120,446	1,366.56	135.59
sql area evicted	17,106	2.88	0.29
sql area purged	51	0.01	0.00
summed dirty queue length	4,694	0.79	0.08
switch current to new buffer	3,020	0.51	0.05
table fetch by rowid	1,322,785	222.61	22.09
table fetch continued row	3,408	0.57	0.06
table scan blocks gotten	83,762,245	14,096.08	1,398.58
table scan rows gotten	5,297,231,460	891,454.09	88,447.87
table scans (direct read)	1,189	0.20	0.02
table scans (long tables)	1,140	0.19	0.02
table scans (short tables)	91,762	15.44	1.53
temp space allocated (bytes)	1,048,576	176.46	17.51
total cf enq hold time	185,100	31.15	3.09
total number of cf enq holders	284	0.05	0.00
total number of times SMON posted	44	0.01	0.00
transaction rollbacks	55,621	9.36	0.93
transaction tables consistent read rollbacks	2	0.00	0.00
transaction tables consistent reads - undo records applied	8	0.00	0.00
undo change vector size	138,884,100	23,372.36	2,318.95
user I/O wait time	1,923,425	323.69	32.12
user calls	1,225,133	206.17	20.46
user commits	59,887	10.08	1.00
user rollbacks	4	0.00	0.00
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	198,574	33.42	3.32
write clones created in background	5	0.00	0.00
write clones created in foreground	845	0.14	0.01

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
opened cursors current	300	334
workarea memory allocated	0	158
logons current	449	438
session uga memory max	1,150,778,040,864	1,164,240,195,856
session pga memory	32,331,644,096	32,597,024,384
session pga memory max	37,673,486,144	38,037,816,800
session cursor cache count	24,911,418	25,156,905
session uga memory	54,192,989,628,328	54,602,577,193,440

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)	8	4.85

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	222.5G	154.19	38.3424	0M	0.00	0M	916.3K	10.69
Buffer Cache Reads	2.8G	58.00	.475578	0M	0.00	0M	343.5K	18.42
Others	644M	1.77	.108376	568M	1.08	.095586	16.9K	46.97
DBWR	0M	0.00	0M	1.1G	8.04	.186461	3166	405.27
LGWR	2M	0.03	.000336	458M	12.26	.077075	140.7K	20.90
Direct Writes	0M	0.00	0M	308M	0.22	.051832	1285	16.88
Streams AQ	0M	0.00	0M	0M	0.00	0M	17	0.41
TOTAL:	225.9G	213.99	38.9267	2.4G	21.60	.410956	1421.9K	14.89

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	225G	212.02	38.7680	1.1G	8.06	.186966	18.48	10.64
Log File	476M	0.09	.080104	456M	12.24	.076738	14.10	119.44
Temp File	306M	0.21	.051495	305M	0.21	.051327	151.71	1.84
Archive Log	0M	0.00	0M	476M	0.08	.080104
Control File	170M	1.67	.028608	94M	1.01	.015818	12.48	360.56
Other	0M	0.00	0M	0M	0.01	0M	8.88
TOTAL:	225.9G	214.00	38.9282	2.4G	21.60	.410956	18.31	10.69

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	222.5G	154.19	38.3424	0M	0.00	0M	0
Direct Reads (Data File)	222.5G	154.19	38.3424	0M	0.00	0M	0
Buffer Cache Reads	2.8G	58.01	.475746	0M	0.00	0M	343.4K	18.34
Buffer Cache Reads (Data File)	2.8G	58.01	.475746	0M	0.00	0M	343.4K	18.34
Others	644M	1.76	.108376	568M	1.07	.095586	10.6K	17.36
Others (Archive Log)	0M	0.00	0M	476M	0.08	.080104	0
Others (Log File)	476M	0.09	.080104	0M	0.00	0M	523	109.87
Others (Control File)	166M	1.64	.027935	91M	0.98	.015314	9773	12.53
Others (Data File)	2M	0.03	.000336	1M	0.01	.000168	272	13.00
DBWR	0M	0.00	0M	1.1G	8.04	.186461	0
DBWR (Data File)	0M	0.00	0M	1.1G	8.04	.186461	0
LGWR	2M	0.03	.000336	459M	12.29	.077243	166	62.39
LGWR (Log File)	0M	0.00	0M	457M	12.26	.076907	32	88.13
LGWR (Control File)	2M	0.02	.000336	2M	0.03	.000336	134	56.24
Direct Writes	0M	0.00	0M	308M	0.22	.051832	0
Direct Writes (Data File)	0M	0.00	0M	308M	0.22	.051832	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	17	0.41
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	17	0.41
TOTAL:	225.9G	214.00	38.9269	2.4G	21.62	.411124	354.1K	18.33

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)
JQGJ20130111_DATA	1,245,092	210	4.47	23.64	32,376	5	415,082	62.46
UNDOTBS1	1,038	0	107.70	1.00	12,437	2	438	10.32
SYSTEM	6,762	1	67.11	1.78	156	0	2,042	729.66
SYSAUX	3,103	1	54.04	1.54	2,218	0	2	95.00
JQGJ20130111_TEMP	1,266	0	0.77	30.95	1,263	0	0	0.00
XNJT20111026_DATA	14	0	5.00	1.00	0	0	0	0.00
TEMP	4	0	22.50	1.00	9	0	0	0.00
JQGJ20130111_HIS	6	0	3.33	1.00	0	0	0	0.00
USERS	4	0	2.50	1.00	0	0	0	0.00
XNJT20111026_HIS	4	0	2.50	1.00	0	0	0	0.00
XNJT20111026_INFO	4	0	5.00	1.00	0	0	0	0.00
XNJT20111026_TEMP	1	0	10.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)
JQGJ20130111_DATA	/opt/oracle/oradata/jqgj/JQGJ20130111_DATA	361,041	61	6.01	25.35	13,033	2	131,220	122.94
JQGJ20130111_DATA	/opt/oracle/oradata/jqgj/JQGJ20130111_DATA1.dbf	388,059	65	3.03	25.06	8,299	1	96,666	48.43
JQGJ20130111_DATA	/opt/oracle/oradata/jqgj/JQGJ20130111_DATA2.dbf	386,285	65	2.92	25.21	6,597	1	93,003	43.19
JQGJ20130111_DATA	/opt/oracle/oradata/jqgj/JQGJ20130111_DATA3.dbf	109,707	18	9.99	7.50	4,447	1	94,193	11.63
JQGJ20130111_HIS	/opt/oracle/oradata/jqgj/JQGJ20130111_HIS.dbf	6	0	3.33	1.00	0	0	0	0.00
JQGJ20130111_TEMP	/opt/oracle/oradata/jqgj/JQGJ20130111_TEMP.dbf	1,266	0	0.77	30.95	1,263	0	0
SYSAUX	/opt/oracle/oradata/xnjt/sysaux01.dbf	3,103	1	54.04	1.54	2,218	0	2	95.00
SYSTEM	/opt/oracle/oradata/xnjt/system01.dbf	6,762	1	67.11	1.78	156	0	2,042	729.66
TEMP	/opt/oracle/oradata/xnjt/temp01.dbf	4	0	22.50	1.00	9	0	0
UNDOTBS1	/opt/oracle/oradata/xnjt/undotbs01.dbf	1,038	0	107.70	1.00	12,437	2	438	10.32
USERS	/opt/oracle/oradata/xnjt/users01.dbf	4	0	2.50	1.00	0	0	0	0.00
XNJT20111026_DATA	/opt/oracle/oradata/xnjt/XNJT20111026_DATA.dbf	14	0	5.00	1.00	0	0	0	0.00
XNJT20111026_HIS	/opt/oracle/oradata/xnjt/XNJT20111026_HIS.dbf	4	0	2.50	1.00	0	0	0	0.00
XNJT20111026_INFO	/opt/oracle/oradata/xnjt/XNJT20111026_INFO.dbf	4	0	5.00	1.00	0	0	0	0.00
XNJT20111026_TEMP	/opt/oracle/oradata/xnjt/XNJT20111026_TEMP.dbf	1	0	10.00	1.00	0	0	0

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	243,303	100	76,996,590	361,012	141,604	0	0	418,688

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 181,140

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	128,906	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	18	4563	23545	320487	580608	320487
E	0	25	14409	118106	337717	580608	337717

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	192	0.09	24	1.32	3,264,585	1	798041.00
D	384	0.19	47	1.27	3,143,934	1	726440.00
D	576	0.28	71	1.22	3,037,329	1	663175.00
D	768	0.38	95	1.19	2,944,213	1	607916.00
D	960	0.47	118	1.15	2,861,611	1	558895.00
D	1,152	0.56	142	1.12	2,786,706	1	514443.00
D	1,344	0.66	166	1.10	2,716,652	1	472870.00
D	1,536	0.75	189	1.07	2,649,151	1	432811.00
D	1,728	0.84	213	1.04	2,583,215	1	393681.00
D	1,920	0.94	237	1.02	2,519,997	1	356165.00
D	2,048	1.00	252	1.00	2,480,911	1	332969.00
D	2,112	1.03	260	0.99	2,466,871	1	324637.00
D	2,304	1.13	284	0.98	2,441,862	1	309795.00
D	2,496	1.22	307	0.98	2,423,858	1	299111.00
D	2,688	1.31	331	0.97	2,407,203	1	289227.00
D	2,880	1.41	355	0.96	2,390,412	1	279262.00
D	3,072	1.50	378	0.96	2,372,851	1	268840.00
D	3,264	1.59	402	0.95	2,354,182	1	257761.00
D	3,456	1.69	426	0.94	2,334,607	1	246144.00
D	3,648	1.78	449	0.93	2,314,614	1	234280.00
D	3,840	1.88	473	0.92	2,294,532	1	222362.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
91.79	4,440	397

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	1,200	603	762.99	0.00	0.00	0.00	0.00	122,880
E	1,200	410	805.66	1.44	0.18	100.00	0.00	122,880

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	195,439	195,439	0
64K	128K	156	156	0
128K	256K	74	74	0
256K	512K	52	52	0
512K	1024K	2,111	2,111	0
1M	2M	402	402	0
2M	4M	171	171	0
4M	8M	16	16	0
8M	16M	96	96	0
64M	128M	1	1	0
128M	256M	2	0	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
150	0.13	168,008.32	81,151.13	67.00	3,888	128,198,244
300	0.25	168,008.32	81,151.13	67.00	3,888	128,198,244
600	0.50	168,008.32	48,628.10	78.00	296	111,464,404
900	0.75	168,008.32	13,948.92	92.00	82	93,621,172
1,200	1.00	168,008.32	12,619.50	93.00	4	92,937,153
1,440	1.20	168,008.32	12,619.50	93.00	0	92,937,153
1,680	1.40	168,008.32	12,619.50	93.00	0	92,937,153
1,920	1.60	168,008.32	12,619.50	93.00	0	92,937,153
2,160	1.80	168,008.32	12,619.50	93.00	0	92,937,153
2,400	2.00	168,008.32	12,619.50	93.00	0	92,937,153
3,600	3.00	168,008.32	12,619.50	93.00	0	92,937,153
4,800	4.00	168,008.32	12,619.50	93.00	0	92,937,153
7,200	6.00	168,008.32	12,619.50	93.00	0	92,937,153
9,600	8.00	168,008.32	12,619.50	93.00	0	92,937,153

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
1,472	1.00	140	9,791	13,961,389	1.00	163,903	1.00	111,356
1,488	1.01	156	10,497	13,961,526	1.00	163,766	1.00	111,361
1,504	1.02	171	11,321	13,961,626	1.00	163,666	1.00	111,368
1,520	1.03	187	12,228	13,961,862	1.00	163,430	1.00	111,406
1,536	1.04	202	13,477	13,962,082	1.00	163,210	1.00	111,426
1,552	1.05	218	14,953	13,962,224	1.00	163,068	0.99	111,443
1,568	1.07	234	16,175	13,962,342	1.00	162,950	0.99	111,459
1,584	1.08	250	17,611	13,962,808	1.00	162,484	0.99	111,560
1,600	1.09	266	18,932	13,963,098	1.00	162,194	0.99	111,599
1,616	1.10	282	20,433	13,963,249	1.00	162,043	0.99	111,629
1,632	1.11	298	21,852	13,963,466	1.00	161,826	0.99	111,668
1,792	1.22	457	29,928	13,963,915	1.00	161,377	0.98	111,846
1,952	1.33	616	38,519	13,963,997	1.00	161,295	0.98	111,861
2,112	1.43	776	45,014	13,964,064	1.00	161,228	0.98	111,870
2,272	1.54	936	51,257	13,964,130	1.00	161,162	0.98	111,880
2,432	1.65	1,095	58,383	13,964,204	1.00	161,088	0.98	111,903
2,592	1.76	1,255	67,755	13,964,229	1.00	161,063	0.98	111,907
2,752	1.87	1,415	73,927	13,964,252	1.00	161,040	0.98	111,912
2,912	1.98	1,574	80,841	13,964,299	1.00	160,993	0.98	111,918
3,072	2.09	1,733	89,315	13,964,321	1.00	160,971	0.98	111,923

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,800	0.50	2,640,122	3,283,235,810
2,700	0.75	2,355,628	2,802,683,614
3,600	1.00	2,165,099	2,480,909,634
4,500	1.25	2,109,023	2,386,386,977
5,400	1.50	2,060,741	2,307,494,051
6,300	1.75	2,060,092	2,307,494,051
7,200	2.00	2,059,875	2,307,494,051

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	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	417,230	27,366	66
system undo header	352	81	230
segment header	532	6	11
undo header	361	4	10
1st level bmb	31	1	32
undo block	84	1	10
2nd level bmb	19	0	23

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (index contention)	53,068	53,068	0	53,030	46,831	883.10
SQ-Sequence Cache	20,979	20,979	0	13,708	26,311	1,919.38
TX-Transaction (allocate ITL entry)	3,106	707	2,400	2,754	2,592	941.33
TX-Transaction (row lock contention)	199	199	0	195	1,039	5,327.44
KO-Multiple Object Checkpoint (fast object checkpoint)	719	719	0	70	522	7,462.71
TH-Threshold Chain (metric threshold evaluation)	227	227	0	2	138	68,900.00
PR-Process Startup	195	195	0	1	64	64,390.00
CF-Controlfile Transaction	2,505	2,494	11	1	11	11,490.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	57.08	116,072	2,418	461	29.1/54	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
27-Jun 17:57	1,466	3,295	2,075	5	47	0/0	0/0/0/0/0/0
27-Jun 17:47	4,015	8,502	2,281	114	51	0/0	0/0/0/0/0/0
27-Jun 17:37	10,043	19,002	1,678	461	41	0/0	0/0/0/0/0/0
27-Jun 17:27	3,760	8,341	1,010	63	30	0/0	0/0/0/0/0/0
27-Jun 17:17	1,208	3,096	2,418	92	54	0/0	0/0/0/0/0/0
27-Jun 17:07	8,254	16,661	967	52	29	0/0	0/0/0/0/0/0
27-Jun 16:57	2,504	5,571	1,047	8	30	0/0	0/0/0/0/0/0
27-Jun 16:47	3,909	7,841	967	6	29	0/0	0/0/0/0/0/0
27-Jun 16:37	19,459	38,982	2,120	21	49	0/0	0/0/0/0/0/0
27-Jun 16:27	2,463	4,781	967	4	30	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	8	0.00		0	0
ASM db client latch	3,949	0.00		0	0
ASM map operation hash table	8	0.00		0	0
ASM network state latch	169	0.00		0	0
AWR Alerted Metric Element list	76,124	0.00		0	0
Change Notification Hash table latch	1,629	0.00		0	0
Consistent RBA	69,188	0.00		0	0
DML lock allocation	518,610	0.06	0.81	72	0
Event Group Locks	61,491	0.00	0.00	0	0
FAL Queue	179	0.00		0	0
FIB s.o chain latch	84	1.19	0.00	0	0
FOB s.o list latch	27,014	0.35	0.95	21	0
File State Object Pool Parent Latch	8	0.00		0	0
I/O Staticstics latch	8	0.00		0	0
IPC stats buffer allocation latch	8	0.00		0	0
In memory undo latch	1,544,553	0.27	0.40	86	115,400	0.37
JS Sh mem access	18	5.56	1.00	0	0
JS mem alloc latch	19	0.00		0	0
JS queue access latch	27	0.00		0	0
JS queue state obj latch	35,096	0.00		0	0
JS slv state obj latch	326	0.31	1.00	1	0
KFC FX Hash Latch	8	0.00		0	0
KFC Hash Latch	8	0.00		0	0
KFCL LE Freelist	8	0.00		0	0
KGNFS-NFS:SHM structure	8	0.00		0	0
KGNFS-NFS:SVR LIST	8	0.00		0	0
KJC message pool free list	8	0.00		0	0
KJCT flow control latch	8	0.00		0	0
KMG MMAN ready and startup request latch	2,785	0.00		0	0
KMG resize request state object freelist	9	0.00		0	0
KTF sga latch	31	0.00		0	1,872	0.00
KWQMN job cache list latch	24	0.00		0	0
KWQP Prop Status	16	0.00		0	0
KWQS pqsubs latch	30	0.00		0	0
KWQS pqueue ctx latch	195	0.00		0	0
Locator state objects pool parent latch	8	0.00		0	0
Lsod array latch	8	0.00		0	0
MQL Tracking Latch	0			0	120	0.00
Memory Management Latch	1,105	0.00		0	2,785	0.00
Memory Queue	8	0.00		0	0
Memory Queue Message Subscriber #1	8	0.00		0	0
Memory Queue Message Subscriber #2	8	0.00		0	0
Memory Queue Message Subscriber #3	8	0.00		0	0
Memory Queue Message Subscriber #4	8	0.00		0	0
Memory Queue Subscriber	8	0.00		0	0
MinActiveScn Latch	62	0.00		0	0
Mutex	8	0.00		0	0
Mutex Stats	8	0.00		0	0
OS process	123,448	0.00		0	0
OS process allocation	73,926	0.37	1.26	1203	0
OS process: request allocation	61,288	0.36	0.90	161	0
PL/SQL warning settings	85,772	0.05	0.00	0	0
PX hash array latch	8	0.00		0	0
QMT	8	0.00		0	0
Real-time plan statistics latch	12,154	0.02	0.00	0	0
Reserved Space Latch	32	0.00		0	0
SGA IO buffer pool latch	16	0.00		0	16	0.00
SGA blob parent	8	0.00		0	0
SGA bucket locks	8	0.00		0	0
SGA heap locks	8	0.00		0	0
SGA pool locks	8	0.00		0	0
SQL memory manager latch	8	0.00		0	1,903	0.00
SQL memory manager workarea list latch	1,235,302	0.00	0.05	0	0
Shared B-Tree	643	0.00		0	0
Streams Generic	8	0.00		0	0
Testing	8	0.00		0	0
Token Manager	8	0.00		0	0
WCR: sync	8	0.00		0	0
Write State Object Pool Parent Latch	8	0.00		0	0
X$KSFQP	9,160	0.00		0	0
XDB NFS Security Latch	8	0.00		0	0
XDB unused session pool	8	0.00		0	0
XDB used session pool	8	0.00		0	0
active checkpoint queue latch	5,106	0.00		0	0
active service list	191,565	0.08	0.16	0	125,191	0.01
alert log latch	16	0.00		0	0
archive control	125	0.00		0	0
archive process latch	547	0.55	1.00	0	0
begin backup scn array	22	0.00		0	0
buffer pool	330	0.00		0	0
business card	8	0.00		0	0
cache buffer handles	1,005	4.88	1.02	6	0
cache buffers chains	157,931,744	1.28	0.00	584	1,246,743	0.06
cache buffers lru chain	176,418	0.01	0.42	1	1,045,264	0.05
cache table scan latch	3,823	0.00		0	3,823	0.00
call allocation	96,204	1.38	0.76	26446	0
cas latch	8	0.00		0	0
change notification client cache latch	8	0.00		0	0
channel handle pool latch	61,439	0.74	0.88	61	0
channel operations parent latch	119,410	0.02	0.31	1	0
checkpoint queue latch	541,502	0.00	0.83	0	164,115	0.01
client/application info	177,108	0.00		0	0
compile environment latch	30,782	0.00		0	0
corrupted undo seg latch	1,048,033	0.05	0.00	0	0
cp cmon/server latch	8	0.00		0	0
cp pool latch	8	0.00		0	0
cp server hash latch	8	0.00		0	0
cp sga latch	169	0.00		0	0
cvmap freelist lock	8	0.00		0	0
deferred cleanup latch	169	0.00		0	0
dml lock allocation	169	0.00		0	0
done queue latch	8	0.00		0	0
dummy allocation	61,456	0.37	0.70	22	0
enqueue freelist latch	8	0.00		0	367,525	0.04
enqueue hash chains	1,342,504	3.60	0.02	52	25,600	0.66
enqueues	616	28.08	1.02	57	0
fifth spare latch	8	0.00		0	0
file cache latch	759	0.00		0	0
flashback copy	8	0.00		0	0
fourth Audit Vault latch	8	0.00		0	0
gc element	8	0.00		0	0
gcs commit scn state	8	0.00		0	0
gcs partitioned table hash	8	0.00		0	0
gcs pcm hashed value bucket hash	8	0.00		0	0
gcs resource freelist	8	0.00		0	0
gcs resource hash	8	0.00		0	0
gcs resource scan list	8	0.00		0	0
gcs shadows freelist	8	0.00		0	0
ges domain table	8	0.00		0	0
ges enqueue table freelist	8	0.00		0	0
ges group table	8	0.00		0	0
ges process hash list	8	0.00		0	0
ges process parent latch	8	0.00		0	0
ges resource hash list	8	0.00		0	0
ges resource scan list	8	0.00		0	0
ges resource table freelist	8	0.00		0	0
ges value block free list	8	0.00		0	0
global KZLD latch for mem in SGA	29,367	0.00		0	0
global tx hash mapping	106	0.00		0	0
granule operation	8	0.00		0	0
hash table column usage latch	1,332	0.00		0	832,588	0.00
hash table modification latch	71	0.00		0	0
heartbeat check	8	0.00		0	0
internal temp table object number allocation latch	40	0.00		0	0
interrupt manipulation	12	0.00		0	0
intra txn parallel recovery	8	0.00		0	0
io pool granule metadata list	8	0.00		0	0
job workq parent latch	103	0.00		0	95	1.05
job_queue_processes free list latch	200	0.00		0	0
job_queue_processes parameter latch	1,143	0.00		0	0
k2q lock allocation	8	0.00		0	0
kcbtsemkid latch	8	0.00		0	0
kdlx hb parent latch	8	0.00		0	0
kgb parent	8	0.00		0	0
kgnfs mount latch	8	0.00		0	0
kokc descriptor allocation latch	550	0.00		0	0
ksfv messages	8	0.00		0	0
ksim group membership cache	8	0.00		0	0
kss move lock	78	0.00		0	0
ksuosstats global area	622	0.00		0	0
ksv allocation latch	308	0.00		0	0
ksv class latch	146	0.00		0	0
ksv msg queue latch	8	0.00		0	0
ksz_so allocation latch	61,288	0.36	0.74	922	0
ktm global data	225	0.00		0	0
kwqbsn:qsga	232	0.00		0	0
lgwr LWN SCN	69,337	0.00	0.00	0	0
list of block allocation	18,900	2.98	1.01	124	0
loader state object freelist	2,437	0.29	0.00	0	0
lob segment dispenser latch	8	0.00		0	0
lob segment hash table latch	28	0.00		0	0
lob segment query latch	8	0.00		0	0
lock DBA buffer during media recovery	8	0.00		0	0
logical standby cache	8	0.00		0	0
logminer context allocation	16	0.00		0	0
logminer work area	8	0.00		0	0
longop free list parent	682	0.00		0	208	0.96
managed standby latch	169	0.00		0	0
mapped buffers lru chain	8	0.00		0	0
message pool operations parent latch	248	4.44	1.00	0	0
messages	304,251	0.07	0.29	1	0
mostly latch-free SCN	70,001	0.12	0.00	0	0
msg queue latch	8	0.00		0	0
multiblock read objects	16,447	0.00		0	0
name-service namespace bucket	8	0.00		0	0
ncodef allocation latch	169	0.00		0	0
object queue header heap	40,723	0.00		0	2,880	0.00
object queue header operation	1,443,184	0.01	0.33	3	15,220	0.00
object stats modification	73	0.00		0	1	0.00
parallel query alloc buffer	792	0.00		0	0
parallel query stats	8	0.00		0	0
parameter list	1,577	0.00		0	0
parameter table management	120,801	2.38	1.10	102916	0
peshm	8	0.00		0	0
pesom_free_list	8	0.00		0	0
pesom_hash_node	8	0.00		0	0
post/wait queue	320,320	1.35	0.01	0	306,449	1.10
process allocation	61,479	2.51	99.50	1253	30,638	0.20
process group creation	61,284	0.04	0.32	0	0
process queue	8	0.00		0	0
process queue reference	8	0.00		0	0
qmn task queue latch	879	0.00		0	0
query server freelists	8	0.00		0	0
queued dump request	20	0.00		0	0
queuing load statistics	8	0.00		0	0
recovery domain hash list	8	0.00		0	0
redo allocation	418,714	0.14	0.29	7	1,034,546	0.57
redo copy	13	30.77	1.00	1	1,035,728	0.63
redo writing	222,116	0.05	0.05	0	0
reservation so alloc latch	16	0.00		0	0
resmgr group change latch	29,557	0.00		0	0
resmgr:active threads	61,456	0.00		0	0
resmgr:actses change group	29,506	0.00		0	0
resmgr:actses change state	8	0.00		0	0
resmgr:free threads list	61,443	1.37	0.88	140	0
resmgr:plan CPU method	8	0.00		0	0
resmgr:resource group CPU method	8	0.00		0	0
resmgr:schema config	648	0.00		0	0
resmgr:session queuing	8	0.00		0	0
rm cas latch	8	0.00		0	0
row cache objects	11,181,817	0.31	0.11	9104	2,892	18.36
rules engine aggregate statistics	14	0.00		0	0
rules engine rule set statistics	828	0.00		0	0
second Audit Vault latch	8	0.00		0	0
second spare latch	8	0.00		0	0
sequence cache	577,840	0.09	0.09	15	0
session allocation	306,631	0.03	0.56	180	245,218	0.14
session idle bit	2,659,979	0.00	0.00	0	0
session queue latch	8	0.00		0	0
session state list latch	61,681	0.19	0.08	5	0
session switching	30,759	0.77	0.93	17	8	0.00
session timer	2,043	0.00		0	0
shared pool	2,917,186	2.54	0.69	266771	0
shared pool sim alloc	8	0.00		0	0
shared pool simulator	89,962	0.12	1.00	12	0
sim partition latch	8	0.00		0	0
simulator hash latch	4,911,199	0.00	0.05	0	0
simulator lru latch	82,198	0.05	0.08	0	4,812,434	2.05
sort extent pool	658	0.00		0	0
space background state object latch	30	0.00		0	0
space background task latch	9,818	0.46	0.00	0	4,053	0.00
state object free list	16	0.00		0	0
statistics aggregation	4,480	0.00		0	0
tablespace key chain	8	0.00		0	0
temp lob duration state obj allocation	5	0.00		0	0
temporary table state object allocation	2	0.00		0	0
test excl. parent l0	8	0.00		0	0
test excl. parent2 l0	8	0.00		0	0
third spare latch	8	0.00		0	0
threshold alerts latch	321	0.00		0	0
trace latch	83	19.28	1.00	221	0
transaction allocation	21,243	2.17	1.00	342	0
transaction branch allocation	2,135	0.00		0	0
undo global data	3,234,091	0.02	0.02	0	11	0.00
virtual circuit buffers	8	0.00		0	0
virtual circuit holder	8	0.00		0	0
virtual circuit queues	8	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	157,931,744	2,029,374	6,207	2,025,962
shared pool	2,917,186	74,220	51,374	29,080
enqueue hash chains	1,342,504	48,270	1,003	47,330
row cache objects	11,181,817	34,873	3,666	31,360
post/wait queue	320,320	4,333	32	4,301
In memory undo latch	1,544,553	4,166	1,672	2,544
parameter table management	120,801	2,879	3,158	66
process allocation	61,479	1,542	153,424	70
call allocation	96,204	1,326	1,009	346
resmgr:free threads list	61,443	844	746	104
undo global data	3,234,091	798	17	782
redo allocation	418,714	579	169	419
corrupted undo seg latch	1,048,033	572	1	571
list of block allocation	18,900	563	570	3
sequence cache	577,840	519	48	471
transaction allocation	21,243	461	459	10
channel handle pool latch	61,439	452	400	52
DML lock allocation	518,610	324	264	90
OS process allocation	73,926	272	343	20
session switching	30,759	238	221	18
dummy allocation	61,456	229	160	76
messages	304,251	224	64	160
OS process: request allocation	61,288	220	197	24
ksz_so allocation latch	61,288	220	162	58
enqueues	616	173	176	0
object queue header operation	1,443,184	168	56	115
active service list	191,565	162	26	136
session state list latch	61,681	116	9	107
redo writing	222,116	111	6	105
shared pool simulator	89,962	105	105	0
FOB s.o list latch	27,014	94	89	13
session allocation	306,631	90	50	40
simulator hash latch	4,911,199	61	3	58
cache buffer handles	1,005	49	50	1
SQL memory manager workarea list latch	1,235,302	39	2	37
simulator lru latch	82,198	38	3	35
channel operations parent latch	119,410	26	8	18
process group creation	61,284	22	7	15
cache buffers lru chain	176,418	19	8	11
trace latch	83	16	16	0
checkpoint queue latch	541,502	12	10	3
message pool operations parent latch	248	11	11	0
redo copy	13	4	4	0
archive process latch	547	3	3	0
JS Sh mem access	18	1	1	0
JS slv state obj latch	326	1	1	0

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
DML lock allocation	ktaiam	183	88
DML lock allocation	ktaidm	81	176
FOB s.o list latch	ksfd_allfob	88	88
FOB s.o list latch	ksfd_fobd	1	1
In memory undo latch	ktiFlush: child	1,416	943
In memory undo latch	ktiFlushMe	154	333
In memory undo latch	ktichg: child	92	352
In memory undo latch	kticmt: child	87	119
In memory undo latch	ktiBRacquire	7	0
JS Sh mem access	jsksGetShMemLatch	1	1
JS slv state obj latch	jslvStateObjCreate	1	1
OS process allocation	kso_new_process:2	292	197
OS process allocation	kso_delete_process:1	44	136
OS process allocation	ksosp_scrub:1	5	0
OS process allocation	ksoreq_submit	1	1
OS process allocation	ksosp_forknew	1	9
OS process: request allocation	kso_new_process	167	165
OS process: request allocation	ksoreqholder_delete	30	32
SQL memory manager workarea list latch	qesmmIRegisterWorkArea:2	2	0
active service list	kswslogon: session logout	23	11
active service list	kswsgsnp: get service name ptr	7	14
active service list	kswsclstabc: scan list to return rows	4	2
archive process latch	kcrrsarc	3	0
cache buffer handles	kcbzgs	50	50
cache buffers chains	kcbgtcr: fast path (cr pin)	1,853	3,402
cache buffers chains	kcbgtcr_2	1,298	278
cache buffers chains	kcbchg1: mod cr pin	1,148	55
cache buffers chains	kcbget: fast path	908	346
cache buffers chains	kcbgcur_2	585	959
cache buffers chains	kcbget: fast exchange	281	286
cache buffers chains	kcbgtcr: fast path	134	73
cache buffers chains	kcbzwb	84	226
cache buffers chains	kcbgcur_4	52	18
cache buffers chains	kcbrls_2	36	92
cache buffers chains	kcbgtcr: kslbegin excl	34	70
cache buffers chains	kcbzib: finish processing buffer	33	12
cache buffers chains	kcbesc: escalate	19	133
cache buffers chains	kcbrls: fast release	19	71
cache buffers chains	kcbget: pin buffer	16	27
cache buffers chains	kcbnew: new latch again	11	1
cache buffers chains	kcb_post_apply: kcbhq62	7	0
cache buffers chains	kcbbxsv	7	0
cache buffers chains	kcbchg1: aux pin	6	16
cache buffers chains	kcbget: upgrade latch	6	5
cache buffers chains	kcbnlc	6	37
cache buffers chains	kcbzpbuf	5	11
cache buffers chains	kcbget: release excl	3	94
cache buffers chains	kcbrls_1	3	4
cache buffers chains	kcbchg1: mod cur pin	2	34
cache buffers chains	kcbzgb: scan from tail. nowait	2	0
cache buffers chains	kcbchg1: clear MS bit	1	12
cache buffers chains	kcbwxb	1	4
cache buffers lru chain	kcbzgws	8	0
call allocation	ksucrp: top call	435	454
call allocation	ksuxds	357	326
call allocation	ksudlp: top call	197	209
call allocation	ksuprc	16	14
call allocation	ksudlc : rec call	4	6
channel handle pool latch	ksrchconnect()	400	392
channel handle pool latch	ksrchdelete()	1	9
channel operations parent latch	ksrchdelete_sub()	8	5
checkpoint queue latch	kcbk_ncv_check	6	0
checkpoint queue latch	kcbkubc_4	4	5
corrupted undo seg latch	ktudiscorrupted	1	1
dummy allocation	ktcscnfy	155	155
dummy allocation	ktcdod	5	5
enqueue hash chains	ksqrcl	558	214
enqueue hash chains	ksqgtl3	297	455
enqueue hash chains	ksqcmi: get hash chain latch after wait	96	305
enqueue hash chains	ksqcmi: kslgpl	42	21
enqueue hash chains	ksqcmi: if deadlock detected	10	8
enqueues	ksqgel: create enqueue	171	170
enqueues	ksqgtl2	5	6
ksz_so allocation latch	ksznfy1	106	106
ksz_so allocation latch	ksz_parent_so_del1	56	56
list of block allocation	ktlabl	402	390
list of block allocation	ktcdod	164	167
list of block allocation	ktlbbl	4	13
message pool operations parent latch	ksrmalloc()	11	8
messages	ksaamb: after wakeup	48	32
messages	ksarcv	9	14
messages	ksarcv: after wait	5	13
messages	ksaclr	2	5
object queue header operation	kcbo_switch_cq	16	29
object queue header operation	kcbo_unlink_q	16	12
object queue header operation	kcbo_link_q	11	0
object queue header operation	kcbo_switch_q_bg	10	8
object queue header operation	kcbo_lbufcnt	2	2
object queue header operation	kcbo_link_q:reget	1	0
parameter table management	ksp_param_table_free	2,022	1,180
parameter table management	kspcpy	1,136	1,042
parameter table management	kspallmod	1	1
post/wait queue	ksliwat:remove	18	32
post/wait queue	ksliwat:add:nowait	12	0
post/wait queue	kslpstevent:reget	2	0
process allocation	ksuapc	151,750	139,817
process allocation	ksucrp:1	1,334	0
process allocation	ksudlp	137	13,434
process group creation	ksupgpadd	7	7
redo allocation	kcrfw_redo_gen: redo allocation 1	115	0
redo allocation	kcrfw_redo_gen: redo allocation 3	41	115
redo allocation	kcrfw_redo_gen: redo allocation 2	10	0
redo allocation	kcrfw_redo_write: before write	2	19
redo allocation	kcrfw_post: more space	1	35
redo copy	kcrfw_redo_gen: nowait	3	0
redo copy	kcrfw_redo_gen: wait	1	4
redo writing	kcrfws: in loop	5	7
redo writing	kcrfwnf: new logfile	1	0
resmgr:free threads list	kskthrsod	446	440
resmgr:free threads list	kskthrcreate	300	306
row cache objects	kqreqd: reget	2,392	6
row cache objects	kqrpre: find obj	540	2,852
row cache objects	kqreqd	93	157
row cache objects	kqrso	81	32
row cache objects	kqrcmt: while loop	55	33
row cache objects	kqrpre: init complete	16	44
row cache objects	kqrsrd	1	33
sequence cache	kdnssd	22	0
sequence cache	kdnnxt: cached seq	19	0
sequence cache	kdnss	7	48
session allocation	ksucri_int : SSO	29	35
session allocation	kspallmod	11	0
session allocation	ksuxds	8	13
session allocation	ksucri_int : licensing	2	2
session state list latch	kpseqd	7	0
session state list latch	kpseqa	2	9
session switching	kskexeall	221	221
shared pool	kghalo	33,707	33,458
shared pool	kghfre	10,030	10,343
shared pool	kghupr1	4,095	4,473
shared pool	kghalp	2,556	2,453
shared pool	kghfrunp: clatch: wait	314	513
shared pool	kghfrunp: alloc: wait	313	297
shared pool	kgh_heap_sizes	288	112
shared pool	kghasp	191	125
shared pool	kghfrunp: clatch: nowait	174	0
shared pool	kgh: add to quiesced list check	79	40
shared pool	kgh: quiesce pick heap	48	1
shared pool	kgh_next_free	35	40
shared pool	kghfree_extents: scan	10	28
shared pool	kghquiesce_extent choose ds	10	0
shared pool	kghfrh	4	0
shared pool	kghquiesce_extent quiesced if free	4	2
shared pool	kgh: add extent to quiesced list	2	0
shared pool	kghcasp	1	1
shared pool simulator	kglsim_upd_newhp	103	59
shared pool simulator	kglsim_chg_simhp_free	1	9
shared pool simulator	kglsim_chg_simhp_noob	1	36
simulator hash latch	kcbsacc: lookup dba	3	3
simulator lru latch	kcbs_simulate: simulate set	2	0
simulator lru latch	kcbs_dump_adv_state	1	0
trace latch	kstipg	16	16
transaction allocation	ktcxbr	356	352
transaction allocation	ktcdod	99	99
transaction allocation	ktiNonImuPoolAllocate	2	0
transaction allocation	ktcccDeleteCommitCallbacks_2	1	0
transaction allocation	ktcdso	1	8
undo global data	ktudba: KSLBEGIN	9	6
undo global data	ktudnx:child	3	4
undo global data	ktufrbs_2	2	4
undo global data	ktusmupst: KSLBEGIN	2	3
undo global data	ktusmst2f: KSLBEGIN	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Cursor Pin	kkslce [KKSCHLPIN2]	3,219,234
Library Cache	kglhdgn2 106	2,479,833
Library Cache	kgllkdl1 85	758,449
Library Cache	kglpin1 4	222,023
Library Cache	kglhdgh1 64	59,341
Library Cache	kgllkc1 57	44,476
Library Cache	kglhdgn1 62	41,193
Library Cache	kglpndl1 95	32,436
Library Cache	kglget2 2	17,984
Library Cache	kglpnal1 90	15,177
Cursor Pin	kksfbc [KKSCHLFSP2]	8,860
Library Cache	kglget1 1	8,140
Library Cache	kglati1 45	6,854
Library Cache	kglllal3 111	5,886
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	3,936
Library Cache	kgldtin1 42	1,596
Cursor Pin	kksfbc [KKSCHLPIN1]	765
Cursor Pin	kksxsccmp [KKSCHLPIN5]	449
Library Cache	kglobld1 75	407
Cursor Pin	kksLockDelete [KKSCHLPIN6]	269
Library Cache	kgllkal3 82	225
Cursor Parent	kkscsPruneChild [KKSPRTLOC35]	220
Library Cache	kglini1 32	164
Library Cache	kglGetHandleReference 124	110
Library Cache	kglrfcl1 79	41
Library Cache	kglhbh1 63	22
Library Cache	kglUpgradeLock 119	15
Library Cache	kglobpn1 71	12
Library Cache	kgllldl2 112	7
Library Cache	kglllal1 109	3
Library Cache	kgllkal5 84	2
hash table	kkshGetNextChild [KKSHBKLOC1]	2
Library Cache	kglReleaseHandleReference 125	1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 106,217,934
Captured Segments account for 94.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
JQGJ20130111	JQGJ20130111_DATA	T_LOC_RECORD		TABLE	34,785,456	32.75
JQGJ20130111	JQGJ20130111_DATA	T_JHDW		TABLE	9,943,440	9.36
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1304	TABLE PARTITION	8,121,312	7.65
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1305	TABLE PARTITION	7,938,400	7.47
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_ADDZGGG		INDEX	5,899,952	5.55

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 29,527,398
Captured Segments account for 97.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1304	TABLE PARTITION	8,121,257	27.50
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1305	TABLE PARTITION	7,938,257	26.88
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1306	TABLE PARTITION	5,826,997	19.73
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1305	TABLE PARTITION	1,042,754	3.53
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1306	TABLE PARTITION	1,012,281	3.43

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 1,260,418
Captured Segments account for 96.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS_ADDZGGG		INDEX	259,353	20.58
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1304	TABLE PARTITION	254,575	20.20
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1305	TABLE PARTITION	248,859	19.74
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1306	TABLE PARTITION	194,500	15.43
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1305	TABLE PARTITION	32,897	2.61

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 1,260,418
Captured Segments account for 96.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS_ADDZGGG		INDEX	259,353	20.58
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1304	TABLE PARTITION	254,575	20.20
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1305	TABLE PARTITION	248,859	19.74
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1306	TABLE PARTITION	194,500	15.43
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1305	TABLE PARTITION	32,897	2.61

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: 29,166,061
Captured Segments account for 97.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1304	TABLE PARTITION	8,121,218	27.84
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1305	TABLE PARTITION	7,938,113	27.22
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_HIS	ADDTIME_1306	TABLE PARTITION	5,814,693	19.94
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1305	TABLE PARTITION	1,042,800	3.58
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1306	TABLE PARTITION	1,011,712	3.47

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 181,140
Captured Segments account for 37.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_ZGUID	INDEX	25,347	13.99
JQGJ20130111	JQGJ20130111_DATA	T_LAST_POSITION	TABLE	10,088	5.57
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE	TABLE	8,439	4.66
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_ADDZGGG	INDEX	5,911	3.26
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE_ZGUID	INDEX	4,655	2.57

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 49,061
Captured Segments account for 64.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_ZGUID	INDEX	9,903	20.19
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_ADDZGGG	INDEX	4,999	10.19
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE_ADDTIME	INDEX	3,744	7.63
JQGJ20130111	JQGJ20130111_DATA	T_LAST_POSITION	TABLE	2,783	5.67
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE	TABLE	2,397	4.89

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 39,385
Captured Segments account for 0.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1872282062_4406	TABLE PARTITION	250	0.63
SYS	SYSAUX	SYS_LOB0000006339C00038$$		LOB	10	0.03

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 1,290
Captured Segments account for 46.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1301	TABLE PARTITION	60	4.65
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1302	TABLE PARTITION	60	4.65
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1303	TABLE PARTITION	60	4.65
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1304	TABLE PARTITION	60	4.65
JQGJ20130111	JQGJ20130111_DATA	T_KQDETAIL	ADDTIME_1305	TABLE PARTITION	60	4.65

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
MISSING	TEMP	** TRANSIENT: 4207360	MISSING	UNDEFINED	245,184	21.28
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE_ZGUID		INDEX	216,832	18.82
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE_ADDTIME		INDEX	159,664	13.86
JQGJ20130111	JQGJ20130111_DATA	T_LAST_POSITION		TABLE	140,256	12.17
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE_GGUID		INDEX	84,544	7.34

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	Obj. Type	Row Lock Waits	% of Capture
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE_ADDTIME	INDEX	22,793	44.16
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_ADDZGGG	INDEX	17,040	33.01
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_PK	INDEX	11,554	22.38
JQGJ20130111	JQGJ20130111_DATA	T_LAST_POSITION	TABLE	168	0.33
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE_GGUID	INDEX	29	0.06

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	Obj. Type	ITL Waits	% of Capture
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_PK	INDEX	322	45.54
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE_ADDTIME	INDEX	315	44.55
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_ADDZGGG	INDEX	70	9.90

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
JQGJ20130111	JQGJ20130111_DATA	HIS_POS_GPSONE_ADDTIME	INDEX	34,433	41.94
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_ADDZGGG	INDEX	25,893	31.54
JQGJ20130111	JQGJ20130111_DATA	T_POSITION_GPSONE_PK	INDEX	17,971	21.89
SYS	SYSTEM	UNDO$	TABLE	1,307	1.59
JQGJ20130111	JQGJ20130111_DATA	T_LAST_POSITION	TABLE	1,251	1.52

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	130	0.00	16	1
dc_files	24	0.00	0	12
dc_global_oids	956	4.50	0	34
dc_histogram_data	478,988	0.31	0	2,762
dc_histogram_defs	334,704	0.79	1	2,949
dc_object_grants	254	20.47	0	79
dc_objects	130,184	0.82	11	1,512
dc_profiles	29,468	0.00	0	1
dc_rollback_segments	46,023	0.00	314	679
dc_segments	59,116	1.20	72	578
dc_sequences	7,707	0.45	7,707	19
dc_tablespaces	976,525	0.00	0	12
dc_users	2,410,644	0.00	0	94
global database name	32,614	0.00	0	1
outstanding_alerts	98	28.57	15	9
sch_lj_oids	15	60.00	0	4

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	58,611	0.00	0		0	0
BODY	1,865	2.36	4,133	3.12	79	0
CLUSTER	453	0.88	457	1.09	1	0
DBLINK	59,590	0.00	0		0	0
EDITION	29,363	0.00	58,699	0.01	2	0
INDEX	178	3.93	178	3.93	0	0
OBJECT ID	1	100.00	0		0	0
QUEUE	104	0.96	330	0.91	1	0
RULESET	0		16	12.50	2	0
SCHEMA	30,284	0.01	0		0	0
SQL AREA	260,615	3.59	1,340,436	4.23	25,271	54
SQL AREA BUILD	35,578	32.26	0		0	0
SQL AREA STATS	10,698	94.02	10,698	94.02	0	0
SUBSCRIPTION	23	4.35	23	4.35	0	0
TABLE/PROCEDURE	68,810	0.59	364,528	0.82	1,815	0
TRIGGER	278	1.44	338	3.55	8	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)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	1,904.00	2,016.00	1,776.00	2,112.00	4	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	1,200.00	1,200.00	1,200.00	1,200.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	3,600.00	3,600.00	3,600.00	3,600.00	0	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	16.00	16.00	16.00	16.00	0	STA/
large pool	16.00	16.00	16.00	16.00	0	STA/
shared pool	1,616.00	1,504.00	1,408.00	1,744.00	4	GRO/DEF
streams pool	16.00	16.00	16.00	16.00	0	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured
ordered by Component

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	1,984.00	2,112.00	2,048.00	4	3	1
shared pool	1,408.00	1,536.00	1,472.00	4	1	3

Back to Memory Statistics
Back to Top

Memory Resize Ops

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size
Status: COMplete/CANcelled/INActive/PENding/ERRor
ordered by start_time desc,component

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
06/27 17:19:49	32	bufcache	SHR/DEF	2,112	-64	2,048	COM
06/27 17:19:49	32	shared	GRO/DEF	1,408	64	1,472	COM
06/27 17:06:55	290	bufcache	GRO/DEF	2,048	64	2,112	COM
06/27 17:06:55	290	shared	SHR/DEF	1,472	-64	1,408	COM
06/27 17:00:58	0	bufcache	GRO/DEF	1,984	64	2,048	COM
06/27 17:00:58	0	shared	SHR/DEF	1,536	-64	1,472	COM
06/27 16:52:57	1	bufcache	GRO/DEF	1,904	80	1,984	COM
06/27 16:52:57	1	shared	SHR/DEF	1,616	-80	1,536	COM

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	675.30		1.49	2.40	27	39	452	452
B	Freeable	70.94	0.00	0.54	0.80	8		132	132
B	PL/SQL	11.68	5.36	0.03	0.16	3	4	449	449
B	SQL	5.37	1.98	0.01	0.04	1	111	433	251
E	Other	690.00		1.56	2.42	27	41	442	442
E	Freeable	108.00	0.00	0.56	0.67	8		194	194
E	PL/SQL	13.47	6.70	0.03	0.16	3	4	439	439
E	SQL	5.67	0.77	0.01	0.02	0	107	422	280

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,996,488,704	2,147,483,648
Fixed Size	2,233,960
Redo Buffers	14,454,784
Variable Size	1,744,832,920	1,593,837,976

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	16.00	16.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	8.19	8.19	0.00
shared	ASH buffers		16.00
shared	KGH: NO ACCESS	39.47	39.47	0.00
shared	KGLH0	331.65	101.09	-69.52
shared	KGLHD	49.20	19.00	-61.38
shared	KKSSP	20.06	20.22	0.80
shared	KTI-UNDO	33.45	33.45	0.00
shared	SQLA	206.03	79.19	-61.56
shared	dbktb: trace buffer	46.88	46.88	0.00
shared	event statistics per sess	56.52	56.52	0.00
shared	free memory	422.52	690.15	63.34
shared	kglsim object batch	27.25	27.25	0.00
shared	ksunfy : SSO free list	52.68	52.68	0.00
shared	private strands	64.68	64.68	0.00
streams	free memory	16.00	16.00	0.00
	buffer_cache	1,904.00	2,048.00	7.56
	fixed_sga	2.13	2.13	0.00
	log_buffer	13.79	13.79	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 CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0620 00:27:31	0.02	0.01	0.00
QMON Coordinator	0620 00:27:21	0.00	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	15	0.00	0	0.11	41.82	0.00	0.00	2.79	0.01	2

Back to Streams Statistics
Back to Top

Persistent Queues

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps
%Exp Msgs - % of msgs enqueued with expiry
%Delay Msgs - % of msgs enqueued with delay
%Trasf Time - % of Enqueue time spent in transformation
%Eval Time - % of Enqueue time spent in rule evaluation

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(12733)	15	0	100.00	0.00	45.09	0.00	0.00	95.90
SYS.AQ$_ALERT_QT_E(12732)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(68711)	85	85	0.00	0.00	2.70	15.56	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
SYS.ALERT_QUE(12733)	0.00	0.00	3.01
SYS.AQ$_ALERT_QT_E(12732)	0.00	0.00
SYSMAN.MGMT_TASK_Q(68711)	0.01	0.01	0.03	0.18

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Ordered by Queue Name, Subscriber Name
* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enqueue Msgs	Dequeue Msgs	Expire Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0
LOCALHOST_LOC_3938_XNJT(41)/SYS.ALERT_QUE	15	0	0	0.00	0.00	0.00

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 %
6,075	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	6,075	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/opt/oracle/admin/xnjt/adump
audit_trail	NONE
compatible	11.2.0.0.0
control_file_record_keep_time	14
control_files	/opt/oracle/oradata/xnjt/control01.ctl, /opt/oracle/fast_recovery_area/xnjt/control02.ctl
db_block_size	8192
db_domain	localdomain
db_name	xnjt
db_recovery_file_dest	/opt/oracle/fast_recovery_area
db_recovery_file_dest_size	53687091200
diagnostic_dest	/opt/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=xnjtXDB)
open_cursors	300
pga_aggregate_target	1258291200
processes	3000
remote_login_passwordfile	EXCLUSIVE
sga_target	3774873600
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

This section only displays parameters that have more one value
'(NULL)' indicates a missing parameter value
A blank in the End Snapshot indicates the same value as the BeginSnapshot

Parameter Name	Begin value	End value (if different)
control_files	/opt/oracle/fast_recovery_area/xnjt/control02.ctl
control_files	/opt/oracle/oradata/xnjt/control01.ctl

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.46	Redo NoWait %:	99.68
Buffer Hit %:	99.53	In-memory Sort %:	100.00
Library Hit %:	96.07	Soft Parse %:	87.70
Execute to Parse %:	69.54	Latch Hit %:	98.87
Parse CPU to Parse Elapsd %:	0.21	% Non-Parse CPU:	98.53