Home » RDBMS Server » Server Administration » db_domain
db_domain [message #194345] Thu, 21 September 2006 10:31 Go to next message
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?

Re: db_domain [message #194364 is a reply to message #194345] Thu, 21 September 2006 12:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Whrs v$parameter located?
memeory as other V$Views
Re: db_domain [message #194448 is a reply to message #194345] Fri, 22 September 2006 05:08 Go to previous messageGo to next message
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 ?
Re: db_domain [message #194486 is a reply to message #194448] Fri, 22 September 2006 06:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: db_domain [message #194510 is a reply to message #194345] Fri, 22 September 2006 08:02 Go to previous messageGo to next message
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>
Re: db_domain [message #194525 is a reply to message #194510] Fri, 22 September 2006 09:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create database backup control file to trace as 'myfile';
Re: db_domain [message #194527 is a reply to message #194345] Fri, 22 September 2006 09:08 Go to previous messageGo to next message
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 ?
Re: db_domain [message #194534 is a reply to message #194527] Fri, 22 September 2006 09:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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

Re: db_domain [message #194538 is a reply to message #194527] Fri, 22 September 2006 09:58 Go to previous messageGo to next message
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
Re: db_domain [message #194540 is a reply to message #194345] Fri, 22 September 2006 10:11 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks a lot al of you
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:
  


Current Time: Fri Dec 09 23:15:14 CST 2016

Total time taken to generate the page: 0.13258 seconds