Hello Oracle,
when I do a simple Query:
SELECT * FROM V$Session WHERE Status = 'ACTIVE' AND Wait_Class = 'Idle' AND Type = 'USER';
I get some records back. So far I understand, an active session means, that an sql statement is fired against the server from that session. But I dont have an sql_id for all active sessions and those sessions have the wait-class 'idle. What does that mean, if a seccion is active but is idle as well ?
sql_coder