Re: Database monitoring/tuning tools?

        Download a copy of orasnap. One of the queries in orasnap is a ranked list of queries with the ones using the most disk I/Os first. I work them one at a time in order to determine how to improve them.

        Basically, I copy the query into a script that does an explain plan, run the script and review the plan. If it calls for a full table scan I add indexes one at a time until I either find a good index (or combination of indexes) that lowers the cost or discover that no matter what I do Oracle is going to do full scans (I have one table like that, fortunately it isn't the largest one in the database, unfortunately it is the second largest table in the database).

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/14/00, 5:02:39 PM, Douglas Scott <dsscott_at_ev1.net> wrote regarding

Database monitoring/tuning tools?:

> Does anyone have a good recommendation for a database monitoring and
> tuning tool that a newbie DBA could use? I need something for a DBA
 who
> is just starting out (all he has done so far is take the Oracle
> Architecture course, he's scheduled for the Tuning course next). He
 is
> responsible for two 10 GB databases and needs any help he can get.
> Prefer something that might make tuning recommendations if something
> like that exists.
 

> Douglas Scott
Received on Sat Apr 15 2000 - 00:00:00 CDT