Home » SQL & PL/SQL » SQL & PL/SQL » find out isolation levels used for my database
find out isolation levels used for my database [message #326002] Mon, 09 June 2008 21:40 Go to next message
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?



Re: find out isolation levels used for my database [message #326042 is a reply to message #326002] Tue, 10 June 2008 00:53 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) If you didn't set anything it is "read committed"
2) Using SET TRANSACTION

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


Current Time: Thu Dec 08 16:02:09 CST 2016

Total time taken to generate the page: 0.08931 seconds