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.

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.

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

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.

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.

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

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 ...

The post Increase DSS Performance by 100x and OLTP by 2x. Learn more about Oracle 12c In-Memory Database. appeared first on VitalSoftTech.

Oracle Database 12c Release 1 [12.1.0.2] Patch Released

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 […]

The post Oracle Database 12c Release 1 [12.1.0.2] Patch Released appeared first on VitalSoftTech.

Oracle 12c Last Login time for Non-Sys Users

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.

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

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...)

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.

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.

Setting up Oracle 12c Active Data Guard Database

In the Multitenant world, the PDB Database is considered an independent database but the operational tasks performed at the CDB level effect all the PDB databases plugged into it. The task of setting up of a Data Guard, switching or failing over are all performed at the CDB level. When the Data Guard is initially setup, with the CDB database, all PDB's are also replicated to the target. Read more here.

The post Setting up (more...)

New SYSBACKUP, SYSDG and SYSKM Administrative Users in Oracle 12c

Large enterprise database environments have dedicated DBAs performing specific database roles. Some of these specific roles include database storage management, tuning, backup and recovery, etc. Inside these organizations there has been growing concern to further ensure the use of the SOD (Segregation of Duties) concept, to fulfill duties for these roles.

The post New SYSBACKUP, SYSDG and SYSKM Administrative Users in Oracle 12c appeared first on VitalSoftTech.

How to Add Disk Storage to Oracle Virtual Box on Linux Guest OS?

Are you looking to install Oracle software on your VirtualBox but are running low on disk space? Learn how to add disk storage to Oracle VirtualBox with Linux Guest OS.

The post How to Add Disk Storage to Oracle Virtual Box on Linux Guest OS? appeared first on VitalSoftTech.

Cloning Oracle 12c Home Binaries

Almost every backup and recovery concern is focused on protecting the data stored inside database and rightly so. But during the course of a DBA career, restoring the Oracle Home or duplicating is sometimes is necessary.

The post Cloning Oracle 12c Home Binaries appeared first on VitalSoftTech.

Profiling your Database 12c – Part 1 – Using Dynamic Performance Views

Database dynamic performance views provide various statistics like session events, system events, waits, etc.. These statistics are mostly cumulative values, aggregated from the time the instance was started.


Below are some views which provide these statistics. In Oracle 12c, to support multitenant environments, most of the views like V$SYSSTAT and V$EVENT_HISTOGRAM now have an additional CON_ID column.

The post Profiling your Database 12c – Part 1 – Using Dynamic Performance Views appeared first on VitalSoftTech.

Oracle 12c Silent Mode Binary Install and De-install

Installation of the Oracle Binaries is a pretty simple task for the DBA's. However the process may become exhaustive if you are repeatedly performing these installs on a number of servers.

The post Oracle 12c Silent Mode Binary Install and De-install appeared first on VitalSoftTech.

Oracle Database 12c New Features

I think I am a little bit late but on the other hand it’s never too late to comment and share opinion about some among the 500+ new features introduced with Oracle Database 12c.

The first feature which really caught my attention was Multiple Indexes on Same Set of Columns (more...)

DataGuard – Far Sync – part 12 – Data Guard Broker

Oracle introduced Far Sync Data Guard configuration which I described briefly in this post. Now is time for part two and using Data Guard Broker to add Far Sync instance.
Assuming that you have basic Data Guard Broker configuration ready (as described in - How to quickly build standby database (more...)

How to quickly build standby database and setup DataGuard configuration using Oracle 12c

With every release of Oracle database there are new possibilities to build a required solution (ex. standby database) faster and with fewer steps. This is not official guide but rather a mix of Oracle 12c functionality used to build DataGuard configuration using RMAN and DataGuard Broker.

Assumptions: