Enabling non-DBAs to View SQL Statements a Session Is Executing

The onstat commands that show the 3SQL statement text that a session is executing are normally restricted to 3DBA users. You can set the UNSECURE_ONSTAT configuration parameter to 1 to remove this restriction. Removing this restriction enables other 3users to execute onstat -ses, onstat 3-stm, onstat -ssc, and onstat 3-sql commands.

The UNSECURE_ONSTAT configuration parameter takes effect when the database 3server is shut down and restarted.