Top 60 Oracle Blogs

Recent comments

A simple interview question

Question: How to check instance parameter values in Oracle?
Answer: show parameter xyz
Answer: select value from v$parameter where name = ‘xyz’
These commands show the session level parameter values, which are separate from instance level parameters:
SQL> show parameter session_cached_cursors NAME TYPE VALUE ------------------------------------ ----------- -------------------------------- session_cached_cursors integer 20 SQL> select value from v$parameter where name = 'session_cached_cursors'; VALUE --------------------------------------------------------------------------------- 20 V$SYSTEM_PARAMETER is the view which shows instance level parameters (and these are what all new sessions inherit)