Is there a way to extract a trace of the queries executed by a session (or by any of the dimensions in PA: DB user, OS user, program, etc), for having the query execution sequence? (the idea is having the queries in order of execution, not only by "tops").
Extracting a complete trace of queries is not possible with Performance Analysis. Please remember, that we only sample the sga at specific intervals, which means we don't pick up queries that run between sample periods. PA was not designed to be an auditing tool, but a performance analyzer, which is why it mainly is concerned with the "tops".