Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

High Logical reads/gets per exec

user10698496Oct 23 2013 — edited Oct 28 2013

Hi,

Oracle version - 11.2.0.2

I am facing high gets/exec for queries.The queries are fine tuned with proper index usage.I checked with SQL tuning set also which says 'no recommendation for this query'.

We have sufficient SGA and shared pool size.Gets/per exec are in 9000 range.

Also I am seeing latch:cache buffer chains in top events which is happening for a delete query.Will altering freelist for this table help?

Kindly assist me with this.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2013

Added on Oct 23 2013

#general-database-discussions

17 comments

4,744 views