Orcale Tutorial Content


Getting Started - البدء مع إدارة قواعد البيانات
  • أنواع مستخدمي قواعد البيانات:
  • مهام مسؤول قاعدة البيانات:
  • SQL Statements:
  • Identifying Your Oracle Database Software Release - تحديد إصدار اوركل
  • About Database Administrator Security and Privileges- أمان وامتيازات مسؤول قاعدة البيانات
  • Database Administrator Authentication - مصادقة مسؤول قاعدة البيانات
  • Creating and Maintaining a Database Password File - إنشاء ملف كلمة المرور
  • Oracle Architectural Components - مكونات قاعدة البيانات أوركل
  • ﻤﻜﻭﻨﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • Oracle Instance
  • Oracle Database
  • Installing Oracle Database - تثبيت الأوركل
  • Installing oracle database 10g in windows
  • Creating and Configuring Database - إنشاء قاعدة البيانات
  • ﺍﻟﺘﺨﻁﻴﻁ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺎﻟﻁﺭﻴﻘﺔ ﺍﻟﻴﺩﻭﻴﺔ علي Windows:
  • ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻋﻥ ﻁﺭﻴﻕ ﺍل(DBCA)
  • About Creating an Oracle Database
  • About Selecting a Character Set
  • Prerequisites for Database Creation
  • Creating a Database with the CREATE DATABASE Statement
  • Specifying CREATE DATABASE Statement Clauses
  • Specifying Initialization Parameters
  • Controlling The Database -التحكم في قاعدة البيانات
  • التحكم في قاعدة البيانات - Controlling The Database
  • ﺘﺸﻐﻴل ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • Opening a Database in Read-Only Mode
  • Opening a Database in Restricted Mode
  • Managing Tablespaces and Data files
  • ﻤﻔﺎﻫﻴﻡ ﻋﺎﻤﺔ ﻋﻥ ﺍل: Tablespaces
  • عملي
  • Control File & Redo Log Files
  • Control File
  • ﺘﻐﻴﻴﺭ ﺍﺴﻡ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • Redo Log Files
  • Administrating Users - إدارة المستخدمين
  • ﺇﻨﺸﺎﺀ ﻭﺇﺩﺍﺭﺓ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ
  • Quota
  • ﻭﺴﻴﻠﺔ ﺍﻟﺘﺤﻘﻴﻕ
  • ﺍﻟﺼﻼﺤﻴﺎﺕ - Privileges
  • Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات
  • Database Security
  • ﻤﺭﺍﻗﺒﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ - AUDITING
  • Oracle Net Services & Database Link & Metrlized Viewِ
  • Oracle Net Services
  • ﺍﻟﺘﺤﻜﻡ ﻓﻲ ﺍﻟﻭﺼﻭل ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • External Procedures
  • Clients Side
  • Database Link
  • Materialized Views
  • Undo Management & Flashback Technology
  • Flashback Query
  • Flashback Table
  • Flashback Versions Query
  • Flashback Transaction
  • Flashback Drop
  • Flashback Database
  • Managing Shared Servers
  • Why Shared Server
  • Dedicated Server
  • Shared Server Architecture
  • ﻤﺘﻰ ﻨﺴﺘﺨﺩﻡ ﺍل Shared Server ؟
  • Using Globalization Support
  • Globalization
  • ﺍﺨﺘﻴﺎﺭ وتغيير ﺍل Character Set
  • ﻤﺴﺘﻭﻴﺎﺕ ﺍل Globalization
  • ﺍﺴﺘﺨﺩﺍﻡ ﺍل Zones Time
  • Logical Backup & Recovery
  • Use Export Utilities to Export Data
  • TABLES EXPORT Using Export Utilities
  • SCHEMAS EXPORT Using Export Utilities
  • TABLESPACE EXPORT Using Export Utilities
  • DATABASE EXPORT Using Export Utilities
  • Use Import Utilities to Import Data
  • TABLES IMPORT Using Import Utilities
  • SCHEMAS IMPORT Using Import Utilities
  • DATABASE IMPORT Using Import Utilities
  • TABLES EXPORT Using Data Pump
  • SCHEMAS EXPORT Using Data Pump
  • DATABASE EXPORT Using Data Pump
  • TABLES IMPORT Using Data Pump
  • SCHEMAS IMPORT Using Data Pump
  • DATABASE IMPORT Using Data Pump
  • SQL*Loader
  • Physical Backup & Recovery
  • Physical Backup
  • ﻜﻴﻑ ﻨﻬﻴﺊ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻟﺘﻌﻤل ﻓﻲ ﺍﻟﻨﻤﻁ ARCHIVELOG؟
  • Cold Backup
  • Full Database Recovery
  • Loss of a Non-SYSTEM Data File
  • Loss of a SYSTEM Data File
  • Loss of an Un-archived Online Log Files
  • Loss of Control Files
  • Loss Unbackup Datafile
  • Damage Tempfile
  • Damage Temporary Tablespace
  • Damage Online Logfile Member
  • Point in Time Recovery
  • Backup and Recovery Options
  • Hot Backup
  • Recovery Manager (RMAN)
  • مقدمة
  • مكونات ال Recovery Manager (RMAN)
  • ﺃﻨﻭﺍﻉ ﺍﻻﺘﺼﺎل ﺒﺎل RMAN
  • ﺨﻴﺎﺭﺍﺕ وأنماط ﺍﻟﻨﺴﺦ ﺍﻹﺤﺘﻴﺎﻁﻰ
  • RMAN Configuration Setting
  • Recovery Catalog
  • RMAN Backups
  • Data Files Backup
  • Tablespaces Backup
  • Archived Redo Log Files Backup
  • Control File Backup
  • Database Backup
  • Incremental Backups
  • RMAN Commands
  • Complete Recovery
  • Incomplete Recovery
  • Restore ControlFile and spfile
  • Managing Resources
  • Consumer Groups
  • Resource Manager Plans
  • Resource Manager Configuration
  • Create Consumer Group
  • Update Consumer Group
  • Delete Consumer Group
  • Privileges & Resource Manager
  • Join To Consumer Group
  • Move Active User To Other Consumer Group
  • Create Resource Manager Plans & Directive
  • Update Resource Manager Plans
  • Update Resource Manager Plan Directives
  • Delete Resource Manager Plan Directives
  • Delete Resource Manager Plans
  • Create Simple Plan
  • Consumer Group Mapping
  • Automating Tasks with the Scheduler
  • The Scheduler Architecture
  • Jobs
  • Programs
  • Schedules
  • Using Programs and Schedules
  • Job Classes
  • Windows
  • (Privileges) ﺍﻟﺼﻼﺤﻴﺎﺕ
  • Job Logs
  • Dealing with Locking
  • Shared & Exclusive Locks
  • Manual Lock Table
  • The Enqueue Mechanism
  • Lock Contention
  • Deadlocks
  • Diagnostic Sources
  • Alert Log
  • Background Trace Files
  • Server-Generated Alerts
  • Editing Thresholds
  • User Trace Files
  • Instance-Level SQL Tracing
  • Session-Level SQL Tracing
  • Dealing With Database Corruption
  • Block Corruption
  • ﺍﻜﺘﺸﺎﻑ ﺍﻟﻜﺘل ﺍﻟﻔﺎﺴﺩﺓ (Detecting Block Corruptions)
  • The DBVERIFY Utility
  • The ANALYZE Command
  • DBMS_REPAIR Backage
  • ﺍﺴﺘﺭﺠﺎﻉ ﺍﻟﻜﺘل ﺍﻟﻔﺎﺴﺩﺓ ﺒﻭﺍﺴﻁﺔ ﺍل:RMAN
  • Managing & Monitoring Memory
  • The System Global Area
  • The Shared Pool
  • The Database Buffer Cache
  • The Default, Keep, and Recycle Pools
  • The Nonstandard Block Size Pools
  • Sizing the Database Buffer Cache
  • The Log Buffer
  • The Large Pool
  • The Java Buffer
  • The Steams Buffer
  • Automatic Shared Memory Management
  • Enable Automatic Shared Memory Management
  • The Program Global Area (PGA)
  • Performance Tunning
  • Invalid Objects
  • Unusable Indexes
  • Rebuild Invalid Inexes
  • Optimizer Statistics
  • Gathering Statistics
  • The Automatic Workload Repository (AWR)
  • The Automatic Database Diagnostic Monitor (ADDM)
  • The SQL Tuning Advisor
  • The SQL Access Advisor
  • The Mean Time to Recover Advisor
  • The Segment Advisor
  • The Undo Advisor
  • Managing Resources

    Create Resource Manager Plans & Directive

     إنشاء  الResource manager Plans & Directive:

    ﻓﻲ ﺍﻟﺨﻁﻭﺍﺕ ﺍﻟﺴﺎﺒﻘﺔ ﻋﺭﻓﻨﺎ ﺃﻥ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﻨﺘﻅﻤﻭﻥ ﻓﻲ ﻋﺩﺩ ﻤﻥ ﺍلConsumer Groups، ﻟﻜﻥ ﻜﻴﻑ ﻴﺘﻡ ﺘﻘﺴﻴﻡ ﺍﻟﻤﻭﺍﺭﺩ ﺒﻴﻥ ﻫﺫﻩ ﺍﻟﻤﺠﻤﻭﻋﺎﺕ؟

    ﺍﻟﺠﻭﺍﺏ ﻋﻥ ﻁﺭﻴﻕ ﺍلPlans.

    ﺍلPlan ﺘﻘﻭﻡ ﺒﺘﻘﺴﻴﻡ ﺍﻟﻤﻭﺍﺭﺩ ﺒﻴﻥ ﻤﺠﻤﻭﻉ ﺍلConsumer Groups، ﻭﻗﺩ ﻴﻜﻭﻥ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﻭﺍﺤﺩﺓ ﻋﺩﺩ ﻤﻥ ﺍلResource Manager Plan، ﻭﻟﻜﻥ ﻓﻲ ﺍﻟﻠﺤﻅﺔ ﺍﻟﻭﺍﺤﺩ ﺘﻨﺸﻁ Plan ﻭﺍﺤﺩﺓ ﻓﻘﻁ،

    ﻫﻲ ﻤﻥ ﺘﺘﺤﻜﻡ ﻓﻲ ﺍﻟﻤﻭﺍﺭﺩ ﻭﻴﺘﻡ ﺘﻁﺒﻴﻘﻬﺎ ﻋﻠﻲ ﺠﻤﻴﻊ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ. ﻭﻟﺤﻅﺔ ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻴﺘﻡ ﺇﻨﺸﺎﺀ ﺜﻼﺙ ﺨﻁﻁ ﺘﺤﺩﺜﻨﺎ ﻋﻨﻬﺎ ﺴﺎﺒﻘﺎﹰ.

    ﻤﺒﺩﺌﻴﹰﺎ ﻴﻤﻜﻥ ﺘﻭﺯﻴﻊ ﺍﻟﻤﻭﺍﺭﺩ ﻋﻠﻲ ﺍﻟﻤﺠﻤﻭﻋﺎﺕ ﻋﻠﻲ ﺜﻤﺎﻨﻲ ﻤﺴﺘﻭﻴﺎﺕ،

    ﻭﺍﻟﺤﻘﻴﻘﺔ ﺃﻥ ﻫﻨﺎﻙ ﻋﺩﺩ ﻤﻥ ﺍﻟﻤﻭﺍﺭﺩ ﻨﺴﺘﻁﻴﻊ ﺍﻟﺘﺤﻜﻡ ﺒﻬﺎ ﻤﻥ ﺨﻼل ﺍلPlan Manager Resource:

    1- CPU Method: ﻭﻫﻲ ﺘﻤﻜﻨﻙ ﻤﻥ ﺍﻟﺘﺤﻜﻡ ﻭﻟﺘﺤﺩﻴﺩ ﻤﺼﺎﺩﺭ ﻭﺤﺩﺓ ﺍﻟﻤﻌﺎﻟﺠﺔ ﺍﻟﻤﺭﻜﺯﻴﺔ CPU ﻭﺘﻘﺴﻴﻤﻬﺎ ﺒﻴﻥ ﺍﻟﻤﺠﻤﻭﻋﺎﺕ Consumer Groups ﺃﻭ الSubplan.

    2-  Active Session Pool with Queuing: ﻴﺴﻤﺢ ﻟﻙ ﺘﺤﺩﻴﺩ ﻋﺩﺩ ﺍلSessions ﺍﻟﻨﺸﻁﺔ ﺍﻟﻤﺘﺼﻠﺔ ﻓﻲ ﻨﻔﺱ ﺍﻟﻭﻗﺕ ﻋﻥ ﻁﺭﻴﻕ ﺍل Consumer Group،

    ﺇﺫﺍ ﺘﺠﺎﺯﺕ ﺍﻟﻤﺠﻤﻭﻋﺔ ﺍﻟﻌﺩﺩ ﺍﻟﻤﺴﻭﺡ ﺒﻪ ﻤﻥ ﺍلSessions ﻓﺈﻥ ﻫﺫﻩ ﺍلSessions ﺘﻅل ﻤﻭﺠﻭﺩﺓ ﻓﻲ ﺼﻑ ﺒﺈﻨﺘﻅﺎﺭ ﺇﻨﺘﻬﺎﺀ ﺍﺤﺩ ﺍلSession ﺍﻟﻨﺸﻁﺔ،

    ﻋﻤﻭﻤﹰﺎ ﺃﻨﺕ ﻴﻤﻜﻥ ﺃﻴﻀﺎﹰ ﺃﻥ ﺘﺤﺩﺩ ﻓﺘﺭﺓ ﺯﻤﻨﻴﺔ ﻹﻨﺘﻅﺎﺭ ﺍلSession ﻓﻲ ﺍﻟﺼﻑ ﻗﺒل ﺃﻥ ﻴﺼﺩﺭ ﺍﻟﺨﻁﺄ.

    3-  Degree of Parallelism: ﺘﻤﻜﻨﻙ ﻤﻥ ﺍﻟﺴﻴﻁﺭﺓ ﻋﻠﻲ ﺍﻟﺩﺭﺠﺔ ﺍﻟﻘﺼﻭﻱ ﻟﻠﻌﻤل ﻋﻠﻲ ﺍﻟﺘﻭﺍﺯﻱ ﻷﻱ ﻋﻤﻠﻴﺔ ﻀﻤﻥ ﺍلConsumer Group.

    4-  Execution Time Limit: ﺘﺴﻤﺢ ﻟﻙ ﺒﺘﺤﺩﺩ ﺍﻗﺼﻲ ﻭﻗﺕ ﻤﺴﻤﻭﺡ ﺒﻪ ﻟﺘﻨﻔﻴﺫ ﺍﻟﻌﻤﻠﻴﺎﺕ.

    5- Idle Time Limit: ﺘﺴﻤﺢ ﻟﻙ ﺒﺘﺤﺩﻴﺩ ﺍﻟﻭﻗﺕ ﺍﻟﺫﻱ ﻴﻤﻜﻥ ﺃﻥ ﺘﻜﻭﻥ ﺍلSession ﻋﺎﻁﻠﺔ ﻋﻥ ﺍﻟﻌﻤل ﻗﺒل ﺃﻥ ﺇﻨﻬﺎﺀ ﺍلSession.

    6- Undo Pool: ﺘﺴﺘﻁﻴﻊ ﻤﻥ ﺨﻼﻟﻪ ﺍﻟﺴﻴﻁﺭﺓ ﻋﻠﻲ ﻜﻤﻴﺔ ﺍلUndo ﺍﻟﺘﻲ ﻴﻤﻜﻥ ﺃﻥ ﺘﺘﻭﻟﺩ ﻤﻥ ﻗﺒل ﺍلConsumer Group ﺃﻭ ﺍلSubplan.


    ﻨﺴﺘﺨﺩﻡ ﺍﻹﺠﺭﺍﺀ CREATE_PLAN ﺍﻟﻤﻭﺠﻭﺩ ﻓﻲ ﺍﻟﺤﺯﻤﺔ DBMS_RESOURCE_MANAGER ﻹﻨﺸﺎﺀ ﺍلPLAN ﻭﻫﺫﺍ ﺍﻹﺠﺭﺍﺀ ﻴﺤﺘﻭﻱ ﻋﻠﻲ ﻋﺩﺩ ﻤﻥ ﺍﻟﻤﺘﻐﻴﺭﺍﺕ.

    ﻭﺃﻴﻀﺎﹰ ﺴﻨﺴﺘﺨﺩﻡ ﺍﻹﺠﺭﺍﺀ CREATE_PLAN_DIRECTIVE ﻟﻤﻨﺢ ﺍﻟﻤﺼﺎﺩﺭ ﻟلCONSUMER GROUPS ﻋﻥ ﻁﺭﻴﻕ ﺍلPLAN.

    ﺇﺫﺍﹰ ﺴﻨﻘﻭﻡ ﺒﺈﻨﺸﺎﺀ ﺍلPLAN ﻋﻥ ﻁﺭﻴﻕ ﺍﻹﺠﺭﺍﺀ CREATE_PLAN ﻭﻟﻜﻥ ﺴﻨﻘﻭﻡ ﻻﺤﻘﺎﹰ ﺒﺈﻨﺸﺎﺀ DIRECTIVE ﻋﻥ ﻁﺭﻴﻕ ﺍﻹﺠﺭﺍﺀ CREATE_PLAN_DIRECTIVE ﻟﺘﻭﺯﻴﻊ ﺍﻟﻤﺼﺎﺩﺭ ﺒﻴﻥ

    ﺍلCONSUMER GROUPS ﻋﻥ ﻁﺭﻴﻕ ﺍلPLAN.

    ﻟﻨﻔﺘﺭﺽ ﻤﺜﻼﹰ ﺃﻨﻨﺎ ﺴﻨﻘﻭﻡ ﺒﺈﻨﺸﺎﺀ PLAN ﺍﺴﻤﻬﺎ NEW PLAN ﺴﻨﻘﻭﻡ ﺒﺘﻭﺯﻴﻊ ﺍﻟﻤﺼﺎﺩﺭ ﺒﺎﺴﺘﺨﺩﺍﻡ ﺍلDIRECTIVES ﻋﺒﺭ ﺍلPLAN ﺒﻴﻥ ﺍلCONSUMER GROUPS،

    ﺤﻴﺙ ﺴﻨﻘﻭﻡ ﺒﺘﻭﺯﻴﻊ ﺍﻟﻤﻭﺍﺭﺩ وهي:

    .(CPU Method , Active Session , Degree of Parallelism , Execution Time Limit ,Idle Time Limit ,Undo Pool)

    ﻫﺫﻩ ﻫﻲ ﻤﺘﻐﻴﺭﺍﺕ ﺍﻹﺠﺭﺍﺀ CREATE_PLAN_DIRECTIVE ﺤﻴﺙ:

    Plan    name of resource plan

    group_or_subplan               name of consumer group or subplan

    comment                             comment for the plan directive

    cpu_p1                        first parameter for the CPU resource allocation method

    cpu_p2                         second parameter for the CPU resource allocation method

    cpu_p3                         third parameter for the CPU resource allocation method

    cpu_p4                          fourth parameter for the CPU resource allocation method

    cpu_p5                         fifth parameter for the CPU resource allocation method

    cpu_p6                         sixth parameter for the CPU resource allocation method

    cpu_p7                         seventh parameter for the CPU resource allocation method

    cpu_p8                         eighth parameter for the CPU resource allocation method

    active_sess_pool_p١        first parameter for the max. active sessions allocation method

    queueing_p١                  queue timeout in seconds

    parallel_degree_limit_p١   first parameter for the degree of parallelism allocation method

    switch_group                      group to switch once switch time is reached

    switch_time                         max execution time within a group

    switch_estimate                  use execution time estimate to assign group?

    max_est_exec_time            max. estimated execution time in seconds

    undo_pool                            max. cumulative undo allocated for consumer groups

    max_idle_time                    max. idle time

    max_idle_blocker_time    max. idle time when blocking other sessions

    switch_time_in_call          max execution time within a top call - will switch back to home group after call



    ﻻﺤﻅ ﺃﻥ ﻫﻨﺎﻙ ٨ ﻤﺴﺘﻭﻴﺎﺕ ﻟﺘﻭﺯﻴﻊ ﻤﺼﺎﺩﺭ ﺍلCPU ﺒﻴﻥ ﺍﻟﻤﺠﻤﻭﻋﺎﺕ، ﻤﻊ ﺍﻟﺘﺄﻜﻴﺩ ﻋﻠﻲ ﺃﻥ ﻜل DIRECTIVE ﻤﻭﺠﻬﺔ لGroup Consumer ﻭﺍﺤﺩﺓ،

    ﻭﻟﻨﻔﺘﺭﺽ ﺍﻻﻥ ﺃﻨﻨﺎ ﻨﺭﻴﺩ ﺇﻨﺸﺎﺀ Plan ﺘﺴﻤﻲ NEW_PLAN ﻫﺫﻩ ﺍلPlan ﻤﻭﺠﻬﺔ ﻟﺜﻼﺙ ﻤﺠﻤﻭﻋﺎﺕ ﻭﻫﻲ (SYS_GROUP & NEW_GROUP &  OTHER_GROUPS).

    ﺃﻱ ﺃﻨﻨﺎ ﻨﺤﺘﺎﺝ Plan ﻭﺍﺤﺩة ﻭﺜﻼﺙ Directives, ﻜل Directive ﻤﻭﺠﻬﺔ  لConsumer Group ﻤﻌﻴﻨﺔ.

    ﻟﻨﻔﺘﺭﺽ ﺃﻨﻨﺎ ﻨﺭﻴﺩ ﻤﻨﺢ ﺍﻟﻤﺠﻤﻭﻋﺔ SYS_GROUP ﺠﺯﺀ ﻤﻥ ﻤﺼﺎﺩﺭ ﺍلCPU ﻋﻠﻲ ﺍﻟﻨﺤﻭ ﺍﻟﺘﺎﻟﻲ:

    ﺍﻟﻤﺴﺘﻭﻱ ﺍﻻﻭل: 60%.

    ﺍﻟﻤﺴﺘﻭﻱ ﺍﻟﺜﺎﻨﻲ: 50%.

    ﺍﻟﻤﺴﺘﻭﻱ ﺍﻟﺜﺎﻟﺙ: 40%.

    ﺒﻤﻌﻨﻲ ﺃﻨﻪ ﻓﻲ ﺍﻟﻤﺴﺘﻭﻱ ﺍﻷﻭل ﺍﻷﻭﻟﻴﺔ ﻟﻠﻤﺠﻤﻭﻋﺔ SYS_GROUP ﺒﻨﺴﺒﺔ ﺘﺼل ﺇﻟﻲ 60 % ﻭﺃﻤﺎ ﺍﻟﻨﺴﺒﺔ ﺍﻟﺒﺎﻗﻴﺔ ﻭﻫﻲ 40 % ﺴﻴﺘﻡ ﺘﻘﺴﻴﻤﻬﺎ ﺒﻴﻥ ﺍﻟﻤﺠﻤﻭﻋﺘﻴﻥ ﺍﻻﺨﺭﺘﻴﻥ

    (NEW_GROUP & OTHER_GROUPS) ﻭﺫﻟﻙ ﻋﻠﻲ ﺍﻟﻨﺤﻭ ﺍﻟﺘﺎﻟﻲ:

    ﺍﻟﻤﺴﺘﻭﻱ ﺍﻷﻭل: 20 %.

    ﺍﻟﻤﺴﺘﻭﻱ ﺍﻟﺜﺎﻨﻲ: 25%.

    ﺍﻟﻤﺴﺘﻭﻱ ﺍﻟﺜﺎﻟﺙ: 30%.


    ﺇﻨﺸﺎﺀ Resource Manager Plans and Directive:



    PLAN VARCHAR2(200);









    PLAN := 'NEW_PLAN';



    CPU_P1 :=20 ;

    CPU_P2 :=25 ;

    CPU_P3 :=30 ;


    MAX_IDLE_TIME := 2;












    ﻫﻜﺫﺍ ﻗﻤﻨﺎ ﺒﺈﻨﺸﺎﺀ PLAN ﺘﺴﻤﻲ NEW_PLAN ﻭﺃﻴﻀﺎﹰ ﻗﻤﻨﺎ ﺒﺈﻨﺸﺎﺀ ﺜﻼﺙ Directives ﻤﻭﺠﻬﺔ للمجموعات (OTHER_GROUPS & SYS_GROUP & NEW_GROUP).

    يجب ﺍﻟﺘﺫﻜﻴﺭ ﺒﺄﻨﻙ ﺘﺴﺘﻁﻴﻊ ﺍﻟﺘﻌﺎﻤل ﻤﻊ ﺜﻤﺎﻨﻴﺔ ﻤﺴﺘﻭﻴﺎﺕ، ﺒﻌﺩ ﺫﻟﻙ ﻴﻤﻜﻥ ﻤﻨﺢ ﺒﺎﻗﻲ ﺍﻟﻤﺘﻐﻴﺭﺍﺕ ﻤﺜل ﺍل active_sess_pool_p1 ﻭﻫﻲ ﻟﺘﺤﺩﻴﺩ ﺃﻜﺒﺭ ﻋﺩﺩ ﻟلSessions ﺍﻟﻨﺸﻁﺔ ﺍﻟﺘﻲ ﺘﻨﺘﻤﻲ

    لConsumer Group ﻭﺍﺤﺩﺓ ﺒﻌﺩ ﻫﺫﺍ ﺍﻟﻌﺩﺩ ﺴﺘﻅل ﺍلSessions ﻓﻲ ﺼﻑ ﺍﻹﻨﺘﻅﺎﺭ. ﻭﺃﻴﻀﺎﹰ ﺍل max_idle_time ﻟﺘﺤﺩﻴﺩ ﺍﻟﻭﻗﺕ ﺍﻟﺫﻱ ﻴﻤﻜﻥ ﺃﻥ ﺘﻅﻠﻪ ﺍلSession ﻋﺎﻁﻠﺔ ﺒﻌﺩﻩ ﻴﺘﻡ ﺇﻨﻬﺎﺀ ﻫﺫﻩ

    ﺍلSession ﻭﻫﻜﺫﺍ ﺒﺎﻗﻲ ﺍﻟﻤﺘﻐﻴﺭﺍﺕ.

    ﺍﻻﻥ ﻨﺴﺘﻁﻴﻊ ﺘﻔﻌﻴل ﻫﺫﻩ ﺍلPlan ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻋﻥ ﻁﺭﻴﻕ ﺍﻻﻤﺭ:




    ﻓﻲ ﻫﺫﻩ ﺍﻟﻠﺤﻅﺔ ﺴﻭﻑ ﻴﺘﻡ ﺘﻔﻌﻴل ﻫﺫﻩ ﺍلPlan ﻋﻠﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ.

    ﻴﻤﻜﻨﻙ ﺍﻹﺴﺘﻌﻼﻡ ﻋﻥ ﺍلPlan ﻭﺍلDirective ﻋﻥ ﻁﺭﻴﻕ: