When I was going through my projects plsql procedures, I found a block which gathers the system, user, program etc... information. SYS_CONTEXT() function was used to get this. I am putting the sample code here... DECLARE v_AUDSID NUMBER; v_DB_USER_NAME VARCHAR(20); v_EXECUTING_ENVIRONMENT VARCHAR(20); v_OSUSER VARCHAR(20); v_TERMINAL_MACHINE VARCHAR(20); BEGIN v_AUDSID := sys_context('USERENV','SESSIONID'); select USERNAME, PROGRAM, OSUSER, MACHINE into v_DB_USER_NAME, v_EXECUTING_ENVIRONMENT, v_OSUSER, v_TERMINAL_MACHINE from V$SESSION where AUDSID = v_AUDSID; DBMS_OUTPUT.PUT_LINE(v_DB_USER_NAME' ' v_EXECUTING_ENVIRONMENT' 'v_OSUSER' 'v_TERMINAL_MACHINE); END; SYS_CONTEXT(name_space, parameter_name) takes two parameters. Go to this link for more details on SYS_CONTEXT() function http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/functions150.htm Regards, Karteek