Thanks for the question, Siva.
Asked: July 08, 2018 - 2:10 pm UTC
Last updated: July 18, 2018 - 1:11 am UTC
Version: 12.2
Viewed 1000+ times
You Asked
This question is from the context when App-server and Oracle Database is hosted on a vendor cloud. They are in a separate container and application will be in a separate container.
Example, App-server and DB on Oracle cloud and GUI on customer's private cloud. If customer needs to tune some DB settings, what options are available? Steps for customer(application user) for Database tuning on Database which is on a vendor cloud.
Could you please suggest.
and Connor said...
Nothing changes when tuning on cloud, Oracle or otherwise. The steps are always:
- find the source of largest performance impact
- resolve that
- move to next largest
AWR reports, statpack, v$ views, database tracing ... all the standard tools apply if you have access to them.
Perhaps one that that becomes more of focus is latency...if components (app, database, etc) are separated by "long" distances (ie, long networks) then ensuring chattiness of applications can become a dominant factor. But still - the usual tuning elements apply - use PL/SQL, use array fetching/binding etc
Is this answer out of date? If it is, please let us know via a Comment