Locks in Oracle - Part 2 Copy
Transaction--> Locks How is my transaction are tracked How does oracle ensures or rather maintains data integrity and table definition integrity during the due course of my transaction? How is...
Oracle Partition Pruning on Date Comparisons
In the previous post we saw date filter clause impact over index, now let us iterate the same testcase against partitioned tables, Table Creation CREATE TABLE "C##HARI"."TBL_OBJECTS_p" ( "ID" NUMBER, "ID_VAL" VARCHAR2(46...
Date Filters and their impact over Index
I was discussing with my friend on date filters and how they impact the performance, thought this topic is worth blogging. With tables holding historic data, you would see columns...
Oracle 12c - Pattern Matching Part 1
Oracle 12c Pattern Matching Big SQL :) Before getting into Oracle 12c Pattern Matching - the set of questions which came across after looking at Oracle 12c Patern Matching -...
You would have never thought that this feature would help in Tuning
The word "Tuning" should be in discussion right at the initial stage of your design and not just after shipping you code to production. In most of the environments have...
Are my Materialized View Used - How to check it ?
The below use case will help to check whether your SQL would be rewritten using particular MV - without having to execute the SQL. Isn't it cool, let us check...
Oracle 12c - PLSQL index by table to Java/SQL
My application front end is Java and DB is Oracle. What array should i use in my PLSQL - program parameters to enable JDBC application to invoke them ? Until...
Oracle 12c - With Clause Enhancements
Until Oracle 12c, we have been using WITH Clause to replace Sub-query Correlated Subqueries Now to this you can define PLSQL declarations in a WITH Clause statement from Oracle 12c....
Locks in Oracle - Part 2
Transaction--> Locks How is my transaction are tracked How does oracle ensures or rather maintains data integrity and table definition integrity during the due course of my transaction? How is...
Locks in Oracle - Part 1
Apart from parsing What happens when i issue an update statement ?/li> How does Oracle comply with the properties of a Database Transaction aka ACID properties If interested read further :)...
Load More