skip to main
|
skip to sidebar
oracle blog
Friday, September 21, 2007
Unsetting the instance parameters
Following syntax is used to unset a parameter:
SQL> alter system reset [parameter_name] scope=spfile sid='*';
where "sid" is the sid of the instance which needs to be affected in a RAC environment. In case of a single instance use "*".
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2016
(5)
►
July
(5)
►
2012
(2)
►
September
(1)
►
February
(1)
►
2011
(3)
►
December
(1)
►
July
(1)
►
March
(1)
►
2010
(4)
►
November
(1)
►
October
(1)
►
September
(1)
►
June
(1)
►
2009
(8)
►
September
(1)
►
August
(1)
►
July
(1)
►
March
(1)
►
February
(2)
►
January
(2)
►
2008
(12)
►
July
(1)
►
June
(1)
►
April
(1)
►
March
(4)
►
February
(2)
►
January
(3)
▼
2007
(40)
►
December
(2)
►
November
(1)
►
October
(3)
▼
September
(3)
EM Grid Control target discovery. How to add more ...
Unsetting the instance parameters
What does it mean if SERVER = 'NONE' in v$session?
►
August
(2)
►
July
(4)
►
June
(4)
►
May
(13)
►
April
(3)
►
February
(2)
►
January
(3)
Labels
advisors
(1)
ajax
(1)
archivelog
(2)
audit
(2)
bfile
(1)
block corruption
(1)
change sid
(1)
control files
(1)
cssd
(1)
cursors
(1)
data pump
(6)
dataguard
(1)
dblinks
(1)
ddl
(3)
dgbroker
(1)
distributed
(1)
execution plan
(3)
export
(1)
fga
(1)
globalization settings
(3)
grants
(1)
grid agent
(1)
invalid objects
(1)
jquery
(1)
killing sessions
(1)
korn
(1)
library cache
(1)
LOB
(1)
lobs
(1)
locks
(3)
materialized views
(1)
migration
(1)
oracle
(64)
oracle 10g
(4)
oracle 11g
(1)
outlines
(1)
parallel query
(1)
perl
(1)
prefetch
(1)
privileges
(2)
rac
(3)
recovery
(1)
rich text editors
(1)
rman
(3)
security
(1)
shared server
(2)
spfile
(2)
sql*loader
(1)
sqlplus
(1)
ssl certificate
(1)
statistics
(3)
tar
(1)
tarantula
(1)
temp tablespaces
(2)
tom kyte book
(1)
tracing sessions
(6)
triggers
(1)
undo
(1)
unix
(2)
users
(1)
useful links
Tanel Poder's blog
Tim Hall's ORACLE-BASE
Jonathan Lewis blog
jQuery - makes DHTML simple
No comments:
Post a Comment