My laptop did 500meg without any problemsģ dbms_output.put_line(rpad('x',1000,'x')) They might be getting an error, but I'd be surprised if its the SAME error. After all.who is going *read* all that output? So if you do 10,000 dbms_output calls with 1000 bytes in each, you'd expect to consume (approx) 10,000,000 bytes of memory for that session.Įventually.presumably you'll run out of process and/or server memory - at which point you'd have to ask yourself if that's really a practical use for dbms_output. ![]() ![]() "As there is no performance penalty, use UNLIMITED unless you want to conserve physical memory."īasically we are simply just going to consume memory (because we simply hold all the messages in a buffer until the call finishes).
2 Comments
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |