Bjr;

J'ai un select un peu bizarre :

select SNAP_ID, END_INTERVAL_TIME, SNAP_LEVEL
from DBA_HIST_SNAPSHOT
where STARTUP_TIME > systimestamp - 1/24
order by snap_id;

=> aucune ligne sélectionnée

Si je fais :

select SNAP_ID, END_INTERVAL_TIME, SNAP_LEVEL
from DBA_HIST_SNAPSHOT order by snap_id;

IL y'a bien des snapshot courant (du jour) :

1764 20/02/09 00:00:50,365 1
1767 20/02/09 02:00:38,345 1
1768 20/02/09 04:00:02,714 1
1769 20/02/09 05:00:24,690 1
1770 20/02/09 06:00:58,407 1
1771 20/02/09 07:00:02,379 1
1772 20/02/09 08:00:15,272 1
1773 20/02/09 09:00:25,212 1
1774 20/02/09 09:18:37,485 1
1775 20/02/09 10:00:47,104 1
1776 20/02/09 10:05:00,835 1

?????