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
Spotlight on Oracle – Tuning Your Database
Tuning Your Database Spotlight on Oracle supports an approach to Oracle performance tuning that could be described as "tuning by bottleneck". Spotlight on Oracle alerts you if any component of the ...
How does Oracle reuse expired and unexpired undo extents?
A frequent question that I have received from many DBAs is: my undo tablespace is almost full, how can I be sure that the space will be reused? Well, First you have to know that there are two kind of...
