Breaking News: Grepper is joining You.com. Read the official announcement!

show last sql executed in oracle

Alex Latorre answered on February 28, 2022 Popularity 7/10 Helpfulness 4/10

answer show last sql executed in oracle

show last sql executed in oracle

Comment

  SELECT DISTINCT
         vs.sql_text,
         vs.sharable_mem,
         vs.persistent_mem,
         vs.runtime_mem,
         vs.sorts,
         vs.executions,
         vs.parse_calls,
         vs.module,
         vs.buffer_gets,
         vs.disk_reads,
         vs.version_count,
         vs.users_opening,
         vs.loads,
         TO_CHAR (TO_DATE (vs.first_load_time, 'YYYY-MM-DD/HH24:MI:SS'),
                  'MM/DD  HH24:MI:SS')    first_load_time,
         RAWTOHEX (vs.address)            address,
         vs.hash_value                    hash_value,
         rows_processed,
         vs.command_type,
         vs.parsing_user_id,
         OPTIMIZER_MODE,
         au.USERNAME                      parseuser
    FROM v$sqlarea vs, all_users au
   WHERE     (parsing_user_id != 0)
         AND (au.user_id(+) = vs.parsing_user_id)
         AND (executions >= 1)
ORDER BY buffer_gets / executions DESC

Popularity 7/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: oracle show sql

Link to this answer
Share Copy Link

Contributed on Feb 28 2022

Alex Latorre

0 Answers Avg Quality 2/10

show last sql executed in oracle

Contents

More Related Answers

show last sql executed in oracle

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.