Search notes:

oradebug translate_addr

oradebug translate_addr 0x… translates a memory-address to a symbolic name (such as internal function names).

On Windows, this can be demonstrated with the Symbolic Debugger (cdb.exe):

First, cdb.exe is started and attached to oracle.exe:

C:\> cdb -pn oracle.exe

Then, the (exported) symbols of oracle.exe are displayed with the x command:

0:004> x oracle!*
*** WARNING: Unable to verify checksum for c:\oracle\19\bin\ORACLE.EXE
00007ff7`61755ac0 ORACLE!qxiqitbcr (<no parameter info>)
00007ff7`61755e60 ORACLE!qxiqitbdr (<no parameter info>)
00007ff7`61756120 ORACLE!qxiqitbi (<no parameter info>)
00007ff7`617565e0 ORACLE!qxiqitbd (<no parameter info>)
00007ff7`617569b0 ORACLE!qxiqitbu (<no parameter info>)
00007ff7`61756e80 ORACLE!qxiqitbr (<no parameter info>)
00007ff7`617570d0 ORACLE!qxiqitbs (<no parameter info>)
00007ff7`61757a90 ORACLE!qxiqitbf (<no parameter info>)
00007ff7`61757e50 ORACLE!qxiqitbc (<no parameter info>)
00007ff7`61758030 ORACLE!qxiqitbe (<no parameter info>)
…

I choose any of the displayed functions, for example qxiqitbr. The respective address is 00007ff7'61756e80. So, I look up this address with oradebug:

sys> oradebug translate_addr 0x00007ff761756e80
0x00007ff761756e8 qxiqitbr()

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758198904, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/tools/oradebug/translate_addr/index(59): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78