Re: Stats on Huge Partitioned Table and ORA-01555
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Wed, 27 May 2015 10:48:06 -0400
Message-ID: <5565D926.4020502_at_yahoo.com>
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.
Date: Wed, 27 May 2015 10:48:06 -0400
Message-ID: <5565D926.4020502_at_yahoo.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 27 2015 - 16:48:06 CEST