Q&A Session for the Advisor Webcast "How To Configure and Debug External Procedure Issues" delivered
Q: EXTPROC_DLLS=NULL means $ORACLE_HOME/lib on linux/unix but %ORACLE_HOME%\bin on windows ??
A: Yes, correct. If this value is set to NULL it means EXTPROC agent can load shared libraries or DLL's from $ORACLE_HOME/lib folder in case of Unix/Linux and from
$ORACLE_HOME/bin folder in case of Windows.
Q: How long time does a context switch from PL/SQL to/from C take?
A: It’s in terms of nano seconds only, don’t take much time for this context switching.
Q: And is this context swapping faster with java than C?