Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: OT: Locally managed tablespaces - ST enque

Re: OT: Locally managed tablespaces - ST enque

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 31 Jan 2001 12:04:27 -0800 (PST)
Message-Id: <10758.127951@fatcity.com>


Hi !

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.



Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Received on Wed Jan 31 2001 - 14:04:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US