Testing variants of CTAS
Category: Oracle
TUE Post: Use Oracle SQL Developer to move data between databases
Use INSERT hint with SQL Developer
CTAS Performance
Tune CTAS statements on Oracle Database
Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans
Very nicely explained by sqlmaria / Maria Colgan in the YouTube clip below. Clear and clean. I repost this as a reference and will add more later, if needed. https://youtu.be/Xpmi55rn4YE
Tuesday Post: Database schemas compare
One of the questions that arise during the development process is if the database schéma I work on is an unaltered image of production. How do I know that another developer didn’t experiment with a new index or modified the…
Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are now available
We published two updates last night, both maintenance releases, aka bug fixes only. Released January 19, 2022.That being said, everyone should …Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are now available
Help, my Oracle SQL Developer is crashing!
With 7,000,000 users, give or take a million, I get quite a few notes from folks who are having problems getting SQL Developer to open, or to STAY …Help, my Oracle SQL Developer is crashing!
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