Oracle - Display parameters

April 2018

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
Published by jak58. Latest update on May 4, 2010 at 10:11 AM by jak58.
This document, titled "Oracle - Display parameters," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
Display name of the Oracle database
Oracle - Optimizing sorting operations