{"id":12201,"date":"2019-06-02T00:39:49","date_gmt":"2019-06-02T00:39:49","guid":{"rendered":"https:\/\/dbtut.com\/?p=12201"},"modified":"2020-10-02T08:19:49","modified_gmt":"2020-10-02T08:19:49","slug":"how-to-find-oracle-database-memory-usagesga-and-pga","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/","title":{"rendered":"How To Find Oracle Database Memory Usage(SGA and PGA)"},"content":{"rendered":"<p>The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values \u200b\u200bfrom time to time, it will be necessary to examine the processes in the relevant time interval. From the dba_hist_snapshot view, memory usage rates can be determined by a query such as the following.<\/p>\n\n<pre class=\"lang:default decode:true\">SQL&gt; set lines 1000\nSQL&gt; set pages 1000\nSQL&gt;   SELECT sn.INSTANCE_NUMBER,\n         sga.allo sga,\n         pga.allo pga,\n         (sga.allo + pga.allo) tot,\n         TRUNC (SN.END_INTERVAL_TIME, 'mi') time\n    FROM (  SELECT snap_id,\n                   INSTANCE_NUMBER,\n                   ROUND (SUM (bytes) \/ 1024 \/ 1024 \/ 1024, 3) allo\n              FROM DBA_HIST_SGASTAT\n          GROUP BY snap_id, INSTANCE_NUMBER) sga,\n         (  SELECT snap_id,\n                   INSTANCE_NUMBER,\n                   ROUND (SUM (VALUE) \/ 1024 \/ 1024 \/ 1024, 3) allo\n              FROM DBA_HIST_PGASTAT\n             WHERE name = 'total PGA allocated'\n          GROUP BY snap_id, INSTANCE_NUMBER) pga,\n         dba_hist_snapshot sn\n   WHERE     sn.snap_id = sga.snap_id\n         AND sn.INSTANCE_NUMBER = sga.INSTANCE_NUMBER\n         AND sn.snap_id = pga.snap_id\n         AND sn.INSTANCE_NUMBER = pga.INSTANCE_NUMBER\nORDER BY sn.snap_id DESC, sn.INSTANCE_NUMBER;<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12201\" class=\"pvc_stats all  \" data-element-id=\"12201\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values \u200b\u200bfrom time to time, it will be necessary to examine the processes in the relevant time interval. From the dba_hist_snapshot view, memory usage rates can be determined by a query such &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12201\" class=\"pvc_stats all  \" data-element-id=\"12201\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":12202,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[4229,4230,4226,4235,4236,4237,4231,4233,4232,4234,4228,4227],"class_list":["post-12201","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-find-pga-usage","tag-find-sga-usage","tag-how-much-memory-is-truly-used-by-my-oracle-instance","tag-how-to-check-free-memory-in-oracle-database","tag-how-to-check-ram-size-in-oracle-database","tag-how-to-check-sga-and-pga-size-in-oracle","tag-how-to-find-out-total-memory-used-by-each-database","tag-oracle-database-memory-usage-linux","tag-oracle-instance-memory-usage","tag-oracle-memory-usage-history","tag-oracle-pga-usage","tag-oracle-sga-usage"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Find Oracle Database Memory Usage(SGA and PGA) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Find Oracle Database Memory Usage(SGA and PGA)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Find Oracle Database Memory Usage(SGA and PGA) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Find Oracle Database Memory Usage(SGA and PGA)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-02T00:39:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-02T08:19:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png\" \/>\n\t<meta property=\"og:image:width\" content=\"632\" \/>\n\t<meta property=\"og:image:height\" content=\"365\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Find Oracle Database Memory Usage(SGA and PGA)\",\"datePublished\":\"2019-06-02T00:39:49+00:00\",\"dateModified\":\"2020-10-02T08:19:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/\"},\"wordCount\":73,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png\",\"keywords\":[\"find pga usage\",\"find sga usage\",\"How much memory is truly used by my Oracle instance?\",\"how to check free memory in oracle database\",\"how to check ram size in oracle database\",\"how to check sga and pga size in oracle\",\"How to find out total memory used by each database\",\"oracle database memory usage linux\",\"Oracle instance memory usage\",\"oracle memory usage history\",\"oracle pga usage\",\"oracle sga usage\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/\",\"name\":\"How To Find Oracle Database Memory Usage(SGA and PGA) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png\",\"datePublished\":\"2019-06-02T00:39:49+00:00\",\"dateModified\":\"2020-10-02T08:19:49+00:00\",\"description\":\"How To Find Oracle Database Memory Usage(SGA and PGA)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png\",\"width\":632,\"height\":365},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Find Oracle Database Memory Usage(SGA and PGA)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Find Oracle Database Memory Usage(SGA and PGA) - Database Tutorials","description":"How To Find Oracle Database Memory Usage(SGA and PGA)","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:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/","og_locale":"en_US","og_type":"article","og_title":"How To Find Oracle Database Memory Usage(SGA and PGA) - Database Tutorials","og_description":"How To Find Oracle Database Memory Usage(SGA and PGA)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/","og_site_name":"Database Tutorials","article_published_time":"2019-06-02T00:39:49+00:00","article_modified_time":"2020-10-02T08:19:49+00:00","og_image":[{"width":632,"height":365,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Find Oracle Database Memory Usage(SGA and PGA)","datePublished":"2019-06-02T00:39:49+00:00","dateModified":"2020-10-02T08:19:49+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/"},"wordCount":73,"commentCount":2,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png","keywords":["find pga usage","find sga usage","How much memory is truly used by my Oracle instance?","how to check free memory in oracle database","how to check ram size in oracle database","how to check sga and pga size in oracle","How to find out total memory used by each database","oracle database memory usage linux","Oracle instance memory usage","oracle memory usage history","oracle pga usage","oracle sga usage"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/","url":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/","name":"How To Find Oracle Database Memory Usage(SGA and PGA) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png","datePublished":"2019-06-02T00:39:49+00:00","dateModified":"2020-10-02T08:19:49+00:00","description":"How To Find Oracle Database Memory Usage(SGA and PGA)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-36.png","width":632,"height":365},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/02\/how-to-find-oracle-database-memory-usagesga-and-pga\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Find Oracle Database Memory Usage(SGA and PGA)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=12201"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12201\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12202"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}