Oracle Tuning Question

From: <rc_at_die@you@!spammers.sandworm.demon.co.uk>
Date: Thu, 21 Aug 2003 23:45:21 +0100
Message-ID: <tdiakvota09ef9tq3gb4sbpk58eflq3ngn@4ax.com>

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 Received on Thu Aug 21 2003 - 17:45:21 CDT