This feature can also produce
advice on new indexes to help enhance performance on queries using these indexes.
Default Database Resource Manager (DRM) plan
The default plan is designed to limit the resources used by automated maintenance
tasks, such as gathering statistics.
Chapter 10: Oracle Data Warehousing and Business Intelligence | 353
Chapter 8: Oracle Multiuser Concurrency
The ability to handle very large groups of users without excessive contention, while
protecting data integrity, has long been one of the best features of the Oracle database.
This capability has been a core part of the Oracle database for 20 years, but this
chapter also covers workspaces, which have changed a bit in the latest release:
Workspace enhancements
Provide support for optimizer hints for workspaces and a wider range of data
maintenance operations on workspace-enabled tables.
Chapter 9: Oracle and Transaction Processing
Oracle has been one of the leading databases for OLTP for many years. Although
Oracle Database 11g includes many enhancements to improve the performance and
manageability of the Oracle database when used for OLTP, there were no significant
new features covered in this chapter.
Pages:
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758