I’m a big fan of Enterprise Manager Grid Control. The performance page and all the drill-downs from there are awesome. Having said that, there are loads of things where it is such a pain in the ass.
Some incidents spring to mind:
- Someone asked me to check what sessions a particular user had against the database. I was already on GC, so I decided to use that. After a couple of clicks and pauses for the screen to load I turned and said, “Bugger this for a game of soldiers!”, opened SQL*Plus, ran my sessions script and it was done. GC is such a waste of time for some simple tasks like this. It’s far easier to do it using SQL*Plus or SQL Developer.
- I was cloning a database and decided to do it with GC. The process was very long winded to fill in all the options I needed and at the end it failed with some crappy error message. I switched to the command line and it was done in no time. I would hazard a guess the whole manual operation took less time than typing in the required options into GC.
- The job scheduler in GC is chronic! For some operations I have to switch from my Super Administrator account to the SYSMAN account or things just cave in. That happens with other areas of functionality too I guess.
I’m not discounting that someone with less command line experience may have a different take on things, but sometimes Grid Control drives me nuts!
Cheers
Tim…
Sometimes Grid Control Drives Me Nuts… | The ORACLE-BASE Blog http://t.co/C1zUSDkr
Ah!
It seems you’re not a DBA 2.0 anymore… 😉
Cheers.
Carlos
Yeah, know what you mean. After many years of hate in my love-hate relationship with EM and grid, I am now using OEM across all our instances. The 11gr2 one seems to be quite usable and actually makes handling the dbms_scheduler nightmare a lot moe palatable. But I entirely agree: the need to jump into SYSMAN for somethings and SYS/SYSTEM for others drives me up the wall! And often simple things become a chore, best handled with the swift application of one CLI script. Or two…
Hey Tim – is this 11g? Are you finding these annoyances to be addressed in 12c?
Yes. GC 11g. We have to use that here as we are a HP-UX shop. 🙁
Not used GC 12c CC enough to know if it is less annoying. 🙂
Cheers
Tim…