• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 546
  • Last Modified:

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
0
bibi92
Asked:
bibi92
1 Solution
 
slightwv (䄆 Netminder) 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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now