Using the Save to Repository generates the following error:
Error
The following unhandled error has occurred:
Out of memory
To report this problem to our Support team, a Support bundle needs to be created to log all the information related to this error.
The memory is notmanaged effectively when the Save to Repository is invoked.
When saving SQL to the Repository, the whole job is scanned for SQL, Execution Plans retrieved and finally stored in a temp file to be sent to the Repository.
Although the temp file will be freed once completed, it can consume quantities of space when is large amount of SQL or when the SQL/Plan is enormous.
WORKAROUND:
Try limiting the SQL captured in Inspector. A good option would be is to ignore the Oracle internal SQL.
STATUS:
Waiting for fix in a future version of Quest SQL Optimizer for Oracle.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center