find file_id or block_id from data block address 2005-12-26 - By Prem
Hi Tanel , Thanks a lot for your reply.
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)
sys.dbms_utility.data_block_address_block(537037017) = 166105
sys.dbms_utility.data_block_address_file(537037017) = 128
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.
>>Tanel.
--
http://www.freelists.org/webpage/oracle-l
|
|
