Aman's Blog....

Words have so much power. Some times some things which are not otherwise expressible are so easily expressed by just few words. All the feelings, happiness, sadness, love,betrayal , everything is explained by them. Those who give shape to feelings through their words are the most amazing people. But words alone some times don't say it all.  They need a voice to be their companion and express that pain which is hidden in those words. Anyone can sing but not anyone can express that feeling of a broken heart, feelings of some one who have lost his/her everything for the sake of his/her love and still have got only tears in return. That melodious voice, that soulful voice comes to some chosen few. Sabar Koti is among those very few Punjabi singers who has made his mark with his soulful singing. If there is a soulful song, a song that has to represent pain, tears, Sabar Koti makes the lyrics come alive with his so intense and deep voice. I am listening to his songs from ...

I am not in my senses I guess at the moment. I have not posted anything since past few days even though I am at home too. I don't know why it is there but I am not feeling good. A deep feeling of pain is there but I don't know for what? I am trying to read as much as I can my Oracle books to keep myself busy. But somehow I am not able to concentrate over them much too. May be I need a little fresh air and a little change. I shall try to get that as soon as possible.

Yes and if you ask me, it was some thing for which I was waiting from a long long time. I am so glad that finally now official All India Oracle User Group  has been established. And its also a part of  Asia Pacific Oracle User Group . I wish them all the very best with my best wishes and I hope they would benefit all the Oracle users in India a lot. Membership is on so if you are a dba, developer or even a student of Oracle , get yourself registered and make this a success. The membership at the moment is free but it will be having a membership fee later on but that's very reasonable. Did I register myself? I don't think you should ask that :-).

Well after the first date, things should become more smooth. At least all the misunderstandings should be clear right? I am afraid I am not able to say the same for this 11g database. I did install it quite without any pain and also worked over it for about 15 minutes. Said it bye in a nice manner with a hope in the heart that the next time, I shall be greeted by it with a smile. But I guess that's not happening. All of a sudden Enterprise Manager is now not working. Despite installing the database again, the problem is still there. I am at the moment buried under the log files of EM. Hope I shall get some thing out of it. At the moment, 11g is behaving very naughty. Well so am I  so lets see who wins :-).And one last note, I don't like losing ;-)!

Yup I just installed Oracle database 11g. I did install it once before too but that was some thing which was done with more haste so lets not count it. This time its done with little more patience so we will call this as the first encounter or meeting with 11g. Hmm so my thoughts about it right? Well I have done the installation on a window xp box with C2D processor and 2gig of RAM so it got installed without any ooh-aah-ouch. Yeah couple of things have changed in the installation for example, it needs a new listener which is a mandatory component of installation. The Enterprise Manager gets installed with secure, HTTPS port. The database installation with Database Configuration Assistant(DBCA) has also got couple of changes. Now DBCA just installs the database with a combined setting for both SGA, PGA. The option is still there for individual settings but I guess that wont be recommended. Also there are some typical security settings and automatic maintenance task settings which are...

Sql statement tuning is the hardest tuning I guess. Its having so many things to look after, the query itself, question which is asked for which the query is written, missing indexes , bad execution plan and the list goes on and on and on. So how can you be some what good in solving this impossible looking puzzle of statement tuning? Greg Rahn  has posted a very good post for troubleshooting bad execution plans.  Its a must read in my opinion as execution plan is like the x-ray report of your statement's flow and by tuning how is your statement is going through, you can get the maximum performance! Have a read, its an excellent post!

Blog is some thing which is about your self and what you feel about anything. And it is so much good to have as much readership as one can get for his/her blog. And this means that more and more people/sites/blog must spread what one writes. But does this mean that people are allowed to give their names to your work and take away that credit which is meant for you? Your work may inspire some one to do some thing better for his/her own work but this doesn't mean that he/she should not give you the credit for the original thought process. At least an attribution to the original source of the content is must if not anything else. Now the issue is that if you are running your blog by yourself , means hosting it own on your own than you have full control as you are the owner of that domain under which your work is hosted. But how about free hostings like Blogger, Typepad, Wordpress? What about them? What kind of control one can have over these free blogging sites? Though they are ...

