Orcale Tutorial Content
Loading...
Getting Started - البدء مع إدارة قواعد البيانات
Oracle Architectural Components - مكونات قاعدة البيانات أوركل
Installing Oracle Database - تثبيت الأوركل
Creating and Configuring Database - إنشاء قاعدة البيانات
Controlling The Database -التحكم في قاعدة البيانات
Administrating Users - إدارة المستخدمين
Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات
Oracle Net Services & Database Link & Metrlized Viewِ
Undo Management & Flashback Technology
Managing Shared Servers
Using Globalization Support
Logical Backup & Recovery
Physical Backup & Recovery
Recovery Manager (RMAN)
Managing Resources
Automating Tasks with the Scheduler
Dealing with Locking
Diagnostic Sources
Dealing With Database Corruption
Managing & Monitoring Memory
Performance Tunning
Managing Resources
Resource Manager Configuration
ﻟﺘﻬﻴﺌﺔ ﻤﺩﻴﺭ ﺍﻟﻤﻭﺍﺭﺩ ﺴﻨﺴﺘﺨﺩﻡ ﺤﺯﻤﺘﺎﻥ (Package):
1- DBMS_RESOURCE_MANAGER: ﻭﻫﻲ ﺘﺴﺘﺨﺩﻡ ﻹﻨﺸﺎﺀ (Plans & Directives Consumer Groups) ﺃﻴﻀﺎﹰ ﺘﺴﺘﺨﺩﻡ ﻫﺫﻩ ﺍﻟﺤﺯﻤﺔ ﻹﻨﺸﺎﺀ ﺍلPending area
ﻭﻫﻲ ﻤﺴﺎﺤﺔ ﻴﺘﻡ ﺇﻨﺸﺎﺅﻫﺎ ﻓﻲ ﺍﻟﺫﺍﻜﺭﺓ SGA ﻭﺘﺴﺘﺨﺩﻡ ﻫﺫﻩ ﺍﻟﺫﺍﻜﺭﺓ ﻟﻌﻤل ﺍلResource Manager objects ﻭﺫﻟﻙ ﻟﺘﺨﺯﻴﻥ ﺍﻟﻜﺎﺌﻨﺎﺕ ﺍﺜﻨﺎﺀ ﺘﻬﻴﺌﺘﻬﺎ،
ﺃﻴﻀﺎﹰ ﻟﺨﻠﻕ ﺍلDirective ﺤﻴﺙ ﺘﺤﺘﻭﻱ ﺍلPlan ﺍﻟﻭﺍﺤﺩﺓ ﻋﻠﻲ ﻤﺠﻤﻭﻋﺔ ﻤﻥ ﺍلDirectives، ﻭﻴﺘﻡ ﺇﻨﺸﺎﺀ ﻫﺫﻩ ﺍلDirectives ﻜﻼﹰ ﻋﻠﻲ ﺤﺩﺍ.
2- DBMS_RESOURCE_MANAGER.PRIVS: ﻭﺘﺴﺘﺨﺩﻡ ﻫﺫﻩ ﺍﻟﺤﺯﻤﺔ ﻟﻭﻀﻊ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ ﻓﻲ ﺍﻟﻤﺠﻤﻭﻋﺎﺕ Consumer Groups ﻭﺃﻴﻀﺎﹰ ﻟﻤﻨﺢ ﺍﻟﺼﻼﺤﻴﺎﺕ ﺍﻟﻤﻬﻤﺔ
ﻹﺩﺍﺭﺓ ﺍلResource Manager.
----------------------------------------