Home » RDBMS Server » Performance Tuning » How to increase the database size of oracle 9i (Oracle 9i)
How to increase the database size of oracle 9i [message #311411] Fri, 04 April 2008 07:20 Go to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
can any body tell me how to increase the database size,Any document please will help me
Re: How to increase the database size of oracle 9i [message #311413 is a reply to message #311411] Fri, 04 April 2008 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean? Explain in details what you want.

Regards
Michel
Re: How to increase the database size of oracle 9i [message #311417 is a reply to message #311413] Fri, 04 April 2008 07:54 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Actually My database size is 9.79 GB by querying this I am getting is 9.79 GB
select sum(bytes)/1024/1024/1024||'SIZE' IN "GB" from dba_segments;
SIZE IN GB
------------------
9.79 GB

AFTER QUERYING THIS QUERY
SELECT SUM(BYTES)/1024/10244/1024||'SIZE' IN "GB" FROM DBA_FREE_SPACE
SIZE IN GB
-----------------
1.49 GB

Now could you please tell me Is there any need to resize the size of database by 1500 MB.How I should resize it.Any document please
Re: How to increase the database size of oracle 9i [message #311465 is a reply to message #311417] Fri, 04 April 2008 10:12 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Any document please

Administrator's Guide
Database SQL Reference

Regards
Michel
Previous Topic: update takes much time to execute
Next Topic: Query Tuning
Goto Forum:
  


Current Time: Wed Dec 07 16:18:55 CST 2016

Total time taken to generate the page: 0.34299 seconds