Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ora817 sga problem

Re: ora817 sga problem

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 13 Dec 2005 22:32:12 +0100
Message-ID: <439f3ddc$0$30426$626a14ce@news.free.fr>

"Morff" <morff1_at_wp.pl> a écrit dans le message de news: op.s1qp8xaxq0kutt_at_nt_januszk.domain_not_set.invalid...
| 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)

My question was "why do *you* think this query means?" Using an aged tip made for version 7.2.3 when shared pool management was different is not really a good point.

Flushing the shared pool without knowing what this also means is not a good idea.

Regards
Michel Cadot Received on Tue Dec 13 2005 - 15:32:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US