Skip to Main Content
Forums

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!

Show underscore parameter not working

906790Jul 27 2017 — edited Jul 27 2017

Hi All,

Its odd for me happen today, i was looking for the parameter value of _enable_space_preallocation by using the Show parameter _enable_space_preallocation but it didn't shown me the output . But my team member got the output. I dont know whats mistake i did. please help me.

For me in 12c:

SQL> show parameter  _enable_space_preallocation

SQL> show parameter _ENABLE_SPACE_PREALLOCATION

SQL>

For my team member:

sho parameter _ENABLE_SPACE_PREALLOCATION

SQL> sho parameter _ENABLE_SPACE_PREALLOCATION

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

_enable_space_preallocation          integer     0

Thanks

Bala

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2017
Added on Jul 27 2017
#general-database-discussions
2 comments
1,085 views