Oracle Database Discussions

Hi,

I am using Oracle 10g. I want to start the audit trace with the XML, extended option , so that the audit trace can show the exact SQL statement the user issued.

In my pfile, when I change the AUDIT_TRAIL to XML, I can see the xml files in the AUDIT_FILE_DEST directory with all the information except the SQLTEXT.
When I change the parameter AUDIT_TRAIL to "XML, EXTENDED", I get the following error.

SQL> startup pfile=C:\oracle\product\10.2.0\db_1\dbs\pfile.ora
LRM-00121: 'XML, EXTENDED' is not an allowable value for 'audit_trail'
ORA-01078: failure in processing system parameters

Following is the setting of audit_trail in my pfile

*.audit_file_dest='C:\oracle\product\10.2.0/admin/orcl/adump'
*.audit_trail='XML, EXTENDED'

I also tried XML_EXTENDED similar to DB_EXTENDED, but it does not work either.

What is the right syntax for the AUDIT_TRAIL parameter if I want to enable the xml extended trace?

Thanks,
Sam