Message after onstat -g sql 1

[omegabeta]

After onstat -g sql I've get the following message:
"Changing data structure forced command termination".
What that means ?


P.S. Sometimes I get a list of users...

 

[vpshriyan]

Hi,

onstat monitoring utility gets it's source information from shared memory based or pointed structures generally known as System Monitoring Interface (SMI) tables.

When database server is initiated, these structures located at sysmaster database gets spawned at the shared memory component. They are updated at run time, and engine stores various user activities.

In a multi-user, OLTP aimed production environment it would be common that these table getting locked and adminitered as and when they changed or gets updated. When this occurs, onstat utility can not be operational or operable side by side, so is the message:

"Changing data structure forced command termination".

is flashed. As a result, no harm is done to any component of the database server. You need to retry your command.

Regards,
Shriyan
"Vision is the art of seeing things invisible."

 

[omegabeta]

Thanks vpshriyan .