| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Event to disable SMON from freeing TEMP
Hi Denny,
10061 disables temp segment cleanup entirely. 10269 disables coalescing of free space entirely. Rebuilding the database will fix up SYS.TS$.
Regards,
Steve Adams
http://www.ixora.com.au/ http://www.oreilly.com/catalog/orinternals/ http://www.christianity.net.au/ -----Original Message----- From: Denny Koovakattu [SMTP:denny_vk_at_yahoo.com] Sent: Friday, May 26, 2000 5:09 AM To: Multiple recipients of list ORACLE-L Subject: Event to disable SMON from freeing TEMP
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/
--
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). Received on Thu May 25 2000 - 13:40:55 CDT
 |
 |