Statistics played in key role for Oracle performance tuning. Oracle Optimizer creates the execution plan based on the statistics of the oracle table involved in the SQL queries. You may want to lock statistics in a oracle table in some cases, for example you don’t want a table to be analyzed by schedule statistics job […]
Techgoeasy
Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts