| TABLESPACES [message #90443] |
Thu, 25 September 2003 11:43  |
Upperm
Messages: 95
Registered: July 2003
|
Member |
|
|
Hello folks,
I'm an oracle newbie. I'm using Win2k.
My question is about tablespaces!
1/ I really like to understand which option will be the best for a tablespace :
EXTENT MANAGEMENT LOCAL or EXTENT MANAGEMENT DICTIONARY ?
2/ I've created a tablespace like this:
CREATE TABLESPACE DATAS
DATAFILE 'C:ORADATAVENUSDATAS1.DBF' SIZE 1M REUSE;
What will happen when the "DATAS1.DBF" is filled ?
MERCI for your help :)
|
|
|
|
| Re: TABLESPACES [message #90444 is a reply to message #90443] |
Thu, 25 September 2003 13:44  |
Manish
Messages: 79
Registered: December 2000
|
Member |
|
|
1) Dictionary managed tablespaces keep the metadata information of the tablespace in the dictionary ( dba_ views). Every time you need a new extent in the tablespace there is a recursive query to the dictionary this is a very expensive process.
2) Locally managed tablespaces keep the free extents informtion in the form of a bitmap at the header of the tablespace. So there is no recursive sql to the dictionary to find free extents. Locally managed tablespaces have uniform extent alLocation hence there is no fragmentation.
For mroe details refer documentation.
Once your datafile is full( if it si not set to autoextend on), of you try to write into it. you will get errors.
This is a nutshell for more details refer documetaion.
Manish
|
|
|
|
| Re: TABLESPACES [message #90448 is a reply to message #90444] |
Fri, 26 September 2003 12:05 |
Upperm
Messages: 95
Registered: July 2003
|
Member |
|
|
Thanks a lot for your help MANISH.
Now things for me are more clarified.
though I still haven't found yet a location to get more documentation about tablespaces. I'll be thankful if you show me where to refer to it :)
Thank you once again.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
