Oracle ZFS Network Attached Storage ZS4-4 System for Oracle Database 12c

Oracle has recently announced its latest generation of Network-attached Storage or NAS system namely the Oracle ZFS Storage ZS4-4. With the new Oracle Database 12c in place, ZS4-4 is capable of providing some brand new exciting features, which in the words of Oracle VP, Mr. John Fowler expand Oracle’s leadership in NAS performance. New Capabilities […]

The post Oracle ZFS Network Attached Storage ZS4-4 System for Oracle Database 12c appeared first on VitalSoftTech.

Happy Holidays and a Prosperous New Year from VitalSoftTech!

We at VST want to thank you, our prestigious members, for making 2014 a memorable year for us!  We are ever so grateful for your continuous support, participation and words of encouragement.  As technological mavens, you help us sustain this community with quality feedback that derives continued success for us all! How about mastering a […]

The post Happy Holidays and a Prosperous New Year from VitalSoftTech! appeared first on VitalSoftTech.

ASM DiskGroup Performance Statistics

The V$ASM_DISKGROUP_STAT view provides 12c ASM DiskGroup Performance Statistics for current DiskGroups. The data is extracted from the X$KFGRP_STAT source table. This view like all other ASM views are available in both the ASM and the Database instance. The data for this view accessed from the ASM includes information for all databases connected to the […]

The post ASM DiskGroup Performance Statistics appeared first on VitalSoftTech.

GoldenGate Not Keeping Up? Split the Process Using GoldenGate Range Function

In most environments one set of GoldenGate process (1 Extract & 1 Replicat process) is sufficient for change data synchronization. But if your source database generates a huge volume of data then a single process may not be sufficient to handle the data volume. In such a scenario there may be need to split the […]

The post GoldenGate Not Keeping Up? Split the Process Using GoldenGate Range Function appeared first on VitalSoftTech.

Configure Oracle Exadata Write Back Flash Cache

In addition to improving read I/Os, Oracle Exadata Write back flash cache also provides the ability to cache write I/Os directly to PCI flash. Exadata storage software version 11.2.3.2.1 is the minimum version required to use write back flash cache. Grid infrastructure and database homes must run 11.2.0.3.9 or later to use with Write-back Smart […]

The post Configure Oracle Exadata Write Back Flash Cache appeared first on VitalSoftTech.

Advanced Sessions for Oracle Open World Conference 2015

As database gurus and fanatics of the world, as well as hotels and cabbies of San Francisco know, one of the largest events the Oracle Open World conference ..

The post Advanced Sessions for Oracle Open World Conference 2015 appeared first on VitalSoftTech.

Larry Ellison Stepping Down as Chief of Oracle

Larry Ellison, CEO of Oracle is finally stepping down! He’s not leaving Oracle but as part of succession planning will be moving into the Executive Chairman role. He is one of the co-founders of Oracle and started the enterprise in 1977. The CEO responsibility will be shared between Mark V. Hurd and Safra A. Catz. […]

The post Larry Ellison Stepping Down as Chief of Oracle appeared first on VitalSoftTech.

Welcome to WordPress 4.0 “Benny”

WordPress 4.0 has been released. Upgraded my site without any issues. Key enhancements include: Intuitive editing Toolbar stays in place as you add content. Allows you to focus on your content. Seamless Media Embeds Just placing the link allows you to see the content.  New Plugin Browser Browse Plugins and Reviews directly in the dashboard. […]

The post Welcome to WordPress 4.0 “Benny” appeared first on VitalSoftTech.

A Preview of Oracle OpenWorld 2014

Oracle OpenWorld is an annual conference organized by Oracle, which provides Oracle users and technologists a unique opportunity to learn and socialize. Oracle OpenWorld 2014 is scheduled to take place from September 28 – October 2, 2014 in San Francisco. The conference is designed to provide Oracle users a platform to find best suited Oracle […]

The post A Preview of Oracle OpenWorld 2014 appeared first on VitalSoftTech.

Oracle Critical Patch Update Advisory – July 2014

The July Oracle Critical Patch has been released. This includes patches for Database Product Suite, Fusion Middleware Product Suite, Exalogic, and Enterprise Manager Suite Critical Patch Updates and Patch Set Updates. It includes 113 new security , 5 Oracle Database and a host of other bug fixes. More about the July 2014 Critical Patch Update […]

