Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Onstat -a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g pqs Operators For All SQL Queries

The onstat -g pqs command displays the operators for all SQL queries.

Query Operators:
addr           ses-id   opname      phase  rows      time      in1     in2 stmt-type
-----------------------------------------------------------------------------------
6cdb9538         201012 sort       close          7      00:00.00  6cdb9838   0
6cdb9838         201012 scan       close          7      00:00.00  0          0
6db8f8c8         200987 sort       close          1      00:00.00  6c99b038   0
6c99b038         200987 scan       close          6      00:00.00  0          0
3da3fa038      22905965 sort       create         0      00:00.00  3da3fa438  0
3da3fa438      22905965 scan       next        2177      00:00.00  0          0
22820742   -            wbe        DR  Wait 60    0    0    9.35  Off
22662219   -            wbe        DR  Wait 60    0    0    9.35  Off
22617207   -            resource   DR  Wait 60    0    0    9.35  Off
22616715   -            resource   DR  Wait 60    0    0    9.35  Off
22616711   -            resource   DR  Wait 60    0    0    9.35  Off
22571703   -            wbe        DR  Wait 60    0    0    9.35  Off

Output Description

Field Description
addr The address of the operator in memory. You can use this address to track which SCAN operator belongs to each JOIN operator.
ses-id The session ID in which the SQL statement was run.
opname The name of the operator.
phase The phase in which the operator was used. For example OPEN, NEXT, CLOSE.
rows The number of rows that are processed by the operator.
time The amount of time to process the operator. The time is displayed to the millisecond. A time of 01:20.10 is 1 minute, 20 seconds, and 10 milliseconds.
in1 The first (outer) operator in the join.
in2 The second (inner) operator in the join.
stmt-type The type of SQL statement, such as SELECT, UPDATE, DELETE.

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.