How to set init.ora parameter _ksmg_granule_size?
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?