To view the current sessions that are logged on to the database click on Database Sessions in the navigator found in Solution Manager / Monitoring folder to open the form. What you see in this form is what was executing the last time the session was used from the session pool. The next time a session is used it can be used for another Foundation1 user.
Note: User IFSSYS is used to logon the database from the Application Server. You should be extremely careful when killing sessions for user IFSSYS. The sessions for user IFSSYS are part of a pool of sessions that the Application Server uses to access the database.
You cannot modify a Database Session. But you can kill a Database Session by selecting the Database Session, right-click and select "Kill Session". This will immediately kill the ongoing session and rollback any ongoing transaction.
There are five different session categories:
| Category | Description |
|---|---|
| PL/SQL Access | These sessions are normally from IFS Enterprise Explorer, but could also be used from other Access Provider clients. |
| Activity/Service | Sessions used by activities or services from IFS Middleware Server. Typically used by Solution Manager or integrations. |
| JMS-AQ integration | Sessions used by the integration between Oracle Advanced Queuing and IFS Middleware Server, typically either the batch processor (IFS Connect) or Streams. |
| Database background job | Sessions used by Oracle database to process background jobs. These sessions are started by the Oracle Scheduler. |
| Other session | Other sessions that have been logged on to Oracle database. These are normally sessions created from tools like PL/SQL Developer etc. |