Can db_cache_advice be used in Oracle8i?
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
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.