duplicate parameters in my spfile
Originally logged by RWestbrook (but as a Document)
I have a few questions about some apparently duplicate parameters in my spfile. I recently did a CREATE PFILE FROM SPFILE and found the following entries in my newly created pfile. In the excerpt below, note that I have a CURSOR_SHARING and a ZVL.CURSOR_SHARING. (zvl is my instance name) It appears that Oracle gives precedence to the entries beginning with "zvl.".
zvl.cursor_sharing='FORCE'
*.cursor_sharing='EXACT'
zvl.event='1555 trace name errorstack level 4'
*.event='1555 trace name errorstack off'
zvl.pga_aggregate_target=138412032
*.pga_aggregate_target=201326592
I have a few questions about some apparently duplicate parameters in my spfile. I recently did a CREATE PFILE FROM SPFILE and found the following entries in my newly created pfile. In the excerpt below, note that I have a CURSOR_SHARING and a ZVL.CURSOR_SHARING. (zvl is my instance name) It appears that Oracle gives precedence to the entries beginning with "zvl.".
zvl.cursor_sharing='FORCE'
*.cursor_sharing='EXACT'
zvl.event='1555 trace name errorstack level 4'
*.event='1555 trace name errorstack off'
zvl.pga_aggregate_target=138412032
*.pga_aggregate_target=201326592
0