-
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
[url]http://www.oracle.com/oramag/oracle/00-Mar/statspack.tar[/url]
But it might be worth reading the installation material, which is
[url]http://www.oracle.com/oramag/oracle/00-Mar/statspack-other.html[/url]
-
Software
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.
[url]http://www.ezsql.net[/url]
-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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|