Oracle : READ COMMITTED - Deadlocks

I understand that read committed option is set for transaction level to get the committed data before the current query is executed. I have a question, may be a dumb question

Let us say, I have a session set as

ALTER SESSION SET ISOLATION_LEVEL READ COMMITTED;

but I have a procedure created in the same session which includes the statement

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;


how does that procedure execute, does it go by READ COMMITTED or SERIALIZABLE ?


Kindly suggest !
d27m11yAsked:
Who is Participating?
 
Franck PachotCommented:
Hi,
The alter session is the default for your session transactions.
So the set transaction is overrides it.
Regards,
Franck.
0
 
d27m11yAuthor Commented:
So, do you mean it would consider serializable transaction ?
0
 
Franck PachotCommented:
Yes that´s right.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.