Home » RDBMS Server » Performance Tuning » row cache lock: Cache id 8 - dc tables on QUERIES.
row cache lock: Cache id 8 - dc tables on QUERIES. [message #65876] Mon, 17 January 2005 22:39
Jonas Rosenthal
Messages: 4
Registered: January 2005
Junior Member
Hello,

I have observed users waiting on a row cache locke (cache id 8 which is dc_objects) while selecting from a table. The wait occurs for about 30 seconds. The getmiss ratio is about 5% for cache id 8.

First, Why would dc_objects need to be updated during a query? Weird.

Thank You,

Jonas Rosenthal
Previous Topic: Required Index .(Urgent help)
Next Topic: Index not being used for query
Goto Forum:
  


Current Time: Tue Sep 29 11:22:20 CDT 2020