Re: date:time of execution

Posted by big on Feb 27, 2024; 1:55pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/date-time-of-execution-tp12337p12342.html

Yes I read document 1371778.1 and was inspired from
And I ran:
select STARTUP_TIME from DBA_HIST_SNAPSHOT where snap_id in (select  snap_id
from dba_hist_sqlstat
where sql_id = 'sql_id' );

But I was wrong and I should use BEGIN_INTERVAL_TIME to the END_INTERVAL_TIME as it is mentionned instead of STARTUP_TIME.


Thanks and regards.