Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
to modifie DB_BLOCK_BUFFERS parameter
- Thread starter amalou
- Start date
SantaMufasa
Technical User
Amalou,
Your question (in English) is a bit puzzling, "...why can i modify it?" I'm not sure if you are asking "Why SHOULD I modify it?" or "How can I modify it?"
If you are asking "Why should I modify it?", you should modify it because Oracle does not run efficiently unless you specify at least several hundred DB_BLOCK_BUFFERS.
If you are asking "How can I modify it?", then you modify the setting in your "init<SID>.ora" file. (Depending upon your installed operating system, your init<SID>.ora parameter file resides, by default, in your $ORACLE_HOME/database path (Windows) or $ORACLE_HOME/dbs path (Unix). If someone has set up your Oracle as OFA-compliant, then it may be in your Oracle...admin/pfile path.) Once you locate your init<SID>.ora file, ensure there is a parameter that says: "DB_BLOCK_BUFFERS=value", where "value" is the number of database blocks you want your Oracle to allocate for the database buffer cache.
Let me know if this is what you wanted to know.
Dave
Sandy, Utah, USA @ 18:44 GMT, 11:44 Mountain Time
Your question (in English) is a bit puzzling, "...why can i modify it?" I'm not sure if you are asking "Why SHOULD I modify it?" or "How can I modify it?"
If you are asking "Why should I modify it?", you should modify it because Oracle does not run efficiently unless you specify at least several hundred DB_BLOCK_BUFFERS.
If you are asking "How can I modify it?", then you modify the setting in your "init<SID>.ora" file. (Depending upon your installed operating system, your init<SID>.ora parameter file resides, by default, in your $ORACLE_HOME/database path (Windows) or $ORACLE_HOME/dbs path (Unix). If someone has set up your Oracle as OFA-compliant, then it may be in your Oracle...admin/pfile path.) Once you locate your init<SID>.ora file, ensure there is a parameter that says: "DB_BLOCK_BUFFERS=value", where "value" is the number of database blocks you want your Oracle to allocate for the database buffer cache.
Let me know if this is what you wanted to know.
Dave
Sandy, Utah, USA @ 18:44 GMT, 11:44 Mountain Time
Check db_cache_size (and probably db_Xk_cache_size) parameters and if they're large enough you may leave db_block_buffers untouched. Oracle 9i memory model slightly differs from that of previous releases, so DB_BLOCK_BUFFERS is obsolete in 9i.
Regards, Dima
Regards, Dima
SantaMufasa
Technical User
Dima,
"Obsolete" implies that DB_BLOCK_BUFFERS no longer works in 9i. Although there may be other methods to size the database buffer cache, DB_BLOCK_BUFFERS certainly does still work in 9i.
Dave
Sandy, Utah, USA @ 06:50 GMT, 23:50 Mountain Time
"Obsolete" implies that DB_BLOCK_BUFFERS no longer works in 9i. Although there may be other methods to size the database buffer cache, DB_BLOCK_BUFFERS certainly does still work in 9i.
Dave
Sandy, Utah, USA @ 06:50 GMT, 23:50 Mountain Time
- Thread starter
- #5
hi i have oracle 9.2 installed on aix 5.1
when i chage the value for DB_BLOCK_BUFFERS in spfile with the oracle administrateur utilitie i receive this message
ORA-00381 cannot use both newand old parameters for buffer cach size specification
when i chage the value for DB_BLOCK_BUFFERS in spfile with the oracle administrateur utilitie i receive this message
ORA-00381 cannot use both newand old parameters for buffer cach size specification
SantaMufasa
Technical User
Amalou,
You can specify db_cache_size as Dima suggests. But if you remove "new" buffer cache size specification references, you may still use the "old" DB_BLOCK_BUFFERS specification.
Dave
Sandy, Utah, USA @ 18:09 (23Nov03) GMT, 11:09 (23Nov03) Mountain Time
You can specify db_cache_size as Dima suggests. But if you remove "new" buffer cache size specification references, you may still use the "old" DB_BLOCK_BUFFERS specification.
Dave
Sandy, Utah, USA @ 18:09 (23Nov03) GMT, 11:09 (23Nov03) Mountain Time
Ok, Dave, you know English better than me, but IMO "Obsolete" doesn't imply "Invalid", but rather "Not recommended", in this case due to enhanced equivalent existence.
According to Meriam-Webster:
obsolete
a : no longer in use or no longer useful b : of a kind or style no longer current : OLD-FASHIONED
Regards, Dima
According to Meriam-Webster:
obsolete
a : no longer in use or no longer useful b : of a kind or style no longer current : OLD-FASHIONED
Regards, Dima
SantaMufasa
Technical User
Dima,
Thou knowest in thy heart that yea, I am yet but an Old-fashioned soul that dost yearn for a simpler time; thus, knowest ye not that if DB_BLOCK_BUFFERS works yet unto Oracle, albeit, of an older fashion, thus accordingly, I shall, therefore, continue its use unto eternity, Amen.
Dave
Sandy, Utah, USA @ 19:51 (24Nov03) GMT, 12:51 (24Nov03) Mountain Time
Thou knowest in thy heart that yea, I am yet but an Old-fashioned soul that dost yearn for a simpler time; thus, knowest ye not that if DB_BLOCK_BUFFERS works yet unto Oracle, albeit, of an older fashion, thus accordingly, I shall, therefore, continue its use unto eternity, Amen.
Dave
Sandy, Utah, USA @ 19:51 (24Nov03) GMT, 12:51 (24Nov03) Mountain Time
- Status
Similar threads
- Locked
- Question
