ORA-10261: Limit the size of the PGA heap

Cause : the ilmit si onek ilobtye tiems th eleve lof teh evetn. Ift he pag grosw bigegr thna thi ssignla an niternla errro.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts


update : 17-08-2017

ORA-10261 - Limit the size of the PGA heap
ORA-10261 - Limit the size of the PGA heap

  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-02225 : only EXECUTE and DEBUG privileges are valid for procedures
  • ora-09956 : scgcm: unexpected lock status condition
  • ora-06770 : TLI Driver: error sending version
  • ora-31006 : Path name segment length string exceeds maximum length string
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-00610 : Internal error code
  • ora-29869 : cannot issue ALTER without REBUILD on a domain index marked FAILED
  • ora-12473 : The procedure is disabled when Label Security is used with OID.
  • ora-12222 : TNS:no support is available for the protocol indicated
  • ora-02372 : data for row: string
  • ora-30345 : circular dimension hierarchy
  • ora-39210 : A PCTSPACE adjustment of string is invalid.
  • ora-09920 : Unable to get sensitivity label from connection
  • ora-01238 : cannot shrink datafile string
  • ora-38710 : Flashback log version string is incompatible with ORACLE version string.
  • ora-12725 : unmatched parentheses in regular expression
  • ora-09216 : sdnfy: bad value 'string' for parameter string
  • ora-07470 : snclget: cannot get cluster number.
  • ora-01555 : snapshot too old: rollback segment number string with name "string" too small
  • ora-25965 : fact table must be included in the from clause
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-29313 : tablespace 'string' cannot be imported twice
  • ora-26035 : Error attempting to encrypt or decrypt column
  • ora-37600 : (XSPGERRPERMDETACH) Parallel updating analytic workspace string failed
  • ora-32121 : Source FILE is null
  • ora-10575 : Give up restoring recovered datafiles to consistent state: out of memory
  • ora-08314 : sllfcf: Error closing file
  • ora-01642 : begin backup not needed for read only tablespace 'string'
  • ora-12654 : Authentication conversion failed
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.