Infrastructure at your Service

All Posts By

Joël Cattin

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 | One Comment

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 | 3 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 | 2 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 | 5 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