oracle slow updates and inserts coldfusion

[fang]

Hi, I can do simple select statements without a problem like: select id from
xyz But, when I do insert or update statements, the Cold Fusion page just
keeps running and never returns, and the webserver's CPU usage goes to 100%.
However, after a few minutes, I can see the value updated in the database. I
am using ColdFusion MX and Oracle 8i Enterprise Edition Release 8.1.7.0.0.
Does anybody have any ideas? Thanks.

[paross1]

You might want to search the knowledge base for your particular version of
Oracle, MX, Data Direct, etc., as there are many different problems with
similar symptoms. One that looks kind of familiar is this one.

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18807[/url]

But, like I said, many different problems and fixes.

Phil

[sdupre]

Did you get around your 100% CPU problem? What version of ColdFusion are you
running? 6.1 or 7.0? Are you using Oracle thin? (I know you said Enterprise
but you didn't say whether you're using the built-in drivers). Do you use
CLOBs? What is your NLS_Characterset (select * from sys.props$) Stephen Dupre
Macromedia QA

[Unregistered]

Did you find a solution for this problem?