You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for statistics


1 to 20 of 2077 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database SQL Language Reference, 12c Release 1 (12.1)

DISASSOCIATE STATISTICS

DISASSOCIATE STATISTICSPurpose 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

Database Concepts, 12c Release 1 (12.1)

SQL

Optimizer StatisticsThe 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

Database SQL Language Reference, 12c Release 1 (12.1)

ASSOCIATE STATISTICS

ASSOCIATE STATISTICSPurpose 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

Database Utilities, 12c Release 1 (12.1)

STATISTICS

STATISTICSDefault: 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

Database Utilities, 12c Release 1 (12.1)

STATISTICS

STATISTICSDefault: 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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics Concepts

Index StatisticsThe 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.

Database SQL Tuning Guide, 12c Release 1 (12.1)

Query Optimizer Concepts

Adaptive StatisticsDOP 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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics Concepts

Column StatisticsColumn 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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics Concepts

System StatisticsShared 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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics Concepts

Table StatisticsIn 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.

Database Performance Tuning Guide, 12c Release 1 (12.1)

Instance Tuning Using Performance Views

Additional StatisticsThere 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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Managing Optimizer Statistics: Advanced Topics

Unlocking StatisticsThe 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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Managing Optimizer Statistics: Advanced Topics

Locking StatisticsThe 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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Enabling Access to Spatial Index Statistics

5.1.7 Enabling Access to Spatial Index StatisticsThe 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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics

Part V Optimizer StatisticsThe 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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Managing Optimizer Statistics: Basic Topics

Gathering Workload StatisticsUse DBMS_STATS.GATHER_SYSTEM_STATS to capture statistics when the database has the most typical

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics Concepts

10 Optimizer Statistics ConceptsOracle 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Measuring Database Performance

Interpreting Database Statisticsby 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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Managing Optimizer Statistics: Advanced Topics

Publishing Pending Optimizer StatisticsBy 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Instance Tuning Using Performance Views

Wait Events Statisticsis set to true, how long each resource was waited for. See Also: \" Setting the Level of Statisticsstatistics for that session are removed from this view. V$SYSTEM_EVENT lists the events and times waited for