Home » RDBMS Server » Server Administration » Recommended tools For Monitoring Oracle Databases (10g,11g, Linux,windows)
Recommended tools For Monitoring Oracle Databases [message #432507] Tue, 24 November 2009 10:14 Go to next message
mnorton
Messages: 1
Registered: November 2009
Junior Member
Hi,

Just wanted to get your ideas we have trialled a couple of bits of software for monitoring performance of the database and sql queries running against it and wondered if any one had any recommendations for any pieces of software such as Spotlight on Oracle, we do not have the option to go to Enterprise edition and therefore can't use the Statistics and Tuning Packs and want something more automated than STATSPACK and basic system performance stats.

Any recommendations would be appreciated.

Regards

Mike
Re: Recommended tools For Monitoring Oracle Databases [message #432530 is a reply to message #432507] Tue, 24 November 2009 18:27 Go to previous messageGo to next message
olddba
Messages: 5
Registered: June 2009
Location: Longview, Wa
Junior Member
what version of Oracle are you running?
Re: Recommended tools For Monitoring Oracle Databases [message #432587 is a reply to message #432530] Wed, 25 November 2009 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
olddba wrote on Wed, 25 November 2009 01:27
what version of Oracle are you running?

Read the title: 10g, 11g

Regards
Michel

Re: Recommended tools For Monitoring Oracle Databases [message #432635 is a reply to message #432507] Wed, 25 November 2009 06:34 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I've seen Quest's Spotlight; didn't use it, though, but I remember it looked very nice and was quite colorful. So, even though it doesn't do what you need, you might enjoy having it on the screen ./fa/1587/0/.
Re: Recommended tools For Monitoring Oracle Databases [message #432638 is a reply to message #432635] Wed, 25 November 2009 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

./fa/449/0/ Sooo true.

Regards
Michel
Re: Recommended tools For Monitoring Oracle Databases [message #432859 is a reply to message #432507] Thu, 26 November 2009 15:38 Go to previous messageGo to next message
ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON
Member

Hi,
I suggest you try Nagios with a check_oracle_health plugin to monitor a variety of oracle database metrics. Nagios+Cacti is a free graphing solution.
Re: Recommended tools For Monitoring Oracle Databases [message #432886 is a reply to message #432507] Fri, 27 November 2009 00:58 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Monitor Oracle Performance? Hmm, I've used OEM (9i) & DBControl (10g) for finding top_SQL, and it's all of purpose.

One of tool as dbtop I've used, too.

However, I've command console to monitor DB by my scripts or collection scripts.

[Updated on: Fri, 27 November 2009 01:05]

Report message to a moderator

Re: Recommended tools For Monitoring Oracle Databases [message #433977 is a reply to message #432886] Sun, 06 December 2009 02:06 Go to previous message
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
Junior Member
I vote for GRID control. DBControl for 10g is inferior to Grid Control for 10g. 11g DBControl is an improvement on 10g's, but I still prefer GRID.

With grid, you'll need to define a repository (in a licensed database.) If you are lucky enough to have a couple of RAC Clusters, you can make the repository highly available by putting the repos there.

Now you only need a server for the Oracle Management Server (note - it will conflict with ASM.) To make OMS highly available, you need a 'shared directory'.

Ooops. You'll need the Oracle Agent on each node with databases to be managed. Install the agent to a different Oracle home.

Summary: with RAC for Repository, and 2 off the shelf linux boxes, middle tier and database tier will be HIGHLY AVAILABLE. The best practice for PRODUCTION environments.

(Also have Spotlight for Oracle and Spotlight for RAC. Fun to look at. Nice 'replay' function as well. Past that, gimme grid control!)

Peace

Nets Edge
Previous Topic: Weird result from ORA 01994
Next Topic: drop database in oracle 10g
Goto Forum:
  


Current Time: Mon Dec 05 21:18:33 CST 2016

Total time taken to generate the page: 0.09145 seconds