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 DBA_HIST_ACTIVE_SESS_HISTORY


1 to 19 of 19 results.


Database Reference, 12c Release 1 (12.1)

DBA_HIST_ACTIVE_SESS_HISTORY

4.230 DBA_HIST_ACTIVE_SESS_HISTORYDBA_HIST_ACTIVE_SESS_HISTORY displays the history of the contents of the in-memory active session

Database Reference, 12c Release 1 (12.1)

DBA_HIST_ACTIVE_SESS_HISTORY

IN_SEQUENCE_LOAD VARCHAR21   Indicates whether the session is loading in sequence in sequence load code…VARCHAR2(1)   Indicates whether the session was trickle repopulating the IM column store at the time of sampling ( Y ) or not ( N ) IN_SEQUENCE_LOAD VARCHAR2(1)   Indicates whether the session is loading in sequence (in sequence load code) ( Y ) or not ( N ) CAPTURE_OVERHEAD VARCHAR2(1)   Indicates whether the session is executing capture code ( Y ) or not ( N ) REPLAY_OVERHEAD VARCHAR2(1)   Indicates

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

Viewing Information About CDBs and PDBs with SQL*Plus

43.1 About CDB and PDB Information in Viewsthe root and displayed in some data dictionary views, such as the DBA_HIST_ACTIVE_SESS_HISTORY view

Database Concepts, 12c Release 1 (12.1)

Glossary

object linkmaking views such as DBA_HIST_ACTIVE_SESS_HISTORY and DBA_HIST_BASELINE accessible in each separate container.

Database Concepts, 12c Release 1 (12.1)

Overview of the Multitenant Architecture

An important part of an Oracle database is its data dictionary, which is a read-only set of tables that…point to the AWR data in the root, thereby making views such as DBA_HIST_ACTIVE_SESS_HISTORY and

Database Reference, 12c Release 1 (12.1)

DBA_HIST_PLAN_OPTION_NAME

5.26 DBA_HIST_PLAN_OPTION_NAMESQL_PLAN_OPTIONS column of the DBA_HIST_ACTIVE_SESS_HISTORY view. CON_DBID NUMBER   The database ID of the PDB

Database Reference, 12c Release 1 (12.1)

DBA_HIST_PLAN_OPERATION_NAME

5.25 DBA_HIST_PLAN_OPERATION_NAMEthe SQL_PLAN_OPERATION column of the DBA_HIST_ACTIVE_SESS_HISTORY view. CON_DBID NUMBER   The

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

Measuring Database Performance

Active Session History StatisticsDBA_HIST_ACTIVE_SESS_HISTORY view, often avoiding the need to replay the workload to trace additional

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

Gathering Database Statistics

Using Automatic Workload Repository Views: DBA_HIST_ACTIVE_SESS_HISTORY displays the history of the contents of the in-memory active session history

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

Analyzing Sampled Data

Interpreting Results from Active Session History Reportsminutes that are found in the DBA_HIST_ACTIVE_SESS_HISTORY table. To generate an ASH report for Oracle

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

Instance Tuning Using Performance Views

Implement and Measure Changeoccurring or V$ACTIVE_SESSION_HISTORY and DBA_HIST_ACTIVE_SESS_HISTORY views after the problem has been

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_SQLTUNE

REPORT_SQL_DETAIL FunctionGV$SQL DBA_HIST_SNAPSHOT DBA_HIST_WR_CONTROL DBA_HIST_ACTIVE_SESS_HISTORY DBA_HIST_SQLSTAT

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_WORKLOAD_REPOSITORY

ASH_REPORT_HTML Function$ACTIVE_SESION_HISTORY) 2 => disk ( DBA_HIST_ACTIVE_SESS_HISTORY ) 0 => both. This is the default value. Here, the begin

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_WORKLOAD_REPOSITORY

ASH_REPORT_TEXT Function$ACTIVE_SESION_HISTORY) 2 => disk ( DBA_HIST_ACTIVE_SESS_HISTORY ) 0 => both. This is the default value. Here, the

Database Reference, 12c Release 1 (12.1)

V$ACTIVE_SESSION_HISTORY

7.7 V$ACTIVE_SESSION_HISTORYAutomatic Workload Repository ( DBA_HIST_ACTIVE_SESS_HISTORY ) ( Y ) or not ( N ) SESSION_ID NUMBER

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsDBA_HEATMAP_TOP_TABLESPACES 4.229 DBA_HIGH_WATER_MARK_STATISTICS 4.230 DBA_HIST_ACTIVE_SESS_HISTORY 4.231