Oracle sql tuning - reg [message #50656] |
Fri, 29 March 2002 04:16 |
Prem
Messages: 79 Registered: August 1998
|
Member |
|
|
I have been executing a paybill PL/SQL script
which was initially taking 0.5 minute and now after a year it has increased to 2 minute. Please help me tuning the oracle databasea and advice me with tips on reducing the execution time.
|
|
|
|
Re: Oracle sql tuning - reg [message #50718 is a reply to message #50656] |
Wed, 03 April 2002 05:44 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
You have not mentioned how big the table has grown. When you got results in 0.5 minutes, how many rows were there, and now that it takes 2 min, how many rows are present ?
Your 1 years data has grown how much ?
|
|
|