Oracle XE question

Hello,

We want to develop an Asp.net application and we want to decide what database to use.

We though of MySql, Oracle Xe or Sql server.

Oracle states that Oracle Xe can use 1 CPU, 1GB Ram,        11GB database.

Does this mean, that the computer should not have more of above, or the database will not use more resources than those?

I mean nowadays I simply cannot assemble a computer with 1 Gb ram and 1 core Cpu ... even my mobile phone has more :-)

Thank you
starhuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
>>Does this mean, that the computer should not have more of above, or the database will not use more resources than those?

Computer can have anything it wants.  Only the Oracle XE instance can consume what is bound by the license.

I believe it is up to you to abide by the license.  I believe there are some safe-guards built in that will limit some things like CPU, memory, disk but there are also some hardware tricks that might fake it out.  If you use those, you are accountable.

Just because you can get it to run in an unlicensed state doesn't mean it is licensed...
0
starhuAuthor Commented:
Should I ask Oracle directly to be sure?
0
sdstuberCommented:
It won't hurt to ask Oracle if you have a question about licensing.

XE is hardwired so  "the database will not use more resources than those"

I've run XE on a multi-core-multi-processor machine with 32gb of ram and far more than 11gb of storage.  XE runs just fine but it does not come anywhere close to using all of the hardware.  It only uses one core of one processor, never consumes more than 1gb of memory and will generate an error if you try to load more than 11gb of data.

I'm not sure what "hardware tricks" slightwv is referring to.  I believe that it would be possible to circumvent the licensing restrictions but I don't recommend doing that (and I'm sure he isn't either.)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.