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 [...]
Thank you for all those who came to my session in NYOUG Metro Area Meeting. I know you had choices; and I am honored by for gracing my session. I apologize for running out of time. In the hindsight, I should have entertained questions at the end.
This week-end I finally got around importing all my old use.perl.org blog entries to Fearful Symmetry. To ease off the migration, I ended up writing two itsy-bitsy scripts. They’re nothing fancy, but in case they might help someone, here they are.
Harvest the entries
This was easy. For each account, use.perl.org has a journal entries [...]
Recently, while delivering a presentation on Cache Fusion at New York Oracle Users Group (www.nyoug.org), the regional user group where I have been a long time member, I was surprised to hear from many participants some beliefs they had held for a long time that were completely wrong. I always thought these were as obvious as they come; but of course I was dead wrong. What was even more surprising that most of these believers were veterans in Oracle Database technologies; not newbies.