{"id":38878,"date":"2026-02-09T18:00:35","date_gmt":"2026-02-09T15:00:35","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/"},"modified":"2026-02-09T18:00:35","modified_gmt":"2026-02-09T15:00:35","slug":"oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/","title":{"rendered":"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi"},"content":{"rendered":"<h2>Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi<\/h2>\n<p>Oracle AI Database 26ai, yapay zeka ve makine \u00f6\u011frenimi yetenekleriyle donat\u0131lm\u0131\u015f, performans ve g\u00fcvenli\u011fi otonom bir \u015fekilde optimize eden yeni nesil bir veritaban\u0131 platformudur. Bu yenilik\u00e7i yap\u0131, y\u00fcksek eri\u015filebilirlik ve felaket kurtarma senaryolar\u0131nda kritik rol oynayan Active Data Guard (ADG) ile birle\u015fti\u011finde, performans y\u00f6netiminin karma\u015f\u0131kl\u0131\u011f\u0131 artmaktad\u0131r. Otomatik \u0130\u015f Y\u00fck\u00fc Deposu (AWR), Oracle veritabanlar\u0131n\u0131n performans\u0131n\u0131 izlemek, analiz etmek ve sorunlar\u0131 gidermek i\u00e7in vazge\u00e7ilmez bir ara\u00e7t\u0131r. Bu makale, Oracle AI Database 26ai&#8217;nin sundu\u011fu geli\u015fmi\u015f \u00f6zellikler ba\u011flam\u0131nda, Active Data Guard ortam\u0131nda AWR y\u00f6netiminin inceliklerini, en iyi uygulamalar\u0131n\u0131 ve performans optimizasyon stratejilerini detayl\u0131 bir \u015fekilde ele alacakt\u0131r.<\/p>\n<h2>Oracle AI Database 26ai&#8217;ye Genel Bak\u0131\u015f<\/h2>\n<p>Oracle AI Database 26ai, Oracle&#8217;\u0131n veritaban\u0131 teknolojisindeki en son yeniliklerini temsil eder. Temelinde yapay zeka ve makine \u00f6\u011frenimi algoritmalar\u0131 bar\u0131nd\u0131rarak, geleneksel veritaban\u0131 y\u00f6netimini bir ad\u0131m \u00f6teye ta\u015f\u0131r. Bu yeni s\u00fcr\u00fcm, \u00f6zellikle performans optimizasyonu, g\u00fcvenlik ve otonom operasyonlar konusunda \u00e7\u0131\u011f\u0131r a\u00e7an \u00f6zellikler sunar.<\/p>\n<h3>26ai&#8217;nin Temel \u00d6zellikleri<\/h3>\n<p>26ai, veritaban\u0131 y\u00f6neticilerinin (DBA) i\u015f y\u00fck\u00fcn\u00fc hafifletirken, veritaban\u0131 performans\u0131n\u0131 ve g\u00fcvenli\u011fini maksimum seviyeye \u00e7\u0131karmay\u0131 hedefler. Ba\u015fl\u0131ca \u00f6zellikleri aras\u0131nda \u015funlar yer al\u0131r:<\/p>\n<ul>\n<li><b>Yapay Zeka Destekli Performans Optimizasyonu:<\/b> Veritaban\u0131 i\u015f y\u00fcklerini s\u00fcrekli izleyerek, anormallikleri tespit eder ve otomatik performans ayarlamalar\u0131 \u00f6nerir veya uygular.<\/li>\n<li><b>Otonom Y\u00f6netim Yetenekleri:<\/b> Kendi kendine yama, kendi kendine ayarlama ve kendi kendine onarma gibi otonom \u00f6zellikler sayesinde insan m\u00fcdahalesini minimize eder.<\/li>\n<li><b>Geli\u015fmi\u015f G\u00fcvenlik:<\/b> Makine \u00f6\u011frenimi tabanl\u0131 tehdit tespiti ve otomatik g\u00fcvenlik yamalar\u0131 ile veri g\u00fcvenli\u011fini art\u0131r\u0131r.<\/li>\n<li><b>Ak\u0131ll\u0131 Kaynak Y\u00f6netimi:<\/b> \u0130\u015f y\u00fck\u00fc taleplerine g\u00f6re kaynaklar\u0131 dinamik olarak tahsis eder ve optimize eder.<\/li>\n<\/ul>\n<h3>Geleneksel Oracle Veritabanlar\u0131ndan Farklar\u0131<\/h3>\n<p>26ai&#8217;yi geleneksel Oracle s\u00fcr\u00fcmlerinden ay\u0131ran en \u00f6nemli fark, yapay zeka entegrasyonudur. Geleneksel veritabanlar\u0131, performans sorunlar\u0131n\u0131 tespit etmek ve \u00e7\u00f6zmek i\u00e7in DBA&#8217;lar\u0131n manuel analizlerine ve deneyimlerine b\u00fcy\u00fck \u00f6l\u00e7\u00fcde ba\u011f\u0131ml\u0131yken, 26ai bu s\u00fcre\u00e7leri otomatikle\u015ftirir ve ak\u0131ll\u0131 hale getirir. \u00d6rne\u011fin, AWR raporlar\u0131n\u0131 analiz ederken, 26ai anormallikleri otomatik olarak belirleyebilir, olas\u0131 k\u00f6k nedenleri hakk\u0131nda tahminlerde bulunabilir ve hatta \u00e7\u00f6z\u00fcm \u00f6nerileri sunabilir. Bu, performans y\u00f6netimini daha proaktif ve verimli hale getirir.<\/p>\n<h2>Active Data Guard ve AWR \u0130li\u015fkisi<\/h2>\n<p>Active Data Guard (ADG), Oracle&#8217;\u0131n y\u00fcksek eri\u015filebilirlik ve felaket kurtarma \u00e7\u00f6z\u00fcmlerinin temel ta\u015flar\u0131ndan biridir. Birincil (primary) veritaban\u0131n\u0131n bir kopyas\u0131n\u0131 s\u00fcrekli olarak g\u00fcncel tutarak, olas\u0131 bir felaket durumunda kesintisiz hizmet sa\u011flaman\u0131n yan\u0131 s\u0131ra, raporlama ve sorgulama gibi salt okunur i\u015f y\u00fcklerini de \u00fcstlenerek birincil veritaban\u0131n\u0131n y\u00fck\u00fcn\u00fc hafifletir.<\/p>\n<h3>Active Data Guard&#8217;\u0131n Rol\u00fc ve Faydalar\u0131<\/h3>\n<p>ADG&#8217;nin sa\u011flad\u0131\u011f\u0131 ba\u015fl\u0131ca faydalar \u015funlard\u0131r:<\/p>\n<ul>\n<li><b>Y\u00fcksek Eri\u015filebilirlik:<\/b> Birincil veritaban\u0131 ar\u0131zaland\u0131\u011f\u0131nda, standby veritaban\u0131 h\u0131zl\u0131 bir \u015fekilde birincil rol\u00fcn\u00fc \u00fcstlenebilir.<\/li>\n<li><b>Felaket Kurtarma:<\/b> Co\u011frafi olarak ayr\u0131lm\u0131\u015f standby veritabanlar\u0131 ile b\u00f6lgesel felaketlere kar\u015f\u0131 koruma sa\u011flar.<\/li>\n<li><b>Performans \u0130zolasyonu:<\/b> Raporlama, yedekleme ve test gibi i\u015f y\u00fcklerini standby veritaban\u0131na aktararak birincil veritaban\u0131n\u0131n performans\u0131n\u0131 korur.<\/li>\n<li><b>Veri Korumas\u0131:<\/b> Veri kayb\u0131n\u0131 en aza indirir veya tamamen ortadan kald\u0131r\u0131r.<\/li>\n<\/ul>\n<h3>Standby Veritaban\u0131nda AWR \u0130statistikleri Toplama<\/h3>\n<p>Active Data Guard ortam\u0131nda, AWR istatistiklerinin hem birincil hem de standby veritabanlar\u0131nda toplanmas\u0131 kritik \u00f6neme sahiptir. Birincil veritaban\u0131, yazma ve okuma i\u015flemlerini y\u00f6netirken, standby veritaban\u0131 sadece okuma i\u015f y\u00fcklerini (ADG durumunda) ve redo uygulamas\u0131n\u0131 y\u00f6netir. Bu farkl\u0131 i\u015f y\u00fck\u00fc profilleri, her iki veritaban\u0131n\u0131n performans\u0131n\u0131 ayr\u0131 ayr\u0131 izlemeyi gerektirir. Standby veritaban\u0131nda toplanan AWR istatistikleri, redo uygulama gecikmeleri, sorgu performans\u0131 ve I\/O y\u00fck\u00fc gibi ADG&#8217;ye \u00f6zg\u00fc performans metriklerini anlamam\u0131z\u0131 sa\u011flar. Bu sayede, birincil ve standby aras\u0131ndaki performans farklar\u0131n\u0131 analiz edebilir, potansiyel darbo\u011fazlar\u0131 belirleyebilir ve ADG ortam\u0131n\u0131n genel sa\u011fl\u0131\u011f\u0131n\u0131 de\u011ferlendirebiliriz.<\/p>\n<h2>AWR Snapshot Mekanizmas\u0131 ve Active Data Guard<\/h2>\n<p>AWR (Automatic Workload Repository), Oracle veritaban\u0131n\u0131n performans istatistiklerini belirli aral\u0131klarla toplayan, saklayan ve analiz i\u00e7in kullan\u0131labilir hale getiren bir depodur. Bu istatistikler &#8220;snapshot&#8221; ad\u0131 verilen anl\u0131k g\u00f6r\u00fcnt\u00fcler halinde al\u0131n\u0131r.<\/p>\n<h3>AWR Snapshot Olu\u015fturma ve Y\u00f6netimi<\/h3>\n<p>AWR snapshot&#8217;lar\u0131, <code>DBMS_WORKLOAD_REPOSITORY<\/code> paketi kullan\u0131larak y\u00f6netilir. Varsay\u0131lan olarak, Oracle her saat ba\u015f\u0131 bir snapshot al\u0131r ve bu snapshot&#8217;lar\u0131 8 g\u00fcn boyunca saklar. Bu ayarlar <code>DBA_HIST_WR_CONTROL<\/code> g\u00f6r\u00fcn\u00fcm\u00fcnden sorgulanabilir ve <code>DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS<\/code> prosed\u00fcr\u00fc ile de\u011fi\u015ftirilebilir.<\/p>\n<pre><code class=\"language-sql\">\n-- Mevcut AWR snapshot ayarlar\u0131n\u0131 g\u00f6r\u00fcnt\u00fcleme\nSELECT snap_interval, retention FROM dba_hist_wr_control;\n\n-- Snapshot aral\u0131\u011f\u0131n\u0131 30 dakikaya, saklama s\u00fcresini 15 g\u00fcne ayarlama\nEXEC DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(interval => 30, retention => 21600); -- retention dakika cinsinden\n<\/pre>\n<p><\/code><br \/>\nManuel snapshot'lar, belirli bir performans testi \u00f6ncesinde veya sonras\u0131nda anl\u0131k durum tespiti yapmak i\u00e7in <code>DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT<\/code> prosed\u00fcr\u00fc ile olu\u015fturulabilir.<\/p>\n<h3>ADG Ortam\u0131nda Snapshot Senkronizasyonu<\/h3>\n<p>Active Data Guard ortam\u0131nda, AWR snapshot'lar\u0131n\u0131n toplanmas\u0131 ve y\u00f6netimi \u00f6zel bir mekanizma ile i\u015fler. Birincil veritaban\u0131nda al\u0131nan AWR snapshot'lar\u0131, redo stream'in bir par\u00e7as\u0131 olarak standby veritaban\u0131na g\u00f6nderilir. Bu, standby veritaban\u0131n\u0131n kendi ba\u015f\u0131na AWR istatistikleri toplamak yerine, birincil veritaban\u0131ndan gelen verileri kullanmas\u0131n\u0131 sa\u011flar. Bu senkronizasyon sayesinde, standby veritaban\u0131 da birincil ile ayn\u0131 AWR verilerine sahip olur ve bu veriler \u00fczerinden performans raporlar\u0131 olu\u015fturulabilir.<br \/>\nStandby veritaban\u0131, birincil veritaban\u0131ndan gelen redo verilerini uygularken, AWR snapshot verilerini de <code>DBA_HIST_SNAPSHOT<\/code>, <code>DBA_HIST_SQLSTAT<\/code>, <code>DBA_HIST_SYSMETRIC_SUMMARY<\/code> gibi <code>DBA_HIST_<\/code> g\u00f6r\u00fcn\u00fcmleri arac\u0131l\u0131\u011f\u0131yla kendi AWR deposuna yazar. Bu, standby'\u0131n salt okunur modda \u00e7al\u0131\u015f\u0131rken bile kendi performans ge\u00e7mi\u015fini tutabilmesini sa\u011flar.<\/p>\n<h2>Active Data Guard \u00dczerinde AWR Raporlar\u0131 Olu\u015fturma ve Analiz Etme<\/h2>\n<p>Active Data Guard ortam\u0131nda, hem birincil hem de standby veritabanlar\u0131ndan AWR raporlar\u0131 olu\u015fturmak ve bunlar\u0131 kar\u015f\u0131la\u015ft\u0131rmak, sistemin genel sa\u011fl\u0131\u011f\u0131n\u0131 ve performans\u0131n\u0131 anlamak i\u00e7in hayati \u00f6neme sahiptir.<\/p>\n<h3>Standby Veritaban\u0131nda AWR Raporu \u00dcretimi<\/h3>\n<p>Standby veritaban\u0131 salt okunur modda \u00e7al\u0131\u015ft\u0131\u011f\u0131 i\u00e7in, AWR raporlar\u0131 da normal bir veritaban\u0131nda oldu\u011fu gibi olu\u015fturulabilir. Bunun i\u00e7in genellikle <code>awrrpt.sql<\/code> veya <code>awrrpti.sql<\/code> (instance baz\u0131nda) script'leri kullan\u0131l\u0131r.<\/p>\n<pre><code class=\"language-sql\">\n-- Standby veritaban\u0131nda AWR raporu olu\u015fturma ad\u0131mlar\u0131 (SQL*Plus \u00fczerinden)\n-- 1. SYSDBA olarak ba\u011flan\u0131n\n-- sqlplus \/ as sysdba\n\n-- 2. awrrpt.sql script'ini \u00e7al\u0131\u015ft\u0131r\u0131n\n-- @?\/rdbms\/admin\/awrrpt.sql\n\n-- 3. Rapor format\u0131n\u0131 se\u00e7in (HTML veya TEXT)\n-- 4. Ba\u015flang\u0131\u00e7 ve biti\u015f snapshot ID'lerini girin\n-- 5. Rapor i\u00e7in bir dosya ad\u0131 belirleyin\n<\/pre>\n<p><\/code><br \/>\nBu raporlar, standby'\u0131n kendi i\u00e7indeki performans\u0131n\u0131 (redo uygulama h\u0131z\u0131, sorgu performans\u0131, I\/O kullan\u0131m\u0131 vb.) detayl\u0131 bir \u015fekilde g\u00f6sterir.<\/p>\n<h3>Performans Analizi ve Farkl\u0131l\u0131klar\u0131 Yorumlama<\/h3>\n<p>Birincil ve standby AWR raporlar\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131r\u0131rken, \u00f6zellikle a\u015fa\u011f\u0131daki metrik ve olaylara odaklanmak \u00f6nemlidir:<\/p>\n<ul>\n<li><b>Wait Olaylar\u0131:<\/b> Standby'da <code>log file sync<\/code> veya <code>redo apply<\/code> ile ilgili bekleme olaylar\u0131, birincil veritaban\u0131na g\u00f6re farkl\u0131l\u0131k g\u00f6sterebilir. \u00d6zellikle <code>managed standby redo apply<\/code> ile ilgili bekleme olaylar\u0131, redo uygulama performans\u0131n\u0131 g\u00f6sterir.<\/li>\n<li><b>SQL \u0130statistikleri:<\/b> Standby \u00fczerinde \u00e7al\u0131\u015ft\u0131r\u0131lan salt okunur sorgular\u0131n performans\u0131, birincil veritaban\u0131ndaki benzer sorgularla kar\u015f\u0131la\u015ft\u0131r\u0131lmal\u0131d\u0131r. Standby'da daha yava\u015f \u00e7al\u0131\u015fan sorgular, indeks eksikli\u011fi veya farkl\u0131 kaynak tahsisi gibi nedenlerden kaynaklanabilir.<\/li>\n<li><b>I\/O ve CPU Kullan\u0131m\u0131:<\/b> Standby'\u0131n I\/O ve CPU kullan\u0131m\u0131, birincil veritaban\u0131na g\u00f6re daha d\u00fc\u015f\u00fck olmal\u0131, ancak raporlama i\u015f y\u00fckleri veya redo uygulamas\u0131 nedeniyle belirli art\u0131\u015flar g\u00f6zlemlenebilir.<\/li>\n<li><b>Veritaban\u0131 Hizmetleri:<\/b> ADG'de hizmetler farkl\u0131 instance'lara y\u00f6nlendirilebilir. Hangi hizmetlerin hangi veritaban\u0131nda daha yo\u011fun \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 analiz etmek, i\u015f y\u00fck\u00fc dengelemesi i\u00e7in fikir verebilir.<\/li>\n<\/ul>\n<p>Bu kar\u015f\u0131la\u015ft\u0131rmalar, ADG yap\u0131land\u0131rmas\u0131n\u0131n etkinli\u011fini de\u011ferlendirmeye ve potansiyel performans darbo\u011fazlar\u0131n\u0131 tespit etmeye yard\u0131mc\u0131 olur.<\/p>\n<h2>Oracle AI Database 26ai'nin AWR Y\u00f6netimine Katk\u0131lar\u0131<\/h2>\n<p>Oracle AI Database 26ai, AWR verilerini toplama ve raporlama s\u00fcre\u00e7lerinin \u00f6tesine ge\u00e7erek, yapay zeka ve makine \u00f6\u011frenimi yetenekleriyle performans y\u00f6netimini devrim niteli\u011finde d\u00f6n\u00fc\u015ft\u00fcr\u00fcyor.<\/p>\n<h3>AI Destekli Performans Analizi<\/h3>\n<p>26ai, AWR verilerini kullanarak otomatik olarak performans analizi yapabilir. Geleneksel AWR raporlar\u0131 DBA'lar\u0131n manuel olarak yorumlamas\u0131n\u0131 gerektirirken, 26ai:<\/p>\n<ul>\n<li><b>Anomali Tespiti:<\/b> AWR ge\u00e7mi\u015f verilerini analiz ederek normalin d\u0131\u015f\u0131ndaki performans davran\u0131\u015flar\u0131n\u0131 (\u00f6rne\u011fin, beklenmedik bir CPU art\u0131\u015f\u0131 veya belirli bir bekleme olay\u0131n\u0131n y\u00fckseli\u015fi) otomatik olarak belirler.<\/li>\n<li><b>Tahmine Dayal\u0131 Sorunlar:<\/b> Mevcut trendlere dayanarak gelecekteki performans sorunlar\u0131n\u0131 tahmin edebilir ve proaktif uyar\u0131lar g\u00f6nderebilir.<\/li>\n<li><b>Ak\u0131ll\u0131 \u00d6neriler:<\/b> Tespit edilen sorunlar i\u00e7in olas\u0131 k\u00f6k nedenleri hakk\u0131nda hipotezler \u00fcretir ve performans iyile\u015ftirme i\u00e7in somut \u00f6neriler sunar (\u00f6rne\u011fin, bir SQL sorgusunun yeniden yaz\u0131lmas\u0131, bir indeksin eklenmesi veya bir parametrenin ayarlanmas\u0131).<\/li>\n<\/ul>\n<p>Bu yetenekler, DBA'lar\u0131n sorun giderme s\u00fcre\u00e7lerini h\u0131zland\u0131r\u0131r ve veritaban\u0131 performans\u0131n\u0131 s\u00fcrekli olarak optimize etmelerine olanak tan\u0131r.<\/p>\n<h3>Otonom AWR Ayarlamalar\u0131<\/h3>\n<p>26ai'nin otonom yetenekleri, AWR y\u00f6netimini de kapsar. Veritaban\u0131, i\u015f y\u00fck\u00fc desenlerine ve performans hedeflerine g\u00f6re AWR snapshot aral\u0131klar\u0131n\u0131 ve saklama s\u00fcrelerini otomatik olarak ayarlayabilir. \u00d6rne\u011fin, yo\u011fun i\u015f y\u00fck\u00fc d\u00f6nemlerinde daha s\u0131k snapshot alarak daha gran\u00fcler veri toplayabilir veya d\u00fc\u015f\u00fck aktivite d\u00f6nemlerinde snapshot s\u0131kl\u0131\u011f\u0131n\u0131 azaltarak kaynak kullan\u0131m\u0131n\u0131 optimize edebilir. Bu otonom ayarlamalar, DBA'lar\u0131n manuel m\u00fcdahalesine gerek kalmadan AWR'nin her zaman en uygun \u015fekilde yap\u0131land\u0131r\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n<h2>En \u0130yi Uygulamalar ve Dikkat Edilmesi Gerekenler<\/h2>\n<p>Oracle AI Database 26ai ve Active Data Guard ortam\u0131nda AWR'yi etkin bir \u015fekilde y\u00f6netmek i\u00e7in baz\u0131 en iyi uygulamalar\u0131 takip etmek ve dikkat edilmesi gereken noktalar\u0131 g\u00f6z \u00f6n\u00fcnde bulundurmak \u00f6nemlidir.<\/p>\n<h3>AWR Snapshot Ayarlar\u0131<\/h3>\n<ul>\n<li><b>Uygun Snapshot Aral\u0131\u011f\u0131:<\/b> Varsay\u0131lan 60 dakikal\u0131k aral\u0131k \u00e7o\u011fu ortam i\u00e7in yeterli olsa da, y\u00fcksek i\u015flem hacmine sahip veya \u00e7ok hassas performans gereksinimleri olan sistemlerde bu aral\u0131\u011f\u0131 15 veya 30 dakikaya d\u00fc\u015f\u00fcrmek daha detayl\u0131 veri sa\u011flayabilir. Ancak \u00e7ok s\u0131k snapshot almak, veritaban\u0131 \u00fczerinde hafif bir y\u00fck olu\u015fturabilir.<\/li>\n<li><b>Saklama S\u00fcresi:<\/b> Performans trendlerini uzun vadede analiz edebilmek i\u00e7in yeterli bir saklama s\u00fcresi belirleyin (\u00f6rne\u011fin, 30 g\u00fcn veya daha fazla). Ancak bu, AWR deposunun boyutunu art\u0131racakt\u0131r. Depo boyutunu ve performans analiz ihtiya\u00e7lar\u0131n\u0131z\u0131 dengeleyin.<\/li>\n<\/ul>\n<h3>Performans \u0130zleme Stratejileri<\/h3>\n<ul>\n<li><b>Hem Primary hem de Standby'\u0131 \u0130zleme:<\/b> Sadece birincil veritaban\u0131n\u0131 de\u011fil, Active Data Guard standby'\u0131n\u0131 da d\u00fczenli olarak AWR raporlar\u0131 ile izleyin. Standby'\u0131n performans\u0131, felaket kurtarma senaryolar\u0131nda kritik \u00f6neme sahiptir.<\/li>\n<li><b>Baseline Olu\u015fturma:<\/b> Normal i\u015f y\u00fck\u00fc d\u00f6nemlerinde AWR raporlar\u0131 alarak performans baseline'lar\u0131 olu\u015fturun. Bu baseline'lar, gelecekteki performans d\u00fc\u015f\u00fc\u015flerini veya anormallikleri tespit etmek i\u00e7in bir referans noktas\u0131 sa\u011flar.<\/li>\n<li><b>ADG'ye \u00d6zg\u00fc Metrikleri Takip Etme:<\/b> Standby'da redo uygulama gecikmeleri, apply rate ve network latency gibi Active Data Guard'a \u00f6zg\u00fc metrikleri AWR raporlar\u0131nda veya <code>V$DATAGUARD_STATS<\/code> gibi g\u00f6r\u00fcn\u00fcmlerden takip edin.<\/li>\n<\/ul>\n<h3>26ai \u00d6zelliklerinden Yararlanma<\/h3>\n<ul>\n<li><b>AI Tabanl\u0131 Performans \u00d6nerilerini Uygulama:<\/b> 26ai'nin AWR verilerine dayanarak sundu\u011fu AI destekli performans \u00f6nerilerini dikkatlice de\u011ferlendirin ve test ortamlar\u0131nda uygulad\u0131ktan sonra \u00fcretim ortam\u0131na ta\u015f\u0131y\u0131n.<\/li>\n<li><b>Otonom Y\u00f6netim \u00d6zelliklerini Etkin Kullanma:<\/b> 26ai'nin otonom AWR ayarlamalar\u0131 gibi \u00f6zelliklerini etkinle\u015ftirerek manuel y\u00f6netim y\u00fck\u00fcn\u00fc azalt\u0131n ve sistemin kendi kendini optimize etmesine izin verin.<\/li>\n<\/ul>\n<h2>Sonu\u00e7<\/h2>\n<p>Oracle AI Database 26ai ve Active Data Guard'\u0131n birle\u015fimi, modern kurumsal ortamlar i\u00e7in y\u00fcksek performansl\u0131, y\u00fcksek eri\u015filebilir ve ak\u0131ll\u0131 bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fc sunar. Bu karma\u015f\u0131k yap\u0131da AWR y\u00f6netimi, sistemin sa\u011fl\u0131\u011f\u0131n\u0131 ve performans\u0131n\u0131 g\u00fcvence alt\u0131na almak i\u00e7in kritik bir rol oynar. 26ai'nin yapay zeka destekli performans analizi ve otonom y\u00f6netim yetenekleri, AWR verilerini yorumlama ve performans sorunlar\u0131n\u0131 giderme s\u00fcre\u00e7lerini d\u00f6n\u00fc\u015ft\u00fcrerek DBA'lara \u00f6nemli avantajlar sa\u011flar. Hem birincil hem de standby veritabanlar\u0131nda AWR'yi etkin bir \u015fekilde kullanarak, do\u011fru snapshot ayarlar\u0131yla ve 26ai'nin ak\u0131ll\u0131 \u00f6zelliklerinden tam olarak yararlanarak, kurulu\u015flar veritaban\u0131 altyap\u0131lar\u0131n\u0131n s\u00fcrekli olarak en y\u00fcksek verimlilikte \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flayabilirler. Gelecekte, yapay zekan\u0131n veritaban\u0131 performans y\u00f6netimindeki rol\u00fc daha da artacak ve 26ai gibi platformlar, bu evrimin \u00f6nc\u00fcs\u00fc olacakt\u0131r.<\/p>\n<h2>S\u0131k Sorulan Sorular (SSS)<\/h2>\n<h3>Active Data Guard'da AWR neden \u00f6nemlidir?<\/h3>\n<p>Active Data Guard ortam\u0131nda AWR, hem birincil hem de standby veritabanlar\u0131n\u0131n performans\u0131n\u0131 ayr\u0131 ayr\u0131 izlemek i\u00e7in hayati \u00f6neme sahiptir. Standby veritaban\u0131, redo uygulama gecikmeleri, raporlama sorgular\u0131n\u0131n performans\u0131 ve ADG'ye \u00f6zg\u00fc bekleme olaylar\u0131 gibi kendi benzersiz performans profiline sahiptir. AWR raporlar\u0131, bu farkl\u0131l\u0131klar\u0131 anlamam\u0131z\u0131, potansiyel darbo\u011fazlar\u0131 tespit etmemizi ve felaket kurtarma yetene\u011finin veya raporlama i\u015f y\u00fcklerinin performans\u0131n\u0131 optimize etmemizi sa\u011flar.<\/p>\n<h3>26ai, AWR y\u00f6netimini nas\u0131l farkl\u0131la\u015ft\u0131r\u0131yor?<\/h3>\n<p>Oracle AI Database 26ai, AWR y\u00f6netimini yapay zeka ve makine \u00f6\u011frenimi ile zenginle\u015ftirir. Geleneksel AWR raporlar\u0131n\u0131n manuel yorumlanmas\u0131 yerine, 26ai AWR verilerini otomatik olarak analiz eder, anormallikleri tespit eder, tahmine dayal\u0131 performans sorunlar\u0131 hakk\u0131nda uyar\u0131lar g\u00f6nderir ve somut performans iyile\u015ftirme \u00f6nerileri sunar. Ayr\u0131ca, i\u015f y\u00fck\u00fc desenlerine g\u00f6re AWR snapshot ayarlar\u0131n\u0131 otonom olarak optimize edebilir.<\/p>\n<h3>Standby \u00fczerinde AWR raporu olu\u015fturmak primary'ye y\u00fck bindirir mi?<\/h3>\n<p>Hay\u0131r, Active Data Guard standby veritaban\u0131 \u00fczerinde AWR raporu olu\u015fturmak, birincil veritaban\u0131na do\u011frudan bir y\u00fck bindirmez. Standby veritaban\u0131, birincil veritaban\u0131ndan gelen redo stream arac\u0131l\u0131\u011f\u0131yla kendi AWR verilerine zaten sahiptir. Rapor olu\u015fturma i\u015flemi, standby'\u0131n kendi kaynaklar\u0131n\u0131 (CPU, I\/O) kullanarak bu yerel verileri i\u015fler. Bu nedenle, raporlama i\u015flemi standby'\u0131n performans\u0131n\u0131 etkileyebilir, ancak birincil veritaban\u0131n\u0131n performans\u0131n\u0131 etkilemez.<\/p>\n<h3>AWR snapshot'lar\u0131 standby'a otomatik olarak kopyalan\u0131r m\u0131?<\/h3>\n<p>Evet, birincil veritaban\u0131nda al\u0131nan AWR snapshot'lar\u0131, redo stream'in bir par\u00e7as\u0131 olarak otomatik olarak Active Data Guard standby veritaban\u0131na kopyalan\u0131r ve uygulan\u0131r. Bu sayede standby veritaban\u0131, birincil ile ayn\u0131 AWR ge\u00e7mi\u015f verilerine sahip olur ve bu veriler \u00fczerinden kendi AWR raporlar\u0131n\u0131 olu\u015fturabilir. Bu senkronizasyon, tutarl\u0131 performans analizi i\u00e7in \u00f6nemlidir.<\/p>\n","protected":false},"excerpt":{"rendered":"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi\nOracle AI Database 26ai, yapay zeka ve makine \u00f6\u011frenimi yetenekleriyle donat\u0131lm\u0131\u015f,&#8230;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[644],"tags":[],"class_list":{"0":"post-38878","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-postgresql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi\" \/>\n<meta property=\"og:description\" content=\"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi Oracle AI Database 26ai, yapay zeka ve makine \u00f6\u011frenimi yetenekleriyle donat\u0131lm\u0131\u015f,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-09T15:00:35+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi\",\"datePublished\":\"2026-02-09T15:00:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/\"},\"wordCount\":2283,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/\",\"name\":\"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-02-09T15:00:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/","og_locale":"tr_TR","og_type":"article","og_title":"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi","og_description":"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi Oracle AI Database 26ai, yapay zeka ve makine \u00f6\u011frenimi yetenekleriyle donat\u0131lm\u0131\u015f,...","og_url":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-02-09T15:00:35+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"12 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi","datePublished":"2026-02-09T15:00:35+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/"},"wordCount":2283,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["PostgreSQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/","url":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/","name":"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-02-09T15:00:35+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/oracle-ai-database-26ai-ve-active-data-guard-ortaminda-awr-yonetimi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle AI Database 26ai ve Active Data Guard Ortam\u0131nda AWR Y\u00f6netimi"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/38878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=38878"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/38878\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=38878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=38878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=38878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}