on 07-15-2010 8:00 AM
hi Experts,
please try to solve my query, here in my system redo log buffer shows(alert monitoring) 99<4000 and message is '4000 redo entries per redo log space requests'
so i think i need to increase log_buffer parameter value upto required level ,then i entered in database
splplus / as sysdba
and i try to check my file is in which type (spfile or in pfile) by executing command
" SHOW PARAMETER pfile"
it shows
name--- spfile
type---string
value---/oracle/qty/102_64/dbs/spfileqty.ora
when i Excute 'SHOW PARAMETER spfile' also the same result
now in here i have doubt please clarify me
1) my file is spfile or pfile ?
2) how can i increase my parameter value (alter system set log_buffer = xxx scope=pfile (or) spfile )
3) is that my process correct for that error
please clarify me
thanks & regards
Hi,
As per my knowledge, Oracle 10g by default starts with SPFILE and if you are setting the parameter with alter command then yes the scope should be SPFILE. After that when you schedule any DB related activity(backup, update statistics etc.,) it will create pfile from spfile.
Before doing any changes take the backup of the existing files both (pfile and spfile) at os level.
Regards,
Sharath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can change the parameter at database level when it is on, but it will come in to affect only after restart. Hence I would suggest you to first take a downtime and then stop SAP. After that make the parameters changes in the database and then stop and start the database. Check if the new parameter value is showing up and after that start SAP.
Regards,
Sharath
the log_buffer is used to store the redo info temporarely to reduce disk IO... when the operation commits the buffer is flushed... a small buffer I presume could give you performance issues a large buffer is useless as the buffer will be flushed before it could use it.. Read the recommended value in the Note and you'll be fine.
Regards
Juan
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.