Bugged Query for Oracle 8

Bugged Query for Oracle 8

Hello,

I want to show that the following query not work on Oracle 8.1.7.4.0:

SELECT d.tablespace_name, SUM(f.phyrds) phyrds, SUM(f.phywrts) phywrts, SUM(f.readtim) readtim, SUM(f.writetim) writetim FROM sys.dba_data_files d, V$filestat f WHERE d.file_id = f.file# GROUP BY d.tablespace_name union SELECT d.tablespace_name, SUM(f.phyrds) phyrds, SUM(f.phywrts) phywrts, SUM(f.readtim) readtim, SUM(f.writetim) writetim FROM sys.dba_temp_files d, V$filestat f WHERE d.file_id = f.file# GROUP BY d.tablespace_name


This query hangs and create a dump file. My DBAs told me that is an Oracle bug, documentated on oracle site.
You can find it in $APPMANAGER_HOME/working/conf/application/Oracle.xml


Bye
Stefano










                New to ADSelfService Plus?