Страницы

▼
среда, 22 июля 2015 г.

Edition-Based redefinition: adjunct schemas

›
EBR (Edition-Based Redefinition) - one of the killer feature of Oracle Database 11g R2, as said Tom Kyte at the 2010 . But I don't thin...
четверг, 18 июня 2015 г.

Function-Based index changed its definition after a rebuild

›
One of our developers have discovered a problem when index column data type changed after index had been rebuild. They asked me for help wi...
четверг, 21 мая 2015 г.

session cursor cache count statistics incorrect with parallel queries

›
Recently I investigated a issue with high 'session cursor cache count' statistics in one of database version 11.2.0.4. I found that ...
среда, 11 февраля 2015 г.

Join elimination not performed in the presence of virtual columns on parent table

›
Today I observed poorly written SQL that performed unnecessary join between PARENT/CHILD tables: SQL> select * from table(dbms_xplan.dis...
понедельник, 9 февраля 2015 г.

Suspending a users session on specific enqueue

›
Recently I faced a strange issue with EBR (Edition-Based Redefinition). In order to understand how things work internally I decided to use D...
понедельник, 22 декабря 2014 г.

c3p0 PROBABLYNOT connection test query

›
I am participating in the project, which uses Play framework version 1.x. Business logic at the application level, data stored in the Orac...
вторник, 16 сентября 2014 г.

Bug 4991675 - Diagnostic event improve diagnosability of data dictionary invalidation issues

›
In recent MOS HOT Topics email I found a note: Bug 4991675 - Diagnostic event improve diagnosability of data dictionary invalidation issues ...