Today, after trying unsuccessfully to drop my temporary tables, and subsequent fails due to object locks, I tried to find who's locking my table.
Not an easy task, so I dig a little and found this amazing script that solved my problem. If you have the same problem, read here --> http://www.orafaq.com/scripts/performance/lockall.txt how to list all locked objects.
Wednesday, January 7, 2009
Subscribe to:
Post Comments (Atom)
Cric Info
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
No comments:
Post a Comment