Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What are the base tables of SYS.V_$PARAMETER ?

chathuApr 26 2016 — edited Apr 27 2016

Hi All,

I'm using express version of oracle and lately I try to learn about useful tables and views in SYS schema that can be used to get information about schema objects and etc. In doing this I've come to known about v$parameter and want know what type of schema object it is and then found out its a synonym owned by PUBLIC schema. So then I've got underlying DDL of this synonym using DBMS_METADATA.GET_DDL and result is output as

CREATE OR REPLACE PUBLIC SYNONYM "V$PARAMETER" FOR "SYS"."V_$PARAMETER"

Eventually I was curious to find out what is the underlying DDL for SYS.V_$PARAMETER and got it as

CREATE OR REPLACE FORCE VIEW "SYS"."V_$PARAMETER" ("NUM", "NAME", "TYPE", "VALUE", "DISPLAY_VALUE", "ISDEFAULT", "ISSES_MODIFIABLE", "ISSYS_MODIFIABLE", "ISINSTANCE_MODIFIABLE", "ISMODIFIED", "ISADJUSTED", "ISDEPRECATED", "ISBASIC", "DESCRIPTION", "UPDATE_COMMENT", "HASH") AS

  select "NUM","NAME","TYPE","VALUE","DISPLAY_VALUE","ISDEFAULT","ISSES_MODIFIABLE","ISSYS_MODIFIABLE","ISINSTANCE_MODIFIABLE","ISMODIFIED","ISADJUSTED","ISDEPRECATED","ISBASIC","DESCRIPTION","UPDATE_COMMENT","HASH" from v$parameter

So that's where I've got into a bit of confusion because synonym name and name of underlying source of this V_$PARAMETER both are same and when I've searched underlying source using DBA_OBJECTS or DBA_CATALOG then always only synonym has come up. So any help to clarify this confusion?

Regards.

This post has been answered by AndrewSayer on Apr 26 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2016
Added on Apr 26 2016
4 comments
781 views