Oracle Processes
This function is used to view the different processes and current locks in the database when the database used is Oracle™.
Important remark
Warning, this type of functionfacilitates, via a user interface homogenous with the software, the launch of live procedures dedicated to a database admin. It is made to be launched by such an admin (usually called DBA).
To be used optimally, the user should be familiar with the functioning of databases and their optimization.
Conversely, an inappropriate use of the function can be problematic for the performances of the system and might compromise the utilization of the software.
Screen management
This function is used to view the processes and the locks corresponding to these processes in the database.
These elements are presented in two tabs : the first provides a list of the processes, the second gives the list of locks.
The function is used to identify the blocking locks. After verification of the blocking and blocked processes, it will be possible to kill the blocking process.
Header
Presentation
Used to identify the characteristics of the database used.
Close
Fields
The following fields are present on this tab :
| Name of the database. |
| Version number of the database. |
| Description of the database version. |
Close
Tab Processes
Presentation
On entry to this function, the processes connected to the current folder are displayed by default.
If the processes in all the solution folders are required, it is necessary to modify the Processes filter.
If the process display sort is to be modified, it is necessary to modify the Process sort and Direction.
It will then be necessary to refresh the display using the bottom of the screen.
This screen is made up of two sections :
Processes
This first section contains a grid that presents the processes running on the database.
Display options
This section is used to modify the filter options and the process sort.
The filter is used to restrict the processes display and as a result the display of the locks.
It will be necessary to refresh the display using the button at the bottom of the scree to take into account the new display options.
Close
Fields
The following fields are present on this tab :
| Identifier for the session in the database |
|
|
| Name of the database user |
| System user name |
| Connection date |
| Connection time |
| Status of the connection |
| Program in the process of execution. |
| Date of the last execution for an SQL instruction on the connection |
| Time of the last execution for an SQL instruction on the connection |
| The SQL instruction type last executed |
| Identifier for the process on the machine (defined by the operating system). |
| Indicates if the process is executed in background. |
| Name or the computer or the machine (defined by the operating system) from which the user is connected. |
| UC volume used by a session for the statistics related to the UC used by this session. |
| PGA memory Quantity of memory used by a session for the statistics related to the PGA memory for the session. |
| Physical reads in E/S Number of physical E/S blocks that can be read during a session fro the Physical reads statistic. |
| Logical reads Number of data blocks can be read during a session, including the blocks read from the memory or disk, for the statistic related to the block read of the database. |
| Actual analyses (hard parses) Actual analyzes (hard parse) can be read during a session for the statistic related to the number of analyzes (actual). These analyzes are carried out when the server analyzes an interrogation and that it finds no exact correspondence in the library cache. |
Block number 2
| Used to restrict or not the list of processes. It is possible to display
|
|
|
| Used to sort the list of processes. There is the possibility to specify the sense of the sort. |
|
|
Close
Action icon
Detail
Fields
The following fields are included in this window :
Block number 1
| Identifier for the session in the database |
| Name of the database user |
|
|
| Date of the last execution for an SQL instruction on the connection |
| Time of the last execution for an SQL instruction on the connection |
| System user name |
Last SQL instruction
| Text for the last SQL instruction executed on the connection |
Close
Used to view the text for the last SQL instruction for the process.
Disconnect after transaction
Used to wait for the end of the current transactions below closing the selected session.
Only a database user having the role DBA can carry out this action. It will therefore be necessary to give the name of the user having sufficient rights plus their password.
Disconnect immediately
Used to immediately close the selected session.
Only a database user having the role DBA can carry out this action. It will therefore be necessary to give the name of the user having sufficient rights plus their password.
Close
Tab Locks
Presentation
The second tab displays the list of locks in place and pending on the database that corresponds to the processes in the first tab.
This is used to distinguish in the case of blocking locks:
- which process is blocking
- which process is blocked and which is the process that it blocks.
Fields
The following fields are present on this tab :
Grid
| Identifier for the session in the database |
|
|
| Name of the database user |
| System user name |
| Name of the object or the transaction currently being locked. |
| Owner of the object currently being locked. |
| Lock, type of external lock (user or system), Description. The external locks of the type user are obtained by the user applications. All processes that are blocked by others are likely to have one of these locks. The external locks of the type user are as follows :
Other types of lock exist. The complete type and the description of the code. |
|
|
|
|
| Locking mode in which the session applies the pending lock. |
| Indicates if it is a blocking lock for another process |
| Locking mode in which the process requests place the external lock in pending. |
| Identifier for the blocking process |
| Time in seconds from which the process has obtained the lock or waits on the lock. |
Action icon
Detail
Fields
The following fields are included in this window :
Block number 1
| Identifier for the session in the database |
| Name of the database user |
|
|
| Date of the last execution for an SQL instruction on the connection |
| Time of the last execution for an SQL instruction on the connection |
| System user name |
Last SQL instruction
| Text for the last SQL instruction executed on the connection |
Close
Used to view the text for the last SQL instruction for the process.
Close