Re: Parameter values for another user's session
From: Andy Sayer <andysayer_at_gmail.com>
Date: Mon, 17 Feb 2020 21:15:40 +0000
Message-ID: <CACj1VR49kS7cVCvBWk5dF8vWKwgfgYc92-gmcbB7=2XbrR_ZSw_at_mail.gmail.com>
Date: Mon, 17 Feb 2020 21:15:40 +0000
Message-ID: <CACj1VR49kS7cVCvBWk5dF8vWKwgfgYc92-gmcbB7=2XbrR_ZSw_at_mail.gmail.com>
What parameters are you looking for? Optimizer environment parameters are
easily found in v$ses_optimizer_env. Otherwise you’ll need to play with
oradebug:
Oradebug setospid <Ospid>
Oradebug dump modified_parameters 1
And review the trace file for the process
Hope that helps,
Andrew
On Mon, 17 Feb 2020 at 20:58, Cee Pee <carlospena999_at_gmail.com> wrote:
> Hi
>
> Is there a way to find out the parameter values for a different user's
> session that is currently executing. I can log in as sys into the database.
>
> CP
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 17 2020 - 22:15:40 CET