Re: dbms_stats.gather_schema_stats does not finish.

I got the root cause:

Corrupt block relative dba: 0x0527795e (file 20, block 2586974) We will provide the solution.

Thanks.
Eriovaldo

2015-11-17 13:04 GMT-02:00 Dominic Brooks <dombrooks_at_hotmail.com>:

> 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 <knecht.stefan_at_gmail.com>
> Sent: ‎17/‎11/‎2015 12:24
> To: ecandrietta_at_gmail.com
> Cc: ORACLE-L <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