Home » RDBMS Server » Server Administration » Maximum Size setting of datafiles (RDBMS, 10.2.0.3, Solaris 10)
Maximum Size setting of datafiles [message #385466] Mon, 09 February 2009 18:11 Go to next message
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 #385468 is a reply to message #385466] Mon, 09 February 2009 18:26 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

What size of these files is reported by Solaris?
Re: Maximum Size setting of datafiles [message #385478 is a reply to message #385468] Mon, 09 February 2009 18:58 Go to previous messageGo to next message
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?
Re: Maximum Size setting of datafiles [message #385479 is a reply to message #385466] Mon, 09 February 2009 19:03 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>When using SQL Plus, should I be looking at someplace other than dba_data_files?

alternatively DBA_FREE_SPACE

http://www.ss64.com/orad/DBA_FREE_SPACE.html
Previous Topic: Flush shared pool
Next Topic: Trouble with DCA
Goto Forum:
  


Current Time: Tue Dec 06 13:54:20 CST 2016

Total time taken to generate the page: 0.06849 seconds