Common SQL for Oracle---(1)AWR Generator
AWR Generator-------------
-- query snapid
SELECT dbid,
instance_number,
MIN (snap_id) begin_snap_id,
MAX (snap_id) end_snap_id
FROM dba_hist_snapshot
WHERE end_interval_time >=
to_date('2014/06/29 07:00:00', 'yyyy/mm/dd hh24:mi:ss')
and end_interval_time
页:
[1]