It's very hard to improve Oracle performance on RDS as there is not much control over the database sys user. Anyways, try below things to quick fix the performance:
Optimize Join Conditions
Many developer when they write join conditions, they actually start with a query which returns highest number of records and then join it over to another table which fetches less records. In such cases, you must make sure the driving query is fetching least amount of records.
Bind Variables
Ask developer team to use more of bind variables for queries rather than literals.
Resize Temp Tablespace
Many a times temp is overlooked in AWS RDS, make sure you constantly check temp tablespace size and add space as required.
Also, let us know if querying from database is slow or importing to RDS using datapump is slow? Coz most of the times people complain about RDS slow datapump imports.
I created a toolkit that works on standard edition. Ee too it pulls data out and runs 100s of checks to improve performance. Send me email and will help you. I use it on several e-commerce sites and custom built apps.
It's very hard to improve Oracle performance on RDS as there is not much control over the database sys user. Anyways, try below things to quick fix the performance:
Optimize Join Conditions
Many developer when they write join conditions, they actually start with a query which returns highest number of records and then join it over to another table which fetches less records. In such cases, you must make sure the driving query is fetching least amount of records.
Bind Variables
Ask developer team to use more of bind variables for queries rather than literals.
Resize Temp Tablespace
Many a times temp is overlooked in AWS RDS, make sure you constantly check temp tablespace size and add space as required.
Also, let us know if querying from database is slow or importing to RDS using datapump is slow? Coz most of the times people complain about RDS slow datapump imports.
I created a toolkit that works on standard edition. Ee too it pulls data out and runs 100s of checks to improve performance. Send me email and will help you. I use it on several e-commerce sites and custom built apps.
robert