TwoCoast Consulting - TCAgent Tasks

TwoCoast >> TCSupportCenter >> TCAgent >> Task List

Database Monitor Tasks

TCAgent's database monitor tasks monitor the health of your managed databases. These tasks transmit detailed alerts to TCSupportWeb when a problem is detected or resource usage exceeds a configurable threshold.

ActiveSessionMonitor	The ActiveSessionMonitor generates an alert when the number of active Oracle sessions exceeds a configurable threshold over the course of multiple samples.
AlertLogMonitor	The AlertLogMonitor parses Oracle alert log files and generates alerts when errors are found. The type of alert generated is determined by comparing the error to a configurable set of patterns (regular expressions).
CPUMonitor	The CPUMonitor generates an alert when it detects a session using more than a configurable percentage of available CPU resources.
DBCheck	The DBCheck task verifies that a database is running and accepting new connections. DBCheck also sends at regular intervals heartbeat messages to TCSupportWeb. An internal TCSupportWeb monitor makes sure that heartbeats are received for all managed databases.
LatchMonitor	The LatchMonitor monitors the database for excessive latch sleep activity. An alert is generated when latch sleep activity exceeds a configurable threshold.
LockMonitor	The LockMonitor monitors the database for blocking locks. TCAgent generates an alert when an identical blocking lock is detected during two consecutive task executions.
LongSQLMonitor	The LongSqlMonitor monitors the database for active sessions executing sql statements whose execution time exceeds a configurable threshold.
MemoryMonitor	The MemoryMonitor monitors the database for sessions using more than a configurable percentage of available memory.
RedoMonitor	The RedoMonitor monitors the database for spikes in redo activity.
RowCountMonitor	The RowCountMonitor generates an alert when the result from a query returning a count is above, below, or equal to a configurable value. This task is useful, among other things, for monitoring materialized view logs.
SessionWaitMonitor	The SessionWaitMonitor monitors the V$SESSION_WAIT view and generates an alert when the number of session waits detected during multiple samples exceeds one or more thresholds.
SharedPoolMonitor	The SharedPoolMonitor task monitors the V$SHARED_POOL_RESERVED view for increasing values in the REQUEST_FAILURES column, indicating an Oracle ORA-04031 error (unable to allocate shared memory). An alert is sent when this error is detected.
StorageMonitor	The StorageMonitor task monitors the database for conditions that would prevent a segment from taking its next extent, due to lack of space in the tablespace or exceeding a MAX_EXTENTS limit. The StorageMonitor task also monitors tablespace storage utilization and can be configured to send an alert when utilization exceeds a threshold.
ThresholdMonitor	The ThresholdMonitor generates an alert when an internal Oracle resource reaches a configurable percentage of the maximum value allowed, as defined by the Oracle initialization parameters. The monitored resources are processes, DML locks and open cursors.

Database Report Tasks

TCAgent's database report tasks collect and transmit to TCSupportWeb a wide variety of useful information about the configuration, structure and performance of your managed databases. This information is used to document your database environment and is analyzed to identify performance issues and growth trends. Important: No proprietary or sensitive information, like table data, source code, or the data model is ever collected.

ControlFileReport	The ControlFileReport task gathers information about control files used by the monitored database.
CoreStatsReport	The CoreStatsReport task gathers a variety of Oracle performance metrics, used in TCSupportWeb to monitor performance trends and to populate charts viewable on the TCSupportWeb web site.
DatabaseInfoReport	The DatabaseInfoReport task transmits a document to TCSupportWeb containing the contents of the V$DATABASE and V$INSTANCE views.
DatafileReport	The DatafileReport task transmits a document to TCSupportWeb containing information about datafiles owned by the datababase.
FilestatsReport	The FilestatsReport gathers performance and usage statistics from the V$FILESTAT view and transmits the data to TCSupportWeb where it is used to monitor performance trends and populate charts viewable on the TCSupportWeb web site.
ParameterReport	The ParameterReport task transmits a document to TCSupportWeb containing the contents of the V$PARAMETER view.
RedoLogReport	The RedoLogReport task transmits a document to TCSupportWeb containing information about the database’s redo logs.
RollbackSegmentReport	The RollbackSegmentReport task transmits a document to TCSupportWeb containing information about the rollback segments used by the monitored database.
SGAStatsReport	The SGAStatsReport task transmits a document to TCSupportWeb containing the contents of the V$SGA and V$SGASTAT views.
SysStatReport	The SysStatReport task transmits a document to TCSupportWeb containing the current contents of the V$SYSSTAT view.
SystemEventReport	The SystemEventReport task transmits a document to TCSupportWeb containing the current contents of the v$system_event view.
TablespaceReport	The TablespaceReport task transmits a document to TCSupportCenter containing information about the tablespaces owned by datababase.

Database Utility Tasks

TCAgent's database utility tasks perform hot backups, exports, and analyze tables and indexes.

Analyze	The Analyze task analyzes Oracle segments (tables and indexes). The task is highly configurable, offering multiple levels of granularity when selecting segments; separate analyze parameters may be specified for collections of segments.
Export	The Export task provides an easy and flexible way to automate Oracle export jobs. An alert is generated if any errors occur during the export. Upon successful completion of the task, an informational alert is generated containing export log messages.
HotBackup	The HotBackup task executes on-line backups of Oracle databases. The task may be configured to include additional (non-datafile) files in the backup. An alert is generated if any errors occur during the backup. Upon successful completion of the task, an informational alert is generated containing backup log messages.

Server Monitor Tasks

TCAgent's server monitor tasks monitor the database server environment for errors and space utilization.

FileSystemStorageMonitor	The FileSystemStorageMonitor monitors free space on file systems. An alert is generated when the amount of free space falls below a configurable threshold.
LogMonitor	The LogMonitor monitors log files on the local file system and generates an alert when errors are found. Errors are detected by matching the contents of the log file against a configurable set of patterns (regular expressions).

Server Utility Tasks

TCAgent's server utility tasks execute basic maintenance jobs on the database server.

FileCleaner	The FileCleaner task deletes files from the local file system. Files are selected for deletion based on location, name and age. This task is typically used to delete old Oracle archived redo log files.
FileCompressor	The FileCleaner task compresses files on the local file system. Files are selected for compression based on location, name and age. This task is typically used to compress Oracle archived redo log files.