RealHeavyDude
Well-Known Member
OpenEdge 11.3.3, Sun Solaris SPARC 64Bit ( Sun V490+ 1800 Mhz with 64 GB memory - database files residing on ZFS file systems on a SAN ).
I know - we should have migrated to a more decent hardware on RHEL a long time ago and I wish I could do something about the SAN but I can't. A migration budget has been cancelled now for 5 years in a row and I don't even want to know how many $$$ Oracle gets for the maintenance of those SPARC dinosaurs ...
Nevertheless, I finally found some time to have a look at some statistics of our production database.
So the before image and after image buffer waits caught my attention:
On average over the last year had
The database is about 500 GB large - you don't want to know how long an online backup takes ...
Startup parameters:
Thanks in Advance and Best Regards,
RealHeavyDude.
I know - we should have migrated to a more decent hardware on RHEL a long time ago and I wish I could do something about the SAN but I can't. A migration budget has been cancelled now for 5 years in a row and I don't even want to know how many $$$ Oracle gets for the maintenance of those SPARC dinosaurs ...
Nevertheless, I finally found some time to have a look at some statistics of our production database.
So the before image and after image buffer waits caught my attention:
On average over the last year had
- A before image buffer wait every 0.2 seconds
- An after image buffer wait every 7 seconds
The database is about 500 GB large - you don't want to know how long an online backup takes ...
Startup parameters:
Code:
-S 47311 # The service or port number used by a broker process on the host machine
-minport 8400 # The lowest port number in a specified range of port numbers accessible to a client
-maxport 8499 # The highest port number in a specified range of port numbers accessible to a client
-Mpb 35 # The maximum number of servers that multiple brokers can start to serve remote users for any one protocol
-B 2800000 # The number of blocks in the database buffers
-B2 20000 # The number of blocks in the alternate buffer pool
-bibufs 750 # The number of before-image buffers
-aibufs 750 # The number of after-image buffers
-bithold 6000 # The recovery log threshold
-tablerangesize 2500 # Specifies the number of tables for which statistics are collected
-indexrangesize 7000 # Specifies the number of indexes for which statistics are collected
-n 350 # The maximum number of OpenEdge processes (users) on the database
-Mn 40 # The maximum number of remote servers
-Ma 15 # The maximum number of clients per remote server
-Mi 5 # The minimum number clients per reomte server
-L 50000 # The number of entries in the record locking table
-Bpmax 250 # The number of private buffers a connection can request through the private read-only buffers
-spin 5000 # The number of times a process tries to acquire a latch before pausing
-prefetchDelay # Enable a delay when sending the first network message
-prefetchFactor 100 # The percent of a message buffer to fill before sending it to a waiting remote client
-prefetchNumRecs 100 # The number of prefetch records to put in a network message before sending the message to a waiting remote client
-Mm 8192 # The network message buffer size. Must match between client and database server
-ssl # Support for secure socket layer connections
-Mxs 156000 # The size of the shared-memory overflow area in kilobytes
-lruskips 100 # The number of times to access a buffer before moving it to the end of the LRU chain
-lru2skips 100 # The number of times to access an alternate buffer before moving it to the end of the LRU chain
-omsize 8192 # The size of the storage object cache ( _StorageObject )
-ServerType 4GL # Type of servers supported by the broker ( 4GL | SQL | both )
Thanks in Advance and Best Regards,
RealHeavyDude.