Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Find parameter values

Posted on 2004-12-01
5
Medium Priority
?
834 Views
Last Modified: 2008-03-17
Hopefully, this is a simple one. How can I find the value of the skip_unusable_indexes parameter?
0
Comment
Question by:awking00
  • 3
  • 2
5 Comments
 
LVL 1

Expert Comment

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

0
 
LVL 32

Author Comment

by:awking00
ID: 12719217
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.
0
 
LVL 1

Expert Comment

by:TelcoDBA
ID: 12719477
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?
0
 
LVL 32

Author Comment

by:awking00
ID: 12719809
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."
0
 
LVL 1

Accepted Solution

by:
TelcoDBA earned 150 total points
ID: 12734495
OK,
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.

Hth,

tDBA
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question