第24次：2014-08-14-plsqldev.sql

botang · 发表于 2014-8-15 08:34:50

select * from ( select s.SQL_TEXT, s.CPU_TIME
from v_$sql s order by cpu_time desc ) where rownum <=6;
select * from v$statname ;
select * from (select s.USERNAME, s.SID, s.TERMINAL , se.VALUE , n.NAME from
v_$session s, v_$sesstat se , v_$statname n
where s.SID=se.SID and se.STATISTIC#=n.STATISTIC# and n.NAME='CPU used by this session' order by se.VALUE desc ) where rownum <=6 ;
select s.USERNAME, s.SID, s.TERMINAL , se.VALUE , n.NAME from
v_$session s, v_$sesstat se , v_$statname n
where s.SID=se.SID and se.STATISTIC#=n.STATISTIC# and n.NAME='redo size' and s.sid=73;
select * from v$fixed_table where name like 'V$%ADVICE%';
select * from V$MEMORY_TARGET_ADVICE;
select * from V$SGA_TARGET_ADVICE;
select component , current_size, current_size/1024/1024 from v$sga_dynamic_components;
select * from V$SHARED_POOL_ADVICE;
select * from V$DB_CACHE_ADVICE;
select * from v$sgastat;
select * from v$sgainfo;
select i.index_name ,i.blevel from dba_indexes i where i.table_owner='HR';
alter index hr.I04209_UNAME_VALUE rebuild online;
create or replace procedure hr.proc05213
is
v_1 number;
begin
select count(*) into v_1 from hr.t04209_uname;
dbms_output.put_line('The total number is '||v_1||'.');
end;
select * from dba_objects o where o.object_name='PROC05213' ;
begin
hr.proc05213;
end;
alter table hr.t04209_uname drop ( uvalue) ;
select * from dba_objects o where o.object_name='PROC05213' ;
alter table hr.t04209_uname add ( uvalue number) ;
alter procedure hr.proc05213 compile;

复制代码