- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 5:03 AM
> Hi ALL,
>
> 1.
> How do I get know memory usage by karnel,application
> programs,Filesystem Cache etc in SunOS 5.6 . I do not
> have the RMC package installed in my m/c
solution :
select a.username, b.value from v$session a, v$sesstat b, v$statname c
where a.sid = b.sid and b.statistic# = c.STATISTIC#
and a.username!='SYSTEM'
- Original Message -
From:
Bjorn
Naessens
To: Multiple recipients of list ORACLE-L
Sent: Monday, Feb
tiple recipients of list ORACLE-LSubject: Re:
memory usage
solution :
select a.username, b.value from v$session a, v$sesstat b, v$statname c
where a.sid = b.sid and b.statistic# = c.STATISTIC#
and a.username!='SYSTEM'
- Original Message -
F
I think the select should have a.username, b.value, c.name
But I am still sure of its usefulness.
Mary Ruiz / Atlanta
-Original Message-
Sent: Tuesday, February 20, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Am I the only one who gets garbage out of this query? There'
add in c.name to get the statistic name that the value corresponds to
select a.username, c.name,b.value from v$session a, v$sesstat b, v$statname
c
where a.sid = b.sid and b.statistic# = c.STATISTIC# and a.username!='SYSTEM'
-Original Message-
Sent: Tuesday, February 20, 2001 7:56
yeah,
forgot to mention it. U have to use c.name or you will get a lot of values
without the meaning of it. Wondering though what they all mean. I only use
pga memory for now.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, February 2
If I'm not mistaken, this figure includes the size of the shared memory
segment from the SGA. Take the output of the "oracle" line of "ipcs -a"
(hopefully you'll only have one!) and subtract it from the process size to
get a better idea of the non-shared memory size of the process.
Rich
Rich Jes
rich
the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08) is used by non shared memory size.
i went thru all the processes and found dbwr using the max %mem. what could be the reason?
sai"Jesse, Rich" <[EMAIL PROTECTED]> wrote:
If I'm not mistaken, this figure includes the size of t
f list ORACLE-L
Sent: Saturday, November 01, 2003 1:34
AM
Subject: RE: memory usage by dbw very
high
rich
the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is
3.08) is used by non shared memory size.
i went thru all the processes and found dbwr using the max %mem. what
f list ORACLE-L
Sent: Saturday, November 01, 2003 1:34 AM
Subject: RE: memory usage by dbw very high
rich
the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08) is
used by non shared memory size.
i went thru all the processes and found dbwr using the max %mem. what
coul
gt; > process or you just guess linux would swap because you don't see "free"
> > memory in top output?
> >
> > Tanel.
> >
> > - Original Message -
> > From: Sai Selvaganesan
> > To: Multiple recipients of list ORACLE-L
> &g
> > Tanel.> >> > - Original Message -> > From: Sai Selvaganesan> > To: Multiple recipients of list ORACLE-L> > Sent: Saturday, November 01, 2003 1:34 AM> > Subject: RE: memory usage by dbw very high> >> >> > rich> > the ipcs
Poder wrote:> > > Just for clarification, do you actually see swapping when starting a new> > > process or you just guess linux would swap because you don't see "free"> > > memory in top output?> > >> > > Tanel.> > >> > > - Origi
e active processes, which will, in
> > > turn. start paging. The only possible response is to eliminate the
> > buffered I/
> > > O and switch to non-buffered I/O. That is not so hard to do.
> > >
> > > On 2003.11.01 09:44, Tanel Poder wrote:
> > > > Just for clarificat
t; Just for clarification, do you actually see swapping when starting a new
> > > process or you just guess linux would swap because you don't see "free"
> > > memory in top output?
> > >
> > > Tanel.
> > >
> > > - Original
> what is meant by OP,tanel..
Original Poster.
Tanel.
On Tru64 Unix there is a tool called SYS_CHECK which you run
which will analyze your system and make recomendations
on tuning parameters. You may have to install it from
the installation CD if not already installed.
-Original Message-
Sent: Friday, October 25, 2002 2:19 PM
To: Multiple re
Peter & List,
This is probably one of the most misunderstood parts of ps... Take a look at
MetaClunk note 174555.1.
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
The manuals for Oracle are here: http://tahiti.oracle.com
The manual for Life is here: http://www.gospelcom.net
We ran into the problem of having an ungodly amount of memory allocated to
each of our users sessions as well. What I had to do was to to into SMITTY
and modify the MBUFFS parameter under the environment. Apparently, if
MBUFFS is set large or wide open , Oracle will take ALL YOU GIVE IT.We
19 matches
Mail list logo
