Hello,

I have a performance problem with Oracle8i (v8.1.7.4.9) (Import goes very slow and cpu is idle most of the time).

To find out what's wrong, I try the v$db_cache_advice, but the data isn't populated yet.

Statement:
select SIZE_FOR_ESTIMATE "Cache size (MB)",
BUFFERS_FOR_ESTIMATE "Buffers",
ESTD_PHYSICAL_READ_FACTOR,
ESTD_PHYSICAL_READS
from v$db_cache_advice
where name='DEFAULT' ;


The columns ESTD_PHYSICAL_READ_FACTOR & ESTD_PHYSICAL_READS are empty. In Oracle9i you first must enable the system (alter system set db_cache_advice on). But when I look in tahiti.oracle.com I cannot find anything about this. Even the view v$db_cache_advice is not known.

Is this a hidden and not working feature in Oracle8i?
If not, can someone point me in the right direction?

Thanks in advance,

Erik