WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

BBGOA 500196284 bbgoa 1 10.2.0.4.0 NO bbgoa

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
BBGOA	500196284	bbgoa	1	10.2.0.4.0	NO	bbgoa

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 27746 18-5月 -12 17:00:40 61 10.0

End Snap: 27747 18-5月 -12 18:00:42 59 9.8

Elapsed: 60.03 (mins)

DB Time: 51.16 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	27746	18-5月 -12 17:00:40	61	10.0
End Snap:	27747	18-5月 -12 18:00:42	59	9.8
Elapsed:		60.03 (mins)
DB Time:		51.16 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 640M 640M Log Buffer: 14,344K

	Begin	End
Buffer Cache:	1,872M	1,872M	Std Block Size:	8K
Shared Pool Size:	640M	640M	Log Buffer:	14,344K

Load Profile

Per Second Per Transaction

Redo size: 208,327.10 59,927.64

Logical reads: 9,314.95 2,679.55

Block changes: 244.67 70.38

Physical reads: 563.63 162.14

Physical writes: 35.82 10.30

User calls: 296.48 85.29

Parses: 50.47 14.52

Hard parses: 7.82 2.25

Sorts: 21.86 6.29

Logons: 0.04 0.01

Executes: 57.27 16.47

Transactions: 3.48

	Per Second	Per Transaction
Redo size:	208,327.10	59,927.64
Logical reads:	9,314.95	2,679.55
Block changes:	244.67	70.38
Physical reads:	563.63	162.14
Physical writes:	35.82	10.30
User calls:	296.48	85.29
Parses:	50.47	14.52
Hard parses:	7.82	2.25
Sorts:	21.86	6.29
Logons:	0.04	0.01
Executes:	57.27	16.47
Transactions:	3.48

% Blocks changed per Read: 2.63 Recursive Call %: 22.38

Rollback per transaction %: 0.14 Rows per Sort: 65.12

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 81.18 Soft Parse %: 84.51

Execute to Parse %: 11.87 Latch Hit %: 99.96

Parse CPU to Parse Elapsd %: 95.16 % Non-Parse CPU: 95.09

Shared Pool Statistics

Begin End

Memory Usage %: 62.24 64.66

% SQL with executions>1: 43.30 58.51

% Memory for SQL w/exec>1: 36.34 53.87

	Begin	End
Memory Usage %:	62.24	64.66
% SQL with executions>1:	43.30	58.51
% Memory for SQL w/exec>1:	36.34	53.87

Top 5 Timed Events

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

CPU time 1,592 51.8

db file sequential read 263,366 1,228 5 40.0 User I/O

direct path read 1,721,880 290 0 9.4 User I/O

SQL*Net more data to client 5,637,615 175 0 5.7 Network

control file sequential read 144,055 35 0 1.2 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		1,592		51.8
db file sequential read	263,366	1,228	5	40.0	User I/O
direct path read	1,721,880	290	0	9.4	User I/O
SQL*Net more data to client	5,637,615	175	0	5.7	Network
control file sequential read	144,055	35	0	1.2	System I/O

Main Report

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

Time Model Statistics

