dbms_stats.gather_schema_stats does not finish.

  • From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 17 Nov 2015 08:39:42 -0200

Hi,

I am running the comand below in Oracle 12c and it does not finish.
I have spatial data in the schema.

BEGIN
dbms_stats.gather_schema_stats(OWNNAME => user, ESTIMATE_PERCENT => 100);
END;
/
The sqltext is:

begin :retval :=
"MDSYS"."SDO_STATISTICS".ODCIStatsCollect(:idx_info,:stat_opt,:stats,:env);
end;

Any idea ?
Is there a bug on this ?

Regards
Eriovaldo

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2015