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 11.1.0.7.0 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.
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 11.1.0.7.0 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