Re: FINE TUNING ORACLE DB ...

On Wed, 8 Jul 1998 11:32:32 +0200, "Reiner Neumann" <reiner.neumann_at_messe.de> wrote:
Just a novice in Oracle database , if there is a case while suddently a system slow down and halt...
I do a top in root level , I can see that all the process is sleep , What is the step I 'm going to trace ?

>I am working with a very good SQL-Tuning Tool.
>SqlLab from www.quests.com is easy to use.
>It looks for the worst Sql-Commands in your Shared-Pool
>and gives you help to tune it
>Regards from Hannover,Germany
>Reiner Neumann
>
>PB6.0 schrieb in Nachricht <35A333AD.63E61B3F_at_writeme.com>...
>>Hi !
>>
>>I'm working with PB6.0 and due to some complex queries in DataWindows
>>including lots of outer joins, I'd like to manage my Oracle 7.3 DB
>>in a accurate way. Does somebody knows where I could find papers
>>(from Sybase, PowerSoft, Oracle) explaining how to fairly tune a DB ?
>>
>> Tanx in advance for any answer !
>> mailto:tanx2_at_writeme.com
>>
>>
>
>
Received on Fri Jul 17 1998 - 00:00:00 CDT