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_LEVEL


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


Database Reference, 12c Release 1 (12.1)

STATISTICS_LEVEL

1.276 STATISTICS_LEVELProperty Description Parameter type String Syntax STATISTICS_LEVEL = { ALL | TYPICAL | BASIC … STATISTICS_LEVEL specifies the level of collection for database and operating system statistics. The Oracle … adequate for most environments. When the STATISTICS_LEVEL parameter is set to ALL, additional … are timed operating system

Database Reference, 12c Release 1 (12.1)

V$STATISTICS_LEVEL

9.78 V$STATISTICS_LEVELV$STATISTICS_LEVEL displays the status of the statistics/advisories controlled by STATISTICS_LEVELSTATISTICS_LEVEL that enables the statistic/advisory: BASIC TYPICAL ALL STATISTICS_VIEW_NAME VARCHAR2(64) If … container ID for the rows containing data See Also: \" STATISTICS_LEVEL \"

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

Gathering Database Statistics

Enabling the Automatic Workload RepositorySTATISTICS_LEVEL initialization parameter. To enable statistics gathering by AWR: Set the STATISTICS_LEVEL … parameter to TYPICAL or ALL. The default setting for this parameter is TYPICAL. Setting STATISTICS_LEVELSTATISTICS_LEVEL is set to BASIC, you can still manually capture AWR statistics using the … may

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

Monitoring Database Operations

Enabling Monitoring of Database Operations at the System LevelThe SQL monitoring feature is enabled by default when the STATISTICS_LEVEL initialization parameter … (the default value). Assumptions This tutorial assumes the following: The STATISTICS_LEVEL … *Plus command: SQL> SHOW PARAMETER statistics_level NAME TYPE VALUE … ----------------------------------- ----------- ----- statistics_level

Database Administrator's Guide, 12c Release 1 (12.1)

Administering PDBs with SQL*Plus

42.4.2 Using the ALTER SYSTEM Statement on a PDBLevel for the PDB This ALTER SYSTEM statement sets the STATISTICS_LEVEL initialization parameter to ALL … for the current PDB: ALTER SYSTEM SET STATISTICS_LEVEL = ALL SCOPE = MEMORY; See Also: \" Using the

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

Measuring Database Performance

Using Wait Events with Timed StatisticsSTATISTICS_LEVEL is set to TYPICAL or ALL. If STATISTICS_LEVEL is set to BASIC, then you must set … TIMED_STATISTICS to TRUE to enable collection of timed statistics. Note that setting STATISTICS_LEVEL to BASIC … STATISTICS_LEVEL. See Also: Oracle Database Reference for information about the STATISTICS_LEVEL

Database Reference, 12c Release 1 (12.1)

V$GG_APPLY_COORDINATOR

NUMBER Active server counttrue, or if the STATISTICS_LEVEL initialization parameter is set to TYPICAL or ALL. See Also: \" TIMED_STATISTICS \" \" STATISTICS_LEVEL \"

Database Reference, 12c Release 1 (12.1)

V$STREAMS_APPLY_COORDINATOR

NUMBER Active server counttrue, or if the STATISTICS_LEVEL initialization parameter is set to TYPICAL or ALL. See Also: \" TIMED_STATISTICS \" \" STATISTICS_LEVEL \"

Database Reference, 12c Release 1 (12.1)

V$XSTREAM_APPLY_COORDINATOR

NUMBER Active server counttrue, or if the STATISTICS_LEVEL initialization parameter is set to TYPICAL or ALL. See Also: \" TIMED_STATISTICS \" \" STATISTICS_LEVEL \"

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

Automatic Performance Diagnostics

Setting Up ADDMCONTROL_MANAGEMENT_PACK_ACCESS and the STATISTICS_LEVEL initialization parameters. The … to NONE disables ADDM. The STATISTICS_LEVEL parameter should be set to the TYPICAL or ALL to enable … automatic database diagnostic monitoring. The default setting is TYPICAL. Setting STATISTICS_LEVEL to … STATISTICS_LEVEL

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tables

20.5 Automatically Collecting Statistics on Tablesdatabase uses these views to identify tables with stale statistics. The default for the STATISTICS_LEVEL … plans. Setting the STATISTICS_LEVEL initialization parameter to BASIC disables the collection of many of … monitoring of all tables, set the STATISTICS_LEVEL initialization parameter to BASIC. Automatic statistics … Also:

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

Analyzing SQL with SQL Tuning Advisor

Configuring the Automatic SQL Tuning TaskSTATISTICS_LEVEL initialization parameter to BASIC to disable collection of all advisories and statistics … , Oracle strongly recommends that you do not set STATISTICS_LEVEL to BASIC. To enable or disable Automatic … level setting. The following SQL*Plus command shows that STATISTICS_LEVEL is set to ALL: sys@PROD> SHOW … PARAMETER

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

Managing Optimizer Statistics: Basic Topics

Configuring Automatic Optimizer Statistics Collection from the Command Linewindow_name parameter. Set the STATISTICS_LEVEL initialization level to BASIC to disable collection of all … many automatic features are disabled, Oracle strongly recommends that you do not set STATISTICS_LEVEL … DBMS_AUTO_TASK_ADMIN package Oracle Database Reference to learn about the STATISTICS_LEVEL initialization parameter

Database Concepts, 12c Release 1 (12.1)

Memory Architecture

Java Poolthe parse rate. The Java Pool Advisor is internally turned on when statistics_level is set to TYPICAL

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

Generating and Displaying Execution Plans

The PLAN_TABLE used by the EXPLAIN PLAN statement contains the columns listed in this topic.available for cursors that have been compiled with the STATISTICS_LEVEL initialization parameter set to … $SQL_PLAN views Oracle Database Reference for information about the STATISTICS_LEVEL initialization parameter

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

Performing Application Tracing

Step 1: Setting Initialization Parameters for Trace File Managementof various statistics in the V$ views. If STATISTICS_LEVEL is set to TYPICAL or ALL, then the default … value of TIMED_STATISTICS is true. If STATISTICS_LEVEL is set to BASIC, then the default value of … TIMED_STATISTICS is false. See Oracle Database Reference for information about the STATISTICS_LEVEL

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

Performance Tuning Overview

Introduction to Performance Tuning Features and Toolscollection and automatic performance features, the STATISTICS_LEVEL initialization parameter must be … packages Oracle Database Reference for information about the STATISTICS_LEVEL initialization parameter

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Resources with Oracle Database Resource Manager

27.11 Monitoring Oracle Database Resource ManagerManager. when the STATISTICS_LEVEL initialization parameter is set to ALL or TYPICAL. See Also … resources that are not currently being managed by Resource Manager. when the STATISTICS_LEVEL … Manager. when the STATISTICS_LEVEL initialization parameter is set to ALL or TYPICAL. See Also: Oracle … currently being managed by Resource

Database Reference, 12c Release 1 (12.1)

TIMED_STATISTICS

1.283 TIMED_STATISTICSProperty Description Parameter type Boolean Default value If STATISTICS_LEVEL is set to TYPICAL or … ALL, then true If STATISTICS_LEVEL is set to BASIC, then false Modifiable ALTER SESSION, ALTER … TIMED_STATISTICS parameter cannot be set to false if the value of STATISTICS_LEVEL is set to TYPICAL or ALL. On

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

Managing Optimizer Statistics: Advanced Topics

Purging Optimizer StatisticsAutomatic purging is enabled when the STATISTICS_LEVEL initialization parameter is set to TYPICAL