Re: shared pool

From: Ian Cary <ian.cary_at_ons.gsi.gov.uk>
Date: Mon, 8 Jun 2009 15:59:59 +0100
Message-ID: <OFAD014053.E03DC86B-ON802575CF.00522B02-802575CF.0052655B_at_ons.gsi.gov.uk>

Presumably because you are using automatic shared memory mananagement and you have SGA_TARGET set where SGA_TARGET is the total size for all *_pool parameters and Oracle automatically sizes them.

N.B. if any *_pool paramters are set these will act as minimum values for the specified pool.

Cheers,

Ian

|---------+----------------------------->


|         |           Brian.Zelli_at_Roswel|

|         |           lPark.org         |

|         |           Sent by:          |

|         |           oracle-l-bounce_at_fr|

|         |           eelists.org       |

|         |                             |

|         |                             |

|         |           08/06/2009 15:38  |

|         |           Please respond to |

|         |           Brian.Zelli       |

|         |                             |

|---------+----------------------------->
  >--------------------------------------------------------------------------------------------------------------|
  |                                                                                                              |
  |       To:       oracle-l_at_freelists.org                                                                       |
  |       cc:                                                                                                    |
  |       Subject:  shared pool                                                                                  |
  >--------------------------------------------------------------------------------------------------------------|

Hello all,

   Oracle 10gR2 on HPUX. Thought I would do a little tuning. My shared pool shows a size of 0. Why?

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

ciao,

Brian

This email was received from the INTERNET and scanned by the Government Secure Intranet anti-virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In case of problems, please call your organisation’s IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk

---

Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications

---

Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics

---

The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes. †Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Mon Jun 08 2009 - 09:59:59 CDT