| RE: Initial , Next sizes [message #62972] |
Mon, 30 August 2004 01:46  |
dhnish
Messages: 26
Registered: March 2002
|
Junior Member |
|
|
Hi
My tablespace and datafiles has been created by my consultants earlier. Now, how can i find out what is the initial and next size used when one of this datafile was created
Do i check from dba_data_files- in-reference to 'increment_by' column.The block size used is 8192.
Pls advice.This is vry urgent.
Thank you and have a nice day
Yours in service,
dhnish
|
|
|
|
|
|
| Re: RE: Initial , Next sizes [message #62985 is a reply to message #62984] |
Mon, 30 August 2004 09:27  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
SELECT tablespace_name, initial_extent, next_extent, extent_management
FROM user_tablespaces;
If you have locally managed tablespaces and aren't using uniform extents, then next_extent will show as null.
|
|
|
|
|
|
| Re: RE: Initial , Next sizes [message #63001 is a reply to message #63000] |
Wed, 01 September 2004 00:07 |
dhnish
Messages: 26
Registered: March 2002
|
Junior Member |
|
|
Dear Andrew,
Using the statement given by u it indicates for a particular TS , the initial_extent and next_extent to be as 40960.
So is this figure in bytes? If so it would be something like 40K , right
Pls advice
Thank you and have a nice day
Yours in service
dhnish
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
