Database version: 12c 12.1.0.2.0
OS: Windows Server 2012 R2 Standard
Memory: 24GB
Automatic memory management: On
Force full database caching mode: Enabled
DB storage media: SAN disk
Index rebuild: every day
Hello All,
I have a 12c database (configuration above) for financial trading up and running for half a year. There are about 8,000 new records written to the database during trading hours. For business needs, I have to restore the database about once in two to three weeks.
I have a log to keep track of the time taken for each insert and query into the database every day. I back up the database by rman every night. During this period, after several database restores, the daily maximum insert time gets longer and longer (going worse from 0.5 sec to several seconds).The problem remains after I restart the database services. But the problem is gone after I reboot the Windows server. After about three months when several restores are done, the problem appears again. The memory usage looks normal throughout.
Just wonder if restore has any impact on database performance.
Thanks.
Winson