Home » Developer & Programmer » Precompilers, OCI & OCCI » Using OCI with ProC
icon5.gif  Using OCI with ProC [message #120598] Fri, 20 May 2005 13:04 Go to next message
rafaelb
Messages: 2
Registered: May 2005
Junior Member
Hi,

Could anyone answer to me if it is possible to use OCI and ProC at the same application. For example, the connection and most of the database access is done with ProC and only some queries with OCI ?

Thanks,

Rafael.
Re: Using OCI with ProC [message #120608 is a reply to message #120598] Fri, 20 May 2005 15:21 Go to previous messageGo to next message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member

Hi,

technically it's possible but you wouldn't want to. You should consider the ProC environment to be encapsulated.

The ProC/OCI hybrid would have to maintain two environments which saves you neither development time or runtime effeciency.

Most work you would want to perform can be undertaken in ProC so stay with it.

If you need to use OCI, do all your work using oci.

Have you considered working with OTL? Try http://otl.sourceforge.net/home.htm This combines OCI with an easy to use C++ wrapper interface.

Kind regards,
Michael Hartley, http://www.openfieldsolutions.co.uk
Re: Using OCI with ProC [message #120616 is a reply to message #120608] Fri, 20 May 2005 16:14 Go to previous messageGo to next message
rafaelb
Messages: 2
Registered: May 2005
Junior Member
Hi Michael,

My actual problem is:
I'm current working in a very big system that uses only ProC to do all the operations in the Oracle database.
But I know some queries that are very slow and I want to convert only this queries to OCI, because there are so many queries in the system.
Now, that you know my problem a little better, do you think that the best solution is trying OTL ? But in this case I will need to replace all the database access ?

Thanks,

Rafael.
Re: Using OCI with ProC [message #120651 is a reply to message #120616] Sat, 21 May 2005 15:55 Go to previous message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member

Hi,

ProC itself isn't necessarily your performance bottleneck. Rather the performance of your ProC application may be affected by database performance.

Have you performed any SQL query performance analysis? You should start by looking for missing indexes, lack of database tuning, then examine alternative ways of generating the same query results. Try profiling the ProC sessions and "plan out" the longest running queries using tkprof.

When looking for bad queries and views I would recommend you start by looking at high disk access queries, then high cpu queries.

Kind regards,
Michael Hartley, http://www.openfieldsolutions.co.uk

Previous Topic: Oracle Network or Shared Library Files
Next Topic: Lock problem without explanation
Goto Forum:
  


Current Time: Wed Dec 07 04:18:27 CST 2022