Re: Performance and Tuning Tool

The Oracle Tuning pack is good but it tends to over do things a bit if you use the Oracle Expert you can analyse the recommendations that Oracle generates and then implement the ones that are really valid.

The main problem is that it analyses all sql statements recently executed which means that if analysts have been running a lot of different select statements which are not part of the system then it will want to create indexes to speed them up.

the way I do it is to run the tuning session and then get copies of all procedures, functions and embedded sql statements which are part of normal operation and pick the indexes to create from the list according to what will actually speed up the operation of the system and then ignore the complaints from the data analysts.

You must have the management server (OMS) running and be able to connect to it to use the tuning pack.

Beware of Oracles tendency to want to create bitmap indexes.

Only ever create indexes on reference data (they are very quick to scan but take a long time to update)

Cheers

Patrick

"Barathidassan" <barathidassan_at_hotmail.com> wrote in message news:l1fe7.80052$cK1.14737079_at_typhoon.jacksonville.mediaone.net...
> Does anyone knows about Performance and Tuning tools.. If yes let me know
> please
>
> Regards
> Barath
>
>
Received on Thu Aug 23 2001 - 07:02:48 CEST