Oracle Trace Runs Viewer
Displays information about all PL/SQL trace runs, including run ID, run date, and run owner. Useful for reviewing available trace executions before drilling into detailed trace events.
oraclesqlmonitoring-alertsv1.0.0
0 stars0 downloads14 views0 comments
By OracleDba • Created
Code
(18 lines)123456789101112131415161718
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/trace_runs.sql
-- Author : Tim Hall
-- Description : Displays information on all trace runs.
-- Requirements : Access to the V$ views.
-- Call Syntax : @trace_runs.sql
-- Last Modified: 06/05/2005
-- -----------------------------------------------------------------------------------
SET LINESIZE 200
SET TRIMOUT ON
COLUMN runid FORMAT 99999
SELECT runid,
run_date,
run_owner
FROM plsql_trace_runs
ORDER BY runid;