STATSPACK report for

DB Name     Instance    Instance #  Release     Parallel   Host               
----------  ----------  ----------  ----------  ---------  ----------         
V815        V815                 1  8.1.5.0.0   NO         dlsun418           
         -------------------------------------------------------------        

                                                                Snap Length   
Start Id   End  Id  Date       Time       Date       Time         (Mins)      
--------  --------  --------------------  --------------------  -----------   
       1         2  17-Aug-99 11:07:58    17-Aug-99 11:15:00           7.03   
         -------------------------------------------------------------        

Cache Sizes
~~~~~~~~~~~

           db_block_buffers:  5000                                            
              db_block_size:  2048                                            
                 log_buffer:  1024                                            
           shared_pool_size:  10000000                                        
                                                                              
         -------------------------------------------------------------        

Load Profile
~~~~~~~~~~~~

         Transactions / sec:           0.01                                   
            Redo size / sec:       3,232.68                                   
         Block visits / sec:          21.11                                   
        Block changes / sec:           6.54                                   
         Oracle reads / sec:           2.24                                   
               Writes / sec:           3.07                                   
           User calls / sec:           1.13                                   
               Parses / sec:           1.01                                   
          Hard parses / sec:           0.06                                   
                Sorts / sec:           0.18                                   
            Redo size / txn:     227,365.33                                   
         Block visits / txn:       1,485.00                                   
        Block changes / txn:         460.00                                   
         Oracle reads / txn:         157.33                                   
               Writes / txn:         215.83                                   
           User calls / txn:          79.50                                   
               Parses / txn:          71.33                                   
          Hard parses / txn:           4.33                                   
                Sorts / txn:          12.83                                   
         Recursive Call Pct:          91.83                                   
 Rollback / transaction Pct:           0.00                                   
 Pct Blocks changed / Visit:          30.98                                   
              Rows per Sort:         591.27                                   
                                                                              
         -------------------------------------------------------------        

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        Buffer Nowait Ratio:         100.00                                   
        Buffer  Hit   Ratio:          89.41                                   
        Library Hit   Ratio:          92.85                                   
        Redo   NoWait Ratio:         100.00                                   
       In-memory Sort Ratio:         100.00                                   
           Soft Parse Ratio:          93.93                                   
            Latch Hit Ratio:         100.00                                   
                                                                              
         -------------------------------------------------------------        

Top Wait Events
~~~~~~~~~~~~~~~

                                                                    % Wait    
Event                                           Waits    Wait Time    Time    
----------------------------------------  -----------  -----------  ------    
log file parallel write                            77          556  ######    
control file parallel write                       138          414  ######    
log buffer space                                   18           63  ######    
db file scattered read                            114           44  ######    
db file sequential read                            36           44  ######    
         -------------------------------------------------------------        
System Events for DB: V815  Instance: V815  Snaps    1  -   2                 
                                                                              
                                                                 Avg          
                                                                wait     Waits
Event                              Waits Timeouts   Wait Time   (ms)      /txn
---------------------------- ----------- -------- ----------- ------ ---------
log file parallel write               77        0         556     72    12.833
control file parallel write          138        0         414     30    23.000
log buffer space                      18        0          63     35     3.000
db file scattered read               114        0          44      4    19.000
db file sequential read               36        0          44     12     6.000
log file sync                         13        0          39     30     2.167
control file sequential read          43        0          20      5     7.167
refresh controlfile command            5        0           6     12     0.833
file open                              8        0           3      4     1.333
db file parallel write                 1        0           1     10     0.167
SQL*Net message to client            478        0           0      0    79.667
direct path write                     10        0           0      0     1.667
SQL*Net break/reset to clien           8        0           0      0     1.333
SQL*Net more data to client            1        0           0      0     0.167
SQL*Net message from client          478        0      42,026    879    79.667
SQL*Net more data from clien          27        0           9      3     4.500
         -------------------------------------------------------------        
Background Wait Events for DB: V815  Instance: V815  Snaps    1  -   2        
                                                                              
                                                                 Avg          
                                                                wait     Waits
