Neoview Command Interface (NCI) Guide (R2.5)

215 LANCASTER
216 JONES
225 HELMSTED
232 SPINNER
--- 5 row(s) selected.
SQL>
GET STATISTICS Command
The GET STATISTICS command returns formatted statistics for the last executed SQL statement.
Syntax
GET STATISTICS
Description of Returned Values:
Records Accessed
number of rows returned by disk process to EID (Executor In Disk process).
Records Used
number of rows returned by EID after selection.
Disk IOs
number of actual disk IOs done by disk process.
Message Count
number of messages sent/received between filesystem and disk process.
Message Bytes
number of message bytes sent/received between filesystem and disk process.
Lock Escl
number of lock escalations.
Lock Wait
number of lock waits.
Disk Process Busy Time
cpu time for disk process processes for the specified table.
Considerations
• The command requires an SQL terminator.
• You can execute this command only in SQL mode.
Examples
SQL>select * from job;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
1234 ENGINEER
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
420 ENGINEER
600 ADMINISTRATOR
200 PRODUCTION SUPV
GET STATISTICS Command 87