V$CLIENT_STATS displays measures for all sessions that are active for the client identifier per instance. The statistics available in this view are a subset of those available in V$SESSTAT and V$SESS_TIME_MODEL.
Column | Datatype | Description |
CLIENT_IDENTIFIER | VARCHAR2(64) | Client identifier |
STAT_ID | NUMBER | Statistic identifier |
STAT_NAME | VARCHAR2(64) | |
VALUE | NUMBER | Cumulative value (in microseconds) |
Note:
1. Setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important
statistics required by Oracle Database features and functionality, including:
-- Automatic Workload Repository (AWR) Snapshots
-- Automatic Database Diagnostic Monitor (ADDM)
-- All server-generated alerts
-- Automatic SGA Memory Management
-- Automatic optimizer statistics collection
-- Object level statistics
-- End to End Application Tracing (V$CLIENT_STATS)
-- Database time distribution statistics (V$SESS_TIME_MODEL and V$SYS_TIME_MODEL)
-- Service level statistics
-- Buffer cache advisory
-- MTTR advisory
-- Shared pool sizing advisory
-- Segment level statistics
-- PGA Target advisory
-- Timed statistics
-- Monitoring of statistics
statistics required by Oracle Database features and functionality, including:
-- Automatic Workload Repository (AWR) Snapshots
-- Automatic Database Diagnostic Monitor (ADDM)
-- All server-generated alerts
-- Automatic SGA Memory Management
-- Automatic optimizer statistics collection
-- Object level statistics
-- End to End Application Tracing (V$CLIENT_STATS)
-- Database time distribution statistics (V$SESS_TIME_MODEL and V$SYS_TIME_MODEL)
-- Service level statistics
-- Buffer cache advisory
-- MTTR advisory
-- Shared pool sizing advisory
-- Segment level statistics
-- PGA Target advisory
-- Timed statistics
-- Monitoring of statistics
Oracle data dictionary views
Last updated: 2009-11-23 Monday |
No comments:
Post a Comment