<p>Is it possible to show other processes in progress on an Oracle database?  Something like Sybases <code>sp_who</code></p>

After looking at sp_who, Oracle does not have that ability per se.  Oracle has at least 8 processes running which run the db. Like RMON etc.
You can ask the DB which queries are running as that just a table query.  Look at the V$ tables.
Quick Example:
```
```
SELECT sid,
       opname,
       sofar,
       totalwork,
       units,
       elapsed_seconds,
       time_remaining
FROM v$session_longops
WHERE sofar != totalwork;
```
```