Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Event to disable SMON from freeing TEMP

Re: Event to disable SMON from freeing TEMP

From: Denny Koovakattu <denny_vk_at_yahoo.com>
Date: Thu, 25 May 2000 13:02:58 -0500
Message-Id: <10508.106747@fatcity.com>


Correction, smon is holding the ST ( space management ) lock and other sessions are wait for it.

Thanks,
Denny

Denny Koovakattu wrote:
>
> Hi,
>
> Platform : HP-UX 11.0 (64 bit)
> Oracle : 8.0.5.1 (64 bit)
>
> I think this was discussed before but I can't find the details in my
> notes or archives. I have a 1TB+ database with TEMP ( set to temporary )
> having approx. 10000 extents. After bouncing the database SMON is
> freeing up the extents and is holding the TS lock. ( v$lock shows SMON
> holding the CI lock, but other sessions are waiting on the TS lock. ) Is
> there an event that can be set to force SMON to release the lock after
> 'n' iterations ?
>
> Thanks,
> Denny

-- 
Denny Koovakattu
http://vitalsol.com/

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
Received on Thu May 25 2000 - 13:02:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US