Oracle Auditing - Feb 14, 2009 at 15:00 PM by Amit Satpute
Auditing can be for an individual user at session level or access level.
At access level a single record is created per action and at session level one
record is created for all audit actions per session.
Session audit records all distinct Encryption and Decryption requests for all
Session Auditing allows viewing who has had access to your encrypted data down
to the Terminal ID and database column level.
The Encryption Wizard management reports to trace user activity against the
Auditing powerful system privileges without regard to specifically named objects
is called statement auditing.
Auditing the use of powerful system privileges without regard to specifically
named objects is called privilege auditing.
Auditing accesses to specific schema objects without regard to user is called
Automatic Performance Diagnostic and Tuning Features, Automatic Shared Memory
Management - Automatic Shared Memory Management puts Oracle in control of
allocating memory within the SGA..........
Post-form commit fires once during the post and commit transactions process,
after the database commit occurs. The post-form-commit trigger fires after
What is Exception in Oracle?, What are the predefined oracle exceptions?,
Explain user defined exceptions in oracle, How PL/SQL Exceptions Are
An extent is stored some specific information. This information is stored using
specific number of adjoining data blocks. A collection of extent is called as a
segment stored in the same tablespace.............
A lot has been written on legacy modernization in the past few years. Most of
the books, analyst reports, and white papers discuss at a high level why one
should modernize and theorize, and the different approaches to, and possible
outcomes of modernization............