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
Session-Level SQL Tracing
ﻴﻤﻜﻥ ﺘﻔﻌﻴل ﺍلTracing ﻋﻠﻲ ﻤﺴﺘﻭﻱ ﺍلSession.
alter session set sql_trace=true; |
ﺒﻌﺩ ﺘﻬﻴﺌﺔ ﺍلSession ﻴﺘﻡ ﺘﻭﻟﻴﺩ ﺍلTrace File ﻓﻲ ﺍﻟﻤﺴﺎﺭ User_Dump_Dest، ﺒﺤﻴﺙ ﻴﺘﺴﻤﻲ ﻤﻠﻑ ﺍلTrace ﺒﺎل(process ID number of the server process).
ﺍﻻﻥ ﻴﺘﻡ ﺇﻨﺸﺎﺀ Trace File ﻋﻨﺩ ﻋﻤل SQL Statement ﻭﻴﺘﻡ ﺘﺨﺯﻴﻥ ﺍﻟﻤﻠﻑ ﻓﻲ ﺍﻟﻤﺴﺎﺭ User_Dump_Dest.
ﻴﺴﺘﻁﻴﻊ ﻜﺫﻟﻙ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺘﻔﻌﻴل ﺍلTracing لUser Session ﻤﻌﻴﻨﺔ ﻋﻥ ﻁﺭﻴﻕ ﺍﻹﺠﺭﺍﺀ Session_Trace_Enable ﺍﻟﻤﻭﺠﻭﺩ ﻓﻲ ﺍﻟﺤﺯﻤﺔ DBMS_MONITOR،
ﻭﺫﻟﻙ ﺒﻌﺩ ﺘﺤﺩﻴﺩ الSessiom عن طريق (Session Identifier & Serial Number).
ﻭﻟﻨﻔﺘﺭﺽ ﺍﻻﻥ ﻨﺭﻴﺩ ﻭﻀﻊ ﺍلSession ﻟﻠﻤﺴﺘﺨﺩﻡ OBAY ﻓﻲ ﺍﻟﻭﻀﻊ Tracing.
Select Sid, serial# from v$session where username='OBAY'; |
ﺍﻻﻥ ﻋﻥ ﻁﺭﻴﻕ ﻤﻌﻠﻭﻤﺎﺕ ﻫﺫﻩ ﺍلSession ﻨﺴﺘﻁﻴﻊ ﺘﻔﻌﻴﻠﻬﺎ ﻓﻲ ﺍﻟﻭﻀﻊ Tracing.
begin dbms_monitor.session_trace_enable( session_id=>841, serial_num=>27); end; / |
ﺘﺴﺘﻁﻴﻊ ﻜﺫﻟﻙ ﺘﻌﻁﻴل ﻫﺫﺍ ﺍﻟﻭﻀﻊ ﻤﻥ ﺨﻼل ﺍﻹﺠﺭﺍﺀ Session_Trace_Disable.
-----------------------------------------------