DBA On Demand^TM Safe and Sound Service Level

Overview > Promotions > Service Levels > FAQ                                         DBA On Demand^TM PDF
Advanced > Intermediate > Safe and Sound > eBusiness Apps > ASPs

This service level is designed with the less active environments in mind. Support is provided Monday thru Friday from 9am-5pm.

• Initial Client Assessment:

  • Collect information about hardware/software environment and business goals, assess current database backup strategy and make recommendations, establish overall performance goals, and perform basic database security analysis.

• Database Administration Monitoring Functions From 9am to5pm Monday through Friday from SmartDog Services Central Monitoring Location (Extra charges apply for work outside of these hours):

  • Monitor database performance.

  • Monitor tablespace and other object space.

  • Monitor Oracle log files, trace files, and statistics.

• Monthly Report To Provide Information Concerning Instance, i/o and Rollback Tuning Performance.

• Basic Database Access Management: Configure Listeners and TNS Names.

• Basic Database Version Patch Update. Troubleshoot Database Service Interruption Problems.

• Additional Services As Required (When deemed necessary or upon client request):

  • Recommend database backup/recovery strategy.

  • Set-up and monitor Archivelog.

  • Problem resolution in conjunction with Oracle Support on TARs (technical assistance requests).

  • Tablespace creation and storage settings adjustment.

  • Allocate space for temporary segments.

  • Optimize storage requirements on existing objects.

  • Rollback segment management.

  • Online redo log management and multiplexing.

  • Control file management and multiplexing.

  • Database recovery