Database
-
Comparing Oracle Databases: Initialization Parameters
-
CTAS Performance II: TESTING
-
TUE Post: Use Oracle SQL Developer to move data between databases
-
CTAS Performance
-
Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans
-
Researching the Performance Puzzle | Ardent Performance Computing
The PostgreSQL Performance Puzzle was, perhaps, too easy – it didn’t take long for someone to guess the correct answer! But I didn’t see much discussion about why the difference or what was happening. My emphasis on the magnitude of the difference was a tip-off that there’s much more than meets the eye with this……
-
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 structure of some table? Writing scripts to compare my current database with the ‘source of…
-
Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are now available
-
Help, my Oracle SQL Developer is crashing!
-
Manage Sessions in Oracle Database
-
Overview: SELECT SAMPLE
-
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 way to estimate the space benefits of defragmenting the tablespace. I will use two methods.