| Maximum Size setting of datafiles [message #385466] |
Mon, 09 February 2009 18:11  |
niswonp
Messages: 4
Registered: September 2008
Location: Umpqua Community College
|
Junior Member |
|
|
I have a tablespace with 2 datafiles in my 10.2.0.3 database. Both datafiles are set to autoextend, with a maximum size set to 3G. If I issue "select * from dba_data_files", I see that "bytes" and "maxbytes" are the same value. I know the data in the tables within this tablespace are growing. However, I guess I don't understand, because the appearance is that there is no room for growth. Am I misunderstanding what the "maximum size" means? I though that "maximum size" was the maximum Oracle would allow a datafile to get. Then you tend to see a crash or hang. What am I missing?
Thanks in advance
|
|
|
|
|
|
| Re: Maximum Size setting of datafiles [message #385478 is a reply to message #385468] |
Mon, 09 February 2009 18:58  |
niswonp
Messages: 4
Registered: September 2008
Location: Umpqua Community College
|
Junior Member |
|
|
Solaris is reporting both at 3221233664 bytes, just under 3.1G. However, OEM is reporting the first file at 77.16% used and the second at at 64.03% used.
When using SQL Plus, should I be looking at someplace other than dba_data_files?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
