This article emphasizes common mistakes clients make in data migration strategies using Oracle datapump. Instead of risking the migration process with large data dumps, the author suggests a strategy to ensure the success of data migration. This includes validating all constraints, refraining from exporting certain database elements, and running jobs in interactive mode. The article also provides recommended parameters for exporting and importing, backed by relevant references.
Category: 19c
SQLcl: Setup on a Mac
Simple and straightforward steps about how to setup Oracle's new SQL command line tool on a macOS X environment. Download Download the mac kit from the Oracle site. Unzip the kit into the correct directory: % unzip Downloads/sqlcl-23.1.0.089.0929.zip -d Applications…
Problematic Statistics of the Application Objects in your Oracle Database
One of the often asked questions is to find out the status of the statistics of the application owned schemas. In this article, I will list the SQL code that I used for this purpose. As well, I will publish…
Read More Problematic Statistics of the Application Objects in your Oracle Database
Oracle Automated DB Maintenance Tasks
This is a short article on how to manage the automated Oracle database maintenance tasks. Make sure the needed rights are in place by running the check: SELECT grantee, privilegeFROM dba_tab_privsWHERE owner = 'SYS'AND table_name = 'DBMS_AUTO_TASK_ADMIN'AND privilege = 'EXECUTE';…
Comparing Oracle Databases: Initialization Parameters
A method for comparing the Oracle init parameters of several PDB’s
CTAS Performance II: TESTING
Testing variants of CTAS
CTAS Performance
Tune CTAS statements on Oracle Database
Manage Sessions in Oracle Database
Review of methods to manage Oracle Database sessions
Overview: SELECT SAMPLE
One feature that many developers and data analysts are not aware of is the SAMPLE function in Oracle. It is quite an old feature (not sure exactly when it was added). Below is a simple example of how it works.…
Estimate Defragmentaton Benefits for a Bigfile Tablespace
Database: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 I write this post in order to follow step by step how a bigfile tablespace is created and managed in 19c. The main purpose is to find a…
Read More Estimate Defragmentaton Benefits for a Bigfile Tablespace