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

Thread: SPFILE or INIT.ORA file....

  1. #1
    Join Date
    Apr 2005
    Posts
    19

    SPFILE or INIT.ORA file....

    Hi All,

    I would like to have the info for the following:

    1) Say for instance, if a DB is started, how shall we determine as to whether DB was started with INIT.ORA or SPFILE..

    Is there a way to investigate this!

    Thanks for your time!

    Regards,

    a1_win.
    Thank You for your time,

    Regards,
    a1_win

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    show parameter spfile
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Apr 2005
    Posts
    19
    Hi adewri,

    so it means if SPFILE is not used to start the DB, we can just use
    SHOW PARAMETER... output as below which will show that INIT.ORA is used to start the DB and not SPFILE since entry for spfile here in this case is NULL....

    SQL> show parameter spfile

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    spfile string



    SQL> show parameter

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    O7_DICTIONARY_ACCESSIBILITY boolean TRUE
    _b_tree_bitmap_plans boolean FALSE
    _fast_full_scan_enabled boolean FALSE
    _index_join_enabled boolean FALSE
    _like_with_bind_as_equality boolean TRUE
    _shared_pool_reserved_min_alloc big integer 4100
    _sort_elimination_cost_ratio integer 5
    _sqlexec_progression_cost integer 2147483647
    _system_trig_enabled boolean TRUE
    _trace_files_public boolean TRUE
    active_instance_count integer


    Regards,

    a1_win.
    Thank You for your time,

    Regards,
    a1_win

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Yes...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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