Ora-1461 Encountered When Generating Server Alert Smg-3500

1. To fix these Bug 6085625 and unpublished bug 6452485, The fixes for these two bugs are now available as Patch 6602742 or Patch 6602482 .

2. Workaround
A. Flushing the shared pool can help remove the problem cursor from the shared pool.
B. Using SESSION_CACHED_CURSORS = 0