| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Maybe it depends on what you mean by a Decision Support database. I've supported types where a weekly batch upload of detail records was used to populate the tables, one database where the detail records on the OLTP database were programatically summarized and the summary data was used to populate the DSS, and a snapshot database (updated every 15 minutes) that duplicates the production database but allows various business analysts to run ad hoc querries from hell without impacting the production database.
In the first 2 instances there are no inserts or updates after the batch load. The input data is saved. An archivelog would simply duplicate the input data. In the case of the snapshot (materialized view) database an archivelog hot backup recovery cannot bring the snapshot back into synchronization. You have to do a full rebuild. (I may be wrong about this and I'm willing to learn. It gives me the creaping willy-wallies that our only recovery is a rebuild.)
There may be other types of decision support databases where an archivelog would be worthwhile. But are these truly DSS or is it a case of DSS and OLTP banged together into the same instance for some unfathomable reason. How would you physically tune such a monster? If archivelog is genuinely useful on your DSS database, then I would take that as a sign to begin disentangling your DSS from your OLTP.
But I'll also admit that there's a lot I don't know.
"Darrell
Landrum" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
<DLANDRUM cc:
@zalecorp.com> Subject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Sent by: root
02/24/2003 03:25
PM
Please respond
to ORACLE-L
Wow, this statement...
>>> If you are a Decision Support database, then ARCHIVELOG is not needed.
is one very broad and daring statement.
>>> tday6_at_csc.com 02/24/03 09:03AM >>>
#4 on the Do list assumes that you are an On-Line Transaction Process
database. If you are a Decision Support database, then ARCHIVELOG is not
needed. But, as a general rule, the world would be a better place if more
production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list
is the same as #4 on the DON'T list (or have they got a way now to do hot
backups without ARCHIVELOG mode?)
My #1 don't is never, ever delete an OS file. Rename it, wait a week, and if everything is still running OK then delete the renamed file.
Freeman Robert -
IL <FREEMANR To: Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>
@tusc.com> cc:
Sent by: root Subject: RE: Top 10 DBA Do's
and Don'ts anyone - Here is my list, comments
02/23/2003 05:23
PM
Please respond
to ORACLE-L
Here is the list of top 10 do's and don't that I came up with.
#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Database
#7 - Do Practice Recoveries
#8 - Do Get Involved with User Groups and Other Resources
#9 - Do Establish Standards and Change Control Processes
#10 - Do Think Ahead
Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!)
Oracle Database Top 10 Don'ts
#1 - Don't Waste Time Re-Organizing Your Databases
#2 - Don't Use .Log or Other Common Extensions For Your Database File Names
#3 - Don't Leave Your Database Open To Attack
#4 - Don't Decide Against Hot Backups
#5 - Don't Use ASSM
#6 - Don't Forget the 80/20 Rule
#7 - Don't Stack Views
#8 - Don't Be a Normalization Bigot
#9 - Don't Forget to Document Everything
#10 - Do Not Use Products You are Not Licensed For.
Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything
Ok, anyone wanna comment?
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!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: FREEMANR_at_tusc.com 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: ListGuru_at_fatcity.com (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: Thomas Day INET: tday6_at_csc.com 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: ListGuru_at_fatcity.com (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: Darrell Landrum INET: DLANDRUM_at_zalecorp.com 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: ListGuru_at_fatcity.com (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: Thomas Day INET: tday6_at_csc.com 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: ListGuru_at_fatcity.com (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).Received on Mon Feb 24 2003 - 16:38:13 CST
 |
 |