Hello,
From the docs, I understand that the Auto FlushMode of a Session does a flush (sometimes) before the next query execution. So, my question is what happens when a query in a different session (at the same time) is executed on the same entity. Does flush automatically happen before the query even if the query is in a different concurrent session?
Thanks,
Madhan.

I suppose two different sessions live completely independed from each other. Query in one session may cause flush() only in the same session.

Moreover (if you worry about visibility of the data inserted in one session to another session): flush does not involve transaction commit and since different sessions live in different transactions, another session will not see inserted data even after explicit flush()

Well, it depends upon the db isolation level...