The hint in the select below was causing a huge impact on the execution time.
SELECT /*+NO_CPU_COSTING*/
ROUND (SUM (df.bytes) / 1024 / 1024)
total_mb,
SUM (df.datafile_count)
database_files,
ROUND (SUM (fs.bytes) / 1024 / 1024)
free_mb,
ROUND ((SUM (df.bytes) - SUM (fs.bytes)) / 1024 / 1024)
used_mb,
ROUND (100 * (SUM (df.bytes) - SUM (fs.bytes)) / SUM (df.bytes))
pct_used,
COUNT (*)
tablespace_count
FROM dba_tablespaces t,
( SELECT tablespace_name, SUM (bytes) bytes, COUNT (*) datafile_count
FROM dba_data_files
GROUP BY tablespace_name) df,
( SELECT tablespace_name, SUM (bytes) bytes
FROM dba_free_space
GROUP BY tablespace_name) fs
WHERE t.status IN ('ONLINE', 'READ ONLY')
AND t.contents AND df.tablespace_name = t.tablespace_name
AND fs.tablespace_name = t.tablespace_name
WORKAROUND
1.Go to \Spotlight on Oracle 10.6\Plug-ins\SoO
2.Replace the file sql122.dat with the one attached (the hint has been removed there)
STATUS
Waiting for fix in a future release of Spotlight on Oracle .
The hint will be removed.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center