topic Re: Parameters in Operating System - HP-UX

Parameters

Griselda Sanchez — Tue, 04 May 2004 10:16:17 GMT

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

Re: Parameters

Mel Burslan — Tue, 04 May 2004 10:21:20 GMT

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 ?

Re: Parameters

Cheryl Griffin — Tue, 04 May 2004 10:25:21 GMT

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.

Re: Parameters

Griselda Sanchez — Tue, 04 May 2004 10:31:24 GMT

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

Re: Parameters

Griselda Sanchez — Tue, 04 May 2004 10:43:05 GMT

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?

Re: Parameters

Mel Burslan — Tue, 04 May 2004 11:06:52 GMT

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.

Re: Parameters

Griselda Sanchez — Tue, 04 May 2004 11:18:43 GMT

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

Re: Parameters

Mel Burslan — Tue, 04 May 2004 11:31:58 GMT

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.

Re: Parameters

Cheryl Griffin — Tue, 04 May 2004 11:55:41 GMT

Well said Mel.

Re: Parameters

Bruno Ganino — Tue, 04 May 2004 12:13:43 GMT

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

Bye
Bruno

Re: Parameters

Griselda Sanchez — Tue, 04 May 2004 12:26:38 GMT

Thanks to all