@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
