-
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
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|