Home » RDBMS Server » Server Administration » Need Queries / PL - SQL blocks for the follwing.
Need Queries / PL - SQL blocks for the follwing. [message #64462] Mon, 31 January 2005 04:51 Go to next message
VJ
Messages: 24
Registered: June 2002
Junior Member
what will be the Query / plsql block for finding the below information ...

1. List of blocking locks in db, their sid , child sid and the query that is causing the block.

2. List of user names along with their sids and no of opened curosors ...

Please let me know if you hav any scripts handy ..

-V

Report message to a moderator

Re: Need Queries / PL - SQL blocks for the follwing. [message #64464 is a reply to message #64462] Mon, 31 January 2005 05:18 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
BigBrother Mark Powell gives an approach.
You may need to tweak a little...

Report message to a moderator

Previous Topic: Unable to Recover the dbf file - URGENT!
Next Topic: Records Deletion
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 04:00:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.