Oracle Solution for Error ora-01342

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

What triggered 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.

What should we do to fix it:

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