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. […]
Category: ORACLE 12C
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 […]
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 […]
Applying JVM Patch In Oracle 12c RAC
This article explains the steps for applying the jvm patch on RAC. In the last post of mine. I have gone through the Patches and its types. 1. check for conflict https://www.linkedin.com/in/dbaanuradhamudgalcd /softdump/patch/JVM/22139226 opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.1.0.1.10 Copyright (c) 2016, Oracle Corporation. All rights reserved. PREREQ session Oracle […]
Move Datafile From File System To ASM Disk In 11g
Today, we are going to learn about those steps which use to move Datafile from file system to ASM disk in Oracle 11g.Being an Oracle DBA we have deep knowledge of Datafiles. We know there importance of Datafiles in the database. Somes lines explain about the technical definition. A data file is a file that is […]
Steps for Install Grid Infrastructure 12c On Standalone Server
Today, we are going to have look on the steps which is used for Install Grid Infrastructure 12c On Standalone Server. Grid installation on the standalone database server is also known as Oracle Restart. This is required if you wish you use ASM file system with Oracle restart feature. Oracle Restart Means, During any accidental Hardware or software […]
Data Dictionary views ( Oracle 12c)
This article is about data dictionary views in Oracle 12c. It is little bit different one from the last one due to its USB which is the cloud. We all know what is Data Dictionary and its importance? In 12c we have four types of static views which are like this USER, ALL, DBA, CDB. Object Categories:- X$:- It provides information […]
MAX_STRING_SIZE Parameter In Oracle 12c
This parameter was introduced in Oracle 12c. MAX_STRING_SIZE controls the maximum size of string size in Oracle database. Either we can set it to STANDARD or.EXTENDED The default value is STANDARD MAX_STRING_SIZE = STANDARD means the maximum size of strings is 4000 bytes for VARCHAR2 and NVARCHAR2 MAX_STRING_SIZE = EXTENDED means maximum size can be upto 32767 byte . We can change the value of MAX_STRING_SIZE from STANDARD to EXTENDED. But not from EXTENDED to STANDARD. With MAX_STRING_SIZE set to STANDARD , […]
How to encrypt the data using Oracle Wallet
Introduction:- Today we are going to learn about encryption in Oracle. Oracle database has the unique feature to secure data from the data loss. As we get a hint from the word encryption that means the process of converting information or data into code, especially to prevent unauthorized access. Rising security threats, expanding compliance requirements, consolidation, and cloud […]
New Background Processes in Oracle 12c
List of New Background Processes in Oracle 12c Name Expanded Name Short Description Long Description External Properties AQPC AQ Process Coordinator Per instance AQ global coordinator AQPC is responsible for performing administrative tasks for AQ Master Class Processes including commands like starting, stopping, and other administrative tasks. This process is automatically started on instance startup. […]