OraFAQ Forum: Server Administration » SQL Error: ORA-00379

Home » RDBMS Server » Server Administration » SQL Error: ORA-00379 (ORACLE DATABASE)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Error: ORA-00379 [message #619188]

Fri, 18 July 2014 14:55

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

Report message to a moderator

Re: SQL Error: ORA-00379 [message #619189 is a reply to message #619188]

Fri, 18 July 2014 14:58

BlackSwan
Messages: 26757
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

Report message to a moderator

Re: SQL Error: ORA-00379 [message #619196 is a reply to message #619188]

Sat, 19 July 2014 00:45

Michel Cadot
Messages: 67667
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Execute:

show parameter buffer
show parameter cache

Report message to a moderator

Re: SQL Error: ORA-00379 [message #619210 is a reply to message #619196]

Sat, 19 July 2014 10:35

Lalit Kumar B
Messages: 3171
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.

Report message to a moderator

Previous Topic:	Default Limit of Resources
Next Topic:	impact of shutdown abort in backup mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 27 00:24:31 CST 2021