Differences

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

--- oracle [2025/07/03 09:34] – mduersch
+++ oracle [2025/08/14 09:19] (current) – [ACLs] mduersch
@@ Line 1: / Line 1: @@
 ====== ORACLE ======
+==== ACLs ====
+ACLs abfragen:
+  SET LINESIZE 150
+  COLUMN host FORMAT A40
+  COLUMN acl FORMAT A50
+  SELECT host, lower_port, upper_port, acl
+  FROM   dba_network_acls
+  ORDER BY host;
+  SET LINESIZE 150
+  COLUMN acl FORMAT A50
+  COLUMN principal FORMAT A20
+  COLUMN privilege FORMAT A10
+  SELECT acl,
+       principal,
+       privilege,
+       is_grant,
+       TO_CHAR(start_date, 'DD-MON-YYYY') AS start_date,
+       TO_CHAR(end_date, 'DD-MON-YYYY') AS end_date
+  FROM   dba_network_acl_privileges
+  ORDER BY acl, principal, privilege;
+Source: https://oracle-base.com/articles/12c/fine-grained-access-to-network-services-enhancements-12cr1
 ==== Spool ====
@@ Line 210: / Line 237: @@
   ,OSUSER,MACHINE, substr(PROGRAM,1,32) PROGRAM, to_char(LOGON_TIME,'DD.MM.yyyy HH24:MI:SS')LOGON_TIME
    from gv$session
-   where type='USER'
+   where type='USER';
+   # Danach ggf:
+   ALTER SYSTEM KILL SESSION 'sid,serial#';
 ==== AWR ====