Find parameter values

Hopefully, this is a simple one. How can I find the value of the skip_unusable_indexes parameter?
LVL 32
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

awking00Author Commented:
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.
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?
awking00Author Commented:
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."
I've done a bit of research and 'SKIP_UNUSABLE_INDEXES' is NOT an initialisation parameter.  It has to be set at the session level via an 'alter session' command.  Check the glogin.sql file on your application server to check if it's set there and check your application to see if it explicitly issues an alter session command.  I guess the rule here is that if this parameter is not set at the session level then the value is always FALSE.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.