Do you thing the following would be poosible
with Oracle Auditing or by writing additional
scripts? The end-users wants to capture these
on a daily basis in a Datamart.

1. SQL statement being executed
2. Userid executing SQL statement
3. Time Length for SQL statement execution
4. Time Length for user session

Using Oracle's auditing option, I know we
can perform 2 and 4. But, 1 and 3 can not
be.

Any suggestions???