Re: lock ?

Brian Peasland wrote:

>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
>>
>>

And now that you have the answer fire the company that wouldn't help you and find someone that will.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)