Home » RDBMS Server » Server Administration » Instance Parameter (10g R2)
Instance Parameter [message #424717] Mon, 05 October 2009 10:03 Go to next message
TRaj
Messages: 82
Registered: September 2006
Member

Dear All,

Is it possible changing a paramater value in another session? For ex: I need to change db_file_multiblock_read_count to 32 from 16 in another session.

Thanks.
Re: Instance Parameter [message #424719 is a reply to message #424717] Mon, 05 October 2009 10:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
What problem are you trying to solve?

Regards
Michel

[Updated on: Mon, 05 October 2009 10:14]

Report message to a moderator

Re: Instance Parameter [message #424943 is a reply to message #424717] Tue, 06 October 2009 11:34 Go to previous messageGo to next message
ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON
Member

Hi,

I think it's impossible. NLS parameters can be set at the database, instance and session level.
Re: Instance Parameter [message #424946 is a reply to message #424943] Tue, 06 October 2009 11:41 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
ursusca wrote on Tue, 06 October 2009 12:34

I think it's impossible. NLS parameters can be set at the database, instance and session level.

I'm not sure what this has to do with the OP's question?
Re: Instance Parameter [message #424993 is a reply to message #424946] Wed, 07 October 2009 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ebrian wrote on Tue, 06 October 2009 18:41
ursusca wrote on Tue, 06 October 2009 12:34

I think it's impossible. NLS parameters can be set at the database, instance and session level.

I'm not sure what this has to do with the OP's question?

But I'm pretty sure this does not add anything to first answer (in OP's point of view).

Regards
Michel

[Updated on: Wed, 07 October 2009 00:49]

Report message to a moderator

Re: Instance Parameter [message #425142 is a reply to message #424717] Wed, 07 October 2009 14:31 Go to previous message
ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON
Member

I am sorry.
Previous Topic: erroneous synonym
Next Topic: Oracle 11g/R12 database applying patch
Goto Forum:
  


Current Time: Sun Dec 11 02:19:27 CST 2016

Total time taken to generate the page: 0.18135 seconds