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 <[EMAIL PROTECTED]>
<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.
>>> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
@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: [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: Thomas Day
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: Darrell Landrum
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: Thomas Day
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).
