Oracle常用操作

来源：互联网发布：安卓手机数据恢复编辑：程序博客网时间：2024/06/16 01:02

select lpad(to_char(13),4,'0') from dual;

update role_right t set t.right_desc =   'RIGHT_DESC_' || to_char(t.right_index);

SELECT * FROM V$DB_OBJECT_CACHE WHERE LOCKS!='0' order by locks desc;

select * from v$lock;

select username,lockwait,status,machine,program from v$session where sid in (select session_id from v$locked_object)；

select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;

select count(*) from wap.t_user us where us.create_time < to_date('2010-12-31 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and us.create_time > to_date('2010-12-30 00:00:00', 'yyyy-mm-dd hh24:mi:ss');

SELECT /*+ rule */ lpad(' ',decode(l.xidusn ,0,3,0))||l.oracle_username User_name, s.MACHINE,o.owner,o.object_name,o.object_type,s.sid,s.serial# FROM v$locked_object l,dba_objects o,v$session s  WHERE l.object_id=o.object_id AND l.session_id=s.sid ORDER BY o.object_id,xidusn DESC;

alter system kill session '1405,1568';

ANALYZE TABLE ZXDBM_APPSTORE.JRUN_POSTS COMPUTE STATISTICS; ----ANALYZE INDEX INDEX_NAME ESTIMATE STATISTICS;

select * from zxdbm_misp.muser_basicinfo as of timestamp to_date('2012-05-17 12:40:00', 'yyyy-mm-dd hh24:mi:ss');