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 1847 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

SQL

Optimizer StatisticsOptimizer 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, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Original Import

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, 11g Release 2 (11.2)

Original Export

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 Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Automatically Collecting Statistics on TablesThe PL/SQL package DBMS_STATS lets you generate and manage statistics for cost-based optimization … . You can use this package to gather, modify, view, export, import, and delete statistics. You can … also use this package to identify or name statistics that have been gathered. Formerly, you enabled … DBMS_STATS to automatically

Database Performance Tuning Guide, 11g Release 2 (11.2)

Managing Optimizer Statistics

13.5.8 Handling Missing StatisticsWhen Oracle Database encounters a table with missing statistics, by default the database … dynamically gathers the statistics needed by the optimizer. However, for certain types of tables, including … remote tables and external tables, Oracle Database does not gather dynamic statistics. In these cases … and also when dynamic statistics

Database Performance Tuning Guide, 11g Release 2 (11.2)

Configuring and Using Memory

7.4.2 Log Buffer Statistics$SYSSTAT. Use the following query to monitor these statistics over a period while your application is

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Statistics

5.1.1 Database StatisticsDatabase statistics provide information on the type of load on the database and the internal and … external resources used by the database. This section describes some of the more important statistics … . 5.1.1.1 Wait Events Wait events are statistics that are incremented by a server process or thread … I/O: wait for blocks to

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic SQL Tuning

17.1.1 Statistics AnalysisThe optimizer relies on object statistics to generate execution plans. If these statistics are … statistics, and produces two types of output: Recommendations to gather relevant statistics for … objects with stale or no statistics Because optimizer statistics are automatically collected

Database Performance Tuning Guide, 11g Release 2 (11.2)

Instance Tuning Using Performance Views

10.2.4 Additional StatisticsThere are several statistics that can indicate performance problems that do not have corresponding … obtain a read-consistent image of the table. Compare the following V$SYSSTAT statistics to … or updated. This is called delayed block cleanout. The ratio of the following V$SYSSTAT statistics … reorganize tables 10.2.4.4 Parse-Related

Database Performance Tuning Guide, 11g Release 2 (11.2)

Managing Optimizer Statistics

13.4 System StatisticsSystem statistics describe the system's hardware characteristics, such as I/O and CPU performance … I/O and CPU resources required for each query. System statistics enable the query optimizer to more … plan. When Oracle Database gathers system statistics, it analyzes system activity in a specified time … period (workload statistics)

Database Performance Tuning Guide, 11g Release 2 (11.2)

Managing Optimizer Statistics

13.4.2 Noworkload StatisticsNoworkload statistics consist of I/O transfer speed, I/O seek time, and CPU speed ( cpuspeednw … ). The major difference between workload statistics and noworkload statistics lies in the gathering … method. Noworkload statistics gather data by submitting random reads against all data files, while … workload statistics

Database Performance Tuning Guide, 11g Release 2 (11.2)

Managing Optimizer Statistics

13.5.2 Managing Extended StatisticsDBMS_STATS enables you to collect extended statistics, which are statistics that can improve … following types of extended statistics: Column group statistics This type of extended statistics … statement. See \"Managing Column Group Statistics\". Expression statistics

Database Performance Tuning Guide, 11g Release 2 (11.2)

Managing Optimizer Statistics

13.6 Controlling Dynamic StatisticsBy default, Oracle Database automatically gathers dynamic statistics when optimizer statistics are … missing or need augmentation. To obtain the statistics, the database uses recursive SQL during … parsing to scan a small random sample of table blocks. Note: Dynamic statistics were called dynamic … sampling in

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Statistics

5.1.3 Interpreting Statisticsstatistics. One way to ensure that your interpretation of the statistics is correct is to perform … , because foreground activities are tunable, it is better to first analyze the statistics from … foreground activities before analyzing the statistics from background activities. Some pitfalls are … timed statistics

Database Performance Tuning Guide, 11g Release 2 (11.2)

Managing Optimizer Statistics

13 Managing Optimizer StatisticsThis chapter explains why statistics are important for the query optimizer and how to gather and … use optimizer statistics with the DBMS_STATS package. The chapter contains the following sections … : Overview of Optimizer Statistics Managing Automatic Optimizer Statistics Collection Gathering … Statistics

Database Performance Tuning Guide, 11g Release 2 (11.2)

Managing Optimizer Statistics

13.3 Gathering Statistics ManuallyIf you do not use automatic optimizer statistics collection, then you must run DBMS_STATS to … manually collect statistics in all schemas, including system schemas. If the database content changes … regularly, then you must also gather statistics regularly to ensure that the statistics accurately … Statistics

Database Performance Tuning Guide, 11g Release 2 (11.2)

Managing Optimizer Statistics

13.6.2 Dynamic Statistics ConceptsDynamic statistics are enabled in the database by default. You can disable the feature by setting … the initialization parameter OPTIMIZER_DYNAMIC_SAMPLING=0. 13.6.2.1 Dynamic Statistics Levels The … dynamic statistics level controls both when the database gathers dynamic statistics, and the size of … the sample

Database Performance Tuning Guide, 11g Release 2 (11.2)

Managing Optimizer Statistics

13.7 Viewing StatisticsThis section discusses: Statistics on Tables, Indexes and Columns Viewing Histograms