Skip to content

Instantly share code, notes, and snippets.

@sheeplogh

sheeplogh/gist:8cc3dcf285c64c462bb5

Last active August 29, 2015 14:21
Show Gist options
  • Save sheeplogh/8cc3dcf285c64c462bb5 to your computer and use it in GitHub Desktop.
Save sheeplogh/8cc3dcf285c64c462bb5 to your computer and use it in GitHub Desktop.
Download ZIP
[Oracle] Monitoring Parallel Execution Performance
Raw
gistfile1.sql
-- Monitoring parallel execution
-- http://www.oracle.com/technetwork/jp/database/enterprise-edition/db11gr2-12-130999-ja.pdf
select status, queuing_time, sql_id, SQL_EXEC_START, SQL_EXEC_ID from gv$sql_monitor where sql_text is not null order by SQL_EXEC_START;
select * from gv$sql_monitor
where STATUS = 'EXECUTING' order by SQL_EXEC_START;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment