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...

Bryan's Oracle Blog: Autonomous Recovery Service Live Lab available

Bryan's Oracle Blog: Autonomous Recovery Service Live Lab available: One of the latest additions to Oracle's Live Labs is the Autonomous Recovery Service. This lab  allow you to understand how to utilize t...

Database-Box: Logging Options in Oracle for Data Guard

Database-Box: Logging Options in Oracle for Data Guard:   Logging Options in Oracle for Data Guard When preparing a  primary Oracle Database  for use with  Oracle Data Guard , enabling the correct...

Bryan's Oracle Blog: MCP Server for Autonomous Recovery Service

Bryan's Oracle Blog: MCP Server for Autonomous Recovery Service: Wouldn't it be nice if I could just use AI and ask my tenancy to tell me about my Autonomous Recovery Service database backups ? I want...

Minimalistic Oracle: Inter-database import and exports using Oracle dat...

Minimalistic Oracle: Inter-database import and exports using Oracle dat...: To move an entire schema from one schema to another within the same Oracle database, there is no need to export data to disk and then reimp...

Bryan's Oracle Blog: How many IP addresses do I need for the Autonomous...

Bryan's Oracle Blog: How many IP addresses do I need for the Autonomous...:  One of the most common questions that comes up is "How many IP addresses do I need to set aside for the Autonomous Recovery Service...

Minimalistic Oracle: How to dump the entire schema's DDL into a file

Minimalistic Oracle: How to dump the entire schema's DDL into a file: pg_dump -d mydb \ --schema-only \ --no-owner \ --no-privileges \ -n myschema \ -f create_schema.sql The flag "--no-owner...

Bryan's Oracle Blog: Recovery Service failure checks

Bryan's Oracle Blog: Recovery Service failure checks:  When using the Autonomous Recovery Service there are some prerequisites that need be met. I have a checklist that goes through these requir...

Oracle DBA by Example. Code samples, Scripts, Reference.: DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC procedure

Oracle DBA by Example. Code samples, Scripts, Reference.: DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC procedure: - Info: Automatic optimizer statistics collection gathers optimizer statistics by  calling the DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC pr...

Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Autotask - auto space advisor

Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Autotask - auto space advisor: Info: The  auto space advisor Calculates stats regarding space usage. The  auto space advisor  Auto Task in Oracle can be very CPU and I/O i...

Erman Arslan's Oracle Blog: Erman Arslan's Oracle Forum -- May 1, 2025 - Feb 6...

Erman Arslan's Oracle Blog: Erman Arslan's Oracle Forum -- May 1, 2025 - Feb 6...: Question:  How much time do you spend/lose? Answer:   Well, how much time I gain? :) Remember, you can ask questions and get remote support ...

Minimalistic Oracle: Dropping an audit policy for a specific user

Minimalistic Oracle: Dropping an audit policy for a specific user: You have the following audit policy: CREATE AUDIT POLICY monitor_sys_everything ACTIONS ALL; AUDIT POLICY monitor_sys_everything BY SYS;...

Erman Arslan's Oracle Blog: Exadata X11M / X11M-Z / Naming, Elasticity, RoCE a...

Erman Arslan's Oracle Blog: Exadata X11M / X11M-Z / Naming, Elasticity, RoCE a...: Recently dived into a new project with newest Exadata(s) inside :) and today, I wanted to share you a quick info about the newest Exadata na...

Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory

Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory: I want to detach an existing oracle_home from my inventory. Note that the last argument must be the full path to the oracle software, NOT t...