I worked with our support team to improve the performance of a PeopleSoft Financials update statement yesterday. The update statement had an index hint already in it but the index was not the best one of the available indexes.
Here is the original update statement:
UPDATE /*+ INDEX(B PSCPYMNT_VCHR_XREF) */
SET BANK_SETID = :1,
BANK_CD = :2,
BANK_ACCT_KEY = :3,
PYMNT_METHOD = :4,
BANK_ACCT_SEQ_NBR = :5,
EFT_LAYOUT_CD = :6,
STL_THROUGH = :7
I finished testing 1000 select statements on our new Exadata X5 to see if they would run faster or slower than on our older Exadata V2. Our current production V2 has 12 nodes and the new X5 has only 2. The memory and parallel server parameters on the X5 are 6 times are large as on the old one, since we have one sixth as many hosts and more than 6 times the memory and (more...)
You can find the full length video of my Delphix talk that I did at OakTable World on Tuesday here: url
Also, the OakTable folks have updated the OakTable World agenda page with video of all the talks. This has lots of good material and for free. Scroll down to the bottom of the page to find the links to the videos.
This morning was my last day of Oracle OpenWorld sessions and this afternoon and evening finished off my day with Delphix Sync.
The first talk was my only NoSQL talk. It was interesting because the claim was that NoSQL was good for large numbers of simple transactions. This seems to be a theme across a couple of sessions. The funny thing is that the NoSQL code reminded me of my pre-SQL mainframe Datacom DB database (more...)
Well, it was a long day but it ended in a fun way.
Today I was back to the normal OpenWorld sessions starting with the general session. It was eye-opening because the speakers described a new CPU chip that they were using in their latest servers. It had some custom elements to support database processing. It was strange because I have recently been studying the latest Intel x86 documentation and it was interesting to compare (more...)
Instead of going to the normal OpenWorld events today I went to OakTable World. Now my brain is fried from information overload.
It started at 8 am with a nice talk about hash joins and Bloom filters. Toon Koppelaars had some nice moving graphics showing how bloom filters work. I’ve studied Bloom filters before but I’m not sure I understood it with the clarity that I had after this talk.
Then I did my talk (more...)
It was a good first full day at Oracle OpenWorld. It started with the keynote led by Oracle’s CEO. Of course he was very upbeat about Oracle’s products. But, I found his comments about the economy and the way it affects IT spending more interesting than Oracle’s cloud products. My translation is that companies have a lot of older systems that they can’t easily retire or upgrade but they want to quickly add all this new (more...)
I just finished reviewing my Delphix blog posts in preparation for the talks that I will give during OpenWorld. I find myself referring back to my blog to help me remember what I have done in the past. I was thinking that I needed to jog my memory so that I could answer questions when I give my talks. Some of the Delphix topics that I am speaking about occurred a year or two ago so my memories (more...)
Here is a YouTube video of a short Toastmasters talk of mine about a DBA topic. It was probably too technical for the audience but may interest the readers of this blog.
Here was a post about a similar topic:
It is official. I will be doing my Delphix presentation at Oaktable World during the Oracle OpenWorld conference at the end of this month. My talk is at 9 am on Tuesday, October 27.
I will describe our journey as a new Delphix customer with its ups and downs. I tried to have the spirit of a user group talk where you get a real person’s experience that you might not get from a more (more...)