Minimalistic Oracle: A SQL-centric and a session-centric way to query V...

Minimalistic Oracle: A SQL-centric and a session-centric way to query V...: Version 1: SQL-Centric  This version starts from V$SQL and optionally attaches information from V$SESSION.  Use this query when: Inves...

Minimalistic Oracle: Script for checking the status of a user and its d...

Minimalistic Oracle: Script for checking the status of a user and its d...: The following script will generate a "drop user" and a "drop tablespace" command if the tablespace is used exclusively ...

Oracle DBA by Example. Code samples, Scripts, Reference.: Unexpected Error: ORA-02054: transaction 94.44.407...

Oracle DBA by Example. Code samples, Scripts, Reference.: Unexpected Error: ORA-02054: transaction 94.44.407...: Scenario A transaction on a local and on a remote database fails at commit The error: Unexpected Error: ORA-02054: transaction 94.44.4071354...

ANJANI APPS DBA: How to apply Oracle 19C RU - January 2026 step by ...

ANJANI APPS DBA: How to apply Oracle 19C RU - January 2026 step by ...:  Hi All, In this post i am going to share about Oracle 19C JAN-2026 RU patch apply step by step lab . Firstly we need to login support.oracl...

Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Encryption - Encrypt data on storage with w...

Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Encryption - Encrypt data on storage with w...:  --Specify location for wallet root ALTER SYSTEM SET WALLET_ROOT='$ORACLE_BASE/admin/igt/wallet' SCOPE=SPFILE; Restart Oracle is req...

Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Encryption - encrypt data

Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Encryption - encrypt data: Permissions on Oracle package  DBMS_CRYPTO ======================================== GRANT EXECUTE ON DBMS_CRYPTO TO TEST_USER; =============...

Bryan's Oracle Blog: Automating cloning of your Exadata Database Servic...

Bryan's Oracle Blog: Automating cloning of your Exadata Database Servic...: One of the questions I often get from customers is  "How do I automate the cloning of a production database backup to a non-prod c...