创建一个系统级的触发器试试,如下:以XXX/yyyy@ZZZdb as sysdba登录数据库SQL> conn XXX/yyyy@ZZZdb as sysdba
已连接。
SQL> create or replace trigger logon_trigger
2 after logon on database
3 declare
4 begin
5 if user='XXX' then
6 for x in (select value from v$parameter where name='job_queue_processes') loop
7 if x.value<10 then
8 execute immediate 'alter system set job_queue_processes=10';
9 end if;
10 end loop;
11 end if;
12 end logon_trigger;
13 /触发器已创建
已连接。
SQL> create or replace trigger logon_trigger
2 after logon on database
3 declare
4 begin
5 if user='XXX' then
6 for x in (select value from v$parameter where name='job_queue_processes') loop
7 if x.value<10 then
8 execute immediate 'alter system set job_queue_processes=10';
9 end if;
10 end loop;
11 end if;
12 end logon_trigger;
13 /触发器已创建
关于spfile的应用可以下载:http://www.eygle.com/pdf/oracle9ispfile.pdf