Differences

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

--- oracle [2025/08/14 09:19] – 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 ====
@@ Line 27: / Line 36: @@
   ORDER BY acl, principal, privilege;
+Source: https://oracle-base.com/articles/12c/fine-grained-access-to-network-services-enhancements-12cr1
 ==== Spool ====
@@ Line 558: / 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 ====