Home » RDBMS Server » Server Administration » SQL Error: ORA-00379 (ORACLE DATABASE)
icon5.gif  SQL Error: ORA-00379 [message #619188] Fri, 18 July 2014 14:55 Go to next message
amanyghoniem
Messages: 1
Registered: July 2014
Location: alexandria-egypt
Junior Member
I'M NEW TO ORACLE DATABASE
I ALWAYS GET THIS ERROR WHEN I TRY TO CREATE ANYTHING IN SCOTT OR A PLSQL STATEMENT
SQL Error: ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K

PLEASE BE SPECIFIC I'M STILL TRYING TO FIGURE IT OUT
Re: SQL Error: ORA-00379 [message #619189 is a reply to message #619188] Fri, 18 July 2014 14:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/


00379, 00000, "no free buffers available in buffer pool %s for block size %sK"
// *Cause:  All buffers in the specified buffer pool for the specified block size
//          are in use and no free buffers are available.
// *Action: Increase the number of buffers in the specified pool for the specified
//          block size
Re: SQL Error: ORA-00379 [message #619196 is a reply to message #619188] Sat, 19 July 2014 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Execute:
show parameter buffer
show parameter cache


Re: SQL Error: ORA-00379 [message #619210 is a reply to message #619196] Sat, 19 July 2014 10:35 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Welcome to the forum!

Is ASMM or AMM enabled? Oracle handles it automatically for you.
Previous Topic: Default Limit of Resources
Next Topic: impact of shutdown abort in backup mode
Goto Forum:
  


Current Time: Mon Mar 18 22:03:00 CDT 2024