| Reg : Buffer cache Error [message #60780] |
Thu, 04 March 2004 20:01  |
Dhanasekaran
Messages: 9
Registered: December 2003
|
Junior Member |
|
|
Hi,
The Error number is ORA -00381. I can't use both parameter of buffer cache Error. Could you please give tips for solve my problem as immediately..
Thanks in Advance,
A.Dhans.
|
|
|
|
| Re: Reg : Buffer cache Error [message #60785 is a reply to message #60780] |
Fri, 05 March 2004 01:20  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
$ oerr ora 381
00381, 00000, "cannot use both new and old parameters for buffer cache size specification"
// *Cause: User specified one or more of { db_cache_size ,
// db_recycle_cache_size, db_keep_cache_size,
// db_nk_cache_size (where n is one of 2,4,8,16,32),
// db_cache_advice } AND one or more of { db_block_buffers,
// buffer_pool_keep , buffer_pool_recycle }. This is illegal.
// *Action: Use EITHER the old (pre-Oracle_8.2) parameters OR the new
// ones. Don't specify both. If old size parameters are specified in
// the parameter file, you may want to replace them with new parameters
// since the new parameters can be modified dynamically and allow
// you to configure additional caches for additional block sizes.
// Cache advisory can only be enabled with the new cache parameters.
//
Best regards.
Frank
|
|
|
|
| Re: Reg : Buffer cache Error [message #60807 is a reply to message #60785] |
Mon, 08 March 2004 03:35 |
Pradeep George
Messages: 6
Registered: March 2004
|
Junior Member |
|
|
Which version of oracle you are using ? guess it is 9i.
If so use the new set of parameters only .Be infomred that in oracle 9i you can create maulitple buffer area for muliple block sizes exists in the database.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
