DBMS_METADATA in 10.2
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 01 Aug 2005 22:34:47 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
