Some of the processes that depend on shared table instances , can experience a dramatic differences in performance, in case all of the instances available are being used, or remaining locked by some orphan or failed process. One way to resolve this problem is to go online and check if tables should be “released”. Here [...]
Entries Tagged as 'Performance'
Non-Shared Temp Tables Cleanup
March 7th, 2008 No Comments
Tags: PeopleSoft · Performance · SQL · Tips