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!

About HuuPV

My name is Huu. I love technology and especially Devops Skill such as Docker, vagrant, git so forth. I likes open-sources. so I created DevopsRoles.com site to share the knowledge that I have learned. My Job: IT system administrator. Hobbies: summoners war game, gossip.
View all posts by HuuPV →

Leave a Reply

Your email address will not be published.

Comment moderation is enabled. Your comment may take some time to appear.

This site uses Akismet to reduce spam. Learn how your comment data is processed.