DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sp file

  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Thumbs down sp file

    what is spfile?

  2. #2
    Join Date
    Jul 2007
    Posts
    2
    What is spfile? It is working on server side or why for spfile actually used?

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    its a parameter file, have you heard of searching?

    http://www.google.co.uk/search?q=spfile

  4. #4
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44

    Thumbs up Spfile

    "THE besic thing is seems difficult who r new!!!!!! so ........"

    SPFILE or server parameter file come with oracle 9i,its a parameter file but binary format and represent of text based PFILE.

    IF u need create SPFILE u must have PFILE.

    SPFILE create com...

    >create spfile from pfile;

    Initialization parameters stored in a server parameter file are persistent, in that any changes made to the parameters while an instance is running can persist across instance shutdown and startup. This eliminates the need to manually update initialization parameters to make changes effected by ALTER SYSTEM statements persistent.

    FOR more info go....

    http://download-uk.oracle.com/docs/c...ate.htm#999303

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