>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement