I well remember the first time I saw it. August, 2016. I was looking at output from the DB2 for z/OS command -DISPLAY BUFFERPOOL(ACTIVE) DETAIL, issued on a DB2 11 system, that a client had sent to me for review. I appreciated the fact that I could see in this command output information about DB2’s use of large real storage page frames for page-fixed buffer pools (in a DB2 10 environment, one had to issue -DISPLAY BUFFERPOOL — for an individual pool, versus for all active pools — with an odd …read more
Related Articles
Solving Problem Partitioning SQL Using PL/SQL
Hi, This article is more of the rest of the story from March’s Lucky Breaks. (Click here to see the first blog). I want to share my successes in using PL/SQL to solve a rather common performance iss...
12cR1 RMAN Restore/Duplicate from ASM to Non ASM takes a longer time...
Yet another exciting journey with Oracle bugs and challenges. Here is the story for you. One of our recent successful migrations was a single instance Oracle EBS 12cR1 database to Oracle Super Cluster...
What’s New in Toad Data Point 4.3
We are happy to announce that Toad Data Point 4.3 is now available! The primary focus of this release has been reworking our Pivot Grid functionality. The new, improved Pivot Grid in Toad Data Poi...
