Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
149
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
InterfaceName
VARCHAR2(40)
NOT NULL
—
InterfaceDirection
VARCHAR2(40)
NOT NULL
—
ClassOfServiceLevel NUMBER(1)
NOT NULL
—
PostPolicyPackets
NUMBER(20)
DEFAULT –1
—
PostPolicyBytes
NUMBER(20)
DEFAULT –1
—
DropPackets
NUMBER(20)
DEFAULT –1
—
DropBytes
NUMBER(20)
DEFAULT –1
—
IS24H
NUMBER(1)
NOT NULL
Whether the PM data is collected in
24-hour or 15-minute increments.
Values are:
1: 24 hour
0: 15 minute
24-hour or 15-minute increments.
Values are:
1: 24 hour
0: 15 minute
ModelType
NUMBER(10)
DEFAULT 0
Model type.
ObjectType
NUMBER(10)
DEFAULT 0
Object type.
StrObjInstance
VARCHAR2(256)
—
StrObjInstance name.
InvalidityList
VARCHAR2(1024) —
Invalidity list for PM data.
1.1.142
ONS15454_DS1_PM_Table
The ONS15454_DS1_PM_Table stores DS-1 PM information about ONS 15327 and
ONS 15454 NEs. This table is used when the module type is a DS1, DS1N, or DS3XM.
ONS 15454 NEs. This table is used when the module type is a DS1, DS1N, or DS3XM.
For medium, large, and high-end configurations, this table is partitioned.
Primary key: ONS15454_DS1_PM_PK
Tablespace: ONS15454_DATA_TABLESPACE
Table 1-138: ONS15454_DS1_PM_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID to access this table for an NE;
same as NEDBAccessID in
NE_INFO_TABLE.
same as NEDBAccessID in
NE_INFO_TABLE.
ModuleType
NUMBER(4)
NOT NULL
Module type to which this PM