SQL> desc v$session;
sql> select program, machine, CLIENT_IDENTIFIER from V$session;
SQL> SELECT USERNAME, SCHEMANAME,PROGRAM FROM V$SESSION;
sql> select osuser, machine, terminal from v$session;
sql> select client_info, machine columns from V$session;
sql> select program from v$session;
sql> select distinct machine from v$session;
sql> select program, osuser, machine, client_info from V$session;
SQL> set line 50000
SQL> SELECT USERNAME, SCHEMANAME, OWNERID, LOGON_TIME, CLIENT_INFO, SERVER, CLIENT_IDENTIFIER,RESOURCE_CONSUMER_GROUP,PROGRAM FROM V$SESSION;
USERNAME SCHEMANAME PROGRAM
------------------------------ ------------------------------ ------------------------------------------------
APPS APPS frmcmp_batch@sujeet.com (TNS V1-V3)
APPS APPS frmcmp_batch@sujeet.com (TNS V1-V3)
No comments:
Post a Comment