Mar 4, 2012

Values with % symbol converted to Percentage when exported to Excel using Toad

 

I noticed when you export data to Excel using Toad and if you have column with % symbol at the start of the value , it becomes a  Percentage when exported.

image

 

image

 

image

 

How avoid this

This can be avoided by clicking the “Treat string fields as strings”  check box during export.

image

 

image

Feb 29, 2012

How associate Unix Process to Oracle Session

 

This post explains how relate the Unix Process Id to Oracle Session. This is very useful when identifying a oracle session using high CPU and Memory. 

It’s very easy please follow the below steps,

1. use prstat  command to see the Unix processes.

prstat –a

(on HP-UX you can use top command alternate to prstat)

2. Get the Process id  and login to the database as a DBA user and use the below query. instead sample value use the PID value.

select  sid, s.username oracle_user, p.username os_user, s.terminal, s.machine, s.program,logon_time from v$process p, v$session s
where spid = 16473
and addr = paddr
order by logon_time desc

Jan 29, 2012

The Big 4

 

There are big 4’s  existing in every industry but music it is well known from the Big 4 in Trash Metal (Anthrax, Slayer, Metallica, Megadeath)  , Big 4 in Grunge  etc.

Although the Big 4 in Trash Metal are my favorites but the big 4 I’m discussing is the Four Noble Truths described by the Buddha.

This is the most important  central teaching by the Buddha. The Four Noble Truths are,

1. Life is suffering

2. Suffering occurs due to attachment or craving 

3. Cessation of suffering is ending attachment or craving (due to ignorance)

4. The path to Cessation of suffering is noble eightfold path

The way I understand and experience the Four Noble Truths are , you feel unsatisfied with life , when you loose what you have or if you don’t have what other people have or if you are away from your family and friends.  This un satisfied feeling is caused because you crave (attached) to them. 

As the everything in the universe is impermanent and constantly changing  your life will experience this unsatisfied feeling very often.  Although it does not mean the life is does not have value.. it does.  This is the nature of the universe and all beings go through this.

The 1 & 2  will make the beings go in a never-ending cycle of  rebirth , which means more suffering.

Until Buddha discovered the 3 and 4.   By eliminating the craving/attachment the beings are able to get out the cycle of rebirth and end suffering.

For this Buddha suggested Noble Eightfold path  which I like to call the Big 8..  (in the next blog post)

image

Jan 28, 2012

Walk the Line–Hello I’m Johnny Cash

 

x 001

I'm wondering why it took me 7 years to watch this movie. This just open me up to whole new world , the world of Johnny Cash.

I saw the parody movie Ward Hard based on this movie so many times on Cable and recently found the special edition DVD at the shop.

Although the movie was quite long, I enjoyed every bit of it. I love how Joaquin Phoenix & Reese Witherspoon played and sang like Johnny Cash and June Carter. My personal feeling is they both should have won the Oscar for this movie, although only Reese one it.

The music selected for the movie was very good and it was a true portrayal of that era. 

This movie open me unto to the music of Johnny Cash , which I became Fan immediately and started looking for his Vinyl. Discovered all his wonderful studio albums and also great Live albums like “At Folsom Prison” and “Live and San Quentin”

220px-Johnny_Cash_At_Folsom_Prison

Johnny cash is a real Rock Icon.. and great human being.

Oct 23, 2011

Few thoughts on Food

Have you ever thought of this?

1.  Majority of people don’t even have one meal day while others  divide the one meal into several parts (entree, appetizer, main course , dessert etc.)

2. Majority of people only have one meal a day while others are not satisfied with  three meals they created other in-between meals (brunch)

3. Majority of people don’t have a choice and have to eat what ever is available while others have luxury of choosing  to skip meals or eat only type of food they like

4. Majority of people eat of garbage while others  throw up the food they just ate

5. There are countries where majority of people are starving while other countries over produce and throw away the food to the ocean to keep the food prices up

fat-boys-sm

Oct 19, 2011

Piece of My Heart ….Remembering Janis Joplin

 

(Come on…)
Didn't I make you feel like you were the only man, well yeah,
An' didn't I give you nearly everything that a woman possibly can ?
Honey, you know I did!
And each time I tell myself that I, well I think I've had enough,
But I'm gonna show you, baby, that a woman can be tough.
I want you to come on, come on, come on, come on and take it,
Take another little piece of my heart now, baby, (break a..)
Break another little bit of my heart now, darling, yeah. (have a..)
Hey! Have another little piece of my heart now, baby, yeah.
You know you got it if it makes you feel good,
Oh yes indeed.
You're out on the streets looking good, and baby,
Deep down in your heart I guess you know that it ain't right,
Never never never never never never never hear me when I cry at night.
Baby, I cry all the time!
And each time I tell myself that I, well I can't stand the pain,
But when you hold me in your arms, I'll sing it once again.
I'll say come on, come on, come on, come on, yeah take it!
Take another little piece of my heart now, baby. (break a..)
Break another little bit of my heart now, darling, yeah, (come on…)
Have another little piece of my heart now, baby, yeah.
Well, You know you got it, child, if it makes you feel good
Guitar
I need you to come on, come on, come on, come on and take it,
Take another little piece of my heart now, baby. (break a…)
Break another little bit of my heart, darling, yeah. (have a)
Have another little piece of my heart now, baby,
You know you got it (waaaaahhh)
Take a…Take another little piece of my heart now, baby. (break a…)
Break another little bit of my heart, and darling, yeah yeah (have a)
Have another little piece of my heart now, baby,
You know you got it, child, if it makes you feel good

 

Oct 13, 2011

SuperHeavy Album launch during Super Heavy Rain

Recently there was a Album launch event was held  at Top Shelf @ Fully Booked , Bonifacio High Street , Taguig City for the album  SuperHeavy from the super group  SuperHeavy.

imagesCAY9PMA0

This super group is made of  Mick Jagger ,Dave Stewart , Joss Stone, Damien Marley , A R Rahman , which brings a wide variety of genres ,generations, styles of music and cultures together.

superheavy 011

I was privileged to attend this event as I was able to meet the Father of Pinoy Rock Joey "Pepe" Smith , who was a special guest at the event.

x 003superheavy 025x 001

See the event photos here.  A big thanks to  event organizers by MCA Music Philippines. 

SuperHeavy is available at the record stores now.