Home » RDBMS Server » Server Administration » Do DBA's use Oracle Enterprise Manager Grid Controlmore more than command line
Do DBA's use Oracle Enterprise Manager Grid Controlmore more than command line [message #498334] Wed, 09 March 2011 12:41 Go to next message
latinmusic74
Messages: 4
Registered: April 2009
Junior Member

Do Does DBA use Oracle Enterprise Manager Grid Control more more than command line or sql+plus to administer their databases?
Re: Do DBA's use Oracle Enterprise Manager Grid Controlmore more than command line [message #498337 is a reply to message #498334] Wed, 09 March 2011 12:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Bad DBA, yes. Good one, no.

Regards
Michel
Re: Do DBA's use Oracle Enterprise Manager Grid Controlmore more than command line [message #498351 is a reply to message #498337] Wed, 09 March 2011 14:14 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Not me. Command line is faster and more accurate. It also works more consistent over different releases. You can also "show" other experts more easily what your problem is by copy and pasting the command line and the output, and they can more easily reproduce it. Its less hassle in general.

Usually in the time it takes to log into Enterprise Manager and navigate to the place I need to go I have already finished the task on the command line and left the office to get a coffee.
Re: Do DBA's use Oracle Enterprise Manager Grid Controlmore more than command line [message #498359 is a reply to message #498351] Wed, 09 March 2011 14:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the final word is from Ana:

Quote:
Those who live by the GUI, die by the GUI.


Regards
Michel
Re: Do DBA's use Oracle Enterprise Manager Grid Controlmore more than command line [message #498365 is a reply to message #498359] Wed, 09 March 2011 15:35 Go to previous messageGo to next message
latinmusic74
Messages: 4
Registered: April 2009
Junior Member

Thanks all for you helpful comments
Re: Do DBA's use Oracle Enterprise Manager Grid Controlmore more than command line [message #498376 is a reply to message #498365] Wed, 09 March 2011 16:22 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
I'm going to suggest an alternative point of view. There are many tasks that are horribly slow and complicated to do from a command line, and simple with Enterprise Manager. For instance: setting up the Resource Manager; configuring alerts; identifying blocking sessions in a RAC; setting up Streams. Sure, you can write the code to do these things yourself - but you will be a lot more productive if you let OEM generate the code for you.
Re: Do DBA's use Oracle Enterprise Manager Grid Controlmore more than command line [message #498378 is a reply to message #498376] Wed, 09 March 2011 16:35 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You have a point there, John. Beside knowledge itself, what makes live easy is a good repository of scripts that do common tasks. When you work a few years you start to accumulate them over time, but for a newcomer OEM might be a good option to get a start on those scripts. As long as he gets not to reliant on that additional level of abstraction, and still learns some of the basics that go on under the hood.
Re: Do DBA's use Oracle Enterprise Manager Grid Controlmore more than command line [message #498456 is a reply to message #498376] Thu, 10 March 2011 01:06 Go to previous message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
John, does this make you use OEM more than SQL*Plus?
Do you set up Streams or resource manager every day?

By the way, if you want to get a standard in your entreprise to set them (and I agree it is far easier with OEM), it is better generate the scripts once (with OEM or other GUI) and then only use the scripts, it is less error-prone.

So, in the end, we all agree. Wink

Regards
Michel
Previous Topic: ORA-01092 - manually creating a database
Next Topic: Data migration between two different application
Goto Forum:
  


Current Time: Thu May 09 10:02:57 CDT 2024