Dicas com Comandos SQL

Algumas dicas com comandos SQL para checar o tempo dos backups da Logical Logs.

1. Tempo de backup da logical log

DATABASE sysutils;

SELECT a.obj_name::VARCHAR(10) AS logfile,
b.act_start, b.act_end,
(b.act_end - b.act_start)::INTERVAL SECOND(9) TO SECOND AS time_sec
FROM bar_object a, bar_action b
WHERE a.obj_oid = b.act_oid
AND a.obj_type = 'L'
ORDER BY 1 ASC;