abbyabby
asked on
Periodical error on running a stored procedure
I've got the following error periodically on running a stored procedure, but
1. the same error have never occurred in running other stored procedures.
2. the duration of running this stored procedure is 5 to 10 minutes, while others are around one to two minutes.
3. the fault rate is 5%.
4. The stored procedures was running successfully in parallel with it when this error occurred.
5. My Oracle Server is 8.1.7 Personal Edition.
6. My Server is Windows 2000 Professional SP3.
7. My Client is Windows 2000 Professional SP4.
*** 2003-11-12 04:04:22.453
*** SESSION ID:(17.9940) 2003-11-12 04:04:22.343
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-11-12 04:04:22.484
ksedmp: internal or fatal error
1. the same error have never occurred in running other stored procedures.
2. the duration of running this stored procedure is 5 to 10 minutes, while others are around one to two minutes.
3. the fault rate is 5%.
4. The stored procedures was running successfully in parallel with it when this error occurred.
5. My Oracle Server is 8.1.7 Personal Edition.
6. My Server is Windows 2000 Professional SP3.
7. My Client is Windows 2000 Professional SP4.
*** 2003-11-12 04:04:22.453
*** SESSION ID:(17.9940) 2003-11-12 04:04:22.343
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-11-12 04:04:22.484
ksedmp: internal or fatal error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I recommend two measures:
1. Migrate to Enterprse edition
2. Increase the buffer cache size (db_buffers parameter in init<sid>ora)
3. Increase the size of online redo logs files. This can be done dropping the groups and creating new one with big size.