Friday, October 16, 2015

How to See Initialization Parameters of my Oracle Database

To see the current settings for initialization parameters, use the following SQL*Plus command:


SQL> SHOW PARAMETERS

 Enter the following text string to display all parameters having BLOCK in their names:


SQL> SHOW PARAMETERS BLOCK
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)