OraFAQ Forum: Performance Tuning » Transaction Isolation Level

Home » RDBMS Server » Performance Tuning » Transaction Isolation Level (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Transaction Isolation Level [message #672038]

Fri, 28 September 2018 22:01

saipradyumn
Messages: 419
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

Report message to a moderator

Re: Transaction Isolation Level [message #672041 is a reply to message #672038]

Sat, 29 September 2018 02:09

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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
/

Report message to a moderator

Re: Transaction Isolation Level [message #672044 is a reply to message #672041]

Sat, 29 September 2018 06:31

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Thanks Michel for your valuable information

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 17:55:01 CST 2025