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 [...]
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 [...]
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.
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.
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 [...]
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 [...]
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.
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 [...]
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 [...]
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 [...]