I have created a application using vb
.net 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.