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
Post a Comment