How one can export statistics

To export statistics in Oracle, you need to use the DBMS_STATS package deal. This package deal offers a number of procedures and features for managing database statistics. Listed below are the essential steps: (1) Connect with your database as a person with the required privileges (corresponding to SYS or SYSTEM). (2) create a stat desk to carry the statistics EXEC DBMS_STATS.CREATE_STAT_TABLE(‘SCOTT’,’STATTAB’); […]

The publish How one can export statistics appeared first on Techgoeasy.

Supply hyperlink