Re: Thoughts on Enterprise manager

Hi Steve,

OEM isn't as bad as many make out. It has a lot of nice features, makes some things much easier to set-up (such as workspace management and replication) and is pretty simple and intuitive to use. And yes, Data Guard too (although I personally haven't used it in anger)

Now this may seem somewhat weird, but I personally would only recommend the more *experienced* Oracle folks to use it. As a beginners tool, or as a learning Oracle tool I would advise against. Why, because it "hides" a lot of the fundamental whys and hows that are necessary for proper learning. It's also easier to make "mistakes" in the sense that a click here and a click there followed by an oooppppppppssss is not uncommon for the novice. It works best when you do something who know how to do more efficiently rather than doing something you're not sure how or why to do but know it works if you click over here (if that makes sense ?)

I prefer it somewhat over Toad from a DBA perspective in that it has more functionality and handles multiple databases better, but it can be sluggish in comparison.

OEM is just another tool which when used appropriately has it's uses.

Cheers

Richard
"steve deno" <sldcrew2k_at_yahoo.com> wrote in message news:8e6b14d8.0209161250.1df5f1e9_at_posting.google.com...
> I am curious what people think of Oracle Enterprise manager. Which
> experienced DBA's out there use it to manage databases.
>
> I am setting up an environment with 3 instances(1 data warehouse, and
> one OLTP with a standby) These will all be 9.2 on Solaris 9. Up
> through 8i I often found that keeping agents and data gatherers, and
> alerts running proved to be a sort of a headache so I just wrote UNIX
> scripts for notifications/jobs/backups, etc. What I'm wondering is:
> Are there significant numbers of experienced DBAs who get a lot out of
> OEM? Is it the way to go if you are doing a logical standby database
> with Dataguard?
>
> Any thoughts are welcomeed. Thanks
Received on Tue Sep 17 2002 - 07:57:32 CDT