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

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


Cause:


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.



Action:


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