eMarcel.com

Oracle Database, Fusion Middleware, Linux

partition

DBMS_STATS in an Oracle Database

DBMS_STATS in an Oracle Database Using DBMS_STATS package to gather Oracle dictionary statistics. 1. To gather table statistics with DBMS_STATS SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(ownname =>’HR’, tabname =>’EMP’) 2. To gather table statistics with DBMS_STATS with estimate percent SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(ownname => ‘HR’, tabname => ‘EMP’, estimate_percent =>50); SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(‘HR’, estimate_percent =>50); 3. To gather a […]

, ,

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close