View Single Post
Old July 6th, 2010, 09:29 AM
nelly78 nelly78 is offline
Authorized User
Points: 437, Level: 7
Points: 437, Level: 7 Points: 437, Level: 7 Points: 437, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Apr 2008
Location: , , .
Posts: 85
Thanks: 10
Thanked 0 Times in 0 Posts
Default Problem with report generation time

Hi All,
I have created a application using which connect to Oracle database.What application does based on the user selection on the interface
Creates temporary table in the database and insert record into that table and then retreive records from the table and generates the csv file as a report.

It used to work fine no problem, But now since couple of days what is happening is evertime user is running application to generate the report time of
genration of the report is increasing by 30 second. When I restart the Oracle service then it takes normal time under 1 min when I run it forst time,when running second time with the same selection of information it keep increasing the report generation time.

Can some one please tell me where is the problem, is it due to less space in database of database got corrupt or something else ?

Any help or suggestion much appriciated.

Many Thanks

Last edited by nelly78; July 6th, 2010 at 09:30 AM.. Reason: Typo mistake