23ai Free edition is great for developers but we have to be careful with respect to the “resource limits” and specifically the 12 GB of user data.
Which is specified as:
- “_12GB of user data on disk (irrespective of compression factor)_” in the FAQ: https://www.oracle.com/database/free/faq/#installation
- “_The maximum amount of user data in Oracle Database Free cannot exceed 12 GB_” in the online documentation: https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinl/licensing-restrictions.html#GUID-5B066473-0502-4ECA-9DF8-DA645386EA2A .
What I find interesting as what does not count towards that limit is:
- Tablespaces where the CONTENTS are either
UNDO or TEMPORARY
- The
SYSTEM tablespace
Meaning that SYSAUX does count as “user data”. And consequently, we have to greatly limit AWR retention, scheduler job log history, statistics history, etc, etc to maximize the available space for actual application data/tablespaces.
Any consideration @gerald-venzl-oracle of maybe removing SYSAUX from counting towards “user data” in the next release?
Thanks