Query Hanging - dba_free_space
Hi Guys,
We got a problem in production environment with one of the query which we run every minutes to check free space through nagios doesn't run any more since last night however previously it has been running successfully without any issue. On average it takes 15 secs to run but now it is hanging. Following is query we run.
SELECT df.tablespace_name TSNAME, df.file_name DFNAME, e.used_bytes BYTES
FROM dba_data_files df,
( SELECT file_id, SUM (DECODE (bytes, NULL, 0, bytes)) used_bytes
FROM dba_extents
GROUP BY file_id) e,
( SELECT MAX (bytes) free_bytes, file_id
We got a problem in production environment with one of the query which we run every minutes to check free space through nagios doesn't run any more since last night however previously it has been running successfully without any issue. On average it takes 15 secs to run but now it is hanging. Following is query we run.
SELECT df.tablespace_name TSNAME, df.file_name DFNAME, e.used_bytes BYTES
FROM dba_data_files df,
( SELECT file_id, SUM (DECODE (bytes, NULL, 0, bytes)) used_bytes
FROM dba_extents
GROUP BY file_id) e,
( SELECT MAX (bytes) free_bytes, file_id
0