Friday, February 28, 2014

Oracle: monitoring long tasks

SELECT start_time, username, target, sofar blocks_read, totalwork total_blocks, round(time_remaining/60) minutes FROM v$session_longops WHERE sofar <> totalwork;

Friday, February 14, 2014

PL/SQL: how to deal with nullable variables in query

where decode(column, variable, 0) is not null