V$SQL

How to Resolve ORA-02030: can only select from fixed tables/views

by Ed Chen
March 30, 2022April 9, 2022

ORA-02030 Tried to grant SELECT object privilege to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant select on… Read More »

SQL Bind Variables, How and Why

by Ed Chen
January 24, 2019December 10, 2022

Bind Variables Shareable Cursor Using bind variables can make statements with minor differences become literally the same so as to share the same cursor when… 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 »