Home » RDBMS Server » Server Administration » LMT tablespace (9i)
LMT tablespace [message #445191] Fri, 26 February 2010 06:12 Go to next message
TRaj
Messages: 82
Registered: September 2006
Member

Hi,

Need explanation for the below one ....

For a locally managed tabelspace, the dropped segment is changed to a Temp. Segment, to prevent bitmap from being updated.

Thanks.

Re: LMT tablespace [message #445197 is a reply to message #445191] Fri, 26 February 2010 07:01 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Always post the reference (preferably a link) where you read this.

To drop a segment in LMT, Oracle has to make several things among them update several tables of the dictionary and update bitmap in the datafiles that indicate which blocks are used and which ones are free.
It cannot do all of this at the same time, so it starts to invalidate the usage of the segment converting its type to temporary segment, then it has time to do the rest of the job as no one else can access this segment.

Regards
Michel

[Updated on: Mon, 01 March 2010 02:34]

Report message to a moderator

Re: LMT tablespace [message #445356 is a reply to message #445191] Mon, 01 March 2010 02:30 Go to previous message
TRaj
Messages: 82
Registered: September 2006
Member

Thanks Michel.
Previous Topic: What was the Problem Listener not functing Porperly
Next Topic: Oracle11G Database startup problem
Goto Forum:
  


Current Time: Sat Sep 24 21:31:02 CDT 2016

Total time taken to generate the page: 0.03922 seconds