If you enable sql trace for the session, does it show any activity in the
trace file?
You can use dbms_monitor.session_trace_enable and session_trace_disable to
comfortably enable them.
Stefan
On Tue, Nov 17, 2015 at 5:39 PM, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
wrote:
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