11gr2: Core dump while using VPD predicate containing certain sub-queries (Doc ID 1193346.1)

Last updated on NOVEMBER 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

  Oracle Database Server crashes during VPD policy expansion when certain type of sub-queries (e.g. connect-by query) are used as VPD  predicates.

 ssexhd()+1885 call ksedmp() 44F ? 0 ? 1 ? B765B708 ?
 1000 ? 1 ?
 kzpchkbu()+21 signal 00000000 B ? B765BC90 ? B765BD10 ?
 kzrtzck()+186 call kzpchkbu() 0 ? 0 ? 0 ? BFFF3154 ? 0 ?
 0 ? 35 ?
 kkmpqaq()+4627 call kzrtzck() BFFF6A7C ? B72C0BE4 ?
 __PGOSF158_kkmpqcbk call kkmpqaq() BFFF3CFC ? B72C16CC ?
 ()+57
 qcspqbDescendents() call 00000000 BFFF3CFC ? 102DD4C0 ?
 +1053 B72C16CC ? 4 ?
 qcspqb()+171 call qcspqbDescendents() BFFF3CFC ? 102DD4C0 ?
 B72C16CC ?
 qcspqbDescendents() call qcspqb() BFFF3CFC ? 102DD4C0 ?
 +2867 B72CF030 ?
 qcspqb()+171 call qcspqbDescendents() BFFF3CFC ? 102DD4C0 ?
 B72C07AC ?
 qcsevw()+404 call qcspqb() BFFF3CFC ? 102DD4C0 ?
 B72C07AC ?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms