Re: Statspack analysis

From: Peter Laursen <ptl_at_REMOVEedbgruppenTHIS.dk>
Date: Sat, 1 Apr 2006 17:23:34 +0200
Message-ID: <442e9ab3$0$11671$ba624c82@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 Received on Sat Apr 01 2006 - 09:23:34 CST