Re: OracleSID processes use inordinate amounts of cpu

In article <3ot3s0$gk7_at_fg1.plk.af.mil>, wilsons_at_mis4.plk.af.mil wrote:

> 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?

Check the users query. If it is using the cost based optimizer it may take a couple of days to run. Switching to the Rule based may reduce the time dramatically. We had similiar queries that ran for days that now run under 2 hours.
>
> --
> +------------------------------+------------------------------------+
> |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 |
> +------------------------------+------------------------------------+
 

-- 
Grant McCracken
DB Marketing - Bell Canada
Toronto, Ontario
GJMCCRAC_at_post.bell.ca