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 ( 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.