Hope you are well with the grace of Almighty Allah (swt) Some times, you may forget about the shortcut key when working in oracle forms. Total System Global Area 1.0255E+10 bytesĪs salamualikum (islamic greetings), brothers and sisters. All rights reserved.Ĭ:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus -prelim "/ as sysdba" ORA-00020: maximum number of processes (150) exceededĬ:\Users\Administrator>CD C:\app\Administrator\product\11.2.0\dbhome_1\BINĬ:\app\Administrator\product\11.2.0\dbhome_1\BIN>SQLPLUS /NOLOG When i tried to connect to database as admin, i got another error is It is not possible to see hidden parameters of other instances in a RAC cluster.ORA-12520: TNS:listener could not find available handler for requested type of server It is never recommended to modify these hidden parameters without the assistance of Oracle Support.Ĭhanging these parameters may lead to serious corruption issues, high performance degradation and other problems in the database.
Until they are specified in root, they are not available to be modified in PDBs since this is a dictionary operation for PDBs. Note: To make an underscore parameter persistent inside a 12c PDB, the same underscore parameter needs to be specified explicitly(with its default value) in cdb$root. SQL> alter system set "" scope=spfile and bounce the database. While starting up the database startup with pfile, e.g.Ĭreate the spfile from pfile using command "create spfile from pfile" and replace the old spfile with the new one.
So you have four options to change the parameters:
This will list all the hidden parameters with their default values.Ī2: Now you can change the desired parameter by setting it explicitly in init.ora or using the ssion set command for session level.ĭuring startup, the database takes the parameters from spfile by default. SELECT a.ksppinm "Parameter", b.KSPPSTDF "Default Value", b.ksppstvl "Session Value", c.ksppstvl "Instance Value", decode(bitand(a.ksppiflg/256,1),1,'TRUE','FALSE') IS_SESSION_MODIFIABLE, decode(bitand(a.ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED',3,'IMMEDIATE','FALSE') IS_SYSTEM_MODIFIABLE FROM x$ksppi a, x$ksppcv b, x$ksppsv c WHERE a.indx = b.indx AND a.indx = c.indx AND a.ksppinm LIKE '/_%' escape '/' / for finding ISPDB_MODIFIABLE : SELECT a.ksppinm "Parameter", decode(bitand(ksppiflg/524288,1),1,'TRUE','FALSE') ISPDB_MODIFIABLE FROM x$ksppi a WHERE a.ksppinm LIKE '/_clusterwide_global_transactions' escape '/' However, if you want to view all the hidden parameters and their default values, as well as : if they are session modifiable and system modifiable, the following query could be of help. Or querying v$parameter unless and until they are set explicitly in init.ora.
#SHOW DATABASE IN ORACLE 10G HOW TO#
Q2: How to change these hidden parameters?Ī1: The hidden parameters start with an "_".They can not be viewed from the output of 'show parameter' Q1: How to query the hidden initialization parameters in sql ?
0 kommentar(er)
