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


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?

-- 
   +------------------------------+------------------------------------+

|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 |
+------------------------------+------------------------------------+
Received on Thu May 11 1995 - 00:00:00 CEST

Original text of this message