Well, I suggest you read the manual on auditing. Basically, it lets you
see who did what on the database. I believe you just change the setting
in the init.ora or spfile to:
Audit_trail=none
-----Original Message-----
From: nitin
[mailto:oracledba-ezmlmshield-x16266555.[Email address protected]
Sent: Wednesday, September 27, 2006 12:09 AM
To: LazyDBA Discussion
Subject: Auditing in Oracle
Hi Gurus,
Why auditing is used in oracle? What will happen if I turn off auditing?
What parameters need to be changed to turn off auditing?
I need to turn off auditing due to space constraint ( Frequent
ORA-09945) We are running Oracle 9i on Solaris.
Thanks in advance.
Nitin
=====-----=====-----=====
Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information. If
you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If you
have received this communication in error, please notify us by reply
e-mail or telephone and immediately and permanently delete the message
and any attachments. Thank you
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
CONFIDENTIALITY NOTICE
This message and any attachments are from the NAIC and are intended
only for the addressee. Information contained herein is
confidential, and may be privileged or exempt from disclosure
pursuant to applicable federal or state law. This message is not
intended as a waiver of the confidential, privileged or exempted
status of the information transmitted. Unauthorized forwarding,
printing, copying, distribution or use of such information is
strictly prohibited and may be unlawful. If you are not the
addressee, please promptly delete this message and notify the
sender of the delivery error by e-mail or by calling the NAIC Help
Desk at (816)783-8500.
Oracle LazyDBA home page