RE: Event to disable SMON from freeing TEMP

...Under the guidance of Oracle Corp, you can

set events..........

10061 - stop smon from handling temp
10269 - stop smon from coalescing
10268 - stop froward coalescing
10901 - stop extent trimming

There is an informative, 4 page article at the website of Jonathan Lewis on smon.....highly recommend this quick read. jonathan_at_jlcomp.demon.co.uk

Brad

-----Original Message-----
From: Denny Koovakattu [mailto:denny_vk_at_YAHOO.COM] Sent: Thursday, May 25, 2000 2:09 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Event to disable SMON from freeing TEMP

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

-- 
Author: Denny Koovakattu
  INET: denny_vk_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).