It should be: SELECT first_time, first_time - LAG(first_time) OVER (ORDER BY first_time) "SECONDS" FROM v$log_history; Regards, Zoran __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- //www.freelists.org/webpage/oracle-l