Tags » 11g

Clean it up

There is some confusion about the expression “clean” in Oracle circles, so I thought I’d write a short note to explain the different ways in which the word may be applied to Oracle blocks. 1,207 more words

Infrastructure

Wei Shan reblogged this on Weishan's Oracle Blog and commented:

An extremely good read for understanding how Oracle deals with clean/dirty buffer using UNDO tablespace. It's pretty confusing though!

Outer join Filter Push Down (FPD)

Version is 12.1.0.2. Given the below tables:

drop table t1 purge;
drop table t2 purge;

create table t1 (id1 number, id2 number, x varchar2(100));
create table t2 (id1 number, id2 number, x varchar2(100));

insert into t1 select rownum, rownum, lpad('X', 100) from dual connect by level <= 1e5; 
insert into t2 select rownum, NULL, lpad('X', 100) from dual connect by level <= 1e5;  

commit; 

create index t1_id1 on t1(id1); 
create index t1_id2 on t1(id2); 
create index t2_id1 on t2(id1); 
create index t2_id2 on t2(id2); 

exec dbms_stats.gather_table_stats(user, 'T1', estimate_percent=> NULL, cascade=> true);
exec dbms_stats.gather_table_stats(user, 'T2', estimate_percent=> NULL, cascade=> true);
… 430 more words
Oracle

Don't forget the Logical Layer

I often see OBIEE RPD’s which are developed via “Drag ‘n Drop”. If you know what you are doing this hasn’t necessarily have to be a problem. 454 more words

11g

Updated Oracle Database Release Schedule

FYI, the release schedule in MOS (742060.1) was updated last week. Basically:

12.2.0.1 – expected in January 2016.
12.1.0.2 – terminal release of 12.1, in Premier Support until the… 177 more words

Oracle Databases

New AWR Report Format: Oracle 11.2.0.4 and 12c

This is a post about Oracle Automatic Workload Repository (AWR) Reports. If you are an Oracle professional you doubtless know what these are – and if you have to perform any sort of performance tuning as part of your day job it’s likely you spend a lot of time immersed in them. 1,346 more words

Oracle

4 X 11g. Promina Ginseng Pearl Acne Cream. (Removal of Freckle or Darkish Spots. - Acne Will Dry and Disappear...

Reviews 4 X 11g. Promina Ginseng Pearl Acne Cream. (Removal of Freckle or Darkish Spots. – Acne Will Dry and Disappear… for sale

Please take a few moments to view the… 112 more words

BI Publisher 11G: How to display a BLOB Image in an RTF Template.

Although the task seems relatively easy, the information available is too vague and you might find yourself struggling to understand what needs to be done, specially if you are just getting started with BI Publisher. 89 more words

11g