{"id":57236,"date":"2024-12-03T14:14:54","date_gmt":"2024-12-03T14:14:54","guid":{"rendered":"https:\/\/dbtut.com\/?p=57236"},"modified":"2024-12-03T14:14:54","modified_gmt":"2024-12-03T14:14:54","slug":"session-statistics","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/","title":{"rendered":"Session Statistics"},"content":{"rendered":"

In today’s article, I will be giving you information about active, inactive and other Session Statistics in the database.<\/p>\n

Active Session Statistics<\/h3>\n

1. We can collect active session statistics in the database as follows.<\/p>\n

\tWITH sessiondata AS\r\n\t(SELECT snaptime, dbtime \/ 1000000 dbtime,\r\n\t        (EXTRACT(DAY FROM duration) * 86400) + (EXTRACT(HOUR FROM duration) * 3600) + (EXTRACT(MINUTE FROM duration) * 60) + EXTRACT(SECOND FROM duration) duration\r\n\t   FROM\r\n\t       (SELECT s.begin_interval_time snaptime,\r\n\t               s.begin_interval_time - LAG(s.begin_interval_time) OVER (ORDER BY s.begin_interval_time) duration,\r\n\t               tm.value - LAG(tm.value) OVER (ORDER BY s.begin_interval_time) dbtime\r\n\t          FROM dba_hist_snapshot s,\r\n\t               dba_hist_sys_time_model tm\r\n\t         WHERE s.snap_id = tm.snap_id\r\n\t           AND s.instance_number = tm.instance_number\r\n\t           AND s.dbid = tm.dbid\r\n\t           AND s.instance_number = (select instance_number from v$instance)\r\n\t           AND s.dbid = (select dbid from v$database)\r\n\t           AND tm.stat_name = 'DB time'\r\n\t           AND TRUNC(begin_interval_time) >= TRUNC(SYSDATE)-21\r\n\t       )\r\n\t)\r\n\tSELECT * FROM (\r\n\tSELECT TO_CHAR(snaptime,'YYYY-MM-DD') \"Day\", ROUND(SUM(duration)) \"Duration(sn) between 09-18\", ROUND(SUM(dbtime)) \"Db Time(sn)\", ROUND(SUM(dbtime) \/ SUM(duration), 2) \"Active Sessions\/sn\"\r\n\t  FROM sessiondata\r\n\t WHERE dbtime IS NOT NULL AND dbtime>0\r\n\t   AND TO_CHAR(snaptime,'HH24:MI') >= '09:00' AND TO_CHAR(snaptime,'HH24:MI') <= '18:00'\r\n\tGROUP BY TO_CHAR(snaptime,'YYYY-MM-DD')\r\n\tORDER BY 1 DESC\r\n\t) WHERE ROWNUM < 21;<\/pre>\n
\"\"<\/p>\n
Active – Inactive Session Statistics (Hourly)<\/h3>\n
1. We can obtain hourly MAX and AVG Session statistics in the database with the query below.<\/p>\n
\tSQL>\r\n\tSELECT   TO_CHAR(begin_interval_time,'YYYYMMDD HH24') hourly, MAX (VALUE) max_sessions, TRUNC (AVG (VALUE)) avg_sessions\r\n\t    FROM   dba_hist_sysstat ss, dba_hist_snapshot sn\r\n\t   WHERE   ss.stat_name LIKE '%logons curr%' AND ss.snap_id = sn.snap_id\r\n\tGROUP BY   TO_CHAR(begin_interval_time,'YYYYMMDD HH24') \r\n\tORDER BY   1 DESC;<\/pre>\n
\"\"<\/p>\n
Number of Sessions that are Inactive for a Long Time (1 hour)<\/h3>\n
1. The number of INACTIVE sessions longer than one hour and the program they came from can be found below.<\/p>\n
\tSQL>\r\n\tcol program for a45\r\n\tcol INACTIVE_PROGRAMS FOR A40\r\n\tselect s.program,count(s.program) Inactive_Sessions_from_1Hour\r\n\tfrom gv$session s,v$process p\r\n\twhere     p.addr=s.paddr  AND\r\n\ts.status='INACTIVE'\r\n\tand s.last_call_et > (3600)\r\n\tgroup by s.program\r\n\torder by 2 desc;<\/pre>\n
\"\"<\/p>\n
6 rows selected.<\/p>\n
2. INACTIVE sessions detailis more than 1 hour.<\/p>\n
\tSQL>\r\n\tset pagesize 40\r\n\tcol INST_ID for 99\r\n\tcol spid for a10\r\n\tset linesize 150\r\n\tcol PROGRAM for a10\r\n\tcol action format a10\r\n\tcol logon_time format a16\r\n\tcol module format a13\r\n\tcol cli_process format a7\r\n\tcol cli_mach for a15\r\n\tcol status format a10\r\n\tcol username format a10\r\n\tcol last_call_et_Hrs for 9999.99\r\n\tcol sql_hash_value for 9999999999999col username for a10\r\n\tset linesize 152\r\n\tset pagesize 80\r\n\tcol \"Last SQL\" for a60\r\n\tcol elapsed_time for 999999999999\r\n\tselect p.spid, s.sid,s.last_call_et\/3600 last_call_et_Hrs ,s.status,s.action,s.module,s.program,t.disk_reads,lpad(t.sql_text,30) \"Last SQL\"\r\n\tfrom gv$session s, gv$sqlarea t,gv$process p\r\n\twhere s.sql_address =t.address and\r\n\ts.sql_hash_value =t.hash_value and\r\n\tp.addr=s.paddr and\r\n\ts.status='INACTIVE'\r\n\tand s.last_call_et > (3600)\r\n\torder by last_call_et;<\/pre>\n
Long-running database operations<\/h3>\n
1. We can list the long-running operations in the database as follows.<\/p>\n
\tSQL>\r\n\tset linesize 1000\r\n\tset pagesize 40\r\n\tcol USERNAME for a10\r\n\tcol OPERATION for a20\r\n\tcol OBJECT for a32\r\n\tcol ELAPSED SECOND for a10\r\n\tcol START_TIME for a17\r\n\tSELECT a.sid,\r\n\t         a.serial#,\r\n\t         b.username,\r\n\t         opname OPERATION,\r\n\t         target OBJECT,\r\n\t         TRUNC (elapsed_seconds, 5) \"Elap_Sec(s)\",\r\n\t         TO_CHAR (start_time, 'DD\/MM\/YY HH24:MI:SS') start_time,\r\n\t         ROUND ( (sofar \/ totalwork) * 100, 2) \"COMPLETE (%)\"\r\n\t    FROM v$session_longops a, v$session b\r\n\t   WHERE     a.sid = b.sid\r\n\t         AND b.username NOT IN ('SYSTEM')\r\n\t         AND totalwork > 0\r\nORDER BY elapsed_seconds;<\/pre>\n
\"\"<\/p>\n
2. We can query the estimated time when the running queries will finish by adding another column to the query above.<\/p>\n
For example, for RMAN, this query could be as follows.<\/p>\n
\tSQL>\r\n\tSELECT s.sid, ROUND(sl.elapsed_seconds\/60) gecen_dak, ROUND(sl.time_remaining\/60) kalan_dak, ROUND(sl.sofar\/sl.totalwork*100, 2) progress_pct\r\n\tFROM v$session s, v$session_longops sl\r\n\tWHERE s.sid = sl.sid\r\n\tAND s.serial# = sl.serial#\r\n\tand sl.opname like '%RMAN%'\r\n\tand totalwork <> 0;<\/pre>\n
\"\"<\/p>\n
CPU Usage Of The User<\/h3>\n
1. Total CPU usage of ACTIVE users in the database can be displayed as follows.<\/p>\n
\tSQL>\r\n\tSELECT ss.username, se.SID, VALUE \/ 100 cpu_usage_seconds\r\n\t    FROM v$session ss, v$sesstat se, v$statname sn\r\n\t   WHERE     se.STATISTIC# = sn.STATISTIC#\r\n\t         AND NAME LIKE '%CPU used by this session%'\r\n\t         AND se.SID = ss.SID\r\n\t         AND ss.status = 'ACTIVE'\r\n\t         AND ss.username IS NOT NULL\r\n\tORDER BY VALUE DESC;<\/pre>\n
\"\"<\/p>\n
12 rows selected.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, I will be giving you information about active, inactive and other Session Statistics in the database. Active Session Statistics 1. We can collect active session statistics in the database as follows. WITH sessiondata AS (SELECT snaptime, dbtime \/ 1000000 dbtime, (EXTRACT(DAY FROM duration) * 86400) + (EXTRACT(HOUR FROM duration) * 3600) + …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":57246,"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":[],"class_list":["post-57236","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nSession Statistics - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, I will be giving you information about active, inactive and other Session Statistics in the database.\" \/>\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\/2024\/12\/03\/session-statistics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Session Statistics - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, I will be giving you information about active, inactive and other Session Statistics in the database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-03T14:14:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png\" \/>\n\t<meta property=\"og:image:width\" content=\"677\" \/>\n\t<meta property=\"og:image:height\" content=\"268\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Session Statistics\",\"datePublished\":\"2024-12-03T14:14:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/\"},\"wordCount\":160,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/\",\"name\":\"Session Statistics - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png\",\"datePublished\":\"2024-12-03T14:14:54+00:00\",\"description\":\"In today's article, I will be giving you information about active, inactive and other Session Statistics in the database.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png\",\"width\":677,\"height\":268},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Session Statistics\"}]},{\"@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\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Session Statistics - Database Tutorials","description":"In today's article, I will be giving you information about active, inactive and other Session Statistics in the database.","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\/2024\/12\/03\/session-statistics\/","og_locale":"en_US","og_type":"article","og_title":"Session Statistics - Database Tutorials","og_description":"In today's article, I will be giving you information about active, inactive and other Session Statistics in the database.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/","og_site_name":"Database Tutorials","article_published_time":"2024-12-03T14:14:54+00:00","og_image":[{"width":677,"height":268,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Session Statistics","datePublished":"2024-12-03T14:14:54+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/"},"wordCount":160,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/","url":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/","name":"Session Statistics - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png","datePublished":"2024-12-03T14:14:54+00:00","description":"In today's article, I will be giving you information about active, inactive and other Session Statistics in the database.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/12\/Ekran-goruntusu-2024-12-03-165019.png","width":677,"height":268},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/12\/03\/session-statistics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Session Statistics"}]},{"@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\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/57236","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\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=57236"}],"version-history":[{"count":2,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/57236\/revisions"}],"predecessor-version":[{"id":57248,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/57236\/revisions\/57248"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/57246"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=57236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=57236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=57236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}