Couple questions: raw drives and top sessions

From: Simon Gottesman <sgotte_at_prodigy-nospamplease.net>
Date: Tue, 29 Jan 2002 02:21:12 GMT
Message-ID: <sGn58.25107$fD6.2383159333@newssvr17.news.prodigy.com>

Hello,
I have a couple questions that have been building up for some time. If you can answer them, I'd very much appreciate it:

Do you know of any online resources where I can find info. concerning Oracle administration on raw devices? In particular, how to create the raw drives and move files on/off them? (Will cp, rm, etc. still work, or must I use Oracle-supplied utilities like ocopy? Where does the "dd "cmd. fit in? etc.)

2)How can I find the top sessions using my instance *without* resorting to Enterprise Manager or statspack? I found this looking around in this ng's archive:
select username, terminal, name, value
from v$statname n,
v$session s,
v$sesstat t
where s.sid=t.sid

and n.statistic# = t.statistic#
and s.type = 'USER'
and s.username is not NULL
and n.name = 'session pga memory'
and t.value > &use_at_least_30000;

Will this display the sessions hogging up the most resources? Could I infer from this who is making the most disk reads and CPU calls?

TIA,
Simon Gottesman Received on Mon Jan 28 2002 - 20:21:12 CST