Saturday, May 16, 2015

Oracle Locally Managed TS

It uses bit map to manage free space in each of the tablespace, instead of linked list as in dictionary managed TS.  This avoid concurrency problem with dictionary and more efficient.

Oracle Managed File
This feature simply storage management for simple database.  Space will be removed when the TS is dropped.  The drawback is that it cannot stip across multiple disks (but can be used if the SAN provide transparent striping).

No comments: