Oracle Database Discussions

Hi all ,

Hope everyone had a wonderful weekend..


My database is installed on oracle 11.1.0.7 and OS is SPARC 64 bit.

In my init.ora file the following are the audit parameters :


audit_trail = none
audit_sys_operations = true

and

SQL> show parameter audit_trail;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string NONE





SQL> show parameter audit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /apps/oracle/product/11.1.0.7.
2010Q1/rdbms/audit
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string NONE


Since the Audit_sys_operations is TRUE and audit_trail is NONE , what does it mean, Is audit enabled ?

Becuase as per my knowledge audit_sys_operations is auditing of all the operations done by sys user.. but here Audit_trail is NONE.



Also , if I just want to track login and logout time for a particular user , is there any method ? using Audit or without Audit ?


regards
KKuKreja

PS: please tell me how to put the output from SQL in proper format here.