Re: Double database load.

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Wed, 30 Jun 2004 00:42:51 -0700 (PDT)
Message-ID: <20040630074251.39819.qmail@web20424.mail.yahoo.com>

• "Patamalla, Chaya" <chaya.patamalla_at_usaa.com> wrote:
  > One of my application said that the load on the
  > database will double in =
  > the month of September. They will be rolling out
  > the app. to lot more =
  > people.
  > What are the precautions I need to take besides
  > space?
  > How do I know if the SGA is enough? It is a
  > datawarehouse.
  > Any suggestions are appreciated.
  

> Thanks

> Chaya Patamalla=20
> I/T Database Administrator=20

I'd recommending determining what hardware, operating system, oracle database software version, network adapters, storage contollers, disk subsystems are in place, along with usage profiles. If you can find the main current bottleneck, you'll be able to predict a less wild-as-guess with a higher confidence interval.

instead, you could just raise all the values (to eleven - "lets have everything louder than everything else"*). when you can't start the instance due to the sga being too large, you went too far and should back off.

At least they gave you until September.
test all of your settings out on your test system (if you have one). if not, see if you can down this system over a weekend to test the changes.
If you need to order hardware - you have 60 days from today to make it happen. That's not alot of time.

you might want to get it up on the latest version and patchset that is stable for your (unnamed) operating system and oracle database software version.

the other approach, is to wait until a week into september, when it will be much easier to find the bottleneck, and no predicting will be necessary. :)

Pd

*deep purple, made in europe, forget the year.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jun 30 2004 - 02:39:44 CDT