{"id":98,"date":"2016-03-04T20:59:04","date_gmt":"2016-03-04T18:59:04","guid":{"rendered":"http:\/\/www.bilisimonline.net\/?p=98"},"modified":"2016-03-04T21:03:09","modified_gmt":"2016-03-04T19:03:09","slug":"oracle-veritabani-mimarisi","status":"publish","type":"post","link":"http:\/\/www.bilisimonline.net\/index.php\/2016\/03\/04\/oracle-veritabani-mimarisi\/","title":{"rendered":"Oracle Veritaban\u0131 Mimarisi"},"content":{"rendered":"<p align=\"JUSTIFY\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Bu makalemizde Oracle veritaban\u0131 mimarisi konusu anlataca\u011f\u0131m. Veritaban\u0131 y\u00f6netiminde d\u00fcnya genelinde b\u00fcy\u00fck projelerde Oracle veritaban\u0131n\u0131 g\u00f6rebilirsiniz. Oracle veritaban\u0131n\u0131 \u00f6\u011frenmek i\u00e7in \u00f6ncelikle mimariyi bilme ve iyi anlamak gerekmektedir. S\u00f6z\u00fc \u00e7ok fazla uzatmadan mimariden basetmeye ba\u015flayal\u0131m.<\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Oracle veritaban\u0131 \u00e7al\u0131\u015ft\u0131\u011f\u0131 anda i\u015fletim sisteminde shared gloabal area (SGA) memory alan\u0131 oracle i\u00e7in ayr\u0131l\u0131r. Hem arkas\u0131ndan e\u015f zamanl\u0131 olarak baz\u0131 processler veritaban\u0131na gelen istekleri kar\u015f\u0131lamak i\u00e7in ba\u015flat\u0131l\u0131r. A\u015fa\u011f\u0131daki resimde oracle veritaban\u0131 mimarisini g\u00f6rebilirsiniz. \u015eimdi bu mimarinin par\u00e7alar\u0131ndan k\u0131saca bahsedelim.<\/span><\/span><!--more--><\/p>\n<p align=\"JUSTIFY\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"99\" data-permalink=\"http:\/\/www.bilisimonline.net\/index.php\/2016\/03\/04\/oracle-veritabani-mimarisi\/oracle_vt_mimari\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?fit=498%2C405\" data-orig-size=\"498,405\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"oracle_vt_mimari\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?fit=300%2C244\" data-large-file=\"https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?fit=498%2C405\" tabindex=\"0\" role=\"button\" class=\"alignnone size-full wp-image-99\" src=\"https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?resize=498%2C405\" alt=\"oracle_vt_mimari\" width=\"498\" height=\"405\" srcset=\"https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?w=498 498w, https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?resize=300%2C244 300w, https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?resize=100%2C81 100w, https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?resize=150%2C122 150w, https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?resize=200%2C163 200w, https:\/\/i0.wp.com\/www.bilisimonline.net\/wp-content\/uploads\/2016\/03\/oracle_vt_mimari.jpg?resize=450%2C366 450w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/p>\n<p align=\"JUSTIFY\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>Control Files: <\/b>Control File ctl uzant\u0131l\u0131 i\u015fletim sistemi \u00fczerinde tutulan Oracle veritaban\u0131 i\u00e7in \u00e7ok \u00f6nemli bir dosyad\u0131r. Oracle veritaban\u0131 ilk ba\u015flad\u0131\u011f\u0131nda SPFILE veya PFILE parametre dosyalar\u0131 okunarak Control File dosyas\u0131n\u0131n bulundu\u011fu yer \u00f6\u011frenilir. Minimum 2 kopya tutulurken tavsiye edilen 3 ayn\u0131 kopyay\u0131 farkl\u0131 disklerde tutmakt\u0131r. Control File dosyas\u0131nda ne gibi bilgiler var, bunlar\u0131 listeleyelim.<\/span><\/span><\/p>\n<ul>\n<li><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Veritaban\u0131 ismi (Instance veritaban\u0131 a\u00e7\u0131l\u0131rken veritaban\u0131 ismini buradan \u00f6\u011frenir)<\/span><\/span><\/li>\n<li><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Veritaban\u0131 verilerinin tutuldu\u011fu Datafile dosyalar\u0131n\u0131n yeri<\/span><\/span><\/li>\n<li><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Online Redo log ve Archive log dosyalar\u0131n\u0131n yeri<\/span><\/span><\/li>\n<li><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">RMAN ile al\u0131nan backup bilgileri<\/span><\/span><\/li>\n<li><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Checkpoint bilgisi<\/span><\/span><\/li>\n<li><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Veritaban\u0131 i\u015flemlerinde kullan\u0131lan SCSN (System Change Number) numaras\u0131n\u0131n g\u00fcncel hali<\/span><\/span><\/li>\n<li><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Transactionlar\u0131n tutuldu\u011fu log dosyalar\u0131n\u0131n sequence number bilgisi<\/span><\/span><\/li>\n<li><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Veritaban\u0131 olu\u015fturulma tarihi<\/span><\/span><\/li>\n<\/ul>\n<p align=\"JUSTIFY\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>Data Files: <\/b>Verilerin bulundu\u011fu dbf uzant\u0131l\u0131 dosyalard\u0131r. Oracle veritaban\u0131 olu\u015fturdu\u011funuzda system, undo, sysaux,temp ve user datafile varsay\u0131lan olarak olu\u015fturulur.<\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>SGA: <\/b>Sytem Global Area, oracle instance \u00e7al\u0131\u015ft\u0131\u011f\u0131nda bellek \u00fczerinde ayr\u0131lan aland\u0131r. Oracle instance kapat\u0131lana kadar bu alan kullan\u0131l\u0131r. SGA de\u011ferinin b\u00fcy\u00fck olmas\u0131 performans\u0131 etkileyecektir. SGA de\u011ferinin b\u00fcy\u00fck olmas\u0131 disk \u00fczerinden yap\u0131lan I\/O miktar\u0131n\u0131 azaltaca\u011f\u0131ndan performans\u0131 etkileyecektir. SGA de\u011ferinin kurulum a\u015famas\u0131nda veritaban\u0131n\u0131 olu\u015ftururken belirleriz. K\u0131sacas\u0131 SGA de\u011ferini do\u011fru bir \u015fekilde ayarlanmas\u0131 \u00f6nemlidir.<\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>PGA: <\/b>Program Global Area, Oracle instance ile ilgili bir process \u00e7al\u0131\u015ft\u0131\u011f\u0131nda bellek \u00fczerinden <span style=\"color: #000000;\">ayr\u0131lan aland\u0131r. Process sonlan\u0131nca bu alan b\u0131rak\u0131l\u0131r.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>Shared Pool: <\/b>Library cache ve Dictionary cache&#8217;den olu\u015fmaktad\u0131r.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Library Cache, SQL statementlerin execution planlar\u0131 ve yol haritalar\u0131 bulunur. Execution planlar, optimizer taraf\u0131ndan toplanan istatistiklere g\u00f6re olu\u015fturulur. Sorgu sonucunun daha h\u0131zl\u0131 \u00e7al\u0131\u015fmas\u0131 i\u00e7in kullan\u0131l\u0131r.Database performans\u0131n\u0131 ciddi \u00f6l\u00e7\u00fcde etkiler. \u00d6rne\u011fin veritaban\u0131na bir sorgu geldi\u011finde ilk bu b\u00f6l\u00fcme gelir, sorgu daha \u00f6nce \u00e7al\u0131\u015ft\u0131r\u0131lm\u0131\u015fsa \u00f6nceki execution plan kullan\u0131l\u0131r.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Data Dictionary cache ise o anda al\u0131nan SQL statement i\u00e7in yetki, rol, eri\u015fim izni, hangi indexi kullanacak gibi datalar\u0131n kontrol edildi\u011fi yerdir.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>Database Buffer Cache: <\/b>Veritaban\u0131nda g\u00fcncel ve s\u0131k kullan\u0131lan verilerin tutuldu\u011fu aland\u0131r. Bir transaction&#8217;a ait datalar tutulur.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>Redo Log Buffer:<\/b> Veritaban\u0131nda yap\u0131lan t\u00fcm de\u011fi\u015fiklikler redo log bufferda tutulur. \u00f6rne\u011fin siz bir insert i\u015flemi yapt\u0131n\u0131z. yap\u0131lan de\u011fi\u015fiklik redolog buffer cache de tutulur. LGWR processini tetikleyen bir olay oldu\u011funda redolog buffer kal\u0131c\u0131 olarak redolog dosyalar\u0131na yaz\u0131l\u0131r ve redolog buffer bo\u015falt\u0131l\u0131r, yeni de\u011fi\u015fiklikleri yazmaya tekrar ba\u015flar. Redo loglar veritaban\u0131nda base de bir recovery i\u015fleminde gerekli olan dosyalard\u0131r. Veritaban\u0131nda \u00f6nemli 3 dosyadan biridir.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>Archive Log: <\/b>Veritaban\u0131nda yap\u0131lan de\u011fi\u015fiklikleri loglar. Archivelog mod\u2019da olmayan bir veritaban\u0131nda online olarak backup al\u0131namamaz.Veritaban\u0131n\u0131 kapat\u0131p Cold backup almak zorunda kal\u0131r\u0131z.Bu da hizmet kesintisi dmektir.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>SMON:<\/b> System Monitor, g\u00f6revi Oracle instance kurtarmakt\u0131r. Veritaban\u0131 beklenmedik bir \u015fekilde kapand\u0131\u011f\u0131nda bu process, veritaban\u0131 a\u00e7l\u0131rken online redo log dosyalar\u0131n\u0131 kullanarak oracle instance a\u00e7\u0131lmas\u0131n\u0131 sa\u011flar.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>PMON: <\/b>Process Monitor, ba\u015far\u0131s\u0131z veya birden sonland\u0131r\u0131lan processlerin kulland\u0131\u011f\u0131 kaynaklar\u0131n serbest kal\u0131p sunumcuya iadesini sa\u011flar. Oracle instance&#8217;\u0131n listener ile ileti\u015fim kurmas\u0131n\u0131 sa\u011flar.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>RECO: <\/b>Recoverer Process, veritaban\u0131nda \u00e7e\u015fitli nedenlerden yar\u0131m kalan i\u015flemleri tamamlanmas\u0131n\u0131 sa\u011flar.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>DBWn:<\/b><\/span><\/span><\/span><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"> Database Writer, Datafile&#8217;lar ile Database Buffer Cache aras\u0131nda \u00e7al\u0131\u015fan bir processdir. Bu processin amac\u0131 eklenen,silinen veya degi\u015fiklik yap\u0131lan bloklar\u0131 database buffer cacheden alarak ilgili veri dosyalar\u0131na yazmakt\u0131r. Veriler \u00fczerinde degi\u015fiklikler verilerin saklanmakta oldugu data file dosyalar\u0131na hemen i\u015flenmezler. Ger\u00e7ekle\u015ftirilen t\u00fcm degi\u015fikliklere ait de\u011fi\u015fim verileri (delta verisi) ilk olarak SGA i\u00e7inde yer alan log buffer alan\u0131na ve ard\u0131ndan LGWR i\u015flemiyle online redo log dosyalar\u0131na yaz\u0131l\u0131r.Daha sonra DBWn degi\u015fmi\u015f olan verileri data file dosyalar\u0131na kaydeder. DBWn en az eri\u015filen ve en son eri\u015filme zaman\u0131 \u00fczerinden en fazla ge\u00e7mi\u015f olan bloklar\u0131 datafile dosyalar\u0131na yazmaya \u00e7al\u0131\u015f\u0131r.Bunun sebebi de s\u0131k eri\u015filip s\u0131k s\u0131k degi\u015ftirilen verileri her seferinde data file dosyalar\u0131na yazmayarak performans art\u0131rmakt\u0131r. <\/span><\/span><\/span><strong><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">DBWn<\/span><\/span><\/span><\/strong><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">prosesinin sonunda ki n harfi,birden \u00e7ok Database Writer processe&#8217;in ayn\u0131 anda \u00e7al\u0131\u015fabilecegini g\u00f6sterir. Proses isimleri n yerine 1-9 veya a-j aras\u0131 karakterler gelir .(\u00d6rn.:DBW2,DBWb vb.)<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>LGWR<\/b>: Log Writer Process, log buffer alan\u0131nda bulunan verilerin disk \u00fczerindeki redo log dosyalar\u0131na yaz\u0131lmas\u0131ndan sorumludur.Redo log dosyas\u0131na yaz\u0131lan veriler,veritaban\u0131nda verinin kal\u0131c\u0131 olmas\u0131n\u0131 temin ettikleri i\u00e7in LGWR \u00f6nemli bir prosesdir.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">LGWR a\u015fag\u0131da ki durumlarda tetiklenir ve yazma i\u015flemine ba\u015flar ;<\/span><\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">COMMIT komutu \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r ise<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Log buffer \u00fc\u00e7te bir oran\u0131nda dolar ise<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Her 3 saniyede bir<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">1 megabayt redo kayd\u0131 olmus ise<\/span><\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">DBWn datafile dosyalar\u0131na yazmaya ba\u015flad\u0131g\u0131 zaman<\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>CKPT: <\/b>Checkpoint Process, Instance ar\u0131zas\u0131 durumunda Instance kurtarma s\u00fcresini azaltmak i\u00e7in yard\u0131mc\u0131 olur.Checkpoint olay\u0131 ger\u00e7ekle\u015ftigi zaman DBW prosesi buffer cachedeki verileri datafile\u2018e yazar ve control file dosyas\u0131n\u0131 g\u00fcnceller. Checkpoint olay\u0131 bir redolog ge\u00e7i\u015fi s\u0131ras\u0131nda tetiklenmekte ve \u00e7al\u0131\u015fmaktad\u0131r.<\/span><\/span><\/span><\/p>\n<p align=\"JUSTIFY\"><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"><b>ARCn:<\/b><\/span><\/span><\/span><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\"> Archiver Process, <\/span><\/span><\/span><strong><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">Oracle Archive<\/span><\/span><\/span><\/strong> <strong><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">log <\/span><\/span><\/span><\/strong><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\"><span style=\"font-size: small;\">modunda \u00e7al\u0131\u015ft\u0131g\u0131 zaman ,online redo log dosyalar\u0131n\u0131n \u00fczerine tekrar yaz\u0131lmadan ba\u015fka bir yere kopyalamas\u0131n\u0131 yedeklemesini saglamaktad\u0131r.<\/span><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bu makalemizde Oracle veritaban\u0131 mimarisi konusu anlataca\u011f\u0131m. Veritaban\u0131 y\u00f6netiminde d\u00fcnya genelinde b\u00fcy\u00fck projelerde Oracle veritaban\u0131n\u0131 g\u00f6rebilirsiniz. Oracle veritaban\u0131n\u0131 \u00f6\u011frenmek i\u00e7in \u00f6ncelikle mimariyi bilme ve iyi anlamak gerekmektedir. S\u00f6z\u00fc \u00e7ok fazla uzatmadan mimariden basetmeye ba\u015flayal\u0131m. Oracle veritaban\u0131 \u00e7al\u0131\u015ft\u0131\u011f\u0131 anda i\u015fletim sisteminde shared gloabal area (SGA) memory alan\u0131 oracle i\u00e7in ayr\u0131l\u0131r. Hem arkas\u0131ndan e\u015f zamanl\u0131 olarak baz\u0131 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[66,65],"tags":[129,122,121,119,120,139,138,124,123,117,133,118,137,116,135,127,136,125,126,130,134,132,128,131],"class_list":["post-98","post","type-post","status-publish","format-standard","hentry","category-veritabani","category-yazilim","tag-archive-log","tag-archiver-process","tag-arcn","tag-checkpoint-process","tag-ckpt","tag-control-file","tag-data-file","tag-database-writer","tag-dbwn","tag-lgwr","tag-library-cache","tag-log-writer-process","tag-oracle-instance","tag-oracle-veritabani-mimarisi","tag-pga","tag-pmon","tag-program-global-area","tag-reco","tag-recoverer-process","tag-redo-log","tag-sga","tag-shared-pool","tag-smon","tag-system-monitor"],"jetpack_publicize_connections":[],"aioseo_notices":[],"views":2902,"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7k56R-1A","jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/posts\/98"}],"collection":[{"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/comments?post=98"}],"version-history":[{"count":2,"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/posts\/98\/revisions"}],"predecessor-version":[{"id":103,"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/posts\/98\/revisions\/103"}],"wp:attachment":[{"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/media?parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/categories?post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bilisimonline.net\/index.php\/wp-json\/wp\/v2\/tags?post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}