Oracle Database Get waiting locks

Returns information about sessions waiting to acquire locks.