Re: Error ORA-00055: maximum number of DML locks exceeded

"news" <oscgonesp_at_hotmail.com> wrote:

>Hi
>I have a process that it runs a lot of scripts in cascade.
>One of them when it pass a few minutes, it show this error in log:
>
>ERROR at line 1:
>ORA-00055: maximum number of DML locks exceeded
>ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118
>ORA-06512: at "SYS.DBMS_SQL", line 316
>ORA-06512: at line 35
>
>
>Another error when i run
>
>ERROR at line 1:
>ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
>ORA-06512: at "SYS.DBMS_OUTPUT", line 91
>ORA-06512: at "SYS.DBMS_OUTPUT", line 58
>ORA-06512: at line 30
>
>
>
>Could you help me?
>

The DML_LOCKS parameter can be increased in your init file..But you may wnnt to explore why so many are being used simultaneously.....Also why so much buffer is needed..

Looks like your scripts need debugging...

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Jun 11 2003 - 19:12:06 CEST