Home » RDBMS Server » Server Administration » Autoextend Datafile (Oracle 10gR2,Solaris 10)
Autoextend Datafile [message #283562] Tue, 27 November 2007 08:30 Go to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
The tablespace consist of 1 datafile of 10GB.Using the OEM the graph shows 10MB free.I have enabled autoextend of 100MB to the datafile.
Even after doing lots of inserts still i don't see any increase in either the filesize or in OEM.
Re: Autoextend Datafile [message #283563 is a reply to message #283562] Tue, 27 November 2007 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because there was free space inside your tables or inside the blocks of your tables.

Regards
Michel
Re: Autoextend Datafile [message #283567 is a reply to message #283563] Tue, 27 November 2007 08:38 Go to previous messageGo to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
Does that mean OEM graph is not accurate,because we have done lots of inserts data of more than 10MB but still the graph shows 10MB free.
Re: Autoextend Datafile [message #283569 is a reply to message #283567] Tue, 27 November 2007 08:41 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

.I have enabled autoextend of 100MB
You enable autoextend on. and did you check tablespace size before & after data inseration through v$view ?
Re: Autoextend Datafile [message #283575 is a reply to message #283567] Tue, 27 November 2007 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't use OEM, I don't trust OEM.
As Mohammad Taj once said:
Quote:

Those who live by the GUI, die by the GUI.

Regards
Michel
Re: Autoextend Datafile [message #283578 is a reply to message #283575] Tue, 27 November 2007 09:07 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Micheal,
This was Ana words not mine.Smile
http://www.orafaq.com/forum/m/282137/93410/?srch=Those+who+live+by+the+GUI%2C+die+by+the+GUI#msg_282137
Re: Autoextend Datafile [message #283598 is a reply to message #283578] Tue, 27 November 2007 10:27 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry for the wrong person.
I have to pay to Ana what is due to Ana:
Thanks Ana for this proverb.

Regards
Michel
Previous Topic: Comparing data structures
Next Topic: Table Scan: (stale) obj#
Goto Forum:
  


Current Time: Sun Dec 04 14:33:10 CST 2016

Total time taken to generate the page: 0.08891 seconds