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

Sorry, couldn't resist this:
To summarise then, if you can afford it you don't need it, but if you need it you can't afford it ;-).

Regards,
Yossarian.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:c9mmie$ite$1_at_titan.btinternet.com...
>
> Looking at the v$sqlarea is an expensive
> and aggressive operation. It is an aggregate
> view of the library cache, and hammers the
> library cache latches every time you do it.
>
> There are two scenarios for getting a
> 'continuous display' of v$sqlarea.
>
> a) You can afford to do it. This means
> you don't need to do it because you have
> so little work going on it's irrelevant
>
> b) Your system is very busy. This means
> you can't afford to do it. If the system is
> busy and you have (cheaper) indications
> that the library cache may be causing problems
> then you could take a few snapshots of v$sql
> to dig a little deeper.
>
>
> --
> Regards
>
> Jonathan Lewis
>
> http://www.jlcomp.demon.co.uk
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/seminar.html
> Optimising Oracle Seminar - schedule updated May 1st
>
>
> "Jumma" <juma_gandhi_at_yahoo.com> wrote in message
> news:c9ade84.0406022059.4ba9ad62_at_posting.google.com...
> > 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
>
>
Received on Mon Jun 07 2004 - 12:49:59 CDT