Re: Stats on Huge Partitioned Table and ORA-01555

  • From: "Mladen Gogala" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "mgogala@xxxxxxxxx" for DMARC)
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 27 May 2015 10:48:06 -0400

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

Other related posts: