Hi,
I have a very basic doubt in Oracle.
Will the output of a Select query depend on how long the Query took for execution?
For example suppose i issue a query 'Select * from Employees' at 10.00 am. And suppose my query takes 20 mins to return with the results. And suppose meanwhile at 10.05 am new data gets commited to Employees table. In this case will/can my select query issued at 10.00 am return the new data.
My feeling is that it will not. Oracle would use some sort of ROW_SCN to determine what rows to return and what not. Thus my feeling is that the output of the Select query would be independent of the Query execution duration. It wont even depend on the IsolationLevels (ReadCommited, ReadUncommited etc). I.e if IsolationLevel is ReadUncommited, then the Select Query would return even Uncommited data as of 10.00 am (but no later).
Please let me know if i am right. If there are any good articles on this please send me the links.
Regards,
Sajee
