Reset/Unset a spfile parameter
Setting a parameter to =’ ‘ often isn’t enough. Do this instead…
alter system reset <parameter> scope=spfile sid='*'
/
The sid='*' bit is always necessary, even in non RAC database.
October 22nd, 2009 by sysdba
Setting a parameter to =’ ‘ often isn’t enough. Do this instead…
alter system reset <parameter> scope=spfile sid='*'
/
The sid='*' bit is always necessary, even in non RAC database.
Hi, Be the first leave some reply
This page is an introduction to my blog, which is dedicated to Oracle data base performance management.
I found over the years sharing knowledge to be an invaluable tool in assisting me in my various consulting assignments. Spending most of my time in capacity planning, tuning, application sizing and performance management, I thought it might be [...]
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Oct | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | ||||




(0.00 out of 5)



(0.00 out of 5)



(0.00 out of 5)



(0.00 out of 5)



(0.00 out of 5)



(0.00 out of 5)



(0.00 out of 5)



(0.00 out of 5)



(0.00 out of 5)



(0.00 out of 5)
Ask TEM Dba © 2008-2012 All Rights Reserved.
Powered by WordPress 2.9.2
Pemuda versi 1.4 created by Nurudin Jauhari
Entries and Comments.