I am running a 10g database and want to capture the SQL statements that
one user is running. I was wondering if you could provide some help on
how to set this up. I think I can accomplish this with Standard
auditing, correct? So I set the AUDIT_TRAIL parameter. What else do I
need to do to capture the SQL ran by a certain user?

Oracle LazyDBA home page