当前位置：Gxlcms >
数据库问题 >
连接oracle数据库，修改启动定时任务所需项 job_queue_processes
连接oracle数据库，修改启动定时任务所需项 job_queue_processes
时间：2021-07-01 10:21:17
帮助过：16人阅读
C:\Users\Administrator>sqlplus sys/sys@192.168.1.251/
orcl as sysdba
2
3 SQL*Plus: Release 11.2.0.1.0 Production on 星期六 12月 16 03:51:28 2017
4
5 Copyright (c) 1982, 2010
, Oracle. All rights reserved.
6
7
8 连接到:
9 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
64bit Production
10 With the Partitioning, OLAP, Data Mining and Real Application Testing options
11
12 SQL> select value from v
$parameter where name like ‘%job_queue_processes%
‘
13 2
14 SQL> alter system set job_queue_processes = 30
15 2
16 SQL> alter system set job_queue_processes = 30
;
17
18 系统已更改。
19
20 SQL> select value from v
$parameter where name like ‘%job_queue_processes%
‘ ;
21
22 VALUE
23 --------------------------------------------------------------------------------
24
25 30
26
27 SQL> select value from v
$parameter where name like ‘%job_queue_processes%‘
连接oracle数据库，修改启动定时任务所需项 job_queue_processes
标签：ola 64bit real blog system log select ati bsp
