Re: Tuning for CLOB usage

From: Jan Krueger <jk_at_stud.uni-hannover.de>
Date: Tue, 21 Aug 2007 17:38:34 +0200
Message-ID: <46cb0676$0$29375$4c56b896@news-read1.lambdanet.net>

I would suggest:
1. get an SQL trace of the activity
2. get an DBMS_PROFILER analysis of the activity.

See, where your code actually spends it's time.

Jan

Shakespeare wrote:

>>
>> My question today is: are there some parameters in Oracle that should be
>> examined that might have a significant impact on its ability to
>> effectively handle a greater number of CLOB-related activities?
>>
>> Thanks for your time.
>>
>>
>> --
>> jeremy
>>
>> ============================================================
>> ENVIRONMENT:
>> Oracle 9iR2 / Oracle HTTP Server / mod_plsql / Solaris 8
>> ============================================================
> Received on Tue Aug 21 2007 - 10:38:34 CDT