OraFAQ Forum: Server Administration » db

Home » RDBMS Server » Server Administration » db_domain

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

db_domain [message #194345]

Thu, 21 September 2006 10:31

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

select name , value from v$parameter where name = 'db_domain';
Will give value for parameter db_name ,in runtime.

I understand 'db_domain' is a parameter we specify in PFILE.But while executing above query,where it is querying?Whrs v$parameter located?

Report message to a moderator

Re: db_domain [message #194364 is a reply to message #194345]

Thu, 21 September 2006 12:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Whrs v$parameter located?
memeory as other V$Views

Report message to a moderator

Re: db_domain [message #194448 is a reply to message #194345]

Fri, 22 September 2006 05:08

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Stil some doubts....
Whrs V$ datas are coming from? from pfile or control file ?

Report message to a moderator

Re: db_domain [message #194486 is a reply to message #194448]

Fri, 22 September 2006 06:38

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Whrs V$ datas are coming from? from pfile or control file ?
Answers to all your questions are in docuementation.
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2012.htm#REFRN30176
In this case of v$parameter file
< Quoting doc >

Quote:

V$PARAMETER displays information about the initialization parameters that are currently in effect for the session.

< /Quoting doc >
again quoting the doc

Quote:

V$ Views

The actual dynamic performance views are identified by the prefix V_$. Public synonyms for these views have the prefix V$. Database administrators and other users should access only the V$ objects, not the V_$ objects.

The dynamic performance views are used by Enterprise Manager and Oracle Trace, which is the primary interface for accessing information about system performance. After an instance is started, the V$ views that read from memory are accessible. Views that read data from disk require that the database be mounted, and some require that the database be open.

Report message to a moderator

Re: db_domain [message #194510 is a reply to message #194345]

Fri, 22 September 2006 08:02

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

now my doubt is there are some parameters that are not in v$parameter like....
MAXLOGFILES 32 MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1600

Hw can i get current values of this from SQL>

Report message to a moderator

Re: db_domain [message #194525 is a reply to message #194510]

Fri, 22 September 2006 09:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

create database backup control file to trace as 'myfile';

Report message to a moderator

Re: db_domain [message #194527 is a reply to message #194345]

Fri, 22 September 2006 09:08

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Oh,you mean to say there is no other V$views or DDs to get this info ?

Report message to a moderator

Re: db_domain [message #194534 is a reply to message #194527]

Fri, 22 September 2006 09:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Try this method.

http://www.orafaq.com/forum/m/165380/42800/?srch=cool+tricks#msg_165332

Report message to a moderator

Re: db_domain [message #194538 is a reply to message #194527]

Fri, 22 September 2006 09:58

ebrian
Messages: 2794
Registered: April 2006

Senior Member

In addition to Mahesh's method (which is probably the preferred way since the data dictionary can change from release to release), you can also try the following:

SQL> select decode(type,'REDO LOG','MAXLOGFILES',
  2             'DATAFILE','MAXDATAFILES',
  3             'REDO THREAD','MAXINSTANCES',
  4             'LOG HISTORY','MAXLOGHISTORY') "Parameter", records_total
  5  from v$controlfile_record_section
  6     where type in ('REDO LOG','DATAFILE','REDO THREAD','LOG HISTORY')
  7  union
  8  select 'MAXLOGMEMBERS', dimlm
  9     from sys.v_$kccdi;

Parameter     RECORDS_TOTAL
------------- -------------
MAXDATAFILES            100
MAXINSTANCES              1
MAXLOGFILES               5
MAXLOGHISTORY           226
MAXLOGMEMBERS             3

Report message to a moderator

Re: db_domain [message #194540 is a reply to message #194345]

Fri, 22 September 2006 10:11

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Thanks a lot al of you

Report message to a moderator

Previous Topic:	ORA-12154: TNS:could not resolve the connect identifier specified
Next Topic:	How to run the Single Server Multiple instance and Multiple database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:34:05 CDT 2024