Monthly Archives: aprile 2015

Oracle 11g: Case sensitive password
  • 28
    Apr

Oracle 11g: Case sensitive password

With 11g rel1 Oracle introduced case sensitive passwords for database accounts based on the SHA1 (Secure Hash Algorithm). This feature can be enabled changing the init.ora parameter SEC_CASE_SENSITIVE_LOGON. By default this parameter is set to false; setting parameter to TRUE all new passwords will be case sensitive. All existing passwords – created before - will remain case insensitive...

Read More
Oracle 12C: Full Database Caching
  • 20
    Apr

Oracle 12C: Full Database Caching

This feature is available starting with Oracle Database 12c Release 1 (12.1.0.2) When to use it: when you have enough memory to keep all segments in memory when you are limited by I/O system and response time Full database caching can be used to cache the entire database in memory. It should be used when the buffer cache...

Read More
Oracle 12c Rdbms: Desupported & Deprecated Features
  • 13
    Apr

Oracle 12c Rdbms: Desupported & Deprecated Features

Below is a list of some features desupported and deprecated since release Oracle Rdbms 12C  Single character SRVCTL command The Server Control Utility (SRVCTL) command line interface (CLI), used in earlier releases, starting with Oracle Database 12c is deprecated and may be desupported in a later release.  Catalog view The following views are deprecated in Oracle...

Read More
Online table partition migration
  • 8
    Apr

Online table partition migration

Migration of a table partition or sub-partition to a different tablespace no longer requires a complex procedure in Oracle 12c. When an “online” clause is specified, all dml operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. No dml operations are allowed if the partition|sub-partition is moved offline. some examples …...

Read More