Home » RDBMS Server » Server Administration » need help with estimating size of database/datafiles (8.1.7,win 2003 server)
need help with estimating size of database/datafiles [message #463752] Sat, 03 July 2010 01:38 Go to next message
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
Senior Member
Hi,

I would be grateful if someone could explain me this:

I have checked the space of my tablespaces/datafiles in my database. I have 8 GB space left in my database server. I cant add more hard-disk as there is no slot left. We r planning to buy a new server with latest config.

My question is, how can we know upto what size our database can increase and when a datafile need to be added in advance. Sometimes even though datafiles have space left,it shows errors abt extents cannot be extended. We have coalesce the tablespaces and added a new datafile.

Best Regards,
Re: need help with estimating size of database/datafiles [message #463758 is a reply to message #463752] Sat, 03 July 2010 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to follow the growth of your database and estimate future size.

Regards
Michel
Re: need help with estimating size of database/datafiles [message #463761 is a reply to message #463758] Sat, 03 July 2010 02:50 Go to previous messageGo to next message
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
Senior Member
Thanks Michel, excellent notes.
Re: need help with estimating size of database/datafiles [message #463884 is a reply to message #463752] Mon, 05 July 2010 01:50 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi Michel,

When I just try to open the link provided by you as the answer, it ask for the username and password which username and the password I have to enter?

Regards
Deepak
Re: need help with estimating size of database/datafiles [message #463928 is a reply to message #463884] Mon, 05 July 2010 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just register (click on Account/Register) as you did it to post here.

Regards
Michel
Re: need help with estimating size of database/datafiles [message #464044 is a reply to message #463928] Tue, 06 July 2010 00:43 Go to previous message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Thanks Michel, Helped alot.

Regards
Deepak
Previous Topic: How to Resize Temp Tablespace
Next Topic: error in identifying datafile
Goto Forum:
  


Current Time: Sun May 19 19:48:21 CDT 2024