Re: ora817 sga problem

"Morff" <morff1_at_wp.pl> wrote in message news:op.s1qoknwmq0kutt_at_nt_januszk.domain_not_set.invalid...
> Hi
>
> Oracle users from time to time have an error "invalid column name" on
> select from database. That invalid column is usually function based
> column. I read thread about "cursor_space_for_time" but I still don't know
> is it reason. Database is used by 30-40 users in time now , but previously
> was 120-130 users and locally guru tunes database to this value of users .
> I thing some values are too big and this is the reason of the error .. am
> I right ?
>
> I found a solution like that :
>
> SELECT sharable_mem/VALUE FROM
> (select sum(sharable_mem) sharable_mem
> from sys.v_$sqlarea a, dba_users b
> where a.parsing_user_id = b.user_id) A,
> (select value from v$sga where name like 'Var%')
>
> when a result is larger than 0.3 (usually in my db is 0.7) i should flush
> a shared pool (alter system flush shared_pool) .. I'm not sure that is
> good idea ..
>
> an error occurs mostly in users which have big value of sum(sharable_mem).
>
> Which parameters should I check ?
>
> If someone want help i can paste some fragments of init.ora :)
>
>
> Regards
> --
> Pozdrawiam
> Morff
> ----------------------
> AQQ 141151
> Powered by Opera/M2

Hi,

I don't understand what the exact error message is ? Could you post the ORA-... number ? Do you have any trace files in the udump folder on the server ? Maybe your shared pool is too small or too fragmented, of course flushing it helps at that time, but only for some time ...

Matthias Received on Tue Dec 13 2005 - 14:34:53 CST