Home » RDBMS Server » Performance Tuning » Does using dbms_lob package improve performance
Does using dbms_lob package improve performance [message #240259] Thu, 24 May 2007 08:32 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using 10g release of Oracle .

I am using clob data inside a package and I am printing it . I am also doing certain manipulations on the same like substr and instr .

Will using dbms_lob package functions like instr,read,getlength improve peformance or can i use normal string functions itself on the clob type

The clob type normally is used to print xml data which is huge .

Pls suggest which one would be better for performance .
Re: Does using dbms_lob package improve performance [message #240274 is a reply to message #240259] Thu, 24 May 2007 09:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In 10g, you can use standard character function on CLOB.

Regards
Michel
Re: Does using dbms_lob package improve performance [message #240284 is a reply to message #240274] Thu, 24 May 2007 09:40 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
Yes from 10g onwards we can manipulate clob as strings .

My question was which will be performance efficient ?
Re: Does using dbms_lob package improve performance [message #240312 is a reply to message #240284] Thu, 24 May 2007 10:39 Go to previous message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As possible. You always have to scan the string.

Regards
Michel
Previous Topic: UL locks in Oracle Workspace Manager
Next Topic: Stress Oracle & OAS
Goto Forum:
  


Current Time: Thu May 16 14:20:57 CDT 2024