Home » RDBMS Server » Server Administration » Bitmaps and Freelists
Bitmaps and Freelists [message #255032] Mon, 30 July 2007 08:05 Go to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,
Can anyone help me in this matter:-

When i was studying locally managed tablespaces i came across bitmaps that are used in locally managed tablespaces it stated that:-
"Locally managed tablespaces use bitmaps stored within the header of the datafiles comprising a tablespace to track the space utilization of the tablespaces."

AND

When i was studying some other topics i came across FreeLists it stated that:-
"Oracle will first search for a free block in the FREELIST and then the data is inserted into that block. The availability of the block in the FREELIST is decided by the PCTFREE value. Initially an empty block will be listed in the FREELIST structure, and it will continue to remain there until the free space reaches the PCTFREE value"

Q) I am confused of Bitmaps and Freelists as they have been used for same purpose whether Bitmaps means Freelists only or is there any difference between them ?


Regards,
Naveen
Re: Bitmaps and Freelists [message #255038 is a reply to message #255032] Mon, 30 July 2007 08:24 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Q) I am confused of Bitmaps and Freelists as they have been used for same purpose whether Bitmaps means Freelists only or is there any difference between them ?

No there are 2 different things and there are no relation between them.
Bitmaps (these ones) manage blocks/extents in a tablespace.
Free lists manage blocks inside a segment.

Regards
Michel
Previous Topic: Create Database Working
Next Topic: Order of patches to rollback
Goto Forum:
  


Current Time: Thu Dec 08 08:39:59 CST 2016

Total time taken to generate the page: 0.12989 seconds