Tracing user Queries & Sessions

Hi Team,

I have a test env where i do multiple tests for users SQL Queries & Sessions.

After creating trace , i could see all files are raw i.e. very limited information i could understand. some examples are FETCH, PARSE, WAIT, SQL Query and so .. on

Except tkprof , are we good to understand trace files or trace files are specific to MOS.

2) Some times we are facing Query is running High CPU.

When i checked , i could see that specific SQL is running with multiple sessions.

All sessions may use same SID

In this case, how do i track or trace particular user session !