Blog: Christian Antognini

209 blogs updated: 4 min. ago
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
Offline Analysis of ASH Data with ASHDUMP
From time to time, it happens to me to carry out offline analyses of ASH data. For that, I mean to analyze the ASH data without having acces...
06-07-2017 14:17:17 Christian Antognini Oracle
Announcing Trivadis Performance Days 2017
It is a great pleasure to announce the next Performance Days! This year the event will take place the 13-14 September in Zurich. Given that ...
24-03-2017 13:01:19 Christian Antognini Oracle
TVD$XTAT 4.0 Beta 11
This is just a short note to point out that I finally uploaded under the downloadable files of TOP a new version of TVD$XTAT. To download it...
01-03-2017 19:53:50 Christian Antognini Oracle
Scripts to Download Oracle Database 12c Release 2 Documentation
In the past (here, here and here) I already shared with you the scripts I use to download the Oracle Database documentation. The aim of this...
01-02-2017 19:36:14 Christian Antognini Oracle
Adaptive Query Optimization: Backport of 12.2 Configuration in
I finally managed to install and test patch 22652097 (PROVIDE SEPARATE CONTROLS FOR ADAPTIVE PLANS AND ADAPTIVE STATISTICS FEATURES). Actual...
22-12-2016 00:30:48 Christian Antognini Oracle
Ad – Oracle Database 12c Release 1 and 2: New Performance Features
In the past I gave a number of 1-day seminars about the new performance features available in Oracle Database 12c Release 1. On the 23rd of ...
20-12-2016 14:27:46 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.