WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ORCL 1288998956 orcl1 1 10.2.0.5.0 YES zyk1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORCL	1288998956	orcl1	1	10.2.0.5.0	YES	zyk1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 12272 07-Feb-13 08:00:09 1431 6.5

End Snap: 12273 07-Feb-13 09:00:24 1459 6.5

Elapsed: 60.25 (mins)

DB Time: 115.96 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	12272	07-Feb-13 08:00:09	1431	6.5
End Snap:	12273	07-Feb-13 09:00:24	1459	6.5
Elapsed:		60.25 (mins)
DB Time:		115.96 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 560M 832M Std Block Size: 8K

Shared Pool Size: 912M 640M Log Buffer: 14,336K

	Begin	End
Buffer Cache:	560M	832M	Std Block Size:	8K
Shared Pool Size:	912M	640M	Log Buffer:	14,336K

Load Profile

Per Second Per Transaction

Redo size: 4,944.85 2,004.23

Logical reads: 3,405.32 1,380.23

Block changes: 27.84 11.29

Physical reads: 1,805.67 731.87

Physical writes: 1.33 0.54

User calls: 330.95 134.14

Parses: 100.26 40.64

Hard parses: 78.95 32.00

Sorts: 17.02 6.90

Logons: 0.14 0.06

Executes: 201.25 81.57

Transactions: 2.47

	Per Second	Per Transaction
Redo size:	4,944.85	2,004.23
Logical reads:	3,405.32	1,380.23
Block changes:	27.84	11.29
Physical reads:	1,805.67	731.87
Physical writes:	1.33	0.54
User calls:	330.95	134.14
Parses:	100.26	40.64
Hard parses:	78.95	32.00
Sorts:	17.02	6.90
Logons:	0.14	0.06
Executes:	201.25	81.57
Transactions:	2.47

% Blocks changed per Read: 0.82 Recursive Call %: 71.80

Rollback per transaction %: 1.20 Rows per Sort: 15.23

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.69 Redo NoWait %: 100.00

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

Library Hit %: 47.84 Soft Parse %: 21.25

Execute to Parse %: 50.18 Latch Hit %: 99.83

Parse CPU to Parse Elapsd %: 28.66 % Non-Parse CPU: 87.15

Shared Pool Statistics

Begin End

Memory Usage %: 84.77 74.47

% SQL with executions>1: 43.72 87.76

% Memory for SQL w/exec>1: 57.61 83.99

	Begin	End
Memory Usage %:	84.77	74.47
% SQL with executions>1:	43.72	87.76
% Memory for SQL w/exec>1:	57.61	83.99

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

enq: TX - row lock contention 6,268 3,043 485 43.7 Application

db file sequential read 475,353 1,937 4 27.8 User I/O

direct path read 209,913 1,477 7 21.2 User I/O

CPU time 1,458 21.0

db file scattered read 171,340 665 4 9.6 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
enq: TX - row lock contention	6,268	3,043	485	43.7	Application
db file sequential read	475,353	1,937	4	27.8	User I/O
direct path read	209,913	1,477	7	21.2	User I/O
CPU time		1,458		21.0
db file scattered read	171,340	665	4	9.6	User I/O

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 407.55 165.19

Global Cache blocks served: 152.28 61.72

GCS/GES messages received: 1,412.68 572.59

GCS/GES messages sent: 1,983.30 803.87

DBWR Fusion writes: 0.12 0.05

Estd Interconnect traffic (KB) 5,141.89

	Per Second	Per Transaction
Global Cache blocks received:	407.55	165.19
Global Cache blocks served:	152.28	61.72
GCS/GES messages received:	1,412.68	572.59
GCS/GES messages sent:	1,983.30	803.87
DBWR Fusion writes:	0.12	0.05
Estd Interconnect traffic (KB)	5,141.89

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

Buffer access - local cache %: 61.93

Buffer access - remote cache %: 11.97

Buffer access - disk %: 26.10

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 5.6

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

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

Avg global cache cr block build time (ms): 0.0

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

Global cache log flushes for cr blocks served %: 1.6

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

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

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

Global cache log flushes for current blocks served %: 0.0

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.2

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

Avg message received queue time (ms): 0.1

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 10.95

% of indirect sent messages: 88.29

% of flow controlled messages: 0.76

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
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Wait Class
Wait Events
Background Wait Events
Operating System Statistics
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 6957.5s
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	6,302.91	90.59
DB CPU	1,457.66	20.95
parse time elapsed	673.10	9.67
hard parse elapsed time	620.49	8.92
hard parse (sharing criteria) elapsed time	16.37	0.24
hard parse (bind mismatch) elapsed time	15.91	0.23
PL/SQL compilation elapsed time	11.73	0.17
PL/SQL execution elapsed time	11.37	0.16
connection management call elapsed time	3.98	0.06
failed parse elapsed time	2.00	0.03
sequence load elapsed time	1.12	0.02
repeated bind elapsed time	0.49	0.01
DB time	6,957.47
background elapsed time	312.23
background cpu time	257.46

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%Total Call Time
User I/O	864,263	0	4,129	5	59.35
Application	15,732	40	3,047	194	43.79
CPU time			1,458		20.95
Cluster	1,504,822	0	460	0	6.61
Concurrency	71,318	2	46	1	0.66
System I/O	20,225		35	2	0.50
Other	252,929	71	12	0	0.18
Commit	8,794		9	1	0.13
Network	1,011,143		7	0	0.10
Configuration	7		0	2	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
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
enq: TX - row lock contention	6,268	99	3,043	485	0.70
db file sequential read	475,353		1,937	4	53.30
direct path read	209,913		1,477	7	23.54
db file scattered read	171,340		665	4	19.21
gc cr multi block request	1,098,520		194	0	123.17
gc buffer busy	37,699	0	140	4	4.23
gc cr grant 2-way	326,760		106	0	36.64
db file parallel read	6,631		40	6	0.74
control file sequential read	9,078		22	2	1.02
os thread startup	199		15	75	0.02
gc current block 2-way	34,099		15	0	3.82
cursor: pin S wait on X	1,085	99	10	10	0.12
read by other session	918	0	10	11	0.10
log file parallel write	9,929		9	1	1.11
log file sync	8,794		9	1	0.99
row cache lock	61,570	0	9	0	6.90
library cache load lock	101		9	90	0.01
control file parallel write	1,218		3	3	0.14
SQL*Net message from dblink	1,754		3	2	0.20
SQL*Net more data to client	118,481		3	0	13.28
name-service call wait	52		2	46	0.01
gc current block busy	133		2	16	0.01
enq: KO - fast object checkpoint	83	5	2	25	0.01
gc cr block 2-way	3,777		2	0	0.42
latch: shared pool	5,271		2	0	0.59
reliable message	308		2	5	0.03
SQL*Net break/reset to client	8,606		1	0	0.96
kksfbc child completion	32	75	1	36	0.00
CGS wait for IPC msg	159,499	100	1	0	17.88
ges lmd/lmses to freeze in rcfg - mrcvr	592	2	1	2	0.07
cr request retry	4	100	1	244	0.00
gc current grant 2-way	2,999		1	0	0.34
SQL*Net message to client	885,945		1	0	99.33
gcs log flush sync	271	1	1	3	0.03
ksxr poll remote instances	78,236	13	1	0	8.77
gcs drm freeze in enter server mode	5		1	132	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	58		1	9	0.01
gc current grant busy	562		0	1	0.06
gc cr block busy	61		0	6	0.01
enq: TM - contention	672		0	0	0.08
library cache pin	1,324		0	0	0.15
library cache lock	499		0	0	0.06
SQL*Net more data from client	2,667		0	0	0.30
latch free	67		0	3	0.01
rdbms ipc reply	1,133		0	0	0.13
IPC send completion sync	316	94	0	0	0.04
DFS lock handle	386		0	0	0.04
ges global resource directory to be frozen	13	100	0	10	0.00
gc remaster	1		0	125	0.00
enq: PS - contention	219		0	1	0.02
PX Deq: reap credit	11,119	99	0	0	1.25
latch: cache buffers chains	1,065		0	0	0.12
direct path write temp	26		0	3	0.00
CSS operation: query	6		0	13	0.00
buffer busy waits	135		0	1	0.02
enq: TX - index contention	5		0	14	0.00
gc current retry	5		0	12	0.00
CSS initialization	2		0	28	0.00
direct path read temp	71		0	1	0.01
enq: TT - contention	118		0	0	0.01
PX Deq: Signal ACK	138	22	0	0	0.02
SQL*Net more data from dblink	279		0	0	0.03
gc current multi block request	115		0	0	0.01
direct path write	11		0	2	0.00
ges inquiry response	23		0	1	0.00
enq: FB - contention	34		0	1	0.00
SGA: allocation forcing component growth	2	50	0	8	0.00
gc cr grant congested	3		0	4	0.00
latch: row cache objects	44		0	0	0.00
gc cr disk read	32		0	0	0.00
enq: JQ - contention	22		0	0	0.00
global enqueue expand wait	1	100	0	10	0.00
enq: SQ - contention	3		0	3	0.00
enq: CF - contention	20		0	0	0.00
PX Deq Credit: send blkd	28	7	0	0	0.00
enq: WF - contention	13		0	0	0.00
latch: KCL gc element parent latch	70		0	0	0.01
SQL*Net more data to dblink	367		0	0	0.04
gc current block unknown	8		0	1	0.00
KJC: Wait for msg sends to complete	18		0	0	0.00
SQL*Net break/reset to dblink	103		0	0	0.01
enq: TD - KTF dump entries	7		0	0	0.00
cursor: mutex X	5		0	0	0.00
enq: MW - contention	2		0	1	0.00
latch: object queue header operation	12		0	0	0.00
CSS operation: action	4		0	0	0.00
enq: HW - contention	4		0	0	0.00
latch: library cache	11		0	0	0.00
LGWR wait for redo copy	54		0	0	0.01
ges2 LMON to wake up LMD - mrcvr	9		0	0	0.00
gc current split	3		0	0	0.00
latch: library cache lock	2		0	1	0.00
SQL*Net message to dblink	1,650		0	0	0.18
enq: DR - contention	2		0	0	0.00
latch: session allocation	2		0	0	0.00
latch: cache buffers lru chain	6		0	0	0.00
enq: SR - contention	2		0	0	0.00
gc object scan	43	88	0	0	0.00
gc cr failure	2		0	0	0.00
latch: gcs resource hash	8		0	0	0.00
enq: PE - contention	1		0	0	0.00
enq: PG - contention	1		0	0	0.00
enq: AF - task serialization	1		0	0	0.00
cursor: pin S	2		0	0	0.00
latch: ges resource hash list	2		0	0	0.00
lock escalate retry	6	67	0	0	0.00
PX qref latch	3	100	0	0	0.00
cursor: mutex S	2		0	0	0.00
SQL*Net message from client	885,990		72,286	82	99.34
jobq slave wait	14,523	99	42,130	2901	1.63
gcs remote message	1,315,977	22	14,009	11	147.55
PX Idle Wait	4,883	96	11,721	2400	0.55
Streams AQ: qmn slave idle wait	1,151		7,030	6107	0.13
i/o slave wait	343,861		3,656	11	38.55
DIAG idle wait	18,062		3,529	195	2.03
Streams AQ: qmn coordinator idle wait	1,620	37	3,529	2178	0.18
ASM background timer	819		3,529	4308	0.09
ges remote message	81,328	52	3,524	43	9.12
Streams AQ: waiting for messages in the queue	373	100	3,517	9429	0.04
virtual circuit status	120	100	3,491	29093	0.01
class slave wait	818	91	3,481	4256	0.09
Streams AQ: waiting for time management or cleanup tasks	1	100	2,686	2686166	0.00
PX Deq: Execute Reply	3,255	31	315	97	0.36
PX Deq: Execution Msg	2,617	14	5	2	0.29
PX Deq: Parse Reply	130	25	0	3	0.01
KSV master wait	68		0	4	0.01
PX Deq: Join ACK	108	31	0	1	0.01
single-task message	1		0	66	0.00
PX Deq: Msg Fragment	168	37	0	0	0.02
SGA: MMAN sleep for component shrink	4	75	0	7	0.00
Streams AQ: RAC qmn coordinator idle wait	1,655	100	0	0	0.19

Back to Wait Events Statistics
Back to Top

