Re: Anyone dealt with address not mapped to object errors?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 15 Oct 2000 09:54:52 +0100
Message-ID: <971600608.824.0.nnrp-10.9e984b29@news.demon.co.uk>

Kai,

I have seen this fairly frequently on 8.1, and it usually seems to occur when Oracle
calls an 'old' optimisation path with a
'new' Oracle feature. For example a
'parallel fast full scan' being applied to an index, which happens to be an
Index Organized table.

If you are getting the error on a small number of specific statements, you could try putting in different hints to choose a path, and see if this (a) makes the problem go away, and (b) identifies the combination of object and access path that causes the problem.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Kai Regi wrote in message <39E8B98E.51BF202_at_rs.ee>...


>Hi, Dave

>

>I can't find this initialization parameter cursor_sharing anywhere in the

 docs.


>V$parameter view shows no rows either.

>Do I miss something, it should be listed in Oracle8i Reference? What value

>should I use instead of FORCE?

>Anyway, I have same problem with Oracle 8.1.5 on Sun and I am looking for

>solutions.

>

>Kai

>

>Dave A wrote:

>

>> No, as it turned out the problem was being caused by the init.ora

 parameter


>> curshor_sharing=FORCE.  Once turned off the problem went away.

>>

>

Received on Sun Oct 15 2000 - 03:54:52 CDT