pl/sql

Hi ,

Below code is returning each snapshot for 15 minutes as it is set in database but I would like to take hourly so how to skip and use snapshot for hourly awr.

What portion and how to modify?

set feedback off

set echo off

set verify off

set timing off

-- Set AWR_FORMAT to "text" or "html"

define AWR_FORMAT = 'html'

define DEFAULT_OUTPUT_FILENAME = 'awr-generate.sql'

define NO_ADDM = 0

-- Get values for dbid and inst_num before calling awrinput.sql

set echo off heading on

column inst_num heading "Inst Num" new_value inst_num format 99999;

column inst_name heading "Instance" new_value inst_name format a12;