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 SmartDog 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
