Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle benchmark
The best hint I can give you is to read the Oracle Concepts manual, and
the Performance Tuning manual.
You are wasting your time, as you don't seem to understand anything
about how the buffer cache mechanism works. You are up to an exercise
in futility, because Oracle never has the complete database in SGA.
Even if it would have been possible, the figures you call 'benchmarks'
would be completely irrelevant once the database starts growing.
You don't plan to increase the SGA once the database grows, do you?
If you do, I would either replace Oracle or find another job.
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Mar 03 2006 - 03:59:42 CST