DBA communities took statspack and AWR very warmly but as it happens usually there are many features, ignored to name few:
1. SQL Monitoring
2. AWR Baseline and AWR Comparison report
3. Real Application test
4. Incident management
5. ASH still ignored by lot of people
6. Query to AWR hist tables are not used.
7. SQL Advisory on SQL Tuning Set
8. Stored Outlines (released long back)
9. SQL PLANBASELINE
10. Gathering Plan with Statistics Hint
11. Stored Execution plan in AWR (certainly not v$SQLPLAN)
12. ORION for I/O calibration before DB setup or Oracle Calibration package in 11g post DB creation.
13. UTL_MAIL to send email from Oracle Database
Similarly there have been many features which we accept without bothering its impact , to name few :
-Automatic Shared Memory Management
-Automatic Memory Management
1. SQL Monitoring
2. AWR Baseline and AWR Comparison report
3. Real Application test
4. Incident management
5. ASH still ignored by lot of people
6. Query to AWR hist tables are not used.
7. SQL Advisory on SQL Tuning Set
8. Stored Outlines (released long back)
9. SQL PLANBASELINE
10. Gathering Plan with Statistics Hint
11. Stored Execution plan in AWR (certainly not v$SQLPLAN)
12. ORION for I/O calibration before DB setup or Oracle Calibration package in 11g post DB creation.
13. UTL_MAIL to send email from Oracle Database
Similarly there have been many features which we accept without bothering its impact , to name few :
-Automatic Shared Memory Management
-Automatic Memory Management
Posts
