Merry Christmas and a Happy New Year!!!!!

I have spent 15yrs of my life, my childhood in one of the smallest states in India, Meghalaya.Shillong is the capital of Meghalaya,and is situated at an average altitude of 4,908 feet (1,496 m) above sea level, with the highest point being Lum Shyllong at 6,447 feet (1,965 m).As Christianity is the dominant religion, the … Continue reading Merry Christmas and a Happy New Year!!!!!

Advertisement

Oracle Table’s Initrans — Am i missing something???

Since this morning i am confused with the initrans values of the table on a 10.2.0.4 version, for which i am writing this blog expecting some help in understanding it 🙂 Well, what is initrans??? i couldn't find anything much simpler than this (By Tim Hall) -- Let's say you have a block that has … Continue reading Oracle Table’s Initrans — Am i missing something???

“local write wait” event

Today one of the Linux server reported high CPU% utilization and then it was time to work on it.The server showed 96-99% CPU utilization and 5 PIDs eating the maximum, so it was time to login to the database (10.2.0.5 version) and start checking whats going on. 00:40:26 SQL> select nvl(s.username, '(oracle)') AS username,s.sid,s.serial#,p.spid,sw.event,sw.wait_time,sw.seconds_in_wait,sw.state from … Continue reading “local write wait” event

Moving datafile from one diskgroup to another in ASM – 10.2.0.4

Most of you would already be knowing the various methods of moving the datafiles from one diskgroup to another.From Oracle ASM 11g we have 'cp' command in asmcmd utility which makes things much easier.As this is more kind of a note i prepared for myself,lets get started. The only way to copy files to or … Continue reading Moving datafile from one diskgroup to another in ASM – 10.2.0.4