The following table lists the OIDs and names the database statistics that can be retrieved using the SQL Anywhere SNMP Extension Agent.
The value n is the database number in the sasnmp.ini file.
Descriptions| OID | Type | Name | Statistic |
|---|---|---|---|
| 1.3.6.1.4.1.897.2.2.1.1.n | Counter64 | dbStatCacheHits | CacheHits |
| 1.3.6.1.4.1.897.2.2.1.2.n | Integer32 | dbStatCacheReadIndInt | CacheReadIndInt |
| 1.3.6.1.4.1.897.2.2.1.3.n | Integer32 | dbStatCacheReadIndLeaf | CacheReadIndLeaf |
| 1.3.6.1.4.1.897.2.2.1.4.n | Counter64 | dbStatCacheRead | CacheRead |
| 1.3.6.1.4.1.897.2.2.1.5.n | Integer32 | dbStatCacheReadTable | CacheReadTable |
| 1.3.6.1.4.1.897.2.2.1.6.n | Integer32 | dbStatChkpt | Chkpt |
| 1.3.6.1.4.1.897.2.2.1.7.n | Integer32 | dbStatChkptFlush | ChkptFlush |
| 1.3.6.1.4.1.897.2.2.1.8.n | Integer32 | dbStatChkptPage | ChkptPage |
| 1.3.6.1.4.1.897.2.2.1.9.n | Integer32 | dbStatCheckpointUrgency | CheckpointUrgency |
| 1.3.6.1.4.1.897.2.2.1.10.n | Integer32 | dbStatInternal | Internal |
| 1.3.6.1.4.1.897.2.2.1.11.n | Integer32 | dbStatInternal | Internal |
| 1.3.6.1.4.1.897.2.2.1.12.n | Integer32 | dbStatCheckpointLogCommitToDisk | CheckpointLogCommitToDisk |
| 1.3.6.1.4.1.897.2.2.1.13.n | Integer32 | dbStatCheckpointLogPagesInUse | CheckpointLogPagesInUse |
| 1.3.6.1.4.1.897.2.2.1.14.n | Integer32 | dbStatCheckpointLogPagesRelocated | CheckpointLogPagesRelocated |
| 1.3.6.1.4.1.897.2.2.1.15.n | Integer32 | dbStatCheckpointLogSavePreimage | CheckpointLogSavePreimage |
| 1.3.6.1.4.1.897.2.2.1.16.n | Integer32 | dbStatCheckpointLogSize | CheckpointLogSize |
| 1.3.6.1.4.1.897.2.2.1.17.n | Integer32 | dbStatCheckpointLogWrites | CheckpointLogWrites |
| 1.3.6.1.4.1.897.2.2.1.18.n | Integer32 | dbStatCheckpointLogPagesWritten | CheckpointLogPagesWritten |
| 1.3.6.1.4.1.897.2.2.1.19.n | Integer32 | dbStatCommitFile | CommitFile |
| 1.3.6.1.4.1.897.2.2.1.20.n | Integer32 | dbStatConnCount | ConnCount |
| 1.3.6.1.4.1.897.2.2.1.21.n | Integer32 | dbStatCurrIO | CurrIO |
| 1.3.6.1.4.1.897.2.2.1.22.n | Integer32 | dbStatCurrRead | CurrRead |
| 1.3.6.1.4.1.897.2.2.1.23.n | Integer32 | dbStatCurrWrite | CurrWrite |
| 1.3.6.1.4.1.897.2.2.1.24.n | Integer32 | dbStatDiskReadIndInt | DiskReadIndInt |
| 1.3.6.1.4.1.897.2.2.1.25.n | Integer32 | dbStatDiskReadIndLeaf | DiskReadIndLeaf |
| 1.3.6.1.4.1.897.2.2.1.26.n | Counter64 | dbStatDiskRead | DiskRead |
| 1.3.6.1.4.1.897.2.2.1.27.n | Integer32 | dbStatDiskReadTable | DiskReadTable |
| 1.3.6.1.4.1.897.2.2.1.28.n | Counter64 | dbStatDiskWrite | DiskWrite |
| 1.3.6.1.4.1.897.2.2.1.29.n | Integer32 | dbStatExtendDB | ExtendDB |
| 1.3.6.1.4.1.897.2.2.1.30.n | Integer32 | dbStatExtendTempWrite | ExtendTempWrite |
| 1.3.6.1.4.1.897.2.2.1.31.n | Integer32 | dbStatFullCompare | FullCompare |
| 1.3.6.1.4.1.897.2.2.1.32.n | Integer32 | dbStatGetData | GetData |
| 1.3.6.1.4.1.897.2.2.1.33.n | Integer32 | dbStatIdleCheck | IdleCheck |
| 1.3.6.1.4.1.897.2.2.1.34.n | Integer32 | dbStatIdleChkpt | IdleChkpt |
| 1.3.6.1.4.1.897.2.2.1.35.n | Integer32 | dbStatIdleChkTime | IdleChkTime |
| 1.3.6.1.4.1.897.2.2.1.36.n | Integer32 | dbStatIdleWrite | IdleWrite |
| 1.3.6.1.4.1.897.2.2.1.37.n | Integer32 | dbStatIndAdd | IndAdd |
| 1.3.6.1.4.1.897.2.2.1.38.n | Integer32 | dbStatIndLookup | IndLookup |
| 1.3.6.1.4.1.897.2.2.1.39.n | Integer32 | dbStatIOToRecover | IOToRecover |
| 1.3.6.1.4.1.897.2.2.1.40.n | Integer32 | dbStatInternal | Internal |
| 1.3.6.1.4.1.897.2.2.1.41.n | Integer32 | dbStatInternal | Internal |
| 1.3.6.1.4.1.897.2.2.1.42.n | Integer32 | dbStatLockTablePages | LockTablePages |
| 1.3.6.1.4.1.897.2.2.1.43.n | Integer32 | dbStatInternal | Internal |
| 1.3.6.1.4.1.897.2.2.1.44.n | Integer32 | dbStatMaxIO | MaxIO |
| 1.3.6.1.4.1.897.2.2.1.45.n | Integer32 | dbStatMaxRead | MaxRead |
| 1.3.6.1.4.1.897.2.2.1.46.n | Integer32 | dbStatMaxWrite | MaxWrite |
| 1.3.6.1.4.1.897.2.2.1.47.n | Counter64 | dbStatPageRelocations | PageRelocations |
| 1.3.6.1.4.1.897.2.2.1.48.n | Integer32 | dbStatProcedurePages | ProcedurePages |
| 1.3.6.1.4.1.897.2.2.1.49.n | Integer32 | dbStatQueryCachePages | QueryCachePages |
| 1.3.6.1.4.1.897.2.2.1.50.n | Integer32 | dbStatQueryLowMemoryStrategy | QueryLowMemoryStrategy |
| 1.3.6.1.4.1.897.2.2.1.51.n | Counter64 | dbStatQueryRowsMaterialized | QueryRowsMaterialized |
| 1.3.6.1.4.1.897.2.2.1.52.n | Integer32 | dbStatRecoveryUrgency | RecoveryUrgency |
| 1.3.6.1.4.1.897.2.2.1.53.n | Integer32 | dbStatLogFreeCommit | LogFreeCommit |
| 1.3.6.1.4.1.897.2.2.1.54.n | Integer32 | dbStatLogWrite | LogWrite |
| 1.3.6.1.4.1.897.2.2.1.55.n | Integer32 | dbStatRelocatableHeapPages | RelocatableHeapPages |
| 1.3.6.1.4.1.897.2.2.1.56.n | Integer32 | dbStatRollbackLogPages | RollbackLogPages |
| 1.3.6.1.4.1.897.2.2.1.57.n | Integer32 | dbStatTempTablePages | TempTablePages |
| 1.3.6.1.4.1.897.2.2.1.58.n | Integer32 | dbStatTriggerPages | TriggerPages |
| 1.3.6.1.4.1.897.2.2.1.59.n | Integer32 | dbStatViewPages | ViewPages |
| 1.3.6.1.4.1.897.2.2.1.60.n | Integer32 | dbStatVersionStorePages | VersionStorePages |
| 1.3.6.1.4.1.897.2.2.1.61.n | Integer32 | dbStatSnapshotCount | SnapshotCount |
| 1.3.6.1.4.1.897.2.2.1.62.n | Integer32 | dbStatLockCount | LockCount |
| 1.3.6.1.4.1.897.2.2.1.63.n | Integer32 | dbStatCacheReadWorkTable | CacheReadWorkTable |
| 1.3.6.1.4.1.897.2.2.1.64.n | Integer32 | dbStatDiskReadWorkTable | DiskReadWorkTable |
| 1.3.6.1.4.1.897.2.2.1.65.n | Integer32 | dbStatPrepares | Prepares |
| 1.3.6.1.4.1.897.2.2.1.66.n | Integer32 | dbStatConnPoolCachedCount | ConnPoolCachedCount |
| 1.3.6.1.4.1.897.2.2.1.67.n | Integer32 | dbStatConnPoolHits | ConnPoolHits |
| 1.3.6.1.4.1.897.2.2.1.68.n | Integer32 | dbStatConnPoolMisses | ConnPoolMisses |
| 1.3.6.1.4.1.897.2.2.1.69.n | Integer32 | dbStatHttpConnPoolCachedCount | HttpConnPoolCachedCount |
| 1.3.6.1.4.1.897.2.2.1.70.n | Integer32 | dbStatHttpConnPoolHits | HttpConnPoolHits |
| 1.3.6.1.4.1.897.2.2.1.71.n | Integer32 | dbStatHttpConnPoolMisses | HttpConnPoolMisses |
| 1.3.6.1.4.1.897.2.2.1.72.n | Integer32 | dbStatHttpConnPoolSteals | HttpConnPoolSteals |
| 1.3.6.1.4.1.897.2.2.1.73.n | Integer32 | dbStatMirrorServerWaits | MirrorServerWaits |
| 1.3.6.1.4.1.897.2.2.1.74.n | Counter64 | dbStatBytesReceived | BytesReceived |
| 1.3.6.1.4.1.897.2.2.1.75.n | Counter64 | dbStatBytesReceivedUncomp | BytesReceivedUncomp |
| 1.3.6.1.4.1.897.2.2.1.76.n | Counter64 | dbStatBytesSent | BytesSent |
| 1.3.6.1.4.1.897.2.2.1.77.n | Counter64 | dbStatBytesSentUncomp | BytesSentUncomp |
| 1.3.6.1.4.1.897.2.2.1.78.n | Integer32 | dbStatCarverHeapPages | CarverHeapPages |
| 1.3.6.1.4.1.897.2.2.1.79.n | Integer32 | dbStatClientStmtCacheHits | ClientStmtCacheHits |
| 1.3.6.1.4.1.897.2.2.1.80.n | Integer32 | dbStatClientStmtCacheMisses | ClientStmtCacheMisses |
| 1.3.6.1.4.1.897.2.2.1.81.n | Integer32 | dbStatCommit | Commit |
| 1.3.6.1.4.1.897.2.2.1.82.n | Integer32 | dbStatCursor | Cursor |
| 1.3.6.1.4.1.897.2.2.1.83.n | Integer32 | dbStatHeapsCarver | HeapsCarver |
| 1.3.6.1.4.1.897.2.2.1.84.n | Integer32 | dbStatHeapsLocked | HeapsLocked |
| 1.3.6.1.4.1.897.2.2.1.85.n | Integer32 | dbStatHeapsQuery | HeapsQuery |
| 1.3.6.1.4.1.897.2.2.1.86.n | Integer32 | dbStatHeapsRelocatable | HeapsRelocatable |
| 1.3.6.1.4.1.897.2.2.1.87.n | Integer32 | dbStatCursorOpen | CursorOpen |
| 1.3.6.1.4.1.897.2.2.1.88.n | Counter64 | dbStatPacketsReceived | PacketsReceived |
| 1.3.6.1.4.1.897.2.2.1.89.n | Counter64 | dbStatPacketsReceivedUncomp | PacketsReceivedUncomp |
| 1.3.6.1.4.1.897.2.2.1.90.n | Counter64 | dbStatPacketsSent | PacketsSent |
| 1.3.6.1.4.1.897.2.2.1.91.n | Counter64 | dbStatPacketsSentUncomp | PacketsSentUncomp |
| 1.3.6.1.4.1.897.2.2.1.92.n | Integer32 | dbStatQueryHeapPages | QueryHeapPages |
| 1.3.6.1.4.1.897.2.2.1.93.n | Integer32 | dbStatQueryMemActiveCurr | QueryMemActiveCurr |
| 1.3.6.1.4.1.897.2.2.1.94.n | Integer32 | dbStatQueryMemGrantFailed | QueryMemGrantFailed |
| 1.3.6.1.4.1.897.2.2.1.95.n | Integer32 | dbStatQueryMemGrantGranted | QueryMemGrantGranted |
| 1.3.6.1.4.1.897.2.2.1.96.n | Integer32 | dbStatQueryMemGrantRequested | QueryMemGrantRequested |
| 1.3.6.1.4.1.897.2.2.1.97.n | Integer32 | dbStatQueryMemGrantWaited | QueryMemGrantWaited |
| 1.3.6.1.4.1.897.2.2.1.98.n | Integer32 | dbStatQueryMemGrantWaiting | QueryMemGrantWaiting |
| 1.3.6.1.4.1.897.2.2.1.99.n | Integer32 | dbStatRequestsReceived | RequestsReceived |
| 1.3.6.1.4.1.897.2.2.1.100.n | Integer32 | dbStatRlbk | Rlbk |
| 1.3.6.1.4.1.897.2.2.1.101.n | Integer32 | dbStatPrepStmt | PrepStmt |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |