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!

How to display current session parameter value

200754Nov 6 2009 — edited Nov 6 2009

Hi,

How can a db user know value of a session parameter, if he doen't have privilege to access v$parameter?

SQL> conn hr/hr
Connected.

SQL> show parameter QUERY_REWRITE_ENABLED
ORA-00942: table or view does not exist

SQL> alter session set QUERY_REWRITE_ENABLED=true ;
Session altered.

...

-- how can the user HR know the value of QUERY_REWRITE_ENABLED

This post has been answered by Toni Lazarin on Nov 6 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2009

Added on Nov 6 2009

#general-database-discussions

4 comments

15,608 views