Solved

Oracle : READ COMMITTED - Deadlocks

Posted on 2013-12-09
3
415 Views
Last Modified: 2013-12-10
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
Comment
Question by:d27m11y
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
Franck Pachot earned 500 total points
ID: 39708442
Hi,
The alter session is the default for your session transactions.
So the set transaction is overrides it.
Regards,
Franck.
0
 

Author Comment

by:d27m11y
ID: 39708922
So, do you mean it would consider serializable transaction ?
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39709169
Yes that´s right.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question