I started this thread to investigate the following error in our v7.3.4 PROD database alert log. ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [12700], [537037017], [5], [], [], [], [], []
Metalink doc says that the second argument is the data block address. We don't have the packages you said on our PROD database. And
SELECT SEGMENT_NAME, SEGMENT_TYPE, OWNER FROM SYS.DBA_EXTENTS WHERE 537037017 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
This did not give me any result. My doubt is whether we can put the data block address ( 537037017) in the above query !!! Is that right ?
I also tried the following in another database which has got the packages you said : (is it okay to execute the below on any database which has got those packages or is it to be done on the problem database only)
With the above results , on the PROD database i tried :
SELECT SEGMENT_NAME, SEGMENT_TYPE, OWNER FROM SYS.DBA_EXTENTS WHERE FILE_ID = 128 AND 166105 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
which gave me no results.
Is there any other way i can find out the file_id / object# from the above ORA-600 (See ORA-600.ora-code.com) error. The trace file too did not give me any pointer about the file# or object# .
This being the case, how do i find which is the object in problem ? Can you help me on this ?
Thanks and Regards, Prem J.
Tanel Wrote : >>Hi,
>>In newer versions, there are two functions under dbms_utility.data_block_address_block >>and data_block_address_file.dbms_utility.make_data_block_address works the other way >too. If 7.3.4 doesn't have those functions, you could just use a newer db version for >>doing the calculations.
