Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

One (or more) of the OraSnap reports seems to “hang”. What should I do?

April 26, 2017hang orasnap reports

0

Posted

One (or more) of the OraSnap reports seems to “hang”. What should I do?

1 Answer

0

Posted

Some of the reports can be very time/cpu intensive. Determine which report(s) are hanging and then modify either the snap7.sql or snap8.sql (depending on your version of Oracle) and comment the report out of the script. I’ve identified the reports that are most likely to hang in the scripts. You should also run the DROPTEMP.sql script to clean-up any temp views that were not dropped.