Can db_cache_advice be used in Oracle8i?
I have a performance problem with Oracle8i (v18.104.22.168.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.
select SIZE_FOR_ESTIMATE "Cache size (MB)",
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,
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
It was a new feature in 9i AFAIK it can't be used in 8i
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Click Here to Expand Forum to Full Width