OraFAQ Forum: General » Hidden parameters available ?

Home » Other » General » Hidden parameters available ?

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

Hidden parameters available ? [message #284869]

Sun, 02 December 2007 01:39

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hi,

I want to know, In oracle 10g R2 hidden parameters available?

Actually i searched. I can't able to find out.

SQL> select name,value from v$parameter where NAME like '_shared_pool%';

no rows selected

Babu

Report message to a moderator

Re: Hidden parameters available ? [message #284871 is a reply to message #284869]

Sun, 02 December 2007 02:18

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't see hidden parameter through v$parameter.
If you want to know dynamic values query V$SGA_DYNAMIC_COMPONENTS: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2101.htm#sthref4012

Regards
Michel

Report message to a moderator

Re: Hidden parameters available ? [message #284920 is a reply to message #284871]

Sun, 02 December 2007 22:08

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Thank you.

1. If possible to modify hidden parameters in 10g?
2. I want to know Oracle 9i hidden parameters.

Can you explain me.

Babu

[Updated on: Mon, 03 December 2007 00:00]

Report message to a moderator

Re: Hidden parameters available ? [message #285123 is a reply to message #284920]

Mon, 03 December 2007 11:46

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

You are not suppose to Work with HIDDEN parameters until ORACLE SUPPORT tell you to do that.
It could be harmful and pretty much dangerous for your database if you don't know about the parameters and there usage.

Report message to a moderator

Re: Hidden parameters available ? [message #285220 is a reply to message #285123]

Tue, 04 December 2007 00:09

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Thank you.

Babu

Report message to a moderator

Re: Hidden parameters available ? [message #285330 is a reply to message #284869]

Tue, 04 December 2007 04:42

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

select
  ksppinm,
  ksppstvl
from
  x$ksppi a,
  x$ksppsv b
where
  a.indx=b.indx and
  substr(ksppinm,1,1) = '_';

Report message to a moderator

Re: Hidden parameters available ? [message #285332 is a reply to message #284869]

Tue, 04 December 2007 04:44

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

SQL> desc x$ksppsv ;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ADDR                                               RAW(8)
 INDX                                               NUMBER
 INST_ID                                            NUMBER
 KSPPSTVL                                           VARCHAR2(512)
 KSPPSTDVL                                          VARCHAR2(512)
 KSPPSTDF                                           VARCHAR2(9)
 KSPPSTVF                                           NUMBER
 KSPPSTCMNT                                         VARCHAR2(255)

SQL> desc x$ksppi;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ADDR                                               RAW(8)
 INDX                                               NUMBER
 INST_ID                                            NUMBER
 KSPPINM                                            VARCHAR2(80)
 KSPPITY                                            NUMBER
 KSPPDESC                                           VARCHAR2(255)
 KSPPIFLG                                           NUMBER
 KSPPILRMFLG                                        NUMBER
 KSPPIHASH                                          NUMBER

Report message to a moderator

Re: Hidden parameters available ? [message #285372 is a reply to message #285330]

Tue, 04 December 2007 05:41

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Arju,
We all (senior DBA) know this query, if we didn't post it this is because it is dangerous.
It is useless to know these parameters and values unless you have a specicic problem and support tells you what to get and what to set.

You don't help anyone with this but you put in danger many.

Regards
Michel

[Updated on: Tue, 04 December 2007 23:25]

Report message to a moderator

Re: Hidden parameters available ? [message #285388 is a reply to message #285372]

Tue, 04 December 2007 06:28

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I didn't know about it...but then again: I'm not a DBA and I think Michel is right here. Fiddling with hidden parameters will cause you to loose help from Oracle Support.

MHE

Report message to a moderator

Re: Hidden parameters available ? [message #285489 is a reply to message #284869]

Tue, 04 December 2007 21:49

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

2. I want to know Oracle 9i hidden parameters.

I answered only to satisfy his requirement. Nothing else then that.

You already told about restriction of hidden parameter and scope of it in the prior topic before my previous topic of this thread.

Thank you.

Report message to a moderator

Re: Hidden parameters available ? [message #285491 is a reply to message #284869]

Tue, 04 December 2007 21:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I answered only to satisfy his requirement. Nothing else then that.
By that (il)logic you should be posting Metalink Notes when asked
You are under NO obligation to provide ANYTHING!

Report message to a moderator