The Study Of Oracle Database Performance Tuning Technology And Real-time Monitoring Based On The Dongfeng Nissan Passenger Car

Oracle is becoming more and more popular, and many database administrators pay attention to the management and performance tuning of Oracle. It is the main factors that Oracle is configured unreasonably and optimized by inappropriate methods, which has been proved by practice.The management and monitoring of Oracle database is analyzed in detail.The performance tuning and real-time monitoring technology of Oracle are researched from a completely new perspective in this paper.Firstly, the knowledge of Oracle architecture and its performance tuning is introduced. Focused on the problem of performance decreasing in Oracle running, the method of performance tunning is analyzed from memory, I/O, SQL and network performance, in order to run Oracle in optimal performance.Secondly, the paper researches on the method of SQL performance tuning. Focused on the performance mode is singler in existing method about SQL tuning, an efficient algorithm of SQL tuning using Euclidean distance is introduced. In addition, its effectiveness is proved and analyse the experimental results.Through these aspects of the application of Tivoli monitoring software and the logical design of the database system, the parallel architecture design, the query optimization analysis and physical database design, the concurrent performance monitoring, I conducted deeply research and analysis about Oracle database performance monitoring, and drew some specific principles and methods of the Oracle database performance monitoring. And then I also apply these methods to dongfeng nissan passenger vehicle design and performance monitoring of the actual data. Through data comparison test, and achieved good results, proved that the method has high practicality.