Results 1 to 3 of 3

Thread: H-e-l-p

  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: H-e-l-p

    which initialization file is the parameter "db_cache_advice" stored?
    And how to show the status of db_cache_advice?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    SQL> desc V$DB_CACHE_ADVICE
     Name					   Null?    Type
     ----------------------------------------- -------- ----------------------------
     ID						    NUMBER
     NAME						    VARCHAR2(20)
     BLOCK_SIZE					    NUMBER
     ADVICE_STATUS					    VARCHAR2(3)
     SIZE_FOR_ESTIMATE				    NUMBER
     SIZE_FACTOR					    NUMBER
     BUFFERS_FOR_ESTIMATE				    NUMBER
     ESTD_PHYSICAL_READ_FACTOR			    NUMBER
     ESTD_PHYSICAL_READS				    NUMBER
     ESTD_PHYSICAL_READ_TIME			    NUMBER
     ESTD_PCT_OF_DB_TIME_FOR_READS			    NUMBER
     ESTD_CLUSTER_READS				    NUMBER
     ESTD_CLUSTER_READ_TIME 			    NUMBER
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2009
    Posts
    2
    Thank you!

Posting Permissions

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