Locks of type ST - space management

Hi:

        How many locks of type ST (space management) can exist in the database? Does this lock type serialize transactions under high load? This is a followup to the ORA 1575 (timeout occurred waiting for space management resource). It seems like it is waiting for a lock of type ST that is held in exclusive mode by other xns at that time.

        I was wondering if increasing enqueue resources would help among other steps such as making pctincrease 0 on temp tablespaces, making initial extent in temp tablespaces larger and making sort_area_size larger.

        is there any documentation on how many locks of a given type can exist?

thanks a lot,

-Badri Received on Mon Apr 13 1998 - 14:53:37 CDT