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.
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: 64152
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
Previous Topic: How to insert character value into number field?
Next Topic: More infos about insert which calls ODCIIndexInsert?
Goto Forum:
  


Current Time: Sat Dec 10 20:17:46 CST 2016

Total time taken to generate the page: 0.09723 seconds