Database Isolation Levels application

Question

I understand the Database isolation levels which is very well documented in Wikipedia and Oracle documentation.

I have few questions perhaps:

For a particular isolation level, does database only decides the resource to lock(e.g. table, row, or data in a column) or this is configurable?
Other than Isolation Levels, can a user/application exclusively create lock on some resource? If not, why?

I don't understand what you mean by "configurable" in your first question. For the seconds, different databases have different tools, there is no general method. — Mat, Aug 25 '12 at 10:56
Are you looking for an oracle-specific answer? (If so, it is best to add an oracle tag to the question.) — kgrittn, Aug 25 '12 at 12:09

score 1 · Accepted Answer · answered Aug 25 '12 at 11:47

1

Oracle will automatically handle locks for all isolation levels. Oracle also lets you set locks yourself.

answered Aug 25 '12 at 11:47

1 Answers1