Database Administration (MOSC)

MOSC Banner

duplicate parameters in my spfile

edited May 19, 2009 2:41AM in Database Administration (MOSC) 2 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center