Oracle Wait Events

鸟儿的翅膀系上黄金,它就飞不起来了.

declare

begin

dbms_lock.sleep(120);

end;

grant execute on dbms_lock to scott

select sid,event,total_waits,average_wait from v$session_wait where sid=144

insert into stats$begin_dc select * from v$rowcache;

 

A collection of wait events provides information on the sessions that had to wait or must wait for different reasons

These events are listed in the v$event_name view which has the following columns:

event#

name

parameter1

parameter2

parameter3

 

 

select name from v$dbfile

create tablespace perftab datafile 'muluming' size 200M; 创建表空间

select job from dba_jobs

@

spool off

execute dbms_job.run(21) 运行job21

host cd

desc dbms_workload_repository

execute dbms_workload_repository,create_snapshot