Re: Oracle Tuning Question

On Thu, 21 Aug 2003 23:45:21 +0100,
rc_at_die@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

Read the performance tuning guide in the Oracle doc set at http://tahiti.oracle.com
>
>I have no controler over the deisgn of the SQL queries as it is an off
>the shelf app designed for Oracle
>

If the shelf app didn't care about statement tuning. tuning the database is NOT (I repeat: NOT) going to help.

>I basically want to tune the server for fast querie response, I am not
>too bothered about the Data input yet
>
>Thanks
>

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Aug 21 2003 - 23:21:10 CDT