?
Solved

Oracle 10g2, problem uses too much swap

Posted on 2008-11-12
3
Medium Priority
?
404 Views
Last Modified: 2013-12-19
I have Oracle database 10.2.0.2 on SLES 10 with one running instance. The instance is configured with the Sga_target to 2,4 GB. The server has 8 GB physical memory and 10GB of swap. However all 8GB of RAM and 4GB out of 10GB of swap is consumed mostly by ORACLE. I would like Oracle to reside only in RAM, not in swap.

Any idea, why all oracle process use so much memory?

Regards

Groxy

The pfile:

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
 
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16
 
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
 
###########################################
# Database Identification
###########################################
db_domain=WORLD
db_name=ABEX
 
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/opt/oracle/admin/ABEX/bdump
core_dump_dest=/opt/oracle/admin/ABEX/cdump
user_dump_dest=/opt/oracle/admin/ABEX/udump
 
###########################################
# File Configuration
###########################################
db_create_file_dest=+DATA1
db_recovery_file_dest=/Oracle-FlashRecoveryArea
#db_recovery_file_dest_size=104857600000
db_recovery_file_dest_size=60000000000
###########################################
# Job Queues
###########################################
job_queue_processes=10
 
###########################################
# Miscellaneous
###########################################
compatible=10.2.0.2.0
 
###########################################
# NLS
###########################################
nls_language="POLISH"
nls_territory="POLAND"
 
###########################################
# Processes and Sessions
###########################################
processes=150
 
###########################################
# SGA Memory
###########################################

sga_target=2479882240
###########################################
# Security and Auditing
###########################################
audit_file_dest=/opt/oracle/admin/ABEX/adump
remote_login_passwordfile=EXCLUSIVE
 
###########################################
# Shared Server
###########################################
#dispatchers="(PROTOCOL=TCP) (SERVICE=ABEXXDB)"
 
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=826277888
 
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1
 
control_files=("+DATA1/kolo/controlfile/current.316.652970077", "/Oracle-FlashRecoveryArea/ABEX/controlfile/o1_mf_413dxxvs_.ctl")
*.utl_file_dir='*'

top-abex.jpg
em-abex.jpg
0
Comment
Question by:adamgasior
1 Comment
 
LVL 23

Accepted Solution

by:
David earned 360 total points
ID: 22938527
As I read it, your PGA AGGREGATE TARGET of 8Gb equals your entire RAM.  The rule of thumb is 50 to 80% for all non-overhead processes.  Pare that back and recheck your statistics please.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Course of the Month16 days, 5 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question