Re: OT: Locally managed tablespaces - ST enque

From: yong huang <yong321_at_yahoo.com>
Date: Thu, 01 Feb 2001 10:21:43 -0800
Message-ID: <F001.002A7AC6.20010201100946@fatcity.com>

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
yong321_at_yahoo.com

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..
5. 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: yong321_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 Feb 01 2001 - 12:21:43 CST