Re: Stats on Huge Partitioned Table and ORA-01555

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Wed, 27 May 2015 16:48:37 -0400
Message-ID: <55662DA5.1010007_at_yahoo.com>

Data is usually moved to a data warehouse database which is differently structured from production.

On 05/27/2015 01:59 PM, Michael Cunningham wrote:
> All the suggestions have been great and I obviously have some reading
> to do. Thanks for all the input.
>
> A question for Cherif and Mladen about "Such table has no place in an
> OLTP system". I will bring this up to the team, but, out of curiosity,
> how would you archive the table? Would you just move the partitions to
> a different table?
>
> Thanks again,
> Michael
>
> On Wed, May 27, 2015 at 7:48 AM, Mladen Gogala
> <dmarc-noreply_at_freelists.org <mailto:dmarc-noreply_at_freelists.org>> wrote:
>
> On 05/27/2015 05:33 AM, Cherif Ben Henda wrote:
>> Hi Michael,
>>
>> Why having "Table has 7.1 billion+ rows, 503 partitions, 3TB" ?
> This is a great question. Such table has no place in an OLTP
> system. That OLTP system is, in my humble opinion, in dire need of
> an archiving solution.
>
> --
> Mladen Gogala
> Oracle DBA
> http://mgogala.freehostia.com
>
>
>
>
> --
> Michael Cunningham

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 27 2015 - 22:48:37 CEST