<div>
Using SQLPLUS connect as a dba user (sys is best)<br />
Type 'show parameter skip_unusable_indexes' &lt;enter&gt;<br />
<br />

</div>


Using SQLPLUS connect as a dba user (sys is best)
Type 'show parameter skip_unusable_indexes' <enter>



<div>
I tried this before. The problem is that the show parameters command only shows the names and values of the parameters that are in v$parameter, of which skip_unusable_indexes is not one.
</div>


I tried this before. The problem is that the show parameters command only shows the names and values of the parameters that are in v$parameter, of which skip_unusable_indexes is not one.

<div>
OK, if you're using enterprise manager, you can select 'instance' and view all initialisation parameters.<br />
<br />
Otherwise, check your init file.<br />
<br />
What db version are you on?
</div>


OK, if you're using enterprise manager, you can select 'instance' and view all initialisation parameters.

Otherwise, check your init file.

What db version are you on?

<div>
Another problem. This is a production database, and while I have select access on the production tables (including the dba_ and v$ tables), I have no OEM access. I do have OEM access on a development system and, even there, the skip_unusable_indexes parameter does not show when I select view &quot;all initialization parameters.&quot;
</div>


Another problem. This is a production database, and while I have select access on the production tables (including the dba_ and v$ tables), I have no OEM access. I do have OEM access on a development system and, even there, the skip_unusable_indexes parameter does not show when I select view "all initialization parameters."

<div>
<div class="content wysiwyg-content">
Hopefully, this is a simple one. How can I find the value of the skip_unusable_indexes parameter?
</div>
</div>


Hopefully, this is a simple one. How can I find the value of the skip_unusable_indexes parameter?

Find parameter values

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.