Event to disable SMON from freeing TEMP

From: Denny Koovakattu <denny_vk_at_yahoo.com>
Date: Thu, 25 May 2000 12:58:45 -0500
Message-Id: <10508.106746@fatcity.com>

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.
http://im.yahoo.com

Received on Thu May 25 2000 - 12:58:45 CDT