Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
find file_id or block_id from data block address

find file_id or block_id from data block address

2005-12-27       - By oracle-l-bounce@(protected)

Reply:     1     2     3     4     5     6  

Prem

A small correction about my last post...

>IMO in 7.3 the file number part of the DBA is 8 bits (from 8.0 it
>is 10 bits). Therefore the correct file number is 32 (not 128).

7.3 supported 1022 files. Therefore 10 bits are reserved for the file number in
the RDBA. The difference is the position... In fact the high order bits of the
file number are stored after the low order bits. The exact number of high/low
order bits is platform specific, in my previous guess I took 8 for the low
order part and, therefore, 2 for the high order part, i.e. something like that
"LL LL LL LL HH".

E.g. in your case:

Decimal: 537037017
Binary: 0010 0000 0000 0010 1000 1000 1101 1001
File Number: 0010 0000 00 --move high order bits--> 00 0010 0000 --> 32
Block Number: 00 0010 1000 1000 1101 1001 --> 166105

This means that with less than 256 files, the high order byte stores the file
number.


HTH
Chris
--
http://www.freelists.org/webpage/oracle-l