Hi Guys,
I'm new to oracle and trying to explore some database audit options, I've doen the following:

set audit_trail=OS
set audit_sys_operations=true

then I run "audit select table by USER1"

But when I'm doing any SELECT by connection USER1, I'm not getting the complete SELECT statment in the audit files under dump location.

Following is contents of the audit file:


SESSIONID: "11745" ENTRYID: "13" STATEMENT: "9" USERID: "USER1" USERHOST: "server123" TERMINAL: "pts/16" ACTION: "103"
RETURNCODE: "0" OBJ$CREATOR: "SYS" OBJ$NAME: "V$INSTANCE" SES$ACTIONS: "---------S------" SES$TID: "4294951066" OS$USERID: "or
acle"



Please help me to do it.

Thanks,
Hussain