Home » RDBMS Server » Server Administration » XE Limitations
XE Limitations [message #503384] Fri, 15 April 2011 03:22 Go to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
I have read following statement from a link

http://www.oracle.com/technetwork/database/express-edition/overview/index.html

Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine.


Can any one tell clarify me about the calculation of this 4GB size. how can we calculate this size?

by simply going to DBF file and seeing their size?
or
by exporting dump and seeing the size of that dump?

Re: XE Limitations [message #503390 is a reply to message #503384] Fri, 15 April 2011 03:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how can we calculate this size?

select sum(bytes) from dba_data_files;

Regards
Michel
Re: XE Limitations [message #503394 is a reply to message #503390] Fri, 15 April 2011 04:09 Go to previous messageGo to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
[quote
Michel
[/quote]


sir thanks a lot. it really helped me in deciding either to adopt XE or not.
Re: XE Limitations [message #520334 is a reply to message #503394] Sun, 21 August 2011 21:12 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Try

select sum(bytes)/1024/1024 "MBytes" from dba_data_files where tablespace_name = 'USERS';

David
Previous Topic: oracle, root and brother are constantly conflicting
Next Topic: Trying to change tablespace and datafile properties on the fly
Goto Forum:
  


Current Time: Thu Mar 28 09:45:22 CDT 2024