Differences

This shows you the differences between two versions of the page.

--- oracle [2026/09/11 05:56] – mduersch
+++ oracle [2026/09/11 07:22] (current) – [Environement] mduersch
@@ Line 645: / Line 645: @@
    SELECT username, elapsed_time, plsql_exec_time, sql_text, cpu_time, rm_last_action, rm_last_action_reason, rm_last_action_time, rm_consumer_group FROM v$sql_monitor WHERE username is not null;
-Long running Statements
+==== Long running Statements v$session_longops ====
   col opname for a20
@@ Line 787: / Line 787: @@
   select PATCH_ID, PATCH_UID, STATUS, ACTION_TIME, DESCRIPTION from DBA_REGISTRY_SQLPATCH;
+  ./datapatch -purge_old_metadata
+  https://mikedietrichde.com/2025/02/28/final-blog-post-about-datapatch-cleanup-and-purge/
 ====== ORACLE 11G ======