what is meant by OP,tanel..
Original Poster.
Tanel.
t ORACLE-L Sent: Saturday, November 01, 2003 1:34 AM Subject: RE: memory usage by dbw very highrich 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 u!
sing the
max %mem. what could be the
ssage - 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 output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08) is used by non shared memory size. i went
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
Sent: Saturday, November 01, 2003 1:34 AM
Subject: RE: memory usage by dbw
, 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
could
be the reason?
sai
output?
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 output shows 1.1 gb. so nearly 2 gb(total ram size
t 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. wha
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
could
be the reason?
sai
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,
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 Jesse
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 the
, 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 memorypages
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)
procs memory
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
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 Memory Usage
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
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..
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
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
** 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: Memory usage by an Oracle
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' will that save
- 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
I
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
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
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
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
. 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, sort
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
, 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 of this table? In v$s
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 -
From:
Bjorn
, 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 of this table? In v$sess_io
i'm a
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
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 o
34 matches
Mail list logo
