Blog: Christian Antognini

210 blogs updated: 69 min. ago
Partition-Wise Operations - New Features in 12c and 18c
Partition-wise operations are not something new. I do not remember when they were introduced, but at that time the release number was still ...
17-05-2018 20:13:56 Christian Antognini Oracle
If you run TKPROF without arguments, you get a complete list of its arguments with a short description for each of them (here the output gen...
21-03-2018 15:39:32 Christian Antognini Oracle
Scripts to Download Oracle Database 18c Documentation
In the past I already shared with you the scripts I use to download the Oracle Database documentation. The aim of this short post is to refe...
27-02-2018 21:08:16 Christian Antognini Oracle
CDB Views and Query Optimizer Cardinality Estimations
Today I faced a performance problem caused by a bad cardinality estimation involving a CDB view in a multitenant environment. While...
18-01-2018 18:41:21 Christian Antognini Oracle
How Well a Query Optimizer Handles Subqueries?
At the beginning of December, at the UKOUG Tech17 conference in Birmingham (GB), I presented a comparison of the query optimizers of MySQL 8...
01-01-2018 00:06:24 Christian Antognini Oracle
Purging Unused Triples Is a Never-ending Operation
This is a short post to point out a problem I recently discovered and for which I couldn't find information online. Hence, in case you hit i...
18-12-2017 16:08:16 Christian Antognini Oracle
You can use the V$SQL.IS_RESOLVED_ADAPTIV E_PLAN column to know whether the execution plan associated to a child cursor is adaptive or not. ...
11-12-2017 14:35:35 Christian Antognini Oracle
SPD State Does Not Change If Adaptive Statistics Are Disabled
The aim of this post is to point out an issue (bug?) that I recently discovered. But, before talking about it, I need to go through a rather...
28-11-2017 16:18:52 Christian Antognini Oracle
The APPROX_MEDIAN Function - A Test Case
The aim of this post is not to explain how the APPROX_MEDIAN function works (you find basic information in the documentation) but to show yo...
30-10-2017 08:14:52 Christian Antognini Oracle
Activating and Deactivating Performance Feedback
Performance feedback is one of the adaptive query optimizer features introduced in Oracle Database 12c. The aim of this short post isn't to ...
26-09-2017 18:47:48 Christian Antognini Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.