Monday, November 23, 2009

V$CLIENT_STATS


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)
Derived statistic name from V$STATNAME and V$SESS_TIME_MODEL
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

Oracle data dictionary views

Last updated: 2009-11-23 Monday

No comments:

Post a Comment