Infrastructure at your Service

Category Archives: Development & Performance

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
Arnaud Berbier

UKOUG 2016 – Third day

By | Application integration & Middleware, Development & Performance | No Comments

Today, it’s the third day in Birmingham for the UKOUG Tech16 event. We had a good time yesterday evening in English pubs. Today, I attended several sessions. Sessions that I was mostly interested in was the “Application Express 5.1 New Features part 1 and part 2. The 1st session was presented by David Peake from Oracle. He provided main new features that will come with Apex 5.1. He demonstrates new capability for developer usage improvement in terms…

 
Read More
Arnaud Berbier

UKOUG 2016 – Second day

By | Application integration & Middleware, Development & Performance | No Comments

This second day at UKOUG was quite good. I slept well at the Jurys Inn hotel and this morning, I enjoyed one more time a real English breakfast with beans, bacons, eggs and sausages. I like that to be fit over all the day Today, I attended the general Keynote and several sessions around integration, APEX & Database Development and Database. My colleague, Franck Pachot also presented today and I attended his session “12c Multitenant: Not…

 
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
Stéphane Haby

SQL Server 2016 – R Services Tips: How to find installed packages using T-SQL?

By | Development & Performance | No Comments

If you have restricted access to the server and you do not know if your packages are installed on the SQL Server with the R Services, you have the possibility to do it by T-SQL. The R command/function to use is “installed.packages()”. As you can read in the R Documentation for installed.packages(),  this function scans the description of each package. The output is a table with 16 columns with basically these information: Package LibPath Version…

 
Read More
Stéphane Haby

SQL Server 2016: New useful function STRING_SPLIT()

By | Development & Performance | No Comments

Now, in the latest version of SQL Server, you have one of the most expected function as well as for developers as for administrators, splitting a string natively in T-SQL: STRING_SPLIT(<character expression>,<separator>) This function has 2 parameters: The character expression with a data type of nvarchar,varchar,nchar or char The separator with a data type of nvarchar(1), varchar(1), nchar(1) or char(1) The function return a table of one column with all splitting string A first test…

 
Read More
David Barbarin

SQL Server 2016: TRUNCATE PARTITIONS with sliding Windows scenarios

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

Some time ago, I had to deal with a new partitioning scenario that included sliding windows stuff for mainly archiving purpose. Regarding the customer context, I used some management scripts that include this time dropping oldest partition. We didn’t care about data oldest than 2 years. Usually in this case, I use a method that consists in dropping data by switching first the oldest partition to a staging table and then truncate it. Finally we may…

 
Read More
David Barbarin

When an index seek operator is not always your friend

By | Development & Performance | No Comments

Did you ever consider an index seek as an issue? . Well, let’s talk about a story with one of my customers where the context is pretty simple: a particular query that is out of the range of the application’s performance requirements (roughly 200ms of execution time in average). The execution plan of the query was similar to what you may see in the picture below:   At first glance, no obvious way to improve…

 
Read More
David Barbarin

Les 24 heures du PASS (24HOP) – édition francophone

By | Business Intelligence, Database management, Development & Performance, Technology Survey | No Comments

Je n’ai pas encore blogué sur le sujet mais il est temps de le faire. Cette année, aura lieu la première édition francophone des 24h du PASS  les 20 et 21 septembre 2016. L’idée est plutôt simple: proposer une série de 24 webinaires gratuits de 10h jusqu’à 22h (heure française)  pendant 2 jours. C’est l’occasion de recevoir et d’échanger les dernières informations autour de l’administration et du développement des bases de données, des nouvelles tendances côté Business Intelligence…

 
Read More
Philippe Schweitzer

Java reflection: Get classes and packages names from a root package within a custom URLClassloader

By | Development & Performance | No Comments

I have got a case for which I needed to use a custom Classloader, in order to find the list of classes and packages available across several software plugins materialized by a set of jar files. These jar files are intended to be located inside a particular place. After googling, some solutions invited us to deploy external libraries. But I was not interested to manage another lib in my soft just for that purpose. So,…

 
Read More