Santosh For maintenance, you might study recommended checklists of regular DBA activities. If you have time, you might pick up a copy of Oracle DBA Checklists Pocket Reference. www.orapub.com <http://www.orapub.com> has a DBA checklist available for free. For implementation, here are some issues to consider: Database Change Request
Date: __________ Change Request #: ______ Project: ____________________ Requester: __________________________ Requester Phone: ___________ Request is for instance: _______________ System: ________________ Reason for change: _________________________________________________________________ Data model change approval: ________________ (authorized by division) Date: ______ Users/systems/teams affected by change, and how:______________________________ Description of change(s): Table Change __________________ _______________________________________________ __________________ _______________________________________________ __________________ _______________________________________________ __________________ _______________________________________________ __________________ _______________________________________________ __________________ _______________________________________________ New tables: Size (# of rows) Growth pattern (static, load/purge, steady growth, other) ____________ _______ ___ static ___ load/purge ___ steady growth ____________ _______ ___ static ___ load/purge ___ steady growth ____________ _______ ___ static ___ load/purge ___ steady growth ____________ _______ ___ static ___ load/purge ___ steady growth ____________ _______ ___ static ___ load/purge ___ steady growth Retain existing data? ____ yes ____ no Location of scripts: _______________ Requested Date / Time for change implementation: __________________________ Have users/systems/teams been notified? ______ This change was successfully implemented in production ______________________________ Date: _______________ -----Original Message----- Sent: Monday, March 24, 2003 12:24 AM To: Multiple recipients of list ORACLE-L Hello list, I will be attending interview on oracle..but the position is for Maintenance/Implementation of Software. Could any one of you provide me with set of questions related to maintenance/Implementation issues in oracle ? Regards, Santosh _____ <http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3 bst%3b&SG=&RAND=86682> Upgrade Your Email - Click here! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).