Monitored ItemsHelping Your Business Succeed At Its Data Mission

From optimization and daily proactive monitoring to trend analysis and planning, BraveSoft Remote DBA service is tailor fit to meet your organization's needs. The Software Services team is online and available when you need us and when you didn't know you needed us. Customize your Remote-DBA Service to supplement your current DBA staff or to provide complete database administration.

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

INSTANCE TUNING

  • Index monitoring
  • Investigate inefficient SQL
  • CBO stats management
  • Undo/Rollback segments activity
  • Shared server configuration
  • Oracle RAC interconnect tuning