WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

CWGKVPD 543330226 CWGKVPD2 2 10.2.0.4.0 YES GKdb2

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
CWGKVPD	543330226	CWGKVPD2	2	10.2.0.4.0	YES	GKdb2

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 12347 09-Mar-12 02:59:28 35 2.1

End Snap: 12348 09-Mar-12 03:59:46 36 2.3

Elapsed: 60.29 (mins)

DB Time: 945.96 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	12347	09-Mar-12 02:59:28	35	2.1
End Snap:	12348	09-Mar-12 03:59:46	36	2.3
Elapsed:		60.29 (mins)
DB Time:		945.96 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 7,168M 7,168M Std Block Size: 16K

Shared Pool Size: 4,096M 4,096M Log Buffer: 14,324K

	Begin	End
Buffer Cache:	7,168M	7,168M	Std Block Size:	16K
Shared Pool Size:	4,096M	4,096M	Log Buffer:	14,324K

Load Profile

Per Second Per Transaction

Redo size: 731.42 679.14

Logical reads: 155.10 144.01

Block changes: 1.81 1.68

Physical reads: 0.01 0.01

Physical writes: 0.13 0.12

User calls: 1.94 1.80

Parses: 1.78 1.65

Hard parses: 0.23 0.21

Sorts: 1.32 1.22

Logons: 0.03 0.03

Executes: 3.48 3.23

Transactions: 1.08

	Per Second	Per Transaction
Redo size:	731.42	679.14
Logical reads:	155.10	144.01
Block changes:	1.81	1.68
Physical reads:	0.01	0.01
Physical writes:	0.13	0.12
User calls:	1.94	1.80
Parses:	1.78	1.65
Hard parses:	0.23	0.21
Sorts:	1.32	1.22
Logons:	0.03	0.03
Executes:	3.48	3.23
Transactions:	1.08

% Blocks changed per Read: 1.16 Recursive Call %: 95.37

Rollback per transaction %: 93.61 Rows per Sort: 190.78

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 85.51 Soft Parse %: 87.06

Execute to Parse %: 48.82 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 0.17 % Non-Parse CPU: 98.97

Shared Pool Statistics

Begin End

Memory Usage %: 59.47 22.21

% SQL with executions>1: 97.44 79.25

% Memory for SQL w/exec>1: 97.34 76.62

	Begin	End
Memory Usage %:	59.47	22.21
% SQL with executions>1:	97.44	79.25
% Memory for SQL w/exec>1:	97.34	76.62

Top 5 Timed Events

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

cursor: pin S wait on X 2,643,183 25,848 10 45.5 Concurrency

rdbms ipc reply 8,736 16,225 1,857 28.6 Other

row cache lock 8,367 14,890 1,780 26.2 Concurrency

CPU time 5,000 8.8

latch: row cache objects 35,534 2,958 83 5.2 Concurrency

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
cursor: pin S wait on X	2,643,183	25,848	10	45.5	Concurrency
rdbms ipc reply	8,736	16,225	1,857	28.6	Other
row cache lock	8,367	14,890	1,780	26.2	Concurrency
CPU time		5,000		8.8
latch: row cache objects	35,534	2,958	83	5.2	Concurrency

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: 0.32 0.30

Global Cache blocks served: 0.81 0.75

GCS/GES messages received: 5.52 5.13

GCS/GES messages sent: 90.97 84.47

DBWR Fusion writes: 0.02 0.02

Estd Interconnect traffic (KB) 36.97

	Per Second	Per Transaction
Global Cache blocks received:	0.32	0.30
Global Cache blocks served:	0.81	0.75
GCS/GES messages received:	5.52	5.13
GCS/GES messages sent:	90.97	84.47
DBWR Fusion writes:	0.02	0.02
Estd Interconnect traffic (KB)	36.97

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

Buffer access - local cache %: 99.78

Buffer access - remote cache %: 0.21

Buffer access - disk %: 0.01

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.2

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

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

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

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

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.2

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.1

% of direct sent messages: 0.96

% of indirect sent messages: 89.62

