stats gather on database


How to check stats  gather with  date  & Time


select OWNER,TABLE_NAME,to_char(LAST_ANALYZED,'DD-MON-YY HH:MI:SS AM') from dba_tables where OWNER='PROD_OLAP'
 and LAST_ANALYZED NOT Like  '%18-FEB-19%'
 and LAST_ANALYZED NOT Like '%17-FEB-19%'



SELECT pname, pval1 FROM sys.aux_stats$ WHERE sname = 'SYSSTATS_MAIN';

EXEC DBMS_STATS.gather_system_stats;


Manually start and stop to sample a representative time (several hours) of system activity.


EXEC DBMS_STATS.gather_system_stats('start');
EXEC DBMS_STATS.gather_system_stats('stop');

-- Sample from now until a specific number of minutes.
DBMS_STATS.gather_system_stats('interval', interval => 180);



Comments

Popular posts from this blog

How to check OS inventory