Oracle v$system_parameter

In this tutorial, How to query “v$system_parameter” in Oracle? Oracle v$system_parameter.

What does “v$system_parameter” mean?

“Oracle v$system_parameter is the view shows instance level parameters”. How to check v$system_parameter values in Oracle Databases.

Example, Oracle v$system_parameter

Log in and connect to the database as “SYSDBA“.

[huupv@devopsroles ~]$ sudo su - oracle
[oracle@devopsroles ~]$ sqlplus "/as sysdba"

Check value “db_block_size” in Oracle Database.

SYS@DEVOPSROLES > SELECT name, value FROM V$SYSTEM_PARAMETER where name = 'db_block_size';

The output screen terminal

NAME                 VALUE
-------------------- -----
db_block_size        9100

To check value “db_cache_size” in Oracle Database.

SYS@DEVOPSROLES > SELECT name, value FROM V$SYSTEM_PARAMETER where name = 'db_cache_size';

Check value “java_pool_size” in Oracle Database.

SYS@DEVOPSROLES > SELECT name, value FROM V$SYSTEM_PARAMETER where name = 'java_pool_size';

To check value “nls_language” in Oracle Database.

SYS@DEVOPSROLES > SELECT name, value FROM V$SYSTEM_PARAMETER where name = 'nls_language';

Check value “processes” in Oracle Database.

SYS@DEVOPSROLES > SELECT name, value FROM V$SYSTEM_PARAMETER where name = 'processes';

To check value “shared_pool_size” in Oracle Database.

SYS@DEVOPSROLES > SELECT name, value FROM V$SYSTEM_PARAMETER where name = 'shared_pool_size';

Conclusion

Thought the article, you can query “v$system_parameter in Oracle” as above. I hope will this your helpful. Thank you for reading the DevopsRoles page!