Event                              Waits Timeouts   Wait Time   (ms)      /txn
---------------------------- ----------- -------- ----------- ------ ---------
log file parallel write               76        0         547     72    12.667
control file parallel write          136        0         408     30    22.667
db file parallel write                 1        0           1     10     0.167
control file sequential read          15        0           0      0     2.500
rdbms ipc message                    451      405     308,801   6847    75.167
smon timer                             2        2      61,452 ######     0.333
pmon timer                           137      137      42,196   3080    22.833
         -------------------------------------------------------------        
SQL ordered by rows for DB: V815  Instance: V815  Snaps    1  -   2           
                                                                              
      Rows                Rows                                                
  Processed      Execs  per Exec  SQL statement                               
----------- ---------- ---------- ----------------------------------------    
         65          9       7.22 select name,intcol#,segcol#,type#,length    
         55         55       1.00 insert into seg$ (file#,block#,type#,ts#    
         24         58       0.41 select node,owner,name from syn$ where o    
         20         10       2.00 select owner#,name,namespace,remoteowner    
         19         10       1.90 select order#,columns,types from access$    
         18          2       9.00 select f.file#, f.block#, f.ts#, f.lengt    
         18         18       1.00 insert into col$(obj#,name,intcol#,segco    
         17         29       0.59 select obj#,type#,ctime,mtime,stime,stat    
         16         16       1.00 update seg$ set type#=:4,blocks=:5,exten    
         16         16       1.00 update tsq$ set blocks=:3,maxblocks=:4,g    
         11         11       1.00 select file# from file$ where ts#=:1        
         11         22       0.50 select file#,block#,length from uet$ whe    
         11         11       1.00 delete from fet$ where file#=:1 and bloc    
         11         11       1.00 insert into uet$ (segfile#,segblock#,ext    
         11         11       1.00 insert into fet$ (file#,block#,ts#,lengt    
          9          9       1.00 update obj$ set obj#=:6,type#=:7,ctime=:    
          8          8       1.00 select text from view$ where rowid=:1       
          6         11       0.55 select o.owner#,o.name,o.namespace,o.rem    
          6          6       1.00 select cols,audit$,textlength,intcols,pr    
          6          6       1.00 select grantee#,privilege#,nvl(col#,0),m    
          5          5       1.00 insert into obj$(owner#,name,namespace,o    
          5         10       0.50 select type#,blocks,extents,minexts,maxe    
          4          1       4.00 select i.obj#,i.ts#,i.file#,i.block#,i.i    
          4          4       1.00 select pos#,intcol#,col#,spare1 from ico    
          4          4       1.00 insert into icol$(obj#,bo#,intcol#,pos#,    
          1          1       1.00 select ts#,file#,block#,nvl(bobj#,0),nvl    
          0          1       0.00 select con#,obj#,rcon#,enabled,nvl(defer    
          0         11       0.00 select length from fet$ where file#=:1 a    
          0          6       0.00 select col#, grantee#, privilege#,max(nv    
          0          1       0.00 select local_tran_id, global_tran_fmt, g    
          0          3       0.00 select con#,type#,condlength,intcols,rob    
         -------------------------------------------------------------        
SQL ordered by gets for DB: V815  Instance: V815  Snaps    1  -   2           
                                                                              
                          Gets                                                
       Gets   Executes  per Exec  SQL statement                               
----------- ---------- ---------- ----------------------------------------    
      1,143         55      20.78 insert into seg$ (file#,block#,type#,ts#    
        204         18      11.33 insert into col$(obj#,name,intcol#,segco    
        140         58       2.41 select node,owner,name from syn$ where o    
        107         16       6.69 update seg$ set type#=:4,blocks=:5,exten    
         90         16       5.63 update tsq$ set blocks=:3,maxblocks=:4,g    
         82          2      41.00 select f.file#, f.block#, f.ts#, f.lengt    
         76         29       2.62 select obj#,type#,ctime,mtime,stime,stat    
         68         10       6.80 select owner#,name,namespace,remoteowner    
         66         22       3.00 select file#,block#,length from uet$ whe    
         66         11       6.00 delete from fet$ where file#=:1 and bloc    
         58         10       5.80 select order#,columns,types from access$    
         40          5       8.00 insert into obj$(owner#,name,namespace,o    
         39          9       4.33 update obj$ set obj#=:6,type#=:7,ctime=:    
         39         11       3.55 insert into uet$ (segfile#,segblock#,ext    
         33         11       3.00 select file# from file$ where ts#=:1        
         33         11       3.00 select length from fet$ where file#=:1 a    
         30         10       3.00 select type#,blocks,extents,minexts,maxe    
         28         11       2.55 select o.owner#,o.name,o.namespace,o.rem    
         27          9       3.00 select name,intcol#,segcol#,type#,length    
         22         11       2.00 insert into fet$ (file#,block#,ts#,lengt    
         20          8       2.50 select text from view$ where rowid=:1       
         20          4       5.00 insert into icol$(obj#,bo#,intcol#,pos#,    
         18          6       3.00 select cols,audit$,textlength,intcols,pr    
         18          6       3.00 select grantee#,privilege#,nvl(col#,0),m    
         16          4       4.00 select pos#,intcol#,col#,spare1 from ico    
         12          6       2.00 select col#, grantee#, privilege#,max(nv    
          6          3       2.00 select con#,type#,condlength,intcols,rob    
          5          1       5.00 select i.obj#,i.ts#,i.file#,i.block#,i.i    
          4          1       4.00 select local_tran_id, global_tran_fmt, g    
          3          1       3.00 select ts#,file#,block#,nvl(bobj#,0),nvl    
          1          1       1.00 select con#,obj#,rcon#,enabled,nvl(defer    
         -------------------------------------------------------------        
SQL ordered by reads/exec for DB: V815  Instance: V815  Snaps    1  -   2     
                                                                              
                         Reads                                                
      Reads   Executes  per Exec  SQL statement                               
----------- ---------- ---------- ----------------------------------------    
         10         58       0.17 select node,owner,name from syn$ where o    
          5          9       0.56 select name,intcol#,segcol#,type#,length    
          3          8       0.38 select text from view$ where rowid=:1       
          3         55       0.05 insert into seg$ (file#,block#,type#,ts#    
          3         10       0.30 select order#,columns,types from access$    
          2          6       0.33 select cols,audit$,textlength,intcols,pr    
          1          6       0.17 select grantee#,privilege#,nvl(col#,0),m    
          1          6       0.17 select col#, grantee#, privilege#,max(nv    
          1          9       0.11 update obj$ set obj#=:6,type#=:7,ctime=:    
          1          5       0.20 insert into obj$(owner#,name,namespace,o    
          1         10       0.10 select owner#,name,namespace,remoteowner    
          0          1       0.00 select con#,obj#,rcon#,enabled,nvl(defer    
          0         11       0.00 select file# from file$ where ts#=:1        
          0         18       0.00 insert into col$(obj#,name,intcol#,segco    
          0         16       0.00 update seg$ set type#=:4,blocks=:5,exten    
          0          4       0.00 select pos#,intcol#,col#,spare1 from ico    
          0         10       0.00 select type#,blocks,extents,minexts,maxe    
          0         16       0.00 update tsq$ set blocks=:3,maxblocks=:4,g    
          0          4       0.00 insert into icol$(obj#,bo#,intcol#,pos#,    
          0         11       0.00 insert into uet$ (segfile#,segblock#,ext    
          0          1       0.00 select local_tran_id, global_tran_fmt, g    
          0         29       0.00 select obj#,type#,ctime,mtime,stime,stat    
          0         11       0.00 insert into fet$ (file#,block#,ts#,lengt    
          0         11       0.00 select length from fet$ where file#=:1 a    
          0          1       0.00 select ts#,file#,block#,nvl(bobj#,0),nvl    
          0         11       0.00 delete from fet$ where file#=:1 and bloc    
          0         22       0.00 select file#,block#,length from uet$ whe    
          0          2       0.00 select f.file#, f.block#, f.ts#, f.lengt    
          0          3       0.00 select con#,type#,condlength,intcols,rob    
          0         11       0.00 select o.owner#,o.name,o.namespace,o.rem    
          0          1       0.00 select i.obj#,i.ts#,i.file#,i.block#,i.i    
         -------------------------------------------------------------        
Instance Activity Stats for DB: V815  Instance: V815  Snaps    1  -   2       
                                                                              
Statistic                              Begin -> End # per Second   # per Trans
-------------------------------------- ------------ ------------ -------------
CPU used when call started                      501          1.2          83.5
CR blocks created                                63          0.2          10.5
DBWR buffers scanned                              0          0.0           0.0
DBWR checkpoint buffers written                   0          0.0           0.0
DBWR checkpoints                                  0          0.0           0.0
DBWR free buffers found                           0          0.0           0.0
DBWR lru scans                                    1          0.0           0.2
DBWR make free requests                           1          0.0           0.2
DBWR summed scan depth                            0          0.0           0.0
DBWR transaction table writes                     0          0.0           0.0
DBWR undo block writes                            0          0.0           0.0
SQL*Net roundtrips to/from client               469          1.1          78.2
background checkpoints completed                  0          0.0           0.0
background checkpoints started                    0          0.0           0.0
background timeouts                             408          1.0          68.0
buffer is not pinned count                    4,322         10.2         720.3
buffer is pinned count                           39          0.1           6.5
bytes received via SQL*Net from client    1,681,122      3,983.7     280,187.0
bytes sent via SQL*Net to client             15,300         36.3       2,550.0
calls to get snapshot scn: kcmgss               662          1.6         110.3
calls to kcmgas                                  72          0.2          12.0
calls to kcmgcs                                  78          0.2          13.0
change write time                                75          0.2          12.5
cleanouts only - consistent read gets             2          0.0           0.3
cluster key scan block gets                     282          0.7          47.0
cluster key scans                               142          0.3          23.7
commit cleanout failures: block lost              2          0.0           0.3
commit cleanout failures: callback fai            4          0.0           0.7
commit cleanouts                                261          0.6          43.5
commit cleanouts successfully complete          255          0.6          42.5
consistent changes                               66          0.2          11.0
consistent gets                               5,231         12.4         871.8
cursor authentications                           23          0.1           3.8
data blocks consistent reads - undo re           66          0.2          11.0
db block changes                              2,760          6.5         460.0
db block gets                                 3,679          8.7         613.2
deferred (CURRENT) block cleanout appl          106          0.3          17.7
dirty buffers inspected                           0          0.0           0.0
enqueue releases                                361          0.9          60.2
enqueue requests                                361          0.9          60.2
execute count                                   479          1.1          79.8
free buffer inspected                             0          0.0           0.0
free buffer requested                         1,129          2.7         188.2
hot buffers moved to head of LRU                 25          0.1           4.2
immediate (CR) block cleanout applicat            2          0.0           0.3
immediate (CURRENT) block cleanout app          111          0.3          18.5
index fast full scans (full)                      0          0.0           0.0
leaf node splits                                 33          0.1           5.5
logons cumulative                                 3          0.0           0.5
logons current                                                                
messages received                                93          0.2          15.5
messages sent                                    92          0.2          15.3
no buffer to keep pinned count                    4          0.0           0.7
no work - consistent read gets                4,058          9.6         676.3
opened cursors cumulative                       381          0.9          63.5
opened cursors current                                                        
Instance Activity Stats for DB: V815  Instance: V815  Snaps    1  -   2       
                                                                              
Statistic                              Begin -> End # per Second   # per Trans
-------------------------------------- ------------ ------------ -------------
parse count (hard)                               26          0.1           4.3
parse count (total)                             428          1.0          71.3
parse time cpu                                   28          0.1           4.7
parse time elapsed                              121          0.3          20.2
physical reads                                  944          2.2         157.3
physical reads direct                             0          0.0           0.0
physical writes                               1,295          3.1         215.8
physical writes direct                        1,295          3.1         215.8
physical writes non checkpoint                1,295          3.1         215.8
prefetched blocks                               795          1.9         132.5
process last non-idle time             ############  2,656,780.6 #############
recovery array read time                          0          0.0           0.0
recovery array reads                              0          0.0           0.0
recovery blocks read                              0          0.0           0.0
recursive calls                               5,360         12.7         893.3
recursive cpu usage                             107          0.3          17.8
redo blocks written                           2,801          6.6         466.8
redo buffer allocation retries                   18          0.0           3.0
redo entries                                  1,893          4.5         315.5
redo log space requests                           0          0.0           0.0
redo log space wait time                          0          0.0           0.0
redo size                                 1,364,192      3,232.7     227,365.3
redo synch time                                  39          0.1           6.5
redo synch writes                                13          0.0           2.2
redo wastage                                 22,644         53.7       3,774.0
redo write time                                 551          1.3          91.8
redo writer latching time                         0          0.0           0.0
redo writes                                      78          0.2          13.0
rollback changes - undo records applie            0          0.0           0.0
rollbacks only - consistent read gets            63          0.2          10.5
rows fetched via callback                        54          0.1           9.0
sorts (memory)                                   77          0.2          12.8
sorts (rows)                                 45,528        107.9       7,588.0
switch current to new buffer                                                  
table fetch by rowid                            177          0.4          29.5
table fetch continued row                         4          0.0           0.7
table scan blocks gotten                      3,659          8.7         609.8
table scan rows gotten                       40,017         94.8       6,669.5
table scans (long tables)                         4          0.0           0.7
table scans (short tables)                       12          0.0           2.0
total file opens                                  8          0.0           1.3
transaction rollbacks                             0          0.0           0.0
user calls                                      477          1.1          79.5
user commits                                      6          0.0           1.0
write clones created in background                0          0.0           0.0
write clones created in foreground                9          0.0           1.5
         -------------------------------------------------------------        
Tablespace IO Summary for DB: V815  Instance: V815  Snaps    1  -   2         
                                                                              
                                    Avg Read                Tot Avg Wait      
Tablespace                    Reads     Time    Writes    Waits     Time      
------------------------- --------- -------- --------- -------- --------      
USERS                           114      0.4        48        0      0.0      
SYSTEM                           35      1.2         0        0      0.0      
         -------------------------------------------------------------        
File IO Statistics for DB: V815  Instance: V815  Snaps    1  -   2            
                                                                              
Tablespace               Filename                                             
------------------------ ---------------------------------------------------- 
       Reads Avg Blks Avg Time     Writes Avg Time   Waits Avg Time           
------------ -------- -------- ---------- -------- ------- --------           
SYSTEM                   /private/8.1.5/dbs/systv815.dbf                      
          35      1.0      1.2          0                0                    
                                                                              
USERS                    /private/8.1.5/dbs/usrs01.dbf                        
         114      8.0      0.4         48   ######       0                    
                                                                              
         -------------------------------------------------------------        
Rollback Segment Activity for DB: V815  Instance: V815  Snaps    1  -   2     
->A high value for "Pct Waits" suggests more rollback segments may be required
                                                                              
Segment Trans Table     Pct  Undo Bytes                                       
  No       Gets       Waits   Written       Wraps  Shrinks  Extends           
------- ----------- ------- ------------ -------- -------- --------           
      0         3.0    0.00            0        0        0        0           
      2       292.0    0.00      185,332        4        0        0           
         -------------------------------------------------------------        
Rollback Segment Storage for DB: V815  Instance: V815  Snaps    1  -   2      
->The value of Optimal should be larger than Avg Active                       
                                                                              
Segment                                                                       
  No    Segment Size  Avg Active     Optimal     Maximum                      
------- ------------ ----------- ----------- -----------                      
      0      407,552           0                 407,552                      
      2    5,220,352     111,770               5,220,352                      
         -------------------------------------------------------------        
Latch Activity for DB: V815  Instance: V815  Snaps    1  -   2                
->"Pct Misses" should be very close to 0.0                                    
                                                                              
                                   Get         Pct     Avg      Nowait     Pct
Latch Name                      Requests    Misses  Sleeps    Requests  Misses
------------------------------ ----------- ------- ------- ----------- -------
Active checkpoint queue latch          135    0.00                   0        
Checkpoint queue latch               1,812    0.00                   0        
Token Manager                            8    0.00                   0        
begin backup scn array                  48    0.00                   0        
cache buffers chains                24,187    0.00               1,899    0.00
cache buffers lru chain              6,272    0.00                   0        
channel handle pool latch                3    0.00                   3    0.00
channel operations parent latc           6    0.00                   3    0.00
dml lock allocation                    286    0.00                   0        
enqueue hash chains                    698    0.00                   0        
enqueues                             1,014    0.00                   0        
event group latch                        3    0.00                   0        
job_queue_processes parameter            7    0.00                   0        
ktm global data                          2    0.00                   0        
library cache                        6,922    0.00                   0        
library cache load lock                112    0.00                   0        
list of block allocation               140    0.00                   0        
loader state object freelist            10    0.00                   0        
messages                             1,162    0.00                   0        
multiblock read objects                228    0.00                   0        
ncodef allocation latch                  7    0.00                   0        
process allocation                       3    0.00                   3    0.00
process group creation                  17    0.00                   3    0.00
redo allocation                      2,201    0.00                   0        
redo writing                           765    0.00                   0        
row cache objects                    2,189    0.00                   0        
sequence cache                          12    0.00                   0        
session allocation                      86    0.00                   0        
session idle bit                       997    0.00                   0        
session switching                        7    0.00                   0        
shared pool                          1,894    0.00                   0        
sort extent pool                         2    0.00                   0        
transaction allocation                 220    0.00                   0        
transaction branch allocation            7    0.00                   0        
undo global data                       473    0.00                   0        
user lock                               12    0.00                   0        
         -------------------------------------------------------------        
Buffer Pool Sets for DB: V815  Instance: V815  Snaps    1  -   2              
                                                                              
                                                Free    Write  Buffer         
 Set   Buffers   Consis.  Physical  Physical  Buffer Complete    Busy         
 Num      Gets      Gets     Reads    Writes   Waits    Waits   Waits         
---- --------- --------- --------- --------- ------- -------- -------         
   1      1140      4418       944      1010       0        0       0         
         -------------------------------------------------------------        
Dictionary Cache Activity for DB: V815  Instance: V815  Snaps    1  -   2     
                                                                              
->"Pct Misses"  should be very low  (< 2% in most cases)                      
->"Cache Usage" is the number of cache entries being used                     
->"Pct SGA"     is the ratio of this to the available SGA cache size          
                                                                              
                          Get        Pct     Scan     Pct      Mod  Final  %of
Parameter               Requests  Misses Requests  Misses Requests  Usage  SGA
----------------------- -------- ------- -------- ------- -------- ------ ----
dc_constraints                 0                0                0    149   97
dc_database_links              0                0                0      0    0
dc_files                       0                0                0      0    0
dc_free_extents               40   27.50       11    0.00       22     22   55
dc_global_oids                 0                0                0      0    0
dc_histogram_data              0                0                0      0    0
dc_histogram_defs              0                1    0.00        0      0    0
dc_object_ids                 68   16.18        0                5    269   97
dc_objects                   155   18.71        0               19    428   99
dc_outlines                    0                0                0      0    0
dc_profiles                    3    0.00        0                0      1   20
dc_rollback_segments          12    0.00        0                0      4   25
dc_segments                   81   12.35        0               26    115   88
dc_sequence_grants             0                0                0      0    0
dc_sequences                   8    0.00        0                0      5   63
dc_synonyms                   20   85.00        0                0     57   90
dc_tablespace_quotas          16    0.00        0               16      3   33
dc_tablespaces                48    0.00        0                0      5   71
dc_used_extents               22  100.00        0               22     73   86
dc_user_grants                68    0.00        0                0      8   17
dc_usernames                  56    0.00        0                0      9   43
dc_users                     112    0.00        0                0     10   83
         -------------------------------------------------------------        


Library Cache Activity for DB: V815  Instance: V815  Snaps    1  -   2        
                                                                              
->"Pct Misses"  should be very low                                            
                                                                              
                  Get     Pct     Pin     Pct                                 
Namespace       Requests Misses Requests Misses Reloads Invalidations         
--------------- -------- ------ -------- ------ ------- -------------         
BODY                   4    0.0        4    0.0       0             0         
CLUSTER                6    0.0       12    0.0       0             0         
INDEX                 12   66.7       12   66.7       0             0         
OBJECT                 0               0              0             0         
PIPE                   0               0              0             0         
SQL AREA             456    2.2    1,484    3.2       0             2         
TABLE/PROCEDURE      277   11.6      377   21.0       0             0         
TRIGGER                0               0              0             0         
         -------------------------------------------------------------        
SGA Memory Summary for DB: V815  Instance: V815                               
                                                                              
SGA Segment                      Size in Bytes                                
------------------------------ ---------------                                
Database Buffers                    10,240,000                                
Fixed Size                              64,912                                
Redo Buffers                            81,920                                
Variable Size                       14,082,048                                
                               ---------------                                
sum                                 24,468,880                                
         -------------------------------------------------------------        


SGA breakdown difference for DB: V815  Instance: V815  Snaps    1  -   2      
                                                                              
Name                           Begin value  End value Difference              
------------------------------ ----------- ---------- ----------              
Checkpoint queue                     43236      43236          0              
DML locks                           114608     114608          0              
KGFF heap                             5828       5828          0              
KGK heap                             10772      10772          0              
KQLS heap                          1186212    1214788      28576              
PL/SQL DIANA                       1888220    1888220          0              
PL/SQL MPCODE                       197792     197792          0              
PLS non-lib hp                        2096       2096          0              
SYSTEM PARAMETERS                    56788      56788          0              
State objects                       263980     263980          0              
branches                             59520      59520          0              
db_block_buffers                  10920000   10920000          0              
db_block_hash_buckets               211128     211128          0              
db_files                            249792     249792          0              
db_handles                          145600     145600          0              
dictionary cache                    476972     511192      34220              
enqueue_resources                   115776     115776          0              
event statistics per sess           716400     716400          0              
file # translation table             38468      38468          0              
fixed allocation callback              320        320          0              
fixed_sga                            64912      64912          0              
free memory                        2025536    1449420    -576116              
java static objs                     37208      37208          0              
ktlbk state objects                 105716     105716          0              
library cache                      1798180    1899252     101072              
log_buffer                           65536      65536          0              
long op statistics array             99000      99000          0              
message pool freequeue              124552     124552          0              
miscellaneous                       451952     451952          0              
processes                           153600     153600          0              
sessions                            452700     452700          0              
sql area                           2067900    2479032     411132              
table columns                        16808      17044        236              
table definiti                         880       1760        880              
transaction_branches                 44896      44896          0              
transactions                        217360     217360          0              
trigger inform                         180        180          0              
view columns d                         916        916          0              
         -------------------------------------------------------------        
init.ora Parameters for DB: V815  Instance: V815  Snaps    1  -   2           
                                                                              
                                                                  End value   
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
background_dump_dest          /private/8.1.5/dbs/log                          
control_files                 /private/8.1.5/dbs/cntrl1v815.dbf               
db_block_buffers              5000                                            
db_files                      600                                             
db_name                       v815                                            
ifile                         /private/8.1.5/dbs/configv815.ora               
log_buffer                    1024                                            
log_checkpoint_interval       400000                                          
max_dump_file_size            1024000                                         
processes                     200                                             
rollback_segments             r01                                             
shared_pool_size              10000000                                        
sort_area_size                524288                                          
timed_statistics              TRUE                                            
user_dump_dest                /private/8.1.5/dbs/log                          
         -------------------------------------------------------------        

End of Report


Questions or comments ? Send a note to Kyle Hailey