tiple recipients of list ORACLE-LSubject: RE:
Paging problem in SunOS
He
is having paging problems and you are recommending that he increase his
SGA? Could
you
explain how you feel that will solve his problem please?
Thx
-Original Message-From: [EMAIL PROT
What are your paging statistics?
run 'vmstat 10 10' during a period of poor performace
and post the output back to the list.
Jared
On Friday 03 May 2002 05:38, Pradyut Mitra wrote:
> Hi,I am experiencing a massive performance problem due tohigh page-in
> operation In Sun OS 5.6/Oracle 8.1.
AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Paging problem in SunOS
I
think your SGA is too small. It should be around 200-250MB
totally.
-Original Message-From: Pradyut Mitra
[mailto:[EMAIL PROTECTED]]Sent: Friday, May 03, 2002 8:38
AMTo: Multiple
Your SGA is pretty small by usual standards - which is not, in itself, a cause for
alarm, and, in any case, you shouldn't experience the SGA being swapped in and out. In
practice, it means that Oracle leaves lots of memory to other processes. I would look
for the culprit on the client side - yo
Hi
Pradyut,
Check
the distribution of your DB on your disks:
-Do U
have multiple /raided Disk sub-system ?
-If
so, what is your lay out in as tablespace datafile(s) location, index datafile
location, redo logs file location etc
If
possible post the above for an analysis of the same.
Thanki
I
think your SGA is too small. It should be around 200-250MB
totally.
-Original Message-From: Pradyut Mitra
[mailto:[EMAIL PROTECTED]]Sent: Friday, May 03, 2002 8:38
AMTo: Multiple recipients of list ORACLE-LSubject:
Paging problem in SunOS
Hi,I am experiencing a