dbuptime.sql 


-- ************************************************************************************************************
-- * Filename           : dbuptime.sql
-- * Author             : Saravanakumar K
-- * Description        : This script with show db/instance uptime  
-- * Usage              : @dbuptime.sql
-- * Version            : v1
-- *************************************************************************************************************
col inst for a80 heading 'Instance Info'
SELECT
rpad('Instance ID',15) || ' : '|| inst_id || CHR(10)
    || rpad('Instance Name',15)|| ' : '|| instance_name|| CHR(10)
    || rpad('Hostname',15)|| ' : '|| host_name|| CHR(10)
    || rpad('Version',15)|| ' : '|| version|| CHR(10)
    || rpad('Started At',15)|| ' : '|| TO_CHAR(startup_time,'DD-MON-YYYY HH24:MI:SS') || CHR(10)
    || rpad('Uptime',15)|| ' : '|| floor(SYSDATE - startup_time)|| ' days(s) '
    || trunc(24 * ( (SYSDATE - startup_time) - trunc(SYSDATE - startup_time) ) ) || ' hour(s) '
    || mod(trunc(1440 * ( (SYSDATE - startup_time) - trunc(SYSDATE - startup_time) ) ),60)   || ' minute(s) '
    || mod(trunc(86400 * ( (SYSDATE - startup_time) - trunc(SYSDATE - startup_time) ) ),60)  || ' seconds' || CHR(10)
    || rpad('Status',15)|| ' : ' || status|| CHR(10)
    || rpad('Inst Role',15)|| ' : ' || INSTANCE_ROLE|| CHR(10)
    || rpad('Logins',15)|| ' : ' || LOGINS|| CHR(10) inst
FROM gv$instance
ORDER BY inst_id;
clear col

Comments

Post a Comment

Popular posts from this blog

Automating DBA Tasks with Oracle GoldenGate - Part 1

Automating DBA Tasks with Oracle GoldenGate Oracle GoldenGate is widely recognized as one of the best tools for real-time data replication. It allows seamless database migrations, schema or table replication across homogeneous and heterogeneous environments, and enhances database performance by offloading reporting workloads. Additionally, it ensures high availability by enables Bi-directional or cascading database replication configurations. Beyond these well-known benefits, GoldenGate can also be leveraged for automating routine DBA tasks, reducing manual intervention and improving efficiency by Streamline Your DBA Tasks with EVENTACTIONS. Let's explore how you can leverage its EVENTACTIONS parameter to automate routine DBA tasks, reduce manual effort, and optimize workflows. In this post, I will demonstrate how GoldenGate can assist in automating key DBA operations, such as: Starting or stopping GoldenGate processes – Automate the m...
Read more

PT interview question blog collection

https://kcsdba.blogspot.com/2015/06/oracle-performance-tuning-interview.html https://kcsdba.blogspot.com/search/label/Interview%20Questions-DBA https://dbakeeda.blogspot.com/2016/05/performance-tuning-interview-questions.html https://ittutorial.org/performance-tuning-and-sql-tuning-tutorial-in-the-oracle-database/ http://www.dbvidya.com/oracle-performance-tuning-interview-questions-developers-dbas/ https://www.youtube.com/watch?v=A78c5Ywl7ow https://www.youtube.com/watch?v=6uXqH0f3aG4&list=PLtVgy5UPCu-eWY8ZwxksTZuxE8UC1GFML&index=6&t=1965s https://www.youtube.com/watch?v=Zd_0BNBsXwA https://datahubinsight.com/oracle-performance-tuning-interview-questions-p1.html https://www.freelists.org/post/oracle-l/Questions-for-a-Jr-DBA https://mindmajix.com/oracle-performance-tuning-interview-questions https://dbaclass.com/article/oracle-performance-tuning-interview-questions-and-answers/ https://www.linkedin.com/posts/aditya-chandak-24692825_here-are-the-sql-performance-tuning-intervi...
Read more