Stats Gathering - 11g
From: A Ebadi <ebadi01_at_yahoo.com>
Date: Mon, 25 Apr 2011 10:47:49 -0700 (PDT)
Message-ID: <898684.36323.qm_at_web112809.mail.gq1.yahoo.com>
For some reason automatic stats gathering job is not picking up partitions of a fact table we are loading? It picks up standalone (dimension) tables OK.
Platform is Oracle Exadata (11G).
Any suggestions?
Thanks,
Abdul
Date: Mon, 25 Apr 2011 10:47:49 -0700 (PDT)
Message-ID: <898684.36323.qm_at_web112809.mail.gq1.yahoo.com>
For some reason automatic stats gathering job is not picking up partitions of a fact table we are loading? It picks up standalone (dimension) tables OK.
Platform is Oracle Exadata (11G).
Any suggestions?
Thanks,
Abdul
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 25 2011 - 12:47:49 CDT