OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » oracle parameters

Sat, 24 May 2003 15:44

Viji Murthy
Messages: 2
Registered: May 2003

Junior Member

I would like to know more about this parameter.
ALTER SYSTEM SET _smm_advice_enabled=FALSE SCOPE=SPFILE SID='*';

What does this do?
Thanks,
Viji

Mon, 26 May 2003 00:49

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Most likely it's an undocumented parameter. You can list the undocumented with the following query (run as SYS or SYSTEM):

SELECT ksppinm name
     , ksppdesc desc
  FROM x$ksppi 
 WHERE ksppinm LIKE '*_%' ESCAPE '*'

Just add your criteria to the query.

MHE

Previous Topic:	Database creation error
Next Topic:	Oracle 8.0.4 with Windows 2000

Goto Forum:

]

Current Time: Sat May 02 16:15:10 CDT 2026