ORA-22280: no more buffers available for operation



ORA-22280: no more buffers available for operation..

Answer / guest

Cause: There are two causes: (1) All buffers in the buffer
pool have been used up by previous operations (2) Attempt to
flush a LOB without any previous buffered update operations.

Action: For (1), flush the LOB(s) through the locator that
is being used to update the LOB. For (2), write to the LOB
through a locator enabled for buffering before attempting to
flush buffers.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16771: Converting physical standby to primary failed in the failover operation.

1 Answers  


ORA-32147: Environment not specified

1 Answers  


ORA-07474: snclrd: close error, unable to close sgadef.dbf file.

1 Answers  


ORA-08232: smsdes: cannot detach from SGA

1 Answers  


TNS-01416: Process ID string

1 Answers  






TNS-01421: Session: string

1 Answers  


ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.

1 Answers  


RMAN-05511: Datafile string skipped by request

1 Answers  


ORA-22340: cannot string type "string"."string". Dependent tables must be upgraded to latest version

1 Answers  


NNL-00342: Log file name is currently string

1 Answers  


KUP-04015: internal SLF error

1 Answers  


ORA-29957: cannot create a function-based domain index on a string table

1 Answers  


Categories