Friday, November 28, 2008

DBA_CPU_USAGE_STATISTICS


DBA_CPU_USAGE_STATISTICS displays database CPU usage statistics.
Column
Datatype
NULL
Description
DBID
NUMBER
NOT NULL
Database ID
VERSION
VARCHAR2(17)
NOT NULL
Database version
TIMESTAMP
DATE
NOT NULL
Time at which the CPU usage changed
CPU_COUNT
NUMBER
CPU count of the database
CPU_CORE_COUNT
NUMBER
CPU core count of the database
CPU_SOCKET_COUNT
NUMBER
CPU socket count of the database
Note:
1.
select * from DBA_CPU_USAGE_STATISTICS;
DBID
VERSION
TIMESTAMP
CPU_COUNT
CPU_CORE_COUNT
CPU_SOCKET_COUNT
1234567890
10.2.0.3.0
2008-09-05 10:23:01 AM
4

Oracle data dictionary views


More Oracle DBA tips, please visit Oracle DBA Tips  

No comments:

Post a Comment