Infrastructure at your Service

12.2 Archives - Page 5 of 5 - Blog dbi services

Oracle Team

Oracle 12cR2: IS_ROLLING_INVALID in V$SQL

By | Database Administration & Monitoring | No Comments

By Franck Pachot . In a previous post I published a test case to show when a cursor is not shared anymore after a rolling invalidation. Basically the dbms_stats marks the cursor as ‘rolling invalid’ and the next execution marks it as ‘rolling invalid executed’. Looking at 12cR2 there is a little enhancement in V$SQL with an additional column displays those states.

Read More
Oracle Team

Oracle 12cR2 Optimizer Adaptive Statistics

By | Database Administration & Monitoring | 6 Comments

By Franck Pachot . When 12.1 came out, the major issue we encountered after migration was related to the new adaptive features of the optimizer: automatic reoptimization, SQL Plan Directives and the resulting dynamic sampling. Of course, Oracle product managers listen to feedbacks, ensure to provide workarounds or fixes and make things better for next release. Let’s see what has been announced on this topic for 12.2

Read More
Oracle Team

Oracle 12cR2 SQL new feature: LISTAGG overflow

By | Database Administration & Monitoring | No Comments

By Franck Pachot . 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…

Read More
Oracle Team

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

By | Database Administration & Monitoring | 8 Comments

By Franck Pachot . 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…

Read More
Oracle Team

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

By | Database Administration & Monitoring, Oracle | 24 Comments

By Franck Pachot . 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…

Read More