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

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.

1. 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
2. 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