-
Read uncommitted or nolock on Oracle
Hi,
In SQL Server, I can do
1. select * from tb_name (nolock)
or
2. SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED
To avoid blocking due to lengthy select operation.
Do we have something like this in Oracle?
-
Hi
Oracle is different in this aspect.
You dont require to do that as reads are not blocked.
regards
Hrishy
-
That's good to know.
So even if I do, "select count(*) from tb_name", it's not going to affect any DML operation?
Please advise.
-
nope, reads do not blocks and writes do not block reads
-
That's good to know. Thank you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|