Troubleshooting
Problem
Useful Oracle queries finding and changing the values of Oracle parameters cursor_sharing others
Symptom
PART: API-OM 5.0 Platform
PRODUCT: Supply Collaboration
COMPONENT:
changeOrderStatus
DATABASE: Oracle
Useful Oracle queries finding and
changing the values of Oracle parameters cursor_sharing others
Cause
Resolving The Problem
To find the value of an oracle parameter on a Oracle database server you can
either check the init.ora or run the following command within sql
show
parameter <parameter-name>
for e.g.
show parameter cursor (we can
put the string partially too)
To alter the value of this or any other
system parameter while logged into SQL with DBA priveleges run the
command:
alter system set <parameter> to <value>;
for e.g.
alter
system set cursor_sharing to FORCE;
A query that lists the values of
all parameters is as follows:
spool param.lst
set trimspool
on
set pagesize 9999
set linesize 256
column ksppinm format
a40
column ksppstvl format a40
select ksppinm,ksppstvl
from
x$ksppi i, x$ksppsv v
where i.indx = v.indx
order by
ksppinm;
spool off
Historical Number
PRI49111
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21531603