Not sure why you think they have disappeared but I have used
dbms_system to set these in 10.2
SQL> exec
dbms_system.set_int_param_in_session(34,4175,'sort_area_size',128000);
PL/SQL procedure successfully completed.
SQL> exec
dbms_system.set_bool_param_in_session(34,4175,'timed_statistics',false);
PL/SQL procedure successfully completed.
Have also raised an ER to get string values set but not sure if this
has been done yet
Thanks
*Fairlie Rego
*Senior Oracle Consultant
http://el-caro.blogspot.com/
M: +61 402 792 405
--- On *Mon, 20/7/09, Tony van Lingen
/<tony_vanlingen@xxxxxxxxxxxxxxxxxxxxx>/* wrote:
From: Tony van Lingen <tony_vanlingen@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Change other users session
To: ian.cary@xxxxxxxxxxxxxx, "Oracle-l" <oracle-l@xxxxxxxxxxxxx>
Received: Monday, 20 July, 2009, 9:55 AM
Those handy functions have disappeared in 10gR2 though.. A search
through the dba_source table shows that they've not just moved to
another package, but dropped completely :(
Cheers,
Tony
Ian Cary wrote:
Its a shame you want to change a string value because you can change other
types using
dbms_session.set_bool_param_in_session and
dbms_session.set_int_param_in_session
Not much help I know, but may be worth knowing in the future.
Cheers,
Ian
|---------+----------------------------->
| | Jan-Hendrik.Boll@d|
| | ataport.de |
| | Sent by: |
| | oracle-l-bounce@fr|
| | eelists.org |
| | |
| | |
| | 17/07/2009 12:16 |
| | Please respond to |
| | Jan-Hendrik.Boll |
| | |
|---------+----------------------------->
>--------------------------------------------------------------------------------------------------------------|
|
|
| To: oracle-l@xxxxxxxxxxxxx
|
| cc:
|
| Subject: Change other users session
|
>--------------------------------------------------------------------------------------------------------------|
Hi folks,
is there any way to change the parameters of an other users session?
I want to change the parameter curser_sharing without interrupting the
other sessions jobs.
(Some kind of third-party import-tool )
Any input is appreciated.
regards,
Jan-Hendrik
This email was received from the INTERNET and scanned by the Government
Secure Intranet anti-virus service supplied by Cable&Wireless in
partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In
case of problems, please call your organisation’s IT Helpdesk.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.(See attached file: atthdlm0.dat)
For the latest data on the economy and society consult National Statistics
at http://www.statistics.gov.uk
*********************************************************************************
Please Note: Incoming and outgoing email messages are routinely monitored
for compliance with our policy on the use of electronic communications
*********************************************************************************
Legal Disclaimer : Any views expressed by the sender of this message are
not necessarily those of the Office for National Statistics
*********************************************************************************
The original of this email was scanned for viruses by the Government Secure
Intranet virus scanning service supplied by Cable&Wireless in partnership with
MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email
was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
------------------------------------------------------------------------
Access Yahoo!7 Mail on your mobile. Anytime. Anywhere. Show me how
<http://au.rd.yahoo.com/mail/mobile/tagline/*http://au.mobile.yahoo.com/mail>.
