Oracle Expertize _____________________________ The DB1
Oracle Service Desk is usually a monthly
fee (Standard and Premium Services) without time commitment, applied to
each Oracle database included in the contract. For Standard and Premium
services, a number of proactive and reactive tasks are included in the monthly fee. The on-site
visit, the remote assistance exceeding the monthly quota are hourly billed. Basic service for a less reactive
assistance is billed at cost. The needs are estimated
in advance for a given period. The
client uses his prepaid hours throughout the year for support / advice. For the 3 levels of service (Basic, Standard,
Premium), the majority of tasks
carried out mostly in remote mode with ssh connection (Remote DBA), but
sometimes DB1 consultant’s visit
could be required. Only one DB1 consultant is in charge of setup and delivery of
selected service. If needed he will be replaced by a colleague with the same level
in case of overloading or absence. The
process is very simple, in case of emergency you call the support line +338.20.22.00.80
to contact your DB1 consultant, reach in less than an hour (Premium). A study can
be made to qualify your actual needs and get the best proposal at the lowest
cost. For example,
the possibility of supplementing the supply of your outsourcing partner who
manages your servers
(Unix, Windows) or your ERP (SAP,
Oracle App, PeopleSoft, Siebel, ...) with Oracle databases
|
The Oracle Expert Service
Desk |
Service levels |
||
|
Basic |
Standard |
Premium |
|
DAILY ACTIVITIES OF DB1
SERVICE |
||||
Commitment (SLA) |
|
|||
Window Service (support calls,
change) -> |
9H-18H |
7H-20H |
24x7x365 |
|
Maximum response time for critical calls -> |
4H |
2H |
1H |
|
Average Response time for critical calls -> |
2H |
15mn |
5mn |
|
Quota hours of advise /
support per 3 Month included (no extra charge) -> |
6H |
12H |
24 |
|
2nd/3rd level Support and Advice |
|
|||
Telephone Support & mail
or resolution with remote connection -> |
v |
v |
v |
|
Identifying the root cause and
change the configuration -> |
v |
v |
v |
|
Responses to requests for
advice with transfer of experience -> |
v |
v |
v |
|
Recovery of lost, damaged or corrupted data |
|
|
|
|
Recovery databases with or
without RMAN, complete or incomplete (until time) -> |
|
1/year |
2/year |
|
Partial
recovery (TS, Schema, Tables) complete or incomplete -> |
|
|
1/year |
|
Recovery without backups (flashback, j-dul) -> |
1/year |
|||
Proactive Audit and advise on the health of the database |
|
|
|
|
Audit of
the database health with report -> |
4/year |
1 / M |
||
Capacity
management (Tablespace, ASM, FileSystem) -> |
|
4/year |
1 / M |
|
Selective
reorganization of index and tables -> |
|
1/year |
4/year |
|
Proactive audit and advise on the database performance |
||||
Audit and Performance Report
with difference since the previous on -> |
4/year |
1 / M |
||
Recommendations for
performance (parameters, optimizer statistics) -> |
4/year |
1 / M |
||
SQL
performance plans outline for a possible come back -> |
4/year |
|||
Changes and implementations |
|
|
|
|
Changes
made after the audits -> |
|
4/year |
1 / M |
|
Patch / patch security ,
patchset -> |
|
|
1/year |
|
Others DBA tasks |
||||
Installing Oracle database
software (with or without RAC) -> |
Time
& material |
|||
Database creation, migration,
reorg, cloning, import / export -> |
||||
DRP with Physical Standby (SE)
or Dataguard (EE) + monitoring -> |
||||
Setting up Enterprise manager (EM) database control or grid control
-> |
||||
SETUP THE DB1 SERVICE |
|
|
|
|
Initial
Steps |
|
|
|
|
Assigning a DB1 expert with a
visit on site -> |
v |
v |
v |
|
Check instance, configuration update,
monitoring and backups -> |
Time & material |
|||
Setting up physical backup and
logical backups if necessary -> |
||||
Automatic monitoring setup
(optional) |
||||
backup alerts-> |
v |
v |
||
disk space alerts (archive
log, TS, ASM, Flash recovery area) -> |
|
v |
v |
|
availability alerts (crash
instance) and serious error (alertSID.log) -> |
|
v |
||
peak performance alerts (instance metrics and slow SQL) -> |
|
|
v |
|
Training for DBAs / developers / operators |
|
|
|
|
Trainings admin / delta10g11g / rman / Tuning, SQL, PL / SQL -> |
Time & material |
|||
Customization of course depending
on the environment -> |
|
v |
v |
|
DB1 course materials scripts
and procedures -> |
v |
v |
v |
|
TRACKING OF DB1 SERVICE |
|
|
|
|
Inventory of the Oracle activity from the previous
period -> |
1/year |
4/year |
1 / M |
|
Oracle actions and call tracking report -> |
Online |
Online |
Online |