Amardeep Sidhu's Tech blog

Today one of my colleague was working on a simple PL/SQL procedure. Based on some logic it was returning count(*) from all_tab_columns for few tables. It gave count incorrectly for one table out of around fifty in total. He just hard coded the table name and ran it but again it showed count as zero. Then he took the code out of procedure and wrote it in DECLARE, BEGIN, END and after running it showed the correct count. But ran as database procedure it always shows incorrectly. ...

From Eddie’s blog I got a link to 3 posts on Regular Expressions on OTN written by CD. Wonderful stuff. Check out. Part 1 Part 2 Part 3 & Thanks CD…wonderful work buddy ! Comments Comment by Tyler on 2008-02-28 07:51:45 +0530 I’ve been working with regular expressions in PL/SQL a lot lately and the one tool that’s helped me more than any other is Regex Buddy (http://www.regexbuddy.com/). Yeah, it’s not free, but it was the best $40 I’ve spent. There are free options, like regex coach and a few free online options, but the problem is you have to find one that matches the Oracle specific Posix ERE format. Regex buddy even has a drop-down for Oracle syntax (http://www.regexbuddy.com/oracle.html). I have no affiliation with this tool whatsoever, just found it to be exceptionally useful. ...

Well, it was in my mind for some time, to register my domain name and finally its here :) . I have imported all the posts from my blog on blogger. I will be checking and editing all the posts for any kind of issues with wordpress. If you see anything out of the way do let me know :) Comments Comment by Amritpal Singh on 2008-02-06 20:57:22 +0530 good work Sidhu saab, this proves JOSH haje hai baaki, so no tension, and Guru di kirpa naal chakki jao kam ...

Howard has posted a pdf on Oracle Administration on his new website. Do check out. Its awesome. Update: Howard has shutdown his website, so unfortunately this pdf is not available. Sidhu Comments Comment by Amritpal Singh on 2008-01-22 11:03:00 +0530 paaji no pdf, all the content is password protected. Comment by Sidhu on 2008-01-22 21:54:00 +0530 Due to some reasons Howard has password protected all the content 🙁 Read more at http://tinyurl.com/yvypmj ...

At my workplace we were facing a problem with refresh of a mview. Say it was created in schema of user1 but when I tried to refresh it from user2 it would give ORA-03113: end-of-file on communication channel. Then we raised a SR and have been following up with Oracle support for long but it was not getting anywhere. Yesterday that guy seemed to have reached some point. The mviews that we have created and are having problem with refresh are created on top of both local & remote objects and he said that up to 11gr2 there is no possibility of creating mviews on both local and remote objects. I did validate this thing. All the mviews failing to refresh are created on top of both local & remote objects. But again from the owner the refresh is fine but from another user it gives problem. By the way that guy hinted at bug 4084125 and also suggested a work around. I haven’t tried that yet. Will try and update about the results. ...

Last week I attended a training on AIX system administration from IBM (organized by company, obviously ;) It was a 7 days course covering all of the system administration stuff. There was a lot of new stuff to learn, LVM being the most number of times uttered word, once we did the chapter on LVM. It was a nice experience as a whole as for the first time I attended any training on Unix. ...

Eddie Awad started a new series Oracle in 3 minutes on his blog. In the first post he has discussed about multi-versioning. Its a must watch for everyone who is working on Oracle. Hoping to get more of such stuff from Eddie. Sidhu Comments Comment by Amritpal Singh on 2008-01-22 11:05:00 +0530 nice man, keep posting all the good work. Comment by Sidhu on 2008-01-22 21:55:00 +0530 Thanks man 🙂 Sidhu

Howard Rogers has done a post on his blog that is the site Dizwell worth it ? Do post your opinion. If he plans to close it down, we will miss a great resource for Oracle. Sidhu Comments Comment by Aman Sharma on 2007-10-23 09:20:00 +0530 Fingers crossed that he wont do that and thats the voice of all(almost) too!Hope he takes the right decision. Cheers, Aman….

Tom Kyte did a post on his blog about posting of reviews of questions on Asktom. In a nutshell the reviews not related to the original question will be ignored/deleted (not decided yet, as Tom said). As other people said in the comments, personally I too like this idea very much. Earlier, many times, there were questions which started with someone asking about appropriate SGA size, then there were some other twists and discussions and then the thread ended in discussion about good or bad authors or something similar light years away from the original topic. ...

Today I was checking Eddie Awad’s blog. From there I came to know that Oracle has started Official Oracle Wiki hosted by Wetpaint. Check out. I just made my login. Hoping to contribute whatever little I can Sidhu Comments Comment by Frank on 2007-11-09 03:10:00 +0530 Another GREAT wiki to contribute to is http://www.orafaq.com/wiki Comment by Sidhu on 2007-11-15 07:48:00 +0530 Yea Frank Indeed this website orafaq.com is a good one. Pretty good articles and content. ...