Re: FINE TUNING ORACLE DB ...

To tune a database, you have to start with tuning SQL queries. To do that, you need a book. Try "Advanced Oracle Tuning and Administration" by Eyal Aronoff, Kevin Loney (Oracle Press). Read the part about manual tuning using hint, rule based and cost based optimizer.

Good luck.

Alan Lee
BSI Consulting
Houston, Texas

In article <35A333AD.63E61B3F_at_writeme.com>,   "PB6.0" <tanx2_at_writeme.com> wrote:
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 08 1998 - 00:00:00 CEST