{"id":54323,"date":"2023-04-10T13:53:44","date_gmt":"2023-04-10T13:53:44","guid":{"rendered":"https:\/\/dbtut.com\/?p=54323"},"modified":"2023-04-10T13:54:57","modified_gmt":"2023-04-10T13:54:57","slug":"oracle-database-uptime","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/","title":{"rendered":"Oracle Database Uptime"},"content":{"rendered":"

In today’s article, we will learn how long the Database software and Server have been running with the help of the uptime command.<\/p>\n

We can find out how long the database software has been running with the following command.<\/p>\n

SQL> SELECT INST_ID, TO_CHAR(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') AS \"DB Startup Time\" FROM GV$INSTANCE;\r\n\r\nDB Startup Time              \r\n-----------------------------\r\n\r\n   INST_ID DB Startup Time\r\n---------- --------------------\r\n         3 06-JUL-2017 13:08:09\r\n         2 06-JUL-2017 13:10:02\r\n         1 06-JUL-2017 13:12:01\r\n<\/pre>\n
If we want to check how long the server has been running.<\/p>\n
# uptime\r\n 15:06:12 up 40 days,  4:34,  6 users,  load average: 6.16, 7.29, 7.49\r\n<\/pre>\n
Or<\/p>\n
 top -c -M\r\n<\/pre>\n
\"\"<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will learn how long the Database software and Server have been running with the help of the uptime command. We can find out how long the database software has been running with the following command. SQL> SELECT INST_ID, TO_CHAR(STARTUP_TIME,’DD-MON-YYYY HH24:MI:SS’) AS “DB Startup Time” FROM GV$INSTANCE; DB Startup Time —————————– INST_ID …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":54325,"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-54323","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nOracle Database Uptime - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will learn how long the Database software and Server have been running with the help of the uptime command.\" \/>\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\/2023\/04\/10\/oracle-database-uptime\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database Uptime - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will learn how long the Database software and Server have been running with the help of the uptime command.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-10T13:53:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-10T13:54:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png\" \/>\n\t<meta property=\"og:image:width\" content=\"682\" \/>\n\t<meta property=\"og:image:height\" content=\"283\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Oracle Database Uptime\",\"datePublished\":\"2023-04-10T13:53:44+00:00\",\"dateModified\":\"2023-04-10T13:54:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/\"},\"wordCount\":55,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/\",\"name\":\"Oracle Database Uptime - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png\",\"datePublished\":\"2023-04-10T13:53:44+00:00\",\"dateModified\":\"2023-04-10T13:54:57+00:00\",\"description\":\"In today's article, we will learn how long the Database software and Server have been running with the help of the uptime command.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png\",\"width\":682,\"height\":283},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database Uptime\"}]},{\"@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":"Oracle Database Uptime - Database Tutorials","description":"In today's article, we will learn how long the Database software and Server have been running with the help of the uptime command.","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\/2023\/04\/10\/oracle-database-uptime\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database Uptime - Database Tutorials","og_description":"In today's article, we will learn how long the Database software and Server have been running with the help of the uptime command.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/","og_site_name":"Database Tutorials","article_published_time":"2023-04-10T13:53:44+00:00","article_modified_time":"2023-04-10T13:54:57+00:00","og_image":[{"width":682,"height":283,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Oracle Database Uptime","datePublished":"2023-04-10T13:53:44+00:00","dateModified":"2023-04-10T13:54:57+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/"},"wordCount":55,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/","url":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/","name":"Oracle Database Uptime - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png","datePublished":"2023-04-10T13:53:44+00:00","dateModified":"2023-04-10T13:54:57+00:00","description":"In today's article, we will learn how long the Database software and Server have been running with the help of the uptime command.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-10-165236.png","width":682,"height":283},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/10\/oracle-database-uptime\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Database Uptime"}]},{"@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\/54323","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=54323"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54323\/revisions"}],"predecessor-version":[{"id":54326,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54323\/revisions\/54326"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54325"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}