Monthly Archives: maggio 2015

Oracle 12c : New Feature - Privilege Analysis
  • 26
    Mag

Oracle 12c : New Feature – Privilege Analysis

In a common situation present in many database we find that some users have been granted more privileges than what was needed and these privileges , over time , have remained . This could be dangerous to the security of the data and the database itself . In Oracle 12c we have a package called DBMS_PRIVLEGE_CAPTURE through which...

Read More
Oracle RAC One Node
  • 15
    Mag

Oracle RAC One Node

Oracle introduced a new option called RAC One Node starting from release Oracle 11g. This option is available with Enterprise Edition only. It provide a cold failover solution for Oracle database. It’s a single instance of Oracle RAC running on one node of the cluster while the second node is in a cold standby mode. If the instance...

Read More
Shared storage planning for grid infrastructure
  • 7
    Mag

Shared storage planning for grid infrastructure

There are three ways of storing Grid infrastructure files: A supported Cluster File System (CFS) A certified Network File System (NFS) Automatic Storage Management (ASM) Sizing Shared Storage Minimum sizing for Oracle Clusterware configuration files using External, Normal, or High redundancy: Redudancy Minimum of disk OCR Files Voting disk Files Total External 1 280 MB 280 MB 560...

Read More