Re: Memory consumption on HP-UX
Hi Helmut, Notice the parameter is called pga_aggregate_TARGET and not pga_aggregate_MAX_SIZE. That's because the P_A_T is just that, a target the Oracle does it's best to not exceed. It does this by controlling and rationing the tuneable component of the PGA (ie. those portions of the PGA previously controlled by the *_AREA_SIZE parameters) on a as need/on demand basis based on current system load. However, if the number of sessions/processes is such that the other non-tuneable components of the PGAs were to put pressure on the P_A_T, then Oracle may have no choice but to exceed it. This is not a good thing in that obviously more PGA memory is allocated that you ideally want and also because the workarea operations are not going to be the ideal optimal executions you're after. Increasing the P_A_T would be therefore be recommended, depending of course on your available memory. v$pgastat, v$pga_target_advice and v$process will give you useful info on how much you may have exceeded your P_A_T. Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 7:54 PM Hi, how do I find out how much memory Oracle uses on an HP-UX box? Finding the shared memory portion (i.e. SGA) is fairly easy... But how do I find out how much memory each dedicated user process is consuming? Or is the rule of thumb like this: no matter whether you have 10 or 500 users, the memory consumed by the user processes will never exceed pg_aggregate_target? This would mean that the maximum memory consumption is SGA + PGA_AGGREGATE_TARGET. No matter how many users are on the system (of course you would size PGA_aggregate_target accordingly beforehand). This is 9.2 on HP-UX 11. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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 consumption on HP-UX
Use glance if you have that package installed, look for ps -ef | grep midaemon Allan -Original Message- Sent: Tuesday, November 11, 2003 3:54 AM To: Multiple recipients of list ORACLE-L Hi, how do I find out how much memory Oracle uses on an HP-UX box? Finding the shared memory portion (i.e. SGA) is fairly easy... But how do I find out how much memory each dedicated user process is consuming? Or is the rule of thumb like this: no matter whether you have 10 or 500 users, the memory consumed by the user processes will never exceed pg_aggregate_target? This would mean that the maximum memory consumption is SGA + PGA_AGGREGATE_TARGET. No matter how many users are on the system (of course you would size PGA_aggregate_target accordingly beforehand). This is 9.2 on HP-UX 11. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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 consumption on HP-UX
Take care with automatic PGA management. We have TNS12500 HPUX err 12 using it because proceses RESERVING lots of swap. We change to manual PGA (we use sort_area_size, etc.) It was on 9.2.0.1 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Richard Foote Enviado el: martes, 11 de noviembre de 2003 13:35 Para: Multiple recipients of list ORACLE-L Asunto: Re: Memory consumption on HP-UX Hi Helmut, Notice the parameter is called pga_aggregate_TARGET and not pga_aggregate_MAX_SIZE. That's because the P_A_T is just that, a target the Oracle does it's best to not exceed. It does this by controlling and rationing the tuneable component of the PGA (ie. those portions of the PGA previously controlled by the *_AREA_SIZE parameters) on a as need/on demand basis based on current system load. However, if the number of sessions/processes is such that the other non-tuneable components of the PGAs were to put pressure on the P_A_T, then Oracle may have no choice but to exceed it. This is not a good thing in that obviously more PGA memory is allocated that you ideally want and also because the workarea operations are not going to be the ideal optimal executions you're after. Increasing the P_A_T would be therefore be recommended, depending of course on your available memory. v$pgastat, v$pga_target_advice and v$process will give you useful info on how much you may have exceeded your P_A_T. Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 7:54 PM Hi, how do I find out how much memory Oracle uses on an HP-UX box? Finding the shared memory portion (i.e. SGA) is fairly easy... But how do I find out how much memory each dedicated user process is consuming? Or is the rule of thumb like this: no matter whether you have 10 or 500 users, the memory consumed by the user processes will never exceed pg_aggregate_target? This would mean that the maximum memory consumption is SGA + PGA_AGGREGATE_TARGET. No matter how many users are on the system (of course you would size PGA_aggregate_target accordingly beforehand). This is 9.2 on HP-UX 11. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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 consumption on HP-UX
Hi Juan, We encountered the same problem. Issue was due to OS being set in Eager swapping mode. Support viewed the fact it reserved a massive amount of swap as a feature. However, after switching the OS (HP 5.1 TRU64) to Lazy swap mode, the problem (as one would hope) disappeared and we haven't looked back. We have about 32G of swap disk doing nothing :) Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:14 AM Take care with automatic PGA management. We have TNS12500 HPUX err 12 using it because proceses RESERVING lots of swap. We change to manual PGA (we use sort_area_size, etc.) It was on 9.2.0.1 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Richard Foote Enviado el: martes, 11 de noviembre de 2003 13:35 Para: Multiple recipients of list ORACLE-L Asunto: Re: Memory consumption on HP-UX Hi Helmut, Notice the parameter is called pga_aggregate_TARGET and not pga_aggregate_MAX_SIZE. That's because the P_A_T is just that, a target the Oracle does it's best to not exceed. It does this by controlling and rationing the tuneable component of the PGA (ie. those portions of the PGA previously controlled by the *_AREA_SIZE parameters) on a as need/on demand basis based on current system load. However, if the number of sessions/processes is such that the other non-tuneable components of the PGAs were to put pressure on the P_A_T, then Oracle may have no choice but to exceed it. This is not a good thing in that obviously more PGA memory is allocated that you ideally want and also because the workarea operations are not going to be the ideal optimal executions you're after. Increasing the P_A_T would be therefore be recommended, depending of course on your available memory. v$pgastat, v$pga_target_advice and v$process will give you useful info on how much you may have exceeded your P_A_T. Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 7:54 PM Hi, how do I find out how much memory Oracle uses on an HP-UX box? Finding the shared memory portion (i.e. SGA) is fairly easy... But how do I find out how much memory each dedicated user process is consuming? Or is the rule of thumb like this: no matter whether you have 10 or 500 users, the memory consumed by the user processes will never exceed pg_aggregate_target? This would mean that the maximum memory consumption is SGA + PGA_AGGREGATE_TARGET. No matter how many users are on the system (of course you would size PGA_aggregate_target accordingly beforehand). This is 9.2 on HP-UX 11. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego
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 swapping and rollback
David, Commit frequency can help or hurt performance. The more often you commit, the more often undo blocks will be reused. This will also cause the log buffer and committed blocks in the buffer cache to be flushed. If you commit less often, these actions happen less often, but undo blocks will not be reused as often. This could cause space management problems if there is not enough space in the tablespace or other processes are causing rollback segments to shrink. The short version is that frequent commits = additional housekeeping (impact can't be known exactly until tested) and infrequent commits = additional space allocation (impact can't be exactly known until tested). The issue of swapping is not related to rollback. I have not tested the merge, but it may be doing some sorting. When it exceeds your sort_area_size in memory it begins to write sort runs to disk (temporary tablespace). Is this what they mean by swapping? The best approach (IMHO) is to go back to the critics and ask for more detailed information, including the logic and scenarios describing the logic. Daniel Fink David Turner wrote: I was presenting a new load process and I am using straight merge selects from external tables and one of the complaints that came up was that Performance would be worse because I wasn't committing more frequently. If my merge was too large memory swapping would occur and it was possibly related to rollback. I said I was not aware of this and would look into it but I had never heard of this before and couldn't find any information on this so of course I'm sending mail to the list. Both items sound bogus to me. I've really never heard where committing more frequently on a load would help performance in any way. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Turner 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).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: Memory strangeness on Win2k
You need to increase value for SGA_MAX_SIZE parameter. Ashish OCP DBA -Original Message- Baumgartel Sent: Friday, April 04, 2003 5:04 PM To: Multiple recipients of list ORACLE-L So I have DB (9.2.0.1) running on Win2K, with db_cache_size of 32M. Windows Task Manager shows 600+ MB of free physical memory. ALTER SYSTEM SET DB_CACHE_SIZE=50248000 SCOPE=BOTH fails with ORA-00384: Insufficient memory to grow cache. I'm going to try ...SCOPE=SPFILE, then bouncing the instance, but any other ideas would be appreciated. I really prefer running Oracle on Unix. TIA, Paul Baumgartel __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ashish 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 taken by s session
Title: RE: Memory taken by s session Hi, I explored the view v$sesstat. What I wanted to ask was whether the column VALUE in this shows bytes or what? Because if it is bytes then I can make out from combining the two views, i.e. v$sesstat and v$statname as to how much memory (pga, uga) is taken by every session. What I forgot to mention earlier was that we are using MTS. The PGA memory and maximum PGA memory remains more or less the same for every session opened, but UGA memory changes with some work. But even that is not consistent, I mean UGA memory doesn't always change with every query I run from that session. Any explanation as to why? Regards, Hussain -Original Message- From: chao_ping [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 22, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Memory taken by s session Hussain Ahmed Qadri, hi, from oracle, you can get it from v$sesstat, in oracle9i ,you can even get the more detailed data from v$process. From Unix os, for solaris, you can use pmap, on linux, you can use /proc/spid/status. FOr other os, I hope others can share there experience. Good luck Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org(China Oracle User Group) === 2003-03-22 00:13:00 ,you wrote£º=== Hi all, Can anyone tell me what is the memory any session takes when it logs on to the database? That's is, when a person opens a SQL plus window, how much memory is allocated to that session (just opening it and then the session is idle). And when he performs certain query, which returns over a few thousand records or more, what is the effect on the memory usage of that session. Any guidelines perhaps? Regards, DBA SKMCHRC = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping 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 taken by s session
Take a look at v$sesstat for the statistics on pga and uga memory used hth connor --- Hussain Ahmed Qadri [EMAIL PROTECTED] wrote: Hi all, Can anyone tell me what is the memory any session takes when it logs on to the database? That's is, when a person opens a SQL plus window, how much memory is allocated to that session (just opening it and then the session is idle). And when he performs certain query, which returns over a few thousand records or more, what is the effect on the memory usage of that session. Any guidelines perhaps? Regards, DBA SKMCHRC = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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 taken by s session
Hussain Ahmed Qadri, hi, from oracle, you can get it from v$sesstat, in oracle9i ,you can even get the more detailed data from v$process. From Unix os, for solaris, you can use pmap, on linux, you can use /proc/spid/status. FOr other os, I hope others can share there experience. Good luck Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org(China Oracle User Group) === 2003-03-22 00:13:00 ,you wrote£º=== Hi all, Can anyone tell me what is the memory any session takes when it logs on to the database? That's is, when a person opens a SQL plus window, how much memory is allocated to that session (just opening it and then the session is idle). And when he performs certain query, which returns over a few thousand records or more, what is the effect on the memory usage of that session. Any guidelines perhaps? Regards, DBA SKMCHRC = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping 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 Free up Failing on Solaris 8 - Off-topic
Anjo response is correct. Try running truss against your executable. You will see that brk is called for allocating memory. The way I understand it is, brk/sbrk is the system call which allocates/deallocates memory and malloc is the user mode library which internally calls brk/sbrk. I don't think free actually releases the memory back to the OS, but may reuse the memory for another request. Run the attached program and check the output. After you free the memory, the next malloc allocates the same memory which has been freed. Output of truss snipped on your program = fstat(3, 0xFFBEEFAC)= 0 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF31 mmap(0x, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF30 close(3)= 0 munmap(0xFF31, 8192)= 0 ioctl(1, TCGETA, 0xFFBEEBA4)= 0 allocating [20480] bytes write(1, a l l o c a t i n g [.., 25) = 25 brk(0x00020ED0) = 0 brk(0x00026ED0) = 0 ioctl(0, TCGETA, 0xFFBEF7CC)= 0 read(0, \n, 1024) = 1 Freeing [1] write(1, F r e e i n g [ 1 ]\n, 12)= 12 read(0, 0xFF2BF634, 1024) (sleeping...) read(0, \n, 1024) = 1 allocating [30720] bytes write(1, a l l o c a t i n g [.., 25) = 25 brk(0x00026ED0) = 0 brk(0x00028ED0) = 0 read(0, 0xFF2BF634, 1024) (sleeping...) read(0, \n, 1024) = 1 Freeing [2] write(1, F r e e i n g [ 2 ]\n, 12)= 12 read(0, 0xFF2BF634, 1024) (sleeping...) read(0, \n, 1024) = 1 allocating [40960] bytes write(1, a l l o c a t i n g [.., 25) = 25 brk(0x00028ED0) = 0 brk(0x0002CED0) = 0 read(0, 0xFF2BF634, 1024) (sleeping...) read(0, \n, 1024) = 1 Freeing [3] write(1, F r e e i n g [ 3 ]\n, 12)= 12 read(0, 0xFF2BF634, 1024) (sleeping...) #include stdio.h #include malloc.h #include string.h main() { char *loc1; char *loc2; printf(Allocating [%d] bytes\n, 10*1024); loc1 = (char *) malloc(10*1024); printf(Address : %x\n,loc1); printf(Allocating [%d] bytes\n, 10*1024); loc2 = (char *) malloc(10*1024); printf(Address : %x\n,loc2); free(loc1); free(loc2); printf(Allocating [%d] bytes\n, 10*1024); loc1 = (char *) malloc(10*1024); printf(Address : %x\n,loc1); printf(Allocating [%d] bytes\n, 10*1024); loc2 = (char *) malloc(10*1024); printf(Address : %x\n,loc2); free(loc1); free(loc2); printf(Allocating [%d] bytes\n, 10*1024); loc1 = (char *) malloc(10*1024); printf(Address : %x\n,loc2); free(loc1); } Regards, Denny Quoting VIVEK_SHARMA [EMAIL PROTECTED]: Hi brk, sbrk functions are used for DATA segments and we have problem with HEAP. Malloc allocates space onto heap and not in DATA segment. Seemingly the man page imply that it should not be used in conjunction with malloc, calloc , that we are using. Pasting from man pages :- USAGE The behavior of brk() and sbrk() is unspecified if an appli- cation also uses any other memory functions (such as malloc(3C), mmap(2), free(3C)). Qs. Is any alternative function which can be used OR am i missing something ? Thanks -Original Message- Sent: Monday, February 03, 2003 1:19 PM To: Multiple recipients of list ORACLE-L hmm, free() doesn't do sbrk() with a negative to reduce the process space. So yes the space stays allocated. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 03, 2003 7:58 AM Hi SITUATION - On a production APP Server having about 4000 Concurrent application processes , the memory allocated does NOT seem to be getting freed even though the application program is issuing the respective call to Free the memory . Qs Any /etc/system parameters , OS patches which should help ? Qs Is our approach of using the pmap command Correct ? else what Command to find the Private memory taken up by a process would be advisable ? Qs How to find the Total Amount of Swap Consumed ? [ We probably do NOT know how to interpret the vmstat output Correctly , top/swap -s commands show an output Differing greatly from df -k output for /tmp filesystem ] Qs Any Body has encountered such as situation before ? Configuration - Solaris 2.8 Patch - Generic 108528-16 patch Machine SF15K CPUs = 36 RAM = 96 GB We created a Small Sample C program which allocates FREEs memory but found that even after FREEing , the memory does NOT show as Freed in the pmap
Re: Memory Free up Failing on Solaris 8 - Off-topic
Thanks Denny :-) I remember writing a tool to prove this point in 1992, it was called ms (memory status), it showed all memory segments (heap, text, shared memory, shared objects, data segment etc). It worked the same as ps, but then for memory. I had enough of explaining all the time that the SZ column in ps contained the shared memory pages for the SGA also. Anjo. Denny Koovakattu wrote: Anjo response is correct. Try running truss against your executable. You will see that brk is called for allocating memory. The way I understand it is, brk/sbrk is the system call which allocates/deallocates memory and malloc is the user mode library which internally calls brk/sbrk. I don't think free actually releases the memory back to the OS, but may reuse the memory for another request. Run the attached program and check the output. After you free the memory, the next malloc allocates the same memory which has been freed. Output of truss snipped on your program = fstat(3, 0xFFBEEFAC)= 0 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF31 mmap(0x, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF30 close(3)= 0 munmap(0xFF31, 8192)= 0 ioctl(1, TCGETA, 0xFFBEEBA4)= 0 allocating [20480] bytes write(1, a l l o c a t i n g [.., 25) = 25 brk(0x00020ED0) = 0 brk(0x00026ED0) = 0 ioctl(0, TCGETA, 0xFFBEF7CC)= 0 read(0, \n, 1024) = 1 Freeing [1] write(1, F r e e i n g [ 1 ]\n, 12)= 12 read(0, 0xFF2BF634, 1024) (sleeping...) read(0, \n, 1024) = 1 allocating [30720] bytes write(1, a l l o c a t i n g [.., 25) = 25 brk(0x00026ED0) = 0 brk(0x00028ED0) = 0 read(0, 0xFF2BF634, 1024) (sleeping...) read(0, \n, 1024) = 1 Freeing [2] write(1, F r e e i n g [ 2 ]\n, 12)= 12 read(0, 0xFF2BF634, 1024) (sleeping...) read(0, \n, 1024) = 1 allocating [40960] bytes write(1, a l l o c a t i n g [.., 25) = 25 brk(0x00028ED0) = 0 brk(0x0002CED0) = 0 read(0, 0xFF2BF634, 1024) (sleeping...) read(0, \n, 1024) = 1 Freeing [3] write(1, F r e e i n g [ 3 ]\n, 12)= 12 read(0, 0xFF2BF634, 1024) (sleeping...) #include stdio.h #include malloc.h #include string.h main() { char *loc1; char *loc2; printf(Allocating [%d] bytes\n, 10*1024); loc1 = (char *) malloc(10*1024); printf(Address : %x\n,loc1); printf(Allocating [%d] bytes\n, 10*1024); loc2 = (char *) malloc(10*1024); printf(Address : %x\n,loc2); free(loc1); free(loc2); printf(Allocating [%d] bytes\n, 10*1024); loc1 = (char *) malloc(10*1024); printf(Address : %x\n,loc1); printf(Allocating [%d] bytes\n, 10*1024); loc2 = (char *) malloc(10*1024); printf(Address : %x\n,loc2); free(loc1); free(loc2); printf(Allocating [%d] bytes\n, 10*1024); loc1 = (char *) malloc(10*1024); printf(Address : %x\n,loc2); free(loc1); } Regards, Denny Quoting VIVEK_SHARMA [EMAIL PROTECTED]: Hi brk, sbrk functions are used for DATA segments and we have problem with HEAP. Malloc allocates space onto heap and not in DATA segment. Seemingly the man page imply that it should not be used in conjunction with malloc, calloc , that we are using. Pasting from man pages :- USAGE The behavior of brk() and sbrk() is unspecified if an appli- cation also uses any other memory functions (such as malloc(3C), mmap(2), free(3C)). Qs. Is any alternative function which can be used OR am i missing something ? Thanks -Original Message- Sent: Monday, February 03, 2003 1:19 PM To: Multiple recipients of list ORACLE-L hmm, free() doesn't do sbrk() with a negative to reduce the process space. So yes the space stays allocated. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 03, 2003 7:58 AM Hi SITUATION - On a production APP Server having about 4000 Concurrent application processes , the memory allocated does NOT seem to be getting freed even though the application program is issuing the respective call to Free the memory . Qs Any /etc/system parameters , OS patches which should help ? Qs Is our approach of using the pmap command Correct ? else what Command to find the Private memory taken up by a process would be advisable ? Qs How to find the Total Amount of
Re: Memory Free up Failing on Solaris 8 - Off-topic
hmm, free() doesn't do sbrk() with a negative to reduce the process space. So yes the space stays allocated. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 03, 2003 7:58 AM Hi SITUATION - On a production APP Server having about 4000 Concurrent application processes , the memory allocated does NOT seem to be getting freed even though the application program is issuing the respective call to Free the memory . Qs Any /etc/system parameters , OS patches which should help ? Qs Is our approach of using the pmap command Correct ? else what Command to find the Private memory taken up by a process would be advisable ? Qs How to find the Total Amount of Swap Consumed ? [ We probably do NOT know how to interpret the vmstat output Correctly , top/swap -s commands show an output Differing greatly from df -k output for /tmp filesystem ] Qs Any Body has encountered such as situation before ? Configuration - Solaris 2.8 Patch - Generic 108528-16 patch Machine SF15K CPUs = 36 RAM = 96 GB We created a Small Sample C program which allocates FREEs memory but found that even after FREEing , the memory does NOT show as Freed in the pmap output . Is the following approach correct ? DETAILS :- @ SAMPLE C PROGRAM @ #include stdio.h main() { char *abc = NULL ; int i = 0 ; for (i = 1; i 10; i++){ printf(allocating [%d] bytes\n, 10*1024*(i+1)); abc = (char *)malloc(10*1024*(i+1)); memset(abc, '\0', 10*1024*(i+1)); getchar(); free(abc); printf(Freeing [%d]\n, i); getchar(); } exit() ; } @ RUN Output :- STEP 1 - allocating [20480] bytes pmap -x PID of Above program process Address Kbytes Resident Shared Private Permissions Mapped File 0001 8 8 8 - read/exec a.out 0002 8 8 - 8 read/write/exec a.out 00022000 24 24 - 24 read/write/exec [ heap ] FF28 688 688 688 - read/exec libc.so.1 FF33C000 32 32 - 32 read/write/exec libc.so.1 FF37 16 16 16 - read/exec libc_psr.so.1 FF39 8 8 8 - read/exec libdl.so.1 FF3A 8 8 - 8 read/write/exec [ anon ] FF3B 152 152 152 - read/exec ld.so.1 FF3E6000 8 8 - 8 read/write/exec ld.so.1 FFBEC000 16 16 - 16 read/write/exec [ stack ] -- -- -- -- total Kb 968 968 872 96 THE Private memory allocated by the [ heap ] is 24 K STEP 2 - Freeing the memory allocated in the above Step Freeing [1] pmap -x PID of Above program process Address Kbytes Resident Shared Private Permissions Mapped File 00022000 24 24 - 24 read/write/exec [ heap ] RESULT - THE Private memory allocated previously does NOT get Freed [ heap ] continues to be 24 K STEP 3 - allocating [30720] bytes pmap -x PID of Above Program process Address Kbytes Resident Shared Private Permissions Mapped File 00022000 32 32 - 32 read/write/exec [ heap ] STEP 4 - Freeing the memory allocated in the above Step Freeing [2] pmap -x PID of Above program process Address Kbytes Resident Shared Private Permissions Mapped File 00022000 32 32 - 32 read/write/exec [ heap ] RESULT - THE Private memory allocated previously in Step 3 does NOT get Freed [ heap ] continues to be 32 K Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk 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]
RE: Memory Free up Failing on Solaris 8 - Off-topic
Hi brk, sbrk functions are used for DATA segments and we have problem with HEAP. Malloc allocates space onto heap and not in DATA segment. Seemingly the man page imply that it should not be used in conjunction with malloc, calloc , that we are using. Pasting from man pages :- USAGE The behavior of brk() and sbrk() is unspecified if an appli- cation also uses any other memory functions (such as malloc(3C), mmap(2), free(3C)). Qs. Is any alternative function which can be used OR am i missing something ? Thanks -Original Message- Sent: Monday, February 03, 2003 1:19 PM To: Multiple recipients of list ORACLE-L hmm, free() doesn't do sbrk() with a negative to reduce the process space. So yes the space stays allocated. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 03, 2003 7:58 AM Hi SITUATION - On a production APP Server having about 4000 Concurrent application processes , the memory allocated does NOT seem to be getting freed even though the application program is issuing the respective call to Free the memory . Qs Any /etc/system parameters , OS patches which should help ? Qs Is our approach of using the pmap command Correct ? else what Command to find the Private memory taken up by a process would be advisable ? Qs How to find the Total Amount of Swap Consumed ? [ We probably do NOT know how to interpret the vmstat output Correctly , top/swap -s commands show an output Differing greatly from df -k output for /tmp filesystem ] Qs Any Body has encountered such as situation before ? Configuration - Solaris 2.8 Patch - Generic 108528-16 patch Machine SF15K CPUs = 36 RAM = 96 GB We created a Small Sample C program which allocates FREEs memory but found that even after FREEing , the memory does NOT show as Freed in the pmap output . Is the following approach correct ? DETAILS :- @ SAMPLE C PROGRAM @ #include stdio.h main() { char *abc = NULL ; int i = 0 ; for (i = 1; i 10; i++){ printf(allocating [%d] bytes\n, 10*1024*(i+1)); abc = (char *)malloc(10*1024*(i+1)); memset(abc, '\0', 10*1024*(i+1)); getchar(); free(abc); printf(Freeing [%d]\n, i); getchar(); } exit() ; } @ RUN Output :- STEP 1 - allocating [20480] bytes pmap -x PID of Above program process Address Kbytes Resident Shared Private Permissions Mapped File 0001 8 8 8 - read/exec a.out 0002 8 8 - 8 read/write/exec a.out 00022000 24 24 - 24 read/write/exec [ heap ] FF28 688 688 688 - read/exec libc.so.1 FF33C000 32 32 - 32 read/write/exec libc.so.1 FF37 16 16 16 - read/exec libc_psr.so.1 FF39 8 8 8 - read/exec libdl.so.1 FF3A 8 8 - 8 read/write/exec [ anon ] FF3B 152 152 152 - read/exec ld.so.1 FF3E6000 8 8 - 8 read/write/exec ld.so.1 FFBEC000 16 16 - 16 read/write/exec [ stack ] -- -- -- -- total Kb 968 968 872 96 THE Private memory allocated by the [ heap ] is 24 K STEP 2 - Freeing the memory allocated in the above Step Freeing [1] pmap -x PID of Above program process Address Kbytes Resident Shared Private Permissions Mapped File 00022000 24 24 - 24 read/write/exec [ heap ] RESULT - THE Private memory allocated previously does NOT get Freed [ heap ] continues to be 24 K STEP 3 - allocating [30720] bytes pmap -x PID of Above Program process Address Kbytes Resident Shared Private Permissions Mapped File 00022000 32 32 - 32 read/write/exec [ heap ] STEP 4 - Freeing the memory allocated in the above Step Freeing [2] pmap -x PID of Above program process Address Kbytes Resident Shared Private Permissions Mapped File 00022000 32 32 - 32 read/write/exec [ heap ] RESULT - THE Private memory allocated previously in Step 3 does NOT get Freed [ heap ] continues to be 32 K Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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
Re: Memory leak in OCI call
Are you making any calls to OCIConnectionPoolDestroy anywhere in your program? HI. I am using OCIConnectionPoolCreate to establish Connection with database. When i run through purifier its showing Leak. The traces are as follows MLK: 128 bytes leaked at 0x1b7c830 This memory was allocated from: malloc [rtlib.o] sltspcinit [sltspc.c] kpucpcreate[kpucp.c] OCIConnectionPoolCreate [oci8.c] MLK: 104 bytes leaked at 0x1bec0b0 This memory was allocated from: malloc [rtlib.o] sltsmxi[sltsm.c] kpucpcreate[kpucp.c] OCIConnectionPoolCreate [oci8.c] Please help me in this... Thanks in Advance -Naren. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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 leak in OCI call
Yes I am using OCIConnectionPoolDestroy. -Naren Tim Gorman [EMAIL PROTECTED] on 12/30/2002 11:03:41 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Narendra Donthineni/HSSBLR) Are you making any calls to OCIConnectionPoolDestroy anywhere in your program? HI. I am using OCIConnectionPoolCreate to establish Connection with database. When i run through purifier its showing Leak. The traces are as follows MLK: 128 bytes leaked at 0x1b7c830 This memory was allocated from: malloc [rtlib.o] sltspcinit [sltspc.c] kpucpcreate[kpucp.c] OCIConnectionPoolCreate [oci8.c] MLK: 104 bytes leaked at 0x1bec0b0 This memory was allocated from: malloc [rtlib.o] sltsmxi[sltsm.c] kpucpcreate[kpucp.c] OCIConnectionPoolCreate [oci8.c] Please help me in this... Thanks in Advance -Naren. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 issues on HPUX --- docs on MetaLink
In my emails of the last two days I had mentioned that I had compiled a list of docs on Metalink. If you'd like to see the docs, I've placed them at http://hkchital.tripod.com/HPUX_Notes_from_Oracle.zip Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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: RE: Memory issues on HPUX --- docs on MetaLink
Hmm.. I was able to download the file at both my employer's Intranet and my Singnet broadband account till last night. Apparently, Tripod discourages file downloads from user's home pages. Those who would like the file, please send me a seperate email and I will send the file across. Hemant - Forwarded message from Cyril Thankappan Date: 12 Dec 2002 01:35:16 - Reply-To: Cyril Thankappan Subject: Re: RE: Memory issues on HPUX --- docs on MetaLink To: Hemant K Chitale [EMAIL PROTECTED] Hi I get the error This file is hosted by Tripod, a Lycos®Network Site, and is not available for download. Please check out Tripod's Help system for more information about Remote Loading and our Remote Loading policy. When I try to download the zip file... Kindly advise Cyril On Wed, 11 Dec 2002 Hemant K Chitale wrote : In my emails of the last two days I had mentioned that I had compiled a list of docs on Metalink. If you'd like to see the docs, I've placed them at http://hkchital.tripod.com/HPUX_Notes_from_Oracle.zip Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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). - End forwarded message - Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hkchital 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 issues on HPUX
They may be talking about large SGA support 32-bit applications on HP-UX and 'memory windows'. Check Note # 77310.1 on Metalink. Also check HP docs (http://docs.hp.com). There is a White Paper on this topic. - Kirti -Original Message- Sent: Tuesday, December 10, 2002 12:09 AM To: Multiple recipients of list ORACLE-L We are considering implementing a number of new products on HPUX. [We are currently running Tru64 and Solaris boxes but are now looking at HPUX for new applications]. The choice is between HPUX and Solaris. The products will include Oracle8i 8.1.7 Oracle9i 9.2.0 Oracle9iRAC Documentum Plumtree Some of our vendors have put in a FUD factor -- there are memory issues running on HPUX, without giving us any specifics. Are there any well-known Memory issues / Memory leaks running Oracle on HPUX ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hkchital 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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 issues on HPUX
It is true that you need to check your kernel parameters before installing and creating databases. Read the readme's and install docs completely first. Also as you have done search metalink for installation on HUPX 64 bit. Once the parameters are set, installation and db creation goes along quite smoothly. However, this advise goes for any platform (HP, IBM, Sun, NT, Linux). Rodd On Tue, 2002-12-10 at 08:41, Hemant K Chitale wrote: Rodd, Yes, we do suspect that the vendors are trying to convince us to go for Solaris. I have compiled a list of docs I could find on MetaLink. Some of them do seem to indicate that we need to be careful setting the kernel parameters (e.g. total max SGA size limited to 1.7G on 32-bit, unless using something called memory windows, nfile parameter must be set properly etc). I also did a search for %memory% in the Patch Download patch and found a few hits and will follow up on those as well. Hemant At 06:25 AM 10-12-02 -0800, you wrote: We run both HPUX and Solaris systems here. Quite frankly the HP systems give us less problems that the Sun systems. What you are getting from the vendors is exactly what you called it FUD. Rodd Holman On Tue, 2002-12-10 at 00:08, hkchital wrote: We are considering implementing a number of new products on HPUX. [We are currently running Tru64 and Solaris boxes but are now looking at HPUX for new applications]. The choice is between HPUX and Solaris. The products will include Oracle8i 8.1.7 Oracle9i 9.2.0 Oracle9iRAC Documentum Plumtree Some of our vendors have put in a FUD factor -- there are memory issues running on HPUX, without giving us any specifics. Are there any well-known Memory issues / Memory leaks running Oracle on HPUX ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Rodd Holman [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Rodd Holman [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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 issues on HPUX
We run both HPUX and Solaris systems here. Quite frankly the HP systems give us less problems that the Sun systems. What you are getting from the vendors is exactly what you called it FUD. Rodd Holman On Tue, 2002-12-10 at 00:08, hkchital wrote: We are considering implementing a number of new products on HPUX. [We are currently running Tru64 and Solaris boxes but are now looking at HPUX for new applications]. The choice is between HPUX and Solaris. The products will include Oracle8i 8.1.7 Oracle9i 9.2.0 Oracle9iRAC Documentum Plumtree Some of our vendors have put in a FUD factor -- there are memory issues running on HPUX, without giving us any specifics. Are there any well-known Memory issues / Memory leaks running Oracle on HPUX ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Rodd Holman [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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 issues on HPUX
Solaris' kernel parameters are a lot simpler that HP's. Practically all of Solaris' parameters are dynamic, whereas on HP, you need to do a fair bit of tweaking. A good example is the need to allocate memory available to Oracle, so you can size the SGA accordingly. Chances are, you will need several goes at it before arriving at an optimal configuration. With demand paging on Solaris, the kernel shuffles resources (especially memory) around as required. [EMAIL PROTECTED] 12/11/02 04:19a.m. It is true that you need to check your kernel parameters before installing and creating databases. Read the readme's and install docs completely first. Also as you have done search metalink for installation on HUPX 64 bit. Once the parameters are set, installation and db creation goes along quite smoothly. However, this advise goes for any platform (HP, IBM, Sun, NT, Linux). Rodd On Tue, 2002-12-10 at 08:41, Hemant K Chitale wrote: Rodd, Yes, we do suspect that the vendors are trying to convince us to go for Solaris. I have compiled a list of docs I could find on MetaLink. Some of them do seem to indicate that we need to be careful setting the kernel parameters (e.g. total max SGA size limited to 1.7G on 32-bit, unless using something called memory windows, nfile parameter must be set properly etc). I also did a search for %memory% in the Patch Download patch and found a few hits and will follow up on those as well. Hemant At 06:25 AM 10-12-02 -0800, you wrote: We run both HPUX and Solaris systems here. Quite frankly the HP systems give us less problems that the Sun systems. What you are getting from the vendors is exactly what you called it FUD. Rodd Holman On Tue, 2002-12-10 at 00:08, hkchital wrote: We are considering implementing a number of new products on HPUX. [We are currently running Tru64 and Solaris boxes but are now looking at HPUX for new applications]. The choice is between HPUX and Solaris. The products will include Oracle8i 8.1.7 Oracle9i 9.2.0 Oracle9iRAC Documentum Plumtree Some of our vendors have put in a FUD factor -- there are memory issues running on HPUX, without giving us any specifics. Are there any well-known Memory issues / Memory leaks running Oracle on HPUX ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Rodd Holman [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Rodd Holman [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Binley Lim 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 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 Based FS on Solaris 8
It wouldn't Cause Other regulat File systems to Crash. However, if the Server crashes, you wouldn't be able to restart your database ! Database Instance recovery requires the online redo logs which wouldn't be available when your server restarts. Hemant At 11:53 PM 29-09-02 -0800, you wrote: With Online Redo Logfiles placed on Memory Based File system i.e. tmpfs on Solaris 8 with Oracle 8.1.7.2) can Heavy / Data Intensive SQL Loads (DIRECT=TRUE , PARALLEL) Cause Other regular File systems to Crash ? SQL Loading happening for 5 Tables Concurrently Also Within Each Table 16 Parallel SQL Loads happening Data SQL Loaded into Tables of Sizes from 2-5 GB Thanks -Original Message- Sent: Tuesday, June 25, 2002 4:53 AM To: Multiple recipients of list ORACLE-L I hesitated mentioning that parameter in this forum, but I figured what the heck? Could be fun, in a sick way... :-) Once I was teaching a DBA class and mentioned _DISABLE_LOGGING. Immediately, I saw every head in the class look down, scribbling furiously! I had to backtrack very quickly and warn of the consequences of disabling redo logging (i.e. database corruption if not shutdown normally for any reason)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 24, 2002 2:48 PM Hi Tim Yes, I have tried the _disable_logging, does not work on all platforms. DB starts up fine, but redo log is generated, evidenced by log switching going on. Also if I do a normal DML (large-ish one to verify), then dump the redo log, I see my transaction there, so for a 420R, running Solaris8 and Oracle 9.0.1, it would seem that _disable_logging does not work. I don't want to complicate the picture even further with transportable tablespaces, which would mean that I would need to store all dependent objects (in this case indexes only) in the same tablespace, which I could easily achieve by rebuilding all indexes using a dynamic SQL. Informatica BTW does not only do single level inserts, version 5.0 onwards has a 'bulk load' feature, but I am not sure what this actually does. Previously Sagent also had a 'direct load' switch, which meant that it wrote all of its data to large (very large) flat files and then used Sql*Loader direct path to load. Fast, but Sagent at the time was very unreliable, because on identical runs, it would sometimes load all the data, sometimes only a portion, and every time, would report no errors and everything hunky dory, until you went looking for your data. I remember that took me about a week of arguing to prove that Sagent was at fault. Thanks for the suggestion of the Non volatile RAM (NVRAM) unit, it makes the most sense. I will suggest this to my damagers. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Sunday, 23 June 2002 9:03 PM To: Multiple recipients of list ORACLE-L Have you considered setting _DISABLE_LOGGING = TRUE instead? It could be just as disastrous... ;-) Buying an NVRAM unit would probably be more sensible, since at least then you have some probability of the file-system on such a unit surviving node failure or restart. I don't use Informatica, but I believe it mainly does single-row inserts, so not using the APPEND hint is a blessing anyway. After all, who likes one row in each database block? However, I could be wrong about that and it may actually be performing multi-row/array insertions... I don't know what your loads are like, but how about something like this instead? - create a small database with _DISABLE_LOGGING set to TRUE - use Informatica to load into a tablespace on that small, sacrificial db - use transportable tablespace to copy the tablespace to your real DW Just an idea (better you than me to try it!)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 23, 2002 8:53 PM Hi All does anyone have any white paper or info on how to configure a dedicated portion of real memory as a virtual drive on Solaris ? I want to move my online redo logs (4 X 128 M single threaded) for a 300 GB DW onto it, to speed up Informatica ETL, since Informatica does not allow me to specify /*+ APPEND */ mode of insert. I know I will not bypass the SQL layer this way, but at least, the LGWR will be writing to memory instead of disk. Thanks in advance. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Saturday, 22 June 2002 9:03 PM To: Multiple recipients of list ORACLE-L On
Re: Memory utilization
Hi Tim, FF21 8K read/write/exec [ anon ] FF34 8K read/write/exec/shared [ anon ] FF3A 8K read/write/exec [ anon ] I don't know what anon means, but let's assume that it is also private to this specific process, The anon refers to anonymous pages that are mapped to /dev/zero by calling mmap() which is a bunch of zeroes and not mapped from a file. It can be shared between processes with common ancestors as it does not have data as such and just zeroes, but processes having access to a single mapping of /dev/zero can share this memory region. In the above case, we have a 8K that is shared and the 16K that is private to this process. I am sure I will be corrected if I am wrong :-) Hope this helps. Regards, Madhavan -- Madhavan Amruthur DecisionPoint Applications -- http://fastmail.fm - You've just been FastMailed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur 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 utilization
From the OS pmap From the DB select * from v$sesstat where stat# in ( select stat# from v$statname where name like '%ga%' ) hth connor --- CP [EMAIL PROTECTED] wrote: Hi Gurus, How can I find out the amount of memory utilized (grabbed from the available memory of the OS) by a server process, whenever a user establishes a connection with the database. The OS is Sun Solairs with Oracle version 8.1.7.3. In other words, if I have a unix process id, is there a way to find out how much memory it is consuming. Thanks for your help and time in advance. CP [EMAIL PROTECTED] wrote: OS: Solaris 2.7 Database: 8.1.7 On dev server, !ls from sqlplus gives the files of current directory where sqlplus runs. On pro server, !ls from sqlplus goes to the home directory of os user. For example, Login to sqlplus from /u01 on both machines, on dev: SQL !pwd /u01 on pro: SQL !pwd /export/oracle What seting affects this ? Thanks, -Li Zhang -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CP 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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 utilization
Sure! One way is to use the UNIX pmap utility... Here is 8.1.7.3 on Sol 2.8; my apologies if this output wraps and comes out really ugly -- there's really no way to prettify this on the plain text email formats enforced by the list server... I've made notes indicating where the Oracle PGA/UGA and SGA data structures are located $ pmap 28598 28598: oracleportal (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) 0001 26520K read/exec /opt/app/oracle/product/8.1.7/bin/oracle 01A04000264K read/write/exec /opt/app/oracle/product/8.1.7/bin/oracle 01A46000720K read/write/exec [ heap ] == ORACLE PGA/UGA IS HERE!!! 8000 205192K read/write/exec/shared [ ism shmid=0xc9 ] == ORACLE SGA IS HERE!!! FEC0 4056K read/exec /opt/app/oracle/product/8.1.7/lib/libjox8.so FF004000160K read/write/exec /opt/app/oracle/product/8.1.7/lib/libjox8.so FF02C000 8K read/write/exec /opt/app/oracle/product/8.1.7/lib/libjox8.so FF08 16K read/exec /usr/platform/sun4u/lib/libc_psr.so.1 FF09 16K read/exec /usr/lib/libmp.so.2 FF0A4000 8K read/write/exec /usr/lib/libmp.so.2 FF0B 88K read/exec /usr/lib/libm.so.1 FF0D4000 8K read/write/exec /usr/lib/libm.so.1 FF0E 8K read/exec /usr/lib/libkstat.so.1 FF0F2000 8K read/write/exec /usr/lib/libkstat.so.1 FF10680K read/exec /usr/lib/libc.so.1 FF1BA000 32K read/write/exec /usr/lib/libc.so.1 FF1D 24K read/exec /usr/lib/librt.so.1 FF1E6000 8K read/write/exec /usr/lib/librt.so.1 FF1F 32K read/exec /usr/lib/libaio.so.1 FF208000 8K read/write/exec /usr/lib/libaio.so.1 FF21 8K read/write/exec [ anon ] FF22 8K read/exec /usr/lib/libsched.so.1 FF232000 8K read/write/exec /usr/lib/libsched.so.1 FF24 24K read/exec /usr/lib/libgen.so.1 FF256000 8K read/write/exec /usr/lib/libgen.so.1 FF26 40K read/exec /usr/lib/libsocket.so.1 FF27A000 8K read/write/exec /usr/lib/libsocket.so.1 FF28560K read/exec /usr/lib/libnsl.so.1 FF31C000 32K read/write/exec /usr/lib/libnsl.so.1 FF324000 32K read/write/exec /usr/lib/libnsl.so.1 FF34 8K read/write/exec/shared [ anon ] FF35 32K read/exec /opt/app/oracle/product/8.1.7/lib/libdsbtsh8.so FF366000 8K read/write/exec /opt/app/oracle/product/8.1.7/lib/libdsbtsh8.so FF368000 8K read/write/exec /opt/app/oracle/product/8.1.7/lib/libdsbtsh8.so FF37 8K read/exec /opt/app/oracle/product/8.1.7/lib/libskgxp8.so FF38 8K read/write/exec /opt/app/oracle/product/8.1.7/lib/libskgxp8.so FF39 8K read/exec /usr/lib/libdl.so.1 FF3A 8K read/write/exec [ anon ] FF3B152K read/exec /usr/lib/ld.so.1 FF3E6000 8K read/write/exec /usr/lib/ld.so.1 FFBE 64K read/write/exec [ stack ] total 238896K So, the total at the bottom shows that total virtual memory consumed for this process is 238896K, but really all but those areas marked as heap and stack are truly distinct for the process. All those other text pages with the file-names next to them, as well as the 205,192 Kbyte section marked as ism are memory pages that are shared amongst all oracle server processes, both foreground and background. I see 720K of heap (i.e. Oracle PGA and UGA) and 64K of stack which is particular to this process. I don't know what anon means, but let's assume that it is also private to this specific process, so that totals to 808K that is specific and private to this process. So, in this example, of the total footprint of 238,896 Kb of virtual memory, only 808Kb of that is private to this process only and the remaining 238,088Kb is shared by all of the oracle server processes... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 7:13 PM Hi Gurus, How can I find out the amount of memory utilized (grabbed from the available memory of the OS) by a server process, whenever a user establishes a connection with the database. The OS is Sun Solairs with Oracle version 8.1.7.3. In other words, if I have a unix process id, is there a way to find out how much memory it is consuming. Thanks for your help and time in advance. CP [EMAIL PROTECTED] wrote: OS: Solaris 2.7 Database: 8.1.7 On dev server, !ls from sqlplus gives the files of current directory where sqlplus runs. On pro server, !ls from sqlplus goes to the home directory of os user. For example, Login to sqlplus from /u01 on both machines, on dev: SQL !pwd /u01 on pro: SQL !pwd /export/oracle What seting affects this ? Thanks, -Li Zhang -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
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?
Hello Clinton, Here is script for calculating memory requirements (shared pool requirements). Tuesday, April 23, 2002, 5:38:33 PM, you wrote: CN Hi all. CN Does anyone have any idea how to calculate the amount of memory each user CN uses during a session? CN This needs to be done to calculate the amount of memory Lawson will use CN during production. CN Any help given will be appreciated. CN Thanks CN Clint CN Confidentiality Warning CN === CN The contents of this message and any attachments are intended solely for the CN addressee's use and may be legally privileged and/or confidential. If you CN are not the addressee indicated in this message, any retention, CN distribution, copying or use of this message is strictly prohibited. If you CN received this message in error, kindly notify the sender immediately by CN reply e-mail and then destroy the message and any copies thereof. The CN content and any views expressed therein are, unless otherwise stated, the CN views of the author and not those of the company or any of its management or CN directors. CN Whilst all reasonable steps are taken to ensure the accuracy and integrity CN of information transmitted, the company does not accept responsibility for CN any corruption of the information or data or breach of confidentiality as a CN result of electronic submission. CN When addressed to the Momentum Employee Benefits clients any opinion or CN advice contained in this e-mail is subject to the terms and conditions CN expressed in any applicable terms of business. -- Best regards, Sergeymailto:[EMAIL PROTECTED] shared_p.sql Description: Binary data
Re: Memory?
Sergey, Attachments are not going through on this list. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 2:58 AM Hello Clinton, Here is script for calculating memory requirements (shared pool requirements). Tuesday, April 23, 2002, 5:38:33 PM, you wrote: CN Hi all. CN Does anyone have any idea how to calculate the amount of memory each user CN uses during a session? CN This needs to be done to calculate the amount of memory Lawson will use CN during production. CN Any help given will be appreciated. CN Thanks CN Clint CN Confidentiality Warning CN === CN The contents of this message and any attachments are intended solely for the CN addressee's use and may be legally privileged and/or confidential. If you CN are not the addressee indicated in this message, any retention, CN distribution, copying or use of this message is strictly prohibited. If you CN received this message in error, kindly notify the sender immediately by CN reply e-mail and then destroy the message and any copies thereof. The CN content and any views expressed therein are, unless otherwise stated, the CN views of the author and not those of the company or any of its management or CN directors. CN Whilst all reasonable steps are taken to ensure the accuracy and integrity CN of information transmitted, the company does not accept responsibility for CN any corruption of the information or data or breach of confidentiality as a CN result of electronic submission. CN When addressed to the Momentum Employee Benefits clients any opinion or CN advice contained in this e-mail is subject to the terms and conditions CN expressed in any applicable terms of business. -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman 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?
I have an idea .. PGA = UGA(user_session_data + cursor state)+stack space So Will it be enough or do I have to add sort_area_size to the value below? select * FROM v$SESSTAT a ,v$STATNAME b WHERE a.statistic#=b.statistic# and name like 'session pga memory' ; Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 4:43 PM Sergey, Attachments are not going through on this list. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 2:58 AM Hello Clinton, Here is script for calculating memory requirements (shared pool requirements). Tuesday, April 23, 2002, 5:38:33 PM, you wrote: CN Hi all. CN Does anyone have any idea how to calculate the amount of memory each user CN uses during a session? CN This needs to be done to calculate the amount of memory Lawson will use CN during production. CN Any help given will be appreciated. CN Thanks CN Clint CN Confidentiality Warning CN === CN The contents of this message and any attachments are intended solely for the CN addressee's use and may be legally privileged and/or confidential. If you CN are not the addressee indicated in this message, any retention, CN distribution, copying or use of this message is strictly prohibited. If you CN received this message in error, kindly notify the sender immediately by CN reply e-mail and then destroy the message and any copies thereof. The CN content and any views expressed therein are, unless otherwise stated, the CN views of the author and not those of the company or any of its management or CN directors. CN Whilst all reasonable steps are taken to ensure the accuracy and integrity CN of information transmitted, the company does not accept responsibility for CN any corruption of the information or data or breach of confidentiality as a CN result of electronic submission. CN When addressed to the Momentum Employee Benefits clients any opinion or CN advice contained in this e-mail is subject to the terms and conditions CN expressed in any applicable terms of business. -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman 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: Bunyamin K. Karadeniz 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?
Can you post this script inline as the list strips attachments. -Original Message- From: Sergey V Dolgov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 2:58 AM To: Multiple recipients of list ORACLE-L Subject: Re: Memory? Hello Clinton, Here is script for calculating memory requirements (shared pool requirements). Tuesday, April 23, 2002, 5:38:33 PM, you wrote: CN Hi all. CN Does anyone have any idea how to calculate the amount of memory each user CN uses during a session? CN This needs to be done to calculate the amount of memory Lawson will use CN during production. CN Any help given will be appreciated. CN Thanks CN Clint CN Confidentiality Warning CN === CN The contents of this message and any attachments are intended solely for the CN addressee's use and may be legally privileged and/or confidential. If you CN are not the addressee indicated in this message, any retention, CN distribution, copying or use of this message is strictly prohibited. If you CN received this message in error, kindly notify the sender immediately by CN reply e-mail and then destroy the message and any copies thereof. The CN content and any views expressed therein are, unless otherwise stated, the CN views of the author and not those of the company or any of its management or CN directors. CN Whilst all reasonable steps are taken to ensure the accuracy and integrity CN of information transmitted, the company does not accept responsibility for CN any corruption of the information or data or breach of confidentiality as a CN result of electronic submission. CN When addressed to the Momentum Employee Benefits clients any opinion or CN advice contained in this e-mail is subject to the terms and conditions CN expressed in any applicable terms of business. -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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 resource...
Hi Shuan, This has nothing to do with how your service is started and everything to do with the value of the initiazation paramaters that are used to start the database. The simple answer is that you can get oracle to use less memory by reducing the value of these parameters. The most likely culprits, db_block_buffers, shared_pool_size, sort_area_size and log_buffer_size. However you didn't mentioned why you want them to be smaller. It is possible they were set by the previous dba at these values to maximize performance of the system. Setting them smaller could negatively effect performance. Why do you want to make these smaller? JOhn [EMAIL PROTECTED] wrote: hi, DBAs... i'm using Win2000 Advance Server, with Oracle Enterprise Edition 8.1.6. by using task manager, i found tat the ORACLE.EXE is using about 58,556K memory for one db, which is start manually. and ORACLE.EXE for anotherdb is only about 10,000K, which is start automatically when server start. is it that problem of manually start? how can i reduce the memory resource used by oracle? thanks... and hav a nice day.
RE: memory resource...
Shuan, The oracle.exe process memory usage is dependant on the size of the SGA. The difference in the memory used for each of the oracle.exe processes is due to the different SGA sizes. Regards $uhen hi, DBAs... i'm using Win2000 Advance Server, with Oracle Enterprise Edition 8.1.6. by using task manager, i found tat the ORACLE.EXE is using about 58,556K memory for one db, which is start manually. and ORACLE.EXE for anotherdb is only about 10,000K, which is start automatically when server start. is it that problem of manually start? how can i reduce the memory resource used by oracle? thanks... and hav a nice day.
Re: memory resource...
hi! john... while i installed the first db, it only consumes 10,000~20,000K memory. afterthe error occurred(ORA-12638, which solved now), it becomes memory sucker. that's why i'm curious about it. and..i'm learning oracle, so my pc will b quite slow if oracle consumes too many memory. and i didnt change any setting for init file. so i feel strange why it changed itself. thanks for ur answer. good day and hav a nice day. - Original Message - From: orantdba To: Multiple recipients of list ORACLE-L Sent: Thursday, January 17, 2002 11:10 AM Subject: Re: memory resource... Hi Shuan,This has nothing to do with how your service is started and everything to do with the value of the initiazation paramaters that are used to start the database. The simple answer is that you can get oracle to use less memory by reducing the value of theseparameters. The most likely culprits, db_block_buffers, shared_pool_size,sort_area_size and log_buffer_size. However you didn't mentioned why you wantthem to be smaller. It is possible they were set by the previous dba at these valuesto maximize performance of the system. Setting them smaller could negatively effect performance.Why do you want to make these smaller?JOhn[EMAIL PROTECTED] wrote: hi, DBAs... i'm using Win2000 Advance Server, with Oracle Enterprise Edition 8.1.6. by using task manager, i found tat the ORACLE.EXE is using about 58,556K memory for one db, which is start manually. and ORACLE.EXE for anotherdb is only about 10,000K, which is start automatically when server start. is it that problem of manually start? how can i reduce the memory resource used by oracle? thanks... and hav a nice day.
RE: Memory Windows for HP-UX
I've had no problems with TNS, dblinks, etc. The only thing to watch out for is some monitoring packages (can't remember which ones) read the SGA structures directly from memory. They need to be started from the correct memory window. Never had the pleasure of MC ServiceGuard. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] [EMAIL PROTECTED] ujitsu.com To: [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED]Subject: RE: Memory Windows for HP-UX 11/08/01 05:20 PM Please respond to ORACLE-L Do you do anything like dblinks in these 10 instances? I will have 4 instances which all have dblinks to each other in one way or another. From what I read I don't think its a problem but I am not really sure either. I also have no idea how MC ServiceGuard will come into play but I put that one out on the HP forum. -Original Message- Sent: Thursday, November 08, 2001 3:55 PM To: Multiple recipients of list ORACLE-L I believe any system running hpux 11.0 or above can utilize this functionality. See http://docs.hp.com/hpux/onlinedocs/os/memwn1_4.pdf I've been using it on our L2000 box. It was the only way to get 10 instances running at once. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] [EMAIL PROTECTED] ujitsu.com To: [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED]Subject: Memory Windows for HP-UX 11/08/01 03:20 PM Please respond to ORACLE-L Is anyone familiar with using memory windows to better utilize their memory when running 32-bit Oracle? I am thinking of going this route instead of upgrading to 64-bit and am looking for info on it. Any HP docs that I can be pointed to would be great. I have a doco from Oracle on how it works and how I get Oracle to use it but nothing that tells me which HP boxes I can use it on. Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Ron Thomas 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Memory Windows for HP-UX
I believe any system running hpux 11.0 or above can utilize this functionality. See http://docs.hp.com/hpux/onlinedocs/os/memwn1_4.pdf I've been using it on our L2000 box. It was the only way to get 10 instances running at once. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] [EMAIL PROTECTED] ujitsu.com To: [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED]Subject: Memory Windows for HP-UX 11/08/01 03:20 PM Please respond to ORACLE-L Is anyone familiar with using memory windows to better utilize their memory when running 32-bit Oracle? I am thinking of going this route instead of upgrading to 64-bit and am looking for info on it. Any HP docs that I can be pointed to would be great. I have a doco from Oracle on how it works and how I get Oracle to use it but nothing that tells me which HP boxes I can use it on. Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Ron Thomas 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 Windows for HP-UX
Do you do anything like dblinks in these 10 instances? I will have 4 instances which all have dblinks to each other in one way or another. From what I read I don't think its a problem but I am not really sure either. I also have no idea how MC ServiceGuard will come into play but I put that one out on the HP forum. -Original Message- Sent: Thursday, November 08, 2001 3:55 PM To: Multiple recipients of list ORACLE-L I believe any system running hpux 11.0 or above can utilize this functionality. See http://docs.hp.com/hpux/onlinedocs/os/memwn1_4.pdf I've been using it on our L2000 box. It was the only way to get 10 instances running at once. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] [EMAIL PROTECTED] ujitsu.com To: [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED]Subject: Memory Windows for HP-UX 11/08/01 03:20 PM Please respond to ORACLE-L Is anyone familiar with using memory windows to better utilize their memory when running 32-bit Oracle? I am thinking of going this route instead of upgrading to 64-bit and am looking for info on it. Any HP docs that I can be pointed to would be great. I have a doco from Oracle on how it works and how I get Oracle to use it but nothing that tells me which HP boxes I can use it on. Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Ron Thomas 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: Kimberly Smith 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 Windows for HP-UX
Kimberly, We are using memory windows on our N-class server supporting 21 instances (mainly development types). For 32-bit applications there is a max limit of 1.75 GB of shared memory resource for all applications combined. HP-UX 11.0 overcomes this with memory windows implementation. And it is fairly easy to setup. Please refer to this white paper for some good information : http://docs.hp.com/hpux/onlinedocs/os/memwn1_4.pdf. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 4:20 PM To: Multiple recipients of list ORACLE-L Subject: Memory Windows for HP-UX Is anyone familiar with using memory windows to better utilize their memory when running 32-bit Oracle? I am thinking of going this route instead of upgrading to 64-bit and am looking for info on it. Any HP docs that I can be pointed to would be great. I have a doco from Oracle on how it works and how I get Oracle to use it but nothing that tells me which HP boxes I can use it on. Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Deshpande, Kirti 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 Sizing
Did you maybe use a different init file? Did you check the parameters in your email from sql or from the init file you think you're using to start the database? Just a sanity check, I'm sure you did all the right things... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield 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 question again ???
Title: RE: memory question again ??? Here is a little C program that works on Solaris: $ sysconf Memory-total=5120M free=1596M pct=31 pagesize=8K CPU-total=6 online=6 $ cat sysconf.c #include stdio.h #include sys/unistd.h main() { int wk1, wk2, wk3, wk4; long total_pages, free_pages, pagesize, total_cpus, total_cpus_online; total_pages = sysconf(_SC_PHYS_PAGES); free_pages = sysconf(_SC_AVPHYS_PAGES); pagesize = sysconf(_SC_PAGESIZE); total_cpus = sysconf(_SC_NPROCESSORS_CONF); total_cpus_online = sysconf(_SC_NPROCESSORS_ONLN); wk1 = (total_pages * (pagesize / 1024)) / 1024; wk2 = (free_pages * (pagesize / 1024)) / 1024; wk3 = (free_pages * 100) / total_pages; wk4 = (pagesize / 1024); printf(Memory-total=%dM free=%dM pct=%d pagesize=%dK CPU-total=%d online=%d\n, wk1, wk2, wk3, wk4, total_cpus, total_cpus_online ); } -Original Message- From: Janet Linsy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 10:27 AM To: Multiple recipients of list ORACLE-L Subject: memory question again ??? Hi, Thank you all for showing me how to check the Unix memory. Is there a way to show how much is used and how much is free? Thank you! Janet __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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
Jeez it took all day for that to get out! No, it would just suck up 100 percent of both processors and then a gig of ram. Figured out what it was, one of the developers had sort of an infinite loop in his code. A beleive it was a procedure that kept calling itself, all fixed now. But what I don't understand is why it sucked up more memory than was allocated to the SGA? Kev -Original Message- Sent: Wednesday, April 25, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Kev, What exactly do you mean by all hell breaks loose.? Is there a specific error? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, April 25, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Hi all, I have a developer running a procedure that is basically an insert statement. When he executes it as stand alone everything is fine, when he executes it from a package all hell breaks loose. Anyone have any ideas? Winnt/8.1.6ee...Also, why would Oracle Process suck up 950MB's of RAM when this procedure crashes? The SGA is supposed to be limited to about 550MB's? Thanks alot Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Haskins, Ed 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 Kostyszyn 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
Kev, What exactly do you mean by all hell breaks loose.? Is there a specific error? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, April 25, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Hi all, I have a developer running a procedure that is basically an insert statement. When he executes it as stand alone everything is fine, when he executes it from a package all hell breaks loose. Anyone have any ideas? Winnt/8.1.6ee...Also, why would Oracle Process suck up 950MB's of RAM when this procedure crashes? The SGA is supposed to be limited to about 550MB's? Thanks alot Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Haskins, Ed 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 refresher
Kevin, When you say migration...I assume you're doing a data migration from some legacy to Oracle...and likely you're using DataMig to take data that's in the staging area ((source(Oracle)) and importing it into the target Oracle instance, yes? Yes, create a RBS called RBIG and size it appropriately. Are 70,000 records in one table or does the whole migration consist of 70,000 records in a multitude of tables? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, April 11, 2001 1:06 PM To: Multiple recipients of list ORACLE-L Hi all, If I am doing a migration of say 70 thousand records, isn't it a good idea to turn off all of my little rollback segments and turn on a couple of big rgs? And, how big do you guys think they should be if that is the case? I am trying to increase the performance of this migration, but it is not easy. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Haskins, Ed 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).