Oracle Alert Database Administration (DBA) alerts help you manage your database by notifying you regularly of:

• Tables and indexes unable to allocate another extent

• Users who are nearing their tablespace quota

• Tablespaces without adequate free space

• Tables and indexes that are too large or are fragmented

• Tables and indexes that are near their maximum extents

If Oracle Alert finds the database exceptions specified in a DBA alert, it sends you a message summarizing all exceptions found. If Oracle Alert finds no exceptions, it sends you a message reporting that no exceptions were found. Oracle Alert keeps you notified of the status of your database, even if it is unchanging.

The Applications DBA application owns the Oracle Alert DBA alerts. This lets Oracle Alert perform the DBA alerts for every database instance you create, even those that reside outside Oracle Alert's database.

The following descriptions list the customizable frequency and inputs of each DBA alert.

Tables Unable to Allocate Another Extent

This alert looks for tables where the next extent is larger than the largest free extent.

• Frequency: Every N Calendar Days

• Inputs:

  • Table Name

  • Oracle Username

Indexes Unable to Allocate Another Extent

This alert looks for indexes where the next extent is larger than the largest free extent.

• Frequency: Every N Calendar Days

• Inputs:

  • Index Name

  • Oracle Username

Users Near Their Tablespace Quota

This alert detects users that are near their tablespace quota.

• Frequency: Every N Calendar Days

• Inputs:

  • Oracle Username

  • Tablespace Name

  • Check minimum percent free space remaining

  • Check maximum percent space used

  • Minimum free space remaining (in bytes)

  • Maximum percent space used

Tablespaces Without Adequate Free Space

This alert looks for tablespaces without a specified minimum amount of free space.

• Frequency: Every N Calendar Days

• Inputs:

  • Tablespace Name

  • Check total free space remaining

  • Check maximum size of free extents available

  • Maximum size of free extents available (in bytes)

  • Minimum total free space remaining (in bytes)

Indexes Too Large or Fragmented

This alert detects indexes that exceed a specified number of blocks or extents.

• Frequenc: Every N Calendar Days

• Inputs:

  • Index Name

  • Oracle Username

  • Check maximum number of blocks

  • Check maximum number of extents

  • Maximum number of blocks

  • Maximum number of extents

Tables Too Large or Fragmented

This alert detects tables that exceed a specified number of blocks or extents.

• Frequency: Every N Calendar Days

• Inputs:

  • Table Name

  • Oracle Username

  • Check maximum number of blocks

  • Check maximum number of extents

  • Maximum number of blocks

  • Maximum number of extents

Tables Near Maximum Extents

This alert searches for tables and indexes that are within a specified number of extents of their maximum extents.

• Frequency: Every N Calendar Days

• Inputs:

  • Table Name

  • Oracle Username

  • Minimum number of extents remaining

Indexes Near Maximum Extents

This alert searches for tables and indexes that are within a specified number of extents of their maximum extents.

• Frequency: Every N Calendar Days

• Inputs:

  • Index Name

  • Oracle Username

  • Minimum number of extents remaining