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 Shared Servers
ﻤﺘﻰ ﻨﺴﺘﺨﺩﻡ ﺍل Shared Server ؟
ﻓﻲ ﺍﻟﺤﻘﻴﻘﺔ ﻟﻥ ﺘﺠﺩ ﺠﻭﺍﺒﺎﹰ ﺸﺎﻓﻴﺎﹰ ﻟﻬﺫﺍ ﺍﻟﺴﺅﺍل؟ ﺃﻱ ﻤﺘﻰ ﻴﺠﺏ ﺃﻥ ﺘﺴﺘﺨﺩﻡ ﺍلShared Server؟
ﻭﺃﻴﻀﺎﹰ ﻜﻡ ﻋﺩﺩ ﺍلDispatchers ﻭﺍلShared Servers ﺍﻟﺘﻲ ﻴﺠﺏ ﺃﻥ ﺘﻌﻤل ﻓﻲ ﺤﺎل ﺘﻬﻴﺌﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﻨﻤﻁ Shared Server
ﺃﻨﺕ ﻜﻤﺩﻴﺭ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺘﺤﺘﺎﺝ ﻟﻭﻀﻊ ﻤﻭﺍﺯﻨﺎﺕ ﻻﺘﺨﺎﺫ ﺍﻟﻘﺭﺍﺭ ﺍﻟﻤﻨﺎﺴﺏ ﻓﺄﻨﺕ ﻤﺤﻜﻭﻡ ﺒﺤﺠﻡ ﻤﻌﻴﻥ ﻤﻥ
ﺍﻟﻤﻭﺍﺭﺩ ﻭﻓﻰ ﻨﻔﺱ ﺍﻟﻠﺤﻅﺔ ﺃﻨﺕ ﻤﻁﺎﻟﺏ ﺒﺘﻭﻓﻴﺭ ﺇﻤﻜﺎﻨﻴﺔ ﻭﺼﻭل ﻋﺩﺩ ﻤﻌﻴﻥ ﻤﻥ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ ﺩﻭﻥ ﺘﺄﺨﻴﺭ.
ﻋﻤﻭﻤﹰﺎ ﻴﺠﺏ ﻋﻠﻰ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﺘﻨﺴﻴﻕ ﻤﻊ ﻤﺩﻴﺭ ﺍﻟﻨﻅﺎﻡ ﻻﺘﺨﺎﺫ ﺍﻟﻘﺭﺍﺭ ﺍﻟﻤﻨﺎﺴﺏ. ﻟﻨﻔﺘﺭﺽ ﺍﻵﻥ ﺃﻨﻙ ﻗﻤﺕ ﺒﺘﺸﻐﻴل ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺍﻟﻭﻀﻊ Shared Server
ﻓﻴﻤﻜﻨﻙ ﺘﺠﺎﻭﺯ ﺍﻻﺘﺼﺎل ﺒﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻤﻥ ﺨﻼل ﻫﺫﺍ ﺍﻟﻨﻤﻁ ﺃﻭ ﺇﻥ ﺸﺌﺕ ﻓﻘل ﻤﻥ ﺨﻼل ﺍلDedicated Server ﻭﺫﻟﻙ ﻤﻥ ﺨﻼل ﺍﻻﺘﺼﺎل ﺒﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ Locally
ﻤﻥ ﻨﻔﺱ ﺍﻟﻤﺎﻜﻴﻨﺔ ﺍﻟﺘﻲ ﺒﻬﺎ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻱ ﺩﻭﻥ ﺍﻟﻤﺭﻭﺭ ﺒﺎلListener ﻭﺫﻟﻙ ﻷﻥ ﺍﻻﺘﺼﺎل ﻴﺘﻡ ﻤﺒﺎﺸﺭﺓ ﺒﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﺩﻭﻥ ﺍﺴﺘﺨﺩﺍﻡ ﺍلtnsnames.ora ﺍﻟﺘﻲ
ﺘﺤﻭﻟﻙ ﺇﻟﻰ ﺍﻟﻤﺴﺘﻤﻊ ﺍﻟﺫﻱ ﻴﻌﻤل ﻋﻠﻰ ﺍلShared Server.
SQL> CONN SYS/SYS AS SYSDBA |
ﺃﻴﻀﺎﹰ ﻴﻤﻜﻨﻙ ﺍﻻﺘﺼﺎل ﺒﻘﺎﻋﺩ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻙDedicated Server ﺤﺘﻰ ﻭﻟﻭ ﻜﺎﻨﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺘﻌﻤل ﻓﻲ ﺍﻟﻨﻤﻁ Shared Server ﻭﺫﻟﻙ ﻤﻥ ﺨﻼل ﺘﻬﻴﺌﺔ ﻤﻠﻑ ﺍلtnsnames
ﺇﺫﺍ ﺘﻡ ﺍﻻﺘﺼﺎل ﺒﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻤﻥ ﺨﻼل ﺍﻻﺴﻡ ﺍﻟﻤﺴﺘﻌﺎﺭ ORCL ﻓﺈﻨﻙ ﺍﻻﺘﺼﺎل ﺴﻭﻑ ﻴﺘﻡ ﻤﻥ ﺨﻼل Dedicated Server.
SQL> CONN SYSTEM/SYS@ORCL |
ﺃﻤﺎ ﺇﺫﺍ ﺘﻡ ﺍﻻﺘﺼﺎل ﻤﻥ ﺨﻼل ﺍﻻﺴﻡ ﺍﻟﻤﺴﺘﻌﺎﺭ TEST ﻓﺈﻥ ﺍﻻﺘﺼﺎل ﺴﻭﻑ ﻴﺘﻡ ﻤﻥ ﺨﻼل ﺍل Shared Server.
SQL> CONN SYSTEM/SYS@TEST |
ﺒﺎﻟﻁﺒﻊ ﻴﻤﻜﻥ ﺇﺭﺠﺎﻉ ﺍلInstance ﻟﺘﻌﻤل ﻋﻠﻰ ﺍﻟﻨﻤﻁ Dedicated Server ﻤﺭﺓ ﺃﺨﺭﻯ ﻭﺫﻟﻙ ﻤﻥ ﺨﻼل ﺍﻻﺘﻰ:
ALTER SYSTEM SET DISPATCHERS='' SCOPE=SPFILE; |
ALTER SYSTEM SET SHARED_SERVERS=0 scope=spfile; |
ﻜﻤﺎ ﺘﺠﺩﺭ ﺍﻹﺸﺎﺭﺓ ﺇﻟﻲ ﺃﻨﻪ ﻤﻥ ﺍﻷﻓﻀل ﺍﻟﻘﻴﺎﻡ ﺒﻤﻬﺎﻡ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻜﺈﻨﺠﺎﺯ ﻋﻤﻠﻴﺎﺕ ﺍﻟﻨﺴﺦ ﺍﻻﺤﺘﻴﺎﻁﻲ ﻭﺍﻻﺴﺘﺭﺠﺎﻉ (Backup & Recovery ) ﺃﻭ إﻨﺸﺎﺀ ﺍﻟﻔﻬﺎﺭﺱ (Indexes) ﻋﻥ ﻁﺭﻴﻕ ﺍل Dedicated Server.
ﻜﻤﺎ ﻴﺘﻌﺫﺭ ﺍﻟﻘﻴﺎﻡ ﺒﺒﻌﺽ ﺍﻟﻤﻬﺎﻡ ﻜﺘﺸﻐﻴل ﻭﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻤﻥ ﺨﻼل ﻫﺫﺍ ﺍﻟﻨﻤﻁ (Shared Server) ﻟﺫﺍ ﻴﻘﻭﻡ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺄﺩﺍﺀ ﻤﻬﺎﻤﻪ ﻋﻥ ﻁﺭﻴﻕ ﺍلDedicated Server.
ﻟﻼﺴﺘﻌﻼﻡ:
V$CIRCUIT
V$DISPATCHERS
V$SHARED_SERVER
V$SHARED_SERVER_MONITOR
-------------------------