# DCperf.cfg: Collects Performance Information
# $Id: DCperf.cfg,v 1.8 2014/11/21 16:53:20 RDA Exp $
# ARCS: $Header: /home/cvs/cvs/RDA_8/src/scripting/lib/collect/OS/DCperf.cfg,v 1.8 2014/11/21 16:53:20 RDA Exp $
#
# Copyright (c) 2002, 2016, Oracle and/or its affiliates. All rights reserved.
#
# Change history
# 20141121  KRA  Include B_PS setting.

###############################################################################
# Collect the performance data setup information
###############################################################################

#------------------------------------------------------------------------------
# Module definition
#------------------------------------------------------------------------------
col=${B_REQUESTED}
dsc='Collects Performance Information'
frk=1
pre=RDA:DCbegin
var=is_forced

#------------------------------------------------------------------------------
# Setting definitions
#------------------------------------------------------------------------------
[is_forced]
typ=B
dft=${PRF.B_TESTS}
dsc='Are the performance tests required by the profile?'
nam=-
var=true:set_requested:\
    false:B_REQUESTED

[set_requested]
typ=B
dft=true
dsc='Gather performance data?'
nam=B_REQUESTED
var=R_FACTOR,B_LSOF,B_PS,B_PSTREE,N_SAR_DATA,do_sysrq,N_TOP_PS,N_TOP_ROOT,\
    db_perf

[B_REQUESTED]
typ=B
dft=true
dsc='Gather performance data?'
inp='Do you want RDA to collect performance data (Y/N)?'
var=true:R_FACTOR,B_LSOF,B_PS,B_PSTREE,N_SAR_DATA,do_sysrq,N_TOP_PS,N_TOP_ROOT,\
         db_perf
lvl=6

[R_FACTOR]
typ=N
dft=1
dsc='Factor to apply to the SQL timeout in the PERF module'
err='The timeout factor must be a positive number'
inp='Enter the factor to apply to the SQL timeout in the PERF module'
lvl=6
ref='R[0,['
val=F

[B_LSOF]
typ=B
dft=false
dsc='List open files?'
fam=Unix
inp='Are open files to be listed (Y/N)?'
lvl=6

[B_PS]
typ=B
dft=false
dsc='Gather process information?'
fam=Unix
inp='Is the process information to be gathered (Y/N)?'
lvl=6

[B_PSTREE]
typ=B
dft=false
dsc='Gather process tree?'
fam=Unix
inp='Is the process tree to be gathered (Y/N)?'
lvl=6

[N_SAR_DATA]
typ=N
dft=0
dsc='Number of sar files to be gathered'
err='The number of files must be a positive integer'
fam=Unix
inp='Enter the number of sar files to gather'
lvl=6
ref='I[0,['
val=F

[do_sysrq]
typ=B
dft=${OS.linux}
dsc='Does this platform support SysRq commands?'
nam=-
var=true:W_SYSRQ,check_sysrq

[W_SYSRQ]
typ=M
aft="\nSome SysRq commands can add a significant system load, that is, \
     enough to disrupt normal operations. Run the SysRq commands only after \
     Oracle has advised you to do so.\n"
bef='Which SysRq commands can be executed when the data collection is done as \
     root:'
dft='0'
dsc='Collection selection'
err='Enter a number from 1 to 3'
inp='Enter the menu item number'
itm=(1,'sysrq-trigger -m and sysrq-trigger -w only',\
     2,'sysrq-trigger -t, sysrq-trigger -m, and sysrq-trigger -w',\
     3,'No SysRq commands')
lvl=6
mnu='<<N'
rsp=(1,'MW',2,'TMW',3,'0')
val=F

[check_sysrq]
typ=B
dft=match(${W_SYSRQ},'T')
dsc='Is a sleep setting required?'
nam=-
var=true:N_SYSRQ_SLEEP

[N_SYSRQ_SLEEP]
typ=N
dft=30
dsc="Sleep time after a 'sysrq-trigger -t' command'"  # stopwords sysrq
err='The number of seconds must to be an integer greater than zero'
inp="Enter the time (in seconds) to sleep after executing 'sysrq-trigger -t'"
lvl=6
ref='I]0,['
val=E

