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.

Prerequisites

See also Refer to documentation Implementation

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.

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.

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
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

  • The processes on the current folder (by default)
  • All the database processes (all the folders)
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

Block number 1

Session (field SID)

Identifier for the session in the database
Oracle user (field DBUSR)

Name of the database user
Instance (field INSTID)
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
O/S user (field OSUSR)

System user name

Last SQL instruction

field SQLTXT

Text for the last SQL instruction executed on the connection

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.

Disconnect immediately

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 :

  • TM : place in the pending queue DML.
  • TX : placed in the pending queue of transactions.
  • UL : supplied by the user.
     

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

Block number 1

Session (field SID)

Identifier for the session in the database
Oracle user (field DBUSR)

Name of the database user
Instance (field INSTID)
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
O/S user (field OSUSR)

System user name

Last SQL instruction

field SQLTXT

Text for the last SQL instruction executed on the connection

Used to view the text for the last SQL instruction for the process.

Specific Buttons

Refresh

This button, also accessible using the short cut, used to refresh the display of the tabs.

Error messages

The only error messages are the generic ones.

Tables used

See also Refer to documentation Implementation