Home » RDBMS Server » Server Administration » High Pagein problem
High Pagein problem [message #55767] Fri, 14 February 2003 06:20 Go to next message
TX
Messages: 1
Registered: February 2003
Junior Member
I have an Oracle 8.1.7 DB on Sol. 8. with 8GB Memory

Total System Global Area 10910368 bytes
Fixed Size 73888 bytes
Variable Size 405856256 bytes
Database Buffers 204800000 bytes
Redo Buffers 180224 bytes

I have very high pagein, no pageout and 0 scan rate from vmstat, the performance from the application is a nightmare.

Why is there a high pagein and can someone offer a 'remedy'

Disk are Solaris Disksuite 3x30GB mirrored on 3x30GB

Report message to a moderator

Re: High Pagein problem [message #55778 is a reply to message #55767] Sat, 15 February 2003 03:44 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hello,
I think the problem lies in Setting the SGA size and all.. refer to Doc ID: Note:1020329.6 in Metalink...It talks about tuning the memory on sun solaris..

sai

Report message to a moderator

Previous Topic: Corruption in Database
Next Topic: PMON - CAUSING CPU 100%
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:51:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.