VitalSoftTech

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: 4 days 6 hours ago

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 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 […]
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 12.1.0.2, 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 [12.1.0.2] Patch Released

Tue, 2014-07-22 11:46
Oracle 12.1.0.2 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

Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox

Mon, 2014-05-26 09:45
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.
Categories: DBA Blogs

Limiting PGA with PGA_AGGREGATE_LIMIT in Oracle 12c

Mon, 2014-05-19 09:50
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.
Categories: DBA Blogs

Learn GoldenGate – The Index

Tue, 2014-04-29 08:51
Learn about GoldenGate Extract, Pump, Replicat, GGSCI, Logdump, Troubleshooting and Upgrade.
Categories: DBA Blogs

Pages