Re: Statspack analysis

  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 /b.bytes_total status, b.bytes_total-a.bytes_full free from (sel ect tablespace_name,sum(bytes) bytes_full from dba_extents where  tablespace_name='HBMSTAB' group by tablespace_name) a, (select tablespace_name,sum(bytes) bytes_total from dba_data_files where

      1,333,334 1 1,333,334.0 6.2 1996628613 -- Der er bøvl med nedenstående SQL. Hvis udkommenterede del tag es med, så kører den i en evighed. select dpLev.navn Levera ndør, dpejer.navn Ejer, dpnet.navn Net, :startdato startd ate, :slutdato slut, forbrug.aftagenummer Aftagenummer, s um(forbrug.forbrugmd) Sumafregnet, sum(balanceafregnet.balfor

Clearly, these two SQLs are your main problem.

About the first query - it does not look like a recursive query (one fired by SYS) to me because the SQL is using a literal like -

tablespace_name='HBMSTAB

Recursive SQLs are always bound.

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. Received on Fri Mar 31 2006 - 13:30:55 CST