Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Use Oracle 11g show spparameter command     - C ++ Supplements - Smart Pointers (Programming)

- Configuring LIDS build Linux kernel security intrusion detection system (Linux)

- Linux desktop system using the remote server in clear text ssh password (Server)

- Source code to compile and install MySQL 5.7.9 (Database)

- How to ensure that the Internet will not be attacked (Linux)

- The callback function used in C ++ (Programming)

- Java threads and thread pools (Programming)

- The difference between vi and nano (Linux)

- Linux configuration Samba server (Server)

- Linux delete duplicate files Artifact: dupeGuru (Linux)

- Linux kernel network subsystem analysis (Programming)

- How to use the Vault secure password storage and API key (Linux)

- Hadoop 2.6.0 standalone configuration and pseudo-distributed configuration under Ubuntu 14.04 (Server)

- MySQL query optimization: profile function (Database)

- Java8 Lambda expressions and flow operations (Programming)

- Zypper command for SUSE Linux package management (Linux)

- bash login and welcome message: / etc / issue, / etc / motd (Linux)

- MySQL development common query summary (Database)

- Linux System Getting Started Tutorial: Linux file permissions brief description (Linux)

- 20 open source / commercial Linux server management control panel (Server)

 
         
  Use Oracle 11g show spparameter command
     
  Add Date : 2018-11-21      
         
       
         
  When we get to the current Oracle database parameter values, you can query the dynamic performance view v $ parameter to get, of course, you can also be used in this way show parameter p_name get. But Oracle 11g ago, show parameter can only get the current session of the parameter values, depending on the value of other parameters, such as system-level parameters and parameter values ​​to modify the parameter file spfile still need to use the data dictionary. Oracle 11g, do some changes, introduced show spparameter p_name command, we can more easily access the parameter values ​​spfile file, it is clear this is just a little skill, but it does make Oracle a more flexible and convenient to use.

SQL> show parameter open_cursors
NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
open_cursors integer 400

We just modify the parameter file, add scope = spfile
SQL> alter system set open_cursors = 300 scope = spfile;
System altered.

If you want to view the value of the parameter, see the current session
SQL> show parameter open_cursors

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
open_cursors integer 400

SQL> desc v $ parameter
Name Null? Type
----------------------------------------- ---------- ---------------------------
NUM NUMBER
NAME VARCHAR2 (80)
TYPE NUMBER
VALUE VARCHAR2 (4000)
DISPLAY_VALUE VARCHAR2 (4000)
ISDEFAULT VARCHAR2 (9)
ISSES_MODIFIABLE VARCHAR2 (5)
ISSYS_MODIFIABLE VARCHAR2 (9)
ISINSTANCE_MODIFIABLE VARCHAR2 (5)
ISMODIFIED VARCHAR2 (10)
ISADJUSTED VARCHAR2 (5)
ISDEPRECATED VARCHAR2 (5)
ISBASIC VARCHAR2 (5)
DESCRIPTION VARCHAR2 (255)
UPDATE_COMMENT VARCHAR2 (255)
HASH NUMBER

SQL> select name, value from v $ parameter where name = 'open_cursors';

NAME VALUE
--------------- ----------------------------------- ----------
open_cursors 400

The value of the parameter file if you want to look after the parameter modification
SQL> desc v $ spparameter
Name Null? Type
----------------------------------------- ---------- ---------------------------
SID VARCHAR2 (80)
NAME VARCHAR2 (80)
TYPE VARCHAR2 (11)
VALUE VARCHAR2 (255)
DISPLAY_VALUE VARCHAR2 (255)
ISSPECIFIED VARCHAR2 (6)
ORDINAL NUMBER
UPDATE_COMMENT VARCHAR2 (255)

SQL> col name for a15
SQL> col value for a45

SQL> select name, value from v $ spparameter where name = 'open_cursors';

NAME VALUE
--------------- ----------------------------------- ----------
open_cursors 300

SQL> show spparameter open_cursors

SID NAME TYPE VALUE
-------- ---------- ------------- --------------------------
* Open_cursors integer 300

Obviously, with the show spparameter, the operation easier.
     
         
       
         
  More:      
 
- Linux SSH remote connection service slow Solutions (Linux)
- Docker: installation under Ubuntu (Server)
- How to use Evernote in the Linux command line (Linux)
- In the case of using cgroups Ubuntu 14.04 and Docker (Linux)
- Enterprise Hadoop cluster architecture - Hadoop installation (Server)
- lolcat: an output terminal rainbow effects in the Linux command-line tool (Linux)
- Nginx Module Development - get user ip (Server)
- Linux System Getting Started Learning: Using the Linux command line detected DVD burner name and write speeds (Linux)
- Ubuntu batch scp to copy files without password (Linux)
- To generate a certificate using OpenSSL under Linux (Server)
- C ++ Object Model Comments (Programming)
- Upgrading to MySQL 5.7.9 MySQL 5.6.23 (Database)
- ASM learning overview (Database)
- JavaScript common functions summary (Programming)
- MongoDB simple replication configuration (Database)
- Executable file format Explanation under Linux (Linux)
- Linux Shell introduces (Linux)
- Dual system Linux (Ubuntu) into the Windows NTFS partition's mount error (Linux)
- Ubuntu 14.04 LTS 64-bit installation and activation Sublime Text 3 can not solve the Chinese input method to solve the problem (Linux)
- Linux centralized log server rsyslog (Server)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.