Re: Capacity Planning on Data load.
Date: Wed, 2 Sep 2015 16:35:02 -0600
Message-ID: <CAAaXtLCGaMD_9RocegEtm4TgCEr-nV2-fgd22gy_74-vRxKu3w_at_mail.gmail.com>
And even more depends on the INDEXES present on the table.
Loading 50,000,000 rows into a table with no indexes is pretty easy. Usually, this is not what we find ourselves doing.
On Wed, Sep 2, 2015 at 5:25 AM, John Hallas <John.Hallas_at_morrisonsplc.co.uk> wrote:
> I am not sure what you expect from this list Bala as a response.
>
> Surely if you load data into a table and then load 50M rows and capture
> the statistics then you will have all the metrics you need.
>
> Subsequent loads should be very similar
>
>
>
> So much depends on the data, the storage, the memory limitations (both
> physical and SGA parameters) and what else is running at the time
>
>
>
> John
>
> www.jhdba.wordpress.com
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Bala Krishna
> *Sent:* 31 August 2015 20:40
> *To:* oracle-l_at_freelists.org
> *Subject:* Capacity Planning on Data load.
>
>
>
> Hi All,
>
> Our client is planning to insert 50Million rows every day to a particular
> table, We've already calculated the required disk space but we'd like to
> know how much is the load(CPU/Memory) will increase if we insert 50M rows
> everyday.
>
> We've tool to look back for CPU & Memory utilization but not the DB load.
> I request can somebody give me some ideas/free tools to solve our problem
> would be appreciated.
>
> Thanks
>
> Bala
>
> ______________________________________________________________________
> Wm Morrison Supermarkets Plc is registered in England with number 358949.
> The registered office of the company is situated at Gain Lane, Bradford,
> West Yorkshire BD3 7DL. This email and any attachments are intended for the
> addressee(s) only and may be confidential.
>
> If you are not the intended recipient, please inform the sender by
> replying to the email that you have received in error and then destroy the
> email.
> If you are not the intended recipient, you must not use, disclose, copy or
> rely on the email or its attachments in any way.
>
> This email does not constitute a contract in writing for the purposes of
> the Law of Property (Miscellaneous Provisions) Act 1989.
>
> Our Standard Terms and Conditions of Purchase, as may be amended from time
> to time, apply to any contract that we enter into. The current version of
> our Standard Terms and Conditions of Purchase is available at:
> http://www.morrisons.co.uk/gscop
>
> Although we have taken steps to ensure the email and its attachments are
> virus-free, we cannot guarantee this or accept any responsibility,
> and it is the responsibility of recipients to carry out their own virus
> checks.
> ______________________________________________________________________
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 03 2015 - 00:35:02 CEST