{"id":4061,"date":"2018-10-21T22:08:42","date_gmt":"2018-10-21T22:08:42","guid":{"rendered":"https:\/\/dbtut.com\/?p=4061"},"modified":"2019-11-19T19:05:05","modified_gmt":"2019-11-19T19:05:05","slug":"how-to-query-transaction-count-on-oracle-11gr1-and-11gr2","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/","title":{"rendered":"How To Query Transaction Count in Oracle"},"content":{"rendered":"<p>A script that you might need during database scaling. Calculation of transaction numbers between two specific dates.<\/p>\n<p>This script was tested in 11gR1 and 11gR2. Please test the scripts on your test servers before running them in the production environment.<\/p>\n<pre class=\"lang:default decode:true \">SELECT BEGIN_TIME,\nEND_TIME,\nTXNCOUNT,\n( (END_TIME - BEGIN_TIME) * 24 * 60 * 60) DIFFSECOND,\nTO_CHAR ( (TXNCOUNT \/ ( (END_TIME - BEGIN_TIME) * 24 * 60 * 60)),\n'999999.99')\nTRANXPERSECOND\nFROM V$UNDOSTAT\nWHERE\u00a0 \u00a0 \u00a0BEGIN_TIME &gt;= TO_DATE('20.09.2014 00:00','DD.MM.YYYY HH24:MI')\nAND BEGIN_TIME &lt;= TO_DATE('25.09.2014 00:00','DD.MM.YYYY HH24:MI')\nAND (TXNCOUNT \/ ( (END_TIME - BEGIN_TIME) * 24 * 60 * 60)) &gt; 50\nORDER BY 1;<\/pre>\n<p>The following queries can be used to find the transaction count in the Oracle database.<\/p>\n<h1>Average transaction count per day in Oracle<\/h1>\n<pre class=\"lang:default decode:true \">SELECT V1          \"Total Commits\",\n       V2          \"Total Rollbacks\",\n       V3          \"Total User Calls\",\n       T1          \"Uptime in days\",\n       S1 \/ T1     \"Avg Daily DML Transactions\",\n       V3 \/ T1     \"Avg Daily User Calls\"\n  FROM (SELECT VALUE     V1\n          FROM V$SYSSTAT\n         WHERE NAME = 'user commits'),\n       (SELECT VALUE     V2\n          FROM V$SYSSTAT\n         WHERE NAME = 'user rollbacks'),\n       (SELECT SUM (VALUE)     S1\n          FROM V$SYSSTAT\n         WHERE NAME IN ('user commits', 'user rollbacks')),\n       (SELECT VALUE     V3\n          FROM V$SYSSTAT\n         WHERE NAME = 'user calls'),\n       (SELECT SYSDATE - STARTUP_TIME T1 FROM V$INSTANCE);<\/pre>\n<h1>Daily average commit count<\/h1>\n<pre class=\"lang:default decode:true \">SELECT (V1 + V2) \/ T1 \"Avg Daily DML Transactions\",\n    V1 \"User Commit\",\n    V2 \"User Rollback\"\n  FROM (SELECT VALUE V1\n          FROM V$SYSSTAT\n         WHERE NAME = 'user commits'),\n       (SELECT VALUE V2\n          FROM V$SYSSTAT\n         WHERE NAME = 'user rollbacks'),\n       (SELECT SYSDATE - STARTUP_TIME T1 FROM V$INSTANCE);<\/pre>\n<h1>Transaction Count in the last 24 hours<\/h1>\n<pre class=\"lang:default decode:true \">SELECT 'DATABASE',\n       'TOPLAM TRANSACTION - 24 SAAT',\n       TO_CHAR (MAX (NEXT_CHANGE#) - MIN (FIRST_CHANGE#), '9,999,999,999') VALUE\n  FROM V$LOG_HISTORY\n WHERE TO_DATE (FIRST_TIME, 'DD\/MM\/RR HH24:MI:SS') &gt; TRUNC (SYSDATE, 'HH24') - 1;<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_4061\" class=\"pvc_stats all  \" data-element-id=\"4061\" 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>A script that you might need during database scaling. Calculation of transaction numbers between two specific dates. This script was tested in 11gR1 and 11gR2. Please test the scripts on your test servers before running them in the production environment. SELECT BEGIN_TIME, END_TIME, TXNCOUNT, ( (END_TIME &#8211; BEGIN_TIME) * 24 * 60 * 60) DIFFSECOND, &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_4061\" class=\"pvc_stats all  \" data-element-id=\"4061\" 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":13908,"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":[5940,5939,5947,2632,5934,5937,5932,5936,2635,5933,5942,5941],"class_list":["post-4061","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-average-transaction-count-per-day","tag-average-transaction-count-per-day-in-oracle","tag-check-transaction-count","tag-find-transaction-count","tag-find-transaction-count-in-oracle","tag-oracle-daily-transaction-count","tag-oracle-get-transaction-count","tag-oracle-transaction-count","tag-transaction-count-in-a-specific-interval","tag-transaction-count-in-oracle","tag-transaction-count-in-the-last-24-hours","tag-transaction-count-per-day-in-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":7811,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Query Transaction Count in Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Determine Transaction Count On Oracle 11gR1 and 11gR2\" \/>\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\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Query Transaction Count in Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Determine Transaction Count On Oracle 11gR1 and 11gR2\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-21T22:08:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-19T19:05:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png\" \/>\n\t<meta property=\"og:image:width\" content=\"977\" \/>\n\t<meta property=\"og:image:height\" content=\"545\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Query Transaction Count in Oracle\",\"datePublished\":\"2018-10-21T22:08:42+00:00\",\"dateModified\":\"2019-11-19T19:05:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/\"},\"wordCount\":82,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png\",\"keywords\":[\"Average transaction count per day\",\"Average transaction count per day in Oracle\",\"check transaction count\",\"Find Transaction Count\",\"find transaction count in oracle\",\"oracle daily transaction count\",\"oracle get transaction count\",\"oracle transaction count\",\"Transaction Count in a specific interval\",\"transaction count in oracle\",\"Transaction Count in the last 24 hours\",\"transaction count per day in Oracle\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/\",\"name\":\"How To Query Transaction Count in Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png\",\"datePublished\":\"2018-10-21T22:08:42+00:00\",\"dateModified\":\"2019-11-19T19:05:05+00:00\",\"description\":\"How To Determine Transaction Count On Oracle 11gR1 and 11gR2\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png\",\"width\":977,\"height\":545},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Query Transaction Count in Oracle\"}]},{\"@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 Query Transaction Count in Oracle - Database Tutorials","description":"How To Determine Transaction Count On Oracle 11gR1 and 11gR2","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\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/","og_locale":"en_US","og_type":"article","og_title":"How To Query Transaction Count in Oracle - Database Tutorials","og_description":"How To Determine Transaction Count On Oracle 11gR1 and 11gR2","og_url":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/","og_site_name":"Database Tutorials","article_published_time":"2018-10-21T22:08:42+00:00","article_modified_time":"2019-11-19T19:05:05+00:00","og_image":[{"width":977,"height":545,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Query Transaction Count in Oracle","datePublished":"2018-10-21T22:08:42+00:00","dateModified":"2019-11-19T19:05:05+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/"},"wordCount":82,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png","keywords":["Average transaction count per day","Average transaction count per day in Oracle","check transaction count","Find Transaction Count","find transaction count in oracle","oracle daily transaction count","oracle get transaction count","oracle transaction count","Transaction Count in a specific interval","transaction count in oracle","Transaction Count in the last 24 hours","transaction count per day in Oracle"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/","url":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/","name":"How To Query Transaction Count in Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png","datePublished":"2018-10-21T22:08:42+00:00","dateModified":"2019-11-19T19:05:05+00:00","description":"How To Determine Transaction Count On Oracle 11gR1 and 11gR2","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-56.png","width":977,"height":545},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/21\/how-to-query-transaction-count-on-oracle-11gr1-and-11gr2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Query Transaction Count in Oracle"}]},{"@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\/4061","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=4061"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/4061\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13908"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=4061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=4061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=4061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}