rem -----------------------------------------------------------------------
rem Filename:   uptime.sql
rem Purpose:    Display database uptime in days and hours
rem             to SYS or SYSTEM
rem Date:      4-Aug-2008
rem -----------------------------------------------------------------------

select SYSDATE-logon_time "Days", (SYSDATE-logon_time)*24 "Hours"
from sys.v_$session where sid=1 /* this is PMON */
/

thank you for this script but I would like to tell you that SID for PMON Process <>1 in all databases so this script is not necessary true.

it is better to use this script

SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time"
FROM   sys.v_$instance;

عزيزي airtifa لقد ذكرت فى الاسكريبت الخاص بي انه يلزم الكونكت من خلال اتنين يوزر فقط sys or system
وهما لن يكونوا متاحين للدخول الا من خلال الادمنستراتور
ولك كامل تحياتى وتقديري

Sure to run this script you connect to database through user SYS or SYSTEM (off course any DBA must do that)
but this script didn't give any result
did it returned any result for you??
I don't think so

(www.Orafaq.com)

مشكوووور جدا اخي بس ممكن شرح قليل لجملة الاستعلام ...

ممكن توضح لنا طريقة عمل clone database لو تكرمت ( بالصور اذا ممكن )

Sure to run this script you connect to database through user SYS or SYSTEM (off course any DBA must do that)
but this script didn't give any result
did it returned any result for you??
I don't think so

(www.Orafaq.com)

I think your seniority level is in oracle 10g only dear airtifa , as this script is intended to run exclusively on 9i database and earlier versions
so here is my result just to be fair and convince you

Days      Hours
---------- ----------
2.10945602 50.6269444


1 row selected.

and considering your code (which shows only database last run time ) i have refined it and added some more code units to show the desired result(up time in days not last runtime )
so look at it and waiting for all members feedback

select  round (sysdate - startup_time) "days" FROM v_$instance ;

    days
----------
        2


1 row selected.

thank your for your reply

مشكور اخى على المجهود الرائع

hello Dr Click

you should verify on what Oracle version this script is valid to run
not all scripts are valid to run on all oracle version.

about my seniority level it is in both oracle 10g and Oracle 9i

also if you copy scripts from other websites you must add this website copy right on this script

I mean you must add a note that this script is copy righted from www.orafaq.com website

also if you copy scripts from other websites you must add this website copy right on this script

I mean you must add a note that this script is copy righted from www.orafaq.com website

that is valid only of development teams in that site had developed it and posted it , actually it seems you don't understand the site policy as quit as their desire for knowledge sharing concept
their policy stands for knowledge sharing regardless any race or religion believes or either work places ...just knowledge sharing with ppl ..like if u downloaded any file from TORRENT website ..exactly the same .
and for transparency principle ..ill post here to all OUG members ..the site message just to give you and all users a small hint about this site policy

Scripts
From Oracle FAQ
Jump to: navigation, search

Below are some free Oracle Scripts and code exampled you can download:

You can have your scripts and code examples published here. Just upload them and include them on this page. However, please ensure all code is properly formatted.
http://www.orafaq.com/wiki/Scripts

Do you really understand the meaning of the word WIKI ?
so please don't post upon your own believes or understandings .
you can see these codes on millions of blogsites ..dont just choose the first search result resulted from search engine you use ..look at other results and you will understand what i mean dear .
and about the oracle version i use ..its in your seniority domain ... 9i (9.2.3) ..so try it and it will run with you ..

 

in oracle forums and websites if you post an article or script you must verify if it is your own creation or you copied it from another website.

 

another thing if you post a script you should verify what oracle version ,operating system this script is valid for

about oracle version its already mentioned ,but for OS ..its valid for all OS platforms as it depends on RDMS server not interfering with OS platform at all .