Why this article? First of all because I had fun digging in the code. Then, I was reading a lot about the improvements we will have in MySQL 5.6, and of some already present in 5.5. Most of them are well cover by people for sure more expert then me, so I read and read, [...]
Pythian’s Oracle Apps DBA team recently upgraded a client’s E-Business Suite system to version 12.1.3, bringing them into compliance with Oracle’s baseline support requirements for Release 12.1 nearly one year ahead of deadline. We’d like to tell you a bit about this project — not to toot our own horn (though that’s nice too, we [...]
I had a tricky performance problem to solve this week. Some SQL was running too slow to support the business need. I made the changes and additions I could see were needed to solve the problem and got the code running much faster – but it would not run faster consistently. It would run like a dream, then run slow, then run like a dream again 2 or 3 times and then run like a wounded donkey 3 or 4 times. It was very frustrating.
In article Installing Oracle Linux in VMware virtual machine we covered installation of Oracle Linux 5U8 including oracle-validated package.
Now, our system is ready for Oracle database installation, and no additional configuration tasks is required at this moment. Note: Most of the time we work with OS from remote locations and target servers are located in data centers or somewhere else.
In preparation for a research project and potential UKOUG conference papers I am researching the effect of NUMA on x86 systems.
NUMA is one of the key features to understand in modern computer organisation, and I recommend reading “Computer Architecture, Fifth Edition: A Quantitative Approach” from Hennessy and Patterson (make sure you grab the 5th edition). Read the chapter about cache optimisation and also the appendix about the memory hierarchy!
There is no replacement for the documentation of the database products. There is no alternative of forums for these technologies, and also there is no alter ego for the database blogs. They add up yet another avenue to explore when the professionals need help. This Log Buffer Edition helps professional in identifying few blog posts [...]
As per TomKyte....it makes all of the queries run by exp be "as of the same point in time-- consistent withregards to eachother"imagine if you started an export at 9am of the EMP and DEPT tables.EMP started exporting at 9am and DEPT at 9:15am.Now, the EMP data would be "as of 9am", but the DEPT data would be as of 9:15am. What ifyou import that data now -- will it work? maybe, maybe not -- perhaps at 9:10am, someonefired the last employee in department 50 and deleted department 50. Your EMP exportwould have them in this deptno, your DEPT export would not have this deptno.
Its been observed that after upgrading the database to 11gR2 (126.96.36.199 onwards) SGA components are getting resized even when automatic memory management (MEMORY_TARGET=0) and automatic shared memory management (SGA_TARGET=0) is disabled. Resize are happening to an extent that the component sizes are shrinking below the minimum size set by DBAs.