view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Repository Creation Utility - OBIEE 11g

RCU is the short name and is basically used to create the database schema for Fusion Middleware 11g.

I Didn’t Know That 6 – What is Wrong with this Quote?

December 14, 2010 (Back to the Previous Post in the Series) In the interest of interesting quotes, a quote that I found in the “Oracle Tuning the Definitive Reference Second Edition” book on page 541: “Oracle speeds are very high with SSD, and SSD is also cheap at only $1k/gig USD…  Companies are now offering solid-state [...]

Teaser Announcement: Second International NoCOUG SQL Challenge

The Second International NoCOUG SQL Challenge is almost ready for publication. This time, the challenge requires contestants to first figure out what exactly needs to be done before trying to do it. The first challenge had nine solutions from seven countries and three continents which should be hard to beat. In addition to prizes, the winner [...]

make count(*) faster

I just install Oracle Enterprise Linux on my new notebook.
I wanted to check how far could I improve the performance of a count(*)

SQL> drop table big_emp;

table big_emp dropped.
258ms elapsed

SQL> create table big_emp as
  with l as(select 1 from dual connect by level<=3000)
  select rownum empno,ename,job,mgr,hiredate,sal,comm,deptno from emp,l,l

table big_emp created.
330,390ms elapsed

SQL> alter table big_emp add primary [...]


Whn looking for information and ideas on a topic I like to browse through a few items that might be related as this can help to prompt me to think about side effects and consequences that I might need to consider, so, to make it easier for people to find related information when searching my [...]

Index ITL fix

Over the last year I’ve written a short collection of articles describing how a defect in the code for handling indexe leaf node splits can cause a significant waste of space in indexes that are subject to a high degree of concurrent inserts. Finally I can announce some good news – Oracle has a patch [...]

OBIEE 11g Getting Started

After a long gap I am looking into OBIEE 11g. After completing Datacenter Migration Project and Database 11g Upgrade Project, I am now set to go for Fusion Middleware 11g Upgrade early next year.

But this December it is OBIEE 11g.
Early this year I created a OBIEE 10g Environment with BI Publisher 10g. But I see that there has been a lot(a lot) of enhancement done with OBIEE 11g.

Oracle changes core processor licensing factor for HP Itanium

This blog is probably only of interest to those shops that use HP Itanium chips but from this month Oracle have changed the Core Processor Licensing Factor for Intel Itanium Series 93XX from 0.5 to 1.0. This will impact new servers that require licensing but and as I understand it for those companies with site [...]

I Didn’t Know That 5 – What is Wrong with this Quote?

December 13, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) In the interest of interesting quotes, a quote that I found in the “Oracle Tuning the Definitive Reference Second Edition” book on page 539: “But what is Oracle’s official position on multiple blocksizes?  For Oracle metal-level customers, there is [...]

Log Buffer #209, A Carnival of the Vanities for DBAs

Welcome to Log Buffer, the weekly news update of happenings in the database world.
A big shout out to Pythian team members Andrey, Gwen, Fahd, and Don for their submissions. We have lots of news and recommended reading this week so let’s get going with Log Buffer #209.
Andrey Goryunov’s top picks:

Dion Cho, the Oracle Performance [...]

view counter