bcm@bcm-laptop:~$ sqlplus dbadmin/admindb@v112

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 1 08:47:51 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exec sys.dbms_lock.sleep(600);

SQL> !ps -ef | grep sqlplus
oracle   22793 22628  0 08:40 pts/1    00:00:00 sqlplus
bcm      22886 22863  0 08:41 pts/2    00:00:00 sqlplus
bcm      23184  2032  0 08:47 pts/0    00:00:00 sqlplus                     
oracle   23212 22793  0 08:48 pts/1    00:00:00 /bin/bash -c ps -ef | grep sqlplus
oracle   23214 23212  0 08:48 pts/1    00:00:00 grep sqlplus

SQL> select sql_text from v$sql where sql_id in (select sql_id from v$session where process = '23184');

SQL_TEXT
--------------------------------------------------------------------------------
BEGIN sys.dbms_lock.sleep(600); END;