Statspack 报告 实例分析
STATSPACK report for
Database DB Id Instance Inst Num Startup Time Release RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
1264805167 cuug 1 08-May-13 02:12 10.2.0.1.0 NO
Host Name: cuug Num CPUs: 1 Phys Memory (MB): 0
~~~~
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- -------------------
Begin Snap: 71 08-May-13 03:19:08 20 2.9
End Snap: 72 08-May-13 03:19:30 20 4.1
Elapsed: 0.37 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 32M Std Block Size: 8K
Shared Pool Size: 60M Log Buffer: 2,859K
Load Profile Per Second Per Transaction
~~~~~~~~~~~~ --------------- ---------------
Redo size: 45,632.18 1,003,908.00
Logical reads: 42,669.86 938,737.00
Block changes: 175.86 3,869.00
Physical reads: 635.95 13,991.00
Physical writes: 279.77 6,155.00
User calls: 0.14 3.00
Parses: 43.27 952.00
Hard parses: 3.64 80.00
Sorts: 34.95 769.00
Logons: 0.00 0.00
Executes: 94.59 2,081.00
Transactions: 0.05
% Blocks changed per Read: 0.41 Recursive Call %: 99.99
Rollback per transaction %: 0.00 Rows per Sort: 12.46
Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 98.51 In-memory Sort %: 100.00
Library Hit %: 85.95 Soft Parse %: 91.60
Execute to Parse %: 54.25 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 18.82 % Non-Parse CPU: 40.74
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 94.07 93.47
% SQL with executions>1: 76.42 88.02
% Memory for SQL w/exec>1: 89.02 94.78
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
db file sequential read 11,361 15 1 92.9
log file parallel write 13 1 56 4.6
CPU time 0 1.7
db file scattered read 166 0 0 .5
log file sync 1 0 27 .2
-------------------------------------------------------------
Host CPU (CPUs: 1)
~~~~~~~~ Load Average
Begin End User System Idle WIO WCPU
------- ------- ------- ------- ------- ------- --------
1.04 1.10 30.67 33.42 35.91
Note: There is a 82% discrepancy between the OS Stat total CPU time and
the total CPU time estimated by Statspack
OS Stat CPU time: 4(s) (BUSY_TIME + IDLE_TIME)
Statspack CPU time: 22(s) (Elapsed time * num CPUs in end snap)
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 60.98
% of busy CPU for Instance: 95.14
%DB time waiting for CPU - Resource Mgr:
Memory Statistics Begin End
~~~~~~~~~~~~~~~~~ ------------ ------------
Host Mem (MB): .0 .0
SGA use (MB): 104.0 104.0
PGA use (MB): 152.9 152.6
% Host Mem used for SGA+PGA: 4372413.5 4654204.0
-------------------------------------------------------------
Time Model System Stats DB/Inst: CUUG/cuug Snaps: 71-72
-> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % of DB time
----------------------------------- -------------------- ------------
sql execute elapsed time 3.7 99.3
RMAN cpu time (backup/restore) 2.2 58.1
parse time elapsed 1.4 36.7
hard parse elapsed time 1.4 36.5
DB CPU 0.2 6.2
repeated bind elapsed time 0.0 .1
PL/SQL execution elapsed time 0.0 .1
DB time 3.7
background elapsed time 18.3
background cpu time 2.2
-------------------------------------------------------------
Wait Events DB/Inst: CUUG/cuug Snaps: 71-72
-> s - second, cs - centisecond, ms - millisecond, us - microsecond
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
--------------------------------- ------------ ------ ---------- ------ --------
db file sequential read 11,361 0 15 1 ########
log file parallel write 13 0 1 56 13.0
db file scattered read 166 0 0 0 166.0
log file sync 1 0 0 27 1.0
control file sequential read 378 0 0 0 378.0
control file parallel write 6 0 0 0 6.0
Streams AQ: qmn slave idle wait 1 0 27 27346 1.0
Streams AQ: qmn coordinator idle 2 50 27 13673 2.0
jobq slave wait 5 100 15 2930 5.0
SQL*Net message from client 2 0 12 5794 2.0
-------------------------------------------------------------
Background Wait Events DB/Inst: CUUG/cuug Snaps: 71-72
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
--------------------------------- ------------ ------ ---------- ------ --------
log file parallel write 13 0 1 56 13.0
db file sequential read 4 0 0 24 4.0
control file parallel write 5 0 0 0 5.0
rdbms ipc message 85 60 181 2128 85.0
Streams AQ: qmn slave idle wait 1 0 27 27346 1.0
Streams AQ: qmn coordinator idle 2 50 27 13673 2.0
pmon timer 6 100 18 2930 6.0
-------------------------------------------------------------
Wait Event Histogram DB/Inst: CUUG/cuug Snaps: 71-72
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)
Total ----------------- % of Waits ------------------
Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
control file parallel writ 6 100.0
control file sequential re 378 99.7 .3
db file scattered read 166 98.2 1.2 .6
db file sequential read 11K 91.9 1.8 .8 1.3 2.3 1.3 .4
direct path write temp 134 100.0
log file parallel write 13 15.4 15.4 69.2
log file sync 1 100.0
SQL*Net message from clien 2 50.0 50.0
SQL*Net message to client 2 100.0
Streams AQ: qmn coordinato 2 50.0 50.0
Streams AQ: qmn slave idle 1 100.0
jobq slave wait 5 100.0
pmon timer 6 100.0
rdbms ipc message 86 3.5 1.2 57.0 38.4
-------------------------------------------------------------
SQL ordered by CPU DB/Inst: CUUG/cuug Snaps: 71-72
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 0
-> Captured SQL accounts for 112.3% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
0.22 1 0.22 95.7 3.71 7,874 2522684317
Module: sqlplus@cuug (TNS V1-V3)
BEGIN statspack.snap; END;
0.02 43 0.00 8.1 0.06 129 199663413
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$
where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
0.01 114 0.00 2.9 0.01 315 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2
0.00 67 0.00 2.1 0.00 280 2482976222
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where c
on#=:1
-------------------------------------------------------------
SQL ordered by Elapsed DB/Inst: CUUG/cuug Snaps: 71-72
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB Time (s): 4
-> Captured SQL accounts for 103.5% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
3.71 1 3.71 99.3 0.22 331 2522684317
Module: sqlplus@cuug (TNS V1-V3)
BEGIN statspack.snap; END;
0.06 43 0.00 1.6 0.02 20 199663413
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$
where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: CUUG/cuug Snaps: 71-72
-> End Disk Reads Threshold: 1000 Total Disk Reads: 13,991
-> Captured SQL accounts for 0.2% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads
CPU Elapsd Old
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
331 1 331.0 2.4 0.22 3.71 2522684317
Module: sqlplus@cuug (TNS V1-V3)
BEGIN statspack.snap; END;
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: CUUG/cuug Snaps: 71-72
-> End Executions Threshold: 100 Total Executions: 2,081
-> Captured SQL accounts for 18.0% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions
CPU per Elap per Old
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
114 87 0.8 0.00 0.00 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2
67 73 1.1 0.00 0.00 2482976222
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where c
on#=:1
43 584 13.6 0.00 0.00 199663413
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$
where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: CUUG/cuug Snaps: 71-72
-> End Parse Calls Threshold: 1000 Total Parse Calls: 952
-> Captured SQL accounts for 10.5% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls
% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
15 15 1.58 2018736380
select timestamp, flags from fixed_obj$ where obj#=:1
10 10 1.05 1198893840
select order#,columns,types from access$ where d_obj#=:1
10 10 1.05 1348827743
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#
,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N
VL(spare1,0),NVL(scanhint,0) from seg$ where ts#=:1 and file#=:2
and block#=:3
10 10 1.05 2062595902
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_
obj#, nvl(property,0),subname,d_attrs from dependency$ d, obj$ o
where d_obj#=:1 and p_obj#=obj#(+) order by order#
-------------------------------------------------------------
Instance Activity Stats DB/Inst: CUUG/cuug Snaps: 71-72
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
CPU used by this session 27 1.2 27.0
CPU used when call started 37 1.7 37.0
CR blocks created 2,641 120.1 2,641.0
DB time 1,168 53.1 1,168.0
DBWR checkpoint buffers written 2 0.1 2.0
DBWR checkpoints 0 0.0 0.0
DBWR revisited being-written buff 0 0.0 0.0
DBWR thread checkpoint buffers wr 0 0.0 0.0
DBWR transaction table writes 3 0.1 3.0
DBWR undo block writes 63 2.9 63.0
IMU Flushes 1 0.1 1.0
IMU Redo allocation size 5,940 270.0 5,940.0
IMU commits 0 0.0 0.0
IMU contention 0 0.0 0.0
IMU ktichg flush 0 0.0 0.0
IMU pool not allocated 0 0.0 0.0
IMU recursive-transaction flush 0 0.0 0.0
IMU undo allocation size 1,732 78.7 1,732.0
IMU- failed to get a private stra 0 0.0 0.0
SQL*Net roundtrips to/from client 2 0.1 2.0
active txn count during cleanout 38 1.7 38.0
application wait time 0 0.0 0.0
auto extends on undo tablespace 0 0.0 0.0
background checkpoints completed 0 0.0 0.0
background checkpoints started 0 0.0 0.0
background timeouts 51 2.3 51.0
buffer is not pinned count 3,073 139.7 3,073.0
buffer is pinned count 138 6.3 138.0
bytes received via SQL*Net from c 194 8.8 194.0
bytes sent via SQL*Net to client 160 7.3 160.0
calls to get snapshot scn: kcmgss 2,301 104.6 2,301.0
calls to kcmgas 13,512 614.2 13,512.0
calls to kcmgcs 17 0.8 17.0
change write time 0 0.0 0.0
cleanout - number of ktugct calls 2,686 122.1 2,686.0
cleanouts and rollbacks - consist 2,641 120.1 2,641.0
cleanouts only - consistent read 0 0.0 0.0
cluster key scan block gets 659 30.0 659.0
cluster key scans 528 24.0 528.0
commit batch/immediate performed 0 0.0 0.0
commit batch/immediate requested 0 0.0 0.0
commit cleanout failures: block l 0 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callbac 11 0.5 11.0
commit cleanout failures: cannot 0 0.0 0.0
commit cleanouts 138 6.3 138.0
commit cleanouts successfully com 127 5.8 127.0
commit immediate performed 0 0.0 0.0
commit immediate requested 0 0.0 0.0
commit txn count during cleanout 2,668 121.3 2,668.0
concurrency wait time 0 0.0 0.0
consistent changes 924,350 42,015.9 924,350.0
consistent gets 937,393 42,608.8 937,393.0
consistent gets - examination 930,142 42,279.2 930,142.0
consistent gets from cache 937,393 42,608.8 937,393.0
cursor authentications 20 0.9 20.0
Instance Activity Stats DB/Inst: CUUG/cuug Snaps: 71-72
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
data blocks consistent reads - un 924,381 42,017.3 924,381.0
db block changes 3,869 175.9 3,869.0
db block gets 1,344 61.1 1,344.0
db block gets direct 0 0.0 0.0
db block gets from cache 1,344 61.1 1,344.0
deferred (CURRENT) block cleanout 88 4.0 88.0
dirty buffers inspected 2,823 128.3 2,823.0
enqueue conversions 50 2.3 50.0
enqueue releases 356 16.2 356.0
enqueue requests 356 16.2 356.0
enqueue timeouts 0 0.0 0.0
enqueue waits 0 0.0 0.0
execute count 2,081 94.6 2,081.0
free buffer inspected 14,105 641.1 14,105.0
free buffer requested 16,705 759.3 16,705.0
global undo segment hints helped 0 0.0 0.0
heap block compress 462,175 21,008.0 462,175.0
hot buffers moved to head of LRU 153 7.0 153.0
immediate (CR) block cleanout app 2,641 120.1 2,641.0
immediate (CURRENT) block cleanou 44 2.0 44.0
index fast full scans (full) 0 0.0 0.0
index fetch by key 900 40.9 900.0
index scans kdiixs1 1,252 56.9 1,252.0
leaf node 90-10 splits 1 0.1 1.0
leaf node splits 19 0.9 19.0
lob reads 0 0.0 0.0
lob writes 0 0.0 0.0
lob writes unaligned 0 0.0 0.0
logons cumulative 0 0.0 0.0
messages received 60 2.7 60.0
messages sent 60 2.7 60.0
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 3,152 143.3 3,152.0
opened cursors cumulative 2,047 93.1 2,047.0
parse count (failures) 0 0.0 0.0
parse count (hard) 80 3.6 80.0
parse count (total) 952 43.3 952.0
parse time cpu 16 0.7 16.0
parse time elapsed 85 3.9 85.0
physical read IO requests 11,513 523.3 11,513.0
physical read bytes 114,614,272 5,209,739.6 ############
physical read total IO requests 11,891 540.5 11,891.0
physical read total bytes 120,807,424 5,491,246.6 ############
physical read total multi block r 166 7.6 166.0
physical reads 13,991 636.0 13,991.0
physical reads cache 13,991 636.0 13,991.0
physical reads cache prefetch 2,478 112.6 2,478.0
physical reads direct 0 0.0 0.0
physical reads direct temporary t 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 2,318 105.4 2,318.0
physical write bytes 50,421,760 2,291,898.2 ############
physical write total IO requests 351 16.0 351.0
physical write total bytes 51,716,096 2,350,731.6 ############
physical write total multi block 221 10.1 221.0
physical writes 6,155 279.8 6,155.0
Instance Activity Stats DB/Inst: CUUG/cuug Snaps: 71-72
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
physical writes direct 3,425 155.7 3,425.0
physical writes direct (lob) 0 0.0 0.0
physical writes direct temporary 3,425 155.7 3,425.0
physical writes from cache 2,730 124.1 2,730.0
physical writes non checkpoint 6,153 279.7 6,153.0
pinned buffers inspected 0 0.0 0.0
prefetch warmup blocks aged out b 0 0.0 0.0
prefetched blocks aged out before 0 0.0 0.0
process last non-idle time 0 0.0 0.0
recursive calls 30,662 1,393.7 30,662.0
recursive cpu usage 27 1.2 27.0
redo blocks written 2,048 93.1 2,048.0
redo buffer allocation retries 0 0.0 0.0
redo entries 3,310 150.5 3,310.0
redo log space requests 0 0.0 0.0
redo log space wait time 0 0.0 0.0
redo ordering marks 0 0.0 0.0
redo size 1,003,908 45,632.2 1,003,908.0
redo synch time 3 0.1 3.0
redo synch writes 1 0.1 1.0
redo wastage 3,208 145.8 3,208.0
redo write time 75 3.4 75.0
redo writer latching time 0 0.0 0.0
redo writes 13 0.6 13.0
rollback changes - undo records a 0 0.0 0.0
rollbacks only - consistent read 0 0.0 0.0
rows fetched via callback 170 7.7 170.0
session connect time 0 0.0 0.0
session cursor cache hits 1,316 59.8 1,316.0
session logical reads 938,737 42,669.9 938,737.0
session pga memory max 131,072 5,957.8 131,072.0
session uga memory 65,464 2,975.6 65,464.0
session uga memory max 65,464 2,975.6 65,464.0
shared hash latch upgrades - no w 12,128 551.3 12,128.0
sorts (memory) 769 35.0 769.0
sorts (rows) 9,578 435.4 9,578.0
sql area purged 0 0.0 0.0
summed dirty queue length 3,001 136.4 3,001.0
switch current to new buffer 0 0.0 0.0
table fetch by rowid 1,149 52.2 1,149.0
table fetch continued row 0 0.0 0.0
table scan blocks gotten 3,942 179.2 3,942.0
table scan rows gotten 468,744 21,306.6 468,744.0
table scans (long tables) 0 0.0 0.0
table scans (short tables) 40 1.8 40.0
total number of times SMON posted 0 0.0 0.0
transaction rollbacks 0 0.0 0.0
transaction tables consistent rea 0 0.0 0.0
transaction tables consistent rea 0 0.0 0.0
undo change vector size 280,852 12,766.0 280,852.0
user I/O wait time 1,435 65.2 1,435.0
user calls 3 0.1 3.0
user commits 1 0.1 1.0
workarea executions - optimal 339 15.4 339.0
write clones created in backgroun 0 0.0 0.0
write clones created in foregroun 0 0.0 0.0
Instance Activity Stats DB/Inst: CUUG/cuug Snaps: 71-72
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
-------------------------------------------------------------
Instance Activity Stats DB/Inst: CUUG/cuug Snaps: 71-72
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
--------------------------------- --------------- ---------------
logons current 20 20
opened cursors current 58 82
session cursor cache count 1,168 1,168
workarea memory allocated 3,183 1,600
-------------------------------------------------------------
Instance Activity Stats DB/Inst: CUUG/cuug Snaps: 71-72
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
--------------------------------- ------------------ ---------
log switches (derived) 0 .00
-------------------------------------------------------------
OS Statistics DB/Inst: CUUG/cuug Snaps: 71-72
-> ordered by statistic type (CPU use, Virtual Memory, Hardware Config), Name
Statistic Total
------------------------- ----------------------
BUSY_TIME 257
IDLE_TIME 144
NICE_TIME 0
SYS_TIME 134
USER_TIME 123
LOAD 1
NUM_CPUS 1
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: CUUG/cuug Snaps: 71-72
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
UNDOTBS1
453,024 20,592 5.3 1.0 545,073 24,776 72 14.6
USERS
95,911 4,360 13.4 4.8 388,899 17,677 130 1.7
SYSTEM
7,266 330 14.6 1.6 762 35 58 32.1
SYSAUX
2,018 92 27.0 1.3 934 42 0 0.0
PERF_TBS
663 30 2.7 1.0 519 24 0 0.0
UNDO_SMALL
353 16 0.0 1.0 350 16 0 0.0
TEMP
1 0 0.0 1.0 135 6 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: CUUG/cuug Snaps: 71-72
->Mx Rd Bkt: Max bucket time for single block read
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Mx Av
Av Rd Rd Av Av Buffer BufWt
Reads Reads/s (ms) Bkt Blks/Rd Writes Writes/s Waits (ms)
-------------- ------- ----- --- ------- ------------ -------- ---------- ------
PERF_TBS /u01/app/oracle/oradata/cuug/perf_tbs01.dbf
663 30 2.7 ### 1.0 519 24 0
SYSAUX /u01/app/oracle/oradata/cuug/sysaux01.dbf
2,018 92 27.0 1.3 934 42 0
SYSTEM /u01/app/oracle/oradata/cuug/system01.dbf
7,266 330 14.6 ### 1.6 762 35 58 32.1
TEMP /u01/app/oracle/oradata/cuug/temp01.dbf
1 0 0.0 1 1.0 135 6 0
UNDOTBS1 /u01/app/oracle/oradata/cuug/undotbs01.dbf
370,326 16,833 4.9 ### 1.0 492,042 22,366 72 14.6
/u01/app/oracle/oradata/cuug/undotbs02.dbf
82,698 3,759 7.4 64 1.0 53,031 2,411 0
UNDO_SMALL /u01/app/oracle/oradata/cuug/undo_small01.dbf
353 16 0.0 1.0 350 16 0
USERS /u01/app/oracle/oradata/cuug/users01.dbf
95,911 4,360 13.4 4.8 388,899 17,677 130 1.7
-------------------------------------------------------------
File Read Histogram Stats DB/Inst: CUUG/cuug Snaps: 71-72
->Number of single block reads in each time range
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
0 - 2 ms 2 - 4 ms 4 - 8 ms 8 - 16 ms 16 - 32 ms 32+ ms
------------ ------------ ------------ ------------ ------------ ------------
PERF_TBS /u01/app/oracle/oradata/cuug/perf_tbs01.dbf
187 12 38 32 22 6
SYSTEM /u01/app/oracle/oradata/cuug/system01.dbf
147 10 27 50 22 4
UNDOTBS1 /u01/app/oracle/oradata/cuug/undotbs01.dbf
10,390 98 135 227 137 48
/u01/app/oracle/oradata/cuug/undotbs02.dbf
0 0 0 0 0 1
TEMP /u01/app/oracle/oradata/cuug/temp01.dbf
1 0 0 0 0 0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: CUUG/cuug Snaps: 71-72
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
-> Buffers: the number of buffers. Units of K, M, G are divided by 1000
Free Writ Buffer
Pool Buffer Physical Physical Buffer Comp Busy
P Buffers Hit% Gets Reads Writes Waits Wait Waits
--- ------- ---- -------------- ------------ ----------- ------- ---- ----------
D 3992 99 950,946 14,200 2,794 0 0 0
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: CUUG/cuug Snaps: 71-72
-> B: Begin snapshot, E: End snapshot
Targt Estd Log File Log Ckpt Log Ckpt
MTTR MTTR Recovery Actual Target Size Timeout Interval
(s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
- ----- ----- ---------- --------- --------- ---------- --------- ------------
B 0 11 319 5317 184320 184320 440368
E 0 11 543 5166 184320 184320 516427
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: CUUG/cuug End Snap: 72
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Pool, Block Size, Buffers For Estimate
Est
Phys Estimated Est
Size for Size Buffers Read Phys Reads Est Phys % dbtime
P Est (M) Factr (thousands) Factr (thousands) Read Time for Rds
--- -------- ----- ------------ ------ -------------- ------------ --------
D 4 .1 0 1.1 988 4,246 73.1
D 8 .3 1 1.0 953 4,023 69.3
D 12 .4 1 1.0 946 3,978 68.5
D 16 .5 2 1.0 940 3,940 67.8
D 20 .6 2 1.0 933 3,895 67.1
D 24 .8 3 1.0 930 3,873 66.7
D 28 .9 3 1.0 928 3,863 66.5
D 32 1.0 4 1.0 928 3,860 66.4
D 36 1.1 4 1.0 928 3,859 66.4
D 40 1.3 5 1.0 928 3,859 66.4
D 44 1.4 5 1.0 927 3,858 66.4
D 48 1.5 6 1.0 927 3,857 66.4
D 52 1.6 6 1.0 927 3,857 66.4
D 56 1.8 7 1.0 927 3,856 66.4
D 60 1.9 7 1.0 927 3,855 66.4
D 64 2.0 8 1.0 926 3,851 66.3
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: CUUG/cuug Snaps: 71-72
-> B: Begin snap E: End snap (rows identified with B or E contain data
which is absolute i.e. not diffed over the interval)
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
-> 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 Cache Hit % W/A MB Processed Extra W/A MB Read/Written
--------------- ---------------- -------------------------
100.0 15 0
Warning: pga_aggregate_target was set too low for current workload, as this
value was exceeded during this interval. Use the PGA Advisory view
to help identify a different value for pga_aggregate_target.
%PGA %Auto %Man
PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
- --------- --------- ---------- ---------- ------ ------ ------ ----------
B 77 5 152.9 3.5 2.3 100.0 .0 2,191
E 77 5 152.6 1.6 1.1 100.0 .0 2,191
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: CUUG/cuug Snaps: 71-72
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
2K 4K 214 214 0 0
64K 128K 5 5 0 0
512K 1024K 20 20 0 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: CUUG/cuug End Snap: 72
-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
where Estd PGA Overalloc Count is 0
Estd Extra Estd PGA Estd PGA
PGA Target Size W/A MB W/A MB Read/ Cache Overalloc
Est (MB) Factr Processed Written to Disk Hit % Count
---------- ------- ---------------- ---------------- -------- ----------
19 0.3 45.8 0.0 100.0 3
39 0.5 45.8 0.0 100.0 3
58 0.8 45.8 0.0 100.0 2
77 1.0 45.8 0.0 100.0 2
92 1.2 45.8 0.0 100.0 0
108 1.4 45.8 0.0 100.0 0
123 1.6 45.8 0.0 100.0 0
139 1.8 45.8 0.0 100.0 0
154 2.0 45.8 0.0 100.0 0
231 3.0 45.8 0.0 100.0 0
308 4.0 45.8 0.0 100.0 0
462 6.0 45.8 0.0 100.0 0
616 8.0 45.8 0.0 100.0 0
-------------------------------------------------------------
Process Memory Summary Stats DB/Inst: CUUG/cuug Snaps: 71-72
-> 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
-> Num Procs or Allocs: For Begin/End snapshot lines, it is the number of
processes. For Category lines, it is the number of allocations
-> ordered by Begin/End snapshot, Alloc (MB) desc
Hist Num
Avg Std Dev Max Max Procs
Alloc Used Freeabl Alloc Alloc Alloc Alloc or
Category (MB) (MB) (MB) (MB) (MB) (MB) (MB) Allocs
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B -------- 152.9 88.5 11.9 6.9 12.6 51 81 22
Other 136.7 6.2 11.1 41 64 22
Freeable 11.9 .0 1.3 2.0 7 9
SQL 4.0 3.7 .3 1.0 4 10 9
PL/SQL .2 .1 .0 .0 0 0 20
E -------- 152.6 88.2 12.0 6.9 12.6 51 81 22
Other 136.3 6.2 11.1 41 64 22
Freeable 12.0 .0 1.3 2.0 7 9
SQL 4.0 3.7 .3 1.0 4 10 9
PL/SQL .2 .1 .0 .0 0 0 20
-------------------------------------------------------------
Top Process Memory (by component) DB/Inst: CUUG/cuug Snaps: 71-72
-> ordered by Begin/End snapshot, Alloc (MB) desc
Alloc Used Freeabl Max Hist Max
PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B 15 TNS V1-V3 --- 51.4 42.6 6.6 51.4 81.1
Other 41.1 41.1 64.4
Freeable 6.6 .0 6.6
SQL 3.7 3.6 3.7 10.1
PL/SQL .0 .0 .0 .0
6 LGWR -------- 25.7 12.1 .0 25.7 25.7
Other 25.7 25.7 25.7
PL/SQL .0 .0 .0 .0
16 ARC0 -------- 21.8 10.3 .0 21.8 21.8
Other 21.8 21.8 21.8
PL/SQL .0 .0 .0 .0
17 ARC1 -------- 21.8 10.3 .0 21.8 21.8
Other 21.8 21.8 21.8
PL/SQL .0 .0 .0 .0
24 TNS V1-V3 --- 9.3 4.3 .3 9.3 9.4
Other 9.0 9.0 9.1
Freeable .3 .0 .3
PL/SQL .0 .0 .0 .0
SQL .0 .0 .0 .0
5 DBW0 -------- 7.0 2.9 .9 7.0 7.1
Other 6.1 6.1 6.2
Freeable .9 .0 .9
PL/SQL .0 .0 .0 .0
20 TNS V1-V3 --- 3.4 1.1 1.2 3.4 3.4
Other 2.0 2.0 2.0
Freeable 1.2 .0 1.2
SQL .1 .1 .1 1.6
PL/SQL .0 .0 .0 .0
11 MMON -------- 2.3 1.0 1.0 2.3 2.3
Other 1.2 1.2 1.2
Freeable 1.0 .0 1.0
SQL .1 .0 .1 .9
PL/SQL .0 .0 .0 .0
10 CJQ0 -------- 1.5 .4 .9 1.5 1.5
Freeable .9 .0 .9
Other .6 .6 .6
SQL .1 .0 .1 .4
PL/SQL .0 .0 .0 .0
18 J000 -------- 1.5 .2 .1 1.5 1.5
Other 1.3 1.3 1.3
Freeable .1 .0 .1
PL/SQL .1 .0 .1 .1
SQL .0 .0 .0 .3
7 CKPT -------- 1.3 .3 .8 1.3 2.0
Freeable .8 .0 .8
Other .5 .5 1.2
SQL .0 .0 .0 .0
PL/SQL .0 .0 .0 .0
8 SMON -------- 1.2 .5 .2 1.2 1.2
Other 1.0 1.0 1.0
Freeable .2 .0 .2
SQL .1 .0 .1 .3
PL/SQL .0 .0 .0 .0
Top Process Memory (by component) DB/Inst: CUUG/cuug Snaps: 71-72
-> ordered by Begin/End snapshot, Alloc (MB) desc
Alloc Used Freeabl Max Hist Max
PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B 13 D000 -------- 1.2 .6 .0 1.2 1.2
Other 1.2 1.2 1.2
E 15 TNS V1-V3 --- 51.4 42.6 6.6 51.4 81.1
Other 41.1 41.1 64.4
Freeable 6.6 .0 6.6
SQL 3.7 3.6 3.7 10.1
PL/SQL .0 .0 .0 .0
6 LGWR -------- 25.7 12.1 .0 25.7 25.7
Other 25.7 25.7 25.7
PL/SQL .0 .0 .0 .0
16 ARC0 -------- 21.8 10.3 .0 21.8 21.8
Other 21.8 21.8 21.8
PL/SQL .0 .0 .0 .0
17 ARC1 -------- 21.8 10.3 .0 21.8 21.8
Other 21.8 21.8 21.8
PL/SQL .0 .0 .0 .0
24 TNS V1-V3 --- 9.3 4.3 .3 9.3 9.4
Other 9.0 9.0 9.1
Freeable .3 .0 .3
PL/SQL .0 .0 .0 .0
SQL .0 .0 .0 .0
5 DBW0 -------- 7.0 2.9 .9 7.0 7.1
Other 6.1 6.1 6.2
Freeable .9 .0 .9
PL/SQL .0 .0 .0 .0
20 TNS V1-V3 --- 3.1 .8 1.3 3.1 3.5
Other 1.6 1.6 1.6
Freeable 1.3 .0 1.3
SQL .1 .1 .1 1.6
PL/SQL .0 .0 .0 .0
11 MMON -------- 2.3 1.0 1.0 2.3 2.3
Other 1.2 1.2 1.2
Freeable 1.0 .0 1.0
SQL .1 .0 .1 .9
PL/SQL .0 .0 .0 .0
10 CJQ0 -------- 1.5 .4 .9 1.5 1.5
Freeable .9 .0 .9
Other .6 .6 .6
SQL .1 .0 .1 .4
PL/SQL .0 .0 .0 .0
18 J000 -------- 1.5 .2 .1 1.5 1.5
Other 1.3 1.3 1.3
Freeable .1 .0 .1
PL/SQL .1 .0 .1 .1
SQL .0 .0 .0 .3
7 CKPT -------- 1.3 .3 .8 1.3 2.0
Freeable .8 .0 .8
Other .5 .5 1.2
SQL .0 .0 .0 .0
PL/SQL .0 .0 .0 .0
8 SMON -------- 1.2 .5 .2 1.2 1.2
Other 1.0 1.0 1.0
Freeable .2 .0 .2
Top Process Memory (by component) DB/Inst: CUUG/cuug Snaps: 71-72
-> ordered by Begin/End snapshot, Alloc (MB) desc
Alloc Used Freeabl Max Hist Max
PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
E 8 SQL .1 .0 .1 .3
PL/SQL .0 .0 .0 .0
13 D000 -------- 1.2 .6 .0 1.2 1.2
Other 1.2 1.2 1.2
-------------------------------------------------------------
Latch Activity DB/Inst: CUUG/cuug Snaps: 71-72
->"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
Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
Consistent RBA 12 0.0 0 0
FAL request queue 1 0.0 0 0
FAL subheap alocation 1 0.0 0 0
In memory undo latch 13 0.0 0 4 0.0
JS queue state obj latch 108 0.0 0 0
KMG MMAN ready and start 5 0.0 0 0
KTF sga latch 0 0 4 0.0
KWQP Prop Status 1 0.0 0 0
MQL Tracking Latch 0 0 2 0.0
Memory Management Latch 0 0 5 0.0
OS process allocation 5 0.0 0 0
PL/SQL warning settings 1 0.0 0 0
SGA IO buffer pool latch 61 0.0 0 61 0.0
SQL memory manager latch 30 0.0 0 5 0.0
SQL memory manager worka 2,411 0.0 0 0
Shared B-Tree 4 0.0 0 0
active checkpoint queue 42 0.0 0 0
active service list 30 0.0 0 6 0.0
archive control 1 0.0 0 0
archive process latch 6 0.0 0 0
cache buffer handles 10 0.0 0 0
cache buffers chains 2,830,707 0.0 0 19,082 0.0
cache buffers lru chain 24,928 0.0 0 2,633 0.0
cache table scan latch 0 0 165 0.0
channel operations paren 70 0.0 0 0
checkpoint queue latch 2,998 0.0 0 2,861 0.0
compile environment latc 2 0.0 0 0
dml lock allocation 126 0.0 0 0
enqueue hash chains 754 0.0 0 14 0.0
enqueues 544 0.0 0 0
hash table column usage 0 0 2,602 0.0
hash table modification 25 0.0 0 0
kks stats 152 0.0 0 0
ksuosstats global area 3 0.0 0 0
kwqbsn:qsga 4 0.0 0 0
lgwr LWN SCN 12 0.0 0 0
library cache 12,369 0.0 0 121 0.0
library cache load lock 796 0.0 0 0
library cache lock 4,436 0.0 0 0
library cache lock alloc 69 0.0 0 0
library cache pin 6,734 0.0 0 0
library cache pin alloca 73 0.0 0 0
list of block allocation 9 0.0 0 0
messages 252 0.0 0 0
mostly latch-free SCN 12 0.0 0 0
multiblock read objects 330 0.0 0 0
object queue header heap 87 0.0 0 108 0.0
object queue header oper 36,490 0.0 0 0
object stats modificatio 97 0.0 0 0
parallel query alloc buf 4 0.0 0 0
Latch Activity DB/Inst: CUUG/cuug Snaps: 71-72
->"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
Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
post/wait queue 1 0.0 0 1 0.0
qmn task queue latch 4 0.0 0 0
redo allocation 32 0.0 0 3,329 0.0
redo copy 0 0 3,329 0.0
redo writing 101 0.0 0 0
resmgr:actses active lis 1 0.0 0 0
resmgr:schema config 1 0.0 0 0
row cache objects 10,818 0.0 0 277 0.0
rules engine rule set st 100 0.0 0 0
sequence cache 3 0.0 0 0
session allocation 56,707 0.0 0 0
session idle bit 9 0.0 0 0
session timer 6 0.0 0 0
shared pool 10,108 0.0 0 0
simulator hash latch 10,534 0.0 0 0
simulator lru latch 5,851 0.0 0 4,295 0.0
sort extent pool 27 0.0 0 0
threshold alerts latch 1 0.0 0 0
undo global data 926,814 0.0 0 0
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: CUUG/cuug Snaps: 71-72
-> End Segment Logical Reads Threshold: 10000
-> Pct Total shows % of logical reads for each top segment compared with total
logical reads for all segments captured by the Snapshot
Subobject Obj. Logical Pct
Owner Tablespace Object Name Name Type Reads Total
---------- ---------- -------------------- ------------ ----- ------------ -----
SCOTT USERS EMP3 TABLE 1,008 100.0
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: CUUG/cuug Snaps: 71-72
->"Pct Misses" should be very low (< 2% in most cases)
->"Final Usage" is the number of cache entries being used in End Snapshot
Get Pct Scan Pct Mod Final
Cache Requests Miss Reqs Miss Reqs Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_histogram_data 435 56.1 0 0 930
dc_histogram_defs 1,337 55.7 0 0 1,781
dc_object_ids 387 12.9 0 0 638
dc_objects 459 30.3 0 0 674
dc_segments 158 31.6 0 0 294
dc_tablespaces 540 0.0 0 0 9
dc_usernames 98 0.0 0 0 13
dc_users 716 0.0 0 0 18
-------------------------------------------------------------
Library Cache Activity DB/Inst: CUUG/cuug Snaps: 71-72
->"Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
CLUSTER 3 0.0 9 0.0 0 0
SQL AREA 45 100.0 3,756 5.0 2 0
TABLE/PROCEDURE 517 22.6 1,388 38.5 7 0
-------------------------------------------------------------
Rule Sets DB/Inst: CUUG/cuug Snaps: 71-72
-> * indicates Rule Set activity (re)started between Begin/End snaps
-> Top 25 ordered by Evaluations desc
No-SQL SQL
Rule * Eval/sec Reloads/sec Eval % Eval %
----------------------------------- - ------------ ----------- ------ ------
SYS.ALERT_QUE_R 0 0 0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: CUUG/cuug End Snap: 72
-> 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
Est LC Est LC Est LC Est LC
Shared SP Est LC Time Time Load Load Est LC
Pool Size Size Est LC Saved Saved Time Time Mem
Size (M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
44 .7 8 1,639 223 1.0 90 1.1 20,017,313
52 .9 15 2,520 230 1.0 83 1.0 20,017,924
60 1.0 22 3,200 230 1.0 83 1.0 20,017,990
68 1.1 29 4,264 230 1.0 83 1.0 20,017,996
76 1.3 32 4,688 230 1.0 83 1.0 20,017,996
84 1.4 32 4,688 230 1.0 83 1.0 20,017,996
92 1.5 32 4,688 230 1.0 83 1.0 20,017,996
100 1.7 32 4,688 230 1.0 83 1.0 20,017,996
108 1.8 32 4,688 230 1.0 83 1.0 20,017,996
116 1.9 32 4,688 230 1.0 83 1.0 20,017,996
124 2.1 32 4,688 230 1.0 83 1.0 20,017,996
-------------------------------------------------------------
SGA Memory Summary DB/Inst: CUUG/cuug Snaps: 71-72
End Size (Bytes)
SGA regions Begin Size (Bytes) (if different)
------------------------------ -------------------- --------------------
Database Buffers 33,554,432
Fixed Size 1,217,980
Redo Buffers 2,973,696
Variable Size 71,305,796
-------------------- --------------------
sum 109,051,904
-------------------------------------------------------------
SGA breakdown difference DB/Inst: CUUG/cuug Snaps: 71-72
-> Top 35 rows by size, ordered by Pool, Name (note rows with null values for
Pool column, or Names showing free memory are always shown)
-> Null 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 p free memory 4.0 4.0 0.00
large free memory 4.0 4.0 0.00
shared ASH buffers 2.0 2.0 0.00
shared CCursor 1.9 1.8 -2.22
shared FileOpenBlock .8 .8 0.00
shared Heap0: KGL 1.1 1.2 11.47
shared KCB Table Scan Buffer 3.8 3.8 0.00
shared KGLS heap 2.9 2.5 -15.03
shared KQR M PO 1.5 1.6 2.78
shared KSFD SGA I/O b 3.8 3.8 0.00
shared KSXR pending messages que .8 .8 0.00
shared KSXR receive buffers 1.0 1.0 0.00
shared KTI-UNDO 1.2 1.2 0.00
shared PCursor 1.2 1.1 -1.48
shared PL/SQL MPCODE 1.4 1.4 -0.28
shared event statistics per sess 1.3 1.3 0.00
shared free memory 3.6 3.9 10.13
shared kglsim hash table bkts 2.0 2.0 0.00
shared kks stbkt .9 .9 0.00
shared library cache 3.5 3.5 1.53
shared message pool freequeue .7 .7 0.00
shared private strands 1.1 1.1 0.00
shared row cache 3.6 3.6 0.00
shared sessions .8 .8 0.00
shared sql area 5.8 5.8 -0.46
buffer_cache 32.0 32.0 0.00
fixed_sga 1.2 1.2 0.00
log_buffer 2.8 2.8 0.00
-------------------------------------------------------------
SQL Memory Statistics DB/Inst: CUUG/cuug Snaps: 71-72
Begin End % Diff
-------------- -------------- --------------
Avg Cursor Size (KB): 39.21 41.02 4.41
Cursor to Parent ratio: 1.03 1.03 .11
Total Cursors: 490 474 -3.38
Total Parents: 475 459 -3.49
-------------------------------------------------------------
init.ora Parameters DB/Inst: CUUG/cuug Snaps: 71-72
End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
audit_file_dest /u01/app/oracle/admin/cuug/adump
background_dump_dest /u01/app/oracle/admin/cuug/bdump
compatible 10.2.0.1.0
control_files /u01/app/oracle/oradata/cuug/cont
core_dump_dest /u01/app/oracle/admin/cuug/cdump
db_block_size 8192
db_cache_size 33554432
db_domain
db_file_multiblock_read_count 16
db_name cuug
db_recovery_file_dest
db_recovery_file_dest_size 2147483648
dispatchers (PROTOCOL=TCP) (SERVICE=cuugXDB)
java_pool_size 4194304
job_queue_processes 10
large_pool_size 4194304
log_archive_dest_1 location=/u01/app/oracle/oradata/
log_archive_format %t_%s_%r.arc
open_cursors 300
pga_aggregate_target 80740352
processes 150
remote_login_passwordfile EXCLUSIVE
sga_target 0
shared_pool_size 62914560
streams_pool_size 0
timed_statistics TRUE
undo_management AUTO
undo_tablespace UNDOTBS1
user_dump_dest /u01/app/oracle/admin/cuug/udump
-------------------------------------------------------------
End of Report ( sp_71_72.more )
