What would you implement to resolve this problem?

DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operations Team.
What would you implement to resolve this problem?

DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operations Team.
What would you implement to resolve this problem?

A.
Complete Oracle Enterprise Manager suite

B.
SQL Performance Analyzer which helps predict and prevent SQL execution performance problems causedby environment changes

C.
SQL Plan Manager which uses system histograms to extrapolate future SQL execution performance

D.
Oracle Database Backup & Recovery

E.
Oracle SQL Developer, which helps develop and test the SQL prior to putting it into production



Leave a Reply 1

Your email address will not be published. Required fields are marked *