Server Oracle 11g
Session Manager
Created a stored procedure and ran -- it created locks on the server.
One of the Transaction Lock type was displayed as AE- ?????
Need to display the Lock properly.
AE type is not listed for user locks. I added locks AE, RX, RS for both user and system locks although they are not in the documentation for the view v$locks. I took those names from the view v$lock_type that exists for Oracle 10g, 11g. I didn't join with this view because it's not very consistent with the types listed for v$lock.
Issue #1648 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
AE type is not listed for user locks. I added locks AE, RX, RS for both user and system locks although they are not in the documentation for the view v$locks. I took those names from the view v$lock_type that exists for Oracle 10g, 11g. I didn't join with this view because it's not very consistent with the types listed for v$lock.