Home » RDBMS Server » Server Administration » find Database Size (Oracle 11gR2, windows xp)
find Database Size [message #576124] Thu, 31 January 2013 14:47 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I have Oracle 11gR2 running on windows xp machine.

Windows xp has total size of 150 GB and free space of 95 GB.

I checked the size of the database that I created. It showed the total size of the database as 2 GB and used space as 2 GB. If I want to increase the total size of the database to 50 GB, what should i do?

Now which is the disk space size? Windows or Oracle? Shocked
Re: find Database Size [message #576125 is a reply to message #576124] Thu, 31 January 2013 14:53 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

> If I want to increase the total size of the database to 50 GB, what should i do?
add 1 or more files to existing tablespace or create new tablespace.



Re: find Database Size [message #576126 is a reply to message #576125] Thu, 31 January 2013 14:54 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
In this case, what is the disk size?
Re: find Database Size [message #576127 is a reply to message #576126] Thu, 31 January 2013 15:00 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
>In this case, what is the disk size?
I only know what you post.
>Windows xp has total size of 150 GB and free space of 95 GB.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: find Database Size [message #576128 is a reply to message #576126] Thu, 31 January 2013 15:00 Go to previous message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your opinion?

Regards
Michel
Previous Topic: Change Database Character set
Next Topic: OFA confuse me - why 3 mount points for datafiles?
Goto Forum:
  


Current Time: Sat Aug 02 02:57:05 CDT 2014

Total time taken to generate the page: 0.09853 seconds