| XE Limitations [message #503384] |
Fri, 15 April 2011 03:22  |
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 #520334 is a reply to message #503394] |
Sun, 21 August 2011 21:12  |
 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
