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:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...