These privileges are required to use the “Monitor SQL” feature of SQL Developer:
create role dynamic_views; grant select on v_$session to dynamic_views; grant select on v_$database to dynamic_views; grant select on v_$lock to dynamic_views; grant select on v_$sql to dynamic_views; grant dynamic_views to <user>;