Database Tuning (MOSC)

MOSC Banner

performance tuning

edited Jul 25, 2013 12:42AM in Database Tuning (MOSC) 6 commentsAnswered
The query is running for long

SQL> select last_call_et, event,username,sql_id,program,module from v$session where status='ACTIVE' and username<>'SYS';


LAST_CALL_ET EVENT                                                            USERNAME                       SQL_ID        PROGRAM                                          MODULE
------------ ---------------------------------------------------------------- ------------------------------ ------------- ------------------------------------------------ ----------------------------------------------------------------
        4742 direct path read temp                                            PSPAYRL                        8m7bzgwzb2ms3 sqr@l4repa19 (TNS V1-V3)                         sqr@l4repa19 (TNS V1-V3)

This is a select statement .

Pls suggest.

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