How can I get a full list of all SQL functions being requested by a user? A developer is saying that they are issuing a commit on a transactiuon, but there is a lock that is left out there leading me to believe that the commit was not issued. I looked at SQL tracing, but that seems to add value in analyzing your SQL for performance, and does not show commit/rollback requests.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Full SQL Tracing (Including Commits)
- Thread starter lawtt
- Start date
How did you know that there is locking? I don't know if there is really a way to know when a commit occured but you could check the value in v$systat for 'user commits' if this one is increasing during the run of your user's procedure.
Locking could also happen when the FK column is not indexed and was updated. Check your schema for this scenario. Robbie
"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War
- Status