Oracle

Update the linux .bashrc_profile to add ORACLE

Update the linux .bashrc_profile to add ORACLE

15 Apr 2018

Certain Linux machines won’t have ORACLE profile set globally for all users, So if you need to invoke oracle command line commands like tnsping from command line without navigating to ORACLE installation directory then you have to do the following.

Learn More
Query to find the space used by a table

Query to find the space used by a table

15 Apr 2018

Query to find the space used by a table SELECT DS.

Learn More
Query to find database uptime

Query to find database uptime

15 Apr 2018

Query to find database uptime SELECT host_name , instance_name , TO_CHAR(startup_time, 'DD-MM-YYYY HH24:MI:SS') startup_time , FLOOR(SYSDATE - startup_time) days FROM sys.

Learn More
Query to find the SQL which is running as a specific user

Query to find the SQL which is running as a specific user

15 Apr 2018

Query to find the SQL which is running as a specific user

Learn More