前回の分析でLINEITEMのdirect path readアクティビティが高いのが分かった。
ON CPU : direct path read = 6 : 4 であるはずだ。
しかし、今回使用しているIntel Core i7 860（実売価格25000円）クラスであればUncompressがそれほど問題になっていないことが分かった。
Lindsay from Cervello Consultants has asked me to promote a job he is recruiting for. Lindsays company specialises in data security assurance and particularly in designing, deploying, integrating and testing database security vulnerability scanning, enterprise scanning solutions, database activity monitoring....[Read More]
Posted by Pete On 13/08/10 At 09:29 AM
LINEITEMのdirect path readが全体の78%の負荷が分かる。
Embarcadero® DB Optimizer™ XE を初めて使ってみたのだけど、
A few years back I had the pleasure of meeting Ben Prusinski at Oracle Open world. Ben has published several books on Oracle Internals and Debugging. In his most recent project he teams with Guenadi Jilevski and Syed Jaffer Hussain to write
“Oracle 11g R1/R2 Real Application Clusters Handbook”. I have only just cracked the cover but already know this will be a good resource for the beginner and seasoned professional. If you want to look for yourself, you can preview or order the book through PACKT publishing.
I’m in the later stages of implementing Oracle Enterprise Manager 11g for a customer. Right now there are rather too many metric collection errors for either myself or the customer to be truly happy with. There is remarkably little other than this post by Oracle’s Werner.de.Guyter on how to deal with these. Unfortunately whilst Werner’s [...]
Wow! I just finished presenting a webinar on APEX 4.0 New Features and Websheets. Websheets allow non-technical people to copy-and-paste spreadsheets into APEX and then manipulate them using sophisticated database features; so easy… You can see the webinar slides at http://www.parklane.com.au or http://www.kingtraining.com
With the recent news that the latest version of VirtualBox now supports shared disks, I thought I better give it a go and see if I could do a RAC installation on it. The good news is it worked as expected. You can see a quick run through here:
This is pretty good news as that was the last feature that tied me to VMware Server. I’ve now moved pretty much everything I do at home on to VirtualBox and it’s working fine.
It’s worth taking a little time looking at the VBoxManage command line. Some of the operations, like creating the shared disks, have to be done from the command line at the moment. It’s also handy for running VMs in headless mode if you don’t want the GUI screen visible all the time.
Unseen Academicals is the 37th book in the Discworld series. When I first started reading the series I found Terry Pratchett‘s writing style a little strange. Having had a long break from reading his stuff, switching back was a little difficult at first. Fortunately the characters are brilliant, so you get drawn back in fairy quickly. The first 50 pages were a little tricky, but after that it was just like home again.
The wizards of the Unseen University are forced to make a decision between playing football or eating less, so obviously they pick football. There are a few new characters introduced, including Nutt, who is awesome.
If you like the others you will love this.
PS. Football refers to real football, not that American stuff.
There seems to be little debate that Oracle’s launch of the Oracle Exadata Storage Server and the Sun Oracle Database Machine has created buzz in the database marketplace. Apparently there is so much buzz and excitement around these products that two competing vendors, Teradata and Netezza, have both authored publications that contain a significant amount of discussion about the Oracle Database with Real Application Clusters (RAC) and Oracle Exadata. Both of these vendor papers are well structured but make no mistake, these are marketing publications written with the intent to be critical of Exadata and discuss how their product is potentially better. Hence, both of these papers are obviously biased to support their purpose. My intent with this blog post is simply to discuss some of the claims, analyze them for factual accuracy, and briefly comment on them. After all, Netezza clearly states in their publication: The information shared in this paper is made available in the spirit of openness. Any inaccuracies result from our mistakes, not an intent to mislead. In the interest of full disclosure, my employer is Oracle Corporation, however, this is a personal blog and what I write here are my own ideas and words (see [...]
In the second note on my thesis that “all joins are nested loop joins with different startup costs” I want to look at hash joins, and I’ll start by going back to the execution plan I posted on “Joins – NLJ”. --------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| [...]