If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I wounder what are the measures that are needed to be taken improve the Buf. Cache hit ratio, for an instance whose tables and indices are analyzed every day. The current hit ratio for an 33 sessions is 88%.

I know one of the solutions is to increase the db_block_buffers. But I'm looking for a way to do things without increasing the db_block_buffers. The sessions are read and write intensive.

The appilication is regular sql nothing fansier. It uses the net8 to interact with the instance.

I wounder whether there is a way to find out what is causing this low hit ratio. In short, the application that uses the OCI would make connection to the database and would use the database tables to keep track of IMP logins and sessions on the database. When ever a user opens/reads their email on the internet, the program would insert/update or select the data from the table.

Thats all the program does on the database side. I wonder whether there are any ways to find out where the contention for the Buffer cache lies at.