OraFAQ Forum: Server Administration » current value of maxlogmembers

Home » RDBMS Server » Server Administration » current value of maxlogmembers

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

current value of maxlogmembers [message #165332]

Wed, 29 March 2006 07:52

k_talino
Messages: 9
Registered: January 2006
Location: Spain

Junior Member

Goodday,
I am looking for a select statement on how to find out, what the current value is of the maxlogmembers in my database.

Report message to a moderator

Re: current value of maxlogmembers [message #165336 is a reply to message #165332]

Wed, 29 March 2006 08:09

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

I will explain you one way.

Alter database backup controlfile to trace;

Select p.spid "SPID" from v$session s , V$process p where s.paddr=s.paddr and s.sid=(select sid from V$mystat where rownum=1);

Show parameter user_dump_dest;

Record the SPID and go to the directory specified in the initialization parameter user_dump_dest.

Sort the files by date.

On the top you can find a trace file. (That trace filename includes SPID)

In that file you can find the value of maxlogmembers.

Rgds
SALIH KM Cool

Report message to a moderator

Re: current value of maxlogmembers [message #165339 is a reply to message #165336]

Wed, 29 March 2006 08:44

k_talino
Messages: 9
Registered: January 2006
Location: Spain

Junior Member

yea, but I am looking for a select statement more or less equal:

Select record_total
from v$controlfile_record_section
where type='REDO LOG'

for MAXLOGFILES

but for MAXLOGMEMBERS

thx

Report message to a moderator

Re: current value of maxlogmembers [message #165349 is a reply to message #165339]

Wed, 29 March 2006 09:12

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

Senior Member
Account Moderator

sys@9i > select dimlm from x$kccdi;

     DIMLM
----------
         3

sys@9i > alter database backup controlfile to trace as '/tmp/mytracefile';

Database altered.

sys@9i > !cat /tmp/mytracefile | grep MAXLOGMEMBERS
    MAXLOGMEMBERS 3
    MAXLOGMEMBERS 3

Report message to a moderator

Re: current value of maxlogmembers [message #165353 is a reply to message #165349]

Wed, 29 March 2006 09:28

k_talino
Messages: 9
Registered: January 2006
Location: Spain

Junior Member

Yeaa,,

thx for all

Mahesh Rajendran wrote on Wed, 29 March 2006 09:12

sys@9i > select dimlm from x$kccdi;

     DIMLM
----------
         3

sys@9i > alter database backup controlfile to trace as '/tmp/mytracefile';

Database altered.

sys@9i > !cat /tmp/mytracefile | grep MAXLOGMEMBERS
    MAXLOGMEMBERS 3
    MAXLOGMEMBERS 3

Report message to a moderator

Re: current value of maxlogmembers [message #165380 is a reply to message #165332]

Wed, 29 March 2006 13:30

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Hehe, Mahesh knows all the cool tricks.

I suppose you could also:

create a new group
repeat add a member until error

Report message to a moderator

Re: current value of maxlogmembers [message #165391 is a reply to message #165380]

Wed, 29 March 2006 16:38

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

Senior Member
Account Moderator

Only after replying, something came to my mind

Oracle Doc says:

Your operating system specific Oracle documentation for the default and legal values of the MAXLOGFILES and MAXLOGMEMBERS parameters

But there is not much to guess here about MAXLOGMEMBERS.
There need to be

Minimum 1 (obviously) -all platforms
Default 2 - in most platforms
Maximum 5 - all platforms.

I may be wrong. I haven't checked any docs yet.

[Updated on: Wed, 29 March 2006 18:15]

Report message to a moderator

Re: current value of maxlogmembers [message #165666 is a reply to message #165353]

Fri, 31 March 2006 06:07

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Yeeah!!!!!

It's is new stuff for me.

Is there any data dictionary that gives information about listeners and sqlnet.ora?

Thanks & Regards
SALIH KM Cool

Report message to a moderator

Re: current value of maxlogmembers [message #165684 is a reply to message #165666]

Fri, 31 March 2006 07:21

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

Senior Member
Account Moderator

Nothing that i know of.
These are external files that deal with the client connectivity.
Nothing to do with Data Dictionary. So i would not even expect any.

Report message to a moderator

Previous Topic:	Version Details
Next Topic:	SPFILE or pfile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 03:00:08 CST 2025