WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

SHCCIOT 1215723246 SHCCIOT 1 28-May-14 01:05 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
SHCCIOT	1215723246	SHCCIOT	1	28-May-14 01:05	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

bakersfield750 Linux x86 64-bit 32 16 2 126.01

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
bakersfield750	Linux x86 64-bit	32	16	2	126.01

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 8891 04-Jun-14 21:00:22 78 3.9

End Snap: 8892 04-Jun-14 22:00:25 85 3.7

Elapsed: 60.05 (mins)

DB Time: 29.74 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	8891	04-Jun-14 21:00:22	78	3.9
End Snap:	8892	04-Jun-14 22:00:25	85	3.7
Elapsed:		60.05 (mins)
DB Time:		29.74 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 31,872M 31,872M Std Block Size: 8K

Shared Pool Size: 5,120M 5,120M Log Buffer: 344,792K

	Begin	End
Buffer Cache:	31,872M	31,872M	Std Block Size:	8K
Shared Pool Size:	5,120M	5,120M	Log Buffer:	344,792K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.5 0.1 0.01 0.01

DB CPU(s): 0.5 0.1 0.01 0.01

Redo size: 4,846.6 804.3

Logical reads: 365,363.2 60,632.0

Block changes: 30.2 5.0

Physical reads: 0.0 0.0

Physical writes: 0.6 0.1

User calls: 57.0 9.5

Parses: 0.2 0.0

Hard parses: 0.0 0.0

W/A MB processed: 0.0 0.0

Logons: 0.0 0.0

Executes: 46.9 7.8

Rollbacks: 0.0 0.0

Transactions: 6.0

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.5	0.1	0.01	0.01
DB CPU(s):	0.5	0.1	0.01	0.01
Redo size:	4,846.6	804.3
Logical reads:	365,363.2	60,632.0
Block changes:	30.2	5.0
Physical reads:	0.0	0.0
Physical writes:	0.6	0.1
User calls:	57.0	9.5
Parses:	0.2	0.0
Hard parses:	0.0	0.0
W/A MB processed:	0.0	0.0
Logons:	0.0	0.0
Executes:	46.9	7.8
Rollbacks:	0.0	0.0
Transactions:	6.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.95 Soft Parse %: 96.64

Execute to Parse %: 99.65 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 34.78 % Non-Parse CPU: 100.00

Shared Pool Statistics

Begin End

Memory Usage %: 63.66 63.69

% SQL with executions>1: 99.73 99.76

% Memory for SQL w/exec>1: 95.46 99.26

	Begin	End
Memory Usage %:	63.66	63.69
% SQL with executions>1:	99.73	99.76
% Memory for SQL w/exec>1:	95.46	99.26

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		1,757		98.49
log file sync	21,707	30	1	1.67	Commit
SQL*Net message to client	204,511	0	0	0.02	Network
control file sequential read	293	0	0	0.01	System I/O
SQL*Net message from dblink	18	0	4	0.00	Network

Host CPU (CPUs: 32 Cores: 16 Sockets: 2)

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

0.55 1.26 2.8 1.0 0.2 96.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.55	1.26	2.8	1.0	0.2	96.1

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

1.5 39.7 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 129,031.6 129,031.6

SGA use (MB): 38,784.0 38,784.0

PGA use (MB): 149.2 158.9

% Host Mem used for SGA+PGA: 30.17 30.18

	Begin	End
Host Mem (MB):	129,031.6	129,031.6
SGA use (MB):	38,784.0	38,784.0
PGA use (MB):	149.2	158.9
% Host Mem used for SGA+PGA:	30.17	30.18

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 1784.2s
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
DB CPU	1,757.32	98.49
sql execute elapsed time	1,732.06	97.08
parse time elapsed	0.22	0.01
repeated bind elapsed time	0.10	0.01
hard parse elapsed time	0.10	0.01
PL/SQL execution elapsed time	0.08	0.00
connection management call elapsed time	0.03	0.00
sequence load elapsed time	0.00	0.00
DB time	1,784.17
background elapsed time	55.12
background cpu time	18.68

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	447,555
IDLE_TIME	11,176,958
IOWAIT_TIME	22,329
NICE_TIME	0
SYS_TIME	119,892
USER_TIME	326,598
LOAD	1	1
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	135,299,489,792
NUM_CPUS	32
NUM_CPU_CORES	16
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_DEFAULT	262,144
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	8,192
TCP_SEND_SIZE_DEFAULT	262,144
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	8,192

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
04-Jun 21:00:22	0.55
04-Jun 22:00:25	1.26	3.85	2.81	1.03	96.15	0.19

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 100.2% of Total DB time 1,784.17 (s)
Total FG Wait Time: 30.39 (s) DB CPU time: 1,757.32 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			1,757		98.49
Commit	21,707	0	30	1	1.67
Network	204,546	0	0	0	0.02
System I/O	293	0	0	0	0.01
Other	12	25	0	4	0.00
User I/O	1,048	0	0	0	0.00
Administrative	0		0		0.00
Concurrency	0		0		0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
log file sync	21,707	0	30	1	1.00	1.67
SQL*Net message to client	204,511	0	0	0	9.42	0.02
control file sequential read	293	0	0	0	0.01	0.01
SQL*Net message from dblink	18	0	0	4	0.00	0.00
ADR block file read	7	0	0	6	0.00	0.00
Disk file operations I/O	15	0	0	1	0.00	0.00
utl_file I/O	1,033	0	0	0	0.05	0.00
CSS initialization	1	0	0	2	0.00	0.00
SQL*Net message from client	204,510	0	203,837	997	9.42
jobq slave wait	142	99	70	495	0.01
single-task message	1	0	0	24	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	21,814	0	20	1	1.00	36.15
control file parallel write	1,279	0	3	2	0.06	5.52
control file sequential read	2,470	0	2	1	0.11	2.83
db file async I/O submit	1,189	0	1	1	0.05	1.42
JS coord start wait	1	100	1	500	0.00	0.91
os thread startup	21	0	0	18	0.00	0.70
db file parallel write	1,189	0	0	0	0.05	0.40
db file sequential read	15	0	0	7	0.00	0.20
resmgr:internal state change	1	100	0	100	0.00	0.18
Disk file operations I/O	116	0	0	1	0.01	0.16
ADR block file read	15	0	0	5	0.00	0.15
rdbms ipc reply	1	0	0	19	0.00	0.03
ADR block file write	5	0	0	0	0.00	0.00
log file sync	2	0	0	1	0.00	0.00
rdbms ipc message	42,615	49	52,066	1222	1.96
DIAG idle wait	7,190	100	7,197	1001	0.33
Space Manager: slave idle wait	1,006	98	4,971	4942	0.05
Streams AQ: qmn coordinator idle wait	266	48	3,613	13583	0.01
Streams AQ: qmn slave idle wait	129	0	3,613	28009	0.01
pmon timer	1,201	100	3,604	3001	0.06
smon timer	16	69	3,602	225131	0.00
SQL*Net message from client	21	0	0	1	0.00
class slave wait	16	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	22	36.4		13.6	18.2	31.8
ADR block file write	5	100.0
ADR file lock	6	100.0
ASM file metadata operation	1	100.0
CSS initialization	1			100.0
Disk file operations I/O	131	91.6		.8	2.3	5.3
JS coord start wait	1							100.0
LGWR wait for redo copy	29	100.0
SQL*Net message from dblink	18	44.4	11.1	27.8	11.1		5.6
SQL*Net message to client	204.5K	100.0
SQL*Net message to dblink	17	100.0
asynch descriptor resize	34	100.0
control file parallel write	1279	78.7	19.7	.9	.2	.2	.1	.3
control file sequential read	2763	98.7	.6	.1	.3	.2	.1	.1
db file async I/O submit	1191	99.5	.3		.1			.1
db file parallel write	1191	99.0	.8	.1		.1
db file sequential read	15				53.3	46.7
direct path write	1	100.0
latch free	1	100.0
latch: call allocation	2	100.0
log file parallel write	21.8K	94.9	4.2	.6	.2	.1	.0	.1
log file sync	21.7K	89.2	9.1	1.1	.2	.1	.1	.2
os thread startup	21					28.6	71.4
rdbms ipc reply	1						100.0
reliable message	2	100.0
resmgr:internal state change	1							100.0
utl_file I/O	1033	100.0
DIAG idle wait	7190							100.0
SQL*Net message from client	204.6K	74.9	5.3	3.0	1.7	.3	.2	4.0	10.6
Space Manager: slave idle wait	1008		.1		.1			.8	99.0
Streams AQ: qmn coordinator idle wait	264	51.5							48.5
Streams AQ: qmn slave idle wait	128								100.0
class slave wait	16	100.0
jobq slave wait	147							100.0
pmon timer	1200								100.0
rdbms ipc message	42.6K	37.7	3.4	.1	.2	.3	.4	29.0	29.0
single-task message	1						100.0
smon timer	19		5.3		5.3			21.1	68.4

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<1/8s	<1/4s	<1/2s	<1s
		% of Total Waits
