>Hi!
>
>>In Oracle, I think you may try to adjust the value of SHARED_SPOOL_SIZE and
>DB_BLOCK_BUFFERS.
>
>How I can do this? Can you post a sample of PL/SQL command for this, or tell where to go to configure these values?

Hi Vlad,

It's in the database initialization parameter file - init???.ora.
The database is required to restart after the changes have been made.

But I've read the Oracle doc., the PL/SQL block size limitation is around 32K.
And Oracle's suggestion is breaking it into sub-blocks, like this:
BEGIN
BEGIN
INSERT INTO vfp_test1 VALUES ('testing');
END;
BEGIN
INSERT INTO vfp_test2 VALUES ('testing');
END;
......
...
commit;
END;

Just curious, why it can be done by SQL pass-thought.