Re: Oracle Tuning Question

From: no-spam <rc_at_(no-spam)bhfshops.org.uk>
Date: Fri, 22 Aug 2003 07:41:32 GMT
Message-ID: <3f45c8eb.326382232@news.demon.co.uk>

On 21 Aug 2003 22:14:28 -0700, vslabs_at_onwe.co.za (Billy Verreynne) wrote:

>rc_at_die@you@!spammers.sandworm.demon.co.uk wrote
>
>> We are implemeting a DB with apporx 5m records in it.
>
>Small.
>
>> 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
>
>First off, is there a performance problem? Have you identified it? Or
>are you imagining there might performance problems and planning to
>take pot shots in the dark in the hope of hitting something?

Pot shots in the dark and hit something, thats why I am asking how do I monitor this ?
>
>Secondly, have you read the Oracle8i Designing and Tuning for
>Performance manual?
>__
>Billy
Received on Fri Aug 22 2003 - 02:41:32 CDT