Toyota Vios 1.5 A, very fuel economy car. Nice ones

Checking tempspace usage

SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free)
FROM V$temp_space_header
GROUP BY tablespace_name
/

Find the highest max open cursors

select max(a.value) as highest_open_cur, p.value as max_open_cur
from v$sesstat a, v$statname b, v$parameter p
where a.statistic# = b.statistic#
and b.name = 'opened cursors current'
and p.name= 'open_cursors'
group by p.value
/

Work related matters

Surprisingly, human at work in this century, living in the fast pace city always demand. Demanding non stop.

If you are in a service industry or an end user environment, your user, colleagues, line managers, supervisor or sometimes sub ordinate (very rare though) could demand things from you. Things that you have done before after a certain time. They could demand again. Just to fill their satisfaction.

And you know, one way of meeting this just to do whatever they ask, satisfy them, "just do it". Of course must always set a boundary as to where to stop.

Try it.
"Just Do It"

Good Oracle Resource for DBAs

http://www.scribd.com/doc/90257

Banking Shares

Source: www.marketwatch.com

Below are extracted from marketwatch website for reference.

Washington Mutual (WM) Mortgage company in bad environment. Down to $19.72 from 52-week high of $46.38.

Capital One Financial (COF) Big financial loss. Down to $50.05 from 52-week high of $83.84.

Fannie Mae (FNM) Mortgages and NY State investigation. Drops to $48.74 from 52-week high of $70.57.

Veraz Networks (VRAZ) Big quarterly loss and downgrade. Falls to $3.65 from 52-week high of $8.33.

Nastech Pharmaceutical (NSTK) Joint venture with Procter & Gamble (PG) falls apart. Down to $8.50 from 52-week high of $19.98.

Starbucks (SBUX) Coffee does not like recessions. Drops to $24.10 from 52-week high of $40.01.

Morgan Stanley (MS) Worries about write-offs. Down to $50.08 from 52-week of $90.95.

Merrill Lynch (MER) No CEO. Drops to $53.64 from 52-week high of $98.68.

Citicorp (C) No CEO and worries about more big write-offs. Falls to $33.38 from 52-week high of $57.

Bear Stearns (BSC) Wall St. wants CEO to leave. Worries about mortage-backed assets. Falls to $96.11 from 52-week high of $172.61.

London China Town

London Here I come

Welcome to London. Tower Bridge.

London Trip (19/8-24/8)

Three valuable Life Experiences

The other day I was reading "My paper' (http://mypaper.sg) and found the article published very interesting and very information and would like to share with you out there. I noticed that it fits into my life very well and if I have known it or whatsoever some of my bad experiences in life might be able to avoid.

1. Never take short cut/route
There's no easy way for life and money. Do not attempt to de tour that usually sounds tempting

2. Do not be curious with things that are bad
Never in your life try to be curious with things that are not bad. Do not attempt to try it as it will ruin your life

3. Always stay calm before you act
Do not act when you are highly unsteady with you mind/emotional

Retrieve X number of days ago data up a particular day

Assuming you need to retrieve 35 days ago of records since last Sunday.

====================================================
DECLARE @day INT
DECLARE @reqdate INT
DECLARE @status int
DECLARE @today SMALLDATETIME


--This SQL is to retrieve 35 days ago data from the last Sunday of the current date.
--Replace 35 with the X no of days that you wish to retrieve

SET @today = CAST(CONVERT(VARCHAR(10), GETDATE(), 101) AS SMALLDATETIME)
SET @day = DATEPART(dw, @today)
set @reqdate = (select DATEPART(dw, getdate()))
set @status = CASE
when @reqdate=1 then '0'
WHEN @reqdate=2 then '1'
WHEN @reqdate=3 then '2'
WHEN @reqdate=4 then '3'
WHEN @reqdate=5 then '4'
WHEN @reqdate=6 then '5'
WHEN @reqdate=7 then '6'
END

select col1, col2, col3, etc...
FROM tableABC
where (submit_date between dateadd(dd, datediff(dd,35, getdate()-@status),0) and getdate()-@status )
ORDER BY 1

HOW TO REMOVE ARCHIVE LOGS ENTRIES FROM V$ARCHIVED_LOG

The archived redo log records are determined by "MAXLOGHISTORY", then when it reach
es the max value it begins to overwrite entries starting from the beginning.

Only way to clean it is by recreate the controlfile

Back from Vietnam Trip

A nice trip back from Saigon, Vietnam. Spent 3 days 2 nights there.

It's a wonderful experience. Things are reasonable priced and cheap. You can get good bargains in the market.

Breakfast on Sunday was a chicken tuna sandwich in the airport.

Evening back to Spore. Wasn't feeling good. Got indigestion. Went to see doc. The relief doc was crappy.