OraFAQ Forum: Server Administration » Recommended tools For Monitoring Oracle Databases

Home » RDBMS Server » Server Administration » Recommended tools For Monitoring Oracle Databases (10g,11g, Linux,windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tue, 24 November 2009 10:14

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

Report message to a moderator

Tue, 24 November 2009 18:27

olddba
Messages: 5
Registered: June 2009
Location: Longview, Wa

Junior Member

what version of Oracle are you running?

Report message to a moderator

Wed, 25 November 2009 00:54

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Wed, 25 November 2009 06:34

Littlefoot
Messages: 21823
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 /forum/fa/1587/0/

Report message to a moderator

Wed, 25 November 2009 06:45

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sooo true.

Regards
Michel

Report message to a moderator

Thu, 26 November 2009 15:38

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.

Report message to a moderator

Fri, 27 November 2009 00:58

trantuananh24hg
Messages: 744
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

Sun, 06 December 2009 02:06

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

Report message to a moderator

Previous Topic:	Weird result from ORA 01994
Next Topic:	drop database in oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 23:23:50 CST 2024