db started
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: db started

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63

    db started

    By default Database starts using spfile .But is there any way to findout whether db have been started using spfile or init.ora .

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    in 9i do

    SQL> show parameter spfile.

    if the value is blank then the instance has started using pfile, else it will show the absolute path of the spfile it has used during startup.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    Thanks

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