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_SNAPSHOT


1 to 17 of 17 results.


Database Reference, 12c Release 1 (12.1)

DBA_HIST_SNAPSHOT

5.53 DBA_HIST_SNAPSHOTDBA_HIST_SNAPSHOT displays information about the snapshots in the Workload Repository. Column

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

Gathering Database Statistics

Managing BaselinesDBA_HIST_SNAPSHOT view. See Also: Oracle Database PL/SQL Packages and Types Reference for information … DBA_HIST_SNAPSHOT view Dropping Snapshots By default, Oracle Database automatically purges snapshots that … also purged. Tip: To determine which snapshots to drop, use the DBA_HIST_SNAPSHOT view to review the … DBA_HIST_SNAPSHOT

Database Reference, 12c Release 1 (12.1)

DBA_HIST_ASH_SNAPSHOT

4.232 DBA_HIST_ASH_SNAPSHOT) data. This view differs from DBA_HIST_SNAPSHOT in that it provides snapshots which had errors flushing … ( DBA_HIST_SNAPSHOT filters out snapshots which had errors flushing AWR tables). Column Datatype … the root n: Where n is the applicable container ID for the rows containing data See Also: \" DBA_HIST_SNAPSHOT \"

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

DBMS_WORKLOAD_REPOSITORY

CREATE_SNAPSHOT Function and ProcedureDBA_HIST_SNAPSHOT view after the CREATE_SNAPSHOT action, you will see one more snapshot ID added to the Workload Repository.

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

DBMS_WORKLOAD_REPOSITORY

DROP_SNAPSHOT_RANGE Proceduredba_hist_snapshot view after the Drop Snapshot action, you will see that snapshots 102 to 105 are removed from the Workload Repository.

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

DBMS_WORKLOAD_REPOSITORY

DROP_BASELINE Procedurecan query the DBA_HIST_SNAPSHOT view to find that the underlying snapshots are left intact.

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

Gathering Database Statistics

Managing Baseline Templatesbaseline, use the DBA_HIST_SNAPSHOT view to review the existing snapshots See Also: Oracle Database … Oracle Database Reference for information about the DBA_HIST_SNAPSHOT view Dropping a Baseline To

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

Gathering Database Statistics

Using Automatic Workload Repository Views, common queues and dispatcher queues. DBA_HIST_SNAPSHOT displays information on snapshots in the

Database Reference, 12c Release 1 (12.1)

DBA_HIST_SEG_STAT

5.39 DBA_HIST_SEG_STATstatistics from the BEGIN_INTERVAL_TIME to the END_INTERVAL_TIME in the DBA_HIST_SNAPSHOT view. Column … data See Also: \" V$SEGSTAT \" \" DBA_HIST_SNAPSHOT \"

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…(12.1.0.2). See Also: \" DBA_HIST_ASH_SNAPSHOT \" \" DBA_HIST_SNAPSHOT \" Oracle Database PL/SQL Packages

Database Reference, 12c Release 1 (12.1)

DBA_HIST_SQLSTAT

5.60 DBA_HIST_SQLSTATstatistics from the BEGIN_INTERVAL_TIME to the END_INTERVAL_TIME in the DBA_HIST_SNAPSHOT view. This … : \" DBA_HIST_SNAPSHOT \" \" DBA_HIST_OPTIMIZER_ENV \" \" DBA_HIST_SQLTEXT \" \" DBA_HIST_SQL_PLAN \" Oracle Database PL

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 Reference, 12c Release 1 (12.1)

DBA_HIST_ACTIVE_SESS_HISTORY

4.230 DBA_HIST_ACTIVE_SESS_HISTORYthe DBA_HIST_ASH_SNAPSHOT view instead of the DBA_HIST_SNAPSHOT view. Column Datatype NULL

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsDBA_HIST_SHARED_POOL_ADVICE 5.51 DBA_HIST_SHARED_SERVER_SUMMARY 5.52 DBA_HIST_SNAP_ERROR 5.53 DBA_HIST_SNAPSHOT 5.54

Database Error Messages, 12c Release 1 (12.1)

ORA-12700 to ORA-19400

ORA-13774: insufficient privileges to select data from the workload repository, and DBA_HIST_SNAPSHOT. Action: Adjust the user's privileges and retry the operation.

Database Error Messages, 12c Release 1 (12.1)

ORA-12700 to ORA-19400

ORA-13548: Unable to find valid snapshot IDs for the inputted baseline time range… The dba_hist_snapshot displays the snapshot id and time information.

Database Licensing Information User Manual, 12c Release 1 (12.1)

Options and Packs

Oracle Diagnostics Packthis pack, along with their underlying tables.The only exception are the views: DBA_HIST_SNAPSHOT