Subscribe to VitalSoftTech feed
Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen
Updated: 2 days 9 hours ago

Want to SPEED Up Your Database Tasks? DBMS_PARALLEL_EXECUTE to the rescue!

Thu, 2015-03-26 05:56
Use DBMS_PARALLEL_EXECUTE to divide one huge task into multiple small tasks that can be executed at the same time. See how many ways are there to divide.
Categories: DBA Blogs

Oracle 12c Deprecated Database Parameters

Mon, 2015-03-02 15:24
When upgrading to Oracle 12c it's good to be familiar with the deprecated parameters. These are not really desupported, just that they will be de-supported in future versions of the Database. Read more ..
Categories: DBA Blogs

Oracle MAA 12c – A Data Plan for Meeting Every Organization’s Needs

Mon, 2015-02-02 22:36
Data is one of the most valuable and crucial asset for any company, hence businesses spend huge amounts of money on their enterprise software to ensure its safety and availability. RAC and clustering are some examples of the ways companies practice for high availability and performance of their enterprise and databases. However there are still […]
Categories: DBA Blogs

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

Sun, 2015-01-11 19:02
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 […]
Categories: DBA Blogs

Happy Holidays and a Prosperous New Year from VitalSoftTech!

Sun, 2014-12-21 09:01
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 […]
Categories: DBA Blogs

ASM DiskGroup Performance Statistics

Sun, 2014-12-07 12:46
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 […]
Categories: DBA Blogs

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

Tue, 2014-11-11 10:35
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 […]
Categories: DBA Blogs

Configure Oracle Exadata Write Back Flash Cache

Thu, 2014-10-23 00:37
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 is the minimum version required to use write back flash cache. Grid infrastructure and database homes must run or later to use with Write-back Smart […]
Categories: DBA Blogs

Advanced Sessions for Oracle Open World Conference 2015

Fri, 2014-10-10 14:44
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 ..
Categories: DBA Blogs

Larry Ellison Stepping Down as Chief of Oracle

Thu, 2014-09-18 19:44
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. […]
Categories: DBA Blogs

Oracle Database 10g Certifications to Expire in March 01, 2015

Tue, 2014-09-16 20:01
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 […]
Categories: DBA Blogs

Welcome to WordPress 4.0 “Benny”

Fri, 2014-09-05 00:06
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. […]
Categories: DBA Blogs

A Preview of Oracle OpenWorld 2014

Wed, 2014-09-03 21:54
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 […]
Categories: DBA Blogs

Increase DSS Performance by 100x and OLTP by 2x. Learn more about Oracle 12c In-Memory Database.

Mon, 2014-08-04 09:45
With Oracle, 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 ...
Categories: DBA Blogs

Oracle Database 12c Release 1 [] Patch Released

Tue, 2014-07-22 11:46
Oracle Database Patch 17694377 for Linux, Solaris SPARC and x86 has been released on Metalink and edelivery. This software is a complete set and does not require a previous install. A number of key features in this release include the much talked about “Oracle Database In-Memory” database option. This feature will increase the DSS […]
Categories: DBA Blogs

Oracle VirtualBox 4.3.14 Released

Wed, 2014-07-16 15:08
Oracle has just released the Oracle VirtualBox 4.3.14. You can download the binaries here and view the change log here. VirtualBox Articles
Categories: DBA Blogs

Oracle Critical Patch Update Advisory – July 2014

Tue, 2014-07-15 20:45
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 […]
Categories: DBA Blogs

GoldenGate Active-Active Database Replication with Conflict Detection and Resolution

Tue, 2014-07-08 14:46
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 […]
Categories: DBA Blogs

Oracle GoldenGate Data Transformation

Tue, 2014-06-17 22:05
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.
Categories: DBA Blogs

Oracle 12c Last Login time for Non-Sys Users

Tue, 2014-06-10 09:45
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 […]
Categories: DBA Blogs