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: 359
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: 21459
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 Nov 22 12:03:55 CST 2008

Total time taken to generate the page: 0.00666 seconds
.:: Forum Home :: Blog Home :: Wiki Home :: Contact :: Privacy ::.