DBA On Demand^TM Advanced Service Level

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

 This 24x7 service level is designed for robust environments.  It is best suited for global sites or sites that have users who work through the day, followed by jobs that run nightly, or are taking advantage of some of the advanced features of Oracle.

• 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.

• Expanded Database Administration Monitoring Functions 24x7 From DCC Services Central Monitoring Location

  • Monitor database performance.

  • Monitor tablespace and other object space.

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

• Weekly 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 Archivelogs.

  • 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

• Create/Clone Databases, Setup Database-Related OS Environment, and Lay-Out Physical (Devices, File Systems, Directories, Files, etc.) and Logical Structure (Tablespaces, Segments, Extents, etc.).

• Analysis of Tables and Indexes

• Additional Advanced Services As Required (When Deemed Necessary or Upon Client Request):

  • Create data dictionary views and standard packages for new database.

  • Create and modify parameter file(s).

  • Database startup and shutdown automation.

  • Set-up database user management framework, including assigning tablespace quotas for a type of user, set-up custom roles, and set-up non-default profiles (including roles, profiles, synonyms, sequences, triggers, and views).

  • Manage system resources usage via profile enforcement (restrict CPU time, idle time, etc.); Oracle version 8 and above.

  • Database backup and recovery strategy for high availability operations.

  • Install or upgrade Oracle Database Server.

  • Monitor interaction between Oracle and system and recommend system modifications.

  • Respond to technical questions via telephone/email regarding the Oracle database.

  • Coordinate with Oracle Support on TAR (technical assistance requests).

  • Alert and warn (via email, page, etc.) in case of abnormal events.

  • Set-up simple audit trails/auditing (object/user access).

• Database Disaster Recovery Recommendations.

• Report On Queries That Are Taking Up the Most Resources (Disk, Memory, or Frequently Invalidated/Need Pinning in Shared Pool).

• Additional Advanced Services As Required (When Deemed Necessary or Upon Client Request):

  • Database backup and recovery strategy for 24x7 operations.

  • Database migration.

  • Tablespace defragmentation for entire database.

  • Advanced replication site creation and administration.

  • Standby site creation and administration.

  • Distributed database set-up.· Parallel server set-up.

  • Snapshot site creation and administration.

  • Set-up and configure Multi-Threaded Server (MTS) including listener, dispatcher, and shared server processes.

  • Partition tables and indexes