DBMS_METADATA in 10.2

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 01 Aug 2005 22:34:47 +0000
Message-Id: <1122935687l.4072l.0l@medo.noip.com>

DBMS_METADATA in 10.2 returns interesting results in alert log. Metalink, of course, doesn't even list 10.2 among the versions with patches, which probably means that 10.2 is bug-free. I cannot open a TAR as the company that I work for doesn't have any 10.2 databases and I doubt that my boss would be thrilled by my opening a TAR for my home database. How do I tell oracle that they have a problem with 10.2?

Mon Aug 1 18:11:33 2005
Errors in file /oracle/product/10g/admin/10G/bdump/10g_s000_3981.trc: ORA-00600: internal error code, arguments: [1234], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [729], [69008], [space leak], [], [], [], [], []

Here is the detail from the trace file:

INSTANTIATION OBJECT: object=0x28bbe458
type=""[92] lock=(nil) handle=(nil) spec=0x2ff38a1c level=-923109122 flags=SHR/BDY/NBD/CGA/[28bb] executions=1 sqltxt(0x324cb56c)=select dbms_metadata.get_ddl('TABLESPACE',tablespace_name) SQL

      from dba_tablespaces 
      where tablespace_name !='SYSTEM' 
      and tablespace_name like upper(:PATT)
      order by contents,tablespace_name

  hash=60a071a8c83b5d57d3d3734caaf854a6
  parent=0x2ff9b7fc maxchild=01 plk=0x3071fb58 ppn=n cursor instantiation=0x28bbe458
child#0(0x32609778) pcs=0x2ff9ba00
  clk=0x30784a7c ci=0x2ff38a1c pn=0x307bf110 ctx=0x2fbbba90 kgsccflg=0 llk[0x28bbe45c,0x28bbe45c] idx=0 xscflg=c0110476 fl2=5200009 fl3=52222008 fl4=0 Frames pfr 0x28bba578 siz=7100 efr 0x28bba5c0 siz=6724

 kxscphp  0x28bc39f8 siz=1000 inu=976 nps=668
 kxscdfhp 0x28bc3e18 siz=1000 inu=56 nps=0
 kxscehp  0x28bc3974 siz=1000 inu=116 nps=44
 kxscwhp  0x28bc3b00 siz=12220 inu=10024 nps=400

--

Mladen Gogala
http://www.mgogala.com

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 01 2005 - 17:36:43 CDT