{"id":11690,"date":"2019-04-27T14:14:37","date_gmt":"2019-04-27T14:14:37","guid":{"rendered":"https:\/\/dbtut.com\/?p=11690"},"modified":"2019-04-27T14:14:38","modified_gmt":"2019-04-27T14:14:38","slug":"how-to-use-oratop-for-monitoring-oracle-databases","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/","title":{"rendered":"How To Use oratop For Monitoring Oracle Databases"},"content":{"rendered":"<p><strong>oratop<\/strong> is a utility that provides a general knowledge of database performance, similar to the top command in linux systems. When used with the Top command, we can get general information about the system performance.<\/p>\n<p>It can be run as compiled script without requiring any installation. You can access the required file from document 1500864.1 at Oracle Support. There are compiled scripts for different operating systems and different database versions.<\/p>\n<p>After downloading the relevant file, the file must be runnable by the oracle user.<\/p>\n<p>Then you can set the required environment variables and run.<\/p>\n<p>In our example, we downloaded the file named oratop.RDBMS_11.2_LINUX_X64, which is the necessary file for our 11.2 version database in Linux x86-64 platform.<\/p>\n<p>Let&#8217;s rename the existing file and make it executable for oracle.<\/p>\n<pre class=\"lang:default decode:true \">[root@db01 ~]$ mv oratop.RDBMS_11.2_LINUX_X64 oratop\n[root@db01 ~]$ chown oracle:oinstall oratop\n[root@db01 ~]$ chmod 755 oratop<\/pre>\n<p>With oracle, we can set the necessary variables and run them as follows. Commands must be run in the following order.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@db01 ~]$ export TERM=xterm #ya da vt100\n[oracle@db01 ~]$ export ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/dbhome_1\n[oracle@db01 ~]$ export LD_LIBRARY_PATH=$ORACLE_HOME\/lib\n[oracle@db01 ~]$ export PATH=$ORACLE_HOME\/bin:$PATH\n[oracle@db01 ~]$ export ORACLE_SID=ORCL1<\/pre>\n<p>We can run the oratop for our database in the local as below. The refresh interval we specified with -i may not provide accurate information in values less than 10 seconds. The default value is 5.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@db01 ~]$ .\/oratop -i 10 \/ as sysdba<\/pre>\n<p>The sample screenshot is as follows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11695 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-40.png\" alt=\"\" width=\"570\" height=\"262\"><\/p>\n<p>It is also possible to monitor a remote database. We can also run the oratop command by connecting to other databases as follows.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@db01 ~]$&nbsp;.\/oratop -i 10 username\/password@tns<\/pre>\n<p>For example;<\/p>\n<pre class=\"lang:default decode:true \">$ .\/oratop -i 5 system\/manager@tns<\/pre>\n<p>Oratop must be run with a user who is either dba or a user who has the authority to select the following.<\/p>\n<pre class=\"lang:default decode:true \">v$active_services\nv$instance\nv$latchname\nv$parameter\nV$PDBS (12c)\nv$recovery_file_dest\nv$sqlcommand\nv$system_event\n[g]v$servicemetric\n[g]v$session\n[g]v$sql\n[g]v$sysmetric\nGV$ASM_DISKGROUP\nGV$DIAG_INFO\nGV$PGASTAT\nGV$PROCESS\nGV$OSSTAT\nGV$RECOVERY_PROGRESS\nGV$SESSION_WAIT_CLASS\nGV$SESSTAT\nGV$SERVICE_EVENT\nGV$SERVICE_STATS\nGV$SGA\nGV$SORT_SEGMENT\nGV$SQLAREA\nGV$SQL_PLAN\nGV$SYSTEM_EVENT\nGV$SYSSTAT\ndba_data_files\ndba_free_space\ndba_tablespaces\ndba_temp_files\ndba_undo_extents\nsys.ts$<\/pre>\n<p>You can authorize a user for these views as follows.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; grant select on &lt;view&gt; to &lt;username&gt;;<\/pre>\n<p>To get help about oratop, you can run it with the -h parameter as follows.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@db01 ~]$ .\/oratop -h\noratop: Release 14.1.2\nUsage: \n\t oratop [ [Options] [Logon] ]\n\n\t Logon:\n\t\t{username[\/password][@connect_identifier] | \/ }\n\t\t[AS {SYSDBA|SYSOPER}]\n\n\t\tconnect_identifier:\n\t\t     o Net Service Name, (TNS) or\n\t\t     o Easy Connect (host[:port]\/[service_name])\n\t Options:\n\t     -d : real-time (RT) wait events, section 3 (default is Cumulative)\n\t     -k : FILE#:BLOCK#, section 4 lt is (EVENT\/LATCH)\n\t     -m : MODULE\/ACTION, section 4 (default is USERNAME\/PROGRAM)\n\t     -s : SQL mode, section 4 (default is process mode)\n\t     -c : database service mode (default is connect string) \n\t     -f : detailed format, 132 columns (default: standard, 80 columns)\n\t     -b : batch mode (default is text-based user interface)\n\t     -n : maximum number of iterations (requires number)\n\t     -i : interval delay, requires value in seconds (default: 5s)\n\t     -v : oratop release version number\n\t     -h : this help<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11690\" class=\"pvc_stats all  \" data-element-id=\"11690\" 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>oratop is a utility that provides a general knowledge of database performance, similar to the top command in linux systems. When used with the Top command, we can get general information about the system performance. It can be run as compiled script without requiring any installation. You can access the required file from document 1500864.1 &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11690\" class=\"pvc_stats all  \" data-element-id=\"11690\" 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":11701,"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":[3526,3520,3519,3525,3527,3529,3522,3524,3518,3528,3523],"class_list":["post-11690","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-how-to-monitor-oracle-database","tag-how-to-use-oracle-oratop-utility","tag-how-to-use-oratop","tag-monitoring-oracle-database","tag-monitoring-oracle-database-with-oratop","tag-monitoring-oracle-with-oratop","tag-oratop-utility","tag-rac-realtime-monitoring-with-oratop","tag-what-is-oratop","tag-what-is-oratop-in-oracle","tag-what-is-oratop-utility"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":1722,"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 Use oratop For Monitoring Oracle Databases - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Use oratop For Monitoring Oracle Databases\" \/>\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\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Use oratop For Monitoring Oracle Databases - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Use oratop For Monitoring Oracle Databases\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-27T14:14:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-27T14:14:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.png\" \/>\n\t<meta property=\"og:image:width\" content=\"643\" \/>\n\t<meta property=\"og:image:height\" content=\"390\" \/>\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\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Use oratop For Monitoring Oracle Databases\",\"datePublished\":\"2019-04-27T14:14:37+00:00\",\"dateModified\":\"2019-04-27T14:14:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/\"},\"wordCount\":274,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.png\",\"keywords\":[\"how to monitor oracle database\",\"How to use Oracle ORATOP utility\",\"how to use oratop\",\"monitoring oracle database\",\"monitoring oracle database with oratop\",\"Monitoring Oracle with oratop\",\"oratop utility\",\"RAC realtime monitoring with ORATOP\",\"what is oratop\",\"what is oratop in oracle\",\"what is oratop utility\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/\",\"name\":\"How To Use oratop For Monitoring Oracle Databases - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.png\",\"datePublished\":\"2019-04-27T14:14:37+00:00\",\"dateModified\":\"2019-04-27T14:14:38+00:00\",\"description\":\"How To Use oratop For Monitoring Oracle Databases\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.png\",\"width\":643,\"height\":390},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Use oratop For Monitoring Oracle Databases\"}]},{\"@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 Use oratop For Monitoring Oracle Databases - Database Tutorials","description":"How To Use oratop For Monitoring Oracle Databases","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\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/","og_locale":"en_US","og_type":"article","og_title":"How To Use oratop For Monitoring Oracle Databases - Database Tutorials","og_description":"How To Use oratop For Monitoring Oracle Databases","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-27T14:14:37+00:00","article_modified_time":"2019-04-27T14:14:38+00:00","og_image":[{"width":643,"height":390,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.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\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Use oratop For Monitoring Oracle Databases","datePublished":"2019-04-27T14:14:37+00:00","dateModified":"2019-04-27T14:14:38+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/"},"wordCount":274,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.png","keywords":["how to monitor oracle database","How to use Oracle ORATOP utility","how to use oratop","monitoring oracle database","monitoring oracle database with oratop","Monitoring Oracle with oratop","oratop utility","RAC realtime monitoring with ORATOP","what is oratop","what is oratop in oracle","what is oratop utility"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/","name":"How To Use oratop For Monitoring Oracle Databases - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.png","datePublished":"2019-04-27T14:14:37+00:00","dateModified":"2019-04-27T14:14:38+00:00","description":"How To Use oratop For Monitoring Oracle Databases","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-41.png","width":643,"height":390},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-use-oratop-for-monitoring-oracle-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Use oratop For Monitoring Oracle Databases"}]},{"@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\/11690","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=11690"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11690\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11701"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}