By Franck Pachot . In a previous post I described the new V$SQL views about rolling invalidation. I did the example with dbms_stats which is able to do rolling invalidation since 11g. But more is coming with 12.2 as you can use rolling invalidation for some DDL. When you do some DDL on an object, dependent cursors are invalidated. On…
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…
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…
By Franck Pachot . This morning during Gerald Venzl presentation of “What’s New for Developers in the Next Generation of Oracle Database” at Oracle Open World, one feature has been acclaimed by a full room: 12.2 show the end of identifiers limited to 30 characters. 12.1 We knew it would happen because in 12.1 all data dictionary views have 128…
By Franck Pachot . It’s official, Larry Ellison made the announcement at first keynote and the database product team at oracle has released the version and the documentation publicly. Oracle Database Exadata Express Cloud Service is the ‘Cloud First’ environment for 12.2 Documentation Documentation is there: Cloud > Platform > Data Management > Exadata Express The 12.2 new features available…
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…
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…
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…
