Unanswered: ORA-1575 Timeout waiting for Space Management
I'm working with an Oracle7, version 126.96.36.199 and hp-ux 10.20.
I'm getting this message too frecuent.
I read that the 1575 error is usually reported by SMON if there is heavy demand fo the 'ST' enqueue.
The PCTINCREASE = 0 and the sort_area_size=50MB
My questions are:
1) how can I see if there is some contention with the ST enqueue?
2) What size should the initial and next extent of the temporary tablespace be? Note that this tablespace is a permanent tablespace.
3) Should I cheat the SMON process adding this line to the init.ora file:
event="10268 trace name context forever, level 10" ?