Re: ORA-1575 error

Are these error being reported to the front-end, or simply appearing in the alert log ? In the latter case they can be ignored.

Judging from the mix of Loads plus ad hoc query tools I would suspect that you need to configure your temporary space and general extent allocation.

The conflict is probably between space allocation to load (increase the size of initial/next extents on the objects being loaded) and space allocation for sorting (use a tablespace with contents of type TEMPORARY as the user's 'temporary_tablespace' in Oracle 8.0; or a proper temporary tablespace in Oracle 8.1 - in either case set a reasonable size of extent).

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

joe_celko_at_my-deja.com wrote in message <876v6g$jqp$1_at_nnrp1.deja.com>...
>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 - 15:32:44 CST