• hi guys you can find bvy this query running query status..

    select sesion.sid,

    sql_text

    from v$sqltext sqltext, v$session sesion

    where sesion.sql_hash_value = sqltext.hash_value

    and sesion.sql_address = sqltext.address

    and sesion.username is not null

    order by sqltext.piece;

    try it and see the result.

    http://www.sajawatevents.com/