Dirty Read [message #23447] |
Mon, 09 December 2002 15:10 |
Prabhu
Messages: 26 Registered: October 2001
|
Junior Member |
|
|
hi..
i'm executing a procedure, which insert millions of rows into a particular table (say TEMP).
Parallelly i open another instance of oracle client and
need to find count(*) from TEMP, but my query doesnt
respond...i guess the table has been locked.
how to read from the other instance (Dirty read).
thanks in advance
Prabhu
|
|
|
Re: Dirty Read [message #23451 is a reply to message #23447] |
Tue, 10 December 2002 02:55 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
other client can't find any data which is inserted by other user if the transaction is not commited. Untilnow, i haven't found any article regarding to check the inserted data.
Hope this is helping.
|
|
|