There is an item on my web-site under
"The Book (errata)" -> Chapter 17 Handling Large Objects
that may be relevant
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
____UK_______March 19th
____USA_(FL)_May 2nd
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Bob wrote in message ...
>I am trying to use temporary LOB to store texts. When I am
manipulation with
>LOB I can see some IO spikes on server from 50 to 100 % of IO.
According to
>Oracle documentation V$TEMPORARY_LOBS view should give me enough
information
>but I couldn't find any description of the columns. Can someone point
me to
>any resource that describes LOB and monitoring of about
memory/resource
>utilization. Can someone tell me how to interpret
CACHE_LOBS,NOCACHE_LOBS
>numbers.
>Thanks in advance for any suggestions
>Bob
>
>
Received on Thu Feb 13 2003 - 05:08:14 CST
