Hi > In sql server we can use nolock hint to see the uncommitted data of the > other sessions. Is their any equivalent hint for query in Oracle? IMHO the only way to get uncommitted data of another session is to dump the information from either the buffer cache or the datafile. HTH Chris -- //www.freelists.org/webpage/oracle-l