A session-specific partition filter can be set to read log records only from a specific partition.
About this task
The setting for the partition filter applies only to the current session and is valid for all reads from SYS_LOG that are started after the setting. The partition data is
stored in the SYS_FEDT_DB_PARTITION system table.
Procedure
▪Set partition filters with the following statement:
SET LOGREADER PARTITION { <partition-name> | NONE }
When set to NONE (default), all log records are read.
▪View the existing partitions in the SYS_FEDT_DB_PARTITION system table with a SELECT statement.