Hi there Giving an SQL tuning training session, I came to the following point: This query: [code language=”sql”] select count(prs.firstname), count(adr.zip_additional), count(mlg.dispatch_date) from addresses adr join recipients rec… Read more »
Hi there, what’s wrong on the picture bellow? When trying to get sql activity behind there is nothing. [code language=”sql”] select sql_id,wait_class, blocking_session from v$active_session_history where event =’log file… Read more »
Hi There, I had a chance to play a little bit with the latest Exadata X5-2 and OVM and here is something really cool. I have create two VMs to… Read more »
Hi there, I have a customer that currently complain on some queries taking too long during his nightly load jobs. After a quick look, I discover few queries doing “select… Read more »
Hi there, The idea came to me while running an audit to identify bottlenecks in an Oracle infrastructure composed of two servers with many single instances. Due to lack of… Read more »
Hi There, I went to a customer today for a performance issue between test and production environment. Basically, a specific process was 5 times faster in test than in… Read more »
References: here and here and here Example 1 Using heap table with ADVANCED ROW COMPRESSION and no movement to tier. [code language=”sql”] SQL> create table scott.employee (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10),… Read more »
[code language=”sql”] [/code] Hi there In a context of storage pressure, it might help, in case of refresh of test database from production, to limit the size of data by… Read more »
Test do with jkosales table that is a copy using CTAS from sh.sales table. [code language=”sql”] Create table jkosales as select * from sales; [/code] Add the in-database archiving feature… Read more »
[code language=”sql”] [/code] Hi there, I was about to copy some backups done in my FRA under ASM on my 12c 8 node stretched cluster. Three mouth ago, with some… Read more »