Oracle Error ORA-01342: LogMiner can not resume session due to inability of staging checkpointed data

Oracle Error Message

ORA-01342: LogMiner can not resume session due to inability of staging checkpointed data

Reason for the Error

Logmnr can not resume session because there is not enough SGA memory available to read in checkpointed data. Logminer periodically checkpoints data to enable faster crash recovery.

Solution

Specify a bigger max_sga for the given LogMiner session and try again.