Страницы

▼
среда, 30 декабря 2015 г.

ORA-8102 on ALTER TABLE SHRINK SPACE with default column optimization

›
We have been using centralized AWR repository since 2013. I developed some PL/SQL procedures for that using original awrextr.sql/awrload.sq...
понедельник, 30 ноября 2015 г.

V$SQL_PLAN_MONITOR.STARTS is higher than expected due to NLJ batching/Prefetching

›
Recently one of the developers asked me to explain why V$SQL_PLAN_MONITOR.STARTS is higher than expected for one particular query. Here is ...
четверг, 29 октября 2015 г.

12c: PX Auto DOP without IO Calibration

›
I have upgraded one of data warehouse database this week and noticed changes in behaviour of PX Auto DOP feature. According to the documen...
среда, 30 сентября 2015 г.

Bug 20214168 - Wrong Results using aggregations of CASE expression with fix of bug 20003240 present

›
I started to use Oracle 12c in the early 2014 in non-production environments. At now I am extensively testing the ADO, In-Memory functional...
понедельник, 17 августа 2015 г.

EM 12.1.0.4 Installing recommended Plug-Ins and Patches

›
In one of the project we will use DBaaS (Database as a Service) functionality of EM Cloud Control 12c. We faced with a multiple issue and d...
понедельник, 3 августа 2015 г.

Reclaim unused space from MLOG$ segments after MVIEW Refresh

›
We are using fast-refreshable MVIEWs in some of our database for reporting purposes. They are works fine most of the time. However, period...
среда, 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...