spfile in data dictionary
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: spfile in data dictionary

  1. #1
    Join Date
    Nov 2001
    Posts
    118

    spfile in data dictionary

    Hi everyone,

    Could someone please tell me which data dictionary view contains the information which sort of initialisation file my instance is using?

    I tried the obvious ones: v$parameter and v$system_parameter, but the information is only shown for some databases (their location, anyway), but not always. Quite often the values for 'ifile' and /or 'spfile' are just empty.

    Thanks
    Peer

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    show parameter spfile will tell you if you are using it - if there is a value you are using it.

    Same goes for v$parameter, if spfile has a parameter you are using one, it not, using a pfile

  3. #3
    Join Date
    Nov 2001
    Posts
    118
    Thanks for the reply, but are you sure the v$parameter always works that way?
    As far as I can see I've got one or two instances where neither spfile or pfile seem to be specified there at all.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    well pfile isnt a valid parameter anyway

    Code:
    SQL> show parameter pfile
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ---------------------------
    spfile                               string
    if spfile is blank you are definitely using a pfile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width