Home » RDBMS Server » Server Administration » DBA Service Contract (Oracle 10g)
DBA Service Contract [message #661462] Sun, 19 March 2017 05:56 Go to next message
chat2raj.s
Messages: 104
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
Re: DBA Service Contract [message #661463 is a reply to message #661462] Sun, 19 March 2017 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 65201
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: DBA Service Contract [message #661464 is a reply to message #661463] Sun, 19 March 2017 06:34 Go to previous messageGo to next message
chat2raj.s
Messages: 104
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.
Re: DBA Service Contract [message #661466 is a reply to message #661462] Sun, 19 March 2017 08:13 Go to previous messageGo to next message
John Watson
Messages: 7149
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.
Re: DBA Service Contract [message #661467 is a reply to message #661466] Sun, 19 March 2017 08:43 Go to previous messageGo to next message
chat2raj.s
Messages: 104
Registered: October 2010
Location: Chennai, India
Senior Member
Thank you. Will consider your suggestions. Can you share your company website.
Re: DBA Service Contract [message #661468 is a reply to message #661467] Sun, 19 March 2017 08:50 Go to previous message
John Watson
Messages: 7149
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

Previous Topic: created sequence not visible
Next Topic: Sql Query
Goto Forum:
  


Current Time: Tue Nov 21 04:20:50 CST 2017

Total time taken to generate the page: 0.02806 seconds