Home » RDBMS Server » Server Administration » dictionary managed free blocks management
dictionary managed free blocks management [message #397528] Sat, 11 April 2009 23:03 Go to next message
tjay
Messages: 37
Registered: September 2008
Member
Hey

I have a question about dictinionary managed tablespaces. I know the scenerio in local managed tablespaces but not sure about dictionary managed.

Assume my extent map is like below.(dictionary managed)

Is the future inserted data put at the end of the extent, or can it be inserted in the middle one of the free blocks?

aaaffaaafffff

assume I wanna insert b

aaabfaaaffff

or

aaaffaaabfff

????
Re: dictionary managed free blocks management [message #397529 is a reply to message #397528] Sat, 11 April 2009 23:21 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>Is the future inserted data put at the end of the extent, or can it be inserted in the middle one of the free blocks?
yes

Please post the CUT & PASTE results of your benchmark tests.


Re: dictionary managed free blocks management [message #397530 is a reply to message #397528] Sat, 11 April 2009 23:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course data may be inserted in free space of currently used blocks otherwise you would have more and more wasted space in the table.

Database Concepts
Chapter 2 Data Blocks, Extents, and Segments
Section Overview of Data Blocks
Paragraphs Free Space Management and PCTFREE, PCTUSED, and Row Chaining

Regards
Michel

Re: dictionary managed free blocks management [message #397532 is a reply to message #397530] Sun, 12 April 2009 00:23 Go to previous messageGo to next message
tjay
Messages: 37
Registered: September 2008
Member
it is not oracle 10g, assume the tablespace is dictionary managed

[Updated on: Sun, 12 April 2009 00:23]

Report message to a moderator

Re: dictionary managed free blocks management [message #397533 is a reply to message #397528] Sun, 12 April 2009 00:26 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>it is not oracle 10g, assume the tablespace is dictionary managed
NO! Default is LTM!
Prove otherwise.
Re: dictionary managed free blocks management [message #397534 is a reply to message #397532] Sun, 12 April 2009 00:28 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
tjay wrote on Sun, 12 April 2009 07:23
it is not oracle 10g, assume the tablespace is dictionary managed

1/ You didn't say your version, refer to the same chapter in the same book for your version
2/ This is what I assumed to answer you as this is what you said.

Read Database Concepts, 99% of this kind of questions is answered there.

Regards
Michel

Previous Topic: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora'
Next Topic: Archived Log backup manually?
Goto Forum:
  


Current Time: Mon Dec 05 20:53:43 CST 2016

Total time taken to generate the page: 0.16550 seconds