Sorry gang....I realize this is probably simple, but I have looked at it
until I have reached a point of diminishing returns :)

Why will this statement not work? I get an ORA-00942 error. Oracle 8i


create or replace view sql_summary as
(select username, sharable_mem, persistent_mem, runtime_mem
from
sys.v_$sqlarea a, dba_users b
where
a.parsing_user_id = b.user_id);

Oracle LazyDBA home page