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: