Atikh's DBA blog
  • Home
  • Oracle
  • MySQL
  • MongoDB
  • PostgreSQL
  • Snowflake
  • About Me
  • Contact Us

Know your Oracle database startup time in Days, Hours Minute

 Atikh Shaikh     oracle     No comments   

As a database administrator, we came across situation where we need to know the database startup time, We can fetch that using startup_time from v$instance

SQL> select to_char(startup_time,'DD-MM-YYY hh24:mm:ss') startup_time from v$instance;

STARTUP_TIME

------------------

03-09-023 22:09:04 

 

What if the application team or you want to know since how many days, how many hours, and how many minutes it was started, We have modified the query for that as well

 

SET LINES 200 PAGES 2000

COL INSTANCE_NAME FOR A15

COL “INSTANCE UP TIME” FOR A65

SELECT INSTANCE_NAME,

FLOOR(((SYSDATE-STARTUP_TIME)*24*60*60)/3600/24) || 'DAYS '

|| FLOOR ((FLOOR(((SYSDATE-STARTUP_TIME)*24*60*60)) –

FLOOR(((SYSDATE-STARTUP_TIME)*24*60*60)/3600/24)*24*60*60)/3600) || ' HOURS '

|| FLOOR(FLOOR ((FLOOR(((SYSDATE-STARTUP_TIME)*24*60*60))

– FLOOR(((SYSDATE-STARTUP_TIME)*24*60*60)/3600/24)*24*60*60) –

( FLOOR ((FLOOR(((SYSDATE-STARTUP_TIME)*24*60*60)) –

FLOOR(((SYSDATE-STARTUP_TIME)*24*60*60)/3600/24)*24*60*60)/3600))*60*60)/60) || ' MINUTES ' 

“INSTANCE UP TIME” FROM V$INSTANCE;

 

This query just plays around startup_time column of v$instance view. Below is the sample output. 


database-instance-uptime

Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Instagram
  •  Pin
  •  linkedin
  •  reddit
Newer Posts Older Posts Home

Author

Atikh Shaikh
View my complete profile

Categories

  • MongoDB (18)
  • Oracle 12c (30)
  • Oracle12cR2 New Feature (3)
  • PostgreSQL (21)
  • RMAN (10)
  • Snowflake (8)
  • mysql (23)
  • oracle (75)

Blog Archive

  • ►  2018 (38)
    • ►  November (25)
    • ►  December (13)
  • ►  2019 (33)
    • ►  January (15)
    • ►  February (6)
    • ►  March (2)
    • ►  April (5)
    • ►  May (5)
  • ►  2020 (5)
    • ►  April (1)
    • ►  May (2)
    • ►  July (2)
  • ►  2021 (8)
    • ►  June (3)
    • ►  July (3)
    • ►  August (1)
    • ►  December (1)
  • ►  2022 (33)
    • ►  May (3)
    • ►  June (10)
    • ►  July (3)
    • ►  August (4)
    • ►  September (8)
    • ►  October (3)
    • ►  November (2)
  • ▼  2023 (14)
    • ►  February (1)
    • ►  April (5)
    • ►  May (2)
    • ►  June (1)
    • ▼  September (1)
      • Know your Oracle database startup time in Days, Ho...
    • ►  October (1)
    • ►  December (3)
  • ►  2024 (5)
    • ►  January (2)
    • ►  March (3)
  • ►  2025 (7)
    • ►  March (1)
    • ►  April (3)
    • ►  May (2)
    • ►  August (1)
  • ►  2026 (3)
    • ►  January (1)
    • ►  May (2)

Popular Posts

  • Oracle DBA Scripts
    Below are some Oracle scripts used in day to day activities note that below script will generate sql statements and then we need to run...
  • Physical location of datafiles in PostgreSQL
    In this article, we will discuss finding the physical location of data files for a particular database. In the logical structure, we can see...
  • Oracle Dataguard Broker Configuration (DGMGRL)
    Data Guard Broker is a command-line interface that makes managing primary and standby databases easy. DBA can use a single command to switch...
  • Oracle RMAN : File Section for backup of large datafiles
    After learning RMAN introduction and taking first backup of database, we will go through file section for RMAN backups of large datafiles ...
  • MongoDB : How to get config file and log file location
    In MongoDB configuration files and log files are important files as far as the daily routine for DBA. We may need to check parameters in th...

Labels

oracle Oracle 12c mysql PostgreSQL MongoDB oracle 19c Oracle23c oracle19c Orale PDB-CDB oracle12c python AWS Oracle ASM Virtualbox pluggable database storage engine

Pages

  • Disclaimer
  • Privacy Policy

Follow TechnoDBA

Copyright © Atikh's DBA blog | Powered by Blogger