Gather schema statistics occupies huge TEMP space without releasing it
Last updated on SEPTEMBER 18, 2008
Applies to:Oracle Server - Enterprise Edition - Version: 126.96.36.199
This problem can occur on any platform.
o When "Gather Schema Statistics" program runs, it uses huge space in the TEMP tablespace.
o Temp space is not released until the request gets completed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms