select a.owner,a.object_name,a.object_type,a.created,a.last_ddl_time,a.status,
b.osuser,b.machine,b.terminal,b.program from DBA_OBJECTS a, v$session b where (a.owner=b.username) and b.osuser=’oeripek’
and a.last_ddl_time between to_date(‘25.03.2009 00:00:00′,’dd.mm.yyyy HH24:MI:SS’) and to_date(‘25.03.2009 23:59:59′,’dd.mm.yyyy HH24:MI:SS’)
order by a.last_ddl_time desc

Reklamlar