Return
-
Title
How to check the users and machines connected to the Oracle database using Toad? -
Description
In Toad for Oracle, is there a way to check the users and machines connected to the Oracle database?
-
Resolution
WORKAROUND:
1. Login to Toad
2. Go to Database | Monitor | Session browser.
3. Expand TOAD.EXE under PROGRAM and you will see the users and the machines connected to the database.
-
Additional Information
Users can also construct select statement to query v$session.
EXAMPLE
Select username, machine from v$session where username is not null;