+321 123 4567
info@test.com
User login
Facebook
Google+
puthranv-logo
  • Home
  • Profile
  • Talks
  • Videos
  • Contact

Category: Oracle

Home Archive by Category "Oracle"

Locks in Oracle - Part 2 Copy

May 8, 2017puthranvMiscellaneous, OracleNo Comments

wordpress

Oracle Partition Pruning on Date Comparisons

August 18, 2016puthranvOracle, Performance TuningNo CommentsDate 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

July 15, 2016puthranvOracle, Performance TuningNo CommentsDate Filters
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

June 15, 2016puthranvOracle, SQLNo CommentsOracle 12c - Pattern Matching
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

January 4, 2015puthranvOracle, Performance TuningNo CommentsTuning
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 ?

March 25, 2014puthranvMiscellaneous, OracleNo Comments
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

February 2, 2014puthranvOracle, PLSQLNo CommentsPLSQL 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

January 12, 2014puthranvOracle, PLSQLNo CommentsOracle 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

April 11, 2013puthranvMiscellaneous, OracleNo Comments
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

March 4, 2013puthranvMiscellaneous, OracleNo Comments
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

Recent Posts

  • Locks in Oracle - Part 2 Copy
  • Oracle Partition Pruning on Date Comparisons
  • Date Filters and their impact over Index
  • Oracle 12c - Pattern Matching Part 1
  • Awarded - AIOUG Volunteer of the Year 2015 at Sangam15

Recent Comments

    Archives

    • May 2017
    • August 2016
    • July 2016
    • June 2016
    • November 2015
    • October 2015
    • January 2015
    • November 2014
    • March 2014
    • February 2014
    • January 2014
    • December 2013
    • April 2013
    • March 2013
    • February 2013
    • January 2013
    • December 2012
    • November 2012
    • October 2012
    • September 2012
    • August 2012
    • July 2012
    • June 2012
    • May 2012
    • April 2012
    • March 2012
    • February 2012
    • January 2012
    • March 2011
    • February 2011
    • January 2011

    Categories

    • Awards
    • Miscellaneous
    • Oracle
    • Performance Tuning
    • PLSQL
    • Replication
    • Speaking
    • SQL
    • Uncategorized

    Meta

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org

    Recent Posts

    • Locks in Oracle - Part 2 Copy May 8, 2017
    • Oracle Partition Pruning on Date Comparisons August 18, 2016
    • Date Filters and their impact over Index July 15, 2016
    • Oracle 12c - Pattern Matching Part 1 June 15, 2016
    February 2019
    M T W T F S S
    « May    
     123
    45678910
    11121314151617
    18192021222324
    25262728  

    Tags

    bind variable Cardinality Estimate Child Cursors Date Comparisons Date Filters design MEMBER OF Vs TABLE OF CAST music oracle Oracle 12c - Pattern Matching Oracle 12c - With Clause Enhancements Oracle 12c New Features photography Pipeline Functions PLSQL PLSQL index by table to Java/SQL Real Time SQL Monitoring Tuning video wordpress Zero Downtime Migration

    Categories

    • General (1)
      • Awards (1)
    • Oracle (28)
      • Miscellaneous (9)
      • Performance Tuning (11)
      • PLSQL (6)
      • Replication (1)
      • SQL (1)
    • Speaking (2)
    • Uncategorized (1)

    Text widget

    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sed diam eget risus varius blandit sit amet non magna. Mattis purus sit amet fermentum.

    Maecenas sed diam eget risus varius blandit sit amet non magna. Mattis purus sit amet fermentum.

    Mattis purus sit amet fermentum. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sed diam eget risus varius blandit sit amet non magna.

    Contacts

    1600 Amphitheatre Parkway, Mountain View, CA 94043, United States
    +321 123 456 7
    info@example.com
    Facebook
    Vimeo
    Behance
    Instagram
    Xing
    SoundCloud
    HomeProfile
    © 2016 Puthranv by Casis