Differences

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

--- oracle [2025/04/23 12:58] – [Spool] mduersch
+++ oracle [2025/12/15 08:24] (current) – [SELECTS] mduersch
@@ Line 1: / Line 1: @@
 ====== ORACLE ======
+==== CDB PDB ====
+Befehle
+  SHOW CON_NAME
+  ALTER SESSION SET CONTAINER=pdb1;
+  SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
+  SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
+  SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;
+==== 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 188: / Line 224: @@
 ==== Sessions (to kill?) ====
-set lines 200
+  set lines 200
-set pages 999
+  set pages 999
   col username for a12
@@ Line 210: / Line 246: @@
   ,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 ====
@@ Line 529: / Line 568: @@
    select LOG_MODE from v$database;
    select name from V$database;
+   # flashbackquery
+   select count(1) from somewhere
+                 AS OF TIMESTAMP TO_TIMESTAMP('2025-12-12 16:00', 'YYYY-MM-DD HH24:MI:SS')
+           where
+                 something is NULL;
 ==== GRANTS ====