This content has been marked as final. Show 3 replies
Beginner wrote:11g's which release, 11201,11202,11203?
We had an oracle11g setup on windows xp system. Will generating some reports we usally face user i/o wait class which delay the generation of report. Database file is located on F: on which we had 250 gb of space allocated out of which we had on 80 MB of free space. My question is whether low space availabilty of space in F:\ can occuer user i/o waits.
Its mostly unlikely that due to less space , the queries would take longer but then again, just with the given info of yours, it would be difficult to say anything precisely. Did you generate the Statspack/AWR report ? If yes, post it here. In addition to look at Dan's notes for the IO metrics, also check the below two threads to know one) what in general you should when your query takes long and two) how to post a query tuning request.
When your query takes too long ...
HOW TO: Post a SQL statement tuning request - template posting