Re: Contents of v$SQLArea.....

On 2 Jun 2004 21:59:22 -0700, juma_gandhi_at_yahoo.com (Jumma) wrote:

>Hi,
>
>I am looking for a solution that would continously show the contents
>of v$SQLArea.
>We need to have a View on what´s going on in the
>Database. I am using forms 6i & oracle 8.17.
>
>We think a Window that shows the contents running through is OK with a
>Method to stop and look at the Details and scroll through within a
>defined
>Buffer size.
>Also safe the contents of the Buffer for later Analysis.
>Could someone give the suggestion that how should I do that?
>
>
>Regards
>
>Jumma

Oracle Enterprise Manager (comes with Oracle) in combination with statspack (comes with Oracle)

--
Sybrand Bakker, Senior Oracle DBA