What are the differences between static and dynamic registrations in Oracle?
On your database server, you have a program called the Oracle Listener. The job of the Listener is to listen for database connection requests (normally from outside the database server) and pass those requests on to the instance. Before the Listener can pass a request to an instance, the instance must be registered with the Listener. You can explicitly state the instance information (called static registration) by updating the listener.ora configuration file. Or, the instance's PMON process can contact the Listener and pass on the information automatically. When PMON performs this activity, it is called dynamic registration. This Oracle doc shows the
details on both registration methods
Dig Deeper on Oracle DBA jobs, training and certification
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.