Re: CLI or EM?

IMO, EM and CLI serve differernt purposes.

CLI gives me immediate and reliable access to the database when I want to perform specific operations that I already know.

In general, if I know 'it', I can do something a lot faster (and possibly with more finesse or accuracy) in CLI than in EM.

I still have a heck of a time running scripts, especially SQL Plus scripts, and especially from the library of scripts that have been created over the years, in EM.

Especially in 10g EM gives me the following:

• high level overview of state of the database;
• portal geared toward common issues with a drill-down interface;
• a training tool for new feature useage or new DBA training (show SQL);
• a wrapper around some of the 'klutzier' packages such as DBMS_SCHEDULER;
• a headache with it's UI inconsistencies.

Both tools are part of my tool kit now.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***