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!!!!!
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???
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
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
This was pending from a long time.As i am little free these days, so thought of writing it down.A little background on the issue - The RDBMS and ASM HOME had 10.2.0.3 version on AIX OS(version i don't remember).A new disk 100Gb had to be added to the ASM diskgroup.As part of initial check, the … Continue reading ORA-15042: ASM disk “N” is missing