% of flow controlled messages: 9.42

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): 56757.3s
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
connection management call elapsed time	42,101.94	74.18
parse time elapsed	35,629.56	62.78
sql execute elapsed time	14,686.45	25.88
hard parse elapsed time	9,762.77	17.20
DB CPU	4,999.51	8.81
failed parse elapsed time	117.19	0.21
PL/SQL compilation elapsed time	5.24	0.01
PL/SQL execution elapsed time	3.47	0.01
sequence load elapsed time	0.14	0.00
hard parse (sharing criteria) elapsed time	0.07	0.00
repeated bind elapsed time	0.01	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	56,757.31
background elapsed time	10,917.08
background cpu time	29.47

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Concurrency	2,696,598	98.21	43,939	16	692.15
Other	432,068	98.83	16,264	38	110.90
System I/O	27,309	0.00	11	0	7.01
Cluster	1,310	0.31	1	1	0.34
User I/O	124	0.00	1	7	0.03
Commit	159	0.00	0	1	0.04
Application	121	0.00	0	1	0.03
Network	6,171	0.00	0	0	1.58

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)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
cursor: pin S wait on X	2,643,183	100.00	25,848	10	678.44
rdbms ipc reply	8,736	97.95	16,225	1857	2.24
row cache lock	8,367	63.06	14,890	1780	2.15
latch: row cache objects	35,534	0.00	2,958	83	9.12
latch: shared pool	6,842	0.00	236	35	1.76
latch free	553	0.00	26	47	0.14
reliable message	99	9.09	9	90	0.03
control file sequential read	24,968	0.00	8	0	6.41
latch: library cache	1,262	0.00	5	4	0.32
CGS wait for IPC msg	414,523	100.00	3	0	106.40
control file parallel write	1,209	0.00	2	1	0.31
db file sequential read	121	0.00	1	7	0.03
log file parallel write	1,036	0.00	1	1	0.27
library cache load lock	19	0.00	1	28	0.00
library cache lock	1,168	0.00	1	0	0.30
gc buffer busy	7	57.14	0	56	0.00
gc cr block 2-way	751	0.00	0	0	0.19
name-service call wait	3	0.00	0	81	0.00
os thread startup	6	0.00	0	34	0.00
kksfbc child completion	4	100.00	0	49	0.00
log file sync	159	0.00	0	1	0.04
gc current block 2-way	316	0.00	0	0	0.08
enq: TM - contention	107	0.00	0	1	0.03
wait for scn ack	728	0.00	0	0	0.19
library cache pin	182	0.00	0	1	0.05
db file parallel write	96	0.00	0	1	0.02
DFS lock handle	105	0.00	0	1	0.03
enq: CF - contention	135	0.00	0	1	0.03
gc current grant busy	192	0.00	0	0	0.05
ksxr poll remote instances	4,694	35.85	0	0	1.20
enq: PS - contention	56	1.79	0	0	0.01
PX Deq: reap credit	2,195	99.09	0	0	0.56
enq: TT - contention	38	0.00	0	0	0.01
enq: JQ - contention	36	0.00	0	0	0.01
gc cr block busy	7	0.00	0	2	0.00
SQL*Net message to client	6,153	0.00	0	0	1.58
PX Deq: Signal ACK	47	42.55	0	0	0.01
PX Deq Credit: send blkd	33	12.12	0	0	0.01
db file scattered read	1	0.00	0	6	0.00
IPC send completion sync	16	100.00	0	0	0.00
gcs log flush sync	11	18.18	0	0	0.00
enq: WF - contention	12	0.00	0	0	0.00
gc current grant 2-way	14	0.00	0	0	0.00
gc cr grant 2-way	12	0.00	0	0	0.00
gc cr multi block request	6	0.00	0	0	0.00
gc current block busy	2	0.00	0	1	0.00
latch: ges resource hash list	20	0.00	0	0	0.01
enq: TD - KTF dump entries	3	0.00	0	0	0.00
enq: PI - contention	1	0.00	0	1	0.00
gc current multi block request	3	0.00	0	0	0.00
direct path write	2	0.00	0	0	0.00
ges inquiry response	2	0.00	0	0	0.00
LGWR wait for redo copy	11	0.00	0	0	0.00
SQL*Net break/reset to client	14	0.00	0	0	0.00
enq: MW - contention	1	0.00	0	1	0.00
enq: IR - contention	1	0.00	0	0	0.00
latch: session allocation	4	0.00	0	0	0.00
enq: DR - contention	1	0.00	0	0	0.00
buffer busy waits	1	0.00	0	0	0.00
SQL*Net more data from client	18	0.00	0	0	0.00
cursor: mutex X	34	0.00	0	0	0.01
SQL*Net message from client	6,153	0.00	14,270	2319	1.58
gcs remote message	488,847	99.76	14,130	29	125.47
ges remote message	73,591	60.06	3,532	48	18.89
virtual circuit status	121	100.00	3,527	29150	0.03
Streams AQ: qmn slave idle wait	128	0.00	3,512	27440	0.03
Streams AQ: qmn coordinator idle wait	266	47.37	3,512	13204	0.07
DIAG idle wait	17,982	0.00	3,512	195	4.62
Streams AQ: waiting for time management or cleanup tasks	12	100.00	3,387	282284	0.00
PX Deq: Execution Msg	1,009	88.80	2,182	2163	0.26
PX Idle Wait	679	95.29	1,621	2387	0.17
jobq slave wait	534	89.51	1,503	2815	0.14
Streams AQ: waiting for messages in the queue	20	100.00	59	2930	0.01
PX Deq: Join ACK	67	34.33	2	33	0.02
PX Deq: Parse Reply	66	34.85	0	1	0.02
PX Deq: Execute Reply	60	26.67	0	0	0.02
PX Deq: Msg Fragment	30	10.00	0	0	0.01
Streams AQ: RAC qmn coordinator idle wait	266	100.00	0	0	0.07
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
row cache lock	3,734	52.73	5,757	1542	0.96
latch: row cache objects	32,045	0.00	2,574	80	8.23
events in waitclass Other	422,141	98.97	2,417	6	108.35
latch: shared pool	5,029	0.00	111	22	1.29
cursor: pin S wait on X	1,745	100.00	17	10	0.45
control file sequential read	9,793	0.00	5	0	2.51
latch: library cache	956	0.00	2	2	0.25
control file parallel write	1,209	0.00	2	1	0.31
log file parallel write	1,038	0.00	1	1	0.27
library cache lock	675	0.00	0	0	0.17
os thread startup	6	0.00	0	34	0.00
enq: TM - contention	107	0.00	0	1	0.03
db file parallel write	96	0.00	0	1	0.02
gc cr block 2-way	165	0.00	0	0	0.04
db file sequential read	10	0.00	0	6	0.00
gc current block 2-way	99	0.00	0	0	0.03
library cache pin	103	0.00	0	0	0.03
gc current grant busy	32	0.00	0	0	0.01
gc cr block busy	2	0.00	0	2	0.00
library cache load lock	2	0.00	0	1	0.00
direct path write	2	0.00	0	0	0.00
gc current grant 2-way	2	0.00	0	0	0.00
gc cr grant 2-way	1	0.00	0	0	0.00
cursor: mutex X	34	0.00	0	0	0.01
rdbms ipc message	52,957	92.27	40,649	768	13.59
gcs remote message	488,868	99.75	14,131	29	125.48
pmon timer	1,219	100.00	3,533	2898	0.31
ges remote message	73,618	60.06	3,532	48	18.90
Streams AQ: qmn slave idle wait	128	0.00	3,512	27440	0.03
Streams AQ: qmn coordinator idle wait	266	47.37	3,512	13204	0.07
DIAG idle wait	17,983	0.00	3,512	195	4.62
Streams AQ: waiting for time management or cleanup tasks	12	100.00	3,387	282284	0.00
smon timer	5	100.00	1,216	243102	0.00
PX Deq: Join ACK	10	40.00	2	218	0.00
PX Deq: Parse Reply	9	44.44	0	1	0.00
Streams AQ: RAC qmn coordinator idle wait	266	100.00	0	0	0.07
PX Deq: Execute Reply	9	33.33	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	18,514
AVG_IDLE_TIME	343,658
AVG_IOWAIT_TIME	65
AVG_SYS_TIME	1,514
AVG_USER_TIME	16,890
BUSY_TIME	298,183
IDLE_TIME	5,500,365
IOWAIT_TIME	2,588
SYS_TIME	26,122
USER_TIME	272,061
LOAD	0
OS_CPU_WAIT_TIME	326,300
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	49,392,123,904
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
SYS$USERS	56,735.80	4,999.50	23	513,750
CWGK	0.00	0.00	0	0
CWGKVPD	0.00	0.00	0	0
CWGKVPD2XDB	0.00	0.00	0	0
SYS$BACKGROUND	0.00	0.00	18	41,054

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 centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	19	13	2651926	3545288	6042	1
CWGKVPD	0	0	0	0	0	0
SYS$BACKGROUND	105	71	44551	848540	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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
28,205	49	24	1175.21	49.69	5ur69atw3vfhj		select decode(failover_method,...
2,347	0	41	57.25	4.14	bvskgnk4p3x2w		DECLARE V_PROGRAM VARCHA...
2,339	0	41	57.06	4.12	d36jrbndgc743		SELECT MAX(TRIM(UPPER(PROGRAM)...
28	2	3	9.31	0.05	a8gqd7rwbm8yv		select f.tablespace_name as na...
22	1	38	0.59	0.04	0070chz1yu5uf		DECLARE job BINARY_INTEGER := ...
19	0	76	0.24	0.03	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
18	0	2	8.85	0.03	ahd0u8z8f3bcv	JDBC Thin Client	select CASE METRIC_NAME WHEN '...
17	0	15	1.15	0.03	1fpdgpwg559bx		SELECT COUNT(*) FROM DBA_OBJEC...
15	0	2	7.42	0.03	a1xgxtssv5rrp		select sum(used_blocks), ts.t...
10	0	2	4.87	0.02	c7sn076yz7030		select smontabv.cnt, smontab....

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 DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Text
49	28,205	24	2.03	49.69	5ur69atw3vfhj	select decode(failover_method,...
5	5	1	4.85	0.01	0jaz0harg375c	INSERT INTO FMIS_STATUS (LOG_N...
5	5	1	4.77	0.01	52jg66k9sq6wh	INSERT INTO FMIS_STATUS (LOG_N...
4	4	1	4.40	0.01	6sjthdk7c46tg	SELECT COUNT(*), TRUNC(SUM(KSM...
3	3	8	0.43	0.01	3map0rqcjzx4h	SELECT OWNER, OBJECT_NAME FROM...
3	3	7	0.46	0.01	dct34c6626znm	DECLARE job BINARY_INTEGER := ...
2	28	3	0.82	0.05	a8gqd7rwbm8yv	select f.tablespace_name as na...
1	1	8	0.11	0.00	a2pssmc6g1xg4	DELETE FROM HZ_CLEARTABLELIST ...
1	3	7	0.10	0.00	80yr9qa4w5gts	select df.tablespace_name as t...
1	22	38	0.01	0.04	0070chz1yu5uf	DECLARE job BINARY_INTEGER := ...
0	2,347	41	0.01	4.14	bvskgnk4p3x2w	DECLARE V_PROGRAM VARCHA...
0	2,339	41	0.01	4.12	d36jrbndgc743	SELECT MAX(TRIM(UPPER(PROGRAM)...

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: 561,073
Captured SQL account for 32.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
111,881	3	37,293.67	19.94	2.47	27.93	a8gqd7rwbm8yv	select f.tablespace_name as na...
16,933	7	2,419.00	3.02	3.25	3.25	dct34c6626znm	DECLARE job BINARY_INTEGER := ...
11,051	2,924	3.78	1.97	0.14	0.28	96g93hntrzjtr	select /+ rule / bucket_cnt,...
9,432	38	248.21	1.68	0.52	22.37	0070chz1yu5uf	DECLARE job BINARY_INTEGER := ...
7,678	8	959.75	1.37	3.46	3.46	3map0rqcjzx4h	SELECT OWNER, OBJECT_NAME FROM...
5,115	1,705	3.00	0.91	0.36	2.65	db78fxqxwxt7r	select /+ rule / bucket, en...
4,239	7	605.57	0.76	0.70	2.70	80yr9qa4w5gts	select df.tablespace_name as t...
2,772	565	4.91	0.49	0.04	2.61	53saa2zkr6wc3	select intcol#, nvl(pos#, 0), ...
2,732	7	390.29	0.49	0.17	0.67	a28cyw6c6p2nm	select tablespace_name as name...
2,377	1	2,377.00	0.42	0.21	6.20	8vkjh60z1g287	select OBJOID, CLSOID, RUNT...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 42
Captured SQL account for 40.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
7	1	7.00	16.67	0.01	0.09	32whwm2babwpt	insert into wrh$_seg_stat_obj ...
6	1,705	0.00	14.29	0.36	2.65	db78fxqxwxt7r	select /+ rule / bucket, en...
2	2,924	0.00	4.76	0.14	0.28	96g93hntrzjtr	select /+ rule / bucket_cnt,...
1	1	1.00	2.38	4.77	4.77	52jg66k9sq6wh	INSERT INTO FMIS_STATUS (LOG_N...
1	41	0.02	2.38	0.33	2347.30	bvskgnk4p3x2w	DECLARE V_PROGRAM VARCHA...
1	41	0.02	2.38	0.24	2339.44	d36jrbndgc743	SELECT MAX(TRIM(UPPER(PROGRAM)...
0	38	0.00	0.00	0.52	22.37	0070chz1yu5uf	DECLARE job BINARY_INTEGER := ...
0	303	0.00	0.00	0.05	0.16	04xtrk7uyhknh	select obj#, type#, ctime, mti...
0	0		0.00	0.02	0.02	06a7wq8prjng7	select DBID, NAME, CREATED,...
0	32	0.00	0.00	0.03	0.04	0fr8zhn4ymu3v	select intcol#, type, flags, l...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 12,578
Captured SQL account for 84.1% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
2,924	2,091	0.72	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...
1,705	27,538	16.15	0.00	db78fxqxwxt7r		select /+ rule / bucket, en...
619	619	1.00	0.00	2ym6hhaq30r73		select type#, blocks, extents,...
565	797	1.41	0.00	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
488	486	1.00	0.00	5ngzsfstg8tmy		select o.owner#, o.name, o.nam...
355	355	1.00	0.02	3my81td8y2rm3	JDBC Thin Client	BEGIN vPD_PKG.SET_CONTEXT_COMP...
303	300	0.99	0.00	04xtrk7uyhknh		select obj#, type#, ctime, mti...
241	240	1.00	0.00	3c1kubcdjnppq		update sys.col_usage$ set eq...
216	520	2.41	0.00	6769wyy3yf66f		select pos#, intcol#, col#, sp...
209	103	0.49	0.00	asvzxj61dc5vs		select timestamp, flags from ...
195	195	1.00	0.00	42ddyag628kjx		begin :con := VPD_PKG.FILTER_C...
181	218	1.20	0.04	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
180	480	2.67	0.00	0h6b2sajwb74n		select privilege#, level from ...
178	2,079	11.68	0.00	83taa7kaw59c1		select name, intcol#, segcol#,...
177	177	1.00	0.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
140	140	1.00	0.00	b70fnskn0kam7	JDBC Thin Client	SELECT * FROM QRTZ_TRIGGERS WH...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 6,437
Captured SQL account for 59.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
619	619	9.62	2ym6hhaq30r73		select type#, blocks, extents,...
355	355	5.51	3my81td8y2rm3	JDBC Thin Client	BEGIN vPD_PKG.SET_CONTEXT_COMP...
209	209	3.25	asvzxj61dc5vs		select timestamp, flags from ...
195	195	3.03	42ddyag628kjx		begin :con := VPD_PKG.FILTER_C...
180	180	2.80	0h6b2sajwb74n		select privilege#, level from ...
105	1	1.63	0v3dvmc22qnam		insert into sys.col_usage$ (ob...
105	241	1.63	3c1kubcdjnppq		update sys.col_usage$ set eq...
105	105	1.63	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
85	85	1.32	19g6x6d7nh669		select blocks, NVL(ts#, -1), s...
78	2,924	1.21	96g93hntrzjtr		select /+ rule / bucket_cnt,...
76	76	1.18	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
76	76	1.18	g00cj285jmgsw		update sys.mon_mods$ set inser...
74	74	1.15	8swypbbr0m372		select order#, columns, types ...
74	74	1.15	cqgv56fmuj63x		select owner#, name, namespace...
68	488	1.06	5ngzsfstg8tmy		select o.owner#, o.name, o.nam...
66	66	1.03	0k8522rmdzg4k		select privilege# from sysauth...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
75	5	99wvrgpaqvtrk		INSERT INTO HZ_LOG (LOG_NO, US...
40	7	dct34c6626znm		DECLARE job BINARY_INTEGER := ...
34	50	15dyr87r4w2a1	JDBC Thin Client	SELECT * FROM QRTZ_CRON_TRIGGE...
32	140	b70fnskn0kam7	JDBC Thin Client	SELECT * FROM QRTZ_TRIGGERS WH...
24	180	0h6b2sajwb74n		select privilege#, level from ...
24	66	0k8522rmdzg4k		select privilege# from sysauth...

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
0.40	93.47	0.43	0.04	56	aq8yqxyyb40nn		update sys.job$ set this_date=...
0.13	4.90	2.65	0.36	1,705	db78fxqxwxt7r		select /+ rule / bucket, en...
0.07	0.26	27.93	2.47	3	a8gqd7rwbm8yv		select f.tablespace_name as na...
0.02	0.62	3.25	3.25	7	dct34c6626znm		DECLARE job BINARY_INTEGER := ...
0.02	3.60	0.49	0.24	1	c2aw4fq306q4k		INSERT /+ APPEND / INTO WRH$...
0.01	2.29	0.46	0.07	177	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
0.01	42.03	0.02	0.02	18	fhdxrqd4stwqk	JDBC Thin Client	SELECT * FROM QRTZ_LOCKS WHERE...
0.01	5.46	0.16	0.05	303	04xtrk7uyhknh		select obj#, type#, ctime, mti...
0.01	19.04	0.05	0.05	619	2ym6hhaq30r73		select type#, blocks, extents,...
0.01	0.04	22.37	0.52	38	0070chz1yu5uf		DECLARE job BINARY_INTEGER := ...
0.01	2.18	0.36	0.10	241	3c1kubcdjnppq		update sys.col_usage$ set eq...
0.01	18.09	0.04	0.04	76	g00cj285jmgsw		update sys.mon_mods$ set inser...
0.01	0.12	5.94	0.06	52	1dubbbfqnqvh9		SELECT ORA_TQ_BASE$.NEXTVAL FR...
0.01	0.11	6.20	0.21	1	8vkjh60z1g287		select OBJOID, CLSOID, RUNT...
0.01	7.05	0.08	0.06	488	5ngzsfstg8tmy		select o.owner#, o.name, o.nam...
0.01	0.03	18.61	0.07	76	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
0.01	1.75	0.31	0.28	1	84qubbrsr0kfn		insert into wrh$_latch (snap...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

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

06a7wq8prjng7 select DBID, NAME, CREATED, RESETLOGS_CHANGE#, RESETLOGS_TIME, PRIOR_RESETLOGS_CHANGE#, PRIOR_RESETLOGS_TIME, LOG_MODE, CHECKPOINT_CHANGE#, ARCHIVE_CHANGE#, CONTROLFILE_TYPE, CONTROLFILE_CREATED, CONTROLFILE_SEQUENCE#, CONTROLFILE_CHANGE#, CONTROLFILE_TIME, OPEN_RESETLOGS, VERSION_TIME, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, REMOTE_ARCHIVE, ACTIVATION#, SWITCHOVER#, DATABASE_ROLE, ARCHIVELOG_CHANGE#, ARCHIVELOG_COMPRESSION, SWITCHOVER_STATUS, DATAGUARD_BROKER, GUARD_STATUS, SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI, FORCE_LOGGING, PLATFORM_ID, PLATFORM_NAME, RECOVERY_TARGET_INCARNATION#, LAST_OPEN_INCARNATION#, CURRENT_SCN, FLASHBACK_ON, SUPPLEMENTAL_LOG_DATA_FK, SUPPLEMENTAL_LOG_DATA_ALL, DB_UNIQUE_NAME, STANDBY_BECAME_PRIMARY_SCN, FS_FAILOVER_STATUS, FS_FAILOVER_CURRENT_TARGET, FS_FAILOVER_THRESHOLD, FS_FAILOVER_OBSERVER_PRESENT, FS_FAILOVER_OBSERVER_HOST from GV$DATABASE where inst_id = USERENV('Instance')

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

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

0jaz0harg375c INSERT INTO FMIS_STATUS (LOG_NO, TIMES, NAME, SUB_NAME, STATUS, INST_INFO) SELECT HZ_SEQ.NEXTVAL, SYSDATE, '��ؿ��п�ֲ��', KSMCHCLS||'('||SIZE_MOD||')', '��'||LPAD(BLOCKS, 8)||';�ܴ�С(�ֽ�):'||LPAD(ALL_SIZE, 14)||';��(�ֽ�):'|| LPAD(MAX_SIZE, 10)||';��С��(�ֽ�):'||LPAD(MIN_SIZE, 10)||';��ƽ��С(�ֽ�):'||LPAD(AVG_SIZE, 12) AS STATUS, INST_INFO FROM (SELECT DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS) AS KSMCHCLS, KSMCHCOM, DECODE(TRUNC(KSMCHSIZ/1024), 0, '0:<1K', 1, '1:1K-2K', DECODE(TRUNC(KSMCHSIZ/2048), 1, '2:2K-4K', 2, '3:4K-6K', 3, '4:6K-8K', 4, '5:8K-10K', '6:>10K')) AS SIZE_MOD, TRIM(TO_CHAR(COUNT(*), '9, 999, 999, 999')) AS BLOCKS, TRIM(TO_CHAR(SUM(KSMCHSIZ), '9, 999, 999, 999')) AS ALL_SIZE, TRIM(TO_CHAR(MAX(KSMCHSIZ), '9, 999, 999, 999')) AS MAX_SIZE, TRIM(TO_CHAR(MIN(KSMCHSIZ), '9, 999, 999, 999')) AS MIN_SIZE, TRIM(TO_CHAR(ROUND(AVG(KSMCHSIZ), 2), '9, 999, 999, 999.99')) AS AVG_SIZE, 'CWGKVPD2_2' AS INST_INFO FROM V$KSMSP WHERE TRIM(UPPER(KSMCHCOM))='FREE MEMORY' GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS), KSMCHCOM, DECODE(TRUNC(KSMCHSIZ/1024), 0, '0:<1K', 1, '1:1K-2K', DECODE(TRUNC(KSMCHSIZ/2048), 1, '2:2K-4K', 2, '3:4K-6K', 3, '4:6K-8K', 4, '5:8K-10K', '6:>10K')) ORDER BY KSMCHCLS, SIZE_MOD)

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

0v3dvmc22qnam insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)

15dyr87r4w2a1 SELECT * FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2

19g6x6d7nh669 select blocks, NVL(ts#, -1), status$, NVL(relfile#, 0), maxextend, inc, crscnwrp, crscnbas, NVL(spare1, 0) from file$ where file#=:1

1dubbbfqnqvh9 SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL

1fpdgpwg559bx SELECT COUNT(*) FROM DBA_OBJECTS WHERE OBJECT_NAME='FMIS_ELT_DIR'

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# (+)

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

32whwm2babwpt insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , decode(ss1.objtype_kewrseg, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 42, 'MATERIALIZED VIEW', 43, 'DIMENSION', 44, 'CONTEXT', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 55, 'XML SCHEMA', 56, 'JAVA DATA', 57, 'SECURITY PROFILE', 'UNDEFINED') , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 6, 7, 9)))) and ss1.objna me_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

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

3map0rqcjzx4h SELECT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE='TABLE' AND OWNER LIKE 'FMIS%' AND (SUBSTR(OBJECT_NAME, 1, 4)='TEMP' OR SUBSTR(OBJECT_NAME, 1, 3)='TMP' OR (SUBSTR(OBJECT_NAME, 1, 5)='BBHBG' AND LENGTH(OBJECT_NAME)>5) OR (SUBSTR(OBJECT_NAME, 1, 10)='ZWCX_PZTMP' AND LENGTH(OBJECT_NAME)>10) OR (SUBSTR(OBJECT_NAME, 1, 7)='PZCX_20' AND LENGTH(OBJECT_NAME)>7) OR (SUBSTR(OBJECT_NAME, 1, 9)='LJZTABLE_' AND LENGTH(OBJECT_NAME)>9)) AND (SYSDATE-LAST_DDL_TIME)*24>2 AND ROWNUM<5000

3my81td8y2rm3 BEGIN vPD_PKG.SET_CONTEXT_COMPID('0300'); END;

42ddyag628kjx begin :con := VPD_PKG.FILTER_COMPID(:sn, :on); end;

52jg66k9sq6wh INSERT INTO FMIS_STATUS (LOG_NO, TIMES, NAME, SUB_NAME, STATUS, INST_INFO) SELECT HZ_SEQ.NEXTVAL, SYSDATE, '��ϸ��', NAME, STATUS, INST_INFO FROM (SELECT DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS) AS NAME, '�ܿ��:'||LPAD(TRIM(TO_CHAR(COUNT(*), '99, 999, 999, 999')), 15)|| ', �ܴ�С:'||LPAD(TRIM(TO_CHAR(SUM(KSMCHSIZ), '99, 999, 999, 999')), 15)||'BYTES'|| ', ��С:'||LPAD(TRIM(TO_CHAR(MAX(KSMCHSIZ), '99, 999, 999, 999')), 15)||'BYTES'|| ', ��С��С:'||LPAD(TRIM(TO_CHAR(MIN(KSMCHSIZ), '999, 999, 999')), 12)||'BYTES'|| ', ƽ��С:'||LPAD(TRIM(TO_CHAR(TRUNC(AVG(KSMCHSIZ)), '999, 999, 999')), 12)||'BYTES' AS STATUS, 'CWGKVPD2_2' AS INST_INFO FROM V$KSMSP GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS))

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

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

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

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

6sjthdk7c46tg SELECT COUNT(*), TRUNC(SUM(KSMCHSIZ)/1024), TRUNC(AVG(KSMCHSIZ)) FROM V$KSMSP

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#

80yr9qa4w5gts select df.tablespace_name as tn, df.file_name as fn, f.phyrds as pyr, f.phyblkrd as pbr, f.phywrts as pyw, f.phyblkwrt as pbw from sys.v_$filestat f, sys.dba_data_files df where f.file# = df.file_id order by df.tablespace_name

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#

84qubbrsr0kfn insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash

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

8vkjh60z1g287 select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID

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

99wvrgpaqvtrk INSERT INTO HZ_LOG (LOG_NO, USER_NAME, BEGIN_TIME, END_TIME, SQL_TEXT, SQL_TEXT1, SQL_TEXT2, ROW_COUNT, LOG_TYPE, LOG_LEVEL, LOG_DETAIL, IP_ADDRESS, TIMES) VALUES (HZ_SEQ.NEXTVAL, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA'), :B8 , SYSDATE, :B7 , :B6 , :B5 , :B4 , :B3 , 'INFO', TO_CHAR(:B2 ), SYS_CONTEXT('USERENV', 'IP_ADDRESS'), :B1 )

a1xgxtssv5rrp select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#

a28cyw6c6p2nm select tablespace_name as name, to_char(sum(bytes)) as bytes from sys.dba_data_files group by tablespace_name order by name

a2pssmc6g1xg4 DELETE FROM HZ_CLEARTABLELIST WHERE ROWID IN (SELECT B.ROWID FROM DBA_TABLES A, HZ_CLEARTABLELIST B WHERE B.TABLE_OWNER=A.OWNER(+) AND B.TABLE_NAME=A.TABLE_NAME(+) AND A.TABLE_NAME IS NULL)

a8gqd7rwbm8yv select f.tablespace_name as name, sum(f.bytes) as used from SYS.Dba_Segments f group by f.tablespace_name

ahd0u8z8f3bcv select CASE METRIC_NAME WHEN 'SQL Service Response Time' then ROUND((AVERAGE * 10), 2) WHEN 'Response Time Per Txn' then ROUND((AVERAGE * 10), 2) ELSE AVERAGE END AVERAGE from SYS.V_$SYSMETRIC_SUMMARY where METRIC_NAME = 'Response Time Per Txn'

aq8yqxyyb40nn update sys.job$ set this_date=:1 where job=:2

asvzxj61dc5vs select timestamp, flags from fixed_obj$ where obj#=:1

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

b70fnskn0kam7 SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2

bvskgnk4p3x2w DECLARE V_PROGRAM VARCHAR2(100); V_SESSIONID NUMBER(10); V_CONTEXT VARCHAR2(32); BEGIN SELECT MAX(TRIM(UPPER(PROGRAM))), MAX(TRIM(UPPER(USERNAME))) INTO V_PROGRAM, V_CONTEXT FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'); IF SUBSTR(V_PROGRAM, 1, 3) IN ('EXP', 'IMP') THEN VPD_PKG.SET_CONTEXT_COMPID('-1'); VPD_PKG.SET_CONTEXT_VPD_YEAR('-1'); VPD_PKG.SET_CONTEXT_ACCBOOKID('-1'); ELSE VPD_PKG.SET_CONTEXT_COMPID(REPLACE(SUBSTR(V_CONTEXT, 5), '_TOP', '9999')); VPD_PKG.SET_CONTEXT_VPD_YEAR(TO_CHAR(SYSDATE, 'YYYYMMDD')); VPD_PKG.SET_CONTEXT_ACCBOOKID('0'); END IF; END;

c2aw4fq306q4k INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)

c7sn076yz7030 select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map, smontab.orig_thread from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.scn = smontabv.scnmax and thread=0

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

d36jrbndgc743 SELECT MAX(TRIM(UPPER(PROGRAM))), MAX(TRIM(UPPER(USERNAME))) FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID')

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

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

fhdxrqd4stwqk SELECT * FROM QRTZ_LOCKS WHERE LOCK_NAME = :1 FOR UPDATE

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

SQL Id	SQL Text
0070chz1yu5uf	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN RUN_JOB; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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
06a7wq8prjng7	select DBID, NAME, CREATED, RESETLOGS_CHANGE#, RESETLOGS_TIME, PRIOR_RESETLOGS_CHANGE#, PRIOR_RESETLOGS_TIME, LOG_MODE, CHECKPOINT_CHANGE#, ARCHIVE_CHANGE#, CONTROLFILE_TYPE, CONTROLFILE_CREATED, CONTROLFILE_SEQUENCE#, CONTROLFILE_CHANGE#, CONTROLFILE_TIME, OPEN_RESETLOGS, VERSION_TIME, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, REMOTE_ARCHIVE, ACTIVATION#, SWITCHOVER#, DATABASE_ROLE, ARCHIVELOG_CHANGE#, ARCHIVELOG_COMPRESSION, SWITCHOVER_STATUS, DATAGUARD_BROKER, GUARD_STATUS, SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI, FORCE_LOGGING, PLATFORM_ID, PLATFORM_NAME, RECOVERY_TARGET_INCARNATION#, LAST_OPEN_INCARNATION#, CURRENT_SCN, FLASHBACK_ON, SUPPLEMENTAL_LOG_DATA_FK, SUPPLEMENTAL_LOG_DATA_ALL, DB_UNIQUE_NAME, STANDBY_BECAME_PRIMARY_SCN, FS_FAILOVER_STATUS, FS_FAILOVER_CURRENT_TARGET, FS_FAILOVER_THRESHOLD, FS_FAILOVER_OBSERVER_PRESENT, FS_FAILOVER_OBSERVER_HOST from GV$DATABASE where inst_id = USERENV('Instance')
0fr8zhn4ymu3v	select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0jaz0harg375c	INSERT INTO FMIS_STATUS (LOG_NO, TIMES, NAME, SUB_NAME, STATUS, INST_INFO) SELECT HZ_SEQ.NEXTVAL, SYSDATE, '��ؿ��п�ֲ��', KSMCHCLS\|\|'('\|\|SIZE_MOD\|\|')', '��'\|\|LPAD(BLOCKS, 8)\|\|';�ܴ�С(�ֽ�):'\|\|LPAD(ALL_SIZE, 14)\|\|';��(�ֽ�):'\|\| LPAD(MAX_SIZE, 10)\|\|';��С��(�ֽ�):'\|\|LPAD(MIN_SIZE, 10)\|\|';��ƽ��С(�ֽ�):'\|\|LPAD(AVG_SIZE, 12) AS STATUS, INST_INFO FROM (SELECT DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS) AS KSMCHCLS, KSMCHCOM, DECODE(TRUNC(KSMCHSIZ/1024), 0, '0:<1K', 1, '1:1K-2K', DECODE(TRUNC(KSMCHSIZ/2048), 1, '2:2K-4K', 2, '3:4K-6K', 3, '4:6K-8K', 4, '5:8K-10K', '6:>10K')) AS SIZE_MOD, TRIM(TO_CHAR(COUNT(*), '9, 999, 999, 999')) AS BLOCKS, TRIM(TO_CHAR(SUM(KSMCHSIZ), '9, 999, 999, 999')) AS ALL_SIZE, TRIM(TO_CHAR(MAX(KSMCHSIZ), '9, 999, 999, 999')) AS MAX_SIZE, TRIM(TO_CHAR(MIN(KSMCHSIZ), '9, 999, 999, 999')) AS MIN_SIZE, TRIM(TO_CHAR(ROUND(AVG(KSMCHSIZ), 2), '9, 999, 999, 999.99')) AS AVG_SIZE, 'CWGKVPD2_2' AS INST_INFO FROM V$KSMSP WHERE TRIM(UPPER(KSMCHCOM))='FREE MEMORY' GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS), KSMCHCOM, DECODE(TRUNC(KSMCHSIZ/1024), 0, '0:<1K', 1, '1:1K-2K', DECODE(TRUNC(KSMCHSIZ/2048), 1, '2:2K-4K', 2, '3:4K-6K', 3, '4:6K-8K', 4, '5:8K-10K', '6:>10K')) ORDER BY KSMCHCLS, SIZE_MOD)
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
15dyr87r4w2a1	SELECT * FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
19g6x6d7nh669	select blocks, NVL(ts#, -1), status$, NVL(relfile#, 0), maxextend, inc, crscnwrp, crscnbas, NVL(spare1, 0) from file$ where file#=:1
1dubbbfqnqvh9	SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL
1fpdgpwg559bx	SELECT COUNT(*) FROM DBA_OBJECTS WHERE OBJECT_NAME='FMIS_ELT_DIR'
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# (+)
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
32whwm2babwpt	insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , decode(ss1.objtype_kewrseg, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 42, 'MATERIALIZED VIEW', 43, 'DIMENSION', 44, 'CONTEXT', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 55, 'XML SCHEMA', 56, 'JAVA DATA', 57, 'SECURITY PROFILE', 'UNDEFINED') , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below /, 10 / NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 6, 7, 9)))) and ss1.objna me_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
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
3map0rqcjzx4h	SELECT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE='TABLE' AND OWNER LIKE 'FMIS%' AND (SUBSTR(OBJECT_NAME, 1, 4)='TEMP' OR SUBSTR(OBJECT_NAME, 1, 3)='TMP' OR (SUBSTR(OBJECT_NAME, 1, 5)='BBHBG' AND LENGTH(OBJECT_NAME)>5) OR (SUBSTR(OBJECT_NAME, 1, 10)='ZWCX_PZTMP' AND LENGTH(OBJECT_NAME)>10) OR (SUBSTR(OBJECT_NAME, 1, 7)='PZCX_20' AND LENGTH(OBJECT_NAME)>7) OR (SUBSTR(OBJECT_NAME, 1, 9)='LJZTABLE_' AND LENGTH(OBJECT_NAME)>9)) AND (SYSDATE-LAST_DDL_TIME)*24>2 AND ROWNUM<5000
3my81td8y2rm3	BEGIN vPD_PKG.SET_CONTEXT_COMPID('0300'); END;
42ddyag628kjx	begin :con := VPD_PKG.FILTER_COMPID(:sn, :on); end;
52jg66k9sq6wh	INSERT INTO FMIS_STATUS (LOG_NO, TIMES, NAME, SUB_NAME, STATUS, INST_INFO) SELECT HZ_SEQ.NEXTVAL, SYSDATE, '��ϸ��', NAME, STATUS, INST_INFO FROM (SELECT DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS) AS NAME, '�ܿ��:'\|\|LPAD(TRIM(TO_CHAR(COUNT(*), '99, 999, 999, 999')), 15)\|\| ', �ܴ�С:'\|\|LPAD(TRIM(TO_CHAR(SUM(KSMCHSIZ), '99, 999, 999, 999')), 15)\|\|'BYTES'\|\| ', ��С:'\|\|LPAD(TRIM(TO_CHAR(MAX(KSMCHSIZ), '99, 999, 999, 999')), 15)\|\|'BYTES'\|\| ', ��С��С:'\|\|LPAD(TRIM(TO_CHAR(MIN(KSMCHSIZ), '999, 999, 999')), 12)\|\|'BYTES'\|\| ', ƽ��С:'\|\|LPAD(TRIM(TO_CHAR(TRUNC(AVG(KSMCHSIZ)), '999, 999, 999')), 12)\|\|'BYTES' AS STATUS, 'CWGKVPD2_2' AS INST_INFO FROM V$KSMSP GROUP BY DECODE(UPPER(KSMCHCLS), 'FREE', '��п�', 'RECR', '��ؽ��', 'FREEABL', '��ͷſ�', 'PERM', '��ÿ�(��ͷ�)', KSMCHCLS))
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
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
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6sjthdk7c46tg	SELECT COUNT(*), TRUNC(SUM(KSMCHSIZ)/1024), TRUNC(AVG(KSMCHSIZ)) FROM V$KSMSP
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#
80yr9qa4w5gts	select df.tablespace_name as tn, df.file_name as fn, f.phyrds as pyr, f.phyblkrd as pbr, f.phywrts as pyw, f.phyblkwrt as pbw from sys.v_$filestat f, sys.dba_data_files df where f.file# = df.file_id order by df.tablespace_name
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#
84qubbrsr0kfn	insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
8vkjh60z1g287	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
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
99wvrgpaqvtrk	INSERT INTO HZ_LOG (LOG_NO, USER_NAME, BEGIN_TIME, END_TIME, SQL_TEXT, SQL_TEXT1, SQL_TEXT2, ROW_COUNT, LOG_TYPE, LOG_LEVEL, LOG_DETAIL, IP_ADDRESS, TIMES) VALUES (HZ_SEQ.NEXTVAL, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA'), :B8 , SYSDATE, :B7 , :B6 , :B5 , :B4 , :B3 , 'INFO', TO_CHAR(:B2 ), SYS_CONTEXT('USERENV', 'IP_ADDRESS'), :B1 )
a1xgxtssv5rrp	select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
a28cyw6c6p2nm	select tablespace_name as name, to_char(sum(bytes)) as bytes from sys.dba_data_files group by tablespace_name order by name
a2pssmc6g1xg4	DELETE FROM HZ_CLEARTABLELIST WHERE ROWID IN (SELECT B.ROWID FROM DBA_TABLES A, HZ_CLEARTABLELIST B WHERE B.TABLE_OWNER=A.OWNER(+) AND B.TABLE_NAME=A.TABLE_NAME(+) AND A.TABLE_NAME IS NULL)
a8gqd7rwbm8yv	select f.tablespace_name as name, sum(f.bytes) as used from SYS.Dba_Segments f group by f.tablespace_name
ahd0u8z8f3bcv	select CASE METRIC_NAME WHEN 'SQL Service Response Time' then ROUND((AVERAGE * 10), 2) WHEN 'Response Time Per Txn' then ROUND((AVERAGE * 10), 2) ELSE AVERAGE END AVERAGE from SYS.V_$SYSMETRIC_SUMMARY where METRIC_NAME = 'Response Time Per Txn'
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
b70fnskn0kam7	SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
bvskgnk4p3x2w	DECLARE V_PROGRAM VARCHAR2(100); V_SESSIONID NUMBER(10); V_CONTEXT VARCHAR2(32); BEGIN SELECT MAX(TRIM(UPPER(PROGRAM))), MAX(TRIM(UPPER(USERNAME))) INTO V_PROGRAM, V_CONTEXT FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'); IF SUBSTR(V_PROGRAM, 1, 3) IN ('EXP', 'IMP') THEN VPD_PKG.SET_CONTEXT_COMPID('-1'); VPD_PKG.SET_CONTEXT_VPD_YEAR('-1'); VPD_PKG.SET_CONTEXT_ACCBOOKID('-1'); ELSE VPD_PKG.SET_CONTEXT_COMPID(REPLACE(SUBSTR(V_CONTEXT, 5), '_TOP', '9999')); VPD_PKG.SET_CONTEXT_VPD_YEAR(TO_CHAR(SYSDATE, 'YYYYMMDD')); VPD_PKG.SET_CONTEXT_ACCBOOKID('0'); END IF; END;
c2aw4fq306q4k	INSERT /+ APPEND / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
c7sn076yz7030	select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map, smontab.orig_thread from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.scn = smontabv.scnmax and thread=0
cqgv56fmuj63x	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
d36jrbndgc743	SELECT MAX(TRIM(UPPER(PROGRAM))), MAX(TRIM(UPPER(USERNAME))) FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID')
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dct34c6626znm	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN RUN_STICK_JOB; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fhdxrqd4stwqk	SELECT * FROM QRTZ_LOCKS WHERE LOCK_NAME = :1 FOR UPDATE
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

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	258,374	71.42	66.32
CPU used when call started	5,849	1.62	1.50
CR blocks created	29	0.01	0.01
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	5,466,599	1,511.15	1,403.13
DBWR checkpoint buffers written	349	0.10	0.09
DBWR checkpoints	0	0.00	0.00
DBWR fusion writes	63	0.02	0.02
DBWR object drop buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	34	0.01	0.01
DBWR undo block writes	80	0.02	0.02
DFO trees parallelized	23	0.01	0.01
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	105	0.03	0.03
PX local messages sent	105	0.03	0.03
PX remote messages recv'd	68	0.02	0.02
PX remote messages sent	87	0.02	0.02
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	23	0.01	0.01
RowCR - row contention	0	0.00	0.00
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	6,025	1.67	1.55
active txn count during cleanout	35	0.01	0.01
application wait time	14	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	11,970	3.31	3.07
branch node splits	0	0.00	0.00
buffer is not pinned count	113,925	31.49	29.24
buffer is pinned count	811,538	224.34	208.30
bytes received via SQL*Net from client	515,966	142.63	132.43
bytes sent via SQL*Net to client	317,223	87.69	81.42
calls to get snapshot scn: kcmgss	17,752	4.91	4.56
calls to kcmgas	3,232	0.89	0.83
calls to kcmgcs	30	0.01	0.01
change write time	8	0.00	0.00
cleanout - number of ktugct calls	62	0.02	0.02
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	19	0.01	0.00
cluster key scan block gets	43,298	11.97	11.11
cluster key scans	27,849	7.70	7.15
cluster wait time	105	0.03	0.03
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	14	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	4	0.00	0.00
commit cleanout failures: cannot pin	1	0.00	0.00
commit cleanouts	970	0.27	0.25
commit cleanouts successfully completed	951	0.26	0.24
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	72	0.02	0.02
concurrency wait time	4,393,857	1,214.61	1,127.79
consistent changes	40	0.01	0.01
consistent gets	553,233	152.93	142.00
consistent gets - examination	143,884	39.77	36.93
consistent gets direct	0	0.00	0.00
consistent gets from cache	553,305	152.95	142.02
current blocks converted for CR	0	0.00	0.00
cursor authentications	363	0.10	0.09
data blocks consistent reads - undo records applied	28	0.01	0.01
db block changes	6,532	1.81	1.68
db block gets	7,840	2.17	2.01
db block gets direct	66	0.02	0.02
db block gets from cache	7,774	2.15	2.00
deferred (CURRENT) block cleanout applications	447	0.12	0.11
dirty buffers inspected	0	0.00	0.00
enqueue conversions	402	0.11	0.10
enqueue releases	25,840	7.14	6.63
enqueue requests	25,851	7.15	6.64
enqueue timeouts	11	0.00	0.00
enqueue waits	394	0.11	0.10
exchange deadlocks	0	0.00	0.00
execute count	12,578	3.48	3.23
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	1,503	0.42	0.39
gc CPU used by this session	1,477	0.41	0.38
gc cr block build time	2	0.00	0.00
gc cr block flush time	0	0.00	0.00
gc cr block receive time	34	0.01	0.01
gc cr block send time	8	0.00	0.00
gc cr blocks received	820	0.23	0.21
gc cr blocks served	1,645	0.45	0.42
gc current block flush time	0	0.00	0.00
gc current block pin time	6	0.00	0.00
gc current block receive time	14	0.00	0.00
gc current block send time	5	0.00	0.00
gc current blocks received	354	0.10	0.09
gc current blocks served	1,278	0.35	0.33
gc local grants	161	0.04	0.04
gc remote grants	117	0.03	0.03
gcs messages sent	7,409	2.05	1.90
ges messages sent	321,693	88.93	82.57
global enqueue get time	249	0.07	0.06
global enqueue gets async	4,039	1.12	1.04
global enqueue gets sync	6,493	1.79	1.67
global enqueue releases	580,873	160.57	149.09
heap block compress	22	0.01	0.01
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	19	0.01	0.00
immediate (CURRENT) block cleanout applications	194	0.05	0.05
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	781	0.22	0.20
index fast full scans (full)	0	0.00	0.00
index fetch by key	435,922	120.50	111.89
index scans kdiixs1	5,523	1.53	1.42
leaf node 90-10 splits	18	0.00	0.00
leaf node splits	22	0.01	0.01
lob reads	270	0.07	0.07
lob writes	78	0.02	0.02
lob writes unaligned	78	0.02	0.02
logons cumulative	124	0.03	0.03
messages received	4,547	1.26	1.17
messages sent	4,547	1.26	1.17
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	402,840	111.36	103.40
opened cursors cumulative	11,416	3.16	2.93
parse count (failures)	2	0.00	0.00
parse count (hard)	833	0.23	0.21
parse count (total)	6,437	1.78	1.65
parse time cpu	5,152	1.42	1.32
parse time elapsed	3,100,503	857.08	795.82
physical read IO requests	38	0.01	0.01
physical read bytes	688,128	190.22	176.62
physical read total IO requests	25,091	6.94	6.44
physical read total bytes	411,156,480	113,657.35	105,532.98
physical read total multi block requests	1	0.00	0.00
physical reads	42	0.01	0.01
physical reads cache	42	0.01	0.01
physical reads cache prefetch	4	0.00	0.00
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	335	0.09	0.09
physical write bytes	7,487,488	2,069.79	1,921.84
physical write total IO requests	6,033	1.67	1.55
physical write total bytes	73,305,088	20,263.97	18,815.47
physical write total multi block requests	978	0.27	0.25
physical writes	457	0.13	0.12
physical writes direct	66	0.02	0.02
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	391	0.11	0.10
physical writes non checkpoint	191	0.05	0.05
pinned buffers inspected	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,539	0.98	0.91
queries parallelized	23	0.01	0.01
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	144,609	39.97	37.12
recursive cpu usage	257,126	71.08	66.00
redo blocks written	6,243	1.73	1.60
redo buffer allocation retries	0	0.00	0.00
redo entries	4,519	1.25	1.16
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	106	0.03	0.03
redo size	2,645,932	731.42	679.14
redo subscn max counts	132	0.04	0.03
redo synch time	20	0.01	0.01
redo synch writes	164	0.05	0.04
redo wastage	341,784	94.48	87.73
redo write time	72	0.02	0.02
redo writer latching time	0	0.00	0.00
redo writes	1,037	0.29	0.27
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	28	0.01	0.01
rows fetched via callback	8,655	2.39	2.22
session connect time	2,380	0.66	0.61
session cursor cache hits	8,542	2.36	2.19
session logical reads	561,073	155.10	144.01
session pga memory	82,667,592	22,852.08	21,218.58
session pga memory max	6,221,245,160	1,719,759.41	1,596,828.84
session uga memory	###############	67,675,487.64	62,837,958.32
session uga memory max	4,494,898,080	1,242,539.57	1,153,721.27
shared hash latch upgrades - no wait	906	0.25	0.23
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	4,768	1.32	1.22
sorts (rows)	909,650	251.46	233.48
sql area evicted	24,750	6.84	6.35
sql area purged	1	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	41	0.01	0.01
table fetch by rowid	36,826	10.18	9.45
table fetch continued row	111	0.03	0.03
table scan blocks gotten	323,156	89.33	82.95
table scan rows gotten	11,148,682	3,081.87	2,861.57
table scans (long tables)	0	0.00	0.00
table scans (short tables)	1,264	0.35	0.32
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	0	0.00	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	944,356	261.05	242.39
user I/O wait time	85	0.02	0.02
user calls	7,013	1.94	1.80
user commits	249	0.07	0.06
user rollbacks	3,647	1.01	0.94
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	2,938	0.81	0.75
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	4,434,162	4,433,210
opened cursors current	75	84
logons current	35	36

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 Rd(ms)	Av Blks/Rd	Writes	Buffer Waits
SYSAUX	19	8.42	1.21	201	0
UNDOTBS2	0	0.00	0.00	72	0
SYSTEM	17	7.06	1.00	47	2
FMIS0300	0	0.00	0.00	10	0
FMISINDEX	0	0.00	0.00	3	2
FMIS_LARGE	0	0.00	0.00	2	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits
FMIS0300	/dev/rlv_vpd0300_01	0			8	0
FMIS0300	/dev/rlv_vpd0300_03	0			2	0
FMISINDEX	/dev/rlv_vpdindex2	0			3	2
FMIS_LARGE	/dev/rlv_vpd_large2	0			2	0
SYSAUX	/dev/rlv_vpdsysaux01	19	8.42	1.21	201	0
SYSTEM	/dev/rlv_vpdsystem01	3	16.67	1.00	11	0
SYSTEM	/dev/rlv_vpdsystem02	14	5.00	1.00	36	2
UNDOTBS2	/dev/rlv_vpdundo2_1	0			18	0
UNDOTBS2	/dev/rlv_vpdundo2_2	0			10	0
UNDOTBS2	/dev/rlv_vpdundo2_3	0			44	0

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	Buffer Busy Waits
D	443,520	100	558,623	42	391	4
K	15,840		0	0	0	0
R	15,840		0	0	0	0

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	200	1231	3533	1843200	3533
E	0	0	299	3136	1200	1843200	1200

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	704	0.10	43,560	1.18	124,966,369
D	1,408	0.20	87,120	1.10	116,060,776
D	2,112	0.29	130,680	1.06	112,399,452
D	2,816	0.39	174,240	1.04	110,251,059
D	3,520	0.49	217,800	1.03	108,578,956
D	4,224	0.59	261,360	1.02	107,661,625
D	4,928	0.69	304,920	1.01	106,767,523
D	5,632	0.79	348,480	1.01	106,442,358
D	6,336	0.88	392,040	1.00	105,962,411
D	7,040	0.98	435,600	1.00	105,852,559
D	7,168	1.00	443,520	1.00	105,833,706
D	7,744	1.08	479,160	1.00	105,655,290
D	8,448	1.18	522,720	1.00	105,486,211
D	9,152	1.28	566,280	0.99	105,230,674
D	9,856	1.38	609,840	0.99	105,122,186
D	10,560	1.47	653,400	0.99	105,071,126
D	11,264	1.57	696,960	0.99	105,012,544
D	11,968	1.67	740,520	0.99	104,963,373
D	12,672	1.77	784,080	0.99	104,723,137
D	13,376	1.87	827,640	0.99	104,662,711
D	14,080	1.96	871,200	0.99	104,263,632

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	184	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	2,000	1,647	411.92	0.00	0.00	0.00	0.00	204,800
E	2,000	1,647	413.72	0.00	0.00	0.00	0.00	204,800

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	2,812	2,812
64K	128K	23	23
512K	1024K	42	42
1M	2M	4	4
2M	4M	9	9
4M	8M	23	23

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
250	0.13	885,826.52	313,162.10	74.00	501
500	0.25	885,826.52	109,649.65	89.00	0
1,000	0.50	885,826.52	109,649.65	89.00	0
1,500	0.75	885,826.52	109,649.65	89.00	0
2,000	1.00	885,826.52	109,649.65	89.00	0
2,400	1.20	885,826.52	98,167.29	90.00	0
2,800	1.40	885,826.52	98,167.29	90.00	0
3,200	1.60	885,826.52	98,167.29	90.00	0
3,600	1.80	885,826.52	98,167.29	90.00	0
4,000	2.00	885,826.52	98,167.29	90.00	0
6,000	3.00	885,826.52	98,167.29	90.00	0
8,000	4.00	885,826.52	98,167.29	90.00	0
12,000	6.00	885,826.52	98,167.29	90.00	0
16,000	8.00	885,826.52	98,167.29	90.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
1,184	0.29	52	12,029	179,968,513	1.00	685,514	3.04	210,248,038
1,600	0.39	52	12,029	180,354,422	1.00	299,605	1.33	210,302,912
2,016	0.49	259	62,798	180,383,116	1.00	270,911	1.20	210,310,449
2,432	0.59	466	83,511	180,411,533	1.00	242,494	1.08	210,314,882
2,848	0.70	506	86,387	180,416,288	1.00	237,739	1.05	210,316,948
3,264	0.80	506	86,387	180,416,302	1.00	237,725	1.05	210,318,217
3,680	0.90	506	86,392	180,421,445	1.00	232,582	1.03	210,319,097
4,096	1.00	506	86,392	180,428,654	1.00	225,373	1.00	210,319,534
4,512	1.10	506	86,398	180,428,658	1.00	225,369	1.00	210,319,615
4,928	1.20	506	86,398	180,428,658	1.00	225,369	1.00	210,319,639
5,344	1.30	506	86,398	180,428,658	1.00	225,369	1.00	210,319,639
5,760	1.41	506	86,398	180,428,658	1.00	225,369	1.00	210,319,639
6,176	1.51	506	86,398	180,428,658	1.00	225,369	1.00	210,319,639
6,592	1.61	506	86,398	180,428,658	1.00	225,369	1.00	210,319,639
7,008	1.71	506	86,398	180,428,658	1.00	225,369	1.00	210,319,639
7,424	1.81	506	86,398	180,428,658	1.00	225,369	1.00	210,319,639
7,840	1.91	506	86,398	180,428,658	1.00	225,369	1.00	210,319,639
8,256	2.02	506	86,398	180,428,658	1.00	225,369	1.00	210,319,639

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

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	4	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	Av Wt Time(ms)
TM-DML	718	718	0	106	1.46
CF-Controlfile Transaction	8,592	8,592	0	135	0.81
PS-PX Process Reservation	161	160	1	54	0.63
JQ-Job Queue	67	58	9	36	0.72
TT-Tablespace	73	73	0	40	0.55
WF-AWR Flush	22	22	0	12	0.67
TD-KTF map table enqueue (KTF dump entries)	3	3	0	3	1.00
PI-Remote PX Process Spawn Status	3	3	0	1	2.00
DR-Distributed Recovery	1	1	0	1	1.00
MW-MWIN Schedule	1	1	0	1	1.00
IR-Instance Recovery	1	1	0	1	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
4	0.12	1,121	0	3	5760/5760	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 Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
09-Mar 04:08	81	625	3	5,760	0/0	0/0/0/0/0/0
09-Mar 03:58	5	290	3	5,760	0/0	0/0/0/0/0/0
09-Mar 03:48	0	0	0	5,760	0/0	0/0/0/0/0/0
09-Mar 03:38	0	0	0	5,760	0/0	0/0/0/0/0/0
09-Mar 03:28	0	0	0	5,760	0/0	0/0/0/0/0/0
09-Mar 03:18	2	39	1	5,760	0/0	0/0/0/0/0/0
09-Mar 03:08	36	167	3	5,760	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 db client latch	2,437	0.00		0	0
ASM network background latch	1	0.00		0	0
AWR Alerted Metric Element list	18,428	0.00		0	0
Consistent RBA	1,038	0.00		0	0
FAL request queue	73	0.00		0	0
FAL subheap alocation	73	0.00		0	0
FOB s.o list latch	384	0.00		0	0
JS broadcast add buf latch	356	0.00		0	0
JS broadcast drop buf latch	356	0.00		0	0
JS broadcast load blnc latch	311	0.00		0	0
JS mem alloc latch	9	0.00		0	0
JS queue access latch	9	0.00		0	0
JS queue state obj latch	13,080	0.00		0	0
JS slv state obj latch	5	0.00		0	0
KCL gc element parent latch	9,569	0.01	0.00	0	45	0.00
KJC message pool free list	45,724	0.26	0.00	0	1,758	0.74
KJCT flow control latch	93,846	0.37	0.00	0	0
KMG MMAN ready and startup request latch	1,207	0.00		0	0
KTF sga latch	6	0.00		0	1,161	0.00
KWQMN job cache list latch	288	0.00		0	0
KWQP Prop Status	2	0.00		0	0
MQL Tracking Latch	0			0	73	0.00
Memory Management Latch	0			0	1,207	0.00
OS process	147	0.00		0	0
OS process allocation	1,306	0.00		0	0
OS process: request allocation	79	0.00		0	0
PL/SQL warning settings	1,178	0.00		0	0
SGA IO buffer pool latch	5	0.00		0	5	0.00
SQL memory manager latch	1	0.00		0	1,205	0.00
SQL memory manager workarea list latch	81,804	0.00		0	0
Shared B-Tree	131	0.00		0	0
active checkpoint queue latch	2,521	0.00		0	0
active service list	4,783	0.00		0	1,219	0.00
archive control	80	0.00		0	0
archive process latch	1,351	0.00		0	0
begin backup scn array	8	0.00		0	0
business card	46	0.00		0	0
cache buffer handles	41	0.00		0	0
cache buffers chains	991,780	0.00	0.00	0	3,143	0.00
cache buffers lru chain	1,560	0.00		0	4,127	0.02
cache table scan latch	0			0	1	0.00
channel handle pool latch	79	0.00		0	0
channel operations parent latch	154,828	0.00	0.00	0	0
checkpoint queue latch	241,687	0.00	0.00	0	738	0.00
client/application info	540	0.00		0	0
commit callback allocation	12	0.00		0	0
compile environment latch	125	0.00		0	0
dml lock allocation	1,496	0.00		0	0
dummy allocation	249	0.00		0	0
enqueue hash chains	54,902	0.00		0	13	0.00
enqueues	53,256	0.01	0.00	0	0
error message lists	111	0.00		0	0
event group latch	40	0.00		0	0
file cache latch	515	0.00		0	0
gcs opaque info freelist	1,940	0.00		0	0
gcs partitioned table hash	20,581	0.00		0	0
gcs remastering latch	244	0.00		0	0
gcs resource freelist	2,251	0.00		0	655	0.00
gcs resource hash	11,265	0.02	0.00	0	0
gcs shadows freelist	2,427	0.00		0	1,307	0.00
ges caches resource lists	952,058	0.05	0.00	0	948,805	0.04
ges deadlock list	2,354	0.00		0	0
ges domain table	12,188	0.00		0	0
ges enqueue table freelist	17,255	0.01	0.00	0	0
ges group table	17,332	0.01	0.00	0	0
ges process hash list	4,036	0.00		0	0
ges process parent latch	614,034	0.00	0.05	0	397,703	0.00
ges process table freelist	79	0.00		0	0
ges resource hash list	620,123	0.01	0.23	0	967,284	0.00
ges resource scan list	14	0.00		0	0
ges resource table freelist	572,244	0.00	0.00	0	2	0.00
ges timeout list	1,610	0.00		0	1,770	0.00
global KZLD latch for mem in SGA	24	0.00		0	0
global ctx hash table latch	161	0.00		0	0
hash table column usage latch	108	1.85	0.00	0	87,741	0.01
hash table modification latch	44	0.00		0	0
job workq parent latch	0			0	116	0.00
job_queue_processes parameter latch	77	0.00		0	0
kks stats	49,078	7.21	0.15	26	0
kokc descriptor allocation latch	24	0.00		0	0
ksuosstats global area	243	0.00		0	0
ktm global data	5	0.00		0	0
kwqbsn:qsga	130	0.00		0	0
lgwr LWN SCN	1,580	0.00		0	0
library cache	1,001,442	1.86	0.07	5	6,033,268	0.12
library cache load lock	1,476	0.07	0.00	0	0
library cache lock	64,457	0.04	0.00	0	0
library cache lock allocation	975	0.00		0	0
library cache pin	22,191	0.02	0.00	0	6	0.00
library cache pin allocation	1,099	0.00		0	0
list of block allocation	161	0.00		0	0
loader state object freelist	2	0.00		0	0
logminer context allocation	1	0.00		0	0
message pool operations parent latch	405	0.00		0	0
messages	120,210	0.01	0.00	0	0
mostly latch-free SCN	1,585	0.32	0.00	0	0
multiblock read objects	122	0.00		0	0
name-service memory objects	2,456	0.00		0	0
name-service namespace bucket	38,029	0.00		0	0
name-service pending queue	324	0.00		0	0
name-service request	6	0.00		0	0
name-service request queue	36,775	0.00		0	0
ncodef allocation latch	58	0.00		0	0
object queue header heap	409	0.00		0	83	0.00
object queue header operation	4,297	0.02	0.00	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	944	0.00		0	0
parallel query stats	96	0.00		0	0
parallel txn reco latch	780	0.00		0	0
parameter list	21	0.00		0	0
parameter table allocation management	200	2.50	1.20	0	0
post/wait queue	265	0.00		0	172	0.00
process allocation	36,475	0.00		0	40	0.00
process group creation	79	0.00		0	0
process queue	257	0.00		0	0
process queue reference	6,688	0.00		0	383	0.00
qmn task queue latch	512	0.00		0	0
query server freelists	213	0.00		0	0
query server process	1	0.00		0	1	0.00
queued dump request	16,484	0.00		0	0
redo allocation	4,200	0.02	0.00	0	4,356	0.05
redo copy	0			0	4,357	0.25
redo writing	8,167	0.00		0	0
resmgr group change latch	127	0.00		0	0
resmgr:active threads	246	0.00		0	0
resmgr:actses change group	108	0.00		0	0
resmgr:free threads list	245	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	705,121	15.41	0.33	2958	238,792	21.05
rules engine aggregate statistics	6	0.00		0	0
rules engine rule set statistics	112	0.00		0	0
sequence cache	1,071	0.00		0	0
session allocation	190,916	6.63	0.00	0	0
session idle bit	18,521	0.00		0	0
session state list latch	358	0.00		0	0
session switching	58	0.00		0	0
session timer	1,219	0.00		0	0
shared pool	943,387	5.21	0.14	236	0
shared pool simulator	3,160,568,499	0.00	0.01	0	0
simulator hash latch	29,290	0.00		0	0
simulator lru latch	0			0	29,274	0.00
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	98	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	840	0.00		0	0
threshold alerts latch	171	0.00		0	0
transaction allocation	28,917	0.00		0	0
transaction branch allocation	1,219	0.00		0	0
undo global data	14,885	0.00		0	0
user lock	236	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	705,121	108,641	35,534	87,051
shared pool	943,387	49,128	6,842	43,097
library cache	1,001,442	18,653	1,262	17,519
session allocation	190,916	12,661	4	12,657
kks stats	49,078	3,538	544	3,176
shared pool simulator	3,160,568,499	100	1	99
ges resource hash list	620,123	87	20	67
ges process parent latch	614,034	22	1	21
parameter table allocation management	200	5	6	0
slave class create	8	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
ges process parent latch	kjpdmc	1	0
ges resource hash list	kjrmas1: lookup master node	8	1
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	6	3
ges resource hash list	kjrref: find matched resource	4	13
ges resource hash list	kjakcai: search for resp by resname	2	0
kks stats	kks stats alloc/free	544	544
library cache	kqlmbfre: child: in loop	175	714
library cache	kglukp: child	60	28
library cache	kqlmbfre: child: no obj to free	42	227
library cache	kglpndl: child: before processing	8	6
library cache	kglhdunp: parent: flush	5	0
library cache	kglpndl: child: after processing	4	0
library cache	kglLockCursor	2	1
library cache	kgldte: child 0	2	34
library cache	kglobpn: child:	2	5
library cache	kglScanDependency	1	0
library cache	kglati	1	1
library cache	kglhdgn: child:	1	10
library cache	kglini: child	1	0
library cache	kglpin	1	8
library cache lock	kgllkdl: child: no lock handle	2	1
parameter table allocation management	ksp_param_table_free	6	6
row cache objects	kqrbip	1,444	30,186
row cache objects	kqrigt	90	4,897
row cache objects	kqrpre: find obj	24	203
row cache objects	kqreqd: reget	21	8
row cache objects	kqreqd	5	24
row cache objects	kqrbgl	4	2
row cache objects	ksucallcbksafely: kqrhngc	3	0
row cache objects	kqrso	2	11
row cache objects	kqrbtm: pop parent	1	4
row cache objects	kqrpre: init complete	1	9
session allocation	ksuprc	3	1
session allocation	ksudlc	1	3
shared pool	kghfrunp: clatch: nowait	31,824	0
shared pool	kghfrunp: alloc: wait	5,439	1
shared pool	kghfrunp: clatch: wait	3,070	400
shared pool	kghfre	1,067	5,579
shared pool	kghupr1	133	753
shared pool	kghdmp	115	0
shared pool	kghalo	66	419
shared pool	kghalp	12	59
shared pool	kghasp	6	31
shared pool	kghfsh	3	0
shared pool	kghfrh	1	0
shared pool simulator	kglsim_unpin_simhp	1	0
slave class create	ksvcreate	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by 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: 561,073
Captured Segments account for 95.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	TAB$	TABLE	92,912	16.56
SYS	SYSTEM	I_OBJ#	INDEX	90,400	16.11
SYS	SYSTEM	IND$	TABLE	74,544	13.29
SYS	SYSTEM	LOB$	TABLE	54,576	9.73
SYS	SYSTEM	CLU$	TABLE	54,560	9.72

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 42
Captured Segments account for 16.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	HISTGRM$		TABLE	5	11.90
SYS	SYSTEM	HIST_HEAD$		TABLE	2	4.76

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% 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	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	JOB$		TABLE	1	100.00

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
FMIS0300	FMISINDEX	IDU060712193340934	INDEX	1	33.33
FMIS0300	FMISINDEX	IDX060712193341043	INDEX	1	33.33
SYS	SYSTEM	SEQ$	TABLE	1	33.33

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 820
Captured Segments account for 53.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	HISTGRM$	TABLE	138	16.83
FMIS0300	FMIS0300	XTCLUSTERUSER	TABLE	53	6.46
FMIS0300	FMISINDEX	IDU060712193340934	INDEX	33	4.02
SYS	SYSTEM	SEG$	TABLE	31	3.78
FMIS0300	FMIS0300	XTCLUSTERLOCK	TABLE	22	2.68

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 354
Captured Segments account for 67.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
SYS	SYSTEM	HISTGRM$	TABLE	37	10.45
FMIS0300	FMIS0300	XTCLUSTERLOCK	TABLE	32	9.04
FMIS0300	FMISINDEX	IDU060712193340934	INDEX	31	8.76
FMIS0300	FMIS0300	QRTZ_LOCKS	TABLE	19	5.37
FMIS0300	FMIS0300	XTCLUSTERUSER	TABLE	19	5.37

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	22	18.18	0	1
dc_database_links	60	1.67	0	1
dc_files	1,275	6.67	0	85
dc_global_oids	64	23.44	0	15
dc_histogram_data	5,762	24.28	0	922
dc_histogram_defs	5,328	39.38	0	1,632
dc_object_ids	5,294	7.88	0	386
dc_objects	2,180	13.94	0	354
dc_profiles	81	2.47	0	1
dc_rollback_segments	1,364	0.00	0	158
dc_segments	953	39.14	25	370
dc_sequences	41	17.07	41	4
dc_tablespaces	21,092	0.11	0	7
dc_usernames	1,295	0.54	0	7
dc_users	23,067	0.09	0	20
outstanding_alerts	75	80.00	6	0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	4	2	2
dc_database_links	1	0	1
dc_files	85	0	85
dc_global_oids	15	0	32
dc_histogram_defs	2,098	0	415,712
dc_object_ids	417	0	8,258
dc_objects	304	0	8,369
dc_profiles	2	0	2
dc_segments	420	5	15,266
dc_sequences	82	1	4
dc_tablespaces	24	0	34
dc_usernames	7	0	26
dc_users	11	0	31
outstanding_alerts	146	56	3

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	33	3.03	2,006	0.05	0	0
CLUSTER	72	2.78	201	1.49	1	0
INDEX	9	100.00	20	45.00	0	0
SQL AREA	3,349	16.12	19,139	18.43	782	447
TABLE/PROCEDURE	842	22.21	7,786	8.90	138	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	201	2	3	2
INDEX	20	9	60	9
TABLE/PROCEDURE	2,708	178	63,336	98

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	353.00		9.29	22.62	135	135	38	38
	Freeable	56.50	0.00	2.69	3.30	11		21	21
	SQL	2.06	1.35	0.11	0.26	1	112	19	17
	PL/SQL	0.37	0.23	0.01	0.01	0	0	36	35
E	Other	354.57		9.09	22.36	135	135	39	39
	Freeable	56.63	0.00	2.57	3.25	11		22	22
	SQL	2.13	1.28	0.11	0.24	1	112	20	17
	PL/SQL	0.41	0.26	0.01	0.02	0	0	37	36

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	8,053,063,680
Fixed Size	2,107,464
Redo Buffers	14,667,776
Variable Size	5,570,037,688

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	256.00	256.00	0.00
large	free memory	256.00	256.00	0.00
shared	CCursor	140.46		-100.00
shared	KGLS heap	139.58		-100.00
shared	KQR L PO	436.93		-100.00
shared	PCursor	57.21		-100.00
shared	free memory	1,660.18	3,186.36	91.93
shared	gcs resources	83.36	83.36	0.00
shared	gcs shadows	49.83	49.83	0.00
shared	ges enqueues	165.27	165.27	0.00
shared	ges resource	475.33	346.74	-27.05
shared	library cache	140.97		-100.00
shared	rm request queue link	41.90	41.90	0.00
shared	sql area	400.07		-100.00
shared	sql area:PLSQL	89.64		-100.00
streams	free memory	16.00	16.00	0.00
	buffer_cache	7,680.00	7,680.00	0.00
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.99	13.99	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 Coordinator	25,050	0	0
QMON Slaves	12,639	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

No data exists for this section of the report.

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	6	451

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_shadows	401,861	466,409	538401	538401

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/app/admin/CWGKVPD/adump
background_dump_dest	/oracle/app/admin/CWGKVPD/bdump
bitmap_merge_area_size	131072
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.3.0
control_files	/dev/rlv_vpdctrl01, /dev/rlv_vpdctrl02, /dev/rlv_vpdctrl03
core_dump_dest	/oracle/app/admin/CWGKVPD/cdump
create_bitmap_area_size	131072
db_block_size	16384
db_cache_size	7516192768
db_domain
db_file_multiblock_read_count	16
db_keep_cache_size	268435456
db_name	CWGKVPD
db_recycle_cache_size	268435456
dispatchers	(PROTOCOL=TCP) (SERVICE=CWGKVPD2XDB)
hash_area_size	2097152
instance_number	2
java_pool_size	268435456
job_queue_processes	4
large_pool_size	268435456
log_archive_dest_1	location=/cwgkvpd2_archive
open_cursors	300
optimizer_mode	CHOOSE
pga_aggregate_target	2097152000
processes	500
recyclebin	OFF
remote_listener	LISTENERS_CWGKVPD
remote_login_passwordfile	EXCLUSIVE
service_names	CWGK
sessions	555
sga_max_size	13639876608
sga_target	0
shared_pool_size	4294967296
sort_area_size	1048576
streams_pool_size	16777216
thread	2
undo_management	AUTO
undo_tablespace	UNDOTBS2
user_dump_dest	/oracle/app/admin/CWGKVPD/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	3,505	0.97	0.90
acks for commit broadcast(logical)	3,531	0.98	0.91
broadcast msgs on commit(actual)	1,036	0.29	0.27
broadcast msgs on commit(logical)	1,037	0.29	0.27
broadcast msgs on commit(wasted)	67	0.02	0.02
broadcast on commit wait time(ms)	61	0.02	0.02
broadcast on commit waits	729	0.20	0.19
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	12	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	731	0.20	0.19
gcs ast xid	0	0.00	0.00
gcs blocked converts	658	0.18	0.17
gcs blocked cr converts	1,156	0.32	0.30
gcs compatible basts	1	0.00	0.00
gcs compatible cr basts (global)	85	0.02	0.02
gcs compatible cr basts (local)	769	0.21	0.20
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	45	0.01	0.01
gcs dbwr write request msgs	77	0.02	0.02
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	60	0.02	0.02
gcs immediate (null) converts	127	0.04	0.03
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	615	0.17	0.16
gcs indirect ast	434	0.12	0.11
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	32	0.01	0.01
gcs msgs process time(ms)	282	0.08	0.07
gcs msgs received	11,304	3.12	2.90
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs side channel msgs actual	226	0.06	0.06
gcs side channel msgs logical	1,274	0.35	0.33
gcs stale cr	0	0.00	0.00
gcs undo cr	0	0.00	0.00
gcs write notification msgs	4	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	449	0.12	0.12
ges msgs received	8,669	2.40	2.23
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	592	0.16	0.15
implicit batch messages sent	8,628	2.39	2.21
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	30,365	8.39	7.79
messages queue sent actual	33,622	9.29	8.63
messages queue sent logical	50,544	13.97	12.97
messages received actual	16,957	4.69	4.35
messages received logical	19,973	5.52	5.13
messages sent directly	3,090	0.85	0.79
messages sent indirectly	288,874	79.85	74.15
messages sent not implicit batched	24,994	6.91	6.42
messages sent pbatched	294,898	81.52	75.69
msgs causing lmd to send msgs	2,906	0.80	0.75
msgs causing lms(s) to send msgs	274	0.08	0.07
msgs received queue time (ms)	190	0.05	0.05
msgs received queued	19,973	5.52	5.13
msgs sent queue time (ms)	2,367	0.65	0.61
msgs sent queue time on ksxp (ms)	13,636	3.77	3.50
msgs sent queued	49,713	13.74	12.76
msgs sent queued on ksxp	40,290	11.14	10.34
process batch messages received	5,282	1.46	1.36
process batch messages sent	22,072	6.10	5.67

Global CR Served Stats

Statistic	Total
CR Block Requests	714
CURRENT Block Requests	873
Data Block Requests	714
Undo Block Requests	0
TX Block Requests	834
Current Results	1,587
Private results	0
Zero Results	0
Disk Read Results	0
Fail Results	0
Fairness Down Converts	172
Fairness Clears	0
Free GC Elements	0
Flushes	1
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	0
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
Pins	1,190	99.92	0.00	0.08
Flushes	2	50.00	50.00	0.00
Writes	63	31.75	58.73	9.52

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
1	data block	518	99.23	0.77	0.00	307	100.00	0.00	0.00
1	undo header	241	99.59	0.41	0.00	2	100.00	0.00	0.00
1	Others	90	100.00	0.00	0.00	59	100.00	0.00	0.00

End of Report

% Blocks changed per Read:	1.16	Recursive Call %:	95.37
Rollback per transaction %:	93.61	Rows per Sort:	190.78

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	85.51	Soft Parse %:	87.06
Execute to Parse %:	48.82	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	0.17	% Non-Parse CPU:	98.97

Buffer access - local cache %:	99.78
Buffer access - remote cache %:	0.21
Buffer access - disk %:	0.01

Avg global enqueue get time (ms):	0.2
Avg global cache cr block receive time (ms):	0.4
Avg global cache current block receive time (ms):	0.4
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 %:	0.1
Avg global cache cr block flush time (ms):	0.0
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.2
Avg global cache current block flush time (ms):	0.0

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.3
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.1
% of direct sent messages:	0.96
% of indirect sent messages:	89.62
% of flow controlled messages:	9.42