Oracle - Display parameters

December 2016




In addition to the file init.ora, it is possible for you to consult the database to be check out parameters such as max_open_cursors ,size of a block ...

Simply run the following command:

SELECT name, value 
FROM v$parameter

Related :

This document entitled « Oracle - Display parameters » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.