How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
DISASSOCIATE STATISTICS → Purpose Use the DISASSOCIATE STATISTICS statement to disassociate default statistics or a … statistics type from columns, standalone functions, packages, types, domain indexes, or indextypes. See Also … : ASSOCIATE STATISTICS for more information on statistics type associations Prerequisites To issue
Optimizer Statistics → The optimizer statistics are a collection of data that describe details about the database and the … objects in the database. The statistics provide a statistically correct picture of data storage and … distribution usable by the optimizer when evaluating access paths. Optimizer statistics include the … following: Table statistics
ASSOCIATE STATISTICS → Purpose Use the ASSOCIATE STATISTICS statement to associate a statistics type (or default … statistics) containing functions relevant to statistics collection, selectivity, or cost with one or more … current statistics type associations, query the USER_ASSOCIATIONS data dictionary view. If you analyze
STATISTICS → Default: ALWAYS Specifies what is done with the database optimizer statistics at import time. The … options are: ALWAYS Always import database optimizer statistics regardless of whether they are … questionable. NONE Do not import or recalculate the database optimizer statistics. SAFE Import database … optimizer statistics
STATISTICS → Default: ESTIMATE Specifies the type of database optimizer statistics to generate when the exported … precalculated statistics in the export file, and also the ANALYZE statements to regenerate the … statistics. However, the precalculated optimizer statistics will not be used at export time if a table has … columns
Index Statistics → The index statistics include information about the number of index levels, the number of index … blocks, and the relationship between the index and the data blocks. The optimizer uses these statistics to determine the cost of index scans.
Adaptive Statistics → DOP of 4\" The database inserts a statistics collector in front of each producer process scanning the … departments table. The query coordinator aggregates the collected statistics. The distribution … method is based on the run-time statistics. In Figure 4-8, the number of rows is below the threshold (8 … following plan, the threshold
Column Statistics → Column statistics track information about column values and data distribution. The optimizer uses … column statistics to generate accurate cardinality estimates and make better decisions about index … usage, join orders, join methods, and so on. For example, statistics in DBA_TAB_COL_STATISTICS track … information The optimizer
System Statistics → Shared and Session-Specific Statistics for Global Temporary Tables Starting in Oracle Database 12 c … , you can set the table-level preference GLOBAL_TEMP_TABLE_STATS to make statistics on a global … SESSION, you can gather optimizer statistics for a global temporary table in one session, and then use … the statistics
Table Statistics → In Oracle Database, table statistics include information about rows and blocks. The optimizer uses … these statistics to determine the cost of table scans and table joins. DBMS_STATS can gather … statistics for both permanent and temporary tables. The database tracks all relevant statistics about … permanent tables.
Additional Statistics → There are several statistics that can indicate performance problems that do not have corresponding … -consistent image of the table. Compare the following V$SYSSTAT statistics to determine whether this is … is called delayed block cleanout. The ratio of the following V$SYSSTAT statistics should be close to … -Related Statistics
Unlocking Statistics → The DBMS_STATS package provides two procedures for unlocking statistics: UNLOCK_SCHEMA_STATS and … UNLOCK_TABLE_STATS. Assumptions This tutorial assumes the following: You locked statistics on the … oe.orders table and on the hr schema. You want to unlock these statistics. To unlock statistics: Start … SQL*Plus
Locking Statistics → The DBMS_STATS package provides two procedures for locking statistics: LOCK_SCHEMA_STATS and … LOCK_TABLE_STATS. Assumptions This tutorial assumes the following: You gathered statistics on the … oe.orders table and on the hr schema. You want to prevent the oe.orders table statistics and hr schema … statistics
5.1.7 Enabling Access to Spatial Index Statistics → The Oracle Database optimizer collects statistics that describe details about the database and its … objects. Statistics are critical to the optimizer's ability to pick the best execution plan for a … SQL statement. For more information about optimizer statistics, see Oracle Database SQL Tuning Guide … DBMS_STATS.GATHER_SCHEMA_STATS
Part V Optimizer Statistics → The optimizer relies on statistics to create execution plans. This part contains the following … chapters: Optimizer Statistics Concepts Histograms Managing Optimizer Statistics: Basic Topics Managing Optimizer Statistics: Advanced Topics
Gathering Workload Statistics → Use DBMS_STATS.GATHER_SYSTEM_STATS to capture statistics when the database has the most typical
10 Optimizer Statistics Concepts → Oracle Database optimizer statistics describe details about the database and its objects. This … chapter includes the following topics: Introduction to Optimizer Statistics About Optimizer Statistics … Types How the Database Gathers Optimizer Statistics When the Database Gathers Optimizer Statistics
Interpreting Database Statistics → by examining the database statistics. To ensure that your interpretation is accurate, cross-check … are tunable, it is recommended to first analyze the statistics from foreground activities before … analyzing the statistics from background activities. The following sections provide tips for … interpreting the various types of
Publishing Pending Optimizer Statistics → By default, the database automatically publishes statistics when the statistics collection ends … . Alternatively, you can use pending statistics to save the statistics and not publish them immediately … statistics. When the test results are satisfactory, you can publish the statistics
Wait Events Statistics → is set to true, how long each resource was waited for. See Also: \" Setting the Level of Statistics … statistics for that session are removed from this view. V$SYSTEM_EVENT lists the events and times waited for