11g create spfile from memory ... implications and potential problems

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Wed, 11 Mar 2009 14:06:38 -0700 (PDT)
Message-ID: <c534078f-1932-4a89-9bbb-b73b75cb29ce_at_e18g2000yqo.googlegroups.com>

Looks like if you try a create spfile from memory ( running 64 bit on OEL 5.1 ) or a pfile from memory you get all the undocumented underscore parameters now put in permanently into your new spfile or pfile.

( Things like _globalindex_pnum_filter_enabled=TRUE etc ).

Looks like it could be a real problem down the road under certain circumstances.

I don't see any warnings about this in the oracle doc for create from memory ... Received on Wed Mar 11 2009 - 16:06:38 CDT

Original text of this message