How do you use automatic PGA memory management with Oracle 9i and above?

- Newsfeed
- Find People
- More
- - Products By Bayt.com
    
    Bayt.com
    
    Shagheel
    
    Specialities
    
    Learning
    
    Companies
    
    Salaries
    
    People
    
    Blog
    
    Podcasts
- - العربية
- Use Our Mobile App
  
  Get contacted by recruiters directly with our newest chat feature!
  
  Download Now

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
Swift vs Objective - c in terms of Memory Management?
Posted by:
mohammed shafiullah
21-October-2017

Question added by khalid Hassanien , Financial Manger , Alrwania Ltd
Date Posted: 2014/10/12

Upvote (0) Views (1) Followers (1) Answers (1) Report Question

Write an Answer
Register now or log in to answer.

1 Answers

Dhairyasheel Tawade

by Dhairyasheel Tawade , Principal Technical Account Manager , Oracle India

Just set PGA_AGGREGATE_TARGET TO SOME VALUE.

SET WORKAREA_SIZE_POLICY=AUTO AND WORT_AREA_SIZE TO NULL.

Upvote (0)

Downvote Reply () Report

Popular Searches

Engineers Jobs Sales Executive Jobs Accountant Jobs Engineering Technicians Jobs Software Engineer Jobs

Write Your Answer

More Questions Like This

What is the difference bitween sga and pga memory in oracle?
Top Answer: System Global Area (SGA) The SGA is a read/write memory area that stores information shared by all databa ... See More

Answers (3)
What would be best memory management strategy while writing a recursive function/method?
Top Answer: Use of Dynamic Memory Allocation to Overcome Stack Overflow and Conversion of the Recursive Function into ... See More

Answers (1)
One of the important advantages of using control charts in managing a production operation is that the control chart tells you when to take corrective action on the process being controlled. Another important result of using control charts is:
Top Answer: Option B is the correct in my opinion See More

Answers (9)
Whats the Excellent way to solve the memory leak problem in android app?
Top Answer: A memory leaks occur in java when you forget to close resource ,or a reference to an object is not releas ... See More

Answers (2)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help