Dissertation > Excellent graduate degree dissertation topics show

The Study of Oracle Database Performance Tuning Technology and Real-time Monitoring Based on the Dongfeng Nissan Passenger Car

Author: LiuZhe
Tutor: WangShengXiang
School: Wuhan Textile University
Course: Physical Electronics
Keywords: Oracle Database Tivoli real-time monitoring Math~*sq1
CLC: TP311.13
Type: Master's thesis
Year: 2013
Downloads: 28
Quote: 0
Read: Download Dissertation

Abstract


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.

Related Dissertations

  1. Design and Development of Application Programme for Fault Analyzer Based on Wince Platform,TP311.52
  2. Study on System of Electronic Documetnt Security Signature,TN918.2
  3. Implementation of Data Compression, Operation and Query Processing System Based on BAP,TP311.13
  4. Design and Implementation of the weapons and equipment information management system,TP311.52
  5. Force Online Examination System Design and Implementation,TP311.52
  6. Xinjiang Oilfield Ground Construction Cost Indicators and Management Information System Study and Application,F284
  7. The Studying of University Students’ Community Management Based on GIS,G647
  8. Research of Contaminated Site Investigation and Assessment Information System for Soil,X825
  9. The Application Research of Database Synchronization Technology in Disaster Recovery System,TP309.3
  10. Research and Development of Field Data Collecting Synchronously System of Mining Area Surface Deformation,P208
  11. Automatic Calibration System Voltage Monitor,TM933.2
  12. Carvings and Knock Down Rebirth,J314.9
  13. The Design and Implementation of Distributed Database Based on Oracle of Mobile CRBT,TP311.13
  14. Computerized financial records management research,F232
  15. The Research of Data Mining and OLAP about Medical Insurance in Social Protection System,TP311.13
  16. The Integrated Application of Database Technology in the Gas Transferring Monitor System,TP277
  17. The Development and Research of Liaoning Mineral Resources Management Information System Based on ArcGIS,P208
  18. The Study of the City 3D Modeling and Visualization Based on CityMaker,P208
  19. Research on Provably Security Model for AKE Protocol,TP309
  20. Research on Safety of Sensitive Data in OA System,TP317.1
  21. Research for Technique of Routing in Delay-Tolerant Nerwork,TN929.5

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile