I have an RDS Oracle SE2 instance with Amazon RDS. Our team is looking forward to move couple of applications to RDS. But we’re looking for options that are available in RDS Oracle SE to perform Performance tuning and management.

As of now I’m aware I can use Statspack. With Statspack not being supported by Oracle now, I’m looking for other options compatible with AWS RDS. Will OUTLINES work with RDS for Plan management ?

Has anyone tried any other tools that could help? Please advise.


You may want to run an EC2 instance as a dev environment. Given that you don't have access to the file system on an RDS database and that you have standard edition, you can't turn on 10046 and 10053 events and use tkprof to read the files, you can't use active session history (ASH) and Automatic Workload Repository (AWR) since you need to have enterprise to use those reports and Oracle would know if you used any of those features in an audit situation.

Your best bet is to look for blocking locks in prod and use and EC2 instance to do load testing possibly using set events 10046 and 10053. There might be another tool that you can use in RDS. I don't know what that would be. You are limited in what you can do give that you are running standard edition on an RDS instance.

  • I am not sure that will provide the needed information as the hardware and performance of the system on EC2 and RDS will be different. Depending on the setup of the RDS something as simple as doubling the amount of storage space available can have a drastic impact on performance from having more iops available. – Joe W Jan 14 at 14:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.