I wish all of you marry Xmas! May god bless you with you his choicest blessings! Have great fun with your near and dear ones and enjoy the holidays. I also have got holidays this time till 2nd week of January 2008 as there are no assignments I am having at the moment. So it means no travel, no tension about the programs. Well actually its fun so there is no big deal in all this too but still I have some time in my hand which I am planning to spend productively. Hopefully I shall be able to do what I have planned for these 2 weeks. Lets see.

A few months back, one of my closest friends, Amandeep and Raman become one from two to start a new beginning  when they got engaged. Today was the day when they have finally tied the knot and got married. It was such a nice feeling to see some one so close getting married. It just feels like that was  yesterday when me and Amandeep met for the first time about 8 some years back when we joined in the same high school class. Amandeep was so much talkative and the first thought that came to my mind that how much this boy talks! I never knew at that time that this talkative boy only will become one of my closest pals, some one who is really close to me like a brother only, always there to give me his advice, support in what ever I need. And that young boy today became a man. Its an amazingly nice and satisfying feeling that my friend is going to start his new life and has also got such a good partner to share with him this journey of life. This is the picture...

I got this today in my mail. Needless to mention it made me smile. Now how much it is true, I don't know the second half. Yes for the first half, it is indeed. As I found it good to have a smile so sharing it with you all here. The last point is the final kick. Have a read: What guys do at ATM: 1. Pull up to ATM 2. Insert Card 3. Enter PIN 4. Take cash, card and receipt 5. Drive away What gals do at ATM: 1. Pull up to ATM 2. Back up and pull forward to get closer 3. Shut off engine 4. Put keys in purse 5. Get out of car because you're too far from machine 6. Hunt for card in purse 7. Insert card 8. Hunt in purse for grocery receipt with PIN written on it 9. Enter PIN 10. Study instructions 11. Hit "CANCEL" 12. Re-enter correct PIN 13. Check balance 14. Look for envelope 15. Look in purse for pen 16. Make out deposit slip 17. Endorse checks 18. Make deposit 19. Study instructions 20. Make cash withdrawal 21. Get in car 22. Check makeup 23. Look for keys 24. Start ...

Yes I got back last night. It was a tiring and little bit odd tour. I managed to finish it with a good note but it has left me a little tired and sick, I can manage being tired but I hate being sick. I have some days with me ( well 3 to be precise ) to have some rest and get myself back on the track. Lets see how will it happen? There were a lot of new things happened in this trip. The starting of it was the first among them. I normally travel in the day time to catch a flight to my destination. Its tiring but still I manage to get a good sleep at home so its kind of okay. This time it was not the case. Well the first reason was that this time I was not catching a flight but was catching a train. I haven't traveled too much by trains. The last time and the only time which I can recall that I traveled by a train was when I went to Calcutta. I had to go to Malaysia for the first time and  there were a lot of problems that I faced for that. In the series of problems , I we...

Yes I shall be leaving tonight for a small program. Well as it is said all big things come in small packages so this small program is for the same module which I have just done. So its not actually that small too. The problematic part is that I shall not be going by flight this time. To my bad luck, there is no flight to where I am  going this time, at least not a direct one. There is a flight to another city and from there, one has to either take a bus/train or hire a cab.  Still not so bad but I guess its not that which is easy will happen with me. So for me, there is no flight which is going to that other city also. So it means I have to catch a train now and the not-so-good thing is that the train also doesn't leave from my place. So I have to go to Delhi in the night and than from there , early in the morning, I have to catch the train. Now as I am not so habitual to use trains so lets see how things will go plus the city where I am going is not so pleasant one so in tot...

