OraFAQ Forum: SQL & PL/SQL » find out isolation levels used for my database

Home » SQL & PL/SQL » SQL & PL/SQL » find out isolation levels used for my database

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

find out isolation levels used for my database [message #326002]

Mon, 09 June 2008 21:40

ora1980
Messages: 251
Registered: May 2008

Senior Member

I was going through this link

http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html

about isolation levels, and if isolation levels are "used"..then
1)how to find out which isolation level my database follows?
2) once i found out, then how to change it to another
isolation level?

Report message to a moderator

Re: find out isolation levels used for my database [message #326042 is a reply to message #326002]

Tue, 10 June 2008 00:53

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

Senior Member
Account Moderator

1) If you didn't set anything it is "read committed"
2) Using SET TRANSACTION

Regards
Michel

Report message to a moderator

Previous Topic:	password encryption
Next Topic:	how to find whether the table is inserted or not in a procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 18:00:41 CST 2024