RE: Oracle Diagnostic and Tuning Packs

Jared,

I can start OEM Change Manager 9.0 and edit a table rename script, add my own custom code and let oem run that as a job, or copy the sql and run it from sql*plus.

Mandar

-----Original Message-----
Sent: Monday, May 13, 2002 1:44 PM
To: ORACLE-L_at_fatcity.com
Cc: Mandar A. Ghosalkar

> All the events in OEM 2.2 and 9 use tcl scripts. Also u can use OS
script and create ur own events scripts.

Mandar,

That may be so, but that doesn't give you access to the scripts that OEM generates to accomplish the change.

As for writing my own TCL ( ugh ), if I have to write it myself anyway, I don't
need OEM.

Jared

"Mandar A. Ghosalkar" <mghosalk_at_byer.com> Sent by: root_at_fatcity.com
05/13/2002 01:53 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Oracle Diagnostic and Tuning Packs

Jared,

All the events in OEM 2.2 and 9 use tcl scripts. Also u can use OS script and create ur own events scripts.

for eg, i have an oem job which does a logical export for my unix and windows oracle databases and then fire a tcl script to change the export filename to add the timestamp.

Also the change propogation is implemented as scripts which u can modify and copy them to write ur own.

Also, Dennis, in 9i oem Performane Manager u can hv Statspack style reports.
"The Performance Data Report collection option allows you to collect a set of data that is similar to the Oracle STATSPACK utility."

the only drawback i found was of version compatibility. In our enterprise (7.3,8.0,8.1,9.0) i becomes a headache sometimes maintaing the agents, management servers and consoles.

Mandar

-----Original Message-----
Sent: Monday, May 13, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L

Kimberly,

The difference was that OEM gave push buttons only. If the change operation failed, there was no access to the underlying scripts.

Quest gives you that access, which can be very important in the case of failures. OEM is strictly a black box, or at least it was when we looked at it. Maybe it's changed since then?

Jared

"Kimberly Smith" <ksmith2_at_myfirstlink.net> Sent by: root_at_fatcity.com
05/12/2002 01:18 PM
Please respond to ORACLE-L  

        To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

        cc: 
        Subject:        RE: Oracle Diagnostic and Tuning Packs

And I normally don't disagree with you Jared but in this case I must. I evaluated both quite extensively just a month or so ago. They both give you the same type of control really, just in a slightly different format. OEM's was actually easier to use with no prior instruction. Both are push button per say. Just a different look at the push buttons.

I actually would have probably used Quests in the end but their pricing structure can at times be a little brutal, even compared to Oracle's OEM. I would have been perfectly happy to take OEM. In the end we are getting neither cause of budget issues. Embarcadero's was disappointing at best. It provided very little mechanism for flexibility.

-----Original Message-----
Sent: Sunday, May 12, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L

I will have to respectfully disagree with that, at least in part.

There is a big difference between change management in OEM tools and Quest tools, Quest's tools being much better.

The OEM tools are push button, just like MicroSlush garbage. Meaing: The OEM tools do no give you near the control over managing change and synching schemas across databases that Quest's tools allow.

Having said that, I don't use either. Had I a need for serious change management though, Quest would win hands down.

Jared

On Sunday 12 May 2002 06:43, Yechiel Adar wrote:
> Hello Peter
>
> We did a comparison between quest tools and OEM.
> The bottom line was that all these tools gives you about the same
> functionality and there is no BIG difference between them.
>
> Our manager got a better deal from Oracle so we bought these packs.
>
> We hope to start implementing them this quarter.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Friday, May 10, 2002 5:58 PM
>
> > Are these addons to OEM worth buying?
> >
> > Thanks
> > Peter Schauss
> > Northrop Grumman Corporation
> > schaupe_at_mail.northgrum.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Schauss, Peter
> > INET: SCHAUPE_at_mail.northgrum.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar A. Ghosalkar
  INET: mghosalk_at_byer.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar A. Ghosalkar
  INET: mghosalk_at_byer.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).