I don't know why but I am feeling so much sad. I have no clue why it is so? May be its some things that happened in the past and/or some things which are happening now or may be its nothing but just my  upset and wandering mind which is not sitting stable. I don't really know. Its feels at times that a guy is lost some where in a completely unknown place and despite trying so hard to find him, its not working out. I just hope that guy will be found some what soon. May be this sadness will go away at that time.

Yes I got back today morning from a chilly and tough program. It is so chilly at this time at my place and the fun is that where I came from , there was no sign even of cold. Though I was prepared to experience this cold and chilly weather but imagine you are traveling in a bus at 2am in a temperature of 10 degree. Not so much enjoyable right? Well my program went well and that's the most important thing for me. We ended with a good note and smile was there on everyone's face. That's what I need and want all the time so can say that I am a little relieved. As usual, I started from my home one day prior to the program in bus. Well this time , I started rather very early from the usual time of mine as my flight was at 5pm and I had to start at about 7am to meet the timing. I got at the airport without any news-making incident and in one piece :). It was as usual so packed but the best thing happened was that the flight was on time which is a real relief at the moment coz of...

Yes I shall be leaving tomorrow. This time its just not the program which will be tough but the travel will also start from a rough edge as I have not received my tickets yet which I am promised to get by tomorrow via the message. And I have to take the print over the airport only. Not some thing which sounds interesting. And to make things worse, its one of those programs which is among the toughest ones and also the audience which is coming is the tough one. I am not really sure what will happen. All I can hope is that every thing goes fine. Pray for me guys, I really need your wishes.

I watched Om Shanti Om  today with my sister Gunjan. My friend Gaurav gave me DVD of this so I thought I shall change my mood with watching it. Well there is nothing much about the review of this movie. I am not sure what to say about it. If you ask me how is the movie, I shall say its a typical Bollywoord movie with lots of things happening, dance, action , a little bit of romance, a small fight, for sure a hero, heroine and a villain and for a change( if we can say it a change though) , a reincarnation story too. On the whole , a just-for-time-pass movie. I am not very happy with watching it. As the entire story( with the modification done by Farah Khan, the director) is picked up from the classic movie, Karz  which starred Rishi Kapoor and is a milestone in the incarnation movies. There is nothing that I could find out which will make me watch it again. Yeah I may watch it if I wont be doing anything. About the music, music score is by Vishal-Shekhar. Songs are nice. My f...

Yes I got back today. It was a real pain to complete 3 different topics out of which alone if of either of 3 or 2 days in just 3 days. But the guys were good. All so much nice and intelligent! It was good to see that all of them were happy when we finished the program. It was their kindness that they used very nice words for me when we were closing the program. I got some couple of good questions that I need to answer and get back to them. I hope I shall get the answers soon. But the tour is not over yet,I shall be leaving tomorrow again. At the moment, I am going to listen some music. So see you later guys!

Yes I am leaving tomorrow. The program and the audience both will be tough this time and to make things worst, I myself am so much upset and pist off which is not good at all. I just hope that every thing goes fine. Wish me luck and pray for me guys. I really need it with me!

Once again I am so much hurt today and again from some one who is very close to me. Once again its that person only for whom I did so much, meant him like a brother, that person only did hurt me so much today. May be its just my fault. May be its just me who expect more than I should from some one. Its ok. I shall try to remember this.Hope I shall.

It is said that love is happiness and to be in love is getting the best gift ever. Yes it is in real too. Love is the greatest miracle that can happen to some one in his/her life. There are so many who long for it for their entire life but still don't get it. They try it to find it so much but they are not able to and its true too that they wont be too as love is not some thing that one can search anywhere. If it has to come to you, it will find you. And when that happens, it seems that there is no need to seek for heaven coz heaven is right there in the arms of your love. There is no need to seek for happiness as the entire world's happiness lies in those two eyes and in that smile which comes on the face of your love. There is nothing more beautiful than falling in love. Yes love is indeed the most beautiful thing that can happen to one in his/ her life. But happiness never comes without tears, roses are never without thorns. In ...

