Re: Need an Oracle Check List
There is a checklist available in http://www.oradb.net/book/dbachecklist.pdf HTH Venkat -- On Mon, 20 Jan 2003 07:39:34 KENNETH JANUSZ wrote: >Dennis: > >Thanks very much for the suggestions. They will help me a lot. I have been >working on the position for about two months now. It has everything I >want - Oracle DBA, manufacturing, large company, and only 14 miles from my >home. > >I will be working for a small IT company but be on-site at their client. I >should be signing my contract later this week and go to the client site next >Monday to start learning from the departing DBA who is going on to another >project. The position will be contract-for-hire. > >I'll be able to say who it is after I sign my contract. > >Ken >Hugo, MN > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Monday, January 20, 2003 8:49 AM > > >> Ken - Be sure to ask for the system password ;-) >> Congratulations on the position. If I'm recalling correctly from your >> previous posts, this is VERY welcome. The best suggestion is one I used >> myself. At some point you'll sit down and go over the systems. That will >> take about 30-minutes to 1 hour. You probably won't understand but a small >> portion of the statements because it will all be new to you. Take a small >> cassette recorder and record (with permission) the discussions of the >> systems you will be taking over. Then that night play the tape back and >type >> up the conversation word-for-word. Then go over the transcript and make a >> list of questions for the departing DBA. Then the next day ask about any >> points that weren't clear when you reviewed the tape. In previous >positions, >> everything would seem clear at the time but the next day I would be pretty >> hazy on the details. I used a tape recorder on my last job changeover and >> didn't miss a thing. >> >> Some other questions >> 1. Which people are most critical to my success in this position? >> 2. What issues are the most important? >> 3. What issues regularly arise which impact the quality of the systems? >> 4. What areas do I need to learn more? >> >> >> >> Dennis Williams >> DBA, 40%OCP >> Lifetouch, Inc. >> [EMAIL PROTECTED] >> >> -Original Message- >> Sent: Sunday, January 19, 2003 9:04 PM >> To: Multiple recipients of list ORACLE-L >> >> >> It appears that I will be taking over an Oracle production DBA position in >> about a week from another DBA. I would like suggestions as to >specifically >> I should be looking for from this person. Something like a check list. >> Items that I need to specifically look at. >> >> Thanks, >> Ken Janusz, CPIM >> >> -- >> 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). >> >> > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: KENNETH JANUSZ > 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). > > _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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).
RE: Need an Oracle Check List
Ken - 14 miles, you dawg! I'm jealous. Here I am humping 30 miles across the major metro area. Seriously, learn as much as you can from the departing person, because even if you have access to that DBA in the future, it is amazing how fast they can forget details. Robert - I think you have excellent points about learning everything about their backup and recovery procedures. That reminds me that a good question would be to ask about their test recovery and the procedure they used. :-) Ken - Here is an audit form I've prepared to investigate various aspects of a database. It may be help you ask more questions. If you use it and any improvements occur to you, be sure to pass them along. Oracle Database Audit Server: __ Instance Name: __ Date: _ Test / Production Backup / Recovery Audit Archive: Y/Nshow parameter log_archive_start Control file placement: number ___ separate devices Y/N select * from v$controlfile; Date of last backup controlfile to trace: show parameter user_dump_dest Log file: size number _ groups _ separate devices Y/N select * from v$logfile, v$log; Backup: schedule RMAN Y/N RMAN validation commands Exports: schedule location: Date of last export, errors in log? Y/N Temp tablespace: select username, temporary_tablespace from dba_users; Are any system? Y/N Default tablespace: select username, default_tablespace from dba_users; Are any system? Y/N Usernames owning tables: __ select distinct owner from dba_tables; LogMiner: show parameter utl_file_dir ___ Security Audit DBA privilege select grantee from dba_role_privs where granted_role = 'DBA'; Default passwords List of schemas, responsible person, # of processes (activity) select username, count(*) from v$session group by username; Performance Audit When are the critical performance times for this database? ___ Attach STATSPACK report from a peak time. TIMED_STATISTICS = true/false show parameter timed_statistics Table statistics are stored: for future diagnosis in case CBO chooses new plans. Shared Pool What is the block size? __ show parameter db_block_size; What is the shared pool size? show parameter shared_pool_size; What is the library-cache hit ratio? __ goal 99%+ (from STATSPACK report, first page) What is the dictionary hit ratio? ___ goal 99%+ (from STATSPACK, Dictionary Cache Stats) What is the JAVA_POOL_SIZE? _ What is the LARGE_POOL_SIZE? _ Buffer Cache What is the BHR? __ (from STATSPACK report, first page) What is db_block_buffers? __ (from STATSPACK report, first page) Keep pool: show parameter buffer_pool_keep Recycle pool: show parameter buffer_pool_recycle ___ What are the hit ratios for all buffer pools? V$BUFFER_POOL_STATISTICS. Statistics for increasing buffers - 8i V$RECENT_BUCKET, 9i V$DB_CACHE_ADVICE Which tables and indexes are assigned to KEEP, RECYCLE? select owner, table_name, buffer_pool from dba_tables; dba_indexes; What are the sum of blocks of the objects assigned to the KEEP pool? As a % of KEEP pool size? select sum(blocks) from dba_tables where buffer_pool = 'KEEP'; Number of LRU_LATCHES? ___ show parameter db_block_lru_latches; Redo Log Buffer What is the log buffer size? ___ show parameter log_buffer; At what time interval are log switches occuring? goal: 20min. Look for "log buffer space%" in v$session_wait In v$sysstat, look for "redo buffer allocation retries", "redo log space requests" Are there waits for the redo allocation latch? File I/O Are all temporary tablespaces correctly defined? select tablespace_name, file_name, autoextensible from dba_temp_files; select tablespace_name, maxextents from dba_tablespaces order by tablespace_name; List objects in SYSTEM tablespace that are not owned by SYS: select segment_name, segment_type, owner from dba_segments where owner <> 'SYS' and tablespace_name = 'SYSTEM'; Do DATA tablespaces contain only tables? select segment_name, segment_type, owner, tablespace_name from dba_segments where tablespace_name like '%DATA%' and segment_type <> 'TABLE' Do INDEX tablespaces contain only indexes? select segment_name, segment_type, owner, tablespace_name from dba_segments where tablespace_name like '%INDEX%' and segment_type <> 'INDEX' Do ROLLBACK tablespaces contain only rollback segments? select segment_name, segment_type, owner, tablespace_name from dba_segments where tablespace_name like '%RBS%' and segment_type <> 'ROLLBACK'; I/O conflicts - priorities 1. Are redo logs on separate devices from any other tablespaces? select member from v$logfile; 2. Are rollback tablespace datafiles on separate devices from any other tablespaces? 3. Are DATA and INDEX tablespace datafiles on separate devices from SYSTEM tablespaces? 4. Are DATA an
Re: Need an Oracle Check List
Dennis: Thanks very much for the suggestions. They will help me a lot. I have been working on the position for about two months now. It has everything I want - Oracle DBA, manufacturing, large company, and only 14 miles from my home. I will be working for a small IT company but be on-site at their client. I should be signing my contract later this week and go to the client site next Monday to start learning from the departing DBA who is going on to another project. The position will be contract-for-hire. I'll be able to say who it is after I sign my contract. Ken Hugo, MN - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 8:49 AM > Ken - Be sure to ask for the system password ;-) > Congratulations on the position. If I'm recalling correctly from your > previous posts, this is VERY welcome. The best suggestion is one I used > myself. At some point you'll sit down and go over the systems. That will > take about 30-minutes to 1 hour. You probably won't understand but a small > portion of the statements because it will all be new to you. Take a small > cassette recorder and record (with permission) the discussions of the > systems you will be taking over. Then that night play the tape back and type > up the conversation word-for-word. Then go over the transcript and make a > list of questions for the departing DBA. Then the next day ask about any > points that weren't clear when you reviewed the tape. In previous positions, > everything would seem clear at the time but the next day I would be pretty > hazy on the details. I used a tape recorder on my last job changeover and > didn't miss a thing. > > Some other questions > 1. Which people are most critical to my success in this position? > 2. What issues are the most important? > 3. What issues regularly arise which impact the quality of the systems? > 4. What areas do I need to learn more? > > > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Sunday, January 19, 2003 9:04 PM > To: Multiple recipients of list ORACLE-L > > > It appears that I will be taking over an Oracle production DBA position in > about a week from another DBA. I would like suggestions as to specifically > I should be looking for from this person. Something like a check list. > Items that I need to specifically look at. > > Thanks, > Ken Janusz, CPIM > > -- > 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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ 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).
RE: Need an Oracle Check List
My big thing would be backup and recovery and making sure I know how they are doing it. Everything else you can ferret out over time if need be, but if that database craters on day 2 and it takes you forever to recover it, you are just not going to look good to management. I've seen a number of different backup strategies, and this includes application oriented recovery needs as much as anything. IMHO, backup and recovery is job #1 for a DBA. Everything else is secondary. MO, YMMV RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Monday, January 20, 2003 8:50 AM To: Multiple recipients of list ORACLE-L Ken - Be sure to ask for the system password ;-) Congratulations on the position. If I'm recalling correctly from your previous posts, this is VERY welcome. The best suggestion is one I used myself. At some point you'll sit down and go over the systems. That will take about 30-minutes to 1 hour. You probably won't understand but a small portion of the statements because it will all be new to you. Take a small cassette recorder and record (with permission) the discussions of the systems you will be taking over. Then that night play the tape back and type up the conversation word-for-word. Then go over the transcript and make a list of questions for the departing DBA. Then the next day ask about any points that weren't clear when you reviewed the tape. In previous positions, everything would seem clear at the time but the next day I would be pretty hazy on the details. I used a tape recorder on my last job changeover and didn't miss a thing. Some other questions 1. Which people are most critical to my success in this position? 2. What issues are the most important? 3. What issues regularly arise which impact the quality of the systems? 4. What areas do I need to learn more? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, January 19, 2003 9:04 PM To: Multiple recipients of list ORACLE-L It appears that I will be taking over an Oracle production DBA position in about a week from another DBA. I would like suggestions as to specifically I should be looking for from this person. Something like a check list. Items that I need to specifically look at. Thanks, Ken Janusz, CPIM -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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).
RE: Need an Oracle Check List
Ken - Be sure to ask for the system password ;-) Congratulations on the position. If I'm recalling correctly from your previous posts, this is VERY welcome. The best suggestion is one I used myself. At some point you'll sit down and go over the systems. That will take about 30-minutes to 1 hour. You probably won't understand but a small portion of the statements because it will all be new to you. Take a small cassette recorder and record (with permission) the discussions of the systems you will be taking over. Then that night play the tape back and type up the conversation word-for-word. Then go over the transcript and make a list of questions for the departing DBA. Then the next day ask about any points that weren't clear when you reviewed the tape. In previous positions, everything would seem clear at the time but the next day I would be pretty hazy on the details. I used a tape recorder on my last job changeover and didn't miss a thing. Some other questions 1. Which people are most critical to my success in this position? 2. What issues are the most important? 3. What issues regularly arise which impact the quality of the systems? 4. What areas do I need to learn more? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, January 19, 2003 9:04 PM To: Multiple recipients of list ORACLE-L It appears that I will be taking over an Oracle production DBA position in about a week from another DBA. I would like suggestions as to specifically I should be looking for from this person. Something like a check list. Items that I need to specifically look at. Thanks, Ken Janusz, CPIM -- 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).
Need an Oracle Check List
It appears that I will be taking over an Oracle production DBA position in about a week from another DBA. I would like suggestions as to specifically I should be looking for from this person. Something like a check list. Items that I need to specifically look at. Thanks, Ken Janusz, CPIM
