-----怪了
SQL> set serveroutput on
SQL> set timing on
SQL> EXEC DBMS_LOCK.SLEEP(5);PL/SQL 过程已成功完成。已用时间: 00: 00: 10.03
SQL>
-----怪了
SQL> set serveroutput on
SQL> set timing on
SQL> EXEC DBMS_LOCK.SLEEP(5);PL/SQL 过程已成功完成。已用时间: 00: 00: 10.03
SQL>
-----怪了
解决方案 »
- 修改主键增长的位数
- oracle通过透明网关访问sybase时,为什么不能增,删,改呢,只能select
- 如何查询oracle某个用户下面的包名列表
- oracle的初始化设置
- oracle10g在linux下的 监听器(listener)问题 高分
- 晕:system居然能修改sys的密码,是什么地方出问题了?郁闷。。。。。。。。。。。。。。。
- 图像、音频数据库的设计
- 我在查询v$latch时oracle报ORA-03113: end-of-file on communication channel,请解答一下。
- Oracle数据库中长字符串用什么?
- 如何将sql-server中表的数据导入到oracle中呢?-在线等待!!!
- 纠结于Oracle
- 求一个简单的linux oci 的连接查询例子
............网络环境还真配合.
SQL> EXEC DBMS_LOCK.SLEEP(10);PL/SQL 过程已成功完成。已用时间: 00: 00: 20.17
SQL> EXEC DBMS_LOCK.SLEEP(20);PL/SQL 过程已成功完成。已用时间: 00: 00: 40.35
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Productionsys@MYDB> set timing on;
sys@MYDB> exec dbms_lock.sleep(5);PL/SQL 过程已成功完成。已用时间: 00: 00: 05.02
sys@MYDB> exec dbms_lock.sleep(5);PL/SQL 过程已成功完成。已用时间: 00: 00: 05.01
sys@MYDB>
咱俩的版本不一样.
SQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production已用时间: 00: 00: 00.10
SQL>
咱俩的版本不一样.
SQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production已用时间: 00: 00: 00.10
SQL>
sys@MYDB> select dbms_utility.get_time time from dual; TIME
----------
195126sys@MYDB> select count(*) from dba_objects; COUNT(*)
----------
29548sys@MYDB> select dbms_utility.get_time-&last_time 用时 from dual;
原值 1: select dbms_utility.get_time-&last_time 用时 from dual
新值 1: select dbms_utility.get_time- 195126 用时 from dual 用时
----------
12
--先创建表
create table t_test_sleep
(id number,
time date);
--再执行测试过程
begin
insert into t_test_sleep
values(1,sysdate);
dbms_lock.sleep(5);
insert into t_test_sleep
values(2,sysdate);
commit;
end;SQL> begin
2 insert into t_test_sleep
3 values(1,sysdate);
4 dbms_lock.sleep(5);
5 insert into t_test_sleep
6 values(2,sysdate);
7 commit;
8 end;
9 /
PL/SQL procedure successfully completed
SQL> select id,to_char(time,'yyyy-mm-dd hh24:mi:ss') from t_test_sleep;
ID TO_CHAR(TIME,'YYYY-MM-DDHH24:M
---------- ------------------------------
1 2010-12-26 09:27:54
2 2010-12-26 09:27:59
SQL>
scott@ORCL> set timing on
scott@ORCL> EXEC DBMS_LOCK.SLEEP(5)PL/SQL 过程已成功完成。已用时间: 00: 00: 05.01
scott@ORCL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'
2 /会话已更改。已用时间: 00: 00: 00.00
scott@ORCL> ed
已写入 file afiedt.buf 1 declare
2 dt1 date;
3 dt2 date;
4 begin
5 dt1:=sysdate;
6 DBMS_LOCK.SLEEP(5);
7 dt2:=sysdate;
8 dbms_output.put_line(dt1);
9 dbms_output.put_line(dt2);
10* end;
scott@ORCL> /
2010-12-27 09:55:12
2010-12-27 09:55:17PL/SQL 过程已成功完成。已用时间: 00: 00: 05.00
------直接查询v$sqlarea
SQL> set timing on;
SQL> EXEC DBMS_LOCK.SLEEP(5);PL/SQL procedure successfully completedExecuted in 5 secondsSQL>
SQL> select i.PLSQL_EXEC_TIME, i.CPU_TIME
2 from v$sqlarea i
3 where sql_text like '%DBMS_LOCK.SLEEP(5)%'
4 order by i.FIRST_LOAD_TIME desc
5 ;PLSQL_EXEC_TIME CPU_TIME
--------------- ----------
0 1435
0 2835
9661 2532Executed in 0 secondsSQL>
SQL> alter system set cpu_count=4 scope=both;
SQL> EXEC DBMS_LOCK.SLEEP(5);
SQL> alter system set cpu_count=4 scope=both;
SQL> EXEC DBMS_LOCK.SLEEP(5);
单位服务器不是什么4核的,但也至少是双核的,貌似没发现楼主所说的情况。
按wkc168的方法测试下看看,能确认在更改cpu_count参数前后数值有变化?