Orcale Tutorial Content
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
Create Consumer Group
ﺇﻨﺸﺎﺀ Consumer Group:
ﻴﻘﻭﻡ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺈﻨﺸﺎﺀ ﺍلConsumer Group ﺒﻭﺍﺴﻁﺔ ﺍﻟﺤﺯﻤﺔ DBMS_RESOURCE_MANAGER ﻭﺍﻟﺤﻘﻴﻘﺔ ﺃﻥ ﻫﺫﻩ ﺍﻟﺤﺯﻤﺔ ﺘﺤﺘﻭﻱ ﻋﻠﻲ ﻋﺩﺩ ﻤﻥ ﺍﻻﺠﺭﺍﺀﺍﺕ
ﺍﻟﺘﻲ ﺴﻨﺘﺤﺩﺙ ﻋﻨﻬﺎ ﻻﺤﻘﺎﹰ، ﻭﻟﻜﻥ ﻴﻤﻜﻨﻙ ﻤﺸﺎﻫﺩﺓ ﺠﻤﻴﻊ ﺍﻻﺠﺭﺍﺀﺍﺕ ﻋﻥ ﻁﺭﻴﻕ
DESC DBMS_RESOURCE_MANAGER |
ﻹﻨﺸﺎﺀ ﺍلConsumer Group ﻻﺒﺩ ﺃﻭﻻﹰ ﻤﻥ ﺇﻨﺸﺎﺀ ﺍلPending Area ﻭﻟﻭ ﻗﻤﺕ ﺒﺈﻨﺸﺎﺀ ﺍل Consumer Group ﻤﺒﺎﺸﺭﺓ ﺩﻭﻥ ﺇﻨﺸﺎﺀ ﺍلPending Area ﺴﺘﻔﺸل ﺍﻟﻌﻤﻠﻴﺔ.
ﺨﻁﻭﺍﺕ ﺇﻨﺸﺎﺀ ﺍلConsumer Group:
1- ﺘﻨﻅﻴﻑ ﺍلPending Area.
ﻭﺫﻟﻙ ﺒﺎﺴﺘﺨﺩﺍﻡ ﺍﻻﺠﺭﺍﺀ CLEAR_PENDING_AREA.
BEGIN SYS.DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA; COMMIT; END; |
2- ﺇﻨﺸﺎﺀ ﺍلPending Area.
ﻭﺫﻟﻙ ﺒﺎﺴﺘﺨﺩﺍﻡ ﺍﻹﺠﺭﺍﺀ CREATE_PENDING_AREA.
BEGIN SYS.DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA; COMMIT; END; |
3- ﺇﻨﺸﺎﺀ ﺍلConsumer Group.
ﻭﺫﻟﻙ ﺒﻭﺍﺴﻁﺔ ﺍﻻﺠﺭﺍﺀ CREATE_CONSUMER_GROUP.
DECLARE CONSUMER_GROUP VARCHAR2(200); COMMENT VARCHAR2(200); BEGIN CONSUMER_GROUP := 'NEW_GROUP'; COMMENT := 'THIS IS NEW GROUP'; SYS.DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP ( CONSUMER_GROUP, COMMENT); COMMIT; END; |
ﻟﻘﺩ ﻗﻤﻨﺎ ﺒﺈﻨﺸﺎﺀ Consumer Group ﺘﺴﻤﻲ NEW_GROUP ﻭﻴﻤﻜﻥ ﺍﻻﺴﺘﻌﻼﻡ ﺍﻻﻥ ﻟﻠﺘﺄﻜﺩ ﻤﻥ ﻋﻤﻠﻴﺔ ﺍﻹﻨﺸﺎﺀ.
SELECT DISTINCT(CONSUMER_GROUP) FROM DBA_RSRC_CONSUMER_GROUPS; |
4- ﺘﺜﺒﻴﺕ ﺍﻟﻤﺘﻐﻴﺭﺍﺕ:
ﻭﺫﻟﻙ ﺒﻭﺍﺴﻁﺔ ﺍﻻﺠﺭﺍﺀ SUBMIT_PENDING_AREA.
ﺤﻴﺙ ﻴﻘﻭﻡ ﺒﺤﻔﻅ ﺠﻤﻴﻊ ﺍﻟﺘﻐﻴﻴﺭﺍﺕ ﻓﻲ ﺍلPending Area ﺜﻡ ﻴﻌﻴﺩﻫﺎ ﻟﻠﻭﻀﻊ ﺍﻟﺨﺎﻤل ﺒﺸﺭﻁ ﺃﻥ ﺘﻜﻭﻥ
ﺍﻟﺘﻐﻴﻴﺭﺍﺕ ﺼﺤﻴﺤﺔ ﺃﻤﺎ ﺇﺫﺍ ﻜﺎﻨﺕ ﻏﻴﺭ ﺼﺤﻴﺤﺔ ﺘﻅل ﺍلArea Pending ﺩﻭﻥ ﺘﻐﻴﻴﺭ.
BEGIN SYS.DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA; COMMIT; END; |
-------------------------------------------