CTAS Performance
25/09/2022
Tune CTAS statements on Oracle Database … More CTAS Performance
Category: db
Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans
11/08/2022
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.
Researching the Performance Puzzle | Ardent Performance Computing
07/08/2022
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 … More Researching the Performance Puzzle | Ardent Performance Computing
Tuesday Post: Database schemas compare
15/03/2022
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 … More Tuesday Post: Database schemas compare
Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are now available
22/01/2022
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 … More Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are now available
Help, my Oracle SQL Developer is crashing!
22/01/2022
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, … More Help, my Oracle SQL Developer is crashing!
Manage Sessions in Oracle Database
20/01/2022
Review of methods to manage Oracle Database sessions … More Manage Sessions in Oracle Database
Overview: SELECT SAMPLE
16/01/2022
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 … More Overview: SELECT SAMPLE
Estimate Defragmentaton Benefits for a Bigfile Tablespace
28/11/2021
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 … More Estimate Defragmentaton Benefits for a Bigfile Tablespace
Oracle ULS
18/11/2021
My experience using Oracle’s Unlimited Learning Subscription … More Oracle ULS
Column Level Collation Example
24/10/2021
The feature was first introduced in 12.2 . It basically determines how the string comparison takes place. In order to use the feature, extended data types should be enabled.
I speak at SPOUG ’21
18/10/2021
Oracle Autonomous and Data Lake Accelerator Below you can see the details of your session, including the scheduled time of your session: Session Code: SP21DBSEINF001 Name: Radu Pârvu Email: radu.parvu@accenture.com Position: Director Twitter: https://twitter.com/rparvu Linkedin: https://www.linkedin.com/in/rparvu/ … More I speak at SPOUG ’21
Riding to fight kids cancer! Please donate!
01/09/2021
Hej! This September, I am taking part in the Great Cycle Challenge to fight kids’ cancer! My goal is to pedal 200 miles throughout the month. Why am I doing … More Riding to fight kids cancer! Please donate!
Starting Oracle SQL Developer with Custom Parameters
21/08/2021
I recently worked at a Client that had the Windows desktop setup in a non-English language. Naturally, I did not get admin rights on the Client owned desktop so I … More Starting Oracle SQL Developer with Custom Parameters