Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: lock ?
You can query V$LOCK or V$LOCKED_OBJECT to see what is locked. The only
way to release those locks is to kill the session that is hold the
locks. You'll need the session_id (SID) and the serial# (from
V$SESSION). Then to kill the session, issue the following:
ALTER SYSTEM KILL SESSION 'session_id,serial#';
HTH,
Brian
search wrote:
>
> The guys from our database provider told us that there was a lock on one of
> our tables.
> It was fixed in 2 minutes.
>
> They won't provide us the information how you can see how a table is locked
> and how to unlock them ?
> Can some-one of you provide me more information.
>
> We use oracle 8.1.7 database.
>
> many thx
>
> Gerry
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Tue Oct 21 2003 - 09:40:49 CDT