Re: ora817 sga problem

Dnia 13-12-2005 o 21:39:50 Michel Cadot <micadot{at}altern{dot}org> napisał:

> | 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%')
>
> What does this query means?

http://www.quest-pipelines.com/pipelines/dba/tips97.htm (i don't use it for flushing shared pool - only for checking memory values)

I know that flush shared pool helps only for some time ... and it helps but I don't know why ?

-- 
Pozdrawiam
Morff
----------------------
AQQ 141151
Powered by Opera/M2