Re: ORA-1575 error

Hi Joe,

The ST enqueue has long been a potential source of contention and serialization, particularly for parallel segment creation operations. The standard mitigations are to avoid the use of a PERMANENT tablespace for sorts, or to avoid disk sorts entirely with a large sort_area_size, and to use a fixed extent size policy on all data tablespaces. The locally managed tablespace feature in 8i should also be adopted if possible. There is also a bit more information in the "Planning Extents" tip on my web site (1st URL below).

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.net.au/

On Tue, 01 Feb 2000 15:47:30 GMT, joe_celko_at_my-deja.com wrote:

>We are getting ORA-1575 errors ("Oracle has timed out waiting to
>acquire the Space Transaction enqueue lock") in Oracle 8 on a Sun. This
>is happening with simple loads, Navigator and IQ for ad hoc queries
>
>I will post the details of the system configuration shortly, but it is
>a good sized Sun with a Raid 5 disk array -- space should not be a
>problem. Are other people are getting the same error? Does somceone
>have a solution?
>
>--CELKO--
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Feb 01 2000 - 19:09:22 CST