Dba Check List
DBA Check List
Oracle DBA Checklist
Version 1.4 Generic
Revised: 23-Aug-2000
Authors: Thomas B. Cox, with Christine Choi
Purpose: This document gives details for performing daily, weekly, and monthly checks of the status of one or more Oracle databases. All SQL and PL/SQL code for the listed checks can be found in the appendix.
The latest version of this paper should always be available on the primary author 's home page, .
Change Notes: 1.1: Typo in 'existext.sql ' identified by Steve DeNunzio, fixed 1.2: Typos fixed 3. Gnu Public License added; pctincr 0 in rebuild index added 4. Added pointer to newest version on Geocities home page, http://www.geocities.com/tbcox23 Fixed pointer to 'orapub ' web site Added nightly checklist and volumetrics
Support Information (customize for your site): Help Desk: Physical DBA: Application DBA: Oracle Support: CSI:
Acknowledgements:
This paper was inspired by the work of David Cook (see References), and Version 1.0 was largely fleshed out by Christine Choi of Hewlett-Packard (Components Group), San Jose, California. I am grateful to both for their contributions to this document.
Please send your corrections, suggestions, and feedback to me at the address below, with your return address so I may credit your contribution. Thank you.
-Thomas B. Cox,
Copyright © 1999, 2000 Thomas B. Cox, All Rights Reserved.
This document is free; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This document is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
For a
Oracle DBA Checklist
Version 1.4 Generic
Revised: 23-Aug-2000
Authors: Thomas B. Cox, with Christine Choi
Purpose: This document gives details for performing daily, weekly, and monthly checks of the status of one or more Oracle databases. All SQL and PL/SQL code for the listed checks can be found in the appendix.
The latest version of this paper should always be available on the primary author 's home page, .
Change Notes: 1.1: Typo in 'existext.sql ' identified by Steve DeNunzio, fixed 1.2: Typos fixed 3. Gnu Public License added; pctincr 0 in rebuild index added 4. Added pointer to newest version on Geocities home page, http://www.geocities.com/tbcox23 Fixed pointer to 'orapub ' web site Added nightly checklist and volumetrics
Support Information (customize for your site): Help Desk: Physical DBA: Application DBA: Oracle Support: CSI:
Acknowledgements:
This paper was inspired by the work of David Cook (see References), and Version 1.0 was largely fleshed out by Christine Choi of Hewlett-Packard (Components Group), San Jose, California. I am grateful to both for their contributions to this document.
Please send your corrections, suggestions, and feedback to me at the address below, with your return address so I may credit your contribution. Thank you.
-Thomas B. Cox,
Copyright © 1999, 2000 Thomas B. Cox, All Rights Reserved.
This document is free; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This document is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
For a
References: 1. Loney, Kevin Oracle8 DBA Handbook 2. Cook, David Database Management from Crisis to Confidence [http://www.orapub.com/] 1. Cox, Thomas B. The Database Administration Maturity Model