Skip to Main Content
  • Questions

  • Oracle Apex applicationson company DB

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, mustafa.

Asked: January 13, 2017 - 12:01 pm UTC

Last updated: January 13, 2017 - 4:24 pm UTC

Version: 11

Viewed 1000+ times

You Asked

Hi,

I am trying to create oracle apex applications for my company,the thing i am worried about is that the applications will be complex and would require a lot of space on the DB.Can you let me know what is the default DB size that is available if you download oracle DB standard edition? Also can you let me know how we can increase the size of the DB?
Please bear in mind,i am an oracle Apex developer but i don't have much experience on the DBA front.


Thanks,
Mustafa Ahmed

and Chris said...

The space available is however much disk space you allocate to your server!

Space you need for a default install is ~10Gb on Windows:

https://docs.oracle.com/database/121/NXDQI/toc.htm#NXDQI109

About half of this is allocated to the data files. i.e. where your data will live. How much you need beyond that entirely depends upon how much data you're storing.

If you wish to, you can limit the space needed by setting the max size of your data files:

http://docs.oracle.com/database/122/ADMIN/managing-data-files-and-temp-files.htm#ADMIN012

Data files belong to tablespaces. I'd recommend reading up on these in the concepts guide:

http://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT89026

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.