...................[@more@]Re: Oracle 10.2.0.2 and TOAD brings ORA-600

by Ronald Breuer Mar 17, 2006; 05:13pm :: Rate this Message: (use ratings to moderate[?])

Reply | Reply to Author | View this Message in the Context of Discussion

Hello John,

I guess there are a lot of problems switching the Data Dictionary from
RBO to CBO.
There are a lot of Hidden Parameters starting with "_optimizer" in 20.2.
See: http://www.orafaq.com/parms/index1020.htm

If you search in MeataLink you will find several BUGs with ORA-600 and
Workarounds setting Hidden Parameters.

I guess it is not a good idea set the Hidden Parameters globally like
ALTER SYSTEM SET "_optimizer_push_pred_cost_based"=FALSE SCOPE=BOTH;
The result could be a performance problem for the 'normal' applications.

May be it is a good idea to add a "startup_TOAD.sql" to each connection
in the Database Login Window.
So you can run all the tricky Oracle Workarounds like
ALTER SESSION SET "_optimizer_push_pred_cost_based"=FALSE
at the begin of a TOAD session.

Kind regards
Ronald

On 16.03.2006 19:02 John Dorlon wrote:
> I was able to reproduce this on 10.2.0.1.
>
> I have found that if I put DBA_OBJECTS in the from clause before
> DBA_TYPES, the error goes away, so I will change the query in toad
> (but the 600 error is still an oracle bug!)
>
> The change will be in the next toad beta (not today's beta, if there
> is one, but the one after that).
>
> -John
>
>
> -----Original Message-----
> From: toad@... [mailto:toad@...]On Behalf Of
> Ronald Breuer
> Sent: Thursday, March 16, 2006 4:47 AM
> To: toad@...
> Cc: John Dorlon
> Subject: [toad] Oracle 10.2.0.2 and TOAD brings ORA-600
>
>
> Hello,
>
> yesterday I setup a 10.2.0.2 Standard Edition.
> I connected with TOAD 8.6 and use the SB to check an imported schema.
> After that I found in the alert.log
>
> Wed Mar 15 11:23:25 2006
> Errors in file /array1/oracle/admin/isobela2/udump/isobela2_ora_10573.trc:
> ORA-00600: internal error code, arguments: [15160], [], [], [], [], [],
> [], []
>
> the trace file looks like
> *** ACTION NAME:() 2006-03-15 11:23:25.816
> *** MODULE NAME:(TOAD 8.6.0.38) 2006-03-15 11:23:25.816
> *** SERVICE NAME:(hostname.entimo.biz) 2006-03-15 11:23:25.816
> *** SESSION ID:(149.8) 2006-03-15 11:23:25.816
> *** 2006-03-15 11:23:25.816
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [15160], [], [], [], [], [],
> [], []
> Current SQL statement for this session:
> Select o.object_name, o.object_type, o.status, t.typecode, t.attributes,
> t.methods
> from SYS.DBA_TYPES t, SYS.DBA_OBJECTS o
> where o.owner = :own
> and o.owner = t.owner
> and o.object_type = 'TYPE'
> and o.object_name = t.type_name
> and o.subobject_name is null
> ----- Call Stack Trace -----
>
> I open a SR and Oracle say:
>
> The cause of this problem has been identified in Bug 4648181. It is
> fixed in 11.1 rel.
>
> To implement the solution, please execute the following steps:
>
> 1. Check if there's a patch for 10.1 or 10.2 for your platform
> available in Metalink.
>
> 2. Use the workaround:
> alter session set "_optimizer_push_pred_cost_based"=FALSE;
>
> There's no one-off patch available for 10.2.0.2 and if you want to
> request a one-off will be necessary to:
>
> 1 - Reproduce the error without TOAD (using SQLPLUS)
> 2 - File a Business Case
>
> I did so.
> May be some one else can open a SR for the same issue to force the
> one-off patch.
>
> Kind regards
> Ronald

ITPub博客

Re: Oracle 10.2.0.2 and TOAD brings ORA-600

最新文章