• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 428
  • Last Modified:

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 !
0
d27m11y
Asked:
d27m11y
  • 2
1 Solution
 
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now