In one of our database instances there are around 15-20 blocking sessions in v$active_session_history with almost all of them having no SQL_ID at all. These are occuring throughout the day and the blocking session_id is Session ID 1 (Oracle instance)
The rest of the blocking sessions have an SQL_ID with the SQL_TEXT of update OBJ$ SET OBJ#=:4 TYPE#=:5, CTIME=:6, MTIME=:7, STIME=:8, STATUS=:9, DATAOBJ#=
There is only one instance our of 8 that is having these issues but I really don't know where to start diagnosing them or if it is even an issue.
What should I do?