Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Waits in Datafile
- Thread starter monujain
- Start date
Waits for what..( Latches, locks, etc)..
Datafiles do not 'have' waits...Accessing Data may cause waits, but it is some code processing not the datafile causing it.
Usually long waits are caused by incorrect locking methods ( like using select ... for UPDATE when it is not needed)
More info please...
OS, Version ( exact: 8.1.x.x ), what sql statementts are waiting?
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
Datafiles do not 'have' waits...Accessing Data may cause waits, but it is some code processing not the datafile causing it.
Usually long waits are caused by incorrect locking methods ( like using select ... for UPDATE when it is not needed)
More info please...
OS, Version ( exact: 8.1.x.x ), what sql statementts are waiting?
- Status
