-
Title
What is quest_exec.get_message? -
Description
The following SQL was found running in the background,
begin quest_exec.get_message(:cmd, :peer, :owner, :folder, :script, :spare1, :spare2, :spare3, :spare4, :delay); end;
What is quest_exec.get_message? -
Resolution
The "get_message" is how the Space Manager for LiveReorg client (Windows GUI) communicates to QSA (qexecd).
LiveReorg uses the dbms_pipe package to communicate between the Space Manager client and the server side agent QSA (qexecd). There are various commands contained within the quest_exec package that issue dbms_pipe commands.
"quest_exec.get_message" is a command used by the server side agent. When the server side agent is idle (waiting to start a script or receive a command) it loops and executes "quest_exec.get_message". "quest_exec.get_message" will block waiting for a command from the client. The amount of time "quest_exec.get_message" will wait for a command, is based on what jobs are scheduled.