Excellent, K!
But regarding your #2, it needs to be pointed out that only when sort segments
are initially created is the ST enqueue acquired. Once they're created, they're
not deallocated so ST is not needed any more.
Yong Huang
[EMAIL PROTECTED]
you wrote:
ST is Space Transaction enque.. (some people call as
Single Threaded) which is acquired in every space
management operation.
It is serialized by design (oly one ST lock per
instance).So tehre may be a contention
1. If you allocate/deallocate space dynamically...
2. Unnecessary disk sorts
3. Dynamic extention of ROllback segments
4. When TEMP space is NOT real temporary space..
4. Improper extent settings
And at peak your alert log will be filled with more
ORA-1575 messages
Sorry I can't think more. I am in half sleep.
__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: yong huang
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
