Database Memory & 4030/4031 (MOSC)

MOSC Banner

How to set init.ora parameter _ksmg_granule_size?

edited Oct 8, 2009 2:36AM in Database Memory & 4030/4031 (MOSC) 12 commentsAnswered ✓
Hi,

MetaLink's solution to my ORA-600: Generic internal error is to  set init.ora parameter _ksmg_granule_size = 16 M. 

I tried to query the table v$parameter to find this particular parameter without success.

SQL> select name, type, value
2 from v$parameter
3 where name like '%ksmg%';

no rows selected

Q1: How do you query the value of an internal parameter?

From http://www.recovery-for-oracle.com/Params/parm527.htm the internal parameter can not be set by 'ALTER SYSTEM' command.

Q2: The proper way to set an internal parameter is to create a pfile from the spfile, modify the pfile,  and restart the database with the pfile.  Is this correct?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center