SQL Developer Explain Plan
For those who don't have GUI tools like SQL developer or Enterprise Manager, you can still get an explain plan for a statement in SQL*Plus.… Read More »SQL Developer Explain Plan
Cost-Based Optimizer
How to Resolve PRVG-1359 : Daemon process "avahi-daemon" is configured on node
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 Resolve PRVG-1359 : Daemon process "avahi-daemon" is configured on node
How to Improve SQL Performance
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 Improve SQL Performance
How to Find Most Expensive SQL
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 »How to Find Most Expensive SQL