Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Archiver Process using paging space on AIX

845567Mar 8 2011 — edited Jul 2 2012

Hi everyone

Hope that I'm in the right forum to post this threat.
We are running Oracle database (10g/11g) on AIX 6.1 and we are seeing a high paging space usage although the server memory does not seem to be overcommitted (telling from SGA and PGA settings and usage). The servers are dedicated database servers so no other application (besides system-mgmt) is running.

What I see on the server is that as soon as there is workload on the database the paging space seems to slowly be eaten up. Looking at the main processes using paging space it always turns out to be the ora_arc and ora_lgwr processes using paging space and I don't have a clue why this is happening.

Anybody got an idea?

Thanks
Marco

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2012

Added on Mar 8 2011

#general-database-discussions

12 comments

4,046 views