Hi,<br><br>I have an Oracle7 (7.3.4.5) database. Upon examination of the v$waitstat table, I see some data block contention. I've upped initrans and pctfree for the tables, and db_block_buffers. The contention still exists. Could you please give me some tips on what causes and how to resolve this issue?<br><br>Thanks a lot.<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data block contention
- Thread starter magician
- Start date
- Status
Similar threads
- Locked
- Question