Cost-Based Optimizer

How to Resolve PRVG-1359 : Daemon process "avahi-daemon" is configured on node

by Ed Chen
April 10, 2021December 7, 2021

PRVG-1359 and PRVG-1360 Found errors PRVG-1359 and PRVG-1360 during pre-installation of Oracle RAC database 19c: [grid@primary01 grid]$ ./runcluvfy.sh stage -pre crsinst -n primary01,primary02 -verbose ...… Read More »

How to Improve SQL Performance

by Ed Chen
March 3, 2018November 14, 2021

SQL statements including queries and DML sometimes execute with the different index because of the following reasons: Missing index The target index might be dropped… Read More »

How to Find Most Expensive SQL

by Ed Chen
October 15, 2012May 4, 2019

With a demanding database, you may want to know how to find out the most expensive sqls. Running on Oracle, we have Cost-Based Optimizer, the… Read More »