Tagged: session

Oracle Tracing SQL Code by using SQL Trace and TKProf 0

Oracle Tracing SQL Code by using SQL Trace and TKProf

If you are running any query in oracle and you want to know what is running in background then the simplest way is to trace the session. On tracing of session, trace file is...

oracle lock query 0

Oracle Query to Check Lock on Rows and Objects

Locks can occur whenever any session holds exclusive lock on any specific object and another session tries to update the same record.  This lock will get released only when first session completes its work....