db file scattered read, latch free, db file sequential read

Hello,

I try to understand why some queries hang because there are some events db file scattered read, latch free, db file sequential read.
How can I resolve this problem, please?

Thanks

Regards

Bibi
bibi92Asked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Define 'hang' or are you just seeing the 'wait' events?  All Oracle queries 'wait'.  That by itself isn't an issue.

Are you tracing specific SQL and seeing high wait events that are becoming a performance issue?
0
 
bibi92Author Commented:
Thanks regards bibi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here