Update the linux .bashrc_profile to add ORACLE
bashrc is the best place to add aliases and Bash related functions. The Bash shell looks for the . bashrc file in the …
Oracle
Query to find the space used by a table in Oracle
Query to find the space used by a table SELECT DS.TABLESPACE_NAME , SEGMENT_NAME , ROUND(SUM(DS.BYTES) / (1024 \ * …
Query to find database uptime in Oracle
Query to find database uptime SELECT host_name , instance_name , TO_CHAR(startup_time, 'DD-MM-YYYY HH24:MI:SS') …
Query to find the queries executed by an user in Oracle
Query to find the queries executed by an user in Oracle SELECT VS.USERNAME , VS.MACHINE , VS.PROGRAM , VS.STATUS , …
Query to find service name
This article explains the steps to find the service name of a database running on your local windows machine. Open …