Oracle Addr

Written by Kimberly Clark
Bookmark and Share

The term "ADDR" is used to denote the address of a process that occurs in an Oracle database. It is an invaluable tool for troubleshooting the database as it can be used to pinpoint exactly where problems are occurring within the database. This can either be accomplished by executing preloaded Oracle scripts or by running those that were custom written by the database administrator.

One of the primary functions of Oracle ADDR is to retrieve information from the database. The tool has the ability to tell the user or troubleshooter exactly where the process they are searching for occurs. Hence, if there is a problem in the system it can be used to notify the user or troubleshooter of exactly where it occurs.

It is a standard part of the v$process table, a function that is used to monitor and display all the processes that are connected to the database. Plus, the ADDR function can be used to obtain the IP address of the system. The function can also be used to publish information to a particular location, this could include pushing data to a website or to another application.

Killing the Process

The Oracle ADDR function can also be used to locate the instance and the SPID (system process id) of the background processes and individual Oracle sessions. This is information can be quite handy if there is ever a need to end a particular process, because killing the ORACLE.EXE process could possible crash the entire database. ADDR is frequently used interchangeable with the term PADDR.

Bookmark and Share