Concurrency control, Locking on read,update,delete for xmltype columns

Posted on 2008-10-23
Medium Priority
Last Modified: 2013-12-07
hi all,

i'm wondering whether the access of xmltype column data has any concurrency locking mechanism like ATOM? mostly i'm worried is the Isolation part upon reading the xml type data.

eg. if reading, update,deleting particular node on xml, is there any locking pattern like READ COMMITED, SERIALIZED etc. accessing this information would be in stored programs only so it's constraint to PL/SQL environment.

anyone has details on this and please advise and educate me, thanks

Question by:wxII
  • 2
LVL 74

Accepted Solution

sdstuber earned 1500 total points
ID: 22791400
for oracle, it's just another column, even if the underlying structure is object relational,  the "main" table has a single column in a single row.  All locking/isolation issues are handled at that layer.
LVL 74

Expert Comment

ID: 22795373
If you needed further assistance you just needed to ask.  Please do not assign penalties without giving the volunteers (not just me) a chance

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question