Database Administrator

When to Rebuild an Index? It is important to periodically examine your indexes to determine if they have become skewed and might need to be ...

Reuse statements select * from emp where ename = :EMPNAME select * from v$parameter where name like '%cursor_sharing%'; cursor_shari...

Oracle Flushing-Pinning PL/SQL packages, FLUSH SHARED POOL http://www.remote-dba.cc/oracle_tips_flushing_secrets.htm 1. Pinning all com...