|
Home > Archive > Oracle Server > April 2006 > a view to know the "maxsize" a datafile can grow ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
a view to know the "maxsize" a datafile can grow ?
|
|
| Patrox 2006-04-05, 9:24 am |
| hi !
is there a view allowing to check simply to which size a datafile in
autoextend mode can grow ? or if it is in "unlimited" size mode ?
thx a lot,
best regards,
Patrox
| |
| stevedhoward@gmail.com 2006-04-05, 9:24 am |
| select maxbytes from dba_data_files;
| |
| Patrox 2006-04-05, 9:24 am |
| thx !
for "unlimited", in reality isn't it a large value like "16384" MB in
dba_data_files' maxbytes field ?
stevedhoward@gmail.com a écrit :
> select maxbytes from dba_data_files;
>
| |
| st.anderson@gmail.com 2006-04-06, 9:24 am |
| It depends on the platform, your block size, and what the ulimits are
set to. It really means it will go as large as the OS will allow. I
generally don't go for anything bigger than 32Gb. Check with your OS
admins to see what is set on your server.
HTH,
Steve.
|
|
|
|
|