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: 204
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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Because there was free space inside your tables or inside the blocks of your tables.

Regards
Michel

Report message to a moderator

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: 204
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.

Report message to a moderator

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 ?

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

Re: Autoextend Datafile [message #283598 is a reply to message #283578] Tue, 27 November 2007 10:27 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 01:23:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.