-
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
-
Amar
"There is a difference between knowing the path and walking the path."
-
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
-
Amar
"There is a difference between knowing the path and walking the path."
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
|