RE: dbms_stats.gather_schema_stats does not finish.

From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Tue, 17 Nov 2015 15:04:03 +0000
Message-ID: <DUB404-EAS329DDE28EBB2C6DFD4F20D5A11D0_at_phx.gbl>

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_at_gmail.com> Sent: ‎17/‎11/‎2015 12:24
To: ecandrietta_at_gmail.com<mailto:ecandrietta_at_gmail.com> Cc: ORACLE-L<mailto:oracle-l_at_freelists.org> 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_at_gmail.com> 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
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 17 2015 - 16:04:03 CET