The dbms_lob.createtemporary function takes three parameters, one of which specifies if the temporary LOB is to be "read into buffer cache or not". I'm not entirely clear on what that means. More importantly, when do i want my LOB in the buffer cache and when do I not want it there?
Asked
Active
Viewed 2,997 times
7
eaolson
- 14,717
- 7
- 43
- 58
2 Answers
5
Basically if the same lob is going to be accessed several times, it will improve performance if the lob is in the cache.
see: http://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_tables.htm
From the link above 'Using the CACHE option results in improved performance when reading and writing data from the LOB column. However, it can potentially age other non-LOB pages out of the buffer cache prematurely.'
Kevin Burton
- 11,676
- 2
- 24
- 37
2
In simple words, that means to be in memory. I don't know how much stays there, but almost sure is put there at creation. Learn here some concepts.
Florin Ghita
- 17,525
- 6
- 57
- 76