Configure the Resource Monitor Using staresmonadm

Use the staresmonadm utility to configure the resource monitor (Resmon).

Prerequisites

The Services Daemon must be running to use staresmonadm.

See Services Daemon - Stop, Restart, or Show Status.
The Oracle user path must be correctly configured.

See Configure the Correct Oracle User Path.

Parameters

The staresmonadm utility uses the parameters listed in the table below. To enable, you must specify all required parameters. You can submit as many parameters as you want in each staresmonadm command line. The utility only updates the parameters you specify. The unspecified parameters remain at their current value.

Some settings (denoted by * in the table) require you to stop and restart the Services Daemon if you want the setting to take effect immediately. Otherwise these changes take effect as soon as the backup service wakes from its current sleep interval. See Services Daemon - Stop, Restart, or Show Status.

A value of "-1" indicates the parameter is not configured.

Table 4-2 staresmonadm Parameters

Name	Parameter	Description	Default Value
Query	`-Q, --query`	Display the current Resmon settings.	None
Clear	`-C, --clear`	Clear all Resmon settings and disable the service.	None
Verbose	-`v, --verbose`	Enables verbose mode, which displays detailed progress information for the command.	None
Help	`-h, --help`	Displays complete syntax information for the command.	None
Daily report time (required)	`-T, --time`	Time of day Resmon sends the Resource Report. Format is `hh:mm`, using 24-hour time. The report is sent automatically every 24 hours at approximately this time. The actual time is immediately after the first server scan performed after this time.	00:00
Scan Interval* (required)	`-i, --interval`	Time in seconds Resmon waits between scans. Valid entries: integers greater than 0.	300
Alert nagging*	`-n, --nag`	Indicates whether Resmon sends alerts if it finds that any high-water marks have been reached. Valid entries: `on\|off, yes\|no, true\|false, 1\|0`. When enabled, Resmon sends alert reports whenever it performs a periodic scan and detects a resource has exceeded its high-water mark (as opposed to just sending during the daily report).	off
Database username* (required)	`-U, --dbusr`	Database username that the Resmon service uses to perform queries against the `information_schema` tables and the MySQL server internal system global variables. This must be a user with full access to the STA database, either the STA database root user or the STA database administrator.	blank
Database password* (required)	`-P, --dbpwd`	Password assigned to the database username.	blank
Database tablespace HWM* (required)	`-t, --tblsphwm`	High-water mark for the database tablespace, entered as a percentage of the total allocated. Valid entries: integers 0–100 Oracle recommends that usage never exceeds 80 percent.	-1
Local backup HWM* (required)	`-b, --backvolhwm`	High-water mark for the STA database local backups volume (for example, `/dbbackup`), entered as a percentage of the total allocated. Valid entries: integers 0 –100 Oracle recommends that usage never exceeds 80 percent.	-1
Database disk volume HWM* (required)	`-d, --dbvolhwm`	High-water mark for the STA database volume (for example, `/dbdata/mysql` ), entered as a percentage of the total allocated. Valid entries: integers 0 –100 Oracle recommends that usage never exceeds 80 percent.	`-1`
Logging disk volume HWM* (required)	`-l, --logvolhwm`	High-water mark for the STA database logs volume (default is `/var/log/tbi`), entered as a percentage of the total allocated. Valid entries: integers 0 –100 Oracle recommends that usage never exceeds 80 percent.	`-1`
Root volume HWM* (required)	`-z, --rootvolhwm`	High-water mark for the root volume (`/`), entered as a percentage of the total allocated. Valid entries: integers 0 –100 Oracle recommends that usage never exceeds 80 percent.	`-1`
Tmp volume HWM* (required)	`-x, --tmpvolhwm`	High-water mark for the temporary directory volume (default is `/tmp`), entered as a percentage of the total allocated. Valid entries: integers 0 –100 Oracle recommends that usage never exceeds 80 percent.	`-1`
Physical memory (RAM) HWM*	`-m, --memhwm`	High-water mark for the total system memory (except virtual memory), entered as a percentage of the total allocated. Valid entries: integers 0 –100 Oracle recommends that usage never exceeds 80 percent.	`-1`
Email from*	`-f, --from`	Name or email address that appears in the "From" field of emails sent by the Resmon service.	`StaResMon@localhost`
Email recipients* (required)	`-r, --recips`	Email addresses to which Resmon sends the daily Resource Report and periodic Resource Depletion Alert Report. Entered as a colon-delimited list (such as .	blank
Email subject*	`-s, --subject`	Text string that appears in the "Subject" field of the standard daily report email, up to 128 characters. Enclose the text string in single-quotes (') or double-quotes (") if it contains spaces. A time stamp in `yyyy-mm-dd hh:mm:ss` form is appended to your entry when the email is sent.	STA Resource Monitor Report
Output data file	`-o, --outfile`	Absolute path of the Resource Report data file. The file name must end in `.csv`. The database user must have privileges to the directory.	`/var/log/tbi/db/staresmon.csv`