Which two statements are true about the extproc process?

Which two statements are true about the extproc process? (Choose two.)

Which two statements are true about the extproc process? (Choose two.)

A.
It loads the dynamic library.

B.
It is started by the server process.

C.
It converts the C output back to PL/SQL.

D.
A single extproc process serves all user sessions.

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

PIERO

PIERO

OPS
A , C

Loading External C Procedures
Note:
You can load external C procedures only on platforms that support either DLLs or dynamically loadable shared libraries (such as Solaris .so libraries).
When an application calls an external C procedure, Oracle Database or Oracle Listener starts the external procedure agent, extproc. Using the network connection established by Oracle Database or Oracle Listener, the application passes the following information to extproc:

Name of DLL or shared library
Name of external procedure
Any parameters for the external procedure
Then extproc loads the DLL or the shared library, runs the external procedure, and passes any values that the external procedure returns back to the application. The application and extproc must reside on the same computer.

extproc can call procedures in any library that complies with the calling standard used. For more information about the calling standard, see CALLING STANDARD.

Note:
The default configuration for external procedures no longer requires a network listener to work with Oracle Database and extproc. Oracle Database now spawns extproc directly, eliminating the risk that Oracle Listener might spawn extproc unexpectedly. This default configuration is recommended for maximum security.
You must change this default configuration, so that Oracle Listener spawns extproc, if you use any of the following:

A multithreaded extproc agent

Oracle Database in shared mode on Windows

An AGENT clause in the LIBRARY specification or an AGENT IN clause in the PROCEDURE specification that redirects external procedures to a different extproc agent

Changing the default configuration requires additional network configuration steps.

Reply