Artifactory Oracle Database Creation

⚠️

Storing BLOBs inside Oracle

The suggested (and recommended) configuration stores all artifact information in Oracle database while the artifact binary data is stored on the file system (under $JFROG_HOME/artifactory /var/data/artifactory/filestore).

While it is not recommended, it is possible to store BLOBs inside Oracle database provided that the typical BLOB size is relatively small.

To store BLOBs in Oracle, configure the Filestore with the Full-DB and Full-DB-Direct Binary Providers. When using this option, create a tablespace large enough to accommodate your binaries.

📘

Artifactory privileges

Artifactory creates all tables automatically the first time it runs. When performing a software upgrade, Artifactory may alter tables and indices, so grant the configured connection the appropriate user permissions to perform such actions.

✅

Recommendation

With both of the above options (Full DB and DB-Filesystem), we recommend creating a dedicated tablespace and using AL32UTF8 encoding.

Reclaiming BLOB space

For efficiency, Artifactory uses a checksum to ensure that only one copy of any binary data is stored. You can reclaim deleted BLOB space periodically by shrinking the BLOB tablespace as follows.

{schema}.binary_blobs modify lob (data) (shrink space cascade);