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
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
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
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
what is meant by OP,tanel..
Original Poster.
Tanel.
t ORACLE-L Sent: Saturday, November 01, 2003 1:34 AM Subject: RE: memory usage by dbw very highrich the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08)is used by non shared memory size. i went thru all the processes and found dbwr u!
sing the
max %mem. what could be the
ssage - From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L Sent: Saturday, November 01, 2003 1:34 AM Subject: RE: memory usage by dbw very high !
rich the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08) is used by non shared memory size. i went
process or you just guess linux would swap because you don't see free
memory in top output?
Tanel.
- Original Message -
From: Sai Selvaganesan
To: Multiple recipients of list ORACLE-L
Sent: Saturday, November 01, 2003 1:34 AM
Subject: RE: memory usage by dbw
, 2003 1:34 AM
Subject: RE: memory usage by dbw very high
rich
the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08)
is
used by non shared memory size.
i went thru all the processes and found dbwr using the max %mem. what
could
be the reason?
sai
output?
Tanel.
- Original Message -
From: Sai Selvaganesan
To: Multiple recipients of list ORACLE-L
Sent: Saturday, November 01, 2003 1:34 AM
Subject: RE: memory usage by dbw very high
rich
the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size
t ORACLE-L
Sent: Saturday, November 01, 2003 1:34
AM
Subject: RE: memory usage by dbw very
high
rich
the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is
3.08)is used by non shared memory size.
i went thru all the processes and found dbwr using the max %mem. wha
Sent: Saturday, November 01, 2003 1:34 AM
Subject: RE: memory usage by dbw very high
rich
the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08) is
used by non shared memory size.
i went thru all the processes and found dbwr using the max %mem. what
could
be the reason?
sai
If I'm not mistaken, this figure includes the size of the shared memory
segment from the SGA. Take the output of the oracle line of ipcs -a
(hopefully you'll only have one!) and subtract it from the process size to
get a better idea of the non-shared memory size of the process.
Rich
Rich Jesse
rich
the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08)is used by non shared memory size.
i went thru all the processes and found dbwr using the max %mem. what could be the reason?
sai"Jesse, Rich" [EMAIL PROTECTED] wrote:
If I'm not mistaken, this figure includes the size of the
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
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
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
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
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
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
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
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
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
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
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
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
- 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
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:
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
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
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
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
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:
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
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
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
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
- 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
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
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
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
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
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
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
.
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
]
ujitsu.com To: [EMAIL PROTECTED]
Sent by:cc:
[EMAIL PROTECTED]Subject: RE: Memory
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]
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
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
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
--
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
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
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
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
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
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,
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
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
58 matches
Mail list logo