Yup I went for shopping today, after a long time I guess. Its always fun to shop and if you are like me who wants nothing but the best in what ever budget he has, than it becomes a mission sort of ;-).Well this time it was not for me. One of my good friend's birthday is on this 7th( I shall miss it as I wont be around that time) so I wanted to buy some thing for him. I thought couple of things like jacket as its winter time, some accessory sort of thing but than taking consideration about his looks, work, I changed my mind and thought that will buy him a nice casual shirt. I don't know how well my choice is of things and it happens some times that people may not like what you buy or may be what you bought would be a tiny thing and may get lost too so I thought that a shirt would be nice, wont be easily lost( how one would lose some thing that he is wearing ;-)) too so I went for it. Well I did spend a lot of time, ate head of sales guys too much and finally bought one. I...

Yup I got back and yes happily which I thought wont happen this time, thanks to all the problems, issues that did come up all this while in the entire tour. It was a long and relatively tough tour. Since the very first day of its starting, the ride was a little bumpy  but thanks to the wishes of all who wished me luck, I was able to manage the program well and make it come to an end with a smile on everyone's face which the only thing that I feel must be there as a result of the program. So as I said , since the very first day only the ride wasn't so cool and easy. I started as like always from my home in the bus. As I was not going to catch any flights for the first program and it was happening in Gurgaon only so I thought I shall be at the guest house a little early and will catch some time to sleep and study, not knowing that it wont happen. Well I did catch the bus on time so I thought everything will be fine only. Every thing was fine too till half an hour since the star...

Yes I am leaving tomorrow. I am really so much tense this time. I just hope that every thing goes fine. Wish me luck and pray for me guys! Really need it!

Yes I got back late night yesterday and I shall be leaving tomorrow again. This time, it was a mixture of issues that happened, thankfully nothing happened in my program but there were other issues that did arise. Thanks to all of your wishes, my program went well. It was a very packed module this time as we finished the curriculum of 5 days in 3 days. So you can expect that what would be the pace that I had to pick up and how much the audience was grilled by me ;-)? But that was the need of the time and I couldn't help it. Even we went really fast and packed, I got some very nice comments on the last day of the program about me. For the first time I heard that the audience submitted the feedback forms which are online at our premises on the very first day of the program. According to them, they judge the person on the first day and that impression doesn't change. They did like the program and that's what is the best thing for me. Now coming on issues. In my class progra...

Yes I shall be leaving tomorrow. I am not having a good feeling from inside. I don't know why? And on the top of everything, I am not in a good mood too. Hope everything goes fine. Lets see what happens? Pray for me guys!

Saawariya  was among the most awaited movies in this year for Indian movie industry. I happened to see this movie with my sister in cinema. Yup you heard it right, I went to a movie hall.Infact after about almost 10 years.  I vowed that when ever I shall go to movie, I shall go with some one else but that wont happen I guess and my sister was keen to watch this movie so I joined her and went. So how is the movie? Well its kind of ironic but my last couple of posts were about pains of love and how one feels when left by his/her love and this movie was no different as gal leaves the boy in the end.Snajay Leela Bhansali picked up two newcomers, Ranbir Kapoor and Sonam Kapoor and have tried to portray a story of 4 nights when the guy meets the gal. To be really true about the movie, its not like a movie, its like you are watching a play. Like in the play, on the same set, everything is happening, people come and go, different scenes of different moods are on the s...

Yes I am just listening from last 2 hours Shail's Hiriye Soniye  about which I wrote also here.  When you will see the video, you will see that the guy never cares about the gal. Its his wish when he will talk to her, meet her. Even when its his own birthday and the gal waits for him for 3 hours, for him its a wastage. Her love, care, emotions all seem to be a botheration for him. In the last moments of the video, gal is in tears and says few lines to the guy which are some thing like this, "coz I love you so much that's why you do this to me. You see the day when I shall leave you forever and go, you will cry so much and look for me but I wont come back.". I am just listening these lines with the song. How much pain she is feeling at that moment can't be described in words. Don't know why people hurt those only who love them so much? A heart touching song as I said before too and a must watch video too. Even if you wont understand the language, if yo...

