Re: Oracle Tuning Question

"rc"@die_at_you@!spammers.sandworm.demon.co.uk wrote:

> Hi
> I new to Oracle, I am familiar with MS SQL, MySQL and Access.
> I have a question for those of u in the know.
>
> We are implemeting a DB with apporx 5m records in it.
>
> Can some one tell me how I would go about monitoring that the
> DB_BLOCK_BUFFER; memory for sort area and shared memory pool (memory
> for SGA I think) and log buffer size is sufficient, or point me some
> urls
>
> I have no controler over the deisgn of the SQL queries as it is an off
> the shelf app designed for Oracle
>
> I basically want to tune the server for fast querie response, I am not
> too bothered about the Data input yet
>
> Thanks

You have struck all of the others that responded as someone looking for a problem to fix: And into that ring I throw my hat too.

5M records is an insignificantly small number of records and it is hard to believe that doing anything with DB_BLOCK_BUFFERS is going to do anything to make something better. And if you have no influence of over the SQL sent to the database you would probably do best forcusing on making sure statistics are current.

What you need is to monitor overall performance and respond to real problems. To do that look at using Oracle's built-in OEM tools, a third-party vendor's tools, or writing your own. Focusing on one single parameter will get you nothing but responses such as what you have already read: Or worse.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)