{"id":13080,"date":"2019-09-17T06:43:11","date_gmt":"2019-09-17T06:43:11","guid":{"rendered":"https:\/\/dbtut.com\/?p=13080"},"modified":"2019-09-17T06:43:13","modified_gmt":"2019-09-17T06:43:13","slug":"real-time-sql-monitoring-with-monitor-hint-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/","title":{"rendered":"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle"},"content":{"rendered":"<p>As of Oracle 11g R1, long-running queries or queries that we run with the \/ * MONITOR * \/ hint are automatically monitored. During the monitoring, statistics about SQL execution are collected every second.<\/p>\n<p>The value of the CONTROL_MANAGEMENT_PACK_ACCESS parameter must be \u2018DIAGNOSTIC + TUNING\u2019, and the value of STATISTICS_LEVEL parameter should be ALL or TYPICAL for monitoring.<\/p>\n<p>Monitoring will start automatically when the following conditions occur.<\/p>\n<ul>\n<li>If the query has consumed more than 5 seconds of CPU time<\/li>\n<li>If the query has consumed more than 5 seconds of I \/ O time<\/li>\n<li>If the query was run in parallel<\/li>\n<li>If the query was run with \/ * + MONITOR * \/ hint<\/li>\n<\/ul>\n<p>If we want to monitor a query, we can run it with \/ * + MONITOR * \/. If we don&#8217;t want to monitor, we can run it with \/ * + NO_MONITOR * \/ hint.<\/p>\n<p>Information about the monitored queries can be found in the V$SQL_MONITOR and V$SQL_PLAN_MONITOR views.<\/p>\n<p><strong>V$SQL_MONITOR:<\/strong> Displays SQL statements monitored by Oracle. A record is added here each time the monitored query runs.<\/p>\n<p><strong>V$SQL_PLAN_MONITOR:<\/strong> Displays plan-level monitoring statistics for each SQL statement in V$SQL_MONITOR.<\/p>\n<p><strong>There are some hidden parameters related to monitoring:<\/strong><\/p>\n<p><strong>_sqlmon_max_plan:<\/strong> The maximum number of plan entries that can be monitored. The default value is 20 per CPU.<br \/>\n<strong>_sqlmon_max_planlines:<\/strong> Number of plan lines in which a plan cannot be tracked The default value is 300.<\/p>\n<p>It is useful to increase the values \u200b\u200bof these hidden parameters to display the monitoring results.<\/p>\n<p>You can query as follows by changing parameter values session-based.<\/p>\n<pre class=\"lang:default decode:true \">ALTER SESSION SET \"_SQLMON_MAX_PLAN\"=4020;\nALTER SESSION SET \"_SQLMON_MAX_PLANLINES\"=4000;\n\nSELECT \n  sql_exec_id,\n  sql_plan_hash_value,\n  mon.process_name,\n  mon.status, \n  mon.sid,\n  mon.px_qcsid,\n  round((LAST_REFRESH_TIME - FIRST_REFRESH_TIME)*24*60) AS elapsed_min,\n  FIRST_REFRESH_TIME,\n  LAST_REFRESH_TIME,\n  px_maxdop,\n  px_servers_requested,\n  mon.sql_text,\n  mon.* \nFROM v$SQL_MONITOR mon WHERE sql_id = '2kspy7v98wv35'\nORDER BY \nmon.sql_exec_id,\nmon.sql_plan_hash_value,\nmon.process_name;<\/pre>\n<p>With the monitored data, the <strong>dbms_sqltune.report_sql_monitor<\/strong> function can be used to generate a report for a query in V$SQL_MONITOR. We can execute this function with sql id information for a specific query as follows.<\/p>\n<pre class=\"lang:default decode:true \">SQL Monitoring Report\n\nSQL Text\n------------------------------\nDELETE FROM AKTARIM_KUYRUK WHERE ID = :B1\n\nGlobal Information\n------------------------------\n Status                                 :  DONE                \n Instance ID                            :  3                   \n Session                                :  ADURUOZ (7492:36208) \n SQL ID                                 :  2kspy7v98wv35       \n SQL Execution ID                       :  56701488            \n Execution Started                      :  11\/27\/2018 12:11:28 \n First Refresh Time                     :  11\/27\/2018 12:11:31 \n Last Refresh Time                      :  11\/27\/2018 12:11:31 \n Duration                               :  3s                  \n Module\/Action                          :  aktarim.exe\/-    \n Service                                :  ORCL                 \n Program                                :  aktarim.exe      \n PLSQL Entry Ids (Object\/Subprogram)    :  233559,1            \n PLSQL Current Ids (Object\/Subprogram)  :  233559,1            \n\nBinds\n========================================================================================================================\n| Name | Position |     Type     |                                        Value                                        |\n========================================================================================================================\n| :B1  |        1 | VARCHAR2(32) | 5L0DQRO028H2WGPO                                                                    |\n========================================================================================================================\n\nGlobal Stats\n===================================================================\n| Elapsed |   Cpu   |    IO    | Cluster  | Buffer | Read | Read  |\n| Time(s) | Time(s) | Waits(s) | Waits(s) |  Gets  | Reqs | Bytes |\n===================================================================\n|    2.96 |    0.76 |     2.13 |     0.07 |   194K | 6914 |  54MB |\n===================================================================\n\nSQL Plan Monitoring Details (Plan Hash Value=2154625852)\n===================================================================================================================================================================================\n| Id |       Operation        |           Name           |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Read | Read  | Activity |           Activity Detail           |\n|    |                        |                          | (Estim) |      | Active(s) | Active |       | (Actual) | Reqs | Bytes |   (%)    |             (# samples)             |\n===================================================================================================================================================================================\n|  0 | DELETE STATEMENT       |                          |         |      |         1 |     +3 |     1 |        0 |      |       |          |                                     |\n|  1 |   DELETE               | AKTARIM_KUYRUK    \t |         |      |         1 |     +3 |     1 |        0 | 1172 |   9MB |    33.33 | cell single block physical read (1) |\n|  2 |    PARTITION RANGE ALL |                          |      36 |   91 |         1 |     +3 |     1 |    13204 |      |       |          |                                     |\n|  3 |     INDEX RANGE SCAN   | IX_AKTARIM_KUYRUK \t |      36 |   91 |         3 |     +1 |    30 |    13204 | 5742 |  45MB |    66.67 | cell single block physical read (2) |\n===================================================================================================================================================================================<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13080\" class=\"pvc_stats all  \" data-element-id=\"13080\" 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>As of Oracle 11g R1, long-running queries or queries that we run with the \/ * MONITOR * \/ hint are automatically monitored. During the monitoring, statistics about SQL execution are collected every second. The value of the CONTROL_MANAGEMENT_PACK_ACCESS parameter must be \u2018DIAGNOSTIC + TUNING\u2019, and the value of STATISTICS_LEVEL parameter should be ALL or &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13080\" class=\"pvc_stats all  \" data-element-id=\"13080\" 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":13081,"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":[4809,4810,4808,4806,4807,4798,4797,4815,4813,4814,4800,4803,4802,4799,4801,4818,4817,4816,4812,4811,4804,4805],"class_list":["post-13080","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-_sqlmon_max_plan","tag-_sqlmon_max_planlines","tag-monitor-hint","tag-no_monitor","tag-no_monitor-hint","tag-monitor","tag-monitor-hint-in-oracle","tag-create-a-report-for-monitored-query","tag-dbms_sqltune-report_sql_monitor","tag-generate-a-report-for-monitored-query","tag-monitor-sql-in-oracle","tag-monitor-sql-queries-in-oracle","tag-monitor-sql-query-in-oracle","tag-monitor-usage-in-oracle","tag-real-time-monitoring-in-oracle","tag-real-time-sql-monitoring","tag-real-time-sql-monitoring-in-oracle","tag-sql-monitoring-report","tag-sqlmon_max_plan","tag-sqlmon_max_planlines","tag-vsql_monitor","tag-vsql_plan_monitor"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle\" \/>\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\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-17T06:43:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-17T06:43:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"641\" \/>\n\t<meta property=\"og:image:height\" content=\"354\" \/>\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=\"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\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle\",\"datePublished\":\"2019-09-17T06:43:11+00:00\",\"dateModified\":\"2019-09-17T06:43:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/\"},\"wordCount\":308,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png\",\"keywords\":[\"_sqlmon_max_plan\",\"_sqlmon_max_planlines\",\"\/ * + MONITOR * \/ hint\",\"\/ * + NO_MONITOR * \/\",\"\/ * + NO_MONITOR * \/ hint\",\"\/*+MONITOR*\/\",\"\/*+MONITOR*\/ Hint in Oracle\",\"create a report for monitored query\",\"dbms_sqltune.report_sql_monitor\",\"generate a report for monitored query\",\"monitor sql in oracle\",\"monitor sql queries in oracle\",\"monitor sql query in oracle\",\"Monitor usage in oracle\",\"real time monitoring in oracle\",\"real-time sql monitoring\",\"real-time sql monitoring in oracle\",\"sql monitoring report\",\"sqlmon_max_plan\",\"sqlmon_max_planlines\",\"V$SQL_MONITOR\",\"V$SQL_PLAN_MONITOR\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/\",\"name\":\"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png\",\"datePublished\":\"2019-09-17T06:43:11+00:00\",\"dateModified\":\"2019-09-17T06:43:13+00:00\",\"description\":\"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png\",\"width\":641,\"height\":354},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint 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":"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle - Database Tutorials","description":"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle","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\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle - Database Tutorials","og_description":"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle","og_url":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2019-09-17T06:43:11+00:00","article_modified_time":"2019-09-17T06:43:13+00:00","og_image":[{"width":641,"height":354,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle","datePublished":"2019-09-17T06:43:11+00:00","dateModified":"2019-09-17T06:43:13+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/"},"wordCount":308,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png","keywords":["_sqlmon_max_plan","_sqlmon_max_planlines","\/ * + MONITOR * \/ hint","\/ * + NO_MONITOR * \/","\/ * + NO_MONITOR * \/ hint","\/*+MONITOR*\/","\/*+MONITOR*\/ Hint in Oracle","create a report for monitored query","dbms_sqltune.report_sql_monitor","generate a report for monitored query","monitor sql in oracle","monitor sql queries in oracle","monitor sql query in oracle","Monitor usage in oracle","real time monitoring in oracle","real-time sql monitoring","real-time sql monitoring in oracle","sql monitoring report","sqlmon_max_plan","sqlmon_max_planlines","V$SQL_MONITOR","V$SQL_PLAN_MONITOR"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/","name":"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png","datePublished":"2019-09-17T06:43:11+00:00","dateModified":"2019-09-17T06:43:13+00:00","description":"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint in Oracle","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-4.png","width":641,"height":354},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/17\/real-time-sql-monitoring-with-monitor-hint-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Real-Time SQL Monitoring with \/*+MONITOR*\/ Hint 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\/13080","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=13080"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13080\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13081"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}