Some times when you get hurt physically, the wounds hurt you for a very long time. Their pain never lets you sit calmly and with every moment, you feel a very strong pain at that place. Some time, these wounds heal fastly but there are time when it takes a long time for them to heal. With that, the pain does go away but some time when you sit and just think (and some times even when you don't do it yourself), those moments of pain, that time of injury shivers you and you feel the same pain, even if its years since the last time when it happened to you. Though the wound has been healed but still you feel the pain just like it was yesterday when it started. Wounds on the body are still able to heal mostly. But there are some wounds which are never seen and there are some pains which have no sound. These wounds are not caused by any physical accidents but they are given by those people whom one takes as his life. These wounds don't come over the body and bleed like the normal on...

I wish to you all a very happy and prosperous Diwali. For those who don't know much about this one of the biggest festivals of India, you can read about it here.  Enjoy this day of joy with your friends, family and dear ones with lots of sweets and crackers. Heartiest wishes from me to all of you!

Yes I am back today morning. It was a good and some what a bit relaxed tour. Well as like always, what matters to me the most is the program must go well and the audience must be happy and contended.  I guess I got that so yes I am happy! As like always, I left from my home to catch my flight which was supposed to fly at 8pm from Delhi domestic airport. Without much of the trouble, I got Delhi at about 4pm by bus and in next one hour,means at 5pm I was at airport. Well there wasn't much rush at that time on the airport so I thought that it would be easy for the first time to complete all the check in details and everything. Well to some extent, it was right too. But all the happiness and smile flew away of mine when I came to know at the check in counter that flight is half an hour late and that too is just the estimation.  There is still no clear information that how much more it can be delayed but it will be that is for sure. Great! Well I had no other choice but to wait a...

Yes that time has come again. I shall be leaving tomorrow for a program which is already going on a very fast pace for different modules by some another persons. Lets see how things will go? Wish me luck and pray for me guys!

If you are working with Oracle than redo log files have a huge impact on the performance of the database. Its some times a huge pain how to attain an optimal size for the redo log files and the corresponding checkpointing and archiving frequency. One option is to find the redo generation rate of your database which is not so-easy option as it will keep on varying.  Second will be the sizing of the redo log files again which becomes a pain coz there is no rule of thumb( well 20minutes as per oracle) given for it. There is one parameter called Archive_lag_target which is described here in oracle docs.  This is given mainly for the dataguard configurations but Howard Rodgers has given a very good explanation for using it on standalone databases too on oracle forums.  It was a good learning to know about it. Here are some links of discussion if you are interested. How often should a database archive its logs Redo log switch Redo log size increase and performance Learning...

Some times, some wordings depict a true story. Those wordings touch you so deep inside that you can actually relate yourself to them. And if the matter is of love, if the matter is of broken hearts than that relation becomes more strong. Last whole night sitting on my pc , I was listening to this song sung by Romey Gill, Tutt Gaye Yarane . I don't like mostly the songs sung by him but this song and most importantly its lyrics are so fabulous that they kept me hooked all night. I shall explain the meaning of the song in English as the original song is in Punjabi. Listen the song and I am sure, even if you don't understand Punjabi, you will be able to feel the pain through the words of this song. Have a read: Lutt ke mohbbatan nu kiti hear feri ve, Tutt gaye yarane, jind fikran ne gheri ve! Hanjuan de saagran vich jindagi di beri hai, Dise na kinara koi maut aap hi saheri hai! Chhadd gaye mallah kiti minnat batheri hai, Tutt gaye yarane jind fikran ne gheri ve! Sar gayi...