Daryl, sorry to get back to you that late, hopefully (or hopefully not if everything runs fine on your system now) you are still interested in an reply on this.
Specific hits i cant give, since DB Setup is more the part of the DBA, but we have collected the top 6 reasons for bad DB performance within a KB Article which might be interesting for you and others who are facing issues, some of the points are oracle related, but most of them are general important points:
** NOTE **
the link which was posted before was invalid, since our supportportal moved please try following link:
https://automic.force.com/support/apex/CommunityArticleDetail?id=ka4b00000004MOH
within the post it is referring to the Automic Oracle Whitepaper, since the move this link is also not valid anymore, you can find the reference to the Whitepaper here:
https://community.automic.com/discussion/438/whitepaper-automic-oracle-database-security-recommendations
hope it helps you further