How do you use automatic pga memory management with oracle 9i and above?
- 1 Answers
- 672 Views
- I also Faced
- E-Mail Answers
Answer / Nitesh Kumar Gupta
Automatic PGA memory management in Oracle 9i and later can be achieved by setting the parameters SESSION_CACHED_CURSORS, SHARED_POOL_SIZE, and DB_BLOCK_BUFFERERS. By default, these are set to dynamic values based on your system configuration.nFor example, if you want to set a maximum limit for session cached cursors, you can use the following command: ALTER SESSION SET sessions_cached_cursors = <number>.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why are recursive relationships bad? How do you resolve them?
I am getting error "no communication channel" after changing the domain name? What is the solution?
How many redo logs should you have and how should they be configured for maximum recoverability?
What is the use of the drop option in the alter table command?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
When should you increase copy latches? What parameters control copy latches?
What is a dba?
What are four common errors found in an alert .log?
How many types of database software are there?
When should the default values for oracle initialization parameters be used as is?
What database block size should I use?
What skills do you need to be a database administrator?
Oracle General 
