analyze of fnd_lobs hangs

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 21 May 2001 10:20:39 -0700
Message-ID: <F001.00309747.20010521101529@fatcity.com>

In oracle financials 11.5.3, have table called fnd_lobs.

analyze table estimate statistics/compute statistics hangs.

validate structure hangs - drives cpu to 60-80 percent but never finishes.

dbms_stats.table_gather - works!!!

Anybody else see this.

Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 Received on Mon May 21 2001 - 12:20:39 CDT