Sunday, March 27, 2011

Basic Oracle Queries


1. How to check Unix O.S Version?

uname -a

2. How to check Oracle Version?

select * from v$version;

3. How to find the Start up time of Oracle Instance?

SELECT instance_name,host_name,
TO_CHAR(startup_time,'DD-MON-YYY HH:MM:SS AM')
FROM v$instance;