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
4.230 DBA_HIST_ACTIVE_SESS_HISTORY → DBA_HIST_ACTIVE_SESS_HISTORY displays the history of the contents of the in-memory active session
VARCHAR21 Indicates whether the session was prepopulating the IM column store at the time of sampling… → IN_INMEMORY_REPOPULATE Footref 1
VARCHAR21 Indicates whether the session was repopulating the IM column store at the time of sampling… → IN_INMEMORY_TREPOPULATE Footref 1
VARCHAR21 Indicates whether the session was populating the IM column store at the time of sampling… → IN_INMEMORY_PREPOPULATE Footref 1
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
43.1 About CDB and PDB Information in Views → the root and displayed in some data dictionary views, such as the DBA_HIST_ACTIVE_SESS_HISTORY view
object link → making views such as DBA_HIST_ACTIVE_SESS_HISTORY and DBA_HIST_BASELINE accessible in each separate container.
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
5.26 DBA_HIST_PLAN_OPTION_NAME → SQL_PLAN_OPTIONS column of the DBA_HIST_ACTIVE_SESS_HISTORY view. CON_DBID NUMBER The database ID of the PDB
5.25 DBA_HIST_PLAN_OPERATION_NAME → the SQL_PLAN_OPERATION column of the DBA_HIST_ACTIVE_SESS_HISTORY view. CON_DBID NUMBER The
Active Session History Statistics → DBA_HIST_ACTIVE_SESS_HISTORY view, often avoiding the need to replay the workload to trace additional
Using Automatic Workload Repository Views → : DBA_HIST_ACTIVE_SESS_HISTORY displays the history of the contents of the in-memory active session history
Interpreting Results from Active Session History Reports → minutes that are found in the DBA_HIST_ACTIVE_SESS_HISTORY table. To generate an ASH report for Oracle
Implement and Measure Change → occurring or V$ACTIVE_SESSION_HISTORY and DBA_HIST_ACTIVE_SESS_HISTORY views after the problem has been
REPORT_SQL_DETAIL Function → GV$SQL DBA_HIST_SNAPSHOT DBA_HIST_WR_CONTROL DBA_HIST_ACTIVE_SESS_HISTORY DBA_HIST_SQLSTAT
ASH_REPORT_HTML Function → $ACTIVE_SESION_HISTORY) 2 => disk ( DBA_HIST_ACTIVE_SESS_HISTORY ) 0 => both. This is the default value. Here, the begin
ASH_REPORT_TEXT Function → $ACTIVE_SESION_HISTORY) 2 => disk ( DBA_HIST_ACTIVE_SESS_HISTORY ) 0 => both. This is the default value. Here, the
7.7 V$ACTIVE_SESSION_HISTORY → Automatic Workload Repository ( DBA_HIST_ACTIVE_SESS_HISTORY ) ( Y ) or not ( N ) SESSION_ID NUMBER