Can db_cache_advice be used in Oracle8i?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Can db_cache_advice be used in Oracle8i?

  1. #1
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317

    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.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    It was a new feature in 9i AFAIK it can't be used in 8i
    Jim
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width