RE: Oracle Grid control

  • From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
  • To: "'cicciuxdba@xxxxxxxxx'" <cicciuxdba@xxxxxxxxx>, "niall.litchfield@xxxxxxxxx" <niall.litchfield@xxxxxxxxx>
  • Date: Thu, 9 Jun 2011 10:36:34 -0400

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
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Guillermo Alan Bort
Sent: Thursday, June 09, 2011 10:27 AM
To: niall.litchfield@xxxxxxxxx
Cc: srinivasanram2004@xxxxxxxxx; prabhu_adam@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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>


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

I hope that's not a recommendation :)
Niall Litchfield
Oracle DBA

NOTICE: Confidential message which may be privileged. Unauthorized 
use/disclosure prohibited. If received in error, please go to 
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 pour des instructions.

Other related posts: