Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Extent Sizing?

Re: Extent Sizing?

From: Bola Ogunlana <bolao_at_incads.demon.co.uk>
Date: 1997/09/14
Message-ID: <5Udo3CAyyFH0EwG5@incads.demon.co.uk>#1/1

In article <19970912140301.KAA21629_at_ladder02.news.aol.com>, CDWaddell <cdwaddell_at_aol.com> writes
>How do I go about determining the size of the extents I will need for my
>database. I'm moving data from paradox tables into Oracle and it is
>incredibly slow. (Doesn't help that we are running NW 4.1 on a 486/66 with
>64M RAM.) I have started reading O'Reilly & Asoc. "Oracle Performance
>Tuning" and it seems that my extents are to small. but I can't figure out
>how to determine the right size for this project. The paradox tables have
>approx. 3/4 to a million records in them. I have roughly 6-10 of these
>tables to bring into Oracle but at the speed things are moving now I will
>spend the next year just moving data. Any suggestions would be greatly
>appreciated. One more thing, how much performance enhancement would I get
>if I were to add more memory to the existing server. (Were a very poor
>health care company)
>
>Thanks CDWaddell_at_AOL.Com

Have a read of the "Oracle 7 Server Administrator's Guide Release 7.3" page A-4 (Appendix A)

-- 
Bola Ogunlana
Received on Sun Sep 14 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US