Category talk:Frequently Asked Questions

From Oracle FAQ

Jump to: navigation, search

How can we find the home and folders where Oracle server is installed

[edit] Buffer Cache Hit Ratio

reply me ata@berger.com.pk

Give me a suggest my init ora para correct or not .

My Buffer Cache Hit Ratio Percentage normally 95% to 100%. Please give me a suggestions how to manage it. Currently using Database Oracle8i OS UnixWare 7.1.1.

Server CONFIGURATION:

System = UnixWare Node = khisales Release = 5 KernelID = 04/11/11 Machine = Pentium 4 BusType = ISA Users = 25 OEM# = 0 Origin# = 1 NumCPU = 1 


   Memory Size: 1024 Megabytes
   System Peripherals:

       Floppy Drive 1 - 1.44 MB 3.5
       SCSI CD-Rom Drive 1 - HL-DT-ST - DVD-ROM GDR8164B
       Disk Drive 1 - LSILOGIC - 1030          IM - 69876 MB
       80387 Math Processor

Tunable Parameters 

  256  number of buffer headers allocated at a time (NBUF)
48640  maximum kilobytes for buffer cache (BUFHWM)
   80  entries in callout table (NCALL)
  400  entries in proc table (NPROC)
   99  maximum global priority in sys class (MAXCLSYSPRI)
   80  processes per user id (MAXUP)
   64  hash slots for buffer cache (NHBUF)
  100  buffers for physical I/O (NPBUF)
   60  auto update time limit in seconds (NAUTOUP)
   25  page stealing low water mark (GPGSLO)
    1  fsflush run rate (FSFLUSHR)
  100  maximum number of ACL entries (ACLMAX)
    4  number of scheduler classes (NCLASS)
  • i386 Specific Tunables

262143 maximum value for major and minor numbers (MAXMINOR) 

   64  size of internal hash table (NSTRPHASH)
 2000  size of buffer to record system messages (PUTBUFSZ)
  • Utsname Tunables 
      5  release (REL)

khisales node name (NODE) UnixWare system name (SYS) 

  7.1.1  version (VER)


My Init ora file.

db_block_size = 4096 db_files = 250 open_cursors = 300 db_file_multiblock_read_count = 16 processes = 101 log_buffer = 16777216 db_block_buffers = 62768 shared_pool_size = 104857600

db_block_checking = true db_block_checksum = false

optimizer_index_cost_adj=50 optimizer_index_caching=50 query_rewrite_enabled=TRUE query_rewrite_integrity=TRUSTED star_transformation_enabled=TRUE

job_queue_processes=5

Retrieved from "http://www.orafaq.com/wiki/Category_talk:Frequently_Asked_Questions"
Personal tools