Understanding CPU on AIX Power SMT Systems. This month I worked with a chicagoland company to improve performance for eBusiness Suite on AIX. Nevertheless, I got thrown for a loop this week. In the end, it came down to a fundamental change in resource accounting that IBM introduced with the POWER7 processor in 2010. Time that the process spent on the CPU.

The PeopleSoft stuff is at blog. This is the non-PeopleSoft Oracle Blog. Monday, March 05, 2018. The changing literal values mean that every SQL statement has a different SQL ID. SQL Baselines are not viable here. No one plan produces optimal performance, so a traditional SQL profile proscribing a particular plan is not the answer. Oracle moves between three adaptive plans depending at least partially upon the number of rows in the elimination table. I found it was .

As last year, this year is also expected to be busy. I plan to attend to all of the conferences listed.

Ultimate List of APEX Links and Shortcuts. A quick browse of the Beta APEX 18. Noticed a few additions, one one omission.

Views are good as they can be used to hide complexity. Views are bad as they can hide complexity.

Streaming Videos with Plex on Raspberry Pi. The recent Bank Holiday weekend in England provided me with a perfect opportunity to get on with some D. Time, once again, to call on my trusty Raspberry Pi 2 b-spec.

I specialise in business and technical consulting focused primarily on using Oracle and Big Data technologies in the BI, Data Warehousing and Analytics space. Over twenty years experience with the Oracle product stack. Data Warehousing, BI and Big Data Support. From architecting to development and everything in between. Consistently adding value to clients worldwide. I have over two decades of business and technical consulting.

There was an oracle-l thread. Last month about blocking sessions which could not be identified.

SQL Performance, Part IV. SQL performance, Part III. How should you approach this e.