Re: Couple questions: raw drives and top sessions

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 Mon Jan 28 2002 - 23:03:20 CST