DATABASE SLOW(8170 ON SUN SOLARIS)

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Mon, 03 May 2004 13:34:14 -0400
Message-ID: <BAY10-F924o6qXlqU6700003af1@hotmail.com>

Hi ,

Couple of customers are noticing some performance issue. Earlier stats was as below.

                                       GET HIT                     PINHIT
NAME                     GETS  GETHITS   RATIO      PINS   PINHITS   RATIO


-------------------- -------- -------- ------- --------- --------- -------

SQL AREA               490135   334814     .68   1223638    903071     .74
TABLE/PROCEDURE        277663   276042     .99    873103    869099    1.00
BODY                      149      138     .93       137       124     .91
TRIGGER                 24129    24101    1.00     24129     24097    1.00
INDEX                      39        0     .00        39         0     .00
CLUSTER                  1834     1823     .99      2068      2051     .99
OBJECT                      0        0    1.00         0         0    1.00
PIPE                        0        0    1.00         0         0    1.00

                    PINHIT             GET HIT
     PINS   PINHITS   RATIO     MISSES   RATIO


--------- --------- ------- ---------- -------

  2123119   1798445   84.71      11079   99.48

Buffer cache hit ratios was also earlier 66%.

I changed couple of parameters .

Parameter Name                         Current value                   
purposed Value
db_block_buffers                                    14424                    
                     16000

shared_pool_reserved_size                    4194304                         
         3670016

large_pool_size                                         614400               
                       0

java_pool_size                                         20971520              
                   15728640

optimizer_mode                                      CHOOSE                   
                FIRST_ROWS

optimizer_index_Adj                             100                          
                       10

_shared_pool_reserved_min_alloc     4000                                     
            0

Sytem was slow earlier but After above changed value couple of customers are complening some issues at time of login. Dictionary cahe ratios bump from .13% to 1.4%. Do you think can I reverse back _shared_pool_reserved_min_alloc 4000 value?
Any suggestions are most welcome!
Other ratios looks fine.

Mother’s Day is May 9. Make it special with great ideas from the Mother’s Day Guide! http://special.msn.com/network/04mothersday.armx

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon May 03 2004 - 12:31:17 CDT