12.2

12cR2 has new SQL*Plus features

By Franck Pachot . 12cR2 is there. What's new in SQL*Plus? For sure, you can't expect lot of things from it. The new command line is the SQL*Developer sqlcl which aims to be 100% compatible with SQL*Plus with lot of(…)

Oracle 12cR2: MAX_PDBS

By Franck Pachot . Oracle database 12.2 is there on the Database Cloud Service, in multitenant. In EE High Performance or Extreme Performance, you have the multitenant option: you can create 4096 pluggable database (instead of 252 in 12.1). If(…)

Oracle 12cR2: Pluggable database relocation

By Franck Pachot . Here is, in my opinion, the most beautiful feature of the multitenant architecture. You know how I love Transportable Tablespaces. But here: No need to put the source in read/only No need to export/import the metadata(…)

12cR2 multitenant containers in SQL_TRACE

By Franck Pachot . In multitenant you session can switch between containers. For example, since 12.1, a common user can switch explicitly between CDB$ROOT and any PDB with the 'ALTER SYSTEM SET CONTAINER'. Any user connected to a PDB will(…)

Oracle 12cR2 multitenant: Local UNDO

By Franck Pachot . Pluggable Databases are supposed to be isolated, containing the whole of user data and metadata. This is the definition of dictionary separation coming with multitenant architecture: only system data and metadata are at CDB level. User(…)

Oracle 12cR2 PL/SQL new feature: TNSPING from the database

By Franck Pachot . Database links are resolved with the server TNS_ADMIN configuration (sqlnet.ora and tnsnames.ora). You can use tnsping to check the resolution, but it supposes that you are on the server and have set the same environment(…)

Oracle 12cR2: DDL deferred invalidation

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(…)

Oracle 12cR2: IS_ROLLING_INVALID in V$SQL

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(…)

Oracle 12cR2 Optimizer Adaptive Statistics

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(…)

Oracle 12cR2 Long Identifiers

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(…)