Bonjour a tous,
je voudrai écrire des scripts permettant d'avoir les alerts oracle suivants.
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 use
Minimum total 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.
Frequency 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
merci
Partager