-
Locks
How to find locks in a table..?
What are the types of locks?
How to release the locks from that table?
-
Hi
If i answer you will answer me back with a link from google.
So why dont you search in google :-D.
regards
Hrishy
-
Originally Posted by hrishy
Hi
If i answer you will answer me back with a link from google.
So why dont you search in google :-D.
regards
Hrishy
thanks Hrishy
-
i got one query from Google...
select
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid = a.session_id and a.object_id = c.object_id;
-
Originally Posted by gopu_g
i got one query from Google...
Lucky you
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
Lucky you
hi PAVB
we cant trust to the information that we get from the google.
you all are experts and having good experience, so i can find a correct answer easily.And i know this forum for the past 10 months
thanks for the help
Gopu
-
Let me break the news to you, you are not required by law to make a post every time you find a script or a question pops-up in your brain. By doing that you are not helping yourself nor anybody else, that's just plain crazyness.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
thanks man i will follow your advice
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|