Category Archives: Articles

This pages contains all the articles of dba-scripts.com

Creating an ACFS filesystem

ACFS

About ACFS filesystem

ACFS mean  Automatic Storage Management Cluster File System. This filesystem volume resides inside the ASM database and can be used to store database files but also any type of files with or without direct relation to the database.

Oracle ACFS does not support Oracle Grid Infrastructure or Oracle Cluster Registry voting files.

The ACFS filesystem can be extended dynamically without any service interruption, you just need to add space to the diskgroup hosting the ACFS volume and then extend the filesystem. Continue reading Creating an ACFS filesystem

OCP 12C – Oracle Data Redaction

What is Oracle Data Redaction ?

  • Oracle Data Redaction is meant to mask (redact) sensitive data returned from application queries.
  • Oracle Data Redaction doesn’t make change to data on disk, the sensitive data is redacted on the fly before it is returned to the application.
  • You can redact column data by using one of the following methods:
    • Full redaction. You redact all of the contents of the column data.
    • Partial redaction. You redact a portion of the column data.
    • Regular expressions. You can use regular expressions to look for patterns of data to redact.
    • Random redaction. The redacted data presented to the querying application user appears as randomly generated values each time it is displayed, depending on the data type of the column.
    • No redaction. The None redaction type option enables you to test the internal operation of your redaction policies, with no effect on the results of queries against tables with policies defined on them.

Data Redaction Continue reading OCP 12C – Oracle Data Redaction

OCP 12C – Resource Manager and Performance Enhancements

Use Resource Manager for a CDB and a PDB

Managing Resources between PDBs

  • The Resource Manager uses Shares ans Utilization limit to manage resources allocated to PDBs.
  • The more “Shares” you allocate to a PDB, the more resource it will have.
  • Shares are allocated through DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE.
  • One directive can only concern one PDB and you can’t have multiple directive for the same PDB in the same plan.

Resource Manager

  • You can limit resource utilization of a specific PDB by using the UTILIZATION_LIMIT of the CREATE_CDB_PLAN_DIRECTIVE procedure. UTILIZATION_LIMIT is expressed in percentage of total system resources, if you set it to 50 it, the PDB will be able to use 50% of total system resources (CPU, I/O, parallel server).
  • The PARALLEL_SERVER_LIMIT parameter let you limit the parallel server utilization for a PDB.
  • If you don’t define a plan for a PDB, the default one applies, by default a PDB is being allocated :
    • 1 Share
    • No Utilization Limit
    • No Parallel Server Utilization limit

Continue reading OCP 12C – Resource Manager and Performance Enhancements