Home » RDBMS Server » Server Administration » Oracle sql tuning - reg
Oracle sql tuning - reg [message #50656] Fri, 29 March 2002 04:16 Go to next message
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.

Report message to a moderator

Re: Oracle sql tuning - reg [message #50669 is a reply to message #50656] Sat, 30 March 2002 19:13 Go to previous messageGo to next message
Natthawut
Messages: 7
Registered: March 2002
Junior Member
Do you analyze your table regulary? If you do and still have problem, you'd better show me the script. so I can figure it out.

Report message to a moderator

Re: Oracle sql tuning - reg [message #50718 is a reply to message #50656] Wed, 03 April 2002 05:44 Go to previous message
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 ?

Report message to a moderator

Previous Topic: Growth of Rollback Segments & Attaining size of Database
Next Topic: How Oracle is said to be a true RDBMS?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 10:36:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.