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

Thread: DBWR question

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    416
    TOAD Server Statistics feature show me " DBWR average scan depth = 3786.48 " and then it says " Number of DB_FILES too high? " Can you tell me what does it mean and do I need to do something ?
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    I don't now how TOAD Server Statistics works , but
    After Oracle 7.3(or 7.3 i can remember) dbrw calculate parameter _db_block_write_batch (and DBWR scan depth directly depend from this parameter and = _db_block_write_batch * 2)
    using formula:

    _db_block_write_batch = min(1/2 * db_simultaneous_writes * DB_FILES, db_buffers / 4, max_batch_size)

    where :
    db_simultaneous_writes = _db_simultaneous_writes (undocumented)
    max_batch_size = _max_batch_size (undocumented)
    db_buffers - from init.ora
    DB_FILES -- specified in the MAXDATAFILES in CREATE DATABASE or CREATE CONTROLFILE (default value = 200)
    may be u reset this parameter.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    90% of times I have seen toad always complains about that

    if i was you i wouldnt use it as a tuning tool

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