SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free)
FROM V$temp_space_header
GROUP BY tablespace_name
/
Wednesday, November 28, 2007
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
/
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"
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"
Friday, November 9, 2007
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.
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.
Subscribe to:
Posts (Atom)