Before you can increase memory in oracle database, you must first understand four oracle memory parameters which govern the instance. SGA_TARGET and SGA_MAX_SIZE MEMORY_TARGET and…
View More How to Increase MEMORY_TARGET
Month: March 2023
PostgreSQL “bind variable peeking”
custom vs. generic plans With my Oracle database background, I know how important it is to balance the pros and cons of using bind variables…
View More PostgreSQL “bind variable peeking”
Postgresql PREPARE — prepare a statement for execution
Synopsis PREPARE name [ ( data_type [, …] ) ] AS statement Description PREPARE creates a prepared statement. A prepared statement is a server-side object that…
View More Postgresql PREPARE — prepare a statement for execution
Adaptive Cursor Sharing in Oracle Database 11g Release 1
DBAs are always encouraging developers to use bind variables, but when bind variables are used against columns containing skewed data they sometimes lead to less…
View More Adaptive Cursor Sharing in Oracle Database 11g Release 1
Partition an existing table on PostgreSQL
Release after release PostgreSQL is better and better on table partitioning, if you do run a version12 or 13 today you must have a look…
View More Partition an existing table on PostgreSQL
Partitioning in Postgres, 2022 edition
Partitioned tables aren’t an everyday go to, but are invaluable in some cases, particularly when you have a high volume table that’s expected to keep…
View More Partitioning in Postgres, 2022 edition