Design and implementation of parameter tuning on Oracle DBMS

العناوين الأخرى

تصميم و تنفيذ تطابق المتغيرات في نظم إدارة قواعد البيانات Oracle

مقدم أطروحة جامعية

Jabir, Muhammad Jamil

مشرف أطروحة جامعية

al-Hamami, Ala Husayn

أعضاء اللجنة

al-Jabir, Ahmad Awdah
Abd al-Raziq, Muayyad

الجامعة

جامعة عمان العربية

الكلية

كلية العلوم الحاسوبية و المعلوماتية

القسم الأكاديمي

قسم علم الحاسوب

دولة الجامعة

الأردن

الدرجة العلمية

ماجستير

تاريخ الدرجة العلمية

2008

الملخص الإنجليزي

-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 .

التخصصات الرئيسية

الرياضيات

الموضوعات

• الإدارة
• التصميم
• قواعد البيانات

عدد الصفحات

65

قائمة المحتويات

• APA
• MLA
• AMA

لغة النص

الإنجليزية

نوع البيانات

رسائل جامعية

رقم السجل

BIM-529545