Disable TDE In Oracle 12c

This post is about Disable TDE In Oracle 12c . Let’s hav look on the steps. Find the encrypted table columns and modify them: SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns;SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns; OWNER TABLE_NAME   COLUMN_NAME ENCRYPTION_ALG—– ———— ———— —————————–RAJ   EMPLOYEE    SALARY AES 192 bits key  SQL> alter table raj.employee modify( salary decrypt); Table altered. SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns; No […]

Read More

How To Move AUD$ Table To Another Tablespace Using DBMS_AUDIT_MGMT

Auditing is always about accountability, and is frequently done to protect and preserve privacy for the information stored in databases. Concern about privacy policies and practices has been rising steadily with the ubiquitous use of databases in businesses and on the Internet. Oracle Database provides a depth of auditing that readily enables system administrators to […]

Read More

ENABLE_DDL_LOGGING In Oracle 12c

This  ENABLE_DDL_LOGGING parameter has been introduced in Oracle 12c. If this ENABLE_DDL_LOGGING is enabled, then DDL records are written to the ADR. All DDL operations like alter/create/drop/truncate objects. Only drop user will be logged, But create user will not be. Enable the parameter: SQL> show parameter enable_ddl_logging NAME TYPE VALUE ———————————— ———– —————————— enable_ddl_logging boolean FALSE SQL> alter system […]

Read More

Purge AUD$ Table Using DBMS_AUDIT_MGMT

  Introduction:- Oracle 11gR2 introduced DBMS_AUDIT_MGMT for managing audit trails.  The growth of AUD$ can impact the performance of the database. So purging it regularly is the best practice followed by DBA’s and DBMS_AUDIT_MGMT makes it easier. Follow below steps for purging aud$ table. 1. Make sure AUD$ table is not in SYSTEM table tablespace.   […]

Read More

Unified Audit Trail In Oracle 12c

This post is about Unified Audit Trail In Oracle 12c . Few starting lines give the overview of ” Unified Audit Trail ” .   With Oracle 12c, unified auditing has been introduced. It consolidates all audit trails into a single audit trail table. It will capture audit records from below sources. SYS audit records ( which was […]

Read More

ASM (Sector Size Validations)

From the technical background, we have an idea of Validations. I talk about normal life we notice that we have lots of Validations in our life. Let’s have look at today about ASM (Sector Size Validations). First few lines will explain the technical definition of  Validations. Validation is the name given to the process whereby the information entered […]

Read More

ASM -(Sector Disk Drives)

This post is about ASM’s attribute deep knowledge. Before going ahead we must have an idea about the topic. Let’s some line must explain about  ASM -(Sector Disk Drives). The database and Oracle’s Automatic Storage Management (ASM) volume manager explicitly understood 4k devices. In this and subsequent versions of ASM, disk groups created on native mode […]

Read More

ASM Disk Group Attributes

We are the part of RDBMS world. As a student when we entered in the world of RDBMS we learned about the attributes of the entity.  I hope you have the idea what we are going to do in this post.  As the heading of the post explains. Today we are going to have look at ASM Disk […]

Read More

Shutdown mode in Oracle ASM Instance

Being an Oracle DBA we have learned about the db instance in Oracle database. As we know db instance has shutdown mode. In this post, we are going to have look at Oracle ASM Instance. The ASM shutdown process is initiated when you run the SHUTDOWN command in SQL*Plus. While running this command we must ensure […]

Read More

ASM Dynamic Performance Views

We are going to have look at the ASM Dynamic Performance Views.  In the database, we have learned about views. Here we are going to focus on ASM Dynamic Performance Views. As we know An ASM instance does not have a data dictionary. The information relating to its configuration and operation is available by querying a set of […]

Read More