How to check if the User is connected to the Databaes from SQLPLUS or TOAD


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:

SHRD0014: GLLEZL - process exiting with failure

  SYMPTOMS Journal Import completes with the following error: Error ------ ORA-01653 : unable to extend table GL.GL_IMPORT_REFERENCES ORA-01...