Systemviews AIX 8.0.5. very slow

From: Ruediger Wehrsig <aliquam_at_hotmail.com>
Date: Fri, 30 Jun 2000 11:11:15 GMT
Message-Id: <10544.110893@fatcity.com>

Hi ,

we have a problem with some systemviews in AIX 8.0.5.2.1. They are very slowly.
For instance :

set timing on

SELECT d.tablespace_name "Name", d.status "Status",
TO_CHAR((a.bytes / 1024 / 1024),'99,999,990.900') "Size (M)",
TO_CHAR((a.bytes / 1024 / 1024),'99,999,990.900') "Size (M)",

TO_CHAR(((a.bytes - DECODE(f.bytes, NULL, 0, f.bytes)) / 1024 / 1024),'99,999,990.900') "Used (M)"
FROM sys.dba_tablespaces d, sys.sm$ts_avail a, sys.sm$ts_free f WHERE d.tablespace_name = a.tablespace_name AND f.tablespace_name (+) = d.tablespace_name; ...
51 rows selected.

Parse             0,02 (Elapsed)     0,00 (CPU)
Execute/Fetch  3276,93 (Elapsed)     0,02 (CPU)
Total          3276,95               0,02

This time is not normal. I can not find the cause. The performance of other applications is normal. The tables of the sys user are N O T analyzed. All objects of SYS are valid.

The problem occurs always (also after start of the database) and especially with sys-Views with storage-information. Any ideas?

Thank you very much!

Ruediger Wehrsig
DBA

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Fri Jun 30 2000 - 06:11:15 CDT