OracleSID processes use inordinate amounts of cpu
From: Susan M. Wilson <wilsons_at_mis4.plk.af.mil>
Date: 1995/05/11
Message-ID: <3ot3s0$gk7_at_fg1.plk.af.mil>#1/1
Date: 1995/05/11
Message-ID: <3ot3s0$gk7_at_fg1.plk.af.mil>#1/1
I have a user who runs create table statements which select rows from multiple tables which are quite large (xxx 100k rows). He claims that _usually_ the table gets created but when I look at what the process is actually accessing (using svrmgrm), all I see is con$ and tab$. The oracleSID process consumes inordinate amounts of the cpu on my Sparc Center 2000, yet seems to be doing nothing.
Any ideas?
-- +------------------------------+------------------------------------+Received on Thu May 11 1995 - 00:00:00 CEST
|Susan M. Wilson | Phone: 505-846-2423 DSN-246-2423 |
|Computer Sciences Corp | FAX: 505-846-5114 DSN-246-5114 |
|CSC/PL/XPP Bldg 497 +------------------------------------+
|3560 Aberdeen Ave SE | e-mail wilsons_at_mis4.plk.af.mil |
|Kirtland AFB, NM 87117-5776 | wilsons_at_129.238.20.137 |
+------------------------------+------------------------------------+