Tuesday, November 10, 2020

Date formatting in PostgreSQL

›
select action_type, to_char(action_date,'DD Mon YYYY'), count(*) from actions group by action_type, action_type | to_char...
Thursday, November 5, 2020

How to change the control_files parameter used in the spfile

›
Mind your syntax when you are changing certain multi-value parameters directly in the spfile. Oracle will tell you that the syntax is accep...
Wednesday, October 21, 2020

How to transfer SQL Profiles from one database to another

›
Following up from part 1 on my post on How to transfer SQL Plan Baselines from one database to another , I will now show you the steps to ...

How to transfer SQL Plan baselines from one database to another

›
A customer called with a request to transfer a specific SQL plan from production to test. The query was found in the shared pool: SELECT T...
Thursday, October 15, 2020

How to select a specific line number using awk

›
The file clonetext.txt contains: Clone Volume: true Clone Parent server Name: myserver1-cluster49 ...
Monday, October 12, 2020

Different ways to check your path variable on a windows client

›
Check the windows registry entry for the value of the PATH variable: Open your regedit application by going to your windows menu and star...
Thursday, September 3, 2020

Potential solution to dgmgrl error ORA-16665: time out waiting for the result from a member

›
After having added a terminal standby database to an existing configuration, the Data Guard Broker configuration seemed unhappy with commu...