Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
monitoring tools for oracle database 1
- Thread starter fatchoy
- Start date
The tools I know of run on Windows clients but should be able to monitor non-Win servers.
For free, there is Monet from Guy Harrison:
(His Xplain is great - same site).
I use Quest's Spotlight - expensive but worth it. I reckon it paid for for itself in two weeks.
TOAD (also by Quest) includes basic stuff, but not much more than Monet (at least that's how it was when I last looked a few years ago).
For free, there is Monet from Guy Harrison:
(His Xplain is great - same site).
I use Quest's Spotlight - expensive but worth it. I reckon it paid for for itself in two weeks.
TOAD (also by Quest) includes basic stuff, but not much more than Monet (at least that's how it was when I last looked a few years ago).
pritirchio
IS-IT--Management
Hi fatchoy
Why don't you use Oracle DBA studio tool?
If you have an Oracle Database, it is the best tool I know for windows clients.
It is indipendent from the server operating system, so I think it is the best choice.
I don't if it is free, or how much it costs, but you can find every information you need on Orale site.
May be you can just have it inside the Oracle Database package.
Greetings
Pritirchio
Why don't you use Oracle DBA studio tool?
If you have an Oracle Database, it is the best tool I know for windows clients.
It is indipendent from the server operating system, so I think it is the best choice.
I don't if it is free, or how much it costs, but you can find every information you need on Orale site.
May be you can just have it inside the Oracle Database package.
Greetings
Pritirchio
As far as I can see DBA Studio only gives "static" information. If you want to go further (buffer miss rates, waits etc.) the tools I mentioned above can start to tell you what is going on in your db NOW. (The info is there for free in the sys.v$.... views - not very user-friendly - assembler programmers prefer this route!).
-
1
- #6
Hi,
The 9i version of DBAstudio ( now part of Enterprise Manager Console) has dynamic info on all current sessions and the database itself..
I know this is the 8i group, but a 9i client ( specifically 9.2 ) can be used with 8i databases and the newer versions of the toolset make it worthwhile , if possible, to upgrade the client.
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
The 9i version of DBAstudio ( now part of Enterprise Manager Console) has dynamic info on all current sessions and the database itself..
I know this is the 8i group, but a 9i client ( specifically 9.2 ) can be used with 8i databases and the newer versions of the toolset make it worthwhile , if possible, to upgrade the client.
- Status
Similar threads
- Locked
- Question