MX Release 3.2 (H06.25+, J06.14+)

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series

216 JONES

225 HELMSTED

232 SPINNER

--- 5 row(s) selected.

SQL>

GET STATISTICS command

The get statistics command returns formatted statistics for the last run 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 performed by disk process.

Message Count

number of messages sent or received between filesystem and disk process.

Message Bytes

number of message bytes sent or 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.

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

--- 11 row(s) selected.

SQL> get statistics;

Start Time 2011/07/18 21:45:34.082329

End Time 2011/07/18 21:45:34.300265

Elapsed Time 00:00:00.217936

Compile Time 00:00:00.002423

Execution Time 00:00:00.218750

Table Name Records Records Disk Message Message Lock Lock Disk Process

Accessed Used I/Os Count Bytes Escl Wait Busy Time

SCH.TOI.JOB 2 2 0 4 15232 0 0 363

GET STATISTICS command 89