Thanks for the question, David.
Asked: May 25, 2022 - 10:57 am UTC
Last updated: May 27, 2022 - 6:36 am UTC
Version: 19c
Viewed 1000+ times
You Asked
Amazon Web Services usurps ownership of the SYSDBA functions, which IMO seems to work pretty well. According to the DBA_ADVISOR_RECOMMENDATIONS view, there's still work to be done. Do you have any thoughts on what parameter tuning is still appropriate? Object defragmentation and memory pools allocation are the two examples I have in mind. TIA
and Connor said...
Under RDS your capabilities are basically at the whim of what AWS is prepared to let you do, and what's available via the RDS_ADMIN package.
Pretty much with any managed service on a cloud provider, most of the focus shifts to good database design, good database code and SQL tuning.
Don't get me wrong, I'm not being critical of that. In my view, 99% of performance in a database lies in application/design tier...not on the infrastructure config.
Is this answer out of date? If it is, please let us know via a Comment