Mohammad Samad

Author's posts

Apr 14 2020

Oracle Database 12c R1 (12.1) RAC installation

Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. Below high level steps will perform to configure / install Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC Install Oracle Linux 5.7 Install GI (Grid Infrastructure) Configure ASM Install Oracle Database Binary Create Database …

Continue reading

Apr 13 2020

Create and Manage Partition Table in Oracle

Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data. 

Continue reading

Apr 12 2020

USABLE_FILE_MB is showing negative values in V$ASM_DISK View

REQUIRED_MIRROR_FREE_MB value in V$ASM_DISKGROUP indicates how much free space is required in an ASM disk group to restore redundancy after failure of an ASM disk or ASM failure group. USABLE_FILE_MB value indicates how much space is available in an ASM disk group considering the redundancy level of the disk group. We need 3614 MB space …

Continue reading

Apr 08 2020

Configure Resource Manager on Container Database

The following issues DBAs may face in oracle databases but we can overcome these issues by using Resource Manager: Excessive overhead: Excessive overhead results from operating system context switching between Oracle Database server processes when the number of server processes is high. Inefficient scheduling: The operating system deschedules database servers while they hold latches, which …

Continue reading

Apr 07 2020

In-Database Archiving

Companies may need to keep data for longer time for compliance purposes even there is not use these data for companies. In-Database Archiving enables you to archive rows within a table by marking them as inactive. These inactive rows are in the database and can be optimized using compression, but are not visible to an application. The data in these …

Continue reading

Apr 05 2020

Temporal Validity in 12c

Temporal Validity enables you to track time periods for real world validity. Valid times can be set by users and applications for data, and data can be selected by a specified valid time, or a valid time range. Concepts that are integral to valid time temporal modeling include: Valid time: This is a user-defined representation …

Continue reading

Apr 05 2020

Clone Virtual Machine

This is always good to have a golden copy of your system. Then you don’t need to spend time to build your environment. For example, you can clone a VM after installed OS and configure network and prerequisites. Within couple of minutes you VM will be ready for any kind of R&D.

Continue reading

Apr 03 2020

Oracle Data Pump (expdp, impdp) in Oracle Database

The Data Pump feature had been introduced from Oracle 10g. Until Oracle 9i, There were a tradition export and import (exp, imp) tools for logical backup. Nowadays Data Pump (expdp & impdp) utilities are mostly use by oracle DBA. Data Pump is very useful tools to migrate database in difference version of Oracle databases or …

Continue reading

Apr 02 2020

Configure Heat Map & Automatic Data Optimization (ADO) in Oracle 12c

Nowadays Data is growing very rapidly at enterprises – various industry estimates indicate that data volume is doubling every 2-3 years. The rapid growing data is going to be challenged for IT, both in cost and performance. Although the cost of storage keeps declining, fast-growing data volumes make storage one ofthe costliest elements of most …

Continue reading

Mar 25 2020

Configure the network environment for Multitenant Database

This topic describes how to configure the network environment on Multitenant Database. Create a Service. Create a Listener. Create a Service: List of Services: Create a Service for PDB: DBMS_SERVICE package will use for creating a new service. For GI env, you may use srvctl to create and manger a service. When execute DBMS_SERVICE.CREATE_SERVICE procedure, …

Continue reading