oracleskill

      Enhanced Password      
      Pete Finnigan notes some new Oracle 11g security features "[Oracle 11g] will have case sensitive passwords and also the password algorithm has changed to SHA-1 instead of the old DES based hashing used."     
            
      Oracle SecureFiles     
      Replacement for LOBs that are faster than Unix files to read/write. Lots of potential benefit for OLAP analytic workspaces, as the LOBs used to hold AWs have historically been slower to write to than the old Express .db files. Mark Rittman Securefiles are a huge improvement to BLOB data types. Faster, with compression, encryption.     
            
      Oracle 11g audit vault     
      Oracle Audit Vault is a new feature that will provide a solution to help customers address the most difficult security problems remaining today, protecting against insider threat and meeting regulatory compliance requirements.

Proxy connect for SQL*Plus      
      

New with 10r2 proxy identification in SQL*Plus, the "connect" command has been enhanced to allow for a "proxy", to aid applications that always connect with the same user ID:

 connect sapr3[scott]/tiger                        
      FGAC for UTL_SMTP, UTL_TCP and UTL_HTTP     
      You can define security on ports and URLs     
            
      Fine Grained Dependency Tracking (FGDT)     
      This means that when you add a column to a table, or a cursor to a package spec, you don't invalidate objects that are dependant on them. Sweet!     
            
      Database Workload Replay     
      Oracle "Replay" allows the total database workload to be captured, transferred to a test database created from a backup or standby database, then replayed to test the affects of an upgrade or system change. Currently, they are working to a capture performance overhead of 5%, so you could conceivably capture real production workloads.     
      RELATE LINK :     
      Oracle 11g SQL new features
Oracle 11g PL/SQL new features
Oracle 11g programming support new features
Oracle 11g DBA new features
Oracle 11g High Availability & RAC new features
Oracle 11g OEM Enterprise Manager new features
Oracle 11g Performance tuning optimization new features