Re: sql_shared_memory

Did you run your CATALOG.SQL?
It's in your rdbms/admin dir

bash-2.02$ grep sql_shared_memory catalog.sql Rem rtaranto 11/09/95 - Add synonym for v$sql_shared_memory create or replace view v_$sql_shared_memory   as select * from v$sql_shared_memory; drop public synonym v$sql_shared_memory; create public synonym v$sql_shared_memory for v_$sql_shared_memory;

On Fri, 30 Jul 1999 10:42:50 +0200, Bruno Plankensteiner <bplank_at_ctp.com> wrote:

>For some reasons the view sys.v_$sql_shared_memory is invalid. I have no
>idea what to do in order to restore it. Any hint?
>I tried to install a tool which requires this view.
>Thank you
>Bruno
>

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email