OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Instance Parameter (10g R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Instance Parameter [message #424717]

Mon, 05 October 2009 10:03

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.

Report message to a moderator

Re: Instance Parameter [message #424719 is a reply to message #424717]

Mon, 05 October 2009 10:13

Michel Cadot
Messages: 68665
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

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.

Report message to a moderator

Re: Instance Parameter [message #424946 is a reply to message #424943]

Tue, 06 October 2009 11:41

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?

Report message to a moderator

Re: Instance Parameter [message #424993 is a reply to message #424946]

Wed, 07 October 2009 00:48

Michel Cadot
Messages: 68665
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

ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON

Member

I am sorry.

Report message to a moderator

Previous Topic:	erroneous synonym
Next Topic:	Oracle 11g/R12 database applying patch

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 07:01:38 CDT 2024