Infrastructure at your Service

All posts by Joël Cattin

Joël Cattin
Consultant

Joël Cattin holds the degree from the École Supérieure d'Informatique de Gestion from Delémont and a Certificate of Professional Qualification in Informatics (Certificat fédéral de Capacité - CFC). Specialized in modelization and development of Oracle APEX Application, practiced during various projects, Joël holds a solid basis in MySQL technologies, Microsoft technologies (Microsoft SQL Server,Windows Server), Oracle technologies (DBA Essentials, Backup & Recovery, Linux, Data Guard) as well as in network administration. Joël is ITIL V3 Foundation certified.
Joël Cattin

PostgreSQL 10 Beta 1 : pg_hba_file_rules view

By | Database Administration & Monitoring, Database management | No Comments

This small blog to share a helpful stuff with the pg_hba.conf file : The pg_hba.conf file is the central configuration file to control client authentication. It is located in the database cluster’s data directory : postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] ll pg_hba.conf lrwxrwxrwx. 1 postgres postgres 59 Jun 30 10:19 pg_hba.conf postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] When you add or modify an entry in this file, you have to reload the cluster to take the changes in account : postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1]…

 
Read More
Joël Cattin

Oracle 12cR2 : Optimizer Statistics Advisor

By | Database Administration & Monitoring, Database management, Development & Performance | No Comments

The Optimizer Statistics Advisor is a new Advisor in Oracle 12.2. The goal of this Advisor is to check the way you gather the statistics on your database, and depending on what is found, it will makes some recommendations on how you can improve the statistics gathering strategy in order to provide more efficient statistics to the CBO. This Advisor is also able to generate remediation scripts to apply the statistics gathering “best practices”. The…

 
Read More
Joël Cattin

Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table

By | Database Administration & Monitoring | No Comments

It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned table…online ! As a reminder, the way to convert a table to a partitioned table were to use the DBMS_REDEFINITION package (since 9i to 12cR1) which require few steps : Verify that the table is a candidate for redefinition : DBMS_REDEFINITION.CAN_REDEF_TABLE…

 
Read More
Joël Cattin

Oracle 12cR2 : Partitioning improvements – multi-column list partitioning & read-only partitions

By | Database Administration & Monitoring, Development & Performance | No Comments

In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image : “Oracle Partitioning in Oracle Database 12c Release 2″ – Hermann Bär With the first release of 12c it wasn’t possible to create list partitioned tables based on multi-column partition key : ORA-14304: List partitioning method expects a single partitioning…

 
Read More
Joël Cattin

Oracle 12cR2 : Partitioning improvements – auto-list partitioning

By | Database Administration & Monitoring, Development & Performance | No Comments

The second release of Oracle Database 12c (12cR2) comes with new improvements regarding partitioning. In this blog post I’ll show one of them : auto-list partitioning. Auto-list partitioning is an extension of list partitioning. It enable the automatic creation of partitions for new values inserted into the partitioned table. Image : “Oracle Partitioning in Oracle Database 12c Release 2″ – Hermann Bär Let’s have a look at the syntax. As you can see below, you…

 
Read More
Joël Cattin

OTN Appreciation Day : OSWatcher Black Box Analyzer (OSWBBA)

By | Operation systems | No Comments

Following my last blog post about OSWatcher, I will present in this one OSWatcher Black Box Analyzer (OSWBBA), which is the tool that you can use to display graphically the data collected by OSWBB. This tool is a Java utility and exists since OSWatcher version 4.0.0. It permits to create graphs and complete HTML reports containing collected OS statistics.   OSWBBA require no installation. It is embedded in the OSWatcher home directory. To start the…

 
Read More
Joël Cattin

OTN Appreciation Day : OSWatcher Black Box (OSWBB)

By | Operation systems | No Comments

In this post, I will present a usefull and easy-to-use Oracle tool : OSWatcher. What is it ? OSWatcher Black Box (OSWBB), for its full name, is a free Oracle Tool which will help you to diagnose performance issues on the OS side. Of course, it will not solve the issue for you, but it gives a system health state at a given moment. OSWBB is multi-platforms supported (AIX, Solaris, HP-UX, Linux and Windows) and…

 
Read More
Joël Cattin

“FRA full” alerts flood the Alert Log

By | Database Administration & Monitoring | 4 Comments

We discovered a strange behavior in the Alert Log when the Fast Recovery Area (FRA) is full and the database wants to write something inside it (for example an archivelog). This case concern Oracle 11.2.0.3 databases and higher. Here is a demo with a 12c database (12.1.0.2) : First, to reproduce the behavior, I set a very small size to the FRA : SQL> alter system set db_recovery_file_dest_size = 1M; System altered. SQL> As you can see, the…

 
Read More