where did you hear that oracle 10g was written almost entirely outside the
US?
what critical problems have you had with 9i?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 23, 2004 10:19 PM
On 01/23/2004 07:54:25 PM, Arnold, Sandra
Personal communication.
On 01/24/2004 06:44:24 AM, Ryan wrote:
where did you hear that oracle 10g was written almost entirely
outside
the
US?
what critical problems have you had with 9i?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday,
a single session is
supposed to be allowed 5% of the P_A_T,
you could get about 90MB. So there are
some funny things going on in that area
which still need fixing.
It's a bit tough for big systems, as I've
found that the optimizer seems to be
much smarter about memory user and
access
There are a series of metalink notes detailing memory leaks with the PGA in 9203. Has
anyone had critical problems? Oracle recommends patching to 9204 to fix this, but it
just came out and we prefer to be conservative with our patches.
--
Please see the official ORACLE-L FAQ: http
I read the paper about the adaptive memory and how it
gets wasted, but with 10G SGA you can afford to be a bit
wasteful. I would set workarea_size_policy to manual and
then set sort_area_size to 32M and hash area size to 128M.
With the memory sizes you mentioned, there shouldn't be any
problems
that the optimizer seems to be
much smarter about memory user and
access paths when P_A_T and W_S_P
are set.
What's the book about ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can
: pga_aggregate_target and a memory leak
I am interested in the bug number. Currently am having memory problems that
may be related to the pga.
Sandra
-Original Message-
Sent: Thursday, January 22, 2004 5:09 PM
To: Multiple recipients of list ORACLE-L
Yes I have and still have a problem with pga
EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: pga_aggregate_target and a memory leak
Kirti,
So is April 12th the latest date you heard for when 10g might be
released?? Because it was the end of 2003, but I didn't know it had
slipped all the way into April
]
Date: 2004/01/23 Fri PM 03:24:45 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: pga_aggregate_target and a memory leak
Kirti,
So is April 12th the latest date you heard for when 10g might be
released?? Because it was the end of 2003, but I didn't know it had
On 01/23/2004 07:54:25 PM, Arnold, Sandra wrote:
We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04
databases. We are planning on upgrading our 8i databases this year.
The
rate we are going it probably will be two years before we get to 10g.
Sandra
That would be a very
Im not sure I see what the size of the PAT has to do with a memory leak. On
metalink there is a laundry list of PGA things that were supposedly causing
memory leaks prior to 9.2.0.4. Are you certain its PAT causing it? Maybe
they didnt fix all the memory leaks with the PGA in general?
has anyone
Paul,
Most of my work is on HP-UX and AIX.
I have yet to see any ORA-600 and memory leaks related to P_A_T. All databases that I
work with
are on 9.2.0.4, except just one running on 9.2.0.3. No memory leak there either.
- Kirti
--- Paul Drake [EMAIL PROTECTED] wrote:
--- Kirtikumar
I have had a problem on my 9i database for three weeks. I am getting a
ORA-7445 error which is pointing to some memory problems. It is occurring
during the CTX_DOC.FILTER process. We are running this process from a
custom PL/SQL package that is being initiated from an Oracle Job. However,
we
is pointing to some memory problems. It is occurring
during the CTX_DOC.FILTER process. We are running this process from a
custom PL/SQL package that is being initiated from an Oracle Job. However,
we still have the problem when we run it from a crontab job. I currently
have a 21 page TAR concerning
To: Multiple recipients of list ORACLE-L
I have had a problem on my 9i database for three weeks. I am getting a
ORA-7445 error which is pointing to some memory problems. It is occurring
during the CTX_DOC.FILTER process. We are running this process from a
custom PL/SQL package that is being initiated
Yes I have and still have a problem with pga memory leak
When using pl/sql tables. I'm on 9i performance and tuning course at oracle
Now and discussed this with the teacher. He went looking and found a bug
Stating that on 9i (9.2.0.2 and further) there seems to be a limit on total
pga per process
is pointing to some memory problems. It is occurring
during the CTX_DOC.FILTER process. We are running this process from a
custom PL/SQL package that is being initiated from an Oracle Job. However,
we still have the problem when we run it from a crontab job. I currently
have a 21 page TAR concerning
I am interested in the bug number. Currently am having memory problems that
may be related to the pga.
Sandra
-Original Message-
Sent: Thursday, January 22, 2004 5:09 PM
To: Multiple recipients of list ORACLE-L
Yes I have and still have a problem with pga memory leak
When using pl/sql
to
P_A_T - and although a single session is
supposed to be allowed 5% of the P_A_T,
you could get about 90MB. So there are
some funny things going on in that area
which still need fixing.
It's a bit tough for big systems, as I've
found that the optimizer seems to be
much smarter about memory user
for three weeks. I am getting a
ORA-7445 error which is pointing to some memory problems. It is occurring
during the CTX_DOC.FILTER process. We are running this process from a
custom PL/SQL package that is being initiated from an Oracle Job. However,
we still have the problem when we run it from
Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and
9.2.0.4 caused
ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to
'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S)
worked,
however
Kirti, you're back!
Must have finished the book. :)
Re the PGA problems, what was the value for 'over allocation count' in v$pgastat?
Did you try increasing P_A_T to a larger number?
Oracle is supposed to grab the memory it needs, if available, regardless of
the P_A_T setting.
Also, did
, I never bothered to look at v$pgastat. Should have.. and will, when we do
some more
testing next week..
Did you try increasing P_A_T to a larger number?
Yes...
Oracle is supposed to grab the memory it needs, if available, regardless
of
the P_A_T setting.
Also, did your system
kirti-- would you recommend avoiding pga_aggregate_target for now?
From: Kirtikumar Deshpande [EMAIL PROTECTED]
Date: 2004/01/21 Wed PM 02:44:31 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: pga_aggregate_target and a memory leak
Replies in line
:44:31 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: pga_aggregate_target and a memory leak
Replies in line...
- Kirti
--- [EMAIL PROTECTED] wrote:
Kirti, you're back!
Thanks. Found some slack time from routine DBA work!
Must
need fixing.
It's a bit tough for big systems, as I've
found that the optimizer seems to be
much smarter about memory user and
access paths when P_A_T and W_S_P
are set.
What's the book about ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can
about memory user and
access paths when P_A_T and W_S_P
are set.
What's the book about ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next
seems to be
much smarter about memory user and
access paths when P_A_T and W_S_P
are set.
What's the book about ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question
Enjoy:
http://www.vldb.org/conf/2002/S29P03.pdf
This explains how Oracle9i does the P_A_T, W_S_P 'magic'.
Cheers!
- Kirti
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
--
Please see the
guessed it - [723], [10332], [10332], [memory leak].
The database was setup in a less than optimal fashion
as far as memory allocations go. The initial
pga_aggregate_target was only 64M (server had 3 GB of
memory and only one instance up) so I'm calling this
one a non-sensical configuration error
One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3
instance due to a possible memory leak. The only note on memory leaks and
pga_aggregate_target I can find on metalink is: 334427.995
doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know
[EMAIL PROTECTED] wrote:
One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3
instance due to a possible memory leak. The only note on memory leaks and
pga_aggregate_target I can find on metalink is: 334427.995
doesnt seem to apply to pga_aggregate_target. We
For further testing but will try do do so and report some more.
Regards,
Jeroen
-Oorspronkelijk bericht-
Van: Stephane Faroult [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 20 januari 2004 20:59
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga_aggregate_target and a memory leak
Dear DBAs,
Good Morning. Using PL/SQL procedure I am trying to spool out
Japanese Characters with VARCHR2(3600) size and I am getting this error.
Here is my code. For your information it is Japanese Characters
Spool c:\test.log
Declare
cursor c1 is select
Dear Friends,
Thank you so much. Yes i was able to solve this issue..
FYI ... I used CONVERT function
]
Subject: Re: RE: large pl/sql table sucking up all memory on a server
I think Unix Kernel parameter limit should help in this case. It can prevent
runaway process from consuming the whole machine resource.
In most unix, there is kernel parameter(or ulimit) that restrict the maximum
That works. I prefer thumb presses, they worked
for the Inquisition and they lasted 500 years...
dr
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
I think Ill get a taser and fry the next person who does it. :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
? Oracle typically holds your hand with memory usage issues. Are
there any parameter settings I can use that limit the size of pl/sql tables?
Or are they just dynamic arrays that can grow as large as you want.
I know your supposed to use a 'limit' command on them. I didnt write it. I just dont
the server.
I was under the impression that pl/sql tables go into the buffer cache and cannot go
large than its size? Oracle typically holds your hand with memory usage issues. Are
there any parameter settings I can use that limit the size of pl/sql tables?
Or are they just dynamic arrays
Does he still have a job? :)
Was it one session or many of them? How many rows got bulk processed?
If it's one session that caused this, then it's either: vary badly designed,
there is memory leak, or the system is already short in memory!
Waleed
-Original Message-
Sent: Monday
PROTECTED]
Subject: RE: large pl/sql table sucking up all memory on a server
Assign the developer a profile that would do good.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed
3 million records in a forall statement. we are bringing on temps and you know how
that goes... Im hoping I can set a parameter somewhere to keep anyone from bringing
down a server.
such as 'memory for pl/sql table area limit hit' errors out what he is doing.
i guess not :(
From: Khedr
Ryan,
First off, PL/SQL tables have nothing to do with the buffer cache. The
buffer cache is part of the SGA (shared memory) and is used to buffer
blocks of database datafiles. That's all that will ever be in the buffer
cache.
PL/SQL tables are memory constructs that are allocated from the PGA
of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: large pl/sql table sucking up all memory on a server
Ryan,
First off, PL/SQL tables have nothing to do with the buffer cache. The
buffer cache is part of the SGA (shared memory) and is used to buffer
blocks of database datafiles. That's all
all memory on a server
Assign the developer a profile that would do good.
Raj
--
--
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod
Btw, PRIVATE_SGA only limits shared server SGA memory usage, for limiting
PGA sizes you could use _pga_max_size (defaults to 200M), but this is
getting kind of dirty and is unsupported (and works starting from 9i)
Tanel.
- Original Message -
To: [EMAIL PROTECTED]
Sent: Monday, December
/detail/-/1590592174
/qid=1072734291/sr=1-1/ref=sr_1_1/102-9815245-5757732?v=glances=books
If you look on pg249, it discusses bulk collect and
pga memory, e.g.
I crashed my database session (and shortly thereafter
my laptop) because insufficient memory was available
to hold the set of 100
This is probably old hat for you, but given it's Unix
(Sun) and it's a client process, wouldn't you be able
to use ulimit to stop memory allocation growing past a
certain size? The other thing I'd try is to limit memory
through the resource control in Oracle. But that is
highly version
PROTECTED]
Subject: RE: large pl/sql table sucking up all memory on a server
Assign the developer a profile that would do good.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed
Hi,
I have an ora-4030 problem
related to pga memory
allocation, at least I have concluded sofar
This program is batch written
in pl/sql and after an hour or so it crashes. PGA allocated is slowly exceeding
2Gb and when I monitor with
top I see the process size rising uptill 2 Gb
This is scary,
I'm planning to upgrade 9.2.0.4 from 9.2.0.2.
I don't know how
removing pga_aggegrate_target will help reducing
memory!!
Does the program
have any memory tables, etc?
Did you monitor
the PGA size from the Oracle side using v$sesstat?
A sql by itself
can't consume
I'm using auto pga allocation on 9.2.0.3 without any problem.
You don't mention which version.
You can turn it off with 'alter system set workarea_size_policy=manual;
Jared
On Tue, 2003-12-23 at 07:24, Jeroen van Sluisdam wrote:
Hi,
I have an ora-4030 problem related to pga memory
/var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_10264.trc:
ORA-04030: out of process memory when trying to allocate 2464 bytes (cursor
work he,rworalo : rwordops)
Tue Dec 23 14:24:40 2003
Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_10249.trc:
ORA-00600: internal error code
Sinardy, where does oracle say anything like that about free memory? Please,
quote me an article or URL. Second, if you are not using MTS, your PGA is a
part of your dedicated server address space, not SGA. It does exist, though.
Similarly, UGA goes to shared pool instead. Buy yourself The Book
Hi,
Those are lines from my friend Oracle University student guide (Original)
Sinardy
-Original Message-
Sent: 16 December 2003 22:34
To: Multiple recipients of list ORACLE-L
Sinardy, where does oracle say anything like that about free memory? Please,
quote me an article or URL
Hi
all,
Why free memory in
v$sgastat is a symptom of the fragmentation?
Why these "free
memory" aremore properly thought of as wasted space?
Thanks
Sinardy
Sinardy, you've attended wrong database tuning course. You need free memory in your
shared pool.
There is no such thing as sga fragmentation unless there is not enough free memory
to satisfy average
request. While oracle is not monitoring the size of an average shared pool request.
you have
Hi Mladen,
I try to understand 8i, and I am not using MTS, my current understanding is UGA and
PGA only exists (I mean in use or in the picture) when you are using MTS.
Oracle themselves said 'free memory' are more properly thought of as wasted space
I just wondering why this million dollar
:
Paul
Drake
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 04, 2003 7:34
PM
Subject: Re: How windows manage memory:
oracle
Hi.
The 2 GB process limit kicks in well under 2 * 1024 *1024 * 1024.
its between 1.7 and 1.8 GB.
I'm quite familiar
PROTECTED] On Behalf Of
Yechiel AdarSent: 05 December 2003 07:24To: Multiple
recipients of list ORACLE-LSubject: Re: How windows manage memory:
oracle
Thanks Paul.
I did a check this week with out Win2000 tech support
and was told that it come with 3GB process size while WNT was limited
, they just left off most of the good pieces in
order to release new versions sooner...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:19 PM
That is utterly disgusting memory management. When I come to think
Hi, friends:
Several months ago there is a thread talking about choosing the proper memory size
for windows server running oracle.
And today I logon to one of my small oracle on NT and found something I cannot
understand. It is a small application running Oracle 817/win2k.
SGA
Hi,
But PGA is only 40M(This is the sum of all process's v$sesstat).
So there is more memory utilization then oracle actually should use.
From task manager, it is 2018(Physical+Virtual), But from oracle v$(sga + pga) it
is only 1020M.This is the problem.
Zhu Chao.
- Original
Hi.
The 2 GB process limit kicks in well under 2 * 1024 *1024 * 1024.
its between 1.7 and 1.8 GB.
I'm quite familiar with hitting it in win32, as large memory support was not enabled in every 8.1.7.x patchset. Large memory support sure works great in 9.2.0.4.
W2K3 Server (not Advanced) ships
SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from task
manager, Oracle is using 1005M physical Memory and 1013M virtual memory(you
can view the data from here:
http://www.cnoug.org/html/ut/attach/2003/12/04/12516-oramem2-embed.gif).
Physical memory and virtual memory overlap
That is utterly disgusting memory management. When I come to think
of it, there was a guy named David Cutler who was promising that Windows
will have the same virtual memory system as VMS, with FREELIM,FREEGOAL,
BORROWLIM, GROWLIM and MPW_ parameters. Working sets are also gone as
well as the most
of the good pieces in
order to release new versions sooner...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:19 PM
That is utterly disgusting memory management. When I come to think
of it, there was a guy
That is utterly disgusting memory management. When I come to think
of it, there was a guy named David Cutler who was promising that Windows
will have the same virtual memory system as VMS, with FREELIM,FREEGOAL,
BORROWLIM, GROWLIM and MPW_ parameters. Working sets are also gone as
well as the most elaborate
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
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
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
Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SVRMGR connect internal
Connected.
SVRMGR startup pfile ='/app/oracle/admin/devbcm/pfile/initdevbcm.ora'
nomount
ORA-27102: out of memory
Compaq Tru64 UNIX Error: 12: Not enough space
Additional
SVRMGR connect internal
Connected.
SVRMGR startup pfile ='/app/oracle/admin/devbcm/pfile/initdevbcm.ora'
nomount
ORA-27102: out of memory
Compaq Tru64 UNIX Error: 12: Not enough space
Additional information: 1
Additional information: 98307
My Shm parameters are as given below .
$ /sbin
what is meant by OP,tanel..
Original Poster.
Tanel.
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
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 [kswa
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
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
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
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 lis
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
hi
i have a system that has no active users at this point of time. the memory used by the dbw process is very high leading to a lot of swapping when any process starts.
here are the spces
version:9.2.0.4
os:Linux 2.4.9-e.24smp
o/p from top:
1:44pm up 29 days, 23:55, 4 users, load average: 1.73
If I'm not mistaken, this figure includes the size of the shared memory
segment from the SGA. Take the output of the oracle line of ipcs -a
(hopefully you'll only have one!) and subtract it from the process size to
get a better idea of the non-shared memory size of the process.
Rich
Rich Jesse
rich
the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08)is used by non shared memory size.
i went thru all the processes and found dbwr using the max %mem. what could be the reason?
sai"Jesse, Rich" [EMAIL PROTECTED] wrote:
If I'm not mistaken, this figure include
Fellow Listers,
Could you please share your experience with Automatic Undo Management and
Automatic Memory Management. Would you recommend it?
One of the Sr. DBAs here suggested not to implement automatic memory
management in 9.2.0.3 but wants to implement it in 9.2.0.4. His suggestion
Thanks Raj,
I knew about dbms_system.ksdwrt to write to trace files or the alert log
or both but not these two. I have see from google that kcfrms allows the
resetting of IO counters in v$session_event and v$filestat. And KSDFLS
is part of the suite of functions to write to the alert log or
Thanks very much Gopal, I have just replied to Raj's post on the same
subject.
kind regards
Pete
In article [EMAIL PROTECTED], K Gopalakrishnan
[EMAIL PROTECTED] writes
Pete:
Sorry for the delay. I was traveling back to Bangalore from San Francisco
when you sent the message. There is a
Pete:
Sorry for the delay. I was traveling back to Bangalore from San Francisco
when you sent the message. There is a procedure in the DBMS_SYSTEM package
called KCFRMS which resets certain timing information from the X$KCFIO
(which is exposed as V$FILESTAT).
And also there is an event which can
Hi Gopal,
I have followed this thread with interest and i was waiting for you to
elaborate on the following statement, specifically what undocumented
procedures ?
kind regards
Pete
code and you can not create/update/delete them. However there are some
undocumented procudures , thru which you
Title: RE: x$ constructs and memory
dbms_system.KCFRMS|KSDFLS (not sure about this one).
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod
database structures when database doesn't exist or isn't mounted/open. The
translation of SGA memory structures to a returnable row set is pure C code,
I think.
Or if you can point me to these certain catalog scripts, I'd be glad to
read them :O)
But yes, about the fixed area I wasn't entirely correct
Hi Steve and welcome back,
Thanks for that detailed answer BUT... A practical question from the
original post remains: What happens when these x$constructs begin to
consume large amounts of memory? From your explanation I'm assuming
that, beyond monitoring the SGA and PGA, memory consumption
I don't generally get too involved in the x$ stuff, just because it
normally helps me very little in my DBA work.
Nonetheless, I have been following this one somewhat, and if my
understanding is correct, x$ tables are not actually responsible
for consuming memory, they are merely a mechanism
Mladen:
I am not sure where I am failing to understand you ;). First of all X$
objects are NOT
tables, so there is no question of blocks or memory or dictionary cache.
They are some
C structures and their point in time (I am not finding a better word) values
are exposed
as table formats
Hi Steve,
The X$ interfaces do not use memory persistently, and the memory usage of
the X$ tables is fixed and necessary to an instance. Thus memory growth is
not possible.
Memory growth is possible for the segmented arrays, which some of the X$
interfaces expose. However, it is very unusual
or memory or dictionary cache.
They are some
C structures and their point in time (I am not finding a better word)
values
are exposed
as table formats. That is what my understanding.
I don't see any relation between them and dictionary cache.. AM I missing
something?
Regards,
Gopal
I was sitting on a mountain here in Colorado, pondering Oracle
optimization and an interesting scenario crossed my feeble mind.
As I began to ponder this (I asked the resident marmot, but he
must be a SQL*Server expert...), I came up with several
questions.
Where in memory (sga or other) do the x
PROTECTED]
Sent: Monday, September 29, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L
Subject: x$ constructs and memory
I was sitting on a mountain here in Colorado, pondering Oracle
optimization and an interesting scenario crossed my feeble mind.
As I began to ponder this (I asked
1 - 100 of 536 matches
Mail list logo
