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: 25050
Registered: January 2009
Location: SoCal
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: 12422
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 Dec 11 08:09:26 CST 2016

Total time taken to generate the page: 0.11293 seconds