Oracle Executive Vice President John Fowler used the occasion of Open World 2015 to introduce Oracle's SPARC M7 processor, the fastest in the world. Learn more ...
The post Oracle SPARC M7 Processor Breaks the “Sacrifice Performance for Security” Rule and Much More appeared first on VitalSoftTech.
During my presentation "Oracle 12c for Developers" at the Sloveninan and Croatian User Groups I got the same question twice about Indentity Columns:
Is it possible to update an Identity Column?
During the presentation I show how it is not possible to insert a value for a "Generated Always Identity" column.
Let's take a look at an example:
SQL> create table t
2 (id number generated as identity
3 ,name varchar2(35)
The goal of this blog is not to analyze the reasons behind working of Oracle optimize as every database implementation is unique. The main objective is to understand what happens when Oracle optimizer chooses Index Fast Full Scan over Unique Scan. Significantly more occurrences of this behavior was observed after upgrading to Oracle12c.
As per Oracle documentation, An index fast full scan reads the index blocks in unsorted order, as they exist on disk. This scan does not (more...)
Rounding amounts may lead to rounding-issues, I have written how this may be resolved in a previous blogpost using some analytic functions.
Playing around a little bit, I also came up with a method to resolve the rounding difference with the MODEL clause.
To create an example, first let's create a table with only three records in it.
SQL> create table t
3 select rownum + 42 id
4 from dual
5 connect (more...)
One of my pet-projects is LoggerUtil, which is a utility for Logger, which is an excellent logging tool for PL/SQL.
This post is not about Logger, but some dealings with Conditional Compilation.
With Conditional Compilation you can create a single code base to handle different functionalities depending on compiler flags.
The latest addition to LoggerUtil was a method to create a custom template. For this to work, LoggerUtil depends on a certain Logger Release (where (more...)
Creating database using DBCA silent mode? Learn how to provision a database in a non-interactive mode.
The post Creating Database Using DBCA Silent Mode appeared first on VitalSoftTech.
The article read most often on this blog is called "Splitting a Comma Delimited String, the RegExp way".
On this blog there are two articles about this technique, one is about splitting up a single string into multiple rows and the other is about multiple strings into multiple rows.
Links to both articles are included at the bottom of this article.
It seems like there is a need for functionality like that frequently. And just (more...)
To refresh multiple Materialized Views you can use the DBMS_MVIEW package, with the procedure aptly named Refresh. One method is to provide a comma-separated list of Materialized View names, or you can use an DBMS_UTILITY.UNCL_ARRAY to achieve the same objective.
When using the latter method, I stumbled upon this oddity (which is not in the current documentation, or at least I couldn't find it).
The procedure that I initially wrote was the following:
When adding Redo logs to a database which has a DataGuard associated with it, the log files have to manually be added to the destination. Below are the steps on how to add them to both the source and the DataGuard databases. Adding Log Groups on Oracle DataGuard Database On the source first determine the […]
The post Adding Log Groups on Oracle DataGuard Database appeared first on VitalSoftTech.
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.
The post Want to SPEED Up Your Database Tasks? DBMS_PARALLEL_EXECUTE to the rescue! appeared first on VitalSoftTech.
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 ..
The post Oracle 12c Deprecated Database Parameters appeared first on VitalSoftTech.
Quite well said – Investment in knowledge is the gives you the best returns. It was a great fun last week to be the speaker at OTN Yathra 2015, organized by All India Oracle Users Group (AIOUG). The OTN tour covered seven cities and I was the part of it at three cities i.e. Hyderabad, Bangalore … Continue reading
When you connect from ODI Studio 12c to the repository you may get error “no ocijdbc in java.library.path”. In my case I use ODI Studio 12c installed on Windows 7 64bit machine and connecting to ODI 12c linux environment. So why do I get this error?
On the same note I use Oracle JDBC Driver ODI driver connection. As the studio does not use the tnsnames to connect to the Oracle (more...)
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 […]
The post Oracle MAA 12c – A Data Plan for Meeting Every Organization’s Needs 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 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.
One of the most wonderful things of Oracle Open World are the Demo-Grounds. When you want to learn more about a certain feature, this is the place to go to. The actual developers and product managers are there to answer your questions and more!
In a previous blog I had written about Temporal Validity in Oracle 12c and whether it would be possible to have multiple validity periods on one table. You can read that (more...)
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.
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.