Re: above average CPU usage

Hi,

I'm using the same user to run the queries. I didnt used the enterprise manager to check the plan table. But with TOAD , I'm using manually the explain plan for the queries.

I have tried with an export/import of a big table used. But after that the statistics (analyze command) got changed. The cost has increased.

Can you please tell me where should I check. IF you require more info, please do let me know.

Thanks,

Matthias Hoys wrote:
>> Hi,
>>
>[quoted text clipped - 8 lines]
>>
>> Thanks.
>
>Does the explain plan in Enterprise Manager correspond with the one from
>sql*plus ? Are you using the same user to execute these queries ? Maybe you
>have some after-logon trigger or alter session ... which changes some user
>profiles before query execution.
>
>Matthias

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200708/1