[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

show parameter audit

can I ask what "db" represents when running the query in the question title, in terms of what, what exactly will be being audited, action wise? I have run this query over a number of databases, so return NONE others DB. I just wondered what kinds of thing will be being audited, with such a configuration?
0
pma111
Asked:
pma111
1 Solution
 
Steve WalesSenior Database AdministratorCommented:
You may want to refer to the documentation on this one :)

http://docs.oracle.com/cd/E11882_01/network.112/e36292/auditing.htm#DBSEG352

There are certain standard auditing options that Oracle can undertake that are written to sys.aud$

If you set audit_trail to NONE, these features are disabled.
Setting to DB means that these rows are written to SYS.AUD$
You can also set to OS, which would write the rows to an operating system level file.

There's a lot of stuff that can be captured, so I'd recommend reading that chapter of the documentation and coming back with any specific questions you might have.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now