Re: What is this doing for me?

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: lawrence.wolfson@xxxxxxxxxx
  • Date: Wed, 17 Aug 2005 12:08:42 -0400

Wolfson Larry - lwolfs wrote:

This 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


Analyzing data dictionary might help, if the oracle version allows it. How do you know that this is the
statement that is killing your performance? May be increasing shared pool would help? What kind
of waits are you encountering?

Mladen Gogala
Oracle DBA
Ext. 121


Other related posts: