Parameters

[Griselda Sanchez]

Where can I find the value of these parameters SSTLRMAX and SSTKBLCK, I already look into the Kernel Parameters but there isn't something.

[Mel Burslan]

I am not familiar with these parameters myself, but not all the parameters are in the kernel by default. Before you can see these, you may need to install an application which will modify your kernel or put a patch to your system.

Where did you see the recommendation to modify these parms ?

[Cheryl Griffin]

These seem to be Oracle tunables, not something tuned in the HP-UX kernel.

For instance:
ORA-27018: skgfidev: blocksize in device parms must be multiple of SSTKBLCK
Cause: User specified a blocking factor that is not a multiple of SSTKBLCK.

Action: Additional information indicates the blocking factor provided by user and the value of SSTKBLCK. Specify a value that is a multiple of SSTKBLCK.

[Griselda Sanchez]

I know that Kernel parameters are the only parameters con HP-UX.
These information were ask by the administrator of Data Bases

[Griselda Sanchez]

Cheryl,
Then what you say is that these parameters are parts of Oracle configuration??
Then the administrator if oracle should be know where can seed these values?

[Mel Burslan]

it does not even look like (from oracle error messages) this sstkblck is an hpux kernel variable. As Cheryl said, it sounds more like an Oracle tunable parm. Your db administrator needs to contact oracle and sort it out with them if he does not have the first hand knowledge. See this from oracle documentation pages :

ORA-27018: skgfidev: blocksize in device parms must be multiple of SSTKBLCK
Cause: User specified a blocking factor that is not a multiple of SSTKBLCK.

Action: Additional information indicates the blocking factor provided by user and the value of SSTKBLCK. Specify a value that is a multiple of SSTKBLCK.

[Griselda Sanchez]

Mel.
The question begins because my administrator of Data Bases ask me for these parameters (values).

[Mel Burslan · Accepted solution]

Griselda,

Well, your answer to the db admin should be something in the tune of :

"these are oracle tunable parameters and as an hpux system administrator I do not have any knowledge of them"

unless of course, you are responsible from installing, configuring and tuning oracle as well. In which case, the question is more suited to be asked to oracle experts rather than hpux.

Hope this helps.

[Cheryl Griffin]

Well said Mel.

[Bruno Ganino]

Mel is right !
Look here:
http://www-rohan.sdsu.edu/doc/oracle/errmsg803/A54625_01/newch2n2.htm

Bye
Bruno

[Griselda Sanchez]

Thanks to all