SAP BASIS,HANA AND ORACLE DBA BLOGS

Oracle 11g Fine-Grained Audit Trail (FGA) Existing FGA Policy View: select * from DBA_AUDIT_POLICIES select * from USER_AUDIT_POLICIES Adding policy for FGA: BEGIN   DBMS_FGA.ADD_POLICY(    object_schema      => 'AUDIT_TEST',    object_name        => 'COUNTRY',    policy_name        => 'CHECK_ID',    enable             =>  TRUE,    statement_types    => 'INSERT, UPDATE, SELECT, DELETE',    audit_condition    => 'REGION_ID = 1',    audit_trail        =>  DBMS_FGA.DB); END; / Example: DBMS_FGA.ADD_POLICY (    object_schema      =>  'scott',    object_name        =>  'emp', ...

Oracle Architecture Objectives These notes introduce the Oracle server architecture.  The architecture includes physical components, memory components, processes, and logical structures. Primary Architecture Components The figure shown above details the Oracle architecture. Oracle server :  An Oracle server includes an  Oracle Instance  and an  Oracle database .   ·          An Oracle database includes several different types of files:  datafiles, control files, redo log files and archive redo log files.  The Oracle server also accesses parameter files and password files.  ·          This set of files has several purposes.  o     One is to enable system users to process SQL statements.  o     Another is to improve system performance.  o   ...