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.

show parameter spfile

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.

Yes...