Home » SQL & PL/SQL » SQL & PL/SQL » how can increase the performance of existing procedure?
how can increase the performance of existing procedure? [message #443132] Fri, 12 February 2010 23:08 Go to next message
ranjan.t
Messages: 1
Registered: November 2007
Location: india
Junior Member
Hi all,

how can increase the performance of existing procedure?
and
what are the new features in oracle10g
Re: how can increase the performance of existing procedure? [message #443133 is a reply to message #443132] Fri, 12 February 2010 23:25 Go to previous messageGo to next message
BlackSwan
Messages: 24903
Registered: January 2009
Senior Member
>how can increase the performance of existing procedure?
Make SQL more efficient

http://download.oracle.com/docs/cd/B14117_01/server.101/b10750/toc.htm

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: how can increase the performance of existing procedure? [message #443135 is a reply to message #443132] Fri, 12 February 2010 23:30 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
without lookking into your procedure no one will help you.
Have a look at the sticky in performance tuning topic in this forum.And for new features in 10g have a look at the documents in OTN (www.tahiti.oracle.com).

sriram Smile
Re: how can increase the performance of existing procedure? [message #443144 is a reply to message #443132] Sat, 13 February 2010 00:36 Go to previous messageGo to next message
Blaylock
Messages: 6
Registered: February 2010
Location: USA
Junior Member
Setup a copy of your application locally, enable the mysql query log, and setup xdebug or some other profiler. The start collecting data, and testing your application. There are lots of guides, and books available about how to optimize things. It is important that you spend time testing, and collecting data first so you optimize the right things.
Re: how can increase the performance of existing procedure? [message #443176 is a reply to message #443144] Sat, 13 February 2010 04:59 Go to previous message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Blaylock wrote on Sat, 13 February 2010 06:36
enable the mysql query log


You realize this is an oracle forum right?
Previous Topic: Sql query data to filter in the week & Monthly wise
Next Topic: how to re write the update statment if high volume records are there
Goto Forum:
  


Current Time: Sun Sep 25 06:09:18 CDT 2016

Total time taken to generate the page: 0.07459 seconds