StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2612535
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-04-10T06:46:44.610
FavoriteCount
0
LastActivityDate
2010-04-10T06:53:08.760
LastEditDate
2010-04-10T06:53:08.760
LastEditorUserId
313312
OwnerUserId
313312
ParentId
67557
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
There is no need to "roll your own". Just turn on auditing: <ol> <li>Set the database parameter AUDIT_TRAIL = DB.</li> <li>Start the instance.</li> <li>Login with SQLPlus.</li> <li>Enter the statement <pre>audit all;</pre>This turns on auditing for many critical DDL operations, but DML and some other DDL statements are still not audited.</li> <li>To enable auditing on these other activities, try statements like these:<pre>audit alter table; -- DDL audit audit select table, update table, insert table, delete table; -- DML audit</pre></li> </ol> Note: All "as sysdba" activity is ALWAYS audited to the O/S. In Windows, this means the Windows event log. In UNIX, this is usually $ORACLE_HOME/rdbms/audit. Check out the <a href="http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4007.htm" rel="nofollow noreferrer">Oracle 10g R2 Audit Chapter</a> of the Database SQL Reference. The database audit trail can be viewed in the SYS.DBA_AUDIT_TRAIL view. It should be pointed out that the internal Oracle auditing will be high-performance by definition. It is designed to be exactly that, and it is very hard to imagine anything else rivaling it for performance. Also, there is a high degree of "fine-grained" control of Oracle auditing. You can get it just as precise as you want it. Finally, the SYS.AUD$ table along with its indexes can be moved to a separate tablespace to prevent filling up the SYSTEM tablespace. Kind regards, Opus
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to Audit Database Activity without Performance and Scalability Issues?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USOpus
UserOwnerUserId
1. USOpus
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.