Re: How can I find out who is connected to an isntance?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

stanb_at_panix.com (Stan Brown) wrote in
news:9vl2lh$m02$1_at_panix1.panix.com:

> I have something starnge (where starnge is deined as something I
> don not understand) going on with a 7.3.4.5 instance.
>
> I shut it down this morning, and when I restarted it the smon
> process started using about 20% of the CPU, and I am geting failry
> high disk I/O rates (as meausred with HP's Glance product).
>
> To the best of my knoledge, there should be no active conectiosn to
> this databse yet!
>
> How can I determine who.what is connected?
>
> Also is there anyway that I can determine what smon is doing?
>
>

There are several jobs that smon performs periodically and at instance startup. It coalesces tablespaces, performs database recovery startup, etc. It's probably performing one of these jobs.

If you want to see who is on the database look at v$session. V$sql will tell you what they are doing. I've never tried this but you might be able to see what smon is doing by obtaning it's SID and looking up the same entries in v$sql and v$session for that SID.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPB4T2mm5A4kkb4ZsEQLzwQCeL9tE0/WiZBWuMRGM/UyvkHJdpbkAoNXs zxPB4XzXD/fgY8lsxJoB9ooB
=DarF
-----END PGP SIGNATURE----- Received on Mon Dec 17 2001 - 09:47:25 CST