From: Tracy Rahmlow [EMAIL PROTECTED]
Date: Mon, 17 Sep 2001 08:37:30 -0500
Subject: Looking for 24 X 7 Design Considerations
We currently have 15+ databases (7.3.4 8i using IBM AIX and HACMP) that
do
not have a 24x7 restriction. Now, management is looking to bring in new
products
: RE: Looking for 24 X 7 Design
Considerations
Sent by:
[EMAIL PROTECTED
DB in production.
Any independently verifiable substantiation for your claim would be
welcomed.
This 9i instance has had flawless performance for the last two
months;
which
is how long it has been in production.
Original Message
Subject: RE: Looking for 24 X
]
charliem@mwh. cc:
com Subject: RE: Looking for 24 X 7
Design Considerations
Sent by:
[EMAIL PROTECTED]
om
09/17/01 06
We currently have 15+ databases (7.3.4 8i using IBM AIX and HACMP) that do
not have a 24x7 restriction. Now, management is looking to bring in new
products that will need to be 24X7. They are looking for costs to determine
the viability of such a decision. I have no 24x7 experience and am
In my opinion, one of the biggest things with 24x7 is planning. Documenting
what is normal maintenance either it be for your application or for the
database itself. This means finding out how often normal maintenance (index
rebuilds, re-orgs, data loads) runs, and how long. This is a good step
That is going to be really tough - especially for 7.3.4. Absolutely no
downtime for anything - including Oracle, OS, application, etc. patches and
upgrades isn't feasible unless you simply prohibit them.
There are a lot of good white papers out there that talk about basic concepts
and the
Tracy:
There's a book Oracle 24X7 by Oracle Press Author : Venkat S. Devraj ISBN
: 0-07-211999-3
could be your good start point reference.
Kevin
-Original Message-
Rahmlow
Sent: Monday, September 17, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L
We currently have 15+
Spence To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cspence@Fuelcc:
Spot.comSubject: RE: Looking for 24 X 7 Design
Considerations
Tracy - Is there any possibility of upgrading these databases to Oracle8i,
or even better 9i before you implement 24X7? Oracle is claiming new features
in 9i will support 24X7. I would also imagine that if you could bring all
databases up to the same level, it would be easier to establish
Anyone contemplating upgrading anything more important than a sandbox
database to 9i is nutso.
9i is ready for development playing around in 6-8 months, production no
earlier than 12-18 months is my estimation.
joe
[EMAIL PROTECTED] 09/17/01 03:25PM
Tracy - Is there any possibility of
cc:
Spot.comSubject: RE: Looking for 24 X 7
Design Considerations
Sent by:
root@fatcity.
com
09/17/01
11:00 AM
al Message
Subject:
RE: Looking for 24 X 7 Design Considerations
Date:
Mon, 17 Sep 2001 12:40:18 -0800
From:
"JOE TESTA" [EMAIL PROTECTED]>
Reply-To:
[EMAIL PROTECTED]
Organization:
Fat City Network Services, San Diego, California
To:
Multiple recipients of list OR
All the databases that I have worked on or been
responsible for, have been 24x7. Here are some
suggestions:
1. Know the requirements of your environment in
regards to UPTIME. Have it documented. The best
practice that works well is Service Level Agreements,
if there is none in place, implement
Now I must disagree with this. Although I am on
call every annoying day of the year it is so rare
that I have database issues its not even funny.
I think nothing of leaving for the weekend. At the
very least I can talk someone though something, even
if I am at the top of a mountain. Calls
in production.
Any independently verifiable substantiation for your claim would be
welcomed.
This 9i instance has had flawless performance for the last two
months;
which
is how long it has been in production.
Original Message
Subject: RE: Looking for 24 X 7 Design
is how long it has been in production.
Original Message
Subject: RE: Looking for 24 X 7 Design Considerations
Date: Mon, 17 Sep 2001 12:40:18 -0800
From: JOE TESTA [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Organization: Fat City Network
I'm pretty much in the same boat. All my global
databases are doing well. There are virtually no
database issues. People wonder why the company pays me
so much money for doing nothing.
However, I still get those calls at odd hours of the
day/night (because of the time differences) from
system
at the earliest.
Rachel
From: JOE TESTA [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Looking for 24 X 7 Design Considerations
Date: Mon, 17 Sep 2001 12:40:18 -0800
Anyone contemplating upgrading anything more important than
19 matches
Mail list logo