| Localy manage Tablespace [message #54188] |
Sun, 03 November 2002 23:08  |
jagjeet singh
Messages: 16
Registered: October 2001
|
Junior Member |
|
|
hi Friend ..
i can get each and every extent info about
localy manage tablespace in DBA_EXTENTS or DBA_SEGMENTS Dictionary ...
if localcy manage tablespace stores all info in dictionary then it what info it stores in Bitmaps ...
and how can we get bitmap info ..
Pls Tell me ...
|
|
|
|
| Re: Localy manage Tablespace [message #54349 is a reply to message #54188] |
Tue, 12 November 2002 11:22  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Jagjeet,
Locally managed tablespaces do record free space left at tablespace level and DBA_FREE_SPACE view maybe used to query it. Even if the LMT does NOT uses the "regular" SYS.FET$/SYS.UET$ tables to store free/used space info, it still uses some new SYS.X$... tables. However all the views (DBA_FREE_SPACE, DBA_EXTENTS, DBA_SEGMENTS, etc.) were changed by Oracle to reflect it.
Oracle gets the FREE_SPACE information from the Datafile Header which has the Bitmap of the free space.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
