Self-taught Oracle database documentation

1. Use the "win+e" shortcut key to open the run (Start-à Run) window. The following figure

2 in the "Run" form, enter "Sqlplus" (pictured above), and click the OK button.

3. Enter "username"/"password" in the Black form that pops up; (format: Sqlplus username/password@ netservicename, username/password the username and password used for the login database ; Netservicename is the local net service name to which you want to run the database connection. (Figure red Circle below)

4. View database parameters: Use the show parameter command.

For example, when a user executes the show parameter instance command, Oracle displays all parameters that contain the instance typeface to the user. (table below)

Note: The show parameter command here does not support wildcard characters.

Sql> show parameter instance;

NAME TYPE VALUE

------------------------------------ ----------- ----------

Active_instance_count integer

Cluster_database_instances Integer 1

Instance_groups string

instance_name String XE

Instance_number integer 0

Instance_type string RDBMS

Open_links_per_instance Integer 4

Parallel_instance_group string

Parallel_server_instances Integer 1

Sql>