Solved

oracle 11g on z/linux

Posted on 2013-01-31
2
550 Views
Last Modified: 2013-03-13
Hi all,

first let me preface this question with... I do not yet have access to the server or database and i have only seen 1 awr report and a the output from df-k and du.

I have an 11g database running on z-linux and frequently the thing starts swapping to disk.  The server has 72g of ram and it is not that heavily used.  some things that jumped out at me are
pga_aggregate_target       6442450944 or 6g
sga_max_size             59055800320  = 55g

Instance Activity Stats - Absolute Values
Statistic Begin Value End Value 
session pga memory max 3,872,656,816 3,125,364,624 
session cursor cache count 1,279,656 1,432,730 
session uga memory 63,353,187,248 63,755,218,768 
opened cursors current 15,253 17,204 
workarea memory allocated 172,094 261,297 
logons current 488 539 
session uga memory max 106,526,891,136 113,217,114,960 
session pga memory 2,009,472,880 2,236,766,544 

Open in new window


so the UGA is greater than the pga
another thing i noticed or rather didnt notice is the shmfs
I recall when installing 11g on redhat and using more than 25% of avail memory i had to set my shmfs or i would get memory_target not supported.

my question is on z-linux is the shmfs required as it is on redhat and is it acceptable to have the uga > pga

Thanks

Steve
0
Comment
Question by:stevetheski
2 Comments
 
LVL 21

Accepted Solution

by:
oleggold earned 500 total points
ID: 38842197
first ,it's never acceptable to have uga>pga , something is really off , secondarily ,yes,You do have to set shmfs  ,z-linux can be more redhat in the installation but in the end it won't be pretty
0
 
LVL 4

Author Comment

by:stevetheski
ID: 38845064
have you ever seen UGA > PGA if so why was it so high.  monday I MAY have access to the server.

Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PHP Apache application gives "Forbidden" message 5 43
AWS CLI - Issue with name display 2 47
Get the parent node - XMLTYPE 9 55
Processing of multiple cursor 6 35
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
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.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

943 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now