This thesis mainly analyzes how to adjust and optimize Oracle database in hugevolume of data to make it in best performance, and finally meet user's demand inpractical application. This thesis, in the aspect of Oracle database optimization,studied the theories of variation parameter adjustment, I/O optimization, SGAoptimization, SQL sentence optimization, and concluded several optimization plansaccording to user's Oracle main database; what's more, all of the plans was put in topractice for test in actual combat with great test data, and satisfied optimization plancan be finalized by analyzing the test data, such plan has already been actualized inuser's main database, result is perfect. In addition, this thesis also studied effectivesingle optimization plan and plan with good quality but low cost, all of the plans wereput into practice, out of which, the test data and result in basic on Oracle maindatabase of FOSHAN POLICE STATION ACTION TECHNICAL DEE... |