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.
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.
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.
In most of the environments, one set of OGG processes (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 […]
The post GoldenGate not keeping up? Use GoldenGate Range function to split up the process appeared first on VitalSoftTech.
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 126.96.36.199.1 is the minimum version required to use write back flash cache. Grid infrastructure and database homes must run 188.8.131.52.9 or later to use with Write-back Smart […]
The post Configure Oracle Exadata Write Back Flash Cache appeared first on VitalSoftTech.
As database gurus and fanatics of the world, as well as hotels and cabbies of San Francisco know, one of the largest enterprise software events, Oracle OpenWorld 2014 was held in San Francisco from September 28th, 2014 to October 2nd, 2014. The reason the later group know a tad bit about the event is because […]
The post Overview of Oracle OpenWorld 2014 appeared first on VitalSoftTech.
Oracle Database is one of the leading relational database management system and is used all over the world. It has various training’s, exams and certifications for its Database and other products. However due to regular update in Database, they have to redesign their trainings, certification and exams to add new features and to remove old […]
The post Oracle Database 10g Certifications to Expire in March 01, 2015 appeared first on VitalSoftTech.
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.
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.
With Oracle 184.108.40.206, the largest performance enhancing features, the Oracle 12c In-memory database option, has been released. Learn more about how to enable it, the licensing costs, etc. Also read other about Oracle 12c In-Memory Database FAQ's here ...
The post Increase DSS Performance by 100x and OLTP by 2x. Learn more about Oracle 12c In-Memory Database. appeared first on VitalSoftTech.
Oracle GoldenGate supports data mapping and manipulation. It is done by using options of Table (Extract) and Map (Replicat) parameters. By default OGG assumes that SOURCE and TARGET table definitions are same that part of replication.
The post Oracle GoldenGate Data Transformation appeared first on VitalSoftTech.
Oracle 12c introduced a new, very useful security feature to store and display the last login information for non-sys users, logging in via SQL*PLUS. The last login time is displayed in the banner by default when we log into the database using SQL*PLUS in 12c. Related Articles • Oracle 12c: Data Redaction Unified Auditing Extended SHA-2 […]
The post Oracle 12c Last login time for Non-Sys Users appeared first on VitalSoftTech.
If you have your Oracle VM VirtualBox setup and running there is a possibility that you may need to setup the network for the Virtual Machine to make it accessible from the host machine (Desktop or Laptop). This may be needed when you want to connect your local applications to the database running on the VM VirtualBox.
The post Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox appeared first (more...)
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.
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.
DBA’s, Developer’s and SYS Admin’s require test environments to perform testing such as OS/Database patching, upgrades, new features, etc. before performing these tasks on the Production environments. They are not always successful in finding a place to test these changes and at other times it takes too long to get the environment provisioned. Many of […]
The post Provision Oracle VM VirtualBox using Pre-Built Developer VMs appeared first on VitalSoftTech.
Learn about GoldenGate Extract, Pump, Replicat, GGSCI, Logdump, Troubleshooting and Upgrade.
The post GoldenGate Extract, Pump, Replicat, GGSCI, Logdump, Troubleshooting and Upgrade Notes appeared first on VitalSoftTech.
This article demonstrates the steps to perform an in-place Oracle GoldenGate 11gr2 Upgrade (220.127.116.11). 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.
We have been migrating our databases from the non-Exadata servers to the Exadata Database Machine using the “RMAN 11g Duplicate standby from Active database” command, to create the standby databases on the Exadata machine. Below are the steps which were performed for these successful migrations. Assumptions Here we assume that the following tasks has been […]
The post Migrating a Database to an Exadata Machine appeared first on VitalSoftTech.
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.