> what is meant by OP,tanel..
Original Poster.
Tanel.
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
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
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
> > 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
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
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
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
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
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
hi
i have a system that has no active users at this point of time. the memory used by the dbw process is very high leading to a lot of swapping when any process starts.
here are the spces
version:9.2.0.4
os:Linux 2.4.9-e.24smp
o/p from top:
1:44pm up 29 days, 23:55, 4 users, load average: 1.73
unix I've
worked before (solaris, aix, hpux). For example it
does not have the column SR (scan rate).
What do you check in a Tru64 to evaluate memory usage?
how can I read these vmstats output?
-
Virtual Memory Statistics: (pagesize = 8192)
pr
e (solaris, aix, hpux). For example it
does not have the column SR (scan rate).
What do you check in a Tru64 to evaluate memory usage?
how can I read these vmstats output?
-
Virtual Memory Statistics: (pagesize = 8192)
procs memo
Use 'svmon', have a look at the man pages.
-Original Message-
Sent: 29 July 2002 17:25
To: Multiple recipients of list ORACLE-L
Hi,
I have a few Oracle scripts to calculate Total Physical Memory usage by
Oracle at any give time. But I would like to find out Total Memor
Hi,
I have a few Oracle scripts to calculate Total Physical Memory usage by Oracle at any
give time. But I would like to find out Total Memory Usage by ORACLE and NON-ORACLE
processes. I used dmesg in HP system but I do not know for IBM AIX system.
Please let me know if you happen to know
SGA is shared memory so it will show up looking as though the
individual connections are as large as the SGA (or larger, to include
the PGA). In reality they are sharing a large chunk of the memory
ipcs -m will show you the memory segment allocation for the SGA,
subtract that from the memory each
Use need to use pmap feature of Unix in order to see the real RAM associated
with the processes.
Vikas Khanna
Oracle - DBA
-Original Message-
Sent: Wednesday, June 26, 2002 5:45 PM
To: Multiple recipients of list ORACLE-L
Need a little assistance on some "concepts", so to speak..
W
Need a little assistance on some "concepts", so to speak..
When looking at the processes(dedicated connections) of an 816 database on a
UNIX environment-the memory used for each process appears to be the same as
the SGA.
It's been awhile since I had to "dig" into this, but I thought that the
ded
http://www.gospelcom.net
** The opinions and statements above are entirely my own and not those of my
employer or clients **
> -Original Message-
> From: Schauss, Peter [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 21, 2002 1:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject:
Looking at the output from the ps command on AIX I see
that each of the Oracle background processes, user processes
and the lgwr, dbw0, pmon, reco, ckpt ... is listed as using
about 30 mb of memory (based on the SZ column.
1. Does this value represent both data and code?
2. Is there any way to
- 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 p
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
2.
How do I know if the ORACLE is using Raw/UFS ?
3.
If I set _filesystemio_options='directIO' instead of
'async&
connect after the application finish. The memory usage of Oracle.exe process
increases when the Second Web server make connections. But after those
connections drop, the memory decrease very little.
For example, before the second Web server make connections, Oracle.exe uses
200M virtual memory. When
We just recently migrated some production databases from 7.3.4 to 8.1.7.3 on
AIX. We have noticed that the amount of memory per dedicated server process
spiked from about 400k to 2m. Anybody have any ideas about why this occurs?
Is this normal? Thanks
--
Please see the official ORACLE-L FAQ:
Hi All,
A while ago somebody posted a question what the reason could be for very
high memory usage per session. We had the same problem and tracked it back
to bug 762114 yesterday.
SO if that person reads this maybe you have the same problem.
Jack
usage per session.
We have a sort_area_size of 1M and have found sessions that have as much as
200Mb memory usage (Exceptional) and 20-40Mb on regular basis.
TIA
Jack
=
De informatie verzonden in dit e-mailbericht is vertrouwelijk
Hi All,
Can somebody enlighten me what is included in the memory usage per session.
We have a sort_area_size of 1M and have found sessions that have as much as
200Mb memory usage (Exceptional) and 20-40Mb on regular basis.
TIA
Jack
nning activities. Is
anyone out there have similar problem with f45webm memory usage. I remembered
reading something about Oracle server process do not release heap memory when it
was done with it, it was up to the OS to reclaim it. In order words, the heap
side shown is not really what is being used, so
Hi,
The "vmstat -s" command shows the number of revolutions of clock hand. My SA says that
if it increases by 3 or more per minute (i.e. 1 or more per 20
seconds) thhen it indicates a shortage of real memory. I have searched for information
on the clock hand revolutions and have not been able t
for a way to do a manual "top-session" on a database.
According
> to TopSession from Oracle, the information should be located in
v$sessions.
> Anyone an idea how to read the memory usage out of this table? In
v$sess_io
> i'm able to get the amount of physical reads, but I
L PROTECTED]>
Sent: Monday, February 19, 2001 3:25 PM
hello dba's ( again )
i'm looking for a way to do a manual "top-session" on a database. According
to TopSession from Oracle, the information should be located in v$sessions.
Anyone an idea how to read the memory usage
do a manual "top-session" on a database. According to
TopSession from Oracle, the information should be located in v$sessions. Anyone an
idea how to read
the memory usage out of this table? In v$sess_io i'm able to get the amount of
physical reads, but I need the memory usage.
th
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
nt: Monday, February 19, 2001 3:25
PM
hello dba's ( again )
i'm looking for a way to do a manual
"top-session" on a database. According to TopSession from Oracle, the
information should be located in v$sessions. Anyone an idea how to read the
memory usage out o
and Resident
columns, not the Shared one. On solaris, this shows up as a line with
(shmid=0x...) in the Mapped File column. To get a more sensible memory
usage, I suppose that you would have to subtract these from total (the size
is different for background and user processes ) and then add the
Long
pmap seems to include portions of the SGA in the Private and Resident
columns, not the Shared one. On solaris, this shows up as a line with
(shmid=0x...) in the Mapped File column. To get a more sensible memory
usage, I suppose that you would have to subtract these from total (the size
is
Good day,
I am looking at how Oracle and other applications running on a Solaris 2.6
server are using memory. The server has 512 MB of RAM. I issued the
"/usr/proc/bin/pmap $pid" command to display memory usage info and used the
figure from the "total KB" line of the output (
37 matches
Mail list logo