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 function facilitates, 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.
Refer to documentation 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
Used to identify the characteristics of the database used.
| Database (field BDDNAM) |
|
Name of the database. |
| Version (field VER) |
|
Version number of the database. |
| field VERDES |
|
Description of the database version. |
Tab Processes
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.
| Session (field SID) |
|
Identifier for the session in the database |
| Instance (field INSTID) |
| Oracle user (field DBUSR) |
|
Name of the database user |
| O/S user (field OSUSR) |
|
System user name |
| Connection date (field LOGDAT) |
|
Connection date |
| field LOGHOU |
|
Connection time |
| Status (field STA) |
|
Status of the connection |
| Application (field APP) |
|
Program in the process of execution. |
| Last execution (field LASDAT) |
|
Date of the last execution for an SQL instruction on the connection |
| field LASHOU |
|
Time of the last execution for an SQL instruction on the connection |
| Processing type (field TYPSQL) |
|
The SQL instruction type last executed |
| Process host (field OSPRO) |
|
Identifier for the process on the machine (defined by the operating system). |
| Background (field BCKGRD) |
|
Indicates if the process is executed in background. |
| Machine (field MAC) |
|
Name or the computer or the machine (defined by the operating system) from which the user is connected. |
| CPU (field CPU) |
|
UC volume used by a session for the statistics related to the UC used by this session. |
| PGA memory (field PGAMEM) |
|
PGA memory Quantity of memory used by a session for the statistics related to the PGA memory for the session. |
| I/O phys reads (field PHYREAD) |
|
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 (field LOGREAD) |
|
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. |
| Hard parses (field HPARSE) |
|
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
| Filter process (field FLT) |
|
Used to restrict or not the list of processes. It is possible to display
|
| field FILLER0 |
| Sort of processes (field TRI) |
|
Used to sort the list of processes. There is the possibility to specify the sense of the sort. |
| Sign (field TYPTRI) |
| Detail | ||||||||||||||
|
Field descriptions
Block number 1
Last SQL instruction
|
Used to view the text for the last SQL instruction for the process.
Used to wait for the end of the current transactions below closing the selected session.
Used to immediately close the selected session.
Tab Locks
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.
Grid
| Session (field SID) |
|
Identifier for the session in the database |
| Instance (field INSTID) |
| Oracle user (field DBUSR) |
|
Name of the database user |
| O/S user (field OSUSR) |
|
System user name |
| Object (field OBJNAM) |
|
Name of the object or the transaction currently being locked. |
| Owner (field OBJOWN) |
|
Owner of the object currently being locked. |
| Lock (field LCK) |
|
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. |
| Type of lock (field LCKTYP) |
| Description (field LCKDES) |
| Locking method (field LMOD) |
|
Locking mode in which the session applies the pending lock. |
| Blocking (field BLOCK) |
|
Indicates if it is a blocking lock for another process |
| Locking method waiting (field RMOD) |
|
Locking mode in which the process requests place the external lock in pending. |
| Delay of the session (field WAIT) |
|
Identifier for the blocking process |
| Since (field CTIM) |
|
Time in seconds from which the process has obtained the lock or waits on the lock. |
| Detail | ||||||||||||||
|
Field descriptions
Block number 1
Last SQL instruction
|
Used to view the text for the last SQL instruction for the process.