Monday, 1 April 2019

Backup Oracle Database Stats

Backup Database stats:-

a)Create the STATS table only one time.
EXEC DBMS_STATS.CREATE_STAT_TABLE(ownname=> 'SYS',stattab=>'DB_NAME_STATS');

b) Export the full database stats as below.
exec dbms_stats.EXPORT_DATABASE_STATS(STATTAB=>'DB_NAME_STATS',statid=>'DB_NAME_STATS_2SDATE',STATOWN=>'SYS');


Please change the above steps as per requirement.

How to login on Oracle Cloud Console?

Login Steps for Oracle Cloud Console To sign in to Oracle Cloud Console, We need to open up the corresponding region console URL for Free Ti...