@D:\wt\Windchill_8.0\db\sql\who
 
column username for a15
column machine for a25
select username,machine,to_char(logon_time,'dd-Mon-yy:hh:mi') Logon_Time,status from v$session
where username is not null
 
select owner, table_name, TABLESPACE_NAME from dba_tables
 
select owner, object_name, object_id, object_type from dba_objects
 
select * from dba_objects