Search
Related topics are listed below.
Jobs for Oracle
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle
Control Center Jobs Description Availability Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database alert log. Alert…
Adding an Oracle Instance
Using Control Center » Instance management » Adding an Oracle Instance
Oracle Prerequisites !1. Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. 2. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or…
Using SQL Performance package on Oracle
Installing and using premium packages » SQL Performance package » Using SQL Performance package on Oracle
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from…
Jobs for PostgreSQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL
Control Center Jobs Description Availability Backup check – pg_dump Checks that there exists an up to date backup file. Backup check – WAL Checks that the WAL files have been backed up. DBMS…
Jobs for MySQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. MySQL aborted connects Checking if there is many aborted connects MySQL max connections Checking if the system…
Jobs for MariaDB
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. Aborted connects alert Collects uptime statistics in the database. Maximum connections alert Collects uptime…
Jobs for Sybase
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase
Control Center Jobs Description Availability Database backup Checks backup status of all databases. Database status Checks status of all databases defined on the system. The following incidents triggers a warning or an…
Editor for engine jobs
Customization » Monitoring » Editor for engine jobs
How to get here Example jobs We have some example jobs to make the development easier here. Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new…
Blocking detector for RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Blocking detector for RAC
Name: Blocking detector for RAC Platform: Oracle Category: Cluster and Replication Description: Checks if a session is waiting on a TX (transaction) lock. (RAC only) Long description: Task checks if a session is…
Jobs for MS SQL Server
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server
Control Center Jobs Description Availability Agent Jobs Check Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution. Agent Jobs Check for MS2000 Checks whether there…
Memory session load for RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Memory session load for RAC
Name: Memory session load for RAC Platform: Oracle Category: Cluster and Replication Description: Records the load memory of RAC active sessions over time. Long description: Task records the load memory of RAC…
Alert log check (java for 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (java for 10g)
Name: Alert log check (java) Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Uses embedded java to read files. Long description: This check…
Supported Web Browsers for dbWatch Dashboard
Customization » Web server » Supported Web Browsers for dbWatch Dashboard
As of the current version, dbWatch Dashboard supports the following web browsers: Google Chrome Microsoft Edge Firefox Why These Browsers? Our focus on Google Chrome and Microsoft Edge is driven by several factors: Advanced Features and Standards These…
Configuring email extension for Service Now
Customization » Extensions and 3rd party integrations » Email and SMS » Configuring email extension for Service Now
Integration with Servicenow In this example we will configure dbWatch and Servicenow so that alarms from dbWatch, can create incidents in Servicenow. To integrate the alerts from dbWatch with Servicenow incident creation, there are two parts that needs to be setup.…
Segment size status for old style tablespaces
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Segment size status for old style tablespaces
Name: Segment size status for old style tablespaces Platform: Oracle Category: Capacity Description: Checks segment storage definitions in tablespaces where extent management is not set to local. Long…
Platforms supported
About dbWatch Control Center » Platforms supported
Platforms supported for the main product. Current release supports the following platforms, versions, and setups: On-premise support Supports* Express edition, Standard edition, Standard edition one, Standard edition two, and Enterprise edition of the following…
Alert log check (8i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (8i)
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
Availability
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Availability
Jobs in the Availability category Control Center Jobs Description Oracle Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database…
Jobs grouped by platform
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform
Go to the individual platforms to see the jobs for that database platform Jobs for Oracle Jobs for MS SQLServer Jobs for MySQL Jobs for MariaDB Jobs for PostgreSQL Jobs for Sybase ← Control Center Jobs / Jobs for Oracle →
Alert log check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
Listener log check (8i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (8i)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Database mount state
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database mount state
Name: Database mount state Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an…
Database uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database uptime
Name: Database uptime Platform: Oracle Category: Availability Description: Collects database uptime statistics for all instances mounted on the database. Long description: Collects database uptime statistics for…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-03-11) Download Important note Linux release is available as an apt repository, see Linux install guide All clients and servers need to be upgraded in a multi-server setup before the connection will resume due to network…
Index status check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Index status check
Name: Index status check Platform: Oracle Category: Availability Description: Detecting indexes in status UNUSABLE Long description: Detecting indexes in status UNUSABLE Version: 1.4 Default…
Listener status check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener status check
Name: Listener status check Platform: Oracle Category: Availability Description: Checks listener status to verify if up and running, requires java support in the database. Long description: Task checks listener…
Data Guard Archive Status Check (10g & 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Data Guard Archive Status Check (10g & 9i)
Name: Data Guard Archive Status Check Platform: Oracle Category: Availability Description: Checks that the standby database is receiving archive files from master database. Long description: Task checks that the…
Alert log check (10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (10g)
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
Alert log check (9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (9i)
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
Listener log check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check (10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (10g)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check (9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (9i)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check (11g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (11g)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Segment size collector (all segments -- aggregate 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Segment size collector (all segments -- aggregate 9i)
Name: Segment size collector (all segments — aggregate) Platform: Oracle Category: Capacity Description: Collects size and number totals on all segment types per segment-owner and tablespace_name. Long…
Password expire
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Password expire
Name: Password expire Platform: Oracle Category: Availability Description: Checks for users whose password will soon expire. Long description: Task checks for users whose password will soon…
avg function
Advanced Topics » FDL – Farm Data Language » Functions » avg function
Description Calculates the average of a set of numbers Example Find the average number of sessions for all your oracle instances avg(instance[databasetype = 'oracle']/total_session_count) avg(instance[databasetype = 'oracle']/total_session_count,…
CPU load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » CPU load
Name: CPU load Platform: Oracle Category: Performance Description: Checks CPU load using Oracle performance view v$osstat. Long description: Checks and collects CPU load statistics. The task also aggregates…
Segment size collector (all segments -- aggregate)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Segment size collector (all segments -- aggregate)
Name: Segment size collector (all segments — aggregate) Platform: Oracle Category: Capacity Description: Collects size and number totals on all segment types per segment-owner and tablespace_name. Long…
RMAN backup status (8)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (8)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Task checks the status of RMAN backup…
Max datafiles check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Max datafiles check
Name: Max datafiles check Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an…
Capacity
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Capacity
Jobs in the Capacity category Control Center Jobs Description Oracle ASM disk statistics Checks ASM disks for status and statistics. ASM diskgroup space Checks ASM diskgroups space statistics. Monitor SYS.AUD$…
Dataguard Archive Status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard Archive Status
Name: Data Guard Archive Status Platform: Oracle Category: Availability Description: Checks that the standby database is receiving archive files from master database. Long description: Task checks that the…
Cluster and replication
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Cluster and replication
Jobs in the Cluster and replication category Control Center Jobs Description Oracle Blocking detector for RAC Checks if a session is waiting on a TX (transaction) lock. (RAC only) Memory session load for RAC Records the…
max function
Advanced Topics » FDL – Farm Data Language » Functions » max function
Description Finds the max value from a set, or from a number of values. Example Find the max number of sessions for all your oracle instances max(instance[databasetype = 'oracle']/total_session_count) Returns the largest of the arguments (average session_count or…
Alert log check (java)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (java)
Name: Alert log check (java) Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Uses embedded java to read files. Long description: This check…
Archive status check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Archive status check
Name: Archive status Check Platform: Oracle Category: Availability Description: Checks how many redolog files that are not archived. Long description: Checks how many redolog files that are not…
Listener log check (java)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (java)
Name: Listener log check (java) Platform: Oracle Category: Availability Description: This checks and reads errors in database listener log. Using embedded java to read. Long description: Task checks and reads…
Extent fragmentation
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Extent fragmentation
Name: Extent fragmentation Platform: Oracle Category: Capacity Description: Checking for extent fragmentation in dba_free_space Long description: Version: 1.23 Default…
Tablespace free space (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Tablespace free space (noschema)
Name: Tablespace free space Platform: Oracle Category: Capacity Description: Checking tablespaces for free space Long description: Version: 1.5 Default schedule: 2h Requires…
Buffer cache statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Buffer cache statistics
Name: Buffer cache statistics Platform: Oracle Category: Performance Description: Gets data cache statistics for buffer cache in SGA. Long description: Task gets data cache statistic for buffer cache in…
File IO statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » File IO statistics
Name: File IO statistics Platform: Oracle Category: Performance Description: Collects I/O statistics for data files. Long description: Returns I/O statistics for data files baseed on dynamic performance view…
ASM disk statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » ASM disk statistics
Name: ASM disk statistics Platform: Oracle Category: Capacity Description: Checks ASM disks for status and statistics. Long description: Checks ASM disks for status and…
Autoextensible data files
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Autoextensible data files
Name: Autoextensible data files Platform: Oracle Category: Capacity Description: Checks all tablespaces for total disk space usage (autoextensible data files). Long description: Task checks all tablespaces for…
Test alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Test alert
Name: Test alert Platform: Oracle Category: Availability Description: Test alert that alerts every ‘X’ minutes. Long description: Test alert that alerts every ‘X’ minutes. Usefull for…
Segment size collector (large segments -- detail)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Segment size collector (large segments -- detail)
Name: Segment size collector (large segments — detail) Platform: Oracle Category: Capacity Description: Collects size and extent number info for larger segments in the database. Long description: Task…
Dataguard standby archivelog gap
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard standby archivelog gap
Name: Dataguard standby archivelog gap Platform: Oracle Category: Cluster and Replication Description: Checking for archivelog gap between threads on primary and standby instances in a replication/service group. Metadata…
Dataguard standby archivelog gap
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard standby archivelog gap
Name: Dataguard standby archivelog gap Platform: Oracle Category: Cluster and Replication Description: Checking for archivelog gap between threads on primary and standby instances in a replication/service group. Metadata…
Disk read statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Disk read statistics
Name: Disk read statistics Platform: Oracle Category: Performance Description: Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event. Long…
Temporary tablespace free space check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Temporary tablespace free space check
Name: Temporary tablespace free space check Platform: Oracle Category: Capacity Description: Checks level of free space for temporary tablespaces. Long description: Task checks the level of free space for…
Tablespace free space check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Tablespace free space check
Name: Tablespace free space check Platform: Oracle Category: Capacity Description: Checks level of free space for all tablespaces. Long description: Task checks the level of free space for all…
PDB status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » PDB status
Name: PDB status Platform: Oracle Category: Availability Description: Alerts if PDB is not in correct state Long description: Alerts if PDB is not in correct state Version: 0.1 Default…
Backup log check (old style 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 10g)
Name: Backup log Check 10g (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long description: …
Backup log check (old style 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 9i)
Name: Backup log Check 9i (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long…
min function
Advanced Topics » FDL – Farm Data Language » Functions » min function
Description Finds the minvalue from a set, or from a number of values. Example Find the minnumber of sessions for all your oracle instances min(instance[databasetype = 'oracle']/total_session_count) Returns the smallest of the arguments (average session_count or…
sum function
Advanced Topics » FDL – Farm Data Language » Functions » sum function
Description Sums the numbers in a set Example Find the total number of sessions for all your oracle instances sum(instance[databasetype = 'oracle']/total_session_count) Syntax sum(expression) Parameters Type Description Expresssion …
Long running queries
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Long running queries
Name: Long running queries Platform: Oracle Category: Performance Description: Checks any long running queries and then alerts. Long description: Task checks for long running queries and then…
Backup log check (old style 8i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 8i)
Name: Backup log Check 8i(‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long…
Redo statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Redo statistics
Name: Redo statistics Platform: Oracle Category: Performance Description: Gets redolog files statistics. Based on Oracle dictionary and performance views. Long description: Task gets redolog files statistics.…
Redo statistics (8i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Redo statistics (8i)
Name: Redo statistics Platform: Oracle Category: Performance Description: Gets redolog files statistics. Based on Oracle dictionary and performance views. Long description: Task gets redolog files statistics.…
Snapshot Log(s) rows count
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Snapshot Log(s) rows count
Name: Snapshot Log(s) rows count Platform: Oracle Category: Cluster and Replication Description: Checks row count on all snapshot logs for given schema. Long description: Task checks the row count of all…
Test alert db
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Test alert db
Name: Test alert db Platform: Oracle Category: Availability Description: Test alert that alerts every ‘X’ minutes. Long description: Test alert that alerts every ‘X’ minutes. Usefull for…
ASM diskgroup space
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » ASM diskgroup space
Name: ASM diskgroup space Platform: Oracle Category: Capacity Description: Checks ASM diskgroups space statistics. Long description: Task checks ASM diskgroups for space…
Defining Autodiscover Ports
Using Control Center » Autodiscover » Discovering Database Instances » Defining Autodiscover Ports
By default autodiscover scans the following ports: MS SQL Server: 1433 Oracle: 1520, 1521, 1522, 1523, 1524, 1526, 1527 Sybase: 4998, 4999, 5000, 5001, 5002 MySQL: 3304, 3305, 3306, 3307, 3308 PostgreSQL: 5429, 5430, 5431, 5432, 5433, 5434 You can override the…
Listener log check (java 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (java 10g)
Name: Listener log check (java) Platform: Oracle Category: Availability Description: This checks and reads errors in database listener log. Using embedded java to read. Long description: Task checks and reads…
Datafile status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Datafile status
Name: Datafile status Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle…
Max datafiles
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Max datafiles
Name: Max datafiles Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle…
SQL statistics (CDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (CDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for container database) from V$SQLAREA and V$SQL_PLAN…
SQL statistics (PDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (PDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for pluggable database) from V$SQLAREA and V$SQL_PLAN…
Job scheduling check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Job scheduling check
Name: Job scheduling check Platform: Oracle Category: Availability Description: Detecting failed scheduled jobs. The STATUS column in the Oracle dictionary view DBA_SCHEDULER_JOB_RUN_DETAILS is used to detect scheduled jobs…
Free extents
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Free extents
Name: Free extents Platform: Oracle Category: Capacity Description: Checks for free extents in all tablespaces. A warning or an alarm is returned if segments storage value is higher than the largest free extent…
Performance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Performance
Jobs in the Performance category Control Center Jobs Description Oracle Blocking detector Checks if a session is waiting on a TX (transaction) lock. Buffer cache statistics Gets data cache statistics for buffer cache in…
Instance alert log
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Instance alert log
Name: Instance alert log Platform: Oracle Category: Availability Description: Reads and checks errors in the X$DBGALERTEXT performance view contained in the XML decoded version of the XML version of Alert log…
DBA jobs check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » DBA jobs check
Name: Dba Jobs check Platform: Oracle Category: Availability Description: Detecting failed scheduled jobs in old style dba_jobs. Long description: The BROKEN column in the Oracle dictionary view DBA_JOBS is used…
RMAN backup status (9)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (9)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Checks the status of RMAN backup…
File status check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » File status check
Name: File status check Platform: Oracle Category: Availability Description: Reacts on any changes in status of data files and/or temporary files. Long description: Task reacts on any changes on the status of…
SQL statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics
Name: SQL statistics Platform: Oracle Category: Performance Description: Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views. Long description: Collects SQL statements…
SQL statistics (RDS)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (RDS)
Name: SQL statistics Platform: Oracle Category: Performance Description: Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views. Long description: Collects SQL statements…
Integration with SSMS
Installing and using premium packages » SQL Performance package » Using SQL Performance package on SQL Server » Integration with SSMS
When analyzing a SQL statement, the choice “Show query plan (using SSMS)” appears on SQL Server. This is for opening a query plan in SQL Server Management Studio. Clicking on this will not open anything, if it is not setup correctly. There is a monitor.xml…
Invalid objects check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Invalid objects check
Name: Invalid objects check Platform: Oracle Category: Availability Description: Detecting invalid objects in the database. Long description: This check detects invalid objects in the database and gives a…
Database link check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database link check
Name: Database link check Platform: Oracle Category: Availability Description: Checks database links. Long description: In order to check private database links you have to create a following view ‘create…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » DBMS uptime
Name: DBMS uptime Platform: Oracle Category: Availability Description: Collects uptime statistics in database. Long description: Task collects uptime statistics in…
Export log Check (‘old style’ backups)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Export log Check (‘old style’ backups)
Name: Export log Check (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (i.e. export log). Long description: Task checks for errors in the…
SQL Performance package
Installing and using premium packages » SQL Performance package
SQL Performance package SQL Performance module is an optional extra cost module in dbWatch Control Center that allows for historical monitoring and analysis of SQL Statements in the database instance. Currently supported platforms: MS SQL Server 2014 and…
RMAN backup status (10.1)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (10.1)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Checks the status of RMAN backup…
Restore uptodate status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Restore uptodate status
Name: Restore uptodate status Platform: Oracle Category: Internal Description: Checking if database restore is uptodate Long description: Version: 1.1 Default…
Max processes (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Max processes (noschema)
Name: Max processes Platform: Oracle Category: Capacity Description: Checking if database reaches max processes (processes) parameter Long description: Version: 1.0 Default…
RMAN backup status (10.2)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (10.2)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Checks the status of RMAN backup…
RMAN backup status (11)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (11)
Name: RMAN backup status Platform: Oracle Category: Availability Description: Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. Long description: Checks the status of RMAN backup…
Exporting configuration from 12 to CC
Advanced Topics » Exporting configuration from 12 to CC
Exporting database instance configuration from dbWatch 12 to CC A version of 12.9.1 or above is needed for this. The idea is that you can export the instance configuration from a dbWatch 12.9.x installation to install the same instances in dbWatch Control Center, as…
Dataguard apply time
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard apply time
Name: Dataguard apply time Platform: Oracle Category: Cluster and Replication Description: Checking apply time in dataguard standby nodes Long description: Version: 1.0 Default…