Oracle query who is connected

Please note that it begins by displaying summaries of all current, cumulative, and the high-water mark for logons before displaying the details for each session:. To see details of these processes, you can write an Oracle script to filter the UNIX ps output to only include these processes:. Execute the UNIX commands. Here is the output from this script. This is a great script for monitoring Oracle connections over time.

The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Related 1. Hot Network Questions. Question feed. Accept all cookies Customize settings. You can unsubscribe at any time. Can we know which users are connected to the Oracle database? How can I get a list of users who are connected to a particular Oracle database.

Any query? Check the below query. This will give you username, program name, logon time of the all the users list connected to the database. Thanks for the URL. I submitted the code plus another to display the tablespace usage in the database.

I run the usage script daily to monitor the growth of my database proactively. Show user just tells you, from sqlplus, who are you or with which user you are connected.

It does not work anywhere else. No Account? Identifying a source of connections is a quite common task for a database administrator. As it is one of troubleshooting steps for various problems, it is crucial to know how to do it. Here you can quickly possess this necessary peace of knowledge. For sure there are many more possibilities. Identifying connections to a database is a very widely needed skill. It is a system view which contains all current sessions.

It provides a lot of useful information but for purpose of checking WHO is connected, you actually need only three columns: username, machine and program. The usage is presented by the following query:.