Background Wait Events

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 file sequential read	7,013		48	7	0.79
control file sequential read	8,949		22	2	1.00
os thread startup	187		14	73	0.02
log file parallel write	9,928		9	1	1.11
library cache load lock	59		6	104	0.01
events in waitclass Other	239,758	70	6	0	26.88
control file parallel write	1,218		3	3	0.14
row cache lock	14,964		2	0	1.68
db file scattered read	212		2	7	0.02
gc cr grant 2-way	4,748		1	0	0.53
gc cr block 2-way	554		0	0	0.06
enq: TM - contention	665		0	0	0.07
db file parallel read	6		0	10	0.00
gc cr multi block request	141		0	0	0.02
latch: shared pool	137		0	0	0.02
cursor: pin S wait on X	4	100	0	10	0.00
gc current grant 2-way	122		0	0	0.01
library cache lock	81		0	0	0.01
library cache pin	142		0	0	0.02
enq: KO - fast object checkpoint	45		0	0	0.01
gc cr block busy	4		0	2	0.00
latch: row cache objects	14		0	0	0.00
latch: library cache lock	1		0	1	0.00
gc cr disk read	3		0	0	0.00
gc object scan	43	88	0	0	0.00
gc current block unknown	1		0	1	0.00
latch: cache buffers chains	1		0	0	0.00
latch: library cache	1		0	0	0.00
gc current block 2-way	11		-0	-0	0.00
rdbms ipc message	148,000	35	52,630	356	16.59
gcs remote message	1,315,979	22	14,009	11	147.55
Streams AQ: qmn slave idle wait	1,151		7,030	6107	0.13
DIAG idle wait	18,061		3,529	195	2.03
Streams AQ: qmn coordinator idle wait	1,620	37	3,529	2178	0.18
ASM background timer	819		3,529	4308	0.09
pmon timer	1,249	100	3,526	2823	0.14
ges remote message	81,311	52	3,524	43	9.12
class slave wait	811	92	3,481	4293	0.09
smon timer	12	100	3,233	269449	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100	2,686	2686166	0.00
KSV master wait	68		0	4	0.01
SGA: MMAN sleep for component shrink	4	75	0	7	0.00
Streams AQ: RAC qmn coordinator idle wait	1,655	100	0	0	0.19

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	12,822
AVG_IDLE_TIME	349,043
AVG_IOWAIT_TIME	10,516
AVG_SYS_TIME	4,628
AVG_USER_TIME	8,081
BUSY_TIME	207,010
IDLE_TIME	5,586,647
IOWAIT_TIME	170,073
SYS_TIME	75,978
USER_TIME	131,032
LOAD	1
OS_CPU_WAIT_TIME	335,800
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	57,344
VM_OUT_BYTES	35,790,848
PHYSICAL_MEMORY_BYTES	32,212,254,720
NUM_CPUS	16
NUM_CPU_CORES	8

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
zydb	4,750.00	97.10	428,415	1,202,276
SYS$USERS	2,207.30	1,360.30	7,106,937	11,852,064
SYS$BACKGROUND	0.20	0.20	10,843	260,532
SYS.KUPC$S_1_20130121165457	0.00	0.00	0	0
orcl	0.00	0.00	0	0
orclXDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
zydb	419087	1503	15219	11	48201	4
SYS$USERS	436370	2567	34643	11	962681	4
SYS$BACKGROUND	8786	59	21469	24	0	0
orcl	0	0	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 Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
SQL ordered by Cluster Wait Time
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
Total DB Time (s): 6,957
Captured SQL account for 83.6% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
3,047	0	86	35.43	43.80	gdaj4m47tf5p9	JDBC Thin Client	UPDATE FRM_TRANS_TASK SET RWZT...
2,580	23	8	322.56	37.09	8utxg8xacgmt8	JDBC Thin Client	BEGIN Trans_Basic_Pkg.Initupqu...
81	5	7	11.58	1.16	bfvbrw587uhqx	JDBC Thin Client	UPDATE FRM_TRANS_UP_QUEUE_VEH ...
30	1	115,990	0.00	0.43	f2tgc423ng3bx	JDBC Thin Client	UPDATE ACD_T_LISTFILE SET BCGS...
20	1			0.29	db78fxqxwxt7r		select /+ rule / bucket, end...
19	1	8	2.43	0.28	6w7tyy2mgyp10	JDBC Thin Client	UPDATE FRM_TRANS_UP_QUEUE_VEH ...
17	1			0.24	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
9	0	353	0.02	0.12	5dc572vuquzzc	JDBC Thin Client	DELETE FRM_TRANS_TASKRUNTIME W...
7	2	3,356	0.00	0.10	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
6	0			0.09	96g93hntrzjtr		select /+ rule / bucket_cnt,...

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 is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 1,458
Captured SQL account for 3.2% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
23	2,580	8	2.93	1.61	37.09	8utxg8xacgmt8	JDBC Thin Client	BEGIN Trans_Basic_Pkg.Initupqu...
5	81	7	0.68	0.33	1.16	bfvbrw587uhqx	JDBC Thin Client	UPDATE FRM_TRANS_UP_QUEUE_VEH ...
2	3	633	0.00	0.16	0.05	8kyvv5knwptbf		select count(*) from sys.job$ ...
2	5	707	0.00	0.15	0.07	8cuu0uynbrhbn		select job, nvl2(last_date, 1,...
2	7	3,356	0.00	0.13	0.10	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
1	6			0.10	0.08	139vuayh56w4w		BEGIN Acd_Comm_Pkg.Saveacd_Tas...
1	30	115,990	0.00	0.09	0.43	f2tgc423ng3bx	JDBC Thin Client	UPDATE ACD_T_LISTFILE SET BCGS...
1	20			0.09	0.29	db78fxqxwxt7r		select /+ rule / bucket, end...
1	17			0.08	0.24	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
1	2	30	0.04	0.08	0.03	0pysymcxq0m05	JDBC Thin Client	BEGIN Trans_Basic_Pkg.Initupqu...

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: 12,310,315
Captured SQL account for 5.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
348,507	115,990	3.00	2.83	1.36	29.69	f2tgc423ng3bx	JDBC Thin Client	UPDATE ACD_T_LISTFILE SET BCGS...
199,865	8	24,983.13	1.62	23.45	2580.45	8utxg8xacgmt8	JDBC Thin Client	BEGIN Trans_Basic_Pkg.Initupqu...
139,802	30	4,660.07	1.14	1.22	2.18	0pysymcxq0m05	JDBC Thin Client	BEGIN Trans_Basic_Pkg.Initupqu...
47,599	7	6,799.86	0.39	4.77	81.04	bfvbrw587uhqx	JDBC Thin Client	UPDATE FRM_TRANS_UP_QUEUE_VEH ...
42,633	3,356	12.70	0.35	1.86	6.86	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
39,603	633	62.56	0.32	2.28	3.50	8kyvv5knwptbf		select count(*) from sys.job$ ...
34,214	707	48.39	0.28	2.21	4.98	8cuu0uynbrhbn		select job, nvl2(last_date, 1,...
28,274	30	942.47	0.23	1.09	5.25	fb9c9hzkdfhvn	JDBC Thin Client	select * from acd_t_listfile w...
16,777	8	2,097.13	0.14	0.63	19.44	6w7tyy2mgyp10	JDBC Thin Client	UPDATE FRM_TRANS_UP_QUEUE_VEH ...
10,013	1,937	5.17	0.08	0.41	2.07	04xtrk7uyhknh		select obj#, type#, ctime, mti...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 6,527,541
Captured SQL account for 0.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
147,705	8	18,463.13	2.26	23.45	2580.45	8utxg8xacgmt8	JDBC Thin Client	BEGIN Trans_Basic_Pkg.Initupqu...
22,666	7	3,238.00	0.35	4.77	81.04	bfvbrw587uhqx	JDBC Thin Client	UPDATE FRM_TRANS_UP_QUEUE_VEH ...
5,710	30	190.33	0.09	1.09	5.25	fb9c9hzkdfhvn	JDBC Thin Client	select * from acd_t_listfile w...
3,282	8	410.25	0.05	0.63	19.44	6w7tyy2mgyp10	JDBC Thin Client	UPDATE FRM_TRANS_UP_QUEUE_VEH ...
1,831	115,990	0.02	0.03	1.36	29.69	f2tgc423ng3bx	JDBC Thin Client	UPDATE ACD_T_LISTFILE SET BCGS...
1,432	7	204.57	0.02	0.32	5.19	cckz17g0nrkp4	JDBC Thin Client	select /+FIRST_ROWS/ p.ph tr...
758	6	126.33	0.01	0.36	2.90	avs2japq8nt2b	JDBC Thin Client	select /+FIRST_ROWS/ p.ph tr...
279	3,356	0.08	0.00	1.86	6.86	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
265	707	0.37	0.00	2.21	4.98	8cuu0uynbrhbn		select job, nvl2(last_date, 1,...
146	1,937	0.08	0.00	0.41	2.07	04xtrk7uyhknh		select obj#, type#, ctime, mti...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 727,508
Captured SQL account for 17.5% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
115,990	0	0.00	0.00	f2tgc423ng3bx	JDBC Thin Client	UPDATE ACD_T_LISTFILE SET BCGS...
3,356	5,076	1.51	0.00	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
1,937	1,831	0.95	0.00	04xtrk7uyhknh		select obj#, type#, ctime, mti...
1,013	1,013	1.00	0.00	8pstj5xwgnc0s		select To_Char(sysdate, 'yyyy-...
707	83	0.12	0.01	8cuu0uynbrhbn		select job, nvl2(last_date, 1,...
633	633	1.00	0.01	8kyvv5knwptbf		select count(*) from sys.job$ ...
460	460	1.00	0.00	3c1kubcdjnppq		update sys.col_usage$ set equa...
446	0	0.00	0.00	6g4pv7gubrgqx	JDBC Thin Client	select * from frm_syspara wher...
353	318	0.90	0.02	5dc572vuquzzc	JDBC Thin Client	DELETE FRM_TRANS_TASKRUNTIME W...
353	353	1.00	0.01	abbhd888ndywn	JDBC Thin Client	INSERT INTO FRM_TRANS_TASKRUNT...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 362,437
Captured SQL account for 1.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
4,599		1.27	2ym6hhaq30r73	select type#, blocks, extents,...
1,276		0.35	39m4sx9k63ba2	select /*+ index(idl_ub2$ i_id...
1,276		0.35	c6awqs517jpj0	select /*+ index(idl_char$ i_i...
1,275		0.35	cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_id...
1,243		0.34	ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_id...
1,106		0.31	96g93hntrzjtr	select /+ rule / bucket_cnt,...
1,034	3,356	0.29	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...
1,015	1,013	0.28	8pstj5xwgnc0s	select To_Char(sysdate, 'yyyy-...
880		0.24	5ngzsfstg8tmy	select o.owner#, o.name, o.nam...
800		0.22	db78fxqxwxt7r	select /+ rule / bucket, end...

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)	% Total	SQL Id	SQL Text
1,393,624	0.21	139vuayh56w4w	BEGIN Acd_Comm_Pkg.Saveacd_Tas...
1,292,016	0.19	d4jcgmf5capqa	SELECT COUNT(*) FROM USER_SEQU...
1,248,760	0.19	32bhha21dkv0v	select col#, intcol#, charseti...
1,215,240	0.18	60vjfwg6gvg2k	INSERT INTO ACD_TASK_LOG (ZXXH...
1,163,456	0.17	9g485acn2n30m	select col#, intcol#, reftyp, ...
1,142,112	0.17	0fr8zhn4ymu3v	select intcol#, type, flags, l...
1,137,456	0.17	a73wbv1yu8x5c	select con#, type#, condlength...
1,116,576	0.17	53saa2zkr6wc3	select intcol#, nvl(pos#, 0), ...
1,091,040	0.16	f8pavn1bvsj7t	select con#, obj#, rcon#, enab...
1,086,672	0.16	db78fxqxwxt7r	select /+ rule / bucket, end...
1,053,208	0.16	ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_id...

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
354		0fr8zhn4ymu3v	select intcol#, type, flags, l...
350		a73wbv1yu8x5c	select con#, type#, condlength...
346		53saa2zkr6wc3	select intcol#, nvl(pos#, 0), ...
338		f8pavn1bvsj7t	select con#, obj#, rcon#, enab...
319		139vuayh56w4w	BEGIN Acd_Comm_Pkg.Saveacd_Tas...
303		d4jcgmf5capqa	SELECT COUNT(*) FROM USER_SEQU...
290		32bhha21dkv0v	select col#, intcol#, charseti...
285		60vjfwg6gvg2k	INSERT INTO ACD_TASK_LOG (ZXXH...
279		5wc2915k44m38	select user#, type# from user$...
270		9g485acn2n30m	select col#, intcol#, reftyp, ...
252		db78fxqxwxt7r	select /+ rule / bucket, end...
247		ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_id...
243		5ngzsfstg8tmy	select o.owner#, o.name, o.nam...
242		cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_id...
231		2ym6hhaq30r73	select type#, blocks, extents,...
225		c6awqs517jpj0	select /*+ index(idl_char$ i_i...
216		96g93hntrzjtr	select /+ rule / bucket_cnt,...
206		f3g84j69n0tjh	select col#, intcol#, ntab# fr...
205		39m4sx9k63ba2	select /*+ index(idl_ub2$ i_id...
197	15	9rfqm06xmuwu0	select intcol#, toid, version#...
188	15	6qz82dptj0qr7	select l.col#, l.intcol#, l.lo...
179	260	83taa7kaw59c1	select name, intcol#, segcol#,...
161	89	1gu8t96d0bdmu	select t.ts#, t.file#, t.block...
161	118	2q93zsrvbdw48	select grantee#, privilege#, n...
152	200	6769wyy3yf66f	select pos#, intcol#, col#, sp...
141	76	6aq34nj2zb2n7	select col#, grantee#, privile...
135	15	7nuw4xwrnuwxq	select col#, intcol#, toid, ve...
77	27	8swypbbr0m372	select order#, columns, types ...
70	1,937	04xtrk7uyhknh	select obj#, type#, ctime, mti...
70	27	451q2032pshqm	select owner#, name, namespace...
60	3,356	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...
60	3,356	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)	CWT % of Elapsd Time	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
40.66	1.58	2,580.45	23.45	8	8utxg8xacgmt8	JDBC Thin Client	BEGIN Trans_Basic_Pkg.Initupqu...
8.56	10.56	81.04	4.77	7	bfvbrw587uhqx	JDBC Thin Client	UPDATE FRM_TRANS_UP_QUEUE_VEH ...
7.64	88.16	8.67	0.32	353	5dc572vuquzzc	JDBC Thin Client	DELETE FRM_TRANS_TASKRUNTIME W...
1.51	77.48	1.94	0.10	353	abbhd888ndywn	JDBC Thin Client	INSERT INTO FRM_TRANS_TASKRUNT...
0.68	3.50	19.44	0.63	8	6w7tyy2mgyp10	JDBC Thin Client	UPDATE FRM_TRANS_UP_QUEUE_VEH ...
0.45	8.72	5.19	0.32	7	cckz17g0nrkp4	JDBC Thin Client	select /+FIRST_ROWS/ p.ph tr...
0.35	15.99	2.18	1.22	30	0pysymcxq0m05	JDBC Thin Client	BEGIN Trans_Basic_Pkg.Initupqu...
0.34	1.14	29.69	1.36	115,990	f2tgc423ng3bx	JDBC Thin Client	UPDATE ACD_T_LISTFILE SET BCGS...
0.25	8.47	2.90	0.36	6	avs2japq8nt2b	JDBC Thin Client	select /+FIRST_ROWS/ p.ph tr...
0.22	4.37	4.98	2.21	707	8cuu0uynbrhbn		select job, nvl2(last_date, 1,...
0.18	3.51	5.25	1.09	30	fb9c9hzkdfhvn	JDBC Thin Client	select * from acd_t_listfile w...
0.15	4.19	3.50	2.28	633	8kyvv5knwptbf		select count(*) from sys.job$ ...
0.14	0.00	3,047.11	0.28	86	gdaj4m47tf5p9	JDBC Thin Client	UPDATE FRM_TRANS_TASK SET RWZT...
0.09	1.36	6.86	1.86	3,356	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.07	3.53	2.07	0.41	1,937	04xtrk7uyhknh		select obj#, type#, ctime, mti...
0.03	1.54	2.17	0.72	30	am2mgzshv9t7u	JDBC Thin Client	select SGBH, '1' ZJGS, ZJLX, Z...
0.03	2.24	1.29	0.57	33	4w33a18a3ma73		select count(*) from sys.job$ ...
0.02	0.40	4.98	0.70	42	5fqmmgtf979p3	JDBC Thin Client	SELECT TO_CHAR(CREATED, 'yyyy-...
0.02	4.49	0.36	0.13	446	6g4pv7gubrgqx	JDBC Thin Client	select * from frm_syspara wher...
0.01	1.44	0.89	0.57	58	7wzw1gjwggfy0	JDBC Thin Client	select mrz from frm_syspara wh...
0.01	1.39	0.92	0.72	275	1dubbbfqnqvh9		SELECT ORA_TQ_BASE$.NEXTVAL FR...
0.01	0.79	1.04	0.57	120	772s25v1y0x8k		select shared_pool_size_for_es...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

04xtrk7uyhknh select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

0fr8zhn4ymu3v select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc

0pysymcxq0m05 BEGIN Trans_Basic_Pkg.Initupqueue(:1, :2, :3, :4, :5, :6); END;

139vuayh56w4w BEGIN Acd_Comm_Pkg.Saveacd_Task_Log(:1, :2, :3); END;

1dubbbfqnqvh9 SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL

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

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

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

32bhha21dkv0v select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc

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

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

451q2032pshqm select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

4w33a18a3ma73 select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

5dc572vuquzzc DELETE FRM_TRANS_TASKRUNTIME WHERE RWID = :B3 AND TDBH = :B2 AND IPDZ = :B1

5fqmmgtf979p3 SELECT TO_CHAR(CREATED, 'yyyy-mm-dd hh24:mi:ss') FROM USER_OBJECTS WHERE OBJECT_NAME = 'ACD_FILE'

5ngzsfstg8tmy select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1

5wc2915k44m38 select user#, type# from user$ where name=:1

60vjfwg6gvg2k INSERT INTO ACD_TASK_LOG (ZXXH, RWID, FLAG, FHXX, ZXSJ, CSBJ) VALUES (:B4 , :B3 , :B2 , SUBSTR(:B1 , 1, 450), SYSDATE, '0')

6769wyy3yf66f select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6g4pv7gubrgqx select * from frm_syspara where xtlb='31' and gjz='TTMRM' and cslx='2'

6qz82dptj0qr7 select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc

6w7tyy2mgyp10 UPDATE FRM_TRANS_UP_QUEUE_VEH SET JQMC = '00' WHERE JQMC = :B1 AND SJLX IN (SELECT SJLX FROM FRM_TRANS_TASK_CONTENT WHERE RWID = :B2 ) AND ZT <> '0'

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

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

7nuw4xwrnuwxq select col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc

7wzw1gjwggfy0 select mrz from frm_syspara where xtlb='03' and gjz='TJXTJSDZ'

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

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

8kyvv5knwptbf select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))

8pstj5xwgnc0s select To_Char(sysdate, 'yyyy-mm-dd') from dual

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

8utxg8xacgmt8 BEGIN Trans_Basic_Pkg.Initupqueue_Veh(:1, :2, :3, :4, :5, :6); END;

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

9g485acn2n30m select col#, intcol#, reftyp, stabid, expctoid from refcon$ where obj#=:1 order by intcol# asc

9rfqm06xmuwu0 select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc

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

abbhd888ndywn INSERT INTO FRM_TRANS_TASKRUNTIME VALUES (:B5 , :B4 , :B3 , :B2 , :B1 )

am2mgzshv9t7u select SGBH, '1' ZJGS, ZJLX, ZJLXFL, TPXH, DSRBH, TPSM, SLR, JBR, LRSJ, TP, SLTP, BZ from acd_photo where sgbh='2207220201200001' and zjlx='11' and tpxh='1'

avs2japq8nt2b select /*+FIRST_ROWS*/ p.ph transph, t.XH, t.HPZL, t.SF, t.HPHM, t.CLPP1, t.CLXH, t.CLPP2, t.GCJK, t.ZZG, t.ZZCMC, t.CLSBDH, t.FDJH, t.CLLX, t.CSYS, t.SYXZ, t.SFZMHM, t.SFZMMC, t.SYR, t.SYQ, t.CCDJRQ, t.DJRQ, t.YXQZ, t.QZBFQZ, t.FZJG, t.GLBM, t.FPRQ, t.FZRQ, t.FDJRQ, t.FHGZRQ, t.BXZZRQ, t.BPCS, t.BZCS, t.BDJCS, t.DJZSBH, t.ZDJZSHS, t.DABH, t.XZQH, t.ZT, t.DYBJ, t.JBR, t.CLLY, t.LSH, t.FDJXH, t.RLZL, t.PL, t.GL, t.ZXXS, t.CWKC, t.CWKK, t.CWKG, t.HXNBCD, t.HXNBKD, t.HXNBGD, t.GBTHPS, t.ZS, t.ZJ, t.QLJ, t.HLJ, t.LTGG, t.LTS, t.ZZL, t.ZBZL, t.HDZZL, t.HDZK, t.ZQYZL, t.QPZK, t.HPZK, t.HBDBQK, t.CCRQ, t.HDFS, t.LLPZ1, t.PZBH1, t.LLPZ2, t.PZBH2, t.XSDW, t.XSJG, t.XSRQ, t.JKPZ, t.JKPZHM, t.HGZBH, t.NSZM, t.NSZMBH, t.GXRQ, t.XGZL, t.QMBH, t.HMBH, t.BZ, t.JYW, t.ZSXZQH, t.ZSXXDZ, t.YZBM1, t.LXDH, t.ZZZ, t.ZZXZQH, t.ZZXXDZ, t.YZBM2, t.ZDYZT, t.YXH, t.CYRY, t.DPHGZBH, t.SQDM, t.CLYT, t.YTSX, t.DZYX, t.XSZBH, t.SJHM, t.JYHGBZBH, t.DWBH, p.zjz transzjz from frm_trans_up_queue_veh p, VEHICLE t where p.zjz = t.XH(+) and p.jqmc='0601' and p.sjlx='0171' and p.zt ='2'

bfvbrw587uhqx UPDATE FRM_TRANS_UP_QUEUE_VEH SET JQMC = :B1 WHERE PH IN (SELECT PH FROM (SELECT DISTINCT T.PH FROM FRM_TRANS_UP_QUEUE_VEH T, FRM_TRANS_TASK_CONTENT V WHERE T.SJLX = V.SJLX AND V.RWID = :B4 AND T.JQMC = '00' AND T.ZT = :B3 AND ROWNUM < :B2 * 30) WHERE ROWNUM <= :B2 )

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

cckz17g0nrkp4 select /*+FIRST_ROWS*/ p.ph transph, t.LSH, t.ZZRQ, t.XH, t.HPZL, t.HPHM, t.YWLX, t.YWYY, t.ZZLX, t.JBR, t.GLBM, t.ZXBH, t.DYJBH, t.KHDIP, t.FZJG, p.zjz transzjz from frm_trans_up_queue_veh p, VEH_PRINT t where substr(p.zjz, 1, instr(p.zjz, '#', 1, 1)-1)=t.XH(+) and to_date(substr(p.zjz, instr(p.zjz, '#', 1, 1)+1), 'YYYY-MM-DD HH24:MI:SS')=t.ZZRQ(+) and p.jqmc='0601' and p.sjlx='0185' and p.zt ='2'

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

d4jcgmf5capqa SELECT COUNT(*) FROM USER_SEQUENCES WHERE SEQUENCE_NAME = :B1

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

f2tgc423ng3bx UPDATE ACD_T_LISTFILE SET BCGSJ = SYSDATE WHERE SGBH = :B4 AND WSLX = :B3 AND CZBJ = :B2 AND DLCRSJ = TO_DATE(:B1 , 'yyyy-mm-dd hh24:mi:ss')

f3g84j69n0tjh select col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc

f8pavn1bvsj7t select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1

fb9c9hzkdfhvn select * from acd_t_listfile where wslx like '4, %' order by dlcrsj, czbj

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

gdaj4m47tf5p9 UPDATE FRM_TRANS_TASK SET RWZT = '1' WHERE RWID = :B1

SQL Id	SQL Text
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0fr8zhn4ymu3v	select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
0pysymcxq0m05	BEGIN Trans_Basic_Pkg.Initupqueue(:1, :2, :3, :4, :5, :6); END;
139vuayh56w4w	BEGIN Acd_Comm_Pkg.Saveacd_Task_Log(:1, :2, :3); END;
1dubbbfqnqvh9	SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
32bhha21dkv0v	select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
451q2032pshqm	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
4w33a18a3ma73	select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5dc572vuquzzc	DELETE FRM_TRANS_TASKRUNTIME WHERE RWID = :B3 AND TDBH = :B2 AND IPDZ = :B1
5fqmmgtf979p3	SELECT TO_CHAR(CREATED, 'yyyy-mm-dd hh24:mi:ss') FROM USER_OBJECTS WHERE OBJECT_NAME = 'ACD_FILE'
5ngzsfstg8tmy	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5wc2915k44m38	select user#, type# from user$ where name=:1
60vjfwg6gvg2k	INSERT INTO ACD_TASK_LOG (ZXXH, RWID, FLAG, FHXX, ZXSJ, CSBJ) VALUES (:B4 , :B3 , :B2 , SUBSTR(:B1 , 1, 450), SYSDATE, '0')
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6g4pv7gubrgqx	select * from frm_syspara where xtlb='31' and gjz='TTMRM' and cslx='2'
6qz82dptj0qr7	select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
6w7tyy2mgyp10	UPDATE FRM_TRANS_UP_QUEUE_VEH SET JQMC = '00' WHERE JQMC = :B1 AND SJLX IN (SELECT SJLX FROM FRM_TRANS_TASK_CONTENT WHERE RWID = :B2 ) AND ZT <> '0'
772s25v1y0x8k	select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7nuw4xwrnuwxq	select col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc
7wzw1gjwggfy0	select mrz from frm_syspara where xtlb='03' and gjz='TJXTJSDZ'
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8cuu0uynbrhbn	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
8kyvv5knwptbf	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
8pstj5xwgnc0s	select To_Char(sysdate, 'yyyy-mm-dd') from dual
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
8utxg8xacgmt8	BEGIN Trans_Basic_Pkg.Initupqueue_Veh(:1, :2, :3, :4, :5, :6); END;
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9g485acn2n30m	select col#, intcol#, reftyp, stabid, expctoid from refcon$ where obj#=:1 order by intcol# asc
9rfqm06xmuwu0	select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc
a73wbv1yu8x5c	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
abbhd888ndywn	INSERT INTO FRM_TRANS_TASKRUNTIME VALUES (:B5 , :B4 , :B3 , :B2 , :B1 )
am2mgzshv9t7u	select SGBH, '1' ZJGS, ZJLX, ZJLXFL, TPXH, DSRBH, TPSM, SLR, JBR, LRSJ, TP, SLTP, BZ from acd_photo where sgbh='2207220201200001' and zjlx='11' and tpxh='1'
avs2japq8nt2b	select /+FIRST_ROWS/ p.ph transph, t.XH, t.HPZL, t.SF, t.HPHM, t.CLPP1, t.CLXH, t.CLPP2, t.GCJK, t.ZZG, t.ZZCMC, t.CLSBDH, t.FDJH, t.CLLX, t.CSYS, t.SYXZ, t.SFZMHM, t.SFZMMC, t.SYR, t.SYQ, t.CCDJRQ, t.DJRQ, t.YXQZ, t.QZBFQZ, t.FZJG, t.GLBM, t.FPRQ, t.FZRQ, t.FDJRQ, t.FHGZRQ, t.BXZZRQ, t.BPCS, t.BZCS, t.BDJCS, t.DJZSBH, t.ZDJZSHS, t.DABH, t.XZQH, t.ZT, t.DYBJ, t.JBR, t.CLLY, t.LSH, t.FDJXH, t.RLZL, t.PL, t.GL, t.ZXXS, t.CWKC, t.CWKK, t.CWKG, t.HXNBCD, t.HXNBKD, t.HXNBGD, t.GBTHPS, t.ZS, t.ZJ, t.QLJ, t.HLJ, t.LTGG, t.LTS, t.ZZL, t.ZBZL, t.HDZZL, t.HDZK, t.ZQYZL, t.QPZK, t.HPZK, t.HBDBQK, t.CCRQ, t.HDFS, t.LLPZ1, t.PZBH1, t.LLPZ2, t.PZBH2, t.XSDW, t.XSJG, t.XSRQ, t.JKPZ, t.JKPZHM, t.HGZBH, t.NSZM, t.NSZMBH, t.GXRQ, t.XGZL, t.QMBH, t.HMBH, t.BZ, t.JYW, t.ZSXZQH, t.ZSXXDZ, t.YZBM1, t.LXDH, t.ZZZ, t.ZZXZQH, t.ZZXXDZ, t.YZBM2, t.ZDYZT, t.YXH, t.CYRY, t.DPHGZBH, t.SQDM, t.CLYT, t.YTSX, t.DZYX, t.XSZBH, t.SJHM, t.JYHGBZBH, t.DWBH, p.zjz transzjz from frm_trans_up_queue_veh p, VEHICLE t where p.zjz = t.XH(+) and p.jqmc='0601' and p.sjlx='0171' and p.zt ='2'
bfvbrw587uhqx	UPDATE FRM_TRANS_UP_QUEUE_VEH SET JQMC = :B1 WHERE PH IN (SELECT PH FROM (SELECT DISTINCT T.PH FROM FRM_TRANS_UP_QUEUE_VEH T, FRM_TRANS_TASK_CONTENT V WHERE T.SJLX = V.SJLX AND V.RWID = :B4 AND T.JQMC = '00' AND T.ZT = :B3 AND ROWNUM < :B2 * 30) WHERE ROWNUM <= :B2 )
c6awqs517jpj0	select /+ index(idl_char$ i_idl_char1) +/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cckz17g0nrkp4	select /+FIRST_ROWS/ p.ph transph, t.LSH, t.ZZRQ, t.XH, t.HPZL, t.HPHM, t.YWLX, t.YWYY, t.ZZLX, t.JBR, t.GLBM, t.ZXBH, t.DYJBH, t.KHDIP, t.FZJG, p.zjz transzjz from frm_trans_up_queue_veh p, VEH_PRINT t where substr(p.zjz, 1, instr(p.zjz, '#', 1, 1)-1)=t.XH(+) and to_date(substr(p.zjz, instr(p.zjz, '#', 1, 1)+1), 'YYYY-MM-DD HH24:MI:SS')=t.ZZRQ(+) and p.jqmc='0601' and p.sjlx='0185' and p.zt ='2'
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d4jcgmf5capqa	SELECT COUNT(*) FROM USER_SEQUENCES WHERE SEQUENCE_NAME = :B1
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
f2tgc423ng3bx	UPDATE ACD_T_LISTFILE SET BCGSJ = SYSDATE WHERE SGBH = :B4 AND WSLX = :B3 AND CZBJ = :B2 AND DLCRSJ = TO_DATE(:B1 , 'yyyy-mm-dd hh24:mi:ss')
f3g84j69n0tjh	select col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc
f8pavn1bvsj7t	select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
fb9c9hzkdfhvn	select * from acd_t_listfile where wslx like '4, %' order by dlcrsj, czbj
ga9j9xk5cy9s0	select /+ index(idl_sb4$ i_idl_sb41) +/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gdaj4m47tf5p9	UPDATE FRM_TRANS_TASK SET RWZT = '1' WHERE RWID = :B1

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

Statistic	Total	per Second	per Trans
CPU used by this session	64,125	17.74	7.19
CPU used when call started	35,062	9.70	3.93
CR blocks created	112	0.03	0.01
Cached Commit SCN referenced	1,150	0.32	0.13
Commit SCN cached	1	0.00	0.00
DB time	5,602,055	1,549.66	628.10
DBWR checkpoint buffers written	1,433	0.40	0.16
DBWR checkpoints	40	0.01	0.00
DBWR fusion writes	421	0.12	0.05
DBWR parallel query checkpoint buffers written	14	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	174	0.05	0.02
DBWR undo block writes	873	0.24	0.10
DFO trees parallelized	30	0.01	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	2,591	0.72	0.29
PX local messages sent	2,591	0.72	0.29
PX remote messages recv'd	2,006	0.55	0.22
PX remote messages sent	1,907	0.53	0.21
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	30	0.01	0.00
RowCR - row contention	24	0.01	0.00
RowCR attempts	1,674	0.46	0.19
RowCR hits	1,826	0.51	0.20
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	885,634	244.99	99.30
SQL*Net roundtrips to/from dblink	1,650	0.46	0.18
active txn count during cleanout	327	0.09	0.04
application wait time	304,801	84.31	34.17
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	15,177	4.20	1.70
branch node splits	0	0.00	0.00
buffer is not pinned count	1,101,797	304.78	123.53
buffer is pinned count	549,679	152.05	61.63
bytes received via SQL*Net from client	70,473,209	19,494.51	7,901.47
bytes received via SQL*Net from dblink	915,910	253.36	102.69
bytes sent via SQL*Net to client	877,889,372	242,844.42	98,429.13
bytes sent via SQL*Net to dblink	1,271,921	351.84	142.61
calls to get snapshot scn: kcmgss	675,143	186.76	75.70
calls to kcmgas	28,623	7.92	3.21
calls to kcmgcs	122	0.03	0.01
change write time	116	0.03	0.01
cleanout - number of ktugct calls	1,032	0.29	0.12
cleanouts and rollbacks - consistent read gets	47	0.01	0.01
cleanouts only - consistent read gets	430	0.12	0.05
cluster key scan block gets	97,912	27.08	10.98
cluster key scans	61,809	17.10	6.93
cluster wait time	45,971	12.72	5.15
commit batch performed	63	0.02	0.01
commit batch requested	63	0.02	0.01
commit batch/immediate performed	63	0.02	0.01
commit batch/immediate requested	63	0.02	0.01
commit cleanout failures: block lost	165	0.05	0.02
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	225	0.06	0.03
commit cleanout failures: cannot pin	17	0.00	0.00
commit cleanouts	28,057	7.76	3.15
commit cleanouts successfully completed	27,650	7.65	3.10
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	5,005	1.38	0.56
concurrency wait time	4,615	1.28	0.52
consistent changes	502	0.14	0.06
consistent gets	12,181,263	3,369.62	1,365.77
consistent gets - examination	1,563,728	432.56	175.33
consistent gets direct	3,312,867	916.42	371.44
consistent gets from cache	8,868,396	2,453.20	994.33
current blocks converted for CR	0	0.00	0.00
cursor authentications	42,124	11.65	4.72
data blocks consistent reads - undo records applied	271	0.07	0.03
db block changes	100,651	27.84	11.29
db block gets	129,052	35.70	14.47
db block gets direct	162	0.04	0.02
db block gets from cache	128,890	35.65	14.45
deferred (CURRENT) block cleanout applications	7,164	1.98	0.80
dirty buffers inspected	2,653	0.73	0.30
enqueue conversions	3,224	0.89	0.36
enqueue releases	774,572	214.26	86.85
enqueue requests	774,588	214.27	86.85
enqueue timeouts	15	0.00	0.00
enqueue waits	1,235	0.34	0.14
exchange deadlocks	4	0.00	0.00
execute count	727,508	201.25	81.57
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	4,780,590	1,322.42	536.00
free buffer requested	4,690,360	1,297.46	525.88
gc CPU used by this session	39,125	10.82	4.39
gc blocks lost	2	0.00	0.00
gc cr block build time	5	0.00	0.00
gc cr block flush time	46	0.01	0.01
gc cr block receive time	224	0.06	0.03
gc cr block send time	11	0.00	0.00
gc cr blocks received	4,072	1.13	0.46
gc cr blocks served	3,513	0.97	0.39
gc current block flush time	29	0.01	0.00
gc current block pin time	342	0.09	0.04
gc current block receive time	163,923	45.34	18.38
gc current block send time	1,606	0.44	0.18
gc current blocks received	1,469,218	406.42	164.73
gc current blocks served	546,988	151.31	61.33
gc local grants	1,639,855	453.62	183.86
gc remote grants	1,575,332	435.77	176.63
gcs messages sent	7,133,890	1,973.40	799.85
ges messages sent	35,782	9.90	4.01
global enqueue get time	305,329	84.46	34.23
global enqueue gets async	67,359	18.63	7.55
global enqueue gets sync	474,788	131.34	53.23
global enqueue releases	540,866	149.62	60.64
heap block compress	126	0.03	0.01
hot buffers moved to head of LRU	503,970	139.41	56.51
immediate (CR) block cleanout applications	477	0.13	0.05
immediate (CURRENT) block cleanout applications	4,326	1.20	0.49
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	5,659	1.57	0.63
index fast full scans (direct read)	1,651	0.46	0.19
index fast full scans (full)	50	0.01	0.01
index fast full scans (rowid ranges)	1,651	0.46	0.19
index fetch by key	402,875	111.44	45.17
index scans kdiixs1	236,800	65.50	26.55
leaf node 90-10 splits	21	0.01	0.00
leaf node splits	105	0.03	0.01
lob reads	491	0.14	0.06
lob writes	111	0.03	0.01
lob writes unaligned	96	0.03	0.01
logons cumulative	494	0.14	0.06
messages received	85,586	23.68	9.60
messages sent	85,586	23.68	9.60
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	10,559,083	2,920.89	1,183.89
opened cursors cumulative	464,695	128.55	52.10
parse count (failures)	2,562	0.71	0.29
parse count (hard)	285,424	78.95	32.00
parse count (total)	362,437	100.26	40.64
parse time cpu	18,728	5.18	2.10
parse time elapsed	65,348	18.08	7.33
physical read IO requests	908,037	251.18	101.81
physical read bytes	53,473,615,872	14,792,033.66	5,995,472.12
physical read total IO requests	917,333	253.76	102.85
physical read total bytes	53,623,456,768	14,833,483.11	6,012,272.31
physical read total multi block requests	379,369	104.94	42.53
physical reads	6,527,541	1,805.67	731.87
physical reads cache	3,214,674	889.25	360.43
physical reads cache prefetch	2,561,329	708.52	287.18
physical reads direct	3,312,867	916.42	371.44
physical reads direct (lob)	1,204	0.33	0.13
physical reads direct temporary tablespace	71	0.02	0.01
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	3,598	1.00	0.40
physical write bytes	39,313,408	10,874.99	4,407.83
physical write total IO requests	14,968	4.14	1.68
physical write total bytes	81,435,648	22,526.98	9,130.58
physical write total multi block requests	9,970	2.76	1.12
physical writes	4,799	1.33	0.54
physical writes direct	162	0.04	0.02
physical writes direct (lob)	71	0.02	0.01
physical writes direct temporary tablespace	71	0.02	0.01
physical writes from cache	4,637	1.28	0.52
physical writes non checkpoint	4,226	1.17	0.47
pinned buffers inspected	304	0.08	0.03
pinned cursors current	43	0.01	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	16	0.00	0.00
process last non-idle time	3,600	1.00	0.40
queries parallelized	30	0.01	0.00
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	3,046,207	842.65	341.54
recursive cpu usage	54,568	15.09	6.12
redo blocks written	42,682	11.81	4.79
redo buffer allocation retries	0	0.00	0.00
redo entries	54,612	15.11	6.12
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	937	0.26	0.11
redo size	17,875,768	4,944.85	2,004.23
redo subscn max counts	229	0.06	0.03
redo synch time	959	0.27	0.11
redo synch writes	8,817	2.44	0.99
redo wastage	3,285,256	908.78	368.34
redo write broadcast ack time	79	0.02	0.01
redo write time	1,062	0.29	0.12
redo writer latching time	0	0.00	0.00
redo writes	9,927	2.75	1.11
rollback changes - undo records applied	768	0.21	0.09
rollbacks only - consistent read gets	60	0.02	0.01
rows fetched via callback	198,094	54.80	22.21
session connect time	0	0.00	0.00
session cursor cache hits	142,470	39.41	15.97
session logical reads	12,310,315	3,405.32	1,380.23
shared hash latch upgrades - no wait	32,125	8.89	3.60
shared hash latch upgrades - wait	5	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	61,528	17.02	6.90
sorts (rows)	937,215	259.26	105.08
sql area evicted	285,711	79.03	32.03
sql area purged	2,562	0.71	0.29
summed dirty queue length	2,629	0.73	0.29
switch current to new buffer	528	0.15	0.06
table fetch by rowid	735,148	203.36	82.42
table fetch continued row	7,350	2.03	0.82
table scan blocks gotten	437,927	121.14	49.10
table scan rows gotten	45,492,522	12,584.28	5,100.63
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	5	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	5,920	1.64	0.66
total number of times SMON posted	0	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	63	0.02	0.01
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	10	0.00	0.00
undo change vector size	5,727,040	1,584.23	642.12
user I/O wait time	412,950	114.23	46.30
user calls	1,196,394	330.95	134.14
user commits	8,812	2.44	0.99
user rollbacks	107	0.03	0.01
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	29,257	8.09	3.28
write clones created in background	0	0.00	0.00
write clones created in foreground	1	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory max	34,878,549,096	35,263,323,408
session pga memory	63,469,719,600	64,335,919,008
session pga memory max	87,915,550,736	89,074,613,472
session cursor cache count	386,294	391,368
session uga memory	3.4E+13	3.4E+13
opened cursors current	9,276	9,472
logons current	1,431	1,459

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)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
DT_SYS_DAT	480,530	133	3.30	1.46	1,445	38,523	3.88
DT_SYS_IDX	210,059	58	0.02	15.77	46	28	3.93
DT_TRA_IDX	158,651	44	3.69	15.46	218	5	4.00
DT_ACC_DAT	25,307	7	8.10	1.00	15	0	0.00
SYSTEM	16,041	4	7.53	1.14	111	8	2.50
DT_ACC_IDX	11,994	3	7.67	1.00	9	0	0.00
SYSAUX	1,031	0	4.23	1.11	503	0	0.00
NTCIS_VEH_A	1,131	0	3.29	1.00	6	0	0.00
UNDOTBS1	461	0	8.63	1.00	474	0	0.00
NTCIS_VEH_INDEX	788	0	3.63	1.00	125	0	0.00
NTCIS_VIO	819	0	1.21	1.00	68	0	0.00
DT_TRA_DAT	220	0	4.68	1.06	179	16	2.50
DT_SYS_TMP	92	0	2.50	1.00	36	0	0.00
NTCIS	104	0	9.62	2.64	24	0	0.00
DT_VIO_IDX	97	0	2.27	1.00	23	0	0.00
NTCIS_VEH_C	62	0	4.84	1.00	56	0	0.00
DT_VEH_IDX	57	0	4.04	1.00	55	0	0.00
DT_VIO_DAT	51	0	1.96	1.00	45	0	0.00
NTCIS_DRV_INDEX	44	0	5.68	1.00	31	0	0.00
DT_VEH_DAT	24	0	2.08	1.00	21	0	0.00
NTCIS_INDEX	34	0	6.18	1.00	0	0	0.00
NTCIS_VEH_D	20	0	2.50	1.00	13	0	0.00
NTCIS_DRV_C	15	0	5.33	1.00	15	0	0.00
NTCIS_VEH_B	15	0	2.67	1.00	14	0	0.00
UNDOTBS2	26	0	1.92	1.00	0	11	0.00
NTCIS_VIO_INDEX	25	0	6.40	1.00	0	0	0.00
DT_BAS_IDX	18	0	5.00	1.00	4	0	0.00
NTCIS_VEH_F	16	0	2.50	1.00	6	0	0.00
NTCIS_VEH_G	9	0	6.67	1.00	7	0	0.00
DT_LOG_DAT	9	0	3.33	1.00	6	0	0.00
DT_LOG_IDX	9	0	4.44	1.00	4	0	0.00
NTCIS_DRV_A	8	0	5.00	1.00	4	0	0.00
NTCIS_DRV_B	8	0	6.25	1.00	4	0	0.00
NTCIS_DRV_H	7	0	1.43	1.00	5	0	0.00
NTCIS_DRV_OTHER	7	0	5.71	1.00	5	0	0.00
NTCIS_DRV_E	6	0	5.00	1.00	4	0	0.00
NTCIS_DRV_F	6	0	1.67	1.00	4	0	0.00
NTCIS_DRV_G	6	0	0.00	1.00	4	0	0.00
DT_BAS_DAT	7	0	5.71	2.57	2	0	0.00
DT_DTS_DAT	0	0	0.00	0.00	7	0	0.00
DT_VIO_IDX2	7	0	4.29	1.00	0	0	0.00
DT_DTS_IDX	6	0	5.00	1.00	0	0	0.00
NTCIS_TEMP	6	0	15.00	1.00	0	0	0.00
TEMP	6	0	10.00	1.00	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	Buffer Waits	Av Buf Wt(ms)
DT_ACC_DAT	+DATA/orcl/datafile/dt_acc_dat01.dbf	25,307	7	8.10	1.00	15	0	0.00
DT_ACC_IDX	+DATA/orcl/datafile/dt_acc_idx01.dbf	11,994	3	7.67	1.00	9	0	0.00
DT_BAS_DAT	+DATA/orcl/datafile/dt_bas_dat01.dbf	7	0	5.71	2.57	2	0	0.00
DT_BAS_IDX	+DATA/orcl/datafile/dt_bas_idx01.dbf	18	0	5.00	1.00	4	0	0.00
DT_DTS_DAT	+DATA/orcl/datafile/dt_dts_dat01.dbf	0	0			7	0	0.00
DT_DTS_IDX	+DATA/orcl/datafile/dt_dts_idx01.dbf	6	0	5.00	1.00	0	0	0.00
DT_LOG_DAT	+DATA/orcl/datafile/dt_log_dat01.dbf	9	0	3.33	1.00	6	0	0.00
DT_LOG_IDX	+DATA/orcl/datafile/dt_log_idx01.dbf	9	0	4.44	1.00	4	0	0.00
DT_SYS_DAT	+DATA/orcl/datafile/dt_sys_dat01.dbf	480,530	133	3.30	1.46	1,445	38,523	3.88
DT_SYS_IDX	+DATA/orcl/datafile/dt_sys_idx01.dbf	210,059	58	0.02	15.77	46	28	3.93
DT_SYS_TMP	+DATA/orcl/datafile/dt_sys_tmp01.dbf	86	0	1.98	1.00	36	0
DT_SYS_TMP	+DATA/orcl/datafile/dt_sys_tmp02.dbf	6	0	10.00	1.00	0	0
DT_TRA_DAT	+DATA/orcl/datafile/dt_tra_dat01.dbf	220	0	4.68	1.06	179	16	2.50
DT_TRA_IDX	+DATA/orcl/datafile/dt_tra_idx01.dbf	158,651	44	3.69	15.46	218	5	4.00
DT_VEH_DAT	+DATA/orcl/datafile/dt_veh_dat01.dbf	24	0	2.08	1.00	21	0	0.00
DT_VEH_IDX	+DATA/orcl/datafile/dt_veh_idx01.dbf	57	0	4.04	1.00	55	0	0.00
DT_VIO_DAT	+DATA/orcl/datafile/dt_vio_dat01.dbf	51	0	1.96	1.00	45	0	0.00
DT_VIO_IDX	+DATA/orcl/datafile/dt_vio_idx01.dbf	97	0	2.27	1.00	23	0	0.00
DT_VIO_IDX2	+DATA/orcl/datafile/dt_vio_idx201.dbf	7	0	4.29	1.00	0	0	0.00
NTCIS	+DATA/orcl/datafile/ntcis 01.dbf	104	0	9.62	2.64	24	0	0.00
NTCIS_DRV_A	+DATA/orcl/datafile/ntcis_drv_a 01.dbf	8	0	5.00	1.00	4	0	0.00
NTCIS_DRV_B	+DATA/orcl/datafile/ntcis_drv_b 01.dbf	8	0	6.25	1.00	4	0	0.00
NTCIS_DRV_C	+DATA/orcl/datafile/ntcis_drv_c 01.dbf	15	0	5.33	1.00	15	0	0.00
NTCIS_DRV_E	+DATA/orcl/datafile/ntcis_drv_e 01.dbf	6	0	5.00	1.00	4	0	0.00
NTCIS_DRV_F	+DATA/orcl/datafile/ntcis_drv_f 01.dbf	6	0	1.67	1.00	4	0	0.00
NTCIS_DRV_G	+DATA/orcl/datafile/ntcis_drv_g 01.dbf	6	0	0.00	1.00	4	0	0.00
NTCIS_DRV_H	+DATA/orcl/datafile/ntcis_drv_h 01.dbf	7	0	1.43	1.00	5	0	0.00
NTCIS_DRV_INDEX	+DATA/orcl/datafile/ntcis_drv_index 01.dbf	44	0	5.68	1.00	31	0	0.00
NTCIS_DRV_OTHER	+DATA/orcl/datafile/ntcis_drv_other 01.dbf	7	0	5.71	1.00	5	0	0.00
NTCIS_INDEX	+DATA/orcl/datafile/ntcis_index 01.dbf	34	0	6.18	1.00	0	0	0.00
NTCIS_TEMP	+DATA/orcl/datafile/ntcis_temp01.dbf	6	0	15.00	1.00	0	0
NTCIS_VEH_A	+DATA/orcl/datafile/ntcis_veh_a 01.dbf	1,131	0	3.29	1.00	6	0	0.00
NTCIS_VEH_B	+DATA/orcl/datafile/ntcis_veh_b 01.dbf	15	0	2.67	1.00	14	0	0.00
NTCIS_VEH_C	+DATA/orcl/datafile/ntcis_veh_c 01.dbf	62	0	4.84	1.00	56	0	0.00
NTCIS_VEH_D	+DATA/orcl/datafile/ntcis_veh_d 01.dbf	20	0	2.50	1.00	13	0	0.00
NTCIS_VEH_F	+DATA/orcl/datafile/ntcis_veh_f 01.dbf	16	0	2.50	1.00	6	0	0.00
NTCIS_VEH_G	+DATA/orcl/datafile/ntcis_veh_g 01.dbf	9	0	6.67	1.00	7	0	0.00
NTCIS_VEH_INDEX	+DATA/orcl/datafile/ntcis_veh_index 01.dbf	788	0	3.63	1.00	125	0	0.00
NTCIS_VIO	+DATA/orcl/datafile/ntcis_vio01.dbf	819	0	1.21	1.00	68	0	0.00
NTCIS_VIO_INDEX	+DATA/orcl/datafile/ntcis_vio_index 01.dbf	25	0	6.40	1.00	0	0	0.00
SYSAUX	+DATA/orcl/datafile/sysaux.261.761218243	1,031	0	4.23	1.11	503	0	0.00
SYSTEM	+DATA/orcl/datafile/system.259.761218229	16,041	4	7.53	1.14	111	8	2.50
TEMP	+DATA/orcl/tempfile/temp.262.761218247	6	0	10.00	1.00	0	0
UNDOTBS1	+DATA/orcl/datafile/undotbs1.260.761218241	311	0	10.74	1.00	249	0	0.00
UNDOTBS1	+DATA/orcl/datafile/undotbs11.dbf	150	0	4.27	1.00	225	0	0.00
UNDOTBS2	+DATA/orcl/datafile/undotbs2.263.761218253	14	0	2.86	1.00	0	6	0.00
UNDOTBS2	+DATA/orcl/datafile/undotbs202.dbf	1	0	0.00	1.00	0	0	0.00
UNDOTBS2	+DATA/orcl/datafile/undotbs203.dbf	11	0	0.91	1.00	0	5	0.00

Back to IO Stats
Back to Top

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	96,717	64	8,997,136	3,214,600	4,637	0	0	38,592

Advisory Statistics

Instance Recovery Stats
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 Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	0	408	4352	43127	737280	43127
E	0	2	2434	18366	19249	737280	19249

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 for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	80	0.10	9,585	1.17	435,290,711
D	160	0.19	19,170	1.15	429,408,163
D	240	0.29	28,755	1.14	423,689,350
D	320	0.38	38,340	1.12	417,804,900
D	400	0.48	47,925	1.10	411,307,321
D	480	0.58	57,510	1.09	404,100,488
D	560	0.67	67,095	1.07	396,929,921
D	640	0.77	76,680	1.05	389,714,921
D	720	0.87	86,265	1.03	382,382,456
D	800	0.96	95,850	1.01	375,150,364
D	832	1.00	99,684	1.00	372,391,122
D	880	1.06	105,435	0.99	368,252,219
D	960	1.15	115,020	0.97	361,517,104
D	1,040	1.25	124,605	0.95	354,815,448
D	1,120	1.35	134,190	0.93	348,113,429
D	1,200	1.44	143,775	0.92	341,411,863
D	1,280	1.54	153,360	0.90	334,706,945
D	1,360	1.63	162,945	0.88	327,978,762
D	1,440	1.73	172,530	0.86	321,248,563
D	1,520	1.83	182,115	0.84	314,542,626
D	1,600	1.92	191,700	0.83	307,838,364

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	194	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	5,366	1,492	5,314.75	0.00	0.00	0.00	0.00	549,470
E	5,366	1,413	5,440.20	0.00	0.00	0.00	0.00	549,470

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	29,011	29,011
64K	128K	71	71
128K	256K	2	2
256K	512K	42	42
512K	1024K	124	124
1M	2M	7	7

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
671	0.13	29,181.07	18,413.17	61.00	1,214
1,342	0.25	29,181.07	11,354.06	72.00	726
2,683	0.50	29,181.07	4,284.33	87.00	264
4,025	0.75	29,181.07	1,661.83	95.00	0
5,366	1.00	29,181.07	1,661.83	95.00	0
6,439	1.20	29,181.07	162.60	99.00	0
7,512	1.40	29,181.07	162.60	99.00	0
8,586	1.60	29,181.07	162.60	99.00	0
9,659	1.80	29,181.07	162.60	99.00	0
10,732	2.00	29,181.07	162.60	99.00	0
16,098	3.00	29,181.07	162.60	99.00	0
21,464	4.00	29,181.07	162.60	99.00	0
32,196	6.00	29,181.07	162.60	99.00	0
42,928	8.00	29,181.07	162.60	99.00	0

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)
448	0.70	71	8,301	3,110,105	1.00	49,731	1.15	67,807
512	0.80	134	9,806	3,112,330	1.00	47,506	1.10	68,448
576	0.90	197	11,164	3,114,551	1.00	45,285	1.05	69,089
640	1.00	260	12,827	3,116,742	1.00	43,094	1.00	69,730
704	1.10	323	14,424	3,118,911	1.00	40,925	0.95	70,374
768	1.20	386	16,025	3,121,060	1.00	38,776	0.90	71,023
832	1.30	449	17,675	3,123,188	1.00	36,648	0.85	71,675
896	1.40	512	19,277	3,125,295	1.00	34,541	0.80	72,333
960	1.50	575	21,128	3,127,363	1.00	32,473	0.75	72,998
1,024	1.60	638	23,354	3,129,389	1.00	30,447	0.71	73,665
1,088	1.70	700	25,762	3,131,383	1.00	28,453	0.66	74,337
1,152	1.80	763	28,137	3,133,351	1.01	26,485	0.61	75,014
1,216	1.90	826	30,621	3,135,291	1.01	24,545	0.57	75,696
1,280	2.00	889	32,906	3,137,201	1.01	22,635	0.53	76,389

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
768	0.50	1,522,599	444,671,131
1,152	0.75	1,411,423	409,033,389
1,536	1.00	1,297,264	372,390,194
1,920	1.25	1,187,515	337,162,082
2,304	1.50	1,134,457	323,085,732
2,688	1.75	1,121,485	323,085,732
3,072	2.00	1,115,517	323,085,732

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	38,535	150	4
1st level bmb	30	0	4
segment header	7	0	3
undo block	11	0	0
2nd level bmb	6	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	42	41	0	41	3,114	75,957.83
KO-Multiple Object Checkpoint (fast object checkpoint)	245	245	0	79	2	27.20
TM-DML	132,498	132,498	0	669	0	0.50
PS-PX Process Reservation	540	539	0	214	0	0.60
TX-Transaction (index contention)	5	5	0	5	0	15.00
TT-Tablespace	737	737	0	118	0	0.43
FB-Format Block	43	43	0	33	0	0.70
JQ-Job Queue	98	83	15	22	0	0.82
CF-Controlfile Transaction	8,314	8,314	0	20	0	0.55
SQ-Sequence Cache	110	110	0	3	0	3.33
WF-AWR Flush	23	23	0	12	0	0.58
HW-Segment High Water Mark	314	314	0	4	0	0.75
TD-KTF map table enqueue (KTF dump entries)	6	6	0	6	0	0.33
DR-Distributed Recovery	2	2	0	2	0	1.00
MW-MWIN Schedule	2	2	0	2	0	1.00
AF-Advisor Framework (task serialization)	7	7	0	1	0	1.00
PG-Global Parameter	34	34	0	1	0	1.00
SR-Synchronized Replication	409	409	0	2	0	0.00
PE-Parameter	68	68	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	0.88	9,587	1,377	8	25000/25000	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
07-Feb 08:59	335	2,256	1,377	2	25,000	0/0	0/0/0/0/0/0
07-Feb 08:49	5	115	774	1	25,000	0/0	0/0/0/0/0/0
07-Feb 08:39	17	444	173	6	25,000	0/0	0/0/0/0/0/0
07-Feb 08:29	67	874	341	7	25,000	0/0	0/0/0/0/0/0
07-Feb 08:19	132	2,573	106	8	25,000	0/0	0/0/0/0/0/0
07-Feb 08:09	326	3,325	0	3	25,000	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
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
ASM allocation	340	0.00		0	0
ASM db client latch	2,523	0.00		0	0
ASM map headers	238	0.00		0	0
ASM map load waiting list	34	0.00		0	0
ASM map operation freelist	1,300	0.00		0	0
ASM map operation hash table	1,976,436	0.00	0.00	0	0
ASM network background latch	1,674	0.00		0	0
AWR Alerted Metric Element list	109,549	0.00		0	0
Consistent RBA	9,928	0.00		0	0
FAL request queue	72	0.00		0	0
FAL subheap alocation	72	0.00		0	0
FIB s.o chain latch	68	0.00		0	0
FOB s.o list latch	2,834	0.04	0.00	0	0
JS broadcast add buf latch	824	0.00		0	0
JS broadcast drop buf latch	824	0.00		0	0
JS broadcast load blnc latch	717	0.00		0	0
JS mem alloc latch	6	0.00		0	0
JS queue access latch	6	0.00		0	0
JS queue state obj latch	34,676	0.00		0	0
KCL gc element parent latch	15,341,082	0.12	0.00	0	62,789	0.04
KFK SGA context latch	862	0.00		0	0
KFMD SGA	134	0.75	0.00	0	0
KJC message pool free list	240,866	5.70	0.00	0	89,802	0.01
KJCT flow control latch	4,394,930	0.01	0.00	0	0
KMG MMAN ready and startup request latch	1,210	0.00		0	0
KMG resize request state object freelist	36	0.00		0	0
KSXR large replies	240	0.00		0	0
KTF sga latch	12	0.00		0	1,014	0.00
KWQMN job cache list latch	1,766	0.00		0	0
KWQP Prop Status	411	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	352	0.00		0	1,209	0.00
Memory Queue	409	0.00		0	0
OS process	1,851	0.00		0	0
OS process allocation	2,473	0.00		0	0
OS process: request allocation	504	0.00		0	0
PL/SQL warning settings	5,164	0.00		0	0
SGA IO buffer pool latch	31,777	0.01	1.50	0	31,777	0.04
SQL memory manager latch	1	0.00		0	1,202	0.00
SQL memory manager workarea list latch	89,549	0.00		0	0
Shared B-Tree	2,645	0.00		0	0
active checkpoint queue latch	3,625	0.19	0.00	0	0
active service list	10,871	0.47	0.00	0	4,493	0.00
archive control	60	0.00		0	0
archive process latch	1,346	0.00		0	0
begin backup scn array	71	0.00		0	0
bq:time manger info latch	131	0.00		0	0
buffer pool	2,710	0.00		0	0
bufq statistics	411	0.00		0	0
business card	42	0.00		0	0
cache buffer handles	940	0.00		0	0
cache buffers chains	26,464,590	0.33	0.01	0	11,594,160	0.07
cache buffers lru chain	3,245,451	0.14	0.00	0	5,503,258	0.17
cache table scan latch	0			0	171,245	0.06
channel handle pool latch	553	0.00		0	0
channel operations parent latch	2,076,659	0.00	0.00	0	0
checkpoint queue latch	214,286	0.00	0.00	0	15,524	0.01
client/application info	1,930	0.00		0	0
commit callback allocation	12	0.00		0	0
compile environment latch	507	0.00		0	0
dml lock allocation	265,053	0.01	0.00	0	0
dummy allocation	986	2.03	0.00	0	0
enqueue hash chains	1,822,805	0.01	0.00	0	3,490	0.00
enqueues	1,408,927	0.06	0.00	0	0
error message lists	274	1.82	0.00	0	0
event group latch	269	0.00		0	0
file cache latch	2,362	0.00		0	0
gcs opaque info freelist	782,610	0.19	0.00	0	0
gcs partitioned table hash	37,428,794	0.00		0	1,521,265	0.00
gcs remaster request queue	10	0.00		0	0
gcs remastering latch	7,415,854	0.00	0.25	0	286	0.00
gcs resource freelist	2,046,402	0.00	0.00	0	1,471,146	0.00
gcs resource hash	15,681,939	0.02	0.00	0	14	0.00
gcs resource scan list	28	0.00		0	0
gcs shadows freelist	1,793,876	0.00		0	1,793,403	0.00
ges caches resource lists	545,308	0.02	0.00	0	101,510	0.05
ges deadlock list	1,069	0.00		0	190	0.00
ges domain table	946,424	0.00	0.00	0	0
ges enqueue table freelist	982,558	0.00	0.00	0	0
ges group table	1,415,101	0.00	0.00	0	0
ges process hash list	72,097	0.00		0	2	0.00
ges process parent latch	2,152,171	0.00	0.00	0	0
ges process table freelist	504	0.00		0	0
ges resource hash list	1,629,004	0.03	0.00	0	66,692	0.00
ges resource scan list	100	0.00		0	0
ges resource table freelist	118,757	0.00	0.00	0	0
ges synchronous data	288	1.04	0.00	0	122,496	0.01
ges timeout list	10,888	0.00		0	5,613	0.00
global KZLD latch for mem in SGA	77	0.00		0	0
global tx hash mapping	1,872	0.00		0	0
hash table column usage latch	914	0.00		0	897,660	0.00
hash table modification latch	120	0.00		0	0
interrupt manipulation	1,181	1.02	0.00	0	0
job workq parent latch	0			0	170	0.00
job_queue_processes parameter latch	145	0.00		0	0
kks stats	1,563,136	0.01	0.01	0	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
kokc descriptor allocation latch	546	0.00		0	0
ksuosstats global area	243	0.00		0	0
ktm global data	12	0.00		0	0
kwqbsn:qsga	2,101	0.00		0	0
lgwr LWN SCN	10,608	0.01	0.00	0	0
library cache	10,408,860	0.03	0.00	0	1,356,723	0.74
library cache load lock	29,504	0.02	0.00	0	11	0.00
library cache lock	9,301,037	0.01	0.00	0	0
library cache lock allocation	6,096	0.00		0	0
library cache pin	2,107,261	0.00	0.00	0	1	0.00
library cache pin allocation	834	0.00		0	0
list of block allocation	596	0.00		0	0
loader state object freelist	3,590	0.67	0.00	0	0
logminer context allocation	1	0.00		0	0
longop free list parent	45	0.00		0	45	0.00
message pool operations parent latch	1,278	0.00		0	0
messages	387,469	0.02	0.00	0	0
mostly latch-free SCN	11,044	3.79	0.00	0	0
msg queue	68	0.00		0	68	0.00
multiblock read objects	574,046	0.02	0.01	0	0
name-service memory objects	10,550	0.00		0	0
name-service namespace bucket	37,656	0.00		0	0
name-service pending queue	8,134	0.00		0	0
name-service request	90	0.00		0	0
name-service request queue	44,699	0.00		0	0
ncodef allocation latch	60	0.00		0	0
object queue header heap	20,458	0.00		0	6,841	0.00
object queue header operation	9,383,865	0.01	0.01	0	7,670	0.01
object stats modification	39	0.00		0	0
parallel query alloc buffer	2,520	0.67	0.00	0	0
parallel query stats	251	3.98	0.00	0	0
parallel txn reco latch	1,176	0.00		0	0
parameter list	371	0.00		0	0
parameter table management	1,020	0.00		0	0
post/wait queue	18,613	0.00		0	9,063	0.01
process allocation	32,179	0.01	1.00	0	269	0.00
process group creation	504	0.00		0	0
process queue	929	0.65	0.00	0	0
process queue reference	96,317	0.01	0.00	0	5,334	0.06
qmn task queue latch	3,828	4.70	0.25	0	0
query server freelists	688	1.16	0.00	0	0
query server process	19	0.00		0	13	0.00
queued dump request	18,061	0.00		0	0
redo allocation	31,209	0.02	0.00	0	54,829	0.08
redo copy	0			0	54,850	0.14
redo writing	35,740	0.02	0.00	0	0
resmgr group change latch	442	0.00		0	0
resmgr:active threads	971	0.00		0	0
resmgr:actses change group	321	0.00		0	0
resmgr:free threads list	970	2.89	0.00	0	0
resmgr:resource group CPU method	288	1.39	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	64,065,986	0.37	0.00	0	389,700	0.12
rules engine aggregate statistics	6	0.00		0	0
rules engine rule set statistics	112	0.00		0	0
segmented array pool	68	0.00		0	0
sequence cache	2,209	0.00		0	0
session allocation	311,917	0.05	0.01	0	0
session idle bit	2,538,838	0.00	0.00	0	0
session state list latch	1,106	4.43	0.00	0	0
session switching	1,235	0.00		0	0
session timer	1,249	0.00		0	0
shared pool	12,491,338	0.37	0.11	2	0
shared pool simulator	1,780,147	0.00	0.00	0	0
simulator hash latch	1,435,390	0.00	0.00	0	0
simulator lru latch	1,575	0.06	1.00	0	888,241	0.72
slave class	212	0.00		0	0
slave class create	1,631	0.12	1.00	0	0
sort extent pool	139	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	1,176	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	2,801	0.00		0	0
trace latch	43	0.00		0	0
transaction allocation	659	0.00		0	2	0.00
transaction branch allocation	1,758	0.00		0	0
undo global data	39,058	0.01	0.00	0	0
user lock	425	0.24	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
row cache objects	64,065,986	235,274	44	235,230
cache buffers chains	26,464,590	87,698	1,065	86,657
shared pool	12,491,338	45,833	5,270	41,076
KCL gc element parent latch	15,341,082	19,072	70	19,008
KJC message pool free list	240,866	13,729	7	13,722
cache buffers lru chain	3,245,451	4,703	6	4,697
library cache	10,408,860	3,450	11	3,439
gcs resource hash	15,681,939	2,408	8	2,400
library cache lock	9,301,037	1,322	2	1,320
object queue header operation	9,383,865	1,002	12	990
enqueues	1,408,927	862	1	861
ges resource hash list	1,629,004	539	2	537
qmn task queue latch	3,828	180	45	135
session allocation	311,917	150	2	148
kks stats	1,563,136	143	1	142
multiblock read objects	574,046	87	1	86
gcs remastering latch	7,415,854	16	4	12
SGA IO buffer pool latch	31,777	2	3	0
process allocation	32,179	2	2	0
slave class create	1,631	2	2	0
simulator lru latch	1,575	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
KCL gc element parent latch	kclzcl	40	7
KCL gc element parent latch	kclnfndnewm	31	8
KCL gc element parent latch	kclplz	27	19
KCL gc element parent latch	KCLUNLNK	12	70
KCL gc element parent latch	kclulb	5	13
KCL gc element parent latch	kclchkping	3	0
KJC message pool free list	kjcsmpav: allocate a msg buffer	4	7
KJC message pool free list	kjcspfmbq: free vector of msg buffers	3	0
SGA IO buffer pool latch	ksfd_free_sgabuffer	2	3
SGA IO buffer pool latch	ksfd_alloc_sgabuffer	1	0
cache buffers chains	kcbgtcr: kslbegin excl	1,964	2,052
cache buffers chains	kclcls_3	202	3
cache buffers chains	kcbrls: kslbegin	72	128
cache buffers chains	kcbzwb	40	105
cache buffers chains	kcbgcur: buf pinned	23	22
cache buffers chains	kcbzib: multi-block read: nowait	20	0
cache buffers chains	kcbgcur: kslbegin	12	7
cache buffers chains	kcbzgb: scan from tail. nowait	9	0
cache buffers chains	kcbgtcr: fast path	6	2
cache buffers chains	kcbchg: kslbegin: bufs not pinned	2	9
cache buffers chains	kcbzib: finish free bufs	2	17
cache buffers chains	kclbla	1	0
cache buffers chains	kclexpandlock	1	0
cache buffers chains	kclfpdb	1	0
cache buffers chains	kclobj_1	1	0
cache buffers chains	kclwcrs_2	1	174
cache buffers lru chain	kcbzgb: wait - one set in buffer pool	3	6
cache buffers lru chain	kcbzgws	3	0
enqueues	ksqdel	1	1
event range base latch	No latch	46	45
gcs remastering latch	43	4	0
gcs resource hash	kjbcropen	2	0
gcs resource hash	kjblocalfile_nolock	2	2
gcs resource hash	kjbrrcfwst	2	0
gcs resource hash	kjbassume	1	1
gcs resource hash	kjbcropen:affinity	1	0
ges resource hash list	kjakcai: search for resp by resname	1	0
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	1	0
kks stats	kks stats alloc/free	1	1
library cache	kgldti: 2child	3	1
library cache	kglic	2	0
library cache	kglobpn: child:	2	1
library cache	kglpndl: child: after processing	1	0
library cache lock	kgllkdl: child: no lock handle	3	1
library cache lock	kgllkal: child: multiinstance	1	1
multiblock read objects	kcbzib: normal mbr free	1	1
object queue header operation	kcbw_unlink_q	10	14
object queue header operation	kclobj_1	4	1
object queue header operation	kcbw_link_q	3	3
object queue header operation	kclobj_3	2	1
process allocation	ksucrp	1	0
process allocation	ksufap: active procs	1	1
row cache objects	kqrpre: find obj	15	16
row cache objects	kqreqd: reget	11	0
row cache objects	kqrigt	5	1
row cache objects	ksucallcbksafely: kqrhngc	4	0
row cache objects	kqreqd	3	10
row cache objects	kqrbtm: pop parent	1	2
row cache objects	kqrso	1	0
session allocation	kspallmod	2	0
shared pool	kghalo	4,100	2,590
shared pool	kgh: quiesce extents	442	0
shared pool	kghfrunp: alloc: wait	282	0
shared pool	kghupr1	259	1,343
shared pool	kghasp	51	126
shared pool	kgh_next_free	50	1
shared pool	kgh: add extent to quiesced list	35	0
shared pool	kghfre	24	197
shared pool	kghalp	23	1,011
shared pool	kgh: sim resz update	4	0
shared pool	kghfrunp: clatch: nowait	3	0
shared pool	kghfrunp: clatch: wait	1	6
simulator lru latch	kcbs_grow_pool	1	0
slave class create	ksvcreate	2	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 12,310,315
Captured Segments account for 96.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TRFF_RES	DT_SYS_IDX	PRM_DTRANSQUEUE_PHSJLXZJZ	INDEX	3,343,488	27.16
TRFF_RES	DT_SYS_DAT	IDX_ITRANSUPQUEUE_JQMC	INDEX	3,146,832	25.56
TRFF_RES	DT_TRA_IDX	IDX_VTRANSUPQUEUE_ZJZ	INDEX	2,518,560	20.46
TRFF_RES	DT_SYS_DAT	FRM_TRANS_UP_QUEUE	TABLE	367,280	2.98
TRFF_RES	DT_SYS_DAT	PK_ACD_T_LISTFILE	INDEX	349,296	2.84

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 6,527,541
Captured Segments account for 99.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TRFF_RES	DT_SYS_IDX	PRM_DTRANSQUEUE_PHSJLXZJZ	INDEX	3,311,696	50.73
TRFF_RES	DT_TRA_IDX	IDX_VTRANSUPQUEUE_ZJZ	INDEX	2,451,664	37.56
TRFF_RES	DT_SYS_DAT	IDX_ITRANSUPQUEUE_JQMC	INDEX	270,847	4.15
TRFF_RES	DT_SYS_DAT	IDX_DTRANSUPQUEUE_JQMC	INDEX	259,252	3.97
TRFF_RES	DT_SYS_DAT	IDX_VTRANSUPQUEUE_SJLX	INDEX	140,549	2.15

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
TRFF_RES	DT_TRA_DAT	FRM_TRANS_TASK	TABLE	54	62.79
TRFF_RES	DT_TRA_DAT	FRM_TRANS_TASK_CONTENT	TABLE	30	34.88
TRFF_RES	DT_TRA_IDX	PK_TRANSROW_ZXSJ	INDEX	2	2.33

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% 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
TRFF_RES	DT_SYS_DAT	PK_TRANS_TASK_RUNNING	INDEX	97	71.85
TRFF_RES	DT_SYS_DAT	FRM_TRANS_TASKRUNTIME	TABLE	24	17.78
SYS	SYSTEM	JOB$	TABLE	8	5.93
TRFF_RES	DT_TRA_DAT	FRM_TRANS_TASK	TABLE	2	1.48
TRFF_RES	DT_SYS_DAT	PK_FRM_TRANS_JQMC	INDEX	2	1.48

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

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

Owner	Tablespace Name	Object Name	Obj. Type	GC Buffer Busy	% of Capture
TRFF_RES	DT_SYS_DAT	IDX_ITRANSUPQUEUE_JQMC	INDEX	36,177	96.41
TRFF_RES	DT_SYS_DAT	FRM_TRANS_UP_QUEUE	TABLE	1,118	2.98
TRFF_RES	DT_SYS_DAT	PK_TRANS_TASK_RUNNING	INDEX	186	0.50
TRFF_RES	DT_SYS_IDX	PRM_DTRANSQUEUE_PHSJLXZJZ	INDEX	22	0.06
TRFF_RES	DT_TRA_DAT	FRM_TRANS_TASK_CONTENT	TABLE	6	0.02

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 4,072
Captured Segments account for 93.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
TRFF_RES	DT_SYS_DAT	FRM_TRANS_UP_QUEUE_VEH	TABLE	1,290	31.68
TRFF_RES	DT_SYS_DAT	IDX_VTRANSUPQUEUE_SJLX	INDEX	1,135	27.87
SYS	SYSTEM	JOB$	TABLE	568	13.95
TRFF_RES	DT_TRA_IDX	IDX_VTRANSUPQUEUE_ZJZ	INDEX	179	4.40
TRFF_RES	DT_TRA_DAT	FRM_TRANS_JQMC	TABLE	116	2.85

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 1,469,218
Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
TRFF_RES	DT_SYS_DAT	IDX_ITRANSUPQUEUE_JQMC	INDEX	1,378,290	93.81
TRFF_RES	DT_TRA_IDX	IDX_VTRANSUPQUEUE_ZJZ	INDEX	66,118	4.50
TRFF_RES	DT_SYS_DAT	IDX_DTRANSUPQUEUE_JQMC	INDEX	16,899	1.15
TRFF_RES	DT_SYS_DAT	IDX_VTRANSUPQUEUE_SJLX	INDEX	2,190	0.15
TRFF_RES	DT_SYS_DAT	FRM_TRANS_UP_QUEUE_VEH	TABLE	1,442	0.10

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats
Dictionary Cache Stats (RAC)

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	66	78.79	1	1
dc_database_links	296	8.78	0	0
dc_global_oids	604	56.62	0	0
dc_histogram_data	1,031,757	3.54	0	597
dc_histogram_defs	17,290,101	0.26	0	1,411
dc_object_grants	238	24.37	0	0
dc_object_ids	2,031,836	0.29	0	299
dc_objects	301,118	2.04	0	230
dc_profiles	159	23.90	0	0
dc_rollback_segments	2,586	0.00	0	100
dc_segments	878,432	0.61	6	271
dc_sequences	113	93.81	113	1
dc_tablespaces	15,715	5.34	0	18
dc_usernames	6,297	5.18	0	2
dc_users	297,027	0.25	0	5
outstanding_alerts	1,367	99.93	6	0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	54	1	51
dc_database_links	26	0	28
dc_global_oids	342	0	350
dc_histogram_defs	44,935	0	45,293
dc_object_ids	5,924	0	6,018
dc_objects	6,153	0	6,244
dc_profiles	38	0	39
dc_segments	5,408	5	5,453
dc_sequences	226	3	102
dc_tablespaces	839	0	936
dc_usernames	326	0	332
dc_users	495	0	509
outstanding_alerts	2,726	672	693

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Library Cache Activity
Library Cache Activity (RAC)

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	416	27.40	123,721	0.34	287	0
CLUSTER	1,228	0.90	5,019	1.71	75	0
INDEX	44	50.00	137	16.06	0	0
SQL AREA	575,321	76.73	2,354,434	77.06	359,101	295,409
TABLE/PROCEDURE	20,328	11.63	1,021,990	1.34	6,367	0
TRIGGER	20	65.00	77	25.97	7	0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases	GES Inval Requests
CLUSTER	5,019	11	11	11
INDEX	137	22	22	22
TABLE/PROCEDURE	328,107	1,088	1,124	774

Back to Library Cache Statistics
Back to Top

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

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	4,514.32		3.15	0.94	13	15	1,434	1,434
	Freeable	703.63	0.00	0.73	0.36	2		969	969
	SQL	55.41	51.74	0.04	0.04	1	5	1,410	1,405
	PL/SQL	42.75	37.47	0.03	0.01	0	21	1,432	1,432
E	Other	4,634.43		3.16	0.93	13	15	1,468	1,468
	Freeable	706.38	0.00	0.72	0.36	2		981	981
	SQL	57.15	53.34	0.04	0.04	1	5	1,447	1,438
	PL/SQL	43.62	38.26	0.03	0.01	0	21	1,466	1,460

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	587,202,560	872,415,232
Fixed Size	2,096,736
Redo Buffers	14,680,064
Variable Size	1,006,633,376	721,420,704

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	ASM map operations hashta	0.38	0.38	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.60	14.60	0.00
shared	ASH buffers	29.00	29.00	0.00
shared	CCursor	57.15	35.02	-38.72
shared	FileOpenBlock	15.20	15.20	0.00
shared	KGH: NO ACCESS	440.71	712.11	61.58
shared	PCursor	39.50	26.24	-33.57
shared	event statistics per sess	19.92	19.92	0.00
shared	free memory	138.90	163.39	17.63
shared	gcs resources	34.04	34.04	0.00
shared	ges big msg buffers	15.20	15.20	0.00
shared	ges enqueues	21.29	21.32	0.16
shared	library cache	45.04	38.30	-14.98
shared	parameter table block	17.71	18.05	1.96
shared	sql area	280.83	27.82	-90.09
shared	trace buffer	22.53	23.20	2.98
streams	KGH: NO ACCESS	15.98	15.98	0.00
streams	free memory	16.00	16.00	0.00
	buffer_cache	560.00	832.00	48.57
	fixed_sga	2.00	2.00	0.00
	log_buffer	14.00	14.00	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	5,860,000	446,958	0
QMON Coordinator	370,000	0	0

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 Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

The Spill Rate should be very close to zero
The Diff in Percentage Spilled should be very close to zero or negative

Queue Schema and Name	Incoming per second	Outgoing per second	Spilled per second	Diff Pct Spilled
SYS.KUPC$S_1_20130121165457	0	0	0	0

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	6	0	0	27	64

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	9,439	220,224	108597	108597
gcs_shadows	5,010	120,960	108597	108597

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/admin/orcl/adump
background_dump_dest	/oracle/admin/orcl/bdump
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.5.0
control_files	+DATA/orcl/controlfile/current.256.761218225
core_dump_dest	/oracle/admin/orcl/cdump
db_block_size	8192
db_create_file_dest	+DATA
db_domain
db_file_multiblock_read_count	16
db_name	orcl
dispatchers	(PROTOCOL=TCP) (SERVICE=orclXDB)
instance_number	1
job_queue_processes	500
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.106.112.7)(PORT=1521))
log_archive_dest_1	LOCATION=+DATA/
log_archive_format	%t_%s_%r.dbf
open_cursors	10000
pga_aggregate_target	5626658816
processes	2000
remote_listener	LISTENERS_ORCL
remote_login_passwordfile	EXCLUSIVE
service_names	zydb, SYS$SYS.KUPC$S_1_20130121165457.ORCL, orcl
sessions	2205
sga_target	1610612736
spfile	+DATA/orcl/spfileorcl.ora
thread	1
undo_management	AUTO
undo_retention	1500000
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/orcl/udump
utl_file_dir	/oracle/log

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	16,991	4.70	1.91
acks for commit broadcast(logical)	17,581	4.86	1.97
broadcast msgs on commit(actual)	9,909	2.74	1.11
broadcast msgs on commit(logical)	9,927	2.75	1.11
broadcast msgs on commit(wasted)	364	0.10	0.04
broadcast on commit wait time(ms)	510	0.14	0.06
broadcast on commit waits	5,282	1.46	0.59
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	269,607	74.58	30.23
gcs ast xid	3	0.00	0.00
gcs blocked converts	2,395	0.66	0.27
gcs blocked cr converts	4,412	1.22	0.49
gcs compatible basts	466	0.13	0.05
gcs compatible cr basts (global)	483	0.13	0.05
gcs compatible cr basts (local)	388,310	107.42	43.54
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	379	0.10	0.04
gcs dbwr write request msgs	107	0.03	0.01
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	4,748	1.31	0.53
gcs immediate (null) converts	76,876	21.27	8.62
gcs immediate cr (compatible) converts	16	0.00	0.00
gcs immediate cr (null) converts	1,540,837	426.23	172.76
gcs indirect ast	353,641	97.83	39.65
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	219	0.06	0.02
gcs msgs process time(ms)	66,470	18.39	7.45
gcs msgs received	5,060,443	1,399.84	567.38
gcs out-of-order msgs	2	0.00	0.00
gcs pings refused	24	0.01	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	30	0.01	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	1	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	7	0.00	0.00
gcs side channel msgs actual	23,259	6.43	2.61
gcs side channel msgs logical	1,802,944	498.74	202.15
gcs stale cr	48	0.01	0.01
gcs undo cr	237	0.07	0.03
gcs write notification msgs	7	0.00	0.00
gcs writes refused	1	0.00	0.00
ges msgs process time(ms)	465	0.13	0.05
ges msgs received	46,447	12.85	5.21
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	6	0.00	0.00
global posts requested	6	0.00	0.00
global posts sent	6	0.00	0.00
implicit batch messages received	192,168	53.16	21.55
implicit batch messages sent	244,163	67.54	27.38
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	25,542	7.07	2.86
messages queue sent actual	344,828	95.39	38.66
messages queue sent logical	3,061,311	846.83	343.23
messages received actual	1,050,047	290.47	117.73
messages received logical	5,106,941	1,412.70	572.59
messages sent directly	369,095	102.10	41.38
messages sent indirectly	2,976,775	823.44	333.76
messages sent not implicit batched	100,669	27.85	11.29
messages sent pbatched	3,908,923	1,081.30	438.27
msgs causing lmd to send msgs	18,892	5.23	2.12
msgs causing lms(s) to send msgs	112,410	31.10	12.60
msgs received queue time (ms)	592,577	163.92	66.44
msgs received queued	5,106,995	1,412.71	572.60
msgs sent queue time (ms)	721,072	199.47	80.85
msgs sent queue time on ksxp (ms)	386,140	106.82	43.29
msgs sent queued	3,024,198	836.56	339.07
msgs sent queued on ksxp	1,087,990	300.96	121.99
number of ges deadlock detected	0	0.00	0.00
process batch messages received	288,453	79.79	32.34
process batch messages sent	507,584	140.41	56.91

Global CR Served Stats

Statistic	Total
CR Block Requests	3,310
CURRENT Block Requests	325
Data Block Requests	3,310
Undo Block Requests	26
TX Block Requests	256
Current Results	3,581
Private results	8
Zero Results	33
Disk Read Results	13
Fail Results	0
Fairness Down Converts	502
Fairness Clears	0
Free GC Elements	0
Flushes	56
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	58
Errors	0

Global CURRENT Served Stats

Pins = CURRENT Block Pin Operations
Flushes = Redo Flush before CURRENT Block Served Operations
Writes = CURRENT Block Fusion Write Operations

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	547,043	99.99	0.00	0.01	0.00	0.00
Flushes	67	68.66	20.90	10.45	0.00	0.00
Writes	421	14.25	52.02	31.12	2.14	0.48

Global Cache Transfer Stats

Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
Busy (Busy) - Block Transfer impacted by Remote Contention
Congested (Congst) - Block Transfer impacted by Remote System Load
ordered by CR + Current Blocks Received desc

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	3,877	98.68	1.32	0.00	1,468,789	99.96	0.01	0.04
2	Others	28	100.00	0.00	0.00	384	100.00	0.00	0.00
2	undo header	112	93.75	6.25	0.00	1	100.00	0.00	0.00
2	undo block	35	100.00	0.00	0.00	0

End of Report

% Blocks changed per Read:	0.82	Recursive Call %:	71.80
Rollback per transaction %:	1.20	Rows per Sort:	15.23

Buffer Nowait %:	99.69	Redo NoWait %:	100.00
Buffer Hit %:	73.90	In-memory Sort %:	100.00
Library Hit %:	47.84	Soft Parse %:	21.25
Execute to Parse %:	50.18	Latch Hit %:	99.83
Parse CPU to Parse Elapsd %:	28.66	% Non-Parse CPU:	87.15

Buffer access - local cache %:	61.93
Buffer access - remote cache %:	11.97
Buffer access - disk %:	26.10

Avg global enqueue get time (ms):	5.6
Avg global cache cr block receive time (ms):	0.6
Avg global cache current block receive time (ms):	1.1
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	1.6
Avg global cache cr block flush time (ms):	8.2
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):	4.3

Avg message sent queue time (ms):	0.2
Avg message sent queue time on ksxp (ms):	0.4
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	10.95
% of indirect sent messages:	88.29
% of flow controlled messages:	0.76