Re: Statspack analysis

"Peter Laursen" <ptl_at_REMOVEedbgruppenTHIS.dk> wrote in message news:442e9ab3$0$11671$ba624c82_at_nntp02.dk.telia.net...
>
> "oracle_doc" <nilendu_at_nilendu.com> skrev i en meddelelse
> news:1143833455.824047.317670_at_v46g2000cwv.googlegroups.com...
> Buffer Gets Executions Gets per Exec % Total Hash Value
> --------------- ------------ -------------- ------- ------------
> 15,790,342 779 20,270.0 73.3 3097108327
> select a.tablespace_name,a.bytes_full,b.bytes_total,a.bytes_full
> ...
> Do you have any job that's running regularly and could fire this SQL?
> Or may be some monitoring tool? It was executed 779 times in 68 mins 68
> secs -- average interval for execution is 5.32 secs.
>
> the full query is here
> http://www.orafaq.com/usenet/comp.databases.oracle.server/2002/09/26/1124.htm
> It has been part of an application tool for many years. I dont know why it
> would suddenly become a problem, but executing it 10 times per minute is
> surely overkill :-)
> Do you think this sql could take up so many resources that it could slow
> down all other database queries?
>
> TIA
> Peter Laursen
>
>

This looks like some sort of home-grown (or 3rd party) query to check whether freespace in the tablespace is close to the limit.

Is it possible that you've made a recent structural change to the tablespace that could be related - e.g. changed data files to autoextent, rebuilt the tablespace as an LMT with small extent size ...

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html