SQL Advisor
Combines SQL Tuning Advisor, SQL Access Advisor, and Partition Advisor
(mentioned above). Covered in more detail in Chapter 7.
Chapter 5: Managing Oracle
This chapter covers Oracle Enterprise Manager improvements and manageability
offered in Oracle Database 11g. New features include:
SQL Performance Impact Advisor
Forecasts how system changes will impact SQL performance.
Undo Advisor
Enables automatic undo management.
Health Monitor infrastructure
Components enable a Support Workbench and include the SQL Test Case
Builder, SQL Repair Advisor, and Data Recovery Advisor.
Real Applications Testing Option
Enables capture of a production workload for replay in a test database
environment.
352 | Appendix A: What??™s New in This Book for Oracle Database 11g
Chapter 6: Oracle Security, Auditing, and Compliance
This chapter is new in this edition, although some of the material was covered in
Chapter 5 in previous versions of the book. The chapter also covers some significant
new features available with Oracle Database 11g:
Prompting for default security settings
To improve security ???out of the box,??? Oracle Database 11g installation procedures
prompt you to determine whether you want to keep the default security
settings.
Pages:
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756