Wednesday, February 23, 2022

How to fix the pending_dst_session error when running the preupgrade script

›
If you receive an error during the precheck-phase of an upgrade from 18c to 19c, which points to "pending_dst_sessions", like thi...

When explaining a query that is accessing a partitioned table, what does the Pstart=KEY or Pstop=KEY indicate?

›
The Pstart=KEY or Pstop=KEY indicate that the exact partition cannot be determined at compile time, but will most likely be found during r...
Thursday, February 3, 2022

Observation: rman saves files according to end date of backup

›
I noticed the following: An archivelog file backed up at 1.01.2022 23:57:18 will NOT be saved in the folder for 31.01.2022. Instead, it wi...
Monday, January 31, 2022

Simple SQL to list

›
The following SQL lists the indexes defined on a table, along with the columns and their positioning: SELECT I.INDEX_NAME,I.INDEX_TYPE,I.N...
Wednesday, January 5, 2022

How to set a dynamic parameter in a postgreSQL database cluster

›
As with oracle, some parameters may be set dynamically in a postgreSQL database cluster. A postgreSQL database cluster uses a parameter f...

How to find out if a hot standby postgres database is receiving logs

›
select pg_is_in_recovery(); pg_is_in_recovery ------------------- t (1 row) https://www.postgresql.org/docs/11/functions-admin.html#F...
Wednesday, December 22, 2021

What is the difference between "force parallel" and "enable parallel" used in the "alter session" statement in Oracle?

›
What is the difference between these two statements? ALTER SESSION ENABLE PARALLEL DML | DDL | QUERY; and ALTER SESSION FORCE PARALLEL ...