NOLOCK for multiple tables
Posted by:
Ra Nala
Date: November 17, 2015 07:30AM
Hi,
I am trying to apply NOLOCK syntax for my extraction query why because i am trying to load millions of records using one of the ETL tool called as PDI.
in this case i am trying to retrieve data from staging area and need to join with data mart table and should write into same data mart table. Is applying NOLOCK to my select query is good practice ??
Select * from course nolock
OR below is good practise ?
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
Select * from course
go
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
Thank you
Subject
Written By
Posted
NOLOCK for multiple tables
November 17, 2015 07:30AM
November 17, 2015 12:10PM
November 18, 2015 01:41AM
November 18, 2015 02:30AM
November 26, 2015 04:51AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.