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: 208
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

Report message to a moderator

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

Report message to a moderator

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: 208
Registered: August 2008
Senior Member
In this case, what is the disk size?

Report message to a moderator

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: 20085
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/

Report message to a moderator

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: 54124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your opinion?

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 04:30:21 CDT 2013

Total time taken to generate the page: 0.24502 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.