Re: where to find sql generated by EM in 10g
From: joel garry <joel-garry_at_home.com>
Date: Mon, 26 Jan 2009 09:27:43 -0800 (PST)
Message-ID: <aeb60c41-257b-4372-96d6-845652964c52_at_o40g2000prn.googlegroups.com>
On Jan 25, 10:46 pm, pellicleund..._at_hotmail.com (obakesan) wrote:
> Hi
>
> some time ago I think I recall stumbling across the sql which was generated
> for an Enterprise Manager operation on the file system of the Oracle host.
> Does anyone know this location as I can't find it again?
>
> See Ya
> (when bandwidth gets better ;-)
>
> Chris Eastwood
> Photographer, Programmer Motorcyclist and dingbat
> blog:http://cjeastwd.blogspot.com/
>
> please remove undies for reply
Date: Mon, 26 Jan 2009 09:27:43 -0800 (PST)
Message-ID: <aeb60c41-257b-4372-96d6-845652964c52_at_o40g2000prn.googlegroups.com>
On Jan 25, 10:46 pm, pellicleund..._at_hotmail.com (obakesan) wrote:
> Hi
>
> some time ago I think I recall stumbling across the sql which was generated
> for an Enterprise Manager operation on the file system of the Oracle host.
> Does anyone know this location as I can't find it again?
>
> See Ya
> (when bandwidth gets better ;-)
>
> Chris Eastwood
> Photographer, Programmer Motorcyclist and dingbat
> blog:http://cjeastwd.blogspot.com/
>
> please remove undies for reply
There're a lot of ways to do this, one way in EM is by going to the session and looking at the open cursors (unless of course it is one of the ones that you can just hover over or click on on the session details page, 'cause they are waiting on the disk).
jg
-- _at_home.com is bogus. rubofh? http://www.theregister.co.uk/2009/01/23/botmaster_sentencing_kerfuffle/Received on Mon Jan 26 2009 - 11:27:43 CST