Month: March 2021

SQL Patch another example

In a post I wrote last year about SQL Patch, I only showed how to use SQL Patch to influence the execution plan of a query with hint injection which disables the existing hardcoded hint. Here I am going to use another example to show how to add a new hint. With Oracle 19c, create_sql_patch … Continue reading SQL Patch another example →

Advertisement

oratop – a handy tool to monitor database in real-time

If you have been using Unix or Linux for a while, you are likely familiar with the command "top" which dynamically shows the system overall activities in real-time. When looking at the database monitoring, you might have your favorite tools -- EM, ADDM, ASH, AWR etc. or even your home grown tools. Starting from Oracle … Continue reading oratop – a handy tool to monitor database in real-time →

ORA-16649: possible failover to another database prevents this database from being opened

We have a newly upgraded 19c primary database which was in ODG configuration. We didn't use the ODG rolling upgrade, but just built the new server and restored/recovered database on it. So the standby was still on old 12c database and we were planning to do it in a week. The application using the database … Continue reading ORA-16649: possible failover to another database prevents this database from being opened →

ORA-01795 — PARSE ERROR: ospid=17974, error=1795 for statement

After an application upgraded over the weekend and we have started to see the following errors in the alert log: WARNING: too many parse errors, count=3593 SQL hash=0x8b6dc8e6 PARSE ERROR: ospid=17974, error=1795 for statement: 2021-02-08T07:37:28.836962-06:00 select * from ( select cust.pk as pk1_431_, cust.name_id as name_i2_431_, cust.cust_id as name_u3_431_, cust.cust_id_type as name_u4_431_ from customer cust … Continue reading ORA-01795 — PARSE ERROR: ospid=17974, error=1795 for statement →