Sybase 12.5.1, User Manual

Page: 129 / 210

APPENDIX A Data Items
User’s Guide
115
Object ID
Version: 11.0 and later
ID of a database object. The object returned is a database table, a stored procedure, or
a temporary table.
Object IDs might be negative numbers. The object IDs that Adaptive Server assigns to
temporary tables can be positive or negative.
Type: Key
Object Name
Version: 11.0 and later
Database object name. The string
**TempObject**
is reported for temporary tables.
Type: Result
Object Type
Version: 11.0 and later
Type of database object:
• 0 – none.
• 1 – stored procedure (including triggers).
• 2 – table.
Type: Result
Owner Name
Version: 11.0 and later
Name of an objects’s owner.
Type: Result
Page Cache Size
Version: 11.0 and later
Amount of memory in bytes allocated for the page cache.
Type: Result
Page Hit Percent
Version: 11.0 and later
Percentage of times that a data page read could be satisfied from cache without
requiring a physical page read.
Type: Result
Page I/O
Version: 11.0 and later
Combined total of logical page reads and page writes.
Type: Result
Page Number
Version: 11.0 and later
Data page number for a particular lock or lock request.
Type: Key
Page Writes
Version: 11.0 and later
Number of pages written to a database device.
Type: Result
Physical Page Reads
Version: 11.0 and later
Number of data page reads that could not be satisfied from the data cache.
Type: Result
Procedure Buffer Size
Version: 11.0 and later
Amount of memory in bytes allocated for the procedure buffer.
Type: Result
Procedure CPU Time
Version: 11.0 and later
Number of seconds of CPU time spent executing a stored procedure.
Type: Result
Data item Description