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