Files
oracle/tpt/sqlmon_restarts.sql
2026-03-12 21:23:47 +01:00

24 lines
576 B
SQL

-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
-- Purpose: List UPDATE/DELETE statements that have experienced restarts due to write consistency from V$SQL_PLAN_MONITOR
SELECT
inst_id
, sql_id
, starts
, sql_exec_start
, sql_exec_id
, plan_operation
, plan_object_owner||'.'||plan_object_name object_name
FROM
gv$sql_plan_monitor
WHERE
plan_line_id = 1
AND starts > 1
ORDER BY
sql_id
, sql_exec_start
/