Or look at ASH (subject to license restriction).
Columns Plsql_object_id / program_id/entry_object_id/program_id can help
identify your session/s
Sent from my Windows Phone
________________________________
From: Stefan Knecht<mailto:knecht.stefan@xxxxxxxxx>
Sent: 17/11/2015 12:24
To: ecandrietta@xxxxxxxxx<mailto:ecandrietta@xxxxxxxxx>
Cc: ORACLE-L<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: dbms_stats.gather_schema_stats does not finish.
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