Stops the transmission of log records on active Logreader connections.
When this command is run, the active Logreader applications reach the end of the result set (SQLSTATE 0200, No data found) when fetching the next row of the SYS_LOG table.
If the form LOGREADER STOP or LOGREADER STOP ALL is used, all log record transmissions are stopped. If partition_id is specified, the command affects only the Logreader operation on that partition.
To access the log again, the application must reconnect. The log reading can be resumed without any loss of information if the last read position is known. If the SYS_LOG table is accessed without specifying the log position, the reading starts from the live data.
Important The stopping of the log transmission is effective immediately, regardless of the fact that there might be records in the log that are awaiting transmission.
If the server is running in relaxed durability mode (default), do not execute LOGREADER STOP before all the appropriate records are written to the log. With the default logging settings, it is safe to wait for 5 seconds after the last write operation.