Two different methods exist to change or create hidden parameters (name begins with an underscore) such as _job_queue_interval.
• The first one is to do:
alter system set "_job_queue_interval"=1
• Another one is to change the parameters in the pfile, then to export modifications from this pfile to spfile:
1 2 3 4
| connect sys/*******@dbname as sysdba
/* create a pfile from current spfile */
CREATE PFILE='C:\oracle\admin\dbname\pfile\init_edit.ora'
FROM SPFILE='C:\oracle\ora92\database\SPFILEEUROPA.ORA'; |
Modify the created pfile, using a text editor, add or modify hidden parameters.
Then:
1 2 3 4
| /* create a spfile from modified pfile */
CREATE SPFILE='C:\oracle\ora92\database\SPFILEEUROPA2.ORA'
FROM PFILE='C:\oracle\admin\dbname\pfile\init_edit.ora';
Shutdown immediate; |
Rename the new spfile with the name of the current one.
Then:
At this point, all modifications applied are visible in database.
Partager