Typically, you would view the AWR data through Oracle Enterprise Manager screens
or AWR reports. However, you can view the statistics with the following views:
■ V$ACTIVE_SESSION_HISTORY
This view displays active database session activity, sampled once every second.
■ V$ metric views provide metric data to track the performance of the system
The metric views are organized into various groups, such as event, event class,
system, session, service, file, and tablespace metrics. These groups are identified in
the V$METRICGROUP view.
■ DBA_HIST views
The DBA_HIST views contain historical data stored in the database. This group of
views includes:
■ DBA_HIST_ACTIVE_SESS_HISTORY displays the history of the contents of
the in-memory active session history for recent system activity.
■ DBA_HIST_BASELINE displays information about the baselines captured on
the system
■ DBA_HIST_DATABASE_INSTANCE displays information about the database
environment
■ DBA_HIST_SNAPSHOT displays information on snapshots in the system
■ DBA_HIST_SQL_PLAN displays the SQL execution plans
■ DBA_HIST_WR_CONTROL displays the settings for controlling AWR.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1004974/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002848
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
