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
Diagnostic Sources
Editing Thresholds
ﻴﺴﺘﻁﻴﻊ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺘﻬﻴﺌﺔ ﺍلThresholds ﻋﻥ ﻁﺭﻴﻕ ﺍﻟﺤﺯﻤﺔ DBMS_SERVER_ALERT ﻟﺼﺩﻭﺭ ﺍلAlerts، ﺭﻏﻡ ﺫﻟﻙ ﻗﺒل ﺃﻥ ﻴﻘﻭﻡ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺫﻟﻙ
ﻓﺈﻥ ﻫﻨﺎﻙ ﺘﻬﻴﺌﺔ ﺃﻭﻟﻴﺔ ﻤﻥ ﻗﺒل ﺍﻷﻭﺭﻜل، ﻓﻌﻠﻲ ﺴﺒﻴل ﺍﻟﻤﺜﺎل ﻟﻭ ﺘﺠﺎﻭﺯ ﺤﺠﻡ ﺍﻟﻤﺴﺎﺤﺔ ﺍﻟﻤﺴﺘﺨﺩﻤﺔ ﻓﻲ ﺍلTablespace ﻋﻠﻲ ﺍل85% ﺘﺼﺩﺭ ﺍلWarning Alert ﺃﻤﺎ ﺇﺫﺍ ﺘﺠﺎﻭﺯﺕ
ﺍﻟﻤﺴﺎﺤﺔ ﺍﻟﻤﺴﺘﺨﺩﻤﺔ ﻋﻠﻲ ﺍل97% ﺘﺼﺩﺭ ﺍلCritical Alert.
ﺘﺤﺘﻭﻱ ﺍﻟﺤﺯﻤﺔ DBMS_SERVER_ALERT علي عدد من ﺍﻹﺠﺭﺍﺀﺍﺕ ﻭﺍﻟﺩﻭﺍل:
.EXPAND_MESSAGE
.GET_THRESHOLD
.SET_THRESHOLD
.VIEW_THRESHOLDS
ﻟﻨﻔﺘﺭﺽ ﺍﻻﻥ ﺃﻥ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻴﺭﻴﺩ ﺘﻬﻴﺌﺔ ﺍلTablespace Usage ﺒﺤﻴﺙ ﻴﺘﻡ ﺇﺼﺩﺍﺭ Warning Alert ﺇﺫﺍ ﺘﺠﺎﻭﺯﺕ ﺍﻟﻤﺴﺎﺤﺔ ﺍﻟﻤﺴﺘﺨﺩﻤﺔ ﻓﻴﻪ 60 %، ﻭﻴﺘﻡ ﺇﺼﺩﺍﺭ Critical Alert
ﺇﺫﺍ ﺘﺠﺎﻭﺯﺕ ﺍﻟﻤﺴﺎﺤﺔ ﺍﻟﻤﺴﺎﺤﺔ ﺍﻟﻤﺴﺘﺨﺩﻤﺔ 70%.
begin dbms_server_alert.set_threshold( metrics_id=>dbms_server_alert.tablespace_pct_full, warning_operator=>dbms_server_alert.operator_ge, warning_value=>'60', critical_operator=>dbms_server_alert.operator_ge, critical_value=>'70', observation_period=>1, consecutive_occurrences=>2, instance_name=>'ORCL', object_type=>dbms_server_alert.object_type_tablespace, object_name=>'USERS'); end; |
ﺍﻻﻥ ﻟﻭ ﺘﺠﺎﻭﺯﺕ ﺍﻟﻤﺴﺎﺤﺔ ﺍﻟﻤﺴﺘﺨﺩﻤﺔ ﻓﻲ ﺍلUsers Tablespace ﻋﻠﻲ 60% ﺴﺘﺼﺩﺭ ﺍل Warning Alert ﻭﻟﻭ ﺘﺠﺎﻭﺯﺕ ﺍﻟﻤﺴﺎﺤﺔ ﺍﻟﻤﺴﺘﺨﺩﻤﺔ ﻋﻠﻲ 70% ﺴﺘﺼﺩﺭ ﺍلCritical Alert ، ﻭﻴﻤﻜﻥ ﺤﻴﻨﻬﺎ
ﺍﻹﺴﺘﻌﻼﻡ ﻋﻨﻬﺎ ﻓﻲ DBA_OUTSTANDING_ALERTS، ﺃﻤﺎ ﺇﺫﺍ ﺘﺩﺨل ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﻗﺎﻡ ﻤﺜﻼﹰ ﺒﺯﻴﺎﺩﺓ ﺤﺠﻡ ﺍلUsers Tablespace ﻓﺴﻭﻑ ﺘﺨﺘﻔﻲ ﺍﻟﺭﺴﺎﻟﺔ ﻤﻥ الDBA_ALERT_HISTORY
وستظهر الرسالة في DBA_OUTSTANDING_ALERTS.
----------------------------------------------