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

Goldengate introduction part-1

Image
What is Oracle GoldenGate? It is an application that provides real-time data integration, data replication, transactional change data capture, data transformations, high availability solutions, and verification between operational and analytical enterprise systems.With Oracle GoldenGate, you can move committed transactions across multiple systems in your enterprise over a secure or non-secure configuration. It supports a wide range of databases and data sources, providing replication between same types or between heterogeneous databases. For example, you could replicate between an Oracle Autonomous Database instance and an Oracle Database instance, or between two Oracle Database instances set up as source and target, or a two-way replication between MySQL database and Oracle Database instances. In addition, you can replicate to Java Messaging Queues, flat files, and to Big Data in combination with Oracle GoldenGate for Big Data. When Do You Use Oracle GoldenGate? Oracle GoldenGate...
Read more