Home » RDBMS Server » Server Administration » Tablespace?
Tablespace? [message #121459] Mon, 30 May 2005 00:01 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

My quetion is ....

--->What is dictionary managed tablespace and locally managed tablespace? And what are there importance?

From:- sunilkumar vishwanath mishra

Report message to a moderator

Re: Tablespace? [message #121460 is a reply to message #121459] Mon, 30 May 2005 00:25 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Dictionary-managed tablespaces rely on data dictionary tables to track space utilization. Beginning with Oracle8i, locally managed tablespaces can be created, which use bitmaps (instead of data dictionary tables) to track used and free space. These locally managed tablespaces provide better performance and greater ease of management.

For further details...
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96521/tspaces.htm#570

Report message to a moderator

Previous Topic: startup force
Next Topic: How to see index on table?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 07:38:05 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.