Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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.
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: 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
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) ] [ ]

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 ::.