BY ACCESS Specify BY ACCESS if you want Oracle Database to write one record for each audited statement and operation.If you specify statement options or system privileges that audit data definition language (DDL) statements, then the database automatically audits by access regardless of whether you specify the BY SESSION clause or BY ACCESS clause.For statement options and system privileges that audit SQL statements other than DDL, you can specify either BY SESSION or BY ACCESS. BY SESSION is the default.意思就是 如果你想对每条记录的每个操作写一条审计记录就用这个,与此相对的关键字是by session这就是对每条SQL语句写一个审计记录。感觉就是审计粒度的选择吧。可想而知如果有几万条记录,要BY ACCESS写审计,估计系统要慢死了吧...
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货