Mr. DBA

O serviço de monitoramento é feito de forma pró-ativa e customizada para cada cliente, visando:

Actively Monitored Items

SPACE MONITORING

• Tablespace free space
• Temporary tablespace usage
• Autoextend usage
• Datafile I/0
• Extent management
• Extent failure detection
• O/S disk free space
• ASM volume free space
• Flash recovery area free space

BACKUP AND RECOVERY

• Archiving usage
• Archive log disk space
• Redolog switches
• RMAN backup successful
• Unrecoverable transactions

AVAILABILITY

• Database availability
• Listener availability
• Alert log errors
• Oracle RAC interconnect efficiency
• Data Guard log apply process
• Application server availability

RESOURCE UTILIZATION

• O/S CPU utilization
• O/S memory utilization
• O/S swap utilization
• O/S concurrent users
• Concurrent database user logins

INSTANCE MONITORING

• SGA and shared pool utilization
• Sorting efficiency
• Buffer cache hit ratios
• Shared pool hit ratios
• Object fragmentations
• Lock & latch issues
• Blocking locks

Administration Items

STORAGE MANAGEMENT

• Review database structures/layouts
• Manage Oracle data files
• Manage tables/ indexes/storage options
• Manage rollback segments issues
• Undo tablespace sizing
• Raw device configuration
• ASM configuration
• Flash recovery area configuration

BACKUP MANAGEMENT

• Define backup and recovery procedures
• Recovery assistance
• Disaster recovery
• Archive log configuration

SECURITY

• Manage DB user, roles and profiles
• Object level privileges
• Security audits

GENERAL ADMINISTRATION

• Instance parameter configuration
• Database jobs
• Listener configuration
• Identify invalid objects
• Patch assistance
• TAR management
• Database creation
• Flash back database configuration