DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: What script to execute for creating x$kcbcbh and x$kcbrbh in oracle 7.3.4

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    Could any one reply me asap the script name to create the buffer cache stat view x$kcbcbh and x$kcbrbh.Its urgent

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    normally they are created under the SYS account, nevertheless read the following :

    [...] Enabling the X$KCBCBH Table
    The collection of statistics in the X$KCBCBH table is controlled by the initialization parameter DB_BLOCK_LRU_STATISTICS. The value of this parameter determines whether Oracle collects the statistics. The default value for this parameter is FALSE, which means that the default behavior is not to collect statistics.

    To enable the collection of statistics in the X$KCBCBH table, set the value of DB_BLOCK_LRU_STATISTICS to TRUE. [...]


  3. #3
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    Thanks a lot .I got it.

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