OraFAQ Forum: Server Administration » Value of parameter from V$parameter

Home » RDBMS Server » Server Administration » Value of parameter from V$parameter

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

Value of parameter from V$parameter [message #227113]

Tue, 27 March 2007 06:19

kukreja
Messages: 33
Registered: February 2007

Member

When i am selecting value for parameter user_dump_dest from v4parameter i am getting some value but when i am seeing value of this parameter in init.ora file it is some other value and i dont have spfile also i m using pfile only.

Report message to a moderator

Re: Value of parameter from V$parameter [message #227116 is a reply to message #227113]

Tue, 27 March 2007 06:26

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post the query you've done and its result.
Post the same query with v$system_parameter instead of v$parameter.
Post the result of "grep user_dump_dest $ORACLE_HOME/dbs/init${ORACLE_SID}.ora" or any other init.ora file you used.

Btw, post your Oracle version (should be a minimum when someone post a question).

Regards
Michel

Report message to a moderator

Re: Value of parameter from V$parameter [message #227129 is a reply to message #227116]

Tue, 27 March 2007 07:11

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

A good idea is probably that you read about the relationships between v$parameter, v$spparameter, pfile etc.

"Google"

Report message to a moderator

Re: Value of parameter from V$parameter [message #227143 is a reply to message #227129]

Tue, 27 March 2007 07:39

kukreja
Messages: 33
Registered: February 2007

Member

I am not using spfile I have only one pfile i.e init.ora file and value of parameter in v$parameter and init.ora is not matching. if I am querying v$spparameter it is blank.

Report message to a moderator

Re: Value of parameter from V$parameter [message #227144 is a reply to message #227143]

Tue, 27 March 2007 07:44

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And you don't have any answer on my questions?

Report message to a moderator

Re: Value of parameter from V$parameter [message #227147 is a reply to message #227143]

Tue, 27 March 2007 07:48

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
There are three files,

TYPE     SPFILE BINARY FILE
NAME     SPFILE<SID>.ORA 
LOCATION $ORACLE_HOME/DATABASE/

TYPE     PFILE ASCII FILE
NAME     INIT<SID>.ORA
LOCATION $ORACLE_HOME/DATABASE/

TYPE     PFILE TEXT FILE
NAME     INIT.ORA
LOCATION $ORACLE_BASE/ADMIN/PFILE/

Now which file are you looking...

regards
Taj

Report message to a moderator

Re: Value of parameter from V$parameter [message #227159 is a reply to message #227116]

Tue, 27 March 2007 08:03

kukreja
Messages: 33
Registered: February 2007

Member

Sorry sir for late reply
select value from v$parameter where name='user_dump_dest'

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
user_dump_dest string
/SLOTS/slot05/appmgr/app/appmg
r05/product/11.1.0/db_1/log/di
ag/rdbms/prodr12/PRODR12/trace

same value is given when i query v$system_parameter
Actually this database was first at 10g and then we upgraded it to 11G so in init.ora it is showing the location of 10G structure
/SLOTS/slot05/appmgr/ProdR12/db/tech_st/10.2.0/admin/ProdR12_ap6020rt/udump

Report message to a moderator

Re: Value of parameter from V$parameter [message #227162 is a reply to message #227159]

Tue, 27 March 2007 08:07

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

To 11G ??

Report message to a moderator

Re: Value of parameter from V$parameter [message #227163 is a reply to message #227162]

Tue, 27 March 2007 08:11

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

To 11G ??
Actaully i also surprised but may be it is Oracle Application.

Report message to a moderator

Re: Value of parameter from V$parameter [message #227164 is a reply to message #227163]

Tue, 27 March 2007 08:12

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Mohammad Taj wrote on Tue, 27 March 2007 15:11

To 11G ??
Actaully i also surprised but may be it is Oracle Application.

Better be

Report message to a moderator

Re: Value of parameter from V$parameter [message #227200 is a reply to message #227159]

Tue, 27 March 2007 09:10

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe you are not starting the database with the init.ora file you think.
How do you start it?

Regards
Michel*

Report message to a moderator

Previous Topic:	problem in sending mails through oracle
Next Topic:	deleted record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:32:30 CDT 2024