|
|
|
|
| Re: How to increase the database size of oracle 9i [message #311417 is a reply to message #311413] |
Fri, 04 April 2008 07:54   |
manoj12
Messages: 210
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
