Re: How to query a session's active initialization parameters from other session?

From: joel garry <joel-garry_at_home.com>
Date: 27 Feb 2007 17:54:49 -0800
Message-ID: <1172627689.712443.218830@m58g2000cwm.googlegroups.com>

On Feb 27, 12:19 am, spiritusz2..._at_yahoo.com wrote:
> Hi All,
>
> Do you have any idea how to query a session's active initialization
> parameters from other session?
> For example, someone has changed the db_file_multiblock_read_count
> parameter with an alter session statement.
> How can I query its new value from other session?
>
> Thanks in advance,
> Zoltan

OK...

0.  Go into sql.
1.  Find the PID or SID of the session.
2.  oradebug setospid <PID>

or oradebug setorapid <SID>
or oradebug setmypid (for your own session)

3.  oradebug event 10046 trace name context forever, level 12
4.  oradebug tracefile_name
5. !vi <the name given you in 4>.

Maybe you can grep for "is now" or any particular parameter you want.

Once this becomes obvious, the variants are obvious.

jg

--
@home.com is bogus.
http://www.wackyuses.com/

Received on Tue Feb 27 2007 - 19:54:49 CST