It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jira software data center oracle instance

Hello, regarding Oracle database, Is there any other requirement than the character set, the DB_BLOCK_SIZE parameter and ACO that I could find in Atlassian documentation ? Thanks. Nicole

1 answer

The Atlassian doc for this should get you going. Also check the supported platforms page for the version of Jira you are running. You need to run a supported version of Oracle or you may have issues. 

Hello Dave, thank you for the links. The additional information that i was thinking about were about the sizing (Database Size, Redo size, Undo size, Temp size, Number of redos, Archivelog size/da ...). Regards,

I wouldn't go too crazy on it.  The normal database usage, even for a large instance isn't huge.  The SQL calls are generally pretty well optimized.  Without knowing your expected growth and usage, it's a bit difficult to get too precise, but I think you should be safe for a while with the following:

  • 20GB DB size
  • 2 redo volume for redundancy
  • Archive double of DB size

Most people run on MySQL or Postgres with a fairly basic configuration, so there really isn't a need for massive scale. 

If you really want to warm up the database, the two most expensive operations that Jira does are reindexing and the XML backup. If you have a lot of data in your instance, doing either of those will put some good load on the DB.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

274 views 1 2
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you