Re: Oracle Diagnostic and Tuning Packs -- Worth it? Why?

Don't leave home without them. TopSessions in Diagnostic pack, SQL Analyze in Tuning pack are a must have for seeing the SQL clogging up your database, and the execution plans relating to them. Tablespace Manager (Tuning pack) lets you see the extents taken up by each segment (not what's in those extents, just their mapping...)

Also, the whole database monitoring and automatic fixing thing is great if you can get it to work, but that's mostly available in Diagnostics pack.

The only gripe is that these were initially in OEM. They were made into packs, apparently, just to sell more licenses. Very miserable.

If you use Platinum or Quest, those tools are probably good too - I don't know. But I use the OEM tools extensively, and their worthwhile.

FWIW, Yosi

Stephen Hurrell wrote:

> Hello.
>
> Been getting some pressure to examine the Oracle Diagnostic and Tuning
> packs.
> Before I spend some dough I'd like to hear from anyone why this product
> is worth it.
>
> We are medium oracle newbies so it appears to be interesting for us.
>
> STeve
> -----EOT
Received on Wed Aug 25 1999 - 14:34:41 CDT