Database Monitoring

Hi DBAs,

My company is looking at ways of monitoring the database activities. This includes almost everything or at least as much as possible.

Ac

There is a useful tool available from Oracle called Statspack, which logs just about everything.

Thanks about 'STATSPACK'.

Where can I find this tool?

Ac

The exact URL for the tar file is

http://www.oracle.com/oramag/oracle/.../statspack.tar

But it might be worth reading the installation material, which is

http://www.oracle.com/oramag/oracle/...ack-other.html

If you are looking for software to monitor the database, I know of a few:

First, of course there is OEM.
I have used some of the software by Quest.com -their software is very good.
I have just started to take a look at something by savant.com

Check them out- they all have free trial downloads and also installation tech support.

Check out Spotlight (by Quest Software). Get a trial download of it. It's a very good tool.

another good one is DBartisan by embarcedero, I use OEM as well, but find it slow & clunky, albeit powerfull. I have the free version of TOAD as well, both TOAD and DBartisan are small, compact & fast compared to OEM, but not as powerfull feature wise. Toad is more of a deleopers tool but great for browsing your schema's etc. DBArtisan is more of a monitoring tool than TOAD and is fast & compact.

I'm in the same situation, I've already started testing some tools.
First Oracle Enterprise Manager: Events are good..Console too slow.
Spotlight by Quest: Great Console with drill-down and everything....bad news: It does affect performance.
How did I know?
Precise/SQL very good until now, I have 2 days and I guess Precise/Pulse does what Spotlight.
See ya!

EZSQL has a lot of DBA utilities and the cost is low.
http://www.ezsql.net

-John

Spotlight is very good, it probably affect the perfomance since it almost goes by real time, running packkages all the time. But I think it´s very nice tool and very intuitive good explained, even shows the traffic from datafiles to SGA hehe