Cisco Cisco Prime Optical 9.6 Referencia técnica
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
144
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
inMaintenance NUMBER(1)
—
Whether the NE was under maintenance
when the PM bucket was collected.
when the PM bucket was collected.
fifteenMinThre
sholdMask
sholdMask
NUMBER(10)
—
Threshold values for the PM bucket for
the 15-minute interval.
the 15-minute interval.
ThresholdList
VARCHAR2(102
4)
4)
—
Threshold value for the PM bucket for the
day.
day.
validPackets
NUMBER(20)
DEFAULT –1
8b10b valid packets.
invalidPackets
NUMBER(20)
DEFAULT –1
8b10b invalid packets.
codeGroupViol
ations
ations
NUMBER(20)
DEFAULT –1
8b10b code group violations.
idleOrderedSet
s
s
NUMBER(20)
DEFAULT –1
8b10b idle ordered sets.
nonIdleOrdere
dSets
dSets
NUMBER(20)
DEFAULT –1
8b10b nonidle ordered sets.
dataCodeGrou
ps
ps
NUMBER(20)
DEFAULT –1
8b10b data code groups.
rxTotalPackets
NUMBER(20)
DEFAULT –1
8b10b total packets received.
ifInErrors
NUMBER(20)
DEFAULT –1
8b10b errors in received packets.
statsEncodingD
ispErrors
ispErrors
NUMBER(20)
DEFAULT –1
8b10b encoding errors.
dataOrderedSe
ts
ts
NUMBER(20)
DEFAULT –1
8b10b data ordered sets.
dataPayLoad
VARCHAR2(102
4)
4)
—
8b10 data payload.
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
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(102
4)
4)
—
Invalidity list for PM data.
invalidOrdered
Sets
Sets
NUMBER(20)
DEFAULT –1
8b10b invalid ordered sets.
InvldOrdrdSetD
ispErrorSum
ispErrorSum
NUMBER(20)
DEFAULT –1
—