Norman Biggar
Member
We have recently experienced a marked degradation in performance of our system following the changing of certain database startup parameters. This is especially noticable when performing large batch processes that create a lot of records (up to 4 times slower).
The original parameter file is as follows
The amendments/additions made are as follows
The databases are on a Sun unix box E10K domain running Solaris 8 revision 108528-19. They have 2PC and AI enabled. Can anyone identify any parameter change, or combination, that would cause this excessive slowing of writing to disk?
The original parameter file is as follows
Code:
-B 50000 # Buffers
-H xxxxxx # Host name
-N TCP # Network type
-S xxxxxxx # Service name
-n 300 # Maximum number of users
-Mn 30 # Maximum servers per database
-Mi 5 # Minimum Clients per Server
-Ma 10 # Maximum Clients per Server
-bibufs 16 # Before image buffers
-aibufs 25 # After image buffers
-spin 2000 # Spin lock retries
-L 10000 # Lock Table overflow
-aistall # Do not crash if all after images full
(AIW,BIW,PROWDOG,3 APW's)
The amendments/additions made are as follows
Code:
-B 20000 # Buffers
-bibufs 50 # Before image buffers
-aibufs 100 # After image buffers
-tablerangesize 200 # Monitor Access to all tables up to 200
-indexrangesize 500 # Monitor Access to all indices up to 500
-groupdelay 250 # Number of milliseconds for BI flush
(AIW,BIW,PROWDOG,2 APW's)