Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Section 6: Enhanced Optimizer Statistics > Manage System Statistics
Manage System Statistics
Collecting system statistics and making these available to the Optimizer is performed using program units within the DBMS_STATS() package. These are the program units which we will consider in this section:
- CREATE_STAT_TABLE()
- GATHER_SYSTEM_STATS()
- GET_SYSTEM_STATS()
- SET_SYSTEM_STATS()
- IMPORT_SYSTEM_STATS()
- EXPORT_SYSTEM_STATS()
- DELETE_SYSTEM_STATS()
- DROP_STAT_TABLE()
Note
We mentioned earlier the possibility of employing user-defined statistics tables as part of the statistics collection effort. We will now demonstrate the use of these tables with system statistics. Bear in mind that such tables may also be used when collecting any Optimizer statistics, although they are most helpful for system statistics.