PAGELOCKS
This system view SYSINFO.PAGELOCKS
can be used to determine the state of locked or requested data pages in the data cache.
Structure
|
FIXED(20) |
Locked or requested page belongs to the file with this root page number |
|
FIXED(20) |
Page number of locked or requested page |
|
CHAR(10) |
Type of page (PERMANENT | TEMPORARY | STATIC) |
|
FIXED(5) |
Identification of the file system |
|
FIXED(5) |
Identification of the partition |
|
FIXED(10) |
Identification of the lock or request holder |
|
FIXED(10) |
Number of lock or request holders |
|
CHAR(10) |
Type of lock (NULL value | SHARE | EXCLUSIVE) |
|
CHAR(10) |
Type of lock request (NULL value | SHARE | EXCLUSIVE) |
More Information
Concepts of the Database System, How Databases Store Data and Log Entries, Working Memory Areas