OraFAQ Forum: Server Administration » DBA Service Contract

Home » RDBMS Server » Server Administration » DBA Service Contract (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBA Service Contract [message #661462]

Sun, 19 March 2017 05:56

chat2raj.s
Messages: 163
Registered: October 2010
Location: Chennai, India

Senior Member

We are going to have a Oracle database maintenance contract with our vendor. They have suggested the following points will be taken care by them as part of DBA Service. Is anything more to be added to this list to be more effective.

1. Checking daily error log and trace files. Backup and deleting the same.
2. Checking daily alerts and ensuring minimum downtime.
3. Monitoring and increasing tablespace
4. Monitoring performance variables like disk I/O, CPU Utilisation, Memory utilization.
5. Monitoring Rollback segment / undo Segment
6. Periodical Index rebuilding
7. Monitoring system utilization against database parameters
8. Tracking new patch releases and bug fixes and applying the same in DB.
9. Raising Service request and applying the recommendations.

Thankyou

Report message to a moderator

Re: DBA Service Contract [message #661463 is a reply to message #661462]

Sun, 19 March 2017 06:27

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

8. Tracking new patch releases and bug fixes and applying the same in DB.
9. Raising Service request and applying the recommendations.

Quote:

Oracle 10g

Easy to do:
8. There is no more patches
9. No need to raise any SR, the recommendation is upgrade.
Good luck.

Note: you did not feedback in your previous topics despite the fact you told us you will tell us if you succeeded.

Report message to a moderator

Re: DBA Service Contract [message #661464 is a reply to message #661463]

Sun, 19 March 2017 06:34

chat2raj.s
Messages: 163
Registered: October 2010
Location: Chennai, India

Senior Member

Upgrade to 11g or 12c is already part of this contract and point 8 and 9 will be considered after this upgrade also.

Thank you for remembering about my previous topic. Am yet to test the same, definitely i will update the status as soon as it is done.

Report message to a moderator

Re: DBA Service Contract [message #661466 is a reply to message #661462]

Sun, 19 March 2017 08:13

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Your vendor is not giving you very much. The company I work for would do this:

1. install a job to mail you when an error message is written to the alert log
2. configure the server generated alert system to raise alerts when certain metric thresholds are crossed.
3. configure this to occur automatically when needed.
4. just another job that will mail you when certain thresholds are crossed
5. ditto
6. why would you pay someone to degrade performance by rebuilding indexes?
7. do you know what that means? I'm not sure that I do.

Overall, you might want to discuss with your vendor what benefit you will get from this contract. Or you could ask my boss for a competitive quote Smile

THe big thing you seem to be missing that is much harder to automate is detecting performance regression from your critical business processes.

Report message to a moderator

Re: DBA Service Contract [message #661467 is a reply to message #661466]

Sun, 19 March 2017 08:43

chat2raj.s
Messages: 163
Registered: October 2010
Location: Chennai, India

Senior Member

Thank you. Will consider your suggestions. Can you share your company website.

Report message to a moderator

Re: DBA Service Contract [message #661468 is a reply to message #661467]

Sun, 19 March 2017 08:50

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Well, this is not really intended to be a commercial website, but here you go:
--
John Watson
Oracle Certified Master DBA
Skillbuilders Inc

Report message to a moderator

Previous Topic:	Calling exp from a shell script throws ora-01034
Next Topic:	Move to new Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 16:39:39 CST 2024