Re: memory usage by dbw very high
what is meant by OP,tanel.. Original Poster. Tanel.
Re: memory usage by dbw very high
hi tanel and mladen not every time a process is started does it swap but sometimes swapping does happen.(this is from the top o/p which shows a increase in the memory used in swap.).how do we check whether a single process swaps or not? and the dbw process is using more % of memory than a couple of days back.(o/p pf ps aux). is this how linux kernel works or is there something else i can check. thanks sai what is meant by OP,tanel.. Tanel Poder [EMAIL PROTECTED] wrote: Thanks Mladen, that was a good tip about linux kernel enhancement, howeverOP still uses 2.4.9 as stated in original post.I just wanted to know whether OP actually sees excessive paging or justmemory being "full", the latter one, as you know, isn't really a problem.Tanel.- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Saturday, November 01, 2003 5:39 PM The whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserFS or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing! pages from the active processes, which will, in turn. start paging. The only possible response is to eliminate thebuffered 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 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 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 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 reason? sai "Jesse, Rich" <[EMAIL PROTECTED]>wrote: If I'm not mistaken, this figure includes the size of the sharedmemory 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 processsize to get a better idea of the non-shared memory size of the process. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-Lhi 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 swappingwhen 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, 1.68, 1.35 132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle CPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idle CPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle CPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idle Mem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448K buff Swap: 2048152K av, 1652K used, 2046500K free 1852468K cached sga size: Total System Global Area 1084823632 bytes Fixed! Size 452688 bytes Variable Size 335544320 bytes Database Buffers 738197504 bytes Redo Buffers 10629120 bytes pga aggregate size:700M and ps o/p of dbw process USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND oracle 4062 0.0 16.4 1131260 508168 ? S 10:16 0:06 ora_dbw0_revenue please advise. what is really going on. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services- To REMOVE yourself from this mailing list, send a! n E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, i
Re: memory usage by dbw very high
mladen i have gtop...and i am trying to get thru the preferences which u have mentioned. 1. can you please help me to find the kernel mode for the processes. 2. on this linux box i see that demon kswapd and bdflush in the process list.should they always be running or do they get intiated only when paging or swapping happens. thanks sai Mladen Gogala [EMAIL PROTECTED] wrote: What we have here is a confusion with terminology. Process cannot "be swapping". When there is a serious shortage of memory, the swap demon(yes, your Unix box is haunted) known by the horrible name of [kswapd] writes the whole address space space belonging to the process onto swap. At that point, process is swapped.Unless, we are talking about the kswapd process, the process cannot "be swapping". Kernelswap demon seldomly uses oracle database.Process can be paging. When there is serious shortage of memory (but less serious then inthe first case), pages are stolen from the process and written onto the swap. It's called"page replacement". When processes need pages that have been thrown out of memory by the page replacement demon (in case of Linux, it's called bdflush but on some unix implementations,there is a process called "updated" or ! "paged " which performs this function.), it pages them in.If the page is in memory (buffer cache would a good place to look), we're talking about the soft page fault. If the page has to be read from the disk, we're talking about hard pagefault. Processes that page get charged for a lot of CPU time, all of it in the kernel mode.If you have gtop (my kindest advice is to get it), you can set preferences and see kernel modefor the processes. Ones consuming large amounts of the kernel mode are ones that are paging.On 11/03/2003 01:24:27 PM, Sai Selvaganesan wrote: hi tanel and mladen not every time a process is started does it swap but sometimes swapping does happen.(this is from the top o/p which shows a increase in the memory used in swap.).how do we check whether a single process swaps or not? and the dbw process is using more % of memory than a couple of days back.(o/p pf ps aux). is this how linux kernel works or is th! ere something else i can check. thanks sai what is meant by OP,tanel.. Tanel Poder <[EMAIL PROTECTED]>wrote: Thanks Mladen, that was a good tip about linux kernel enhancement, however OP still uses 2.4.9 as stated in original post. I just wanted to know whether OP actually sees excessive paging or just memory being "full", the latter one, as you know, isn't really a problem. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" Sent: Saturday, November 01, 2003 5:39 PMThe whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserF! S or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing pages from the 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 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 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 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" wrote: 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 System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Su! ssex, WI USA -Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-L 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, 1.68, 1.35 132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 24.4% user, 2.2% system,
Re: memory usage by dbw very high
Preferences-Process Fields-STime, UTime. On 11/03/2003 02:44:34 PM, Sai Selvaganesan wrote: mladen i have gtop...and i am trying to get thru the preferences which u have mentioned. 1. can you please help me to find the kernel mode for the processes. 2. on this linux box i see that demon kswapd and bdflush in the process list.should they always be running or do they get intiated only when paging or swapping happens. thanks sai Mladen Gogala [EMAIL PROTECTED] wrote: What we have here is a confusion with terminology. Process cannot be swapping. When there is a serious shortage of memory, the swap demon (yes, your Unix box is haunted) known by the horrible name of [kswapd] writes the whole address space space belonging to the process onto swap. At that point, process is swapped. Unless, we are talking about the kswapd process, the process cannot be swapping. Kernel swap demon seldomly uses oracle database. Process can be paging. When there is serious shortage of memory (but less serious then in the first case), pages are stolen from the process and written onto the swap. It's called page replacement. When processes need pages that have been thrown out of memory by the page replacement demon (in case of Linux, it's called bdflush but on some unix implementations, there is a process called updated or paged which performs this function.), it pages them in. If the page is in memory (buffer cache would a good place to look), we're talking about the soft page fault. If the page has to be read from the disk, we're talking about hard page fault. Processes that page get charged for a lot of CPU time, all of it in the kernel mode. If you have gtop (my kindest advice is to get it), you can set preferences and see kernel mode for the processes. Ones consuming large amounts of the kernel mode are ones that are paging. On 11/03/2003 01:24:27 PM, Sai Selvaganesan wrote: hi tanel and mladen not every time a process is started does it swap but sometimes swapping does happen.(this is from the top o/p which shows a increase in the memory used in swap.).how do we check whether a single process swaps or not? and the dbw process is using more % of memory than a couple of days back.(o/p pf ps aux). is this how linux kernel works or is there something else i can check. thanks sai what is meant by OP,tanel.. Tanel Poder wrote: Thanks Mladen, that was a good tip about linux kernel enhancement, however OP still uses 2.4.9 as stated in original post. I just wanted to know whether OP actually sees excessive paging or just memory being full, the latter one, as you know, isn't really a problem. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Saturday, November 01, 2003 5:39 PM The whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserFS or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing pages from the 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 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 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 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 wrote: 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 System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-L 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
Re: memory usage by dbw very high
What we have here is a confusion with terminology. Process cannot be swapping. When there is a serious shortage of memory, the swap demon (yes, your Unix box is haunted) known by the horrible name of [kswapd] writes the whole address space space belonging to the process onto swap. At that point, process is swapped. Unless, we are talking about the kswapd process, the process cannot be swapping. Kernel swap demon seldomly uses oracle database. Process can be paging. When there is serious shortage of memory (but less serious then in the first case), pages are stolen from the process and written onto the swap. It's called page replacement. When processes need pages that have been thrown out of memory by the page replacement demon (in case of Linux, it's called bdflush but on some unix implementations, there is a process called updated or paged which performs this function.), it pages them in. If the page is in memory (buffer cache would a good place to look), we're talking about the soft page fault. If the page has to be read from the disk, we're talking about hard page fault. Processes that page get charged for a lot of CPU time, all of it in the kernel mode. If you have gtop (my kindest advice is to get it), you can set preferences and see kernel mode for the processes. Ones consuming large amounts of the kernel mode are ones that are paging. On 11/03/2003 01:24:27 PM, Sai Selvaganesan wrote: hi tanel and mladen not every time a process is started does it swap but sometimes swapping does happen.(this is from the top o/p which shows a increase in the memory used in swap.).how do we check whether a single process swaps or not? and the dbw process is using more % of memory than a couple of days back.(o/p pf ps aux). is this how linux kernel works or is there something else i can check. thanks sai what is meant by OP,tanel.. Tanel Poder [EMAIL PROTECTED] wrote: Thanks Mladen, that was a good tip about linux kernel enhancement, however OP still uses 2.4.9 as stated in original post. I just wanted to know whether OP actually sees excessive paging or just memory being full, the latter one, as you know, isn't really a problem. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Saturday, November 01, 2003 5:39 PM The whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserFS or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing pages from the 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 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 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 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 wrote: 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 System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-L 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, 1.68, 1.35 132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle CPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idle CPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle CPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idle Mem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448K buff Swap: 2048152K av, 1652K used, 2046500K free 1852468K cached sga size: Total System Global Area
Re: memory usage by dbw very high
Thanks Mladen, that was a good tip about linux kernel enhancement, however OP still uses 2.4.9 as stated in original post. I just wanted to know whether OP actually sees excessive paging or just memory being full, the latter one, as you know, isn't really a problem. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 01, 2003 5:39 PM The whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserFS or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing pages from the 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 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 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 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 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 System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-L 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, 1.68, 1.35 132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle CPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idle CPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle CPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idle Mem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448K buff Swap: 2048152K av, 1652K used, 2046500K free 1852468K cached sga size: Total System Global Area 1084823632 bytes Fixed Size 452688 bytes Variable Size 335544320 bytes Database Buffers 738197504 bytes Redo Buffers 10629120 bytes pga aggregate size:700M and ps o/p of dbw process USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND oracle 4062 0.0 16.4 1131260 508168 ? S 10:16 0:06 ora_dbw0_revenue please advise. what is really going on. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
Re: memory usage by dbw very high
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 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 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 shared memorysegment 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 toget a better idea of the non-shared memory size of the process.RichRich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message-Sent: Friday, October 31, 2003 3:49 PMTo: Multiple recipients of list ORACLE-Lhii have a system that has no active users at this point of time. the memoryused by the dbw process is very high leading to a lot of swapping when anyprocess starts.here are the spcesversion:9.2.0.4os:Linux 2.4.9-e.24smpo/p from top:1:44pm up 29 days, 23:55, 4 users, load average: 1.73, 1.68, 1.35132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stoppedCPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idleCPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idleCPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idleCPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idleMem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448KbuffSwap: 2048152K av, 1652K used, 2046500K free 1852468Kcachedsga size:Total System Global Area 1084823632 bytesFixed Size 452688 bytesVariable Size 335544320 bytesDatabase Buffers 738197504 bytesRedo Buffers 10629120 bytespga aggregate size:700Mand ps o/p of dbw processUSER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMANDoracle 4062 0.0 16.4 1131260 508168 ? S 10:16 0:06ora_dbw0_revenueplease advise. what is really going on.thankssai-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jesse, RichINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: memory usage by dbw very high
The whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserFS or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing pages from the 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 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 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 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 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 System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-L 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, 1.68, 1.35 132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle CPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idle CPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle CPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idle Mem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448K buff Swap: 2048152K av, 1652K used, 2046500K free 1852468K cached sga size: Total System Global Area 1084823632 bytes Fixed Size 452688 bytes Variable Size 335544320 bytes Database Buffers 738197504 bytes Redo Buffers 10629120 bytes pga aggregate size:700M and ps o/p of dbw process USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND oracle 4062 0.0 16.4 1131260 508168 ? S 10:16 0:06 ora_dbw0_revenue please advise. what is really going on. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: memory usage by dbw very high
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 System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-L 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, 1.68, 1.35 132 processes: 131 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle CPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idle CPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle CPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idle Mem: 3089964K av, 3083380K used,6584K free, 846848K shrd, 193448K buff Swap: 2048152K av,1652K used, 2046500K free 1852468K cached sga size: Total System Global Area 1084823632 bytes Fixed Size 452688 bytes Variable Size 335544320 bytes Database Buffers 738197504 bytes Redo Buffers 10629120 bytes pga aggregate size:700M and ps o/p of dbw process USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND oracle4062 0.0 16.4 1131260 508168 ?S10:16 0:06 ora_dbw0_revenue please advise. what is really going on. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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"Jesse, Rich" [EMAIL PROTECTED] wrote: If I'm not mistaken, this figure includes the size of the shared memorysegment 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 toget a better idea of the non-shared memory size of the process.RichRich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message-Sent: Friday, October 31, 2003 3:49 PMTo: Multiple recipients of list ORACLE-Lhii have a system that has no active users at this point of time. the memoryused by the dbw process is very high leading to a lot of swapping when anyprocess starts.here are the spcesversion:9.2.0.4os:Linux 2.4.9-e.24smpo/p from top:1:44pm up 29 days, 23:55, 4 users, load average: 1.73, 1.68, 1.35132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stoppedCPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idleCPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idleCPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idleCPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idleMem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448KbuffSwap: 2048152K av, 1652K used, 2046500K free 1852468Kcachedsga size:Total System Global Area 1084823632 bytesFixed Size 452688 bytesVariable Size 335544320 bytesDatabase Buffers 738197504 bytesRedo Buffers 10629120 bytespga aggregate size:700Mand ps o/p of dbw processUSER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMANDoracle 4062 0.0 16.4 1131260 508168 ? S 10:16 0:06ora_dbw0_revenueplease advise. what is really going on.thankssai-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jesse, RichINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Memory usage control in Tru64 - urgent !!!
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 recipients of list ORACLE-L Hi!! I'm trying to see if a unix machine is having performance problem with any resources: cpu, disk and memory. When I started analyzing the memory statistics, taken previously with vmstat I realized that it's columns are completely different from any other 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) procs memorypages intr cpu r w u act free wire fault cow zero react pin pout in sy cs us sy id 12 757 216 304K 140K 65K 640M 87M 398M 156K 118M 1853 1K 5K 4K 2 5 93 8 761 216 302K 142K 65K 14190 1730 10K 0 1903 0 772 1K 2K 1 2 97 9 764 216 304K 140K 65K 9376 532 7686 0 253 0 612 376 1K 0 1 98 - I'd appreciate any help thanks in advance Pablo. ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20Rodriguez?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kurth, Michael J. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Memory usage by an Oracle instance
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 ** 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 instance 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 determine how much (if any) of the memory listed here is in the form of shared libraries or shared memory segments? Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MEMORY USAGE
- 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 think that you can use /usr/proc/bin/pmap pid This will display the memmory map for a process. Detailing shared memory, shared libraries, code, etc. Here you have an example: 25431: ora_lgwr_PRUE73 0001 8312K read/exec /u01/app/oracle/product/7.3.4/bin/oracle 0083D000 76K read/write/exec /u01/app/oracle/product/7.3.4/bin/oracle 0085140K read/write/exec [ heap ] 8000 6440K read/write/exec/shared [ shmid=0x578 ] 8064A000 4K read/shared[ shmid=0x578 ] 8064B000160K read/write/exec/shared [ shmid=0x578 ] 80673000 4K read/shared[ shmid=0x578 ] 80674000 4K read/write/exec/shared [ shmid=0x578 ] EF5A 12K read/exec /usr/lib/libmp.so.2 EF5B2000 4K read/write/exec /usr/lib/libmp.so.2 2. How do I know if the ORACLE is using Raw/UFS ? Check in dba_data_files (dba_temp_files if you're using temporary tablespace Oracle 8i onwards), v$controlfile , v$logfile the locations of the files. After this, go and take a look to these files with the comand file: oracle:/u01/oradata/RAW81 file raw_data01.dbf raw_data01.dbf: character special (32/39) oracle:/u02/oradata/PRUE73 file data1_01.dbf data1_01.dbf: data 3. If I set _filesystemio_options='directIO' instead of 'async' will that save memory consumption and improve performance ? It depends on the tipe of datafiles you're using. If your database is on FS, and you mount your FS with forcedirectio option, you can set set _filesystemio_options='directIO' and you'll be using direct io for the FS datafiles. This will save you memory and will boost your performance. If you're on Raw devices you should use Async I/O (KAIO in solaris to be precise) HTH Greetings Diego Cutrone Any suggestion ...Thanks in advance __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Memory Usage per Session on AIX 4.3.2 Oracle 8.0.5
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 had MBUFFS set to 65 Megs, so each oracle session was allocated , at a minimum, 65 megs. Used up memeory real fast. -Original Message- Sent: Thursday, June 07, 2001 9:16 AM To: Multiple recipients of list ORACLE-L 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 = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Naessens To: Multiple recipients of list ORACLE-L 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 out of this table? In v$sess_io i'm able to get the amount of physical reads, but I need the memory usage. thanks for any help Bjorn Naessens Roularta IT Solutions
RE: memory usage
Am I the only one who gets garbage out of this query? There's a mismatch on v$statname. Which statistic are you suggesting to display, uga or pga memory? -Original Message-From: Bjorn Naessens [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 20, 2001 5:15 AMTo: Multiple 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 Naessens To: Multiple recipients of list ORACLE-L 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 out of this table? In v$sess_io i'm able to get the amount of physical reads, but I need the memory usage. thanks for any help Bjorn Naessens Roularta IT Solutions
RE: memory usage
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 PM To: Multiple recipients of list ORACLE-L Am I the only one who gets garbage out of this query? There's a mismatch on v$statname. Which statistic are you suggesting to display, uga or pga memory? -Original Message- Sent: Tuesday, February 20, 2001 5:15 AM To: Multiple recipients of list ORACLE-L 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 - To: Multiple recipients of list ORACLE-L mailto:[EMAIL 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 out of this table? In v$sess_io i'm able to get the amount of physical reads, but I need the memory usage. thanks for any help Bjorn Naessens Roularta IT Solutions -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).