Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tuning for CLOB usage

Tuning for CLOB usage

From: Jeremy <jeremy0505_at_gmail.com>
Date: Tue, 21 Aug 2007 08:43:00 +0100
Message-ID: <MPG.2134a7cf411c64e798a493@news.individual.net>

Oracle 9iR2

We have recently implemented a new way of generating web pages from our app (mod_plsql) which involves storing the basic page template in a CLOB and then replacing "place holders" with data from the application's tables.

We have noticed that, since using this new approach, the execution time has increased significantly. When there is some concurrency, as each call is taking longer to execute, we are finding that the server is running low on resources occasionally maxing out on sessions.

As I see it there are three possibilities:

1) make the code more efficient
2) tune Oracle 
3) allocate more hardware

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 - 02:43:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US