Re: select statement uses 100% CPU

From: Vince Laurent <eAddict_at_yahoo.com>
Date: Wed, 04 Jun 2003 09:35:20 -0500
Message-ID: <ps0sdvos8jj2vps0e3f39l2ll0fobrsoqe@4ax.com>

On Wed, 04 Jun 2003 12:29:08 GMT, in comp.databases.oracle.server you wrote:

>
>Are there statistics on the tables owned by SYS?
>select last_analyzed from dba_tables where owner = 'SYS';

Yes, almost 200 of them have stats on the system that does not work. The system that behaves well has not stats in the SYS owned tables.
>
>If yes .. then delete statistics and see if it makes a difference. If no ... then gather stats and see if it makes a difference.

Since my experience is with 8i I have tried Analyze table <table_name> delete statistcs; but that does not work for 9i. Do you happen to know the equivilant command for 9i? I am digging into the net via google right now looking too.

>What optimizer goal are you using?

choose (CBO) as per SAP

Thanks!
Vince Received on Wed Jun 04 2003 - 09:35:20 CDT