Hi,
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@xxxxxxxxxxx>:
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@xxxxxxxxx>
Sent: 17/11/2015 12:24
To: ecandrietta@xxxxxxxxx
Cc: ORACLE-L <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