JS coord start wait	1				100.0
control file parallel write	4	99.7			.3
control file sequential read	2	99.9		.0	.0
db file async I/O submit	1	99.9			.1
log file parallel write	22	99.9	.0	.0	.1	.0
log file sync	44	99.8	.0	.0	.1	.0
resmgr:internal state change	1		100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Logical Reads (K)
SHCCIOT	1,749	1,723	1,316,189
SYS$USERS	34	34	107
SYS$BACKGROUND	0	0	16

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	Concurcy Total Wts	Admin Total Wts	Admin Wt Time	Network Total Wts
SHCCIOT	1	0	0	0	68680
SYS$USERS	1047	0	0	0	135855
SYS$BACKGROUND	133	22	1	1	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,675.40	124	13.51	93.90	100.00	0.00	3wr0rz6hquxg6	LedgerExport@deepbay751 (TNS V1-V3)	INSERT INTO ACCT_BOOK (ACCT_B...
21.63	125	0.17	1.21	99.48	0.03	07sf7mbmdm8v9	LedgerExport@deepbay751 (TNS V1-V3)	DELETE FROM ACCT_ITEM WHERE AC...
21.42	1,343	0.02	1.20	99.68	0.00	08wftvygkvwxr	PL/SQL Developer	select /+ all_rows / count(...
6.43	63,000	0.00	0.36	13.38	0.00	f173ympfbb2cy	JDBC Thin Client	select * from (select distinct...
5.02	207	0.02	0.28	96.53	0.00	cd9kh7jfykwdu	oracle@bakersfield750 (TNS V1-V3)	SELECT COUNT(*) FROM "ACCT_ITE...
4.26	2,340	0.00	0.24	85.03	0.00	1x7hp5cbvz2un	mdbClean@deepbay751 (TNS V1-V3)	delete from CC_MDB_CHANGE_NOTI...
3.14	20,889	0.00	0.18	16.09	0.00	gpy4xf1g906kp	JDBC Thin Client	SELECT * FROM (SELECT a.interf...
1.95	720	0.00	0.11	85.01	0.00	0wy2cjyd5caz2	mdbFlushFromOra@deepbay751 (TNS V1-V3)	select count(1) COUNTS from c...
1.88	10,728	0.00	0.11	15.12	0.00	0jqgub0ftgk7n	mdbFlushSequence@deepbay751 (TNS V1-V3)	update CC_MDB_SEQUENCE set STA...
1.56	10,728	0.00	0.09	17.27	0.00	56rb8z2j522d3	mdbFlushSequence@deepbay751 (TNS V1-V3)	update TT_MDB_SEQUENCE set STA...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,675.37	124	13.51	95.34	1,675.40	100.00	0.00	3wr0rz6hquxg6	LedgerExport@deepbay751 (TNS V1-V3)	INSERT INTO ACCT_BOOK (ACCT_B...
21.52	125	0.17	1.22	21.63	99.48	0.03	07sf7mbmdm8v9	LedgerExport@deepbay751 (TNS V1-V3)	DELETE FROM ACCT_ITEM WHERE AC...
21.35	1,343	0.02	1.21	21.42	99.68	0.00	08wftvygkvwxr	PL/SQL Developer	select /+ all_rows / count(...
4.85	207	0.02	0.28	5.02	96.53	0.00	cd9kh7jfykwdu	oracle@bakersfield750 (TNS V1-V3)	SELECT COUNT(*) FROM "ACCT_ITE...
3.62	2,340	0.00	0.21	4.26	85.03	0.00	1x7hp5cbvz2un	mdbClean@deepbay751 (TNS V1-V3)	delete from CC_MDB_CHANGE_NOTI...
1.66	720	0.00	0.09	1.95	85.01	0.00	0wy2cjyd5caz2	mdbFlushFromOra@deepbay751 (TNS V1-V3)	select count(1) COUNTS from c...
0.86	63,000	0.00	0.05	6.43	13.38	0.00	f173ympfbb2cy	JDBC Thin Client	select * from (select distinct...
0.58	1	0.58	0.03	0.59	99.52	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
0.51	20,889	0.00	0.03	3.14	16.09	0.00	gpy4xf1g906kp	JDBC Thin Client	SELECT * FROM (SELECT a.interf...
0.50	120	0.00	0.03	0.50	99.26	0.00	772s25v1y0x8k		select shared_pool_size_for_es...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.12	1	0.12	51.63	0.12	2.54	98.12	350myuyx0t1d6		insert into wrh$_tablespace_st...
0.01	1	0.01	5.51	0.05	73.80	23.96	b4qw7n9wg64mh		INSERT /*+ APPEND LEADING(@"SE...
0.01	1	0.01	3.16	0.04	82.94	16.76	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.01	125	0.00	2.68	21.63	99.48	0.03	07sf7mbmdm8v9	LedgerExport@deepbay751 (TNS V1-V3)	DELETE FROM ACCT_ITEM WHERE AC...
0.00	1	0.00	1.57	0.24	64.41	1.46	73629tmfbjzrh	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
0.00	1,343	0.00	0.00	21.42	99.68	0.00	08wftvygkvwxr	PL/SQL Developer	select /+ all_rows / count(...
0.00	1	0.00	0.00	0.06	15.58	0.00	0dt31u12uau0k	LedgerExport@deepbay751 (TNS V1-V3)	SELECT COUNT(DISTINCT ACCT_ID)...
0.00	1	0.00	0.00	0.04	99.81	0.00	0j6d9y40st3k1	DBMS_SCHEDULER	select client_name, status fr...
0.00	10,728	0.00	0.00	1.88	15.12	0.00	0jqgub0ftgk7n	mdbFlushSequence@deepbay751 (TNS V1-V3)	update CC_MDB_SEQUENCE set STA...
0.00	5	0.00	0.00	0.00	33.40	0.00	0k8522rmdzg4k		select privilege# from sysauth...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - Buffer Gets as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 1,316,441,983
Captured SQL account for 100.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	SQL Id	SQL Module	SQL Text
1,313,459,418	124	10,592,414.66	99.77	1,675.40	100	3wr0rz6hquxg6	LedgerExport@deepbay751 (TNS V1-V3)	INSERT INTO ACCT_BOOK (ACCT_B...
1,497,343	125	11,978.74	0.11	21.63	99.5	07sf7mbmdm8v9	LedgerExport@deepbay751 (TNS V1-V3)	DELETE FROM ACCT_ITEM WHERE AC...
1,485,358	1,343	1,106.00	0.11	21.42	99.7	08wftvygkvwxr	PL/SQL Developer	select /+ all_rows / count(...
1,069,509	207	5,166.71	0.08	5.02	96.5	cd9kh7jfykwdu	oracle@bakersfield750 (TNS V1-V3)	SELECT COUNT(*) FROM "ACCT_ITE...
168,480	720	234.00	0.01	1.95	85	0wy2cjyd5caz2	mdbFlushFromOra@deepbay751 (TNS V1-V3)	select count(1) COUNTS from c...
53,640	10,728	5.00	0.00	1.88	15.1	0jqgub0ftgk7n	mdbFlushSequence@deepbay751 (TNS V1-V3)	update CC_MDB_SEQUENCE set STA...
52,440	7,397	7.09	0.00	0.57	10.6	18tjm5bt5w948	LedgerExport@deepbay751 (TNS V1-V3)	SELECT ACCT_BOOK_ID, BAL_ID, A...
51,420	2,340	21.97	0.00	4.26	85	1x7hp5cbvz2un	mdbClean@deepbay751 (TNS V1-V3)	delete from CC_MDB_CHANGE_NOTI...
42,912	10,728	4.00	0.00	1.56	17.3	56rb8z2j522d3	mdbFlushSequence@deepbay751 (TNS V1-V3)	update TT_MDB_SEQUENCE set STA...
21,000	10,500	2.00	0.00	0.78	10.9	12z80nvnjx3ma	JDBC Thin Client	select source_id, source_name ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 1
Captured SQL account for 0.0% of Total

Executions	Reads per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
125	0.00	21.63	99.48	0.03	07sf7mbmdm8v9	LedgerExport@deepbay751 (TNS V1-V3)	DELETE FROM ACCT_ITEM WHERE AC...
1,343	0.00	21.42	99.68	0.00	08wftvygkvwxr	PL/SQL Developer	select /+ all_rows / count(...
1	0.00	0.06	15.58	0.00	0dt31u12uau0k	LedgerExport@deepbay751 (TNS V1-V3)	SELECT COUNT(DISTINCT ACCT_ID)...
1	0.00	0.04	99.81	0.00	0j6d9y40st3k1	DBMS_SCHEDULER	select client_name, status fr...
10,728	0.00	1.88	15.12	0.00	0jqgub0ftgk7n	mdbFlushSequence@deepbay751 (TNS V1-V3)	update CC_MDB_SEQUENCE set STA...
5	0.00	0.00	33.40	0.00	0k8522rmdzg4k		select privilege# from sysauth...
12	0.00	0.00	62.40	0.00	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
0		0.00	0.00	0.00	0v3dvmc22qnam		insert into sys.col_usage$ (ob...
5	0.00	0.00	191.71	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
720	0.00	1.95	85.01	0.00	0wy2cjyd5caz2	mdbFlushFromOra@deepbay751 (TNS V1-V3)	select count(1) COUNTS from c...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 1
Captured SQL account for 1.4E+04% of Total
Total UnOptimized Read Requests: 1
Captured SQL account for 1.4E+04% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Module	SQL Text
290	290	1	290.00	0.00	29000.00	73629tmfbjzrh	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
116	116	1	116.00	0.00	11600.00	7qx7y9h2rkt9g	DBMS_SCHEDULER	SELECT ddf.file_name file_name...
19	19	1	19.00	0.00	1900.00	350myuyx0t1d6		insert into wrh$_tablespace_st...
0	0	125	0.00		0.00	07sf7mbmdm8v9	LedgerExport@deepbay751 (TNS V1-V3)	DELETE FROM ACCT_ITEM WHERE AC...
0	0	1,343	0.00		0.00	08wftvygkvwxr	PL/SQL Developer	select /+ all_rows / count(...
0	0	1	0.00		0.00	0dt31u12uau0k	LedgerExport@deepbay751 (TNS V1-V3)	SELECT COUNT(DISTINCT ACCT_ID)...
0	0	1	0.00		0.00	0j6d9y40st3k1	DBMS_SCHEDULER	select client_name, status fr...
0	0	10,728	0.00		0.00	0jqgub0ftgk7n	mdbFlushSequence@deepbay751 (TNS V1-V3)	update CC_MDB_SEQUENCE set STA...
0	0	5	0.00		0.00	0k8522rmdzg4k		select privilege# from sysauth...
0	0	12	0.00		0.00	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 168,819
Captured SQL account for 98.7% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	SQL Id	SQL Module	SQL Text
63,000	0	0.00	6.43	13.4	f173ympfbb2cy	JDBC Thin Client	select * from (select distinct...
20,889	0	0.00	3.14	16.1	gpy4xf1g906kp	JDBC Thin Client	SELECT * FROM (SELECT a.interf...
10,728	10,728	1.00	1.88	15.1	0jqgub0ftgk7n	mdbFlushSequence@deepbay751 (TNS V1-V3)	update CC_MDB_SEQUENCE set STA...
10,728	10,728	1.00	1.56	17.3	56rb8z2j522d3	mdbFlushSequence@deepbay751 (TNS V1-V3)	update TT_MDB_SEQUENCE set STA...
10,611	0	0.00	0.69	12.2	8410zusksmy1j	JDBC Thin Client	SELECT * FROM (SELECT a.interf...
10,500	63,000	6.00	0.78	10.9	12z80nvnjx3ma	JDBC Thin Client	select source_id, source_name ...
7,397	959	0.13	0.57	10.6	18tjm5bt5w948	LedgerExport@deepbay751 (TNS V1-V3)	SELECT ACCT_BOOK_ID, BAL_ID, A...
6,963	6,963	1.00	0.65	16.5	fcfsr8zffddms	JDBC Thin Client	select section from tfm_serv_e...
5,087	0	0.00	0.45	14.1	27q6w0zy3xhh2	JDBC Thin Client	select * from (select ASK_NO, ...
5,087	0	0.00	0.26	14.4	5qas8kt4w9svy	JDBC Thin Client	select * from tom_msg where ro...
5,087	0	0.00	0.63	16.5	8f9tksujz3fac	JDBC Thin Client	update tom_msg set msg_flag = ...
3,537	3,537	1.00	0.33	20.5	cp46kh2um54f5	JDBC Thin Client	select section from tfm_serv_e...
2,340	0	0.00	4.26	85	1x7hp5cbvz2un	mdbClean@deepbay751 (TNS V1-V3)	delete from CC_MDB_CHANGE_NOTI...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 595
Captured SQL account for 47.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
131	131	22.02	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
9	0	1.51	2h0gb24h6zpnu		insert into access$(d_obj#, or...
8	10	1.34	1gfaj4z5hn1kf		delete from dependency$ where ...
8	10	1.34	20vv6ttajyjzq		delete from access$ where d_ob...
7	26	1.18	bsa0wjtftg3uw		select file# from file$ where ...
6	60	1.01	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
6	6	1.01	a1xgxtssv5rrp	MMON_SLAVE	select sum(used_blocks), ts.ts...
6	60	1.01	csnp95dz2r8ss		select file#, block# from recy...
5	5	0.84	0k8522rmdzg4k		select privilege# from sysauth...
5	5	0.84	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...

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

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

07sf7mbmdm8v9 DELETE FROM ACCT_ITEM WHERE ACCT_BOOK_ID = :ACCT_BOOK_ID AND BILLING_CYCLE_ID = 18

08wftvygkvwxr select /*+ all_rows */ count(1) from "CCDRPRD"."PAYMENT_SETT_ITEM" where "ACCT_ITEM_ID" = :1

0dt31u12uau0k SELECT COUNT(DISTINCT ACCT_ID) COUNTS FROM ACCT_ITEM_IMM@LINK_RB WHERE STATE = 'B' AND BILLING_CYCLE_ID=18

0j6d9y40st3k1 select client_name, status from DBA_AUTOTASK_CLIENT where lower(client_name) = 'sql tuning advisor'

0jqgub0ftgk7n update CC_MDB_SEQUENCE set START_NUMBER=:START_NUMBER, END_NUMBER=:END_NUMBER, CUR_NUMBER=:CUR_NUMBER, STEP_NUMBER=:STEP_NUMBER where upper(SEQ_NAME)=upper(:name) and upper(DSN_NAME)=upper(:dsn_name) and LOCAL_IP=:local_ip

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

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

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)

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

0wy2cjyd5caz2 select count(1) COUNTS from cc_MDB_CHANGE_NOTIF A, (select nvl(max(update_time), TO_DATE('19700102000000', 'YYYYMMDDHH24MISS')) max_update_time from cc_MDB_CHANGE_NOTIF) B where B.max_update_time >= (sysdate - :P_DELAY_TIME/(24*3600))

12z80nvnjx3ma select source_id, source_name from tip_interface_source where state='1' order by source_id

18tjm5bt5w948 SELECT ACCT_BOOK_ID, BAL_ID, ACCT_ID, BILLING_CYCLE_ID, BELONG_ACCT_ID, F_ACCT_BOOK_ID, CHARGE, SETT_CHARGE, ACCT_RES_ID, EXTEND_FIELD1, EXTEND_FIELD2 FROM ACCT_BOOK_TEMP WHERE ACCT_ID = :ACCT_ID AND BILLING_CYCLE_ID = :BILLING_CYCLE_ID AND STATE = 'B'

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

1x7hp5cbvz2un delete from CC_MDB_CHANGE_NOTIF where lower(table_name) = lower(:table_name) and table_sequence <= :table_sequence and update_time < (sysdate - :delay_time/(24*3600))

20vv6ttajyjzq delete from access$ where d_obj#=:1

27q6w0zy3xhh2 select * from (select ASK_NO, ORD_NO, PROCESSINSTANCE_NO, SEQ, MSG_NO, DISPATCH_NO, ACTIVITY_NO, ACTIVITYINSTANCE_INSTALL, ACTIVITYINSTANCE_ID, WORKITEM_NO, SHEET_NO, ACTIVITY_TYPE, STAFF_JOB_ID, SITE_NO, STAFF_NO, to_char(MSG_OCCUR_DATE, 'yyyy-mm-dd hh24:mi:ss') MSG_OCCUR_DATE, to_char(MSG_OPER_DATE, 'yyyy-mm-dd hh24:mi:ss') MSG_OPER_DATE, MSG_FLAG, MSG_CALL_COUNT, ORD_PRIO, CUSTOM_REASON, NOTES, RET_CODE, to_char(RET_DATE, 'yyyy-mm-dd hh24:mi:ss') RET_DATE, ORD_TYPE, ORD_ID, STAFF_NAME, OTHER_PARAMETER, WORKORDER_NO, ERROR_CODE, COST from tom_msg where msg_flag = '0' order by ord_prio desc, msg_occur_date) where rownum <= 100

2h0gb24h6zpnu insert into access$(d_obj#, order#, columns, types) values (:1, :2, :3, :4)

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

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

3wr0rz6hquxg6 INSERT INTO ACCT_BOOK (ACCT_BOOK_ID, ACCT_ID, ACCT_RES_ID, ACCT_BOOK_TYPE, CREATED_DATE, PRE_BALANCE, CHARGE, BILL_ID, BAL_ID, PARTY_TYPE) SELECT :ACCT_BOOK_ID_SEQ, C.AI, C.ASI, 'I', SYSDATE, C.PC, -1*C.CG, C.BI, C.BL, C.PT FROM ( SELECT B.ACCT_ID AI, B.ACCT_RES_ID ASI, A.PRE_BALANCE+A.CHARGE PC, B.CHARGE CG, B.BILL_ID BI, B.BAL_ID BL, B.PARTY_TYPE PT FROM ACCT_BOOK A, ACCT_BOOK B WHERE B.ACCT_BOOK_ID=:ACCT_BOOK_ID AND A.ACCT_BOOK_ID>=B.ACCT_BOOK_ID AND A.ACCT_ID=B.ACCT_ID AND A.BAL_ID=B.BAL_ID ORDER BY A.ACCT_BOOK_ID DESC ) C WHERE ROWNUM=1

56rb8z2j522d3 update TT_MDB_SEQUENCE set START_NUMBER=:START_NUMBER, END_NUMBER=:END_NUMBER, CUR_NUMBER=:CUR_NUMBER, STEP_NUMBER=:STEP_NUMBER where upper(SEQ_NAME)=upper(:name) and upper(DSN_NAME)=upper(:dsn_name) and LOCAL_IP=:local_ip

5qas8kt4w9svy select * from tom_msg where rownum <1

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

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

73629tmfbjzrh DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.COLLECT_CONFIG_METRICS('ORACLE_OCM_CONFIG_DIR'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

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

7qx7y9h2rkt9g SELECT ddf.file_name file_name, vdf.status status, ddf.tablespace_name tablespace_name, '', ddf.autoextensible autoextensible, ddf.increment_by increment_by, ddf.maxbytes max_file_size, vdf.create_bytes, 'NA' os_storage FROM sys.dba_data_files ddf, v$datafile vdf /*+ all_rows use_concat */ WHERE (ddf.file_name = vdf.name) UNION ALL SELECT dtf.file_name file_name, vtf.status status, dtf.tablespace_name tablespace_name, '', dtf.autoextensible autoextensible, dtf.increment_by increment_by, dtf.maxbytes max_file_size, vtf.create_bytes, 'NA' os_storage FROM sys.dba_temp_files dtf, v$tempfile vtf WHERE (dtf.file_id = vtf.file#)

8410zusksmy1j SELECT * FROM (SELECT a.interface_id, a.source_id, a.interface_type, b.prov_level, a.task_no, ord_no, a.oper_state, a.oper_code, a.city_no, a.area_id, prod_spec_id, a.subs_event_id, a.workorder_type, a.install_flag, a.except_flag, a.subs_id, a.new_acc_nbr, a.old_acc_nbr, '0' send_flag, 'threadpool_limit_UIP' thread_poolname, a.notes result_msg, a.subs_event_id serv_no, a.except_flag excep_flag, a.task_no sheet_no, a.task_no WORKORDER_NO, a.prod_spec_id prod_no, a.workorder_type action_no, a.workorder_type task_type, a.new_acc_nbr new_num, a.old_acc_nbr old_num, a.other_parameter FROM tip_interface_data a, tip_user_level b WHERE a.provision_level = b.user_level(+) AND b.state = '1' AND EXISTS (SELECT 1 FROM tip_interface_wait_data c WHERE a.interface_id = c.interface_id AND c.exp_date < SYSDATE AND a.oper_state < 0) and a.ord_no !='2010012000406943' AND b.prov_level = :1 ORDER BY interface_id)WHERE ROWNUM < :2

8f9tksujz3fac update tom_msg set msg_flag = decode( sign(MSG_CALL_COUNT - 10), -1, :1 , 0, :2 , 1, :3 ), MSG_OPER_DATE = sysdate , notes = '???????????????' where msg_flag = :4

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#

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

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

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

cd9kh7jfykwdu SELECT COUNT(*) FROM "ACCT_ITEM" "A1" WHERE "A1"."BILLING_CYCLE_ID"=18

cp46kh2um54f5 select section from tfm_serv_ext where service_name='uip_manager_limit'

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

f173ympfbb2cy select * from (select distinct filter_type, decode(filter_type, '=', '0', 'between', '0', '!=', '1', '1') filter_type_sign from TIP_INTERFACE_DATA_FILTER where exp_date>=sysdate and source_id=:1 ) order by filter_type_sign

fcfsr8zffddms select section from tfm_serv_ext where service_name='uip_manager_nolimit'

gpy4xf1g906kp SELECT * FROM (SELECT a.interface_id, a.source_id, a.interface_type, b.prov_level, a.task_no, ord_no, a.oper_state, a.oper_code, a.city_no, a.area_id, prod_spec_id, a.subs_event_id, a.workorder_type, a.install_flag, a.except_flag, a.subs_id, a.new_acc_nbr, a.old_acc_nbr, '0' send_flag, DECODE (a.oper_state, '0', 'threadpool_nolimit_UIP', 'threadpool_limit_UIP') thread_poolname, a.notes result_msg, a.subs_event_id serv_no, a.except_flag excep_flag, a.task_no sheet_no, a.task_no WORKORDER_NO, a.prod_spec_id prod_no, a.workorder_type action_no, a.workorder_type task_type, a.new_acc_nbr new_num, a.old_acc_nbr old_num, a.other_parameter FROM tip_interface_data a, tip_user_level b WHERE a.provision_level = b.user_level(+) AND b.state = '1' AND a.oper_state IN (0, 5) and a.ord_no !='2010012000406943' AND b.prov_level = :1 ORDER BY interface_id) WHERE ROWNUM < :2

SQL Id	SQL Text
07sf7mbmdm8v9	DELETE FROM ACCT_ITEM WHERE ACCT_BOOK_ID = :ACCT_BOOK_ID AND BILLING_CYCLE_ID = 18
08wftvygkvwxr	select /+ all_rows / count(1) from "CCDRPRD"."PAYMENT_SETT_ITEM" where "ACCT_ITEM_ID" = :1
0dt31u12uau0k	SELECT COUNT(DISTINCT ACCT_ID) COUNTS FROM ACCT_ITEM_IMM@LINK_RB WHERE STATE = 'B' AND BILLING_CYCLE_ID=18
0j6d9y40st3k1	select client_name, status from DBA_AUTOTASK_CLIENT where lower(client_name) = 'sql tuning advisor'
0jqgub0ftgk7n	update CC_MDB_SEQUENCE set START_NUMBER=:START_NUMBER, END_NUMBER=:END_NUMBER, CUR_NUMBER=:CUR_NUMBER, STEP_NUMBER=:STEP_NUMBER where upper(SEQ_NAME)=upper(:name) and upper(DSN_NAME)=upper(:dsn_name) and LOCAL_IP=:local_ip
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0kkhhb2w93cx0	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
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)
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0wy2cjyd5caz2	select count(1) COUNTS from cc_MDB_CHANGE_NOTIF A, (select nvl(max(update_time), TO_DATE('19700102000000', 'YYYYMMDDHH24MISS')) max_update_time from cc_MDB_CHANGE_NOTIF) B where B.max_update_time >= (sysdate - :P_DELAY_TIME/(24*3600))
12z80nvnjx3ma	select source_id, source_name from tip_interface_source where state='1' order by source_id
18tjm5bt5w948	SELECT ACCT_BOOK_ID, BAL_ID, ACCT_ID, BILLING_CYCLE_ID, BELONG_ACCT_ID, F_ACCT_BOOK_ID, CHARGE, SETT_CHARGE, ACCT_RES_ID, EXTEND_FIELD1, EXTEND_FIELD2 FROM ACCT_BOOK_TEMP WHERE ACCT_ID = :ACCT_ID AND BILLING_CYCLE_ID = :BILLING_CYCLE_ID AND STATE = 'B'
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
1x7hp5cbvz2un	delete from CC_MDB_CHANGE_NOTIF where lower(table_name) = lower(:table_name) and table_sequence <= :table_sequence and update_time < (sysdate - :delay_time/(24*3600))
20vv6ttajyjzq	delete from access$ where d_obj#=:1
27q6w0zy3xhh2	select * from (select ASK_NO, ORD_NO, PROCESSINSTANCE_NO, SEQ, MSG_NO, DISPATCH_NO, ACTIVITY_NO, ACTIVITYINSTANCE_INSTALL, ACTIVITYINSTANCE_ID, WORKITEM_NO, SHEET_NO, ACTIVITY_TYPE, STAFF_JOB_ID, SITE_NO, STAFF_NO, to_char(MSG_OCCUR_DATE, 'yyyy-mm-dd hh24:mi:ss') MSG_OCCUR_DATE, to_char(MSG_OPER_DATE, 'yyyy-mm-dd hh24:mi:ss') MSG_OPER_DATE, MSG_FLAG, MSG_CALL_COUNT, ORD_PRIO, CUSTOM_REASON, NOTES, RET_CODE, to_char(RET_DATE, 'yyyy-mm-dd hh24:mi:ss') RET_DATE, ORD_TYPE, ORD_ID, STAFF_NAME, OTHER_PARAMETER, WORKORDER_NO, ERROR_CODE, COST from tom_msg where msg_flag = '0' order by ord_prio desc, msg_occur_date) where rownum <= 100
2h0gb24h6zpnu	insert into access$(d_obj#, order#, columns, types) values (:1, :2, :3, :4)
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
3wr0rz6hquxg6	INSERT INTO ACCT_BOOK (ACCT_BOOK_ID, ACCT_ID, ACCT_RES_ID, ACCT_BOOK_TYPE, CREATED_DATE, PRE_BALANCE, CHARGE, BILL_ID, BAL_ID, PARTY_TYPE) SELECT :ACCT_BOOK_ID_SEQ, C.AI, C.ASI, 'I', SYSDATE, C.PC, -1*C.CG, C.BI, C.BL, C.PT FROM ( SELECT B.ACCT_ID AI, B.ACCT_RES_ID ASI, A.PRE_BALANCE+A.CHARGE PC, B.CHARGE CG, B.BILL_ID BI, B.BAL_ID BL, B.PARTY_TYPE PT FROM ACCT_BOOK A, ACCT_BOOK B WHERE B.ACCT_BOOK_ID=:ACCT_BOOK_ID AND A.ACCT_BOOK_ID>=B.ACCT_BOOK_ID AND A.ACCT_ID=B.ACCT_ID AND A.BAL_ID=B.BAL_ID ORDER BY A.ACCT_BOOK_ID DESC ) C WHERE ROWNUM=1
56rb8z2j522d3	update TT_MDB_SEQUENCE set START_NUMBER=:START_NUMBER, END_NUMBER=:END_NUMBER, CUR_NUMBER=:CUR_NUMBER, STEP_NUMBER=:STEP_NUMBER where upper(SEQ_NAME)=upper(:name) and upper(DSN_NAME)=upper(:dsn_name) and LOCAL_IP=:local_ip
5qas8kt4w9svy	select * from tom_msg where rownum <1
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
73629tmfbjzrh	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.COLLECT_CONFIG_METRICS('ORACLE_OCM_CONFIG_DIR'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
772s25v1y0x8k	select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7qx7y9h2rkt9g	SELECT ddf.file_name file_name, vdf.status status, ddf.tablespace_name tablespace_name, '', ddf.autoextensible autoextensible, ddf.increment_by increment_by, ddf.maxbytes max_file_size, vdf.create_bytes, 'NA' os_storage FROM sys.dba_data_files ddf, v$datafile vdf /+ all_rows use_concat / WHERE (ddf.file_name = vdf.name) UNION ALL SELECT dtf.file_name file_name, vtf.status status, dtf.tablespace_name tablespace_name, '', dtf.autoextensible autoextensible, dtf.increment_by increment_by, dtf.maxbytes max_file_size, vtf.create_bytes, 'NA' os_storage FROM sys.dba_temp_files dtf, v$tempfile vtf WHERE (dtf.file_id = vtf.file#)
8410zusksmy1j	SELECT * FROM (SELECT a.interface_id, a.source_id, a.interface_type, b.prov_level, a.task_no, ord_no, a.oper_state, a.oper_code, a.city_no, a.area_id, prod_spec_id, a.subs_event_id, a.workorder_type, a.install_flag, a.except_flag, a.subs_id, a.new_acc_nbr, a.old_acc_nbr, '0' send_flag, 'threadpool_limit_UIP' thread_poolname, a.notes result_msg, a.subs_event_id serv_no, a.except_flag excep_flag, a.task_no sheet_no, a.task_no WORKORDER_NO, a.prod_spec_id prod_no, a.workorder_type action_no, a.workorder_type task_type, a.new_acc_nbr new_num, a.old_acc_nbr old_num, a.other_parameter FROM tip_interface_data a, tip_user_level b WHERE a.provision_level = b.user_level(+) AND b.state = '1' AND EXISTS (SELECT 1 FROM tip_interface_wait_data c WHERE a.interface_id = c.interface_id AND c.exp_date < SYSDATE AND a.oper_state < 0) and a.ord_no !='2010012000406943' AND b.prov_level = :1 ORDER BY interface_id)WHERE ROWNUM < :2
8f9tksujz3fac	update tom_msg set msg_flag = decode( sign(MSG_CALL_COUNT - 10), -1, :1 , 0, :2 , 1, :3 ), MSG_OPER_DATE = sysdate , notes = '???????????????' where msg_flag = :4
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#
b4qw7n9wg64mh	INSERT /+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_mo del , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /+ PARAM('_module_action_old_length', 0) /:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_s ession_serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.d elta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
bsa0wjtftg3uw	select file# from file$ where ts#=:1
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
cd9kh7jfykwdu	SELECT COUNT(*) FROM "ACCT_ITEM" "A1" WHERE "A1"."BILLING_CYCLE_ID"=18
cp46kh2um54f5	select section from tfm_serv_ext where service_name='uip_manager_limit'
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
f173ympfbb2cy	select * from (select distinct filter_type, decode(filter_type, '=', '0', 'between', '0', '!=', '1', '1') filter_type_sign from TIP_INTERFACE_DATA_FILTER where exp_date>=sysdate and source_id=:1 ) order by filter_type_sign
fcfsr8zffddms	select section from tfm_serv_ext where service_name='uip_manager_nolimit'
gpy4xf1g906kp	SELECT * FROM (SELECT a.interface_id, a.source_id, a.interface_type, b.prov_level, a.task_no, ord_no, a.oper_state, a.oper_code, a.city_no, a.area_id, prod_spec_id, a.subs_event_id, a.workorder_type, a.install_flag, a.except_flag, a.subs_id, a.new_acc_nbr, a.old_acc_nbr, '0' send_flag, DECODE (a.oper_state, '0', 'threadpool_nolimit_UIP', 'threadpool_limit_UIP') thread_poolname, a.notes result_msg, a.subs_event_id serv_no, a.except_flag excep_flag, a.task_no sheet_no, a.task_no WORKORDER_NO, a.prod_spec_id prod_no, a.workorder_type action_no, a.workorder_type task_type, a.new_acc_nbr new_num, a.old_acc_nbr old_num, a.other_parameter FROM tip_interface_data a, tip_user_level b WHERE a.provision_level = b.user_level(+) AND b.state = '1' AND a.oper_state IN (0, 5) and a.ord_no !='2010012000406943' AND b.prov_level = :1 ORDER BY interface_id) WHERE ROWNUM < :2

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	4	0.00	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	170,933	47.44	7.87
CPU used when call started	170,255	47.25	7.84
CR blocks created	256	0.07	0.01
Cached Commit SCN referenced	916,501	254.36	42.21
Commit SCN cached	8	0.00	0.00
DB time	175,027	48.58	8.06
DBWR checkpoint buffers written	2,072	0.58	0.10
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR transaction table writes	114	0.03	0.01
DBWR undo block writes	875	0.24	0.04
DFO trees parallelized	0	0.00	0.00
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	27,105	7.52	1.25
Heap Segment Array Inserts	1,066	0.30	0.05
Heap Segment Array Updates	21,469	5.96	0.99
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	127	0.04	0.01
IMU Redo allocation size	553,048	153.49	25.47
IMU commits	21,585	5.99	0.99
IMU contention	0	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	33,235,728	9,224.19	1,530.75
IMU- failed to get a private strand	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
Requests to/from client	204,524	56.76	9.42
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 recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	204,526	56.76	9.42
SQL*Net roundtrips to/from dblink	17	0.00	0.00
active txn count during cleanout	318	0.09	0.01
application wait time	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	20,731	5.75	0.95
branch node splits	0	0.00	0.00
buffer is not pinned count	685,565,277	190,270.69	31,575.41
buffer is pinned count	227,891,564	63,248.66	10,496.11
bytes received via SQL*Net from client	23,285,179	6,462.53	1,072.46
bytes received via SQL*Net from dblink	10,606	2.94	0.49
bytes sent via SQL*Net to client	29,581,769	8,210.08	1,362.46
bytes sent via SQL*Net to dblink	5,384	1.49	0.25
calls to get snapshot scn: kcmgss	196,254	54.47	9.04
calls to kcmgas	33,620	9.33	1.55
calls to kcmgcs	58,470	16.23	2.69
cell physical IO interconnect bytes	178,150,400	49,443.58	8,205.16
change write time	72	0.02	0.00
cleanout - number of ktugct calls	335	0.09	0.02
cleanouts and rollbacks - consistent read gets	255	0.07	0.01
cleanouts only - consistent read gets	20	0.01	0.00
cluster key scan block gets	84	0.02	0.00
cluster key scans	65	0.02	0.00
commit batch performed	1	0.00	0.00
commit batch requested	1	0.00	0.00
commit batch/immediate performed	3	0.00	0.00
commit batch/immediate requested	3	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	6	0.00	0.00
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	24,673	6.85	1.14
commit cleanouts successfully completed	24,667	6.85	1.14
commit immediate performed	2	0.00	0.00
commit immediate requested	2	0.00	0.00
commit txn count during cleanout	55	0.02	0.00
concurrency wait time	49	0.01	0.00
consistent changes	3,836	1.06	0.18
consistent gets	1,316,328,503	365,331.71	60,626.77
consistent gets - examination	57,079,829	15,841.84	2,628.95
consistent gets direct	0	0.00	0.00
consistent gets from cache	1,316,328,526	365,331.71	60,626.77
consistent gets from cache (fastpath)	1,259,193,245	349,474.48	57,995.27
cursor authentications	6	0.00	0.00
data blocks consistent reads - undo records applied	3,825	1.06	0.18
db block changes	108,824	30.20	5.01
db block gets	114,725	31.84	5.28
db block gets direct	9	0.00	0.00
db block gets from cache	114,716	31.84	5.28
db block gets from cache (fastpath)	8,402	2.33	0.39
deferred (CURRENT) block cleanout applications	8,191	2.27	0.38
enqueue conversions	4,171	1.16	0.19
enqueue releases	68,543	19.02	3.16
enqueue requests	68,559	19.03	3.16
enqueue timeouts	1	0.00	0.00
enqueue waits	0	0.00	0.00
execute count	168,819	46.85	7.78
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	1,001,332	277.91	46.12
free buffer inspected	0	0.00	0.00
free buffer requested	13,412	3.72	0.62
heap block compress	313	0.09	0.01
immediate (CR) block cleanout applications	275	0.08	0.01
immediate (CURRENT) block cleanout applications	1,235	0.34	0.06
in call idle wait time	7,875,005	2,185.62	362.70
index crx upgrade (positioned)	0	0.00	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	1,398	0.39	0.06
index fetch by key	2,194	0.61	0.10
index scans kdiixs1	684,572,909	189,995.27	31,529.70
leaf node 90-10 splits	25	0.01	0.00
leaf node splits	30	0.01	0.00
lob reads	0	0.00	0.00
lob writes	1	0.00	0.00
lob writes unaligned	1	0.00	0.00
logical read bytes from cache	10,784,303,702,016	2,993,058,404.35	496,697,849.21
logons cumulative	29	0.01	0.00
max cf enq hold time	0	0.00	0.00
messages received	23,366	6.48	1.08
messages sent	23,366	6.48	1.08
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	321,152	89.13	14.79
no work - consistent read gets	1,259,156,828	349,464.37	57,993.59
non-idle wait count	277,675	77.07	12.79
non-idle wait time	5,722	1.59	0.26
opened cursors cumulative	3,498	0.97	0.16
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	20	0.01	0.00
parse count (total)	595	0.17	0.03
parse time cpu	8	0.00	0.00
parse time elapsed	23	0.01	0.00
physical read IO requests	0	0.00	0.00
physical read bytes	0	0.00	0.00
physical read total IO requests	2,778	0.77	0.13
physical read total bytes	45,391,872	12,597.99	2,090.64
physical read total multi block requests	0	0.00	0.00
physical reads	0	0.00	0.00
physical reads cache	0	0.00	0.00
physical reads cache prefetch	0	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	1,192	0.33	0.05
physical write bytes	17,047,552	4,731.35	785.17
physical write total IO requests	48,669	13.51	2.24
physical write total bytes	132,758,528	36,845.59	6,114.52
physical write total multi block requests	43	0.01	0.00
physical writes	2,081	0.58	0.10
physical writes direct	9	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	2,072	0.58	0.10
physical writes non checkpoint	841	0.23	0.04
pinned cursors current	1	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
process last non-idle time	2,397	0.67	0.11
queries parallelized	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	67,149	18.64	3.09
recursive cpu usage	2,410	0.67	0.11
redo blocks checksummed by FG (exclusive)	2,996	0.83	0.14
redo blocks written	51,607	14.32	2.38
redo buffer allocation retries	0	0.00	0.00
redo entries	33,123	9.19	1.53
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	12	0.00	0.00
redo size	17,462,732	4,846.58	804.29
redo size for direct writes	96	0.03	0.00
redo subscn max counts	423	0.12	0.02
redo synch long waits	62	0.02	0.00
redo synch time	3,002	0.83	0.14
redo synch time (usec)	30,036,214	8,336.20	1,383.39
redo synch writes	21,716	6.03	1.00
redo wastage	8,143,244	2,260.06	375.06
redo write time	2,017	0.56	0.09
redo writes	21,814	6.05	1.00
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	1	0.00	0.00
root node splits	0	0.00	0.00
rows fetched via callback	583	0.16	0.03
session connect time	0	0.00	0.00
session cursor cache hits	7,333	2.04	0.34
session logical reads	1,316,441,983	365,363.20	60,632.00
shared hash latch upgrades - no wait	43,070	11.95	1.98
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	89,494	24.84	4.12
sorts (rows)	21,002	5.83	0.97
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
switch current to new buffer	12,287	3.41	0.57
table fetch by rowid	114,422,433	31,756.62	5,270.01
table fetch continued row	0	0.00	0.00
table scan blocks gotten	1,250,893	347.17	57.61
table scan rows gotten	108,297,412	30,056.69	4,987.91
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	12,133	3.37	0.56
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	140	0.04	0.01
total number of cf enq holders	20	0.01	0.00
total number of times SMON posted	7	0.00	0.00
transaction rollbacks	1	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	6,043,436	1,677.29	278.35
user I/O wait time	22	0.01	0.00
user calls	205,252	56.97	9.45
user commits	21,712	6.03	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	2,124	0.59	0.10
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
logons current	78	85
session uga memory max	9,341,998,464	9,375,068,264
session pga memory	208,750,800	220,661,152
session pga memory max	407,718,096	429,196,704
session cursor cache count	56,594	56,936
session uga memory	232,288,749,496	245,176,789,568
opened cursors current	308	315
workarea memory allocated	407	407

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

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	44M	0.77	.012211	60M	1.07	.016652	4057	0.78
LGWR	0M	0.00	0M	50M	12.11	.013876	21.8K	0.39
DBWR	0M	0.00	0M	16M	0.33	.004440	0
TOTAL:	44M	0.77	.012211	126M	13.51	.034969	25.9K	0.45

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read
Control File	44M	0.77	.012211	60M	1.06	.016652	0.30
Log File	0M	0.00	0M	50M	12.11	.013876
Data File	0M	0.00	0M	15M	0.33	.004163	7.27
TOTAL:	44M	0.77	.012211	125M	13.51	.034692	0.34

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	43M	0.77	.011934	60M	1.07	.016652	2778	0.34
Others (Control File)	43M	0.77	.011934	60M	1.06	.016652	2763	0.30
Others (Data File)	0M	0.00	0M	0M	0.00	0M	15	7.27
LGWR	0M	0.00	0M	50M	12.11	.013876	0
LGWR (Log File)	0M	0.00	0M	50M	12.11	.013876	0
DBWR	0M	0.00	0M	16M	0.33	.004440	0
DBWR (Data File)	0M	0.00	0M	16M	0.33	.004440	0
TOTAL:	43M	0.77	.011934	126M	13.51	.034969	2778	0.34

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	0	0	0.00	0.00	304	0	0	0.00
TAB_CC	0	0	0.00	0.00	289	0	0	0.00
UNDO01	0	0	0.00	0.00	248	0	0	0.00
TAB_MDB	0	0	0.00	0.00	199	0	0	0.00
IDX_CC	0	0	0.00	0.00	119	0	0	0.00
SYSTEM	0	0	0.00	0.00	19	0	0	0.00
TAB_DEF	0	0	0.00	0.00	12	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Writes
IDX_CC	/tccdata03/oradata/SHCCIOT/idx_cc01.dbf	45
IDX_CC	/tccdata03/oradata/SHCCIOT/idx_cc02.dbf	74
SYSAUX	/tccdata02/oradata/SHCCIOT/sysaux01.dbf	304
SYSTEM	/tccdata02/oradata/SHCCIOT/system01.dbf	19
TAB_CC	/tccdata03/oradata/SHCCIOT/tab_cc01.dbf	29
TAB_CC	/tccdata03/oradata/SHCCIOT/tab_cc02.dbf	26
TAB_CC	/tccdata03/oradata/SHCCIOT/tab_cc03.dbf	65
TAB_CC	/tccdata03/oradata/SHCCIOT/tab_cc04.dbf	108
TAB_CC	/tccdata03/oradata/SHCCIOT/tab_cc05.dbf	61
TAB_DEF	/tccdata03/oradata/SHCCIOT/tab_def01.dbf	12
TAB_MDB	/tccdata03/oradata/SHCCIOT/tab_mdb01.dbf	111
TAB_MDB	/tccdata03/oradata/SHCCIOT/tab_mdb02.dbf	88
UNDO01	/tccdata02/oradata/SHCCIOT/undo01_01.dbf	248

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	3,929,718	100	1,316,398,279	0	2,072	0	0	0

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 2,081

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	2,072	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	11	269	4498	21725	5945400	21725
E	0	11	450	5585	28272	5945400	28272

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	3,072	0.10	379	1.15	2,226	1	1954.00
D	6,144	0.19	758	1.06	2,061	1	1721.00
D	9,216	0.29	1,136	1.01	1,953	1	1570.00
D	12,288	0.39	1,515	1.00	1,943	1	1556.00
D	15,360	0.48	1,894	1.00	1,943	1	1555.00
D	18,432	0.58	2,273	1.00	1,943	1	1555.00
D	21,504	0.67	2,651	1.00	1,943	1	1555.00
D	24,576	0.77	3,030	1.00	1,943	1	1555.00
D	27,648	0.87	3,409	1.00	1,943	1	1555.00
D	30,720	0.96	3,788	1.00	1,943	1	1555.00
D	31,872	1.00	3,930	1.00	1,943	1	1555.00
D	33,792	1.06	4,166	1.00	1,943	1	1555.00
D	36,864	1.16	4,545	1.00	1,943	1	1555.00
D	39,936	1.25	4,924	1.00	1,943	1	1555.00
D	43,008	1.35	5,303	1.00	1,943	1	1555.00
D	46,080	1.45	5,682	1.00	1,943	1	1555.00
D	49,152	1.54	6,060	1.00	1,943	1	1555.00
D	52,224	1.64	6,439	1.00	1,943	1	1555.00
D	55,296	1.73	6,818	1.00	1,943	1	1555.00
D	58,368	1.83	7,197	1.00	1,943	1	1555.00
D	61,440	1.93	7,575	0.97	1,882	1	1470.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	133	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	4,096	3,595	149.22	0.40	0.27	100.00	0.00	419,430
E	4,096	3,590	158.88	0.40	0.25	100.00	0.00	419,430

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	1,969	1,969
64K	128K	6	6
256K	512K	2	2
512K	1024K	144	144
1M	2M	1	1
4M	8M	2	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd Time
512	0.13	158,285.73	1,310.63	99.00	2,510,130
1,024	0.25	158,285.73	557.83	100.00	2,498,290
2,048	0.50	158,285.73	0.00	100.00	2,489,516
3,072	0.75	158,285.73	0.00	100.00	2,489,516
4,096	1.00	158,285.73	0.00	100.00	2,489,516
4,915	1.20	158,285.73	0.00	100.00	2,489,516
5,734	1.40	158,285.73	0.00	100.00	2,489,516
6,554	1.60	158,285.73	0.00	100.00	2,489,516
7,373	1.80	158,285.73	0.00	100.00	2,489,516
8,192	2.00	158,285.73	0.00	100.00	2,489,516
12,288	3.00	158,285.73	0.00	100.00	2,489,516
16,384	4.00	158,285.73	0.00	100.00	2,489,516
24,576	6.00	158,285.73	0.00	100.00	2,489,516
32,768	8.00	158,285.73	0.00	100.00	2,489,516

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
3,584	0.70	26	35,748	385,837	0.93	28,325	123.69	12,429
3,840	0.75	281	43,852	413,141	1.00	1,021	4.46	20,421
3,968	0.78	409	51,719	413,857	1.00	305	1.33	20,615
4,096	0.80	536	60,738	413,863	1.00	299	1.31	20,618
4,224	0.83	663	69,757	413,869	1.00	293	1.28	20,622
4,352	0.85	790	78,776	413,875	1.00	287	1.25	20,626
4,480	0.88	917	87,795	413,882	1.00	280	1.22	20,630
4,608	0.90	1,044	96,814	413,888	1.00	274	1.20	20,634
4,736	0.93	1,171	105,833	413,898	1.00	264	1.15	20,638
4,864	0.95	1,298	114,852	413,905	1.00	257	1.12	20,645
4,992	0.98	1,425	123,871	413,915	1.00	247	1.08	20,649
5,120	1.00	1,552	132,890	413,933	1.00	229	1.00	20,661
5,248	1.03	1,679	141,909	413,934	1.00	228	1.00	20,661
5,376	1.05	1,807	149,648	413,934	1.00	228	1.00	20,661
5,504	1.08	1,886	151,957	413,934	1.00	228	1.00	20,661
5,632	1.10	1,886	151,957	413,934	1.00	228	1.00	20,661
5,760	1.13	1,886	151,957	413,934	1.00	228	1.00	20,661
5,888	1.15	1,886	151,957	413,934	1.00	228	1.00	20,661
6,016	1.18	1,886	151,957	413,934	1.00	228	1.00	20,661
6,144	1.20	1,886	151,957	413,934	1.00	228	1.00	20,661
6,272	1.23	1,886	151,957	413,934	1.00	228	1.00	20,661
6,656	1.30	1,886	151,957	413,934	1.00	228	1.00	20,661
7,168	1.40	1,886	151,957	413,934	1.00	228	1.00	20,661
7,680	1.50	1,886	151,957	413,934	1.00	228	1.00	20,661
8,192	1.60	1,886	151,957	413,934	1.00	228	1.00	20,661
8,704	1.70	1,886	151,957	413,934	1.00	228	1.00	20,661
9,216	1.80	1,886	151,957	413,934	1.00	228	1.00	20,661
9,728	1.90	1,886	151,957	413,934	1.00	228	1.00	20,661
10,240	2.00	1,886	151,957	413,934	1.00	228	1.00	20,661

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
9,696	0.25	110,345	2,225,634
14,544	0.38	110,015	1,953,064
19,392	0.50	109,949	1,943,156
24,240	0.63	109,949	1,942,767
29,088	0.75	109,949	1,942,767
33,936	0.88	109,949	1,942,767
38,784	1.00	109,949	1,942,767
43,632	1.13	109,949	1,942,767
48,480	1.25	109,949	1,942,767
53,328	1.38	109,949	1,942,767
58,176	1.50	109,949	1,942,767
63,024	1.63	109,949	1,942,767
67,872	1.75	109,861	1,882,153
72,720	1.88	109,861	1,882,153
77,568	2.00	109,861	1,882,153

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)
128	0.25	0	0	0	0
256	0.50	0	0	0	0
384	0.75	0	0	0	0
512	1.00	0	0	0	0
640	1.25	0	0	0	0
768	1.50	0	0	0	0
896	1.75	0	0	0	0
1,024	2.00	0	0	0	0
1,152	2.25	0	0	0	0
1,280	2.50	0	0	0	0
1,408	2.75	0	0	0	0
1,536	3.00	0	0	0	0
1,664	3.25	0	0	0	0
1,792	3.50	0	0	0	0
1,920	3.75	0	0	0	0
2,048	4.00	0	0	0	0
2,176	4.25	0	0	0	0
2,304	4.50	0	0	0	0
2,432	4.75	0	0	0	0
2,560	5.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

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	0.80	21,928	2,561	3	45089.9/48698.2	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
04-Jun 21:59	136	3,685	426	3	48,698	0/0	0/0/0/0/0/0
04-Jun 21:49	143	3,709	1,028	3	47,907	0/0	0/0/0/0/0/0
04-Jun 21:39	152	3,646	427	3	47,206	0/0	0/0/0/0/0/0
04-Jun 21:29	92	3,565	1,032	2	46,437	0/0	0/0/0/0/0/0
04-Jun 21:19	95	3,581	2,561	2	45,588	0/0	0/0/0/0/0/0
04-Jun 21:09	177	3,742	1,960	3	45,090	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
ASM db client latch	2,399	0.00		0
ASM map operation hash table	1	0.00		0
ASM network background latch	1	0.00		0
ASM network state latch	58	0.00		0
AWR Alerted Metric Element list	28,590	0.00		0
Change Notification Hash table latch	1,201	0.00		0
Consistent RBA	21,818	0.00		0
DML lock allocation	62,498	0.00		0
Event Group Locks	56	0.00		0
FOB s.o list latch	244	0.00		0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC stats buffer allocation latch	1	0.00		0
In memory undo latch	106,275	0.00		29,530	0.00
JS Sh mem access	7	0.00		0
JS broadcast autostart latch	1	0.00		0
JS mem alloc latch	16	0.00		0
JS queue access latch	17	0.00		0
JS queue state obj latch	10,212	0.00		0
JS slv state obj latch	22	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1	0.00		0
KJCT flow control latch	1	0.00		0
KMG MMAN ready and startup request latch	1,201	0.00		0
KTF sga latch	18	0.00		1,207	0.00
KWQMN job cache list latch	1	0.00		0
KWQP Prop Status	2	0.00		0
KWQS pqueue ctx latch	2	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	1	0.00		1,201	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	40	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	189	0.00		0
OS process allocation	7,299	0.00		0
OS process: request allocation	45	0.00		0
PL/SQL warning settings	32	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	34,213	0.00		0
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	1	0.00		1,199	0.00
SQL memory manager workarea list latch	206,787	0.00		0
Shared B-Tree	135	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	5,994	0.03	0.00	0
active service list	4,066	0.02	0.00	1,796	0.00
begin backup scn array	1	0.00		0
buffer pool	1	0.00		0
business card	1	0.00		0
cache buffer handles	8	0.00		0
cache buffers chains	2,576,041,770	0.00	0.00	1,131	0.00
cache buffers lru chain	26,669	0.00		15,696	0.00
call allocation	164	1.22	1.00	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	50	0.00		0
channel operations parent latch	17,002	0.00		0
checkpoint queue latch	810,700	0.00		2,229	0.00
client/application info	80	0.00		0
compile environment latch	29	0.00		0
corrupted undo seg latch	1	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	58	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	58	0.00		0
dml lock allocation	58	0.00		0
done queue latch	1	0.00		0
dummy allocation	52	0.00		0
enqueue freelist latch	1	0.00		30,614	0.00
enqueue hash chains	141,240	0.01	0.00	0
enqueues	2	0.00		0
fifth spare latch	1	0.00		0
file cache latch	212	0.00		0
flashback copy	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	1	0.00		0
gcs commit scn state	1	0.00		0
gcs partitioned table hash	1	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs resource freelist	1	0.00		0
gcs resource hash	1	0.00		0
gcs resource scan list	1	0.00		0
gcs shadows freelist	1	0.00		0
ges domain table	1	0.00		0
ges enqueue table freelist	1	0.00		0
ges group table	1	0.00		0
ges process hash list	1	0.00		0
ges process parent latch	1	0.00		0
ges resource hash list	1	0.00		0
ges resource scan list	1	0.00		0
ges resource table freelist	1	0.00		0
ges value block free list	1	0.00		0
global KZLD latch for mem in SGA	5	0.00		0
global ctx hash table latch	1	0.00		0
global tx hash mapping	2,909	0.00		0
granule operation	1	0.00		0
hash table column usage latch	54	0.00		129	0.00
hash table modification latch	88	0.00		0
heartbeat check	1	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	5	0.00		3	0.00
job_queue_processes free list latch	12	0.00		0
job_queue_processes parameter latch	369	0.00		0
k2q lock allocation	1	0.00		0
kcfis latch	41	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kgnfs mount latch	1	0.00		0
kokc descriptor allocation latch	4	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	1	0.00		0
kss move lock	33	0.00		0
ksuosstats global area	363	0.00		0
ksv allocation latch	122	0.00		0
ksv class latch	65	0.00		0
ksv msg queue latch	1	0.00		0
ksz_so allocation latch	45	0.00		0
ktm global data	61	0.00		0
kwqbsn:qsga	131	0.00		0
lgwr LWN SCN	22,143	0.00		0
list of block allocation	47	0.00		0
loader state object freelist	2	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	13	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	2	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	9	0.00		0
messages	115,448	0.02	0.00	0
mostly latch-free SCN	22,311	0.33	0.00	0
msg queue latch	1	0.00		0
name-service namespace bucket	1	0.00		0
ncodef allocation latch	58	0.00		0
object queue header heap	48,008	0.00		4	0.00
object queue header operation	67,835	0.00		0
object stats modification	30	0.00		0
parallel query alloc buffer	961	0.00		0
parallel query stats	1	0.00		0
parameter list	28	0.00		0
parameter table management	128	0.00		0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	35,350	0.01	0.00	23,351	0.08
process allocation	66	0.00		26	0.00
process group creation	45	0.00		0
process queue	1	0.00		0
process queue reference	1	0.00		0
qmn task queue latch	783	0.00		0
query server freelists	1	0.00		0
queued dump request	12	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	125,170	0.03	0.00	33,059	0.03
redo copy	1	0.00		33,064	0.14
redo writing	73,965	0.00	0.00	0
resmgr group change latch	299	0.00		0
resmgr:active threads	66	1.52	1.00	20	0.00
resmgr:actses change group	30	0.00		0
resmgr:actses change state	2	0.00		0
resmgr:free threads list	53	1.89	0.00	0
resmgr:method mem alloc latch	16	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	495	0.00		0
resmgr:schema config	376	0.00		1	0.00
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	427,930	0.01	0.00	0
rules engine rule set statistics	100	0.00		0
second Audit Vault latch	1	0.00		0
second spare latch	1	0.00		0
sequence cache	59	0.00		0
session allocation	36,736	0.00		36,693	0.00
session idle bit	447,154	0.01	0.00	0
session queue latch	1	0.00		0
session state list latch	78	0.00		0
session switching	194	0.00		0
session timer	1,201	0.00		0
shared pool	13,381	0.14	0.00	0
shared pool sim alloc	3	0.00		0
shared pool simulator	36	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	250,550	0.00		0
simulator lru latch	1,216	0.00		249,228	0.00
sort extent pool	98	0.00		0
space background state object latch	10	0.00		0
space background task latch	4,447	0.02	0.00	2,408	0.00
state object free list	2	0.00		0
statistics aggregation	336	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	2	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	179	0.00		0
transaction allocation	496	0.00		0
transaction branch allocation	3,900	0.00		0
undo global data	111,301	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
call allocation	164	2	2	0
resmgr:active threads	66	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	NoWait Misses	Sleeps	Waiter Sleeps
call allocation	ksuxds	0	2	1
resmgr:active threads	kgsksysstop	0	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 1,316,441,983
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
CCDRPRD	IDX_CC	IDX_AB_ACCT_BOOK_ID	P5	INDEX PARTITION	171,099,200	13.00
CCDRPRD	IDX_CC	IDX_AB_ACCT_BOOK_ID	P6	INDEX PARTITION	114,579,696	8.70
CCDRPRD	IDX_CC	IDX_AB_ACCT_BOOK_ID	P12	INDEX PARTITION	114,069,376	8.66
CCDRPRD	IDX_CC	IDX_AB_ACCT_BOOK_ID	P1	INDEX PARTITION	114,066,320	8.66
CCDRPRD	IDX_CC	IDX_AB_ACCT_BOOK_ID	P3	INDEX PARTITION	114,066,320	8.66

Back to Segment Statistics
Back to Top

Segments by Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 2,081
Captured Segments account for 22.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
CCDRPRD	TAB_CC	IDX_AI_SUBS_ID	INDEX	127	6.10
CCDRPRD	TAB_CC	ACCT_ITEM	TABLE	33	1.59
CCDRPRD	IDX_CC	IDX_AI_ACCT_ID_STATE	INDEX	23	1.11
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	17	0.82
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX	INDEX	17	0.82

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 1,192
Captured Segments account for 32.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
CCDRPRD	TAB_CC	IDX_AI_SUBS_ID		INDEX	117	9.82
CCDRPRD	TAB_CC	ACCT_ITEM		TABLE	32	2.68
CCDRPRD	IDX_CC	IDX_AI_ACCT_ID_STATE		INDEX	19	1.59
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY		TABLE	17	1.43
CCDRPRD	TAB_CC	ACCT_BOOK	P6	TABLE PARTITION	15	1.26

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 1,398
Captured Segments account for 95.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
CCDRPRD	IDX_CC	PK_PAYMENT_SETT_ITEM		INDEX	1,334	95.42

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
CCDRPRD	TAB_CC	ACCT_ITEM		TABLE	5,440	47.95
CCDRPRD	IDX_CC	PK_ACCT_ITEM		INDEX	1,456	12.83
CCDRPRD	IDX_CC	IDX_AB_ACCT_BOOK_ID	P6	INDEX PARTITION	1,040	9.17
CCDRPRD	TAB_CC	ACCT_BOOK	P6	TABLE PARTITION	992	8.74
CCDRPRD	TAB_CC	ACCT_BOOK_TEMP		TABLE	720	6.35

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	65	0.00	2	1
dc_files	15	0.00	0	15
dc_global_oids	7	0.00	0	222
dc_histogram_data	209	0.00	0	13,804
dc_histogram_defs	8,120	0.00	0	114,114
dc_objects	1,946	0.15	8	51,972
dc_profiles	11	0.00	0	1
dc_rollback_segments	1,130	0.00	0	27
dc_segments	114	0.00	13	8,501
dc_sequences	1	0.00	1	35
dc_tablespaces	63,565	0.00	0	13
dc_users	65,289	0.00	0	11,242
global database name	2,423	0.00	0	2
outstanding_alerts	48	0.00	0	8
sch_lj_objs	1	0.00	0	3
sch_lj_oids	6	16.67	0	17

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
ACCOUNT_STATUS	10	0.00	0		0
APP CONTEXT	1	0.00	2	0.00	0
BODY	34	0.00	39	0.00	0
DBLINK	36	0.00	0		0
DIRECTORY	1	0.00	2	0.00	0
EDITION	19	0.00	26	0.00	0
INDEX	2	0.00	2	0.00	0
OBJECT ID	1	100.00	0		0
SCHEMA	8	0.00	0		0
SQL AREA	514	3.70	169,850	0.04	1
SQL AREA BUILD	20	95.00	0		0
SQL AREA STATS	20	95.00	20	95.00	0
TABLE/PROCEDURE	1,548	0.00	1,688	0.06	1

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	31,872.00	31,872.00	31,872.00	31,872.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	4,096.00	4,096.00	4,096.00	4,096.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	38,784.00	38,784.00	38,784.00	38,784.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	256.00	256.00	256.00	256.00	STA/
large pool	512.00	512.00	512.00	512.00	STA/
shared pool	5,120.00	5,120.00	5,120.00	5,120.00	STA/
streams pool	512.00	512.00	512.00	512.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	118.50		1.52	1.78	12	12	78	78
B	Freeable	28.19	0.00	1.48	2.74	13		19	19
B	SQL	2.01	0.56	0.03	0.06	0	5	64	59
B	PL/SQL	0.55	0.34	0.01	0.02	0	0	78	78
E	Other	127.31		1.50	1.71	12	12	85	85
E	Freeable	28.94	0.00	1.45	2.69	13		20	20
E	SQL	2.06	0.57	0.03	0.06	0	5	69	62
E	PL/SQL	0.60	0.37	0.01	0.02	0	0	85	85

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	33,420,214,272
Fixed Size	2,237,088
Redo Buffers	353,067,008
Variable Size	6,710,889,824

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	PX msg pool	7.81	7.81	0.00
large	free memory	504.19	504.19	0.00
shared	ASH buffers	64.00	64.00	0.00
shared	KGLDA	53.26	53.27	0.02
shared	KGLH0	1,026.86	1,027.33	0.05
shared	KGLHD	245.32	245.36	0.01
shared	KGLS	89.06	89.06	0.00
shared	KQR L PO	61.72	61.72	0.00
shared	KQR M PO	70.90	70.90	0.00
shared	SQLA	624.66	624.98	0.05
shared	SQLP	497.91	497.91	0.00
shared	db_block_hash_buckets	178.00	178.00	0.00
shared	free memory	1,860.36	1,858.90	-0.08
streams	free memory	511.94	511.94	0.00
	buffer_cache	31,872.00	31,872.00	0.00
	fixed_sga	2.13	2.13	0.00
	log_buffer	336.71	336.71	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0528 01:29:50	0.06	0.00	0.00
QMON Coordinator	0528 01:29:40	0.06	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

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

Shared Servers Activity

Values represent averages for all samples

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/tccdata01/app/oracle/admin/SHCCIOT/adump
audit_trail	DB
compatible	11.2.0.0.0
control_file_record_keep_time	14
control_files	/tccdata02/oradata/SHCCIOT/control01.ctl, /tccdata02/oradata/SHCCIOT/control02.ctl, /tccdata02/oradata/SHCCIOT/control03.ctl
db_block_size	8192
db_cache_size	6442450944
db_domain
db_name	SHCCIOT
diagnostic_dest	/tccdata01/app/oracle
filesystemio_options	SETALL
java_pool_size	268435456
large_pool_size	536870912
log_buffer	268427264
open_cursors	300
pga_aggregate_target	4294967296
processes	1000
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan		SCHEDULER[0x3191]:DEFAULT_MAINTENANCE_PLAN
sec_case_sensitive_logon	FALSE
sessions	1536
sga_target	40667971584
shared_pool_size	2147483648
streams_pool_size	536870912
undo_tablespace	UNDO01

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

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

Parameter Name	Begin value	End value (if different)
control_files	/tccdata02/oradata/SHCCIOT/control01.ctl
control_files	/tccdata02/oradata/SHCCIOT/control02.ctl
control_files	/tccdata02/oradata/SHCCIOT/control03.ctl

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.95	Soft Parse %:	96.64
Execute to Parse %:	99.65	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	34.78	% Non-Parse CPU:	100.00