ALTER TABLE <table name> MODIFY LOB("<column name>") (CACH

[ddrillich]

Good Day,

We got a recommendation from the software vendor to perform the following change on the DB:

ALTER TABLE IKS_BINARYDOCUMENT MODIFY LOB("IKS_CONTENTDATA") (CACHE)

ALTER TABLE IKS_ASCIIDOCUMENT MODIFY LOB("IKS_CONTENTDATA") (CACHE)

These are pretty large tables -

SQL> select count(*) from ikmapp.IKS_BINARYDOCUMENT;

COUNT(*)
----------
1142049

SQL> select count(*) from ikmapp.IKS_ASCIIDOCUMENT;

COUNT(*)
----------
227680


What does this change do? Does it place a certain column in memory?


Regards,
Dan

 

[engineer2100]

is the IKS_CONTENTDATA column a Large Object (LOB)? If yes, then the ALTER would bring the LOB Data into Memory but I have this feeling that this might bring the system to its knees if you do

SELECT * FROM IKS_BINARYDOCUMENT

or

SELECT * FROM IKS_ASCIIDOCUMENT

-Engi