The post Oracle Critical Patch Update Advisory – July 2014 appeared first on VitalSoftTech.

GoldenGate Active-Active Database Replication with Conflict Detection and Resolution

Bi-Directional Replication also known as Active-Active Replication, is a configuration where both databases are used as an active site and applications perform DML/DDL activities on both Databases. The OGG processes is configured to replicate the transaction data of both the source databases back and forth to each other. 1. Advantages Bi-directional GoldenGate Replication can be […]

The post GoldenGate Active-Active Database Replication with Conflict Detection and Resolution appeared first on VitalSoftTech.

Limiting PGA with PGA_AGGREGATE_LIMIT in Oracle 12c

In Oracle 12c, a new interesting much needed feature, has been introduced which controls the maximum amount of the PGA memory consumed by the user processes. The PGA_AGGREGATE_LIMIT parameter limits the amount of memory used by processes in the PGA.

The post Limiting PGA with PGA_AGGREGATE_LIMIT in Oracle 12c appeared first on VitalSoftTech.

How to Provision Oracle VM VirtualBox using Pre-Built Developer VMs

The post How to Provision Oracle VM VirtualBox using Pre-Built Developer VMs appeared first on VitalSoftTech.

Learn GoldenGate – The Index

Learn about GoldenGate Extract, Pump, Replicat, GGSCI, Logdump, Troubleshooting and Upgrade.

The post Learn GoldenGate – The Index appeared first on VitalSoftTech.

Oracle GoldenGate 11gr2 Upgrade

This article demonstrates the steps to perform an in-place Oracle GoldenGate 11gr2 Upgrade (11.2.0.2). Expectations and Requirements There should be NO DATA LOSS. There should be NO database downtime. Oracle GoldenGate processes names will remain unchanged. Oracle GoldenGate replication will be DOWN for the period of OGG upgrade activity. Upgrade Oracle GoldenGate binaries Source and […]

The post Oracle GoldenGate 11gr2 Upgrade appeared first on VitalSoftTech.

Get the HAPPIEST Job on Earth!

Have you ever met one of those rare breed of people who is unusually fond of his/her job and, says, TGIM (Thanks God its Monday) instead of TGIF (Thanks God its Friday)? Chances are he/she is a DBA (database administrator). Most of us already know that the DBA position can be a very rewarding career. […]

The post Get the HAPPIEST Job on Earth! appeared first on VitalSoftTech.

The Step-by-Step Guide to Migrating to an Exadata Database Machine

We have migrated a number of our databases from non-Exadata servers to the Exadata Database Machine using the “RMAN 11g Duplicate standby from Active database” method. After creating a Dataguard Database, during a narrow maintenance window, we performed a failover of the database to the one Exadata Database Machines in the cluster. Below are the […]

The post The Step-by-Step Guide to Migrating to an Exadata Database Machine appeared first on VitalSoftTech.

Speaking at COLLABORATE 14 – IOUG on Managing Oracle 12c

COLLABORATE 14 - IOUG starts in a week. Very excited to be presenting "Learn What It Takes to Manage the Oracle 12c Database in the Cloud" on Thursday April 10, 2014.

The post Speaking at COLLABORATE 14 – IOUG on Managing Oracle 12c appeared first on VitalSoftTech.

Oracle VirtualBox New Released

A new version of the Oracle VirtualBox Software (4.3.10) has been released and can be downloaded here. This release fixes about 23 bugs. VirtualBox Resources • Pre-Built Developer VMs (for Oracle VM VirtualBox) • Oracle Linux VM Download • VirtualBox HOWTOs and tutorials documentation. Other Related Articles • How to Add Disk Storage to Oracle […]

The post Oracle VirtualBox New Released appeared first on VitalSoftTech.

50 Oracle GoldenGate Interview Questions and Answers

Read GoldenGate Interview Questions Learn GoldenGate – The Index Simple Replication • GoldenGate Replication Pre-requisites • GoldenGate Manager • GoldenGate Classical Extract • GoldenGate Pump • GoldenGate Replicat • Uni-directional Replication Summary Advanced Replication • Configure GoldenGate DDL Replication • GoldenGate Integrated Extract 12c Upgrade • Upgrade Classic Extract to Integrated Capture • Goldengate upgrade […]

The post 50 Oracle GoldenGate Interview Questions and Answers appeared first on VitalSoftTech.