tag:blogger.com,1999:blog-3647965877069534489.post78695709681768155..comments2017-11-15T22:41:16.725-08:00Comments on Merav Kedem's Blog: Beyond database tuningMerav Kedem's Bloghttp://www.blogger.com/profile/04962151891192655993noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3647965877069534489.post-70603467627067037312011-05-20T10:21:50.101-07:002011-05-20T10:21:50.101-07:00This is so true and I have seen this many times wo...This is so true and I have seen this many times working as an application DBA. Usually you get involved at test or UAT stage, when the data structures are built and the code is written, often far too late. I helped reduce running times on batch processes to reduce an end of week batch run from 60 hours to under 24 hours, just by using tkprof to identify slow code and then working with the application developers (in a systems house) to improve performance.<br /><br />You can also look at the block level of the table to incrase the initrans parameter to be greater than 1 when building the table so you can have more than one lock per database block.lloydscornerhttps://www.blogger.com/profile/08407962897295707287noreply@blogger.comtag:blogger.com,1999:blog-3647965877069534489.post-71035943611570964222011-05-07T07:23:21.533-07:002011-05-07T07:23:21.533-07:00Well said! Thanks for sharing this story with us.Well said! Thanks for sharing this story with us.Rotemhttps://www.blogger.com/profile/13626036676502634730noreply@blogger.comtag:blogger.com,1999:blog-3647965877069534489.post-9255328604291572892011-05-05T21:42:11.444-07:002011-05-05T21:42:11.444-07:00Thats very true !! Every DBA should work with apli...Thats very true !! Every DBA should work with aplication team. Because in a way their SQLs/code are affecting your database performance only.This is how you will expand your knowledge not only technically , functionally also. You will get to know that how application and that domain works.<br /><br />"Never stop learning "Mayankhttps://www.blogger.com/profile/15373309135088776776noreply@blogger.com