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@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> Cheers Alan.- 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: 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.