Home » Developer & Programmer » Precompilers, OCI & OCCI » Performance issues for PRO*C script (pro*c)
Performance issues for PRO*C script [message #332000] Mon, 07 July 2008 03:50 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Hi All,

I wrote one PRC*C Script.It contains pl/sql block also.Pl/sql will give the error message.While executing the script it tooks around 30 mins.Is it possible to increase the performance of the script.if it is possible please let me know the steps to optimze the script.

Thank you.

Report message to a moderator

Re: Performance issues for PRO*C script [message #332033 is a reply to message #332000] Mon, 07 July 2008 05:24 Go to previous message
Michel Cadot
Messages: 68343
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

You can also have a look at Database Performance Tuning Guide.

Regards
Michel

Report message to a moderator

Previous Topic: How to insert character value into number field?
Next Topic: More infos about insert which calls ODCIIndexInsert?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 31 16:27:05 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.