How to find isolation levels and locks the table is using ?

padma_prakasam · New User Joined: 06 Oct 2005 Posts: 31

Hi,

I have a table created long back. Now if i want to know what isolation levels and locks the table is using, where can i find??

Thanks
Padma

Title changed from "Isolation level" to "How to find isolation levels and locks the table is using ?" : Priyesh.

vijikesavan · Posted: Wed Jan 10, 2007 3:14 am

Padma,
I am not sure if this is the right way. But I use this method to get the details.

Run EXPLAIN on the SQL which uses the table. You can see it in the output.
In the plan_table look for this column