Check the Oracle Database Uptime

Hello ITKians From today we start a new chapter from our blog that is DBMS

From today we post about small DB query that any DBMS administrator want to know 

lets start with Check your DBMS up time with this simple query

Copy Query From  —–>  Here

First Go to SQL PLUS >> 

When you want to check start up time of oracle database instance so you need to run following Query direct any SQL tool like Toad,SQL Developer ,iSQL*Plus etc.

  1. select NAME “DB_NAME”,INSTANCE_NAME “INSTANCE”,OPEN_MODE “MODE”,STATUS,DATABASE_ROLE “ROLE”,HOST_NAME “HOST”, to_char(STARTUP_TIME,’MON/DD/YYYY hh24:mi:ss’)startup_time from gv$database NATURAL JOIN gv$instance; 

For example i run this query on my isql*plus data base . look at below image

Like and share with your friends and update with IT KEEDA for more DB query.


नमस्ते _/\_ to all . This is JOY DUTTA working in Spark Minda group as a IT Engg from last 4 years , I completed my Diploma from Goverment Polytechnic Dehradun in Computer Science And Engg in 2011.Well, above i written my Qualification and My JOB Role. now i am tell you about Who am i as a person. I am a fun loving guy who love Acting, Dancing, Hangout with friends, I believe in Smart work Rather Than Hard work. I love computers because I love Computers :)In short I am interesting guy if you want reveals more about me You should to meet me. if that not possibleMail me :- or Join me on Facebook:-

Leave a Reply

%d bloggers like this: