Thanks Sybrand,
These hints are appreciated.
-Simon Gottesman
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:n4bc5usse08oqrqnbp2at2e1p7p3e69c86_at_4ax.com...
>
> Comments embedded
>
> On Tue, 29 Jan 2002 02:21:12 GMT, "Simon Gottesman"
> <sgotte_at_prodigy-nospamplease.net> wrote:
>
> >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:
> >
> >1) 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.)
> >
> Please consult the Oracle administrators manual for your platform.
>
>
> >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?
> NO
> >Could I infer
> >from this who is making the most disk reads and CPU calls?
> NO, it will simply display the sessions with pga memory above 30000
> bytes, and nothing else
> >
> >TIA,
> >Simon Gottesman
> >
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Jan 29 2002 - 20:58:29 CST
