Home » RDBMS Server » Server Administration » Describe V_$SGA
Describe V_$SGA [message #54792] Thu, 05 December 2002 01:32 Go to next message
Selina
Messages: 5
Registered: September 2002
Junior Member
I have a oracle DB account (DBMon) with the role 'SELECT_CATALOG_ROLE'. It is presumed that I can describe V_$SGA thru DBMon account. However, error ORA-00942 prompted if I type 'DESC V_$SGA'. How can I solve the problem?

Report message to a moderator

Re: Describe V_$SGA [message #54795 is a reply to message #54792] Thu, 05 December 2002 03:48 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
V_$SGA is sys table fully quantified sys.V_$SGA
use V$SGA instead .. but i'm not sure u can query this table with those privileges...

Report message to a moderator

Previous Topic: Re: Don't know what is my connection identifier?
Next Topic: moving table with long raw column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:41:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.