UNSECURE_ONSTAT configuration parameter
Use the UNSECURE_ONSTAT configuration parameter to remove the database system administrator (DBSA) user access restriction for onstat commands.
- onconfig.std value
- Not set.
- values
1= All users can run onstat commands to view running SQL statements- takes effect
- After you edit your onconfig file and restart the database server.
Usage
By
default, the onstat commands that show the SQL statement text from
an active session are restricted to DBSA users. To remove this restriction,
set the UNSECURE_ONSTAT configuration parameter to 1.
The onstat commands that show SQL statements include onstat
-g his, onstat -g ses, onstat
-g stm, onstat -g ssc, and onstat
-g sql.