Home » RDBMS Server » Performance Tuning » Transaction Isolation Level (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production)
Transaction Isolation Level [message #672038] Fri, 28 September 2018 22:01 Go to next message
saipradyumn
Messages: 400
Registered: October 2011
Location: Hyderabad
Senior Member
Hi All,

By default oracle transaction isolation is READ COMMITTED.
how can we check the oracle is using the same and no one is over redid that behavior.

Is there any way to check the Transaction isolation level in oracle database ?

Thanks
Revathi.T

Re: Transaction Isolation Level [message #672041 is a reply to message #672038] Sat, 29 September 2018 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

select s.sid, s.username, 
       decode(bitand(t.flag, POWER(2, 28)), 0,'READ COMMITTED', 'SERIALIZABLE')
         isolation_level
FROM v$transaction t, v$session s
WHERE s.saddr = t.ses_addr
order by 1
/
Re: Transaction Isolation Level [message #672044 is a reply to message #672041] Sat, 29 September 2018 06:31 Go to previous message
saipradyumn
Messages: 400
Registered: October 2011
Location: Hyderabad
Senior Member
Thanks Michel for your valuable information
Previous Topic: Pleaese clear my doubt about View and synonym having same name
Next Topic: How do I know who are running the long running ops sql?
Goto Forum:
  


Current Time: Fri Dec 13 21:22:30 CST 2019