AWR report showing the following sql statement in 200 Million times executions with module toad 11.
The below sql statement showing high executions
select user from sys.dual.
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
98,273,767 | 98,272,869 | 1 |
| 0 | 1v717nvrhgbn9 | TOAD 11.0.0.116 | SELECT USER FROM SYS.DUAL |
106,297,345 | 106,284,561 | 1 | 1,040.97 |
| 0 | 1v717nvrhgbn9 | TOAD 11.0.0.116 | SELECT USER FROM SYS.DUAL |
Need to know that who is executing the above sql statement , from which user/machine,
How to find the Machine / user who is executing the statement ( select user from sys.dual)
The module name it is showing TOAD 11.0.0.116, But when i searched in v$active_sessio_history with module and sql_id it gives me no rows.