In the previous installment of this series we looked at four reasons from gv$sql_shared_cursor view and explained the situations and criteria for which Oracle is forced to compile a new execution plan...
Recommendations Create a minimum of three groups with two log files each. A minimum of two groups of log files each are required for each Oracle instance (even in a parallel instance environment.)
I...
Recently, a DB2 for z/OS professional I’ve known for some years sent to me a question about the relationship between the PGSTEAL and PGFIX options of the DB2 command -ALTER BUFFERPOOL. It took a few i...
