Database Tuning (MOSC)

MOSC Banner

same SQL picking different sqlid's

edited Jul 21, 2013 11:02PM in Database Tuning (MOSC) 14 commentsAnswered
select module,program,event,sid,last_call_et,sql_id from v$session where status='ACTIVE' and username<>'SYS';

aqtv9.exe                                                        aqtv9.exe                                        db file sequential read                                                 155           55 gytz18vqbvrh8
QUERY_MANAGER                                                     (TNS V1-V3)                    db file sequential read                                                 539          873 4k1dxxrz26ncj

3 rows selected.

SQL> /

The same sql is picking up different sqlid's when run from dif tools one sqlid takes 60 seconds and other one takes hours

Regards,

Vishal

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