Design and implementation of parameter tuning on Oracle DBMS
Other Title(s)
تصميم و تنفيذ تطابق المتغيرات في نظم إدارة قواعد البيانات Oracle
Dissertant
Thesis advisor
Comitee Members
al-Jabir, Ahmad Awdah
Abd al-Raziq, Muayyad
University
Amman Arab University
Faculty
Collage of Computer Sciences and Informatics
Department
Department of Computer Science
University Country
Jordan
Degree
Master
Degree Date
2008
English Abstract
-Retrieving data in the huge database resources needs a lot of time since hardware resources can not be modified in windows operating system.
This delay may lead to serious problems in large institutions such as airlines, banks, security or military institution; accordingly, the quality of services and the time of offering these services to their clients will be affected negatively.
This delay will be very clear in some operating systems, databases and some reports especially intelligent reports that are retrieved from more than one table.
This delay will cause many problems; the most important one is hanging of operating systems.
In order to solve this problem, and with the same resources (Memory, CPU, etc…), and without changing hardware or any computer specifications, some parameters from Linux operating system with some Oracle parameter are modified (tuning Parameter) to reduce the delay time of data retrieved from database tables, and thus reducing the hang time on available hardware resources.
This research aims to study the relationship between different Operating Systems and Database application, to increase the performance of the database using database parameter tuning with operating system parameters, as a concept can be applied on any Operating System with many differences.
For instance, Windows Operating System is not as clear as Unix or Linux OSs because we can not control the hardware resources of the computer to serve operating system requirements.
In the contrast with windows which is dependant on the registry editor construction, since it's difficult to be applied in such operating system.
So Linux operating system was chosen to implement this study.
As a result of this thesis, and when parameters from operating system and Oracle Database are connected , the execution time is reduced in a certain amount depending on database size .
Main Subjects
Topics
No. of Pages
65
Table of Contents
Table of contents.
Abstract.
Abstract in Arabic.
Chapter One : Introduction.
Chapter Two : Linux operating system, Oracle DBMS literature review.
Chapter Three : Parameters design and configuration in Linux operating system with oracle database management system.
Chapter Four : Implementation.
Chapter Five : Conclusion and future work.
References.
American Psychological Association (APA)
Jabir, Muhammad Jamil. (2008). Design and implementation of parameter tuning on Oracle DBMS. (Master's theses Theses and Dissertations Master). Amman Arab University, Jordan
https://search.emarefa.net/detail/BIM-529545
Modern Language Association (MLA)
Jabir, Muhammad Jamil. Design and implementation of parameter tuning on Oracle DBMS. (Master's theses Theses and Dissertations Master). Amman Arab University. (2008).
https://search.emarefa.net/detail/BIM-529545
American Medical Association (AMA)
Jabir, Muhammad Jamil. (2008). Design and implementation of parameter tuning on Oracle DBMS. (Master's theses Theses and Dissertations Master). Amman Arab University, Jordan
https://search.emarefa.net/detail/BIM-529545
Language
English
Data Type
Arab Theses
Record ID
BIM-529545