latch: row cache objects
Hello,
We are seeing l atch: row cache objects during peak hours its being happening since we have upgraded to 11.1.0.6. We are using Automatic Memory Management and our SGA is decided by oracle so we can’t modify the shared pool size manually to rectify this issue.
The problem we face is that we see sudden increase in active sessions and we have lots blocking sessions for example this morning the value of P2RAW was 253 so we killed all the related sessions but soon after killing them new session started and we saw new blocking session with same p2raw value. We can see what query is causing this issue but even killing all related sessions doesn't resolve this issue. We could not replicate this issue in test environment and when it happens in production environment we don't have much time to investigate this issue.
We are seeing l atch: row cache objects during peak hours its being happening since we have upgraded to 11.1.0.6. We are using Automatic Memory Management and our SGA is decided by oracle so we can’t modify the shared pool size manually to rectify this issue.
The problem we face is that we see sudden increase in active sessions and we have lots blocking sessions for example this morning the value of P2RAW was 253 so we killed all the related sessions but soon after killing them new session started and we saw new blocking session with same p2raw value. We can see what query is causing this issue but even killing all related sessions doesn't resolve this issue. We could not replicate this issue in test environment and when it happens in production environment we don't have much time to investigate this issue.
0