[N_TOP_PS]
typ=N
dft=15
dsc='Number of top processes to report'
err='The number of processes must be an integer greater than zero'
inp='Enter the number of top processes to report'
lvl=6
ref='I]0,['
val=F

[N_TOP_ROOT]
typ=N
dft=5
dsc='Number of top root processes to report'
err='The number of processes must be an integer greater than zero'
inp='Enter the number of top root processes to report'
lvl=6
ref='I]0,['
val=F

[db_perf]
typ=B
dft=${PRF.B_DB:${SET.DB.DB.B_LOCAL/P}}
dsc="Are the ADDM, AWR, ASH, or STATSPACK required by the profile?"
nam=-
var=true:awr_check

[awr_check]
typ=F
alt=statspack_check
dft=(catFile(${SET.DB.DB.D_ORACLE_HOME/P},'rdbms','admin','addmrpti.sql'),\
     catFile(${SET.DB.DB.D_ORACLE_HOME/P},'rdbms','admin','awrrpti.sql'),\
     catFile(${SET.DB.DB.D_ORACLE_HOME/P},'rdbms','admin','ashrpti.sql'))
nam=-
var=B_AWR_USE

[B_AWR_USE]
typ=B
dft=true
dsc='Can ADDM, AWR, and ASH be used?'
inp='Can ADDM, AWR, and ASH be used (Y/N)?'
var=true:T_START_TIME,check_start_time:\
    false:statspack_check

[statspack_check]
typ=F
dft=catFile(${SET.DB.DB.D_ORACLE_HOME/P},'rdbms','admin','spreport.sql')
nam=-
var=T_STATSPACK_USER,check_statuser

[T_STATSPACK_USER]
typ=T
clr='-'
dft=''
dsc='User in which Statspack package has been installed'
inp='Enter an Oracle User ID (user name only) which has Statspack installed'
ref='^([A-Za-z0-9][\w\$\#]{0,127})?$'
err="The user name should begin with an alphanumeric character and can have \
     only alphanumeric characters, '_', '$', or '#' thereafter. It can be \
     only 128 characters long."
val=E

[check_statuser]
typ=B
dft=match(${T_STATSPACK_USER},'^[A-Za-z0-9][\w\$\#]{0,127}$')
dsc='Check if the start time must be specified'
nam=-
var=true:T_START_TIME,check_start_time:\
    false:no_start_time,no_end_time

[no_start_time]
typ=T
dft=''
dsc='Start time for generation of the performance reports'
nam=T_START_TIME

[T_START_TIME]
typ=T
clr='-'
dft=''
dsc='Start time for generation of the performance reports'
err='Start time format should be DD-Mon-YYYY_HH24:MI'
hlp='If you want to generate the performance reports for a specific time \
     interval, enter the start and end times. Otherwise, RDA uses a default \
     time interval around the current time.'
inp="Enter the time, when you want to start the collection of the performance \
     reports. When a dash (${AUX.clr}) is specified as input, current time is \
     considered. Start time should be in DD-Mon-YYYY_HH24:MI format."
lvl=6
ref='^([0-3]\d\-[A-Za-z]{3}\-[1-2]\d{3}_[0-2]\d:[0-5]\d)?$'
val=E

[check_start_time]
typ=B
dft=match(${T_START_TIME},'^[0-3]\d\-[A-Za-z]{3}\-[1-2]\d{3}_[0-2]\d:[0-5]\d$')
dsc='Check if the end time must be specified'
nam=-
var=true:T_END_TIME:\
    false:no_end_time

[no_end_time]
typ=T
dft=''
dsc='End time for generation of the performance reports'
nam=T_END_TIME

[T_END_TIME]
typ=T
clr='-'
dft=''
dsc='End time for generation of the performance reports'
err='End time format should be DD-Mon-YYYY_HH24:MI'
inp="Enter the time, when you want to end the collection of the performance \
     reports. When a dash (${AUX.clr}) is specified as input, current time is \
     taken as end time. End time should be in DD-Mon-YYYY_HH24:MI format."
lvl=6
ref='^([0-3]\d\-[A-Za-z]{3}\-[1-2]\d{3}_[0-2]\d:[0-5]\d)?$'
val=E