RE: Oracle Grid control

From: Amaral, Rui <Rui.Amaral_at_tdsecurities.com>
Date: Thu, 9 Jun 2011 10:36:34 -0400
Message-ID: <1B861F1ABE40A84AA92AD585B20C558B271984D133_at_EX7T2-CV06.TDBFG.COM>



I agree with Alan.

In my current and previous places of work we used/use GC as a general monitoring tool and notification system. Adding custom extensions is nice too but when it comes to the nitty-gritty nothing beats command line, especially during those times when there's an issue that hits the db and os at the same time. Also, ever tried to dig and manipulate the trace files data in GC? run root/oracle commands to debug in GC when the db is in a slow or hung state?

Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Guillermo Alan Bort Sent: Thursday, June 09, 2011 10:27 AM
To: niall.litchfield_at_gmail.com
Cc: srinivasanram2004_at_gmail.com; prabhu_adam_at_hotmail.com; oracle-l_at_freelists.org Subject: Re: Oracle Grid control

I have two main strategies, for general monitoring GC is the tool of choice.

When we have a specific problem in a database I fire up spotlight and toad and do everything from there, it just depends on what you are used to.

Oh, and not being able to do things from the command line is most definitely not a plus. Choosing not to is open to discussion, but not being able... not a good idea.

<insert rant about overrated DBAs who know nothing about how the database works>

Cheers
Alan.-

On Thu, Jun 9, 2011 at 8:31 AM, Niall Litchfield <niall.litchfield_at_gmail.com<mailto:niall.litchfield_at_gmail.com>> wrote: On Thu, Jun 9, 2011 at 12:19 PM, Ram Srinivasan <srinivasanram2004_at_gmail.com<mailto:srinivasanram2004_at_gmail.com>> wrote: Prabhu:
  all our DBAs are so used to it that they can't do any command line tasks any more.

I hope that's not a recommendation :)
--

Niall Litchfield
Oracle DBA
http://www.orawin.info

NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions. AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 09 2011 - 09:36:34 CDT

Original text of this message