If your init parameter AQ_TM_PROCESSES parameter has a value of zero, remove it.
Ensure that your streams_pool_size is configured with a minimum value of 50MB and 128MB would be better then retry the job.
SQL> SHOW PARAMETER streams_pool_size
TO SET THE PARAMETER streams_pool_size
SQL> ALTER SYSTEM SET streams_pool_size=128M
SHUT DOWN & RESTART THE DATABASE
No comments:
Post a Comment