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

????

Report message to a moderator

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: 26766
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.

Report message to a moderator

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: 68665
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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
>it is not oracle 10g, assume the tablespace is dictionary managed
NO! Default is LTM!
Prove otherwise.

Report message to a moderator

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: 68665
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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 23:42:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.