Total time in database user-calls (DB Time): 3069.9s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	2,302.03	74.99
DB CPU	1,591.52	51.84
parse time elapsed	90.49	2.95
hard parse elapsed time	71.90	2.34
PL/SQL execution elapsed time	3.91	0.13
connection management call elapsed time	1.05	0.03
hard parse (sharing criteria) elapsed time	0.33	0.01
PL/SQL compilation elapsed time	0.29	0.01
failed parse elapsed time	0.14	0.00
hard parse (bind mismatch) elapsed time	0.06	0.00
sequence load elapsed time	0.04	0.00
repeated bind elapsed time	0.01	0.00
DB time	3,069.89
background elapsed time	62.80
background cpu time	26.71

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	1,998,284	1,523	1	159.59
Network	6,763,655	181	0	540.18
System I/O	180,393	67	0	14.41
Commit	12,349	18	1	0.99
Configuration	979	3	3	0.08
Concurrency	530	1	2	0.04
Application	1,034	0	0	0.08
Other	113	0	1	0.01

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	263,366	0.00	1,228	5	21.03
direct path read	1,721,880	0.00	290	0	137.52
SQL*Net more data to client	5,637,615	0.00	175	0	450.25
control file sequential read	144,055	0.00	35	0	11.51
log file parallel write	15,313	0.00	19	1	1.22
log file sync	12,349	0.00	18	1	0.99
log file sequential read	779	0.00	5	6	0.06
SQL*Net more data from client	225,512	0.00	4	0	18.01
direct path write	12,709	0.00	4	0	1.02
Log archive I/O	751	0.00	3	4	0.06
enq: HW - contention	971	0.00	3	3	0.08
db file parallel write	17,502	0.00	2	0	1.40
control file parallel write	1,977	0.00	2	1	0.16
SQL*Net message to client	900,528	0.00	1	0	71.92
db file scattered read	292	0.00	1	3	0.02
db file parallel read	31	0.00	1	17	0.00
latch: shared pool	199	0.00	0	2	0.02
latch: library cache lock	23	0.00	0	10	0.00
SQL*Net break/reset to client	1,034	0.00	0	0	0.08
log file switch completion	8	0.00	0	25	0.00
latch: library cache	50	0.00	0	2	0.00
os thread startup	2	0.00	0	41	0.00
read by other session	6	0.00	0	13	0.00
latch free	14	0.00	0	3	0.00
enq: TX - index contention	2	0.00	0	14	0.00
latch: cache buffers chains	162	0.00	0	0	0.01
LGWR wait for redo copy	91	0.00	0	0	0.01
buffer busy waits	88	0.00	0	0	0.01
log file single write	16	0.00	0	0	0.00
latch: session allocation	1	0.00	0	2	0.00
latch: row cache objects	4	0.00	0	1	0.00
latch: object queue header operation	2	0.00	0	1	0.00
latch: cache buffers lru chain	4	0.00	0	0	0.00
latch: undo global data	1	0.00	0	0	0.00
SQL*Net message from client	900,529	0.00	119,915	133	71.92
wait for unread message on broadcast channel	3,598	100.00	3,517	977	0.29
Streams AQ: waiting for messages in the queue	720	100.00	3,516	4883	0.06
jobq slave wait	1,200	95.00	3,513	2928	0.10
Streams AQ: qmn slave idle wait	128	0.00	3,507	27398	0.01
Streams AQ: qmn coordinator idle wait	259	50.58	3,507	13540	0.02
SGA: MMAN sleep for component shrink	108	3.70	0	1	0.01
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	15,309	0.00	19	1	1.22
log file sequential read	779	0.00	5	6	0.06
Log archive I/O	751	0.00	3	4	0.06
db file parallel write	17,502	0.00	2	0	1.40
control file sequential read	4,120	0.00	2	1	0.33
control file parallel write	1,977	0.00	2	1	0.16
direct path read	3,475	0.00	2	1	0.28
db file sequential read	155	0.00	2	10	0.01
db file scattered read	62	0.00	0	3	0.00
direct path write	1,075	0.00	0	0	0.09
os thread startup	2	0.00	0	41	0.00
events in waitclass Other	96	0.00	0	0	0.01
log file single write	16	0.00	0	0	0.00
latch: shared pool	1	0.00	0	0	0.00
rdbms ipc message	26,769	43.20	36,771	1374	2.14
pmon timer	1,235	100.00	3,516	2847	0.10
Streams AQ: qmn slave idle wait	128	0.00	3,507	27398	0.01
Streams AQ: qmn coordinator idle wait	259	50.58	3,507	13540	0.02
smon timer	31	32.26	3,320	107087	0.00
SGA: MMAN sleep for component shrink	108	3.70	0	1	0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	173,156
IDLE_TIME	1,267,187
IOWAIT_TIME	103,516
NICE_TIME	0
SYS_TIME	24,214
USER_TIME	130,383
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	4,138,074,112
NUM_CPUS	4
NUM_CPU_SOCKETS	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
bbgoa	3,009.10	1,560.80	2,022,861	33,078,756
SYS$USERS	66.00	33.30	2,400	453,638
SYS$BACKGROUND	0.00	0.00	5,739	44,342

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
bbgoa	1990347	151063	504	73	6761288	18096
SYS$USERS	1624	439	17	2	2246	1
SYS$BACKGROUND	6350	801	9	10	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
216	9	1,512	0.14	7.03	0g5c28fmgavat	w3wp.exe	select USERID, EMAILID, substr...
87	25	3,791	0.02	2.83	0yqkhcfnc94gk	w3wp.exe	insert into INBOX(USERID, EMAI...
62	32	5,744	0.01	2.02	2rkjfjh0ayn4b	w3wp.exe	select USERID, EMAILID, substr...
27	27	97	0.28	0.89	4qubqwvspfkx9	w3wp.exe	select a.GS, a.gwh, a.gwbh, a....
19	3	657	0.03	0.63	9895xcuktuppc	w3wp.exe	insert into OUTBOX(USERID, EMA...
17	11	301	0.06	0.55	dy1nqwbjsv8nv	w3wp.exe	INSERT INTO EMAILATTS2(EMAILID...
16	7	4,038	0.00	0.53	630ds4u4vysz7	w3wp.exe	insert into log(userid, ip, ti...
13	13	53,631	0.00	0.42	3k326fnhd3ra6	w3wp.exe	select ID, DEPTID, DEPTNAME, P...
12	12	210	0.06	0.38	7gzj5c1nw3jt3	w3wp.exe	select TXLBH, lpad('　', level*...
11	3	8	1.42	0.37	34rwuvgmzu2x2		select tablespace_name, sum(ph...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
32	62	5,744	0.01	2.02	2rkjfjh0ayn4b	w3wp.exe	select USERID, EMAILID, substr...
27	27	97	0.28	0.89	4qubqwvspfkx9	w3wp.exe	select a.GS, a.gwh, a.gwbh, a....
25	87	3,791	0.01	2.83	0yqkhcfnc94gk	w3wp.exe	insert into INBOX(USERID, EMAI...
13	13	53,631	0.00	0.42	3k326fnhd3ra6	w3wp.exe	select ID, DEPTID, DEPTNAME, P...
12	12	210	0.06	0.38	7gzj5c1nw3jt3	w3wp.exe	select TXLBH, lpad('　', level*...
11	17	301	0.04	0.55	dy1nqwbjsv8nv	w3wp.exe	INSERT INTO EMAILATTS2(EMAILID...
9	216	1,512	0.01	7.03	0g5c28fmgavat	w3wp.exe	select USERID, EMAILID, substr...
9	10	4,079	0.00	0.34	ak7y26nppxsd9	w3wp.exe	update INBOX set READFLAG='2' ...
8	8	240	0.03	0.25	09kg06xq8vsw9	w3wp.exe	select txlbh, lpad('　', level*...
8	8	23	0.33	0.25	7dtr6m8y1rdwj	w3wp.exe	select a.GS, a.gwh, a.gwbh, a....

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: 33,550,664
Captured SQL account for 20.6% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,773,446	5,744	308.75	5.29	31.72	61.99	2rkjfjh0ayn4b	w3wp.exe	select USERID, EMAILID, substr...
858,032	53,631	16.00	2.56	12.83	12.85	3k326fnhd3ra6	w3wp.exe	select ID, DEPTID, DEPTNAME, P...
761,670	3,791	200.92	2.27	24.85	86.99	0yqkhcfnc94gk	w3wp.exe	insert into INBOX(USERID, EMAI...
658,920	97	6,792.99	1.96	27.37	27.45	4qubqwvspfkx9	w3wp.exe	select a.GS, a.gwh, a.gwbh, a....
343,140	28	12,255.00	1.02	6.06	6.09	3swf66vkm4j78	w3wp.exe	select a.GS, a.gwh, a.gwbh, a....
289,763	301	962.67	0.86	10.76	16.78	dy1nqwbjsv8nv	w3wp.exe	INSERT INTO EMAILATTS2(EMAILID...
242,023	1,512	160.07	0.72	8.90	215.93	0g5c28fmgavat	w3wp.exe	select USERID, EMAILID, substr...
152,858	23	6,646.00	0.46	7.69	7.72	7dtr6m8y1rdwj	w3wp.exe	select a.GS, a.gwh, a.gwbh, a....
130,860	18	7,270.00	0.39	5.86	5.86	2rt7f212942pf	w3wp.exe	select a.GS, a.gwh, a.gwbh, a....
129,759	21	6,179.00	0.39	6.21	6.24	6y2usfv2jqwp2	w3wp.exe	select count(*) from gwyd whe...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 2,030,101
Captured SQL account for 5.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
43,966	1,512	29.08	2.17	8.90	215.93	0g5c28fmgavat	w3wp.exe	select USERID, EMAILID, substr...
27,114	3,791	7.15	1.34	24.85	86.99	0yqkhcfnc94gk	w3wp.exe	insert into INBOX(USERID, EMAI...
7,052	5,744	1.23	0.35	31.72	61.99	2rkjfjh0ayn4b	w3wp.exe	select USERID, EMAILID, substr...
3,404	657	5.18	0.17	3.26	19.47	9895xcuktuppc	w3wp.exe	insert into OUTBOX(USERID, EMA...
2,454	4,038	0.61	0.12	7.44	16.32	630ds4u4vysz7	w3wp.exe	insert into log(userid, ip, ti...
2,145	3,492	0.61	0.11	3.80	9.77	2tk61z71n7ank	w3wp.exe	select sum(emailsize) from inb...
1,542	4,079	0.38	0.08	8.63	10.32	ak7y26nppxsd9	w3wp.exe	update INBOX set READFLAG='2' ...
1,410	3,485	0.40	0.07	4.07	8.55	0k9a8fzxz8nb8	w3wp.exe	select sum(emailsize) from out...
1,368	4	342.00	0.07	0.17	6.67	61u1gqw16ujh0	w3wp.exe	select count(*) from inbox whe...
1,052	2	526.00	0.05	0.12	5.13	gdrzgrqmm43r5	w3wp.exe	select count(*) from inbox whe...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 206,282
Captured SQL account for 62.7% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
53,631	53,634	1.00	0.00	0.00	3k326fnhd3ra6	w3wp.exe	select ID, DEPTID, DEPTNAME, P...
11,132	11,127	1.00	0.00	0.00	4mdux9p30pdvx	w3wp.exe	select DEPTRIGHTS from txl whe...
5,744	1,733,256	301.75	0.01	0.01	2rkjfjh0ayn4b	w3wp.exe	select USERID, EMAILID, substr...
4,414	4,407	1.00	0.00	0.00	gac1dmbuwtays	w3wp.exe	select * from INBOX where emai...
4,079	4,072	1.00	0.00	0.00	ak7y26nppxsd9	w3wp.exe	update INBOX set READFLAG='2' ...
4,038	3,706	0.92	0.00	0.00	630ds4u4vysz7	w3wp.exe	insert into log(userid, ip, ti...
3,791	3,791	1.00	0.01	0.02	0yqkhcfnc94gk	w3wp.exe	insert into INBOX(USERID, EMAI...
3,492	3,491	1.00	0.00	0.00	2tk61z71n7ank	w3wp.exe	select sum(emailsize) from inb...
3,485	3,485	1.00	0.00	0.00	0k9a8fzxz8nb8	w3wp.exe	select sum(emailsize) from out...
3,481	3,478	1.00	0.00	0.00	68bxq5mrt54r2	w3wp.exe	select sum(emailsize) from dra...
3,472	3,470	1.00	0.00	0.00	f4t7gfjj3nm5z	w3wp.exe	select sum(emailsize) from tra...
2,586	2,586	1.00	0.00	0.00	d40k85mru9xm0	w3wp.exe	select ATTFILENAME, ATTFILETYP...
2,521	0	0.00	0.00	0.00	6kczcnmjxqzch	w3wp.exe	select * from alert_msg
2,196	2,120	0.97	0.00	0.00	4nbnydja3dg9j	w3wp.exe	select a.ATTFILENAME, a.ATTFIL...
2,167	2,166	1.00	0.00	0.00	2p54kcvz0vdhk	w3wp.exe	select count(*) from USER_PASS...
2,153	2,164	1.01	0.00	0.00	84a4tbzat99ku	w3wp.exe	UPDATE USER_PASSWORD_CONFIG SE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 181,793
Captured SQL account for 68.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
53,631	53,631	29.50	3k326fnhd3ra6	w3wp.exe	select ID, DEPTID, DEPTNAME, P...
11,132	11,132	6.12	4mdux9p30pdvx	w3wp.exe	select DEPTRIGHTS from txl whe...
5,744	5,744	3.16	2rkjfjh0ayn4b	w3wp.exe	select USERID, EMAILID, substr...
4,414	4,414	2.43	gac1dmbuwtays	w3wp.exe	select * from INBOX where emai...
4,079	4,079	2.24	ak7y26nppxsd9	w3wp.exe	update INBOX set READFLAG='2' ...
4,038	4,038	2.22	630ds4u4vysz7	w3wp.exe	insert into log(userid, ip, ti...
3,791	3,791	2.09	0yqkhcfnc94gk	w3wp.exe	insert into INBOX(USERID, EMAI...
3,492	3,492	1.92	2tk61z71n7ank	w3wp.exe	select sum(emailsize) from inb...
3,485	3,485	1.92	0k9a8fzxz8nb8	w3wp.exe	select sum(emailsize) from out...
3,481	3,481	1.91	68bxq5mrt54r2	w3wp.exe	select sum(emailsize) from dra...
3,472	3,472	1.91	f4t7gfjj3nm5z	w3wp.exe	select sum(emailsize) from tra...
2,586	2,586	1.42	d40k85mru9xm0	w3wp.exe	select ATTFILENAME, ATTFILETYP...
2,521	2,521	1.39	6kczcnmjxqzch	w3wp.exe	select * from alert_msg
2,196	2,196	1.21	4nbnydja3dg9j	w3wp.exe	select a.ATTFILENAME, a.ATTFIL...
2,167	2,167	1.19	2p54kcvz0vdhk	w3wp.exe	select count(*) from USER_PASS...
2,153	2,153	1.18	84a4tbzat99ku	w3wp.exe	UPDATE USER_PASSWORD_CONFIG SE...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
32	3,791	0yqkhcfnc94gk	w3wp.exe	insert into INBOX(USERID, EMAI...
28	657	9895xcuktuppc	w3wp.exe	insert into OUTBOX(USERID, EMA...
22	4,038	630ds4u4vysz7	w3wp.exe	insert into log(userid, ip, ti...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

09kg06xq8vsw9 select txlbh, lpad('　', level*2, '　')||txlmc txlmc, sjbm from TXL connect by prior txlbh=sjbm start with sjbm is null

0g5c28fmgavat select USERID, EMAILID, substr(TITLE, 0, 20) TITLE, substr(RECEIPT, 0, 20) RECEIPT, SENDTIME, EMAILSIZE, REPLYFLAG, ATTNUM from outbox where userid=:userid1 order by sendtime desc

0k9a8fzxz8nb8 select sum(emailsize) from outbox where userid=:userid

0yqkhcfnc94gk insert into INBOX(USERID, EMAILID, RECEIPT, COPYTO, TITLE, CONTENT, SENDER, READFLAG, SENDTIME, EMAILSIZE, REPLYFLAG, ATTNUM) values(:USERID, :EMAILID, :RECEIPT, :COPYTO, :TITLE, :CONTENT, :SENDER, :READFLAG, :SENDTIME, :EMAILSIZE, :REPLYFLAG, :ATTNUM)

2p54kcvz0vdhk select count(*) from USER_PASSWORD_CONFIG where userid= :userid

2rkjfjh0ayn4b select USERID, EMAILID, substr(TITLE, 0, 20) TITLE, SENDER, READFLAG, replyflag, SENDTIME, EMAILSIZE, ATTNUM from inbox where userid=:userid1 order by sendtime desc

2rt7f212942pf select a.GS, a.gwh, a.gwbh, a.gwbt, a.fjs, a.fwbm, b.ydbz from gwda a, gwyd b where a.gwbh=b.gwbh and (b.YDZBH='桂阳店防损课' or b.YDZBH=' ') order by TO_NUMBER(a.gwbh) desc

2tk61z71n7ank select sum(emailsize) from inbox where userid=:userid

34rwuvgmzu2x2 select tablespace_name, sum(phywrts) wrts from v$filestat a, dba_data_files b where a.FILE#=b.file_id group by b.tablespace_name

3k326fnhd3ra6 select ID, DEPTID, DEPTNAME, PARENTID FROM OA_DEPT where PARENTID=:PARENTID order by ID

3swf66vkm4j78 select a.GS, a.gwh, a.gwbh, a.gwbt, a.fjs, a.fwbm, b.ydbz from gwda a, gwyd b where a.gwbh=b.gwbh and (b.YDZBH='南县店店长办' or b.YDZBH='') order by TO_NUMBER(a.gwbh) desc

4mdux9p30pdvx select DEPTRIGHTS from txl where txlbh=:userid

4nbnydja3dg9j select a.ATTFILENAME, a.ATTFILETYPE, a.ATTSIZE, b.ATTCONTENT from EMAILATTS a, EMAILATTS2 b WHERE a.EMAILID=b.EMAILID AND a.emailid=:emailid

4qubqwvspfkx9 select a.GS, a.gwh, a.gwbh, a.gwbt, a.fjs, a.fwbm, b.ydbz from gwda a, gwyd b where a.gwbh=b.gwbh and (b.YDZBH='娄底超市店长办' or b.YDZBH=' ') order by TO_NUMBER(a.gwbh) desc

61u1gqw16ujh0 select count(*) from inbox where (userid='张旭' or userid=' ') and READFLAG<>'2'

630ds4u4vysz7 insert into log(userid, ip, time, op, computername) values(:userid, :ip, :time, :op, :newip)

68bxq5mrt54r2 select sum(emailsize) from draftbox where userid=:userid

6kczcnmjxqzch select * from alert_msg

6y2usfv2jqwp2 select count(*) from gwyd where (YDZBH='汉寿店人事' or YDZBH=' ') and (ydbz='1' or ydbz is null)

7dtr6m8y1rdwj select a.GS, a.gwh, a.gwbh, a.gwbt, a.fjs, a.fwbm, b.ydbz, a.fbrq from gwda a, gwyd b where a.gwbh=b.gwbh and (b.YDZBH='家电桥北店' or b.YDZBH=' ')

7gzj5c1nw3jt3 select TXLBH, lpad('　', level*2, '　')||TXLMC txlmc FROM txl where lx='1' connect by prior txlbh=sjbm start with sjbm is null

84a4tbzat99ku UPDATE USER_PASSWORD_CONFIG SET PASSWORDMD = :passwordMD WHERE USERID = :userid

9895xcuktuppc insert into OUTBOX(USERID, EMAILID, RECEIPT, COPYTO, TITLE, CONTENT, SENDER, READFLAG, SENDTIME, EMAILSIZE, REPLYFLAG, ATTNUM) values(:USERID, :EMAILID, :RECEIPT, :COPYTO, :TITLE, :CONTENT, :SENDER, :READFLAG, :SENDTIME, :EMAILSIZE, :REPLYFLAG, :ATTNUM)

ak7y26nppxsd9 update INBOX set READFLAG='2' WHERE userid=:userid and emailid=:emailid

d40k85mru9xm0 select ATTFILENAME, ATTFILETYPE, ATTSIZE FROM EMAILATTS WHERE EMAILID =:emailid

dy1nqwbjsv8nv INSERT INTO EMAILATTS2(EMAILID, FDATE, ATTCONTENT) VALUES(:EMAILID, :FDATE, :ATTCONTENT)

f4t7gfjj3nm5z select sum(emailsize) from trashbox where userid=:userid

gac1dmbuwtays select * from INBOX where emailid=:emailid

gdrzgrqmm43r5 select count(*) from inbox where (userid='湘潭超市杂货专家' or userid=' ') and READFLAG<>'2'

SQL Id	SQL Text
09kg06xq8vsw9	select txlbh, lpad('　', level*2, '　')\|\|txlmc txlmc, sjbm from TXL connect by prior txlbh=sjbm start with sjbm is null
0g5c28fmgavat	select USERID, EMAILID, substr(TITLE, 0, 20) TITLE, substr(RECEIPT, 0, 20) RECEIPT, SENDTIME, EMAILSIZE, REPLYFLAG, ATTNUM from outbox where userid=:userid1 order by sendtime desc
0k9a8fzxz8nb8	select sum(emailsize) from outbox where userid=:userid
0yqkhcfnc94gk	insert into INBOX(USERID, EMAILID, RECEIPT, COPYTO, TITLE, CONTENT, SENDER, READFLAG, SENDTIME, EMAILSIZE, REPLYFLAG, ATTNUM) values(:USERID, :EMAILID, :RECEIPT, :COPYTO, :TITLE, :CONTENT, :SENDER, :READFLAG, :SENDTIME, :EMAILSIZE, :REPLYFLAG, :ATTNUM)
2p54kcvz0vdhk	select count(*) from USER_PASSWORD_CONFIG where userid= :userid
2rkjfjh0ayn4b	select USERID, EMAILID, substr(TITLE, 0, 20) TITLE, SENDER, READFLAG, replyflag, SENDTIME, EMAILSIZE, ATTNUM from inbox where userid=:userid1 order by sendtime desc
2rt7f212942pf	select a.GS, a.gwh, a.gwbh, a.gwbt, a.fjs, a.fwbm, b.ydbz from gwda a, gwyd b where a.gwbh=b.gwbh and (b.YDZBH='桂阳店防损课' or b.YDZBH=' ') order by TO_NUMBER(a.gwbh) desc
2tk61z71n7ank	select sum(emailsize) from inbox where userid=:userid
34rwuvgmzu2x2	select tablespace_name, sum(phywrts) wrts from v$filestat a, dba_data_files b where a.FILE#=b.file_id group by b.tablespace_name
3k326fnhd3ra6	select ID, DEPTID, DEPTNAME, PARENTID FROM OA_DEPT where PARENTID=:PARENTID order by ID
3swf66vkm4j78	select a.GS, a.gwh, a.gwbh, a.gwbt, a.fjs, a.fwbm, b.ydbz from gwda a, gwyd b where a.gwbh=b.gwbh and (b.YDZBH='南县店店长办' or b.YDZBH='') order by TO_NUMBER(a.gwbh) desc
4mdux9p30pdvx	select DEPTRIGHTS from txl where txlbh=:userid
4nbnydja3dg9j	select a.ATTFILENAME, a.ATTFILETYPE, a.ATTSIZE, b.ATTCONTENT from EMAILATTS a, EMAILATTS2 b WHERE a.EMAILID=b.EMAILID AND a.emailid=:emailid
4qubqwvspfkx9	select a.GS, a.gwh, a.gwbh, a.gwbt, a.fjs, a.fwbm, b.ydbz from gwda a, gwyd b where a.gwbh=b.gwbh and (b.YDZBH='娄底超市店长办' or b.YDZBH=' ') order by TO_NUMBER(a.gwbh) desc
61u1gqw16ujh0	select count(*) from inbox where (userid='张旭' or userid=' ') and READFLAG<>'2'
630ds4u4vysz7	insert into log(userid, ip, time, op, computername) values(:userid, :ip, :time, :op, :newip)
68bxq5mrt54r2	select sum(emailsize) from draftbox where userid=:userid
6kczcnmjxqzch	select * from alert_msg
6y2usfv2jqwp2	select count(*) from gwyd where (YDZBH='汉寿店人事' or YDZBH=' ') and (ydbz='1' or ydbz is null)
7dtr6m8y1rdwj	select a.GS, a.gwh, a.gwbh, a.gwbt, a.fjs, a.fwbm, b.ydbz, a.fbrq from gwda a, gwyd b where a.gwbh=b.gwbh and (b.YDZBH='家电桥北店' or b.YDZBH=' ')
7gzj5c1nw3jt3	select TXLBH, lpad('　', level*2, '　')\|\|TXLMC txlmc FROM txl where lx='1' connect by prior txlbh=sjbm start with sjbm is null
84a4tbzat99ku	UPDATE USER_PASSWORD_CONFIG SET PASSWORDMD = :passwordMD WHERE USERID = :userid
9895xcuktuppc	insert into OUTBOX(USERID, EMAILID, RECEIPT, COPYTO, TITLE, CONTENT, SENDER, READFLAG, SENDTIME, EMAILSIZE, REPLYFLAG, ATTNUM) values(:USERID, :EMAILID, :RECEIPT, :COPYTO, :TITLE, :CONTENT, :SENDER, :READFLAG, :SENDTIME, :EMAILSIZE, :REPLYFLAG, :ATTNUM)
ak7y26nppxsd9	update INBOX set READFLAG='2' WHERE userid=:userid and emailid=:emailid
d40k85mru9xm0	select ATTFILENAME, ATTFILETYPE, ATTSIZE FROM EMAILATTS WHERE EMAILID =:emailid
dy1nqwbjsv8nv	INSERT INTO EMAILATTS2(EMAILID, FDATE, ATTCONTENT) VALUES(:EMAILID, :FDATE, :ATTCONTENT)
f4t7gfjj3nm5z	select sum(emailsize) from trashbox where userid=:userid
gac1dmbuwtays	select * from INBOX where emailid=:emailid
gdrzgrqmm43r5	select count(*) from inbox where (userid='湘潭超市杂货专家' or userid=' ') and READFLAG<>'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

Statistic	Total	per Second	per Trans
CPU used by this session	144,770	40.19	11.56
CPU used when call started	144,338	40.07	11.53
CR blocks created	2,247	0.62	0.18
Cached Commit SCN referenced	4,110	1.14	0.33
Commit SCN cached	31	0.01	0.00
DB time	1,394,616	387.20	111.38
DBWR checkpoint buffers written	46,852	13.01	3.74
DBWR checkpoints	4	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	117	0.03	0.01
DBWR undo block writes	7,101	1.97	0.57
IMU CR rollbacks	172	0.05	0.01
IMU Flushes	3,202	0.89	0.26
IMU Redo allocation size	12,097,732	3,358.80	966.20
IMU commits	10,072	2.80	0.80
IMU contention	188	0.05	0.02
IMU ktichg flush	639	0.18	0.05
IMU pool not allocated	464	0.13	0.04
IMU recursive-transaction flush	2	0.00	0.00
IMU undo allocation size	37,160,392	10,317.15	2,967.85
IMU- failed to get a private strand	464	0.13	0.04
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	899,951	249.86	71.88
SQL*Net roundtrips to/from dblink	0	0.00	0.00
active txn count during cleanout	10,850	3.01	0.87
application wait time	21	0.01	0.00
background checkpoints completed	5	0.00	0.00
background checkpoints started	4	0.00	0.00
background timeouts	11,591	3.22	0.93
branch node splits	2	0.00	0.00
buffer is not pinned count	4,831,027	1,341.28	385.83
buffer is pinned count	4,071,279	1,130.34	325.16
bytes received via SQL*Net from client	563,566,395	156,467.68	45,009.70
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	11,888,387,869	3,300,673.21	949,475.91
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	1,155,775	320.89	92.31
calls to kcmgas	96,753	26.86	7.73
calls to kcmgcs	6,011	1.67	0.48
change write time	958	0.27	0.08
cleanout - number of ktugct calls	11,249	3.12	0.90
cleanouts and rollbacks - consistent read gets	1,775	0.49	0.14
cleanouts only - consistent read gets	380	0.11	0.03
cluster key scan block gets	28,311	7.86	2.26
cluster key scans	23,558	6.54	1.88
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	191	0.05	0.02
commit batch/immediate requested	191	0.05	0.02
commit cleanout failures: block lost	1	0.00	0.00
commit cleanout failures: callback failure	368	0.10	0.03
commit cleanout failures: cannot pin	13	0.00	0.00
commit cleanouts	93,269	25.90	7.45
commit cleanouts successfully completed	92,887	25.79	7.42
commit immediate performed	191	0.05	0.02
commit immediate requested	191	0.05	0.02
commit txn count during cleanout	1,553	0.43	0.12
concurrency wait time	85	0.02	0.01
consistent changes	41,716	11.58	3.33
consistent gets	31,917,455	8,861.51	2,549.11
consistent gets - examination	4,907,834	1,362.60	391.97
consistent gets direct	1,798,624	499.37	143.65
consistent gets from cache	30,118,831	8,362.14	2,405.47
cursor authentications	5,798	1.61	0.46
data blocks consistent reads - undo records applied	8,913	2.47	0.71
db block changes	881,244	244.67	70.38
db block gets	1,633,209	453.44	130.44
db block gets direct	76,016	21.10	6.07
db block gets from cache	1,557,193	432.34	124.37
deferred (CURRENT) block cleanout applications	32,439	9.01	2.59
dirty buffers inspected	902	0.25	0.07
enqueue conversions	796	0.22	0.06
enqueue releases	242,567	67.35	19.37
enqueue requests	242,861	67.43	19.40
enqueue timeouts	294	0.08	0.02
enqueue waits	946	0.26	0.08
execute count	206,282	57.27	16.47
failed probes on index block reclamation	3	0.00	0.00
free buffer inspected	219,406	60.92	17.52
free buffer requested	283,277	78.65	22.62
heap block compress	3,196	0.89	0.26
hot buffers moved to head of LRU	391,336	108.65	31.25
immediate (CR) block cleanout applications	2,155	0.60	0.17
immediate (CURRENT) block cleanout applications	39,475	10.96	3.15
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	13,868	3.85	1.11
index fast full scans (full)	11	0.00	0.00
index fetch by key	655,116	181.89	52.32
index scans kdiixs1	1,770,964	491.69	141.44
leaf node 90-10 splits	46	0.01	0.00
leaf node splits	321	0.09	0.03
lob reads	386,908	107.42	30.90
lob writes	15,691	4.36	1.25
lob writes unaligned	11,762	3.27	0.94
logons cumulative	134	0.04	0.01
messages received	32,947	9.15	2.63
messages sent	32,947	9.15	2.63
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	24,784,607	6,881.16	1,979.44
opened cursors cumulative	187,508	52.06	14.98
parse count (failures)	4	0.00	0.00
parse count (hard)	28,164	7.82	2.25
parse count (total)	181,793	50.47	14.52
parse time cpu	7,810	2.17	0.62
parse time elapsed	8,207	2.28	0.66
physical read IO requests	1,985,060	551.13	158.54
physical read bytes	16,630,587,392	4,617,289.99	1,328,215.59
physical read total IO requests	2,130,230	591.43	170.13
physical read total bytes	19,840,980,480	5,508,618.45	1,584,616.28
physical read total multi block requests	33,275	9.24	2.66
physical reads	2,030,101	563.63	162.14
physical reads cache	228,659	63.48	18.26
physical reads cache prefetch	2,372	0.66	0.19
physical reads direct	1,801,442	500.15	143.87
physical reads direct (lob)	1,761,180	488.97	140.66
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	107,185	29.76	8.56
physical write bytes	1,056,931,840	293,444.88	84,412.73
physical write total IO requests	145,342	40.35	11.61
physical write total bytes	3,493,898,752	970,040.52	279,043.11
physical write total multi block requests	40,466	11.23	3.23
physical writes	129,020	35.82	10.30
physical writes direct	77,091	21.40	6.16
physical writes direct (lob)	76,009	21.10	6.07
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	51,929	14.42	4.15
physical writes non checkpoint	111,001	30.82	8.87
pinned buffers inspected	1,893	0.53	0.15
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,673	1.02	0.29
recursive calls	307,907	85.49	24.59
recursive cpu usage	8,908	2.47	0.71
redo blocks written	1,521,104	422.32	121.48
redo buffer allocation retries	22	0.01	0.00
redo entries	460,393	127.82	36.77
redo log space requests	22	0.01	0.00
redo log space wait time	22	0.01	0.00
redo ordering marks	5,826	1.62	0.47
redo size	750,354,024	208,327.10	59,927.64
redo subscn max counts	16,393	4.55	1.31
redo synch time	1,549	0.43	0.12
redo synch writes	12,537	3.48	1.00
redo wastage	3,790,376	1,052.35	302.72
redo write time	2,088	0.58	0.17
redo writer latching time	1	0.00	0.00
redo writes	15,306	4.25	1.22
rollback changes - undo records applied	410	0.11	0.03
rollbacks only - consistent read gets	359	0.10	0.03
rows fetched via callback	894,781	248.43	71.46
session connect time	0	0.00	0.00
session cursor cache hits	122,686	34.06	9.80
session logical reads	33,550,664	9,314.95	2,679.55
session pga memory	187,400,336	52,029.53	14,966.88
session pga memory max	526,597,616	146,203.73	42,057.15
session uga memory	###############	71,547,832.19	20,581,541.64
session uga memory max	317,018,272	88,016.45	25,318.93
shared hash latch upgrades - no wait	36,319	10.08	2.90
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	78,742	21.86	6.29
sorts (rows)	5,127,740	1,423.66	409.53
sql area evicted	27,481	7.63	2.19
sql area purged	4	0.00	0.00
summed dirty queue length	10,426	2.89	0.83
switch current to new buffer	37,073	10.29	2.96
table fetch by rowid	3,936,463	1,092.91	314.39
table fetch continued row	7,324	2.03	0.58
table scan blocks gotten	19,906,367	5,526.77	1,589.84
table scan rows gotten	4,223,774,126	1,172,681.97	337,335.21
table scans (cache partitions)	1	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (short tables)	74,948	20.81	5.99
total number of times SMON posted	21	0.01	0.00
transaction rollbacks	191	0.05	0.02
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	44,947,916	12,479.27	3,589.80
user I/O wait time	151,994	42.20	12.14
user calls	1,067,868	296.48	85.29
user commits	12,503	3.47	1.00
user rollbacks	18	0.00	0.00
workarea executions - optimal	33,157	9.21	2.65
write clones created in background	0	0.00	0.00
write clones created in foreground	2	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	92,863	98,029
opened cursors current	613	576
logons current	61	59

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)	4	4.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
BBGOA_LOB	1,875,708	521	1.35	1.02	89,956	25	79	0.38
TB_OFFICE_DATA	87,929	24	0.88	1.03	8,329	2	0	0.00
BBGOA_DATA	18,427	5	2.66	1.00	6,609	2	0	0.00
SYSTEM	1,998	1	3.11	1.63	130	0	0	0.00
SYSAUX	1,302	0	3.10	1.15	776	0	0	0.00
UNDOTBS1	46	0	16.30	1.00	873	0	12	0.00
T_BBGOA	102	0	9.41	1.00	332	0	0	0.00
BBGOA_IND	64	0	16.72	1.00	87	0	3	23.33
NEWOA_DATA	125	0	28.32	1.00	25	0	0	0.00
NEWOA_IND	125	0	29.44	1.00	25	0	0	0.00
NEWOA_LOB	125	0	30.96	1.00	25	0	0	0.00
JDXX	40	0	37.25	1.00	10	0	0	0.00
USERS	5	0	18.00	1.00	5	0	0	0.00
TEMP	0	0	0.00		1	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
BBGOA_DATA	/dev/raw/raw21	2,554	1	5.05	1.00	2,318	1	0	0.00
BBGOA_DATA	/dev/raw/raw22	1,367	0	5.64	1.00	965	0	0	0.00
BBGOA_DATA	/dev/raw/raw23	7,208	2	1.31	1.00	1,000	0	0	0.00
BBGOA_DATA	/dev/raw/raw24	5,425	2	1.68	1.00	917	0	0	0.00
BBGOA_DATA	/dev/raw/raw25	1,873	1	5.25	1.00	1,409	0	0	0.00
BBGOA_IND	/dev/raw/raw26	5	0	28.00	1.00	5	0	0	0.00
BBGOA_IND	/dev/raw/raw27	7	0	28.57	1.00	5	0	0	0.00
BBGOA_IND	/dev/raw/raw28	5	0	28.00	1.00	14	0	0	0.00
BBGOA_IND	/dev/raw/raw29	5	0	28.00	1.00	5	0	0	0.00
BBGOA_IND	/dev/raw/raw30	42	0	10.71	1.00	58	0	3	23.33
BBGOA_LOB	/dev/raw/raw100	6,959	2	1.09	1.01	168	0	0	0.00
BBGOA_LOB	/dev/raw/raw101	5,177	1	1.56	1.01	218	0	0	0.00
BBGOA_LOB	/dev/raw/raw102	6,492	2	1.62	1.03	166	0	0	0.00
BBGOA_LOB	/dev/raw/raw103	2,191	1	2.85	1.03	150	0	0	0.00
BBGOA_LOB	/dev/raw/raw104	3,381	1	2.02	1.02	466	0	0	0.00
BBGOA_LOB	/dev/raw/raw106	5,527	2	1.93	1.01	156	0	0	0.00
BBGOA_LOB	/dev/raw/raw107	5,980	2	1.77	1.02	237	0	0	0.00
BBGOA_LOB	/dev/raw/raw108	4,068	1	2.25	1.02	165	0	8	0.00
BBGOA_LOB	/dev/raw/raw109	3,791	1	2.52	1.02	313	0	0	0.00
BBGOA_LOB	/dev/raw/raw110	3,058	1	2.84	1.01	113	0	0	0.00
BBGOA_LOB	/dev/raw/raw111	4,351	1	2.20	1.01	173	0	0	0.00
BBGOA_LOB	/dev/raw/raw112	6,696	2	1.65	1.04	291	0	0	0.00
BBGOA_LOB	/dev/raw/raw113	3,087	1	2.73	1.02	177	0	0	0.00
BBGOA_LOB	/dev/raw/raw114	4,050	1	2.23	1.02	221	0	0	0.00
BBGOA_LOB	/dev/raw/raw115	20,608	6	1.02	1.03	213	0	0	0.00
BBGOA_LOB	/dev/raw/raw116	3,971	1	3.47	1.04	327	0	0	0.00
BBGOA_LOB	/dev/raw/raw117	4,522	1	3.15	1.03	277	0	0	0.00
BBGOA_LOB	/dev/raw/raw118	4,351	1	2.87	1.03	355	0	0	0.00
BBGOA_LOB	/dev/raw/raw119	8,374	2	1.82	1.03	445	0	7	0.00
BBGOA_LOB	/dev/raw/raw120	3,804	1	3.38	1.02	327	0	0	0.00
BBGOA_LOB	/dev/raw/raw121	7,050	2	2.11	1.02	341	0	0	0.00
BBGOA_LOB	/dev/raw/raw122	4,950	1	2.82	1.02	311	0	0	0.00
BBGOA_LOB	/dev/raw/raw123	5,748	2	2.09	1.02	264	0	0	0.00
BBGOA_LOB	/dev/raw/raw124	8,521	2	1.88	1.02	328	0	0	0.00
BBGOA_LOB	/dev/raw/raw125	4,959	1	2.68	1.02	538	0	0	0.00
BBGOA_LOB	/dev/raw/raw126	3,779	1	3.60	1.01	312	0	0	0.00
BBGOA_LOB	/dev/raw/raw127	7,803	2	2.56	1.03	407	0	0	0.00
BBGOA_LOB	/dev/raw/raw128	4,947	1	3.49	1.01	356	0	0	0.00
BBGOA_LOB	/dev/raw/raw131	8,619	2	2.17	1.04	281	0	0	0.00
BBGOA_LOB	/dev/raw/raw132	5,269	1	3.03	1.04	258	0	0	0.00
BBGOA_LOB	/dev/raw/raw133	7,256	2	2.37	1.02	191	0	0	0.00
BBGOA_LOB	/dev/raw/raw134	5,661	2	2.84	1.00	165	0	0	0.00
BBGOA_LOB	/dev/raw/raw135	8,378	2	2.11	1.02	139	0	0	0.00
BBGOA_LOB	/dev/raw/raw136	4,748	1	3.12	1.01	264	0	5	0.00
BBGOA_LOB	/dev/raw/raw137	6,534	2	2.79	1.00	314	0	0	0.00
BBGOA_LOB	/dev/raw/raw138	6,316	2	3.13	1.01	430	0	0	0.00
BBGOA_LOB	/dev/raw/raw139	8,073	2	2.58	1.03	414	0	0	0.00
BBGOA_LOB	/dev/raw/raw140	4,578	1	3.26	1.01	264	0	0	0.00
BBGOA_LOB	/dev/raw/raw141	9,449	3	2.42	1.02	218	0	0	0.00
BBGOA_LOB	/dev/raw/raw142	19,439	5	1.20	1.03	199	0	0	0.00
BBGOA_LOB	/dev/raw/raw143	74,606	21	1.09	1.02	292	0	0	0.00
BBGOA_LOB	/dev/raw/raw144	86,413	24	0.83	1.01	115	0	0	0.00
BBGOA_LOB	/dev/raw/raw145	102,641	28	0.80	1.01	119	0	0	0.00
BBGOA_LOB	/dev/raw/raw146	5,938	2	2.38	1.04	168	0	0	0.00
BBGOA_LOB	/dev/raw/raw147	174,418	48	0.88	1.02	242	0	0	0.00
BBGOA_LOB	/dev/raw/raw148	36,611	10	1.48	1.02	157	0	0	0.00
BBGOA_LOB	/dev/raw/raw149	108,249	30	0.90	1.03	186	0	0	0.00
BBGOA_LOB	/dev/raw/raw150	147,087	41	0.83	1.01	1,392	0	0	0.00
BBGOA_LOB	/dev/raw/raw151	10,582	3	0.95	1.03	553	0	0	0.00
BBGOA_LOB	/dev/raw/raw152	3,967	1	2.23	1.01	259	0	0	0.00
BBGOA_LOB	/dev/raw/raw153	3,736	1	2.37	1.01	444	0	0	0.00
BBGOA_LOB	/dev/raw/raw154	34,353	10	0.54	1.08	411	0	0	0.00
BBGOA_LOB	/dev/raw/raw155	11,069	3	1.23	1.04	363	0	0	0.00
BBGOA_LOB	/dev/raw/raw156	6,511	2	2.02	1.01	4,960	1	0	0.00
BBGOA_LOB	/dev/raw/raw157	27,312	8	1.11	1.01	8,524	2	0	0.00
BBGOA_LOB	/dev/raw/raw158	51,069	14	1.00	1.00	8,493	2	0	0.00
BBGOA_LOB	/dev/raw/raw159	23,091	6	1.61	1.03	8,524	2	0	0.00
BBGOA_LOB	/dev/raw/raw160	353,690	98	0.77	1.03	8,247	2	0	0.00
BBGOA_LOB	/dev/raw/raw161	2,030	1	3.77	1.01	256	0	0	0.00
BBGOA_LOB	/dev/raw/raw162	1,435	0	4.08	1.01	187	0	0	0.00
BBGOA_LOB	/dev/raw/raw163	6,121	2	1.76	1.02	533	0	0	0.00
BBGOA_LOB	/dev/raw/raw164	3,489	1	2.30	1.01	482	0	2	5.00
BBGOA_LOB	/dev/raw/raw165	976	0	4.68	1.02	161	0	0	0.00
BBGOA_LOB	/dev/raw/raw166	893	0	4.29	1.01	113	0	0	0.00
BBGOA_LOB	/dev/raw/raw167	3,137	1	1.66	1.06	130	0	0	0.00
BBGOA_LOB	/dev/raw/raw168	1,051	0	5.03	1.02	146	0	0	0.00
BBGOA_LOB	/dev/raw/raw169	1,277	0	4.84	1.00	288	0	0	0.00
BBGOA_LOB	/dev/raw/raw170	1,824	1	4.05	1.00	261	0	0	0.00
BBGOA_LOB	/dev/raw/raw171	1,117	0	6.35	1.00	507	0	0	0.00
BBGOA_LOB	/dev/raw/raw172	1,366	0	4.88	1.02	510	0	0	0.00
BBGOA_LOB	/dev/raw/raw173	788	0	4.57	1.01	40	0	0	0.00
BBGOA_LOB	/dev/raw/raw174	789	0	5.48	1.00	44	0	0	0.00
BBGOA_LOB	/dev/raw/raw175	1,368	0	3.43	1.00	33	0	0	0.00
BBGOA_LOB	/dev/raw/raw176	704	0	5.06	1.01	23	0	0	0.00
BBGOA_LOB	/dev/raw/raw177	842	0	4.41	1.03	27	0	0	0.00
BBGOA_LOB	/dev/raw/raw178	514	0	6.73	1.00	16	0	0	0.00
BBGOA_LOB	/dev/raw/raw179	951	0	5.31	1.00	51	0	0	0.00
BBGOA_LOB	/dev/raw/raw180	757	0	4.49	1.01	26	0	0	0.00
BBGOA_LOB	/dev/raw/raw181	6,547	2	1.61	1.01	19	0	0	0.00
BBGOA_LOB	/dev/raw/raw182	644	0	4.27	1.02	40	0	0	0.00
BBGOA_LOB	/dev/raw/raw183	832	0	3.47	1.00	29	0	0	0.00
BBGOA_LOB	/dev/raw/raw184	971	0	2.92	1.00	25	0	0	0.00
BBGOA_LOB	/dev/raw/raw185	684	0	5.25	1.01	39	0	0	0.00
BBGOA_LOB	/dev/raw/raw186	542	0	4.67	1.00	15	0	0	0.00
BBGOA_LOB	/dev/raw/raw187	736	0	4.90	1.00	32	0	0	0.00
BBGOA_LOB	/dev/raw/raw188	1,636	0	3.50	1.01	44	0	0	0.00
BBGOA_LOB	/dev/raw/raw189	614	0	4.92	1.01	20	0	0	0.00
BBGOA_LOB	/dev/raw/raw190	688	0	4.04	1.00	20	0	0	0.00
BBGOA_LOB	/dev/raw/raw191	799	0	3.97	1.00	26	0	0	0.00
BBGOA_LOB	/dev/raw/raw192	601	0	6.14	1.00	30	0	0	0.00
BBGOA_LOB	/dev/raw/raw193	476	0	5.84	1.00	37	0	0	0.00
BBGOA_LOB	/dev/raw/raw194	1,052	0	3.23	1.01	23	0	0	0.00
BBGOA_LOB	/dev/raw/raw195	512	0	5.41	1.00	28	0	0	0.00
BBGOA_LOB	/dev/raw/raw196	676	0	4.32	1.00	32	0	0	0.00
BBGOA_LOB	/dev/raw/raw197	1,114	0	3.25	1.01	64	0	0	0.00
BBGOA_LOB	/dev/raw/raw198	441	0	6.05	1.00	19	0	0	0.00
BBGOA_LOB	/dev/raw/raw199	786	0	4.20	1.00	35	0	0	0.00
BBGOA_LOB	/dev/raw/raw200	571	0	5.45	1.00	35	0	0	0.00
BBGOA_LOB	/dev/raw/raw201	454	0	6.43	1.01	41	0	0	0.00
BBGOA_LOB	/dev/raw/raw202	516	0	5.14	1.00	17	0	0	0.00
BBGOA_LOB	/dev/raw/raw203	518	0	5.64	1.00	22	0	0	0.00
BBGOA_LOB	/dev/raw/raw204	20,995	6	1.12	1.03	27	0	0	0.00
BBGOA_LOB	/dev/raw/raw205	5,918	2	1.26	1.02	41	0	0	0.00
BBGOA_LOB	/dev/raw/raw206	438	0	5.89	1.00	37	0	0	0.00
BBGOA_LOB	/dev/raw/raw207	581	0	5.82	1.00	12	0	0	0.00
BBGOA_LOB	/dev/raw/raw208	626	0	4.66	1.02	11	0	0	0.00
BBGOA_LOB	/dev/raw/raw209	4,705	1	0.91	1.03	5	0	0	0.00
BBGOA_LOB	/dev/raw/raw210	456	0	4.25	1.04	10	0	0	0.00
BBGOA_LOB	/dev/raw/raw31	2,802	1	4.10	1.00	1,180	0	0	0.00
BBGOA_LOB	/dev/raw/raw32	3,229	1	3.78	1.00	1,157	0	0	0.00
BBGOA_LOB	/dev/raw/raw33	2,000	1	4.33	1.00	478	0	0	0.00
BBGOA_LOB	/dev/raw/raw34	2,381	1	4.15	1.00	848	0	0	0.00
BBGOA_LOB	/dev/raw/raw35	2,512	1	3.46	1.02	660	0	1	0.00
BBGOA_LOB	/dev/raw/raw36	3,954	1	2.75	1.02	992	0	0	0.00
BBGOA_LOB	/dev/raw/raw37	11,529	3	1.36	1.03	985	0	0	0.00
BBGOA_LOB	/dev/raw/raw38	9,555	3	1.53	1.00	875	0	0	0.00
BBGOA_LOB	/dev/raw/raw39	4,166	1	2.65	1.00	811	0	0	0.00
BBGOA_LOB	/dev/raw/raw40	4,919	1	2.41	1.01	706	0	0	0.00
BBGOA_LOB	/dev/raw/raw41	2,407	1	3.72	1.01	739	0	0	0.00
BBGOA_LOB	/dev/raw/raw42	2,483	1	3.78	1.01	683	0	0	0.00
BBGOA_LOB	/dev/raw/raw43	3,541	1	2.77	1.02	580	0	0	0.00
BBGOA_LOB	/dev/raw/raw44	2,447	1	4.01	1.00	945	0	0	0.00
BBGOA_LOB	/dev/raw/raw45	3,755	1	3.46	1.01	1,012	0	0	0.00
BBGOA_LOB	/dev/raw/raw46	2,976	1	3.87	1.00	675	0	0	0.00
BBGOA_LOB	/dev/raw/raw47	2,991	1	4.22	1.00	576	0	0	0.00
BBGOA_LOB	/dev/raw/raw48	2,997	1	4.15	1.00	811	0	0	0.00
BBGOA_LOB	/dev/raw/raw49	3,281	1	3.80	1.00	801	0	1	0.00
BBGOA_LOB	/dev/raw/raw50	3,434	1	4.14	1.00	1,061	0	0	0.00
BBGOA_LOB	/dev/raw/raw51	2,066	1	2.60	1.01	143	0	3	0.00
BBGOA_LOB	/dev/raw/raw52	1,852	1	2.78	1.00	171	0	0	0.00
BBGOA_LOB	/dev/raw/raw53	3,992	1	1.98	1.03	110	0	0	0.00
BBGOA_LOB	/dev/raw/raw54	1,442	0	4.02	1.02	58	0	0	0.00
BBGOA_LOB	/dev/raw/raw55	3,586	1	2.66	1.04	32	0	0	0.00
BBGOA_LOB	/dev/raw/raw56	1,919	1	3.69	1.02	77	0	0	0.00
BBGOA_LOB	/dev/raw/raw57	1,170	0	4.73	1.01	62	0	0	0.00
BBGOA_LOB	/dev/raw/raw58	1,922	1	4.01	1.00	465	0	0	0.00
BBGOA_LOB	/dev/raw/raw59	1,905	1	3.62	1.02	404	0	0	0.00
BBGOA_LOB	/dev/raw/raw60	1,656	0	4.12	1.00	518	0	0	0.00
BBGOA_LOB	/dev/raw/raw61	1,746	0	3.04	1.01	107	0	0	0.00
BBGOA_LOB	/dev/raw/raw62	2,566	1	2.23	1.04	142	0	0	0.00
BBGOA_LOB	/dev/raw/raw63	3,038	1	1.91	1.02	192	0	1	10.00
BBGOA_LOB	/dev/raw/raw64	4,068	1	1.79	1.02	511	0	0	0.00
BBGOA_LOB	/dev/raw/raw65	2,935	1	2.00	1.05	68	0	0	0.00
BBGOA_LOB	/dev/raw/raw66	4,682	1	2.50	1.00	677	0	0	0.00
BBGOA_LOB	/dev/raw/raw67	2,127	1	3.49	1.04	590	0	1	0.00
BBGOA_LOB	/dev/raw/raw68	5,899	2	1.71	1.03	530	0	0	0.00
BBGOA_LOB	/dev/raw/raw69	4,392	1	1.77	1.04	542	0	0	0.00
BBGOA_LOB	/dev/raw/raw70	7,858	2	1.31	1.03	666	0	0	0.00
BBGOA_LOB	/dev/raw/raw71	3,823	1	2.63	1.01	598	0	0	0.00
BBGOA_LOB	/dev/raw/raw72	5,663	2	2.00	1.01	928	0	0	0.00
BBGOA_LOB	/dev/raw/raw73	2,917	1	2.23	1.02	195	0	0	0.00
BBGOA_LOB	/dev/raw/raw74	2,450	1	2.70	1.01	239	0	0	0.00
BBGOA_LOB	/dev/raw/raw75	3,358	1	2.23	1.03	224	0	0	0.00
BBGOA_LOB	/dev/raw/raw76	1,885	1	3.19	1.01	363	0	3	0.00
BBGOA_LOB	/dev/raw/raw77	3,791	1	2.06	1.01	331	0	0	0.00
BBGOA_LOB	/dev/raw/raw78	2,463	1	2.58	1.03	245	0	0	0.00
BBGOA_LOB	/dev/raw/raw79	5,575	2	1.30	1.04	306	0	1	0.00
BBGOA_LOB	/dev/raw/raw80	2,863	1	2.27	1.02	251	0	23	0.00
BBGOA_LOB	/dev/raw/raw81	8,711	2	0.93	1.06	350	0	21	0.48
BBGOA_LOB	/dev/raw/raw82	2,080	1	2.97	1.02	159	0	0	0.00
BBGOA_LOB	/dev/raw/raw83	3,171	1	2.04	1.02	348	0	0	0.00
BBGOA_LOB	/dev/raw/raw84	3,950	1	2.01	1.05	254	0	0	0.00
BBGOA_LOB	/dev/raw/raw85	4,788	1	1.83	1.03	204	0	0	0.00
BBGOA_LOB	/dev/raw/raw86	3,362	1	2.28	1.02	205	0	0	0.00
BBGOA_LOB	/dev/raw/raw87	3,052	1	2.21	1.02	235	0	0	0.00
BBGOA_LOB	/dev/raw/raw88	4,629	1	1.81	1.02	201	0	0	0.00
BBGOA_LOB	/dev/raw/raw89	3,462	1	1.93	1.08	244	0	2	0.00
BBGOA_LOB	/dev/raw/raw91	3,527	1	1.93	1.02	259	0	0	0.00
BBGOA_LOB	/dev/raw/raw92	3,312	1	2.08	1.02	173	0	0	0.00
BBGOA_LOB	/dev/raw/raw93	16,962	5	1.22	1.04	202	0	0	0.00
BBGOA_LOB	/dev/raw/raw94	9,917	3	1.23	1.02	385	0	0	0.00
BBGOA_LOB	/dev/raw/raw95	8,482	2	1.46	1.01	235	0	0	0.00
BBGOA_LOB	/dev/raw/raw96	5,601	2	1.47	1.01	326	0	0	0.00
BBGOA_LOB	/dev/raw/raw97	7,406	2	1.24	1.02	159	0	0	0.00
BBGOA_LOB	/dev/raw/raw98	5,890	2	1.34	1.03	280	0	0	0.00
BBGOA_LOB	/dev/raw/raw99	3,022	1	2.18	1.01	347	0	0	0.00
JDXX	/dev/raw/raw216	20	0	37.50	1.00	5	0	0	0.00
JDXX	/dev/raw/raw217	20	0	37.00	1.00	5	0	0	0.00
NEWOA_DATA	/dev/raw/raw226	25	0	28.40	1.00	5	0	0	0.00
NEWOA_DATA	/dev/raw/raw227	25	0	28.40	1.00	5	0	0	0.00
NEWOA_DATA	/dev/raw/raw228	25	0	27.60	1.00	5	0	0	0.00
NEWOA_DATA	/dev/raw/raw229	25	0	28.40	1.00	5	0	0	0.00
NEWOA_DATA	/dev/raw/raw230	25	0	28.80	1.00	5	0	0	0.00
NEWOA_IND	/dev/raw/raw231	25	0	29.20	1.00	5	0	0	0.00
NEWOA_IND	/dev/raw/raw232	25	0	30.00	1.00	5	0	0	0.00
NEWOA_IND	/dev/raw/raw233	25	0	29.20	1.00	5	0	0	0.00
NEWOA_IND	/dev/raw/raw234	25	0	28.80	1.00	5	0	0	0.00
NEWOA_IND	/dev/raw/raw235	25	0	30.00	1.00	5	0	0	0.00
NEWOA_LOB	/dev/raw/raw236	25	0	30.40	1.00	5	0	0	0.00
NEWOA_LOB	/dev/raw/raw237	25	0	32.40	1.00	5	0	0	0.00
NEWOA_LOB	/dev/raw/raw238	25	0	30.40	1.00	5	0	0	0.00
NEWOA_LOB	/dev/raw/raw239	25	0	30.40	1.00	5	0	0	0.00
NEWOA_LOB	/dev/raw/raw240	25	0	31.20	1.00	5	0	0	0.00
SYSAUX	/dev/raw/raw9	1,302	0	3.10	1.15	776	0	0	0.00
SYSTEM	/dev/raw/raw10	1,998	1	3.11	1.63	130	0	0	0.00
TB_OFFICE_DATA	/dev/raw/raw14	7,423	2	1.52	1.02	1,881	1	0	0.00
TB_OFFICE_DATA	/dev/raw/raw15	6,883	2	1.50	1.02	1,379	0	0	0.00
TB_OFFICE_DATA	/dev/raw/raw16	6,217	2	1.49	1.02	1,145	0	0	0.00
TB_OFFICE_DATA	/dev/raw/raw17	7,133	2	1.22	1.04	977	0	0	0.00
TB_OFFICE_DATA	/dev/raw/raw18	25,185	7	0.55	1.04	916	0	0	0.00
TB_OFFICE_DATA	/dev/raw/raw19	25,128	7	0.54	1.02	1,100	0	0	0.00
TB_OFFICE_DATA	/dev/raw/raw20	9,960	3	0.99	1.01	931	0	0	0.00
TEMP	/dev/raw/raw11	0	0			1	0	0
T_BBGOA	/dev/raw/raw105	102	0	9.41	1.00	332	0	0
UNDOTBS1	/dev/raw/raw12	24	0	3.75	1.00	543	0	12	0.00
UNDOTBS1	/dev/raw/raw90	22	0	30.00	1.00	330	0	0	0.00
USERS	/dev/raw/raw13	5	0	18.00	1.00	5	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	231,428	99	31,682,417	228,770	51,929	0	0	94

Advisory Statistics

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

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	13	5419	216727	693884	737280	693884
E	0	11	2166	54720	737280	737280	763130

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	176	0.09	21,769	5.48	15,990,632
D	352	0.19	43,538	4.19	12,229,663
D	528	0.28	65,307	3.28	9,570,431
D	704	0.38	87,076	2.64	7,712,181
D	880	0.47	108,845	2.19	6,380,803
D	1,056	0.56	130,614	1.85	5,390,802
D	1,232	0.66	152,383	1.59	4,625,097
D	1,408	0.75	174,152	1.38	4,014,084
D	1,584	0.85	195,921	1.21	3,520,396
D	1,760	0.94	217,690	1.07	3,125,871
D	1,872	1.00	231,543	1.00	2,917,225
D	1,936	1.03	239,459	0.96	2,798,162
D	2,112	1.13	261,228	0.86	2,512,798
D	2,288	1.22	282,997	0.78	2,289,420
D	2,464	1.32	304,766	0.72	2,090,064
D	2,640	1.41	326,535	0.65	1,908,693
D	2,816	1.50	348,304	0.60	1,747,849
D	2,992	1.60	370,073	0.55	1,604,797
D	3,168	1.69	391,842	0.51	1,479,455
D	3,344	1.79	413,611	0.47	1,364,063
D	3,520	1.88	435,380	0.43	1,255,449

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	1,926	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	512	392	202.70	0.00	0.00	0.00	0.00	102,400
E	512	393	201.87	0.00	0.00	0.00	0.00	102,400

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	26,457	26,457
64K	128K	3,078	3,078
128K	256K	1,493	1,493
256K	512K	1,349	1,349
512K	1024K	119	119
1M	2M	668	668

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
64	0.13	19,354.22	378.69	98.00	617
128	0.25	19,354.22	0.00	100.00	9
256	0.50	19,354.22	0.00	100.00	0
384	0.75	19,354.22	0.00	100.00	0
512	1.00	19,354.22	0.00	100.00	0
614	1.20	19,354.22	0.00	100.00	0
717	1.40	19,354.22	0.00	100.00	0
819	1.60	19,354.22	0.00	100.00	0
922	1.80	19,354.22	0.00	100.00	0
1,024	2.00	19,354.22	0.00	100.00	0
1,536	3.00	19,354.22	0.00	100.00	0
2,048	4.00	19,354.22	0.00	100.00	0
3,072	6.00	19,354.22	0.00	100.00	0
4,096	8.00	19,354.22	0.00	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
256	0.40	67	9,302	83,416	0.65	45,570	44.16	3,019,591
320	0.50	130	13,704	89,033	0.70	39,953	38.71	3,033,378
384	0.60	193	19,695	94,649	0.74	34,337	33.27	3,047,117
448	0.70	256	25,660	100,350	0.78	28,636	27.75	3,059,117
512	0.80	319	29,494	105,754	0.83	23,232	22.51	3,069,966
576	0.90	382	33,080	122,955	0.96	6,031	5.84	3,079,916
640	1.00	445	36,903	127,954	1.00	1,032	1.00	3,088,937
704	1.10	508	41,150	132,614	1.04	1	0.00	3,097,062
768	1.20	570	45,586	136,168	1.06	1	0.00	3,104,031
832	1.30	633	50,129	139,007	1.09	1	0.00	3,110,201
896	1.40	696	54,602	141,285	1.10	1	0.00	3,115,866
960	1.50	759	59,207	143,138	1.12	1	0.00	3,121,075
1,024	1.60	822	64,166	144,690	1.13	1	0.00	3,125,875
1,088	1.70	885	69,475	146,049	1.14	1	0.00	3,130,116
1,152	1.80	948	73,910	147,435	1.15	1	0.00	3,134,152
1,216	1.90	1,011	78,814	148,876	1.16	1	0.00	3,137,993
1,280	2.00	1,074	83,260	150,365	1.18	1	0.00	3,141,714

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
640	0.25	139,096	12,229,712
1,280	0.50	76,959	9,570,343
1,920	0.75	49,536	4,625,014
2,560	1.00	38,640	2,917,254
3,200	1.25	33,876	2,090,212
3,840	1.50	30,359	1,479,340
4,480	1.75	29,069	1,255,586
5,120	2.00	29,069	1,255,586

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Avg Time (ms)
data block	32	3
1st level bmb	37	0
2nd level bmb	13	0
undo header	12	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
HW-Segment High Water Mark	33,518	33,224	294	944	3	3.28
TX-Transaction (index contention)	132	132	0	2	0	15.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	7.98	60,292	138	6	5760/5760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
18-5月 18:00	987	6,834	0	4	5,760	0/0	0/0/0/0/0/0
18-5月 17:50	1,075	6,812	138	4	5,760	0/0	0/0/0/0/0/0
18-5月 17:40	910	7,101	0	3	5,760	0/0	0/0/0/0/0/0
18-5月 17:30	647	5,017	0	4	5,760	0/0	0/0/0/0/0/0
18-5月 17:20	1,160	7,284	19	4	5,760	0/0	0/0/0/0/0/0
18-5月 17:10	1,222	9,963	66	5	5,760	0/0	0/0/0/0/0/0
18-5月 17:00	1,981	17,281	84	6	5,760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,401	0.00		0
AWR Alerted Metric Element list	22,501	0.00		0
Consistent RBA	15,318	0.01	0.00	0
FAL request queue	80	0.00		0
FAL subheap alocation	80	0.00		0
FIB s.o chain latch	116	0.00		0
FOB s.o list latch	12,196	0.23	0.00	0
In memory undo latch	81,117	0.00		15,005	0.00
JS queue state obj latch	21,600	0.00		0
KMG MMAN ready and startup request latch	1,313	0.00		0
KMG resize request state object freelist	38	0.00		0
KTF sga latch	7	0.00		1,166	0.00
MQL Tracking Latch	0			72	0.00
Memory Management Latch	488	0.00		1,313	0.00
OS process	240	0.00		0
OS process allocation	1,359	0.00		0
OS process: request allocation	150	0.00		0
PL/SQL warning settings	1,002	0.00		0
SGA IO buffer pool latch	416	0.00		416	0.00
SQL memory manager latch	1	0.00		1,198	0.00
SQL memory manager workarea list latch	92,891	0.00		0
Shared B-Tree	128	0.00		0
active checkpoint queue latch	18,735	0.01	0.00	0
active service list	6,986	0.06	1.00	1,235	0.00
archive control	83	0.00		0
archive process latch	1,366	0.00		0
begin backup scn array	69,720	0.00		0
buffer pool	121	0.00		0
cache buffer handles	614	0.00		0
cache buffers chains	60,720,423	0.04	0.01	346,544	0.00
cache buffers lru chain	224,348	0.26	0.01	317,535	0.12
cache table scan latch	0			292	0.00
channel handle pool latch	220	0.00		0
channel operations parent latch	21,748	0.01	0.00	0
checkpoint queue latch	282,411	0.00	0.00	75,408	0.01
client/application info	2,452	0.00		0
compile environment latch	134	0.00		0
dml lock allocation	62,530	0.01	0.00	0
dummy allocation	270	0.00		0
enqueue hash chains	487,205	0.01	0.00	453	0.00
enqueues	331,438	0.01	0.03	0
event group latch	74	0.00		0
file cache latch	8,234	0.00		0
global KZLD latch for mem in SGA	72	0.00		0
hash table column usage latch	674	0.00		275,692	0.00
hash table modification latch	65	0.00		0
job workq parent latch	0			120	0.00
job_queue_processes parameter latch	120	0.00		0
kks stats	128,960	0.03	0.08	0
kokc descriptor allocation latch	348	0.00		0
ksuosstats global area	242	0.00		0
ktm global data	31	0.00		0
kwqbsn:qsga	128	0.00		0
lgwr LWN SCN	15,325	0.05	0.00	0
library cache	1,438,379	0.05	0.07	100,498	0.04
library cache load lock	2,380	0.00		0
library cache lock	477,597	0.06	0.08	0
library cache lock allocation	7,233	0.04	0.00	0
library cache pin	313,801	0.00	0.00	0
library cache pin allocation	1,150	0.00		0
list of block allocation	1,909	0.16	0.00	0
loader state object freelist	827,812	0.04	0.01	0
message pool operations parent latch	114	0.00		0
messages	104,735	0.01	0.00	0
mostly latch-free SCN	15,473	0.58	0.00	0
multiblock read objects	948	0.00		0
ncodef allocation latch	58	0.00		0
object queue header heap	38,282	0.00		869	0.00
object queue header operation	759,741	0.01	0.05	29,358	0.03
object stats modification	6	0.00		0
parallel query alloc buffer	480	0.00		0
parameter list	189	0.00		0
parameter table allocation management	174	2.30	0.00	0
post/wait queue	18,482	0.00		12,355	0.00
process allocation	150	0.00		74	0.00
process group creation	150	0.00		0
qmn task queue latch	512	0.00		0
redo allocation	76,720	0.05	0.00	460,320	0.03
redo copy	0			460,370	0.03
redo writing	67,349	0.00		0
resmgr group change latch	442	0.00		0
resmgr:active threads	267	0.00		0
resmgr:actses change group	132	0.00		0
resmgr:free threads list	266	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	3,656,728	0.08	0.00	1,294	0.00
sequence cache	2,522	0.00		0
session allocation	235,103	0.00	0.25	0
session idle bit	2,140,537	0.00	0.00	0
session state list latch	580	0.00		0
session switching	58	0.00		0
session timer	1,235	0.00		0
shared pool	1,191,718	0.18	0.09	0
shared pool sim alloc	63	0.00		0
shared pool simulator	1,291,221	0.00	0.00	0
simulator hash latch	1,863,592	0.00	0.00	0
simulator lru latch	50,771	0.05	0.09	1,804,636	0.10
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	514	0.00		0
state object free list	2	0.00		0
statistics aggregation	336	0.00		0
temp lob duration state obj allocation	68	0.00		0
threshold alerts latch	455	0.00		0
transaction allocation	684,223	0.00		0
transaction branch allocation	1,235	0.00		0
undo global data	219,558	0.00	0.13	0
user lock	414	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
cache buffers chains	60,720,423	23,352	162	23,190
row cache objects	3,656,728	3,030	4	3,026
shared pool	1,191,718	2,105	199	1,906
library cache	1,438,379	721	50	673
cache buffers lru chain	224,348	588	4	584
loader state object freelist	827,812	338	3	335
library cache lock	477,597	293	23	271
object queue header operation	759,741	41	2	39
enqueues	331,438	39	1	38
kks stats	128,960	39	3	36
simulator lru latch	50,771	23	2	21
undo global data	219,558	8	1	7
active service list	6,986	4	4	0
session allocation	235,103	4	1	3
slave class create	8	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
active service list	ksws_event: ksws event	4	4
cache buffers chains	kcbgtcr: kslbegin excl	146	70
cache buffers chains	kcbgcur: kslbegin	32	14
cache buffers chains	kcbget: pin buffer	30	7
cache buffers chains	kcbrls: kslbegin	22	78
cache buffers chains	kcbgtcr: fast path	12	7
cache buffers chains	kcbzwb	3	0
cache buffers chains	kcbzgb: scan from tail. nowait	2	0
cache buffers chains	kcbget: exchange	1	8
cache buffers lru chain	kcbzgws	4	0
enqueues	ksqdel	1	0
kks stats	kks stats alloc/free	3	3
library cache	kglobpn: child:	5	4
library cache	kglhdgc: child:	4	0
library cache	kgldti: 2child	3	0
library cache	kglLockCursor	1	7
library cache	kglhdgn: child:	1	8
library cache	kglpin	1	2
library cache	kglpndl: child: after processing	1	1
library cache lock	kgllkdl: child: cleanup	23	23
library cache lock	kgllkdl: child: no lock handle	16	16
loader state object freelist	kcblgs	2	2
loader state object freelist	kcblfs	1	1
object queue header operation	kcbo_ivbo	2	1
object queue header operation	kcbo_switch_cq	1	0
row cache objects	kqreqd	2	0
row cache objects	kqreqd: reget	1	0
row cache objects	kqrpre: find obj	1	4
session allocation	ksuxds: KSUSFCLC not set	1	0
session idle bit	ksupuc: clear busy	1	1
shared pool	kghalo	147	74
shared pool	kghupr1	23	78
shared pool	kghfrunp: alloc: wait	18	2
shared pool	kghfrunp: clatch: nowait	12	0
shared pool	kghalp	9	34
shared pool	kghfrunp: clatch: wait	6	6
shared pool	kgh: sim resz update	2	0
simulator lru latch	kcbs_free_granule_sim_buffers	2	0
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 33,550,664
Captured Segments account for 96.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
BBGOA	BBGOA_DATA	GWYD		TABLE	18,553,456	55.30
BBGOA	BBGOA_LOB	SYS_IL0000013794C00002$$	S_IL_P1815	INDEX PARTITION	3,895,408	11.61
BBGOA	BBGOA_LOB	SYS_LOB0000013794C00002$$	_LOB_P1813	LOB PARTITION	1,596,736	4.76
BBGOA	BBGOA_LOB	INBOX	P201205	TABLE PARTITION	1,119,392	3.34
BBGOA	BBGOA_LOB	SYS_IL0000013587C00006$$	S_IL_P1993	INDEX PARTITION	1,013,664	3.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 2,030,101
Captured Segments account for 91.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
BBGOA	BBGOA_LOB	SYS_LOB0000013794C00002$$	_LOB_P1813	LOB PARTITION	1,336,913	65.85
BBGOA	BBGOA_LOB	SYS_LOB0000013587C00006$$	_LOB_P1991	LOB PARTITION	290,380	14.30
BBGOA	BBGOA_LOB	OUTBOX		TABLE	44,267	2.18
BBGOA	TB_OFFICE_DATA	SYS_LOB0000013099C00006$$		LOB	34,587	1.70
BBGOA	BBGOA_LOB	INBOX	P201204	TABLE PARTITION	24,403	1.20

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
BBGOA	BBGOA_LOB	SYS_IL0000013587C00006$$	S_IL_P1993	INDEX PARTITION	5,121	76.71
BBGOA	BBGOA_LOB	IDX_INBOX_EMAILID		INDEX	65	0.97
BBGOA	BBGOA_DATA	PK_LOG1		INDEX	43	0.64
BBGOA	BBGOA_DATA	IDX_INBOX_USERID_EMAILID		INDEX	3	0.04
BBGOA	TB_OFFICE_DATA	IDX_INBOX_USERID_EMAILSIZE		INDEX	2	0.03

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
BBGOA	BBGOA_LOB	SYS_IL0000013587C00006$$	S_IL_P2038	INDEX PARTITION	1	100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
BBGOA	BBGOA_LOB	SYS_LOB0000013587C00006$$	_LOB_P1991	LOB PARTITION	49	64.47
BBGOA	BBGOA_LOB	SYS_IL0000013587C00006$$	S_IL_P1993	INDEX PARTITION	24	31.58
BBGOA	BBGOA_LOB	SYS_LOB0000013088C00006$$		LOB	1	1.32
BBGOA	BBGOA_LOB	TRASHBOX		TABLE	1	1.32

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_database_links	146	0.00	0	1
dc_files	74,390	0.00	0	215
dc_global_oids	5,524	0.40	0	28
dc_histogram_data	690,966	0.17	0	1,608
dc_histogram_defs	182,158	1.17	0	1,688
dc_object_grants	255	28.63	0	110
dc_object_ids	441,673	0.06	0	531
dc_objects	50,065	0.80	0	458
dc_profiles	132	0.00	0	1
dc_rollback_segments	2,574	0.00	0	102
dc_segments	142,644	0.41	10	509
dc_sequences	46	6.52	46	4
dc_tablespace_quotas	6	0.00	6	1
dc_tablespaces	13,186	0.00	0	14
dc_usernames	734	0.95	0	15
dc_users	74,812	0.01	0	56
outstanding_alerts	192	0.00	0	28

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,431	0.77	7,868	0.19	3	0
CLUSTER	44	0.00	71	1.41	1	0
INDEX	80	26.25	9,698	0.22	0	0
SQL AREA	74,572	62.67	277,775	29.64	4,714	29
TABLE/PROCEDURE	2,712	13.94	145,161	0.78	306	0
TRIGGER	439	0.23	3,135	0.06	1	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	124.22		2.04	4.60	22	31	61	61
	Freeable	71.88	0.00	1.50	2.07	10		48	48
	SQL	5.83	3.00	0.11	0.18	1	6	53	51
	PL/SQL	1.07	0.88	0.02	0.01	0	0	61	61
E	Other	123.80		2.10	4.67	22	31	59	59
	Freeable	71.63	0.00	1.49	2.07	10		48	48
	SQL	5.46	2.84	0.11	0.18	1	6	51	49
	PL/SQL	1.01	0.83	0.02	0.01	0	0	59	59

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,962,934,272
Fixed Size	2,086,352
Redo Buffers	14,688,256
Variable Size	704,645,680

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	CCursor	48.94	57.31	17.09
shared	Cursor Stats	13.71	13.71	0.00
shared	FileOpenBlock	11.00	11.00	0.00
shared	KGH: NO ACCESS	31.13	31.13	0.00
shared	PCursor	45.62	47.48	4.07
shared	db_block_hash_buckets	11.25	11.25	0.00
shared	free memory	241.66	226.18	-6.41
shared	kglsim heap	7.86	7.95	1.12
shared	kglsim object batch	14.39	14.54	1.02
shared	library cache	31.20	33.08	6.05
shared	private strands	7.68	7.68	0.00
shared	row cache	7.16	7.16	0.00
shared	sql area	128.00	130.10	1.64
	buffer_cache	1,872.00	1,872.00	0.00
	fixed_sga	1.99	1.99	0.00
	log_buffer	14.01	14.01	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/admin/bbgoa/adump
audit_trail	DB_EXTENDED
background_dump_dest	/oracle/admin/bbgoa/bdump
compatible	10.2.0.3.0
control_files	/dev/raw/raw5, /dev/raw/raw6, /dev/raw/raw7
core_dump_dest	/oracle/admin/bbgoa/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_files	500
db_name	bbgoa
db_recovery_file_dest	/Data/flash_recovery_area
db_recovery_file_dest_size	2147483648
job_queue_processes	10
log_archive_dest_1	LOCATION=/Databackup/arch1
log_archive_format	%t_%s_%r.dbf
open_cursors	2000
optimizer_mode	FIRST_ROWS
pga_aggregate_target	536870912
processes	500
remote_login_passwordfile	NONE
session_cached_cursors	100
sessions	555
sga_target	2684354560
sql_trace	FALSE
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/bbgoa/udump

End of Report

% Blocks changed per Read:	2.63	Recursive Call %:	22.38
Rollback per transaction %:	0.14	Rows per Sort:	65.12

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	104.57	In-memory Sort %:	100.00
Library Hit %:	81.18	Soft Parse %:	84.51
Execute to Parse %:	11.87	Latch Hit %:	99.96
Parse CPU to Parse Elapsd %:	95.16	% Non-Parse CPU:	95.09