select * from v$instance

Connect time(ms): 313

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 16

INSTANCE_NUMBER|INSTANCE_NAME|HOST_NAME|VERSION|STARTUP_TIME|STATUS|PARALLEL|THREAD#|ARCHIVER|LOG_SWITCH_WAIT|LOGINS|SHUTDOWN_PENDING|DATABASE_STATUS|INSTANCE_ROLE|ACTIVE_STATE
1|wind|LARRYSERVER|9.2.0.5.0|2006-10-24 20:33:44.0|OPEN|NO|1|STOPPED||ALLOWED|NO|ACTIVE|PRIMARY_INSTANCE|NORMAL

