Hi Gopal
How may the PGA be Dumped to get the ALTER SYSTEM .. Value ?
NOTE In 8.1.7.2 Both of the following do NOT appear in the alert_SID.log
ALTER SYSTEM SET USE_STORED_OUTLINES=RBOCAT
ALTER SYSTEM SET CREATE_STORED_OUTLINES=RBOCAT
Thanks
P.S. Good indeed to see you . Trust All is Well
Is there NO Other Way to find How ?
In Particular :-
ALTER SYSTEM SET USE_STORED_OUTLINES=RBOCAT;
NOTE USE_STORED_OUTLINES does NOT appear in v$parameters NOT in x$ksppinm
Thanks
-Original Message-
Sent: Tuesday, June 25, 2002 12:15 AM
To: LazyDBA.com Discussion; VIVEK_SHARMA
In
VIVEK_SHARMA wrote:
How can Values Set by a previously Issued ALTER SYSTEM SET Command be Found ?
SQL desc v$parameter
Name Null?Type
-
NUM
Hi:
There is no direct way to find out from the V$/X$ tables since the session
modified parameter settings are kept in the PGA and it is not visible to
external sessions.
Technically there is a way, you have to dump the PGA and you can get the
session parameter values.
Best Regards,
K