OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » find Database Size (Oracle 11gR2, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

find Database Size [message #576124]

Thu, 31 January 2013 14:47

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

Report message to a moderator

Re: find Database Size [message #576125 is a reply to message #576124]

Thu, 31 January 2013 14:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

lg123
Messages: 225
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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Michel Cadot
Messages: 68641
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 13:38:31 CDT 2024