Managing multiple oracle instances on the same server
We have multiple Oracle 10g databases and corresponding instances on the same physical server. The server runs HP tru-unix B.11.23. We want to do a physical restart of the server, so it is needed to determine what all users are logged in into each instance and which interactive / non-interactive sessions are in progress.
Please suggest how can a consolidated report be generated automatically for all instances?