Santosh Kangane

It was a great pleasure to present something in Cost based Oracle . Great thanks to Jonathan Lewis for his book Cost Based Oracle: Fundamentals . I would recommend everyone to read this book at least once to get the exact depth and breadth of CBO. It’s amazing…  Cost Based Oracle by  Santosh Kangane

Recently, I was working on an Archival process for one of my client, where this process suppose to move data from Live OLTP system to Archived database. This process is going little slow, so one of my DBA has advice me following approach, In delete part instead of using single delete statement with Join, open cursor and loop it through. Then fir delete statement for each row by row in a loop. I was wondering how oracle would go about it ? and will it improve the things? So, h ere is my small investigation on this ,      1.    If you have db_file_multiblock_read_count = 8 and Tablespace Block size = 8KB . So, in single IO            read request oracle would read 64KB of data.      2. If you fir a delete statements in a loop , oracle will have to instantiate IO request for each delete statement           and out of that it will pick up just one row or few rows if there is one to m...

Hi Friends, Recently for one of the functionality in my app, I was working on the bulk data operation. To handle the bulk data movement with DML exception handling Oracle Provides us two inherent functionality,             1.        Save Exceptions : http://rwijk.blogspot.com/2007/11/save-exceptions.html             2.        DML Error Logs : http://www.orafaq.com/node/76 So, I was evaluating on both the approaches, here is what I have came up to so far, Performance for Save Exceptions Vs DML Error Logs, a.        Save exception works better for the large data volume over DML Error logs. -           You can keep better control on the number of rows been process in particular iteration by configuring Bulk collect row count limit...

Few days back, I had seen some magical behavior of oracle sequences. We got a complaint from users about missing on some data. When we check database and SQLs, logically it must have traveled in data files. After analyzing the data download plug-ins, file status screen we found that, 17 files have the same name around time frame of 1658Hrs to 1735Hrs. We are using the Oracle Sequence Number to allocate the file name uniquely, and then also why file names are duplicate?? What's wrong there??  -- After 1636hrs oracle started allocating the sequence number with lesser value than the current one and continued till 1740Hrs.    -- The file allocation logic was looking for max file ID value.  -- Which coming out to be same for this entire time frame; as new file ID has lesser value than the old file ID. How this happ...

SOAP Message in WCF: 1.        The max size of SOAP message in WCF is 9,223,372,036,854,775,807 bytes. Including metadata. 2.        For actual user data we can use 2,147,483,647 bytes out of it. 3.        With default setting WCF uses only 65536 bytes. 4.        We can change it by setting maxReceivedMessageSize in clients app.config file.    5.        So selection of data types in Data Contract and Data table will matter a lot! 6.       Reference :   http://blogs.msdn.com/drnick/archive/2006/03/16/552628.aspx          http://blogs.msdn.com/drnick/archive/2006/03/10/547568.aspx       “Amazing blog for WCF!” Data Contract: 1.        By Default WCF can serialize 65536 DataMember. 2.     ...