We have taken an Oracle 11G database for approximately 12 months in our business, and one of our reports takes 40 minutes Was to run Our DBA has suggested that we flip / reload all the data.
Now, we were in doubt for the first time and thought that it seemed like a harsh perspective, but it has reduced report time by 3 minutes !!
What was he really doing here? His description was It worked clearly, what did he do, but I wonder if Oracle could not do it himself. I thought that without such a thing you can make indexes again? A statement on a table of our databases used for a long time. When we checked the table size, it was about 900 MB. Records in the table were being removed from time to time. After the reconstruction of the table, the size of the table decreased by 100 MB and the time for the statement was greatly increased. It seems that the disc works like a defragmentation works. Exporting all schema objects to unload / reload the data, leaving the schema (or reclaiming the database) and importing it again.
No comments:
Post a Comment