Wolfson Larry - lwolfs wrote:
Analyzing data dictionary might help, if the oracle version allows it. How do you know that this is theThis statement appears to be killing our performance.
What's going on and is there anything we can do about it?
groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
-- Mladen Gogala Oracle DBA Ext. 121