It obviously varies sooo much between platforms and different configs BUT, I can't help believing you must be CPU bound with that kind of memory compared to the number of CPU's... What does unix sar say? What about oracle utlbstat/estat and/or statspack say?
>>> Diane Whitehead <Diane.[Email Address Removed] 03/31/03 09:20AM >>>
We have a data warehouse running on solaris 2.8 Oracle 8.1.7.4
we have 2 cpu's and 8GB of Ram on the server. All the examples I can find
in oracle documentation have much lower levels of ram per server.
Does anyone else have this sort of skew? Can anyone offer any tips on
getting the best performance out of this set-up please?
**********************************************************************
--=Disclaimer=--
This email and any files transmitted with it including replies and forwarded copies are confidential and solely for the use of the intended recipient.
If you are not the intended recipient or the person responsible for delivering to the intended recipient please be advised that you have received this email in error and that any use is strictly prohibited. In this case please destroy this email and notify [Email Address Removed]
Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late, incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of email transmissions. If verification is required please request a hard copy version.
Any opinions expressed in this email are those of the individual and not necessarily the company or other companies in the P & H group.
Palmer & Harvey McLane Limited, P&H House, Davigdor Road, Hove, East Sussex BN3 1RE
**********************************************************************
--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed]
To subscribe: send a blank email to oracledba-[Email Address Removed]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page