Infrastructure at your Service

12.2 Archives - Page 5 of 5 - Blog dbi services

Franck Pachot

Oracle 12cR2 SQL new feature: LISTAGG overflow

By | Database Administration & Monitoring | No Comments

LISTAGG was a great feature introduced in 11g: put rows into line with a simple aggregate function. 12cR2 adds an overflow clause to it. What happens when you have so many rows that the LISTAGG result is too long? SQL> select listagg(rownum,’,’)within group(order by rownum) from xmltable(‘1 to 10000′); select listagg(rownum,’,’)within group(order by rownum) from xmltable(‘1 to 10000′) * ERROR at line 1: ORA-01489: result of string concatenation is too long An error at runtime,…

 
Read More
Franck Pachot

Question is: upgrade now to 12.1.0.2 or wait for 12.2 ?

By | Database Administration & Monitoring | 8 Comments

Let’s look at Release Schedule of Current Database Releases (Doc ID 742060.1) 12.2.0.1 is planned for 2HCY2016 on platforms Linux x86-64, Oracle Solaris SPARC (64-bit), Oracle Solaris x86-64 (64-bit). 2HCY2016 starts next week but we can imagine that it will not be released immediately and anyway we will have to wait a few months to download the on-premise(s) version. Add another couple of months to get at least one Proactive Bundle Patch to stabilize that…

 
Read More
Franck Pachot

You are in Standard Edition One? Don’t worry.

By | Database Administration & Monitoring, Oracle | 21 Comments

You want the amazing features of Oracle SQL and PL/SQL with minimal cost. Your database is too large for Oracle XE edition, but not big enough to require the cost of Enterprise Edition. You accept to do things manually, have maintenance windows. You are ok with a RTO of 5 minutes (time to switchover with Dbvisit standby), RPO of 10 minutes (archive_lag_target=600). Your servers have no more than 2 sockets. So you opted for Standard…

 
Read More