Database Tuning (MOSC)

MOSC Banner

AWR report showing the following sql statement in 200 Million times executions with module toad 11.

edited Oct 9, 2014 10:01AM in Database Tuning (MOSC) 2 commentsAnswered

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

  1. 926.36
  2. 99.6

0

1v717nvrhgbn9

TOAD 11.0.0.116

SELECT USER FROM SYS.DUAL

106,297,345

106,284,561

1

1,040.97

  1. 98.5

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center