- Article Type: General
- Product: Aleph
- Product Version: 20
- Relevant for Installation Type: Dedicated-Direct; Direct; Local;
Sometimes SQL queries across libraries -- such as item ADM queries getting title information from the bib library via the Z103 -- will run for 1/2 hour or and hour and then get an error such as:
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
snapshot too old: rollback segment number 2 with name 'R01' too small
We have found that, in some cases, changing:
improves the performance dramatically.
Also, adding "DYNAMIC SAMPLING", as described in KB 16384-25265 (see link in Additional Information below).
KB 16384-25265: SQL queries slow in Aleph 18-up **MASTER record**
Category: System management
- Article last edited: 10/8/2013