Re: CLI or EM?

On 2006-01-21, HansF <News.Hans_at_telus.net> wrote:
> 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.

        However, the EM is java and as such prone to many of the same problems you might have seen in other java applications and applications servers. In particular, I've already seen em start running amok on my test cluster. I have 2 nodes currently with the dbconsole running on the "master" node. On occassion, the 2nd node will get hammered by activity apparently generated by EM. This includes numerous database connections and excessive use of swap. This tends to lead to a load average of about 15 and continues until I kill the em agent on the second node.

        Although I think I have managed to avoid subsequent problems by putting the em db user in a resource group that can only get 25% of the box (at most).

>
> 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.
>

        EM is kind of nice but relatively inflexible and crude. If given sufficient resources, I'd still much prefer Quest tools. If I had foglight, EM would immediately get shut off and flushed from all of my databases.

        It's a definite improvement on the 8i & 9i versions though...

-- 
     If you think that an 80G disk can hold HUNDRENDS of           |||
hours of DV video then you obviously haven't used iMovie either.  / | \

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com