Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on SAP ASE 2.12 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Open Objects grid

The Open Objects I/O for Database grid shows a listing of each object that is either open or has been open. It also shows related I/O activity. Objects are only removed from the list if the configured number of "open objects" is exceeded, and then they are aged out to make room for newly opened objects.

The following table describes the columns on the grid:

Column

Description

DB Name

Name of the database where the object was created

Object Name

Name of object

Times Accessed

Number of times this object has been accessed

Lock Requests

Number of requests for a lock on this object

Lock Waits

Number of times a task waited for a lock on this object

Logical Reads

Total number of buffers read

Physical Reads

Number of buffers read from disk

APF Reads

Number of Asynchronous Pre-Fetch buffers read

Pages Read

Total number of pages read

Physical Writes

Total number of buffers written to disk

Pages Written

Total number of pages written to disk

Rows Inserted

Number of rows inserted

Rows Deleted

Number of rows deleted

Rows Updated

Number of rows updated

*Available only in Adaptive Server versions 12.5.0.3 or later

  

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation