What determines JIRA Oracle DB parameters?

Question

Looking in the database parameters, there are various jira.__sga_target ones etc.  What is the purpose of these?  How are the values derived?

Sue Bridges · Answer

Hi,

OK, if it gets them from the database setup, that's fine.

Thanks

Sue

Nic Brough -Adaptavist- · Answer

Those are things set by your DBAs/System owners.

Jira expects you to set up an empty database for it to use as a datastore.  The settings it needs from the database are some precise permissions, and for it to be set to utf-8.  All the other properties are up to you.

See https://confluence.atlassian.com/adminjiraserver071/connecting-jira-applications-to-oracle-802592181.html for the stuff Jira needs from an Oracle db.