Wednesday, November 28, 2007

Checking tempspace usage

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

Thursday, November 22, 2007

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
/

Monday, November 19, 2007

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"

Thursday, November 8, 2007

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.